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 |
|---|
| bb9be82e-771a-422f-9234-fa429e9c9b15 | 2026-09-24 11:54 | 2026-09-24 11:54 | 2026-09-24 11:54 | SPXW | SPXW260925C07650000 | call | 7650.0000 | 2026-09-25 | 38.2700 | 38.2000 | 38.6000 | 7672.2200 | 76540.00 | 0.00 | 76540.00 | 20 | 5 | 550 | 2704 | 0.203402366863905 | 0.156941868684378 | 0.156273147114198 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T15:54:32.289461Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| 4229e6a0-f15f-4cb1-bd84-94941b0bcac0 | 2026-09-24 11:32 | 2026-09-24 11:32 | 2026-09-24 11:32 | SPXW | SPXW260925C07650000 | call | 7650.0000 | 2026-09-25 | 34.5700 | 34.3000 | 34.6000 | 7664.7200 | 20740.00 | 20740.00 | 0.00 | 6 | 5 | 408 | 2704 | 0.150887573964497 | 0.162514877178221 | 0.162514877178221 | false | false | false | true | ||||||||||||||||
| f1f80851-f69b-4168-8fe3-4b38e0a1e14f | 2026-09-24 11:28 | 2026-09-24 11:28 | 2026-09-24 11:28 | SPXW | SPXW260925C07650000 | call | 7650.0000 | 2026-09-25 | 35.5000 | 35.3000 | 35.6000 | 7666.0800 | 24850.00 | 24850.00 | 0.00 | 7 | 6 | 369 | 2704 | 0.13646449704142 | 0.163704186357597 | 0.163704186357597 | false | false | false | true | ||||||||||||||||
| 3e0c9547-fe67-467d-b3ae-93f7fceb7f29 | 2026-09-24 11:13 | 2026-09-24 11:13 | 2026-09-24 11:13 | SPXW | SPXW260925C07650000 | call | 7650.0000 | 2026-09-25 | 35.4000 | 35.2000 | 35.5000 | 7645.0000 | 21240.00 | 21240.00 | 0.00 | 6 | 5 | 276 | 2704 | 0.10207100591716 | 0.1671172190879 | 0.1671172190879 | false | false | false | true | ||||||||||||||||
| eddc0baf-d8b0-4ebc-b5ee-907aef4ba598 | 2026-09-18 16:00 | 2026-09-18 16:00 | 2026-09-18 16:00 | SPXW | SPXW260925C07650000 | call | 7650.0000 | 2026-09-25 | 42.0000 | 43.5000 | 43.8000 | 7630.0000 | 6241200.00 | 0.00 | 6241200.00 | 1486 | 7 | 2842 | 1270 | 2.23779527559055 | 0.0922090660088509 | 0.0922090660088509 | false | true | false | true | ||||||||||||||||
| a88b22c2-7d04-45d3-8c16-9b729acbed87 | 2026-09-18 15:44 | 2026-09-18 15:44 | 2026-09-18 15:44 | SPXW | SPXW260925C07650000 | call | 7650.0000 | 2026-09-25 | 41.4000 | 41.3000 | 41.6000 | 7643.4700 | 414000.00 | 115920.00 | 298080.00 | 100 | 9 | 1213 | 1270 | 0.955118110236221 | 0.0988705291732779 | 0.0988705291732779 | false | false | false | true | ||||||||||||||||
| c1109d6c-7d9b-4a0f-bdbf-5b4b77d700fc | 2026-09-18 14:55 | 2026-09-18 14:55 | 2026-09-18 14:55 | SPXW | SPXW260925C07650000 | call | 7650.0000 | 2026-09-25 | 42.0600 | 41.8000 | 42.1000 | 7643.6300 | 126170.00 | 126170.00 | 0.00 | 30 | 5 | 739 | 1270 | 0.581889763779528 | 0.100101779710347 | 0.100101779710347 | false | false | false | true | ||||||||||||||||
| c916eb82-3106-4d03-8cd7-f4126d270555 | 2026-09-17 14:41 | 2026-09-17 14:40 | 2026-09-17 14:40 | SPXW | SPXW260925C07650000 | call | 7650.0000 | 2026-09-25 | 47.0000 | 46.8000 | 47.0000 | 7633.7800 | 173900.00 | 173900.00 | 0.00 | 37 | 8 | 611 | 1006 | 0.607355864811133 | 0.114486910570136 | 0.114486910570136 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:29:44.716579Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:14:35.650072Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |