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_alerts375,978 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 |
|---|
| 5471a1b4-993c-4b98-b6d0-3175e2e0fe6d | 2026-09-23 10:59 | 2026-09-23 10:58 | 2026-09-23 10:58 | PLD | PLD261016C00140000 | call | 140.0000 | 2026-10-16 | 1.2500 | 1.2500 | 1.5000 | 134.0000 | 14125.00 | 0.00 | 14125.00 | 113 | 26 | 116 | 1214 | 0.0955518945634267 | 0.225000077632885 | 0.225000077632885 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Real Estate | 124994860960.00 | 2026-10-15 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T15:00:57.901243Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| c212cfae-1d3f-435d-afbb-4215473781ba | 2026-09-23 10:37 | 2026-09-23 10:37 | 2026-09-23 10:37 | PLD | PLD270115P00150000 | put | 150.0000 | 2027-01-15 | 16.4000 | 14.2000 | 16.5000 | 134.8300 | 100040.00 | 9840.00 | 90200.00 | 61 | 5 | 669 | 692 | 0.966763005780347 | 0.259469032146373 | 0.259469032146373 | false | false | false | |||||||||||||||||
| 80ea0f32-0714-49fb-8a1f-883f336af726 | 2026-09-23 10:37 | 2026-09-23 10:37 | 2026-09-23 10:37 | PLD | PLD270115P00150000 | put | 150.0000 | 2027-01-15 | 16.4000 | 16.4000 | 16.6000 | 134.8100 | 364080.00 | 0.00 | 364080.00 | 222 | 12 | 608 | 692 | 0.878612716763006 | 0.258907514930717 | 0.258907514930717 | false | false | false | |||||||||||||||||
| 5bea5016-7de5-4757-ae6d-e48260863e7f | 2026-09-23 10:30 | 2026-09-23 10:30 | 2026-09-23 10:30 | PLD | PLD270115P00150000 | put | 150.0000 | 2027-01-15 | 16.3000 | 16.3000 | 16.6000 | 134.8350 | 163000.00 | 0.00 | 163000.00 | 100 | 5 | 333 | 692 | 0.48121387283237 | 0.255682846386652 | 0.255682846386652 | false | false | false | |||||||||||||||||
| ec155f60-f194-488e-a1e3-be721493a24a | 2026-09-23 10:30 | 2026-09-23 10:30 | 2026-09-23 10:30 | PLD | PLD270115P00150000 | put | 150.0000 | 2027-01-15 | 16.3000 | 16.3000 | 16.7000 | 134.8400 | 218420.00 | 0.00 | 218420.00 | 134 | 7 | 157 | 692 | 0.226878612716763 | 0.255824493533875 | 0.255824493533875 | false | false | false | |||||||||||||||||
| 0eaa3e9d-70de-47b8-8630-c078e520375f | 2026-09-22 15:10 | 2026-09-22 15:10 | 2026-09-22 15:10 | PLD | PLD261016C00140000 | call | 140.0000 | 2026-10-16 | 1.7000 | 1.6000 | 1.7000 | 135.4217 | 34000.00 | 34000.00 | 0.00 | 200 | 22 | 246 | 996 | 0.246987951807229 | 0.241700932491473 | 0.241700932491473 | false | false | false | |||||||||||||||||
| 608d014a-8698-4261-9b8a-d062c231197c | 2026-09-21 10:37 | 2026-09-21 10:37 | 2026-09-21 10:37 | PLD | PLD261016C00135000 | call | 135.0000 | 2026-10-16 | 4.1000 | 4.0000 | 4.2000 | 135.6400 | 60680.00 | 17630.00 | 0.00 | 148 | 29 | 191 | 1031 | 0.185257032007759 | 0.253366821863281 | 0.253366821863281 | false | false | false | |||||||||||||||||
| 20458e9f-d4e5-49cc-be6d-9156e948e51f | 2026-09-17 14:58 | 2026-09-17 14:58 | 2026-09-17 14:58 | PLD | PLD261016P00135000 | put | 135.0000 | 2026-10-16 | 3.5000 | 3.3000 | 3.5000 | 134.9300 | 117929.00 | 117929.00 | 0.00 | 337 | 38 | 382 | 1306 | 0.29249617151608 | 0.242527854951506 | 0.242527854951506 | false | false | false | |||||||||||||||||
| 3c2e6907-6b38-452b-9bfe-07018cf86de4 | 2026-09-16 11:23 | 2026-09-16 11:23 | 2026-09-16 11:23 | PLD | PLD261016C00135000 | call | 135.0000 | 2026-10-16 | 4.3000 | 4.1000 | 4.5000 | 135.3400 | 303150.00 | 24080.00 | 250260.00 | 705 | 146 | 705 | 148 | 4.76351351351351 | 0.25041898923555 | 0.252733346716324 | true | false | false | |||||||||||||||||
| c2b132c9-3db9-40bc-9a36-84b58d256a13 | 2026-09-14 11:59 | 2026-09-14 11:59 | 2026-09-14 11:59 | PLD | PLD261120C00135000 | call | 135.0000 | 2026-11-20 | 5.7000 | 4.9000 | 6.0000 | 135.4300 | 57000.00 | 41610.00 | 15390.00 | 100 | 6 | 200 | 58 | 3.44827586206897 | 0.215036472663047 | 0.215036472663047 | false | false | false | |||||||||||||||||
| 4d869dcb-dbc1-4d24-a910-be51d91ce7d3 | 2026-08-28 14:26 | 2026-08-28 14:26 | 2026-08-28 14:26 | PLD | PLD260918C00145000 | call | 145.0000 | 2026-09-18 | 1.1000 | 0.7500 | 1.1000 | 141.0400 | 89740.00 | 89740.00 | 0.00 | 816 | 44 | 852 | 2771 | 0.307470227354746 | 0.183801019465175 | 0.183801019465175 | false | false | false | |||||||||||||||||
| b8251302-a5c0-45de-a605-1c322c5b688f | 2026-08-28 12:45 | 2026-08-28 12:45 | 2026-08-28 12:45 | PLD | PLD261120P00130000 | put | 130.0000 | 2026-11-20 | 2.2500 | 2.2500 | 2.4500 | 140.7300 | 327619.00 | 0.00 | 327619.00 | 1456 | 51 | 1456 | 438 | 3.32420091324201 | 0.253970664903334 | 0.253970664903334 | false | false | false | |||||||||||||||||
| 9ef5c501-e46a-4635-b260-309e773b152b | 2026-08-27 14:05 | 2026-08-27 14:05 | 2026-08-27 14:05 | PLD | PLD270319P00125000 | put | 125.0000 | 2027-03-19 | 4.0000 | 3.6000 | 4.4000 | 141.6000 | 51200.00 | 50800.00 | 0.00 | 128 | 8 | 300 | 0 | 0 | 0.280152089890848 | 0.280152089890848 | false | false | false | |||||||||||||||||
| d87fde14-7695-42c4-9591-fc7557d15dcf | 2026-08-27 12:47 | 2026-08-27 12:47 | 2026-08-27 12:47 | PLD | PLD270617P00125000 | put | 125.0000 | 2027-06-17 | 5.8000 | 5.4000 | 6.3000 | 142.2400 | 52200.00 | 46980.00 | 5220.00 | 90 | 14 | 90 | 539 | 0.166975881261596 | 0.292771723917852 | 0.292771723917852 | false | false | false | |||||||||||||||||
| e9e6fe27-a2d7-4b0e-b9a2-d9e52d85e51c | 2026-08-25 14:42 | 2026-08-25 14:42 | 2026-08-25 14:42 | PLD | PLD261016P00135000 | put | 135.0000 | 2026-10-16 | 2.2000 | 2.0500 | 2.3000 | 143.3500 | 64900.00 | 8360.00 | 56540.00 | 295 | 13 | 311 | 486 | 0.639917695473251 | 0.268559600983668 | 0.268559600983668 | false | false | false | |||||||||||||||||
| 59135c22-d29d-45fb-876f-2bfc92f14e5c | 2026-08-25 11:03 | 2026-08-25 11:03 | 2026-08-25 11:03 | PLD | PLD260918C00145000 | call | 145.0000 | 2026-09-18 | 2.1000 | 2.0000 | 2.1000 | 143.2200 | 86940.00 | 3780.00 | 0.00 | 414 | 21 | 638 | 2020 | 0.315841584158416 | 0.186894839684189 | 0.186894839684189 | false | false | false | |||||||||||||||||
| 79e8a057-fd44-4731-be8b-44e81eab6e0c | 2026-08-19 10:58 | 2026-08-19 10:58 | 2026-08-19 10:58 | PLD | PLD260918C00140000 | call | 140.0000 | 2026-09-18 | 4.0000 | 4.0000 | 4.4000 | 140.9800 | 57200.00 | 0.00 | 28000.00 | 143 | 61 | 748 | 616 | 1.21428571428571 | 0.202225493845643 | 0.202225493845643 | true | false | false | |||||||||||||||||
| a8270651-aaca-4f82-8e3e-88311beffcbe | 2026-08-19 10:58 | 2026-08-19 10:57 | 2026-08-19 10:57 | PLD | PLD260918C00140000 | call | 140.0000 | 2026-09-18 | 4.0000 | 3.9000 | 4.4000 | 141.0400 | 80000.00 | 22800.00 | 35600.00 | 200 | 99 | 603 | 616 | 0.978896103896104 | 0.200012646205328 | 0.200012646205328 | true | false | false | |||||||||||||||||
| cea6a69f-cb9e-4d3b-98c1-41b73698b84b | 2026-08-19 10:26 | 2026-08-19 10:26 | 2026-08-19 10:26 | PLD | PLD260918C00140000 | call | 140.0000 | 2026-09-18 | 4.3000 | 4.0000 | 4.6000 | 141.4000 | 86000.00 | 1290.00 | 76110.00 | 200 | 20 | 202 | 616 | 0.327922077922078 | 0.202858749090036 | 0.205547527755649 | true | false | false | |||||||||||||||||
| 9d9dc528-2800-478b-b122-6f14d804b34d | 2026-08-18 15:03 | 2026-08-18 15:03 | 2026-08-18 15:03 | PLD | PLD270617P00125000 | put | 125.0000 | 2027-06-17 | 6.5000 | 6.2000 | 7.0000 | 140.2350 | 55250.00 | 50050.00 | 5200.00 | 85 | 13 | 85 | 344 | 0.247093023255814 | 0.298627755138087 | 0.298627755138087 | false | false | false | |||||||||||||||||
| 07467522-741f-4d88-a53d-97b0f7fcdf71 | 2026-08-18 10:35 | 2026-08-18 10:35 | 2026-08-18 10:35 | PLD | PLD260918P00135000 | put | 135.0000 | 2026-09-18 | 1.7500 | 1.3000 | 2.0000 | 140.1450 | 130375.00 | 1750.00 | 128625.00 | 745 | 20 | 746 | 1119 | 0.666666666666667 | 0.245927384332619 | 0.245927384332619 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 124994860960.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:37:43.750009Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 124994860960.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:37:43.750009Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 124994860960.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:31:12.586989Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 124994860960.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:31:12.586989Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 126786366880.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:10:39.996631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 126730382320.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:39:35.705687Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 126133213680.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 124789584240.00 |
| 2026-10-15 |
| premarket |
| — |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 126142544440.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:02:31.142849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 126142544440.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T18:46:22.896033Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Real Estate |
| 126142544440.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 126142544440.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:14:24.609292Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 126142544440.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:57:23.365599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 126142544440.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T18:54:14.733334Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 126142544440.00 |
| 2026-10-15 |
| premarket |
| — |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 126142544440.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 126142544440.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 126142544440.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 126142544440.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 126142544440.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |