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_alerts474,253 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 |
|---|
| fcabbad2-440d-4833-b431-9bda27b75e63 | 2026-08-31 10:04 | 2026-08-31 10:04 | 2026-08-31 10:04 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 67.2300 | 66.4000 | 67.4000 | 466.1700 | 67235.00 | 67235.00 | 0.00 | 10 | 10 | 11 | 4402 | 0.00249886415265788 | 0.807055746608614 | 0.800148237800662 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 168529643685.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7e0d8518-60cd-49a9-91b7-471cf1b66980 | 2026-09-02 09:57 | 2026-09-02 09:57 | 2026-09-02 09:57 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 51.4500 | 51.4000 | 51.4500 | 453.6900 | 2932650.00 | 411600.00 | 0.00 | 570 | 17 | 630 | 4428 | 0.142276422764228 | 0.630245041487365 | 0.630245041487365 | false | false | false | true | ||||||||||||||||
| 33fa433f-e190-4a24-a6c0-7df05bbcdddb | 2026-09-02 09:59 | 2026-09-02 09:58 | 2026-09-02 09:58 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 50.9700 | 50.4000 | 51.0000 | 452.8300 | 157995.00 | 107045.00 | 50950.00 | 31 | 7 | 685 | 4428 | 0.154697380307136 | 0.653222315018051 | 0.639078149022922 | true | false | false | true | ||||||||||||||||
| a2498f20-85a5-46fd-b128-63650604f014 | 2026-09-02 10:04 | 2026-09-02 10:04 | 2026-09-02 10:04 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 47.6500 | 47.3000 | 47.6500 | 448.3050 | 1839290.00 | 1839290.00 | 0.00 | 386 | 13 | 1126 | 4428 | 0.254290876242096 | 0.645974393732381 | 0.645974393732381 | false | false | false | true | ||||||||||||||||
| ee0b8be6-8e10-4f72-b23b-2f504f62fd37 | 2026-09-02 12:45 | 2026-09-02 12:44 | 2026-09-02 12:44 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 53.2000 | 53.2000 | 53.3000 | 456.4600 | 260680.00 | 0.00 | 5320.00 | 49 | 47 | 4246 | 4428 | 0.958897922312556 | 0.611018881284426 | 0.611018881284426 | false | false | false | true | ||||||||||||||||
| b069c517-4c43-4077-a9ea-c3570519c144 | 2026-09-02 12:45 | 2026-09-02 12:45 | 2026-09-02 12:45 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 54.5000 | 54.5000 | 54.7500 | 458.0400 | 130800.00 | 0.00 | 130800.00 | 24 | 13 | 4272 | 4428 | 0.964769647696477 | 0.610956988806704 | 0.610956988806704 | false | false | false | true | ||||||||||||||||
| 2b4f7e8d-de89-48a2-ae4c-54b1d4c0caa8 | 2026-09-02 12:46 | 2026-09-02 12:45 | 2026-09-02 12:45 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 54.5000 | 54.5000 | 54.7500 | 457.9943 | 59950.00 | 0.00 | 59950.00 | 11 | 11 | 4285 | 4428 | 0.967705510388437 | 0.612496257625236 | 0.612496257625236 | true | false | false | true | ||||||||||||||||
| 248ea5ca-8eed-417c-a76d-5eb75af974ea | 2026-09-02 12:46 | 2026-09-02 12:46 | 2026-09-02 12:46 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 54.5000 | 54.5000 | 55.0500 | 458.2500 | 343350.00 | 0.00 | 343350.00 | 63 | 42 | 4348 | 4428 | 0.98193315266486 | 0.603814199400228 | 0.603814199400228 | false | false | false | true | ||||||||||||||||
| b4eb29d6-c1ab-4a41-a1de-1324aac7a879 | 2026-09-02 12:47 | 2026-09-02 12:47 | 2026-09-02 12:47 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 54.5000 | 54.5000 | 55.0000 | 458.1600 | 234350.00 | 0.00 | 234350.00 | 43 | 37 | 4391 | 4428 | 0.991644083107498 | 0.593400939743277 | 0.606889608277567 | true | false | false | true | ||||||||||||||||
| 55381e46-9f25-4295-aa4e-991370df7bd9 | 2026-09-02 14:17 | 2026-09-02 14:17 | 2026-09-02 14:17 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 68.2000 | 67.7500 | 68.2000 | 473.9650 | 75020.00 | 75020.00 | 0.00 | 11 | 11 | 4413 | 4428 | 0.996612466124661 | 0.612279287516455 | 0.612279287516455 | false | false | false | true | ||||||||||||||||
| 1d6383ae-e9f9-42d5-afd4-9d0735857e42 | 2026-09-02 14:17 | 2026-09-02 14:17 | 2026-09-02 14:17 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 68.2000 | 67.6000 | 68.2000 | 473.9650 | 136400.00 | 136400.00 | 0.00 | 20 | 18 | 4433 | 4428 | 1.00112917795845 | 0.629054092497323 | 0.612279287516455 | false | false | false | true | ||||||||||||||||
| 2c0c6a4f-71a6-4f79-bcfd-c36d709a6491 | 2026-09-02 14:17 | 2026-09-02 14:17 | 2026-09-02 14:17 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 68.2000 | 67.8000 | 68.2000 | 473.7750 | 136400.00 | 136400.00 | 0.00 | 20 | 18 | 4462 | 4428 | 1.00767841011743 | 0.620994317947464 | 0.620994317947464 | false | false | false | true | ||||||||||||||||
| 1c2a079e-2fe3-4937-8121-08b47467708d | 2026-09-02 14:17 | 2026-09-02 14:17 | 2026-09-02 14:17 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 68.2000 | 68.0000 | 68.2000 | 473.7750 | 102300.00 | 102300.00 | 0.00 | 15 | 15 | 4477 | 4428 | 1.01106594399277 | 0.620994317947464 | 0.620994317947464 | false | false | false | true | ||||||||||||||||
| 8b17f6bb-6c03-4ed8-909a-374e4c30cfa2 | 2026-09-02 14:18 | 2026-09-02 14:18 | 2026-09-02 14:18 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 68.2000 | 67.9000 | 68.2000 | 474.0700 | 136400.00 | 136400.00 | 0.00 | 20 | 18 | 4502 | 4428 | 1.016711833785 | 0.607364923238749 | 0.607364923238749 | false | false | false | true | ||||||||||||||||
| 3515e96f-d54e-499e-9c61-a57c135581d6 | 2026-09-02 14:18 | 2026-09-02 14:18 | 2026-09-02 14:18 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 68.2000 | 68.0000 | 69.6500 | 474.1100 | 136400.00 | 129580.00 | 6820.00 | 20 | 16 | 4522 | 4428 | 1.02122854561879 | 0.60547342552367 | 0.60547342552367 | false | false | false | true | ||||||||||||||||
| f014d2b7-6f7a-4197-a582-cace7be7b5b3 | 2026-09-02 14:19 | 2026-09-02 14:19 | 2026-09-02 14:19 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 68.2500 | 68.2000 | 68.2500 | 474.5000 | 238875.00 | 6825.00 | 0.00 | 35 | 33 | 4557 | 4428 | 1.02913279132791 | 0.589218270098406 | 0.589218270098406 | false | false | false | true | ||||||||||||||||
| 8b923d10-0f15-4184-8a9b-1d6d03b596b2 | 2026-09-02 14:19 | 2026-09-02 14:19 | 2026-09-02 14:19 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 68.7000 | 68.5000 | 68.7000 | 474.7899 | 116790.00 | 116790.00 | 0.00 | 17 | 16 | 4574 | 4428 | 1.03297199638663 | 0.59974775344081 | 0.59974775344081 | false | false | false | true | ||||||||||||||||
| 3369a467-6976-45ee-87e8-2bcc12f1d360 | 2026-09-02 14:19 | 2026-09-02 14:19 | 2026-09-02 14:19 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 68.7000 | 68.5500 | 68.7000 | 474.3291 | 96180.00 | 96180.00 | 0.00 | 14 | 12 | 4588 | 4428 | 1.03613369467028 | 0.621525343180934 | 0.621525343180934 | false | false | false | true | ||||||||||||||||
| 03e4808f-443d-492b-8e6b-9184a41a708e | 2026-09-02 14:19 | 2026-09-02 14:19 | 2026-09-02 14:19 | DELL | DELL260918C00410000 | call | 410.0000 | 2026-09-18 | 68.7000 | 68.5000 | 68.9000 | 474.4350 | 75570.00 | 68700.00 | 0.00 | 11 | 11 | 4599 | 4428 | 1.03861788617886 | 0.616644831470445 | 0.616644831470445 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:11:00.326314Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:11:00.326314Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:11:00.326314Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:56:20.498446Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:56:20.498446Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:56:20.498446Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:56:20.498446Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:56:20.498446Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |