Simplify Analytics
← Data Explorer

Options flow alerts (market-wide)

core.flow_alerts

Every UW flow alert, on every ticker - untracked ones included, which is the point. Keyed on the vendor's alert id. `ticker` is verbatim (SPX weeklies arrive as SPXW). Not exportable: each alert carries the contract's bid and ask.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

created_at (ET days)to
column equals (exact text)
sort
chart against created_at
reset
active:ticker = MAIN×
iduuidcreated_at ↓timestamp with time zonestart_timetimestamp with time zoneend_timetimestamp with time zonetickertextoption_symboltextoption_typetextstrikenumericexpirydatepricenumericbidnumericasknumericunderlying_pricenumerictotal_premiumnumerictotal_ask_side_premnumerictotal_bid_side_premnumerictotal_sizebiginttrade_countintegervolumebigintopen_interestbigintvolume_oi_rationumericiv_startnumericiv_endnumerichas_sweepbooleanhas_floorbooleanhas_multilegbooleanhas_singlelegbooleanall_opening_tradesbooleanalert_ruletextrule_iduuidexpiry_countintegerissue_typetextsectortextmarketcapnumericnext_earnings_datedateer_timetextmissing_periscopebooleansourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
fb3aaf43-03ce-4c59-969d-aea34753d0bb2026-09-14 13:402026-09-14 13:402026-09-14 13:40MAINMAIN260918P00059400put59.40002026-09-183.02002.75003.900056.070095130.000.0095130.00315264345300.1419426048565120.7387785822295960.738778582229596falsetruetruefalsefalseLowHistoricVolumeFloorb356ec2b-92e1-458a-934a-7719f71c40bc1Common StockFinancial Services5271071947.002026-11-05unknown—uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"}2026-09-152026-09-15 08:452026-09-15 08:45
a851a405-01b3-4c87-a996-001402e935e02026-09-14 13:402026-09-14 13:402026-09-14 13:40MAINMAIN270319P00060000put60.00002027-03-196.20005.80007.200056.0700136400.000.00136400.0022012222910.7628865979381440.2930708834502720.293070883450272falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51Common StockFinancial Services5271071947.002026-11-05unknown—uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"}2026-09-152026-09-15 08:452026-09-15 08:45
086a6868-179b-4ed1-9094-eee3ad3d6ba02026-09-09 11:282026-09-09 11:282026-09-09 11:28MAINMAIN261218C00054700call54.70002026-12-183.20003.00003.300056.190063671.0047671.0016000.00199152098560.2441588785046730.1722678027840240.172267802784024falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockFinancial Services5271071947.002026-11-05unknown—uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-09T15:29:26.424015Z"}2026-09-152026-09-15 08:452026-09-15 08:45
6cc29b80-fc9d-492d-9711-47cc5e37a87d2026-08-20 10:112026-08-20 10:112026-08-20 10:11MAINMAIN260821C00054700call54.70002026-08-213.97003.80004.000058.610011918.0011918.000.00306348840.03846153846153850.7849968700169720.784996870016972falsefalsefalsetruefalseRepeatedHitsAscendingFilla0979b52-28e4-4585-8f22-881faad2dd8e1Common StockFinancial Services5271071947.002026-11-05unknown—uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"}2026-09-152026-09-15 08:452026-09-15 08:45
5cdb3849-a8a7-4b31-a2df-b6b595bc35212026-08-19 11:012026-08-19 11:012026-08-19 11:01MAINMAIN261218C00059700call59.70002026-12-181.80001.70001.800058.510014940.0014940.000.0083219210710.08590102707749770.1483924978509880.148392497850988falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockFinancial Services5271071947.002026-11-05unknown—uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"}2026-09-152026-09-15 08:452026-09-15 08:45