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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = RIOT261002C00024000×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

9dbb653e-e5c7-4677-8987-7966a18e16a3	2026-09-25 15:18	2026-09-25 15:18	2026-09-25 15:18	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	0.5800	0.5800	0.6000	23.0386	11890.00	0.00	11890.00	205	19	5599	12672	0.441840277777778	0.755067975340431	0.755067975340431	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	8630955505.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:24:28.165724Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
df9d3bcb-f70f-49f2-9146-b117bb385e8e	2026-09-25 15:12	2026-09-25 15:12	2026-09-25 15:12	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	0.5700	0.5600	0.6000	23.0000	11799.00	741.00	11058.00	207	25	4354	12672	0.343592171717172	0.758554867197011	0.758554867197011	true	false	false	true
23b2abe4-712e-4f23-b8c9-bef60492202f	2026-09-25 13:42	2026-09-25 13:42	2026-09-25 13:42	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	0.5500	0.4800	0.5700	22.9100	10120.00	10120.00	0.00	184	15	2389	12672	0.188525883838384	0.770424407088265	0.768926292069711	true	false	false	true
197f6561-c218-4d19-bdb0-cca177a1ccce	2026-09-25 13:19	2026-09-25 13:19	2026-09-25 13:19	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	0.4900	0.4900	0.5000	22.0000	12152.00	0.00	12152.00	248	13	1945	12672	0.153488005050505	0.746855285400622	0.746855285400622	true	false	false	true
4775c95b-2ac5-4c21-93ad-6596dab89eb7	2026-09-25 13:09	2026-09-25 13:08	2026-09-25 13:08	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	0.4800	0.4800	0.5000	22.7800	19200.00	0.00	19200.00	400	46	1556	12672	0.122790404040404	0.746777206862606	0.746777206862606	true	false	false	true
9249c0ed-4f92-4532-bcb2-20a91ad8a14b	2026-09-18 15:39	2026-09-18 15:39	2026-09-18 15:39	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3300	1.3300	1.3900	23.7000	66500.00	0.00	66500.00	500	43	5361	8262	0.648874364560639	0.7837740275243	0.7837740275243	true	false	false	true
996a42ad-957b-4f40-bf4d-b5d755a6ec48	2026-09-18 15:21	2026-09-18 15:21	2026-09-18 15:21	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3700	1.3700	1.4000	23.8000	27948.00	0.00	27948.00	204	36	4822	8262	0.583635923505205	0.77799768470004	0.77799768470004	true	false	false	true
97a84a84-25f8-4efb-8264-8e0a757eca3c	2026-09-18 15:20	2026-09-18 15:20	2026-09-18 15:20	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3600	1.3600	1.3900	23.7650	10064.00	0.00	10064.00	74	13	4519	8262	0.546961994674413	0.782236630016044	0.782236630016044	true	false	false	true
f58b360c-9ba4-4af5-bc36-56143b44d717	2026-09-18 15:15	2026-09-18 15:15	2026-09-18 15:15	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3000	1.3000	1.3500	23.7350	41860.00	0.00	41860.00	322	33	4319	8262	0.522754780924716	0.758086417988754	0.758086417988754	true	false	false	true
c092afad-9130-4b6c-9c66-fb1957972c39	2026-09-18 15:15	2026-09-18 15:15	2026-09-18 15:15	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3000	1.3000	1.3500	23.7350	14040.00	0.00	14040.00	108	38	3997	8262	0.483781166787703	0.758086417988754	0.758086417988754	true	false	false	true
4b21b2b9-32fe-48c4-be7c-f38240113733	2026-09-18 15:12	2026-09-18 15:12	2026-09-18 15:12	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.2800	1.2800	1.3400	23.6650	14464.00	0.00	14464.00	113	24	3817	8262	0.461994674412975	0.766195771443677	0.766195771443677	true	false	false	true
07d8c9c2-92b3-4707-90b5-0982ae982d21	2026-09-18 15:11	2026-09-18 15:11	2026-09-18 15:11	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.2600	1.2600	1.3000	23.6150	21672.00	0.00	21672.00	172	40	3591	8262	0.434640522875817	0.768738274701951	0.768738274701951	true	false	false	true
9fedb450-82b3-4d3a-bc5b-6f364bed5b7d	2026-09-18 14:08	2026-09-18 14:08	2026-09-18 14:08	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.2000	1.1700	1.2000	23.4900	10200.00	5880.00	0.00	85	6	3228	8262	0.390704429920116	0.769024387950921	0.769024387950921	false	false	false	true
a6b24fb3-6ee5-4e35-8070-682341761494	2026-09-18 13:48	2026-09-18 13:48	2026-09-18 13:48	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.0400	1.0200	1.0400	23.1700	10504.00	10504.00	0.00	101	19	2380	8262	0.288065843621399	0.761720952298141	0.761720952298141	false	false	false	true
9d4178e6-3a2b-44ab-9aec-7528893ece8a	2026-09-18 13:46	2026-09-18 13:46	2026-09-18 13:46	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	0.9900	0.9900	1.0500	23.1000	38808.00	0.00	38808.00	392	17	2154	8262	0.260711692084241	0.750761449036321	0.750761449036321	true	false	false	true
8a3bf63d-1e52-400f-a683-05212f7163b6	2026-09-18 13:46	2026-09-18 13:46	2026-09-18 13:46	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.0100	0.9600	1.0100	23.0850	10900.00	10200.00	0.00	108	18	1762	8262	0.213265553134834	0.765651923449264	0.76002184190307	false	false	false	true
abb91d0f-a224-4801-a621-737139ab742d	2026-09-18 13:35	2026-09-18 13:35	2026-09-18 13:35	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	0.9800	0.9800	1.0300	23.0450	21952.00	0.00	21952.00	224	33	1653	8262	0.200072621641249	0.758386167104125	0.758386167104125	true	false	false	true
280077ff-0459-4746-b20a-83394be2cf0f	2026-09-18 13:34	2026-09-18 13:34	2026-09-18 13:34	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	0.9700	0.9600	1.0000	22.9950	12804.00	97.00	12707.00	132	27	1291	8262	0.156257564754297	0.764698479073678	0.764698479073678	true	false	false	true
1a5473b2-2d07-4ad4-9157-a5fd6ec4bac5	2026-09-18 12:44	2026-09-18 12:44	2026-09-18 12:44	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	0.9600	0.9500	1.0000	22.9050	26304.00	0.00	26304.00	274	19	538	8262	0.065117404986686	0.780386741008026	0.780386741008026	true	false	false	true
0b65900f-7694-44ba-917b-8c93515e7412	2026-09-08 15:18	2026-09-08 15:18	2026-09-08 15:18	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.2900	1.2900	1.3300	22.4400	10191.00	0.00	10191.00	79	5	7417	12220	0.606955810147299	0.823350571297699	0.823350571297699	false	false	false	true
ba5911c9-d776-4ad6-a7cd-7621ad4dac7f	2026-09-08 15:17	2026-09-08 15:17	2026-09-08 15:17	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.2800	1.2800	1.3400	22.4300	10112.00	0.00	10112.00	79	11	7330	12220	0.599836333878887	0.820769621088235	0.820769621088235	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
4e578200-a95e-4d03-90ed-8a857b98521a	2026-09-08 15:07	2026-09-08 15:07	2026-09-08 15:07	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3300	1.3300	1.3700	22.4850	10241.00	0.00	10241.00	77	27	6492	12220	0.53126022913257	0.832645259260861	0.832645259260861	false	false	false	true
8cd9de3d-a5c6-4223-93d5-390192401c86	2026-09-08 15:06	2026-09-08 15:06	2026-09-08 15:06	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3400	1.3300	1.3700	22.4750	11377.00	0.00	11377.00	85	19	6373	12220	0.52152209492635	0.847802261226921	0.834528851626889	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
7eab91ba-6adb-4464-8ee1-9d01d0a97603	2026-09-08 14:58	2026-09-08 14:57	2026-09-08 14:57	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3400	1.3400	1.3900	22.5000	11926.00	0.00	11926.00	89	6	5731	12220	0.4689852700491	0.834237260725611	0.834237260725611	false	false	false	true
240ef785-3d7d-436f-891f-f4959153f6f4	2026-09-08 14:55	2026-09-08 14:55	2026-09-08 14:55	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3400	1.3400	1.3900	22.5000	13303.00	0.00	13303.00	99	5	5547	12220	0.45392798690671	0.834237260725611	0.838654431506933	false	false	false	true
cb0c04e9-e34c-450a-9410-a26c8627a80e	2026-09-08 14:53	2026-09-08 14:53	2026-09-08 14:53	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3200	1.3200	1.3800	22.4550	13728.00	0.00	13728.00	104	10	5347	12220	0.437561374795417	0.833859809532434	0.833859809532434	false	false	false	true
3ea747ac-d42a-4ae5-821d-a52bcc7f4d13	2026-09-08 14:49	2026-09-08 14:49	2026-09-08 14:49	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3000	1.3000	1.3700	22.4400	12350.00	0.00	12350.00	95	5	5034	12220	0.411947626841244	0.827794646873244	0.827794646873244	false	false	false	true
38d87e6b-150f-4d5f-8e73-afa7e11db871	2026-09-08 14:40	2026-09-08 14:40	2026-09-08 14:40	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3000	1.3000	1.3600	22.4250	13000.00	0.00	13000.00	100	5	4332	12220	0.354500818330606	0.830601131997658	0.830601131997658	false	false	false	true
976ac212-a638-47ac-bcf3-7188b64d8fee	2026-09-08 14:38	2026-09-08 14:38	2026-09-08 14:38	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3200	1.3200	1.3700	22.4150	13860.00	0.00	13860.00	105	5	4131	12220	0.338052373158756	0.841368533591203	0.841368533591203	false	false	false	true
31566579-dbc8-4af2-b5a5-26fda5ca394f	2026-09-08 14:34	2026-09-08 14:33	2026-09-08 14:33	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3600	1.3600	1.4300	22.5100	14280.00	0.00	14280.00	105	32	3822	12220	0.312765957446809	0.841175634418151	0.841175634418151	false	false	false	true
0951a5aa-d623-463c-a315-4e9e64ce9c36	2026-09-08 14:33	2026-09-08 14:32	2026-09-08 14:32	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3800	1.3800	1.4400	22.5550	15594.00	0.00	15594.00	113	18	3717	12220	0.30417348608838	0.841436029111284	0.841436029111284	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
50d74783-0b8e-4d8f-9388-9da56272b64d	2026-09-08 14:29	2026-09-08 14:28	2026-09-08 14:28	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3700	1.3700	1.4300	22.5204	15481.00	0.00	15481.00	113	28	3376	12220	0.276268412438625	0.843612727709961	0.843612727709961	false	false	false	true
0c953f7f-6d31-481c-848e-f63cd5e46784	2026-09-08 14:27	2026-09-08 14:27	2026-09-08 14:27	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3700	1.3700	1.4400	22.5240	16303.00	0.00	16303.00	119	9	3263	12220	0.267021276595745	0.842929252923858	0.842929252923858	false	false	false	true
7e2ef2d7-db3d-4bc5-9aad-4a122c5e8fe3	2026-09-08 14:23	2026-09-08 14:23	2026-09-08 14:23	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3800	1.3800	1.4300	22.5750	15732.00	0.00	15732.00	114	12	2926	12220	0.239443535188216	0.837626261641421	0.837626261641421	false	false	false	true
0000d165-7929-492a-b526-6c043af531cf	2026-09-08 14:20	2026-09-08 14:20	2026-09-08 14:20	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3700	1.3700	1.4200	22.5450	16714.00	0.00	16714.00	122	14	2695	12220	0.220540098199673	0.838940228690055	0.838940228690055	false	false	false	true
8237885a-6823-4d63-808b-6b35e34728fb	2026-09-08 14:18	2026-09-08 14:18	2026-09-08 14:18	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3600	1.3600	1.4200	22.5199	16048.00	0.00	16048.00	118	20	2573	12220	0.210556464811784	0.839299492630509	0.839299492630509	false	false	false	true
9c2fd469-ff69-4c01-a857-4da04b98f20e	2026-09-08 14:16	2026-09-08 14:16	2026-09-08 14:16	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3600	1.3600	1.4200	22.5250	15640.00	0.00	15640.00	115	9	2455	12220	0.200900163666121	0.838332688130152	0.838332688130152	false	false	false	true
22f02169-335b-48d7-aad1-51af6193d70d	2026-09-08 14:14	2026-09-08 14:14	2026-09-08 14:14	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3500	1.3500	1.4000	22.4800	16065.00	0.00	16065.00	119	17	2230	12220	0.182487725040917	0.842434884283251	0.842434884283251	false	false	false	true
98c231dd-a9ba-4640-b2e4-6c50e38ccdba	2026-09-08 14:12	2026-09-08 14:12	2026-09-08 14:12	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3500	1.3500	1.4000	22.4850	16740.00	0.00	16740.00	124	19	2105	12220	0.172258592471358	0.841490064372406	0.841490064372406	false	false	false	true
75909aa4-2487-4a7e-873f-d2fb914371bf	2026-09-08 14:09	2026-09-08 14:09	2026-09-08 14:09	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3400	1.3400	1.4000	22.4571	16214.00	0.00	16214.00	121	16	1857	12220	0.151963993453355	0.842330005443512	0.842330005443512	false	false	false	true
bd1326b0-18d7-4ff0-97bd-f67bbe677ccf	2026-09-08 14:01	2026-09-08 14:01	2026-09-08 14:01	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3500	1.3500	1.4000	22.4050	15660.00	0.00	15660.00	116	5	1242	12220	0.101636661211129	0.856584519400563	0.856584519400563	false	false	false	true
61abd005-cd83-487e-98e9-bade12bbc738	2026-09-08 13:59	2026-09-08 13:58	2026-09-08 13:58	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3800	1.3800	1.4400	22.4900	16146.00	0.00	16146.00	117	16	999	12220	0.0817512274959084	0.853795328400043	0.853795328400043	false	false	false	true
8e9b015f-4282-4ada-a98d-94df7442aae3	2026-09-08 13:57	2026-09-08 13:57	2026-09-08 13:57	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3900	1.3900	1.4500	22.5200	16402.00	0.00	16402.00	118	22	882	12220	0.072176759410802	0.852500232803517	0.852500232803517	false	false	false	true
19e0b739-7710-4752-aa41-9fe1f590831a	2026-09-08 13:56	2026-09-08 13:56	2026-09-08 13:56	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.3800	1.3800	1.4500	22.5050	16422.00	0.00	16422.00	119	7	764	12220	0.0625204582651391	0.850946152801656	0.850946152801656	false	false	false	true
9ac4826d-fe1b-418b-9264-dfd08576160e	2026-09-08 13:54	2026-09-08 13:54	2026-09-08 13:54	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.4200	1.4200	1.4600	22.5400	17182.00	0.00	17182.00	121	25	645	12220	0.0527823240589198	0.861879839511861	0.861879839511861	false	false	false	true
6d853a25-2b2c-4997-9c4e-5f9ea7ddd722	2026-09-08 13:53	2026-09-08 13:53	2026-09-08 13:53	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.4100	1.4100	1.4600	22.5300	16779.00	0.00	16779.00	119	21	524	12220	0.0428805237315876	0.859395694824625	0.859395694824625	false	false	false	true
a6a66356-0471-4778-8c6c-700e6edd7a33	2026-09-08 13:52	2026-09-08 13:52	2026-09-08 13:52	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	1.4100	1.4100	1.4700	22.5200	16497.00	0.00	16497.00	117	23	405	12220	0.0331423895253683	0.861305765369219	0.861305765369219	false	false	false	true