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_alerts609,118 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 |
|---|
| 1d5fbc1c-882c-40db-a188-0587f4566314 | 2026-08-31 13:16 | 2026-08-31 13:16 | 2026-08-31 13:16 | SPXW | SPXW260902C07680000 | call | 7680.0000 | 2026-09-02 | 22.5000 | 22.2000 | 22.6000 | 7677.5400 | 225000.00 | 150750.00 | 74250.00 | 100 | 14 | 517 | 277 | 1.86642599277978 | 0.101084383506141 | 0.101084383506141 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c32d1991-36dd-42c6-a6a5-d4bb181f180e | 2026-09-02 10:44 | 2026-09-02 10:44 | 2026-09-02 10:44 | SPXW | SPXW260902C07680000 | call | 7680.0000 | 2026-09-02 | 10.0000 | 9.9000 | 10.1000 | 7679.5500 | 100000.00 | 74000.00 | 26000.00 | 100 | 11 | 32506 | 3405 | 9.54654919236417 | 0.134992810776064 | 0.134992810776064 | false | false | false | true | ||||||||||||||||
| d923893e-43e9-4044-b917-27ad3da058cd | 2026-09-02 11:26 | 2026-09-02 11:26 | 2026-09-02 11:26 | SPXW | SPXW260902C07680000 | call | 7680.0000 | 2026-09-02 | 7.2000 | 7.1000 | 7.3000 | 7678.2300 | 110130.00 | 92880.00 | 16530.00 | 153 | 34 | 47970 | 3405 | 14.0881057268722 | 0.112694543359147 | 0.114132652955313 | false | false | false | true | ||||||||||||||||
| e192c551-3a8c-4d5f-958c-04e4e2de51a7 | 2026-09-02 11:36 | 2026-09-02 11:36 | 2026-09-02 11:36 | SPXW | SPXW260902C07680000 | call | 7680.0000 | 2026-09-02 | 7.1600 | 7.0000 | 7.2000 | 7677.8000 | 114620.00 | 112490.00 | 0.00 | 160 | 40 | 53849 | 3405 | 15.814684287812 | 0.117830879285933 | 0.119295778697499 | true | false | false | true | ||||||||||||||||
| c32ea0c0-b2ae-467e-bd77-4427b95d04f4 | 2026-09-02 12:39 | 2026-09-02 12:39 | 2026-09-02 12:39 | SPXW | SPXW260902C07680000 | call | 7680.0000 | 2026-09-02 | 2.2200 | 2.1000 | 2.3000 | 7667.7300 | 100685.00 | 100235.00 | 450.00 | 453 | 48 | 80484 | 3405 | 23.6370044052863 | 0.108715345324238 | 0.11091816030309 | false | false | false | true | ||||||||||||||||
| 1262953c-6924-43fe-8eb3-8e88aaca7b1f | 2026-09-02 14:18 | 2026-09-02 14:18 | 2026-09-02 14:18 | SPXW | SPXW260902C07680000 | call | 7680.0000 | 2026-09-02 | 4.3100 | 3.0000 | 5.5000 | 7675.4100 | 115640.00 | 70290.00 | 44930.00 | 268 | 139 | 122102 | 3405 | 35.8596182085169 | 0.136097597439724 | 0.138644844537881 | false | false | false | true | ||||||||||||||||
| 3f3ead0c-64f6-40a3-9b3f-ff7f7454caee | 2026-09-02 14:19 | 2026-09-02 14:18 | 2026-09-02 14:18 | SPXW | SPXW260902C07680000 | call | 7680.0000 | 2026-09-02 | 3.5100 | 3.3000 | 4.8000 | 7676.7400 | 121300.00 | 1190.00 | 120110.00 | 346 | 129 | 122520 | 3405 | 35.9823788546256 | 0.116181980958982 | 0.128321189026335 | false | false | false | true | ||||||||||||||||
| 0b77220d-cb71-4ba8-90ed-e0d341021380 | 2026-09-02 14:19 | 2026-09-02 14:18 | 2026-09-02 14:18 | SPXW | SPXW260902C07680000 | call | 7680.0000 | 2026-09-02 | 3.1200 | 2.7000 | 4.1000 | 7673.4500 | 192245.00 | 18370.00 | 173155.00 | 617 | 289 | 123202 | 3405 | 36.1826725403818 | 0.103975672654412 | 0.146282440949697 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:56:20.498446Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |