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_alerts658,639 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 |
|---|
| 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 |
|---|
| a8b46381-931d-456e-bead-7ce31816eae0 | 2026-08-20 09:50 | 2026-08-20 09:49 | 2026-08-20 09:49 | SBET | SBET260821C00007000 | call | 7.0000 | 2026-08-21 | 0.4700 | 0.4100 | 0.5600 | 7.4100 | 28858.00 | 1833.00 | 27025.00 | 614 | 16 | 831 | 5408 | 0.15366124260355 | 1.26236465754286 | 1.33962571365259 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-20T13:54:26.267880Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 777bc1b4-a8ff-407b-9fe1-ce586b6ca7a7 | 2026-08-20 09:53 | 2026-08-20 09:53 | 2026-08-20 09:53 | SBET | SBET260821C00007000 | call | 7.0000 | 2026-08-21 | 0.4500 | 0.4200 | 0.5000 | 7.4000 | 27270.00 | 9225.00 | 18045.00 | 606 | 20 | 1464 | 5408 | 0.270710059171598 | 1.26553822158798 | 1.22684664972833 | true | false | false | true | ||||||||||||||||
| 99196cfe-fa4f-43ba-905b-6df98ed78a9f | 2026-08-20 09:55 | 2026-08-20 09:55 | 2026-08-20 09:55 | SBET | SBET260821C00007000 | call | 7.0000 | 2026-08-21 | 0.4400 | 0.4100 | 0.5000 | 7.3950 | 35024.00 | 8800.00 | 26224.00 | 796 | 28 | 2260 | 5408 | 0.417899408284024 | 1.16882906011561 | 1.16882906011561 | true | false | false | true | ||||||||||||||||
| 611f892b-7ff0-47c8-b72b-dbc52f74ee9b | 2026-08-20 09:57 | 2026-08-20 09:57 | 2026-08-20 09:57 | SBET | SBET260821C00007000 | call | 7.0000 | 2026-08-21 | 0.4400 | 0.4300 | 0.4700 | 7.3900 | 63800.00 | 0.00 | 63800.00 | 1450 | 8 | 4467 | 5408 | 0.825998520710059 | 1.20892286482475 | 1.20892286482475 | true | false | false | true | ||||||||||||||||
| 8cb1ccd8-2845-4b24-80d0-1285c6ff6e30 | 2026-08-20 09:59 | 2026-08-20 09:59 | 2026-08-20 09:59 | SBET | SBET260821C00007000 | call | 7.0000 | 2026-08-21 | 0.4300 | 0.4100 | 0.4700 | 7.3800 | 18834.00 | 8600.00 | 10234.00 | 438 | 15 | 5114 | 5408 | 0.945636094674556 | 1.19088523574871 | 1.19088523574871 | true | false | false | true | ||||||||||||||||
| 77c938c2-8316-4797-be1b-cd33f39fb658 | 2026-08-20 10:00 | 2026-08-20 09:59 | 2026-08-20 09:59 | SBET | SBET260821C00007000 | call | 7.0000 | 2026-08-21 | 0.4300 | 0.4200 | 0.4700 | 7.3850 | 87247.00 | 4515.00 | 82732.00 | 2029 | 31 | 7238 | 5408 | 1.3383875739645 | 1.15118700579858 | 1.15118700579858 | true | false | false | true | ||||||||||||||||
| 1b520220-0d14-42ea-bfa6-80cf88602b74 | 2026-08-20 10:01 | 2026-08-20 10:01 | 2026-08-20 10:01 | SBET | SBET260821C00007000 | call | 7.0000 | 2026-08-21 | 0.4300 | 0.4100 | 0.4700 | 7.3850 | 65059.00 | 1935.00 | 63124.00 | 1513 | 8 | 9106 | 5408 | 1.68380177514793 | 1.15118700579858 | 1.15118700579858 | false | false | false | true | ||||||||||||||||
| 1ac25730-f99e-412a-b9ec-da7b981ca561 | 2026-08-20 10:03 | 2026-08-20 10:03 | 2026-08-20 10:03 | SBET | SBET260821C00007000 | call | 7.0000 | 2026-08-21 | 0.4500 | 0.4200 | 0.4800 | 7.3900 | 32285.00 | 9000.00 | 22925.00 | 713 | 10 | 9820 | 5408 | 1.81582840236686 | 1.05007536588093 | 1.30269620812835 | true | false | false | true | ||||||||||||||||
| 50bada57-69c1-42b7-bebc-abc80e6a1dfc | 2026-08-20 10:04 | 2026-08-20 10:04 | 2026-08-20 10:04 | SBET | SBET260821C00007000 | call | 7.0000 | 2026-08-21 | 0.4400 | 0.4200 | 0.4500 | 7.3901 | 26532.00 | 8624.00 | 17908.00 | 603 | 16 | 10428 | 5408 | 1.92825443786982 | 1.20813930897955 | 1.20813930897955 | true | false | false | true | ||||||||||||||||
| b7b44171-e8b5-4340-8ed6-2d0b95322103 | 2026-08-20 10:11 | 2026-08-20 10:11 | 2026-08-20 10:11 | SBET | SBET260821C00007000 | call | 7.0000 | 2026-08-21 | 0.4500 | 0.4400 | 0.4800 | 7.4100 | 24615.00 | 0.00 | 24615.00 | 547 | 20 | 11192 | 5408 | 2.06952662721893 | 1.14374263021574 | 1.14374263021574 | true | false | false | true | ||||||||||||||||
| 6d64d69f-9a34-4cda-afe1-008cd6c636fc | 2026-08-20 10:11 | 2026-08-20 10:11 | 2026-08-20 10:11 | SBET | SBET260821C00007000 | call | 7.0000 | 2026-08-21 | 0.4500 | 0.4400 | 0.4800 | 7.4150 | 24435.00 | 9000.00 | 15435.00 | 543 | 7 | 11935 | 5408 | 2.20691568047337 | 1.0985297104993 | 1.0985297104993 | false | false | false | true | ||||||||||||||||
| 5a6e2b8c-7a4b-42b9-b956-b381faed3fda | 2026-08-20 10:13 | 2026-08-20 10:13 | 2026-08-20 10:13 | SBET | SBET260821C00007000 | call | 7.0000 | 2026-08-21 | 0.4300 | 0.4200 | 0.4500 | 7.3850 | 23220.00 | 1720.00 | 21500.00 | 540 | 32 | 12607 | 5408 | 2.33117603550296 | 1.06510679122725 | 1.15118700579858 | true | false | false | true | ||||||||||||||||
| e7a9dce0-ba86-4284-b1d7-b88f166a237e | 2026-08-20 10:33 | 2026-08-20 10:33 | 2026-08-20 10:33 | SBET | SBET260821C00007000 | call | 7.0000 | 2026-08-21 | 0.4500 | 0.4400 | 0.4800 | 7.4195 | 17730.00 | 8190.00 | 9540.00 | 394 | 12 | 13360 | 5408 | 2.47041420118343 | 1.05509073180379 | 1.05509073180379 | true | false | false | true | ||||||||||||||||
| 89ce70ba-f2e1-403e-a84c-ca18b14e2b3a | 2026-08-20 11:01 | 2026-08-20 11:01 | 2026-08-20 11:01 | SBET | SBET260821C00007000 | call | 7.0000 | 2026-08-21 | 0.4500 | 0.4100 | 0.4800 | 7.4200 | 43650.00 | 34650.00 | 9000.00 | 970 | 5 | 16048 | 5408 | 2.96745562130178 | 1.0985297104993 | 1.05007536588093 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-20T13:54:26.267880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-20T14:18:56.683244Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-20T14:18:56.683244Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-20T14:18:56.683244Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-20T14:33:56.503993Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-20T15:02:58.462752Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |