-- CreateTable CREATE TABLE "IvSnapshot" ( "id" SERIAL NOT NULL, "underlying" TEXT NOT NULL, "expiry" TEXT NOT NULL, "strike" DOUBLE PRECISION NOT NULL, "optionType" TEXT NOT NULL, "iv" DOUBLE PRECISION NOT NULL, "volume" DOUBLE PRECISION NOT NULL DEFAULT 0, "oi" DOUBLE PRECISION NOT NULL DEFAULT 0, "spotPrice" DOUBLE PRECISION NOT NULL, "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "IvSnapshot_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "AtmIvHistory" ( "id" SERIAL NOT NULL, "underlying" TEXT NOT NULL, "atmIv" DOUBLE PRECISION NOT NULL, "spotPrice" DOUBLE PRECISION NOT NULL, "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "AtmIvHistory_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "Signal" ( "id" SERIAL NOT NULL, "type" TEXT NOT NULL, "underlying" TEXT NOT NULL, "symbol" TEXT NOT NULL, "severity" TEXT NOT NULL, "data" JSONB NOT NULL, "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "Signal_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "MarketSnapshot" ( "id" SERIAL NOT NULL, "underlying" TEXT NOT NULL, "totalOptions" INTEGER NOT NULL, "totalVolume" DOUBLE PRECISION NOT NULL, "totalOi" DOUBLE PRECISION NOT NULL, "putCallRatio" DOUBLE PRECISION NOT NULL, "avgIv" DOUBLE PRECISION NOT NULL, "spotPrice" DOUBLE PRECISION NOT NULL, "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "MarketSnapshot_pkey" PRIMARY KEY ("id") ); -- CreateIndex CREATE INDEX "IvSnapshot_underlying_createdAt_idx" ON "IvSnapshot"("underlying", "createdAt"); -- CreateIndex CREATE INDEX "IvSnapshot_underlying_expiry_strike_optionType_idx" ON "IvSnapshot"("underlying", "expiry", "strike", "optionType"); -- CreateIndex CREATE INDEX "AtmIvHistory_underlying_createdAt_idx" ON "AtmIvHistory"("underlying", "createdAt"); -- CreateIndex CREATE INDEX "Signal_type_createdAt_idx" ON "Signal"("type", "createdAt"); -- CreateIndex CREATE INDEX "Signal_underlying_createdAt_idx" ON "Signal"("underlying", "createdAt"); -- CreateIndex CREATE INDEX "MarketSnapshot_underlying_createdAt_idx" ON "MarketSnapshot"("underlying", "createdAt");