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 |
|---|
| 4e884cf4-172b-4963-8f7a-07f38d859314 | 2026-09-16 15:11 | 2026-09-16 15:11 | 2026-09-16 15:11 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 1.4800 | 1.2800 | 1.5700 | 91.4950 | 59516.00 | 744.00 | 58474.00 | 403 | 18 | 1216 | 7607 | 0.159852767188116 | 0.640744692139433 | 0.636588378631244 | 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-09-16T19:16:52.058969Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 0b9a0b24-9f3b-4752-8867-f2666d0bb2a6 | 2026-09-16 15:11 | 2026-09-16 15:11 | 2026-09-16 15:11 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 1.5000 | 1.4000 | 1.5100 | 91.4700 | 35550.00 | 9600.00 | 25950.00 | 237 | 24 | 1459 | 7607 | 0.191797029052189 | 0.643649410840828 | 0.643649410840828 | true | false | false | true | ||||||||||||||||
| 068425a9-1f05-4866-beff-5b1ecef95e01 | 2026-09-14 11:28 | 2026-09-14 11:28 | 2026-09-14 11:28 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 0.9800 | 0.9700 | 1.0100 | 93.7800 | 44100.00 | 7938.00 | 36162.00 | 450 | 15 | 5316 | 7677 | 0.692457991402892 | 0.543111364401407 | 0.543111364401407 | true | false | false | true | ||||||||||||||||
| 73023b75-20d3-45cd-aebc-ffcb2f74207f | 2026-09-14 11:28 | 2026-09-14 11:28 | 2026-09-14 11:28 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 1.0000 | 1.0000 | 1.0800 | 93.7200 | 50600.00 | 0.00 | 50600.00 | 506 | 39 | 4848 | 7677 | 0.631496678389996 | 0.543923891759096 | 0.543923891759096 | false | false | false | true | ||||||||||||||||
| 75c58bef-4f15-4426-b7f5-98944b37a616 | 2026-09-14 11:28 | 2026-09-14 11:28 | 2026-09-14 11:28 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 1.0100 | 1.0100 | 1.0500 | 93.7000 | 41208.00 | 0.00 | 41208.00 | 408 | 11 | 4342 | 7677 | 0.565585515175199 | 0.545167691388423 | 0.545167691388423 | false | false | false | true | ||||||||||||||||
| 518996a3-adae-4521-8d3e-9cfd31a8c8a3 | 2026-09-14 10:06 | 2026-09-14 10:06 | 2026-09-14 10:06 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 1.2000 | 1.2000 | 1.2500 | 93.2700 | 27481.00 | 0.00 | 27481.00 | 229 | 15 | 3676 | 7677 | 0.478832877426078 | 0.559573717055138 | 0.561885500959196 | false | false | false | true | ||||||||||||||||
| 5a20400f-2c35-4e0a-b162-bf614759c08e | 2026-09-14 09:44 | 2026-09-14 09:44 | 2026-09-14 09:44 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 1.1400 | 1.1200 | 1.2800 | 93.0000 | 42750.00 | 42636.00 | 114.00 | 375 | 12 | 2317 | 7677 | 0.301810603100169 | 0.548407235134468 | 0.548407235134468 | true | false | false | true | ||||||||||||||||
| d185fe8e-0d8c-494f-ad8b-e1de799ea968 | 2026-09-14 09:44 | 2026-09-14 09:44 | 2026-09-14 09:44 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 1.1500 | 1.1300 | 1.1500 | 93.0000 | 10810.00 | 10810.00 | 0.00 | 94 | 5 | 1707 | 7677 | 0.222352481438062 | 0.548987217192972 | 0.548987217192972 | true | false | false | true | ||||||||||||||||
| b4e2d80b-7d56-4ee4-9868-925ac78362e2 | 2026-09-14 09:35 | 2026-09-14 09:35 | 2026-09-14 09:35 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 1.0900 | 1.0300 | 1.1300 | 93.4700 | 37169.00 | 36624.00 | 545.00 | 341 | 11 | 1489 | 7677 | 0.193955972385046 | 0.548423977686725 | 0.548423977686725 | true | false | false | true | ||||||||||||||||
| 69d90723-0574-474f-ad6e-aa00a58899ea | 2026-09-14 09:35 | 2026-09-14 09:35 | 2026-09-14 09:35 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 1.0700 | 1.0400 | 1.1650 | 93.4950 | 40553.00 | 40232.00 | 321.00 | 379 | 6 | 763 | 7677 | 0.0993877816855542 | 0.544829618701415 | 0.544829618701415 | true | false | false | true | ||||||||||||||||
| 11928264-7655-4511-8ab4-a84dc03ddd93 | 2026-09-14 09:35 | 2026-09-14 09:35 | 2026-09-14 09:35 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 1.0800 | 1.0400 | 1.0800 | 93.4950 | 41580.00 | 41580.00 | 0.00 | 385 | 14 | 1148 | 7677 | 0.14953757978377 | 0.54774502471083 | 0.54774502471083 | true | false | false | true | ||||||||||||||||
| bbf4894f-4c7a-4fea-8bdb-1b1c43729c1c | 2026-09-11 14:19 | 2026-09-11 14:19 | 2026-09-11 14:19 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 0.5300 | 0.5300 | 0.5500 | 96.7600 | 21571.00 | 0.00 | 21571.00 | 407 | 18 | 604 | 8007 | 0.0754339952541526 | 0.462473108447601 | 0.462473108447601 | false | false | false | true | ||||||||||||||||
| 2eb6e91d-a23f-420c-9874-92314fe0d604 | 2026-09-10 09:38 | 2026-09-10 09:38 | 2026-09-10 09:38 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 0.9000 | 0.8700 | 0.9000 | 96.3455 | 210960.00 | 210960.00 | 0.00 | 2344 | 15 | 5765 | 2810 | 2.05160142348754 | 0.510078143767289 | 0.510078143767289 | false | false | false | true | ||||||||||||||||
| 47d62fa0-a29a-4582-b341-0b613062538e | 2026-09-10 09:33 | 2026-09-10 09:33 | 2026-09-10 09:33 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 0.9400 | 0.8100 | 0.9400 | 96.4100 | 50628.00 | 50628.00 | 0.00 | 539 | 15 | 3393 | 2810 | 1.20747330960854 | 0.520648003981359 | 0.520648003981359 | false | false | false | true | ||||||||||||||||
| 60a57cc7-e0b1-4074-b2a1-0782ee11ba7f | 2026-09-10 09:33 | 2026-09-10 09:33 | 2026-09-10 09:33 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 0.9400 | 0.7700 | 0.9400 | 96.3500 | 110074.00 | 110074.00 | 0.00 | 1171 | 26 | 2658 | 2810 | 0.945907473309609 | 0.51997347019309 | 0.51997347019309 | false | false | false | true | ||||||||||||||||
| ea36f155-a84b-47ed-abbc-fab43ff87c97 | 2026-09-10 09:33 | 2026-09-10 09:33 | 2026-09-10 09:33 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 0.8700 | 0.8700 | 1.0500 | 96.4275 | 11919.00 | 0.00 | 11919.00 | 137 | 6 | 257 | 2810 | 0.0914590747330961 | 0.506919924378881 | 0.506919924378881 | true | false | false | true | ||||||||||||||||
| 37c79da5-699b-415d-9353-3ee4bd915078 | 2026-09-01 09:30 | 2026-09-01 09:30 | 2026-09-01 09:30 | GDX | GDX260918P00091000 | put | 91.0000 | 2026-09-18 | 1.8600 | 1.7000 | 1.8700 | 94.7250 | 16154.00 | 12680.00 | 3474.00 | 87 | 5 | 89 | 2615 | 0.0340344168260038 | 0.434889707645269 | 0.429343879923845 | 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-16T19:16:52.058969Z"} |
| 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-14T15:39:52.032222Z"} |
| 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:39:52.032222Z"} |
| 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:39:52.032222Z"} |
| 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-14T14:14:09.812180Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-14T13:48:00.043994Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-14T13:48:00.043994Z"} |
| 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-14T13:38:30.454841Z"} |
| 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-14T13:38:30.454841Z"} |
| 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-14T13:38:30.454841Z"} |
| 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-11T18:33:12.425630Z"} |
| 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-10T13:42:34.192825Z"} |
| 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-09-10T13:42:34.192825Z"} |
| 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-10T13:42:34.192825Z"} |
| 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-10T13:42:34.192825Z"} |
| 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-01T13:34:32.417809Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |