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:er_time = unknown×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

c9079065-37af-4c16-a994-88b635a488c5	2026-09-08 12:29	2026-09-08 12:29	2026-09-08 12:29	CRCL	CRCL260918C00100000	call	100.0000	2026-09-18	4.7500	4.6500	4.7500	97.7100	16150.00	16150.00	0.00	34	34	1177	8341	0.141110178635655	0.886350126004904	0.886350126004904	false	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-08T16:42:24.738421Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
1a70e225-f70e-45c1-af25-16e6ad16a860	2026-09-08 12:29	2026-09-08 12:29	2026-09-08 12:29	CRCL	CRCL260918C00095000	call	95.0000	2026-09-18	7.2000	7.0000	7.2000	97.7100	11520.00	11520.00	0.00	16	9	646	3262	0.198038013488657	0.89493721046902	0.89493721046902	true	false	false	true
6c47e344-ff52-4b8b-8d5c-c4f4548efcf7	2026-09-08 12:29	2026-09-08 12:29	2026-09-08 12:29	CRCL	CRCL270319C00140000	call	140.0000	2027-03-19	12.3500	12.3000	12.5000	97.7000	38292.00	4940.00	32117.00	31	7	507	3671	0.138109506946336	0.835304434611771	0.835304434611771	true	false	false	true
16348103-2887-4e39-8b23-6fbed033f7ad	2026-09-08 12:29	2026-09-08 12:29	2026-09-08 12:29	CRCL	CRCL260918C00095000	call	95.0000	2026-09-18	7.1000	7.0000	7.1500	97.7000	26270.00	9940.00	4970.00	37	15	555	3262	0.170141017780503	0.879831311187714	0.879831311187714	true	false	false	true
1c410be5-c0ec-43bb-bb65-3a8a327e8125	2026-09-08 12:12	2026-09-08 12:12	2026-09-08 12:12	CRCL	CRCL261016C00100000	call	100.0000	2026-10-16	9.4100	9.3500	9.5000	97.6100	43265.00	940.00	42325.00	46	7	2302	5634	0.408590699325524	0.818810932122006	0.818810932122006	false	false	false	true
337f4c60-fac6-49fe-ba23-10a9d554f034	2026-09-08 12:04	2026-09-08 12:04	2026-09-08 12:04	CRCL	CRCL260918P00095000	put	95.0000	2026-09-18	3.8000	3.6500	3.8000	98.7200	20900.00	20900.00	0.00	55	55	190	1687	0.11262596324837	0.856381342778647	0.861135460434401	false	false	false	true
a0bd87eb-7f9c-4c09-8eee-0b90335fda9a	2026-09-08 11:27	2026-09-08 11:27	2026-09-08 11:27	CRCL	CRCL261016C00100000	call	100.0000	2026-10-16	9.4500	9.4000	9.5500	97.7500	94500.00	26460.00	68040.00	100	5	625	5634	0.110933617323394	0.816957936837432	0.816957936837432	false	false	false	true
a99e7065-2d3f-4f03-823e-3bdbb479880f	2026-09-08 11:24	2026-09-08 11:24	2026-09-08 11:24	CRCL	CRCL260918P00095000	put	95.0000	2026-09-18	4.2000	4.2000	4.4000	97.5215	15120.00	0.00	15120.00	36	11	129	1687	0.0764671013633669	0.852202948002331	0.852202948002331	true	false	false	true
976bd234-1883-486a-9ead-cf2aaf2882d6	2026-09-08 11:14	2026-09-08 11:14	2026-09-08 11:14	CRCL	CRCL260911C00100000	call	100.0000	2026-09-11	2.5900	2.5200	2.6100	97.9700	32141.00	25925.00	6216.00	124	11	1004	1340	0.749253731343284	0.977843438389286	0.980713314256438	false	false	false	true
a88329d5-49aa-4b5f-9432-e268e92f6627	2026-09-08 10:59	2026-09-08 10:59	2026-09-08 10:59	CRCL	CRCL270319C00160000	call	160.0000	2027-03-19	9.6000	9.2000	9.7500	98.2700	28800.00	28800.00	0.00	30	7	51	292	0.174657534246575	0.847403928814299	0.847403928814299	false	false	false	true
2d1b8168-b267-4016-9881-4ecfee8443af	2026-09-08 10:49	2026-09-08 10:49	2026-09-08 10:49	CRCL	CRCL260911C00100000	call	100.0000	2026-09-11	3.0000	3.0000	3.1500	98.9900	15000.00	0.00	15000.00	50	7	783	1340	0.584328358208955	0.964041526039559	0.964041526039559	false	false	false	true
4d693ddd-42f1-4e1e-8777-c0294c68e2dd	2026-09-08 10:40	2026-09-08 10:40	2026-09-08 10:40	CRCL	CRCL260911P00095000	put	95.0000	2026-09-11	1.7400	1.7100	1.8700	98.7330	17380.00	9856.00	7524.00	100	7	446	1845	0.241734417344173	0.928403189728916	0.928403189728916	false	false	false	true
22e0f998-126e-4cfa-96dd-edd289db8ae7	2026-09-08 10:27	2026-09-08 10:27	2026-09-08 10:27	CRCL	CRCL261016C00115000	call	115.0000	2026-10-16	5.5500	5.5000	5.7500	99.5506	11100.00	0.00	11100.00	20	5	27	3172	0.00851197982345523	0.840401515088673	0.840401515088673	false	false	false	true
ac90ebb1-63da-4cf8-b343-28ca0935be99	2026-09-08 10:19	2026-09-08 10:19	2026-09-08 10:19	CRCL	CRCL270319C00165000	call	165.0000	2027-03-19	9.4000	8.5000	9.5500	99.4300	31020.00	31020.00	0.00	33	6	34	42	0.80952380952381	0.851798043083016	0.851798043083016	false	false	false	true
2c26112d-1909-4036-b566-34af10b1fa93	2026-09-08 10:19	2026-09-08 10:19	2026-09-08 10:19	CRCL	CRCL270319C00170000	call	170.0000	2027-03-19	8.8000	7.9500	8.9500	99.3400	17595.00	17595.00	0.00	20	7	25	185	0.135135135135135	0.854551430414596	0.854671384157163	true	false	false	true
19db3a86-1761-4596-9437-32c4e35df532	2026-09-08 10:10	2026-09-08 10:09	2026-09-08 10:09	CRCL	CRCL260925C00120000	call	120.0000	2026-09-25	1.6600	1.5000	1.7300	97.9150	16563.00	16563.00	0.00	100	8	127	344	0.369186046511628	0.919315149227003	0.899218067296814	false	false	false	true
e99accdc-ae4f-4cc1-991c-77fddec48311	2026-09-08 10:08	2026-09-08 10:08	2026-09-08 10:08	CRCL	CRCL261016P00080000	put	80.0000	2026-10-16	2.8000	2.6800	2.8000	97.7100	16800.00	16800.00	0.00	60	22	78	2319	0.0336351875808538	0.803348597350488	0.803566060361425	false	false	false	true
620357bf-da43-410e-8f25-b687ca9e70f1	2026-09-08 10:00	2026-09-08 10:00	2026-09-08 10:00	CRCL	CRCL270319C00160000	call	160.0000	2027-03-19	9.8100	9.0000	9.9500	98.8700	16685.00	10775.00	2970.00	17	11	17	292	0.0582191780821918	0.847878433884187	0.853296109949769	true	false	false	true
c6f6364b-71b0-4b2d-bba0-442d3d5d7a6c	2026-09-08 09:58	2026-09-08 09:58	2026-09-08 09:58	CRCL	CRCL260911C00098000	call	98.0000	2026-09-11	3.4500	3.4500	3.7000	97.9700	34500.00	0.00	34500.00	100	8	153	243	0.62962962962963	0.973892492711931	0.973892492711931	false	false	false	true
9ecfc328-af65-4d2e-849e-0d98294c1a80	2026-09-08 09:52	2026-09-08 09:52	2026-09-08 09:52	CRCL	CRCL260911C00100000	call	100.0000	2026-09-11	2.5000	2.5000	2.5800	97.5400	20500.00	0.00	20500.00	82	16	309	1340	0.230597014925373	1.00389485596691	1.00389485596691	true	false	false	true
39ea16bd-c617-43f9-84de-9c7d1c9049f9	2026-09-08 09:40	2026-09-08 09:40	2026-09-08 09:40	CRCL	CRCL260911P00099000	put	99.0000	2026-09-11	3.7000	3.6500	3.8000	98.5599	37000.00	0.00	37000.00	100	8	143	475	0.301052631578947	0.977768021161999	0.977768021161999	false	false	false	true
18660554-c62b-4f77-aa7d-14406d56e815	2026-09-04 15:58	2026-09-04 15:58	2026-09-04 15:58	CRCL	CRCL260911C00108000	call	108.0000	2026-09-11	2.0000	1.9700	2.0300	101.8700	20800.00	0.00	20600.00	104	6	2523	865	2.91676300578035	0.755653415190491	0.755653415190491	false	false	false	true
3cd34892-f857-43f3-8230-7812234aa78c	2026-09-04 15:56	2026-09-04 15:56	2026-09-04 15:56	CRCL	CRCL260911C00105000	call	105.0000	2026-09-11	2.5800	2.5800	2.6400	101.2000	19092.00	0.00	19092.00	74	14	2258	1560	1.4474358974359	0.734578897309402	0.734578897309402	false	false	false	true
517ef14a-548b-41e6-9cff-0c77080d5519	2026-09-04 15:56	2026-09-04 15:55	2026-09-04 15:55	CRCL	CRCL260918C00140000	call	140.0000	2026-09-18	0.4000	0.2700	0.4000	101.3300	20034.00	19999.00	35.00	501	39	747	4219	0.177056174448922	0.961654676630176	0.937522111780292	false	false	false	true
332bf848-cf4d-4989-b52c-b01f17144e7c	2026-09-04 15:54	2026-09-04 15:54	2026-09-04 15:54	CRCL	CRCL260911C00093000	call	93.0000	2026-09-11	9.4500	9.2000	9.5000	101.4000	10395.00	10395.00	0.00	11	6	91	279	0.326164874551971	0.710193429754979	0.710193429754979	false	false	false	true
0baf4bbf-3a7f-4151-926d-e1bfc7c017c2	2026-09-04 15:46	2026-09-04 15:45	2026-09-04 15:45	CRCL	CRCL261016C00120000	call	120.0000	2026-10-16	5.2000	5.2000	5.2500	101.4700	22880.00	0.00	22880.00	44	14	981	9872	0.099371961102107	0.816467415217925	0.816467415217925	false	false	false	true
5d81fa45-4c43-4c5c-b380-df2a91925939	2026-09-04 15:45	2026-09-04 15:45	2026-09-04 15:45	CRCL	CRCL261016C00120000	call	120.0000	2026-10-16	5.2400	5.1500	5.2500	101.4800	15734.00	14700.00	1034.00	30	8	880	9872	0.0891410048622366	0.820233056210447	0.813784576526834	false	false	false	true
2cdd7d92-e271-4fb8-a294-b71dc5b78467	2026-09-04 15:26	2026-09-04 15:26	2026-09-04 15:26	CRCL	CRCL260918C00100000	call	100.0000	2026-09-18	7.0500	7.0500	7.1000	101.5500	34545.00	0.00	34545.00	49	5	1165	8325	0.13993993993994	0.784401993948429	0.784401993948429	false	false	false	true
539b75f2-2561-4931-8ebe-5149f8ff0a6b	2026-09-04 15:26	2026-09-04 15:26	2026-09-04 15:26	CRCL	CRCL260918C00100000	call	100.0000	2026-09-18	7.0500	7.0500	7.1500	101.5500	69090.00	0.00	69090.00	98	6	1116	8325	0.134054054054054	0.784401993948429	0.784401993948429	false	false	false	true
40a65b5a-099b-44e3-ad9e-2592b00a3ac1	2026-09-04 15:11	2026-09-04 15:11	2026-09-04 15:11	CRCL	CRCL260925P00095000	put	95.0000	2026-09-25	4.3500	4.2500	4.5000	101.6200	43500.00	11745.00	13920.00	100	5	220	161	1.36645962732919	0.773891067984949	0.773891067984949	false	false	false	true
21eac0a2-300b-4786-bd76-cb54c6b81080	2026-09-04 14:44	2026-09-04 14:43	2026-09-04 14:43	CRCL	CRCL270319C00160000	call	160.0000	2027-03-19	10.6000	10.2500	10.6000	101.0900	81620.00	81620.00	0.00	77	6	80	214	0.373831775700935	0.84047980943044	0.84047980943044	false	false	false	true
5fa4b1f2-d852-4b4f-b66c-d3293980badb	2026-09-04 14:33	2026-09-04 14:33	2026-09-04 14:33	CRCL	CRCL261218C00260000	call	260.0000	2026-12-18	1.1200	0.8900	1.1200	101.4000	75935.00	75824.00	111.00	678	62	680	327	2.07951070336391	0.957881744353681	0.957881744353681	false	false	false	true
d2733fe0-8b6f-4463-a990-fbf1471a628f	2026-09-04 14:07	2026-09-04 14:07	2026-09-04 14:07	CRCL	CRCL260911C00105000	call	105.0000	2026-09-11	2.5900	2.5300	2.7000	101.2150	15546.00	0.00	15546.00	60	7	1772	1560	1.13589743589744	0.739124573291271	0.739124573291271	false	false	false	true
797dd693-f3dc-4330-ab8a-717a3a2916e3	2026-09-04 13:19	2026-09-04 13:19	2026-09-04 13:19	CRCL	CRCL261016C00115000	call	115.0000	2026-10-16	6.4000	6.3500	6.5500	101.7650	72320.00	6400.00	60800.00	113	13	199	3140	0.0633757961783439	0.801724480849566	0.801724480849566	false	false	false	true
05d18223-fe2a-4012-9532-c14f2cd34ba1	2026-09-04 12:42	2026-09-04 12:42	2026-09-04 12:42	CRCL	CRCL261016C00105000	call	105.0000	2026-10-16	10.1500	10.0000	10.2000	102.6150	95410.00	64960.00	30450.00	94	7	234	2948	0.0793758480325644	0.79365084572203	0.79365084572203	false	false	false	true
ac44da3c-eec5-4fc3-b2c3-ef324a272861	2026-09-04 12:31	2026-09-04 12:31	2026-09-04 12:31	CRCL	CRCL260918P00105000	put	105.0000	2026-09-18	7.9500	7.6000	8.0500	102.0000	19875.00	19080.00	795.00	25	6	45	548	0.0821167883211679	0.796070202854009	0.796070202854009	false	false	false	true
e9285d13-9a88-4318-a384-7e58a3a93dcc	2026-09-04 11:59	2026-09-04 11:59	2026-09-04 11:59	CRCL	CRCL260904C00101000	call	101.0000	2026-09-04	1.5500	1.4100	1.6500	101.9401	10525.00	449.00	10076.00	68	31	1723	799	2.15644555694618	1.01276717933738	1.04197615407502	true	false	false	true
564ff704-cb76-4ff0-9c24-1ebd5536c68a	2026-09-04 11:59	2026-09-04 11:59	2026-09-04 11:59	CRCL	CRCL270115C00100000	call	100.0000	2027-01-15	21.0500	21.0500	21.5000	101.9400	12630.00	0.00	12630.00	6	6	173	3820	0.0452879581151832	0.808185051096812	0.808187715231071	false	false	false	true
05f42e51-b5c6-4316-9874-f363ccb98404	2026-09-04 11:55	2026-09-04 11:54	2026-09-04 11:54	CRCL	CRCL260918C00100000	call	100.0000	2026-09-18	7.4500	7.3000	7.4500	102.1250	16390.00	16390.00	0.00	22	7	703	8325	0.0844444444444444	0.792862923687037	0.792862923687037	false	false	false	true
3055ab17-9a16-4895-bb3b-ab7852bb8a37	2026-09-04 11:47	2026-09-04 11:47	2026-09-04 11:47	CRCL	CRCL260904P00101000	put	101.0000	2026-09-04	0.6600	0.6100	0.6800	101.6700	14600.00	13280.00	1320.00	220	5	759	331	2.29305135951662	1.07717736285973	1.08170400397125	false	false	false	true
8ab53db4-6d96-47af-bcf9-c2833ba6dbe7	2026-09-04 11:40	2026-09-04 11:40	2026-09-04 11:40	CRCL	CRCL261016C00110000	call	110.0000	2026-10-16	7.8000	7.7500	7.8500	101.7000	32760.00	31980.00	0.00	42	6	171	2439	0.0701107011070111	0.792338581288427	0.792338581288427	false	false	false	true
0a605ae3-1c34-4e69-b746-687a614b6185	2026-09-04 11:40	2026-09-04 11:40	2026-09-04 11:40	CRCL	CRCL261016C00105000	call	105.0000	2026-10-16	9.5500	9.2500	9.6000	101.7000	15280.00	12415.00	955.00	16	12	67	2948	0.0227272727272727	0.78457996884938	0.78457996884938	true	false	false	true
93ceb634-dba2-4a13-bfa1-27a934755016	2026-09-04 11:39	2026-09-04 11:39	2026-09-04 11:39	CRCL	CRCL260904P00102000	put	102.0000	2026-09-04	1.4300	1.3000	1.4300	101.3000	14300.00	14300.00	0.00	100	5	257	241	1.06639004149378	1.15632890923772	1.15632890923772	false	false	false	true
0ea3b3ad-a86f-4064-b1a1-a01ad280f416	2026-09-04 11:34	2026-09-04 11:33	2026-09-04 11:33	CRCL	CRCL260918C00120000	call	120.0000	2026-09-18	1.3100	1.2100	1.3400	100.9700	18995.00	18733.00	0.00	145	11	606	2883	0.210197710718002	0.821486527842623	0.827630437414281	false	false	false	true
90ec688f-1b0d-484a-b1f8-92275497058a	2026-09-04 11:33	2026-09-04 11:33	2026-09-04 11:33	CRCL	CRCL261016C00105000	call	105.0000	2026-10-16	9.1000	8.7500	9.1500	100.9332	10010.00	10010.00	0.00	11	7	39	2948	0.0132293080054274	0.780039346677632	0.780039346677632	true	false	false	true
885eb526-d5cc-4c71-a018-b143f1dd17cd	2026-09-04 11:33	2026-09-04 11:33	2026-09-04 11:33	CRCL	CRCL261120C00120000	call	120.0000	2026-11-20	9.0000	8.6500	9.1000	100.9350	38700.00	38700.00	0.00	43	5	71	441	0.160997732426304	0.825683814653484	0.825683814653484	false	false	false	true
7877d775-bb68-4437-9a4b-3823155011ec	2026-09-04 11:33	2026-09-04 11:33	2026-09-04 11:33	CRCL	CRCL260911C00105000	call	105.0000	2026-09-11	2.4600	2.3300	2.4700	100.9350	17221.00	17221.00	0.00	70	7	794	1560	0.508974358974359	0.732595004589875	0.730700272703775	false	false	false	true
0ebb12e8-1424-42b8-a3a5-ca373f043ee8	2026-09-04 11:28	2026-09-04 11:28	2026-09-04 11:28	CRCL	CRCL260904C00100000	call	100.0000	2026-09-04	0.9800	0.9700	1.0300	100.1800	10435.00	99.00	10336.00	106	40	4508	4968	0.907407407407407	0.997715155567278	0.975620060925511	true	false	false	true
c975ec67-a9c3-47ac-be03-e1722f5b90ce	2026-09-04 11:27	2026-09-04 11:27	2026-09-04 11:27	CRCL	CRCL260904C00100000	call	100.0000	2026-09-04	0.9700	0.8600	1.0300	100.0400	13999.00	8199.00	5800.00	144	16	4350	4968	0.8756038647343	1.04181516517195	1.07753333409921	true	false	false	true
f1d80b01-cfc5-4bc8-9d55-0be72a2fc02f	2026-09-04 11:27	2026-09-04 11:27	2026-09-04 11:27	CRCL	CRCL260918P00055000	put	55.0000	2026-09-18	0.0300	0.0200	0.0800	99.8500	6000.00	0.00	6000.00	2000	2	2104	7382	0.285017610403685	1.19878872364512	1.19878872364512	false	true	true	false