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 |
|---|
| expirydate |
|---|
| 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 |
|---|
| 7a78ba98-26f5-4951-b281-ae21e7e92694 | 2026-08-18 10:42 | 2026-08-18 10:42 | 2026-08-18 10:42 | IBIT | IBIT270617C00045000 | call | 45.0000 | 2027-06-17 | 3.5000 | 3.4000 | 3.5000 | 36.7078 | 70000.00 | 70000.00 | 0.00 | 200 | 7 | 211 | 4090 | 0.0515892420537897 | 0.43839778150879 | 0.43839778150879 | 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-08-18T14:49:07.673043Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 76573168-c06d-469a-b64d-1793eb215ca7 | 2026-08-20 14:31 | 2026-08-20 14:31 | 2026-08-20 14:31 | IBIT | IBIT270617C00045000 | call | 45.0000 | 2027-06-17 | 5.8700 | 5.7000 | 5.9000 | 41.1500 | 58663.00 | 58663.00 | 0.00 | 100 | 6 | 30645 | 4228 | 7.24810785241249 | 0.460416162762302 | 0.458398397482626 | false | false | false | |||||||||||||||||
| e733f6f7-fd03-4270-bfc6-63d483a5741e | 2026-08-28 09:30 | 2026-08-28 09:30 | 2026-08-28 09:30 | IBIT | IBIT270617C00045000 | call | 45.0000 | 2027-06-17 | 8.0000 | 7.6000 | 8.1000 | 44.8500 | 177600.00 | 176000.00 | 1600.00 | 222 | 8 | 1668 | 34379 | 0.0485179906338172 | 0.467499113619153 | 0.467499113619153 | false | false | false | |||||||||||||||||
| db7313ee-3a2e-45c2-a92a-d125af0b2e1e | 2026-08-28 09:30 | 2026-08-28 09:30 | 2026-08-28 09:30 | IBIT | IBIT270617C00045000 | call | 45.0000 | 2027-06-17 | 8.0000 | 7.6000 | 8.0500 | 44.8550 | 668800.00 | 668800.00 | 0.00 | 836 | 11 | 2504 | 34379 | 0.0728351609994473 | 0.467301221158368 | 0.467301221158368 | false | false | false | |||||||||||||||||
| 2797165e-62b8-4956-adfe-d0df234db42b | 2026-08-28 09:30 | 2026-08-28 09:30 | 2026-08-28 09:30 | IBIT | IBIT270617C00045000 | call | 45.0000 | 2027-06-17 | 8.1100 | 7.7500 | 8.2000 | 44.8550 | 559100.00 | 345640.00 | 213460.00 | 689 | 12 | 1446 | 34379 | 0.0420605602257192 | 0.479685096406579 | 0.467301221158368 | false | false | false | |||||||||||||||||
| e4889921-8065-4023-9364-ca414a3d401a | 2026-08-31 13:23 | 2026-08-31 13:23 | 2026-08-31 13:23 | IBIT | IBIT270617C00045000 | call | 45.0000 | 2027-06-17 | 7.5000 | 7.3500 | 7.5000 | 44.5150 | 596250.00 | 596250.00 | 0.00 | 795 | 60 | 980 | 36903 | 0.026556106549603 | 0.450249318593787 | 0.450249318593787 | false | false | false | |||||||||||||||||
| bf869593-b56a-4137-8cb9-23d4f2841fe4 | 2026-09-18 10:16 | 2026-09-18 10:16 | 2026-09-18 10:16 | IBIT | IBIT270617C00045000 | call | 45.0000 | 2027-06-17 | 7.7000 | 7.6000 | 7.7000 | 45.5981 | 77000.00 | 77000.00 | 0.00 | 100 | 9 | 135 | 38205 | 0.00353356890459364 | 0.434170328555947 | 0.434170328555947 | false | false | false | |||||||||||||||||
| fd9b9b92-dc57-42c0-b568-70e16a375e19 | 2026-09-23 10:25 | 2026-09-23 10:24 | 2026-09-23 10:24 | IBIT | IBIT270617C00045000 | call | 45.0000 | 2027-06-17 | 8.8500 | 8.8500 | 9.0500 | 47.0000 | 10620.00 | 0.00 | 10620.00 | 12 | 5 | 55 | 39042 | 0.00140873930638799 | 0.426449801261052 | 0.426449801261052 | false | false | false | |||||||||||||||||
| 179e050b-50b3-4fc6-8a2e-a5b9bf3764e7 | 2026-09-23 13:07 | 2026-09-23 13:07 | 2026-09-23 13:07 | IBIT | IBIT270617C00045000 | call | 45.0000 | 2027-06-17 | 8.8400 | 8.7500 | 8.9500 | 47.4950 | 17680.00 | 0.00 | 17680.00 | 20 | 5 | 101 | 39042 | 0.00258695763536704 | 0.433517221591705 | 0.433517221591705 | 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-08-20T18:45:57.711481Z"} |
| 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-08-28T13:32:48.312014Z"} |
| 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-08-28T13:32:48.312014Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:32:48.312014Z"} |
| 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-08-31T17:45:10.653528Z"} |
| 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-18T14:19:45.885567Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 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:26:39.791719Z"} |
| 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-23T17:11:20.356460Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |