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_alerts523,327 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 |
|---|
| c94e8cb1-b39c-4854-b954-ba19fcfbac38 | 2026-09-24 14:03 | 2026-09-24 14:03 | 2026-09-24 14:03 | XLK | XLK261016P00185000 | put | 185.0000 | 2026-10-16 | 1.7500 | 1.5500 | 1.7500 | 193.0000 | 11899.00 | 11899.00 | 0.00 | 68 | 13 | 1135 | 4457 | 0.254655597935831 | 0.275403194157182 | 0.275403194157182 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 127233255405.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T18:05:05.581438Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| 4d589d69-2b77-4511-a905-c51afdd21337 | 2026-09-24 11:56 | 2026-09-24 11:56 | 2026-09-24 11:56 | XLK | XLK261016P00185000 | put | 185.0000 | 2026-10-16 | 1.8900 | 1.7200 | 1.9000 | 193.3000 | 97713.00 | 97524.00 | 189.00 | 517 | 38 | 792 | 4457 | 0.177698003141126 | 0.276637580329567 | 0.276637580329567 | true | false | false | true | false | |||||||||||||||
| b3d1417c-38c8-40ab-8e41-428424bf220a | 2026-09-22 10:28 | 2026-09-22 10:28 | 2026-09-22 10:28 | XLK | XLK261016P00185000 | put | 185.0000 | 2026-10-16 | 1.3400 | 1.1700 | 1.5000 | 195.3500 | 48072.00 | 11188.00 | 32834.00 | 359 | 25 | 631 | 4384 | 0.143932481751825 | 0.257190351060456 | 0.255689410390387 | false | false | false | true | false | |||||||||||||||
| 94d36e56-73ee-491f-87cc-55728486b53e | 2026-09-21 10:24 | 2026-09-21 10:24 | 2026-09-21 10:24 | XLK | XLK261016P00185000 | put | 185.0000 | 2026-10-16 | 1.8400 | 1.8300 | 2.1100 | 192.6800 | 26166.00 | 185.00 | 17286.00 | 142 | 14 | 145 | 4322 | 0.0335492827394725 | 0.248453970603829 | 0.247182460809223 | true | false | false | true | false | |||||||||||||||
| ba1c627f-e411-4c91-9235-0733233fb016 | 2026-09-16 12:26 | 2026-09-16 12:26 | 2026-09-16 12:26 | XLK | XLK261016P00185000 | put | 185.0000 | 2026-10-16 | 4.5500 | 4.5500 | 4.7000 | 185.4900 | 82378.00 | 0.00 | 82378.00 | 181 | 18 | 1150 | 3454 | 0.3329473074696 | 0.239957956463659 | 0.239957956463659 | false | false | false | true | false | |||||||||||||||
| 95b04d9c-6bb9-47c4-9857-da25472b7911 | 2026-09-16 11:27 | 2026-09-16 11:27 | 2026-09-16 11:27 | XLK | XLK261016P00185000 | put | 185.0000 | 2026-10-16 | 4.5500 | 4.5500 | 4.9500 | 185.8600 | 253908.00 | 0.00 | 253908.00 | 558 | 39 | 725 | 3454 | 0.209901563404748 | 0.247816166298555 | 0.247816166298555 | false | false | false | true | false | |||||||||||||||
| c249b397-5251-4830-b72e-995db0cfa4a1 | 2026-09-16 09:52 | 2026-09-16 09:52 | 2026-09-16 09:52 | XLK | XLK261016P00185000 | put | 185.0000 | 2026-10-16 | 4.7000 | 4.5000 | 5.2500 | 185.5550 | 62980.00 | 62040.00 | 940.00 | 134 | 7 | 135 | 3454 | 0.0390851187029531 | 0.248473340625931 | 0.248473340625931 | false | false | false | true | false | |||||||||||||||
| e001200a-a1c4-4c56-a1bd-079f170acb62 | 2026-09-15 14:56 | 2026-09-15 14:56 | 2026-09-15 14:56 | XLK | XLK261016P00185000 | put | 185.0000 | 2026-10-16 | 5.6500 | 5.6500 | 5.7000 | 183.6550 | 551440.00 | 0.00 | 551440.00 | 976 | 14 | 3012 | 497 | 6.06036217303823 | 0.247247688480453 | 0.247247688480453 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 127233255405.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:00:52.133329Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 126496834839.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:31:31.654153Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 123191972879.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:26:48.053449Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 119221096945.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T16:35:37.886334Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 119221096945.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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 119221096945.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 119462218474.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:59:21.919987Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |