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 | 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 |
|---|
| 7bfb876d-3172-4fa5-a8c4-6237cf7110de | 2026-09-22 15:30 | 2026-09-22 15:30 | 2026-09-22 15:30 | SNDK | SNDK260925C02000000 | call | 2000.0000 | 2026-09-25 | 22.4700 | 22.2000 | 22.5000 | 1880.0000 | 20220.00 | 20220.00 | 0.00 | 9 | 5 | 13473 | 3675 | 3.66612244897959 | 0.892288066489964 | 0.894108040247018 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 276298511647.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T19:33:11.786837Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 2a6e6b59-21ec-4138-a159-fa514c1dcdad | 2026-09-22 15:30 | 2026-09-22 15:30 | 2026-09-22 15:30 | SNDK | SNDK260925C02000000 | call | 2000.0000 | 2026-09-25 | 22.4000 | 22.0000 | 22.4000 | 1880.0000 | 20160.00 | 20160.00 | 0.00 | 9 | 8 | 13483 | 3675 | 3.66884353741497 | 0.892566384325805 | 0.892566384325805 | true | false | false | true | ||||||||||||||||
| 49e106cd-0f20-4e15-9d99-07774d1cbe91 | 2026-09-22 15:34 | 2026-09-22 15:33 | 2026-09-22 15:33 | SNDK | SNDK260925C02000000 | call | 2000.0000 | 2026-09-25 | 24.7200 | 24.6000 | 24.9000 | 1898.8100 | 14830.00 | 0.00 | 14830.00 | 6 | 6 | 13549 | 3675 | 3.68680272108844 | 0.888143132773553 | 0.888143132773553 | false | false | false | true | ||||||||||||||||
| 83604046-702d-4aa6-98bc-1eba4a567169 | 2026-09-22 15:34 | 2026-09-22 15:34 | 2026-09-22 15:34 | SNDK | SNDK260925C02000000 | call | 2000.0000 | 2026-09-25 | 24.8000 | 24.4000 | 24.8000 | 1898.3600 | 37200.00 | 37200.00 | 0.00 | 15 | 7 | 13581 | 3675 | 3.69551020408163 | 0.891340402569161 | 0.891340402569161 | true | false | false | true | ||||||||||||||||
| d5f0cf3a-6b96-4279-be01-fb688158d1fa | 2026-09-22 15:34 | 2026-09-22 15:34 | 2026-09-22 15:34 | SNDK | SNDK260925C02000000 | call | 2000.0000 | 2026-09-25 | 25.0000 | 24.8000 | 25.0000 | 1899.6000 | 40000.00 | 40000.00 | 0.00 | 16 | 8 | 13629 | 3675 | 3.70857142857143 | 0.888886662819303 | 0.888886662819303 | false | false | false | true | ||||||||||||||||
| e6b25387-0291-490b-9005-42602e0ba432 | 2026-09-22 15:44 | 2026-09-22 15:44 | 2026-09-22 15:44 | SNDK | SNDK260925C02000000 | call | 2000.0000 | 2026-09-25 | 22.8000 | 22.7000 | 23.0000 | 1893.5150 | 11400.00 | 9120.00 | 2280.00 | 5 | 5 | 14221 | 3675 | 3.86965986394558 | 0.878846804523397 | 0.878846804523397 | false | false | false | true | ||||||||||||||||
| 9417897a-2bc6-423f-9d1f-e9b29136fce5 | 2026-09-22 15:53 | 2026-09-22 15:53 | 2026-09-22 15:53 | SNDK | SNDK260925C02000000 | call | 2000.0000 | 2026-09-25 | 24.0000 | 23.7000 | 24.0000 | 1890.0000 | 26400.00 | 26400.00 | 0.00 | 11 | 7 | 14559 | 3675 | 3.96163265306122 | 0.87429718809269 | 0.87211101120263 | false | false | false | true | ||||||||||||||||
| e25ee0ff-d081-4104-a9eb-e054685d4eae | 2026-09-23 10:22 | 2026-09-23 10:22 | 2026-09-23 10:22 | SNDK | SNDK260925C02000000 | call | 2000.0000 | 2026-09-25 | 5.7600 | 5.7000 | 6.0000 | 1825.6300 | 28786.00 | 0.00 | 28786.00 | 50 | 10 | 2244 | 3653 | 0.614289624965782 | 0.929490165590699 | 0.934990619142474 | false | false | false | true | ||||||||||||||||
| 75e511cd-0042-4e2e-804c-0b49dfe278fa | 2026-09-23 10:25 | 2026-09-23 10:25 | 2026-09-23 10:25 | SNDK | SNDK260925C02000000 | call | 2000.0000 | 2026-09-25 | 6.2000 | 5.9000 | 6.2000 | 1825.0000 | 26660.00 | 26660.00 | 0.00 | 43 | 11 | 2311 | 3653 | 0.632630714481248 | 0.9301483814392 | 0.9301483814392 | false | false | false | true | ||||||||||||||||
| ea28ffe1-59ba-4f8f-a55a-ad5a712274e2 | 2026-09-23 10:29 | 2026-09-23 10:29 | 2026-09-23 10:29 | SNDK | SNDK260925C02000000 | call | 2000.0000 | 2026-09-25 | 6.5000 | 6.3000 | 6.5000 | 1835.9150 | 16250.00 | 16250.00 | 0.00 | 25 | 9 | 2513 | 3653 | 0.687927730632357 | 0.918225373998023 | 0.918225373998023 | true | false | false | true | ||||||||||||||||
| 0c179f3b-868c-4347-b18b-94680d11c056 | 2026-09-23 13:56 | 2026-09-23 13:56 | 2026-09-23 13:56 | SNDK | SNDK260925C02000000 | call | 2000.0000 | 2026-09-25 | 4.7000 | 4.6000 | 4.7000 | 1829.0000 | 15980.00 | 15980.00 | 0.00 | 34 | 9 | 4851 | 3653 | 1.32794963044073 | 0.871339418920671 | 0.871339418920671 | false | false | false | true | ||||||||||||||||
| 9b9438f2-7e2a-4b2b-a790-3f1c1ad639a8 | 2026-09-23 15:55 | 2026-09-23 15:55 | 2026-09-23 15:55 | SNDK | SNDK260925C02000000 | call | 2000.0000 | 2026-09-25 | 4.0000 | 3.5000 | 4.0000 | 1815.0000 | 76770.00 | 76770.00 | 0.00 | 192 | 6 | 6876 | 3653 | 1.88228852997536 | 0.904560000631151 | 0.898521293040278 | false | false | false | true | ||||||||||||||||
| 3defaecf-a1f7-415b-b762-78750e68e785 | 2026-09-23 15:59 | 2026-09-23 15:59 | 2026-09-23 15:59 | SNDK | SNDK260925C02000000 | call | 2000.0000 | 2026-09-25 | 4.1000 | 4.1000 | 4.2000 | 1815.0000 | 44282.00 | 0.00 | 44282.00 | 108 | 6 | 7155 | 3653 | 1.95866411168902 | 0.878206003921391 | 0.879041354152101 | false | false | false | true | ||||||||||||||||
| d462b655-fe7a-479e-a7b1-d706e2518d89 | 2026-09-24 10:57 | 2026-09-24 10:57 | 2026-09-24 10:57 | SNDK | SNDK260925C02000000 | call | 2000.0000 | 2026-09-25 | 0.7500 | 0.7500 | 0.9000 | 1767.2200 | 14400.00 | 0.00 | 14400.00 | 192 | 18 | 2608 | 4281 | 0.609203457136183 | 1.13256522581105 | 1.13256522581105 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 276298511647.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:33:11.786837Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 276298511647.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 276298511647.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 276298511647.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 276298511647.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 276298511647.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 265980364647.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:24:55.903933Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 265980364647.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:26:39.791719Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 265980364647.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:31:12.586989Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 265980364647.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:00:02.240433Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 265980364647.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:57:58.068578Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 265980364647.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 265980364647.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:58:33.796895Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |