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_alerts566,287 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 |
|---|
| 79c2d6b6-9a80-4424-8ecc-de3b880d4c32 | 2026-08-27 14:13 | 2026-08-27 14:13 | 2026-08-27 14:13 | IBIT | IBIT270115C00046000 | call | 46.0000 | 2027-01-15 | 5.0000 | 5.0000 | 5.1000 | 45.4400 | 50011.00 | 0.00 | 50011.00 | 100 | 24 | 372 | 12080 | 0.030794701986755 | 0.43977707153805 | 0.43977707153805 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 64762757065.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T18:14:24.609292Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 44863ab5-e0d8-492f-adc0-f7a4e590556b | 2026-09-11 12:23 | 2026-09-11 12:22 | 2026-09-11 12:22 | IBIT | IBIT270115C00046000 | call | 46.0000 | 2027-01-15 | 3.5500 | 3.5000 | 3.5500 | 43.8715 | 61770.00 | 61770.00 | 0.00 | 174 | 8 | 1568 | 12269 | 0.127801776835928 | 0.407613233216291 | 0.407613233216291 | true | false | false | true | ||||||||||||||||
| a9a23b9c-4220-4981-a707-3efb316cfb21 | 2026-09-15 09:41 | 2026-09-15 09:41 | 2026-09-15 09:41 | IBIT | IBIT270115C00046000 | call | 46.0000 | 2027-01-15 | 3.2500 | 3.2000 | 3.3000 | 43.2200 | 130000.00 | 104000.00 | 26000.00 | 400 | 8 | 415 | 12056 | 0.0344226940942269 | 0.415644899890249 | 0.415644899890249 | false | false | false | |||||||||||||||||
| 009621a7-01fc-4874-a3b3-81cccb529786 | 2026-09-15 09:42 | 2026-09-15 09:42 | 2026-09-15 09:42 | IBIT | IBIT270115C00046000 | call | 46.0000 | 2027-01-15 | 3.2500 | 3.2000 | 3.3000 | 43.2250 | 91975.00 | 65650.00 | 13000.00 | 283 | 17 | 1098 | 12056 | 0.0910749834107498 | 0.415409537688929 | 0.415409537688929 | true | false | false | |||||||||||||||||
| 490c5e34-e93b-48b4-8a27-c3bc6eec31e1 | 2026-09-16 10:17 | 2026-09-16 10:17 | 2026-09-16 10:17 | IBIT | IBIT270115C00046000 | call | 46.0000 | 2027-01-15 | 2.8700 | 2.8700 | 2.9300 | 42.0000 | 351575.00 | 0.00 | 351575.00 | 1225 | 42 | 1240 | 13003 | 0.095362608628778 | 0.401162434048104 | 0.401618452146144 | false | false | false | |||||||||||||||||
| cbba99a7-06e6-4d45-bb97-a16bf076f262 | 2026-09-16 13:24 | 2026-09-16 13:24 | 2026-09-16 13:24 | IBIT | IBIT270115C00046000 | call | 46.0000 | 2027-01-15 | 2.8500 | 2.8300 | 2.8500 | 42.8100 | 142215.00 | 142215.00 | 0.00 | 499 | 8 | 1751 | 13003 | 0.134661232023379 | 0.395913806568411 | 0.395913806568411 | false | false | false | true | ||||||||||||||||
| fa04b083-2828-4ace-86fe-b6cfbd6f345f | 2026-09-16 13:53 | 2026-09-16 13:53 | 2026-09-16 13:53 | IBIT | IBIT270115C00046000 | call | 46.0000 | 2027-01-15 | 2.7800 | 2.7500 | 2.7800 | 42.0000 | 116760.00 | 116760.00 | 0.00 | 420 | 8 | 2171 | 13003 | 0.166961470429901 | 0.395525613365304 | 0.395525613365304 | false | false | false | true | ||||||||||||||||
| be23ece2-48f1-4080-99d8-a7452770f82b | 2026-09-17 11:00 | 2026-09-17 11:00 | 2026-09-17 11:00 | IBIT | IBIT270115C00046000 | call | 46.0000 | 2027-01-15 | 2.9900 | 2.9800 | 3.0500 | 43.2700 | 119600.00 | 0.00 | 104351.00 | 400 | 27 | 464 | 13728 | 0.0337995337995338 | 0.390402876113745 | 0.390402876113745 | false | false | false | true | ||||||||||||||||
| ff8565da-6fcd-4fcf-aad1-3c22d4b9fded | 2026-09-17 11:02 | 2026-09-17 11:02 | 2026-09-17 11:02 | IBIT | IBIT270115C00046000 | call | 46.0000 | 2027-01-15 | 2.9500 | 2.9400 | 2.9800 | 43.1800 | 58900.00 | 0.00 | 58900.00 | 200 | 14 | 689 | 13728 | 0.0501893939393939 | 0.389514895250473 | 0.390533324536534 | false | false | false | true | ||||||||||||||||
| bbe5bb56-ba89-49dc-900b-6617a0f8d10f | 2026-09-17 11:05 | 2026-09-17 11:05 | 2026-09-17 11:05 | IBIT | IBIT270115C00046000 | call | 46.0000 | 2027-01-15 | 2.9300 | 2.9300 | 2.9600 | 43.1600 | 71492.00 | 0.00 | 71492.00 | 244 | 19 | 1189 | 13728 | 0.0866113053613054 | 0.389425451101918 | 0.389425451101918 | false | false | false | true | ||||||||||||||||
| 0f1287d6-599e-493c-8822-3b5eae5704c5 | 2026-09-17 11:23 | 2026-09-17 11:23 | 2026-09-17 11:23 | IBIT | IBIT270115C00046000 | call | 46.0000 | 2027-01-15 | 2.9400 | 2.9300 | 2.9800 | 43.1950 | 133476.00 | 0.00 | 133476.00 | 454 | 35 | 1643 | 13728 | 0.119682400932401 | 0.388626592422472 | 0.388817311842063 | false | false | false | |||||||||||||||||
| 219b3884-7d59-47c1-8a76-286087bd4391 | 2026-09-22 14:08 | 2026-09-22 14:07 | 2026-09-22 14:07 | IBIT | IBIT270115C00046000 | call | 46.0000 | 2027-01-15 | 6.4500 | 6.4000 | 6.5000 | 49.0150 | 161250.00 | 18060.00 | 143190.00 | 250 | 22 | 472 | 13334 | 0.0353982300884956 | 0.417431858633194 | 0.417431858633194 | true | false | false | |||||||||||||||||
| 0bd77eb5-53b9-407d-8596-009bbf26aa0c | 2026-09-22 14:09 | 2026-09-22 14:09 | 2026-09-22 14:09 | IBIT | IBIT270115C00046000 | call | 46.0000 | 2027-01-15 | 6.4500 | 6.4000 | 6.5000 | 49.0150 | 161250.00 | 18060.00 | 143190.00 | 250 | 7 | 722 | 13334 | 0.0541472926353682 | 0.417431858633194 | 0.417431858633194 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T16:54:27.741510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:03:30.942669Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:02:25.509626Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:37:51.418712Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:10:48.215993Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:10:48.215993Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |