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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| bd1b448f-7b17-4a9d-93fc-38c6b816a42e | 2026-08-19 15:03 | 2026-08-19 15:03 | 2026-08-19 15:03 | LABU | LABU260828C00385000 | call | 385.0000 | 2026-08-28 | 5.3900 | 3.0000 | 5.4000 | 333.8600 | 24250.00 | 21600.00 | 530.00 | 45 | 9 | 46 | 0 | 0 | 0.984927558349214 | 0.978114279104108 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 529932298.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5b31b750-5acd-4b18-8212-dea83260f051 | 2026-08-19 15:03 | 2026-08-19 15:03 | 2026-08-19 15:03 | LABU | LABU260828C00370000 | call | 370.0000 | 2026-08-28 | 8.2000 | 6.0000 | 8.2000 | 333.8600 | 148419.00 | 148419.00 | 0.00 | 181 | 29 | 182 | 0 | 0 | 0.978744887109797 | 0.978744887109797 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 529932298.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 17bfc241-0329-4833-bba2-91f6f8295bdc | 2026-08-19 15:03 | 2026-08-19 15:03 | 2026-08-19 15:03 | LABU | LABU260828C00365000 | call | 365.0000 | 2026-08-28 | 9.3000 | 7.5000 | 9.3000 | 333.8600 | 10230.00 | 10230.00 | 0.00 | 11 | 6 | 17 | 0 | 0 | 0.972447183635373 | 0.972447183635373 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 529932298.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5e14f7b9-8174-489b-831d-1d73ddf3d0cd | 2026-08-19 11:46 | 2026-08-19 11:46 | 2026-08-19 11:46 | LABU | LABU260821P00330000 | put | 330.0000 | 2026-08-21 | 16.2500 | 15.6000 | 17.8000 | 321.9150 | 24370.00 | 0.00 | 24370.00 | 15 | 7 | 33 | 0 | 0 | 1.22873069355872 | 1.22873069355872 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 529932298.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0eb009b9-f301-4073-baf1-fe7ff84f4816 | 2026-08-19 10:44 | 2026-08-19 10:44 | 2026-08-19 10:44 | LABU | LABU260828P00312500 | put | 312.5000 | 2026-08-28 | 11.7000 | 10.4000 | 13.5000 | 331.1575 | 52650.00 | 12870.00 | 39780.00 | 45 | 5 | 45 | 1 | 45 | 0.981049496429356 | 0.981049496429356 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 529932298.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:50:22.027850Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a0ac9881-a84e-4d4a-9e63-ab856b0484f9 | 2026-08-19 10:08 | 2026-08-19 10:08 | 2026-08-19 10:08 | LABU | LABU260821C00330000 | call | 330.0000 | 2026-08-21 | 11.3000 | 9.8000 | 12.4000 | 328.3550 | 11300.00 | 11300.00 | 0.00 | 10 | 6 | 21 | 29 | 0.724137931034483 | 1.24138584544951 | 1.24138584544951 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 529932298.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c1280dfb-d7f1-4c0f-9a74-63c22d9fc5e2 | 2026-08-19 09:54 | 2026-08-19 09:54 | 2026-08-19 09:54 | LABU | LABU260821C00365000 | call | 365.0000 | 2026-08-21 | 2.1500 | 0.4500 | 2.1500 | 329.7000 | 12900.00 | 12900.00 | 0.00 | 60 | 10 | 67 | 43 | 1.55813953488372 | 1.23856044904729 | 1.23856044904729 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 529932298.00 | — | — | — | 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 |
| a0d99ae7-8d0c-4d7d-a4ff-115d6f217f1a | 2026-08-19 09:54 | 2026-08-19 09:54 | 2026-08-19 09:54 | LABU | LABU260918C00370000 | call | 370.0000 | 2026-09-18 | 19.5000 | 17.0000 | 19.5000 | 329.7000 | 83850.00 | 83850.00 | 0.00 | 43 | 10 | 43 | 4 | 10.75 | 0.897421648677178 | 0.897421648677178 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 529932298.00 | — | — | — | 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 |
| 33906af6-e8f2-43bd-91e2-14354c3ee2ed | 2026-08-19 09:54 | 2026-08-19 09:54 | 2026-08-19 09:54 | LABU | LABU260904C00355000 | call | 355.0000 | 2026-09-04 | 15.6000 | 13.5000 | 15.6000 | 329.7000 | 88918.00 | 88918.00 | 0.00 | 57 | 20 | 57 | 3 | 19 | 0.915922970938138 | 0.915922970938138 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 529932298.00 | — | — | — | 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 |
| 11916b73-0fcf-4fa2-b1c0-d506c7452686 | 2026-08-19 09:54 | 2026-08-19 09:54 | 2026-08-19 09:54 | LABU | LABU260904C00380000 | call | 380.0000 | 2026-09-04 | 9.2000 | 7.0000 | 9.2000 | 329.7000 | 13800.00 | 13800.00 | 0.00 | 15 | 6 | 15 | 25 | 0.6 | 0.917915784043988 | 0.917915784043988 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 529932298.00 | — | — | — | 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 |
| 9d87c2d4-46b7-4db0-9916-6cdf1efa5334 | 2026-08-19 09:32 | 2026-08-19 09:32 | 2026-08-19 09:32 | LABU | LABU260821C00350000 | call | 350.0000 | 2026-08-21 | 2.1700 | 0.9000 | 3.0000 | 319.2400 | 16260.00 | 8490.00 | 7770.00 | 75 | 10 | 75 | 35 | 2.14285714285714 | 1.14329644744095 | 1.17916505444068 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 529932298.00 | — | — | — | 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 |
| 366dfc75-e77f-4c3d-9133-da5dfd670f02 | 2026-08-18 10:11 | 2026-08-18 10:11 | 2026-08-18 10:11 | LABU | LABU260925C00285000 | call | 285.0000 | 2026-09-25 | 30.6000 | 30.1000 | 33.5000 | 284.5350 | 30600.00 | 0.00 | 30600.00 | 10 | 6 | 10 | 0 | 0 | 0.829783242973334 | 0.829783242973334 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 529932298.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 94a644e8-7077-40ae-830f-2d264a14085f | 2026-08-18 09:48 | 2026-08-18 09:48 | 2026-08-18 09:48 | LABU | LABU260918C00275000 | call | 275.0000 | 2026-09-18 | 34.2100 | 34.2000 | 36.4000 | 287.0000 | 41050.00 | 0.00 | 41050.00 | 12 | 6 | 247 | 334 | 0.739520958083832 | 0.83398821797509 | 0.83398821797509 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 529932298.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7ea8500e-9e6e-44fa-8998-cce794fe43b6 | 2026-08-18 09:48 | 2026-08-18 09:48 | 2026-08-18 09:48 | LABU | LABU260918C00275000 | call | 275.0000 | 2026-09-18 | 34.2000 | 34.1000 | 36.4000 | 287.0000 | 468530.00 | 0.00 | 468530.00 | 137 | 8 | 226 | 334 | 0.676646706586826 | 0.83398821797509 | 0.830842384224434 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 529932298.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |