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 | 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 |
|---|
| e1c91779-e7bb-490a-855b-b8888853c310 | 2026-08-17 15:18 | 2026-08-17 15:18 | 2026-08-17 15:18 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 9.4400 | 9.3000 | 9.5000 | 404.9300 | 47200.00 | 47200.00 | 0.00 | 50 | 5 | 466 | 39738 | 0.0117268106094922 | 0.233011356519325 | 0.233011356519325 | 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-17T19:39:36.389012Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5aea5f20-7cdf-43ae-a451-62e2988ecfc9 | 2026-08-19 09:31 | 2026-08-19 09:30 | 2026-08-19 09:30 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 11.2000 | 11.0500 | 11.2500 | 408.7710 | 73920.00 | 64960.00 | 4480.00 | 66 | 5 | 141 | 39704 | 0.00355127946806367 | 0.239501768001591 | 0.239160678397006 | true | false | false | true | ||||||||||||||||
| e20c96da-3507-4c87-a7b6-b2c72ef9d6a4 | 2026-08-19 09:31 | 2026-08-19 09:31 | 2026-08-19 09:31 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 11.3000 | 10.9500 | 11.3000 | 408.8900 | 205660.00 | 205660.00 | 0.00 | 182 | 6 | 604 | 39704 | 0.0152125730404997 | 0.239988858209076 | 0.239988858209076 | true | false | false | true | ||||||||||||||||
| 9f03b223-aabe-45b9-a20d-a80d2f90c634 | 2026-08-19 10:43 | 2026-08-19 10:43 | 2026-08-19 10:43 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 13.6500 | 13.6500 | 13.8500 | 412.5750 | 136500.00 | 0.00 | 136500.00 | 100 | 15 | 1655 | 39704 | 0.0416834575861374 | 0.247269962906212 | 0.247574452096208 | false | false | false | true | ||||||||||||||||
| 81c0cc7a-ad27-4664-aa70-2f7678ace53a | 2026-08-19 15:01 | 2026-08-19 15:01 | 2026-08-19 15:01 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 13.5000 | 13.2500 | 13.5500 | 412.5500 | 135000.00 | 133650.00 | 1350.00 | 100 | 19 | 3194 | 39704 | 0.0804452951843643 | 0.244654996825877 | 0.244654996825877 | false | false | false | true | ||||||||||||||||
| a3d93269-870e-4d39-a7af-f5751b0003cd | 2026-08-20 11:20 | 2026-08-20 11:20 | 2026-08-20 11:20 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 16.0400 | 15.9000 | 16.2000 | 416.3400 | 60970.00 | 0.00 | 32080.00 | 38 | 5 | 637 | 39813 | 0.0159997990606083 | 0.256038079750622 | 0.256038079750622 | false | false | false | true | ||||||||||||||||
| 8e7673ae-1115-48c2-845e-6b1ce57be1a4 | 2026-08-28 11:58 | 2026-08-28 11:58 | 2026-08-28 11:58 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 12.7000 | 12.4000 | 12.8000 | 414.0000 | 82550.00 | 82550.00 | 0.00 | 65 | 6 | 153 | 38842 | 0.00393903506513568 | 0.243604979623966 | 0.243604979623966 | false | false | false | true | ||||||||||||||||
| 6ffb16c5-a53a-4914-a226-1bdbfd62a936 | 2026-09-01 12:30 | 2026-09-01 12:30 | 2026-09-01 12:30 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 4.0000 | 3.9000 | 4.1000 | 398.9750 | 79200.00 | 62800.00 | 16400.00 | 198 | 11 | 1450 | 39486 | 0.0367218761079876 | 0.233708196781022 | 0.233708196781022 | false | false | false | true | ||||||||||||||||
| 3dcc0797-e5cd-4a5b-9740-a211ce7034eb | 2026-09-01 14:30 | 2026-09-01 14:30 | 2026-09-01 14:30 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 3.6900 | 3.6000 | 3.7000 | 397.6300 | 92218.00 | 92218.00 | 0.00 | 250 | 13 | 3195 | 39486 | 0.0809147545965659 | 0.237390117467671 | 0.237390117467671 | false | false | false | true | ||||||||||||||||
| a412ff5d-4c42-446e-941f-9664e2c51c08 | 2026-09-02 11:13 | 2026-09-02 11:13 | 2026-09-02 11:13 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 4.7000 | 4.7000 | 4.8500 | 401.2600 | 94000.00 | 0.00 | 94000.00 | 200 | 19 | 1630 | 40148 | 0.0405997808109993 | 0.239497543950151 | 0.239185420813097 | false | false | false | true | ||||||||||||||||
| c0f96175-a052-4eb2-ad0a-ee937b917639 | 2026-09-03 09:53 | 2026-09-03 09:53 | 2026-09-03 09:53 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 8.0500 | 8.0500 | 8.2500 | 409.1700 | 111917.00 | 0.00 | 111917.00 | 139 | 17 | 497 | 40091 | 0.012396797286174 | 0.246024505545121 | 0.246024505545121 | true | false | false | true | ||||||||||||||||
| 82fb8faf-c72c-4c1e-ba68-37c1c4e36545 | 2026-09-04 14:47 | 2026-09-04 14:47 | 2026-09-04 14:47 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 6.1100 | 5.9500 | 6.1500 | 405.6900 | 122142.00 | 122142.00 | 0.00 | 200 | 7 | 10793 | 39949 | 0.270169466069238 | 0.245437870127367 | 0.245437870127367 | false | false | false | true | ||||||||||||||||
| da76e148-2052-4d8c-b95a-ef7b9d4dd3e5 | 2026-09-04 14:50 | 2026-09-04 14:50 | 2026-09-04 14:50 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 6.1500 | 6.0000 | 6.2000 | 405.7300 | 117455.00 | 117455.00 | 0.00 | 191 | 20 | 11593 | 39949 | 0.290194998623245 | 0.24648024663434 | 0.24648024663434 | false | false | false | true | ||||||||||||||||
| d9e1462d-37a8-48f3-a7a2-f2e080b7b2d5 | 2026-09-08 15:55 | 2026-09-08 15:55 | 2026-09-08 15:55 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 3.6000 | 3.6000 | 3.7500 | 399.8800 | 54000.00 | 0.00 | 54000.00 | 150 | 11 | 3335 | 42215 | 0.079000355323937 | 0.279453569349697 | 0.279453569349697 | false | false | false | true | ||||||||||||||||
| 7c206961-764f-407a-9838-ccb815568fd0 | 2026-09-09 09:32 | 2026-09-09 09:32 | 2026-09-09 09:32 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 6.2000 | 6.1000 | 6.3000 | 406.5000 | 104780.00 | 103540.00 | 620.00 | 169 | 14 | 194 | 43571 | 0.00445250281150306 | 0.300971961240611 | 0.299562625658596 | true | false | false | true | ||||||||||||||||
| 043a6b51-8b9a-4d94-8c18-19a0aabf89fb | 2026-09-10 14:30 | 2026-09-10 14:29 | 2026-09-10 14:29 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 2.8400 | 2.8000 | 3.0000 | 397.5900 | 213750.00 | 14384.00 | 198517.00 | 752 | 55 | 2779 | 43554 | 0.063805850208936 | 0.30849044114718 | 0.307391542210888 | true | false | false | true | ||||||||||||||||
| 4a30430c-fe0b-452f-b2eb-7564e428ac44 | 2026-09-10 15:39 | 2026-09-10 15:39 | 2026-09-10 15:39 | GLD | GLD260918C00410000 | call | 410.0000 | 2026-09-18 | 2.5500 | 2.5500 | 2.5500 | 396.6000 | 51000.00 | 0.00 | 0.00 | 200 | 8 | 3191 | 43554 | 0.0732653717224595 | 0.306393516320114 | 0.306393516320114 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} |
| 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-19T13:32:56.078945Z"} |
| 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-19T14:50:22.027850Z"} |
| 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-19T19:07:34.318493Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} |
| 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-09-01T16:48:42.201804Z"} |
| 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-09-01T18:40:09.958238Z"} |
| 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-09-02T15:25:17.297093Z"} |
| 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-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:05:15.166096Z"} |
| 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-09-04T19:05:15.166096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:30:57.501605Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:36:21.128731Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:37:18.479310Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T19:48:54.834059Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |