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_alerts523,327 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 | expiry |
|---|
| 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 |
|---|
| f06e9d73-d328-4511-8f46-4331e10ef6a4 | 2026-08-18 13:00 | 2026-08-18 13:00 | 2026-08-18 13:00 | SLV | SLV261016C00059000 | call | 59.0000 | 2026-10-16 | 3.4500 | 3.4000 | 3.4500 | 57.7000 | 69000.00 | 69000.00 | 0.00 | 200 | 7 | 783 | 1056 | 0.741477272727273 | 0.418568571667628 | 0.418568571667628 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 38529495748.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 414f3c60-1fe6-4530-975b-2cd67ed6c3bd | 2026-08-18 13:48 | 2026-08-18 13:48 | 2026-08-18 13:48 | SLV | SLV261016C00059000 | call | 59.0000 | 2026-10-16 | 3.4000 | 3.3500 | 3.5000 | 57.6650 | 14960.00 | 3400.00 | 11220.00 | 44 | 7 | 1133 | 1056 | 1.07291666666667 | 0.415034113246133 | 0.415034113246133 | true | false | false | true | ||||||||||||||||
| 939975bd-da99-408d-8562-8bb78cd95934 | 2026-08-19 13:18 | 2026-08-19 13:18 | 2026-08-19 13:18 | SLV | SLV261016C00059000 | call | 59.0000 | 2026-10-16 | 4.3500 | 4.3500 | 4.4500 | 59.3399 | 130594.00 | 0.00 | 130594.00 | 300 | 11 | 791 | 1995 | 0.396491228070175 | 0.426023676793811 | 0.426023676793811 | true | false | false | true | ||||||||||||||||
| aaaafed6-ef74-4269-b1c6-d2a16be26049 | 2026-08-19 13:18 | 2026-08-19 13:18 | 2026-08-19 13:18 | SLV | SLV261016C00059000 | call | 59.0000 | 2026-10-16 | 4.3500 | 4.3500 | 4.4500 | 59.3250 | 22185.00 | 0.00 | 22185.00 | 51 | 5 | 842 | 1995 | 0.422055137844612 | 0.426920260449146 | 0.426920260449146 | false | false | false | true | ||||||||||||||||
| 9f8804ec-c317-4aeb-9b23-08d967144a06 | 2026-08-19 14:03 | 2026-08-19 14:03 | 2026-08-19 14:03 | SLV | SLV261016C00059000 | call | 59.0000 | 2026-10-16 | 4.5000 | 4.4000 | 4.5000 | 59.5400 | 32400.00 | 32400.00 | 0.00 | 72 | 11 | 1252 | 1995 | 0.627568922305764 | 0.429978836288964 | 0.429978836288964 | false | false | false | true | ||||||||||||||||
| 9d81a324-ea86-4467-b6dd-e73937d9e221 | 2026-08-27 13:44 | 2026-08-27 13:44 | 2026-08-27 13:44 | SLV | SLV261016C00059000 | call | 59.0000 | 2026-10-16 | 6.4000 | 6.4000 | 6.5000 | 62.8199 | 145944.00 | 0.00 | 145944.00 | 228 | 26 | 239 | 1325 | 0.180377358490566 | 0.446907453927743 | 0.448124849055869 | false | false | false | true | ||||||||||||||||
| 9ea2b94e-733c-475b-868e-b0196cfb7855 | 2026-08-28 11:02 | 2026-08-28 11:02 | 2026-08-28 11:02 | SLV | SLV261016C00059000 | call | 59.0000 | 2026-10-16 | 6.5500 | 6.5500 | 6.6500 | 63.1350 | 10480.00 | 0.00 | 10480.00 | 16 | 10 | 47 | 1422 | 0.0330520393811533 | 0.443302004220429 | 0.443302004220429 | false | false | false | true | ||||||||||||||||
| f22ac612-bc6e-43fc-929c-7f9a566d089d | 2026-09-10 10:24 | 2026-09-10 10:24 | 2026-09-10 10:24 | SLV | SLV261016C00059000 | call | 59.0000 | 2026-10-16 | 3.0000 | 3.0000 | 3.0500 | 58.2300 | 40800.00 | 0.00 | 40800.00 | 136 | 14 | 278 | 1682 | 0.165279429250892 | 0.445649310620985 | 0.445649310620985 | true | false | false | true | ||||||||||||||||
| 8f339a69-07b2-4e8f-91bf-5943aeac43dd | 2026-09-11 09:39 | 2026-09-11 09:39 | 2026-09-11 09:39 | SLV | SLV261016C00059000 | call | 59.0000 | 2026-10-16 | 2.9900 | 2.9900 | 3.1000 | 58.5950 | 31726.00 | 0.00 | 22126.00 | 106 | 9 | 184 | 2562 | 0.0718188914910226 | 0.424940011892465 | 0.424940011892465 | false | false | false | true | ||||||||||||||||
| 846392ae-53df-40fd-9b0b-635048b6be2b | 2026-09-15 15:00 | 2026-09-15 15:00 | 2026-09-15 15:00 | SLV | SLV261016C00059000 | call | 59.0000 | 2026-10-16 | 2.3700 | 2.3600 | 2.3700 | 57.6699 | 24885.00 | 24885.00 | 0.00 | 105 | 7 | 362 | 3676 | 0.0984766050054407 | 0.428432825369437 | 0.428432825369437 | false | false | false | true | ||||||||||||||||
| 8413636e-403a-4f7c-97ed-a9eeb095c948 | 2026-09-17 09:33 | 2026-09-17 09:33 | 2026-09-17 09:33 | SLV | SLV261016C00059000 | call | 59.0000 | 2026-10-16 | 2.8900 | 2.8100 | 2.8900 | 59.0850 | 30043.00 | 29762.00 | 281.00 | 104 | 9 | 146 | 3836 | 0.0380604796663191 | 0.403396621297889 | 0.415494577661978 | true | false | false | true | ||||||||||||||||
| 2b650e13-d29e-43e6-9157-56e5a9d188d5 | 2026-09-17 09:37 | 2026-09-17 09:37 | 2026-09-17 09:37 | SLV | SLV261016C00059000 | call | 59.0000 | 2026-10-16 | 2.8700 | 2.8700 | 2.9600 | 59.1850 | 30135.00 | 0.00 | 30135.00 | 105 | 6 | 717 | 3836 | 0.186913451511992 | 0.404278692651403 | 0.404278692651403 | false | false | false | true | ||||||||||||||||
| 425b1be2-9daf-4b38-9098-05b4056fc9cb | 2026-09-22 15:10 | 2026-09-22 15:10 | 2026-09-22 15:10 | SLV | SLV261016C00059000 | call | 59.0000 | 2026-10-16 | 3.1200 | 3.1000 | 3.2000 | 60.5685 | 26533.00 | 0.00 | 26533.00 | 85 | 9 | 385 | 3526 | 0.1091888825865 | 0.348727996132212 | 0.353903671097396 | false | false | false | true | ||||||||||||||||
| f646ecc0-6e73-4195-95bc-a5c820ef9aeb | 2026-09-24 10:43 | 2026-09-24 10:43 | 2026-09-24 10:43 | SLV | SLV261016C00059000 | call | 59.0000 | 2026-10-16 | 1.3300 | 1.3300 | 1.3600 | 57.2150 | 12236.00 | 0.00 | 12236.00 | 92 | 25 | 164 | 3803 | 0.043123849592427 | 0.360358026639172 | 0.360358026639172 | false | false | false | true | ||||||||||||||||
| bf69df5e-d2a0-4ddb-b582-0137ad4b5565 | 2026-09-25 10:01 | 2026-09-25 10:01 | 2026-09-25 10:01 | SLV | SLV261016C00059000 | call | 59.0000 | 2026-10-16 | 1.3000 | 1.2900 | 1.3300 | 57.0000 | 12995.00 | 5330.00 | 7665.00 | 100 | 7 | 148 | 3879 | 0.0381541634441866 | 0.333892814672238 | 0.333892814672238 | false | false | false | true | ||||||||||||||||
| 68ced055-6bc0-4920-9b21-a0bd54193425 | 2026-09-25 14:31 | 2026-09-25 14:31 | 2026-09-25 14:31 | SLV | SLV261016C00059000 | call | 59.0000 | 2026-10-16 | 1.5100 | 1.4700 | 1.5100 | 58.2500 | 11023.00 | 11023.00 | 0.00 | 73 | 14 | 646 | 3879 | 0.166537767465842 | 0.321383156710507 | 0.321383156710507 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T17:46:53.178792Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:11:58.135920Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:46:58.036194Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:10:39.996631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:44:10.025245Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:02:31.622340Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 38529495748.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:38:37.498256Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |