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_alerts474,253 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 | price |
|---|
| 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 |
|---|
| 1ac1ff50-9d07-4b67-9faa-ba735997955f | 2026-09-21 10:14 | 2026-09-21 10:14 | 2026-09-21 10:14 | SBET | SBET260925C00010000 | call | 10.0000 | 2026-09-25 | 0.3000 | 0.3000 | 0.3500 | 9.7850 | 30000.00 | 0.00 | 30000.00 | 1000 | 14 | 1189 | 4172 | 0.284995206136146 | 0.960251716833949 | 0.960251716833949 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 2167891568.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:14:40.112451Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| b337d5eb-bf6a-4d90-942e-b4999e064651 | 2026-09-21 11:09 | 2026-09-21 11:09 | 2026-09-21 11:09 | SBET | SBET261002P00008500 | put | 8.5000 | 2026-10-02 | 0.1200 | 0.1100 | 0.1300 | 9.0000 | 12288.00 | 0.00 | 12168.00 | 1024 | 10 | 1327 | 170 | 7.80588235294118 | 0.851510047784559 | 0.851510047784559 | false | false | false | true | false | |||||||||||||||
| 102b152f-29ab-44b2-af0e-72d61f0078bd | 2026-09-21 11:20 | 2026-09-21 11:20 | 2026-09-21 11:20 | SBET | SBET261218C00014000 | call | 14.0000 | 2026-12-18 | 0.6400 | 0.6400 | 0.6600 | 9.7150 | 23424.00 | 0.00 | 23424.00 | 366 | 7 | 700 | 775 | 0.903225806451613 | 0.922824872886435 | 0.922824872886435 | false | false | false | true | false | |||||||||||||||
| a6bbf406-582f-43c0-91eb-fab5692e0adb | 2026-09-21 11:35 | 2026-09-21 11:35 | 2026-09-21 11:35 | SBET | SBET270115C00015000 | call | 15.0000 | 2027-01-15 | 0.7000 | 0.7000 | 0.7200 | 9.0000 | 11340.00 | 0.00 | 11340.00 | 162 | 10 | 890 | 32577 | 0.0273198882647266 | 0.917273432375817 | 0.917273432375817 | false | false | false | true | false | |||||||||||||||
| 2dc8826a-6a45-4ce2-808e-e65fc65c6945 | 2026-09-22 09:44 | 2026-09-22 09:44 | 2026-09-22 09:44 | SBET | SBET261016C00009000 | call | 9.0000 | 2026-10-16 | 1.4800 | 1.3600 | 1.5600 | 10.0000 | 306653.00 | 145.00 | 306508.00 | 2072 | 54 | 2084 | 2974 | 0.700739744451917 | 0.812917471734616 | 0.817194724646868 | false | false | false | true | false | |||||||||||||||
| 5e3c1499-bd9c-4d1e-b477-d29de10fce6e | 2026-09-22 12:21 | 2026-09-22 12:21 | 2026-09-22 12:21 | SBET | SBET261016C00009000 | call | 9.0000 | 2026-10-16 | 1.5200 | 1.5200 | 1.6200 | 10.1700 | 15358.00 | 0.00 | 15358.00 | 101 | 17 | 2273 | 2974 | 0.764290517821116 | 0.814122735750199 | 0.801789723696389 | true | false | false | true | false | |||||||||||||||
| 78039480-7e6c-4d86-8e82-946c7329bc19 | 2026-09-22 13:11 | 2026-09-22 13:11 | 2026-09-22 13:11 | SBET | SBET270115C00015000 | call | 15.0000 | 2027-01-15 | 0.8200 | 0.8200 | 0.8500 | 10.3150 | 28700.00 | 0.00 | 28700.00 | 350 | 20 | 711 | 31364 | 0.0226693023848999 | 0.883416746490891 | 0.883416746490891 | false | false | false | true | false | |||||||||||||||
| b81f9d6f-519a-4457-a031-7c2dacc49379 | 2026-09-22 13:31 | 2026-09-22 13:31 | 2026-09-22 13:31 | SBET | SBET270115C00015000 | call | 15.0000 | 2027-01-15 | 0.8400 | 0.8300 | 0.8600 | 10.0000 | 42000.00 | 4620.00 | 37380.00 | 500 | 10 | 1214 | 31364 | 0.0387067976023466 | 0.885774648430629 | 0.886174522296495 | false | false | false | true | false | |||||||||||||||
| 739b58b4-2bba-416d-87ce-cf860d9c2b9d | 2026-09-23 10:38 | 2026-09-23 10:37 | 2026-09-23 10:37 | SBET | SBET261016C00010000 | call | 10.0000 | 2026-10-16 | 0.8300 | 0.8000 | 0.8400 | 9.9450 | 62250.00 | 830.00 | 27639.00 | 750 | 9 | 790 | 6628 | 0.119191309595655 | 0.848693191435501 | 0.848693191435501 | true | false | false | true | false | |||||||||||||||
| 1efbc0f2-2e70-4e53-b638-6c06b7209dde | 2026-09-23 13:46 | 2026-09-23 13:46 | 2026-09-23 13:46 | SBET | SBET270115C00010000 | call | 10.0000 | 2027-01-15 | 1.8300 | 1.7400 | 1.8500 | 9.0000 | 114043.00 | 77976.00 | 36067.00 | 624 | 44 | 1715 | 21662 | 0.0791708983473363 | 0.849038742493221 | 0.840721764788199 | false | false | false | true | false | |||||||||||||||
| ed30bb5a-dbf8-4e33-88f1-04c19359bc6a | 2026-09-23 13:47 | 2026-09-23 13:47 | 2026-09-23 13:47 | SBET | SBET270115C00010000 | call | 10.0000 | 2027-01-15 | 1.7700 | 1.7500 | 1.8500 | 9.0000 | 88562.00 | 61054.00 | 27508.00 | 500 | 18 | 2215 | 21662 | 0.102252792909242 | 0.818236432023909 | 0.805611511620896 | false | false | false | true | false | |||||||||||||||
| 4c2fa00d-183e-41b4-a5bb-4a9ed2af2627 | 2026-09-23 15:19 | 2026-09-23 15:19 | 2026-09-23 15:19 | SBET | SBET261120C00015000 | call | 15.0000 | 2026-11-20 | 0.2900 | 0.2900 | 0.3300 | 9.8150 | 36350.00 | 0.00 | 36350.00 | 1250 | 7 | 2324 | 3358 | 0.692078618225134 | 0.941322311932092 | 0.941322311932092 | false | false | false | true | false | |||||||||||||||
| 304e67a2-1232-4cf1-842e-83c0ce1ed829 | 2026-09-24 11:09 | 2026-09-24 11:09 | 2026-09-24 11:09 | SBET | SBET280616C00020000 | call | 20.0000 | 2028-06-16 | 2.2500 | 2.1400 | 2.2500 | 9.0000 | 25875.00 | 25875.00 | 0.00 | 115 | 6 | 115 | 0 | 0 | 0.813678200641312 | 0.813678200641312 | false | false | false | true | false | |||||||||||||||
| d205ed47-dc6f-490d-80ca-b549f43aa98d | 2026-09-24 15:51 | 2026-09-24 15:51 | 2026-09-24 15:51 | SBET | SBET261016C00010000 | call | 10.0000 | 2026-10-16 | 0.7700 | 0.7300 | 0.7700 | 9.9100 | 23100.00 | 23100.00 | 0.00 | 300 | 10 | 619 | 9080 | 0.0681718061674009 | 0.825522540336465 | 0.825522540336465 | false | false | false | true | false | |||||||||||||||
| d2f9cf8b-c0c8-456a-a9a8-b7b5352a057d | 2026-09-24 15:55 | 2026-09-24 15:55 | 2026-09-24 15:55 | SBET | SBET261016C00010000 | call | 10.0000 | 2026-10-16 | 0.7700 | 0.7400 | 0.7900 | 9.9300 | 28875.00 | 23100.00 | 5775.00 | 375 | 14 | 1019 | 9080 | 0.112224669603524 | 0.814604650226322 | 0.814604650226322 | false | false | false | true | false | |||||||||||||||
| 9d403a92-1f1e-4185-8eac-47f48cb856e1 | 2026-09-25 10:34 | 2026-09-25 10:34 | 2026-09-25 10:34 | SBET | SBET270115C00012000 | call | 12.0000 | 2027-01-15 | 1.0500 | 1.0000 | 1.1000 | 9.6500 | 37695.00 | 0.00 | 22995.00 | 359 | 5 | 359 | 3275 | 0.109618320610687 | 0.832745348753632 | 0.832745348753632 | false | false | false | true | false | |||||||||||||||
| 8dc13f07-2086-4183-aef0-2d302d73d060 | 2026-09-25 12:15 | 2026-09-25 12:15 | 2026-09-25 12:15 | SBET | SBET270115C00010000 | call | 10.0000 | 2027-01-15 | 1.6200 | 1.6000 | 1.6900 | 9.6600 | 74358.00 | 0.00 | 74358.00 | 459 | 13 | 471 | 19917 | 0.0236481397800874 | 0.804700698468133 | 0.804700698468133 | false | false | false | true | false | |||||||||||||||
| 3dc1feb5-1cd1-4798-8e23-496fd73fdedf | 2026-09-25 13:24 | 2026-09-25 13:24 | 2026-09-25 13:24 | SBET | SBET261002P00009500 | put | 9.5000 | 2026-10-02 | 0.3100 | 0.1100 | 0.3200 | 9.6712 | 65999.00 | 31.00 | 65968.00 | 2129 | 11 | 2550 | 161 | 15.8385093167702 | 0.742376934869198 | 0.742376934869198 | false | false | false | true | false | |||||||||||||||
| 9458f9c1-aac4-4385-be6d-7f95053ece91 | 2026-09-25 13:46 | 2026-09-25 13:46 | 2026-09-25 13:46 | SBET | SBET261106C00010000 | call | 10.0000 | 2026-11-06 | 0.9800 | 0.8900 | 1.0000 | 9.6900 | 16536.00 | 16536.00 | 0.00 | 168 | 25 | 188 | 0 | 0 | 0.852312858466028 | 0.827421074260373 | false | false | false | true | false | |||||||||||||||
| 8b7c757a-e02f-4aee-b63e-745e771d5ee7 | 2026-09-25 13:55 | 2026-09-25 13:55 | 2026-09-25 13:55 | SBET | SBET270115C00015000 | call | 15.0000 | 2027-01-15 | 0.5800 | 0.5800 | 0.6500 | 9.6400 | 28942.00 | 0.00 | 28942.00 | 499 | 8 | 548 | 30983 | 0.0176871187425362 | 0.869281420459692 | 0.87077770507557 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2167891568.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:13:03.739619Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2167891568.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:22:54.080611Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2167891568.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:36:47.844885Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2222197469.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:45:11.876123Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2222197469.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:27:20.551854Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2222197469.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:14:46.677665Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2222197469.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:40:26.166069Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2130963555.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:39:41.777134Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2130963555.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:48:41.957434Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2130963555.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:48:41.957434Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2130963555.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:25:57.460829Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2130963555.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:12:31.706500Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2130963555.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:53:57.742588Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2130963555.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:58:08.680508Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2091863307.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:37:32.022295Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2091863307.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:18:06.291601Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2091863307.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:33:28.969909Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2091863307.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:50:01.932714Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2091863307.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:00:15.336636Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |