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_alerts474,253 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 |
|---|
| 3f15e857-bb27-49dd-bd4d-cf07d26f5779 | 2026-09-24 10:40 | 2026-09-24 10:40 | 2026-09-24 10:40 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 2.8000 | 2.6600 | 2.8000 | 91.5100 | 56280.00 | 56280.00 | 0.00 | 201 | 33 | 504 | 10150 | 0.0496551724137931 | 0.405368943130939 | 0.405368943130939 | true | 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-24T14:44:10.025245Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| 8ecead2e-e21a-48c4-addc-c458372f7a3e | 2026-09-22 13:54 | 2026-09-22 13:54 | 2026-09-22 13:54 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 1.3600 | 1.3300 | 1.4000 | 96.7050 | 29240.00 | 7616.00 | 21624.00 | 215 | 6 | 671 | 9583 | 0.0700198267765835 | 0.407420597770551 | 0.407420597770551 | false | false | false | true | false | |||||||||||||||
| 16769648-77f8-4502-b1b7-a4054b7f91a0 | 2026-09-18 13:36 | 2026-09-18 13:36 | 2026-09-18 13:36 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 1.9700 | 1.9500 | 1.9700 | 95.6750 | 10047.00 | 10047.00 | 0.00 | 51 | 5 | 1268 | 9796 | 0.1294405879951 | 0.420817998560282 | 0.420817998560282 | false | false | false | true | false | |||||||||||||||
| fa4fcb37-c1f8-4e66-b9f5-a7367ef09f7c | 2026-09-18 12:01 | 2026-09-18 12:01 | 2026-09-18 12:01 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 2.2000 | 2.1400 | 2.2800 | 94.8500 | 124572.00 | 0.00 | 122362.00 | 566 | 23 | 1133 | 9796 | 0.115659452837893 | 0.420369357491642 | 0.421470103064213 | false | false | false | true | false | |||||||||||||||
| daec9815-ab8e-4fe9-a340-75090805a65c | 2026-09-16 10:53 | 2026-09-16 10:53 | 2026-09-16 10:53 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 2.6900 | 2.6900 | 2.7300 | 94.7700 | 20444.00 | 0.00 | 20444.00 | 76 | 8 | 1071 | 11283 | 0.0949215634139856 | 0.455605976811218 | 0.455605976811218 | false | false | false | true | false | |||||||||||||||
| 1303b106-d218-4299-8eaf-21f1c1dda51a | 2026-09-16 10:53 | 2026-09-16 10:53 | 2026-09-16 10:53 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 2.6900 | 2.6400 | 2.7000 | 94.7800 | 19368.00 | 17485.00 | 0.00 | 72 | 20 | 988 | 11283 | 0.0875653638216786 | 0.455931492950257 | 0.455931492950257 | true | false | false | true | false | |||||||||||||||
| 2fc84825-e6c4-48b6-b9d1-122bec0166f0 | 2026-09-16 10:24 | 2026-09-16 10:24 | 2026-09-16 10:24 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 2.8800 | 2.8200 | 2.8800 | 93.0000 | 12096.00 | 12096.00 | 0.00 | 42 | 5 | 827 | 11283 | 0.073296109190818 | 0.44674963413822 | 0.44674963413822 | false | false | false | true | false | |||||||||||||||
| 3fd56d0a-38d6-4a3a-9cf5-f6f4bbf26366 | 2026-09-14 10:10 | 2026-09-14 10:10 | 2026-09-14 10:10 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 3.2000 | 3.1500 | 3.3000 | 93.3200 | 1600000.00 | 0.00 | 1600000.00 | 5000 | 30 | 5277 | 12127 | 0.435144718396965 | 0.444634374142457 | 0.444634374142457 | false | false | false | true | false | |||||||||||||||
| 343cfe10-cc8e-40aa-bd1d-9790cbc4fa60 | 2026-09-08 14:37 | 2026-09-08 14:37 | 2026-09-08 14:37 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 2.0200 | 2.0200 | 2.0800 | 99.2450 | 20403.00 | 203.00 | 20200.00 | 101 | 23 | 491 | 12002 | 0.0409098483586069 | 0.456982486262958 | 0.458029293196594 | false | false | false | true | false | |||||||||||||||
| 1138119f-2239-4617-836b-9f813c3caa29 | 2026-09-04 10:31 | 2026-09-04 10:31 | 2026-09-04 10:31 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 2.0500 | 2.0500 | 2.1400 | 99.5400 | 14350.00 | 0.00 | 14350.00 | 70 | 5 | 907 | 12357 | 0.073399692481994 | 0.445692754664499 | 0.445692754664499 | true | false | false | true | false | |||||||||||||||
| cddbef0a-e5be-4690-80d4-d24ffd014e41 | 2026-09-04 09:49 | 2026-09-04 09:49 | 2026-09-04 09:49 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 2.0600 | 2.0100 | 2.0600 | 99.5800 | 24308.00 | 24308.00 | 0.00 | 118 | 6 | 728 | 12357 | 0.0589139758841143 | 0.447572674995479 | 0.447572674995479 | false | false | false | true | false | |||||||||||||||
| b221ee42-fc07-488c-99e8-4b1c41cc7793 | 2026-09-04 09:49 | 2026-09-04 09:49 | 2026-09-04 09:49 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 2.0600 | 2.0600 | 2.0700 | 99.5200 | 15656.00 | 0.00 | 15656.00 | 76 | 7 | 610 | 12357 | 0.0493647325402606 | 0.446251398101303 | 0.446251398101303 | false | false | false | true | false | |||||||||||||||
| 4246155d-9e3d-4925-8722-707299edc3fe | 2026-09-04 09:49 | 2026-09-04 09:49 | 2026-09-04 09:49 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 2.0800 | 2.0800 | 2.0900 | 99.4550 | 19344.00 | 0.00 | 14560.00 | 93 | 8 | 486 | 12357 | 0.0393299344501093 | 0.446809799122789 | 0.446809799122789 | true | false | false | true | false | |||||||||||||||
| 6e78e628-9bd9-4023-ada7-c978e42d0bc0 | 2026-09-04 09:49 | 2026-09-04 09:49 | 2026-09-04 09:49 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 2.0800 | 2.0800 | 2.1100 | 99.4900 | 14768.00 | 0.00 | 10608.00 | 71 | 6 | 309 | 12357 | 0.0250060694343287 | 0.44758359835705 | 0.44758359835705 | false | false | false | true | false | |||||||||||||||
| 10e6159f-38a4-492a-8992-7458eea60923 | 2026-09-01 15:56 | 2026-09-01 15:56 | 2026-09-01 15:56 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 3.5500 | 3.4000 | 3.5500 | 94.6250 | 17750.00 | 17750.00 | 0.00 | 50 | 6 | 465 | 9037 | 0.0514551289144628 | 0.443819442257811 | 0.443819442257811 | false | false | false | true | false | |||||||||||||||
| d387902b-0f21-44f0-b990-17aefb569fce | 2026-09-01 09:30 | 2026-09-01 09:30 | 2026-09-01 09:30 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 3.5000 | 3.3500 | 3.5000 | 94.7280 | 19950.00 | 19950.00 | 0.00 | 57 | 17 | 68 | 9037 | 0.00752462100254509 | 0.442515651753158 | 0.442515651753158 | true | false | false | true | false | |||||||||||||||
| fda3659c-7b27-43fd-a0cb-aba825a347b8 | 2026-08-28 12:03 | 2026-08-28 12:03 | 2026-08-28 12:03 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 2.2000 | 2.1200 | 2.2600 | 100.0000 | 21987.00 | 19140.00 | 0.00 | 100 | 5 | 709 | 5308 | 0.133571966842502 | 0.452624740113985 | 0.452624740113985 | false | false | false | true | false | |||||||||||||||
| 0dbe58af-3fb4-4f8d-aa2e-04fb3a4e8d07 | 2026-08-28 11:57 | 2026-08-28 11:57 | 2026-08-28 11:57 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 2.2200 | 2.1100 | 2.2500 | 100.0000 | 15513.00 | 15513.00 | 0.00 | 70 | 5 | 602 | 5308 | 0.113413715146948 | 0.451272546730966 | 0.451272546730966 | false | false | false | true | false | |||||||||||||||
| b1720ad7-04bd-4a8f-87da-64c2a81ef949 | 2026-08-26 11:20 | 2026-08-26 11:20 | 2026-08-26 11:20 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 2.2000 | 2.1450 | 2.2100 | 102.6900 | 44000.00 | 4620.00 | 0.00 | 200 | 19 | 436 | 5465 | 0.0797804208600183 | 0.48052527104916 | 0.48052527104916 | false | false | false | true | false | |||||||||||||||
| 255c9b47-2cc4-4b1d-ab36-d9d8d0b574e9 | 2026-08-24 13:04 | 2026-08-24 13:03 | 2026-08-24 13:03 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 2.5400 | 2.4600 | 2.5800 | 102.6600 | 25368.00 | 25368.00 | 0.00 | 100 | 5 | 3828 | 1943 | 1.97014925373134 | 0.501173252038276 | 0.501173252038276 | false | false | false | true | false | |||||||||||||||
| 9708a5e3-f585-4dbc-b223-d24cd6621565 | 2026-08-21 09:35 | 2026-08-21 09:35 | 2026-08-21 09:35 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 2.5800 | 2.4500 | 2.7100 | 102.1100 | 12900.00 | 10836.00 | 0.00 | 50 | 5 | 68 | 1701 | 0.0399764844209289 | 0.482488466986516 | 0.482488466986516 | false | false | false | true | false | |||||||||||||||
| 6037204a-5653-4f9c-a521-e2545a7ad44f | 2026-08-19 10:33 | 2026-08-19 10:32 | 2026-08-19 10:32 | GDX | GDX261016P00090000 | put | 90.0000 | 2026-10-16 | 3.5500 | 3.4500 | 3.5500 | 96.8600 | 10650.00 | 2130.00 | 0.00 | 30 | 6 | 52 | 1506 | 0.0345285524568393 | 0.446477407054485 | 0.446477407054485 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:57:38.128984Z"} |
| 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-18T17:59:53.998874Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"} |
| 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-09-16T14:55:35.772586Z"} |
| 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-16T14:55:35.772586Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 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-14T14:14:09.812180Z"} |
| 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-09-08T18:43:21.019108Z"} |
| 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-09-04T14:44:26.340635Z"} |
| 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-09-04T13:56:18.493427Z"} |
| 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-09-04T13:56:18.493427Z"} |
| 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-09-04T13:56:18.493427Z"} |
| 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-09-04T13:56:18.493427Z"} |
| 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-09-02T13:31:29.863287Z"} |
| 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-09-01T13:34:32.417809Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} |
| 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-26T15:22:15.766686Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 52.34 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T17:17:38.633077Z"} |
| 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-21T13:43:10.748747Z"} |
| 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:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |