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_alerts326,449 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 | price |
|---|
| 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 |
|---|
| a67702db-afc1-48cf-ad85-e8b15728e7db | 2026-09-22 14:39 | 2026-09-22 14:39 | 2026-09-22 14:39 | UBER | UBER261002C00071000 | call | 71.0000 | 2026-10-02 | 1.0200 | 1.0200 | 1.0800 | 69.6050 | 10200.00 | 0.00 | 10200.00 | 100 | 10 | 788 | 770 | 1.02337662337662 | 0.343393693498337 | 0.343393693498337 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 142754526857.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T18:44:24.241276Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 6bf2f64a-8a55-4860-bab4-659f35ca7619 | 2026-09-22 14:51 | 2026-09-22 14:51 | 2026-09-22 14:51 | UBER | UBER270917C00090000 | call | 90.0000 | 2027-09-17 | 5.7500 | 5.6500 | 5.8000 | 69.6600 | 422693.00 | 396728.00 | 25965.00 | 735 | 55 | 760 | 1815 | 0.418732782369146 | 0.402712828584273 | 0.402396825657156 | true | false | false | true | false | |||||||||||||||
| 79380037-e712-4686-947b-3a026f18204c | 2026-09-22 14:52 | 2026-09-22 14:51 | 2026-09-22 14:51 | UBER | UBER270917C00090000 | call | 90.0000 | 2027-09-17 | 5.7700 | 5.6500 | 5.8000 | 69.6500 | 49045.00 | 38082.00 | 10963.00 | 85 | 5 | 1065 | 1815 | 0.586776859504132 | 0.402538524597471 | 0.402538524597471 | false | false | false | true | false | |||||||||||||||
| d8b951c6-b678-4260-aa2e-92ce88201aa6 | 2026-09-22 14:59 | 2026-09-22 14:59 | 2026-09-22 14:59 | UBER | UBER260925C00070000 | call | 70.0000 | 2026-09-25 | 0.8000 | 0.7900 | 0.8100 | 69.5700 | 31200.00 | 25600.00 | 5600.00 | 390 | 10 | 5107 | 973 | 5.24871531346351 | 0.389780815667386 | 0.392447779568731 | false | false | false | true | false | |||||||||||||||
| 03480b52-eba2-4bf7-8937-40e76bac32cd | 2026-09-22 15:05 | 2026-09-22 15:04 | 2026-09-22 15:04 | UBER | UBER270617C00085000 | call | 85.0000 | 2027-06-17 | 5.1500 | 4.9500 | 5.5000 | 69.6800 | 78280.00 | 72615.00 | 5665.00 | 152 | 14 | 166 | 1494 | 0.111111111111111 | 0.396940984653709 | 0.396940984653709 | true | false | false | true | false | |||||||||||||||
| b209f9dd-3019-413b-8e5c-2edd85e54635 | 2026-09-22 15:05 | 2026-09-22 15:05 | 2026-09-22 15:05 | UBER | UBER270617C00082500 | call | 82.5000 | 2027-06-17 | 5.8800 | 5.6000 | 6.1500 | 69.6900 | 50018.00 | 43528.00 | 6490.00 | 85 | 7 | 87 | 619 | 0.140549273021002 | 0.400985782669055 | 0.400985782669055 | false | false | false | true | false | |||||||||||||||
| 27394693-94ec-4ae7-a47c-8a2cf996b3d3 | 2026-09-22 15:09 | 2026-09-22 15:09 | 2026-09-22 15:09 | UBER | UBER261120P00062500 | put | 62.5000 | 2026-11-20 | 1.4100 | 1.3900 | 1.4700 | 69.7399 | 13363.00 | 140.00 | 13083.00 | 95 | 14 | 386 | 2843 | 0.135772071755188 | 0.394554568576432 | 0.393567388244214 | false | false | false | true | false | |||||||||||||||
| 99f30acc-3943-4aa6-b92d-be34043714a8 | 2026-09-22 15:19 | 2026-09-22 15:19 | 2026-09-22 15:19 | UBER | UBER270917C00100000 | call | 100.0000 | 2027-09-17 | 3.9500 | 3.9500 | 4.0500 | 69.7756 | 163925.00 | 0.00 | 23700.00 | 415 | 6 | 658 | 1430 | 0.46013986013986 | 0.402664829939746 | 0.402664829939746 | false | false | false | true | false | |||||||||||||||
| dbb52e32-b9ad-4ffd-8562-dee4995a2c1a | 2026-09-22 15:27 | 2026-09-22 15:27 | 2026-09-22 15:27 | UBER | UBER270319C00070000 | call | 70.0000 | 2027-03-19 | 8.4000 | 8.2000 | 8.4000 | 70.0501 | 29400.00 | 29400.00 | 0.00 | 35 | 5 | 336 | 1903 | 0.176563321071992 | 0.396479891258331 | 0.396479891258331 | false | false | false | true | false | |||||||||||||||
| 1ff9d5b3-bd24-4aca-95ff-10912592a532 | 2026-09-22 15:29 | 2026-09-22 15:29 | 2026-09-22 15:29 | UBER | UBER260925C00066000 | call | 66.0000 | 2026-09-25 | 4.2000 | 4.1000 | 4.3500 | 70.0000 | 42019.00 | 0.00 | 42019.00 | 100 | 5 | 208 | 110 | 1.89090909090909 | 0.436705880233872 | 0.436705880233872 | false | false | false | true | false | |||||||||||||||
| 91e0af60-aef3-4857-9a8a-5a69e9f68668 | 2026-09-22 15:40 | 2026-09-22 15:40 | 2026-09-22 15:40 | UBER | UBER261120C00085000 | call | 85.0000 | 2026-11-20 | 0.7800 | 0.7400 | 0.7800 | 70.0900 | 77751.00 | 77751.00 | 0.00 | 1000 | 61 | 2774 | 6148 | 0.451203643461288 | 0.404286346952591 | 0.402488652020552 | true | false | false | true | false | |||||||||||||||
| 8132c760-1681-47ed-9d86-8a1ab46e3dc8 | 2026-09-22 15:49 | 2026-09-22 15:48 | 2026-09-22 15:48 | UBER | UBER261016C00072500 | call | 72.5000 | 2026-10-16 | 1.5300 | 1.4900 | 1.5300 | 70.1750 | 35037.00 | 35037.00 | 0.00 | 229 | 26 | 1297 | 3514 | 0.369095048377917 | 0.336507014604446 | 0.336507014604446 | false | false | false | true | false |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 142754526857.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:55:20.077577Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 142754526857.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:55:20.077577Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 142754526857.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:02:38.336545Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 142754526857.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:10:39.996631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 142754526857.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:10:39.996631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 142754526857.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:10:39.996631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 142754526857.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:23:17.824277Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 142754526857.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:27:59.988967Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 142754526857.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:33:11.786837Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 142754526857.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 142754526857.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:49:40.866869Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |