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_alerts566,287 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 | strike |
|---|
| 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 |
|---|
| cd16d412-8144-4244-b0e8-c342a89e277a | 2026-09-24 12:16 | 2026-09-24 12:16 | 2026-09-24 12:16 | COPX | COPX261120C00090000 | call | 90.0000 | 2026-11-20 | 4.3500 | 4.0000 | 4.9000 | 86.0000 | 27856.00 | 5220.00 | 17416.00 | 64 | 8 | 75 | 137 | 0.547445255474453 | 0.427616736904806 | 0.423888279414048 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 2256686669.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T16:16:49.777231Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| efe007b3-b2ed-4358-8810-6f2cd339e865 | 2026-09-23 09:58 | 2026-09-23 09:58 | 2026-09-23 09:58 | COPX | COPX270917P00075000 | put | 75.0000 | 2027-09-17 | 7.4900 | 7.4000 | 9.9000 | 86.4300 | 158880.00 | 111750.00 | 47130.00 | 212 | 9 | 212 | 900 | 0.235555555555556 | 0.438469143925439 | 0.438469143925439 | false | false | ||||||||||||||||||
| fbd5e965-c2ef-447d-8db4-c28f595110a5 | 2026-09-15 13:21 | 2026-09-15 13:21 | 2026-09-15 13:21 | COPX | COPX261016P00074000 | put | 74.0000 | 2026-10-16 | 0.8100 | 0.8000 | 0.9000 | 84.1616 | 40504.00 | 0.00 | 40504.00 | 500 | 12 | 525 | 104 | 5.04807692307692 | 0.446813452728298 | 0.446813452728298 | false | false | ||||||||||||||||||
| 071f720f-07d8-431f-ba93-f9a9a0ddcd1c | 2026-09-14 14:34 | 2026-09-14 14:33 | 2026-09-14 14:33 | COPX | COPX260925C00090000 | call | 90.0000 | 2026-09-25 | 1.2500 | 1.2500 | 1.3500 | 86.0200 | 12379.00 | 0.00 | 12379.00 | 99 | 5 | 211 | 27 | 7.81481481481481 | 0.456173980470959 | 0.456173980470959 | false | false | ||||||||||||||||||
| d3ebc28a-5fdd-41aa-beea-ea332ed60d56 | 2026-09-14 14:33 | 2026-09-14 14:33 | 2026-09-14 14:33 | COPX | COPX260925C00090000 | call | 90.0000 | 2026-09-25 | 1.2500 | 1.2500 | 1.3500 | 86.0200 | 11258.00 | 0.00 | 11258.00 | 90 | 5 | 111 | 27 | 4.11111111111111 | 0.456173980470959 | 0.456173980470959 | false | false | ||||||||||||||||||
| 9b1f9ebc-e2e8-46b6-9a87-f9fa0ce56ef1 | 2026-09-11 11:50 | 2026-09-11 11:50 | 2026-09-11 11:50 | COPX | COPX270115C00090000 | call | 90.0000 | 2027-01-15 | 9.5000 | 9.0000 | 9.8000 | 89.1500 | 18999.00 | 18999.00 | 0.00 | 20 | 5 | 23 | 5113 | 0.00449833757089771 | 0.451207992981976 | 0.451207992981976 | false | false | ||||||||||||||||||
| 996be973-005f-42ec-91ca-167cd97378c5 | 2026-09-09 09:55 | 2026-09-09 09:55 | 2026-09-09 09:55 | COPX | COPX260911C00095000 | call | 95.0000 | 2026-09-11 | 1.8100 | 1.6000 | 2.0500 | 95.0300 | 18130.00 | 4305.00 | 13825.00 | 100 | 7 | 106 | 1378 | 0.0769230769230769 | 0.72185245264066 | 0.614884541095704 | false | false | ||||||||||||||||||
| 74af4287-ac34-4da9-a54c-f30478d7d54f | 2026-09-08 11:14 | 2026-09-08 11:14 | 2026-09-08 11:14 | COPX | COPX280121C00120000 | call | 120.0000 | 2028-01-21 | 15.7000 | 12.6000 | 15.8000 | 95.6925 | 10990.00 | 9430.00 | 1560.00 | 7 | 6 | 8 | 1103 | 0.00725294650951949 | 0.489050138357722 | 0.486812028547477 | false | false | ||||||||||||||||||
| 937f147b-80ee-462d-85a4-03f4f1760614 | 2026-09-04 09:58 | 2026-09-04 09:58 | 2026-09-04 09:58 | COPX | COPX261016P00088000 | put | 88.0000 | 2026-10-16 | 3.9100 | 3.8000 | 4.0000 | 90.4200 | 34432.00 | 34432.00 | 0.00 | 88 | 6 | 94 | 44 | 2.13636363636364 | 0.432677117870165 | 0.432677117870165 | false | false | ||||||||||||||||||
| 6659f67a-e25a-48dd-8cbf-3aafb9fb84cd | 2026-09-03 11:42 | 2026-09-03 11:42 | 2026-09-03 11:42 | COPX | COPX261218C00095000 | call | 95.0000 | 2026-12-18 | 7.8500 | 7.6000 | 8.1000 | 91.1868 | 19623.00 | 8655.00 | 9398.00 | 25 | 6 | 49 | 146 | 0.335616438356164 | 0.461703113970006 | 0.461703113970006 | false | false | ||||||||||||||||||
| 3a8dc3aa-0215-4b3f-8d65-b91be0cb793a | 2026-09-03 10:40 | 2026-09-03 10:40 | 2026-09-03 10:40 | COPX | COPX261016P00090000 | put | 90.0000 | 2026-10-16 | 4.8300 | 4.8000 | 5.0000 | 90.6000 | 24164.00 | 0.00 | 24164.00 | 50 | 8 | 101 | 776 | 0.130154639175258 | 0.433304035159534 | 0.433304035159534 | false | false | ||||||||||||||||||
| 06084d19-6898-4a76-b999-3a5bb000d9f7 | 2026-08-26 15:36 | 2026-08-26 15:36 | 2026-08-26 15:36 | COPX | COPX261120P00070000 | put | 70.0000 | 2026-11-20 | 1.0000 | 0.9000 | 1.0000 | 95.7150 | 95680.00 | 95680.00 | 0.00 | 957 | 44 | 961 | 5 | 192.2 | 0.522780374365174 | 0.522780374365174 | false | false | ||||||||||||||||||
| 5df42bfe-a481-48a0-9749-50c932c65633 | 2026-08-26 15:00 | 2026-08-26 15:00 | 2026-08-26 15:00 | COPX | COPX270617C00095000 | call | 95.0000 | 2027-06-17 | 17.7000 | 15.7000 | 17.8000 | 95.6700 | 83168.00 | 47768.00 | 35400.00 | 47 | 14 | 88 | 171 | 0.514619883040936 | 0.472588720979641 | 0.466483351483613 | true | false | ||||||||||||||||||
| 8d02001c-e2e4-4dec-9bfd-7181f2ded7b5 | 2026-08-25 15:25 | 2026-08-25 15:25 | 2026-08-25 15:25 | COPX | COPX261218C00110000 | call | 110.0000 | 2026-12-18 | 6.0000 | 5.4000 | 6.0000 | 96.2100 | 374379.00 | 374379.00 | 0.00 | 624 | 46 | 690 | 40 | 17.25 | 0.487884779326933 | 0.487515757414406 | false | false | ||||||||||||||||||
| 5e1dda63-86b5-4407-8490-8b21ff28f969 | 2026-08-21 11:22 | 2026-08-21 11:22 | 2026-08-21 11:22 | COPX | COPX280121C00145000 | call | 145.0000 | 2028-01-21 | 9.5000 | 7.5000 | 10.6000 | 93.1800 | 13302.00 | 11401.00 | 1901.00 | 14 | 11 | 32 | 537 | 0.0595903165735568 | 0.480514664876563 | 0.480271700940202 | false | false | ||||||||||||||||||
| fe3e795e-32aa-4acc-9a84-a81850d210e7 | 2026-08-21 11:18 | 2026-08-21 11:18 | 2026-08-21 11:18 | COPX | COPX261016C00100000 | call | 100.0000 | 2026-10-16 | 4.7000 | 4.5000 | 4.7000 | 93.2150 | 652802.00 | 652802.00 | 0.00 | 1389 | 64 | 1516 | 2233 | 0.678907299596955 | 0.492057296183679 | 0.492057296183679 | false | false | ||||||||||||||||||
| 66f9d6a7-72ed-48eb-a736-7fe80e85cd23 | 2026-08-21 10:36 | 2026-08-21 10:36 | 2026-08-21 10:36 | COPX | COPX270115C00145000 | call | 145.0000 | 2027-01-15 | 1.6000 | 1.5500 | 2.1000 | 93.4550 | 16175.00 | 170.00 | 16005.00 | 101 | 14 | 334 | 4492 | 0.0743544078361532 | 0.509393294287318 | 0.505280491477923 | false | false | ||||||||||||||||||
| 19694fae-1ae7-4a92-9732-374193c01d2b | 2026-08-21 09:43 | 2026-08-21 09:43 | 2026-08-21 09:43 | COPX | COPX260918C00095000 | call | 95.0000 | 2026-09-18 | 4.7000 | 4.6000 | 4.9000 | 94.5800 | 23520.00 | 0.00 | 23520.00 | 50 | 5 | 164 | 4260 | 0.0384976525821596 | 0.457481743016691 | 0.457481743016691 | false | false | ||||||||||||||||||
| 0f66b241-e52f-44d4-ad8f-63dc1d7ec219 | 2026-08-19 09:54 | 2026-08-19 09:54 | 2026-08-19 09:54 | COPX | COPX270115C00095000 | call | 95.0000 | 2027-01-15 | 8.2000 | 7.4000 | 8.2000 | 87.6300 | 196687.00 | 172907.00 | 0.00 | 240 | 16 | 240 | 1580 | 0.151898734177215 | 0.473202183904965 | 0.473202183904965 | false | false | ||||||||||||||||||
| 56c79fba-95c2-4577-8cda-5304db8ee0a1 | 2026-08-19 09:36 | 2026-08-19 09:36 | 2026-08-19 09:36 | COPX | COPX261016P00080000 | put | 80.0000 | 2026-10-16 | 3.1000 | 2.5500 | 3.1000 | 87.5000 | 194660.00 | 194660.00 | 0.00 | 628 | 41 | 628 | 1561 | 0.402306213965407 | 0.475770909100243 | 0.475770909100243 | false | false | ||||||||||||||||||
| 13557bfe-8378-4772-b8e4-873ce3927fb2 | 2026-08-17 15:49 | 2026-08-17 15:49 | 2026-08-17 15:49 | COPX | COPX260821P00085000 | put | 85.0000 | 2026-08-21 | 0.8500 | 0.7000 | 0.8500 | 87.5500 | 33983.00 | 33983.00 | 0.00 | 400 | 52 | 441 | 1845 | 0.239024390243902 | 0.51765717664809 | 0.51765717664809 | true | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:00:44.029710Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T17:45:33.615815Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T18:49:41.095224Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T18:49:41.095224Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:53:19.427541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:57:31.693440Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:26:49.659255Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:57:35.447301Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:41:15.773512Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:11:05.103195Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T19:47:14.629482Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:38:28.521674Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:52:23.943774Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 2256686669.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:59:29.758034Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |