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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×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

95c4eee5-e73c-4f0f-a4d8-35d586e29943	2026-09-04 15:26	2026-09-04 15:26	2026-09-04 15:26	RIOT	RIOT260925C00021000	call	21.0000	2026-09-25	2.0900	2.0500	2.0900	21.7450	25916.00	25916.00	0.00	124	12	285	872	0.326834862385321	0.816169779096706	0.816169779096706	true	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-09-04T19:30:40.028430Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
b5c27ea5-e231-4257-8867-41877840040f	2026-09-04 15:24	2026-09-04 15:24	2026-09-04 15:24	RIOT	RIOT260918C00025000	call	25.0000	2026-09-18	0.4000	0.3600	0.4000	21.7000	10000.00	10000.00	0.00	250	7	1059	17415	0.0608096468561585	0.824812731362691	0.824812731362691	false	false	false	true
e80d3035-9eba-4f3e-8678-0da53c17ac17	2026-09-04 15:23	2026-09-04 15:23	2026-09-04 15:23	RIOT	RIOT260911C00022500	call	22.5000	2026-09-11	0.5700	0.5700	0.6200	21.6850	20178.00	0.00	20178.00	354	33	1243	3702	0.335764451647758	0.74978584773275	0.74978584773275	true	false	false	true
9ca93faf-367c-472b-b28a-43574c6cfd35	2026-09-04 14:30	2026-09-04 14:30	2026-09-04 14:30	RIOT	RIOT270115P00022000	put	22.0000	2027-01-15	4.4500	4.3250	4.4500	21.6600	596188.00	596188.00	0.00	1340	49	2923	1636	1.78667481662592	0.860298077990189	0.859713979251264	false	false	false	true
3effd0c1-567d-4891-baed-fab65b72da61	2026-09-04 14:02	2026-09-04 14:02	2026-09-04 14:02	RIOT	RIOT261120P00020000	put	20.0000	2026-11-20	2.4700	2.4700	2.5300	21.5200	30134.00	0.00	30134.00	122	16	124	62	2	0.861814672746019	0.861814672746019	false	false	false	true
f0673d08-985d-44be-83d5-9735f58a62bc	2026-09-04 13:13	2026-09-04 13:13	2026-09-04 13:13	RIOT	RIOT261218C00030000	call	30.0000	2026-12-18	1.7900	1.7900	1.8300	21.5600	127627.00	0.00	127627.00	713	10	720	21111	0.0341054426602245	0.88966604423199	0.88966604423199	false	false	false	true
b5a7ecab-277d-4447-8e96-18689a653075	2026-09-04 12:47	2026-09-04 12:47	2026-09-04 12:47	RIOT	RIOT261120C00029000	call	29.0000	2026-11-20	1.3900	1.2400	1.3900	21.5150	130521.00	130521.00	0.00	939	45	1146	108	10.6111111111111	0.883923439519836	0.883923439519836	false	false	false	true
7fa85c5e-7715-49d6-b1b5-5c4d101c68b1	2026-09-04 12:47	2026-09-04 12:47	2026-09-04 12:47	RIOT	RIOT261120C00028000	call	28.0000	2026-11-20	1.5600	1.4500	1.5600	21.5800	110901.00	108576.00	2325.00	711	44	917	73	12.5616438356164	0.878570225043393	0.8725458272327	true	false	false	true
a7327692-f063-4d2e-9d03-5502b0dd0858	2026-09-04 12:33	2026-09-04 12:33	2026-09-04 12:33	RIOT	RIOT261016C00021000	call	21.0000	2026-10-16	2.6600	2.5000	2.7700	21.5750	19684.00	19418.00	266.00	74	12	94	3540	0.0265536723163842	0.815711059388545	0.806195017501086	true	false	false	true
8e2352d9-65d0-4ccf-aeb2-a5502c2bae9f	2026-09-04 12:33	2026-09-04 12:33	2026-09-04 12:33	RIOT	RIOT261016C00023000	call	23.0000	2026-10-16	1.8300	1.7400	1.9200	21.5750	105408.00	105225.00	183.00	576	54	698	2490	0.280321285140562	0.818899579600869	0.811656749022086	true	false	false	true
42dde7f1-93ad-46e2-879c-42b31a36fea0	2026-09-04 12:33	2026-09-04 12:33	2026-09-04 12:33	RIOT	RIOT261016C00028000	call	28.0000	2026-10-16	0.6700	0.5900	0.6700	21.5300	33701.00	33701.00	0.00	503	20	563	269	2.09293680297398	0.831407567407825	0.831407567407825	false	false	false	true
a987a8c7-df1e-43e0-b8a1-1a43db586231	2026-09-04 12:30	2026-09-04 12:30	2026-09-04 12:30	RIOT	RIOT270115C00030000	call	30.0000	2027-01-15	2.0600	2.0600	2.0900	21.4800	82592.00	13376.00	69216.00	400	17	441	20001	0.0220488975551222	0.855503353758696	0.855503353758696	false	false	false	true
cb7b15ae-7551-4cd5-9bdb-d9c2727991ca	2026-09-04 11:31	2026-09-04 11:31	2026-09-04 11:31	RIOT	RIOT261016C00025000	call	25.0000	2026-10-16	1.1600	1.1300	1.1600	21.4600	26912.00	26912.00	0.00	232	22	482	6403	0.0752772138060284	0.80443404144941	0.80443404144941	false	false	false	true
93f11e76-0da3-44c7-af50-7fb217f12a37	2026-09-04 10:51	2026-09-04 10:51	2026-09-04 10:51	RIOT	RIOT260911P00022000	put	22.0000	2026-09-11	1.3200	1.3200	1.3900	21.2400	13200.00	0.00	13200.00	100	21	325	54	6.01851851851852	0.748406095549559	0.753821632737248	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
306ef9aa-6a5c-48bf-888b-766a0462325e	2026-09-04 10:19	2026-09-04 10:19	2026-09-04 10:19	RIOT	RIOT261218P00022000	put	22.0000	2026-12-18	4.0500	4.0000	4.1500	21.4000	19035.00	14175.00	4860.00	47	6	49	374	0.131016042780749	0.846208680769982	0.846208680769982	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
58cf104a-e394-48c1-b063-910911faa78b	2026-09-04 09:34	2026-09-04 09:34	2026-09-04 09:34	RIOT	RIOT260918P00018000	put	18.0000	2026-09-18	0.2900	0.2500	0.2900	21.0200	14585.00	10329.00	1316.00	509	13	848	6395	0.132603596559812	0.83875308435406	0.828287754791878	false	false	false	true
48a03c68-061b-4c28-b817-3c4ad6c4b638	2026-09-03 15:57	2026-09-03 15:57	2026-09-03 15:57	RIOT	RIOT260904C00022000	call	22.0000	2026-09-04	0.1600	0.1500	0.1700	21.1600	16000.00	0.00	13920.00	1000	6	6511	7023	0.927096682329489	1.02840386384553	1.02840386384553	false	false	false	true
0e0fece7-4cda-4cd6-a81b-77d8c7914e23	2026-09-03 15:52	2026-09-03 15:52	2026-09-03 15:52	RIOT	RIOT260918P00020000	put	20.0000	2026-09-18	0.8200	0.8200	0.8500	21.1450	11152.00	0.00	11152.00	136	5	560	8078	0.0693240901213172	0.798589730169303	0.798589730169303	false	false	false	true
ef9b4bab-c6d4-4a1b-9054-7ae1019dc662	2026-09-03 15:45	2026-09-03 15:45	2026-09-03 15:45	RIOT	RIOT260918C00020000	call	20.0000	2026-09-18	1.9700	1.8600	1.9700	21.1000	16351.00	16351.00	0.00	83	5	1775	18668	0.0950824941075637	0.801092179504662	0.801092179504662	false	false	false	true
a06d665f-9174-4e0f-b4ff-dd7d7b606d41	2026-09-03 15:33	2026-09-03 15:33	2026-09-03 15:33	RIOT	RIOT270115C00045000	call	45.0000	2027-01-15	0.5600	0.4700	0.5700	20.9500	14336.00	14281.00	55.00	256	8	418	2134	0.195876288659794	0.875024808986803	0.878830786025467	false	false	false	true
8a268da0-27a1-4497-b5e3-13f363faa2fa	2026-09-03 15:33	2026-09-03 15:32	2026-09-03 15:32	RIOT	RIOT260911C00018500	call	18.5000	2026-09-11	2.2900	2.2900	2.7400	20.9350	10534.00	0.00	10534.00	46	5	520	488	1.0655737704918	0.955603492346639	0.955603492346639	false	false	false	true
a5ed6171-3c5d-40fa-8c0a-e2bcbec89a56	2026-09-03 15:32	2026-09-03 15:32	2026-09-03 15:32	RIOT	RIOT260911P00019000	put	19.0000	2026-09-11	0.2100	0.2100	0.2500	20.9600	14217.00	0.00	14217.00	677	38	1903	436	4.36467889908257	0.73003545130154	0.73003545130154	false	false	false	true
07726324-48a7-424e-9844-a45295ddea26	2026-09-03 15:16	2026-09-03 15:16	2026-09-03 15:16	RIOT	RIOT260904C00018500	call	18.5000	2026-09-04	2.1500	2.1500	2.4900	20.8300	172000.00	0.00	172000.00	800	10	1677	2115	0.79290780141844	2.11859893753351	2.11859893753351	false	false	false	true
fb87a782-fdde-4d81-868f-5654e3d18e36	2026-09-03 14:47	2026-09-03 14:47	2026-09-03 14:47	RIOT	RIOT261218C00035000	call	35.0000	2026-12-18	0.9500	0.8200	0.9500	20.7750	11210.00	11210.00	0.00	118	7	119	12307	0.00966929389778175	0.897028395322818	0.897028395322818	false	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
ad680389-4566-4342-b88b-dc5bad8597ef	2026-09-03 13:30	2026-09-03 13:29	2026-09-03 13:29	RIOT	RIOT260911C00022500	call	22.5000	2026-09-11	0.3600	0.3300	0.3700	20.7150	18000.00	17676.00	324.00	500	34	1655	1104	1.49909420289855	0.789457284892756	0.789457284892756	false	false	false	true
1d543da4-d30b-4a0e-9f68-ecef443c2b0e	2026-09-03 13:24	2026-09-03 13:24	2026-09-03 13:24	RIOT	RIOT261016C00019000	call	19.0000	2026-10-16	3.2400	3.1500	3.4000	20.7500	44086.00	0.00	44086.00	136	6	446	591	0.754653130287648	0.818405858313499	0.818405858313499	false	false	false	true
44e9ab84-634f-4de2-9802-d834b1709f15	2026-09-03 13:19	2026-09-03 13:18	2026-09-03 13:18	RIOT	RIOT260911P00020000	put	20.0000	2026-09-11	0.5500	0.5200	0.5500	20.8400	16500.00	16500.00	0.00	300	12	707	308	2.29545454545455	0.75975002641331	0.75975002641331	false	false	false	true
2702f67d-811c-4c52-9a11-d92bc27913cc	2026-09-03 13:06	2026-09-03 13:05	2026-09-03 13:05	RIOT	RIOT261016C00028000	call	28.0000	2026-10-16	0.5900	0.5300	0.5900	20.7250	11800.00	11800.00	0.00	200	29	212	115	1.84347826086957	0.863986725368942	0.863986725368942	false	false	false	true
f9081ac3-6b1e-400c-a64e-e1ce70c33fcb	2026-09-03 12:54	2026-09-03 12:54	2026-09-03 12:54	RIOT	RIOT261016C00020000	call	20.0000	2026-10-16	2.6700	2.6500	2.6900	20.6460	10670.00	0.00	2660.00	40	5	304	1026	0.296296296296296	0.825563250110284	0.825563250110284	false	false	false	true
261f10ee-6b4b-4546-bc3f-c4167f5a0a04	2026-09-03 12:51	2026-09-03 12:51	2026-09-03 12:51	RIOT	RIOT260911C00023000	call	23.0000	2026-09-11	0.2400	0.2400	0.2600	20.7100	24000.00	0.00	24000.00	1000	7	10660	11666	0.913766500942911	0.765529106266173	0.765529106266173	true	false	false	true
fddc46de-fbe1-408d-96e3-4adc217cfb18	2026-09-03 12:49	2026-09-03 12:48	2026-09-03 12:48	RIOT	RIOT260911C00023000	call	23.0000	2026-09-11	0.2500	0.2500	0.2600	20.7550	12575.00	0.00	12575.00	503	6	9331	11666	0.799845705468884	0.766838509274773	0.766838509274773	true	false	false	true
28ff4618-e225-4e3c-b489-aeaa28b9534c	2026-09-03 12:44	2026-09-03 12:43	2026-09-03 12:43	RIOT	RIOT260911C00023000	call	23.0000	2026-09-11	0.2300	0.2300	0.2500	20.6750	34730.00	0.00	34730.00	1510	15	8656	11666	0.74198525630036	0.761597730402378	0.761597730402378	true	false	false	true
b799ae0c-a0ee-453e-b877-c31c949e1d71	2026-09-03 12:42	2026-09-03 12:42	2026-09-03 12:42	RIOT	RIOT260911C00023000	call	23.0000	2026-09-11	0.2400	0.2400	0.2600	20.7000	19848.00	0.00	19848.00	827	41	6999	11666	0.599948568489628	0.767833428741917	0.767833428741917	true	false	false	true
ffcb0f70-8078-4a5e-8f8d-4bd04d77f7a3	2026-09-03 12:41	2026-09-03 12:41	2026-09-03 12:41	RIOT	RIOT260911C00023000	call	23.0000	2026-09-11	0.2500	0.2500	0.2700	20.7300	24225.00	0.00	24225.00	969	54	5124	11666	0.439225098577062	0.772652431770342	0.772652431770342	true	false	false	true
b143d380-3662-4d87-8d0e-6b366ca7a51b	2026-09-03 12:41	2026-09-03 12:41	2026-09-03 12:41	RIOT	RIOT260911C00023000	call	23.0000	2026-09-11	0.2400	0.2300	0.2500	20.6800	17616.00	504.00	17088.00	734	29	6144	11666	0.526658666209498	0.772440370413272	0.772440370413272	true	false	false	true
1de90b0a-4798-4ac9-809b-8ed5dccd6849	2026-09-03 12:23	2026-09-03 12:23	2026-09-03 12:23	RIOT	RIOT261120C00023000	call	23.0000	2026-11-20	2.5100	2.5000	2.6700	20.6800	23092.00	251.00	22841.00	92	7	315	246	1.28048780487805	0.871723309778052	0.870366960555211	true	false	false	true
bd2e62fe-1a65-43d0-a877-f63e4393647c	2026-09-03 12:19	2026-09-03 12:18	2026-09-03 12:18	RIOT	RIOT260911C00023000	call	23.0000	2026-09-11	0.2800	0.2800	0.2900	20.8213	14000.00	0.00	14000.00	500	22	3645	11666	0.312446425510029	0.785288960974248	0.785288960974248	true	false	false	true
289ea722-bb31-41f6-8548-cac613cece37	2026-09-03 12:15	2026-09-03 12:15	2026-09-03 12:15	RIOT	RIOT270115P00020000	put	20.0000	2027-01-15	3.5500	3.5000	3.6500	20.7900	177500.00	19525.00	157975.00	500	12	510	5277	0.0966458214894827	0.840274070081795	0.840274070081795	false	false	false	true
3a3e059d-af7b-44a7-9b8e-cb4b20dc76bd	2026-09-03 12:13	2026-09-03 12:12	2026-09-03 12:12	RIOT	RIOT261218C00023000	call	23.0000	2026-12-18	3.0700	2.7900	3.2000	20.8101	15342.00	15342.00	0.00	50	5	60	639	0.0938967136150235	0.855220600142946	0.855220600142946	false	false	false	true
62628f92-ee6c-40d6-88b8-01c6f9ff54dd	2026-09-03 11:59	2026-09-03 11:59	2026-09-03 11:59	RIOT	RIOT261016P00020000	put	20.0000	2026-10-16	1.9300	1.8900	1.9400	20.7550	23203.00	23203.00	0.00	120	6	154	410	0.375609756097561	0.842432686817083	0.838765141058501	false	false	false	true
4c972819-552e-4f06-ba97-796c425716cd	2026-09-03 11:50	2026-09-03 11:50	2026-09-03 11:50	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	2.9000	2.7700	2.9900	20.7200	12471.00	12179.00	0.00	43	5	156	6648	0.0234657039711191	0.849577706414298	0.853582938776972	false	false	false	true
3108678e-fc28-4c93-aa40-2b7d58a65f2b	2026-09-03 11:50	2026-09-03 11:50	2026-09-03 11:50	RIOT	RIOT261016C00020000	call	20.0000	2026-10-16	2.7500	2.7400	2.8700	20.7200	13750.00	0.00	13750.00	50	8	229	1026	0.223196881091618	0.838386646698118	0.838386646698118	false	false	false	true
88961cfc-5366-4092-bb2e-1cde33e0bb39	2026-09-03 11:14	2026-09-03 11:14	2026-09-03 11:14	RIOT	RIOT261009P00016000	put	16.0000	2026-10-09	0.4100	0.4100	0.4500	20.4850	18819.00	0.00	18819.00	459	28	4372	20	218.6	0.823699524525034	0.823699524525034	false	false	false	true
69572cdb-3e64-4ead-8980-c088efffa1f3	2026-09-03 11:14	2026-09-03 11:14	2026-09-03 11:14	RIOT	RIOT261009P00016000	put	16.0000	2026-10-09	0.4100	0.4100	0.4200	20.4900	25748.00	0.00	25748.00	628	33	5000	20	250	0.824183549392334	0.824183549392334	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
11beb6eb-7c84-4f29-b3a6-f84334f9abbc	2026-09-03 11:13	2026-09-03 11:13	2026-09-03 11:13	RIOT	RIOT261009P00016000	put	16.0000	2026-10-09	0.4100	0.4000	0.4500	20.4100	18983.00	0.00	18983.00	463	25	2753	20	137.65	0.816411614891807	0.816411614891807	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