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.
uw_flow_alerts523,327 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 | expiry |
|---|
| 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 |
|---|
| 0404c35d-bf43-4725-aa8c-8e228af3c2ef | 2026-09-21 12:43 | 2026-09-21 12:43 | 2026-09-21 12:43 | AMZN | AMZN260921C00255000 | call | 255.0000 | 2026-09-21 | 3.6100 | 3.5000 | 3.7000 | 258.6100 | 29566.00 | 728.00 | 21278.00 | 82 | 12 | 31637 | 5127 | 6.17066510629998 | 0.397870681057472 | 0.50850334772315 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 2787722742683.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:45:57.787225Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| edcd6072-28cd-476d-8983-76f2167019b7 | 2026-09-21 12:30 | 2026-09-21 12:30 | 2026-09-21 12:30 | AMZN | AMZN260921C00255000 | call | 255.0000 | 2026-09-21 | 3.0000 | 2.8600 | 3.0000 | 257.0000 | 10499.00 | 10499.00 | 0.00 | 35 | 9 | 30993 | 5127 | 6.0450555880632 | 0.399567453263868 | 0.34836102434188 | false | false | false | true | ||||||||||||||||
| a8456ba7-a708-41d1-9c27-3840ed8a5451 | 2026-09-21 12:25 | 2026-09-21 12:25 | 2026-09-21 12:25 | AMZN | AMZN260921C00255000 | call | 255.0000 | 2026-09-21 | 2.5100 | 2.4100 | 2.6800 | 257.5000 | 10543.00 | 10543.00 | 0.00 | 42 | 8 | 30439 | 5127 | 5.93700019504584 | 0.374256304668805 | 0.3177074483553 | false | false | false | true | ||||||||||||||||
| a2008bcd-e679-4629-b4ba-238cb99c87d3 | 2026-09-21 12:21 | 2026-09-21 12:21 | 2026-09-21 12:21 | AMZN | AMZN260921C00255000 | call | 255.0000 | 2026-09-21 | 1.9400 | 1.8700 | 2.0000 | 256.8050 | 26384.00 | 3104.00 | 970.00 | 136 | 6 | 30017 | 5127 | 5.8546908523503 | 0.330478036322485 | 0.330478036322485 | false | false | false | true | ||||||||||||||||
| e3635273-4f2d-4f04-8064-bbcf54cec527 | 2026-09-21 11:48 | 2026-09-21 11:48 | 2026-09-21 11:48 | AMZN | AMZN260921C00255000 | call | 255.0000 | 2026-09-21 | 1.5100 | 1.5200 | 1.6300 | 256.3900 | 14929.00 | 0.00 | 14929.00 | 99 | 13 | 27284 | 5127 | 5.32163058318705 | 0.293930917963806 | 0.290160469087958 | true | false | false | true | ||||||||||||||||
| 4b69f91f-35ff-4682-a56c-1175a2c2eed6 | 2026-09-21 11:47 | 2026-09-21 11:47 | 2026-09-21 11:47 | AMZN | AMZN260921C00255000 | call | 255.0000 | 2026-09-21 | 1.5000 | 1.4600 | 1.5500 | 256.3200 | 10347.00 | 10195.00 | 152.00 | 69 | 16 | 26850 | 5127 | 5.23698069046226 | 0.312183715455086 | 0.293023724442221 | true | false | false | true | ||||||||||||||||
| 966a9272-8b53-4b8d-acb6-98dba92d3d22 | 2026-09-21 11:41 | 2026-09-21 11:41 | 2026-09-21 11:41 | AMZN | AMZN260921C00255000 | call | 255.0000 | 2026-09-21 | 1.0400 | 1.0200 | 1.0600 | 255.6100 | 11128.00 | 104.00 | 11024.00 | 107 | 8 | 25364 | 5127 | 4.94714257850595 | 0.302020117153891 | 0.305052490146189 | false | false | false | true | ||||||||||||||||
| 4b9b856c-624d-44b4-9a22-d84c8797821a | 2026-09-21 11:13 | 2026-09-21 11:13 | 2026-09-21 11:13 | AMZN | AMZN260921C00255000 | call | 255.0000 | 2026-09-21 | 0.6700 | 0.6700 | 0.6900 | 254.8550 | 10854.00 | 0.00 | 10854.00 | 162 | 16 | 20700 | 5127 | 4.03744880046811 | 0.310500056300057 | 0.310500056300057 | true | false | false | true | ||||||||||||||||
| 9f53c6da-f168-4a6f-91cb-88e7fe035cb6 | 2026-09-21 10:38 | 2026-09-21 10:38 | 2026-09-21 10:38 | AMZN | AMZN260921C00255000 | call | 255.0000 | 2026-09-21 | 1.4900 | 1.4500 | 1.4900 | 256.0000 | 14900.00 | 14900.00 | 0.00 | 100 | 7 | 16233 | 5127 | 3.16617905207724 | 0.356394701587181 | 0.356394701587181 | false | false | false | true | ||||||||||||||||
| 242ccf6b-23b4-450a-a0c8-1f80f5571415 | 2026-09-21 10:10 | 2026-09-21 10:10 | 2026-09-21 10:10 | AMZN | AMZN260921C00255000 | call | 255.0000 | 2026-09-21 | 2.0900 | 2.0400 | 2.2800 | 256.7000 | 10638.00 | 1703.00 | 7885.00 | 51 | 17 | 13428 | 5127 | 2.61907548273844 | 0.398598902731297 | 0.395512313842313 | true | false | false | true | ||||||||||||||||
| 415e808e-468e-4bee-8c98-8ae9a60df346 | 2026-09-21 10:06 | 2026-09-21 10:06 | 2026-09-21 10:06 | AMZN | AMZN260921C00255000 | call | 255.0000 | 2026-09-21 | 1.3900 | 1.2800 | 1.3900 | 255.6250 | 14448.00 | 14448.00 | 0.00 | 104 | 6 | 11763 | 5127 | 2.29432416617905 | 0.383362430440703 | 0.395072723718482 | false | false | false | true | ||||||||||||||||
| 65c5438c-a842-430d-b550-6c6d9bd62daf | 2026-09-21 10:06 | 2026-09-21 10:06 | 2026-09-21 10:06 | AMZN | AMZN260921C00255000 | call | 255.0000 | 2026-09-21 | 1.2200 | 1.2100 | 1.2700 | 255.4000 | 24396.00 | 0.00 | 24396.00 | 200 | 21 | 11617 | 5127 | 2.26584747415643 | 0.372226971643391 | 0.372210971322363 | false | false | false | true | ||||||||||||||||
| 63ba6d48-2e09-43fc-8a08-af7bef47e2e6 | 2026-09-21 10:04 | 2026-09-21 10:04 | 2026-09-21 10:04 | AMZN | AMZN260921C00255000 | call | 255.0000 | 2026-09-21 | 1.1500 | 1.1200 | 1.1600 | 255.2600 | 23921.00 | 23921.00 | 0.00 | 208 | 5 | 10526 | 5127 | 2.05305246732982 | 0.381750872083405 | 0.385547764164705 | true | false | false | true | ||||||||||||||||
| 046482d9-5593-4f18-8629-39e29cc67e7a | 2026-09-21 10:03 | 2026-09-21 10:03 | 2026-09-21 10:03 | AMZN | AMZN260921C00255000 | call | 255.0000 | 2026-09-21 | 1.1700 | 1.1400 | 1.1700 | 255.3000 | 12396.00 | 12166.00 | 0.00 | 106 | 7 | 10168 | 5127 | 1.98322605812366 | 0.38623721568333 | 0.380774908988362 | false | false | false | true | ||||||||||||||||
| 17b6d29a-175f-4269-8e02-44926a059047 | 2026-09-21 10:03 | 2026-09-21 10:03 | 2026-09-21 10:03 | AMZN | AMZN260921C00255000 | call | 255.0000 | 2026-09-21 | 1.1100 | 1.0800 | 1.1500 | 255.2600 | 25975.00 | 25207.00 | 218.00 | 234 | 28 | 9794 | 5127 | 1.91027891554515 | 0.379891437938814 | 0.3813103286691 | true | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:32:17.927421Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:25:44.384112Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:25:44.384112Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:49:21.879731Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:49:21.879731Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:43:39.846801Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:16:13.769524Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:39:35.705687Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:10:29.738922Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:08:15.762043Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:06:26.378716Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:04:59.983035Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:04:59.983035Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:04:59.983035Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |