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.
Simplify Analyticsuw_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 | 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 |
|---|
| 521b96ee-134a-4412-8273-b35ef2bda018 | 2026-08-18 12:45 | 2026-08-18 12:45 | 2026-08-18 12:45 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 1.7700 | 1.7100 | 1.8300 | 89.6100 | 154043.00 | 49410.00 | 95403.00 | 868 | 39 | 883 | 4669 | 0.18911972585136 | 0.439675457499325 | 0.437361756365051 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 52.34 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1a6d2b18-bbc3-49a0-a6e6-6968d315a2b4 | 2026-08-18 12:46 | 2026-08-18 12:46 | 2026-08-18 12:46 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 1.7400 | 1.7200 | 1.7800 | 89.5500 | 72906.00 | 70470.00 | 2436.00 | 419 | 6 | 1503 | 4669 | 0.321910473334761 | 0.43574928389303 | 0.43574928389303 | true | false | false | true | ||||||||||||||||
| 52222955-b30f-47ed-b0d9-f6c44af96e8a | 2026-08-18 12:46 | 2026-08-18 12:46 | 2026-08-18 12:46 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 1.7500 | 1.7300 | 1.7900 | 89.5900 | 28875.00 | 2800.00 | 21700.00 | 165 | 9 | 1764 | 4669 | 0.377811094452774 | 0.435666220604868 | 0.435666220604868 | false | false | false | true | ||||||||||||||||
| 27567c8f-669f-4af2-b2b5-77e5f651a0f8 | 2026-08-18 12:47 | 2026-08-18 12:46 | 2026-08-18 12:46 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 1.7500 | 1.7400 | 1.7900 | 89.6150 | 20650.00 | 6300.00 | 12950.00 | 118 | 10 | 1935 | 4669 | 0.414435639323196 | 0.434886532812925 | 0.434886532812925 | true | false | false | true | ||||||||||||||||
| 44ef628d-3643-470c-a52d-384ddac06681 | 2026-08-18 15:26 | 2026-08-18 15:26 | 2026-08-18 15:26 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 1.7100 | 1.6800 | 1.7400 | 89.6000 | 83619.00 | 3249.00 | 68058.00 | 489 | 18 | 2525 | 4669 | 0.5408010280574 | 0.430697119173702 | 0.430697119173702 | false | false | false | true | ||||||||||||||||
| 6c5ce8db-52c3-439b-b39c-7560496f5da8 | 2026-08-18 15:27 | 2026-08-18 15:27 | 2026-08-18 15:27 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 1.6900 | 1.6600 | 1.6900 | 89.5900 | 14703.00 | 7774.00 | 0.00 | 87 | 6 | 3265 | 4669 | 0.699293210537588 | 0.428669199898809 | 0.428669199898809 | false | false | false | true | ||||||||||||||||
| 67d3b82e-b3f0-4324-ad4f-2fd0b50672cb | 2026-08-18 15:27 | 2026-08-18 15:27 | 2026-08-18 15:27 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 1.6900 | 1.6800 | 1.7600 | 89.5875 | 62361.00 | 51038.00 | 11323.00 | 369 | 12 | 3634 | 4669 | 0.778325123152709 | 0.428746583774113 | 0.428746583774113 | false | false | false | true | ||||||||||||||||
| 35fbf90a-cb3c-4a90-b11b-285a2fde494e | 2026-08-18 15:27 | 2026-08-18 15:27 | 2026-08-18 15:27 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 1.6900 | 1.6900 | 1.7000 | 89.5875 | 80106.00 | 0.00 | 80106.00 | 474 | 12 | 4108 | 4669 | 0.879845791390019 | 0.428746583774113 | 0.428746583774113 | false | false | false | true | ||||||||||||||||
| 2fb1f188-4e1e-46a2-b18e-c231336352c6 | 2026-08-25 13:03 | 2026-08-25 13:03 | 2026-08-25 13:03 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 9.3000 | 9.2500 | 9.4500 | 104.7300 | 2744450.00 | 0.00 | 2692370.00 | 2951 | 49 | 2961 | 3418 | 0.866296079578701 | 0.489844133273672 | 0.489844133273672 | false | false | false | true | ||||||||||||||||
| 7866ef89-f5b3-42f7-bc01-054520e0f59c | 2026-08-31 09:31 | 2026-08-31 09:31 | 2026-08-31 09:31 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 4.8100 | 4.8000 | 5.3000 | 99.2000 | 80262.00 | 0.00 | 80262.00 | 167 | 18 | 167 | 5964 | 0.0280013413816231 | 0.466561418203053 | 0.466561418203053 | true | false | false | true | ||||||||||||||||
| 23c37778-09ea-41e2-9b6f-99f642aeea87 | 2026-08-31 12:10 | 2026-08-31 12:10 | 2026-08-31 12:10 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 3.8000 | 3.8000 | 3.8500 | 97.9250 | 11780.00 | 0.00 | 11780.00 | 31 | 7 | 249 | 5964 | 0.0417505030181087 | 0.432032284175978 | 0.432032284175978 | true | false | false | true | ||||||||||||||||
| 4cf90cc8-10ae-411c-a8b7-73bc2fd9f176 | 2026-09-02 15:34 | 2026-09-02 15:34 | 2026-09-02 15:34 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 3.3000 | 3.2500 | 3.3000 | 97.1500 | 165000.00 | 165000.00 | 0.00 | 500 | 8 | 1762 | 6727 | 0.26192953768396 | 0.446194185470188 | 0.446194185470188 | false | false | false | true | ||||||||||||||||
| 409e4ac5-70dc-4ad1-bb9c-f78a4d6ceb46 | 2026-09-09 11:13 | 2026-09-09 11:13 | 2026-09-09 11:13 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 3.7000 | 3.5000 | 3.8000 | 99.0100 | 185000.00 | 18500.00 | 166500.00 | 500 | 17 | 540 | 6254 | 0.0863447393668052 | 0.505662464129659 | 0.505662464129659 | true | false | false | true | ||||||||||||||||
| 135e8395-a643-4ebf-8cb7-87db09622cb5 | 2026-09-09 11:22 | 2026-09-09 11:22 | 2026-09-09 11:22 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 3.6500 | 3.5000 | 3.7500 | 98.9700 | 212065.00 | 47815.00 | 164250.00 | 581 | 7 | 1126 | 6254 | 0.180044771346338 | 0.501211347748426 | 0.501211347748426 | false | false | false | true | ||||||||||||||||
| 85513ae6-9181-42fd-928c-3a546275e20c | 2026-09-09 12:08 | 2026-09-09 12:08 | 2026-09-09 12:08 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 4.1100 | 4.0000 | 4.2000 | 99.8350 | 205639.00 | 205639.00 | 0.00 | 500 | 6 | 1762 | 6254 | 0.281739686600576 | 0.495921391894007 | 0.495921391894007 | false | false | false | true | ||||||||||||||||
| 0c55af18-68ce-47dc-bf51-923265ce696e | 2026-09-10 11:52 | 2026-09-10 11:52 | 2026-09-10 11:52 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 2.3000 | 2.1700 | 2.4000 | 96.8900 | 27600.00 | 3680.00 | 23920.00 | 120 | 6 | 199 | 6134 | 0.0324421258558852 | 0.484075859029283 | 0.484075859029283 | false | false | false | true | ||||||||||||||||
| 1a9559f9-d939-442d-b45c-2d448626e473 | 2026-09-14 11:15 | 2026-09-14 11:15 | 2026-09-14 11:15 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 0.6800 | 0.6700 | 0.7200 | 93.6400 | 82552.00 | 20468.00 | 62084.00 | 1214 | 18 | 1903 | 6610 | 0.287897125567322 | 0.549026242666356 | 0.549026242666356 | false | false | false | true | ||||||||||||||||
| 5549a8ec-492d-4290-a92e-f08f1fca6221 | 2026-09-16 10:11 | 2026-09-16 10:11 | 2026-09-16 10:11 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 0.5800 | 0.5400 | 0.5800 | 94.4150 | 24476.00 | 24476.00 | 0.00 | 422 | 17 | 566 | 7602 | 0.0744540910286767 | 0.647089938403978 | 0.647089938403978 | true | false | false | true | ||||||||||||||||
| 3b4518ee-3cf7-4f9b-b61d-b9b63f6b5bd2 | 2026-09-17 09:54 | 2026-09-17 09:54 | 2026-09-17 09:54 | GDX | GDX260918C00098000 | call | 98.0000 | 2026-09-18 | 0.4300 | 0.3800 | 0.4300 | 95.7300 | 13760.00 | 13760.00 | 0.00 | 320 | 6 | 347 | 7846 | 0.0442263573795565 | 0.616849198765484 | 0.616849198765484 | true | 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-08-18T16:50:14.134420Z"} |
| 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-18T16:50:14.134420Z"} |
| 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-18T16:50:14.134420Z"} |
| 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-18T19:46:05.553268Z"} |
| 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-18T19:46:05.553268Z"} |
| 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-18T19:46:05.553268Z"} |
| 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-18T19:46:05.553268Z"} |
| 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-25T17:31:01.749779Z"} |
| 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-31T13:35:53.678596Z"} |
| 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-31T16:39:59.140702Z"} |
| 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-02T19:37:03.508091Z"} |
| 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-09T15:13:56.572588Z"} |
| 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-09T15:29:26.424015Z"} |
| 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-09-09T16:21:26.040266Z"} |
| 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-14T15:20:09.779343Z"} |
| 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-16T14:14:36.942021Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 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-17T13:57:31.198579Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |