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 |
|---|
| 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 |
|---|
| d836e9a6-0499-4ded-9dcd-3737e1387620 | 2026-09-30 09:32 | 2026-09-30 09:32 | 2026-09-30 09:32 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 7.1000 | 7.1000 | 7.4000 | 185.2300 | 14200.00 | 0.00 | 14200.00 | 20 | 7 | 20 | 986 | 0.0202839756592292 | 0.446489845854554 | 0.446489845854554 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 26692687000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T13:33:11.727621Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| f76ab020-ef67-4834-8a95-8249d34d94f2 | 2026-09-29 10:09 | 2026-09-29 10:09 | 2026-09-29 10:09 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 7.5500 | 7.5500 | 8.4500 | 185.6000 | 16610.00 | 0.00 | 16610.00 | 22 | 9 | 22 | 983 | 0.0223804679552391 | 0.453661103608417 | 0.453661103608417 | true | false | false | |||||||||||||||||
| cba9e594-d4b4-4055-828d-236f729e4e28 | 2026-09-28 11:20 | 2026-09-28 11:20 | 2026-09-28 11:20 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 6.4000 | 6.2000 | 6.4000 | 181.0000 | 19840.00 | 19840.00 | 0.00 | 31 | 9 | 55 | 961 | 0.0572320499479709 | 0.461437186870578 | 0.461437186870578 | true | false | false | |||||||||||||||||
| 503c9883-a045-4512-8cb3-bb93dfbd8927 | 2026-09-25 09:35 | 2026-09-25 09:35 | 2026-09-25 09:35 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 8.0500 | 7.8000 | 8.0500 | 186.0700 | 45080.00 | 45080.00 | 0.00 | 56 | 15 | 104 | 896 | 0.116071428571429 | 0.447738910536475 | 0.447738910536475 | true | false | false | |||||||||||||||||
| 5bc9eeb2-8b1c-442d-a5cb-b15616561547 | 2026-09-25 09:31 | 2026-09-25 09:31 | 2026-09-25 09:31 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 7.9000 | 7.9000 | 8.2000 | 185.7800 | 36340.00 | 0.00 | 36340.00 | 46 | 14 | 46 | 896 | 0.0513392857142857 | 0.446360447294259 | 0.446360447294259 | true | false | false | |||||||||||||||||
| d4f1ea1d-91f3-43f7-bca1-e3b44a95a233 | 2026-09-24 14:52 | 2026-09-24 14:52 | 2026-09-24 14:52 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 7.0500 | 6.4000 | 7.3000 | 182.7100 | 11985.00 | 11280.00 | 705.00 | 17 | 7 | 85 | 914 | 0.0929978118161926 | 0.45257102953791 | 0.45257102953791 | false | false | false | |||||||||||||||||
| 51a4e074-92a6-42ec-aae8-98f746910aea | 2026-09-24 14:06 | 2026-09-24 14:06 | 2026-09-24 14:06 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 6.8000 | 6.6500 | 6.8500 | 182.0400 | 11560.00 | 11560.00 | 0.00 | 17 | 5 | 59 | 914 | 0.0645514223194748 | 0.451936274663088 | 0.451936274663088 | true | false | false | |||||||||||||||||
| 01bea951-ea33-4612-9767-4e07a8bf7cb3 | 2026-09-23 09:50 | 2026-09-23 09:50 | 2026-09-23 09:50 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 9.2000 | 9.0000 | 9.2000 | 187.7100 | 23000.00 | 23000.00 | 0.00 | 25 | 5 | 78 | 886 | 0.0880361173814898 | 0.456935550559324 | 0.456935550559324 | true | false | false | |||||||||||||||||
| 7d1732f1-24e1-44ee-93bc-9bca9c2cf02d | 2026-09-22 11:12 | 2026-09-22 11:12 | 2026-09-22 11:12 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 10.3500 | 10.3500 | 10.6000 | 190.3100 | 31050.00 | 0.00 | 31050.00 | 30 | 9 | 121 | 923 | 0.131094257854821 | 0.454034429724905 | 0.454034429724905 | false | false | false | |||||||||||||||||
| 801e06cd-1c85-42bf-82c3-a3a2a1ed857a | 2026-09-22 10:01 | 2026-09-22 10:00 | 2026-09-22 10:00 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 10.9000 | 10.9000 | 11.1500 | 191.0000 | 44690.00 | 0.00 | 44690.00 | 41 | 8 | 54 | 923 | 0.0585048754062839 | 0.459608625223276 | 0.459608625223276 | false | false | false | |||||||||||||||||
| a5aedd59-177e-4936-aed8-a458e7569eae | 2026-09-21 10:03 | 2026-09-21 10:02 | 2026-09-21 10:02 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 9.1500 | 9.0500 | 9.4000 | 187.0000 | 24710.00 | 1835.00 | 22875.00 | 27 | 9 | 27 | 936 | 0.0288461538461538 | 0.456868292480988 | 0.458566861562691 | true | false | false | |||||||||||||||||
| 647933a0-218d-4739-b02c-e0e54d922fde | 2026-09-14 10:28 | 2026-09-14 10:28 | 2026-09-14 10:28 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 7.3000 | 7.0000 | 7.8000 | 177.3500 | 37230.00 | 0.00 | 36500.00 | 51 | 21 | 56 | 845 | 0.0662721893491124 | 0.490151787626577 | 0.490151787626577 | false | false | false | |||||||||||||||||
| 912bcbfb-6211-47ce-b715-3e497aa528cb | 2026-09-11 13:57 | 2026-09-11 13:57 | 2026-09-11 13:57 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 11.7500 | 11.3000 | 12.3500 | 189.7100 | 44655.00 | 8225.00 | 30555.00 | 38 | 16 | 424 | 956 | 0.443514644351464 | 0.46519240548037 | 0.46519240548037 | true | false | false | |||||||||||||||||
| 3aa9c95a-6e6f-4ad7-9314-5ee3ebc0e3ec | 2026-09-11 11:02 | 2026-09-11 11:02 | 2026-09-11 11:02 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 11.5000 | 11.3500 | 11.5000 | 188.8700 | 21850.00 | 21850.00 | 0.00 | 19 | 5 | 382 | 956 | 0.399581589958159 | 0.469059107783095 | 0.469059107783095 | false | false | false | |||||||||||||||||
| f66098c5-b28b-4c9c-a25c-1ab3b5919813 | 2026-09-11 11:02 | 2026-09-11 11:02 | 2026-09-11 11:02 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 11.5100 | 11.5000 | 11.8500 | 188.8000 | 57532.00 | 0.00 | 57532.00 | 50 | 8 | 330 | 956 | 0.345188284518828 | 0.470011706422001 | 0.470011706422001 | false | false | false | |||||||||||||||||
| bd817ed3-2cb3-4b53-87e0-b43f4dc9ff78 | 2026-09-11 11:00 | 2026-09-11 11:00 | 2026-09-11 11:00 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 11.3000 | 11.3000 | 11.6500 | 188.5100 | 28250.00 | 0.00 | 28250.00 | 25 | 6 | 236 | 956 | 0.246861924686192 | 0.467815280312996 | 0.467815280312996 | false | false | false | |||||||||||||||||
| 0f0c6c0f-1faf-4ce7-b750-d08c4acfd1cf | 2026-08-27 15:25 | 2026-08-27 15:25 | 2026-08-27 15:25 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 9.5000 | 9.5000 | 10.5000 | 180.0000 | 33250.00 | 0.00 | 33250.00 | 35 | 9 | 37 | 432 | 0.0856481481481482 | 0.467847887564252 | 0.467847887564252 | false | false | false | |||||||||||||||||
| baa923d1-03a7-4f61-8046-b2c23aad567b | 2026-08-19 10:47 | 2026-08-19 10:47 | 2026-08-19 10:47 | EWY | EWY261120C00200000 | call | 200.0000 | 2026-11-20 | 10.2000 | 9.4000 | 10.2000 | 174.1400 | 76500.00 | 76500.00 | 0.00 | 75 | 23 | 151 | 226 | 0.668141592920354 | 0.533572013629985 | 0.533572013629985 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26241574562.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:10:17.656675Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26898842873.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:21:41.621308Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26262034779.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:35:49.891887Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26262034779.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:31:26.059584Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27420786707.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:57:49.526864Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27420786707.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:09:26.312126Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27420786707.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:50:57.741684Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27365088480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:15:45.651673Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27365088480.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:01:27.900775Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26287352023.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:04:59.983035Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 28584308397.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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 28584308397.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T18:02:32.717866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 28584308397.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:05:41.395170Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 28584308397.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:05:41.395170Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 28584308397.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:05:41.395170Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:35:44.109119Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:50:22.027850Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |