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_alerts658,639 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 | expiry |
|---|
| 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 |
|---|
| 481d5fe3-e2d5-48fb-8e0d-ad0efa03be2d | 2026-09-28 10:03 | 2026-09-28 10:03 | 2026-09-28 10:03 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 6.1500 | 6.1500 | 6.5000 | 89.1800 | 731321.00 | 0.00 | 731321.00 | 1189 | 35 | 1206 | 3933 | 0.306636155606407 | 0.414514257699922 | 0.414514257699922 | 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-28T14:05:57.750889Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 06757171-300f-4da8-a932-a8c20f4303b0 | 2026-09-23 14:03 | 2026-09-23 14:03 | 2026-09-23 14:03 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 8.6500 | 8.6500 | 9.0000 | 94.1550 | 21625.00 | 0.00 | 21625.00 | 25 | 8 | 317 | 3819 | 0.083006022518984 | 0.403936015409874 | 0.403936015409874 | false | false | false | true | ||||||||||||||||
| 5764617c-f05d-4c0b-b43a-9ba41e2c8766 | 2026-09-23 10:19 | 2026-09-23 10:19 | 2026-09-23 10:19 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 8.3000 | 8.0500 | 8.6000 | 93.0000 | 83000.00 | 830.00 | 6640.00 | 100 | 19 | 259 | 3819 | 0.0678188007331762 | 0.410297257408504 | 0.410297257408504 | false | false | false | true | ||||||||||||||||
| 627d0f83-c822-4dc9-b626-b6022ddaf4dd | 2026-09-23 10:14 | 2026-09-23 10:14 | 2026-09-23 10:14 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 8.5000 | 8.3000 | 8.5000 | 93.5000 | 42500.00 | 42500.00 | 0.00 | 50 | 19 | 159 | 3819 | 0.0416339355852317 | 0.413964225557613 | 0.413964225557613 | false | false | false | true | ||||||||||||||||
| d1f7ee08-77c6-4375-b30d-f2aaba412ed0 | 2026-09-23 10:09 | 2026-09-23 10:09 | 2026-09-23 10:09 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 8.6000 | 8.4500 | 8.6000 | 93.6500 | 34400.00 | 34400.00 | 0.00 | 40 | 16 | 98 | 3819 | 0.0256611678449856 | 0.414858577661099 | 0.414858577661099 | false | false | false | true | ||||||||||||||||
| 8511ea9b-e322-4a17-b012-708764152aff | 2026-09-22 14:13 | 2026-09-22 14:12 | 2026-09-22 14:12 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 10.6500 | 10.4000 | 10.7500 | 97.3000 | 71355.00 | 5325.00 | 66030.00 | 67 | 17 | 256 | 3800 | 0.0673684210526316 | 0.41009952512122 | 0.41009952512122 | false | false | false | true | ||||||||||||||||
| 47a55726-d6d2-43e4-9652-6827050f189b | 2026-09-21 10:45 | 2026-09-21 10:45 | 2026-09-21 10:45 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 8.7000 | 8.7000 | 9.0000 | 94.0800 | 87000.00 | 0.00 | 87000.00 | 100 | 8 | 125 | 3774 | 0.0331213566507684 | 0.404444438275666 | 0.404444438275666 | true | false | false | true | ||||||||||||||||
| 8a832419-1f65-4773-be24-7184424e9888 | 2026-09-18 09:50 | 2026-09-18 09:50 | 2026-09-18 09:50 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 10.0000 | 9.8500 | 10.0500 | 95.2900 | 100000.00 | 15000.00 | 14000.00 | 100 | 19 | 104 | 3715 | 0.0279946164199192 | 0.427666830854731 | 0.427666830854731 | false | false | false | true | ||||||||||||||||
| e84742e9-c6a2-4e64-b3cd-7ebf37e45656 | 2026-09-17 13:16 | 2026-09-17 13:15 | 2026-09-17 13:15 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 10.3500 | 10.3500 | 10.4500 | 95.8150 | 103500.00 | 0.00 | 32085.00 | 100 | 18 | 148 | 3700 | 0.04 | 0.431665847187194 | 0.431665847187194 | false | false | false | true | ||||||||||||||||
| 883fbbfd-95ad-46b5-94f0-95659a234831 | 2026-09-10 14:15 | 2026-09-10 14:15 | 2026-09-10 14:15 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 11.2500 | 11.2000 | 11.2500 | 96.3300 | 56250.00 | 21375.00 | 0.00 | 50 | 19 | 210 | 3518 | 0.0596930073905628 | 0.445662992863035 | 0.445662992863035 | false | false | false | true | ||||||||||||||||
| e43f467e-271b-45c3-837d-1ed3de1497a2 | 2026-09-10 12:01 | 2026-09-10 12:01 | 2026-09-10 12:01 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 11.5500 | 11.4000 | 11.9500 | 96.9400 | 24255.00 | 23100.00 | 1155.00 | 21 | 18 | 151 | 3518 | 0.0429221148379761 | 0.442771958154891 | 0.442771958154891 | false | false | false | true | ||||||||||||||||
| 6af19fbd-9440-477e-b3fc-3484eafdaf97 | 2026-09-10 11:59 | 2026-09-10 11:59 | 2026-09-10 11:59 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 11.5500 | 11.4000 | 11.5500 | 96.8100 | 33495.00 | 4620.00 | 0.00 | 29 | 8 | 130 | 3518 | 0.0369528140989198 | 0.44630569894188 | 0.44630569894188 | false | false | false | true | ||||||||||||||||
| 0cd510f1-febe-4f26-aeee-2a7aaecd68de | 2026-09-10 11:10 | 2026-09-10 11:10 | 2026-09-10 11:10 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 11.6000 | 11.4000 | 11.8000 | 96.9350 | 116000.00 | 8120.00 | 5800.00 | 100 | 18 | 101 | 3518 | 0.0287094940306993 | 0.44517295394606 | 0.44517295394606 | false | false | false | true | ||||||||||||||||
| 48248364-628b-402b-be42-782016361489 | 2026-09-03 11:24 | 2026-09-03 11:24 | 2026-09-03 11:24 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 14.6000 | 14.6000 | 14.7000 | 101.1950 | 119720.00 | 0.00 | 1460.00 | 82 | 15 | 137 | 3450 | 0.0397101449275362 | 0.442075200080698 | 0.442075200080698 | false | false | false | true | ||||||||||||||||
| c7ea56a0-c693-4dfb-b807-bb058783dbf4 | 2026-09-03 11:19 | 2026-09-03 11:19 | 2026-09-03 11:19 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 14.5000 | 14.2000 | 14.6500 | 101.0500 | 49300.00 | 4350.00 | 1450.00 | 34 | 19 | 55 | 3450 | 0.0159420289855072 | 0.441905400358783 | 0.441905400358783 | false | false | false | true | ||||||||||||||||
| bdbe965c-fb5c-4736-9e49-7782cdd142da | 2026-09-03 11:18 | 2026-09-03 11:18 | 2026-09-03 11:18 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 14.3500 | 14.3500 | 14.4500 | 100.9050 | 18655.00 | 0.00 | 4305.00 | 13 | 6 | 21 | 3450 | 0.00608695652173913 | 0.439489482958621 | 0.439489482958621 | false | false | false | true | ||||||||||||||||
| 09d6e95d-0d4d-4dfb-90b4-87b54c5941cd | 2026-09-01 14:20 | 2026-09-01 14:20 | 2026-09-01 14:20 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 11.2000 | 11.2000 | 11.2500 | 95.8200 | 19040.00 | 0.00 | 19040.00 | 17 | 17 | 107 | 3446 | 0.0310504933255949 | 0.437066103145344 | 0.437066103145344 | false | false | false | true | ||||||||||||||||
| 8ddc3a61-2c21-42ad-9a75-94ca17fa7974 | 2026-09-01 14:18 | 2026-09-01 14:18 | 2026-09-01 14:18 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 11.2000 | 11.0000 | 11.2500 | 95.8500 | 22400.00 | 2240.00 | 3360.00 | 20 | 18 | 87 | 3446 | 0.0252466627974463 | 0.436291673549482 | 0.436291673549482 | false | false | false | true | ||||||||||||||||
| 8faae020-ea41-4f06-9a9f-664320ab523f | 2026-09-01 12:23 | 2026-09-01 12:23 | 2026-09-01 12:23 | GDX | GDX270115C00095000 | call | 95.0000 | 2027-01-15 | 11.5000 | 11.5000 | 11.6500 | 96.2100 | 11500.00 | 0.00 | 3450.00 | 10 | 10 | 52 | 3446 | 0.0150899593731863 | 0.440124974746692 | 0.440124974746692 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| 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 |
| 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-23T14:19:47.877581Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:16:29.786516Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:10:43.742349Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:18:27.911867Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:47:49.730853Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:50:28.178058Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:37:18.479310Z"} |
| 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-09-10T16:13:08.333814Z"} |
| 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-09-10T16:13:08.333814Z"} |
| 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-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 |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:27:44.291947Z"} |
| 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-09-03T15:27:44.291947Z"} |
| 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-09-03T15:27:44.291947Z"} |
| 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-09-01T18:40:09.958238Z"} |
| 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-09-01T18:40:09.958238Z"} |
| 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-09-01T16:27:11.873526Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |