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.
Simplify Analyticsuw_flow_alerts326,449 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 |
|---|
| 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 |
|---|
| 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 | false | 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 |
| 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 | ||||||||||||||||
| 0419abf1-974e-4c68-a3fd-3a387ff4500b | 2026-09-17 13:20 | 2026-09-17 13:20 | 2026-09-17 13:20 | NUE | NUE260918P00260000 | put | 260.0000 | 2026-09-18 | 1.7500 | 0.8000 | 2.2000 | 265.8900 | 218750.00 | 218750.00 | 0.00 | 1250 | 1 | 1296 | 806 | 1.60794044665012 | 0.73551168255604 | 0.73551168255604 | false | true | false | true | ||||||||||||||||
| c0246c6d-b817-42fa-bfc6-b93c5bf6308e | 2026-09-16 12:46 | 2026-09-16 12:45 | 2026-09-16 12:45 | NUE | NUE261016C00290000 | call | 290.0000 | 2026-10-16 | 2.8500 | 2.7500 | 3.5000 | 263.6000 | 51870.00 | 285.00 | 51585.00 | 182 | 11 | 195 | 335 | 0.582089552238806 | 0.357958346038637 | 0.357958346038637 | false | false | false | true | ||||||||||||||||
| 918eb722-14ad-4c4b-a7e9-6e51c4274d51 | 2026-09-14 10:13 | 2026-09-14 10:13 | 2026-09-14 10:13 | NUE | NUE260918C00260000 | call | 260.0000 | 2026-09-18 | 5.0200 | 3.7000 | 5.3000 | 257.7750 | 283389.00 | 249389.00 | 34000.00 | 565 | 65 | 577 | 1022 | 0.564579256360078 | 0.574654382801062 | 0.545550655606716 | true | false | false | true | ||||||||||||||||
| 0cd79b80-dff3-412b-8f9d-69398ca7905e | 2026-09-14 10:13 | 2026-09-14 10:13 | 2026-09-14 10:13 | NUE | NUE260918C00260000 | call | 260.0000 | 2026-09-18 | 5.1400 | 4.9000 | 5.8000 | 258.6700 | 129570.00 | 0.00 | 129570.00 | 252 | 8 | 843 | 1022 | 0.824853228962818 | 0.506835477386275 | 0.534654161048878 | true | false | false | true | ||||||||||||||||
| 8f13cc47-eb4a-46cb-a049-9b2dfa1525f7 | 2026-09-11 12:42 | 2026-09-11 12:41 | 2026-09-11 12:41 | NUE | NUE270617P00250000 | put | 250.0000 | 2027-06-17 | 25.9700 | 25.7000 | 28.0000 | 257.8400 | 225930.00 | 189680.00 | 28510.00 | 87 | 23 | 227 | 27 | 8.40740740740741 | 0.383241630491365 | 0.382099088047674 | true | false | false | true | ||||||||||||||||
| 403b9b6f-91e1-4a9e-bf12-5c173fbc732e | 2026-09-11 12:42 | 2026-09-11 12:41 | 2026-09-11 12:41 | NUE | NUE270617P00250000 | put | 250.0000 | 2027-06-17 | 25.8000 | 25.7000 | 27.1000 | 257.9500 | 67090.00 | 59350.00 | 7740.00 | 26 | 8 | 309 | 27 | 11.4444444444444 | 0.382184512472261 | 0.38256867726848 | false | false | false | true | ||||||||||||||||
| dac8ce71-3e28-4ba0-af7a-562976d76347 | 2026-09-10 13:47 | 2026-09-10 13:47 | 2026-09-10 13:47 | NUE | NUE261016P00250000 | put | 250.0000 | 2026-10-16 | 9.1000 | 9.1000 | 9.5000 | 254.2900 | 92820.00 | 0.00 | 92820.00 | 102 | 18 | 118 | 192 | 0.614583333333333 | 0.365410509929595 | 0.365410509929595 | false | false | false | true | ||||||||||||||||
| 0a26731c-a75f-42cb-b401-0f5ce493be9b | 2026-09-10 11:43 | 2026-09-10 11:43 | 2026-09-10 11:43 | NUE | NUE261218P00230000 | put | 230.0000 | 2026-12-18 | 9.0000 | 8.3000 | 9.0000 | 255.6050 | 334790.00 | 334790.00 | 0.00 | 372 | 40 | 373 | 94 | 3.96808510638298 | 0.397741814019012 | 0.397741814019012 | false | false | false | true | ||||||||||||||||
| 4bc549c8-1ae3-476d-99d5-38f131a6fa21 | 2026-09-04 10:51 | 2026-09-04 10:51 | 2026-09-04 10:51 | NUE | NUE261016P00260000 | put | 260.0000 | 2026-10-16 | 11.4000 | 11.4000 | 12.0000 | 261.2200 | 55860.00 | 0.00 | 55860.00 | 49 | 14 | 49 | 48 | 1.02083333333333 | 0.356281353895919 | 0.356281353895919 | false | false | false | true | ||||||||||||||||
| 3c78451a-3737-4d67-bc84-e05f6fd5c074 | 2026-09-03 11:26 | 2026-09-03 11:25 | 2026-09-03 11:25 | NUE | NUE270617C00280000 | call | 280.0000 | 2027-06-17 | 31.0000 | 30.7000 | 31.0000 | 264.5750 | 58900.00 | 58900.00 | 0.00 | 19 | 7 | 32 | 14 | 2.28571428571429 | 0.361651011475232 | 0.361651011475232 | false | false | false | true | ||||||||||||||||
| 1236d448-5b2e-47b4-9fe1-97530fe8adfa | 2026-08-25 12:42 | 2026-08-25 12:42 | 2026-08-25 12:42 | NUE | NUE261016P00240000 | put | 240.0000 | 2026-10-16 | 10.0000 | 10.0000 | 11.4000 | 246.4200 | 50000.00 | 0.00 | 50000.00 | 50 | 20 | 51 | 191 | 0.267015706806283 | 0.371905202282042 | 0.370181748010249 | false | false | false | true | ||||||||||||||||
| 88f3c5a3-6ef4-411d-868d-be7803509fa4 | 2026-08-21 12:33 | 2026-08-21 12:33 | 2026-08-21 12:33 | NUE | NUE261016C00260000 | call | 260.0000 | 2026-10-16 | 8.0000 | 8.0000 | 8.5000 | 243.8900 | 80800.00 | 0.00 | 80800.00 | 101 | 17 | 105 | 350 | 0.3 | 0.360022953114514 | 0.360022953114514 | false | false | false | true | ||||||||||||||||
| 03d2f16d-3bd8-4844-8f7d-a285b34a9b87 | 2026-08-21 10:19 | 2026-08-21 10:19 | 2026-08-21 10:19 | NUE | NUE260821C00240000 | call | 240.0000 | 2026-08-21 | 10.0000 | 10.0000 | 11.8000 | 250.1500 | 54000.00 | 0.00 | 54000.00 | 54 | 7 | 60 | 647 | 0.0927357032457496 | 2.09971631115706 | 2.09971631115706 | false | false | false | true | ||||||||||||||||
| 8e2a978d-abe8-4352-b66d-b7f7cc77a8a6 | 2026-08-19 14:08 | 2026-08-19 14:08 | 2026-08-19 14:08 | NUE | NUE260821P00250000 | put | 250.0000 | 2026-08-21 | 8.5000 | 6.3000 | 9.8000 | 243.2300 | 56100.00 | 56100.00 | 0.00 | 66 | 6 | 1441 | 241 | 5.9792531120332 | 0.595846743331355 | 0.595846743331355 | false | false | false | true | ||||||||||||||||
| 8238eccb-db30-4ae4-9eca-e78c991a25b6 | 2026-08-19 14:08 | 2026-08-19 14:08 | 2026-08-19 14:08 | NUE | NUE260821P00250000 | put | 250.0000 | 2026-08-21 | 8.5000 | 7.5000 | 10.0000 | 243.1350 | 65450.00 | 56100.00 | 9350.00 | 77 | 8 | 1375 | 241 | 5.70539419087137 | 0.584273598889145 | 0.584273598889145 | false | false | false | true | ||||||||||||||||
| 23d666c0-5e39-4f48-9e74-e2d2de4775a0 | 2026-08-19 13:49 | 2026-08-19 13:49 | 2026-08-19 13:49 | NUE | NUE260821P00250000 | put | 250.0000 | 2026-08-21 | 3.0000 | 2.1000 | 5.0000 | 251.0500 | 75585.00 | 69300.00 | 6285.00 | 252 | 8 | 1036 | 241 | 4.29875518672199 | 0.476336174448116 | 0.476336174448116 | false | false | false | true |
| 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 |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Basic Materials |
| 60153816735.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 59141951220.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 57769353380.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:14:09.812180Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 57769353380.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:14:09.812180Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 57769353380.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T16:54:27.741510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 57769353380.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T16:54:27.741510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 57769353380.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:09:00.187388Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 57769353380.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T15:47:40.219521Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 57769353380.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 57769353380.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:27:44.291947Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 57769353380.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:59:46.608693Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 57769353380.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:43:46.028086Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 57769353380.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 57769353380.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:37:13.611011Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 57769353380.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:37:13.611011Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Basic Materials |
| 57769353380.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |