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 |
|---|
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| f4477787-a541-49ea-9dd6-4b27ba5fa0cb | 2026-09-25 10:48 | 2026-09-25 10:48 | 2026-09-25 10:48 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 41.6000 | 41.5500 | 41.7000 | 391.9300 | 336960.00 | 324480.00 | 12480.00 | 81 | 6 | 96 | 3112 | 0.0308483290488432 | 0.240427416993893 | 0.240427416993893 | false | false | false | |||||||||||||||||
| 9856dc01-0b42-49b0-bc77-7629ac53da60 | 2026-09-28 09:36 | 2026-09-28 09:36 | 2026-09-28 09:36 | GLD | GLD270115P00430000 | put | 430.0000 | 2027-01-15 | 52.1000 | 52.1000 | 52.5500 | 379.4540 | 109410.00 | 0.00 | 109410.00 | 21 | 10 | 21 | 3190 | 0.00658307210031348 | 0.261432386539819 | 0.261432386539819 | false | false | false |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 144613484818.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:52:00.220874Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 144430510273.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:37:13.633320Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |