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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = RIOT×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate	price

388409e3-c909-485e-8947-c08e933c7bfa	2026-08-20 15:42	2026-08-20 15:42	2026-08-20 15:42	RIOT	RIOT260925P00020000	put	20.0000	2026-09-25	1.8000	1.7600	2.0000	20.8500	81355.00	360.00	80995.00	451	5	471	91	5.17582417582418	0.86643823125289	0.880753692806886	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Technology	7861674688.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
cd41d7fa-b3a2-4397-90fe-9586b42bb85c	2026-08-20 15:39	2026-08-20 15:39	2026-08-20 15:39	RIOT	RIOT260911C00019000	call	19.0000	2026-09-11	2.7500	2.4900	2.7500	20.7700	13750.00	13750.00	0.00	50	8	62	184	0.33695652173913	0.871480499995648	0.871480499995648	false	false	false	true	false
353c32e6-a604-4e41-a97b-09476b582b6a	2026-08-20 15:38	2026-08-20 15:38	2026-08-20 15:38	RIOT	RIOT260821C00019000	call	19.0000	2026-08-21	1.7500	1.6400	1.7500	20.7200	106925.00	106925.00	0.00	611	7	1915	3507	0.546050755631594	1.06159530871937	1.06159530871937	false	false	false	true	false
e4addf91-91a7-453b-9e80-7df8ded87b02	2026-08-20 15:04	2026-08-20 15:04	2026-08-20 15:04	RIOT	RIOT260828P00018000	put	18.0000	2026-08-28	0.1900	0.1800	0.2100	20.3750	11400.00	0.00	11400.00	600	6	1232	1245	0.989558232931727	0.829862781919683	0.829862781919683	false	false	false	true	false
97adb2a0-a5d5-4614-b6b1-ec5fd771daa2	2026-08-20 14:14	2026-08-20 14:13	2026-08-20 14:13	RIOT	RIOT260918C00018000	call	18.0000	2026-09-18	3.3500	3.2500	3.3500	20.4200	86765.00	86765.00	0.00	259	6	310	5232	0.0592507645259939	0.86409393587228	0.86409393587228	false	false	false	true	false
19962273-7ac6-4356-8940-5a1df4cbebd2	2026-08-20 13:59	2026-08-20 13:59	2026-08-20 13:59	RIOT	RIOT260828C00023000	call	23.0000	2026-08-28	0.3200	0.3100	0.3400	20.6800	14080.00	2208.00	10688.00	440	89	13880	861	16.1207897793264	0.862330931878166	0.863552063649119	true	false	false	true	false
4a55d0da-4108-4363-b9cd-2bb78fbf04f6	2026-08-20 13:35	2026-08-20 13:35	2026-08-20 13:35	RIOT	RIOT260828C00023000	call	23.0000	2026-08-28	0.3200	0.3200	0.3300	20.5800	31680.00	0.00	31680.00	990	14	13251	861	15.390243902439	0.887944615570332	0.887944615570332	true	false	false	true	false
da28fc3d-13ca-4e91-a0ed-07adfb3b1106	2026-08-20 13:29	2026-08-20 13:29	2026-08-20 13:29	RIOT	RIOT260828C00023000	call	23.0000	2026-08-28	0.3200	0.3200	0.3300	20.6500	16576.00	0.00	16576.00	518	34	12247	861	14.2241579558653	0.870875730098129	0.870875730098129	true	false	false	true	false
66241a84-97e5-400e-9fe6-28094bd38372	2026-08-20 13:25	2026-08-20 13:25	2026-08-20 13:25	RIOT	RIOT260821C00019500	call	19.5000	2026-08-21	1.1800	1.1800	1.2300	20.6000	89208.00	0.00	89208.00	756	53	2207	2364	0.933587140439932	0.994479702463742	0.994479702463742	false	false	false	true	false
65957d99-362e-4463-a23c-f3b1edb2240a	2026-08-20 13:21	2026-08-20 13:21	2026-08-20 13:21	RIOT	RIOT260828C00023000	call	23.0000	2026-08-28	0.3100	0.3100	0.3400	20.5150	14787.00	0.00	14787.00	477	10	11010	861	12.787456445993	0.892520987460235	0.892520987460235	true	false	false	true	false
ec1a7746-0907-49e3-8ea0-2b25ce48efc5	2026-08-20 12:30	2026-08-20 12:30	2026-08-20 12:30	RIOT	RIOT260918P00020000	put	20.0000	2026-09-18	1.8500	1.7600	1.8500	20.1600	191475.00	191475.00	0.00	1035	23	4121	5132	0.803000779423227	0.870591594750381	0.870591594750381	false	false	false	true	false
5632f3d5-f952-4e86-98b3-24122408b8ac	2026-08-20 11:55	2026-08-20 11:55	2026-08-20 11:55	RIOT	RIOT260828C00023000	call	23.0000	2026-08-28	0.2900	0.2900	0.3200	20.2700	123743.00	0.00	123743.00	4267	37	7073	861	8.21486643437863	0.928006569365118	0.928006569365118	false	false	false	true	false
58685313-6625-451e-86fb-6392758d0b1e	2026-08-20 11:36	2026-08-20 11:36	2026-08-20 11:36	RIOT	RIOT260918P00020000	put	20.0000	2026-09-18	1.7800	1.6200	1.7800	20.2750	535602.00	535602.00	0.00	3009	8	3085	5132	0.601130163678878	0.861361181894192	0.861361181894192	false	false	false	true	false
edd52f95-5647-427e-b48b-d8330b5f04d0	2026-08-20 11:31	2026-08-20 11:31	2026-08-20 11:31	RIOT	RIOT260821C00021000	call	21.0000	2026-08-21	0.3100	0.3100	0.3500	20.5700	20770.00	0.00	20770.00	670	33	5707	14531	0.392746541875989	1.14021565856976	1.14021565856976	false	false	false	true	false
7fc2689d-d0bf-42cb-8880-fdd279c8fc70	2026-08-20 11:31	2026-08-20 11:31	2026-08-20 11:31	RIOT	RIOT260904C00021000	call	21.0000	2026-09-04	1.3100	1.2600	1.4200	20.5200	22138.00	129.00	21877.00	169	13	261	528	0.494318181818182	0.894514910574402	0.897269454460708	true	false	false	true	false
f35c1260-2ff0-406a-baf6-0f4db8a43cf8	2026-08-20 11:28	2026-08-20 11:28	2026-08-20 11:28	RIOT	RIOT260828C00023000	call	23.0000	2026-08-28	0.3400	0.3400	0.3800	20.5450	18802.00	0.00	18802.00	553	52	2317	861	2.69105691056911	0.918585729962004	0.918585729962004	true	false	false	true	false
04a1d435-b570-4fe2-a450-7e9414c571a3	2026-08-20 11:28	2026-08-20 11:28	2026-08-20 11:28	RIOT	RIOT260828C00023000	call	23.0000	2026-08-28	0.3400	0.3400	0.3800	20.5350	12070.00	0.00	12070.00	355	24	2672	861	3.10336817653891	0.921051249815238	0.921051249815238	true	false	false	true	false
b4ca370c-46bb-46e7-afb2-8b7db3fd582e	2026-08-20 11:26	2026-08-20 11:26	2026-08-20 11:26	RIOT	RIOT260828C00023000	call	23.0000	2026-08-28	0.3500	0.3500	0.3800	20.4700	15050.00	0.00	13685.00	430	8	1639	861	1.90360046457607	0.948101624274216	0.948101624274216	true	false	false	true	false
beed1745-f155-405d-886b-cc7f3ce3e1cb	2026-08-20 11:19	2026-08-20 11:19	2026-08-20 11:19	RIOT	RIOT260828C00023000	call	23.0000	2026-08-28	0.3600	0.3600	0.3800	20.5800	17352.00	0.00	17352.00	482	40	1189	861	1.38095238095238	0.931611020512772	0.931611020512772	true	false	false	true	false
95717352-4c8d-47a6-8d8c-bb7f5f29ee65	2026-08-20 10:50	2026-08-20 10:50	2026-08-20 10:50	RIOT	RIOT261218C00035000	call	35.0000	2026-12-18	1.0300	0.9400	1.1500	20.3700	516096.00	52390.00	463706.00	5000	5	5001	6867	0.728265618173875	0.901095533351268	0.901095533351268	false	false	false	true	false
85e4aecf-21e8-4201-88de-36ba7a45cb20	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	RIOT	RIOT261016C00020000	call	20.0000	2026-10-16	3.1000	2.9900	3.1500	20.3900	10850.00	310.00	10540.00	35	5	440	788	0.558375634517767	0.89890168682931	0.89890168682931	false	false	false	true	false
ec222130-347d-4cf1-a78c-056ad2fb5a31	2026-08-20 09:56	2026-08-20 09:55	2026-08-20 09:55	RIOT	RIOT260821C00020500	call	20.5000	2026-08-21	0.4100	0.3900	0.4100	20.1200	12300.00	12300.00	0.00	300	8	2219	4783	0.463934768973448	1.36666790167429	1.36666790167429	false	false	false	true	false
1d223f56-dcc6-479d-96ce-c9c999dc35bd	2026-08-20 09:55	2026-08-20 09:54	2026-08-20 09:54	RIOT	RIOT260918C00032000	call	32.0000	2026-09-18	0.1500	0.1100	0.1500	19.9600	14355.00	14355.00	0.00	957	45	991	16317	0.0607342035913465	1.01359772054418	1.01268084547303	false	false	false	true	false
b35d3c82-4bb9-4765-aaa7-e662ab554b20	2026-08-20 09:52	2026-08-20 09:52	2026-08-20 09:52	RIOT	RIOT260821C00020500	call	20.5000	2026-08-21	0.3300	0.3300	0.3500	19.9897	13266.00	0.00	13266.00	402	41	1901	4783	0.39744929960276	1.29416993789724	1.29416993789724	false	false	false	true	false
df06e2f0-aec6-4841-a07d-a61c0353d4c0	2026-08-20 09:48	2026-08-20 09:48	2026-08-20 09:48	RIOT	RIOT261218C00022000	call	22.0000	2026-12-18	3.5000	3.3500	3.5500	20.2000	18550.00	18550.00	0.00	53	13	141	4899	0.0287813839559094	0.889449384058261	0.889449384058261	false	false	false	true	false
b85ca023-4333-416b-973c-cd1bfc5499bb	2026-08-20 09:48	2026-08-20 09:48	2026-08-20 09:48	RIOT	RIOT260821C00019500	call	19.5000	2026-08-21	0.9400	0.9400	1.0000	20.2200	10716.00	0.00	10716.00	114	14	958	2364	0.405245346869712	1.20105939779254	1.20105939779254	false	false	false	true	false
fb211a28-b689-4d57-afea-1844a3d24ce5	2026-08-20 09:46	2026-08-20 09:46	2026-08-20 09:46	RIOT	RIOT260821C00019500	call	19.5000	2026-08-21	1.0800	1.0200	1.0800	20.3600	10476.00	10476.00	0.00	97	35	795	2364	0.336294416243655	1.3501650093812	1.30702375606447	true	false	false	true	false
17fb62b4-8cfd-4f7a-9aa9-a20d9da60c08	2026-08-20 09:43	2026-08-20 09:43	2026-08-20 09:43	RIOT	RIOT260828C00020000	call	20.0000	2026-08-28	1.3000	1.2200	1.3000	20.3600	33670.00	33670.00	0.00	259	5	843	3034	0.277851021753461	0.925316500506268	0.925316500506268	true	false	false	true	false
80c183f9-6674-48b8-a8de-48943d12870e	2026-08-20 09:42	2026-08-20 09:42	2026-08-20 09:42	RIOT	RIOT260821C00020500	call	20.5000	2026-08-21	0.4800	0.4400	0.5000	20.2500	14400.00	672.00	13728.00	300	13	747	4783	0.156178130880201	1.40065065010216	1.40065065010216	false	false	false	true	false
49a1841f-0e5f-47a1-8222-ce5296255bf3	2026-08-19 15:32	2026-08-19 15:32	2026-08-19 15:32	RIOT	RIOT260911C00020000	call	20.0000	2026-09-11	1.2100	1.1300	1.2100	18.9750	27830.00	27830.00	0.00	230	37	332	190	1.74736842105263	0.849796232002306	0.849796232002306	false	false	false	true	false
d24c437b-cfc3-4553-8f0d-51b13a8a296a	2026-08-19 15:14	2026-08-19 15:14	2026-08-19 15:14	RIOT	RIOT260828C00018500	call	18.5000	2026-08-28	1.1900	1.0900	1.2000	18.8850	65622.00	63004.00	2618.00	550	49	977	155	6.30322580645161	0.811141008551849	0.834255221172035	false	false	false	true	false
9bcfe46e-cb24-4d3c-96cd-6f4c36cd524b	2026-08-19 15:14	2026-08-19 15:14	2026-08-19 15:14	RIOT	RIOT260828P00020000	put	20.0000	2026-08-28	1.6500	1.6400	1.6500	18.9600	13860.00	13860.00	0.00	84	11	108	1000	0.108	0.871641475321474	0.871641475321474	false	false	false	true	false
ad15c8fc-19bd-44f6-8177-77a618bc238e	2026-08-19 14:23	2026-08-19 14:23	2026-08-19 14:23	RIOT	RIOT260918C00024000	call	24.0000	2026-09-18	0.5500	0.5300	0.5600	19.0400	10780.00	1045.00	9735.00	196	5	1342	12981	0.103381865803867	0.890577466366743	0.890577466366743	false	false	false	true	false
e9c2dc9d-adf2-4482-afac-b6819f405bca	2026-08-19 14:23	2026-08-19 14:23	2026-08-19 14:23	RIOT	RIOT260918C00024000	call	24.0000	2026-09-18	0.5500	0.5400	0.5600	19.0400	12155.00	0.00	11275.00	221	9	1093	12981	0.0841999845928665	0.890577466366743	0.890577466366743	false	false	false	true	false
da233653-0515-44e2-bed1-d6b3f07bb78a	2026-08-19 14:17	2026-08-19 14:16	2026-08-19 14:16	RIOT	RIOT260918C00024000	call	24.0000	2026-09-18	0.5400	0.5200	0.5400	19.0150	13230.00	13230.00	0.00	245	29	818	12981	0.0630151760265003	0.887798817748921	0.887798817748921	false	false	false	true	false
8915e6c9-f1f5-41de-9dfc-95bcd2476957	2026-08-19 14:12	2026-08-19 14:12	2026-08-19 14:12	RIOT	RIOT261218C00025000	call	25.0000	2026-12-18	2.1200	2.0800	2.1200	19.0200	56392.00	56392.00	0.00	266	24	928	22164	0.0418696986103591	0.887070354172767	0.887070354172767	false	false	false	true	false
67ffc6c8-a50a-4af7-8c88-16c65d0b5c81	2026-08-19 11:53	2026-08-19 11:53	2026-08-19 11:53	RIOT	RIOT260828C00020000	call	20.0000	2026-08-28	0.8800	0.8700	0.8900	19.5500	31800.00	0.00	12528.00	363	18	4430	4857	0.912085649577929	0.866381546916061	0.874580898156664	true	false	false	true	false
a5cc8a93-ba69-42ab-825f-93f958a4af71	2026-08-19 11:50	2026-08-19 11:50	2026-08-19 11:50	RIOT	RIOT260821C00019000	call	19.0000	2026-08-21	0.9200	0.9200	0.9700	19.6000	14536.00	0.00	14536.00	158	9	2711	3785	0.716248348745046	0.996384478224482	0.996384478224482	false	false	false	true	false
2856c7b3-d680-4cc4-85d5-2115beed5f71	2026-08-19 11:46	2026-08-19 11:46	2026-08-19 11:46	RIOT	RIOT260828C00020000	call	20.0000	2026-08-28	0.9600	0.9500	0.9600	19.7050	17472.00	17472.00	0.00	182	15	3551	4857	0.731109738521721	0.879685370465365	0.879685370465365	false	false	false	true	false
35f72396-1d79-4a24-b4bd-39ee89d830a9	2026-08-19 11:43	2026-08-19 11:42	2026-08-19 11:42	RIOT	RIOT260821C00017000	call	17.0000	2026-08-21	2.7100	2.4700	2.7100	19.6800	59078.00	59078.00	0.00	218	6	1744	84	20.7619047619048	1.14608984742244	1.14608984742244	false	false	false	true	false
0a8ccc6a-534b-49d2-aff7-118a5de0c633	2026-08-19 11:41	2026-08-19 11:41	2026-08-19 11:41	RIOT	RIOT260918C00018000	call	18.0000	2026-09-18	2.7500	2.6400	2.7500	19.5700	48125.00	48125.00	0.00	175	6	661	5241	0.126120969280672	0.852358807340456	0.852358807340456	false	false	false	true	false
cae8b457-331c-4c5f-8087-afad0d64b970	2026-08-19 11:40	2026-08-19 11:40	2026-08-19 11:40	RIOT	RIOT260918C00018000	call	18.0000	2026-09-18	2.7600	2.7000	2.8700	19.6001	21528.00	276.00	18492.00	78	14	478	5241	0.0912039687082618	0.847040919586639	0.847040919586639	false	false	false	true	false
e6ce039c-a317-4ca7-a303-845e801472b3	2026-08-19 11:40	2026-08-19 11:40	2026-08-19 11:40	RIOT	RIOT261218P00021000	put	21.0000	2026-12-18	4.6000	4.5000	4.6000	19.5900	55660.00	55660.00	0.00	121	9	129	640	0.2015625	0.874435346107382	0.874435346107382	false	false	false	true	false
8f00a738-4a94-49ac-945d-aa18dbef9392	2026-08-19 11:38	2026-08-19 11:38	2026-08-19 11:38	RIOT	RIOT260918C00018000	call	18.0000	2026-09-18	2.7500	2.6700	2.7500	19.5700	31900.00	31900.00	0.00	116	10	323	5241	0.0616294600267125	0.852358807340456	0.852358807340456	false	false	false	true	false
bb10e001-1192-494a-9612-45ed0b2b8610	2026-08-19 11:10	2026-08-19 11:10	2026-08-19 11:10	RIOT	RIOT261016C00020000	call	20.0000	2026-10-16	2.5700	2.4300	2.5800	19.3800	27484.00	25713.00	1771.00	107	6	167	194	0.860824742268041	0.90915337427529	0.89283377511633	true	false	false	true	false
8e7b58ee-ce7a-4c03-a9ff-2b8e3006e5c4	2026-08-19 11:01	2026-08-19 11:00	2026-08-19 11:00	RIOT	RIOT270319C00020000	call	20.0000	2027-03-19	4.9000	4.7500	4.9000	19.1350	31850.00	31850.00	0.00	65	15	69	165	0.418181818181818	0.884008359084193	0.884008359084193	false	false	false	true	false
7ef18042-178e-4b63-b67f-731f488f8a65	2026-08-19 10:57	2026-08-19 10:57	2026-08-19 10:57	RIOT	RIOT260918C00020000	call	20.0000	2026-09-18	1.4900	1.4900	1.5200	19.0950	13410.00	0.00	11771.00	90	7	559	11271	0.04959630911188	0.84510080466792	0.84510080466792	false	false	false	true	false
c1f578f5-e7a0-407a-a6f2-2ca605a6b899	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	RIOT	RIOT260821C00020000	call	20.0000	2026-08-21	0.2400	0.2000	0.2600	19.0497	23736.00	23736.00	0.00	989	63	3830	13581	0.282011633900302	1.03717971475789	1.03717971475789	false	false	false	true	false
ab9d2226-7cee-4438-8d28-41500bcb4948	2026-08-19 10:55	2026-08-19 10:55	2026-08-19 10:55	RIOT	RIOT260904C00020000	call	20.0000	2026-09-04	0.8800	0.8300	0.8800	18.8700	17952.00	17952.00	0.00	204	8	307	231	1.32900432900433	0.83891552011722	0.83891552011722	true	false	false	true	false
ff892308-1702-4d77-9d6f-bedacb17e1ae	2026-08-19 10:23	2026-08-19 10:23	2026-08-19 10:23	RIOT	RIOT261016P00011000	put	11.0000	2026-10-16	0.1600	0.0900	0.2800	18.1541	1703520.00	0.00	1703520.00	109200	2	109200	28	3900	0.864222578325237	0.864222578325237	false	true	false	true	true