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_alerts609,118 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 |
|---|
| ee5a9d77-b84c-4ae7-8ae5-143f9dcf47d2 | 2026-09-15 11:58 | 2026-09-15 11:58 | 2026-09-15 11:58 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 1.5900 | 1.5800 | 1.6100 | 80.7301 | 385893.00 | 115116.00 | 270777.00 | 2427 | 56 | 21014 | 5556 | 3.78221742260619 | 0.107752798642037 | 0.108128898128293 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 47711923102.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| be267b6f-a718-4f57-ad5d-20248d79fbc7 | 2026-09-15 11:58 | 2026-09-15 11:58 | 2026-09-15 11:58 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 1.6000 | 1.5900 | 1.6100 | 80.7401 | 273920.00 | 480.00 | 273440.00 | 1712 | 47 | 18587 | 5556 | 3.34539236861051 | 0.108530360755249 | 0.108522679525607 | true | false | false | true | false | |||||||||||||||
| d32bb2c1-606a-4e63-af25-c768fa37e7e0 | 2026-09-15 11:57 | 2026-09-15 11:57 | 2026-09-15 11:57 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 1.6200 | 1.6200 | 1.6400 | 80.7601 | 810000.00 | 0.00 | 810000.00 | 5000 | 89 | 16875 | 5556 | 3.03725701943844 | 0.108929402008455 | 0.109308124580751 | true | false | false | true | false | |||||||||||||||
| 384efa99-fa11-4fef-afe5-c5923755e95a | 2026-09-15 11:56 | 2026-09-15 11:56 | 2026-09-15 11:56 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 1.6300 | 1.6300 | 1.6500 | 80.7750 | 418258.00 | 0.00 | 418258.00 | 2566 | 38 | 11875 | 5556 | 2.13732901367891 | 0.109320208598665 | 0.109320208598665 | true | false | false | true | false | |||||||||||||||
| 116f0ac7-a698-47d7-923e-efd24d3bb11f | 2026-09-15 11:56 | 2026-09-15 11:56 | 2026-09-15 11:56 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 1.6500 | 1.6400 | 1.6600 | 80.8000 | 401610.00 | 165.00 | 367620.00 | 2434 | 28 | 9309 | 5556 | 1.67548596112311 | 0.109709425076341 | 0.109709425076341 | true | false | false | true | false | |||||||||||||||
| 7cd7976a-da59-4a50-8bfe-237802f3d8ab | 2026-09-15 10:36 | 2026-09-15 10:36 | 2026-09-15 10:36 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 1.5700 | 1.5700 | 1.5800 | 80.6300 | 78500.00 | 0.00 | 78500.00 | 500 | 16 | 1717 | 5556 | 0.309035277177826 | 0.113305228727678 | 0.113305228727678 | false | false | false | true | false | |||||||||||||||
| d441b11e-a5ed-484e-99e0-021c1e28ea2a | 2026-09-15 10:36 | 2026-09-15 10:36 | 2026-09-15 10:36 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 1.5700 | 1.5700 | 1.5800 | 80.6350 | 11147.00 | 0.00 | 11147.00 | 71 | 5 | 1088 | 5556 | 0.195824334053276 | 0.112940717636234 | 0.112940717636234 | false | false | false | true | false | |||||||||||||||
| 2bf39eff-0455-4453-a4ff-93d9423a25ea | 2026-09-15 10:36 | 2026-09-15 10:36 | 2026-09-15 10:36 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 1.5700 | 1.5700 | 1.5800 | 80.6350 | 20296.00 | 6794.00 | 13502.00 | 129 | 16 | 1217 | 5556 | 0.219042476601872 | 0.114078712319532 | 0.112940717636234 | false | false | false | true | false | |||||||||||||||
| 833c5620-3877-4362-945b-be235b58ddef | 2026-09-15 10:36 | 2026-09-15 10:36 | 2026-09-15 10:36 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 1.5700 | 1.5700 | 1.5800 | 80.6300 | 78186.00 | 0.00 | 78186.00 | 498 | 5 | 1017 | 5556 | 0.18304535637149 | 0.113305228727678 | 0.113305228727678 | false | false | false | true | false | |||||||||||||||
| a6b4c1d6-c1ee-45f8-a605-adb069152e5d | 2026-09-15 10:16 | 2026-09-15 10:16 | 2026-09-15 10:16 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 1.5400 | 1.5200 | 1.5400 | 80.5550 | 19250.00 | 19250.00 | 0.00 | 125 | 12 | 504 | 5556 | 0.0907127429805616 | 0.115288605997557 | 0.115288605997557 | false | false | false | true | false | |||||||||||||||
| d7c9e8d4-9b25-4e59-8c49-8956d4c6fd67 | 2026-09-15 09:38 | 2026-09-15 09:38 | 2026-09-15 09:38 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 1.6100 | 1.5800 | 1.6100 | 80.6770 | 20125.00 | 20125.00 | 0.00 | 125 | 14 | 341 | 5556 | 0.0613750899928006 | 0.114421857957972 | 0.114421857957972 | false | false | false | true | false | |||||||||||||||
| d12315a2-64dd-4099-8216-934376708b62 | 2026-09-14 15:28 | 2026-09-14 15:28 | 2026-09-14 15:28 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 1.8100 | 1.7900 | 1.8100 | 81.0300 | 15747.00 | 15747.00 | 0.00 | 87 | 5 | 1613 | 4402 | 0.366424352567015 | 0.107622902921316 | 0.107622902921316 | true | false | false | true | false | |||||||||||||||
| 1d563215-ae44-4fed-a8ae-22444dac7fb1 | 2026-09-14 11:36 | 2026-09-14 11:36 | 2026-09-14 11:36 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 1.8400 | 1.8200 | 1.8400 | 81.1300 | 23920.00 | 23920.00 | 0.00 | 130 | 6 | 1335 | 4402 | 0.303271240345298 | 0.102581769844344 | 0.102581769844344 | true | false | false | true | false | |||||||||||||||
| 5bd75f43-5ccd-4df6-8d63-ab622d9274d7 | 2026-09-11 09:42 | 2026-09-11 09:42 | 2026-09-11 09:42 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 2.0400 | 2.0200 | 2.0500 | 81.4100 | 24480.00 | 24480.00 | 0.00 | 120 | 6 | 474 | 4181 | 0.113370007175317 | 0.094781617100789 | 0.094781617100789 | true | false | false | true | false | |||||||||||||||
| 1da0d2df-6048-4511-a243-55223f248187 | 2026-09-10 11:03 | 2026-09-10 11:03 | 2026-09-10 11:03 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 1.8600 | 1.8400 | 1.8700 | 81.0150 | 13206.00 | 12276.00 | 930.00 | 71 | 8 | 990 | 3685 | 0.26865671641791 | 0.107535494744729 | 0.107535494744729 | true | false | false | true | false | |||||||||||||||
| c5452d55-24a9-46d3-9b8f-0cf87691311b | 2026-09-10 09:31 | 2026-09-10 09:31 | 2026-09-10 09:31 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 1.8400 | 1.8300 | 1.8600 | 81.0000 | 50600.00 | 13800.00 | 36800.00 | 275 | 26 | 285 | 3685 | 0.0773405698778833 | 0.106460467909841 | 0.106460467909841 | true | false | false | true | false | |||||||||||||||
| 4c7d8c6c-6918-4a95-8296-97ae0e87e48b | 2026-09-09 14:58 | 2026-09-09 14:57 | 2026-09-09 14:57 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 2.3300 | 2.3000 | 2.3300 | 81.7300 | 11184.00 | 11184.00 | 0.00 | 48 | 8 | 863 | 3135 | 0.275279106858054 | 0.0963074154617787 | 0.0963074154617787 | true | false | false | true | false | |||||||||||||||
| 7c7bd1f7-272a-45e5-be3e-e4759aee9f2c | 2026-09-09 13:07 | 2026-09-09 13:06 | 2026-09-09 13:06 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 2.3700 | 2.3300 | 2.3600 | 81.0000 | 29343.00 | 29343.00 | 0.00 | 124 | 8 | 764 | 3135 | 0.243700159489633 | 0.09904468501699 | 0.09904468501699 | false | false | false | true | false | |||||||||||||||
| 8e9b0510-2c66-4b21-9e50-8a04ee66e771 | 2026-09-09 13:06 | 2026-09-09 13:06 | 2026-09-09 13:06 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 2.3700 | 2.3500 | 2.3900 | 81.0000 | 28914.00 | 0.00 | 27729.00 | 122 | 8 | 640 | 3135 | 0.20414673046252 | 0.0968469778239342 | 0.0968469778239342 | false | false | false | true | false | |||||||||||||||
| 4557903e-deae-4b1d-b034-4f3a2c81ee75 | 2026-08-26 10:02 | 2026-08-26 10:01 | 2026-08-26 10:01 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 3.4500 | 3.4500 | 3.5000 | 83.1620 | 24150.00 | 0.00 | 24150.00 | 70 | 14 | 130 | 2808 | 0.0462962962962963 | 0.109629133041439 | 0.109629133041439 | false | false | false | true | false | |||||||||||||||
| 186c35c5-360e-488a-bfe0-7a46b99cbba3 | 2026-08-24 10:46 | 2026-08-24 10:46 | 2026-08-24 10:46 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 3.0500 | 3.0000 | 3.0500 | 82.5550 | 39650.00 | 39650.00 | 0.00 | 130 | 7 | 957 | 1839 | 0.520391517128874 | 0.0637084798482795 | 0.0637084798482795 | false | false | false | true | false | |||||||||||||||
| 5dcfbead-2456-4d70-9729-5f4b89687777 | 2026-08-24 09:39 | 2026-08-24 09:39 | 2026-08-24 09:39 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 3.0200 | 2.9800 | 3.0500 | 82.5169 | 15100.00 | 15100.00 | 0.00 | 50 | 5 | 768 | 1839 | 0.417618270799347 | 0.0651005820864631 | 0.0651005820864631 | false | false | false | true | false | |||||||||||||||
| 94a62817-0f05-429e-8b3b-be4a710b27c6 | 2026-08-20 11:37 | 2026-08-20 11:37 | 2026-08-20 11:37 | TLT | TLT261016C00080000 | call | 80.0000 | 2026-10-16 | 2.8600 | 2.8300 | 2.8600 | 82.2250 | 10010.00 | 10010.00 | 0.00 | 35 | 6 | 77 | 1790 | 0.0430167597765363 | 0.07564174878071 | 0.07564174878071 | false | false | false | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47711923102.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47711923102.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47711923102.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47711923102.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47711923102.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47711923102.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 47711923102.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47711923102.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:36:37.058930Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47711923102.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47711923102.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47432867617.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47432867617.00 |
| — |
| — |
| — |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47432867617.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:46:58.036194Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47432867617.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T15:21:12.723015Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47432867617.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:32:54.294551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47432867617.00 |
| — |
| — |
| — |
| 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 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 47432867617.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47432867617.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47711923102.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47711923102.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47711923102.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:46:45.098903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 47711923102.00 |
| — |
| — |
| — |
| 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 |