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_alerts425,429 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 |
|---|
| 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 |
|---|
| a6d10a0a-b91f-4732-8407-1bf2a52649f1 | 2026-09-23 11:31 | 2026-09-23 11:30 | 2026-09-23 11:30 | LH | LH261016C00320000 | call | 320.0000 | 2026-10-16 | 3.8000 | 3.3000 | 3.8000 | 310.2500 | 40280.00 | 40280.00 | 0.00 | 106 | 17 | 121 | 3 | 40.3333333333333 | 0.235908251017705 | 0.235908251017705 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 24652778000.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T15:35:15.101362Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 0ee04c1d-5e43-4b48-923e-8fc998dbdc5a | 2026-09-22 10:26 | 2026-09-22 10:26 | 2026-09-22 10:26 | LH | LH261016P00320000 | put | 320.0000 | 2026-10-16 | 10.0200 | 9.7000 | 11.5000 | 314.0000 | 150374.00 | 0.00 | 150374.00 | 150 | 9 | 171 | 157 | 1.08917197452229 | 0.226683227463814 | 0.230504717757199 | false | false | false | true | false | |||||||||||||||
| 8bef4385-d0c1-40aa-a261-82ada71d5a7e | 2026-09-21 11:47 | 2026-09-21 11:47 | 2026-09-21 11:47 | LH | LH261016P00320000 | put | 320.0000 | 2026-10-16 | 7.0000 | 5.4000 | 7.0000 | 323.0600 | 38486.00 | 38486.00 | 0.00 | 55 | 14 | 164 | 6 | 27.3333333333333 | 0.263311869445843 | 0.263311869445843 | false | false | false | true | false | |||||||||||||||
| 6319991e-cf2c-4d77-be40-a2db92400a9d | 2026-09-21 10:07 | 2026-09-21 10:07 | 2026-09-21 10:07 | LH | LH261016P00320000 | put | 320.0000 | 2026-10-16 | 7.3000 | 6.1000 | 7.4000 | 321.3500 | 25550.00 | 7300.00 | 18250.00 | 35 | 6 | 49 | 6 | 8.16666666666667 | 0.250157892655273 | 0.250157892655273 | false | false | false | true | false | |||||||||||||||
| 484163b5-7608-4d63-a038-1d672ac763e5 | 2026-09-14 11:28 | 2026-09-14 11:28 | 2026-09-14 11:28 | LH | LH260918P00310000 | put | 310.0000 | 2026-09-18 | 3.9000 | 2.2000 | 4.3000 | 309.7500 | 17940.00 | 1170.00 | 12090.00 | 46 | 7 | 46 | 736 | 0.0625 | 0.296911655405259 | 0.296911655405259 | false | false | false | true | false | |||||||||||||||
| 221aed2a-8a90-4325-89e7-435a8a01ddce | 2026-09-11 14:00 | 2026-09-11 14:00 | 2026-09-11 14:00 | LH | LH260918P00310000 | put | 310.0000 | 2026-09-18 | 4.7000 | 4.3000 | 4.7000 | 309.1200 | 28200.00 | 28200.00 | 0.00 | 60 | 21 | 378 | 271 | 1.39483394833948 | 0.255543825903219 | 0.255543825903219 | true | false | false | true | false | |||||||||||||||
| 715a44a4-0625-4244-bdf2-655e0498b4b1 | 2026-09-10 14:45 | 2026-09-10 14:45 | 2026-09-10 14:45 | LH | LH260918P00320000 | put | 320.0000 | 2026-09-18 | 12.5000 | 11.4000 | 13.6000 | 307.9800 | 206250.00 | 0.00 | 0.00 | 165 | 1 | 602 | 327 | 1.84097859327217 | 0.231176680770546 | 0.231176680770546 | false | true | false | true | false | |||||||||||||||
| d4470d92-27a4-4faf-948b-a325e9d2727f | 2026-09-10 13:53 | 2026-09-10 13:53 | 2026-09-10 13:53 | LH | LH260918P00310000 | put | 310.0000 | 2026-09-18 | 5.9300 | 4.9000 | 6.0000 | 307.3700 | 118640.00 | 118640.00 | 0.00 | 200 | 10 | 225 | 76 | 2.96052631578947 | 0.256144122940604 | 0.256144122940604 | false | false | false | true | false | |||||||||||||||
| 7305a4b3-2cfe-4308-9745-5001a049dafd | 2026-09-10 12:22 | 2026-09-10 12:22 | 2026-09-10 12:22 | LH | LH260918P00320000 | put | 320.0000 | 2026-09-18 | 6.5900 | 4.9000 | 7.8000 | 316.1200 | 59320.00 | 59320.00 | 0.00 | 90 | 11 | 300 | 327 | 0.917431192660551 | 0.243214595112099 | 0.243214595112099 | false | false | false | true | false | |||||||||||||||
| c5793d34-05a4-4750-8979-e78ac7b4f961 | 2026-09-10 12:02 | 2026-09-10 12:02 | 2026-09-10 12:02 | LH | LH260918P00320000 | put | 320.0000 | 2026-09-18 | 7.4400 | 5.3000 | 8.1000 | 315.3300 | 59488.00 | 59488.00 | 0.00 | 80 | 9 | 100 | 327 | 0.305810397553517 | 0.271832525556318 | 0.26048358335349 | false | false | false | true | false | |||||||||||||||
| 80423055-8641-4fd6-bc91-fa49cfc10960 | 2026-09-10 11:30 | 2026-09-10 11:30 | 2026-09-10 11:30 | LH | LH260918C00320000 | call | 320.0000 | 2026-09-18 | 3.2000 | 2.4500 | 4.4000 | 317.4250 | 64000.00 | 0.00 | 64000.00 | 200 | 1 | 350 | 612 | 0.571895424836601 | 0.226181004756259 | 0.226181004756259 | false | true | false | true | false | |||||||||||||||
| de11f983-8406-4bed-b7fe-2aefd56945b2 | 2026-09-09 14:59 | 2026-09-09 14:59 | 2026-09-09 14:59 | LH | LH260918C00320000 | call | 320.0000 | 2026-09-18 | 6.4900 | 5.0000 | 6.7000 | 321.7400 | 32447.00 | 32447.00 | 0.00 | 50 | 16 | 550 | 69 | 7.97101449275362 | 0.269221186794474 | 0.26972468483875 | false | false | false | true | false | |||||||||||||||
| d302995f-4f38-4036-814d-8a81fd0ff9e7 | 2026-09-09 14:28 | 2026-09-09 14:28 | 2026-09-09 14:28 | LH | LH260918C00320000 | call | 320.0000 | 2026-09-18 | 6.6000 | 4.3000 | 6.9000 | 321.9500 | 98978.00 | 98978.00 | 0.00 | 150 | 9 | 500 | 69 | 7.2463768115942 | 0.268719355650094 | 0.268719355650094 | false | false | false | true | false | |||||||||||||||
| 01fd999b-1246-449f-b2a7-957bd9ff96ca | 2026-09-04 10:59 | 2026-09-04 10:59 | 2026-09-04 10:59 | LH | LH261016P00330000 | put | 330.0000 | 2026-10-16 | 10.0000 | 8.0000 | 10.0000 | 329.5000 | 28000.00 | 28000.00 | 0.00 | 28 | 5 | 110 | 202 | 0.544554455445545 | 0.235516293396424 | 0.235516293396424 | false | false | false | true | false | |||||||||||||||
| 6ece12c0-73db-4caa-b18f-5f66310edbed | 2026-09-03 14:38 | 2026-09-03 14:38 | 2026-09-03 14:38 | LH | LH261016P00330000 | put | 330.0000 | 2026-10-16 | 9.0000 | 8.3000 | 9.7000 | 329.8700 | 180000.00 | 0.00 | 0.00 | 200 | 10 | 200 | 2 | 100 | 0.213945564354028 | 0.213945564354028 | false | false | false | true | false | |||||||||||||||
| 68c14295-f06f-4acb-b631-61d06a3a929a | 2026-08-20 11:13 | 2026-08-20 11:13 | 2026-08-20 11:13 | LH | LH270115C00340000 | call | 340.0000 | 2027-01-15 | 19.1000 | 19.1000 | 20.2000 | 335.3100 | 53480.00 | 0.00 | 53480.00 | 28 | 9 | 323 | 2 | 161.5 | 0.220514679707291 | 0.220514679707291 | false | false | false | true | false | |||||||||||||||
| dca5d478-c897-426e-a826-cd4484e2c1fe | 2026-08-20 11:13 | 2026-08-20 11:13 | 2026-08-20 11:13 | LH | LH270115C00340000 | call | 340.0000 | 2027-01-15 | 19.3000 | 19.3000 | 20.2000 | 335.7600 | 82990.00 | 0.00 | 82990.00 | 43 | 18 | 262 | 2 | 131 | 0.22003058555019 | 0.22003058555019 | false | false | false | true | false | |||||||||||||||
| 9b2943eb-a0af-4b8b-a7e0-a3aaf6dbc340 | 2026-08-20 11:12 | 2026-08-20 11:12 | 2026-08-20 11:12 | LH | LH270115C00340000 | call | 340.0000 | 2027-01-15 | 19.7000 | 19.5000 | 19.7000 | 335.7550 | 29550.00 | 29550.00 | 0.00 | 15 | 5 | 179 | 2 | 89.5 | 0.224773088903855 | 0.224773088903855 | false | false | false | true | false | |||||||||||||||
| 2bc983c8-1a32-4a3a-a6cf-7406a29d3177 | 2026-08-20 11:12 | 2026-08-20 11:12 | 2026-08-20 11:12 | LH | LH270115C00340000 | call | 340.0000 | 2027-01-15 | 19.5000 | 19.5000 | 20.7000 | 336.1150 | 68250.00 | 0.00 | 68250.00 | 35 | 16 | 161 | 2 | 80.5 | 0.220131864762818 | 0.220131864762818 | false | false | false | true | false | |||||||||||||||
| 309fe075-be02-4679-9ccd-58d656deee7d | 2026-08-20 11:11 | 2026-08-20 11:11 | 2026-08-20 11:11 | LH | LH270115C00340000 | call | 340.0000 | 2027-01-15 | 19.6000 | 19.6000 | 20.7000 | 336.2400 | 82320.00 | 0.00 | 82320.00 | 42 | 18 | 93 | 2 | 46.5 | 0.22051271291242 | 0.22051271291242 | false | false | false | true | false | |||||||||||||||
| fde2721c-36e1-43c6-98fa-8808bb60550a | 2026-08-19 10:09 | 2026-08-19 10:09 | 2026-08-19 10:09 | LH | LH270115C00360000 | call | 360.0000 | 2027-01-15 | 9.7000 | 6.7000 | 9.7000 | 328.3600 | 46560.00 | 46560.00 | 0.00 | 48 | 13 | 48 | 3 | 16 | 0.230706275129082 | 0.230706275129082 | false | false | false | true | false | |||||||||||||||
| bde02e7a-4ae6-49f1-9310-f357bec56eea | 2026-08-18 15:35 | 2026-08-18 15:35 | 2026-08-18 15:35 | LH | LH260821C00300000 | call | 300.0000 | 2026-08-21 | 25.4700 | 24.7000 | 27.4000 | 325.3100 | 50940.00 | 0.00 | 50940.00 | 20 | 10 | 20 | 143 | 0.13986013986014 | 0.425733930736424 | 0.425733930736424 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 25265894000.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:27:42.600893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 26032289000.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:49:21.879731Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 26032289000.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:08:15.762043Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:39:52.032222Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| 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 |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:09:00.187388Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T16:37:06.868856Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T16:13:08.333814Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T15:47:40.219521Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:58:33.363095Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:16:49.821442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:16:49.821442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:16:49.821442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:16:49.821442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:16:49.821442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 25571641000.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |