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_alerts281,039 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 |
|---|
| cc6cf2db-839c-4c09-b2a6-e56859a505b6 | 2026-08-27 10:54 | 2026-08-27 10:53 | 2026-08-27 10:53 | KHC | KHC261016P00025000 | put | 25.0000 | 2026-10-16 | 1.0600 | 1.0200 | 1.0600 | 25.1450 | 60314.00 | 60314.00 | 0.00 | 569 | 36 | 602 | 2498 | 0.240992794235388 | 0.32311045054578 | 0.32311045054578 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 28779942607.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T15:06:04.251678Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3f0b627f-eecf-4b01-833e-ba6df5d016e0 | 2026-08-27 10:05 | 2026-08-27 10:05 | 2026-08-27 10:05 | KHC | KHC270917C00027500 | call | 27.5000 | 2027-09-17 | 1.8200 | 1.7300 | 1.8200 | 24.9750 | 27300.00 | 27300.00 | 0.00 | 150 | 8 | 150 | 32 | 4.6875 | 0.231453910465261 | 0.231453910465261 | false | false | false | true | false | |||||||||||||||
| b288c1da-f256-49a6-a4ac-d9507eb61461 | 2026-08-26 12:12 | 2026-08-26 12:12 | 2026-08-26 12:12 | KHC | KHC261016C00025000 | call | 25.0000 | 2026-10-16 | 0.6400 | 0.6100 | 0.6400 | 24.5100 | 43264.00 | 43264.00 | 0.00 | 676 | 33 | 977 | 5031 | 0.194195984893659 | 0.219044027022556 | 0.219044027022556 | false | false | false | true | false | |||||||||||||||
| 10fb86ab-bfda-4292-993f-b7d9ae24d2be | 2026-08-26 12:07 | 2026-08-26 12:07 | 2026-08-26 12:07 | KHC | KHC261016P00025000 | put | 25.0000 | 2026-10-16 | 1.4000 | 1.4000 | 1.4300 | 24.4750 | 11480.00 | 0.00 | 11480.00 | 82 | 10 | 239 | 2327 | 0.102707348517404 | 0.323861486888158 | 0.324587455750874 | false | false | false | true | false | |||||||||||||||
| 101d9cce-5f50-4bb7-ad9c-dd655b3afdf7 | 2026-08-26 10:41 | 2026-08-26 10:41 | 2026-08-26 10:41 | KHC | KHC260918P00024500 | put | 24.5000 | 2026-09-18 | 0.7300 | 0.7200 | 0.7300 | 24.6927 | 14892.00 | 14892.00 | 0.00 | 204 | 19 | 398 | 78 | 5.1025641025641 | 0.345468474821746 | 0.345468474821746 | false | false | false | true | false | |||||||||||||||
| fd6774ab-dfc6-4858-8d19-11c94d743d78 | 2026-08-26 10:40 | 2026-08-26 10:40 | 2026-08-26 10:40 | KHC | KHC260828C00025000 | call | 25.0000 | 2026-08-28 | 0.1300 | 0.1000 | 0.1300 | 24.6750 | 14066.00 | 14066.00 | 0.00 | 1082 | 33 | 2167 | 1226 | 1.76753670473083 | 0.353318505986262 | 0.353318505986262 | false | false | false | true | false | |||||||||||||||
| 5eaa2d22-ddb7-4ac1-b1e0-f2a809166ead | 2026-08-25 14:59 | 2026-08-25 14:59 | 2026-08-25 14:59 | KHC | KHC261016C00025000 | call | 25.0000 | 2026-10-16 | 0.9700 | 0.9500 | 0.9700 | 25.1899 | 94478.00 | 94478.00 | 0.00 | 974 | 27 | 1103 | 4031 | 0.273629372364178 | 0.211555031130362 | 0.211555031130362 | false | false | false | true | false | |||||||||||||||
| 960af944-9523-44cd-b612-526690e1440e | 2026-08-25 12:09 | 2026-08-25 12:09 | 2026-08-25 12:09 | KHC | KHC270617P00025000 | put | 25.0000 | 2027-06-17 | 2.5700 | 2.5600 | 2.7400 | 25.3150 | 16709.00 | 258.00 | 16451.00 | 65 | 17 | 365 | 579 | 0.630397236614853 | 0.348993380064889 | 0.349872655752343 | true | false | false | true | false | |||||||||||||||
| 33df34b2-9a82-425e-beb9-1f5947b241b5 | 2026-08-24 15:37 | 2026-08-24 15:37 | 2026-08-24 15:37 | KHC | KHC280121P00022500 | put | 22.5000 | 2028-01-21 | 2.0800 | 2.0000 | 2.1100 | 25.6750 | 15631.00 | 15631.00 | 0.00 | 75 | 6 | 248 | 3946 | 0.0628484541307653 | 0.357750620608162 | 0.356725847137653 | false | false | false | true | false | |||||||||||||||
| a24f158c-d120-4fd6-a588-e560148c9c8c | 2026-08-21 14:19 | 2026-08-21 14:19 | 2026-08-21 14:19 | KHC | KHC261016P00025000 | put | 25.0000 | 2026-10-16 | 0.9000 | 0.9000 | 0.9400 | 25.0000 | 53910.00 | 0.00 | 53910.00 | 599 | 17 | 683 | 1749 | 0.390508862206975 | 0.313495575448872 | 0.313495575448872 | false | false | false | true | false | |||||||||||||||
| 0567d480-27b1-4be0-bbc3-e9e63a6fb6ae | 2026-08-21 11:02 | 2026-08-21 11:02 | 2026-08-21 11:02 | KHC | KHC261218C00025000 | call | 25.0000 | 2026-12-18 | 1.8800 | 1.8600 | 1.9500 | 25.7213 | 156040.00 | 2445.00 | 153408.00 | 830 | 42 | 860 | 7773 | 0.110639392769844 | 0.226097839764571 | 0.224260571655312 | false | false | false | true | false | |||||||||||||||
| 0dddea3d-c6ea-4168-b098-8a67880373f3 | 2026-08-20 15:57 | 2026-08-20 15:57 | 2026-08-20 15:57 | KHC | KHC260918P00025000 | put | 25.0000 | 2026-09-18 | 0.7400 | 0.7100 | 0.7400 | 25.4800 | 11100.00 | 11100.00 | 0.00 | 150 | 14 | 620 | 5908 | 0.104942450914015 | 0.35047398043122 | 0.35047398043122 | false | false | false | true | false | |||||||||||||||
| 502955d7-4337-403e-a7cf-d97f48f589ea | 2026-08-20 15:41 | 2026-08-20 15:40 | 2026-08-20 15:40 | KHC | KHC261218P00022500 | put | 22.5000 | 2026-12-18 | 0.6000 | 0.6000 | 0.6700 | 25.6250 | 12120.00 | 0.00 | 12120.00 | 202 | 13 | 385 | 5511 | 0.0698602794411178 | 0.333464623684112 | 0.333464623684112 | false | false | false | true | false | |||||||||||||||
| 89ee7e66-a10d-4ba4-b430-a252c239f1bc | 2026-08-20 10:59 | 2026-08-20 10:59 | 2026-08-20 10:59 | KHC | KHC270617C00030000 | call | 30.0000 | 2027-06-17 | 1.0800 | 0.9400 | 1.2300 | 25.4150 | 12312.00 | 11232.00 | 1080.00 | 114 | 11 | 114 | 1207 | 0.0944490472245236 | 0.252236299569952 | 0.252236299569952 | false | false | false | true | false | |||||||||||||||
| 779710f4-5591-4935-a22b-5ba4c69c5985 | 2026-08-19 10:01 | 2026-08-19 10:01 | 2026-08-19 10:01 | KHC | KHC261218C00027500 | call | 27.5000 | 2026-12-18 | 0.7700 | 0.7700 | 0.8200 | 25.4250 | 30877.00 | 0.00 | 30877.00 | 401 | 18 | 409 | 5985 | 0.0683375104427736 | 0.244158575730569 | 0.244158575730569 | false | false | false | true | false | |||||||||||||||
| 81ae3026-c59f-445e-9b59-b3169213d3c7 | 2026-08-18 13:30 | 2026-08-18 13:30 | 2026-08-18 13:30 | KHC | KHC280121C00027500 | call | 27.5000 | 2028-01-21 | 2.4700 | 2.3300 | 2.4800 | 24.9850 | 12367.00 | 12367.00 | 0.00 | 50 | 6 | 59 | 3195 | 0.0184663536776213 | 0.241325532577143 | 0.240485662161348 | false | false | false | true | false | |||||||||||||||
| 209fa8fa-9d1f-4a1b-bc58-153c9ac28d3a | 2026-08-18 09:57 | 2026-08-18 09:57 | 2026-08-18 09:57 | KHC | KHC260918C00025000 | call | 25.0000 | 2026-09-18 | 0.7400 | 0.6600 | 0.7400 | 25.0050 | 69424.00 | 28872.00 | 0.00 | 942 | 18 | 967 | 13965 | 0.0692445399212317 | 0.244505809815974 | 0.233022122720152 | false | false | false | true | false | |||||||||||||||
| 01de27db-f149-4ebb-9fa2-7f1dbad9f671 | 2026-08-18 09:57 | 2026-08-18 09:57 | 2026-08-18 09:57 | KHC | KHC260918C00025000 | call | 25.0000 | 2026-09-18 | 0.7400 | 0.6600 | 0.7600 | 25.0050 | 296456.00 | 2232.00 | 294224.00 | 4007 | 9 | 5025 | 13965 | 0.359828141783029 | 0.233022122720152 | 0.239926221127247 | false | false | false | true | false | |||||||||||||||
| ad76f2c7-a262-425e-bac2-db1443d6bfcd | 2026-08-17 15:46 | 2026-08-17 15:46 | 2026-08-17 15:46 | KHC | KHC260828C00025500 | call | 25.5000 | 2026-08-28 | 0.2000 | 0.1800 | 0.2000 | 24.7250 | 17460.00 | 17460.00 | 0.00 | 873 | 22 | 918 | 455 | 2.01758241758242 | 0.278669934492201 | 0.278669934492201 | false | false | false | true | false | |||||||||||||||
| ceac2982-93a2-4ba9-9d82-de3c6701bacb | 2026-08-17 14:43 | 2026-08-17 14:43 | 2026-08-17 14:43 | KHC | KHC260828P00024500 | put | 24.5000 | 2026-08-28 | 0.3400 | 0.3000 | 0.3400 | 24.7650 | 12410.00 | 12410.00 | 0.00 | 365 | 25 | 540 | 279 | 1.93548387096774 | 0.276916831603387 | 0.276916831603387 | false | false | false | true | false | |||||||||||||||
| 2d47ad44-10c3-4a6b-b53f-3297d2723ac7 | 2026-08-17 11:44 | 2026-08-17 11:43 | 2026-08-17 11:43 | KHC | KHC260911P00025000 | put | 25.0000 | 2026-09-11 | 0.9400 | 0.8300 | 0.9400 | 24.8650 | 40419.00 | 40326.00 | 0.00 | 430 | 28 | 434 | 35 | 12.4 | 0.348025816155654 | 0.344173503659518 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:11:49.813441Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T19:21:53.483381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:29:52.792110Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:47:47.207382Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:59:19.634890Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:02:58.462752Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| 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 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:59:29.758034Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 28779942607.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |