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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5bf272c8-94be-4607-b8bf-096f4aacf7b7 | 2026-09-21 15:58 | 2026-09-21 15:58 | 2026-09-21 15:58 | TOL | TOL261218P00140000 | put | 140.0000 | 2026-12-18 | 10.7000 | 10.7000 | 11.3000 | 135.6350 | 82393.00 | 0.00 | 82393.00 | 77 | 8 | 513 | 245 | 2.09387755102041 | 0.341282687605772 | 0.341282687605772 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 12485918500.00 | 2026-12-14 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 8ad7b60e-2f2a-46c1-9e2b-6cfab816cbbf | 2026-09-21 15:09 | 2026-09-21 15:09 | 2026-09-21 15:09 | TOL | TOL261218P00150000 | put | 150.0000 | 2026-12-18 | 16.8300 | 16.8000 | 17.5000 | 136.5300 | 45454.00 | 0.00 | 45454.00 | 27 | 5 | 446 | 38 | 11.7368421052632 | 0.349118608544813 | 0.347087928880988 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 12485918500.00 | 2026-12-14 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 16b4269d-152f-4133-a720-9a2df3963753 | 2026-09-21 15:08 | 2026-09-21 15:08 | 2026-09-21 15:08 | TOL | TOL261218P00150000 | put | 150.0000 | 2026-12-18 | 16.8000 | 16.8000 | 17.5000 | 136.4700 | 48722.00 | 0.00 | 48722.00 | 29 | 7 | 361 | 38 | 9.5 | 0.345477779703754 | 0.345477779703754 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 12485918500.00 | 2026-12-14 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 067c9a8f-9318-4c65-9b23-68ebcfeb2fb2 | 2026-09-09 12:51 | 2026-09-09 12:51 | 2026-09-09 12:51 | TOL | TOL260918P00130000 | put | 130.0000 | 2026-09-18 | 1.4200 | 1.4000 | 1.6500 | 133.0000 | 14100.00 | 3950.00 | 10150.00 | 99 | 6 | 115 | 554 | 0.207581227436823 | 0.367402924787834 | 0.367402924787834 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 12368891810.00 | 2026-12-14 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 636bd2a9-caf1-4ab7-8774-1935179a3ff3 | 2026-09-03 14:45 | 2026-09-03 14:45 | 2026-09-03 14:45 | TOL | TOL261016C00160000 | call | 160.0000 | 2026-10-16 | 1.2100 | 0.9500 | 1.2500 | 141.8500 | 12115.00 | 12115.00 | 0.00 | 100 | 6 | 212 | 43 | 4.93023255813953 | 0.321075527063684 | 0.316817464884469 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 12368891810.00 | 2026-12-14 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T18:47:01.806289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1fed4e4d-0713-4850-9e2f-6db1b5bc7bfe | 2026-08-24 12:05 | 2026-08-24 12:04 | 2026-08-24 12:04 | TOL | TOL260918C00150000 | call | 150.0000 | 2026-09-18 | 3.8400 | 3.8000 | 4.0000 | 147.3850 | 28005.00 | 10140.00 | 17865.00 | 73 | 14 | 94 | 886 | 0.106094808126411 | 0.318260250165516 | 0.318260250165516 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 12368891810.00 | 2026-12-14 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T16:14:40.561585Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |