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.
Simplify Analyticsuw_flow_alerts326,449 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 | price |
|---|
| 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 |
|---|
| 68bae5e2-4114-43bb-b00c-427d07171e02 | 2026-08-20 10:44 | 2026-08-20 10:44 | 2026-08-20 10:44 | LABU | LABU260828P00325000 | put | 325.0000 | 2026-08-28 | 28.2100 | 27.7000 | 30.5000 | 308.1600 | 31030.00 | 5650.00 | 25380.00 | 11 | 10 | 12 | 2 | 6 | 1.00497458443559 | 1.00497458443559 | true | 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-20T14:48:30.894899Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 41f6658e-6db7-47d4-b3ad-3794bab670ad | 2026-08-20 09:32 | 2026-08-20 09:32 | 2026-08-20 09:32 | LABU | LABU260828C00350000 | call | 350.0000 | 2026-08-28 | 9.0300 | 8.9000 | 11.5000 | 326.6450 | 18050.00 | 0.00 | 18050.00 | 20 | 5 | 20 | 33 | 0.606060606060606 | 0.915390580406307 | 0.909686554420506 | true | false | false | true | false | |||||||||||||||
| b486c804-d632-406a-ad93-dd585efc3835 | 2026-08-19 15:48 | 2026-08-19 15:48 | 2026-08-19 15:48 | LABU | LABU280121C00370000 | call | 370.0000 | 2028-01-21 | 133.5000 | 129.0000 | 133.7000 | 339.9450 | 240300.00 | 240300.00 | 0.00 | 18 | 8 | 25 | 77 | 0.324675324675325 | 0.877789238391578 | 0.880590522745654 | false | false | false | true | false | |||||||||||||||
| c59d2b7e-9fdc-41db-a3d5-b3c5876c7ef5 | 2026-08-19 15:03 | 2026-08-19 15:03 | 2026-08-19 15:03 | LABU | LABU260828C00375000 | call | 375.0000 | 2026-08-28 | 7.1000 | 5.0000 | 7.1000 | 333.8600 | 49700.00 | 49700.00 | 0.00 | 70 | 14 | 70 | 0 | 0 | 0.977723472488216 | 0.977723472488216 | false | false | false | true | false | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 529932298.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 529932298.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |