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 |
|---|
| 4003e8df-5282-46e2-b6d5-77f45b0b1806 | 2026-09-25 13:01 | 2026-09-25 13:01 | 2026-09-25 13:01 | GLD | GLD261120C00425000 | call | 425.0000 | 2026-11-20 | 4.0000 | 4.0000 | 4.1000 | 393.3221 | 50010.00 | 0.00 | 50010.00 | 125 | 7 | 438 | 9998 | 0.0438087617523505 | 0.219330181212572 | 0.219108858201917 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 144613484818.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T17:04:49.737352Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| d017085a-7892-4247-9296-9e97f86c5580 | 2026-09-10 10:25 | 2026-09-10 10:25 | 2026-09-10 10:25 | GLD | GLD261120C00425000 | call | 425.0000 | 2026-11-20 | 10.3000 | 10.1500 | 10.3500 | 400.7200 | 51520.00 | 27945.00 | 0.00 | 50 | 5 | 103 | 9784 | 0.0105273916598528 | 0.263419671984851 | 0.261893115573739 | false | false | false | true | false | |||||||||||||||
| 729a3bc7-7886-4959-9b36-d086e0eb8eac | 2026-08-28 13:07 | 2026-08-28 13:07 | 2026-08-28 13:07 | GLD | GLD261120C00425000 | call | 425.0000 | 2026-11-20 | 15.0400 | 14.9000 | 15.4500 | 410.3900 | 75212.00 | 0.00 | 75212.00 | 50 | 11 | 1791 | 10765 | 0.166372503483511 | 0.24976569312396 | 0.252472500708437 | false | false | false | true | false | |||||||||||||||
| 6a8059b5-cfe0-4914-a3cb-6f7c8c4ef63f | 2026-08-20 13:50 | 2026-08-20 13:50 | 2026-08-20 13:50 | GLD | GLD261120C00425000 | call | 425.0000 | 2026-11-20 | 17.7000 | 17.5000 | 17.7000 | 414.4700 | 123900.00 | 21240.00 | 0.00 | 70 | 6 | 116 | 9233 | 0.0125636304559731 | 0.24809388970414 | 0.24809388970414 | false | false | false | true | false | |||||||||||||||
| 5e5554d2-4f87-4f89-ae0e-37d5ad700ff7 | 2026-08-19 09:47 | 2026-08-19 09:47 | 2026-08-19 09:47 | GLD | GLD261120C00425000 | call | 425.0000 | 2026-11-20 | 14.8400 | 14.3500 | 14.8500 | 408.9150 | 2226285.00 | 2107215.00 | 119070.00 | 1500 | 32 | 1522 | 7920 | 0.192171717171717 | 0.242527955175106 | 0.242527955175106 | false | false | false | true | ||||||||||||||||
| b8eb2ec5-fe49-4286-8dff-64642ff1e632 | 2026-08-18 11:01 | 2026-08-18 11:01 | 2026-08-18 11:01 | GLD | GLD261120C00425000 | call | 425.0000 | 2026-11-20 | 11.2000 | 11.1500 | 11.3500 | 400.7350 | 1230085.00 | 558085.00 | 372960.00 | 1098 | 27 | 5722 | 12992 | 0.440424876847291 | 0.23598529999325 | 0.23598529999325 | false | false | false | true | ||||||||||||||||
| 81a82ea7-ab69-455b-afb4-71abcee716f3 | 2026-08-18 11:01 | 2026-08-18 11:01 | 2026-08-18 11:01 | GLD | GLD261120C00425000 | call | 425.0000 | 2026-11-20 | 11.1500 | 11.1500 | 11.4500 | 400.8300 | 1672644.00 | 0.00 | 1667044.00 | 1500 | 22 | 4585 | 12992 | 0.352909482758621 | 0.234877894369432 | 0.234877894369432 | false | false | false | true | ||||||||||||||||
| a9e087fa-914f-44dd-8c37-e93a094ebee3 | 2026-08-18 11:01 | 2026-08-18 11:01 | 2026-08-18 11:01 | GLD | GLD261120C00425000 | call | 425.0000 | 2026-11-20 | 11.2500 | 11.2000 | 11.6000 | 400.7300 | 553597.00 | 3405.00 | 550192.00 | 492 | 11 | 3085 | 12992 | 0.23745381773399 | 0.236663628885665 | 0.237971737405885 | false | false | false | true | ||||||||||||||||
| 424a621d-feaf-44ea-a662-5d083c10a3b2 | 2026-08-18 11:01 | 2026-08-18 11:01 | 2026-08-18 11:01 | GLD | GLD261120C00425000 | call | 425.0000 | 2026-11-20 | 11.2500 | 11.2500 | 11.6000 | 400.8100 | 1135125.00 | 0.00 | 1135125.00 | 1009 | 31 | 2591 | 12992 | 0.199430418719212 | 0.236281806728199 | 0.236281806728199 | false | false | false | true | ||||||||||||||||
| a1a77520-af3a-4313-beeb-9232abe964e6 | 2026-08-18 11:00 | 2026-08-18 11:00 | 2026-08-18 11:00 | GLD | GLD261120C00425000 | call | 425.0000 | 2026-11-20 | 11.2000 | 11.2000 | 11.6500 | 400.8800 | 1680000.00 | 0.00 | 1680000.00 | 1500 | 37 | 1562 | 12992 | 0.120227832512315 | 0.235293720678683 | 0.235293720678683 | false | false | false | true | ||||||||||||||||
| 4cce6b02-2d45-4ce4-bd09-ebf96cebd3ed | 2026-08-17 12:42 | 2026-08-17 12:42 | 2026-08-17 12:42 | GLD | GLD261120C00425000 | call | 425.0000 | 2026-11-20 | 13.7100 | 13.6500 | 13.8000 | 405.9300 | 137112.00 | 35880.00 | 101232.00 | 100 | 5 | 4724 | 6944 | 0.680299539170507 | 0.242074360544253 | 0.240583209171514 | false | false | false | true | ||||||||||||||||
| f58068fc-0d65-4fb8-8132-a116627d42ec | 2026-08-17 12:38 | 2026-08-17 12:38 | 2026-08-17 12:38 | GLD | GLD261120C00425000 | call | 425.0000 | 2026-11-20 | 13.7200 | 13.5500 | 13.7500 | 406.0300 | 732680.00 | 732680.00 | 0.00 | 534 | 47 | 4533 | 6944 | 0.652793778801843 | 0.240153953555875 | 0.240944272626141 | true | false | false | true | false | |||||||||||||||
| fc35edb0-00a7-4a8e-93e7-523fb76d7c48 | 2026-08-17 11:21 | 2026-08-17 11:21 | 2026-08-17 11:21 | GLD | GLD261120C00425000 | call | 425.0000 | 2026-11-20 | 13.3500 | 13.1000 | 13.4000 | 405.7800 | 1149435.00 | 1066665.00 | 82770.00 | 861 | 25 | 2492 | 6944 | 0.358870967741935 | 0.237186689548578 | 0.237237240950885 | false | false | false | true | ||||||||||||||||
| b3a76690-7fa7-4aa2-b529-235bde550f26 | 2026-08-17 10:31 | 2026-08-17 10:31 | 2026-08-17 10:31 | GLD | GLD261120C00425000 | call | 425.0000 | 2026-11-20 | 13.1500 | 12.9000 | 13.2000 | 405.3600 | 1973813.00 | 1229523.00 | 744290.00 | 1501 | 56 | 1528 | 6944 | 0.220046082949309 | 0.236959517582172 | 0.236858980139599 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:36:53.026568Z"} |
| 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-28T17:15:24.821907Z"} |
| 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-20T18:14:08.178572Z"} |
| 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:50:14.094967Z"} |
| 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-18T15:04:03.259366Z"} |
| 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-18T15:04:03.259366Z"} |
| 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-18T15:04:03.259366Z"} |
| 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-18T15:04:03.259366Z"} |
| 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-18T15:04:03.259366Z"} |
| 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-17T16:56:51.972483Z"} |
| 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-17T16:56:51.972483Z"} |
| 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-17T15:40:30.458422Z"} |
| 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-08-17T14:42:42.502476Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |