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.
uw_flow_alerts474,253 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 | expiry |
|---|
| 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 |
|---|
| 8aaeec21-a937-4494-be5e-fcecfc6c9863 | 2026-08-25 15:58 | 2026-08-25 15:58 | 2026-08-25 15:58 | LLY | LLY261016P01180000 | put | 1180.0000 | 2026-10-16 | 34.5000 | 27.6000 | 34.5000 | 1233.4100 | 175940.00 | 175940.00 | 0.00 | 51 | 5 | 82 | 468 | 0.175213675213675 | 0.329040844978962 | 0.329639863412181 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 1071527919948.00 | 2026-10-29 | premarket | — | 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 |
| a34c0f80-d7a5-43f8-ace0-ff4476154e92 | 2026-08-21 15:18 | 2026-08-21 15:18 | 2026-08-21 15:18 | LLY | LLY260925C01220000 | call | 1220.0000 | 2026-09-25 | 76.7800 | 74.4000 | 78.8500 | 1261.7800 | 115175.00 | 92180.00 | 22995.00 | 15 | 6 | 22 | 13 | 1.69230769230769 | 0.327887169299523 | 0.328937183130065 | true | false | false | true | ||||||||||||||||
| 65fea716-a3fc-438e-b675-113907102738 | 2026-08-21 14:06 | 2026-08-21 14:06 | 2026-08-21 14:06 | LLY | LLY261218P01200000 | put | 1200.0000 | 2026-12-18 | 67.2000 | 67.2000 | 70.3500 | 1260.0000 | 1075204.00 | 0.00 | 1075204.00 | 160 | 30 | 445 | 323 | 1.37770897832817 | 0.365344590085499 | 0.365344590085499 | false | false | false | true | ||||||||||||||||
| f60d4c2e-747b-4d72-8f61-e33b53f40472 | 2026-08-21 10:49 | 2026-08-21 10:49 | 2026-08-21 10:49 | LLY | LLY261218P01200000 | put | 1200.0000 | 2026-12-18 | 67.6600 | 67.6500 | 71.2000 | 1263.3100 | 392410.00 | 6800.00 | 385610.00 | 58 | 19 | 275 | 323 | 0.851393188854489 | 0.366930436325648 | 0.368253417287172 | false | false | false | true | ||||||||||||||||
| 7782d247-b205-4a20-85ad-ec1e208d02f8 | 2026-08-21 10:37 | 2026-08-21 10:37 | 2026-08-21 10:37 | LLY | LLY261218P01260000 | put | 1260.0000 | 2026-12-18 | 94.0800 | 92.5000 | 97.9500 | 1263.0800 | 1683985.00 | 275185.00 | 1408800.00 | 179 | 17 | 189 | 40 | 4.725 | 0.364576199920048 | 0.365865160107217 | false | false | false | true | ||||||||||||||||
| 13281b9c-9b71-4590-a456-7a2a83cc85a1 | 2026-08-21 10:30 | 2026-08-21 10:30 | 2026-08-21 10:30 | LLY | LLY260918C01300000 | call | 1300.0000 | 2026-09-18 | 29.0200 | 27.2500 | 29.4000 | 1260.2258 | 145090.00 | 145090.00 | 0.00 | 50 | 5 | 209 | 2790 | 0.074910394265233 | 0.316527555301126 | 0.316900682939143 | false | false | false | true | ||||||||||||||||
| 7bcf9fbf-936b-4b80-b5e1-a91ced9e63e2 | 2026-08-21 10:15 | 2026-08-21 10:15 | 2026-08-21 10:15 | LLY | LLY261218P01200000 | put | 1200.0000 | 2026-12-18 | 69.8000 | 69.6000 | 73.2000 | 1256.8450 | 1486819.00 | 7050.00 | 1479769.00 | 213 | 46 | 217 | 323 | 0.671826625386997 | 0.366622686515953 | 0.369256345428879 | false | false | false | true | ||||||||||||||||
| 488ebfe3-fe1f-427f-ba6f-1d08b4cbc45d | 2026-08-20 11:47 | 2026-08-20 11:46 | 2026-08-20 11:46 | LLY | LLY270115P01280000 | put | 1280.0000 | 2027-01-15 | 111.2000 | 111.1500 | 112.8500 | 1270.5950 | 278010.00 | 0.00 | 255780.00 | 25 | 21 | 46 | 266 | 0.172932330827068 | 0.36332519150594 | 0.363481918228049 | true | false | false | true | ||||||||||||||||
| d25128c3-d728-4fee-876e-1d22bfb42d2b | 2026-08-19 15:56 | 2026-08-19 15:56 | 2026-08-19 15:56 | LLY | LLY270115P01280000 | put | 1280.0000 | 2027-01-15 | 108.0000 | 107.9500 | 108.0000 | 1279.0300 | 215990.00 | 32400.00 | 0.00 | 20 | 20 | 278 | 16 | 17.375 | 0.363751371394165 | 0.36390730430578 | false | false | false | true | ||||||||||||||||
| f20df115-c85a-467d-8e80-18c43d5bfe21 | 2026-08-19 15:23 | 2026-08-19 15:23 | 2026-08-19 15:23 | LLY | LLY270115P01280000 | put | 1280.0000 | 2027-01-15 | 104.5300 | 103.0500 | 105.8500 | 1288.7300 | 355390.00 | 334480.00 | 0.00 | 34 | 32 | 218 | 16 | 13.625 | 0.365736402991695 | 0.365892166780377 | false | false | false | true | ||||||||||||||||
| 7d52e907-58d1-422d-b103-9ee9de25fbed | 2026-08-19 15:23 | 2026-08-19 15:23 | 2026-08-19 15:23 | LLY | LLY270115P01280000 | put | 1280.0000 | 2027-01-15 | 104.6000 | 103.1000 | 107.7500 | 1288.7200 | 219655.00 | 177820.00 | 10455.00 | 21 | 18 | 239 | 16 | 14.9375 | 0.365879238920714 | 0.366035003056195 | false | false | false | true | ||||||||||||||||
| e1a53a09-8684-4997-acb4-f88c9f3db5cd | 2026-08-19 15:01 | 2026-08-19 15:01 | 2026-08-19 15:01 | LLY | LLY270115P01280000 | put | 1280.0000 | 2027-01-15 | 105.8300 | 104.7000 | 106.8500 | 1284.2100 | 518570.00 | 148275.00 | 211690.00 | 49 | 41 | 116 | 16 | 7.25 | 0.363589298744849 | 0.364524223488601 | true | false | false | true | ||||||||||||||||
| 6c5cd345-33a5-4197-8659-a3415f478a98 | 2026-08-19 14:48 | 2026-08-19 14:48 | 2026-08-19 14:48 | LLY | LLY260918C01220000 | call | 1220.0000 | 2026-09-18 | 88.3800 | 82.0000 | 89.7500 | 1282.3750 | 715910.00 | 556675.00 | 159235.00 | 81 | 32 | 301 | 1995 | 0.150877192982456 | 0.334845029504685 | 0.349040362540034 | true | false | false | true | ||||||||||||||||
| 9cd033a1-da55-4b6f-9a58-27b6b9384494 | 2026-08-19 14:45 | 2026-08-19 14:45 | 2026-08-19 14:45 | LLY | LLY270115P01280000 | put | 1280.0000 | 2027-01-15 | 108.5200 | 108.1000 | 109.6000 | 1278.4950 | 542605.00 | 195440.00 | 249585.00 | 50 | 50 | 66 | 16 | 4.125 | 0.364440580730883 | 0.365064384782093 | true | false | false | true | ||||||||||||||||
| 0d38e991-e1f7-4e41-8ead-25fcfbfe1b12 | 2026-08-19 10:02 | 2026-08-19 10:02 | 2026-08-19 10:02 | LLY | LLY260904C01245000 | call | 1245.0000 | 2026-09-04 | 62.8700 | 62.1500 | 69.0000 | 1285.7300 | 452630.00 | 44215.00 | 408415.00 | 72 | 24 | 73 | 9 | 8.11111111111111 | 0.352830927959651 | 0.359247827242439 | true | false | false | true | ||||||||||||||||
| 32760c6b-d866-44d9-81b2-599c142d2565 | 2026-08-19 10:01 | 2026-08-19 10:01 | 2026-08-19 10:01 | LLY | LLY260918C01360000 | call | 1360.0000 | 2026-09-18 | 23.2700 | 22.5000 | 23.7000 | 1287.0000 | 181485.00 | 90285.00 | 91200.00 | 78 | 9 | 505 | 975 | 0.517948717948718 | 0.332534583880856 | 0.335223643012278 | true | false | false | true | ||||||||||||||||
| 3305c677-75bd-42ab-948e-5c93911efc18 | 2026-08-19 10:00 | 2026-08-19 10:00 | 2026-08-19 10:00 | LLY | LLY260918P01280000 | put | 1280.0000 | 2026-09-18 | 42.8600 | 42.8500 | 45.7500 | 1287.8600 | 1362966.00 | 21725.00 | 1341241.00 | 318 | 47 | 320 | 53 | 6.0377358490566 | 0.330064914346584 | 0.335275119903924 | true | false | false | true | ||||||||||||||||
| 1130b69d-917a-4913-9258-baa3f2830efc | 2026-08-19 09:46 | 2026-08-19 09:46 | 2026-08-19 09:46 | LLY | LLY260918C01360000 | call | 1360.0000 | 2026-09-18 | 21.6100 | 17.9500 | 22.8000 | 1284.4300 | 576905.00 | 309270.00 | 229215.00 | 267 | 18 | 320 | 975 | 0.328205128205128 | 0.321182471225279 | 0.334362819840084 | true | false | false | true | ||||||||||||||||
| 1a54ce86-459e-4916-af25-a50376fce8bb | 2026-08-19 09:46 | 2026-08-19 09:45 | 2026-08-19 09:45 | LLY | LLY260918C01260000 | call | 1260.0000 | 2026-09-18 | 65.0000 | 59.0500 | 67.9000 | 1284.9700 | 162505.00 | 162505.00 | 0.00 | 25 | 5 | 144 | 1248 | 0.115384615384615 | 0.338708815642664 | 0.338708815642664 | false | false | false | true | ||||||||||||||||
| f8c9d303-6a43-44ac-ba6e-b32697232f66 | 2026-08-19 09:45 | 2026-08-19 09:45 | 2026-08-19 09:45 | LLY | LLY270115C01620000 | call | 1620.0000 | 2027-01-15 | 28.6100 | 23.0000 | 29.6500 | 1283.0050 | 286104.00 | 286104.00 | 0.00 | 100 | 18 | 121 | 150 | 0.806666666666667 | 0.348807840906482 | 0.354226456234574 | true | false | false | true | ||||||||||||||||
| d104f567-07e8-496a-9d40-250d1430cbeb | 2026-08-19 09:35 | 2026-08-19 09:35 | 2026-08-19 09:35 | LLY | LLY260904C01285000 | call | 1285.0000 | 2026-09-04 | 25.2500 | 23.3000 | 25.3000 | 1260.5700 | 141390.00 | 136480.00 | 4910.00 | 56 | 16 | 68 | 28 | 2.42857142857143 | 0.332260136373275 | 0.332746336754512 | true | false | false | true | ||||||||||||||||
| 7168649f-432d-4e56-a307-4afa8cfc8a43 | 2026-08-17 10:03 | 2026-08-17 10:03 | 2026-08-17 10:03 | LLY | LLY260918C01250000 | call | 1250.0000 | 2026-09-18 | 18.9000 | 15.6500 | 19.0000 | 1182.0800 | 103930.00 | 96350.00 | 0.00 | 55 | 9 | 61 | 236 | 0.258474576271186 | 0.303073284845965 | 0.304729338292976 | true | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:32:44.160800Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:50:41.871179Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:50:41.871179Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 1071527919948.00 |
| 2026-10-29 |
| premarket |
| — |
| 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 |