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 |
|---|
| 4d7b1a53-f3a5-491d-add3-48f2bbccc91c | 2026-09-15 10:48 | 2026-09-15 10:48 | 2026-09-15 10:48 | VIX | VIX261021C00022000 | call | 22.0000 | 2026-10-21 | 1.2600 | 1.2500 | 1.2700 | 17.5600 | 566370.00 | 406980.00 | 145152.00 | 4495 | 13 | 15770 | 155648 | 0.101318359375 | 1.19980552297462 | 1.19980552297462 | false | 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-15T14:53:20.680156Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 935127ad-f48b-4f84-a5ff-dcfb28454cad | 2026-09-15 10:48 | 2026-09-15 10:48 | 2026-09-15 10:48 | VIX | VIX261021C00022000 | call | 22.0000 | 2026-10-21 | 1.2600 | 1.2500 | 1.2800 | 17.5600 | 133938.00 | 123858.00 | 10080.00 | 1063 | 16 | 17833 | 155648 | 0.114572625411184 | 1.19980552297462 | 1.19980552297462 | false | false | false | |||||||||||||||||
| 077f69fe-9237-41c3-ae95-ab1ec20918c7 | 2026-09-15 10:50 | 2026-09-15 10:50 | 2026-09-15 10:50 | VIX | VIX261021C00022000 | call | 22.0000 | 2026-10-21 | 1.2900 | 1.2600 | 1.3100 | 17.6500 | 858624.00 | 394353.00 | 464271.00 | 6656 | 34 | 24506 | 155648 | 0.157445004111842 | 1.19918987938228 | 1.19918987938228 | false | false | false | |||||||||||||||||
| ddce16cc-fa33-4056-9500-4b71192575ff | 2026-09-23 10:00 | 2026-09-23 10:00 | 2026-09-23 10:00 | VIX | VIX261021C00022000 | call | 22.0000 | 2026-10-21 | 0.7300 | 0.7000 | 0.7500 | 14.4300 | 13943.00 | 12556.00 | 1387.00 | 191 | 10 | 572 | 169372 | 0.00337718158845618 | 1.60991009035581 | 1.60991009035581 | false | false | false | true | ||||||||||||||||
| 54dd8c17-80d5-4b8e-abf2-e358f536ed68 | 2026-09-23 10:21 | 2026-09-23 10:21 | 2026-09-23 10:21 | VIX | VIX261021C00022000 | call | 22.0000 | 2026-10-21 | 0.7900 | 0.7500 | 0.7900 | 14.7000 | 789763.00 | 789763.00 | 0.00 | 9997 | 9 | 10603 | 169372 | 0.0626018468223791 | 1.60546785143853 | 1.60546785143853 | true | false | false | true | ||||||||||||||||
| f5d070ae-41fb-44b1-8a4a-05be1ee1b795 | 2026-09-23 14:11 | 2026-09-23 14:11 | 2026-09-23 14:11 | VIX | VIX261021C00022000 | call | 22.0000 | 2026-10-21 | 0.8100 | 0.7700 | 0.8200 | 15.0300 | 348300.00 | 348300.00 | 0.00 | 4300 | 7 | 53968 | 169372 | 0.318635902038117 | 1.55743629601758 | 1.55743629601758 | false | false | false | true | ||||||||||||||||
| 9268745c-0998-4daf-bea2-c22f7af879de | 2026-09-29 13:39 | 2026-09-29 13:39 | 2026-09-29 13:39 | VIX | VIX261021C00022000 | call | 22.0000 | 2026-10-21 | 0.7900 | 0.7500 | 0.8000 | 16.2700 | 39500.00 | 39500.00 | 0.00 | 500 | 7 | 8646 | 229804 | 0.0376233659988512 | 1.48483930146325 | 1.48483930146325 | false | 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-15T14:53:20.680156Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:00:44.029710Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:22:47.791063Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:19:20.444616Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:44:25.905906Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |