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 |
|---|
| 3139bb99-06ed-4527-8987-9416de8e3c07 | 2026-09-10 12:11 | 2026-09-10 12:11 | 2026-09-10 12:11 | IBIT | IBIT261009C00049000 | call | 49.0000 | 2026-10-09 | 0.4200 | 0.4200 | 0.4300 | 43.5350 | 228522.00 | 0.00 | 228522.00 | 5441 | 28 | 5535 | 1631 | 3.39362354383814 | 0.401640138589282 | 0.401640138589282 | false | false | false | true | 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-10T16:13:08.333814Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 40d073fd-2ac3-4b83-8161-88061e12c268 | 2026-09-21 15:19 | 2026-09-21 15:19 | 2026-09-21 15:19 | IBIT | IBIT261009C00049000 | call | 49.0000 | 2026-10-09 | 1.7500 | 1.7300 | 1.7500 | 48.8900 | 10850.00 | 10850.00 | 0.00 | 62 | 6 | 3267 | 8860 | 0.368735891647856 | 0.405745324135909 | 0.405745324135909 | false | false | false | |||||||||||||||||
| 676e2154-5dc7-4c87-8156-56fcd543db32 | 2026-09-23 10:13 | 2026-09-23 10:13 | 2026-09-23 10:13 | IBIT | IBIT261009C00049000 | call | 49.0000 | 2026-10-09 | 1.1300 | 1.1200 | 1.1300 | 47.0000 | 19888.00 | 19888.00 | 0.00 | 176 | 6 | 315 | 8146 | 0.0386692855389148 | 0.395561795427334 | 0.394513256860804 | true | false | false | |||||||||||||||||
| 5b53c908-8b1d-4cb4-9af8-47d967f1ec97 | 2026-09-23 12:11 | 2026-09-23 12:11 | 2026-09-23 12:11 | IBIT | IBIT261009C00049000 | call | 49.0000 | 2026-10-09 | 1.0300 | 1.0300 | 1.0400 | 47.7220 | 10712.00 | 0.00 | 10712.00 | 104 | 8 | 568 | 8146 | 0.0697274736066781 | 0.385199623527861 | 0.385199623527861 | false | false | false | |||||||||||||||||
| 38b76cd8-9461-436c-943b-7a59bffa152b | 2026-09-24 13:47 | 2026-09-24 13:47 | 2026-09-24 13:47 | IBIT | IBIT261009C00049000 | call | 49.0000 | 2026-10-09 | 0.9200 | 0.9200 | 0.9300 | 47.0000 | 11868.00 | 0.00 | 11868.00 | 129 | 7 | 986 | 8114 | 0.121518363322652 | 0.376129536250884 | 0.376129536250884 | false | false | false | |||||||||||||||||
| 863a37f5-4288-42b2-a5ab-8e3ef1b191b5 | 2026-09-25 14:15 | 2026-09-25 14:15 | 2026-09-25 14:15 | IBIT | IBIT261009C00049000 | call | 49.0000 | 2026-10-09 | 0.7100 | 0.7000 | 0.7100 | 47.5550 | 16188.00 | 16188.00 | 0.00 | 228 | 15 | 447 | 8376 | 0.0533667621776504 | 0.339678104144841 | 0.339678104144841 | false | false | false | |||||||||||||||||
| 9586e3bf-1dce-4074-bbf9-863acb84f154 | 2026-09-25 14:23 | 2026-09-25 14:23 | 2026-09-25 14:23 | IBIT | IBIT261009C00049000 | call | 49.0000 | 2026-10-09 | 0.7200 | 0.7100 | 0.7200 | 47.5650 | 22896.00 | 22896.00 | 0.00 | 318 | 21 | 766 | 8376 | 0.0914517669531996 | 0.341571875417992 | 0.341571875417992 | 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-21T19:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-23T14:14:46.490149Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T16:13:15.432740Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-24T17:55:11.953323Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-25T18:18:37.657539Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 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-25T18:27:02.000981Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |