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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| f2ed101a-afaf-465a-acf1-cfa2d557702e | 2026-08-17 10:00 | 2026-08-17 10:00 | 2026-08-17 10:00 | TQQQ | TQQQ260925P00060000 | put | 60.0000 | 2026-09-25 | 1.1800 | 1.1700 | 1.2200 | 77.4200 | 29500.00 | 0.00 | 29500.00 | 250 | 6 | 767 | 1016 | 0.75492125984252 | 0.737890322699305 | 0.737890322699305 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 34717389300.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f11e8807-89fb-4745-9020-6f6fe153c42b | 2026-08-17 13:34 | 2026-08-17 13:33 | 2026-08-17 13:33 | TQQQ | TQQQ260925P00060000 | put | 60.0000 | 2026-09-25 | 1.2600 | 1.2600 | 1.3100 | 76.5800 | 77112.00 | 0.00 | 77112.00 | 612 | 5 | 1498 | 1016 | 1.4744094488189 | 0.733737313255502 | 0.733737313255502 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 34717389300.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a14760c3-ca78-4f39-8d46-c0a22b4595cc | 2026-08-20 13:36 | 2026-08-20 13:36 | 2026-08-20 13:36 | TQQQ | TQQQ260925P00060000 | put | 60.0000 | 2026-09-25 | 2.0000 | 1.9700 | 2.0000 | 70.3800 | 29800.00 | 29800.00 | 0.00 | 149 | 14 | 2034 | 2845 | 0.71493848857645 | 0.71835595393867 | 0.71835595393867 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 34717389300.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| eaf29122-6846-4474-aa8b-58a982ca7649 | 2026-09-01 11:01 | 2026-09-01 11:00 | 2026-09-01 11:00 | TQQQ | TQQQ260925P00060000 | put | 60.0000 | 2026-09-25 | 1.0300 | 1.0000 | 1.0300 | 69.9900 | 253071.00 | 253071.00 | 0.00 | 2457 | 15 | 8324 | 7274 | 1.14434973879571 | 0.655727906368865 | 0.655727906368865 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 34717389300.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T15:18:08.991662Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 76ee4ca9-def4-4b93-95e9-130b0d186937 | 2026-09-03 09:47 | 2026-09-03 09:47 | 2026-09-03 09:47 | TQQQ | TQQQ260925P00060000 | put | 60.0000 | 2026-09-25 | 0.9100 | 0.9000 | 0.9100 | 70.7300 | 188734.00 | 188734.00 | 0.00 | 2074 | 16 | 2081 | 13780 | 0.151015965166909 | 0.681417166167745 | 0.681417166167745 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 34717389300.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2f0c3cc4-589d-4df6-b6cc-9cedf9b69d6c | 2026-09-04 09:59 | 2026-09-04 09:59 | 2026-09-04 09:59 | TQQQ | TQQQ260925P00060000 | put | 60.0000 | 2026-09-25 | 0.5600 | 0.5400 | 0.5600 | 73.1497 | 56000.00 | 56000.00 | 0.00 | 1000 | 5 | 1134 | 15524 | 0.0730481834578717 | 0.676690419207192 | 0.676690419207192 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 34717389300.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6725efaa-95f0-4bad-96ba-ac45e74f4043 | 2026-09-04 10:00 | 2026-09-04 10:00 | 2026-09-04 10:00 | TQQQ | TQQQ260925P00060000 | put | 60.0000 | 2026-09-25 | 0.5600 | 0.5400 | 0.5600 | 73.1800 | 16762.00 | 14672.00 | 0.00 | 300 | 10 | 2434 | 15524 | 0.156789487245555 | 0.674248336736814 | 0.677658369525018 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 34717389300.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 281c3892-b4c1-405b-be32-25107d06a1ae | 2026-09-04 13:31 | 2026-09-04 13:30 | 2026-09-04 13:30 | TQQQ | TQQQ260925P00060000 | put | 60.0000 | 2026-09-25 | 0.6400 | 0.6400 | 0.6500 | 71.8799 | 274560.00 | 0.00 | 274560.00 | 4290 | 19 | 11623 | 15524 | 0.74871167224942 | 0.660907049426794 | 0.660907049426794 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 34717389300.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T17:34:11.817020Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fad5b5e7-9e58-48e2-8ae7-e589ed9b6063 | 2026-09-04 14:40 | 2026-09-04 14:39 | 2026-09-04 14:39 | TQQQ | TQQQ260925P00060000 | put | 60.0000 | 2026-09-25 | 0.6300 | 0.6300 | 0.6600 | 71.9400 | 160335.00 | 0.00 | 160335.00 | 2545 | 18 | 14209 | 15524 | 0.915292450399382 | 0.659815450712522 | 0.659815450712522 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 34717389300.00 | — | — | — | 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 |
| 17df2a22-5337-4298-980f-e9185d996201 | 2026-09-14 10:22 | 2026-09-14 10:21 | 2026-09-14 10:21 | TQQQ | TQQQ260925P00060000 | put | 60.0000 | 2026-09-25 | 0.7000 | 0.7000 | 0.7100 | 68.0000 | 506800.00 | 0.00 | 506800.00 | 7240 | 20 | 8105 | 10550 | 0.76824644549763 | 0.756122515611214 | 0.756122515611214 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 35638212540.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a7d7d96c-f53f-4076-aba5-37906af1e536 | 2026-09-14 11:02 | 2026-09-14 11:02 | 2026-09-14 11:02 | TQQQ | TQQQ260925P00060000 | put | 60.0000 | 2026-09-25 | 0.7300 | 0.7000 | 0.7300 | 68.2700 | 27156.00 | 27156.00 | 0.00 | 372 | 7 | 8650 | 10550 | 0.819905213270142 | 0.76394677826446 | 0.76394677826446 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 35638212540.00 | — | — | — | 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 |
| 9e461262-7fac-4d78-9194-9cee78c8468c | 2026-09-14 11:36 | 2026-09-14 11:35 | 2026-09-14 11:35 | TQQQ | TQQQ260925P00060000 | put | 60.0000 | 2026-09-25 | 0.6000 | 0.5700 | 0.6000 | 69.2950 | 30000.00 | 30000.00 | 0.00 | 500 | 7 | 9764 | 10550 | 0.925497630331754 | 0.767250515769682 | 0.767250515769682 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 35638212540.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:39:52.032222Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 980df942-6deb-4580-875c-96187ad27c7a | 2026-09-15 14:48 | 2026-09-15 14:47 | 2026-09-15 14:47 | TQQQ | TQQQ260925P00060000 | put | 60.0000 | 2026-09-25 | 0.6800 | 0.6500 | 0.6800 | 67.8600 | 13668.00 | 13668.00 | 0.00 | 201 | 13 | 1005 | 17545 | 0.0572812767170134 | 0.758430966654005 | 0.758430966654005 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 34717389300.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T18:59:21.919987Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |