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 |
|---|
| 37831981-95dd-4e51-8012-30cd74259538 | 2026-09-23 13:19 | 2026-09-23 13:19 | 2026-09-23 13:19 | ORCL | ORCL260925P00148000 | put | 148.0000 | 2026-09-25 | 3.1500 | 3.1500 | 3.3000 | 146.0000 | 10085.00 | 0.00 | 10085.00 | 32 | 6 | 987 | 2489 | 0.396544797107272 | 0.553156878231334 | 0.550795582303145 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 437111276160.00 | 2026-12-09 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T17:20:19.861269Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 24d2d436-7fbf-46a1-b5f7-a0001db98a8d | 2026-09-22 15:55 | 2026-09-22 15:55 | 2026-09-22 15:55 | ORCL | ORCL260925P00148000 | put | 148.0000 | 2026-09-25 | 2.5100 | 2.5100 | 2.5400 | 148.0000 | 19076.00 | 0.00 | 19076.00 | 76 | 17 | 3129 | 2111 | 1.48223590715301 | 0.539813415127126 | 0.539813415127126 | true | false | false | true | ||||||||||||||||
| e4e6a912-fb5a-4e76-a018-1ce7ab2d95a6 | 2026-09-22 14:30 | 2026-09-22 14:30 | 2026-09-22 14:30 | ORCL | ORCL260925P00148000 | put | 148.0000 | 2026-09-25 | 2.0000 | 1.9200 | 2.0000 | 150.1350 | 10400.00 | 10400.00 | 0.00 | 52 | 16 | 2590 | 2111 | 1.22690667929891 | 0.550015829654316 | 0.550015829654316 | true | false | false | true | ||||||||||||||||
| 8d1fe019-8d4c-484b-8d4b-56542f97a373 | 2026-09-22 14:27 | 2026-09-22 14:27 | 2026-09-22 14:27 | ORCL | ORCL260925P00148000 | put | 148.0000 | 2026-09-25 | 1.9400 | 1.9400 | 2.0000 | 150.0800 | 10670.00 | 0.00 | 10670.00 | 55 | 6 | 2518 | 2111 | 1.19279962103269 | 0.534391706910328 | 0.534391706910328 | false | false | false | true | ||||||||||||||||
| c985453f-f4ed-40f9-9f53-c71fb7c91935 | 2026-09-22 14:11 | 2026-09-22 14:11 | 2026-09-22 14:11 | ORCL | ORCL260925P00148000 | put | 148.0000 | 2026-09-25 | 2.1900 | 2.1300 | 2.2000 | 149.5616 | 12070.00 | 12070.00 | 0.00 | 55 | 9 | 2442 | 2111 | 1.15679772619612 | 0.545557761245607 | 0.539843459289055 | false | false | false | true | ||||||||||||||||
| e99f745b-229c-4a85-8474-33f031cd55ae | 2026-09-22 11:44 | 2026-09-22 11:44 | 2026-09-22 11:44 | ORCL | ORCL260925P00148000 | put | 148.0000 | 2026-09-25 | 2.1700 | 2.1700 | 2.2300 | 149.7300 | 13671.00 | 0.00 | 13671.00 | 63 | 5 | 2080 | 2111 | 0.98531501657982 | 0.552683590947703 | 0.552683590947703 | false | false | false | true | ||||||||||||||||
| dfe470bf-1606-41ea-a8b6-37faef89a185 | 2026-09-22 11:33 | 2026-09-22 11:33 | 2026-09-22 11:33 | ORCL | ORCL260925P00148000 | put | 148.0000 | 2026-09-25 | 2.0400 | 1.9700 | 2.0400 | 150.0000 | 54060.00 | 54060.00 | 0.00 | 265 | 22 | 1984 | 2111 | 0.939838938891521 | 0.565380282526903 | 0.565380282526903 | false | false | false | true | ||||||||||||||||
| 31704a1a-1561-437b-9fd6-3c2444519acf | 2026-09-22 10:46 | 2026-09-22 10:46 | 2026-09-22 10:46 | ORCL | ORCL260925P00148000 | put | 148.0000 | 2026-09-25 | 2.2300 | 2.1400 | 2.2500 | 149.5500 | 18065.00 | 18065.00 | 0.00 | 81 | 16 | 1040 | 2111 | 0.49265750828991 | 0.560342379719088 | 0.554180820524812 | true | false | false | true | ||||||||||||||||
| dc9d88d6-3876-4591-87f7-8e204d0d3457 | 2026-09-21 15:48 | 2026-09-21 15:48 | 2026-09-21 15:48 | ORCL | ORCL260925P00148000 | put | 148.0000 | 2026-09-25 | 3.0500 | 3.0500 | 3.1000 | 148.0000 | 34478.00 | 3978.00 | 21655.00 | 113 | 5 | 1951 | 1808 | 1.07909292035398 | 0.537901694749874 | 0.537901694749874 | true | false | false | true | ||||||||||||||||
| 6b25c6e1-2f76-404e-8f94-b4fd0d1ccb3a | 2026-09-21 15:46 | 2026-09-21 15:46 | 2026-09-21 15:46 | ORCL | ORCL260925P00148000 | put | 148.0000 | 2026-09-25 | 3.0000 | 2.9700 | 3.0500 | 148.0000 | 30000.00 | 0.00 | 30000.00 | 100 | 7 | 1836 | 1808 | 1.01548672566372 | 0.538715983081066 | 0.538715983081066 | true | false | false | true | ||||||||||||||||
| b84378a4-a746-4597-84f8-3a6ab1655224 | 2026-09-21 10:34 | 2026-09-21 10:34 | 2026-09-21 10:34 | ORCL | ORCL260925P00148000 | put | 148.0000 | 2026-09-25 | 3.3500 | 3.2500 | 3.4000 | 147.9200 | 50585.00 | 35510.00 | 0.00 | 151 | 5 | 978 | 1808 | 0.540929203539823 | 0.541059114149632 | 0.541059114149632 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:36:42.386317Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:29:55.439380Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:18:27.911867Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:49:01.734970Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:34:09.835499Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:48:37.826382Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 449206220160.00 |
| 2026-12-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:50:07.722851Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 449206220160.00 |
| 2026-12-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:50:07.722851Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 449206220160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:37:14.719915Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |