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.
Simplify Analyticsuw_flow_alerts474,253 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 |
|---|
| b5801cd0-765d-4f07-87b5-92d6accc6cef | 2026-09-24 15:30 | 2026-09-24 15:30 | 2026-09-24 15:30 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 16.5500 | 16.4500 | 16.6000 | 391.5700 | 18205.00 | 18205.00 | 0.00 | 11 | 7 | 1185 | 6365 | 0.186174391201885 | 0.215631587498122 | 0.215631587498122 | false | false | false | true | 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-24T19:37:02.882742Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| 5ec66c9b-7c54-41b7-b7de-16fbbb0cdda8 | 2026-09-24 13:56 | 2026-09-24 13:56 | 2026-09-24 13:56 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 17.2000 | 17.1000 | 17.2500 | 390.5600 | 39560.00 | 18920.00 | 20640.00 | 23 | 5 | 855 | 6365 | 0.134328358208955 | 0.217229496096458 | 0.217044006311309 | true | false | false | true | false | |||||||||||||||
| ec56424a-099b-49b0-962a-1139d3ebd914 | 2026-09-24 10:08 | 2026-09-24 10:08 | 2026-09-24 10:08 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 16.8500 | 16.6500 | 16.8500 | 391.4900 | 70770.00 | 70770.00 | 0.00 | 42 | 8 | 159 | 6365 | 0.024980361351139 | 0.219811956732686 | 0.219811956732686 | false | false | false | true | false | |||||||||||||||
| fe210cfb-7500-4807-9d1e-464016be23b9 | 2026-09-24 09:41 | 2026-09-24 09:41 | 2026-09-24 09:41 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 17.0000 | 16.8000 | 17.0500 | 391.2500 | 76500.00 | 1700.00 | 74800.00 | 45 | 7 | 48 | 6365 | 0.00754124116260801 | 0.220093661049541 | 0.220093661049541 | false | false | false | true | false | |||||||||||||||
| 9ad6ef96-1bdb-48f1-882b-0cee7dce89f8 | 2026-09-23 15:12 | 2026-09-23 15:12 | 2026-09-23 15:12 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 15.9500 | 15.9000 | 15.9500 | 393.2500 | 25520.00 | 25520.00 | 0.00 | 16 | 5 | 4235 | 4145 | 1.02171290711701 | 0.21928124279584 | 0.219111109394199 | false | false | false | true | false | |||||||||||||||
| 99d4951d-963b-4ee5-9589-29ab3e9287a9 | 2026-09-23 13:44 | 2026-09-23 13:44 | 2026-09-23 13:44 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 15.9500 | 15.9500 | 16.1000 | 393.0000 | 17550.00 | 1600.00 | 15950.00 | 11 | 6 | 2390 | 4145 | 0.576598311218335 | 0.218960387018362 | 0.218158058048411 | false | false | false | true | false | |||||||||||||||
| fd5b48ef-6faa-4366-b53b-199dd3006420 | 2026-09-23 13:43 | 2026-09-23 13:43 | 2026-09-23 13:43 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 16.1000 | 16.0500 | 16.1000 | 392.0000 | 27370.00 | 27370.00 | 0.00 | 17 | 5 | 2305 | 4145 | 0.556091676718938 | 0.219126831081951 | 0.219126831081951 | false | false | false | true | false | |||||||||||||||
| 412d0e61-bfc2-4144-9ec2-f061f39b2653 | 2026-09-23 13:41 | 2026-09-23 13:41 | 2026-09-23 13:41 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 16.3500 | 16.2500 | 16.3500 | 392.0000 | 16350.00 | 16350.00 | 0.00 | 10 | 5 | 2274 | 4145 | 0.548612786489747 | 0.219612117707109 | 0.219612117707109 | false | false | false | true | false | |||||||||||||||
| bda4493b-ac3c-4436-968b-d5e652be12eb | 2026-09-23 12:33 | 2026-09-23 12:33 | 2026-09-23 12:33 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 16.0500 | 16.0000 | 16.1500 | 393.0000 | 14445.00 | 4815.00 | 9630.00 | 9 | 5 | 968 | 4145 | 0.233534378769602 | 0.218271512522986 | 0.218581042210948 | false | false | false | true | false | |||||||||||||||
| 22392d68-99e5-4a44-8884-86b26131c543 | 2026-09-23 11:50 | 2026-09-23 11:50 | 2026-09-23 11:50 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 16.5600 | 16.5000 | 16.7000 | 392.0000 | 43044.00 | 3315.00 | 39729.00 | 26 | 6 | 481 | 4145 | 0.116043425814234 | 0.220005531098871 | 0.219860759297275 | true | false | false | true | false | |||||||||||||||
| e2dae7b9-c2f9-440c-a17f-668413b2daea | 2026-09-16 15:46 | 2026-09-16 15:46 | 2026-09-16 15:46 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 19.6000 | 19.6000 | 19.8000 | 391.0000 | 196000.00 | 0.00 | 196000.00 | 100 | 11 | 779 | 3211 | 0.242603550295858 | 0.249717680881217 | 0.249717680881217 | true | false | false | true | false | |||||||||||||||
| 182ab4b3-6c23-42e3-89ee-be8ccc2349e8 | 2026-09-16 15:44 | 2026-09-16 15:44 | 2026-09-16 15:44 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 19.7500 | 19.6500 | 19.7500 | 391.0950 | 177750.00 | 53325.00 | 0.00 | 90 | 18 | 669 | 3211 | 0.208346309560884 | 0.25008676170541 | 0.25008676170541 | false | false | false | true | false | |||||||||||||||
| 140c2eea-8c98-49fa-a978-de6d9346690c | 2026-09-16 15:36 | 2026-09-16 15:36 | 2026-09-16 15:36 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 20.1000 | 19.9500 | 20.1000 | 390.4400 | 104520.00 | 104520.00 | 0.00 | 52 | 19 | 579 | 3211 | 0.180317658050452 | 0.250035263501468 | 0.250035263501468 | false | false | false | true | false | |||||||||||||||
| 7aa500c8-2323-422a-95d9-953dfd007dd5 | 2026-09-16 15:36 | 2026-09-16 15:36 | 2026-09-16 15:36 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 20.1000 | 19.9000 | 20.1000 | 390.6600 | 96480.00 | 36180.00 | 0.00 | 48 | 10 | 527 | 3211 | 0.164123326066646 | 0.25185622019007 | 0.25185622019007 | false | false | false | true | false | |||||||||||||||
| c04ad1d8-a1c9-47c5-91e7-d6e00360432a | 2026-09-16 15:02 | 2026-09-16 15:02 | 2026-09-16 15:02 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 19.1500 | 19.1500 | 19.5000 | 392.0700 | 70855.00 | 0.00 | 70855.00 | 37 | 16 | 467 | 3211 | 0.145437558393024 | 0.248846952778313 | 0.248846952778313 | false | false | false | true | false | |||||||||||||||
| 5a28ee52-952d-410b-8659-d49dfc4ef7cc | 2026-09-16 15:01 | 2026-09-16 15:01 | 2026-09-16 15:01 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 19.0000 | 19.0000 | 19.3500 | 392.4800 | 95000.00 | 0.00 | 1900.00 | 50 | 19 | 426 | 3211 | 0.132668950482716 | 0.249838104547865 | 0.249838104547865 | false | false | false | true | false | |||||||||||||||
| 39beb46e-7600-43aa-b82d-e65b81e44ae1 | 2026-09-16 15:00 | 2026-09-16 15:00 | 2026-09-16 15:00 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 19.6500 | 19.6500 | 19.9000 | 391.2100 | 127725.00 | 0.00 | 127725.00 | 65 | 10 | 376 | 3211 | 0.117097477421364 | 0.248684351796864 | 0.249501653088799 | false | false | false | true | false | |||||||||||||||
| 4d1395f3-e419-4a5a-bad5-4946597e047b | 2026-09-16 15:00 | 2026-09-16 15:00 | 2026-09-16 15:00 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 19.6500 | 19.6500 | 19.9000 | 391.1000 | 51090.00 | 0.00 | 51090.00 | 26 | 7 | 306 | 3211 | 0.0952974151354718 | 0.248602495007186 | 0.248602495007186 | false | false | false | true | false | |||||||||||||||
| a1351438-f6c6-4c2a-9537-c81db09cea62 | 2026-09-16 14:58 | 2026-09-16 14:58 | 2026-09-16 14:58 | GLD | GLD261120P00400000 | put | 400.0000 | 2026-11-20 | 19.7500 | 19.3500 | 19.9500 | 391.4300 | 197500.00 | 13825.00 | 1975.00 | 100 | 20 | 275 | 3211 | 0.0856431018374338 | 0.252814254528882 | 0.252814254528882 | false | false | false | true | 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-24T18:01:57.698805Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 145541313705.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:08:54.070178Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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:42:52.039375Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146956242979.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:12:23.721983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 146956242979.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:45:14.864344Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146956242979.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:45:14.864344Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146956242979.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:43:03.709156Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146956242979.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:39:09.093031Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 146956242979.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:51:01.874824Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 145045725759.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 145045725759.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:45:47.974261Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 145045725759.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:45:47.974261Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 145045725759.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:45:47.974261Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 145045725759.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 145045725759.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 145045725759.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 145045725759.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 145045725759.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |