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 | 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 |
|---|
| 0e993eea-14c5-43a2-8ca3-1f4e44428960 | 2026-09-29 13:26 | 2026-09-29 13:26 | 2026-09-29 13:26 | NUE | NUE270115C00240000 | call | 240.0000 | 2027-01-15 | 18.2000 | 17.7000 | 18.5000 | 237.1301 | 83730.00 | 10930.00 | 72800.00 | 46 | 10 | 48 | 217 | 0.221198156682028 | 0.352551881437017 | 0.35450495593409 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 53597109698.00 | 2026-10-26 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T17:28:10.749874Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 47a6a1df-fed5-438f-b433-53dba5bd5ffe | 2026-09-29 12:32 | 2026-09-29 12:32 | 2026-09-29 12:32 | NUE | NUE290119P00190000 | put | 190.0000 | 2029-01-19 | 23.6500 | 22.0000 | 25.5000 | 237.0000 | 236500.00 | 0.00 | 236500.00 | 100 | 2 | 100 | 0 | 0 | 0.420245687730768 | 0.420245687730768 | false | true | false | true | false | |||||||||||||||
| e48d9195-3d2e-4567-9942-6a5c81f4fece | 2026-09-28 12:50 | 2026-09-28 12:50 | 2026-09-28 12:50 | NUE | NUE280121C00260000 | call | 260.0000 | 2028-01-21 | 41.3000 | 40.5000 | 41.9000 | 244.2200 | 24780.00 | 12390.00 | 12390.00 | 6 | 5 | 16 | 135 | 0.118518518518519 | 0.371859251856797 | 0.371859251856797 | false | false | false | true | ||||||||||||||||
| 728cc565-a65d-4ec3-8382-9b756cf72bfe | 2026-09-25 13:12 | 2026-09-25 13:11 | 2026-09-25 13:11 | NUE | NUE261016P00240000 | put | 240.0000 | 2026-10-16 | 4.8000 | 4.5000 | 4.8000 | 247.6800 | 73440.00 | 73440.00 | 0.00 | 153 | 16 | 295 | 804 | 0.366915422885572 | 0.355097858992281 | 0.355097858992281 | false | false | false | true | ||||||||||||||||
| 6825667d-61b0-4355-89c7-7fdb2b31293b | 2026-09-24 10:36 | 2026-09-24 10:36 | 2026-09-24 10:36 | NUE | NUE261218P00230000 | put | 230.0000 | 2026-12-18 | 8.6000 | 8.6000 | 8.9000 | 250.2050 | 22360.00 | 0.00 | 22360.00 | 26 | 6 | 31 | 460 | 0.0673913043478261 | 0.383123872961015 | 0.383123872961015 | false | false | false | true | ||||||||||||||||
| 28720344-c7ee-4550-81cd-0aaa03473f4c | 2026-09-23 12:58 | 2026-09-23 12:58 | 2026-09-23 12:58 | NUE | NUE270115P00250000 | put | 250.0000 | 2027-01-15 | 20.4000 | 20.4000 | 21.1000 | 247.0750 | 144850.00 | 0.00 | 142800.00 | 71 | 15 | 81 | 355 | 0.228169014084507 | 0.374730174693998 | 0.376556982633049 | false | false | false | true | ||||||||||||||||
| 58faa535-7dae-4277-9728-51bc406479aa | 2026-09-22 15:52 | 2026-09-22 15:52 | 2026-09-22 15:52 | NUE | NUE270115C00300000 | call | 300.0000 | 2027-01-15 | 4.6000 | 4.6000 | 5.4000 | 245.5800 | 14260.00 | 0.00 | 14260.00 | 31 | 7 | 31 | 828 | 0.03743961352657 | 0.343932330451731 | 0.343932330451731 | false | false | false | true | ||||||||||||||||
| 7b61dd86-e6be-4191-a2f1-6cd01eb85181 | 2026-09-22 13:33 | 2026-09-22 13:33 | 2026-09-22 13:33 | NUE | NUE261016C00280000 | call | 280.0000 | 2026-10-16 | 0.8000 | 0.8000 | 0.9000 | 244.0000 | 10240.00 | 0.00 | 10240.00 | 128 | 19 | 146 | 505 | 0.289108910891089 | 0.356996797296574 | 0.356996797296574 | false | false | false | true | ||||||||||||||||
| 095ee80a-a102-4f49-a192-85e71fd659f1 | 2026-09-22 10:59 | 2026-09-22 10:59 | 2026-09-22 10:59 | NUE | NUE261120P00200000 | put | 200.0000 | 2026-11-20 | 2.0000 | 2.0000 | 2.3500 | 242.8950 | 11600.00 | 0.00 | 11600.00 | 58 | 16 | 59 | 13 | 4.53846153846154 | 0.413025225614102 | 0.413025225614102 | false | false | false | true |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 53597109698.00 |
| 2026-10-26 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:39:28.276769Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 55468834025.00 |
| 2026-10-26 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:56:37.183860Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 56095010891.00 |
| 2026-10-26 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:13:31.947650Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 56033754458.00 |
| 2026-10-26 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:39:59.397883Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 56033754458.00 |
| 2026-10-26 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:01:20.516262Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 55734278566.00 |
| 2026-10-26 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 55734278566.00 |
| 2026-10-26 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:40:26.166069Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 55734278566.00 |
| 2026-10-26 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:00:53.883267Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |