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 |
|---|
| 6ee5cf1c-2bbd-409a-bfc2-a41a06f35409 | 2026-09-23 12:40 | 2026-09-23 12:40 | 2026-09-23 12:40 | GDX | GDX270115C00110000 | call | 110.0000 | 2027-01-15 | 4.0000 | 4.0000 | 4.2000 | 93.0000 | 122000.00 | 0.00 | 122000.00 | 305 | 26 | 456 | 32897 | 0.0138614463324923 | 0.425673054090204 | 0.425841337318343 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 52.34 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T16:43:49.845741Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 93f2828f-0706-4a86-87e0-cd66671d1821 | 2026-09-16 14:13 | 2026-09-16 14:13 | 2026-09-16 14:13 | GDX | GDX270115C00110000 | call | 110.0000 | 2027-01-15 | 4.2500 | 4.2500 | 4.9500 | 93.1700 | 42925.00 | 0.00 | 42925.00 | 101 | 6 | 261 | 32650 | 0.00799387442572741 | 0.438884108158139 | 0.438884108158139 | false | false | false | true | false | |||||||||||||||
| 8024c536-2ae8-4399-85f5-2715e23d87e2 | 2026-09-04 11:21 | 2026-09-04 11:20 | 2026-09-04 11:20 | GDX | GDX270115C00110000 | call | 110.0000 | 2027-01-15 | 7.4000 | 7.3000 | 7.4000 | 100.0400 | 14060.00 | 14060.00 | 0.00 | 19 | 6 | 215 | 31195 | 0.00689213014906235 | 0.443490016510356 | 0.443490016510356 | true | false | false | true | false | |||||||||||||||
| 0d2a3efd-b2f2-4164-a7de-0be3f093c702 | 2026-08-31 09:55 | 2026-08-31 09:55 | 2026-08-31 09:55 | GDX | GDX270115C00110000 | call | 110.0000 | 2027-01-15 | 6.8000 | 6.8000 | 7.0500 | 97.4800 | 27200.00 | 0.00 | 27200.00 | 40 | 5 | 118 | 30775 | 0.00383428107229894 | 0.456004172440259 | 0.456004172440259 | false | false | false | true | false | |||||||||||||||
| 6d1cc290-f7d2-4af5-bc78-bfc323d3714a | 2026-08-27 14:10 | 2026-08-27 14:09 | 2026-08-27 14:09 | GDX | GDX270115C00110000 | call | 110.0000 | 2027-01-15 | 9.8600 | 9.8500 | 10.0500 | 103.5000 | 43404.00 | 0.00 | 43404.00 | 44 | 6 | 15712 | 16092 | 0.976385781754909 | 0.462994157049222 | 0.463773561630763 | false | false | false | true | false | |||||||||||||||
| d6f46911-165c-482e-be97-7da52c0d4c73 | 2026-08-27 14:09 | 2026-08-27 14:08 | 2026-08-27 14:08 | GDX | GDX270115C00110000 | call | 110.0000 | 2027-01-15 | 9.9000 | 9.7500 | 9.9000 | 103.5600 | 200970.00 | 200970.00 | 0.00 | 203 | 8 | 15668 | 16092 | 0.973651503852846 | 0.463786027896343 | 0.463786027896343 | false | false | false | true | false | |||||||||||||||
| 5b534a13-f0ca-4bad-a4fb-9309a4d10aa1 | 2026-08-27 10:20 | 2026-08-27 10:20 | 2026-08-27 10:20 | GDX | GDX270115C00110000 | call | 110.0000 | 2027-01-15 | 10.0000 | 9.6500 | 10.0000 | 103.5700 | 214929.00 | 201994.00 | 12935.00 | 215 | 10 | 347 | 16092 | 0.0215635098185434 | 0.466319163018363 | 0.465540324509355 | false | false | false | true | ||||||||||||||||
| 69322c30-5a92-4635-ac25-d0fb11c29c39 | 2026-08-26 09:58 | 2026-08-26 09:58 | 2026-08-26 09:58 | GDX | GDX270115C00110000 | call | 110.0000 | 2027-01-15 | 10.4000 | 10.1500 | 10.5500 | 103.7500 | 31200.00 | 23920.00 | 6240.00 | 30 | 6 | 33 | 15978 | 0.00206533984228314 | 0.477627944479328 | 0.477627944479328 | false | false | false | true | false | |||||||||||||||
| cd91a4ca-7eed-4f4b-8d62-099ba35903ab | 2026-08-25 11:45 | 2026-08-25 11:45 | 2026-08-25 11:45 | GDX | GDX270115C00110000 | call | 110.0000 | 2027-01-15 | 11.1000 | 10.9000 | 11.2500 | 105.0500 | 24420.00 | 9990.00 | 13320.00 | 22 | 5 | 214 | 15517 | 0.0137913256428433 | 0.47712181185942 | 0.47712181185942 | false | false | false | true | false | |||||||||||||||
| 5949c3f9-c06f-4917-bb6b-ef43e893017e | 2026-08-21 12:51 | 2026-08-21 12:51 | 2026-08-21 12:51 | GDX | GDX270115C00110000 | call | 110.0000 | 2027-01-15 | 10.0000 | 9.9500 | 10.0000 | 103.1700 | 27999.00 | 27999.00 | 0.00 | 28 | 11 | 769 | 16043 | 0.0479336782397307 | 0.464392567384093 | 0.464392567384093 | false | false | false | true | false | |||||||||||||||
| af7e8350-5032-4b0a-9219-e2483cf741fc | 2026-08-21 10:22 | 2026-08-21 10:22 | 2026-08-21 10:22 | GDX | GDX270115C00110000 | call | 110.0000 | 2027-01-15 | 9.6500 | 9.5000 | 9.7000 | 102.7300 | 24125.00 | 24125.00 | 0.00 | 25 | 17 | 251 | 16043 | 0.0156454528454778 | 0.459232537252499 | 0.459232537252499 | false | false | false | true | false | |||||||||||||||
| e0b8a8eb-f4d4-44a3-8754-6554da6e5b01 | 2026-08-21 10:16 | 2026-08-21 10:16 | 2026-08-21 10:16 | GDX | GDX270115C00110000 | call | 110.0000 | 2027-01-15 | 9.6500 | 9.4000 | 9.6500 | 102.6100 | 60795.00 | 46320.00 | 0.00 | 63 | 13 | 223 | 16043 | 0.0139001433647073 | 0.461476574392784 | 0.461476574392784 | false | false | false | true | false | |||||||||||||||
| c7388cca-3856-4cdd-832f-990f91190e33 | 2026-08-20 09:30 | 2026-08-20 09:30 | 2026-08-20 09:30 | GDX | GDX270115C00110000 | call | 110.0000 | 2027-01-15 | 6.5000 | 6.5500 | 6.9000 | 96.6800 | 14950.00 | 0.00 | 14950.00 | 23 | 7 | 55 | 16238 | 0.00338711663998029 | 0.438386645937133 | 0.438386645937133 | false | false | false | true | false | |||||||||||||||
| 9ddfceb2-aacd-4e73-ba3a-ffb5ea19e612 | 2026-08-19 15:31 | 2026-08-19 15:31 | 2026-08-19 15:31 | GDX | GDX270115C00110000 | call | 110.0000 | 2027-01-15 | 6.9000 | 6.7500 | 6.9000 | 96.9550 | 69000.00 | 69000.00 | 0.00 | 100 | 8 | 2157 | 16888 | 0.127723827569872 | 0.44890065223366 | 0.44890065223366 | false | false | false | true | false | |||||||||||||||
| 971f5c35-ea02-4cf8-aead-f51f0b7fc616 | 2026-08-19 11:29 | 2026-08-19 11:29 | 2026-08-19 11:29 | GDX | GDX270115C00110000 | call | 110.0000 | 2027-01-15 | 6.8000 | 6.6000 | 6.9000 | 97.0895 | 36040.00 | 36040.00 | 0.00 | 53 | 5 | 1045 | 16888 | 0.0618782567503553 | 0.442472156829369 | 0.442472156829369 | false | false | false | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:26:46.257544Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:23:10.886670Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:02:22.723941Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |