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: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

d0f70417-380f-4d29-ac32-8af07f723f27	2026-09-23 15:39	2026-09-23 15:39	2026-09-23 15:39	RIOT	RIOT260925P00023000	put	23.0000	2026-09-25	0.1000	0.0900	0.1000	24.7900	17580.00	17580.00	0.00	1758	35	1943	1178	1.64940577249576	0.891487991182984	0.891487991182984	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	9265143105.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T19:42:45.926021Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
389b8302-1b77-4fa2-bbfa-cbc72681cb9c	2026-09-23 15:27	2026-09-23 15:27	2026-09-23 15:27	RIOT	RIOT261002P00024000	put	24.0000	2026-10-02	0.8600	0.7900	0.8700	24.0000	17298.00	8526.00	0.00	200	9	396	557	0.710951526032316	0.843555483753868	0.843555483753868	false	false	false	true
ca48288e-0c1d-4cb3-be1f-3a4b3b215df5	2026-09-23 15:24	2026-09-23 15:23	2026-09-23 15:23	RIOT	RIOT261002P00025000	put	25.0000	2026-10-02	1.3500	1.2700	1.3500	24.8950	27000.00	27000.00	0.00	200	7	324	348	0.931034482758621	0.838815441934887	0.838815441934887	false	false	false	true
133152e2-5626-4a66-b133-90cca8f737f6	2026-09-23 14:37	2026-09-23 14:37	2026-09-23 14:37	RIOT	RIOT270115C00035000	call	35.0000	2027-01-15	2.0300	2.0000	2.1500	24.9850	20706.00	2030.00	18676.00	102	9	118	6897	0.0171088879222851	0.851075811737359	0.851075811737359	true	false	false	true
7dcb0119-73e5-408d-b5cc-0905152f1321	2026-09-23 14:33	2026-09-23 14:33	2026-09-23 14:33	RIOT	RIOT261120C00030000	call	30.0000	2026-11-20	1.8300	1.8200	1.8900	25.0500	18483.00	3294.00	15189.00	101	14	1647	2028	0.812130177514793	0.862470612663076	0.862960789201556	true	false	false	true
23f61395-c8f5-464d-99b6-87ae50334660	2026-09-23 14:27	2026-09-23 14:26	2026-09-23 14:26	RIOT	RIOT261016C00028000	call	28.0000	2026-10-16	1.0300	1.0300	1.0700	25.0000	17098.00	0.00	17098.00	166	11	810	2017	0.401586514625682	0.825107962930922	0.825107962930922	false	false	false	true
200f14b7-36f3-4531-988c-bdabbfdfb110	2026-09-23 13:40	2026-09-23 13:40	2026-09-23 13:40	RIOT	RIOT261218C00029000	call	29.0000	2026-12-18	2.7400	2.7100	3.0500	24.0000	75076.00	57266.00	17810.00	274	18	539	1501	0.359093937375083	0.851567799365331	0.851567799365331	false	false	false	true
fc41c398-5df0-4a5a-af8d-97e6a1916c16	2026-09-23 13:31	2026-09-23 13:31	2026-09-23 13:31	RIOT	RIOT261218P00023000	put	23.0000	2026-12-18	2.8000	2.7900	2.8000	25.0000	19320.00	19320.00	0.00	69	11	78	749	0.104138851802403	0.844589574753733	0.844589574753733	false	false	false	true
da520a5f-5cc3-419d-a9b8-ba7b396a352c	2026-09-23 13:31	2026-09-23 13:31	2026-09-23 13:31	RIOT	RIOT261218P00022000	put	22.0000	2026-12-18	2.3500	2.3400	2.3500	25.0000	243439.00	128545.00	114894.00	1038	41	1056	472	2.23728813559322	0.846373981842006	0.846373981842006	false	false	false	true
9339d1bc-8c6b-4ea7-8138-9b351a43c4a1	2026-09-23 13:31	2026-09-23 13:31	2026-09-23 13:31	RIOT	RIOT261218C00025000	call	25.0000	2026-12-18	4.3000	4.3000	4.3500	25.0000	21500.00	0.00	21500.00	50	5	85	23477	0.00362056480811007	0.848277852625767	0.848277852625767	false	false	false	true
09c75837-8ec2-49e2-b843-c3b4fc755f37	2026-09-23 13:31	2026-09-23 13:31	2026-09-23 13:31	RIOT	RIOT261120P00022000	put	22.0000	2026-11-20	1.8100	1.7900	1.8100	25.0000	19711.00	16471.00	3240.00	109	11	246	358	0.687150837988827	0.863052370581354	0.863052370581354	false	false	false	true
32bdac0a-8a7e-408a-b8c4-ae53a1861c9f	2026-09-23 13:23	2026-09-23 13:23	2026-09-23 13:23	RIOT	RIOT261120C00029000	call	29.0000	2026-11-20	2.1900	2.0500	2.1900	25.0750	14016.00	14016.00	0.00	64	10	94	1040	0.0903846153846154	0.885216202007596	0.885216202007596	false	false	false	true
f6531b5b-150e-4004-b74d-4452d8779976	2026-09-23 13:22	2026-09-23 13:22	2026-09-23 13:22	RIOT	RIOT261120C00030000	call	30.0000	2026-11-20	1.9000	1.8500	1.9200	25.0850	69540.00	67640.00	1900.00	366	8	1373	2028	0.677021696252465	0.878027589948474	0.878027589948474	false	false	false	true
a0b9bd4c-9f26-47e0-9634-765f38190c2b	2026-09-23 13:22	2026-09-23 13:22	2026-09-23 13:22	RIOT	RIOT261120C00030000	call	30.0000	2026-11-20	1.8200	1.8200	1.8500	24.9750	42224.00	0.00	42224.00	232	7	334	2028	0.164694280078895	0.86765221208194	0.86765221208194	false	false	false	true
4373f9d9-39a2-4db1-b86c-82efc82050bf	2026-09-23 13:10	2026-09-23 13:10	2026-09-23 13:10	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.6500	4.8500	24.9150	745440.00	694080.00	28800.00	1553	44	36690	6801	5.39479488310543	0.857960651660282	0.854036337306258	false	false	false	true
cbde97d2-fcb8-49b8-9946-50d7b924c80c	2026-09-23 13:09	2026-09-23 13:09	2026-09-23 13:09	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.7000	4.8500	24.8900	63360.00	20640.00	42720.00	132	7	35137	6801	5.16644611086605	0.856839550499631	0.856839550499631	false	false	false	true
75820288-427b-4863-8714-ac1083628125	2026-09-23 13:09	2026-09-23 13:09	2026-09-23 13:09	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.8000	4.8500	24.8550	160320.00	0.00	160320.00	334	20	35005	6801	5.1470372004117	0.86076296387288	0.86076296387288	false	false	false	true
40c02192-3846-4a31-afcf-97be093a3da0	2026-09-23 13:09	2026-09-23 13:09	2026-09-23 13:09	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.8000	4.8500	24.8650	145920.00	0.00	145920.00	304	20	34671	6801	5.0979267754742	0.859642113141805	0.859642113141805	false	false	false	true
88466b8c-de03-4a60-9bd0-9de24a871ccc	2026-09-23 13:04	2026-09-23 13:04	2026-09-23 13:04	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.8000	4.8500	24.8900	158880.00	0.00	158880.00	331	22	34279	6801	5.04028819291281	0.856839550499631	0.856839550499631	false	false	false	true
510adb76-dd15-4bcf-84d6-8e28c5d40850	2026-09-23 13:04	2026-09-23 13:03	2026-09-23 13:03	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.8000	4.8500	24.8703	144000.00	0.00	144000.00	300	18	33948	6801	4.99161887957653	0.859048022458219	0.859048022458219	false	false	false	true
029d8246-ef2b-466f-8c03-53a363b2987a	2026-09-23 13:02	2026-09-23 13:02	2026-09-23 13:02	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.8000	4.8500	24.8800	40320.00	0.00	40320.00	84	21	33608	6801	4.94162623143655	0.857960651660282	0.857960651660282	false	false	false	true
410fe398-2207-445a-b020-7723255ea873	2026-09-23 13:02	2026-09-23 13:02	2026-09-23 13:02	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.8000	4.8500	24.8700	38400.00	0.00	38400.00	80	20	33524	6801	4.92927510660197	0.859081650977238	0.859081650977238	false	false	false	true
ec66befa-2205-4dfd-abfa-36c045a024ac	2026-09-23 13:02	2026-09-23 13:02	2026-09-23 13:02	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.8000	4.8500	24.8750	42240.00	0.00	42240.00	88	22	33444	6801	4.91751213056903	0.857400113950212	0.858521163909579	false	false	false	true
de8b0b38-1b63-416c-8100-413ba4a7a75f	2026-09-23 13:02	2026-09-23 13:02	2026-09-23 13:02	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.8000	4.8500	24.9000	21120.00	0.00	21120.00	44	11	33356	6801	4.9045728569328	0.855718345255002	0.855718345255002	false	false	false	true
26db9726-9f39-41e5-b2c3-a09a9341b9b1	2026-09-23 13:02	2026-09-23 13:02	2026-09-23 13:02	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.8000	4.8500	24.9000	17280.00	0.00	17280.00	36	9	33260	6801	4.89045728569328	0.852354082469449	0.855718345255002	false	false	false	true
9399df6b-1381-4001-904d-aba5c4f1fd12	2026-09-23 13:00	2026-09-23 13:00	2026-09-23 13:00	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.8000	4.8500	24.9000	11520.00	0.00	11520.00	24	6	33212	6801	4.88339950007352	0.855157702898476	0.855718345255002	false	false	false	true
656caa9d-8488-49d4-b5a5-8cbb610a7d28	2026-09-23 12:59	2026-09-23 12:59	2026-09-23 12:59	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.8000	4.8500	24.9000	11520.00	0.00	11520.00	24	6	33136	6801	4.87222467284223	0.855718345255002	0.855718345255002	false	false	false	true
4b3e6f15-fe70-4f89-ae62-9a2e88f43a54	2026-09-23 12:57	2026-09-23 12:56	2026-09-23 12:56	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.7000	4.8500	24.8700	77760.00	55680.00	22080.00	162	7	32265	6801	4.74415527128363	0.859081650977238	0.859081650977238	false	false	false	true
02c36847-b720-42ef-bc82-8d9efcff3781	2026-09-23 12:57	2026-09-23 12:56	2026-09-23 12:56	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.7000	4.8500	24.8700	153600.00	116640.00	36960.00	320	5	32585	6801	4.79120717541538	0.859081650977238	0.859081650977238	false	false	false	true
b8145dc5-8062-41ef-8226-fbf8eb354b3b	2026-09-23 12:56	2026-09-23 12:56	2026-09-23 12:56	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.6500	4.8500	24.8850	245275.00	243840.00	960.00	511	47	29773	6801	4.37773856785767	0.863564674281199	0.857400113950212	false	false	false	true
861db758-412a-43b6-8eae-e39f4125db7f	2026-09-23 12:56	2026-09-23 12:56	2026-09-23 12:56	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.6500	4.8500	24.8850	152640.00	144480.00	6720.00	318	22	30115	6801	4.42802529039847	0.857400113950212	0.857400113950212	false	false	false	true
41dda898-7b3c-4a99-b1b1-bff194275be4	2026-09-23 12:56	2026-09-23 12:56	2026-09-23 12:56	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.7500	4.5500	4.7500	24.7400	111625.00	111625.00	0.00	235	15	24964	6801	3.67063667107778	0.865414215925347	0.864296969918847	false	false	false	true
93ec160f-95fa-4931-8398-7026d83b5ebf	2026-09-23 12:56	2026-09-23 12:55	2026-09-23 12:55	RIOT	RIOT270115C00034000	call	34.0000	2027-01-15	2.0600	1.9900	2.1600	24.6702	30902.00	208.00	30694.00	150	37	151	206	0.733009708737864	0.84102367268081	0.845980604453752	false	false	false	true
cbd80633-dcc6-449a-bb3d-db2be3e92981	2026-09-23 11:37	2026-09-23 11:36	2026-09-23 11:36	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.7000	4.8000	24.8750	26870.00	26870.00	0.00	56	17	21602	6801	3.17629760329363	0.858521163909579	0.858521163909579	false	false	false	true
54bc2c10-241a-4e4c-9bee-92af0521c21b	2026-09-23 11:36	2026-09-23 11:35	2026-09-23 11:35	RIOT	RIOT261016C00025000	call	25.0000	2026-10-16	2.0100	2.0100	2.0200	24.9250	10653.00	0.00	10653.00	53	5	341	8161	0.0417840950863865	0.808948352661215	0.808948352661215	false	false	false	true
9e311c82-ee8e-4e85-8eb3-53e240692180	2026-09-23 10:57	2026-09-23 10:57	2026-09-23 10:57	RIOT	RIOT270115C00026000	call	26.0000	2027-01-15	4.4000	4.4000	4.6000	25.0000	10120.00	0.00	10120.00	23	6	23	575	0.04	0.843800756490525	0.843800756490525	false	false	false	true
d5ae99f3-500a-40ed-8c95-2106192dc99a	2026-09-23 10:22	2026-09-23 10:22	2026-09-23 10:22	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.6500	4.8000	24.7500	53760.00	53760.00	0.00	112	8	17520	6801	2.57609175121306	0.872526501637879	0.872526501637879	false	false	false	true
a5d7dc9b-7bc3-476e-963f-d73fafcb96ea	2026-09-23 10:22	2026-09-23 10:22	2026-09-23 10:22	RIOT	RIOT260925P00024000	put	24.0000	2026-09-25	0.3400	0.3200	0.3400	24.7800	16014.00	16014.00	0.00	471	14	1583	1595	0.992476489028213	0.916116915642897	0.916116915642897	false	false	false	true
74d7b94a-7aac-4200-898b-b9f11ef1357d	2026-09-23 10:10	2026-09-23 10:10	2026-09-23 10:10	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.6000	4.8000	24.0000	1077120.00	1077120.00	0.00	2244	60	14876	6801	2.18732539332451	0.873086448189215	0.86580563242399	false	false	false	true
413fa328-0812-462e-a0d3-e500df628561	2026-09-23 10:10	2026-09-23 10:10	2026-09-23 10:10	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.6000	4.8000	24.8000	12000.00	12000.00	0.00	25	5	12512	6801	1.83972945155124	0.866925980770852	0.866925980770852	false	false	false	true
0c61db41-411f-4cd9-9677-b0303e395c17	2026-09-23 10:10	2026-09-23 10:09	2026-09-23 10:09	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.7000	4.8000	24.8400	146400.00	146400.00	0.00	305	29	11947	6801	1.75665343331863	0.862444060125994	0.862444060125994	false	false	false	true
e6579add-e1ab-4327-8cd5-71579d6f9ea4	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	RIOT	RIOT261009C00026000	call	26.0000	2026-10-09	1.3200	1.2200	1.4000	25.0000	26400.00	26400.00	0.00	200	5	292	4117	0.070925431139179	0.805777926123082	0.805777926123082	false	false	false	true
8e6fbc12-df4e-49b8-b064-5bedfab69540	2026-09-23 09:59	2026-09-23 09:59	2026-09-23 09:59	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.7500	4.8000	24.8500	99840.00	99840.00	0.00	208	5	9032	6801	1.32803999411851	0.861323352993526	0.861323352993526	false	false	false	true
6c1b1c23-5b10-4400-86bd-2979dd8951cb	2026-09-23 09:58	2026-09-23 09:58	2026-09-23 09:58	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.7000	4.8000	24.8631	13920.00	13920.00	0.00	29	5	7458	6801	1.09660344067049	0.859855082292587	0.859855082292587	false	false	false	true
99a170d5-7f1a-4572-98f5-5d4784ee2931	2026-09-23 09:58	2026-09-23 09:58	2026-09-23 09:58	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.8000	4.7000	4.8000	24.8550	13440.00	13440.00	0.00	28	6	7429	6801	1.09233936185855	0.86076296387288	0.86076296387288	false	false	false	true
0a7549d1-76bd-4229-8ac0-2b660b47f969	2026-09-23 09:57	2026-09-23 09:57	2026-09-23 09:57	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.7500	4.7000	4.7500	24.8350	229425.00	229425.00	0.00	483	26	7153	6801	1.05175709454492	0.853678813515508	0.853678813515508	false	false	false	true
f54f8fb9-b85b-42cd-b621-c49f08c7771c	2026-09-23 09:54	2026-09-23 09:54	2026-09-23 09:54	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.7500	4.6000	4.7500	24.8400	68875.00	68875.00	0.00	145	5	4629	6801	0.680635200705779	0.853119726633975	0.853119726633975	false	false	false	true
b9656ef7-8a2d-47e3-8e9e-9d7ac1893104	2026-09-23 09:54	2026-09-23 09:54	2026-09-23 09:54	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.7400	4.6000	4.8000	24.8499	92850.00	60325.00	32525.00	196	5	4484	6801	0.659314806646081	0.852012658842518	0.852012658842518	false	false	false	true
3796bc34-dfcb-4469-abc3-d5ebba320c82	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	RIOT	RIOT270115C00025000	call	25.0000	2027-01-15	4.6500	4.5000	4.6500	24.7750	30225.00	30225.00	0.00	65	10	1017	6801	0.149536832818703	0.8417223855583	0.8417223855583	false	false	false	true
38a1f09c-992b-4118-a3a7-4b445a03e5c1	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	RIOT	RIOT261016C00037000	call	37.0000	2026-10-16	0.1100	0.1100	0.1200	24.0000	10318.00	0.00	10318.00	938	14	4510	67	67.3134328358209	0.873034493200631	0.873034493200631	false	false	false	true