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_alerts425,429 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 |
|---|
| 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 |
|---|
| 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 | RepeatedHitsDescendingFill | 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 |
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 9b565b63-69d8-4d15-99c8-44f56351260a | 2026-09-18 15:45 | 2026-09-18 15:45 | 2026-09-18 15:45 | SBET | SBET261120C00015000 | call | 15.0000 | 2026-11-20 | 0.3100 | 0.2800 | 0.3200 | 9.3000 | 23364.00 | 23364.00 | 0.00 | 750 | 23 | 2491 | 917 | 2.7164667393675 | 1.01134662116961 | 1.00056570281219 | false | false | false | |||||||||||||||||
| ac39e53e-78ef-49f1-829c-f5ba72620360 | 2026-09-18 11:58 | 2026-09-18 11:58 | 2026-09-18 11:58 | SBET | SBET261120C00010000 | call | 10.0000 | 2026-11-20 | 1.0200 | 0.9700 | 1.0300 | 9.1650 | 25558.00 | 25558.00 | 0.00 | 250 | 10 | 888 | 2354 | 0.377230246389125 | 0.876452269548093 | 0.869864012220406 | false | false | false | |||||||||||||||||
| b28c6a84-faaf-4bb7-abe9-4cb9de58c2f8 | 2026-09-15 14:48 | 2026-09-15 14:48 | 2026-09-15 14:48 | SBET | SBET270115C00010000 | call | 10.0000 | 2027-01-15 | 1.0000 | 1.0000 | 1.0500 | 8.1800 | 22301.00 | 0.00 | 22301.00 | 223 | 5 | 516 | 20738 | 0.0248818593885621 | 0.837999577380514 | 0.832642768642415 | false | false | false | |||||||||||||||||
| 6968d324-b48c-4bf0-ad31-e610794a487e | 2026-09-15 10:41 | 2026-09-15 10:41 | 2026-09-15 10:41 | SBET | SBET280121C00035000 | call | 35.0000 | 2028-01-21 | 0.7100 | 0.6500 | 0.7200 | 8.4325 | 14281.00 | 14281.00 | 0.00 | 200 | 7 | 200 | 5515 | 0.0362647325475975 | 0.899808338056637 | 0.896336925652161 | false | false | false | |||||||||||||||||
| 782fe689-30d8-4db9-9e38-1212d1077e48 | 2026-09-11 09:59 | 2026-09-11 09:59 | 2026-09-11 09:59 | SBET | SBET261120C00010000 | call | 10.0000 | 2026-11-20 | 1.1500 | 1.0600 | 1.1500 | 9.0000 | 60187.00 | 57475.00 | 2712.00 | 524 | 37 | 551 | 1376 | 0.400436046511628 | 0.87565788974445 | 0.869388837978127 | false | false | false | |||||||||||||||||
| 27354df1-9fc5-49cc-969e-d84deb40eeba | 2026-09-11 09:55 | 2026-09-11 09:55 | 2026-09-11 09:55 | SBET | SBET261016C00010000 | call | 10.0000 | 2026-10-16 | 0.6200 | 0.4800 | 0.6600 | 9.0000 | 31130.00 | 31130.00 | 0.00 | 500 | 17 | 549 | 6372 | 0.0861581920903955 | 0.891282666273641 | 0.836512624160772 | false | false | false | |||||||||||||||||
| 9b853f9a-41ae-470f-b082-2004574be509 | 2026-09-09 13:25 | 2026-09-09 13:25 | 2026-09-09 13:25 | SBET | SBET270115C00015000 | call | 15.0000 | 2027-01-15 | 0.4800 | 0.4700 | 0.5100 | 8.6950 | 22047.00 | 0.00 | 22047.00 | 464 | 8 | 1179 | 32146 | 0.0366764138617557 | 0.890185811489087 | 0.883742118887266 | false | false | false | |||||||||||||||||
| 87336b8e-549a-452d-aca1-b7cda7f44eed | 2026-09-04 11:55 | 2026-09-04 11:55 | 2026-09-04 11:55 | SBET | SBET270416C00008000 | call | 8.0000 | 2027-04-16 | 2.3500 | 2.1800 | 2.4300 | 8.5950 | 77266.00 | 77266.00 | 0.00 | 329 | 6 | 339 | 8369 | 0.0405066316166806 | 0.763917696321175 | 0.763917696321175 | false | false | false | |||||||||||||||||
| a2605a05-26d1-4eee-83b8-ef367dc64edc | 2026-09-04 09:51 | 2026-09-04 09:51 | 2026-09-04 09:51 | SBET | SBET261218C00010000 | call | 10.0000 | 2026-12-18 | 1.1100 | 0.8800 | 1.1200 | 8.5300 | 45197.00 | 44555.00 | 642.00 | 406 | 40 | 806 | 219 | 3.68036529680365 | 0.881794253506793 | 0.851719105455285 | false | false | false | |||||||||||||||||
| 2f7ecebd-df03-461e-b1db-05afc80ada92 | 2026-09-03 11:28 | 2026-09-03 11:28 | 2026-09-03 11:28 | SBET | SBET281215C00010000 | call | 10.0000 | 2028-12-15 | 4.0000 | 3.6500 | 4.0000 | 8.8610 | 13593.00 | 13593.00 | 0.00 | 34 | 15 | 35 | 6268 | 0.00558391831525207 | 0.804846662845806 | 0.804846662845806 | false | false | false | |||||||||||||||||
| 52b26531-009b-4ba4-9791-f6fa085d559e | 2026-08-25 09:31 | 2026-08-25 09:31 | 2026-08-25 09:31 | SBET | SBET260918C00008500 | call | 8.5000 | 2026-09-18 | 0.6600 | 0.5100 | 0.6900 | 8.1600 | 16538.00 | 16538.00 | 0.00 | 250 | 10 | 250 | 31 | 8.06451612903226 | 0.989541898309909 | 0.941600213984983 | false | false | false | |||||||||||||||||
| 86541b74-d317-49b7-bc26-35f18c2b19d5 | 2026-08-20 13:08 | 2026-08-20 13:08 | 2026-08-20 13:08 | SBET | SBET270115P00007000 | put | 7.0000 | 2027-01-15 | 1.0900 | 1.0900 | 1.1600 | 7.6450 | 23290.00 | 0.00 | 23290.00 | 213 | 18 | 642 | 1855 | 0.346091644204852 | 0.792674093963813 | 0.78695437311489 | false | false | false | |||||||||||||||||
| ca59d233-a18d-4999-9ba7-3abe4f370603 | 2026-08-19 11:34 | 2026-08-19 11:33 | 2026-08-19 11:33 | SBET | SBET280121C00008000 | call | 8.0000 | 2028-01-21 | 2.5500 | 2.5400 | 2.6200 | 7.0750 | 11720.00 | 6120.00 | 5600.00 | 46 | 9 | 890 | 18462 | 0.0482071281551295 | 0.828474166774716 | 0.8306465114349 | false | false | false | |||||||||||||||||
| c67aa018-267f-4bcb-979e-5936800399e7 | 2026-08-19 09:50 | 2026-08-19 09:50 | 2026-08-19 09:50 | SBET | SBET280121C00035000 | call | 35.0000 | 2028-01-21 | 0.4900 | 0.3500 | 0.5000 | 6.4250 | 14759.00 | 14712.00 | 47.00 | 300 | 6 | 300 | 5476 | 0.0547845142439737 | 0.954468843611967 | 0.939632771568673 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2031040697.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2031040697.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:59:21.919987Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:59:42.234161Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:59:42.234161Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:50:47.676652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:13:56.145626Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:56:18.493427Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:32:26.163070Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |