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 | price |
|---|
| 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 |
|---|
| d89fa4b2-4968-4072-bee0-8f078a37d201 | 2026-08-18 10:07 | 2026-08-18 10:07 | 2026-08-18 10:07 | ICE | ICE260821P00155000 | put | 155.0000 | 2026-08-21 | 1.2000 | 0.9500 | 1.5000 | 156.7000 | 85437.00 | 85317.00 | 120.00 | 712 | 40 | 716 | 124 | 5.7741935483871 | 0.346149736880797 | 0.346149736880797 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 88559980324.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8b067316-b749-4bcd-aa0c-7abad5e1198c | 2026-08-20 11:16 | 2026-08-20 11:16 | 2026-08-20 11:16 | ICE | ICE260918P00160000 | put | 160.0000 | 2026-09-18 | 5.0000 | 4.8000 | 5.2000 | 159.1800 | 74000.00 | 30500.00 | 43000.00 | 148 | 16 | 148 | 137 | 1.08029197080292 | 0.269461280073894 | 0.269461280073894 | false | false | false | true | false | |||||||||||||||
| 0aee73be-ee2c-4520-a2c1-30b1b86c405b | 2026-08-21 13:22 | 2026-08-21 13:22 | 2026-08-21 13:22 | ICE | ICE261218C00170000 | call | 170.0000 | 2026-12-18 | 6.9000 | 6.6000 | 6.9000 | 161.5100 | 55890.00 | 55890.00 | 0.00 | 81 | 26 | 83 | 135 | 0.614814814814815 | 0.260144240433115 | 0.260144240433115 | false | false | false | true | false | |||||||||||||||
| 01981770-bee4-481e-9de2-169b1bbb1e66 | 2026-08-25 10:58 | 2026-08-25 10:58 | 2026-08-25 10:58 | ICE | ICE270115C00160000 | call | 160.0000 | 2027-01-15 | 13.0000 | 13.0000 | 13.2000 | 162.3687 | 50700.00 | 0.00 | 50700.00 | 39 | 6 | 41 | 2013 | 0.020367610531545 | 0.26084173591852 | 0.26084173591852 | false | false | false | true | false | |||||||||||||||
| 234a8e23-fc8f-4695-a341-f9c6ed81c173 | 2026-08-31 12:10 | 2026-08-31 12:09 | 2026-08-31 12:09 | ICE | ICE270115P00155000 | put | 155.0000 | 2027-01-15 | 7.3000 | 7.1000 | 7.4000 | 159.7250 | 68620.00 | 68620.00 | 0.00 | 94 | 5 | 115 | 740 | 0.155405405405405 | 0.274013789422956 | 0.274013789422956 | false | false | false | true | false | |||||||||||||||
| a5ff3b3d-8909-49a1-9bf9-9e1ffb612163 | 2026-08-31 12:44 | 2026-08-31 12:44 | 2026-08-31 12:44 | ICE | ICE260911P00182500 | put | 182.5000 | 2026-09-11 | 23.8000 | 23.7000 | 23.8000 | 159.5800 | 118999.00 | 118999.00 | 0.00 | 50 | 11 | 58 | 0 | 0 | 0.644082964196365 | 0.642358596824784 | false | false | false | true | false | |||||||||||||||
| 7acd49a4-dfde-4259-a0c2-1cc8d8b5e4b9 | 2026-09-01 15:08 | 2026-09-01 15:08 | 2026-09-01 15:08 | ICE | ICE280121C00140000 | call | 140.0000 | 2028-01-21 | 37.2000 | 33.9000 | 37.2000 | 159.2800 | 368280.00 | 368280.00 | 0.00 | 99 | 10 | 100 | 179 | 0.558659217877095 | 0.303817463910481 | 0.303817463910481 | false | false | false | true | false | |||||||||||||||
| c0075cfa-2e4a-487c-8c49-6cd93e68ded5 | 2026-09-03 15:25 | 2026-09-03 15:25 | 2026-09-03 15:25 | ICE | ICE260911P00162500 | put | 162.5000 | 2026-09-11 | 1.9500 | 1.6000 | 1.9500 | 163.2500 | 67663.00 | 67663.00 | 0.00 | 347 | 29 | 462 | 31 | 14.9032258064516 | 0.246154366458519 | 0.246154366458519 | false | false | false | true | false | |||||||||||||||
| a7d5bf28-1c95-4b5e-b67c-7f7f1dd0809e | 2026-09-15 14:16 | 2026-09-15 14:16 | 2026-09-15 14:16 | ICE | ICE260918C00145000 | call | 145.0000 | 2026-09-18 | 11.3000 | 10.5000 | 12.0000 | 156.4700 | 2034000.00 | 2034000.00 | 0.00 | 1800 | 1 | 1803 | 9236 | 0.195214378518839 | 0.681507187095777 | 0.681507187095777 | false | true | false | true | false | |||||||||||||||
| 1d6ceafb-6b6b-4b27-a995-8335d57f5d2b | 2026-09-15 14:16 | 2026-09-15 14:16 | 2026-09-15 14:16 | ICE | ICE260918C00145000 | call | 145.0000 | 2026-09-18 | 11.3000 | 10.5000 | 12.0000 | 156.4700 | 2034000.00 | 2034000.00 | 0.00 | 1800 | 1 | 3603 | 9236 | 0.390103941100043 | 0.681507187095777 | 0.681507187095777 | false | true | false | true | false | |||||||||||||||
| e98e5873-1337-4fb7-a948-6ac713ef98f8 | 2026-09-15 14:16 | 2026-09-15 14:16 | 2026-09-15 14:16 | ICE | ICE260918C00145000 | call | 145.0000 | 2026-09-18 | 11.3000 | 10.5000 | 12.0000 | 156.4700 | 2034000.00 | 2034000.00 | 0.00 | 1800 | 1 | 7203 | 9236 | 0.779883066262451 | 0.681507187095777 | 0.681507187095777 | false | true | false | true | false | |||||||||||||||
| d5bacca3-5496-4f4b-bc08-fd1df01fd05f | 2026-09-15 14:16 | 2026-09-15 14:16 | 2026-09-15 14:16 | ICE | ICE260918C00145000 | call | 145.0000 | 2026-09-18 | 11.3000 | 10.5000 | 12.0000 | 156.4700 | 2034000.00 | 2034000.00 | 0.00 | 1800 | 1 | 10803 | 9236 | 1.16966219142486 | 0.681507187095777 | 0.681507187095777 | false | true | false | true | false | |||||||||||||||
| 70ebc2d2-133a-432e-b784-fa9c19edf57b | 2026-09-15 14:16 | 2026-09-15 14:16 | 2026-09-15 14:16 | ICE | ICE260918C00145000 | call | 145.0000 | 2026-09-18 | 11.3000 | 10.5000 | 12.0000 | 156.4700 | 2034000.00 | 2034000.00 | 0.00 | 1800 | 1 | 14403 | 9236 | 1.55944131658727 | 0.681507187095777 | 0.681507187095777 | false | true | false | true | false | |||||||||||||||
| 12d1329d-c0b9-405a-b869-02d2e0dc7ddf | 2026-09-17 12:01 | 2026-09-17 12:01 | 2026-09-17 12:01 | ICE | ICE270115C00150000 | call | 150.0000 | 2027-01-15 | 12.3000 | 12.2000 | 12.6000 | 153.7250 | 142680.00 | 1230.00 | 141450.00 | 116 | 32 | 116 | 941 | 0.12327311370882 | 0.261306134219579 | 0.264244750508582 | false | false | false | true | false | |||||||||||||||
| 847f5d17-b6e3-4dfe-bbf3-ddcd5df63d8f | 2026-09-17 15:11 | 2026-09-17 15:11 | 2026-09-17 15:11 | ICE | ICE261120C00160000 | call | 160.0000 | 2026-11-20 | 4.5000 | 4.5000 | 4.7000 | 153.5600 | 68400.00 | 0.00 | 68400.00 | 152 | 29 | 153 | 0 | 0 | 0.261451406619153 | 0.261451406619153 | false | false | false | true | false | |||||||||||||||
| dab3a389-c682-456d-b414-2af213445690 | 2026-09-21 12:28 | 2026-09-21 12:28 | 2026-09-21 12:28 | ICE | ICE261016P00155000 | put | 155.0000 | 2026-10-16 | 3.6000 | 3.4000 | 3.6000 | 155.3100 | 110880.00 | 110880.00 | 0.00 | 308 | 49 | 316 | 205 | 1.54146341463415 | 0.244500121195321 | 0.244500121195321 | false | false | false | true | false | |||||||||||||||
| 42c1bfe4-157b-466e-be7e-6d4bbd22c0b7 | 2026-09-22 10:41 | 2026-09-22 10:41 | 2026-09-22 10:41 | ICE | ICE270115C00170000 | call | 170.0000 | 2027-01-15 | 3.8000 | 3.7000 | 3.8000 | 153.5800 | 21280.00 | 21280.00 | 0.00 | 56 | 24 | 56 | 412 | 0.135922330097087 | 0.255992794855398 | 0.255992794855398 | false | false | false | true | false | |||||||||||||||
| c7fec65e-f039-467e-a8a0-50bb266928bd | 2026-09-22 11:28 | 2026-09-22 11:28 | 2026-09-22 11:28 | ICE | ICE280121C00200000 | call | 200.0000 | 2028-01-21 | 8.0000 | 8.0000 | 8.9000 | 152.0000 | 12800.00 | 0.00 | 12800.00 | 16 | 5 | 16 | 69 | 0.231884057971014 | 0.270029096070257 | 0.270029096070257 | false | false | false | true | false | |||||||||||||||
| af1c787e-92cf-4a4f-8fad-cc13f3f774c1 | 2026-09-22 14:28 | 2026-09-22 14:28 | 2026-09-22 14:28 | ICE | ICE270115P00140000 | put | 140.0000 | 2027-01-15 | 3.3000 | 3.2000 | 3.4000 | 153.2886 | 23760.00 | 23430.00 | 0.00 | 72 | 11 | 75 | 251 | 0.298804780876494 | 0.273254204657494 | 0.273254204657494 | false | false | false | true | false | |||||||||||||||
| 7486dfce-31cb-4daf-b682-3e522cc409d9 | 2026-09-23 10:46 | 2026-09-23 10:46 | 2026-09-23 10:46 | ICE | ICE261218C00170000 | call | 170.0000 | 2026-12-18 | 3.8000 | 3.7000 | 3.9000 | 157.2150 | 85880.00 | 85120.00 | 0.00 | 226 | 19 | 227 | 335 | 0.677611940298507 | 0.260060764729634 | 0.260060764729634 | false | false | false | true | false | |||||||||||||||
| d47f2ad4-166c-4a07-94d2-2469ae2bf587 | 2026-09-23 14:00 | 2026-09-23 14:00 | 2026-09-23 14:00 | ICE | ICE261120C00165000 | call | 165.0000 | 2026-11-20 | 3.9000 | 3.6000 | 3.9000 | 156.7650 | 83459.00 | 83459.00 | 0.00 | 214 | 39 | 224 | 23 | 9.73913043478261 | 0.270726759887257 | 0.270726759887257 | false | false | false | true | false | |||||||||||||||
| 488aa0ed-d4fc-4e95-9213-16ba563a5b5f | 2026-09-23 14:00 | 2026-09-23 14:00 | 2026-09-23 14:00 | ICE | ICE261120C00170000 | call | 170.0000 | 2026-11-20 | 2.5500 | 2.3000 | 2.5500 | 156.7650 | 36463.00 | 36463.00 | 0.00 | 143 | 23 | 148 | 3 | 49.3333333333333 | 0.270911671356569 | 0.270911671356569 | false | false | false | true | false | |||||||||||||||
| 0989190c-50fe-4a8a-8365-ce7fb1fa058c | 2026-09-24 11:08 | 2026-09-24 11:08 | 2026-09-24 11:08 | ICE | ICE270617P00125000 | put | 125.0000 | 2027-06-17 | 3.7600 | 1.6500 | 4.0000 | 155.0000 | 18816.00 | 18816.00 | 0.00 | 50 | 8 | 50 | 16 | 3.125 | 0.310862411362337 | 0.328629435567153 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 88559980324.00 |
| 2026-10-29 |
| 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 |
| Financial Services |
| 88559980324.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 88559980324.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:00:40.665909Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 88559980324.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:39:59.140702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 88559980324.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:08:52.274087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 88559980324.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T19:21:20.162349Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 88559980324.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Financial Services |
| 88559980324.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Financial Services |
| 88559980324.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Financial Services |
| 88559980324.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Financial Services |
| 88559980324.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Financial Services |
| 88559980324.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 86061774857.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T16:22:15.429007Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 86061774857.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:28:01.580099Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 87223861445.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:29:13.911862Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 85854058897.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:42:44.065275Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 85854058897.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:29:11.777432Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 85854058897.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:29:55.439380Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 87774028042.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:47:19.358930Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 87774028042.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:04:42.135923Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 87774028042.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:04:42.135923Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 87774028042.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:12:31.706500Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |