Simplify AnalyticsOptions 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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| db2a779c-8d35-4340-8028-b536e7fc62ec | 2026-08-17 09:45 | 2026-08-17 09:45 | 2026-08-17 09:45 | VIX | VIX260916C00024000 | call | 24.0000 | 2026-09-16 | 0.7200 | 0.6800 | 0.7200 | 14.9800 | 751750.00 | 751750.00 | 0.00 | 10441 | 11 | 10482 | 81143 | 0.129179350036356 | 1.62078609499879 | 1.62078609499879 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cfbf5138-5a4c-44ca-9bfb-cc6cf64404fe | 2026-08-17 09:45 | 2026-08-17 09:45 | 2026-08-17 09:45 | VIX | VIX260916C00024000 | call | 24.0000 | 2026-09-16 | 0.7300 | 0.6800 | 0.7400 | 14.9800 | 10949299.00 | 10949299.00 | 0.00 | 150000 | 10 | 160482 | 81143 | 1.97776764477527 | 1.62078609499879 | 1.62078609499879 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 178f1c81-9fba-4582-98bc-7f23fc8ff17f | 2026-08-17 10:19 | 2026-08-17 10:19 | 2026-08-17 10:19 | VIX | VIX261021C00024000 | call | 24.0000 | 2026-10-21 | 1.7200 | 1.6800 | 1.7300 | 14.9500 | 431000.00 | 431000.00 | 0.00 | 2500 | 10 | 7517 | 58571 | 0.128339963463147 | 1.56976142537795 | 1.56976142537795 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 528120a1-dc30-41a9-8721-3a8c0aece748 | 2026-08-20 13:02 | 2026-08-20 13:02 | 2026-08-20 13:02 | VIX | VIX270120C00020000 | call | 20.0000 | 2027-01-20 | 3.8900 | 3.8500 | 3.9000 | 15.6000 | 139726.00 | 139726.00 | 0.00 | 359 | 10 | 1284 | 7425 | 0.172929292929293 | 1.29278374065605 | 1.29278374065605 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 81a03a46-f43c-44db-860b-39c60afbacee | 2026-08-28 09:39 | 2026-08-28 09:39 | 2026-08-28 09:39 | VIX | VIX261021C00028000 | call | 28.0000 | 2026-10-21 | 0.9200 | 0.8700 | 0.9300 | 14.5400 | 11743337.00 | 11743337.00 | 0.00 | 127645 | 15 | 127645 | 66815 | 1.91042430591933 | 1.60058707880024 | 1.60058707880024 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e8f2be6c-f641-4972-98c2-dd0a667c74b4 | 2026-09-04 15:02 | 2026-09-04 15:02 | 2026-09-04 15:02 | VIX | VIX261118C00031000 | call | 31.0000 | 2026-11-18 | 0.9400 | 0.9000 | 1.0600 | 14.0100 | 11843997.00 | 11735241.00 | 108664.00 | 126000 | 14 | 126266 | 462 | 273.30303030303 | 1.54711705261359 | 1.54711705261359 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T19:05:15.166096Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 71a2345d-cc3f-48cb-ba27-7a519ff99944 | 2026-09-04 15:42 | 2026-09-04 15:42 | 2026-09-04 15:42 | VIX | VIX261118C00034000 | call | 34.0000 | 2026-11-18 | 0.8900 | 0.8400 | 0.8900 | 14.2500 | 11261612.00 | 11261612.00 | 0.00 | 126535 | 15 | 143158 | 804 | 178.057213930348 | 1.59733210204598 | 1.59733210204598 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T19:47:04.296573Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 071f10d6-ce20-4f19-a601-fa9814a2fcef | 2026-09-09 11:03 | 2026-09-09 11:03 | 2026-09-09 11:03 | VIX | VIX261118C00030000 | call | 30.0000 | 2026-11-18 | 1.1200 | 1.1000 | 1.1600 | 16.2300 | 3378450.00 | 0.00 | 0.00 | 30300 | 16 | 48215 | 145603 | 0.331140155079222 | 1.39927575033226 | 1.40372510684589 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T15:13:56.572588Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b77f9dab-ad55-4f69-934a-303fe461622c | 2026-09-10 13:41 | 2026-09-10 13:41 | 2026-09-10 13:41 | VIX | VIX261021C00024000 | call | 24.0000 | 2026-10-21 | 1.2200 | 1.1900 | 1.2200 | 17.5400 | 1219996.00 | 1219996.00 | 0.00 | 10000 | 10 | 37642 | 88430 | 0.425670021485921 | 1.28688757940043 | 1.28688757940043 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | 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 |
| a32d87ba-25b9-41d1-87b3-f3207919404f | 2026-09-10 16:21 | 2026-09-10 16:18 | 2026-09-10 16:18 | VIX | VIX261216C00020000 | call | 20.0000 | 2026-12-16 | 2.7700 | 2.7100 | 2.8000 | 17.8400 | 164540.00 | 0.00 | 0.00 | 595 | 5 | 3961 | 32586 | 0.121555269133984 | 0.953886523788127 | 0.956613854648909 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T13:30:31.573730Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b63b2d3a-6165-43b8-9310-531c42124bce | 2026-09-14 11:10 | 2026-09-14 11:10 | 2026-09-14 11:10 | VIX | VIX260916P00017000 | put | 17.0000 | 2026-09-16 | 0.4000 | 0.3600 | 0.4100 | 17.3200 | 133024.00 | 132984.00 | 40.00 | 3326 | 10 | 18750 | 200392 | 0.0935666094454869 | 1.05884651642986 | 1.07916778763787 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 93d5d6ec-1c7c-4f30-8f6c-4b1a05d74dd4 | 2026-09-15 10:33 | 2026-09-15 10:33 | 2026-09-15 10:33 | VIX | VIX261216C00040000 | call | 40.0000 | 2026-12-16 | 0.8100 | 0.7700 | 0.8200 | 17.5000 | 140997.00 | 140997.00 | 0.00 | 1740 | 9 | 2879 | 41392 | 0.0695545032856591 | 1.28805411033023 | 1.29247546731102 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:36:37.058930Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 7e25442b-2a81-4cdf-8a8e-685ff546ddcd | 2026-09-16 09:42 | 2026-09-16 09:42 | 2026-09-16 09:42 | VIX | VIX261118C00022000 | call | 22.0000 | 2026-11-18 | 1.7200 | 1.6700 | 1.7400 | 16.9100 | 150358.00 | 150358.00 | 0.00 | 875 | 5 | 876 | 61596 | 0.014221702707968 | 1.15694672496262 | 1.15694672496262 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T13:45:36.515971Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| d6aa8070-3a5c-4c63-a14a-e285e4277df7 | 2026-09-16 09:44 | 2026-09-16 09:44 | 2026-09-16 09:44 | VIX | VIX261021P00019000 | put | 19.0000 | 2026-10-21 | 2.2700 | 2.2500 | 2.3100 | 16.9500 | 2265000.00 | 0.00 | 2265000.00 | 10000 | 10 | 10001 | 112156 | 0.0891704411712258 | 0.437283167839024 | 0.443564872101219 | false | true | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T13:45:36.515971Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 870e430f-2235-4f82-94a0-31c01ad87c43 | 2026-09-21 15:12 | 2026-09-21 15:12 | 2026-09-21 15:12 | VIX | VIX261216C00020000 | call | 20.0000 | 2026-12-16 | 2.3500 | 2.3000 | 2.3700 | 15.0400 | 1036638.00 | 1036638.00 | 0.00 | 4409 | 29 | 8464 | 36401 | 0.232521084585588 | 1.31062363629801 | 1.31407938222599 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:15:34.344712Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 8638ac84-c246-4b93-a01b-f363ff2bc59a | 2026-09-21 15:13 | 2026-09-21 15:13 | 2026-09-21 15:13 | VIX | VIX261216C00020000 | call | 20.0000 | 2026-12-16 | 2.3700 | 2.3100 | 2.5100 | 15.0300 | 2373520.00 | 2321464.00 | 52056.00 | 10000 | 24 | 18466 | 36401 | 0.507293755666053 | 1.31910991963878 | 1.33293186707902 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:15:34.344712Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| ce512c1d-fc76-4c2b-8f51-304b119f7ae0 | 2026-09-21 15:50 | 2026-09-21 15:50 | 2026-09-21 15:50 | VIX | VIX261021P00017000 | put | 17.0000 | 2026-10-21 | 0.8600 | 0.8200 | 0.8800 | 14.8300 | 2736000.00 | 1376000.00 | 0.00 | 32000 | 14 | 43485 | 205104 | 0.212014392698338 | 0.634607430205288 | 0.634607430205288 | false | true | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:52:57.186278Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 94675bac-e896-469e-a58d-0757bcea3440 | 2026-09-21 16:12 | 2026-09-21 16:12 | 2026-09-21 16:12 | VIX | VIX261021P00015500 | put | 15.5000 | 2026-10-21 | 0.2100 | 0.1700 | 0.2200 | 14.0000 | 250912.00 | 250912.00 | 0.00 | 12000 | 6 | 14945 | 71252 | 0.209748498287767 | 0.497101750212991 | 0.497101750212991 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |