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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46efc976-c4be-4524-9f03-f9ff15bf1375 | 2026-08-14 15:55 | 2026-08-14 15:55 | 2026-08-14 15:55 | MUU | MUU260814C00030000 | call | 30.0000 | 2026-08-14 | 2.2000 | 2.2000 | 3.0000 | 32.2650 | 23105.00 | 0.00 | 23105.00 | 105 | 13 | 653 | 1288 | 0.506987577639752 | 42.3940370069356 | 42.3940370069356 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1040000000.00 | — | — | — | 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 |
| 6bcc065d-c934-45fc-aa1c-2f3409a5f3ec | 2026-08-17 11:03 | 2026-08-17 11:03 | 2026-08-17 11:03 | MUU | MUU260828C00040000 | call | 40.0000 | 2026-08-28 | 2.3700 | 1.7500 | 2.4000 | 36.3700 | 11850.00 | 10800.00 | 1050.00 | 50 | 5 | 120 | 186 | 0.645161290322581 | 1.37118950248184 | 1.4941981376374 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1040000000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d0385a85-22b1-443c-97e3-a731800b8d28 | 2026-08-17 15:12 | 2026-08-17 15:11 | 2026-08-17 15:11 | MUU | MUU260904C00033000 | call | 33.0000 | 2026-09-04 | 4.9100 | 4.8000 | 5.7000 | 35.0177 | 12277.00 | 2450.00 | 9827.00 | 25 | 6 | 55 | 15 | 3.66666666666667 | 1.2566677478431 | 1.26697997407059 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1040000000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c6db6290-45e7-4639-8978-5170f4d8e61e | 2026-08-26 12:18 | 2026-08-26 12:18 | 2026-08-26 12:18 | MUU | MUU261218C00035000 | call | 35.0000 | 2026-12-18 | 6.6200 | 6.1000 | 7.2000 | 29.5400 | 43004.00 | 0.00 | 43004.00 | 65 | 10 | 67 | 682 | 0.0982404692082111 | 1.27303889251413 | 1.27303889251413 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1040000000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 09c28b38-0e52-4d3d-9927-19bf800c13c6 | 2026-08-31 15:53 | 2026-08-31 15:53 | 2026-08-31 15:53 | MUU | MUU260904C00031000 | call | 31.0000 | 2026-09-04 | 1.2900 | 1.0500 | 1.3000 | 30.5250 | 12904.00 | 12904.00 | 0.00 | 100 | 6 | 1699 | 160 | 10.61875 | 1.16829084693575 | 1.17614971383351 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1040000000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ba7fd71a-adad-4c09-8fac-cf36f52a23aa | 2026-09-03 15:10 | 2026-09-03 15:10 | 2026-09-03 15:10 | MUU | MUU260911C00031500 | call | 31.5000 | 2026-09-11 | 1.3100 | 1.2000 | 1.3500 | 30.3200 | 13114.00 | 13114.00 | 0.00 | 100 | 5 | 131 | 26 | 5.03846153846154 | 1.00343202745842 | 1.00343202745842 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1040000000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9213da31-0e19-466a-bad2-c8471ccfd512 | 2026-09-03 15:59 | 2026-09-03 15:59 | 2026-09-03 15:59 | MUU | MUU260918C00030000 | call | 30.0000 | 2026-09-18 | 2.9500 | 2.9000 | 2.9500 | 30.6700 | 24164.00 | 23869.00 | 0.00 | 82 | 6 | 806 | 1254 | 0.64274322169059 | 1.04854962420617 | 1.05267779512301 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1040000000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1e753b96-0dd9-4f93-8576-1a805e3ed229 | 2026-09-04 09:36 | 2026-09-04 09:36 | 2026-09-04 09:36 | MUU | MUU261218C00035000 | call | 35.0000 | 2026-12-18 | 7.4300 | 7.1000 | 7.5000 | 32.9272 | 44606.00 | 44606.00 | 0.00 | 60 | 5 | 60 | 913 | 0.0657174151150055 | 1.15768370287216 | 1.15768370287216 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1040000000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T13:37:16.307537Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 28e415e0-652a-4ab4-8f82-12b470a8fae0 | 2026-09-08 11:29 | 2026-09-08 11:29 | 2026-09-08 11:29 | MUU | MUU261218P00020000 | put | 20.0000 | 2026-12-18 | 2.0600 | 1.8000 | 2.2000 | 34.3658 | 12380.00 | 12380.00 | 0.00 | 60 | 6 | 71 | 761 | 0.0932982917214192 | 1.30207249466709 | 1.30207249466709 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1040000000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:43:32.720264Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| faefa9fa-f008-4a3a-9c2c-adf63e1d0a7b | 2026-09-08 14:53 | 2026-09-08 14:53 | 2026-09-08 14:53 | MUU | MUU260911C00035000 | call | 35.0000 | 2026-09-11 | 1.2100 | 1.1500 | 1.3000 | 34.1000 | 48456.00 | 16974.00 | 31482.00 | 400 | 22 | 1703 | 2107 | 0.808258186995728 | 1.23404307362906 | 1.31046780250459 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1040000000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T19:03:39.512328Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d151d55f-2853-4992-8aae-ea993fbd1737 | 2026-09-10 13:23 | 2026-09-10 13:23 | 2026-09-10 13:23 | MUU | MUU270319C00033000 | call | 33.0000 | 2027-03-19 | 10.2700 | 10.0000 | 10.7000 | 31.9000 | 30801.00 | 4112.00 | 26689.00 | 30 | 7 | 89 | 46 | 1.93478260869565 | 1.16390748013439 | 1.16745550229044 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1040000000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T17:37:34.117542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f54ab714-0f9e-46a2-9157-5667ec7d08dd | 2026-09-14 09:31 | 2026-09-14 09:31 | 2026-09-14 09:31 | MUU | MUU270319C00030000 | call | 30.0000 | 2027-03-19 | 6.9900 | 6.9000 | 9.2000 | 27.2400 | 11190.00 | 0.00 | 11190.00 | 16 | 5 | 16 | 757 | 0.0211360634081902 | 1.00281088433263 | 1.01613478697947 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1040000000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T13:31:50.503893Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b1e12d3a-d226-4592-b215-2eae98ed4af4 | 2026-09-17 10:12 | 2026-09-17 10:12 | 2026-09-17 10:12 | MUU | MUU260918C00029000 | call | 29.0000 | 2026-09-18 | 2.4600 | 2.2500 | 2.6500 | 31.3000 | 10069.00 | 245.00 | 8354.00 | 41 | 8 | 97 | 374 | 0.259358288770053 | 1.33695158957468 | 1.36547293976904 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1040000000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| d5430e97-58bb-4ac7-8e5b-6690d230de2c | 2026-09-17 10:41 | 2026-09-17 10:41 | 2026-09-17 10:41 | MUU | MUU260918C00028000 | call | 28.0000 | 2026-09-18 | 3.7400 | 3.5000 | 3.8000 | 31.6500 | 30664.00 | 30664.00 | 0.00 | 82 | 5 | 463 | 499 | 0.927855711422846 | 1.58966165880805 | 1.58966165880805 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1040000000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:48:09.438351Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 0c9b2dcf-2093-4e08-9120-14188a1101c5 | 2026-09-17 10:42 | 2026-09-17 10:42 | 2026-09-17 10:42 | MUU | MUU260918C00028000 | call | 28.0000 | 2026-09-18 | 3.7600 | 3.5000 | 3.8000 | 31.6700 | 30814.00 | 30814.00 | 0.00 | 82 | 6 | 545 | 499 | 1.09218436873748 | 1.59584202838521 | 1.59584202838521 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1040000000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:48:09.438351Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| ac7b9933-ee23-4be0-bf12-c42726aaaa5f | 2026-09-18 14:30 | 2026-09-18 14:30 | 2026-09-18 14:30 | MUU | MUU260925P00032000 | put | 32.0000 | 2026-09-25 | 1.2600 | 1.2500 | 1.4000 | 33.0550 | 25183.00 | 0.00 | 25183.00 | 200 | 7 | 449 | 470 | 0.95531914893617 | 0.967507813899179 | 0.984761031706395 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1040000000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T18:43:10.830314Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |