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_alerts658,639 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 |
|---|
| 1a2a0549-d86a-4c34-b64b-f19354af9376 | 2026-09-03 12:17 | 2026-09-03 12:17 | 2026-09-03 12:17 | GLD | GLD260918C00450000 | call | 450.0000 | 2026-09-18 | 0.9300 | 0.8700 | 0.9300 | 412.0000 | 199764.00 | 199764.00 | 0.00 | 2148 | 48 | 6603 | 64462 | 0.102432440817846 | 0.301737808088166 | 0.301737808088166 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 143675098310.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:31:32.213825Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 962526cc-cba3-4938-a4e7-27430bee8dda | 2026-09-03 12:03 | 2026-09-03 12:03 | 2026-09-03 12:03 | GLD | GLD260918C00450000 | call | 450.0000 | 2026-09-18 | 0.8700 | 0.7900 | 0.8700 | 411.8800 | 225069.00 | 225069.00 | 0.00 | 2587 | 50 | 4424 | 64462 | 0.0686295802178027 | 0.297792090879178 | 0.297727796209699 | false | false | false | true | false | |||||||||||||||
| 0c1f25b7-dfc2-4c04-91ba-249eb058f2b4 | 2026-08-31 13:04 | 2026-08-31 13:04 | 2026-08-31 13:04 | GLD | GLD260918C00450000 | call | 450.0000 | 2026-09-18 | 0.5400 | 0.5200 | 0.5500 | 406.4087 | 63936.00 | 60696.00 | 3240.00 | 1184 | 24 | 13747 | 74133 | 0.185436984878529 | 0.273500362189756 | 0.273500362189756 | true | false | false | true | false | |||||||||||||||
| e75b366a-c6ba-46f7-a977-ca3bee9dd6d4 | 2026-08-31 13:00 | 2026-08-31 12:59 | 2026-08-31 12:59 | GLD | GLD260918C00450000 | call | 450.0000 | 2026-09-18 | 0.5400 | 0.5200 | 0.5400 | 406.5600 | 56106.00 | 56106.00 | 0.00 | 1039 | 19 | 10623 | 74133 | 0.143296507628182 | 0.272677691169042 | 0.272677691169042 | true | false | false | true | false | |||||||||||||||
| 641031e6-0408-4c46-a2bd-adf20fa95764 | 2026-08-31 12:46 | 2026-08-31 12:46 | 2026-08-31 12:46 | GLD | GLD260918C00450000 | call | 450.0000 | 2026-09-18 | 0.5400 | 0.5300 | 0.5500 | 406.6500 | 63396.00 | 11286.00 | 5184.00 | 1174 | 46 | 9094 | 74133 | 0.122671414889455 | 0.272188295414399 | 0.272188295414399 | false | false | false | true | false | |||||||||||||||
| 0b851a30-2d55-4d8e-944a-18b66d302a7a | 2026-08-31 12:41 | 2026-08-31 12:41 | 2026-08-31 12:41 | GLD | GLD260918C00450000 | call | 450.0000 | 2026-09-18 | 0.5400 | 0.5300 | 0.5400 | 406.5801 | 63396.00 | 63396.00 | 0.00 | 1174 | 38 | 7354 | 74133 | 0.0992000863313234 | 0.272568395021954 | 0.272568395021954 | true | false | false | true | false | |||||||||||||||
| d2468ddf-d08c-4f2e-bd26-9d8200509871 | 2026-08-31 12:36 | 2026-08-31 12:35 | 2026-08-31 12:35 | GLD | GLD260918C00450000 | call | 450.0000 | 2026-09-18 | 0.5400 | 0.5100 | 0.5700 | 406.7400 | 174542.00 | 141966.00 | 30402.00 | 3233 | 46 | 5371 | 74133 | 0.0724508653366247 | 0.271698873630224 | 0.271698873630224 | true | false | false | true | ||||||||||||||||
| 1b4dee6d-6fa4-4b13-9e50-d68efa12ee4d | 2026-08-28 10:54 | 2026-08-28 10:53 | 2026-08-28 10:53 | GLD | GLD260918C00450000 | call | 450.0000 | 2026-09-18 | 1.5100 | 1.5100 | 1.6000 | 418.6100 | 302000.00 | 0.00 | 302000.00 | 2000 | 60 | 2974 | 73669 | 0.0403697620437362 | 0.247295430400592 | 0.247961166320822 | false | false | false | true | false | |||||||||||||||
| 36f3edf3-9e66-492d-9f3a-1acb3037bec0 | 2026-08-26 11:12 | 2026-08-26 11:12 | 2026-08-26 11:12 | GLD | GLD260918C00450000 | call | 450.0000 | 2026-09-18 | 2.8500 | 2.8400 | 2.9300 | 421.4200 | 57000.00 | 0.00 | 57000.00 | 200 | 16 | 2389 | 74187 | 0.0322024074298732 | 0.272285815018838 | 0.272285815018838 | false | false | false | true | false | |||||||||||||||
| e196bbf3-a61f-4424-9c4a-b863024cdcbe | 2026-08-26 11:08 | 2026-08-26 11:07 | 2026-08-26 11:07 | GLD | GLD260918C00450000 | call | 450.0000 | 2026-09-18 | 2.8500 | 2.8300 | 2.9500 | 421.2100 | 57000.00 | 6840.00 | 50160.00 | 200 | 11 | 1372 | 74187 | 0.0184938061924596 | 0.273665266219988 | 0.273665266219988 | false | false | false | true | false | |||||||||||||||
| d1183d54-1302-4a9f-8592-bb006c169a9e | 2026-08-17 13:01 | 2026-08-17 13:01 | 2026-08-17 13:01 | GLD | GLD260918C00450000 | call | 450.0000 | 2026-09-18 | 1.6100 | 1.6100 | 1.6200 | 405.9399 | 13524.00 | 0.00 | 4669.00 | 84 | 5 | 762 | 51592 | 0.0147697317413552 | 0.264509532878328 | 0.264509532878328 | false | false | false | true | false | |||||||||||||||
| 3c5ad7ba-fd9a-49b9-b00c-be036d29985c | 2026-08-17 13:01 | 2026-08-17 13:01 | 2026-08-17 13:01 | GLD | GLD260918C00450000 | call | 450.0000 | 2026-09-18 | 1.6100 | 1.5700 | 1.6200 | 405.9399 | 32200.00 | 28980.00 | 805.00 | 200 | 10 | 978 | 51592 | 0.018956427353078 | 0.264509532878328 | 0.264509532878328 | true | false | false | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:03:37.205690Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:08:52.274087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:08:52.274087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:08:52.274087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:08:52.274087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:39:59.140702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:54:23.998586Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:22:15.766686Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:22:15.766686Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |