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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| f964776e-0c86-4e29-a989-7ac87bb29af1 | 2026-09-18 15:51 | 2026-09-18 15:51 | 2026-09-18 15:51 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 7.3500 | 7.2900 | 7.3500 | 720.0000 | 104370.00 | 104370.00 | 0.00 | 142 | 27 | 696 | 3778 | 0.18422445738486 | 0.151801227878598 | 0.151801227878598 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 485431540564.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| e20846c7-0193-4db8-9bb8-34e47f611876 | 2026-09-16 13:19 | 2026-09-16 13:19 | 2026-09-16 13:19 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 15.0000 | 14.9200 | 15.0500 | 709.6601 | 262500.00 | 262500.00 | 0.00 | 175 | 5 | 368 | 3702 | 0.0994057266342518 | 0.173393502989845 | 0.173393502989845 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| e1a874ba-0f46-4dc0-b4ab-5b9af9fea038 | 2026-09-16 13:19 | 2026-09-16 13:19 | 2026-09-16 13:19 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 15.0000 | 14.9100 | 15.0500 | 709.6650 | 112500.00 | 76500.00 | 36000.00 | 75 | 5 | 193 | 3702 | 0.0521339816315505 | 0.173454154837591 | 0.173454154837591 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| d64c1c57-09e5-4e15-b008-234382cb068e | 2026-09-11 15:04 | 2026-09-11 15:04 | 2026-09-11 15:04 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 12.2500 | 12.2000 | 12.3000 | 715.9650 | 245000.00 | 205800.00 | 39200.00 | 200 | 6 | 664 | 3527 | 0.188261979018996 | 0.167221457357537 | 0.167221457357537 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 482508363106.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c3331c68-13ad-4dbc-908f-2b6ac6915279 | 2026-09-11 15:04 | 2026-09-11 15:04 | 2026-09-11 15:04 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 12.3000 | 12.2500 | 12.3300 | 715.8700 | 205410.00 | 143910.00 | 61500.00 | 167 | 6 | 464 | 3527 | 0.131556563651829 | 0.167215285640323 | 0.167215285640323 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 482508363106.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 261a1216-241e-41e0-bdd4-4ff6c17eebd0 | 2026-08-28 12:20 | 2026-08-28 12:20 | 2026-08-28 12:20 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 15.5800 | 15.5300 | 15.6000 | 716.8850 | 548416.00 | 300694.00 | 247722.00 | 352 | 8 | 3191 | 2876 | 1.10952712100139 | 0.17737580455793 | 0.17737580455793 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:25:17.992358Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c79d8a49-b39b-473f-9f23-d0fa2bb1a669 | 2026-08-28 12:20 | 2026-08-28 12:20 | 2026-08-28 12:20 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 15.5300 | 15.5200 | 15.5800 | 716.8650 | 776500.00 | 0.00 | 776500.00 | 500 | 5 | 2839 | 2876 | 0.987134909596662 | 0.176678934422322 | 0.176678934422322 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:25:17.992358Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6f26b3d9-3015-4c2e-86aa-a51eb87401bd | 2026-08-28 12:19 | 2026-08-28 12:19 | 2026-08-28 12:19 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 15.5500 | 15.5500 | 15.6900 | 716.8700 | 175715.00 | 0.00 | 175715.00 | 113 | 23 | 2327 | 2876 | 0.809109874826147 | 0.17694038011462 | 0.17694038011462 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:25:17.992358Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ad635e93-893e-446d-8aab-726bda43c2dd | 2026-08-28 10:20 | 2026-08-28 10:20 | 2026-08-28 10:20 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 14.7800 | 14.6900 | 14.7800 | 719.2300 | 147800.00 | 128586.00 | 0.00 | 100 | 5 | 1786 | 2876 | 0.621001390820584 | 0.181263186150614 | 0.181263186150614 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:22:34.427319Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e956af6a-9813-4905-8218-8ddef6968e5a | 2026-08-28 10:18 | 2026-08-28 10:18 | 2026-08-28 10:18 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 14.9800 | 14.8700 | 14.9800 | 719.0400 | 149791.00 | 136318.00 | 13473.00 | 100 | 16 | 1686 | 2876 | 0.586230876216968 | 0.182427186342523 | 0.182543376489066 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:22:34.427319Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fbeca0a6-53c5-4152-9c1a-93c4042bb61f | 2026-08-28 10:11 | 2026-08-28 10:11 | 2026-08-28 10:11 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 15.6000 | 15.4800 | 15.6000 | 717.8700 | 156000.00 | 156000.00 | 0.00 | 100 | 5 | 983 | 2876 | 0.341794158553547 | 0.183226921693918 | 0.183226921693918 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:22:34.427319Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d8b0b0cb-48bd-414f-a81e-6897e4827bed | 2026-08-28 10:10 | 2026-08-28 10:10 | 2026-08-28 10:10 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 15.1600 | 15.0300 | 15.1600 | 718.8100 | 151600.00 | 151600.00 | 0.00 | 100 | 7 | 832 | 2876 | 0.289290681502086 | 0.183365672523676 | 0.183365672523676 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:22:34.427319Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a7b4ba3e-d562-4ad9-8e4b-16a55f3e1c8c | 2026-08-28 10:09 | 2026-08-28 10:09 | 2026-08-28 10:09 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 15.1100 | 14.9600 | 15.1100 | 718.9400 | 151100.00 | 151100.00 | 0.00 | 100 | 12 | 732 | 2876 | 0.25452016689847 | 0.183502808193692 | 0.183502808193692 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:22:34.427319Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cc6440bd-8263-4e20-98ce-6544f4a41bdc | 2026-08-28 10:06 | 2026-08-28 10:06 | 2026-08-28 10:06 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 15.3300 | 15.1500 | 15.3300 | 718.4900 | 153300.00 | 153300.00 | 0.00 | 100 | 7 | 271 | 2876 | 0.0942280945757997 | 0.183564879893801 | 0.183564879893801 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:08:43.927668Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 34ccca0a-d035-4bae-9c6e-186a451e3fde | 2026-08-27 13:27 | 2026-08-27 13:26 | 2026-08-27 13:26 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 14.7300 | 14.7000 | 14.7700 | 720.0444 | 736500.00 | 0.00 | 589200.00 | 500 | 7 | 1342 | 2647 | 0.506989044200982 | 0.182746504772034 | 0.182746504772034 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T17:46:53.178792Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 59abb021-923a-4fb0-8ad9-e301d1d141a5 | 2026-08-27 13:20 | 2026-08-27 13:20 | 2026-08-27 13:20 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 14.5600 | 14.5300 | 14.5600 | 720.3200 | 582400.00 | 582400.00 | 0.00 | 400 | 5 | 832 | 2647 | 0.314318095957688 | 0.182415149424537 | 0.182256935465444 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6b3da989-17a3-477b-be19-e58fd514d8fc | 2026-08-27 13:16 | 2026-08-27 13:16 | 2026-08-27 13:16 | QQQ | QQQ260930P00720000 | put | 720.0000 | 2026-09-30 | 14.4900 | 14.4400 | 14.5400 | 720.4150 | 143426.00 | 124589.00 | 0.00 | 99 | 5 | 426 | 2647 | 0.160936909709105 | 0.181955469147653 | 0.181840873315149 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |