Simplify AnalyticsOptions 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
uw_flow_alerts281,039 rowsrestricted — hover for the licence
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6a19048b-bf38-49c9-8a1f-8628a24c9cf5 | 2026-08-20 12:42 | 2026-08-20 12:42 | 2026-08-20 12:42 | XRT | XRT260821P00087000 | put | 87.0000 | 2026-08-21 | 0.6200 | 0.6000 | 0.9900 | 86.8050 | 54132.00 | 3416.00 | 50716.00 | 874 | 67 | 1336 | 11250 | 0.118755555555556 | 0.28752235564181 | 0.281954104906807 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 273660796.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T16:44:56.732853Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e04564f7-5714-40e6-a0dd-78dd7206b84d | 2026-08-21 13:05 | 2026-08-21 13:05 | 2026-08-21 13:05 | XRT | XRT261218P00088000 | put | 88.0000 | 2026-12-18 | 4.7000 | 4.5500 | 4.7000 | 87.6700 | 134346.00 | 134346.00 | 0.00 | 286 | 30 | 291 | 43 | 6.76744186046512 | 0.255667430782751 | 0.255667430782751 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 273660796.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e39f66ca-1eee-423a-96d4-f49efca1cad3 | 2026-09-11 10:40 | 2026-09-11 10:40 | 2026-09-11 10:40 | XRT | XRT261016P00085000 | put | 85.0000 | 2026-10-16 | 2.6000 | 2.5200 | 2.6000 | 84.4000 | 112446.00 | 95160.00 | 17286.00 | 433 | 12 | 939 | 10480 | 0.0895992366412214 | 0.235672335991573 | 0.233754088809126 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 292617327.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5f48675a-2f73-450c-878d-4806bdd8f660 | 2026-09-17 10:58 | 2026-09-17 10:58 | 2026-09-17 10:58 | XRT | XRT261016C00087000 | call | 87.0000 | 2026-10-16 | 0.6700 | 0.6100 | 0.6800 | 83.1600 | 30136.00 | 23771.00 | 0.00 | 449 | 24 | 4456 | 1081 | 4.12210915818686 | 0.206395606167992 | 0.205033890262604 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 322487885.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:02:25.509626Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 809c5879-bbc0-42d7-ab84-a3320808690a | 2026-09-17 10:59 | 2026-09-17 10:59 | 2026-09-17 10:59 | XRT | XRT261016C00087000 | call | 87.0000 | 2026-10-16 | 0.6800 | 0.6200 | 0.6800 | 83.1750 | 22447.00 | 19968.00 | 0.00 | 332 | 26 | 5243 | 1081 | 4.85013876040703 | 0.2058974658095 | 0.204537217168685 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 322487885.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:02:25.509626Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| a1bf795e-a721-4e9e-99de-d73ca0cf4d58 | 2026-09-17 11:17 | 2026-09-17 11:16 | 2026-09-17 11:16 | XRT | XRT270917P00070000 | put | 70.0000 | 2027-09-17 | 2.8700 | 2.8600 | 2.9500 | 83.2300 | 24362.00 | 0.00 | 8010.00 | 85 | 35 | 170 | 0 | 0 | 0.292223110711269 | 0.291775092025424 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 322487885.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 55239765-e3ae-41da-b286-8d2e4aea1895 | 2026-09-17 11:17 | 2026-09-17 11:16 | 2026-09-17 11:16 | XRT | XRT270917P00070000 | put | 70.0000 | 2027-09-17 | 2.8400 | 2.3200 | 2.8700 | 83.2300 | 27842.00 | 285.00 | 18168.00 | 98 | 52 | 268 | 0 | 0 | 0.291326705014687 | 0.290428816379033 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 322487885.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |