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
uw_flow_alerts231,528 rowsrestricted — hover for the licence
active:option_symbol = SPXW260921C07640000×
| iduuid | created_at ↓timestamp with time zone | start_timetimestamp with time zone | end_timetimestamp with time zone | tickertext | option_symboltext | option_typetext | strikenumeric | expirydate | pricenumeric | bidnumeric | asknumeric | underlying_pricenumeric | total_premiumnumeric | total_ask_side_premnumeric | total_bid_side_premnumeric | total_sizebigint | trade_countinteger | volumebigint | open_interestbigint | volume_oi_rationumeric | iv_startnumeric | iv_endnumeric | has_sweepboolean | has_floorboolean | has_multilegboolean | has_singlelegboolean | all_opening_tradesboolean | alert_ruletext | rule_iduuid | expiry_countinteger | issue_typetext | sectortext | marketcapnumeric | next_earnings_datedate | er_timetext | missing_periscopeboolean | sourcetext | endpointtext | request_paramsjsonb | as_ofdate | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| a9cbb4d0-edb3-4fad-a8d8-f0b12167abe2 | 2026-09-18 16:55 | 2026-09-18 16:54 | 2026-09-18 16:54 | SPXW | SPXW260921C07640000 | call | 7640.0000 | 2026-09-21 | 29.3800 | 29.2000 | 29.6000 | 7630.0000 | 14690.00 | 0.00 | 14690.00 | 5 | 5 | 8858 | 406 | 21.8177339901478 | 0.0806011883709991 | 0.0806011883709991 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 94b73d0f-5688-45dd-b69b-12ca76d2d19a | 2026-09-18 15:59 | 2026-09-18 15:59 | 2026-09-18 15:59 | SPXW | SPXW260921C07640000 | call | 7640.0000 | 2026-09-21 | 21.7400 | 21.6000 | 21.9000 | 7625.0000 | 178270.00 | 165250.00 | 13020.00 | 82 | 14 | 8627 | 406 | 21.2487684729064 | 0.0596602421750799 | 0.0592882674397005 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | — | — | — | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| acb93b24-8580-4746-b0f7-36d2a001c6b5 | 2026-09-18 15:02 | 2026-09-18 15:02 | 2026-09-18 15:02 | SPXW | SPXW260921C07640000 | call | 7640.0000 | 2026-09-21 | 19.7000 | 19.6000 | 19.7000 | 7641.5300 | 143810.00 | 143810.00 | 0.00 | 73 | 16 | 4848 | 406 | 11.9408866995074 | 0.0637543676439858 | 0.0637543676439858 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| b08e37c0-3091-47fc-bb9e-f297588e89ea | 2026-09-18 14:53 | 2026-09-18 14:53 | 2026-09-18 14:53 | SPXW | SPXW260921C07640000 | call | 7640.0000 | 2026-09-21 | 21.4000 | 21.3000 | 21.4000 | 7643.5500 | 109140.00 | 109140.00 | 0.00 | 51 | 8 | 4558 | 406 | 11.2266009852217 | 0.0659309293247239 | 0.0659309293247239 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 213f9dba-1aea-47f8-8c57-dd8fa9ab1f41 | 2026-09-18 14:53 | 2026-09-18 14:52 | 2026-09-18 14:52 | SPXW | SPXW260921C07640000 | call | 7640.0000 | 2026-09-21 | 21.1100 | 21.0000 | 21.4000 | 7643.2800 | 198470.00 | 78070.00 | 120400.00 | 94 | 16 | 4446 | 406 | 10.9507389162562 | 0.0657456671172036 | 0.065380854075334 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |