Options flow alerts (market-wide)
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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44493ca9-97b8-44c1-9d14-6bd746d7c0cd | 2026-09-18 14:37 | 2026-09-18 14:37 | 2026-09-18 14:37 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 1.8300 | 1.7800 | 1.8300 | 60.2000 | 54900.00 | 54900.00 | 0.00 | 300 | 28 | 5094 | 5851 | 0.870620406768074 | 0.379272359783226 | 0.379272359783226 | 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-09-18T18:43:10.830314Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 6a807240-9a86-4283-a1ba-5e67519cea83 | 2026-09-18 13:41 | 2026-09-18 13:41 | 2026-09-18 13:41 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 1.8800 | 1.8800 | 1.9000 | 60.3100 | 733576.00 | 0.00 | 733576.00 | 3902 | 17 | 4681 | 5851 | 0.800034182191078 | 0.379775624778799 | 0.379775624778799 | 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-09-18T17:59:53.998874Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 63c17786-5c99-4107-9e6e-8fc39764e8ef | 2026-09-18 12:28 | 2026-09-18 12:28 | 2026-09-18 12:28 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 1.7900 | 1.7400 | 1.8000 | 60.0800 | 24881.00 | 23270.00 | 1611.00 | 139 | 9 | 639 | 5851 | 0.109212100495642 | 0.380829052037401 | 0.380829052037401 | 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-09-18T16:45:45.480252Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 0a66260a-b644-4f1c-8b25-5fb73229ea6c | 2026-09-17 11:18 | 2026-09-17 11:18 | 2026-09-17 11:18 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 1.7800 | 1.7700 | 1.7800 | 59.4400 | 74226.00 | 74226.00 | 0.00 | 417 | 5 | 970 | 5429 | 0.178670104991711 | 0.411810900227267 | 0.411810900227267 | true | 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-09-17T15:18:48.953485Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 0557a049-1c4b-40f8-a095-55505cb79943 | 2026-09-17 09:30 | 2026-09-17 09:30 | 2026-09-17 09:30 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 1.7100 | 1.6800 | 1.7800 | 59.0100 | 29583.00 | 684.00 | 28899.00 | 173 | 7 | 179 | 5429 | 0.0329710812304292 | 0.42540283065676 | 0.426587348733877 | 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-09-17T13:32:41.851557Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 103df7e6-ccff-43dd-aad5-28a65b301c38 | 2026-09-11 09:38 | 2026-09-11 09:38 | 2026-09-11 09:38 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 2.0100 | 1.9800 | 2.0500 | 58.7200 | 86832.00 | 66531.00 | 20301.00 | 432 | 9 | 542 | 5478 | 0.0989412194231471 | 0.445364107877054 | 0.445364107877054 | 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-09-11T13:46:58.036194Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ddf7d35a-a144-47ed-a2f6-102d3c4576b3 | 2026-09-10 14:13 | 2026-09-10 14:13 | 2026-09-10 14:13 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 1.7600 | 1.7600 | 1.8100 | 57.6900 | 11440.00 | 0.00 | 11440.00 | 65 | 11 | 1081 | 4843 | 0.223208754903985 | 0.45711401150357 | 0.45711401150357 | 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-09-10T18:37:18.479310Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c7c663b9-426f-4be1-b218-4a780fcc170e | 2026-09-09 14:42 | 2026-09-09 14:42 | 2026-09-09 14:42 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 3.1500 | 3.1500 | 3.2500 | 61.0850 | 66150.00 | 0.00 | 66150.00 | 210 | 6 | 1498 | 4768 | 0.314177852348993 | 0.445759552239786 | 0.445759552239786 | 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-09-09T18:58:33.363095Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7147cd0f-239b-48cb-af5a-41f0e60dbb0c | 2026-09-09 10:37 | 2026-09-09 10:36 | 2026-09-09 10:36 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 3.5400 | 3.5000 | 3.5500 | 61.0000 | 106062.00 | 106062.00 | 0.00 | 300 | 6 | 599 | 4768 | 0.125629194630872 | 0.463709753162493 | 0.460815061927638 | false | false | false | true | false | 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-09T14:40:24.011597Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ba5f5bd9-4c3c-4e9a-b005-f2d67e3166b2 | 2026-09-04 15:54 | 2026-09-04 15:54 | 2026-09-04 15:54 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 2.7200 | 2.7200 | 2.7600 | 59.8300 | 81600.00 | 0.00 | 81600.00 | 300 | 15 | 416 | 4951 | 0.0840234296101798 | 0.436527875104122 | 0.436527875104122 | 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-09-04T20:00:02.053596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8a57fb66-5a06-40f8-81de-9fee4a5cd51d | 2026-09-02 10:10 | 2026-09-02 10:10 | 2026-09-02 10:10 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 2.5600 | 2.5400 | 2.5900 | 59.0950 | 12800.00 | 0.00 | 12800.00 | 50 | 5 | 127 | 4997 | 0.0254152491494897 | 0.445409347208804 | 0.445409347208804 | 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-09-02T14:11:00.326314Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6bf80207-9fb8-413f-8169-18dd789fc12a | 2026-09-01 14:17 | 2026-09-01 14:17 | 2026-09-01 14:17 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 2.1900 | 2.1600 | 2.2100 | 58.2450 | 10941.00 | 0.00 | 648.00 | 50 | 6 | 310 | 5010 | 0.06187624750499 | 0.4326679278357 | 0.436516227070975 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 38529495748.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 |
| 0591586e-1dde-4b9d-88ab-b2720fb494b7 | 2026-08-28 11:24 | 2026-08-28 11:24 | 2026-08-28 11:24 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 4.5400 | 4.4500 | 4.5500 | 62.5899 | 44492.00 | 44492.00 | 0.00 | 98 | 8 | 2000 | 5094 | 0.392618767177071 | 0.448715996459896 | 0.448715996459896 | 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-28T15:36:02.227679Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ffc4f106-cb68-4ad3-8329-554b3b23f9f2 | 2026-08-28 11:08 | 2026-08-28 11:08 | 2026-08-28 11:08 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 4.8000 | 4.7500 | 4.8000 | 62.9826 | 48000.00 | 48000.00 | 0.00 | 100 | 9 | 1586 | 5094 | 0.311346682371417 | 0.452498366600718 | 0.452498366600718 | true | 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-28T15:11:58.135920Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 283bd098-f35a-4798-a01b-500b35f7833a | 2026-08-28 10:55 | 2026-08-28 10:55 | 2026-08-28 10:55 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 4.8200 | 4.7500 | 4.8500 | 63.0350 | 43380.00 | 43380.00 | 0.00 | 90 | 5 | 1319 | 5094 | 0.258932076953278 | 0.451323551886642 | 0.451323551886642 | 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-28T15:11:58.135920Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3ec058f1-9a23-45b5-bd65-a8dd4bce7e93 | 2026-08-27 10:06 | 2026-08-27 10:06 | 2026-08-27 10:06 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 4.1000 | 4.0500 | 4.1000 | 61.5699 | 67240.00 | 67240.00 | 0.00 | 164 | 5 | 309 | 4653 | 0.0664087685364281 | 0.457059379829759 | 0.457059379829759 | 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-27T14:11:49.813441Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b833b9cf-7ff2-46e2-aa26-4988548f52e4 | 2026-08-21 15:19 | 2026-08-21 15:19 | 2026-08-21 15:19 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 5.0500 | 4.9500 | 5.0500 | 62.8216 | 25246.00 | 25246.00 | 0.00 | 50 | 7 | 1136 | 4049 | 0.280563102000494 | 0.456632752341619 | 0.452479358492813 | 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-21T19:32:44.160800Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ffdf2b50-8eb2-4339-b41e-1e61b0aa5988 | 2026-08-21 10:08 | 2026-08-21 10:08 | 2026-08-21 10:08 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 5.1000 | 5.0500 | 5.1000 | 62.7900 | 51000.00 | 51000.00 | 0.00 | 100 | 6 | 417 | 4049 | 0.102988392195604 | 0.46371707364704 | 0.46371707364704 | 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-21T14:12:36.432845Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 169a9808-3f66-4ea9-a575-41a17ebe2579 | 2026-08-20 12:49 | 2026-08-20 12:49 | 2026-08-20 12:49 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 4.4000 | 4.3500 | 4.4000 | 61.6595 | 23760.00 | 23760.00 | 0.00 | 54 | 5 | 951 | 2994 | 0.317635270541082 | 0.45193302579906 | 0.45193302579906 | 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-20T17:13:28.834542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 51e9d3f5-669f-49a5-bac5-0790eea6ed7c | 2026-08-19 12:08 | 2026-08-19 12:08 | 2026-08-19 12:08 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 3.4000 | 3.3000 | 3.4500 | 59.6601 | 23460.00 | 17680.00 | 5100.00 | 69 | 27 | 302 | 2585 | 0.116827852998066 | 0.44767952129405 | 0.44767952129405 | true | 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-19T16:28:32.259187Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a6d0ae12-c133-4558-b65f-b939e47f9875 | 2026-08-19 12:05 | 2026-08-19 12:05 | 2026-08-19 12:05 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 3.3500 | 3.3500 | 3.4000 | 59.5850 | 16080.00 | 0.00 | 16080.00 | 48 | 19 | 233 | 2585 | 0.0901353965183752 | 0.446054931991746 | 0.446054931991746 | 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-19T16:07:57.422777Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 80ee8715-1dc7-47ce-99d4-94c23e5858d0 | 2026-08-19 12:05 | 2026-08-19 12:05 | 2026-08-19 12:05 | SLV | SLV261016C00062000 | call | 62.0000 | 2026-10-16 | 3.3500 | 3.3500 | 3.4000 | 59.5850 | 21775.00 | 0.00 | 17085.00 | 65 | 8 | 185 | 2585 | 0.0715667311411992 | 0.446054931991746 | 0.446054931991746 | 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-19T16:07:57.422777Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |