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 | 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 |
|---|
| e0746c53-7a02-4ce9-801e-99e10c7d6a80 | 2026-08-25 11:21 | 2026-08-25 11:21 | 2026-08-25 11:21 | EWZ | EWZ260918C00035000 | call | 35.0000 | 2026-09-18 | 1.1700 | 1.1500 | 1.1700 | 35.3000 | 37908.00 | 37908.00 | 0.00 | 324 | 13 | 391 | 42831 | 0.00912890196353109 | 0.268507471096525 | 0.268507471096525 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 8633146199.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:37:01.391907Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f2666f64-8726-4c94-95ec-f52e3fffd3ef | 2026-08-21 11:59 | 2026-08-21 11:58 | 2026-08-21 11:58 | EWZ | EWZ260918C00035000 | call | 35.0000 | 2026-09-18 | 1.2600 | 1.2600 | 1.2900 | 35.2200 | 42840.00 | 0.00 | 42840.00 | 340 | 11 | 2576 | 40906 | 0.0629736468977656 | 0.281838567871883 | 0.281838567871883 | true | false | false | true | ||||||||||||||||
| bada0d04-dfd9-4c03-b3a6-f3c9887a33bc | 2026-08-21 09:58 | 2026-08-21 09:58 | 2026-08-21 09:58 | EWZ | EWZ260918C00035000 | call | 35.0000 | 2026-09-18 | 1.0200 | 1.0200 | 1.0400 | 34.8800 | 17034.00 | 0.00 | 17034.00 | 167 | 8 | 2133 | 40906 | 0.0521439397643378 | 0.266991389685882 | 0.266991389685882 | false | false | false | true | ||||||||||||||||
| ddaa2f29-d23f-46ec-b1c7-52b0d8077e8b | 2026-08-21 09:54 | 2026-08-21 09:54 | 2026-08-21 09:54 | EWZ | EWZ260918C00035000 | call | 35.0000 | 2026-09-18 | 1.0000 | 0.9600 | 1.0000 | 34.8050 | 12200.00 | 12200.00 | 0.00 | 122 | 9 | 1901 | 40906 | 0.0464724001368992 | 0.271661655421329 | 0.271661655421329 | false | false | false | true | ||||||||||||||||
| bb1cc2b9-a4c8-43e7-8b3a-e349687e7105 | 2026-08-21 09:54 | 2026-08-21 09:54 | 2026-08-21 09:54 | EWZ | EWZ260918C00035000 | call | 35.0000 | 2026-09-18 | 0.9900 | 0.9700 | 0.9900 | 34.8050 | 52272.00 | 52272.00 | 0.00 | 528 | 18 | 964 | 40906 | 0.0235662250036669 | 0.269061397708367 | 0.269061397708367 | false | false | false | true | ||||||||||||||||
| 1469334d-677b-4216-8148-a6b651d45b56 | 2026-08-19 10:46 | 2026-08-19 10:46 | 2026-08-19 10:46 | EWZ | EWZ260918C00035000 | call | 35.0000 | 2026-09-18 | 1.0200 | 1.0000 | 1.0200 | 34.7400 | 52428.00 | 52428.00 | 0.00 | 514 | 8 | 7175 | 33453 | 0.214480016739904 | 0.274820686269511 | 0.274820686269511 | false | false | false | true | ||||||||||||||||
| c0e4542b-13bc-4c8a-8949-e0a581480236 | 2026-08-19 10:42 | 2026-08-19 10:42 | 2026-08-19 10:42 | EWZ | EWZ260918C00035000 | call | 35.0000 | 2026-09-18 | 1.0200 | 1.0200 | 1.0300 | 34.7650 | 16320.00 | 0.00 | 16320.00 | 160 | 5 | 4001 | 33453 | 0.119600633724928 | 0.271705091430116 | 0.271705091430116 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:50:22.027850Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:50:22.027850Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |