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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×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

8ab57543-1b83-4c98-8618-d5c9ceaecb31	2026-08-21 12:38	2026-08-21 12:37	2026-08-21 12:37	RIOT	RIOT280121C00020000	call	20.0000	2028-01-21	8.5000	8.5000	8.8000	19.8300	599250.00	0.00	599250.00	705	8	846	4446	0.190283400809717	0.913609753539461	0.913609753539461	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	7861674688.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T16:43:46.028086Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c194bdd9-6b74-4db6-b5d6-66adb9c408d2	2026-08-21 12:13	2026-08-21 12:13	2026-08-21 12:13	RIOT	RIOT261120P00018000	put	18.0000	2026-11-20	2.5500	2.5500	2.5700	20.1300	79050.00	0.00	79050.00	310	9	312	16	19.5	0.958402559949398	0.958402559949398	false	false	false	true
701193a5-9b1a-49c7-9adc-6962a285024c	2026-08-21 12:13	2026-08-21 12:13	2026-08-21 12:13	RIOT	RIOT261016C00022000	call	22.0000	2026-10-16	2.3200	2.3200	2.3600	20.1300	34336.00	0.00	34336.00	148	10	208	334	0.622754491017964	0.954960163891135	0.954960163891135	false	false	false	true
0dfaee66-6d5b-439c-b8fc-da5e30d0acd5	2026-08-21 12:13	2026-08-21 12:13	2026-08-21 12:13	RIOT	RIOT261120P00017000	put	17.0000	2026-11-20	2.0900	1.9100	2.1300	20.1450	191027.00	190608.00	419.00	914	33	942	21	44.8571428571429	0.96022900360549	0.967462460397352	false	false	false	true
6678bba6-8235-4a04-bbbc-a45ac788ff62	2026-08-21 12:13	2026-08-21 12:13	2026-08-21 12:13	RIOT	RIOT261120C00038000	call	38.0000	2026-11-20	0.6800	0.6800	0.7000	20.1700	74732.00	0.00	74732.00	1099	12	1099	0	0	0.998973915027954	0.998973915027954	true	false	false	true
e3d2d10f-4f55-455f-82f4-fddca507285a	2026-08-21 11:29	2026-08-21 11:29	2026-08-21 11:29	RIOT	RIOT260904C00021000	call	21.0000	2026-09-04	1.1300	1.0900	1.2300	20.1801	43731.00	339.00	43392.00	387	35	1227	1159	1.05867126833477	0.929233621176918	0.929233621176918	false	false	false	true
2168f74f-d8e0-4d8d-b49e-22e3bbd34f28	2026-08-21 10:04	2026-08-21 10:04	2026-08-21 10:04	RIOT	RIOT261016C00025000	call	25.0000	2026-10-16	1.9500	1.8600	2.0600	21.3450	19500.00	7605.00	11895.00	100	10	536	54	9.92592592592593	0.955516211724817	0.955516211724817	false	false	false	true
2f9091f7-a36c-4410-9684-d9368f39ac1c	2026-08-21 09:57	2026-08-21 09:57	2026-08-21 09:57	RIOT	RIOT260821C00020500	call	20.5000	2026-08-21	1.2000	1.1500	1.3200	21.6750	12000.00	0.00	12000.00	100	6	377	6121	0.0615912432609051	1.43664358938691	1.43664358938691	false	false	false	true
428372c1-56af-41c1-a6e2-80e84f668dd5	2026-08-21 09:50	2026-08-21 09:50	2026-08-21 09:50	RIOT	RIOT260821P00023000	put	23.0000	2026-08-21	1.1100	1.1100	1.2900	21.9800	17094.00	0.00	17094.00	154	11	155	1413	0.109695682944091	1.74822975090386	1.74822975090386	true	false	false	true
ee97d1f2-b48a-4503-95e4-5e73297c8025	2026-08-21 09:39	2026-08-21 09:39	2026-08-21 09:39	RIOT	RIOT260821C00020000	call	20.0000	2026-08-21	1.9900	1.9900	2.0400	21.9800	39800.00	0.00	39800.00	200	6	525	13113	0.0400366048959048	1.78729600886872	1.78729600886872	false	false	false	true
511b16f7-37f0-4e65-989c-aa69492c863d	2026-08-21 09:37	2026-08-21 09:36	2026-08-21 09:36	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.9000	1.7700	1.9200	21.9200	15580.00	15580.00	0.00	82	8	573	12988	0.0441176470588235	0.899716436698537	0.899716436698537	false	false	false	true
8580981e-c2fa-478b-9448-761c8b856359	2026-08-20 15:59	2026-08-20 15:59	2026-08-20 15:59	RIOT	RIOT260821C00021000	call	21.0000	2026-08-21	0.4500	0.4300	0.4500	20.9850	10395.00	10395.00	0.00	231	28	10713	14531	0.737251393572363	1.04131353184035	1.04131353184035	false	false	false	true
11d2dd76-3a4c-4c72-8902-755971853e75	2026-08-20 15:57	2026-08-20 15:57	2026-08-20 15:57	RIOT	RIOT260821C00022500	call	22.5000	2026-08-21	0.0900	0.0700	0.1000	20.9200	17703.00	16866.00	342.00	1967	57	3170	1922	1.64932362122789	1.2283848440538	1.2283848440538	true	false	false	true
091025a2-0e58-4bb9-9743-fc3cf371531f	2026-08-20 15:42	2026-08-20 15:42	2026-08-20 15:42	RIOT	RIOT260918C00022000	call	22.0000	2026-09-18	1.6200	1.5900	1.6300	20.8499	10692.00	10692.00	0.00	66	5	773	9738	0.0793797494352023	0.887967584150215	0.882979921010383	true	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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