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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

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

f35eb459-fd32-4d21-8772-2f0451af441d	2026-09-18 15:17	2026-09-18 15:17	2026-09-18 15:17	RIOT	RIOT260925C00022500	call	22.5000	2026-09-25	1.7100	1.6700	1.7700	23.6900	21335.00	16376.00	4959.00	125	11	5578	6122	0.911140150277687	0.769273329310488	0.778121223903531	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Technology	8912399706.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
9b9d56e5-bb9a-4ca3-9f0c-7b0be578aaf1	2026-09-18 10:38	2026-09-18 10:38	2026-09-18 10:38	RIOT	RIOT260918P00022500	put	22.5000	2026-09-18	0.2100	0.1800	0.2300	22.6800	10530.00	6834.00	3696.00	500	6	1764	1158	1.52331606217617	1.31729124065426	1.30817493332998	false	false	false	true
7c5b6d55-6310-430e-8947-ea7ff9e210b7	2026-09-16 11:00	2026-09-16 11:00	2026-09-16 11:00	RIOT	RIOT261120P00017000	put	17.0000	2026-11-20	1.2600	1.2600	1.5100	20.5050	14366.00	127.00	14239.00	114	14	114	1068	0.106741573033708	0.862505566996753	0.867579552181244	false	false	false	true
76474664-28e7-4a1b-a619-1f446dc67df7	2026-09-15 13:03	2026-09-15 13:03	2026-09-15 13:03	RIOT	RIOT260918C00019500	call	19.5000	2026-09-18	0.9300	0.8700	0.9300	19.9100	12246.00	12246.00	0.00	132	11	250	171	1.46198830409357	0.971485378224373	0.971485378224373	false	false	false	true
cb7ffd47-94be-43bf-bfdf-8f4ffee2b907	2026-09-15 11:24	2026-09-15 11:24	2026-09-15 11:24	RIOT	RIOT260918C00020000	call	20.0000	2026-09-18	0.8500	0.8500	0.8900	20.3150	12788.00	0.00	12788.00	150	16	639	15092	0.042340312748476	0.929251889359385	0.929251889359385	false	false	false	true
60979eb4-9860-48d3-a97d-9b4207d0a8cb	2026-09-15 09:53	2026-09-15 09:52	2026-09-15 09:52	RIOT	RIOT260918C00021000	call	21.0000	2026-09-18	0.4200	0.3200	0.4300	20.2100	20960.00	20960.00	0.00	500	6	702	8049	0.0872158032053671	0.988589242134532	0.988589242134532	false	false	false	true
b4cde647-e529-42de-9c73-8cca73047bf3	2026-09-11 15:30	2026-09-11 15:30	2026-09-11 15:30	RIOT	RIOT260911P00021500	put	21.5000	2026-09-11	0.2000	0.1600	0.2100	21.3000	45703.00	45703.00	0.00	2230	10	5511	2019	2.7295690936107	0.439775869579475	1.06234650895562	false	false	false	true
1622e368-bbeb-4dee-875f-c16703d1a6f6	2026-09-11 12:57	2026-09-11 12:57	2026-09-11 12:57	RIOT	RIOT260925C00023000	call	23.0000	2026-09-25	0.7400	0.7300	0.7700	21.5800	23125.00	1500.00	20350.00	312	45	3719	404	9.20544554455446	0.756353892743755	0.764942366344875	true	false	false	true
c5df9486-7532-42c6-9e1c-52fb3f988c3d	2026-09-10 11:02	2026-09-10 11:01	2026-09-10 11:01	RIOT	RIOT261023C00022000	call	22.0000	2026-10-23	2.3800	2.3100	2.3900	21.7150	12158.00	4529.00	0.00	51	11	207	29	7.13793103448276	0.830205926897843	0.833590708000462	false	false	false	true
720011f7-74a6-4239-ad9e-b379a5fda31d	2026-09-10 11:01	2026-09-10 11:01	2026-09-10 11:01	RIOT	RIOT261023C00022000	call	22.0000	2026-10-23	2.4100	2.2900	2.4300	21.7250	26258.00	11804.00	0.00	109	16	116	29	4	0.835128526213407	0.845282063842572	false	false	false	true
219be853-9731-4773-afd6-70d59451514d	2026-09-10 10:47	2026-09-10 10:47	2026-09-10 10:47	RIOT	RIOT270115P00018000	put	18.0000	2027-01-15	2.2700	2.2200	2.3500	21.6250	11136.00	6584.00	4552.00	49	15	61	782	0.0780051150895141	0.853988867721114	0.859451050278291	false	false	false	true
7e3a6c39-cf1e-48fc-b0dd-5994e5e2a50c	2026-09-09 14:10	2026-09-09 14:10	2026-09-09 14:10	RIOT	RIOT260911C00023000	call	23.0000	2026-09-11	0.2600	0.2300	0.2700	22.0650	13748.00	13748.00	0.00	526	37	890	21009	0.0423627968965681	0.927208645157132	0.94517312901304	true	false	false	true
584dba77-1d60-4ffd-bb4d-4d23b757c762	2026-09-09 13:47	2026-09-09 13:47	2026-09-09 13:47	RIOT	RIOT261218C00030000	call	30.0000	2026-12-18	1.7400	1.7100	1.7500	21.8750	27164.00	26820.00	344.00	156	6	742	21699	0.0341951241992719	0.869955380501252	0.874777344680678	false	false	false	true
bec8e927-53b2-42bd-935e-0678eede11e0	2026-09-08 15:12	2026-09-08 15:12	2026-09-08 15:12	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3500	1.3400	1.3900	22.5300	12389.00	0.00	12389.00	92	5	6848	12220	0.560392798690671	0.828569324416147	0.83297778958425	false	false	false	true
6fbb73c2-2e5f-4c6d-841c-84a63fb92e57	2026-09-08 15:01	2026-09-08 15:01	2026-09-08 15:01	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3400	1.3300	1.3800	22.4750	13105.00	0.00	13105.00	98	5	6007	12220	0.491571194762684	0.834528851626889	0.838955052001768	false	false	false	true
fcfb7343-ad9a-490f-8539-1f8d76ae7726	2026-09-08 14:30	2026-09-08 14:30	2026-09-08 14:30	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3800	1.3700	1.4100	22.5150	16268.00	0.00	16268.00	118	6	3494	12220	0.285924713584288	0.844637745582956	0.849045726651133	false	false	false	true
9bf4858c-cdd7-47de-ac5a-ff44917f9227	2026-09-08 11:12	2026-09-08 11:12	2026-09-08 11:12	RIOT	RIOT270115C00030000	call	30.0000	2027-01-15	2.4900	2.4800	2.5000	22.2550	91662.00	49750.00	41912.00	368	17	383	19613	0.0195278641717228	0.889104146871391	0.893036445574324	false	false	false	true
8527e633-0818-4649-8e99-8f86e574e8d7	2026-09-08 09:56	2026-09-08 09:56	2026-09-08 09:56	RIOT	RIOT260918C00023000	call	23.0000	2026-09-18	1.0700	1.0100	1.1000	22.3500	11130.00	11023.00	107.00	104	9	689	11828	0.0582516063577951	0.925349191378047	0.909821512628357	false	false	false	true
5f6a52ed-03cb-42c6-85c5-657863b82df1	2026-09-04 10:37	2026-09-04 10:37	2026-09-04 10:37	RIOT	RIOT260925C00023000	call	23.0000	2026-09-25	1.0500	1.0500	1.1000	21.4700	10512.00	432.00	10080.00	100	9	126	330	0.381818181818182	0.795523237067272	0.795523237067272	false	false	false	true
4299fa90-af39-4d6f-88ec-8e4bbdcdd239	2026-09-04 09:35	2026-09-04 09:35	2026-09-04 09:35	RIOT	RIOT260918P00018000	put	18.0000	2026-09-18	0.3000	0.2700	0.3000	20.9813	14810.00	14810.00	0.00	494	21	1502	6395	0.234870992963253	0.832688296665582	0.843003648524783	true	false	false	true
9c0e7981-cd30-437e-bbf8-f3060677d7d4	2026-09-03 14:36	2026-09-03 14:36	2026-09-03 14:36	RIOT	RIOT270115C00035000	call	35.0000	2027-01-15	1.1400	0.9900	1.2300	20.6900	19583.00	10552.00	9031.00	172	12	277	6383	0.0433965220115933	0.84758829674261	0.850210437892109	false	false	false	true
bed429a2-b973-4493-8d39-9c2685a8a26a	2026-09-03 11:14	2026-09-03 11:14	2026-09-03 11:14	RIOT	RIOT261009P00016000	put	16.0000	2026-10-09	0.4500	0.4000	0.4500	20.4850	25739.00	25739.00	0.00	575	47	3896	20	194.8	0.823699524525034	0.851788899487451	false	false	false	true
f0cd7af5-b3d1-4c5c-9337-7f04f904c26c	2026-09-03 11:13	2026-09-03 11:13	2026-09-03 11:13	RIOT	RIOT261009P00016000	put	16.0000	2026-10-09	0.4200	0.4200	0.4800	20.3900	41414.00	86.00	41328.00	986	46	2198	20	109.9	0.821037486725269	0.828542437537721	true	false	false	true
103f8b84-429d-47a5-882c-5bcd30fe7b41	2026-09-03 11:10	2026-09-03 11:10	2026-09-03 11:10	RIOT	RIOT261120C00023000	call	23.0000	2026-11-20	2.3500	2.3500	2.4200	20.3579	39088.00	239.00	38849.00	166	6	180	246	0.731707317073171	0.871161694666005	0.871161694666005	true	false	false	true
74a7d52c-2ce8-44c6-a2c8-f724a1e111d3	2026-09-03 09:36	2026-09-03 09:36	2026-09-03 09:36	RIOT	RIOT260904C00019500	call	19.5000	2026-09-04	0.1900	0.1500	0.1900	18.7150	18736.00	18311.00	0.00	1000	25	2036	7070	0.287977369165488	1.13484665017179	1.21364505195398	false	false	false	true
40ae9409-cdbe-4a4e-8036-31cb55361225	2026-08-31 15:58	2026-08-31 15:58	2026-08-31 15:58	RIOT	RIOT260918C00020000	call	20.0000	2026-09-18	0.9500	0.9000	1.0000	19.0250	54238.00	4462.00	19376.00	571	11	4190	11366	0.368643322188985	0.787150424003421	0.793187293555465	true	false	false	true
b516a736-a5cb-4c89-aadb-786181de508f	2026-08-31 15:58	2026-08-31 15:58	2026-08-31 15:58	RIOT	RIOT260918C00020000	call	20.0000	2026-09-18	0.9200	0.8200	0.9300	18.9450	92382.00	92382.00	0.00	1000	6	2613	11366	0.229896181594228	0.789385163611555	0.801561229194594	false	false	false	true
249af89f-355f-427e-9736-ca7e46c93f94	2026-08-31 15:58	2026-08-31 15:58	2026-08-31 15:58	RIOT	RIOT260918C00020000	call	20.0000	2026-09-18	0.9200	0.8200	0.9400	18.9450	91849.00	91849.00	0.00	1000	5	1613	11366	0.141914481787788	0.789385163611555	0.789385163611555	false	false	false	true
d2a94f51-acf5-403a-9baf-6432959192ae	2026-08-28 13:53	2026-08-28 13:53	2026-08-28 13:53	RIOT	RIOT270319C00027000	call	27.0000	2027-03-19	2.7000	2.6400	2.8400	18.9850	23224.00	273.00	22951.00	86	15	180	28	6.42857142857143	0.858556613365592	0.864347988455331	false	false	false	true
32fb8deb-e2bc-4f11-b4c4-2ed6371061c1	2026-08-27 14:26	2026-08-27 14:25	2026-08-27 14:25	RIOT	RIOT270115P00022000	put	22.0000	2027-01-15	5.0000	4.6500	5.1000	20.9200	303512.00	51500.00	251012.00	607	12	624	1051	0.59372026641294	0.885494293188506	0.889437654353442	false	false	false	true
6af93c84-b4d9-406c-b036-47199ee01ebd	2026-08-27 10:48	2026-08-27 10:48	2026-08-27 10:48	RIOT	RIOT260904C00022500	call	22.5000	2026-09-04	0.8800	0.8700	0.9200	21.8150	13210.00	0.00	13210.00	150	12	571	403	1.41687344913151	0.899297883487909	0.905442617021054	false	false	false	true
36b4f7da-acc0-4cfd-9fa8-492e80652a5c	2026-08-27 10:46	2026-08-27 10:46	2026-08-27 10:46	RIOT	RIOT260904P00020500	put	20.5000	2026-09-04	0.5300	0.5100	0.6200	21.8200	33751.00	771.00	32980.00	636	46	1103	307	3.5928338762215	0.855769105431334	0.873901364782453	false	false	false	true
78a17538-9d0a-47a8-9352-bbee705f4744	2026-08-25 10:34	2026-08-25 10:34	2026-08-25 10:34	RIOT	RIOT260828C00021000	call	21.0000	2026-08-28	0.7500	0.7200	0.7600	20.8400	22876.00	22876.00	0.00	303	13	1648	7956	0.207139265962795	1.0902573790121	1.10352838145202	true	false	false	true
2289a99a-0a98-4ccb-970b-982563b7bc55	2026-08-24 15:27	2026-08-24 15:27	2026-08-24 15:27	RIOT	RIOT261016C00027000	call	27.0000	2026-10-16	0.9200	0.9200	1.0300	20.0500	46184.00	0.00	46184.00	500	11	1013	1362	0.743759177679883	0.921607232820398	0.922648860494304	true	false	false	true
5882a1a2-817d-49b9-8098-b2a978401164	2026-08-24 11:32	2026-08-24 11:32	2026-08-24 11:32	RIOT	RIOT260828C00021000	call	21.0000	2026-08-28	0.8400	0.8300	0.8500	20.8300	21232.00	8425.00	10707.00	254	40	7170	2756	2.60159651669086	1.05198196001523	1.063655587345	false	false	false	true
f97138a5-601b-4969-ba07-e36999a8c215	2026-08-21 10:47	2026-08-21 10:47	2026-08-21 10:47	RIOT	RIOT261016C00027000	call	27.0000	2026-10-16	1.1100	0.9800	1.2800	20.0300	55610.00	0.00	55610.00	500	6	1040	45	23.1111111111111	0.972519700767186	0.972519700767186	false	false	false	true
0c4d950f-53d7-4f6d-a0f9-798ed40b323e	2026-08-21 10:47	2026-08-21 10:47	2026-08-21 10:47	RIOT	RIOT260821P00021000	put	21.0000	2026-08-21	1.0000	0.9900	1.0500	20.0400	29433.00	21513.00	7920.00	293	6	1373	4420	0.310633484162896	0.748052961060292	1.65376126691198	false	false	false	true
db2eba7e-eef5-432b-b575-272748477120	2026-08-21 09:31	2026-08-21 09:31	2026-08-21 09:31	RIOT	RIOT260821C00020000	call	20.0000	2026-08-21	1.7600	1.7200	2.0000	21.9100	12699.00	0.00	12699.00	72	6	124	13113	0.00945626477541371	2.79935015104673	2.79935015104673	false	false	false	true
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
f6461013-a222-44fa-b1bf-7a4e186266b4	2026-08-17 11:59	2026-08-17 11:59	2026-08-17 11:59	RIOT	RIOT260821C00020000	call	20.0000	2026-08-21	0.6000	0.5900	0.6100	19.6600	15622.00	15022.00	0.00	260	15	3197	13343	0.239601289065428	0.914197039906764	0.923607343341091	false	false	false	true