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:alert_rule = RepeatedHits×ticker = CRCL×

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

4a5fd43b-e9ac-4137-97dc-c2cd6ccecc76	2026-09-10 14:57	2026-09-10 14:56	2026-09-10 14:56	CRCL	CRCL260918C00094000	call	94.0000	2026-09-18	3.2500	3.0500	3.3000	91.0700	15275.00	12675.00	2600.00	47	18	297	174	1.70689655172414	0.830498714056331	0.830498714056331	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	22863031210.00	2026-11-11	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-10T19:03:59.290358Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f34d6616-7ff2-4015-83b0-f8e9f81a4e17	2026-09-10 14:48	2026-09-10 14:48	2026-09-10 14:48	CRCL	CRCL260918P00088000	put	88.0000	2026-09-18	3.0500	2.9100	3.0500	90.5000	10670.00	10670.00	0.00	35	5	929	320	2.903125	0.799940348962476	0.799940348962476	false	false	false	true
d498f01e-9ecb-414f-9edb-85b4d6674eea	2026-09-10 14:48	2026-09-10 14:48	2026-09-10 14:48	CRCL	CRCL260918P00085000	put	85.0000	2026-09-18	1.9600	1.8300	1.9600	90.5000	101920.00	101920.00	0.00	520	31	917	4626	0.198227410289667	0.804970790511642	0.804970790511642	false	false	false	true
10689197-b2d9-47b9-89a4-506025a71adb	2026-09-10 14:48	2026-09-10 14:48	2026-09-10 14:48	CRCL	CRCL260918P00087000	put	87.0000	2026-09-18	2.6700	2.5700	2.6700	90.5000	13617.00	13617.00	0.00	51	8	100	142	0.704225352112676	0.805561690277592	0.805561690277592	false	false	false	true
531f9105-b14a-409d-b95b-f4a502da6d7a	2026-09-10 14:02	2026-09-10 14:02	2026-09-10 14:02	CRCL	CRCL260911P00091000	put	91.0000	2026-09-11	1.6800	1.5800	1.7000	90.8150	20496.00	20496.00	0.00	122	23	722	517	1.39651837524178	0.838078935197667	0.838078935197667	true	false	false	true
2f879074-b965-4ed3-afb5-ca070ce87739	2026-09-10 14:01	2026-09-10 14:00	2026-09-10 14:00	CRCL	CRCL261016C00100000	call	100.0000	2026-10-16	5.6000	5.6000	5.8500	91.0650	16800.00	0.00	16800.00	30	6	470	7472	0.0629014989293362	0.777047602574772	0.777047602574772	false	false	false	true
7da1fc13-5306-4814-8137-ae90b7eb12c9	2026-09-10 13:38	2026-09-10 13:37	2026-09-10 13:37	CRCL	CRCL260911C00091500	call	91.5000	2026-09-11	1.4600	1.4600	1.5800	91.3600	34894.00	0.00	34894.00	239	31	1178	75	15.7066666666667	0.798514560953031	0.798514560953031	true	false	false	true
aeeb5da9-acec-4415-bee5-235a53a402e7	2026-09-10 13:31	2026-09-10 13:31	2026-09-10 13:31	CRCL	CRCL260911C00091500	call	91.5000	2026-09-11	1.6300	1.5500	1.6300	91.4200	32595.00	31785.00	810.00	200	13	931	75	12.4133333333333	0.871919785065604	0.866681338619004	true	false	false	true
1a15bdd6-cc0d-41c0-a526-2965b453dc82	2026-09-10 12:01	2026-09-10 12:01	2026-09-10 12:01	CRCL	CRCL260918C00096000	call	96.0000	2026-09-18	2.5600	2.5600	2.6400	91.2700	47872.00	0.00	47872.00	187	6	1422	835	1.70299401197605	0.816272549171104	0.816272549171104	true	false	false	true
a7bf9685-9bf8-4c62-b253-6abd4f413ccc	2026-09-10 11:24	2026-09-10 11:24	2026-09-10 11:24	CRCL	CRCL260925P00094000	put	94.0000	2026-09-25	7.1500	7.1500	7.4000	91.5000	22880.00	0.00	22880.00	32	6	36	39	0.923076923076923	0.78792498980221	0.78792498980221	false	false	false	true
1a729f66-3610-42e8-a6b6-3d19ad7fb3e3	2026-09-10 10:52	2026-09-10 10:52	2026-09-10 10:52	CRCL	CRCL261016C00090000	call	90.0000	2026-10-16	10.4000	10.2500	10.6000	92.3500	20800.00	0.00	20800.00	20	5	75	1972	0.0380324543610548	0.790271323073537	0.790271323073537	false	false	false	true
229e7c43-1d7d-41e1-84c2-b6a6d9b916dd	2026-09-10 10:47	2026-09-10 10:46	2026-09-10 10:46	CRCL	CRCL261218C00120000	call	120.0000	2026-12-18	7.8500	7.5000	7.8500	92.3900	39250.00	39250.00	0.00	50	5	54	1838	0.029379760609358	0.832992381556897	0.832992381556897	false	false	false	true
96d4e811-62f3-44f2-9d41-ac8da46266ad	2026-09-10 10:45	2026-09-10 10:45	2026-09-10 10:45	CRCL	CRCL270416C00150000	call	150.0000	2027-04-16	10.1500	9.6500	10.3000	92.2600	50750.00	50750.00	0.00	50	5	50	5	10	0.836193527103734	0.835137434946867	false	false	false	true
3f2ffd10-a14d-4cb1-8899-017c5414e89c	2026-09-10 10:36	2026-09-10 10:36	2026-09-10 10:36	CRCL	CRCL270319C00145000	call	145.0000	2027-03-19	9.3000	8.9500	9.4500	91.8100	46500.00	10230.00	7440.00	50	5	60	281	0.213523131672598	0.838587760575495	0.838587760575495	false	false	false	true
ef4c1931-1da6-4247-b023-030c288638ee	2026-09-10 10:36	2026-09-10 10:36	2026-09-10 10:36	CRCL	CRCL270115C00125000	call	125.0000	2027-01-15	8.6000	8.4500	8.6000	91.9100	43000.00	27520.00	0.00	50	6	83	643	0.129082426127527	0.826473699709279	0.827272747406376	false	false	false	true
16ed4581-72cd-4b19-a397-9d0dfaef7771	2026-09-10 10:36	2026-09-10 10:36	2026-09-10 10:36	CRCL	CRCL270115C00125000	call	125.0000	2027-01-15	8.6000	8.4500	8.8000	91.9200	15480.00	11180.00	1720.00	18	6	101	643	0.157076205287714	0.827095156229944	0.827095156229944	false	false	false	true
7d87b039-6990-49dd-add7-9ad32cef4dd1	2026-09-10 10:28	2026-09-10 10:28	2026-09-10 10:28	CRCL	CRCL260918P00095000	put	95.0000	2026-09-18	6.4000	6.4000	6.5500	91.7300	16000.00	0.00	16000.00	25	5	117	2709	0.0431893687707641	0.84075588626431	0.84075588626431	false	false	false	true
4ad8dc01-7c40-43a9-b9d0-e1661c458ef2	2026-09-10 09:49	2026-09-10 09:49	2026-09-10 09:49	CRCL	CRCL270115P00080000	put	80.0000	2027-01-15	10.5000	10.2000	10.9000	91.4250	21000.00	0.00	21000.00	20	6	31	2745	0.0112932604735883	0.806978345647678	0.806978345647678	false	false	false	true
130c6559-d59f-4368-8dc4-3694d0fb646f	2026-09-10 09:49	2026-09-10 09:49	2026-09-10 09:49	CRCL	CRCL261120P00075000	put	75.0000	2026-11-20	5.4500	5.0500	5.4500	91.3400	219061.00	219061.00	0.00	402	44	411	633	0.649289099526066	0.835119477976429	0.835119477976429	false	false	false	true
4d761dda-1a15-45b7-a520-01f8dbdfcb82	2026-09-10 09:30	2026-09-10 09:30	2026-09-10 09:30	CRCL	CRCL270617P00060000	put	60.0000	2027-06-17	8.2500	7.8000	8.2500	89.8950	28875.00	28875.00	0.00	35	7	35	674	0.0519287833827893	0.814681635674298	0.814681635674298	false	false	false	true
e549efcb-b966-441c-8107-5bb2c42654d3	2026-09-09 15:28	2026-09-09 15:28	2026-09-09 15:28	CRCL	CRCL260911P00093000	put	93.0000	2026-09-11	2.0200	2.0100	2.0900	94.0300	16596.00	0.00	16596.00	82	10	339	274	1.23722627737226	0.905449304848279	0.912797953110694	false	false	false	true
5bac89a6-5f71-4083-b896-7f360410100c	2026-09-09 15:21	2026-09-09 15:21	2026-09-09 15:21	CRCL	CRCL260918P00090000	put	90.0000	2026-09-18	3.1500	3.1500	3.2000	93.6300	13545.00	0.00	13545.00	43	8	533	6341	0.0840561425642643	0.831978692377554	0.831978692377554	false	false	false	true
e5a119d4-2310-473c-8e68-c1dc4d43e57b	2026-09-09 14:49	2026-09-09 14:49	2026-09-09 14:49	CRCL	CRCL261120C00120000	call	120.0000	2026-11-20	6.4500	6.3000	7.0000	93.7200	27090.00	645.00	26445.00	42	9	136	500	0.272	0.860787405386181	0.860787405386181	true	false	false	true
3d561740-7fd8-428b-ac7c-63eb4eb261ac	2026-09-09 14:34	2026-09-09 14:34	2026-09-09 14:34	CRCL	CRCL261016C00100000	call	100.0000	2026-10-16	7.4000	7.3000	7.7000	94.2131	11840.00	740.00	11100.00	16	5	1315	7343	0.179082119024922	0.804177967925159	0.804177967925159	false	false	false	true
ec675444-9c6e-48e2-bf10-a6dd908cbfe3	2026-09-09 14:28	2026-09-09 14:27	2026-09-09 14:27	CRCL	CRCL270115P00100000	put	100.0000	2027-01-15	20.4500	20.4500	20.7500	94.4500	67485.00	0.00	67485.00	33	6	52	1934	0.0268872802481903	0.810133314291143	0.810133314291143	false	false	false	true
2e545488-642e-45b7-9ca0-ab4a3e31a1ab	2026-09-09 13:15	2026-09-09 13:15	2026-09-09 13:15	CRCL	CRCL260918C00095000	call	95.0000	2026-09-18	4.9000	4.9000	5.1500	94.6650	10290.00	0.00	10290.00	21	5	167	2870	0.0581881533101045	0.84641198811089	0.84641198811089	false	false	false	true
b35a6a56-63d2-4624-8cc4-516a6c7405f0	2026-09-09 12:05	2026-09-09 12:05	2026-09-09 12:05	CRCL	CRCL260918P00095000	put	95.0000	2026-09-18	4.9500	4.9500	5.0500	95.2900	23265.00	0.00	23265.00	47	6	163	2398	0.0679733110925771	0.862931353564196	0.862931353564196	false	false	false	true
e2f95fb8-df53-4755-b99f-090b8d328b40	2026-09-09 12:02	2026-09-09 12:02	2026-09-09 12:02	CRCL	CRCL260925P00101000	put	101.0000	2026-09-25	10.2500	10.2000	10.8000	94.7550	18450.00	8200.00	10250.00	18	5	25	337	0.0741839762611276	0.831739688640992	0.831739688640992	false	false	false	true
b50564d3-fa8f-484a-9865-78cc1ece9d8a	2026-09-09 11:30	2026-09-09 11:30	2026-09-09 11:30	CRCL	CRCL260918P00093000	put	93.0000	2026-09-18	4.3500	4.3000	4.7000	94.4600	17835.00	0.00	13920.00	41	6	62	176	0.352272727272727	0.867268751001569	0.867268751001569	true	false	false	true
a30fbe0e-bd11-4390-a3fb-a3ef056e7396	2026-09-09 11:24	2026-09-09 11:24	2026-09-09 11:24	CRCL	CRCL261218C00140000	call	140.0000	2026-12-18	5.5500	5.5000	6.0000	93.9058	10540.00	0.00	10540.00	19	5	37	2721	0.0135979419331128	0.868413527950778	0.865301773259948	false	false	false	true
c09e1d2e-3dd5-4c1e-8ecb-2bb6bb0d2847	2026-09-09 10:38	2026-09-09 10:38	2026-09-09 10:38	CRCL	CRCL261016C00105000	call	105.0000	2026-10-16	7.1000	7.1000	7.2500	96.0000	22015.00	715.00	21300.00	31	6	57	3007	0.0189557698703026	0.82836583008314	0.82836583008314	false	false	false	true
6ba2f752-817f-4333-943d-a8674efbbdf9	2026-09-09 10:37	2026-09-09 10:36	2026-09-09 10:36	CRCL	CRCL261016C00100000	call	100.0000	2026-10-16	8.8500	8.7000	8.9000	96.0000	26550.00	16815.00	9735.00	30	5	732	7343	0.0996867765218575	0.827650221469254	0.827650221469254	false	false	false	true
e8826712-4f4f-4c4b-aefa-f792406d082d	2026-09-09 10:33	2026-09-09 10:33	2026-09-09 10:33	CRCL	CRCL260911C00106000	call	106.0000	2026-09-11	0.5300	0.5300	0.5900	96.0000	15900.00	0.00	371.00	300	6	927	1574	0.588945362134689	1.10471087198396	1.10471087198396	false	false	false	true
6bd1836d-7ae2-4de1-b2cf-9d671830cd2b	2026-09-09 10:29	2026-09-09 10:29	2026-09-09 10:29	CRCL	CRCL261016C00095000	call	95.0000	2026-10-16	10.7500	10.5500	10.9000	96.0000	32250.00	3225.00	29025.00	30	5	52	1375	0.0378181818181818	0.813828403254389	0.813828403254389	true	false	false	true
9a49d1ed-c336-471e-a2b1-6b6e624c7d02	2026-09-09 10:29	2026-09-09 10:29	2026-09-09 10:29	CRCL	CRCL261120C00125000	call	125.0000	2026-11-20	6.4000	6.4000	6.5500	96.0000	42880.00	0.00	42880.00	67	5	91	75	1.21333333333333	0.864950988826185	0.864950988826185	false	false	false	true
a590b967-7a46-490a-ad73-861b37ccde68	2026-09-09 10:29	2026-09-09 10:29	2026-09-09 10:29	CRCL	CRCL261120C00120000	call	120.0000	2026-11-20	7.4000	7.4000	7.5500	96.0000	55500.00	0.00	55500.00	75	5	83	500	0.166	0.8610480853418	0.8610480853418	false	false	false	true
662a8249-de90-4189-8351-65d3b543cd84	2026-09-09 10:27	2026-09-09 10:27	2026-09-09 10:27	CRCL	CRCL261016P00095000	put	95.0000	2026-10-16	8.9500	8.8000	9.0500	96.0000	179000.00	64440.00	114560.00	200	6	222	1814	0.122381477398015	0.803253702412748	0.803253702412748	false	false	false	true
72c3050c-c91b-47fc-ad33-61787ddd30b2	2026-09-09 10:27	2026-09-09 10:27	2026-09-09 10:27	CRCL	CRCL261016C00120000	call	120.0000	2026-10-16	3.4900	3.3000	3.5000	96.0000	17425.00	12250.00	5175.00	50	6	379	10549	0.0359275760735615	0.855018862755758	0.855018862755758	false	false	false	true
2c848bca-b646-4404-a9c1-144ffcfd3c52	2026-09-09 10:07	2026-09-09 10:07	2026-09-09 10:07	CRCL	CRCL270319C00120000	call	120.0000	2027-03-19	15.2000	15.0000	15.6500	94.9451	218880.00	217360.00	1520.00	144	7	146	831	0.175691937424789	0.826112184282855	0.825674258158745	false	false	false	true
5bf2c308-10bc-48ba-b989-702497d8cd76	2026-09-09 10:02	2026-09-09 10:01	2026-09-09 10:01	CRCL	CRCL260918C00100000	call	100.0000	2026-09-18	3.6000	3.6000	3.7000	95.7600	26280.00	0.00	26280.00	73	6	502	8181	0.061361691724728	0.885694582908691	0.885694582908691	false	false	false	true
aa6de7af-fc31-42e1-961f-e944fb699a60	2026-09-09 10:00	2026-09-09 10:00	2026-09-09 10:00	CRCL	CRCL260911C00106000	call	106.0000	2026-09-11	0.5000	0.4500	0.5300	95.9150	23050.00	7450.00	5850.00	461	8	471	1574	0.299237611181703	1.14361812015291	1.14361812015291	false	false	false	true
9a2e3626-bd54-4e37-9477-ab6c3bb67a44	2026-09-09 09:55	2026-09-09 09:55	2026-09-09 09:55	CRCL	CRCL261120C00115000	call	115.0000	2026-11-20	8.3000	8.3000	8.8000	95.6850	62250.00	0.00	62250.00	75	5	378	647	0.584234930448223	0.860288107412308	0.860288107412308	false	false	false	true
f64841fb-03e8-4e3e-8c86-743110f19ac9	2026-09-09 09:54	2026-09-09 09:54	2026-09-09 09:54	CRCL	CRCL261120C00115000	call	115.0000	2026-11-20	8.4000	8.4000	8.9500	95.8000	51240.00	0.00	51240.00	61	5	302	647	0.46676970633694	0.863628253919815	0.863628253919815	false	false	false	true
90a8630f-4dc8-4f3a-b8b8-c62e61b5ef5a	2026-09-09 09:54	2026-09-09 09:54	2026-09-09 09:54	CRCL	CRCL261120C00115000	call	115.0000	2026-11-20	8.5000	8.5000	8.9500	96.1050	63750.00	0.00	63750.00	75	5	241	647	0.372488408037094	0.862349347837767	0.862349347837767	false	false	false	true
e68ecb36-b62b-4fdd-97f2-57e529d5f41b	2026-09-09 09:49	2026-09-09 09:49	2026-09-09 09:49	CRCL	CRCL261120C00115000	call	115.0000	2026-11-20	8.6000	8.6000	9.1000	96.5700	65360.00	0.00	65360.00	76	6	80	647	0.123647604327666	0.857150098151014	0.857150098151014	false	false	false	true
0c28aab4-8848-4df7-bb9d-c0eabddf8f2e	2026-09-09 09:39	2026-09-09 09:39	2026-09-09 09:39	CRCL	CRCL261218C00225000	call	225.0000	2026-12-18	1.4100	1.2500	1.6100	96.4850	27777.00	27495.00	282.00	197	5	198	167	1.18562874251497	0.956997666754112	0.956997666754112	false	false	false	true
bf90797e-7e05-424b-81c6-5be4cb6820f2	2026-09-09 09:30	2026-09-09 09:30	2026-09-09 09:30	CRCL	CRCL260911C00098000	call	98.0000	2026-09-11	3.4500	3.4500	3.7500	98.4700	14490.00	0.00	14490.00	42	5	70	730	0.0958904109589041	1.1030812244129	1.1030812244129	false	false	false	true
20a16a56-d64c-425b-b7f6-30e00c7fe277	2026-09-08 15:41	2026-09-08 15:40	2026-09-08 15:40	CRCL	CRCL260925P00100000	put	100.0000	2026-09-25	8.7000	8.6500	9.1000	96.5900	13920.00	870.00	13050.00	16	9	48	71	0.676056338028169	0.824790625763255	0.824790625763255	false	false	false	true
7d164c78-b84f-4aa9-8824-2137f3f8f583	2026-09-08 15:05	2026-09-08 15:05	2026-09-08 15:05	CRCL	CRCL261218C00130000	call	130.0000	2026-12-18	7.6300	7.4000	7.8500	96.5700	61040.00	0.00	0.00	80	8	115	3123	0.0368235670829331	0.842880894824512	0.842880894824512	false	false	false	true
fbf072c0-7b01-477b-9b84-4dbc7535e7ca	2026-09-08 15:05	2026-09-08 15:05	2026-09-08 15:05	CRCL	CRCL270115C00130000	call	130.0000	2027-01-15	9.4600	9.1500	9.7500	96.5700	1254396.00	0.00	0.00	1326	7	1364	7585	0.179828609096902	0.827974396717981	0.827974396717981	false	false	false	true