Options flow alerts (market-wide)
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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| c8dd49cc-35bb-4f7c-9e38-08428e765042 | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | SNDK | SNDK260821C01710000 | call | 1710.0000 | 2026-08-21 | 78.9700 | 76.6000 | 79.7000 | 1717.4100 | 315880.00 | 260650.00 | 55230.00 | 40 | 13 | 83 | 194 | 0.427835051546392 | 1.05105547683345 | 1.04545170737279 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 227240825362.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d5353ce5-62d3-4aff-b9f7-df2d3194adc3 | 2026-08-17 09:33 | 2026-08-17 09:33 | 2026-08-17 09:33 | SNDK | SNDK260821C01710000 | call | 1710.0000 | 2026-08-21 | 85.2700 | 83.9000 | 85.5000 | 1727.6800 | 136436.00 | 85380.00 | 51056.00 | 16 | 11 | 180 | 194 | 0.927835051546392 | 1.04281809006816 | 1.05460841942794 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 227240825362.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d1bdbed0-1e2f-4a01-99ce-85931c56dbf5 | 2026-08-17 10:54 | 2026-08-17 10:54 | 2026-08-17 10:54 | SNDK | SNDK260821C01710000 | call | 1710.0000 | 2026-08-21 | 137.3000 | 133.3000 | 137.3000 | 1809.2000 | 3775732.00 | 3775732.00 | 0.00 | 275 | 40 | 625 | 194 | 3.22164948453608 | 1.05277542667799 | 1.05277542667799 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 227240825362.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c7b902ab-48d9-4fa9-8dea-581916c3b581 | 2026-08-17 15:52 | 2026-08-17 15:52 | 2026-08-17 15:52 | SNDK | SNDK260821C01710000 | call | 1710.0000 | 2026-08-21 | 114.0000 | 114.0000 | 115.8000 | 1783.8000 | 159601.00 | 0.00 | 159601.00 | 14 | 8 | 769 | 194 | 3.9639175257732 | 0.968134308497799 | 0.968284333810944 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 227240825362.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:59:29.758034Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a421ef16-c832-4396-a498-cdfb6e3d9625 | 2026-08-18 09:31 | 2026-08-18 09:31 | 2026-08-18 09:31 | SNDK | SNDK260821C01710000 | call | 1710.0000 | 2026-08-21 | 68.5800 | 67.0000 | 70.4000 | 1713.4900 | 89160.00 | 48480.00 | 40680.00 | 13 | 8 | 42 | 347 | 0.121037463976945 | 1.12133475757709 | 1.08717336583311 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 227240825362.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| edbe1f39-d5a5-4116-ae40-ac92a191dcfc | 2026-08-18 09:31 | 2026-08-18 09:31 | 2026-08-18 09:31 | SNDK | SNDK260821C01710000 | call | 1710.0000 | 2026-08-21 | 74.0000 | 73.3000 | 76.2000 | 1720.2036 | 103600.00 | 22120.00 | 81480.00 | 14 | 8 | 73 | 347 | 0.210374639769452 | 1.10649557384841 | 1.09840797182651 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 227240825362.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7b275983-300e-4fcd-8eb9-4b209e29e657 | 2026-08-18 09:33 | 2026-08-18 09:32 | 2026-08-18 09:32 | SNDK | SNDK260821C01710000 | call | 1710.0000 | 2026-08-21 | 71.7000 | 70.5500 | 72.3000 | 1717.2600 | 200760.00 | 114480.00 | 57520.00 | 28 | 8 | 128 | 347 | 0.368876080691643 | 1.09552163258493 | 1.09669003889772 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 227240825362.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3e6bba89-e68d-4f56-8074-13a1ecc14a8d | 2026-08-18 09:35 | 2026-08-18 09:34 | 2026-08-18 09:34 | SNDK | SNDK260821C01710000 | call | 1710.0000 | 2026-08-21 | 69.9500 | 69.0000 | 70.6000 | 1714.8250 | 195850.00 | 98140.00 | 97710.00 | 28 | 8 | 190 | 347 | 0.547550432276657 | 1.08865333456566 | 1.08380042285512 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 227240825362.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d3ba01d1-fa47-451f-a1f8-131af67359ea | 2026-08-18 11:29 | 2026-08-18 11:29 | 2026-08-18 11:29 | SNDK | SNDK260821C01710000 | call | 1710.0000 | 2026-08-21 | 38.8000 | 38.0000 | 39.3000 | 1650.6440 | 65960.00 | 11640.00 | 54320.00 | 17 | 13 | 673 | 347 | 1.93948126801153 | 1.05299944044364 | 1.05299944044364 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 227240825362.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b1ac50ca-0ba8-4611-a5bc-941aa243f999 | 2026-08-18 11:37 | 2026-08-18 11:37 | 2026-08-18 11:37 | SNDK | SNDK260821C01710000 | call | 1710.0000 | 2026-08-21 | 32.7000 | 32.7000 | 33.1000 | 1634.6786 | 166770.00 | 0.00 | 166770.00 | 51 | 17 | 734 | 347 | 2.11527377521614 | 1.04414485724999 | 1.04523808476219 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 227240825362.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 32da2240-62c7-4696-9ae1-9bfca42769d3 | 2026-08-19 09:32 | 2026-08-19 09:32 | 2026-08-19 09:32 | SNDK | SNDK260821C01710000 | call | 1710.0000 | 2026-08-21 | 42.2800 | 39.2000 | 43.9000 | 1681.5000 | 295960.00 | 151590.00 | 144370.00 | 70 | 5 | 257 | 497 | 0.517102615694165 | 1.09830788792724 | 1.10753472975282 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 227240825362.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5537c9f4-3779-4c2c-9d10-b6c0d4a59b86 | 2026-08-19 09:51 | 2026-08-19 09:51 | 2026-08-19 09:51 | SNDK | SNDK260821C01710000 | call | 1710.0000 | 2026-08-21 | 14.0200 | 13.9000 | 14.4000 | 1576.1400 | 196222.00 | 166600.00 | 29622.00 | 140 | 7 | 489 | 497 | 0.983903420523139 | 1.19595717432744 | 1.19280546790092 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 227240825362.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |