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_alerts523,327 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 |
|---|
| c9ba1960-2448-423e-bcfe-f5e700fe0032 | 2026-09-22 14:38 | 2026-09-22 14:38 | 2026-09-22 14:38 | GDX | GDX261016C00105000 | call | 105.0000 | 2026-10-16 | 1.6800 | 1.6600 | 1.8000 | 97.0450 | 11592.00 | 0.00 | 11592.00 | 69 | 5 | 4940 | 7472 | 0.661134903640257 | 0.438415046755944 | 0.438415046755944 | 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-22T18:44:24.241276Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 1ce4a4aa-7d54-4f17-b69f-550d8f3b6ca5 | 2026-09-22 14:21 | 2026-09-22 14:21 | 2026-09-22 14:21 | GDX | GDX261016C00105000 | call | 105.0000 | 2026-10-16 | 1.7800 | 1.6800 | 1.8200 | 97.5000 | 401917.00 | 401917.00 | 0.00 | 2258 | 61 | 4737 | 7472 | 0.633966809421842 | 0.435813957967553 | 0.43548162299797 | true | false | false | true | false | |||||||||||||||
| 03a86787-aab4-498c-aeb6-610e3d78de6a | 2026-09-22 14:11 | 2026-09-22 14:11 | 2026-09-22 14:11 | GDX | GDX261016C00105000 | call | 105.0000 | 2026-10-16 | 1.7000 | 1.6000 | 1.7000 | 97.3500 | 290190.00 | 290190.00 | 0.00 | 1707 | 40 | 2383 | 7472 | 0.318923982869379 | 0.432826143159663 | 0.430855873932346 | false | false | false | true | false | |||||||||||||||
| d717b0e7-ff4c-478e-ae2c-c35c16e8fe8b | 2026-09-22 14:09 | 2026-09-22 14:09 | 2026-09-22 14:09 | GDX | GDX261016C00105000 | call | 105.0000 | 2026-10-16 | 1.7200 | 1.6200 | 1.7200 | 97.4400 | 17200.00 | 17200.00 | 0.00 | 100 | 6 | 671 | 7472 | 0.0898019271948608 | 0.430300276372532 | 0.430300276372532 | false | false | false | true | false | |||||||||||||||
| d1907ba9-5939-4eac-bd91-c88e10e345a6 | 2026-09-18 09:51 | 2026-09-18 09:51 | 2026-09-18 09:51 | GDX | GDX261016C00105000 | call | 105.0000 | 2026-10-16 | 1.4900 | 1.4900 | 1.5700 | 95.1300 | 19966.00 | 0.00 | 19966.00 | 134 | 23 | 164 | 7018 | 0.0233684810487318 | 0.4388653402828 | 0.4388653402828 | false | false | false | true | false | |||||||||||||||
| a6731789-4110-4a85-9f37-e8d936957b3c | 2026-08-27 12:15 | 2026-08-27 12:15 | 2026-08-27 12:15 | GDX | GDX261016C00105000 | call | 105.0000 | 2026-10-16 | 6.8500 | 6.8500 | 6.9000 | 103.7000 | 20550.00 | 0.00 | 20550.00 | 30 | 10 | 394 | 2031 | 0.193993106843919 | 0.470490870708973 | 0.470490870708973 | true | false | false | true | false | |||||||||||||||
| 8538d9c5-8209-4cc9-ab10-6e2adfb9a8d8 | 2026-08-27 11:04 | 2026-08-27 11:04 | 2026-08-27 11:04 | GDX | GDX261016C00105000 | call | 105.0000 | 2026-10-16 | 6.8000 | 6.7500 | 6.8500 | 103.4200 | 10200.00 | 0.00 | 6800.00 | 15 | 15 | 162 | 2031 | 0.0797636632200886 | 0.476662928100994 | 0.476662928100994 | true | false | false | true | false | |||||||||||||||
| fd0f2a19-c095-4f73-9ad9-c614e357b1f4 | 2026-08-27 09:36 | 2026-08-27 09:36 | 2026-08-27 09:36 | GDX | GDX261016C00105000 | call | 105.0000 | 2026-10-16 | 6.4500 | 6.3500 | 6.4500 | 102.5544 | 19350.00 | 19350.00 | 0.00 | 30 | 6 | 31 | 2031 | 0.0152634170359429 | 0.482313648273247 | 0.482313648273247 | false | false | false | true | false | |||||||||||||||
| eb40962b-a842-434e-a4ed-ad693f633d5f | 2026-08-20 11:42 | 2026-08-20 11:42 | 2026-08-20 11:42 | GDX | GDX261016C00105000 | call | 105.0000 | 2026-10-16 | 5.3500 | 5.3000 | 5.4000 | 99.3141 | 56710.00 | 50290.00 | 0.00 | 106 | 6 | 1555 | 2706 | 0.574648928307465 | 0.475077674198758 | 0.475077674198758 | false | false | false | true | false | |||||||||||||||
| e9bedc49-c17a-485f-8033-f17b9ae5f4eb | 2026-08-20 11:41 | 2026-08-20 11:41 | 2026-08-20 11:41 | GDX | GDX261016C00105000 | call | 105.0000 | 2026-10-16 | 5.4000 | 5.3500 | 5.4000 | 99.2700 | 25920.00 | 25920.00 | 0.00 | 48 | 13 | 1350 | 2706 | 0.498891352549889 | 0.479834708173938 | 0.479554340228363 | false | false | false | true | false | |||||||||||||||
| 2fa00679-4c60-41b5-8d70-b4b29fa87a91 | 2026-08-20 10:36 | 2026-08-20 10:36 | 2026-08-20 10:36 | GDX | GDX261016C00105000 | call | 105.0000 | 2026-10-16 | 4.8000 | 4.6500 | 4.9000 | 98.5800 | 278280.00 | 33460.00 | 194900.00 | 580 | 7 | 1064 | 2706 | 0.39320029563932 | 0.458047823262923 | 0.460027328565056 | false | false | false | true | false | |||||||||||||||
| a894c5e5-dd2c-4e1e-a533-9be969c4a269 | 2026-08-19 10:49 | 2026-08-19 10:49 | 2026-08-19 10:49 | GDX | GDX261016C00105000 | call | 105.0000 | 2026-10-16 | 4.0000 | 4.0000 | 4.2500 | 96.3850 | 59200.00 | 0.00 | 59200.00 | 148 | 5 | 1225 | 1765 | 0.694050991501416 | 0.458645483894208 | 0.458645483894208 | true | false | false | true | false | |||||||||||||||
| 89b7da30-840a-4ee0-b3f4-50fb78f179fb | 2026-08-19 09:31 | 2026-08-19 09:31 | 2026-08-19 09:31 | GDX | GDX261016C00105000 | call | 105.0000 | 2026-10-16 | 3.2000 | 3.1000 | 3.4000 | 94.6500 | 96000.00 | 81600.00 | 14400.00 | 300 | 6 | 302 | 1765 | 0.171104815864023 | 0.444092693525352 | 0.444092693525352 | false | false | false | true | false | |||||||||||||||
| ed335c55-23ff-4fdf-a4f9-57d758aa5544 | 2026-08-17 09:50 | 2026-08-17 09:50 | 2026-08-17 09:50 | GDX | GDX261016C00105000 | call | 105.0000 | 2026-10-16 | 2.3100 | 2.2300 | 2.4100 | 91.3700 | 14553.00 | 14322.00 | 231.00 | 63 | 14 | 1585 | 1864 | 0.850321888412017 | 0.440666217708971 | 0.440666217708971 | false | false | false | true | false | |||||||||||||||
| 19c23b07-54d6-44c9-bb65-4e9c0a558b0f | 2026-08-17 09:36 | 2026-08-17 09:36 | 2026-08-17 09:36 | GDX | GDX261016C00105000 | call | 105.0000 | 2026-10-16 | 2.0800 | 2.0700 | 2.2900 | 90.3300 | 24492.00 | 13728.00 | 10764.00 | 118 | 11 | 1504 | 1864 | 0.8068669527897 | 0.44210890974895 | 0.44210890974895 | false | false | false | true | false | |||||||||||||||
| 79599389-c66f-4198-bd05-9c654fab37e4 | 2026-08-17 09:35 | 2026-08-17 09:35 | 2026-08-17 09:35 | GDX | GDX261016C00105000 | call | 105.0000 | 2026-10-16 | 2.1300 | 2.1300 | 2.2900 | 90.5300 | 46284.00 | 13482.00 | 32802.00 | 217 | 9 | 1277 | 1864 | 0.685085836909871 | 0.443170744311617 | 0.443170744311617 | 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-22T18:23:27.944500Z"} |
| 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-22T18:18:27.911867Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T18:10:48.215993Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:30:57.923324Z"} |
| 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-27T15:06:04.251678Z"} |
| 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-27T13:38:22.111482Z"} |
| 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-20T15:52:12.298393Z"} |
| 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-20T15:52:12.298393Z"} |
| 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-20T14:48:30.894899Z"} |
| 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-19T14:50:22.027850Z"} |
| 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-19T13:32:56.078945Z"} |
| 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-17T13:54:20.333138Z"} |
| 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-17T13:42:20.529509Z"} |
| 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-17T13:42:20.529509Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |