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 |
|---|
| 0dd0f83f-a438-40c9-a82f-53f699934b6e | 2026-09-28 15:37 | 2026-09-28 15:36 | 2026-09-28 15:36 | IBIT | IBIT270319C00050000 | call | 50.0000 | 2027-03-19 | 4.4500 | 4.4500 | 4.5500 | 47.0000 | 111250.00 | 0.00 | 111250.00 | 250 | 12 | 1290 | 18130 | 0.0711527854384997 | 0.402329813785062 | 0.402329813785062 | false | false | false | true | 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-28T19:41:20.736872Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| e1910b88-2506-41f2-9857-cddd22c46ef7 | 2026-09-28 10:31 | 2026-09-28 10:31 | 2026-09-28 10:31 | IBIT | IBIT270319C00050000 | call | 50.0000 | 2027-03-19 | 4.4000 | 4.4000 | 4.4500 | 47.0850 | 88001.00 | 0.00 | 88001.00 | 200 | 11 | 770 | 18130 | 0.0424710424710425 | 0.404074954099923 | 0.404850474282556 | false | false | false | true | ||||||||||||||||
| c6c9e958-1d35-41f9-b3a2-ef123159eb54 | 2026-09-28 10:29 | 2026-09-28 10:29 | 2026-09-28 10:29 | IBIT | IBIT270319C00050000 | call | 50.0000 | 2027-03-19 | 4.4000 | 4.4000 | 4.4500 | 47.0000 | 88000.00 | 0.00 | 88000.00 | 200 | 26 | 470 | 18130 | 0.0259238830667402 | 0.403688489396838 | 0.403688489396838 | false | false | false | true | ||||||||||||||||
| 67abd048-55f0-4b2f-bf83-075a4295c6c3 | 2026-09-23 14:07 | 2026-09-23 14:07 | 2026-09-23 14:07 | IBIT | IBIT270319C00050000 | call | 50.0000 | 2027-03-19 | 4.9500 | 4.9500 | 5.0500 | 47.7199 | 49500.00 | 0.00 | 49500.00 | 100 | 6 | 670 | 18317 | 0.0365780422558279 | 0.415126719783066 | 0.415126719783066 | false | false | false | true | ||||||||||||||||
| b014fe7f-2821-43a7-9c2f-e851c3328344 | 2026-09-23 13:54 | 2026-09-23 13:53 | 2026-09-23 13:53 | IBIT | IBIT270319C00050000 | call | 50.0000 | 2027-03-19 | 5.0000 | 4.9500 | 5.0500 | 47.7500 | 20000.00 | 17000.00 | 0.00 | 40 | 6 | 520 | 18317 | 0.028388928317956 | 0.417715306039293 | 0.417715306039293 | false | false | false | true | ||||||||||||||||
| c91a25a8-0ee1-4d45-86ce-7415e81efa27 | 2026-09-23 10:35 | 2026-09-23 10:35 | 2026-09-23 10:35 | IBIT | IBIT270319C00050000 | call | 50.0000 | 2027-03-19 | 5.0500 | 5.0000 | 5.0500 | 47.8000 | 50500.00 | 50500.00 | 0.00 | 100 | 9 | 307 | 18317 | 0.0167603865261779 | 0.419511372385296 | 0.419511372385296 | false | false | false | true | ||||||||||||||||
| 7d322dfc-3dc0-4f9b-9810-b0d3c317ba2f | 2026-09-23 10:21 | 2026-09-23 10:20 | 2026-09-23 10:20 | IBIT | IBIT270319C00050000 | call | 50.0000 | 2027-03-19 | 5.0000 | 5.0000 | 5.1000 | 47.8450 | 62500.00 | 0.00 | 62500.00 | 125 | 8 | 193 | 18317 | 0.0105366599333952 | 0.413958518160351 | 0.413958518160351 | false | false | false | true | ||||||||||||||||
| c1aad4df-efa0-40d4-936d-f8e669778920 | 2026-09-21 11:38 | 2026-09-21 11:38 | 2026-09-21 11:38 | IBIT | IBIT270319C00050000 | call | 50.0000 | 2027-03-19 | 5.6600 | 5.6500 | 5.7500 | 48.0000 | 56624.00 | 0.00 | 56624.00 | 100 | 5 | 464 | 18337 | 0.0253040301030703 | 0.425751109664465 | 0.428716588798012 | false | false | false | true | ||||||||||||||||
| 5e2c2d8d-037a-4733-9384-4e2a8fc5def7 | 2026-09-18 11:38 | 2026-09-18 11:38 | 2026-09-18 11:38 | IBIT | IBIT270319C00050000 | call | 50.0000 | 2027-03-19 | 4.0000 | 3.9500 | 4.0500 | 45.7854 | 100000.00 | 88000.00 | 0.00 | 250 | 7 | 844 | 18098 | 0.0466349872914134 | 0.408008427735581 | 0.408008427735581 | false | false | false | true | ||||||||||||||||
| 492c1440-02c1-4083-87f9-d3dfd13c6879 | 2026-09-18 10:30 | 2026-09-18 10:30 | 2026-09-18 10:30 | IBIT | IBIT270319C00050000 | call | 50.0000 | 2027-03-19 | 4.0500 | 3.9500 | 4.0500 | 45.7200 | 101250.00 | 101250.00 | 0.00 | 250 | 38 | 396 | 18098 | 0.0218808708144546 | 0.414275484280478 | 0.414275484280478 | false | false | false | true | ||||||||||||||||
| 86e32b02-e916-41cf-8537-d47aa3b0aaeb | 2026-09-01 12:26 | 2026-09-01 12:26 | 2026-09-01 12:26 | IBIT | IBIT270319C00050000 | call | 50.0000 | 2027-03-19 | 3.6000 | 3.5500 | 3.6000 | 43.9050 | 72000.00 | 72000.00 | 0.00 | 200 | 7 | 262 | 17193 | 0.015238759960449 | 0.422708221841626 | 0.422708221841626 | false | false | false | true | ||||||||||||||||
| be676b9d-e4fc-4eb8-9143-6ec3c48738b5 | 2026-08-27 10:51 | 2026-08-27 10:51 | 2026-08-27 10:51 | IBIT | IBIT270319C00050000 | call | 50.0000 | 2027-03-19 | 4.6000 | 4.6000 | 4.7000 | 45.4400 | 53360.00 | 0.00 | 53360.00 | 116 | 30 | 463 | 16635 | 0.0278328824767057 | 0.440934555694134 | 0.440934555694134 | false | false | false | true | ||||||||||||||||
| c3230252-f658-445d-8133-5c5af0b38e5c | 2026-08-27 10:51 | 2026-08-27 10:51 | 2026-08-27 10:51 | IBIT | IBIT270319C00050000 | call | 50.0000 | 2027-03-19 | 4.6000 | 4.6000 | 4.7000 | 45.4200 | 92003.00 | 0.00 | 92003.00 | 200 | 21 | 347 | 16635 | 0.0208596333032762 | 0.441639927450253 | 0.44237934959803 | false | false | false | true | ||||||||||||||||
| 6a83d446-4e26-4088-942c-a89f12da81f6 | 2026-08-20 15:20 | 2026-08-20 15:20 | 2026-08-20 15:20 | IBIT | IBIT270319C00050000 | call | 50.0000 | 2027-03-19 | 2.9000 | 2.8700 | 2.9000 | 41.0969 | 72500.00 | 72500.00 | 0.00 | 250 | 27 | 1576 | 18651 | 0.0844994906439333 | 0.442866716098379 | 0.442866716098379 | false | false | false | true | ||||||||||||||||
| 4a99ec0e-c1d8-48f0-a1fd-36fa2b6c250c | 2026-08-20 12:21 | 2026-08-20 12:21 | 2026-08-20 12:21 | IBIT | IBIT270319C00050000 | call | 50.0000 | 2027-03-19 | 2.7500 | 2.6900 | 2.7500 | 40.9450 | 56375.00 | 56375.00 | 0.00 | 205 | 25 | 941 | 18651 | 0.0504530588172216 | 0.434707411440247 | 0.434707411440247 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:35:37.335936Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-28T14:31:22.759072Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:11:21.793472Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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:55:17.981841Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:35:38.031989Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:21:45.775363Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-21T15:39:42.073830Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| 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:32:18.430939Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T16:27:11.873526Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T15:06:04.251678Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T15:06:04.251678Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 64762757065.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:44:56.732853Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |