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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 409b99cb-95ae-457b-8587-71e738aabfc8 | 2026-09-18 14:39 | 2026-09-18 14:39 | 2026-09-18 14:39 | LQD | LQD260918C00104500 | call | 104.5000 | 2026-09-18 | 0.1800 | 0.1300 | 0.2000 | 104.6650 | 18000.00 | 18000.00 | 0.00 | 1000 | 2 | 2500 | 10016 | 0.249600638977636 | 0.130014230223264 | 0.130014230223264 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 28170681642.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T18:43:10.830314Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| f595a7a4-fb26-4ada-a755-040adf7411b9 | 2026-09-18 11:23 | 2026-09-18 11:23 | 2026-09-18 11:23 | LQD | LQD261120C00105000 | call | 105.0000 | 2026-11-20 | 0.8400 | 0.8100 | 0.9000 | 104.6224 | 84000.00 | 0.00 | 84000.00 | 1000 | 1 | 1000 | 11033 | 0.090637179370978 | 0.0369827993917229 | 0.0369827993917229 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 28170681642.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 8ba910d3-0b0f-465f-b5d2-714b9c328660 | 2026-09-17 09:33 | 2026-09-17 09:33 | 2026-09-17 09:33 | LQD | LQD261120C00107000 | call | 107.0000 | 2026-11-20 | 0.3000 | 0.2600 | 0.3300 | 104.9350 | 60000.00 | 60000.00 | 0.00 | 2000 | 1 | 2000 | 65192 | 0.0306786108724997 | 0.0443237939255926 | 0.0443237939255926 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 27980328804.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| b7f96c8a-770b-4b82-a350-1388b92a1f10 | 2026-09-16 11:25 | 2026-09-16 11:25 | 2026-09-16 11:25 | LQD | LQD261016P00104000 | put | 104.0000 | 2026-10-16 | 0.5700 | 0.5600 | 0.6100 | 104.8200 | 171000.00 | 0.00 | 171000.00 | 3000 | 1 | 3014 | 52580 | 0.0573221757322176 | 0.0878979818227421 | 0.0878979818227421 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 27659068466.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T15:39:18.643032Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 8ba97bac-6f1b-495a-8488-75ba77b0287a | 2026-09-16 10:15 | 2026-09-16 10:15 | 2026-09-16 10:15 | LQD | LQD261002C00105500 | call | 105.5000 | 2026-10-02 | 0.2500 | 0.2200 | 0.2800 | 104.0000 | 125000.00 | 0.00 | 0.00 | 5000 | 1 | 5000 | 121 | 41.3223140495868 | 0.057148860318595 | 0.057148860318595 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 27659068466.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 9809490e-54a1-495f-b095-c5af5438295e | 2026-09-15 13:06 | 2026-09-15 13:06 | 2026-09-15 13:06 | LQD | LQD260918C00106000 | call | 106.0000 | 2026-09-18 | 0.0400 | 0.0200 | 0.0400 | 104.1950 | 14800.00 | 14800.00 | 0.00 | 3700 | 1 | 3700 | 25958 | 0.142537945912628 | 0.128135704068196 | 0.128135704068196 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 27583004809.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T17:17:02.017770Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| ae536e94-26e2-4ae7-ab64-c5afc7bfcc4c | 2026-09-14 12:42 | 2026-09-14 12:42 | 2026-09-14 12:42 | LQD | LQD270115P00104000 | put | 104.0000 | 2027-01-15 | 1.8100 | 1.5600 | 2.0100 | 104.5850 | 253400.00 | 253400.00 | 0.00 | 1400 | 2 | 1400 | 6443 | 0.217290082259817 | 0.111818920915318 | 0.111818920915318 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 28077877716.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T16:49:37.903150Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 262a2636-8f52-4243-a582-6ecded5f0ffc | 2026-09-14 12:25 | 2026-09-14 12:25 | 2026-09-14 12:25 | LQD | LQD261218C00108000 | call | 108.0000 | 2026-12-18 | 0.2100 | 0.1300 | 0.2600 | 104.5850 | 75600.00 | 75600.00 | 0.00 | 3600 | 1 | 5002 | 27214 | 0.183802454618946 | 0.0434747183982573 | 0.0434747183982573 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 28077877716.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T16:49:37.903150Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b43bc08c-e2a7-4345-8763-b3260d206515 | 2026-09-11 15:21 | 2026-09-11 15:21 | 2026-09-11 15:21 | LQD | LQD260918P00110000 | put | 110.0000 | 2026-09-18 | 5.7500 | 5.5000 | 5.7500 | 104.3450 | 522100.00 | 522100.00 | 0.00 | 908 | 2 | 916 | 605 | 1.51404958677686 | 0.281897332865785 | 0.281897332865785 | false | true | true | false | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 28077877716.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 |
| a10be992-553f-4b96-8b1e-a770155d9e89 | 2026-09-11 14:01 | 2026-09-11 14:01 | 2026-09-11 14:01 | LQD | LQD261016C00107000 | call | 107.0000 | 2026-10-16 | 0.0900 | 0.0800 | 0.1000 | 104.5050 | 45000.00 | 0.00 | 0.00 | 5000 | 1 | 12500 | 11140 | 1.12208258527828 | 0.0519534607967968 | 0.0519534607967968 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 28077877716.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T18:02:32.717866Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 237005cc-b417-44ec-9d02-bd16fd35d9a3 | 2026-09-10 14:49 | 2026-09-10 14:49 | 2026-09-10 14:49 | LQD | LQD260918P00109000 | put | 109.0000 | 2026-09-18 | 4.4500 | 4.4000 | 4.6500 | 104.4238 | 3354410.00 | 0.00 | 3354410.00 | 7538 | 2 | 15538 | 27141 | 0.572491802070668 | 0.221106105630542 | 0.221106105630542 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 28077877716.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T19:03:59.290358Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 20575379-03c4-41b1-bea4-0a50d5cd6775 | 2026-09-09 13:53 | 2026-09-09 13:53 | 2026-09-09 13:53 | LQD | LQD261218C00108000 | call | 108.0000 | 2026-12-18 | 0.3500 | 0.3000 | 0.3700 | 105.3500 | 35000.00 | 35000.00 | 0.00 | 1000 | 1 | 1000 | 25706 | 0.0389014237921108 | 0.0406108393461458 | 0.0406108393461458 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 28077877716.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4f949ed8-97a3-4843-b204-bee20bcb2d2c | 2026-09-09 11:10 | 2026-09-09 11:10 | 2026-09-09 11:10 | LQD | LQD260918C00106500 | call | 106.5000 | 2026-09-18 | 0.0800 | 0.0600 | 0.0900 | 105.2250 | 80000.00 | 80000.00 | 0.00 | 10000 | 1 | 10016 | 505 | 19.8336633663366 | 0.0661101340116611 | 0.0661101340116611 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 28077877716.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T15:13:56.572588Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3a8aac5c-89a6-4504-8d81-f19c6cda88fe | 2026-09-08 15:16 | 2026-09-08 15:16 | 2026-09-08 15:16 | LQD | LQD260918P00109000 | put | 109.0000 | 2026-09-18 | 3.5200 | 3.5000 | 3.7500 | 105.4150 | 1284800.00 | 0.00 | 1284800.00 | 3650 | 2 | 11188 | 27141 | 0.412217678051656 | 0.121022692581288 | 0.121022692581288 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 28077877716.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T19:30:09.198364Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b79cafa1-f502-43b9-80a5-4732ad827939 | 2026-09-08 15:16 | 2026-09-08 15:15 | 2026-09-08 15:15 | LQD | LQD260918P00109000 | put | 109.0000 | 2026-09-18 | 3.5300 | 3.5000 | 3.7500 | 105.4200 | 2660914.00 | 0.00 | 2660914.00 | 7538 | 2 | 7538 | 27141 | 0.277734792380531 | 0.128155633084076 | 0.128155633084076 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 28077877716.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T19:30:09.198364Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 47077ec7-4055-4815-a418-bbaf7a1b8714 | 2026-09-03 14:45 | 2026-09-03 14:44 | 2026-09-03 14:44 | LQD | LQD260918P00110000 | put | 110.0000 | 2026-09-18 | 4.5000 | 4.2500 | 4.5000 | 105.5700 | 408600.00 | 408600.00 | 0.00 | 908 | 2 | 908 | 605 | 1.50082644628099 | 0.172033958564151 | 0.172033958564151 | false | true | true | false | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 27583004809.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T18:47:01.806289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1a8b0474-cf2b-499d-b892-6953075a36ba | 2026-09-03 14:44 | 2026-09-03 14:44 | 2026-09-03 14:44 | LQD | LQD260918P00109000 | put | 109.0000 | 2026-09-18 | 3.3100 | 3.3000 | 3.5500 | 105.5700 | 1208481.00 | 0.00 | 1208481.00 | 3651 | 2 | 12557 | 27141 | 0.462657971334881 | 0.0945378889740145 | 0.0945378889740145 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 27583004809.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T18:47:01.806289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6cff8a71-4f82-43e9-8a5d-f606a9c1d460 | 2026-09-03 12:44 | 2026-09-03 12:44 | 2026-09-03 12:44 | LQD | LQD270820P00055000 | put | 55.0000 | 2027-08-20 | 0.0500 | 0.0000 | 0.2900 | 105.6501 | 150000.00 | 0.00 | 150000.00 | 30000 | 1 | 30000 | 0 | 0 | 0.28672731062533 | 0.28672731062533 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 27583004809.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4937b639-697b-4726-97b4-ba9856fde77e | 2026-09-02 09:33 | 2026-09-02 09:33 | 2026-09-02 09:33 | LQD | LQD261120C00107000 | call | 107.0000 | 2026-11-20 | 0.5400 | 0.4800 | 0.5600 | 105.3700 | 267500.00 | 267500.00 | 0.00 | 5000 | 2 | 5000 | 30196 | 0.165584845674924 | 0.0429980848359375 | 0.0429980848359375 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 27583004809.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T13:42:51.501101Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b5c1c2e3-fb23-40d6-981d-af422b853e2e | 2026-08-28 13:15 | 2026-08-28 13:15 | 2026-08-28 13:15 | LQD | LQD260828C00106500 | call | 106.5000 | 2026-08-28 | 0.0300 | 0.0100 | 0.0400 | 106.4050 | 3000.00 | 3000.00 | 0.00 | 1000 | 1 | 11033 | 20228 | 0.545432074352383 | 0.0886772767523056 | 0.0886772767523056 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 27583004809.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T17:47:47.104019Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 45e8ea0c-750d-4eb5-bd69-6ff833379ab7 | 2026-08-27 14:52 | 2026-08-27 14:52 | 2026-08-27 14:52 | LQD | LQD260918P00103000 | put | 103.0000 | 2026-09-18 | 0.0500 | 0.0400 | 0.0600 | 106.6850 | 12500.00 | 0.00 | 0.00 | 2500 | 1 | 2501 | 63813 | 0.0391926409979158 | 0.0927719761029907 | 0.0927719761029907 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 27583004809.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b44cbb52-c632-4f70-a4b3-6a39406f71e5 | 2026-08-21 11:04 | 2026-08-21 11:04 | 2026-08-21 11:04 | LQD | LQD260925P00105500 | put | 105.5000 | 2026-09-25 | 0.7500 | 0.7400 | 0.7900 | 105.9350 | 450000.00 | 0.00 | 450000.00 | 6000 | 2 | 6000 | 8 | 750 | 0.0852502844019672 | 0.0852502844019672 | false | true | true | false | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 2 | ETF | — | 27583004809.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fd8620f4-62d7-4a82-a521-48e314ec4b25 | 2026-08-19 14:17 | 2026-08-19 14:17 | 2026-08-19 14:17 | LQD | LQD261120C00107000 | call | 107.0000 | 2026-11-20 | 1.0200 | 0.9700 | 1.0500 | 106.4550 | 1025000.00 | 1025000.00 | 0.00 | 10000 | 2 | 10003 | 10185 | 0.98213058419244 | 0.0350227770885942 | 0.0350227770885942 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 27583004809.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T18:37:13.611011Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9c437b13-30f1-4768-928b-d5e71865fb9a | 2026-08-17 10:12 | 2026-08-17 10:12 | 2026-08-17 10:12 | LQD | LQD260821P00100000 | put | 100.0000 | 2026-08-21 | 0.0100 | 0.0000 | 0.0100 | 105.9650 | 25000.00 | 25000.00 | 0.00 | 25000 | 1 | 25000 | 10003 | 2.49925022493252 | 0.243777643373434 | 0.243777643373434 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 27583004809.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |