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:sector = Utilities×ticker = ORA×
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
f015c404-cf10-4aae-a42b-9e5f193e27ce2026-09-18 11:562026-09-18 11:562026-09-18 11:56ORAORA270617C00100000call100.00002027-06-1711.740011.600014.300097.220022310.000.0019720.0019819850.2235294117647060.3417799284985370.382695517212113falsefalsefalsetruefalseRepeatedHitsAscendingFilla0979b52-28e4-4585-8f22-881faad2dd8e1Common StockUtilities5986112237.002026-11-02unknown—uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"}2026-09-182026-09-18 21:152026-09-18 21:15
455fcabd-512c-4329-9971-f798553550d12026-09-16 12:342026-09-16 12:342026-09-16 12:34ORAORA261218P00095000put95.00002026-12-188.60008.20008.600091.610098900.0098900.000.0011512115681.691176470588240.3938738389078870.393873838907887falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockUtilities5650953908.002026-11-02unknown—uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-16T16:35:37.886334Z"}2026-09-162026-09-16 21:152026-09-16 21:15
c92cacb9-207b-47d7-a25f-c4efccee51dd2026-09-09 14:352026-09-09 14:342026-09-09 14:34ORAORA261218P00100000put100.00002026-12-188.23006.80009.400098.315012349.008227.00822.00156151810.08287292817679560.3868279756825860.384874613577014falsefalsefalsetruefalseRepeatedHitsDescendingFill5ce5ec11-087c-4c00-b164-08106b0158561Common StockUtilities5662638327.002026-11-02unknown—uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-09T18:58:33.363095Z"}2026-09-152026-09-15 08:452026-09-15 08:45
5b97f0ba-b023-4435-a491-bcfb084989502026-09-09 11:502026-09-09 11:502026-09-09 11:50ORAORA261016P00095000put95.00002026-10-162.95001.95003.100098.180023895.0011210.0012685.00811481233.521739130434780.368283141442090.36828314144209falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockUtilities5662638327.002026-11-02unknown—uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-09T15:51:30.246262Z"}2026-09-152026-09-15 08:452026-09-15 08:45
2194d174-72e5-442e-8dbb-0e96398dc7a72026-09-09 11:422026-09-09 11:422026-09-09 11:42ORAORA260918P00100000put100.00002026-09-182.75002.40002.750099.160010175.0010175.000.003792511551.619354838709680.3782619056912520.378261905691252falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockUtilities5662638327.002026-11-02unknown—uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-09T15:51:30.246262Z"}2026-09-152026-09-15 08:452026-09-15 08:45
24b6fcc3-c1d3-4559-9221-4c17f41822a42026-09-09 10:232026-09-09 10:232026-09-09 10:23ORAORA260918P00100000put100.00002026-09-181.70001.10001.7000102.000032470.0032470.000.00191281911551.232258064516130.4213244455112970.413521565793832falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockUtilities5662638327.002026-11-02unknown—uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-09T14:24:00.331334Z"}2026-09-152026-09-15 08:452026-09-15 08:45