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_alerts566,287 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 |
|---|
| 12ff5776-bc0c-41e3-ab3a-abb22cc43e44 | 2026-08-21 11:37 | 2026-08-21 11:37 | 2026-08-21 11:37 | EWZ | EWZ261120P00035000 | put | 35.0000 | 2026-11-20 | 2.3000 | 2.2200 | 2.3000 | 35.2450 | 22080.00 | 22080.00 | 0.00 | 96 | 7 | 118 | 28170 | 0.00418885339013135 | 0.371158085765863 | 0.371158085765863 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 8633146199.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:38:28.521674Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| da1bd50b-feae-4f5c-9e3a-ce611a19b836 | 2026-08-21 11:39 | 2026-08-21 11:39 | 2026-08-21 11:39 | EWZ | EWZ261120P00035000 | put | 35.0000 | 2026-11-20 | 2.3400 | 2.3000 | 2.3700 | 35.2150 | 15678.00 | 15678.00 | 0.00 | 67 | 6 | 234 | 28170 | 0.00830670926517572 | 0.375089558818375 | 0.375089558818375 | false | false | false | true | ||||||||||||||||
| 5d2398bc-fa2b-416a-a899-9b5dfb0c07cf | 2026-08-21 12:13 | 2026-08-21 12:13 | 2026-08-21 12:13 | EWZ | EWZ261120P00035000 | put | 35.0000 | 2026-11-20 | 2.3600 | 2.3500 | 2.3600 | 35.1950 | 19352.00 | 19352.00 | 0.00 | 82 | 5 | 488 | 28170 | 0.0173233936812212 | 0.376740833006538 | 0.376740833006538 | true | false | false | true | ||||||||||||||||
| 50598273-ceba-448e-84fe-73dc8f37b13e | 2026-08-21 13:44 | 2026-08-21 13:43 | 2026-08-21 13:43 | EWZ | EWZ261120P00035000 | put | 35.0000 | 2026-11-20 | 2.3700 | 2.3100 | 2.3700 | 35.0450 | 40290.00 | 40290.00 | 0.00 | 170 | 7 | 1087 | 28170 | 0.0385871494497693 | 0.368734553526358 | 0.368734553526358 | true | false | false | true | ||||||||||||||||
| fa947060-5448-4544-a9f0-1d40644a0244 | 2026-08-21 13:53 | 2026-08-21 13:52 | 2026-08-21 13:52 | EWZ | EWZ261120P00035000 | put | 35.0000 | 2026-11-20 | 2.3700 | 2.3200 | 2.3700 | 35.0450 | 40290.00 | 40290.00 | 0.00 | 170 | 8 | 1257 | 28170 | 0.0446219382321619 | 0.368734553526358 | 0.368734553526358 | true | false | false | true | ||||||||||||||||
| 15be024c-9481-4141-bf53-bb17edffb2e7 | 2026-08-21 14:21 | 2026-08-21 14:21 | 2026-08-21 14:21 | EWZ | EWZ261120P00035000 | put | 35.0000 | 2026-11-20 | 2.3100 | 2.1300 | 2.3100 | 35.0000 | 33264.00 | 19866.00 | 0.00 | 144 | 6 | 1401 | 28170 | 0.0497337593184239 | 0.368249863023813 | 0.368249863023813 | true | false | false | true | ||||||||||||||||
| 876453a1-ae09-49e6-8ded-bb762c23f9fd | 2026-08-25 13:33 | 2026-08-25 13:33 | 2026-08-25 13:33 | EWZ | EWZ261120P00035000 | put | 35.0000 | 2026-11-20 | 2.2200 | 2.2100 | 2.2300 | 35.4650 | 235320.00 | 143190.00 | 87468.00 | 1060 | 24 | 1272 | 47979 | 0.0265115988244857 | 0.380338469980789 | 0.380338469980789 | false | false | false | true | ||||||||||||||||
| 8aadbf0e-bfc7-428f-a95a-93d8c4e71dda | 2026-09-02 13:45 | 2026-09-02 13:45 | 2026-09-02 13:45 | EWZ | EWZ261120P00035000 | put | 35.0000 | 2026-11-20 | 1.5200 | 1.5200 | 1.5300 | 38.0100 | 54872.00 | 0.00 | 54872.00 | 361 | 6 | 430 | 54481 | 0.00789265982636148 | 0.42715049365898 | 0.42715049365898 | true | false | false | true | ||||||||||||||||
| 6d6cb844-25ac-41ac-abe1-df82bbd558a2 | 2026-09-04 09:40 | 2026-09-04 09:40 | 2026-09-04 09:40 | EWZ | EWZ261120P00035000 | put | 35.0000 | 2026-11-20 | 1.5100 | 1.5100 | 1.5200 | 37.6800 | 37146.00 | 0.00 | 37146.00 | 246 | 9 | 246 | 54638 | 0.00450236099417988 | 0.41420336125365 | 0.41420336125365 | true | false | false | true | ||||||||||||||||
| b4500056-64dc-498d-8323-d330bc71df1a | 2026-09-10 09:47 | 2026-09-10 09:47 | 2026-09-10 09:47 | EWZ | EWZ261120P00035000 | put | 35.0000 | 2026-11-20 | 1.5000 | 1.5000 | 1.5200 | 37.7450 | 20100.00 | 0.00 | 20100.00 | 134 | 15 | 197 | 64633 | 0.00304797858679003 | 0.431822530515095 | 0.431822530515095 | false | false | false | true | ||||||||||||||||
| 0be0eec7-6f9d-443b-951b-f946bbe91f33 | 2026-09-14 13:38 | 2026-09-14 13:38 | 2026-09-14 13:38 | EWZ | EWZ261120P00035000 | put | 35.0000 | 2026-11-20 | 1.5200 | 1.5200 | 1.5400 | 37.7000 | 14288.00 | 0.00 | 14288.00 | 94 | 10 | 775 | 64712 | 0.0119761404376314 | 0.443657927680673 | 0.443657927680673 | true | false | false | true | ||||||||||||||||
| ef2fc437-2e66-45ce-9e55-2f42ee9651c7 | 2026-09-14 13:57 | 2026-09-14 13:56 | 2026-09-14 13:56 | EWZ | EWZ261120P00035000 | put | 35.0000 | 2026-11-20 | 1.5100 | 1.5100 | 1.5300 | 37.7150 | 23707.00 | 0.00 | 23707.00 | 157 | 8 | 932 | 64712 | 0.0144022746940289 | 0.442680603496537 | 0.442680603496537 | true | 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-21T15:55:19.311132Z"} |
| 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-21T16:17:50.496167Z"} |
| 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-21T18:03:10.492596Z"} |
| 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-21T18:03:10.492596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} |
| 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-25T17:59:30.582778Z"} |
| 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-02T18:05:44.095975Z"} |
| 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-04T13:45:37.268469Z"} |
| 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-10T13:52:43.061304Z"} |
| 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-14T17:44:35.656770Z"} |
| 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-14T18:18:53.599003Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |