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 | expirydate |
|---|
| 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 |
|---|
| 55c4a784-f3bb-4167-a202-9b88cb063b44 | 2026-08-19 13:17 | 2026-08-19 13:16 | 2026-08-19 13:16 | IGV | IGV260918P00104000 | put | 104.0000 | 2026-09-18 | 4.2000 | 3.8000 | 4.2500 | 102.6400 | 40320.00 | 40320.00 | 0.00 | 96 | 13 | 121 | 561 | 0.215686274509804 | 0.310134874010216 | 0.310134874010216 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 14038397136.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 569b4da4-71ac-482c-8d2b-c8b60cdc8ed3 | 2026-08-28 11:17 | 2026-08-28 11:17 | 2026-08-28 11:17 | IGV | IGV260918P00104000 | put | 104.0000 | 2026-09-18 | 0.8700 | 0.8700 | 1.1300 | 110.1800 | 15225.00 | 0.00 | 15225.00 | 175 | 8 | 175 | 574 | 0.304878048780488 | 0.299647998577725 | 0.299647998577725 | false | false | false | true | ||||||||||||||||
| 6cb268b9-de3b-4eaa-bbed-7be562f5cd70 | 2026-09-02 09:55 | 2026-09-02 09:55 | 2026-09-02 09:55 | IGV | IGV260918P00104000 | put | 104.0000 | 2026-09-18 | 2.3000 | 2.3000 | 2.6800 | 104.7650 | 29670.00 | 0.00 | 29670.00 | 129 | 14 | 129 | 1004 | 0.128486055776892 | 0.315117173124354 | 0.315117173124354 | true | false | false | true | ||||||||||||||||
| f10a4956-652a-465d-8dae-ca8835a4c725 | 2026-09-02 09:55 | 2026-09-02 09:55 | 2026-09-02 09:55 | IGV | IGV260918P00104000 | put | 104.0000 | 2026-09-18 | 2.3000 | 2.3000 | 2.3100 | 104.7500 | 13800.00 | 0.00 | 13800.00 | 60 | 8 | 360 | 1004 | 0.358565737051793 | 0.314364215861002 | 0.314364215861002 | true | false | false | true | ||||||||||||||||
| 913679f1-d4c9-48ab-ab6b-1be3cb7ceab8 | 2026-09-02 09:55 | 2026-09-02 09:55 | 2026-09-02 09:55 | IGV | IGV260918P00104000 | put | 104.0000 | 2026-09-18 | 2.3000 | 2.3000 | 2.3100 | 104.7500 | 28290.00 | 0.00 | 28290.00 | 123 | 22 | 272 | 1004 | 0.270916334661355 | 0.314364215861002 | 0.314364215861002 | true | false | false | true | ||||||||||||||||
| bb95918d-f4bf-40d9-a5be-346259cfeb9c | 2026-09-02 09:55 | 2026-09-02 09:55 | 2026-09-02 09:55 | IGV | IGV260918P00104000 | put | 104.0000 | 2026-09-18 | 2.3000 | 2.3000 | 2.3100 | 104.7400 | 20700.00 | 0.00 | 20700.00 | 90 | 11 | 530 | 1004 | 0.527888446215139 | 0.313861586620134 | 0.313861586620134 | true | false | false | true | ||||||||||||||||
| 419d13df-7959-4b8b-b769-c5e7024b67e8 | 2026-09-02 09:55 | 2026-09-02 09:55 | 2026-09-02 09:55 | IGV | IGV260918P00104000 | put | 104.0000 | 2026-09-18 | 2.3000 | 2.3000 | 2.3100 | 104.7400 | 11500.00 | 0.00 | 11500.00 | 50 | 8 | 600 | 1004 | 0.597609561752988 | 0.313861586620134 | 0.313861586620134 | true | false | false | true | ||||||||||||||||
| 8bcb7041-bd1f-4354-8a78-4a3fbda8ea0f | 2026-09-02 09:56 | 2026-09-02 09:56 | 2026-09-02 09:56 | IGV | IGV260918P00104000 | put | 104.0000 | 2026-09-18 | 2.3000 | 2.3000 | 2.3100 | 104.7000 | 14490.00 | 0.00 | 14490.00 | 63 | 15 | 1097 | 1004 | 1.09262948207171 | 0.311845757851823 | 0.311845757851823 | true | false | false | true | ||||||||||||||||
| 320cec25-db4b-4232-886c-36bd6de47c52 | 2026-09-02 09:56 | 2026-09-02 09:56 | 2026-09-02 09:56 | IGV | IGV260918P00104000 | put | 104.0000 | 2026-09-18 | 2.3000 | 2.3000 | 2.3200 | 104.7000 | 11500.00 | 0.00 | 11500.00 | 50 | 6 | 1203 | 1004 | 1.19820717131474 | 0.311845757851823 | 0.311845757851823 | true | false | false | true | ||||||||||||||||
| 21bc0225-ca73-44c5-9aff-17af3c5cfd07 | 2026-09-02 09:56 | 2026-09-02 09:56 | 2026-09-02 09:56 | IGV | IGV260918P00104000 | put | 104.0000 | 2026-09-18 | 2.3000 | 2.3000 | 2.3800 | 104.7000 | 14490.00 | 0.00 | 14490.00 | 63 | 16 | 1034 | 1004 | 1.02988047808765 | 0.311845757851823 | 0.311845757851823 | true | false | false | true | ||||||||||||||||
| fe91b2f2-130f-41b4-8aed-b12646e0adbf | 2026-09-02 09:56 | 2026-09-02 09:56 | 2026-09-02 09:56 | IGV | IGV260918P00104000 | put | 104.0000 | 2026-09-18 | 2.3000 | 2.3000 | 2.3400 | 104.7200 | 72680.00 | 0.00 | 72680.00 | 316 | 19 | 1849 | 1004 | 1.84163346613546 | 0.312854739248024 | 0.312854739248024 | true | false | false | true | ||||||||||||||||
| d16b7f5b-9023-4fbf-a1df-93a1c873522f | 2026-09-03 09:52 | 2026-09-03 09:52 | 2026-09-03 09:52 | IGV | IGV260918P00104000 | put | 104.0000 | 2026-09-18 | 1.4600 | 1.4600 | 1.6500 | 106.3450 | 53728.00 | 0.00 | 53728.00 | 368 | 21 | 396 | 2454 | 0.161369193154034 | 0.29622559482668 | 0.29622559482668 | false | false | false | true | ||||||||||||||||
| 3cf5a3c3-ed5a-4d26-9277-68eeb189942d | 2026-09-18 11:42 | 2026-09-18 11:42 | 2026-09-18 11:42 | IGV | IGV260918P00104000 | put | 104.0000 | 2026-09-18 | 0.2500 | 0.2500 | 0.3000 | 104.2400 | 23700.00 | 0.00 | 23700.00 | 948 | 21 | 1162 | 2701 | 0.430211032950759 | 0.389668197738648 | 0.389668197738648 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:36:02.227679Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T13:56:06.315925Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T13:56:06.315925Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T13:56:06.315925Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T13:56:06.315925Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T13:56:06.315925Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:11:00.326314Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:11:00.326314Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:11:00.326314Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:11:00.326314Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14038397136.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14284070404.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |