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 = SPX×

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

9fc75406-408c-4e1b-ac7c-c198bc089029	2026-09-29 14:06	2026-09-29 14:06	2026-09-29 14:06	SPX	SPX261016P07250000	put	7250.0000	2026-10-16	10.7000	10.7000	11.0000	7666.9800	321000.00	0.00	321000.00	300	6	742	10837	0.068469133524038	0.188893035826922	0.188893035826922	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-29T18:07:24.158187Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
759bdb62-f950-46f2-a8a2-36f915b2083b	2026-09-29 14:05	2026-09-29 14:05	2026-09-29 14:05	SPX	SPX261218C08600000	call	8600.0000	2026-12-18	4.6000	4.2000	4.6000	7665.6000	690000.00	690000.00	0.00	1500	7	1860	18646	0.0997532982945404	0.11725304337226	0.11725304337226	false	false	false	true
c9b72f20-c631-4186-bb6c-e71b055c500d	2026-09-29 13:59	2026-09-29 13:59	2026-09-29 13:59	SPX	SPX270917C07975000	call	7975.0000	2027-09-17	480.4300	478.3000	479.4000	7656.0200	32669240.00	0.00	0.00	680	11	700	90	7.77777777777778	0.155790899588517	0.155790899588517	false	false	false	true
b65a36f0-7cf4-4baf-afbf-3aa8eb7c8cf1	2026-09-29 13:59	2026-09-29 13:59	2026-09-29 13:59	SPX	SPX261218P07720000	put	7720.0000	2026-12-18	198.9000	200.3000	201.0000	7656.0200	815490.00	0.00	0.00	41	11	3233	1640	1.97134146341463	0.142014788925924	0.142014788925924	false	false	false	true
6307badb-bc04-489c-9382-4026561e6750	2026-09-29 13:59	2026-09-29 13:59	2026-09-29 13:59	SPX	SPX270917P07975000	put	7975.0000	2027-09-17	480.5100	481.2000	482.5000	7656.0200	32674680.00	0.00	0.00	680	11	680	123	5.52845528455285	0.16495188856006	0.16495188856006	false	false	false	true
0fc3f530-3c76-48d6-9957-8257e7521891	2026-09-29 13:59	2026-09-29 13:59	2026-09-29 13:59	SPX	SPX261218C07720000	call	7720.0000	2026-12-18	197.9000	195.9000	196.5000	7656.0200	811390.00	0.00	0.00	41	11	3236	1740	1.85977011494253	0.135642288456126	0.135642288456126	false	false	false	true
dd2a4745-bf2e-4a1d-a115-493af01cbede	2026-09-29 13:41	2026-09-29 13:41	2026-09-29 13:41	SPX	SPX270521P04600000	put	4600.0000	2027-05-21	22.5000	22.4000	22.9000	7661.2600	191250.00	0.00	191250.00	85	4	85	350	0.242857142857143	0.367842959993439	0.367842959993439	false	true	false	true
5964fd9d-11fa-4786-a2d9-fad1c7837fd2	2026-09-29 13:39	2026-09-29 13:39	2026-09-29 13:39	SPX	SPX261016C07740000	call	7740.0000	2026-10-16	50.4000	49.9000	50.4000	7660.8900	25200.00	25200.00	0.00	5	5	54	680	0.0794117647058823	0.11850731203799	0.11850731203799	false	false	false	true
9052b25b-2755-4ebd-885b-6b9074cd7eb0	2026-09-29 13:33	2026-09-29 13:33	2026-09-29 13:33	SPX	SPX261016P06600000	put	6600.0000	2026-10-16	2.5500	2.4000	2.5500	7659.7400	34680.00	34680.00	0.00	136	9	519	20473	0.0253504615835491	0.320680682332895	0.320680682332895	false	false	false	true
f1ef38b9-9aa3-4f56-887f-01fd2b6cc646	2026-09-29 13:11	2026-09-29 13:11	2026-09-29 13:11	SPX	SPX270617P06500000	put	6500.0000	2027-06-17	112.0000	111.7000	112.1000	7656.5800	112000.00	67200.00	44800.00	10	5	222	11616	0.0191115702479339	0.231541885529196	0.231541885529196	false	false	false	true
cb0326d3-5c03-4a9f-9eb1-1cbf5b1bf289	2026-09-29 13:09	2026-09-29 13:09	2026-09-29 13:09	SPX	SPX270617P07750000	put	7750.0000	2027-06-17	350.7000	350.2000	351.1000	7656.1400	350700.00	70140.00	210420.00	10	5	73	2440	0.0299180327868852	0.166119762019469	0.166119762019469	false	false	false	true
27c8a5c8-371c-40fa-b7d0-772ff5464ff7	2026-09-29 13:08	2026-09-29 13:08	2026-09-29 13:08	SPX	SPX270617P07750000	put	7750.0000	2027-06-17	350.6000	350.0000	351.2000	7655.9900	350600.00	70120.00	280480.00	10	5	53	2440	0.0217213114754098	0.166055499905532	0.166055499905532	false	false	false	true
07544871-ad86-4601-91b3-d2b1c08bd7b3	2026-09-29 13:01	2026-09-29 13:01	2026-09-29 13:01	SPX	SPX261120C08070000	call	8070.0000	2026-11-20	25.0000	24.8000	25.2000	7656.5400	17500.00	10000.00	5000.00	7	7	14	248	0.0564516129032258	0.115640709548453	0.115640709548453	false	false	false	true
53e0229a-8790-4778-b448-89b20077e38e	2026-09-29 12:35	2026-09-29 12:35	2026-09-29 12:35	SPX	SPX261120P06025000	put	6025.0000	2026-11-20	7.6000	7.4000	7.6000	7640.0000	228000.00	228000.00	0.00	300	6	600	278	2.15827338129496	0.330358464050982	0.330358464050982	false	false	false	true
c2337aa6-54c9-425f-8060-eadf2d231488	2026-09-29 12:21	2026-09-29 12:20	2026-09-29 12:20	SPX	SPX270319P05500000	put	5500.0000	2027-03-19	28.8000	28.5000	29.0000	7662.0100	80640.00	80640.00	0.00	28	5	59	10203	0.00578261295697344	0.313219406389369	0.313219406389369	false	false	false	true
5d5452bc-70dd-408c-869b-a9915a6cfc08	2026-09-29 12:17	2026-09-29 12:17	2026-09-29 12:17	SPX	SPX270617P04550000	put	4550.0000	2027-06-17	25.1000	24.8000	25.1000	7660.3700	45180.00	45180.00	0.00	18	5	261	429	0.608391608391608	0.363344930490179	0.363344930490179	false	false	false	true
54f0102d-ef4f-477d-a234-7bdd98679bed	2026-09-29 12:15	2026-09-29 12:14	2026-09-29 12:14	SPX	SPX270617P04550000	put	4550.0000	2027-06-17	25.1000	24.9000	25.1000	7659.8900	35140.00	35140.00	0.00	14	5	178	429	0.414918414918415	0.363313184183206	0.363313184183206	false	false	false	true
8be353c9-eaf0-4d11-9efe-f75057f2d987	2026-09-29 12:08	2026-09-29 12:08	2026-09-29 12:08	SPX	SPX270617P02200000	put	2200.0000	2027-06-17	3.3500	3.1000	3.5000	7640.0000	418750.00	0.00	0.00	1250	8	1250	865	1.44508670520231	0.593029670857429	0.593029670857429	false	false	false	true
681c914d-4f7b-426b-9120-2e1a79831c0b	2026-09-29 12:08	2026-09-29 12:08	2026-09-29 12:08	SPX	SPX270617P03000000	put	3000.0000	2027-06-17	7.5600	7.4000	7.7000	7640.0000	453600.00	0.00	0.00	600	8	750	1659	0.452079566003617	0.502428961643982	0.502428961643982	false	false	false	true
5fe48f2f-5ed9-48c4-954a-89f8a4fc6d37	2026-09-29 12:08	2026-09-29 12:08	2026-09-29 12:08	SPX	SPX261016P06510000	put	6510.0000	2026-10-16	2.2400	2.1000	2.3000	7640.0000	16800.00	0.00	0.00	75	8	75	607	0.123558484349259	0.339887183969139	0.339887183969139	false	false	false	true
5303b957-afd8-4426-bce5-365a36199567	2026-09-29 12:08	2026-09-29 12:08	2026-09-29 12:08	SPX	SPX270617P01200000	put	1200.0000	2027-06-17	0.7500	0.7000	0.8000	7640.0000	348750.00	0.00	0.00	4650	8	4650	7773	0.598224623697414	0.749362718819637	0.749362718819637	false	false	false	true
2bcecba9-d98b-4921-8c88-99c38ab656b0	2026-09-29 12:08	2026-09-29 12:08	2026-09-29 12:08	SPX	SPX270617P03800000	put	3800.0000	2027-06-17	14.6200	14.4000	14.8000	7640.0000	511700.00	0.00	0.00	350	8	369	26213	0.014076984702247	0.426494575235316	0.426494575235316	false	false	false	true
5627edf6-1876-4cad-a571-36a78aa7ba20	2026-09-29 11:48	2026-09-29 11:48	2026-09-29 11:48	SPX	SPX261120P07250000	put	7250.0000	2026-11-20	51.8000	51.2000	51.8000	7666.1300	31080.00	31080.00	0.00	6	5	8	7323	0.00109244845008876	0.182661719071906	0.182661719071906	false	false	false	true
f5f5adcc-748f-4d03-9581-a7df1b086afd	2026-09-29 11:41	2026-09-29 11:41	2026-09-29 11:41	SPX	SPX270319P06250000	put	6250.0000	2027-03-19	54.7100	54.6000	55.2000	7665.3200	93010.00	32820.00	60190.00	17	12	17	2105	0.00807600950118765	0.253744443786462	0.253755850084282	false	false	false	true
b7c5a72f-f79f-4292-8311-3cd78e30c0f6	2026-09-29 11:41	2026-09-29 11:41	2026-09-29 11:41	SPX	SPX270917P07475000	put	7475.0000	2027-09-17	321.6000	320.2000	321.6000	7665.2100	2637120.00	2637120.00	0.00	82	6	165	1189	0.138772077375946	0.186286002354634	0.186286002354634	false	false	false	true
42ac0c0c-aca0-48ea-bfd9-0c65b730826d	2026-09-29 11:41	2026-09-29 11:41	2026-09-29 11:41	SPX	SPX270917P07475000	put	7475.0000	2027-09-17	321.2000	320.0000	321.6000	7665.2100	2633840.00	1991440.00	642400.00	82	6	83	1189	0.0698065601345669	0.186137376160859	0.186137376160859	false	false	false	true
7e97e788-f590-430b-9524-7d32febf477e	2026-09-29 11:39	2026-09-29 11:39	2026-09-29 11:39	SPX	SPX261218P07725000	put	7725.0000	2026-12-18	196.6000	195.8000	196.6000	7668.7400	1867700.00	0.00	0.00	95	8	244	1745	0.139828080229226	0.142907635963718	0.142907635963718	false	false	false	true
5cdd8230-2786-485e-8609-228cd7fd89d4	2026-09-29 11:39	2026-09-29 11:39	2026-09-29 11:39	SPX	SPX261218C07725000	call	7725.0000	2026-12-18	198.6000	198.7000	199.5000	7668.7400	1509360.00	0.00	0.00	76	8	237	3161	0.0749762733312243	0.133205184777066	0.133205184777066	false	false	false	true
4cff4efa-7981-4941-b4f9-d9103b09cb89	2026-09-29 11:39	2026-09-29 11:39	2026-09-29 11:39	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	75.5700	75.2000	75.9000	7668.7400	3778500.00	0.00	0.00	500	8	2676	286981	0.00932465912377474	0.119989650955966	0.119989650955966	false	false	false	true
0046e48c-b881-41d9-bc42-3a4cef916eb0	2026-09-29 11:39	2026-09-29 11:39	2026-09-29 11:39	SPX	SPX261218P06500000	put	6500.0000	2026-12-18	26.8300	26.6000	27.0000	7668.7400	1341500.00	0.00	0.00	500	8	504	27145	0.0185669552403758	0.255370256038441	0.255370256038441	false	false	false	true
27f021b2-efea-4eb3-a620-9ceff735e76c	2026-09-29 11:38	2026-09-29 11:38	2026-09-29 11:38	SPX	SPX261016P07315000	put	7315.0000	2026-10-16	14.1000	13.9000	14.2000	7667.1700	18330.00	14100.00	4230.00	13	11	249	350	0.711428571428571	0.17885892755083	0.17885892755083	false	false	false	true
f0e10aed-b69c-4c8d-968b-9b06256f546f	2026-09-29 11:36	2026-09-29 11:36	2026-09-29 11:36	SPX	SPX261016C08000000	call	8000.0000	2026-10-16	3.2000	3.2000	3.4000	7645.0000	80000.00	0.00	80000.00	250	7	10594	206192	0.0513792969659347	0.10921607506081	0.10921607506081	false	false	false	true
3fc4223b-2ff5-4913-ae43-91e41b14cf11	2026-09-29 11:26	2026-09-29 11:26	2026-09-29 11:26	SPX	SPX261218P08125000	put	8125.0000	2026-12-18	444.7000	444.1000	446.4000	7640.0000	222350.00	0.00	222350.00	5	5	50	168	0.297619047619048	0.129044851735999	0.129044851735999	false	false	false	true
df9f4647-3077-4abb-b876-6b658e38d0a8	2026-09-29 11:26	2026-09-29 11:26	2026-09-29 11:26	SPX	SPX261218P08125000	put	8125.0000	2026-12-18	445.1000	444.8000	446.0000	7640.0000	222550.00	0.00	222550.00	5	5	31	168	0.18452380952381	0.129509319638264	0.129509319638264	false	false	false	true
38456d73-4c6f-4bfa-8313-4cfc55563342	2026-09-29 11:02	2026-09-29 11:02	2026-09-29 11:02	SPX	SPX261218C08300000	call	8300.0000	2026-12-18	20.2000	20.2000	20.6000	7674.4700	46460.00	0.00	46460.00	23	5	29	18101	0.00160212142975526	0.114907632428418	0.114907632428418	false	false	false	true
27729c79-4f5e-46dd-aa69-73d7e6f8fbde	2026-09-29 10:44	2026-09-29 10:44	2026-09-29 10:44	SPX	SPX261016P06500000	put	6500.0000	2026-10-16	1.9000	1.8000	1.9500	7679.8900	19000.00	19000.00	0.00	100	4	107	22944	0.00466352859135286	0.339962757161907	0.339962757161907	false	true	false	true
ff85c2cb-ed9d-448c-bc45-e9430a9b160b	2026-09-29 10:40	2026-09-29 10:39	2026-09-29 10:39	SPX	SPX261016P07000000	put	7000.0000	2026-10-16	4.4800	4.3000	4.5000	7683.3800	927360.00	0.00	0.00	2070	5	4133	211724	0.0195206967561542	0.235776931378125	0.235776931378125	false	false	false	true
3b1cdbc0-e6d9-453b-b0ba-04c0624498b1	2026-09-29 10:40	2026-09-29 10:39	2026-09-29 10:39	SPX	SPX261016C08000000	call	8000.0000	2026-10-16	3.9500	3.8000	4.1000	7683.3800	817650.00	0.00	0.00	2070	5	4075	206192	0.0197631333902382	0.109138538137862	0.109138538137862	false	false	false	true
ee4b19b1-787f-4435-8cb8-bcb3cd719be1	2026-09-29 10:37	2026-09-29 10:37	2026-09-29 10:37	SPX	SPX261218C07740000	call	7740.0000	2026-12-18	198.0000	197.3000	198.1000	7682.5100	792000.00	0.00	0.00	40	5	1397	1874	0.745464247598719	0.132927969631424	0.132927969631424	false	false	false	true
c0ad1cc0-83d1-4267-a245-b279adbb1c8f	2026-09-29 10:37	2026-09-29 10:37	2026-09-29 10:37	SPX	SPX261218P07740000	put	7740.0000	2026-12-18	196.0000	196.1000	196.9000	7682.5100	784000.00	0.00	0.00	40	5	1407	1984	0.709173387096774	0.141850558778498	0.141850558778498	false	false	false	true
a4ac725e-925d-4586-bdc5-b1070e9feaeb	2026-09-29 10:37	2026-09-29 10:37	2026-09-29 10:37	SPX	SPX270115P07875000	put	7875.0000	2027-01-15	275.8000	275.7000	276.8000	7682.5100	3668140.00	0.00	0.00	133	5	133	890	0.149438202247191	0.135200378481666	0.135200378481666	false	false	false	true
3e88cd68-35d5-4376-a6b2-42a8bdd6fe4f	2026-09-29 10:37	2026-09-29 10:37	2026-09-29 10:37	SPX	SPX270617C08525000	call	8525.0000	2027-06-17	135.6000	135.3000	136.5000	7682.5100	2752680.00	0.00	0.00	203	5	203	1468	0.138283378746594	0.129671439754999	0.129671439754999	false	false	false	true
133aeff4-652b-46de-b956-0f0b4cecd260	2026-09-29 10:37	2026-09-29 10:37	2026-09-29 10:37	SPX	SPX261120P07000000	put	7000.0000	2026-11-20	28.9100	28.9000	29.3000	7682.5100	202370.00	0.00	0.00	70	5	85	81089	0.00104823095610995	0.209129958702382	0.209129958702382	false	false	false	true
0082909d-f785-4b80-8f34-6395f5390697	2026-09-29 10:37	2026-09-29 10:37	2026-09-29 10:37	SPX	SPX261120C08125000	call	8125.0000	2026-11-20	21.0000	20.8000	21.3000	7682.5100	617400.00	0.00	0.00	294	5	298	4877	0.0611031371744925	0.114780508031939	0.114780508031939	false	false	false	true
3eebe514-b539-4d10-805a-f2bcb2a0698e	2026-09-29 10:35	2026-09-29 10:35	2026-09-29 10:35	SPX	SPX270219P07200000	put	7200.0000	2027-02-19	119.0000	120.0000	120.8000	7682.8600	7140000.00	0.00	0.00	600	5	900	3161	0.284720025308447	0.184387506053061	0.184387506053061	false	false	false	true
9d43773f-29b3-47d3-849d-8d5349048baa	2026-09-29 10:10	2026-09-29 10:10	2026-09-29 10:10	SPX	SPX261120P06410000	put	6410.0000	2026-11-20	11.4000	11.2000	11.6000	7660.0000	34200.00	20520.00	0.00	30	5	30	109	0.275229357798165	0.279779879882272	0.279779879882272	false	false	false	true
2b18a490-aba7-4b00-be80-81147caa5c1e	2026-09-29 09:36	2026-09-29 09:36	2026-09-29 09:36	SPX	SPX261218P06600000	put	6600.0000	2026-12-18	29.7000	29.4000	29.7000	7683.6200	142560.00	142560.00	0.00	48	5	48	31245	0.00153624579932789	0.245792991952282	0.245792991952282	false	false	false	true
b4544a47-cafb-4734-b71a-b15d5d67f3c8	2026-09-29 09:35	2026-09-29 09:35	2026-09-29 09:35	SPX	SPX261016C07800000	call	7800.0000	2026-10-16	34.8000	34.8000	35.4000	7682.8600	20880.00	0.00	20880.00	6	5	11	24461	0.000449695433547279	0.112922393330045	0.112922393330045	false	false	false	true
3526b22a-42aa-45e7-894e-f4821821476c	2026-09-29 09:33	2026-09-29 09:33	2026-09-29 09:33	SPX	SPX261016P07550000	put	7550.0000	2026-10-16	37.7000	37.7000	38.3000	7685.8400	94250.00	0.00	94250.00	25	5	50	6238	0.00801538954793203	0.1439840465468	0.1439840465468	false	false	false	true
eca0ac9a-e628-49a5-b1cc-982b5197c6ae	2026-09-29 09:30	2026-09-29 09:30	2026-09-29 09:30	SPX	SPX270219P07300000	put	7300.0000	2027-02-19	134.1000	134.1000	134.5000	7693.6700	844830.00	0.00	844830.00	63	8	63	4243	0.0148479849163328	0.178333514119733	0.178333514119733	false	false	false	true