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 = RepeatedHits×ticker = RIOT×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

cc1bae38-07b7-434c-b162-e54b23849541	2026-08-17 09:37	2026-08-17 09:37	2026-08-17 09:37	RIOT	RIOT260821P00017500	put	17.5000	2026-08-21	0.1900	0.1800	0.1900	19.0400	15599.00	15599.00	0.00	821	37	940	2350	0.4	0.933571541929173	0.933571541929173	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-17T13:42:20.529509Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
102d4d9e-368b-498a-a366-5ea580e08e9c	2026-08-17 10:07	2026-08-17 10:07	2026-08-17 10:07	RIOT	RIOT260821P00019500	put	19.5000	2026-08-21	0.8600	0.8600	0.9300	19.2490	10578.00	0.00	10578.00	123	23	193	1374	0.140465793304221	0.905382404185478	0.905382404185478	false	false	false	true
fe491fd9-60ba-4177-89bd-34d8fbf5a22c	2026-08-17 10:33	2026-08-17 10:33	2026-08-17 10:33	RIOT	RIOT280121C00020000	call	20.0000	2028-01-21	8.0000	8.0000	8.2500	19.2505	18400.00	0.00	800.00	23	15	75	3569	0.0210142897170076	0.899297057521132	0.899297057521132	false	false	false	true
01fdf10d-f846-4bf9-a064-97f460d28b1d	2026-08-17 10:42	2026-08-17 10:42	2026-08-17 10:42	RIOT	RIOT260828P00017000	put	17.0000	2026-08-28	0.2800	0.2700	0.3000	19.1550	23856.00	924.00	22932.00	852	36	994	299	3.32441471571906	0.81675682091012	0.815729269320575	false	false	false	true
3345a05b-f8f5-479c-9df9-879992e12a21	2026-08-17 10:44	2026-08-17 10:44	2026-08-17 10:44	RIOT	RIOT260828P00017000	put	17.0000	2026-08-28	0.2600	0.2600	0.2900	19.1900	28158.00	0.00	28158.00	1083	78	2409	299	8.05685618729097	0.799519340620012	0.799519340620012	false	false	false	true
2576600a-c409-46f7-8041-b0d54e5591df	2026-08-17 10:44	2026-08-17 10:44	2026-08-17 10:44	RIOT	RIOT260828P00017000	put	17.0000	2026-08-28	0.2600	0.2600	0.2900	19.2200	11856.00	0.00	11856.00	456	26	2865	299	9.5819397993311	0.80556736734714	0.80556736734714	false	false	false	true
628e0bc0-1f15-4fe1-943f-ee60334df541	2026-08-17 10:44	2026-08-17 10:44	2026-08-17 10:44	RIOT	RIOT260828P00017000	put	17.0000	2026-08-28	0.2600	0.2500	0.2900	19.2200	16380.00	0.00	14170.00	630	44	3495	299	11.6889632107023	0.80556736734714	0.80556736734714	false	false	false	true
ab92927e-cddf-4748-8da5-a3fc13b78ea6	2026-08-17 11:02	2026-08-17 11:02	2026-08-17 11:02	RIOT	RIOT260918P00017000	put	17.0000	2026-09-18	0.8100	0.7900	0.8100	19.3800	22194.00	19926.00	0.00	274	28	387	5120	0.0755859375	0.827220037207826	0.827220037207826	false	false	false	true
0d7179d1-036e-4089-9915-599864d7fc89	2026-08-17 11:12	2026-08-17 11:12	2026-08-17 11:12	RIOT	RIOT260918C00024000	call	24.0000	2026-09-18	0.6400	0.6400	0.6500	19.4450	13568.00	0.00	13568.00	212	5	273	13975	0.0195348837209302	0.859110934326472	0.859110934326472	false	false	false	true
dfb8c61e-f3fe-4a4d-939e-334e383997bc	2026-08-17 11:12	2026-08-17 11:12	2026-08-17 11:12	RIOT	RIOT260918C00024000	call	24.0000	2026-09-18	0.6500	0.6200	0.6500	19.4350	10530.00	10530.00	0.00	162	12	485	13975	0.0347048300536673	0.865973396197416	0.865973396197416	false	false	false	true
c720aa78-d9d8-4aa0-9503-a0b61a10a92c	2026-08-17 11:12	2026-08-17 11:12	2026-08-17 11:12	RIOT	RIOT260918C00024000	call	24.0000	2026-09-18	0.6500	0.6300	0.6700	19.4300	11505.00	845.00	10660.00	177	11	669	13975	0.047871198568873	0.866654102840858	0.866654102840858	false	false	false	true
e5a513f4-c748-4f8c-8440-a32cb80954c3	2026-08-17 11:24	2026-08-17 11:23	2026-08-17 11:23	RIOT	RIOT260904C00023500	call	23.5000	2026-09-04	0.3400	0.3400	0.3600	19.4700	23834.00	0.00	23834.00	701	26	2288	0	0	0.846812240495871	0.846812240495871	false	false	false	true
13a678a2-c6dd-4020-98a1-ae1ac1bdca05	2026-08-17 11:24	2026-08-17 11:23	2026-08-17 11:23	RIOT	RIOT260904C00023500	call	23.5000	2026-09-04	0.3400	0.3400	0.3600	19.4550	17646.00	0.00	17646.00	519	20	2807	0	0	0.849216979970656	0.849216979970656	false	false	false	true
a4c4a39d-55ad-448d-9601-4dea852f394a	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.6000	19.6414	14400.00	14400.00	0.00	240	18	2937	13343	0.220115416323166	0.921566546930329	0.921566546930329	false	false	false	true
fcc6b1c0-1c4f-43e8-a193-40c0d196145b	2026-08-17 12:06	2026-08-17 12:06	2026-08-17 12:06	RIOT	RIOT260918P00017000	put	17.0000	2026-09-18	0.7300	0.7100	0.7300	19.7750	22046.00	22046.00	0.00	302	24	743	5120	0.1451171875	0.83521102982931	0.83521102982931	false	false	false	true
7940c86d-05bc-4ac5-b5de-56dcd1fc8982	2026-08-17 12:24	2026-08-17 12:24	2026-08-17 12:24	RIOT	RIOT260828P00017000	put	17.0000	2026-08-28	0.2100	0.2100	0.2300	19.5300	34902.00	0.00	34902.00	1662	27	8006	299	26.7759197324415	0.800469988452963	0.803266166307086	false	false	false	true
c8f2e1f6-ebf6-4016-aa94-b245f797786e	2026-08-17 12:24	2026-08-17 12:24	2026-08-17 12:24	RIOT	RIOT260828P00017000	put	17.0000	2026-08-28	0.2100	0.2100	0.2300	19.5400	11109.00	0.00	11109.00	529	12	8537	299	28.5518394648829	0.805127297428188	0.805127297428188	false	false	false	true
a482da1f-6a73-429b-96fa-3f51dfffb51d	2026-08-17 12:24	2026-08-17 12:24	2026-08-17 12:24	RIOT	RIOT260904P00017000	put	17.0000	2026-09-04	0.4000	0.3900	0.4500	19.5500	14720.00	0.00	14720.00	368	53	441	271	1.62730627306273	0.808555745727064	0.808555745727064	false	false	false	true
ce2010c6-0c4e-4c05-a690-1025f027b1d7	2026-08-17 13:08	2026-08-17 13:08	2026-08-17 13:08	RIOT	RIOT260821P00019500	put	19.5000	2026-08-21	0.5300	0.5000	0.5400	19.9910	59572.00	58936.00	636.00	1124	53	1719	1374	1.25109170305677	0.920724603241315	0.914188500397488	false	false	false	true
a9f412be-5d5c-4365-829b-2f76c539ad82	2026-08-17 13:39	2026-08-17 13:39	2026-08-17 13:39	RIOT	RIOT261218P00020000	put	20.0000	2026-12-18	4.0500	3.8500	4.1000	19.5200	17010.00	7290.00	9720.00	42	5	74	537	0.13780260707635	0.876434398884186	0.876434398884186	false	false	false	true
45170d6d-eead-4853-9137-13688b917712	2026-08-17 14:16	2026-08-17 14:15	2026-08-17 14:15	RIOT	RIOT260918C00025000	call	25.0000	2026-09-18	0.5300	0.5300	0.5600	19.5750	39750.00	0.00	39750.00	750	6	1273	17842	0.0713485035309943	0.869252869436449	0.869252869436449	false	false	false	true
d31bb232-368d-46d0-8143-a791d9356469	2026-08-17 14:37	2026-08-17 14:37	2026-08-17 14:37	RIOT	RIOT260821P00019000	put	19.0000	2026-08-21	0.4100	0.3900	0.4200	19.7600	13735.00	13079.00	656.00	335	36	1774	5639	0.314594786309629	0.905537866518893	0.90337466316893	false	false	false	true
6bffd796-5c5f-4f2f-a009-03bcfeb5fc8e	2026-08-17 14:42	2026-08-17 14:42	2026-08-17 14:42	RIOT	RIOT260918C00023000	call	23.0000	2026-09-18	0.9000	0.8700	0.9100	19.6250	18000.00	15210.00	2250.00	200	14	1017	5695	0.178577699736611	0.863758263483379	0.863758263483379	true	false	false	true
858cc865-89ac-4efd-92fd-248ea8a0a49a	2026-08-17 14:55	2026-08-17 14:55	2026-08-17 14:55	RIOT	RIOT261218C00020000	call	20.0000	2026-12-18	3.8500	3.8000	4.0000	19.5900	11165.00	7700.00	3465.00	29	8	70	4751	0.0147337402652073	0.870538960838431	0.870538960838431	false	false	false	true
73564b3c-8c3f-4b21-bd6e-b6a78e0156ea	2026-08-17 15:05	2026-08-17 15:05	2026-08-17 15:05	RIOT	RIOT261218P00020000	put	20.0000	2026-12-18	4.0000	3.9500	4.0500	19.5350	16000.00	6800.00	9200.00	40	12	147	537	0.273743016759777	0.866467717822762	0.866467717822762	false	false	false	true
2ba1a144-50d2-406c-81f8-497e8795cafd	2026-08-18 09:46	2026-08-18 09:46	2026-08-18 09:46	RIOT	RIOT260828C00020000	call	20.0000	2026-08-28	0.8800	0.8700	0.8800	19.0000	14344.00	14344.00	0.00	163	11	591	1204	0.490863787375415	0.889642363308517	0.889642363308517	false	false	false	true
920cc33c-e832-4ea9-9e6b-236e6f5b7a85	2026-08-18 09:48	2026-08-18 09:48	2026-08-18 09:48	RIOT	RIOT260828C00020000	call	20.0000	2026-08-28	0.9100	0.9100	0.9200	19.0000	11193.00	0.00	11193.00	123	15	1712	1204	1.421926910299	0.888364602515701	0.888364602515701	true	false	false	true
7cf11512-54a9-44e6-afa1-b327f7bd850d	2026-08-18 09:50	2026-08-18 09:50	2026-08-18 09:50	RIOT	RIOT260821P00019000	put	19.0000	2026-08-21	0.4800	0.4700	0.5000	19.4199	44928.00	288.00	44640.00	936	50	989	5772	0.171344421344421	0.95564337049117	0.967035934782653	false	false	false	true
d9763f17-fbeb-4776-b677-13f544142dba	2026-08-18 10:38	2026-08-18 10:37	2026-08-18 10:37	RIOT	RIOT260918P00018000	put	18.0000	2026-09-18	1.1600	1.1600	1.1800	19.4800	64380.00	0.00	64380.00	555	6	794	3065	0.25905383360522	0.842451595814746	0.842451595814746	false	false	false	true
5858c6fa-0061-4ef5-aadd-56b741768a09	2026-08-18 10:38	2026-08-18 10:38	2026-08-18 10:38	RIOT	RIOT260918P00018000	put	18.0000	2026-09-18	1.1600	1.1400	1.1900	19.4800	22851.00	0.00	22851.00	197	9	1328	3065	0.433278955954323	0.842451595814746	0.837547008519545	false	false	false	true
11b6790a-b840-4fa7-a4e6-0dcb5d1ad8de	2026-08-18 10:38	2026-08-18 10:38	2026-08-18 10:38	RIOT	RIOT260918P00018000	put	18.0000	2026-09-18	1.1600	1.1400	1.1800	19.4800	23200.00	3828.00	19372.00	200	7	1528	3065	0.498531810766721	0.842451595814746	0.842451595814746	false	false	false	true
7f6f54fc-5e9d-4801-9e2a-6e9decf764f1	2026-08-18 10:50	2026-08-18 10:50	2026-08-18 10:50	RIOT	RIOT260828C00020000	call	20.0000	2026-08-28	0.7600	0.7500	0.7600	19.1850	10792.00	10792.00	0.00	142	21	4947	1204	4.10880398671096	0.861039120558535	0.861039120558535	true	false	false	true
b887892f-f631-4ec9-abc4-accdff68d346	2026-08-18 11:03	2026-08-18 11:03	2026-08-18 11:03	RIOT	RIOT260918C00017000	call	17.0000	2026-09-18	3.0400	2.9500	3.0500	19.0450	27056.00	27056.00	0.00	89	6	102	2011	0.0507210343112879	0.862764795479647	0.862764795479647	false	false	false	true
ecc38290-8a71-4b8a-b4f2-44148e94ae0c	2026-08-18 12:28	2026-08-18 12:27	2026-08-18 12:27	RIOT	RIOT260918C00017000	call	17.0000	2026-09-18	3.1500	3.1000	3.2500	19.2550	93268.00	315.00	66178.00	296	15	594	2011	0.295375435106912	0.837062277932502	0.839059683551007	true	false	false	true
576ae15c-2ecd-474a-9aa8-100f050cbff1	2026-08-18 13:36	2026-08-18 13:36	2026-08-18 13:36	RIOT	RIOT260918C00020000	call	20.0000	2026-09-18	1.5000	1.5000	1.5200	18.9850	24750.00	0.00	24750.00	165	12	938	10783	0.0869887786330335	0.859048895433668	0.859048895433668	false	false	false	true
fd5a72e2-76a1-4df7-a667-240fe69ff4dd	2026-08-18 13:56	2026-08-18 13:56	2026-08-18 13:56	RIOT	RIOT260828C00019000	call	19.0000	2026-08-28	1.0300	1.0200	1.0400	18.9300	17097.00	0.00	17097.00	166	7	496	481	1.03118503118503	0.843517571260248	0.835507486612525	true	false	false	true
fc37daf3-ab43-4014-a44b-9e0d09da40a9	2026-08-18 15:18	2026-08-18 15:18	2026-08-18 15:18	RIOT	RIOT260821C00020000	call	20.0000	2026-08-21	0.2600	0.2600	0.2800	18.9400	15912.00	0.00	15912.00	612	37	3938	14813	0.265847566326875	0.932515703429126	0.933283802231936	false	false	false	true
55bda9da-e204-430e-97c4-90c43ab35099	2026-08-18 15:19	2026-08-18 15:19	2026-08-18 15:19	RIOT	RIOT260821C00022000	call	22.0000	2026-08-21	0.0600	0.0500	0.0600	18.9400	12006.00	12006.00	0.00	2001	51	4572	17958	0.254594052789843	1.10246019451914	1.10092284257216	false	false	false	true
2509cabf-b3f3-464f-b520-e19be316c003	2026-08-18 15:19	2026-08-18 15:19	2026-08-18 15:19	RIOT	RIOT260821C00020000	call	20.0000	2026-08-21	0.2800	0.2700	0.2900	18.9600	11592.00	3528.00	0.00	414	6	4807	14813	0.324512252750962	0.958175959785564	0.958175959785564	true	false	false	true
d1523559-0d06-46d3-91a3-c381638f187e	2026-08-18 15:19	2026-08-18 15:19	2026-08-18 15:19	RIOT	RIOT260821C00020000	call	20.0000	2026-08-21	0.2800	0.2800	0.3000	18.9700	19096.00	0.00	19096.00	682	27	6144	14813	0.414770809424154	0.953288314588881	0.953288314588881	false	false	false	true
889b958d-9807-4452-8a92-f5e6fc7a6fab	2026-08-18 15:19	2026-08-18 15:19	2026-08-18 15:19	RIOT	RIOT260821C00020000	call	20.0000	2026-08-21	0.2700	0.2700	0.3000	18.9550	23382.00	0.00	23382.00	866	35	7127	14813	0.481131438601229	0.943408690764168	0.943408690764168	false	false	false	true
94389429-9820-415b-92a4-ddaad93c8ee9	2026-08-18 15:19	2026-08-18 15:19	2026-08-18 15:19	RIOT	RIOT260821C00020000	call	20.0000	2026-08-21	0.2700	0.2700	0.3000	18.9500	13419.00	0.00	13419.00	497	15	7898	14813	0.533180314588537	0.945830862235763	0.945830862235763	false	false	false	true
c5eeb0e6-34f4-407d-b9e8-35adffb637e4	2026-08-18 15:19	2026-08-18 15:19	2026-08-18 15:19	RIOT	RIOT260821C00020000	call	20.0000	2026-08-21	0.2500	0.2500	0.2700	18.9250	10625.00	0.00	10625.00	425	33	8652	14813	0.584081549989874	0.922900183232807	0.922900183232807	false	false	false	true
13ca77fb-8fe8-4ccb-9a90-415d20092d2a	2026-08-18 15:33	2026-08-18 15:33	2026-08-18 15:33	RIOT	RIOT260918C00017000	call	17.0000	2026-09-18	3.0000	3.0000	3.1000	19.0400	96000.00	0.00	62400.00	320	10	1246	2011	0.619592242665341	0.843163792673549	0.843163792673549	false	false	false	true
a2537c65-307a-4bfd-b2c5-d3e33e470b54	2026-08-19 09:34	2026-08-19 09:34	2026-08-19 09:34	RIOT	RIOT260925P00017000	put	17.0000	2026-09-25	1.1500	1.0000	1.3000	18.7200	57500.00	11500.00	46000.00	500	9	1000	210	4.76190476190476	0.84749213654115	0.84749213654115	false	false	false	true
28575529-18ff-46b0-8aec-9d03e709530c	2026-08-19 09:51	2026-08-19 09:51	2026-08-19 09:51	RIOT	RIOT261218P00019000	put	19.0000	2026-12-18	4.0000	3.6000	4.0500	18.1650	22395.00	21600.00	395.00	56	6	56	5654	0.00990449239476477	0.881689680267434	0.881689680267434	false	false	false	true
82a44f79-f215-481a-84a8-984918daea79	2026-08-19 10:14	2026-08-19 10:14	2026-08-19 10:14	RIOT	RIOT261002C00024000	call	24.0000	2026-10-02	0.5900	0.5900	0.6000	17.9099	61891.00	0.00	61891.00	1049	16	1217	12673	0.0960309319024698	0.88435057878716	0.88435057878716	false	false	false	true
ab9d2226-7cee-4438-8d28-41500bcb4948	2026-08-19 10:55	2026-08-19 10:55	2026-08-19 10:55	RIOT	RIOT260904C00020000	call	20.0000	2026-09-04	0.8800	0.8300	0.8800	18.8700	17952.00	17952.00	0.00	204	8	307	231	1.32900432900433	0.83891552011722	0.83891552011722	true	false	false	true
c1f578f5-e7a0-407a-a6f2-2ca605a6b899	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	RIOT	RIOT260821C00020000	call	20.0000	2026-08-21	0.2400	0.2000	0.2600	19.0497	23736.00	23736.00	0.00	989	63	3830	13581	0.282011633900302	1.03717971475789	1.03717971475789	false	false	false	true
7ef18042-178e-4b63-b67f-731f488f8a65	2026-08-19 10:57	2026-08-19 10:57	2026-08-19 10:57	RIOT	RIOT260918C00020000	call	20.0000	2026-09-18	1.4900	1.4900	1.5200	19.0950	13410.00	0.00	11771.00	90	7	559	11271	0.04959630911188	0.84510080466792	0.84510080466792	false	false	false	true