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

691af7f5-b55a-4fc5-b5c7-a37c888c9bb0	2026-08-25 13:05	2026-08-25 13:05	2026-08-25 13:05	RIOT	RIOT260828P00020000	put	20.0000	2026-08-28	0.2400	0.2400	0.2800	21.2200	36000.00	0.00	36000.00	1500	39	2617	2132	1.22748592870544	0.920479879018784	0.920479879018784	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-25T17:31:01.749779Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e13d32e0-a0eb-4a96-8b4f-389d73a4cf64	2026-08-25 11:55	2026-08-25 11:55	2026-08-25 11:55	RIOT	RIOT261002P00016000	put	16.0000	2026-10-02	0.4200	0.4200	0.4300	21.4100	17430.00	0.00	17430.00	415	21	6417	63	101.857142857143	0.891515605381107	0.892822920598847	false	false	false	true
937fa083-c360-4a55-8126-81fc91dc4940	2026-08-25 11:55	2026-08-25 11:55	2026-08-25 11:55	RIOT	RIOT261002P00016000	put	16.0000	2026-10-02	0.4200	0.4000	0.4300	21.4300	22932.00	2604.00	20328.00	546	7	6984	63	110.857142857143	0.89456343889022	0.89456343889022	false	false	false	true
f09c7e2b-03d8-406b-a505-fb3339ad8ed1	2026-08-25 11:55	2026-08-25 11:55	2026-08-25 11:55	RIOT	RIOT261002P00016000	put	16.0000	2026-10-02	0.4300	0.4300	0.4400	21.3600	11309.00	0.00	11309.00	263	19	5837	63	92.6507936507936	0.89559878440316	0.89559878440316	false	false	false	true
1b063414-2f25-44cb-97c3-776748ce7c17	2026-08-25 11:55	2026-08-25 11:55	2026-08-25 11:55	RIOT	RIOT261002P00016000	put	16.0000	2026-10-02	0.4300	0.4300	0.4400	21.3500	12943.00	0.00	12943.00	301	12	5574	63	88.4761904761905	0.894720700916974	0.894720700916974	false	false	false	true
85c26170-a677-4ade-88dc-a40b5b693fb0	2026-08-25 11:55	2026-08-25 11:55	2026-08-25 11:55	RIOT	RIOT261002P00016000	put	16.0000	2026-10-02	0.4300	0.4300	0.4400	21.3589	27821.00	0.00	27821.00	647	19	4756	63	75.4920634920635	0.895502231704757	0.895502231704757	false	false	false	true
2334e14d-2cc1-45c5-98fd-1631dae98b7b	2026-08-25 11:37	2026-08-25 11:37	2026-08-25 11:37	RIOT	RIOT260828C00021000	call	21.0000	2026-08-28	0.9700	0.9700	1.0000	21.2900	15617.00	0.00	15617.00	161	11	3577	7956	0.449597787833082	1.06383782434078	1.06383782434078	false	false	false	true
b048445c-0fd9-44bc-9024-bb0438b61a9a	2026-08-25 11:37	2026-08-25 11:37	2026-08-25 11:37	RIOT	RIOT270319C00035000	call	35.0000	2027-03-19	2.7600	2.4500	2.7600	21.2800	14349.00	14349.00	0.00	52	12	348	304	1.14473684210526	0.940800213569507	0.93584757325187	false	false	false	true
f0e23895-ff43-4b53-b6c5-7518c33dab54	2026-08-25 11:36	2026-08-25 11:36	2026-08-25 11:36	RIOT	RIOT261002P00016000	put	16.0000	2026-10-02	0.4700	0.4700	0.4800	21.2900	25427.00	0.00	25427.00	541	19	1928	63	30.6031746031746	0.917368896376149	0.917368896376149	false	false	false	true
1f5a7a7d-6ad3-416f-a315-18646fd787a2	2026-08-25 11:36	2026-08-25 11:36	2026-08-25 11:36	RIOT	RIOT261002P00016000	put	16.0000	2026-10-02	0.4700	0.4700	0.5300	21.2900	26696.00	0.00	26696.00	568	23	1387	63	22.015873015873	0.917368896376149	0.917368896376149	false	false	false	true
edbe0f08-fecb-4ec7-af1d-7843290bd097	2026-08-25 11:36	2026-08-25 11:36	2026-08-25 11:36	RIOT	RIOT261002P00016000	put	16.0000	2026-10-02	0.4700	0.4700	0.5400	21.2701	11139.00	0.00	11139.00	237	16	738	63	11.7142857142857	0.915587165555404	0.915587165555404	false	false	false	true
8a9a8ec0-ed86-4d2a-91b2-f3902523d19b	2026-08-25 11:21	2026-08-25 11:21	2026-08-25 11:21	RIOT	RIOT260828C00020000	call	20.0000	2026-08-28	1.5000	1.4100	1.5200	21.1400	10050.00	9900.00	150.00	67	9	622	3307	0.188085878439673	1.07560262932856	1.07560262932856	false	false	false	true
e38dcc67-0749-417f-ba71-952dc6cd180a	2026-08-25 11:17	2026-08-25 11:17	2026-08-25 11:17	RIOT	RIOT261016C00025000	call	25.0000	2026-10-16	1.6300	1.5800	1.6500	21.0200	339855.00	133823.00	206032.00	2085	32	5069	682	7.43255131964809	0.935573835397328	0.930530839741942	false	false	false	true
8ee43ced-6ce3-48eb-9241-0371c76a27a2	2026-08-25 11:16	2026-08-25 11:16	2026-08-25 11:16	RIOT	RIOT261016C00025000	call	25.0000	2026-10-16	1.6000	1.6000	1.6100	20.9300	33920.00	0.00	1920.00	212	5	2764	682	4.05278592375367	0.93189333990922	0.93189333990922	true	false	false	true
40cb3306-540b-4284-9642-6a04f0b1d167	2026-08-25 11:15	2026-08-25 11:15	2026-08-25 11:15	RIOT	RIOT261016C00025000	call	25.0000	2026-10-16	1.5800	1.5300	1.6100	20.8800	349022.00	349022.00	0.00	2209	52	2412	682	3.5366568914956	0.935242363075375	0.931483157993487	false	false	false	true
abc6f656-2208-4eeb-a529-7f8453aae487	2026-08-25 11:00	2026-08-25 11:00	2026-08-25 11:00	RIOT	RIOT260828C00019000	call	19.0000	2026-08-28	2.1900	1.9700	2.1900	20.9400	10950.00	10950.00	0.00	50	5	85	698	0.121776504297994	1.25100658170782	1.25100658170782	false	false	false	true
a7b85ab1-c86d-410e-8103-b35e2b181af5	2026-08-25 10:42	2026-08-25 10:42	2026-08-25 10:42	RIOT	RIOT260918C00026000	call	26.0000	2026-09-18	0.5100	0.5100	0.5300	20.8000	10743.00	1716.00	9027.00	210	24	739	10162	0.0727219051367841	0.917799479149465	0.924356467898573	false	false	false	true
f9a7d5e0-cb58-4e93-871a-df0e58f60e45	2026-08-25 10:28	2026-08-25 10:28	2026-08-25 10:28	RIOT	RIOT260828C00021000	call	21.0000	2026-08-28	0.6500	0.6300	0.6500	20.6150	19500.00	19500.00	0.00	300	18	1193	7956	0.149949723479135	1.09751693496324	1.09751693496324	false	false	false	true
89d9486d-0749-4f58-81cb-39b5601d04ae	2026-08-25 10:28	2026-08-25 10:28	2026-08-25 10:28	RIOT	RIOT260918C00021000	call	21.0000	2026-09-18	1.7500	1.7300	1.7500	20.6000	11550.00	11550.00	0.00	66	6	78	8122	0.0096035459246491	0.907068684209246	0.904980018600194	false	false	false	true
6c6f2105-ded1-4d74-9e82-2cd9fab6ce4c	2026-08-25 10:14	2026-08-25 10:14	2026-08-25 10:14	RIOT	RIOT261016C00021000	call	21.0000	2026-10-16	2.5000	2.5000	2.6300	20.2000	18750.00	0.00	18750.00	75	7	158	196	0.806122448979592	0.919552284449075	0.919552284449075	false	false	false	true
4476ce69-63b6-47cc-9c8d-804bab2bf794	2026-08-25 10:07	2026-08-25 10:07	2026-08-25 10:07	RIOT	RIOT260828P00019000	put	19.0000	2026-08-28	0.2400	0.2400	0.2600	20.4350	49080.00	0.00	49080.00	2045	38	2184	12182	0.179280906255131	1.04943890112494	1.05336010184709	false	false	false	true
5ebda206-91d4-4081-8d69-2439da73b4b5	2026-08-24 15:50	2026-08-24 15:49	2026-08-24 15:49	RIOT	RIOT270115P00020000	put	20.0000	2027-01-15	4.3000	4.3000	4.5000	19.9200	215430.00	0.00	215430.00	501	14	511	4739	0.107828655834564	0.901250787779007	0.901250787779007	false	false	false	true
7b5b49b7-ca5b-429f-a0c7-a31fa5bc18b2	2026-08-24 15:49	2026-08-24 15:49	2026-08-24 15:49	RIOT	RIOT261218C00025000	call	25.0000	2026-12-18	2.5400	2.5400	2.6200	19.9150	10160.00	0.00	10160.00	40	6	161	22294	0.0072216739930026	0.917444397652539	0.917444397652539	false	false	false	true
4c7212be-ba9a-41ca-a6b6-44d25a8ca6cb	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	0.9900	20.0400	18676.00	0.00	18676.00	203	27	1315	1362	0.965491923641703	0.923690831080814	0.923690831080814	true	false	false	true
4eb329b0-5222-4891-860a-ea4de4ea36ab	2026-08-24 14:25	2026-08-24 14:25	2026-08-24 14:25	RIOT	RIOT261016P00021000	put	21.0000	2026-10-16	3.1500	3.0500	3.2000	20.2600	14175.00	315.00	13860.00	45	6	372	5	74.4	0.908470983776484	0.908470983776484	false	false	false	true
7cdaadc1-8d82-4a14-a71b-91326b94ee8d	2026-08-24 14:11	2026-08-24 14:11	2026-08-24 14:11	RIOT	RIOT260828C00021000	call	21.0000	2026-08-28	0.5600	0.5500	0.5700	20.2700	25312.00	24752.00	560.00	452	21	10248	2756	3.71843251088534	1.014586699271	1.014586699271	false	false	false	true
d6fb45fe-b1b9-4497-baba-1e17723d3c3b	2026-08-24 13:54	2026-08-24 13:54	2026-08-24 13:54	RIOT	RIOT260918C00024000	call	24.0000	2026-09-18	0.7500	0.7000	0.7500	20.1550	18750.00	18750.00	0.00	250	10	1671	11125	0.150202247191011	0.928819835056844	0.928819835056844	false	false	false	true
fddba615-5132-4642-9d64-9be6da4a6571	2026-08-24 13:54	2026-08-24 13:54	2026-08-24 13:54	RIOT	RIOT260918C00024000	call	24.0000	2026-09-18	0.7500	0.7000	0.7800	20.1599	18750.00	4725.00	9375.00	250	6	1421	11125	0.127730337078652	0.928048690800827	0.928048690800827	false	false	false	true
8fbb3617-6b61-49db-9031-6d19db02dba9	2026-08-24 13:20	2026-08-24 13:20	2026-08-24 13:20	RIOT	RIOT260828P00020000	put	20.0000	2026-08-28	0.6900	0.6700	0.6900	20.3700	13731.00	13731.00	0.00	199	19	611	2022	0.30217606330366	1.02808710318472	1.02808710318472	true	false	false	true
9dbfcef9-0a30-4e20-88a1-0f34e2c99562	2026-08-24 13:00	2026-08-24 13:00	2026-08-24 13:00	RIOT	RIOT261016P00021000	put	21.0000	2026-10-16	3.1500	3.0000	3.2000	20.2600	23625.00	630.00	22050.00	75	15	89	5	17.8	0.908470983776484	0.908470983776484	false	false	false	true
6d2faf71-a5a9-4618-aa9d-957493f0e776	2026-08-24 12:10	2026-08-24 12:10	2026-08-24 12:10	RIOT	RIOT260918C00024000	call	24.0000	2026-09-18	0.8300	0.8300	0.8900	20.4700	60175.00	0.00	60175.00	725	54	848	11125	0.0762247191011236	0.922758345725013	0.922758345725013	false	false	false	true
bef51fd0-7507-4f2e-abde-57d389ad25f9	2026-08-24 11:29	2026-08-24 11:29	2026-08-24 11:29	RIOT	RIOT260918C00032000	call	32.0000	2026-09-18	0.1200	0.1200	0.1300	20.7300	10392.00	0.00	10392.00	866	10	2524	16614	0.151920067413025	0.972047096961387	0.972047096961387	false	false	false	true
017c8c56-4011-4a96-b6f9-048e7f9dd118	2026-08-24 11:28	2026-08-24 11:28	2026-08-24 11:28	RIOT	RIOT260918C00032000	call	32.0000	2026-09-18	0.1200	0.1200	0.1400	20.7493	17040.00	0.00	17040.00	1420	42	1431	16614	0.0861321776814735	0.970267051686374	0.970267051686374	false	false	false	true
5f6f84bd-1db4-4e45-92da-c4a297abebb9	2026-08-24 11:26	2026-08-24 11:26	2026-08-24 11:26	RIOT	RIOT261218P00022000	put	22.0000	2026-12-18	4.9000	4.9000	5.1500	20.7450	11760.00	0.00	11760.00	24	8	38	337	0.112759643916914	0.930403342780763	0.929934548931768	false	false	false	true
35c3c7c0-2040-4fbd-80af-f98a64cd19e4	2026-08-24 11:17	2026-08-24 11:17	2026-08-24 11:17	RIOT	RIOT260828C00021000	call	21.0000	2026-08-28	0.7000	0.6900	0.7000	20.5600	115150.00	115150.00	0.00	1645	36	6087	2756	2.20863570391872	1.03954112959243	1.0369235847496	true	false	false	true
977f5d7a-b5da-4c39-8d70-de8be6232916	2026-08-24 11:16	2026-08-24 11:16	2026-08-24 11:16	RIOT	RIOT260828C00021000	call	21.0000	2026-08-28	0.7000	0.6800	0.7000	20.5350	63840.00	63840.00	0.00	912	18	4442	2756	1.61175616835994	1.04998624499487	1.04998624499487	false	false	false	true
91c50fdc-6368-4d69-87bb-2727a1333f54	2026-08-24 11:08	2026-08-24 11:08	2026-08-24 11:08	RIOT	RIOT260918C00022000	call	22.0000	2026-09-18	1.2700	1.2500	1.2700	20.2200	10160.00	10160.00	0.00	80	8	457	9418	0.048524102781907	0.918331323282311	0.918331323282311	false	false	false	true
e1f38133-00ef-48d8-a5cf-f6d2174a017e	2026-08-24 11:08	2026-08-24 11:08	2026-08-24 11:08	RIOT	RIOT260918C00022000	call	22.0000	2026-09-18	1.2700	1.2500	1.2700	20.2150	10160.00	10160.00	0.00	80	8	357	9418	0.0379061371841155	0.919333174158066	0.919333174158066	false	false	false	true
9aee8fc1-6e4c-4cc6-88cf-9ced999e90b2	2026-08-24 11:08	2026-08-24 11:08	2026-08-24 11:08	RIOT	RIOT260918C00022000	call	22.0000	2026-09-18	1.2800	1.2700	1.2800	20.2200	10240.00	10240.00	0.00	80	8	127	9418	0.0134848163091952	0.923182916068608	0.923182916068608	false	false	false	true
de619c0e-3eda-40c2-b6a9-cb417b500179	2026-08-24 10:49	2026-08-24 10:49	2026-08-24 10:49	RIOT	RIOT260828C00021000	call	21.0000	2026-08-28	0.6300	0.6300	0.6700	20.3500	10080.00	0.00	10080.00	160	18	3025	2756	1.09760522496372	1.06066766598703	1.06066766598703	false	false	false	true
76c43e2c-e570-411f-adea-854e871bb19a	2026-08-24 10:42	2026-08-24 10:41	2026-08-24 10:41	RIOT	RIOT261016C00024000	call	24.0000	2026-10-16	1.7900	1.7700	1.8100	20.6348	17900.00	16289.00	0.00	100	18	115	336	0.342261904761905	0.936560202478328	0.936560202478328	false	false	false	true
e7ff1faf-caee-4bfb-9b75-299279902223	2026-08-24 10:39	2026-08-24 10:39	2026-08-24 10:39	RIOT	RIOT260918C00018000	call	18.0000	2026-09-18	3.4500	3.4000	3.5500	20.6300	98670.00	8280.00	90390.00	286	44	1018	5209	0.195430984833941	0.899423396128273	0.899423396128273	false	false	false	true
b9a1ab33-2145-41d7-8aab-c90def270e85	2026-08-24 10:39	2026-08-24 10:39	2026-08-24 10:39	RIOT	RIOT260918C00018000	call	18.0000	2026-09-18	3.4500	3.4000	3.5500	20.6450	73830.00	62100.00	11730.00	214	6	732	5209	0.140526012670378	0.892594578075109	0.892594578075109	false	false	false	true
aba3f848-72e8-4053-982a-c0882748094f	2026-08-24 10:35	2026-08-24 10:35	2026-08-24 10:35	RIOT	RIOT261218P00021000	put	21.0000	2026-12-18	4.2500	4.2000	4.3000	20.6900	11050.00	0.00	7650.00	26	8	51	763	0.0668414154652687	0.91680042905578	0.91680042905578	false	false	false	true
ad8ae9d9-4f5d-4b74-883b-1221252f02c2	2026-08-24 10:35	2026-08-24 10:34	2026-08-24 10:34	RIOT	RIOT260918P00020000	put	20.0000	2026-09-18	1.6000	1.5900	1.6600	20.6250	17760.00	0.00	17760.00	111	7	4013	8755	0.458366647629926	0.908479382548672	0.908479382548672	false	false	false	true
6a278e0e-e643-4c02-af09-6eacc8c1e075	2026-08-24 10:30	2026-08-24 10:30	2026-08-24 10:30	RIOT	RIOT260828P00020500	put	20.5000	2026-08-28	0.9000	0.9000	1.0200	20.4800	10170.00	0.00	10170.00	113	15	149	10787	0.0138129229628256	1.04576363413477	1.04576363413477	true	false	false	true
9d806a7e-9adb-4508-ab70-39e83a669416	2026-08-21 15:45	2026-08-21 15:45	2026-08-21 15:45	RIOT	RIOT270115C00020000	call	20.0000	2027-01-15	4.4500	4.4500	4.5500	19.7050	137060.00	0.00	137060.00	308	9	550	9391	0.0585667128101374	0.902640859665602	0.902640859665602	false	false	false	true
ef44ddfe-7de0-4b93-91d7-71a9a1a96b8e	2026-08-21 15:38	2026-08-21 15:38	2026-08-21 15:38	RIOT	RIOT260911C00025000	call	25.0000	2026-09-11	0.3500	0.3500	0.4000	19.6400	12005.00	0.00	12005.00	343	13	3107	432	7.19212962962963	0.924418672382205	0.924418672382205	false	false	false	true
5ecf728f-6284-4539-9294-ddd68c5f1a36	2026-08-21 13:39	2026-08-21 13:38	2026-08-21 13:38	RIOT	RIOT260821P00021500	put	21.5000	2026-08-21	1.5200	1.5200	1.6000	19.9411	11096.00	0.00	11096.00	73	5	1669	944	1.76800847457627	3.29125592656862	3.29125592656862	false	false	false	true
78cfadad-0e24-4832-a25c-c7d6965e25b8	2026-08-21 12:57	2026-08-21 12:56	2026-08-21 12:56	RIOT	RIOT260911C00025000	call	25.0000	2026-09-11	0.4000	0.3900	0.4600	19.7600	53080.00	40.00	53040.00	1327	60	1375	432	3.18287037037037	0.944799436484806	0.948425967451332	false	false	false	true