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_alerts609,118 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 | strike |
|---|
| expirydate |
|---|
| 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 |
|---|
| dcdb85fe-b4a6-4500-8688-37fba0540b9b | 2026-09-30 14:49 | 2026-09-30 14:49 | 2026-09-30 14:49 | GDXJ | GDXJ270115C00100000 | call | 100.0000 | 2027-01-15 | 19.9500 | 19.2000 | 20.1000 | 114.0000 | 91750.00 | 85810.00 | 5940.00 | 46 | 9 | 46 | 2151 | 0.0213854021385402 | 0.469578761211946 | 0.456609030757498 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 8550376247.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T18:54:12.320411Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| dcd97c30-0426-4ed6-9d59-a2a12dbfc863 | 2026-09-30 09:31 | 2026-09-30 09:31 | 2026-09-30 09:31 | GDXJ | GDXJ261218P00110000 | put | 110.0000 | 2026-12-18 | 6.5200 | 6.2500 | 6.8500 | 116.3100 | 15640.00 | 0.00 | 15640.00 | 24 | 7 | 48 | 689 | 0.06966618287373 | 0.467654508098737 | 0.467654508098737 | false | false | ||||||||||||||||||
| 7afe9a8a-b237-4593-8169-bf6b66c3796a | 2026-09-28 14:32 | 2026-09-28 14:32 | 2026-09-28 14:32 | GDXJ | GDXJ261120P00115000 | put | 115.0000 | 2026-11-20 | 7.7500 | 7.1500 | 8.2000 | 114.9901 | 15506.00 | 15506.00 | 0.00 | 20 | 8 | 50 | 194 | 0.257731958762887 | 0.465367421733478 | 0.465367421733478 | false | false | ||||||||||||||||||
| 6d1e808c-ec9a-4c0f-83c8-0d595d0a1df0 | 2026-09-25 09:55 | 2026-09-25 09:55 | 2026-09-25 09:55 | GDXJ | GDXJ260925P00121000 | put | 121.0000 | 2026-09-25 | 1.5800 | 0.4400 | 2.3800 | 119.7400 | 23403.00 | 23403.00 | 0.00 | 148 | 10 | 148 | 828 | 0.178743961352657 | 0.679832966634447 | 0.679832966634447 | false | false | ||||||||||||||||||
| d0236625-1c79-476d-9035-57c344580e7f | 2026-09-23 13:14 | 2026-09-23 13:14 | 2026-09-23 13:14 | GDXJ | GDXJ280121P00105000 | put | 105.0000 | 2028-01-21 | 15.6800 | 13.6000 | 16.4500 | 121.0000 | 36055.00 | 31380.00 | 3110.00 | 23 | 9 | 32 | 1698 | 0.0188457008244994 | 0.511263077432525 | 0.507950791424776 | true | false | ||||||||||||||||||
| 78b26785-4a20-42f1-8de9-b3f68deb8165 | 2026-09-22 14:40 | 2026-09-22 14:40 | 2026-09-22 14:40 | GDXJ | GDXJ270115C00210000 | call | 210.0000 | 2027-01-15 | 1.0000 | 0.5100 | 1.2000 | 126.5500 | 251275.00 | 243475.00 | 2600.00 | 2513 | 49 | 2518 | 65 | 38.7384615384615 | 0.533408282256131 | 0.505458232137813 | false | false | ||||||||||||||||||
| 5051ac0e-c8d0-4202-90c4-8820d4fe7468 | 2026-09-21 10:02 | 2026-09-21 10:02 | 2026-09-21 10:02 | GDXJ | GDXJ270115P00125000 | put | 125.0000 | 2027-01-15 | 13.7100 | 11.4500 | 13.8000 | 122.9400 | 23300.00 | 8225.00 | 15075.00 | 17 | 7 | 17 | 562 | 0.0302491103202847 | 0.491063304207375 | 0.487417531391473 | false | false | ||||||||||||||||||
| 8ffd22f5-a326-48bf-a7d7-e71236d36931 | 2026-09-18 11:18 | 2026-09-18 11:17 | 2026-09-18 11:17 | GDXJ | GDXJ261016C00130000 | call | 130.0000 | 2026-10-16 | 3.6100 | 3.4500 | 3.8500 | 122.4700 | 18045.00 | 2900.00 | 365.00 | 50 | 29 | 51 | 299 | 0.17056856187291 | 0.475405274120943 | 0.471454087605109 | false | false | ||||||||||||||||||
| e99ed0df-6ba7-4a38-9296-b7cb40157107 | 2026-09-16 15:05 | 2026-09-16 15:05 | 2026-09-16 15:05 | GDXJ | GDXJ260918P00118000 | put | 118.0000 | 2026-09-18 | 2.4000 | 1.6100 | 3.1500 | 117.6900 | 47944.00 | 47944.00 | 0.00 | 200 | 7 | 215 | 258 | 0.833333333333333 | 0.650939104282339 | 0.650939104282339 | false | false | ||||||||||||||||||
| db86085a-0641-4aa8-bad0-222646e7d1f7 | 2026-09-16 10:53 | 2026-09-16 10:53 | 2026-09-16 10:53 | GDXJ | GDXJ261120C00185000 | call | 185.0000 | 2026-11-20 | 0.5500 | 0.3400 | 0.5500 | 121.3350 | 36181.00 | 36133.00 | 48.00 | 658 | 42 | 659 | 49 | 13.4489795918367 | 0.557732673190015 | 0.543987393689233 | true | false | ||||||||||||||||||
| 0f716163-0b27-4df9-b0c3-7824dddb3c94 | 2026-09-15 12:46 | 2026-09-15 12:46 | 2026-09-15 12:46 | GDXJ | GDXJ270115C00140000 | call | 140.0000 | 2027-01-15 | 6.7400 | 6.5000 | 7.1500 | 119.0000 | 14148.00 | 0.00 | 14148.00 | 21 | 11 | 63 | 6742 | 0.00934440818748146 | 0.474955661964375 | 0.474955661964375 | false | false | ||||||||||||||||||
| e626bafa-4845-46bc-aa0b-77ffffcaf60d | 2026-09-15 12:33 | 2026-09-15 12:33 | 2026-09-15 12:33 | GDXJ | GDXJ270115C00109000 | call | 109.0000 | 2027-01-15 | 19.5700 | 18.5500 | 20.8500 | 119.0000 | 11742.00 | 0.00 | 11742.00 | 6 | 6 | 6 | 25 | 0.24 | 0.475039168301837 | 0.475039168301837 | false | false | ||||||||||||||||||
| f26d3bf0-9aeb-4959-b9ff-ba211df02a8d | 2026-09-01 15:35 | 2026-09-01 15:35 | 2026-09-01 15:35 | GDXJ | GDXJ261016P00114000 | put | 114.0000 | 2026-10-16 | 4.1500 | 3.9500 | 4.2000 | 123.1900 | 276367.00 | 273462.00 | 2905.00 | 666 | 38 | 679 | 442 | 1.53619909502262 | 0.489296286352449 | 0.489296286352449 | false | false | ||||||||||||||||||
| c002975e-072a-4e81-91ae-8ba77b2d76fd | 2026-08-28 11:28 | 2026-08-28 11:28 | 2026-08-28 11:28 | GDXJ | GDXJ261016P00120000 | put | 120.0000 | 2026-10-16 | 4.2500 | 3.8500 | 4.2500 | 132.5800 | 280897.00 | 280897.00 | 0.00 | 661 | 51 | 664 | 21 | 31.6190476190476 | 0.512307619742138 | 0.512307619742138 | false | false | ||||||||||||||||||
| 5d542b80-1518-4e7c-acee-2bf30e31bc3e | 2026-08-27 10:19 | 2026-08-27 10:19 | 2026-08-27 10:19 | GDXJ | GDXJ280121C00170000 | call | 170.0000 | 2028-01-21 | 23.0000 | 21.5000 | 23.4500 | 134.1795 | 1154565.00 | 1154565.00 | 0.00 | 502 | 29 | 502 | 159 | 3.15723270440252 | 0.504574810010593 | 0.504574810010593 | true | false | ||||||||||||||||||
| aa07b321-5a24-4364-94e5-0111874f4626 | 2026-08-24 10:56 | 2026-08-24 10:56 | 2026-08-24 10:56 | GDXJ | GDXJ261218C00150000 | call | 150.0000 | 2026-12-18 | 10.4600 | 10.0000 | 11.2500 | 133.1300 | 20916.00 | 0.00 | 20916.00 | 20 | 5 | 41 | 354 | 0.115819209039548 | 0.540578375630047 | 0.540578375630047 | false | false | ||||||||||||||||||
| 9c3a1212-6497-4f11-b455-4402b2604b1e | 2026-08-21 09:30 | 2026-08-21 09:30 | 2026-08-21 09:30 | GDXJ | GDXJ260821C00125000 | call | 125.0000 | 2026-08-21 | 8.5800 | 7.3500 | 8.6500 | 133.2100 | 60054.00 | 60054.00 | 0.00 | 70 | 7 | 139 | 617 | 0.225283630470016 | 2.02351360032942 | 1.4794792118678 | false | false | ||||||||||||||||||
| 792f7022-05e5-4c13-a43e-2d2331fc49f4 | 2026-08-19 15:56 | 2026-08-19 15:56 | 2026-08-19 15:56 | GDXJ | GDXJ260821C00125000 | call | 125.0000 | 2026-08-21 | 2.7300 | 2.2000 | 2.8500 | 125.9200 | 19114.00 | 19114.00 | 0.00 | 70 | 11 | 309 | 915 | 0.337704918032787 | 0.633542306341059 | 0.573286576477678 | false | false | ||||||||||||||||||
| ed11a76e-361c-40b9-b514-4ec53db3e000 | 2026-08-19 15:50 | 2026-08-19 15:50 | 2026-08-19 15:50 | GDXJ | GDXJ260828C00125000 | call | 125.0000 | 2026-08-28 | 4.6200 | 3.8500 | 5.3000 | 125.5910 | 36975.00 | 17335.00 | 19640.00 | 80 | 13 | 329 | 1830 | 0.179781420765027 | 0.57856019066821 | 0.521025077092071 | false | false | ||||||||||||||||||
| 0b97abad-cc63-4d1f-8736-10ff1145cc0c | 2026-08-19 15:50 | 2026-08-19 15:50 | 2026-08-19 15:50 | GDXJ | GDXJ260828C00125000 | call | 125.0000 | 2026-08-28 | 4.5000 | 3.8500 | 4.6500 | 125.5910 | 44580.00 | 42790.00 | 1790.00 | 99 | 5 | 428 | 1830 | 0.233879781420765 | 0.540205132076646 | 0.527418651666009 | false | false | ||||||||||||||||||
| abcd70e7-2c98-44c1-a2b8-0131f904dd6a | 2026-08-19 09:48 | 2026-08-19 09:48 | 2026-08-19 09:48 | GDXJ | GDXJ261120P00100000 | put | 100.0000 | 2026-11-20 | 3.5000 | 3.0000 | 3.5000 | 123.4516 | 252305.00 | 251275.00 | 685.00 | 721 | 46 | 721 | 170 | 4.24117647058824 | 0.537269012159638 | 0.530843413839 | true | false | ||||||||||||||||||
| 686ac48a-1fcc-4ccd-8747-9b893f45c622 | 2026-08-18 10:40 | 2026-08-18 10:40 | 2026-08-18 10:40 | GDXJ | GDXJ261218P00090000 | put | 90.0000 | 2026-12-18 | 3.0500 | 2.5100 | 3.0500 | 117.6950 | 307105.00 | 307105.00 | 0.00 | 1007 | 46 | 1007 | 271 | 3.71586715867159 | 0.53207026380191 | 0.53207026380191 | false | false | ||||||||||||||||||
| 680fdb6b-62b2-4627-9fae-b34833f6c7d6 | 2026-08-17 12:47 | 2026-08-17 12:47 | 2026-08-17 12:47 | GDXJ | GDXJ260821P00120000 | put | 120.0000 | 2026-08-21 | 1.9700 | 1.9700 | 2.0500 | 121.1350 | 18129.00 | 0.00 | 18129.00 | 92 | 18 | 110 | 203 | 0.541871921182266 | 0.502294315102352 | 0.50027204589729 | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 8550376247.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:31:22.078710Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:38:54.071675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:56:09.661998Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:17:19.986908Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| 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 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:02:45.816631Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| 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 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| 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 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:48:10.363261Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:48:10.363261Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T19:44:53.190071Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:36:02.227679Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:09:19.758040Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:35:10.222979Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 68.68 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |