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 | 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 |
|---|
| 54186b0c-7c4a-44fa-887b-785a515b2d31 | 2026-08-24 09:59 | 2026-08-24 09:59 | 2026-08-24 09:59 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 1.3700 | 1.3200 | 1.3700 | 35.2600 | 61622.00 | 61486.00 | 0.00 | 450 | 15 | 558 | 53932 | 0.0103463620855893 | 0.374138767801903 | 0.374138767801903 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 8633146199.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 10808dff-0d73-49f6-894b-94936f6494ee | 2026-08-24 09:59 | 2026-08-24 09:59 | 2026-08-24 09:59 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 1.3800 | 1.3400 | 1.3800 | 35.2700 | 63470.00 | 62100.00 | 0.00 | 460 | 15 | 1499 | 53932 | 0.0277942594378106 | 0.375266953819856 | 0.375266953819856 | false | false | false | true | ||||||||||||||||
| 94affdd1-ba78-456c-8b26-a2caf9735117 | 2026-08-25 10:52 | 2026-08-25 10:52 | 2026-08-25 10:52 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 1.1600 | 1.1500 | 1.1900 | 35.1100 | 156600.00 | 0.00 | 156600.00 | 1350 | 10 | 1585 | 85542 | 0.0185289097753151 | 0.348634308893219 | 0.348634308893219 | false | false | false | true | ||||||||||||||||
| e8f82709-ede3-4b66-be03-6a0d633ff660 | 2026-09-02 10:12 | 2026-09-02 10:12 | 2026-09-02 10:12 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 2.5000 | 2.4800 | 2.5000 | 37.6800 | 30000.00 | 5250.00 | 0.00 | 120 | 6 | 445 | 85352 | 0.00521370325241353 | 0.396680744899382 | 0.396680744899382 | false | false | false | true | ||||||||||||||||
| b0407bd4-acdd-47bb-acb0-94d060d2498a | 2026-09-02 10:12 | 2026-09-02 10:12 | 2026-09-02 10:12 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 2.5000 | 2.5000 | 2.6500 | 37.6700 | 45250.00 | 0.00 | 45250.00 | 181 | 7 | 626 | 85352 | 0.00733433311463117 | 0.397847701257242 | 0.397847701257242 | true | false | false | true | ||||||||||||||||
| dcc8617a-a75d-4bbc-911c-efaa08e282d9 | 2026-09-02 10:13 | 2026-09-02 10:13 | 2026-09-02 10:13 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 2.5000 | 2.4800 | 2.5000 | 37.6750 | 19750.00 | 19750.00 | 0.00 | 79 | 5 | 824 | 85352 | 0.00965413815727809 | 0.397264470563489 | 0.397264470563489 | false | false | false | true | ||||||||||||||||
| 1bc95735-438e-4870-9fe7-d0a1e996b59f | 2026-09-02 10:13 | 2026-09-02 10:13 | 2026-09-02 10:13 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 2.5000 | 2.4800 | 2.5000 | 37.6850 | 121250.00 | 117750.00 | 0.00 | 485 | 19 | 1309 | 85352 | 0.0153364888930546 | 0.396096521696595 | 0.396096521696595 | false | false | false | true | ||||||||||||||||
| 55bcace4-0d20-49fe-b43f-1b136440f65d | 2026-09-03 10:24 | 2026-09-03 10:24 | 2026-09-03 10:24 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 2.9000 | 2.9000 | 2.9900 | 38.4550 | 59740.00 | 0.00 | 59740.00 | 206 | 35 | 595 | 83906 | 0.0070912688008009 | 0.385053924016798 | 0.385053924016798 | true | false | false | true | ||||||||||||||||
| 1db7c0e9-7c61-423c-9e10-dddaa062f692 | 2026-09-03 10:24 | 2026-09-03 10:24 | 2026-09-03 10:24 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 2.9000 | 2.8800 | 2.9900 | 38.4550 | 315520.00 | 290.00 | 315230.00 | 1088 | 23 | 1683 | 83906 | 0.0200581603222654 | 0.385053924016798 | 0.385053924016798 | true | false | false | true | ||||||||||||||||
| d2cc257d-e6e0-461d-9704-ef1716eb48fc | 2026-09-04 15:24 | 2026-09-04 15:23 | 2026-09-04 15:23 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 2.4200 | 2.4100 | 2.4300 | 37.8550 | 24200.00 | 0.00 | 0.00 | 100 | 6 | 5124 | 83366 | 0.0614639061487897 | 0.369325139204871 | 0.369325139204871 | false | false | false | true | ||||||||||||||||
| 0e1ee270-9f4a-45e4-902e-dce3fb297958 | 2026-09-14 10:17 | 2026-09-14 10:17 | 2026-09-14 10:17 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 2.1000 | 2.0900 | 2.2500 | 37.0000 | 21000.00 | 20790.00 | 210.00 | 100 | 8 | 105 | 77503 | 0.00135478626633808 | 0.414438774780324 | 0.414438774780324 | false | false | false | true | ||||||||||||||||
| 89750025-dfaa-44bd-936f-6d4a88fb73db | 2026-09-14 10:42 | 2026-09-14 10:42 | 2026-09-14 10:42 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 2.1400 | 2.1300 | 2.1400 | 37.4850 | 10700.00 | 10700.00 | 0.00 | 50 | 7 | 156 | 77503 | 0.002012825309988 | 0.414937024364231 | 0.414937024364231 | false | false | false | true | ||||||||||||||||
| 387016f5-dd23-4c43-8ac0-62829d67f8d1 | 2026-09-15 11:45 | 2026-09-15 11:45 | 2026-09-15 11:45 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 2.4700 | 2.4400 | 2.4700 | 37.9800 | 24700.00 | 24700.00 | 0.00 | 100 | 6 | 148 | 77274 | 0.00191526257214587 | 0.428734924173073 | 0.428734924173073 | false | false | false | true | ||||||||||||||||
| 2898d0fa-d08b-406d-8d71-d85ebe6ab753 | 2026-09-16 11:51 | 2026-09-16 11:51 | 2026-09-16 11:51 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 2.2700 | 2.2700 | 2.2800 | 37.6650 | 10896.00 | 0.00 | 10896.00 | 48 | 6 | 394 | 77144 | 0.00510733174323343 | 0.434605097662664 | 0.434605097662664 | true | false | false | true | ||||||||||||||||
| 6e04a896-0746-4064-9d61-b4aea1195c07 | 2026-09-16 12:11 | 2026-09-16 12:11 | 2026-09-16 12:11 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 2.3100 | 2.3100 | 2.3200 | 37.7200 | 13860.00 | 0.00 | 13860.00 | 60 | 6 | 470 | 77144 | 0.00609250233329877 | 0.436358999666253 | 0.436358999666253 | true | false | false | true | ||||||||||||||||
| 10989b52-05c6-4f10-b5f4-d84eb040eac4 | 2026-09-16 14:04 | 2026-09-16 14:04 | 2026-09-16 14:04 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 2.2200 | 2.2200 | 2.2300 | 37.5700 | 21534.00 | 0.00 | 21534.00 | 97 | 8 | 924 | 77144 | 0.0119776003318469 | 0.435987627447408 | 0.435987627447408 | true | false | false | true | ||||||||||||||||
| 1df00d0b-4368-4ca0-9244-eb512a48f65a | 2026-09-17 14:23 | 2026-09-17 14:23 | 2026-09-17 14:23 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 2.2500 | 2.2400 | 2.2600 | 37.7500 | 69525.00 | 0.00 | 67725.00 | 309 | 8 | 535 | 76546 | 0.00698926135918271 | 0.425291706404987 | 0.425291706404987 | false | false | false | true | ||||||||||||||||
| dd81207e-5e64-4ba5-8872-7f3f2ec2bcc6 | 2026-09-22 12:24 | 2026-09-22 12:24 | 2026-09-22 12:24 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 2.2900 | 2.2900 | 2.3200 | 37.8800 | 20839.00 | 0.00 | 20839.00 | 91 | 6 | 839 | 76250 | 0.0110032786885246 | 0.460133460768725 | 0.460133460768725 | true | false | false | true | ||||||||||||||||
| 9ddff38f-2320-4efb-a7b2-43c911d4d225 | 2026-09-25 10:44 | 2026-09-25 10:44 | 2026-09-25 10:44 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 1.4800 | 1.4800 | 1.4900 | 36.5599 | 14800.00 | 0.00 | 12136.00 | 100 | 6 | 111 | 76102 | 0.00145856876297601 | 0.469994412895137 | 0.469994412895137 | false | false | false | true | ||||||||||||||||
| e637aa62-51a8-4822-888f-f9be4680c312 | 2026-09-29 09:43 | 2026-09-29 09:43 | 2026-09-29 09:43 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 1.2200 | 1.2000 | 1.2300 | 36.0800 | 24400.00 | 24400.00 | 0.00 | 200 | 5 | 400 | 76292 | 0.00524301368426572 | 0.512406807825452 | 0.512406807825452 | false | false | false | true | ||||||||||||||||
| 308c3896-d53d-4aa0-8d0b-0cf8803e8c1d | 2026-09-29 11:27 | 2026-09-29 11:27 | 2026-09-29 11:27 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 1.2200 | 1.2000 | 1.2300 | 36.0350 | 11346.00 | 2684.00 | 8662.00 | 93 | 5 | 1104 | 76292 | 0.0144707177685734 | 0.518817884982111 | 0.518817884982111 | false | false | false | true | ||||||||||||||||
| 896cb0a1-d983-4929-849d-3e4e7bf1f72f | 2026-09-29 13:44 | 2026-09-29 13:44 | 2026-09-29 13:44 | EWZ | EWZ261016C00037000 | call | 37.0000 | 2026-10-16 | 1.3100 | 1.3000 | 1.3100 | 36.2350 | 26200.00 | 26200.00 | 0.00 | 200 | 8 | 1346 | 76292 | 0.0176427410475541 | 0.519145069413763 | 0.519145069413763 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:00:40.665909Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:25:30.485375Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:25:30.485375Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:25:30.485375Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:25:30.485375Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:24:32.358904Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:24:32.358904Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8686956917.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8686956917.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:43:33.165845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:54:17.138635Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8662096023.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T16:04:58.541898Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8662096023.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T16:35:37.886334Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8662096023.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:26:46.257544Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8590352179.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8710683063.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:27:20.551854Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8572757732.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:47:41.799650Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8410816973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:44:04.459232Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8410816973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:29:51.337369Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8410816973.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:52:12.020508Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |