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.
Simplify Analyticsuw_flow_alerts425,429 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 |
|---|
| 39174d0d-2a5d-4d99-90a1-91a392bf2915 | 2026-08-19 11:18 | 2026-08-19 11:18 | 2026-08-19 11:18 | WMT | WMT260911C00117000 | call | 117.0000 | 2026-09-11 | 3.2000 | 3.2000 | 3.3000 | 116.3750 | 112960.00 | 0.00 | 112960.00 | 353 | 6 | 8617 | 99 | 87.040404040404 | 0.288838118308716 | 0.288838118308716 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 865413039968.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e0e7b318-95e6-433f-a649-dfc45197f000 | 2026-08-19 11:18 | 2026-08-19 11:17 | 2026-08-19 11:18 | WMT | WMT260911C00117000 | call | 117.0000 | 2026-09-11 | 3.2000 | 3.2000 | 3.3000 | 116.3650 | 130092.00 | 0.00 | 130092.00 | 406 | 27 | 7964 | 99 | 80.4444444444444 | 0.289051776233613 | 0.290981627518577 | false | false | false | true | ||||||||||||||||
| 2642122d-528a-4abc-a959-25325224afdd | 2026-08-19 11:15 | 2026-08-19 11:15 | 2026-08-19 11:15 | WMT | WMT260911C00117000 | call | 117.0000 | 2026-09-11 | 3.3000 | 3.3000 | 3.3500 | 116.4900 | 135630.00 | 0.00 | 135630.00 | 411 | 13 | 7383 | 99 | 74.5757575757576 | 0.292473350313802 | 0.292473350313802 | false | false | false | true | ||||||||||||||||
| 432884cf-b9f0-4789-be94-3bde5fb8b374 | 2026-08-19 11:11 | 2026-08-19 11:11 | 2026-08-19 11:11 | WMT | WMT260821P00120000 | put | 120.0000 | 2026-08-21 | 4.9600 | 4.8000 | 5.0500 | 116.5500 | 248000.00 | 248000.00 | 0.00 | 500 | 5 | 2074 | 5665 | 0.366107678729038 | 0.84057601097187 | 0.84057601097187 | false | false | false | true | ||||||||||||||||
| 8a98b85d-e986-41d5-a024-21081bd7be51 | 2026-08-19 11:10 | 2026-08-19 11:10 | 2026-08-19 11:10 | WMT | WMT260911C00117000 | call | 117.0000 | 2026-09-11 | 3.3500 | 3.3000 | 3.4500 | 116.5400 | 184910.00 | 670.00 | 179885.00 | 552 | 34 | 5716 | 99 | 57.7373737373737 | 0.29459421154486 | 0.29459421154486 | true | false | false | true | ||||||||||||||||
| 98a17055-3f44-491c-b1b9-ca3efb6a85ba | 2026-08-19 11:05 | 2026-08-19 11:05 | 2026-08-19 11:05 | WMT | WMT260911C00117000 | call | 117.0000 | 2026-09-11 | 3.5000 | 3.5000 | 3.5500 | 116.7100 | 144200.00 | 0.00 | 144200.00 | 412 | 15 | 4227 | 99 | 42.6969696969697 | 0.300009504060701 | 0.300009504060701 | false | false | false | true | ||||||||||||||||
| 533c011b-8192-40de-a632-a1ca860dc7d7 | 2026-08-19 10:22 | 2026-08-19 10:22 | 2026-08-19 10:22 | WMT | WMT270617C00120000 | call | 120.0000 | 2027-06-17 | 11.7000 | 11.1000 | 11.9500 | 116.7780 | 124020.00 | 124020.00 | 0.00 | 106 | 8 | 274 | 2765 | 0.0990958408679928 | 0.269507036362442 | 0.269507036362442 | false | false | false | true | ||||||||||||||||
| ff9afb5c-15f0-42d7-9aae-7bbaf2a25d86 | 2026-08-18 13:30 | 2026-08-18 13:30 | 2026-08-18 13:30 | WMT | WMT260821P00115000 | put | 115.0000 | 2026-08-21 | 2.7200 | 2.6800 | 2.7200 | 115.4500 | 138176.00 | 138176.00 | 0.00 | 508 | 50 | 1669 | 13161 | 0.126814071879037 | 0.709673446489493 | 0.709673446489493 | false | false | false | true | ||||||||||||||||
| 890c80f4-0313-44cf-a2f9-02ddf7ec844a | 2026-08-18 11:46 | 2026-08-18 11:46 | 2026-08-18 11:46 | WMT | WMT260828C00120000 | call | 120.0000 | 2026-08-28 | 1.6000 | 1.5900 | 1.6500 | 115.5500 | 159687.00 | 1287.00 | 158400.00 | 998 | 41 | 1269 | 2731 | 0.464664957890882 | 0.427163921010791 | 0.427863358734172 | false | false | false | true | ||||||||||||||||
| a47f819f-d962-4e7b-80af-53bab8838899 | 2026-08-18 10:21 | 2026-08-18 10:21 | 2026-08-18 10:21 | WMT | WMT260904C00102000 | call | 102.0000 | 2026-09-04 | 13.6500 | 12.4500 | 13.6500 | 115.4500 | 167895.00 | 167895.00 | 0.00 | 123 | 5 | 123 | 152 | 0.809210526315789 | 0.250666323262845 | 0.250666323262845 | true | false | false | true | ||||||||||||||||
| 5263db2d-1ab8-4a23-9b92-2b6f5770691b | 2026-08-17 14:56 | 2026-08-17 14:55 | 2026-08-17 14:55 | WMT | WMT260821C00116000 | call | 116.0000 | 2026-08-21 | 2.0300 | 2.0300 | 2.1100 | 114.0201 | 340228.00 | 0.00 | 340228.00 | 1676 | 69 | 2396 | 1920 | 1.24791666666667 | 0.60272651748371 | 0.60272651748371 | false | false | false | true | ||||||||||||||||
| d30b757c-f50f-441d-adea-4475631f1e56 | 2026-08-17 13:47 | 2026-08-17 13:47 | 2026-08-17 13:47 | WMT | WMT260918P00115000 | put | 115.0000 | 2026-09-18 | 4.3500 | 4.2000 | 4.4000 | 114.0000 | 366696.00 | 361911.00 | 4785.00 | 843 | 50 | 1476 | 8338 | 0.177020868313744 | 0.303544017867362 | 0.305958823456609 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 865413039968.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 865413039968.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 865413039968.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 865413039968.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 865413039968.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 865413039968.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 865413039968.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 865413039968.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 865413039968.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 865413039968.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 865413039968.00 |
| 2026-11-19 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |