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.

231,528 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 = MAIR×
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
1c5e91f6-bbd4-4fea-b149-36dc9f1331ff2026-09-18 14:212026-09-18 14:212026-09-18 14:21MAIRMAIR261218C00050000call50.00002026-12-180.35000.25000.350023.500085707.0085677.000.00246359380624315.66255144032920.9255804408420650.89676279192023truefalsefalsetruefalseRepeatedHitsDescendingFill5ce5ec11-087c-4c00-b164-08106b0158561—Basic Materials4257999500.002026-10-29unknown—uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"}2026-09-182026-09-18 21:152026-09-18 21:15
06c5f870-c382-4af4-ac78-a75ec23e9f8f2026-09-18 14:202026-09-18 14:202026-09-18 14:20MAIRMAIR261218C00050000call50.00002026-12-180.35000.00000.350023.500011582.0011549.0033.003333713432435.526748971193420.9251166314497470.749537597959478truefalsefalsetruefalseRepeatedHitsDescendingFill5ce5ec11-087c-4c00-b164-08106b0158561—Basic Materials4257999500.002026-10-29unknown—uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"}2026-09-182026-09-18 21:152026-09-18 21:15
05187b94-8342-493a-9112-1f3f4c5ade4c2026-09-16 15:072026-09-16 15:072026-09-16 15:07MAIRMAIR261016C00025000call25.00002026-10-161.15001.15001.450023.400011500.000.0011500.001006236415.756097560975610.6558812749998780.655881274999878falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31—Basic Materials4164007840.002026-10-29unknown—uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-16T19:16:52.058969Z"}2026-09-162026-09-16 21:152026-09-16 21:15
a0cdcfdd-38b8-4df3-8be4-49d1485742a02026-09-16 11:432026-09-16 11:422026-09-16 11:42MAIRMAIR261016C00025000call25.00002026-10-161.30001.30002.050023.815013000.000.001170.001007100412.43902439024390.6463592790476120.646359279047612falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31—Basic Materials4164007840.002026-10-29unknown—uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-16T16:04:58.541898Z"}2026-09-162026-09-16 21:152026-09-16 21:15