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.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28414cb3-e1fc-4adc-aeb4-3b99b902fd41 | 2026-09-15 09:43 | 2026-09-15 09:43 | 2026-09-15 09:43 | LABU | LABU260925P00255000 | put | 255.0000 | 2026-09-25 | 16.9000 | 15.5000 | 17.0000 | 253.5600 | 216261.00 | 194401.00 | 21860.00 | 128 | 13 | 128 | 272 | 0.470588235294118 | 0.978606740353993 | 0.972626140267621 | 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-09-15T13:48:14.023311Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| dbd829a6-d261-48a6-a0bc-ca0f5ec936fe | 2026-09-11 11:18 | 2026-09-11 11:18 | 2026-09-11 11:18 | LABU | LABU280121C00235000 | call | 235.0000 | 2028-01-21 | 109.0400 | 105.5000 | 109.4000 | 264.0250 | 686935.00 | 676105.00 | 10830.00 | 63 | 19 | 70 | 6 | 11.6666666666667 | 0.789175786919728 | 0.789175786919728 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 515933192.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T15:28:46.184785Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ff92fa1f-4c93-48ca-9a83-5ba6362ab869 | 2026-09-08 12:59 | 2026-09-08 12:58 | 2026-09-08 12:58 | LABU | LABU260911C00310000 | call | 310.0000 | 2026-09-11 | 6.0100 | 4.9000 | 7.8000 | 295.7200 | 18642.00 | 0.00 | 18642.00 | 31 | 8 | 77 | 29 | 2.6551724137931 | 1.07706862279748 | 1.07706862279748 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 515933192.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T17:11:09.796111Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 52ca7d3b-0b9e-47ae-8a44-b4640157ff1a | 2026-08-31 09:34 | 2026-08-31 09:34 | 2026-08-31 09:34 | LABU | LABU260904C00315000 | call | 315.0000 | 2026-09-04 | 3.0200 | 3.0000 | 4.2000 | 283.8050 | 16616.00 | 0.00 | 16616.00 | 55 | 5 | 55 | 48 | 1.14583333333333 | 1.04947398949458 | 1.04947398949458 | 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-31T13:35:53.678596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 539f8723-c773-4688-bc5d-52a9f24109c9 | 2026-08-31 09:32 | 2026-08-31 09:32 | 2026-08-31 09:32 | LABU | LABU260918P00270000 | put | 270.0000 | 2026-09-18 | 15.8100 | 13.8000 | 16.5000 | 287.6900 | 14230.00 | 12650.00 | 1580.00 | 9 | 9 | 9 | 37 | 0.243243243243243 | 0.97082008320469 | 0.966550134805346 | 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-31T13:35:53.678596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 47b4d0cc-65b5-4ac4-b462-f4e5478462de | 2026-08-31 09:32 | 2026-08-31 09:32 | 2026-08-31 09:32 | LABU | LABU260918P00275000 | put | 275.0000 | 2026-09-18 | 18.0500 | 15.8000 | 18.8000 | 287.6900 | 19860.00 | 18060.00 | 1800.00 | 11 | 11 | 11 | 38 | 0.289473684210526 | 0.979400127561968 | 0.966988962805633 | 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-31T13:35:53.678596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 10b20c9b-6ac9-45b3-88e5-4ba1c261f332 | 2026-08-25 15:55 | 2026-08-25 15:54 | 2026-08-25 15:54 | LABU | LABU260918C00330000 | call | 330.0000 | 2026-09-18 | 34.8200 | 33.0000 | 36.3000 | 334.8310 | 34816.00 | 34816.00 | 0.00 | 10 | 6 | 19 | 182 | 0.104395604395604 | 0.942263741460683 | 0.942263741460683 | 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-26T13:31:08.388238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b561c877-829e-430d-b6c7-a40988bae9d9 | 2026-08-25 11:09 | 2026-08-25 11:09 | 2026-08-25 11:09 | LABU | LABU260904C00375000 | call | 375.0000 | 2026-09-04 | 10.0500 | 9.6000 | 11.4000 | 338.3050 | 10049.00 | 0.00 | 10049.00 | 10 | 8 | 100 | 1 | 100 | 1.02378773952206 | 1.02378773952206 | 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-25T15:21:33.843586Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 38dd267a-6609-48f2-bfbf-4699a823fa76 | 2026-08-25 09:39 | 2026-08-25 09:39 | 2026-08-25 09:39 | LABU | LABU260918C00390000 | call | 390.0000 | 2026-09-18 | 13.3000 | 11.0000 | 13.3000 | 331.9700 | 46548.00 | 46548.00 | 0.00 | 35 | 9 | 35 | 5 | 7 | 0.942484245682008 | 0.942484245682008 | 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-25T13:41:46.514863Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 61b85e79-9940-4b65-8192-3dce614b54c1 | 2026-08-21 10:34 | 2026-08-21 10:34 | 2026-08-21 10:34 | LABU | LABU270115C00475000 | call | 475.0000 | 2027-01-15 | 37.2000 | 36.3000 | 39.4000 | 326.8400 | 26040.00 | 7400.00 | 18640.00 | 7 | 5 | 7 | 28 | 0.25 | 0.927344264742637 | 0.927344264742637 | 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-21T14:36:46.143381Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4e84943f-0c2e-4d22-baad-cae996ab43b8 | 2026-08-21 09:38 | 2026-08-21 09:38 | 2026-08-21 09:38 | LABU | LABU260918C00325000 | call | 325.0000 | 2026-09-18 | 26.4700 | 25.6000 | 28.9000 | 313.3300 | 137660.00 | 68220.00 | 69440.00 | 52 | 5 | 52 | 104 | 0.5 | 0.910550243252179 | 0.8903304444363 | 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-21T13:43:10.748747Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 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 |
| 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 |