Simplify AnalyticsOptions flow alerts (market-wide)
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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 635db73e-d82e-4456-999c-fa5b7e9cb027 | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 36.9000 | 36.6000 | 36.9500 | 402.3600 | 33210.00 | 29520.00 | 0.00 | 9 | 9 | 9 | 3110 | 0.00289389067524116 | 0.238525330940985 | 0.238525330940985 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0f115a6b-013a-4faf-b230-6084c61a0873 | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 36.9500 | 36.7000 | 37.4500 | 402.4450 | 22170.00 | 0.00 | 14780.00 | 6 | 6 | 15 | 3110 | 0.00482315112540193 | 0.239532450785051 | 0.239532450785051 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a2902e06-ebfe-477a-947c-f566d81ad81f | 2026-08-17 09:31 | 2026-08-17 09:31 | 2026-08-17 09:31 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 36.9500 | 36.7500 | 36.9500 | 402.4500 | 29560.00 | 29560.00 | 0.00 | 8 | 8 | 23 | 3110 | 0.00739549839228296 | 0.239562270938146 | 0.239562270938146 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| daea9a95-eacb-410c-ba39-68e999aebff6 | 2026-08-17 09:31 | 2026-08-17 09:31 | 2026-08-17 09:31 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 36.9000 | 36.7500 | 37.1000 | 402.4100 | 25830.00 | 3690.00 | 3690.00 | 7 | 7 | 32 | 3110 | 0.0102893890675241 | 0.23882424043918 | 0.23882424043918 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 40ecc623-f717-4db0-8eae-1319195abe62 | 2026-08-17 09:31 | 2026-08-17 09:31 | 2026-08-17 09:31 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 36.9000 | 36.7500 | 37.1000 | 402.4300 | 25830.00 | 22140.00 | 3690.00 | 7 | 7 | 39 | 3110 | 0.012540192926045 | 0.238943695522906 | 0.238943695522906 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6a8a16d2-bd9a-4b66-9843-6566f0c66d5f | 2026-08-17 09:31 | 2026-08-17 09:31 | 2026-08-17 09:31 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 36.8500 | 36.7000 | 36.8500 | 402.5700 | 25795.00 | 25795.00 | 0.00 | 7 | 7 | 53 | 3110 | 0.0170418006430868 | 0.239279400808776 | 0.239279400808776 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b965d4e4-3b20-450e-bc06-d6e312ff63df | 2026-08-17 09:32 | 2026-08-17 09:32 | 2026-08-17 09:32 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 36.7500 | 36.7000 | 36.7500 | 402.4600 | 40425.00 | 3675.00 | 0.00 | 11 | 11 | 64 | 3110 | 0.0205787781350482 | 0.237624726164298 | 0.237624726164298 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c59763a9-9958-4d08-9dcb-1fbf1cab8995 | 2026-08-17 09:32 | 2026-08-17 09:32 | 2026-08-17 09:32 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 36.8500 | 36.6500 | 36.8500 | 402.6050 | 36850.00 | 36850.00 | 0.00 | 10 | 10 | 75 | 3110 | 0.0241157556270096 | 0.239487699370531 | 0.239487699370531 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f81f4814-c8a0-48f4-b8dc-32a8d2e3b6cf | 2026-08-17 09:32 | 2026-08-17 09:32 | 2026-08-17 09:32 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 36.8500 | 36.6500 | 36.8500 | 402.5600 | 33165.00 | 33165.00 | 0.00 | 9 | 9 | 85 | 3110 | 0.0273311897106109 | 0.239219852414955 | 0.239219852414955 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 87737431-f315-4a66-bf04-a42998bfa78f | 2026-08-31 09:31 | 2026-08-31 09:31 | 2026-08-31 09:31 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 34.1500 | 34.1000 | 34.3000 | 407.5000 | 51225.00 | 3415.00 | 37565.00 | 15 | 15 | 15 | 3044 | 0.00492772667542707 | 0.249514745312074 | 0.249514745312074 | 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-08-31T13:35:53.678596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a0f0a927-f276-4f8b-b53e-6d9a9a649752 | 2026-08-31 09:31 | 2026-08-31 09:31 | 2026-08-31 09:31 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 34.1000 | 34.0000 | 34.1000 | 407.6700 | 105710.00 | 54560.00 | 0.00 | 31 | 7 | 64 | 3044 | 0.0210249671484888 | 0.249991686827415 | 0.249991686827415 | 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-31T13:35:53.678596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0448500e-5b9a-4794-86d4-c0826e3d1f1b | 2026-08-31 09:31 | 2026-08-31 09:31 | 2026-08-31 09:31 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 34.1000 | 34.0500 | 34.3500 | 407.6700 | 208010.00 | 190960.00 | 17050.00 | 61 | 12 | 125 | 3044 | 0.0410643889618922 | 0.249991686827415 | 0.249991686827415 | 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-31T13:35:53.678596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7b16f5c2-0b66-4fe9-b87e-5b2f90510564 | 2026-08-31 09:32 | 2026-08-31 09:32 | 2026-08-31 09:32 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 34.3000 | 34.2000 | 34.3000 | 407.2600 | 72030.00 | 13720.00 | 0.00 | 21 | 8 | 188 | 3044 | 0.0617608409986859 | 0.249647609639025 | 0.249647609639025 | 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-31T13:35:53.678596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3405dc28-2135-4df4-90e8-45f29a680dc4 | 2026-08-31 09:32 | 2026-08-31 09:32 | 2026-08-31 09:32 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 34.4000 | 34.3000 | 34.4000 | 407.2200 | 137600.00 | 137600.00 | 0.00 | 40 | 19 | 238 | 3044 | 0.0781865965834428 | 0.250435306189217 | 0.250435306189217 | 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-31T13:35:53.678596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3dae1c7d-ed2b-4415-8b90-819a4aeae4b9 | 2026-08-31 09:32 | 2026-08-31 09:32 | 2026-08-31 09:32 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 34.4000 | 34.3500 | 34.4000 | 407.1900 | 106640.00 | 99760.00 | 0.00 | 31 | 18 | 269 | 3044 | 0.0883705650459921 | 0.250260239956023 | 0.250260239956023 | 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-31T13:35:53.678596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cd0842dc-1edb-4ac0-a0da-abf2fc5f2868 | 2026-09-14 12:16 | 2026-09-14 12:16 | 2026-09-14 12:16 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 42.8100 | 42.6000 | 42.8500 | 394.0197 | 59930.00 | 25695.00 | 4275.00 | 14 | 6 | 39 | 3082 | 0.0126541207008436 | 0.263732445733437 | 0.264326720368398 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 147692376545.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T16:23:59.234542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |