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_alerts566,287 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 |
|---|
| d8ee9dff-bb05-4216-a7d0-2d3cb23745af | 2026-08-31 11:04 | 2026-08-31 11:04 | 2026-08-31 11:04 | GLD | GLD270115C00450000 | call | 450.0000 | 2027-01-15 | 11.0500 | 11.0500 | 11.4000 | 406.4550 | 62985.00 | 0.00 | 62985.00 | 57 | 7 | 312 | 34567 | 0.0090259496051147 | 0.244110515008028 | 0.244110515008028 | 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-08-31T15:07:09.972110Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e725299c-f852-42e4-8c6c-0421eaf4e14e | 2026-09-02 10:24 | 2026-09-02 10:24 | 2026-09-02 10:24 | GLD | GLD270115C00450000 | call | 450.0000 | 2027-01-15 | 9.9000 | 9.8500 | 10.2500 | 402.4200 | 137610.00 | 0.00 | 136620.00 | 139 | 22 | 591 | 35839 | 0.0164904154691816 | 0.246781852408883 | 0.246781852408883 | false | false | false | |||||||||||||||||
| 28f74283-2dbb-4373-868e-dee657ed8c34 | 2026-09-11 13:40 | 2026-09-11 13:39 | 2026-09-11 13:39 | GLD | GLD270115C00450000 | call | 450.0000 | 2027-01-15 | 9.2000 | 9.2000 | 9.3500 | 399.9438 | 52440.00 | 0.00 | 52440.00 | 57 | 9 | 1994 | 42745 | 0.046648730845713 | 0.256172659435018 | 0.25621153410726 | false | false | false | true | ||||||||||||||||
| 925f353d-5e48-4079-85b3-73aff124e1d0 | 2026-09-15 14:22 | 2026-09-15 14:22 | 2026-09-15 14:22 | GLD | GLD270115C00450000 | call | 450.0000 | 2027-01-15 | 8.0000 | 7.9000 | 8.1000 | 394.7100 | 160000.00 | 0.00 | 136800.00 | 200 | 5 | 3877 | 39983 | 0.0969662106395218 | 0.264719029001746 | 0.264719029001746 | false | false | false | true | ||||||||||||||||
| 04c63bb8-1163-4889-9cd9-c377024a1024 | 2026-09-16 10:57 | 2026-09-16 10:56 | 2026-09-16 10:56 | GLD | GLD270115C00450000 | call | 450.0000 | 2027-01-15 | 8.8000 | 8.7000 | 8.8500 | 398.7600 | 104720.00 | 85360.00 | 19360.00 | 119 | 8 | 55850 | 42724 | 1.30722778766033 | 0.260604889593051 | 0.260604889593051 | false | false | false | |||||||||||||||||
| 4aa9b13a-9674-4a6a-85ef-3726506025ce | 2026-09-21 13:25 | 2026-09-21 13:24 | 2026-09-21 13:24 | GLD | GLD270115C00450000 | call | 450.0000 | 2027-01-15 | 6.7500 | 6.7500 | 6.9000 | 398.0822 | 29025.00 | 0.00 | 29025.00 | 43 | 6 | 53428 | 107715 | 0.496012625910969 | 0.239990165004147 | 0.239990165004147 | false | false | false | true | ||||||||||||||||
| b79c7365-91e3-4944-8271-f01c22b09c37 | 2026-09-22 09:47 | 2026-09-22 09:47 | 2026-09-22 09:47 | GLD | GLD270115C00450000 | call | 450.0000 | 2027-01-15 | 6.5000 | 6.5000 | 6.7000 | 397.5543 | 22753.00 | 0.00 | 22753.00 | 35 | 7 | 121 | 160800 | 0.000752487562189055 | 0.239168845178475 | 0.239318291981291 | false | false | false | true | ||||||||||||||||
| 4987a9ad-e7f7-42f0-8591-2561bedda5ce | 2026-09-22 10:42 | 2026-09-22 10:42 | 2026-09-22 10:42 | GLD | GLD270115C00450000 | call | 450.0000 | 2027-01-15 | 6.2000 | 6.2000 | 6.4000 | 395.8391 | 25420.00 | 0.00 | 25420.00 | 41 | 8 | 342 | 160800 | 0.00212686567164179 | 0.240358612305171 | 0.240358612305171 | false | false | false | true | ||||||||||||||||
| 1d8abf84-49bd-49c5-80c2-42f62281771d | 2026-09-23 10:23 | 2026-09-23 10:22 | 2026-09-23 10:22 | GLD | GLD270115C00450000 | call | 450.0000 | 2027-01-15 | 5.4000 | 5.3500 | 5.5000 | 392.5800 | 1021368.00 | 3240.00 | 1018128.00 | 1891 | 36 | 2662 | 161207 | 0.0165129305799376 | 0.23950551274507 | 0.239537861194875 | false | false | false | |||||||||||||||||
| 9c4e4129-3849-4a69-9872-4cb56dfede02 | 2026-09-23 11:37 | 2026-09-23 11:37 | 2026-09-23 11:37 | GLD | GLD270115C00450000 | call | 450.0000 | 2027-01-15 | 5.3000 | 5.3000 | 5.4000 | 392.6801 | 344507.00 | 0.00 | 344507.00 | 650 | 33 | 3643 | 161207 | 0.0225982742684871 | 0.237566429777042 | 0.237566107499187 | false | false | false | |||||||||||||||||
| e8f3e62f-d8b2-4f5e-b6a8-3085dc615f71 | 2026-09-23 12:25 | 2026-09-23 12:25 | 2026-09-23 12:25 | GLD | GLD270115C00450000 | call | 450.0000 | 2027-01-15 | 5.1500 | 5.1500 | 5.2500 | 392.6800 | 213210.00 | 0.00 | 213210.00 | 414 | 39 | 4113 | 161207 | 0.0255137804189644 | 0.23507602384927 | 0.23507602384927 | false | false | false | |||||||||||||||||
| b6959201-c185-4edd-9933-0b7554939445 | 2026-09-23 12:28 | 2026-09-23 12:28 | 2026-09-23 12:28 | GLD | GLD270115C00450000 | call | 450.0000 | 2027-01-15 | 5.1500 | 5.1500 | 5.2500 | 392.8600 | 500826.00 | 0.00 | 500826.00 | 972 | 36 | 5085 | 161207 | 0.0315432952663346 | 0.234499252819674 | 0.234499252819674 | false | false | false | |||||||||||||||||
| 7b0f2643-fa2f-4017-bf3a-b89b5d2c14da | 2026-09-23 12:53 | 2026-09-23 12:53 | 2026-09-23 12:53 | GLD | GLD270115C00450000 | call | 450.0000 | 2027-01-15 | 5.0000 | 4.9500 | 5.0500 | 392.3000 | 12000.00 | 0.00 | 11500.00 | 24 | 5 | 5266 | 161207 | 0.0326660752944971 | 0.233772593434201 | 0.233772593434201 | false | false | false | true | ||||||||||||||||
| 13a36e09-f530-4282-89b0-e0cfa0ec6d06 | 2026-09-24 09:58 | 2026-09-24 09:58 | 2026-09-24 09:58 | GLD | GLD270115C00450000 | call | 450.0000 | 2027-01-15 | 4.7000 | 4.6500 | 4.7500 | 390.8700 | 70500.00 | 0.00 | 61100.00 | 150 | 5 | 260 | 162324 | 0.00160173480200094 | 0.234172825874025 | 0.234172825874025 | 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-02T14:25:30.485375Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T18:02:32.717866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-15T18:42:39.046957Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 145045725759.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147753657378.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:29:25.525905Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146698617465.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:48:39.949749Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146698617465.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:42:44.065275Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146956242979.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:24:55.903933Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146956242979.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:41:14.023510Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146956242979.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:31:43.812748Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146956242979.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:31:43.812748Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146956242979.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:56:20.780869Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 145541313705.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:59:25.813942Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |