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_alerts523,327 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 | expiry |
|---|
| 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 |
|---|
| ea92a18c-9e97-45d8-a34d-f356b052d421 | 2026-08-18 09:55 | 2026-08-18 09:55 | 2026-08-18 09:55 | TSLA | TSLA260821P00350000 | put | 350.0000 | 2026-08-21 | 14.3000 | 14.1500 | 14.3000 | 337.6000 | 142996.00 | 142996.00 | 0.00 | 100 | 12 | 1591 | 7807 | 0.203791469194313 | 0.510863548696445 | 0.510863548696445 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | 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 |
| e06eff78-96e0-46d5-893b-bd954b9bff5e | 2026-08-18 12:23 | 2026-08-18 12:23 | 2026-08-18 12:23 | TSLA | TSLA260821P00350000 | put | 350.0000 | 2026-08-21 | 13.4200 | 13.3500 | 13.5500 | 338.1400 | 134210.00 | 0.00 | 38715.00 | 100 | 6 | 6827 | 7807 | 0.87447162802613 | 0.45235106270383 | 0.463629861002165 | false | false | false | true | ||||||||||||||||
| ddb3145f-d282-4f12-9781-3ddb61822bcd | 2026-08-18 15:31 | 2026-08-18 15:31 | 2026-08-18 15:31 | TSLA | TSLA260821P00350000 | put | 350.0000 | 2026-08-21 | 14.4000 | 14.3500 | 14.5500 | 336.9501 | 144000.00 | 24480.00 | 119520.00 | 100 | 7 | 7689 | 7807 | 0.984885359292942 | 0.463729908293392 | 0.463729908293392 | false | false | false | true | ||||||||||||||||
| d6ee2fc1-f1fe-4494-8a43-ee996a15623f | 2026-08-19 15:22 | 2026-08-19 15:22 | 2026-08-19 15:22 | TSLA | TSLA260821P00350000 | put | 350.0000 | 2026-08-21 | 5.5500 | 5.4500 | 5.5500 | 348.4900 | 496123.00 | 496123.00 | 0.00 | 894 | 64 | 21192 | 7719 | 2.74543334628838 | 0.475143964371331 | 0.465187814151638 | false | false | false | true | ||||||||||||||||
| 2fb5b916-4c23-48f0-89cd-e2e1e6485aea | 2026-08-20 10:36 | 2026-08-20 10:36 | 2026-08-20 10:36 | TSLA | TSLA260821P00350000 | put | 350.0000 | 2026-08-21 | 11.0000 | 11.0000 | 11.2000 | 339.6400 | 110000.00 | 0.00 | 110000.00 | 100 | 5 | 25345 | 9029 | 2.8070661202791 | 0.528180259696298 | 0.528180259696298 | false | false | false | true | ||||||||||||||||
| 7beb0b76-198d-4238-8e4e-857f69c0a725 | 2026-08-20 12:10 | 2026-08-20 12:10 | 2026-08-20 12:10 | TSLA | TSLA260821P00350000 | put | 350.0000 | 2026-08-21 | 6.3000 | 6.3000 | 6.4000 | 345.3102 | 126000.00 | 0.00 | 126000.00 | 200 | 5 | 29741 | 9029 | 3.29394174327168 | 0.48089860461228 | 0.48089860461228 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1417769028024.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1417769028024.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1417769028024.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1417769028024.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1417769028024.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |