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 |
|---|
| 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 |
|---|
| d8f62542-0013-4ee7-9b66-4c4b99ea4924 | 2026-08-21 10:31 | 2026-08-21 10:31 | 2026-08-21 10:31 | BABA | BABA261120C00160000 | call | 160.0000 | 2026-11-20 | 2.2100 | 2.2000 | 2.2100 | 120.8600 | 131716.00 | 131716.00 | 0.00 | 596 | 12 | 50605 | 1612 | 31.3926799007444 | 0.485268797387081 | 0.485268797387081 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Consumer Cyclical | 253691785216.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9ae9a971-ca96-46bc-a084-3812d972ef00 | 2026-08-21 10:31 | 2026-08-21 10:31 | 2026-08-21 10:31 | BABA | BABA261120C00160000 | call | 160.0000 | 2026-11-20 | 2.2100 | 2.2000 | 2.2100 | 120.8400 | 99229.00 | 99229.00 | 0.00 | 449 | 6 | 51054 | 1612 | 31.6712158808933 | 0.485486482940128 | 0.485486482940128 | false | false | false | true | ||||||||||||||||
| 69535f06-94be-4b81-a0c0-62e018752206 | 2026-08-21 10:31 | 2026-08-21 10:31 | 2026-08-21 10:31 | BABA | BABA261120C00160000 | call | 160.0000 | 2026-11-20 | 2.2200 | 2.2100 | 2.2200 | 120.9000 | 61272.00 | 61272.00 | 0.00 | 276 | 5 | 51687 | 1612 | 32.0638957816377 | 0.485515103350554 | 0.485515103350554 | false | false | false | true | ||||||||||||||||
| 32c34922-b0bb-477f-b6be-6fda21843c05 | 2026-08-21 10:32 | 2026-08-21 10:32 | 2026-08-21 10:32 | BABA | BABA261120C00160000 | call | 160.0000 | 2026-11-20 | 2.2100 | 2.2100 | 2.2200 | 120.9150 | 70720.00 | 0.00 | 70720.00 | 320 | 12 | 52117 | 1612 | 32.3306451612903 | 0.484724677379174 | 0.484670272745333 | false | false | false | true | ||||||||||||||||
| 80ab58c1-e008-497a-95e6-7b34b224e748 | 2026-08-21 12:47 | 2026-08-21 12:47 | 2026-08-21 12:47 | BABA | BABA261120C00160000 | call | 160.0000 | 2026-11-20 | 2.2600 | 2.2600 | 2.3000 | 121.0499 | 1024684.00 | 0.00 | 1024684.00 | 4534 | 9 | 64042 | 1612 | 39.7282878411911 | 0.48659191477429 | 0.48659191477429 | false | false | false | true | ||||||||||||||||
| c624264e-e72a-42b7-a9f3-acae425599f6 | 2026-08-21 13:02 | 2026-08-21 13:02 | 2026-08-21 13:02 | BABA | BABA261120C00160000 | call | 160.0000 | 2026-11-20 | 2.2700 | 2.2600 | 2.2700 | 120.8450 | 90629.00 | 51983.00 | 38646.00 | 400 | 25 | 66518 | 1612 | 41.2642679900744 | 0.488831180862077 | 0.489507545211258 | false | false | false | true | ||||||||||||||||
| 4ce4aede-5efb-4aba-823d-05e9edadfa10 | 2026-08-21 15:59 | 2026-08-21 15:59 | 2026-08-21 15:59 | BABA | BABA261120C00160000 | call | 160.0000 | 2026-11-20 | 2.0400 | 2.0400 | 2.1000 | 119.4900 | 61608.00 | 0.00 | 61608.00 | 302 | 24 | 75629 | 1612 | 46.916253101737 | 0.48815497342102 | 0.488208897903987 | false | false | false | true | ||||||||||||||||
| dfe54602-55d3-4a81-b5c5-8470377e74da | 2026-08-21 16:00 | 2026-08-21 15:59 | 2026-08-21 15:59 | BABA | BABA261120C00160000 | call | 160.0000 | 2026-11-20 | 2.0300 | 2.0200 | 2.1000 | 119.3300 | 55825.00 | 7714.00 | 48111.00 | 275 | 7 | 76284 | 1612 | 47.3225806451613 | 0.489214272059572 | 0.489214272059572 | false | false | false | true | ||||||||||||||||
| d1f78f78-1e93-41b3-a712-bf2588e5e5fb | 2026-08-21 16:00 | 2026-08-21 15:59 | 2026-08-21 15:59 | BABA | BABA261120C00160000 | call | 160.0000 | 2026-11-20 | 2.0300 | 2.0200 | 2.1000 | 119.3300 | 56840.00 | 15428.00 | 41412.00 | 280 | 17 | 76009 | 1612 | 47.1519851116625 | 0.489214272059572 | 0.489214272059572 | false | false | false | true | ||||||||||||||||
| 1b49d05f-19c4-43b6-a2e1-b7d5a45ce003 | 2026-08-24 11:16 | 2026-08-24 11:16 | 2026-08-24 11:16 | BABA | BABA261120C00160000 | call | 160.0000 | 2026-11-20 | 2.1500 | 1.9900 | 2.1700 | 119.0800 | 59340.00 | 59340.00 | 0.00 | 276 | 21 | 9122 | 57572 | 0.158445077468214 | 0.509336404437612 | 0.509336404437612 | true | false | false | true | ||||||||||||||||
| 7e17335b-3601-4024-9f45-2ff5ad380398 | 2026-08-26 12:42 | 2026-08-26 12:42 | 2026-08-26 12:42 | BABA | BABA261120C00160000 | call | 160.0000 | 2026-11-20 | 2.0100 | 2.0100 | 2.1500 | 120.2400 | 55275.00 | 0.00 | 55275.00 | 275 | 5 | 465 | 61000 | 0.00762295081967213 | 0.492820885131409 | 0.492820885131409 | false | false | false | true | ||||||||||||||||
| 48650df5-f9ca-4969-83d0-1bbd686f0ef5 | 2026-09-21 10:05 | 2026-09-21 10:05 | 2026-09-21 10:05 | BABA | BABA261120C00160000 | call | 160.0000 | 2026-11-20 | 0.7500 | 0.6900 | 0.7600 | 113.7900 | 15000.00 | 14925.00 | 75.00 | 200 | 10 | 315 | 60472 | 0.00520902235745469 | 0.531447906987536 | 0.530989427320965 | false | false | false | true | ||||||||||||||||
| 50eaa027-fc5e-460f-849f-243ef382606e | 2026-09-22 10:02 | 2026-09-22 10:02 | 2026-09-22 10:02 | BABA | BABA261120C00160000 | call | 160.0000 | 2026-11-20 | 1.0000 | 1.0000 | 1.1100 | 118.5009 | 24641.00 | 3131.00 | 21510.00 | 246 | 43 | 560 | 60390 | 0.00927305845338632 | 0.515816131950205 | 0.516577992426276 | true | false | false | true | ||||||||||||||||
| 4e3e6381-ce9d-4388-8046-8adc4f1fd61f | 2026-09-22 12:27 | 2026-09-22 12:27 | 2026-09-22 12:27 | BABA | BABA261120C00160000 | call | 160.0000 | 2026-11-20 | 0.7800 | 0.7800 | 0.8000 | 116.2750 | 15600.00 | 0.00 | 15600.00 | 200 | 18 | 1588 | 60390 | 0.0262957443285312 | 0.511548725040002 | 0.511548725040002 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:29:12.492303Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 253691785216.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:52:20.196728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 268834790248.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:06:26.378716Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Consumer Cyclical |
| 270135416447.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:04:08.107942Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Consumer Cyclical |
| 270135416447.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:27:20.551854Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |