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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = SPOT×

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

1a4aaba3-a56b-4283-8c15-8156a630c72e	2026-09-24 13:59	2026-09-24 13:59	2026-09-24 13:59	SPOT	SPOT261030P00470000	put	470.0000	2026-10-30	15.0000	13.5500	16.4500	506.4300	87025.00	0.00	55525.00	58	17	58	105	0.552380952380952	0.498671652653515	0.498671652653515	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Communication Services	105056921781.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T18:01:57.698805Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
134cd907-42c5-465d-a10d-6855347a4545	2026-09-24 13:59	2026-09-24 13:59	2026-09-24 13:59	SPOT	SPOT261030P00470000	put	470.0000	2026-10-30	15.0900	14.9000	16.4500	506.4300	54320.00	9175.00	45145.00	36	14	94	105	0.895238095238095	0.498671652653515	0.505190876176235	false	false	false
ca57a7b9-b377-46c7-886a-90e96cd2afd4	2026-09-24 13:57	2026-09-24 13:57	2026-09-24 13:57	SPOT	SPOT261030C00545000	call	545.0000	2026-10-30	17.7000	15.6000	19.0500	506.0950	38940.00	35400.00	3540.00	22	7	22	90	0.244444444444444	0.500525048301416	0.500525048301416	false	false	false
96ca6fbd-7322-4e90-be2a-45877f7c077e	2026-09-24 13:51	2026-09-24 13:51	2026-09-24 13:51	SPOT	SPOT261030P00490000	put	490.0000	2026-10-30	23.1000	21.7000	24.5500	506.0000	55440.00	36960.00	18480.00	24	9	152	206	0.737864077669903	0.504867554855467	0.504867554855467	false	false	false
ab8f4be8-6dce-4997-9995-fef7d526ee4e	2026-09-24 13:49	2026-09-24 13:49	2026-09-24 13:49	SPOT	SPOT261030P00485000	put	485.0000	2026-10-30	21.1000	18.5000	23.7000	506.0000	50640.00	0.00	25320.00	24	13	24	105	0.228571428571429	0.505883388135788	0.505883388135788	false	false	false	true
e3bffdad-7e02-4bab-97b7-59693f6f6927	2026-09-24 13:48	2026-09-24 13:48	2026-09-24 13:48	SPOT	SPOT261030P00490000	put	490.0000	2026-10-30	23.3000	21.1500	25.2000	505.0000	67570.00	30290.00	37280.00	29	17	128	206	0.621359223300971	0.505670516726945	0.505670516726945	false	false	false
186ea372-448f-497a-b31f-3d1ea94c2333	2026-09-24 12:23	2026-09-24 12:23	2026-09-24 12:23	SPOT	SPOT261030C00535000	call	535.0000	2026-10-30	21.1900	21.0500	26.5000	509.7300	59332.00	2295.00	57037.00	28	19	28	76	0.368421052631579	0.479087227652502	0.50948995657561	false	false	false
bea92c53-981c-413b-8310-326acbeef1e8	2026-09-24 11:11	2026-09-24 11:10	2026-09-24 11:10	SPOT	SPOT270416C00610000	call	610.0000	2027-04-16	37.6800	37.2500	39.1000	510.0000	97970.00	60370.00	37600.00	26	5	68	5	13.6	0.440008495815775	0.441038931785293	false	false	false	true
576e2b9d-3cb6-40af-90fb-944f751a21cf	2026-09-24 10:58	2026-09-24 10:58	2026-09-24 10:58	SPOT	SPOT270917C00680000	call	680.0000	2027-09-17	48.5200	44.0000	49.0000	510.6400	72785.00	58250.00	14535.00	15	5	34	1	34	0.459054661765118	0.459054661765118	false	false	false	true
f0ffaac3-6ea7-4d1c-8e14-449f64b1c049	2026-09-24 10:49	2026-09-24 10:49	2026-09-24 10:49	SPOT	SPOT261023C00550000	call	550.0000	2026-10-23	17.0000	17.0000	20.1500	510.0000	340000.00	0.00	340000.00	200	8	210	4	52.5	0.545845476114488	0.545845476114488	true	false	false	true
76cfd1c8-f26b-44b9-b156-3aa69d0c7119	2026-09-24 10:48	2026-09-24 10:48	2026-09-24 10:48	SPOT	SPOT270115P00490000	put	490.0000	2027-01-15	35.8900	34.1500	36.0500	511.0000	104085.00	100515.00	3570.00	29	11	29	247	0.117408906882591	0.439865075044319	0.437991435890616	false	false	false
5241a83b-6fa8-47b6-9259-b853daa35f57	2026-09-24 10:45	2026-09-24 10:45	2026-09-24 10:45	SPOT	SPOT261120P00470000	put	470.0000	2026-11-20	19.2300	18.0000	19.3000	511.3650	80775.00	69345.00	11430.00	42	11	42	7	6	0.485607407679144	0.483418931327871	false	false	false	true
e2d8ac71-3270-4d2d-8ba7-664ce27ae4a5	2026-09-24 10:25	2026-09-24 10:25	2026-09-24 10:25	SPOT	SPOT260925P00502500	put	502.5000	2026-09-25	3.1000	2.9500	4.4000	509.4100	32266.00	330.00	31936.00	104	41	104	69	1.50724637681159	0.557061007630711	0.583762578672713	true	false	false	true
3908f307-0e67-4093-ac7a-6937a9b5eb42	2026-09-24 09:57	2026-09-24 09:57	2026-09-24 09:57	SPOT	SPOT261218C00550000	call	550.0000	2026-12-18	28.8800	27.8500	31.4000	507.4300	25990.00	17310.00	8680.00	9	9	14	254	0.0551181102362205	0.445757196178303	0.448379180795149	false	false	false
4b4baf26-14e8-4e58-ba70-3db70f211f84	2026-09-24 09:51	2026-09-24 09:51	2026-09-24 09:51	SPOT	SPOT261030C00595000	call	595.0000	2026-10-30	7.2000	4.1500	11.5000	506.8700	23770.00	8130.00	15640.00	33	7	35	3	11.6666666666667	0.50423111836802	0.494632831054582	false	false	false	true
445e162f-99c0-4cc4-adc8-6886cefa1cf0	2026-09-24 09:51	2026-09-24 09:51	2026-09-24 09:51	SPOT	SPOT261030C00595000	call	595.0000	2026-10-30	7.0100	5.6000	11.4500	506.8700	17525.00	7025.00	10500.00	25	8	65	3	21.6666666666667	0.494632831054582	0.494632831054582	true	false	false	true
4df35916-9dcd-4aa2-b48a-ff36a027bbdc	2026-09-23 15:56	2026-09-23 15:55	2026-09-23 15:55	SPOT	SPOT270115C00880000	call	880.0000	2027-01-15	1.0400	0.9600	1.6800	511.5300	27985.00	10360.00	17625.00	270	18	273	52	5.25	0.445907523326854	0.443286498102453	true	false	false	true
7be8a568-69a7-4405-aed8-7d15fba7939b	2026-09-23 14:31	2026-09-23 14:31	2026-09-23 14:31	SPOT	SPOT270416C00640000	call	640.0000	2027-04-16	29.3000	25.0500	29.3000	505.4700	108410.00	108410.00	0.00	37	11	39	4	9.75	0.441965217348803	0.441965217348803	false	false	false	true
be7a06cf-9cff-4ace-bb42-076464e586cd	2026-09-23 13:59	2026-09-23 13:59	2026-09-23 13:59	SPOT	SPOT290119C00810000	call	810.0000	2029-01-19	80.4200	77.9000	80.5000	504.1000	120625.00	56265.00	64360.00	15	8	40	0	0	0.464811183970608	0.465306503077198	false	false	false	true
a9ff2d5d-0bfe-42ea-aae1-29f88d58f6bc	2026-09-23 13:59	2026-09-23 13:59	2026-09-23 13:59	SPOT	SPOT290119C00810000	call	810.0000	2029-01-19	80.1200	74.0000	80.1500	504.1000	200300.00	200300.00	0.00	25	6	25	0	0	0.464315791463333	0.464315791463333	false	false	false	true
c1a34514-f085-4c27-8bec-f77589d60085	2026-09-23 13:15	2026-09-23 13:14	2026-09-23 13:14	SPOT	SPOT270416C00530000	call	530.0000	2027-04-16	59.8700	57.3500	60.5500	501.0000	47900.00	41930.00	5970.00	8	5	8	6	1.33333333333333	0.44596328787036	0.444624695750429	true	false	false	true
35e12659-a86b-4785-a57c-5cbbf94ee14c	2026-09-23 12:57	2026-09-23 12:57	2026-09-23 12:57	SPOT	SPOT270416C00580000	call	580.0000	2027-04-16	42.9700	40.1500	43.0000	501.6000	249220.00	171910.00	77310.00	58	6	58	1	58	0.444285463616445	0.443945648723015	false	false	false	true
eb0c3fad-1029-4242-9ee5-3ce6116cd727	2026-09-23 11:39	2026-09-23 11:38	2026-09-23 11:38	SPOT	SPOT270115P00470000	put	470.0000	2027-01-15	30.2800	29.7500	31.0500	501.5300	39361.00	30285.00	9076.00	13	5	13	311	0.0418006430868167	0.435899315539662	0.435504702541386	false	false	false
9da494cb-b7e6-4c9b-aebc-bf86f9d97fbc	2026-09-23 11:37	2026-09-23 11:37	2026-09-23 11:37	SPOT	SPOT261120P00450000	put	450.0000	2026-11-20	15.1500	15.1500	16.2500	500.9575	42420.00	0.00	42420.00	28	5	29	52	0.557692307692308	0.476484223504543	0.476484223504543	false	false	false	true
685ebd7a-90f9-482f-95de-5f69e5e6548f	2026-09-23 11:29	2026-09-23 11:29	2026-09-23 11:29	SPOT	SPOT261030P00435000	put	435.0000	2026-10-30	6.9700	6.8000	9.5500	499.0000	62765.00	28265.00	34500.00	90	11	120	1	120	0.489382878901933	0.485508352840726	true	false	false	true
a5ccba33-b7f7-4803-8391-b8e1ade91502	2026-09-23 11:25	2026-09-23 11:25	2026-09-23 11:25	SPOT	SPOT260925P00475000	put	475.0000	2026-09-25	0.5500	0.5500	0.8900	502.4000	11935.00	0.00	11935.00	217	46	227	68	3.33823529411765	0.509755426737047	0.509755426737047	false	false	false	true
b9eb2151-30fd-4874-ae6a-06ab018ebbbd	2026-09-23 10:41	2026-09-23 10:41	2026-09-23 10:41	SPOT	SPOT270319P00430000	put	430.0000	2027-03-19	25.8100	24.0000	27.1000	501.0350	33550.00	7750.00	25800.00	13	8	13	107	0.121495327102804	0.446693212840442	0.448255946398836	false	false	false
2b332f80-fa6d-4696-b33a-b6b3911d0363	2026-09-23 10:40	2026-09-23 10:40	2026-09-23 10:40	SPOT	SPOT280121C00730000	call	730.0000	2028-01-21	51.5000	50.7500	52.5500	500.3350	25750.00	0.00	25750.00	5	5	7	23	0.304347826086957	0.458255300070973	0.458255300070973	false	false	false	true
7f0e1bbf-8121-42bc-ada4-2027707ef827	2026-09-23 10:08	2026-09-23 10:08	2026-09-23 10:08	SPOT	SPOT270319C00650000	call	650.0000	2027-03-19	19.0000	18.9000	19.7000	490.0150	19000.00	3800.00	15200.00	10	6	39	17	2.29411764705882	0.444849809381883	0.443449796008539	false	false	false
cafadec2-e107-4cbf-a645-017b1bba1a1a	2026-09-23 09:56	2026-09-23 09:56	2026-09-23 09:56	SPOT	SPOT261016C00495000	call	495.0000	2026-10-16	20.7100	20.7000	23.8000	495.0250	14495.00	0.00	14495.00	7	5	20	8	2.5	0.398444305298649	0.406406476620153	true	false	false	true
8f3e8093-a82d-4011-b761-f18f093791d4	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	SPOT	SPOT261016P00502500	put	502.5000	2026-10-16	20.7200	19.1500	21.7000	501.0000	41440.00	2030.00	39410.00	20	7	35	1	35	0.39693690798305	0.396821410882299	false	false	false	true
6c2d3d6a-871e-42c3-82d7-8fe3ecb08a91	2026-09-22 15:36	2026-09-22 15:36	2026-09-22 15:36	SPOT	SPOT261030P00530000	put	530.0000	2026-10-30	47.2800	45.1000	47.7500	500.7350	23640.00	18930.00	4710.00	5	5	54	43	1.25581395348837	0.485620874915631	0.486422554896906	false	false	false	true
b5e7fdf2-a820-4247-9c91-235af77b95c9	2026-09-22 15:18	2026-09-22 15:18	2026-09-22 15:18	SPOT	SPOT261016C00540000	call	540.0000	2026-10-16	7.4000	7.2000	7.6000	500.4700	11105.00	5960.00	5145.00	15	5	230	317	0.725552050473186	0.401172309993858	0.401172309993858	false	false	false
a0b97644-2300-45ca-8cd3-542d2d5f22f6	2026-09-22 15:18	2026-09-22 15:18	2026-09-22 15:18	SPOT	SPOT261016C00540000	call	540.0000	2026-10-16	7.4000	6.1000	7.6000	500.4700	53290.00	52540.00	750.00	72	11	209	317	0.659305993690852	0.399955298822498	0.402387453255943	false	false	false
075668a7-bca7-4aac-8b2b-272e024a675c	2026-09-22 14:11	2026-09-22 14:11	2026-09-22 14:11	SPOT	SPOT261218P00500000	put	500.0000	2026-12-18	40.7100	40.0000	41.0000	498.7295	65135.00	36650.00	16260.00	16	6	22	475	0.0463157894736842	0.440631953058114	0.43959207806149	true	false	false
db80af7f-6198-4526-89cb-a3cca6705518	2026-09-22 13:47	2026-09-22 13:47	2026-09-22 13:47	SPOT	SPOT260925P00505000	put	505.0000	2026-09-25	12.2400	11.3000	12.4500	498.0050	232610.00	142100.00	31710.00	190	47	202	82	2.46341463414634	0.473886239145512	0.463020780101998	false	false	false
5639e534-6efd-4e39-88e4-cb462a73a756	2026-09-22 13:47	2026-09-22 13:47	2026-09-22 13:47	SPOT	SPOT261002P00497500	put	497.5000	2026-10-02	12.5800	10.0500	12.8500	498.0050	60380.00	55370.00	5010.00	48	24	50	0	0	0.404574238633312	0.399324625847489	true	false	false	true
072822b9-44c2-4d34-ac9c-a594f2996b5b	2026-09-22 13:46	2026-09-22 13:46	2026-09-22 13:46	SPOT	SPOT260925P00497500	put	497.5000	2026-09-25	7.5100	5.7500	7.8000	498.9550	53308.00	40578.00	12730.00	71	12	90	56	1.60714285714286	0.467025152064697	0.465354761104013	true	false	false	true
f7ba8860-fbf7-4c35-830a-e274c54f73a7	2026-09-22 13:46	2026-09-22 13:46	2026-09-22 13:46	SPOT	SPOT261023P00435000	put	435.0000	2026-10-23	3.5000	2.8300	3.5000	499.0700	22750.00	22750.00	0.00	65	35	66	1	66	0.419129918506106	0.419129918506106	false	false	false	true
3d66727e-51a4-43b0-b0ec-db1d26b279b8	2026-09-22 11:57	2026-09-22 11:57	2026-09-22 11:57	SPOT	SPOT261016P00520000	put	520.0000	2026-10-16	26.0300	25.9000	26.3000	508.7350	203015.00	49495.00	101420.00	78	13	94	623	0.150882825040128	0.394421503975449	0.393451222858138	false	false	false
07c994cb-1429-44c0-908d-1a9bbed245a1	2026-09-22 11:57	2026-09-22 11:57	2026-09-22 11:57	SPOT	SPOT261016P00520000	put	520.0000	2026-10-16	25.8500	25.8500	26.3000	508.7350	28435.00	0.00	28435.00	11	7	11	623	0.0176565008025682	0.390539888017773	0.390539888017773	false	false	false	true
f140015e-8c73-4409-a4c6-176c3f22302b	2026-09-22 11:50	2026-09-22 11:49	2026-09-22 11:49	SPOT	SPOT261030C00510000	call	510.0000	2026-10-30	30.8000	28.9500	33.8000	508.3400	46200.00	0.00	46200.00	15	5	24	3	8	0.467449632347689	0.467449632347689	false	false	false	true
d8f336b1-ccf0-43ce-b17a-2522c187c9f9	2026-09-22 11:50	2026-09-22 11:49	2026-09-22 11:49	SPOT	SPOT261030P00510000	put	510.0000	2026-10-30	29.9000	26.0000	32.9500	508.3400	47840.00	20930.00	26910.00	16	6	23	4	5.75	0.461504751637452	0.461504751637452	false	false	false	true
da080898-5971-4dfe-855f-634cd2e9a9ed	2026-09-22 11:47	2026-09-22 11:47	2026-09-22 11:47	SPOT	SPOT261030C00545000	call	545.0000	2026-10-30	16.0500	15.2500	19.1000	508.2500	33705.00	0.00	33705.00	21	5	21	1	21	0.446929802347279	0.446929802347279	false	false	false	true
8074742f-d6fb-4165-adf8-b35e9798c9bc	2026-09-22 11:47	2026-09-22 11:47	2026-09-22 11:47	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	12.9200	9.0000	15.4000	508.5200	419780.00	221085.00	198695.00	325	28	325	6	54.1666666666667	0.442691388589312	0.434433452592805	true	false	false
6d5556e0-3071-4c4c-b75a-9be6ce0ffc86	2026-09-22 11:41	2026-09-22 11:41	2026-09-22 11:41	SPOT	SPOT261030P00420000	put	420.0000	2026-10-30	2.3500	2.3500	2.7000	509.2750	14100.00	0.00	14100.00	60	10	64	25	2.56	0.434889911344327	0.434889911344327	false	false	false	true
11bb45fa-aa4b-4d56-82a1-c1ed56e06383	2026-09-22 10:32	2026-09-22 10:31	2026-09-22 10:31	SPOT	SPOT260925C00515000	call	515.0000	2026-09-25	5.7500	5.1000	6.0500	507.4900	50600.00	33350.00	17250.00	88	6	144	57	2.52631578947368	0.48393080354812	0.48393080354812	false	false	false	true
08086140-21a6-4f8e-b79f-c827cb02f488	2026-09-22 10:30	2026-09-22 10:30	2026-09-22 10:30	SPOT	SPOT261218C00550000	call	550.0000	2026-12-18	29.0500	28.4500	29.6000	507.1550	20335.00	17430.00	0.00	7	7	17	238	0.0714285714285714	0.443514350909303	0.443514350909303	false	false	false
361b7534-090c-4248-800a-dbaefe699af3	2026-09-22 09:51	2026-09-22 09:51	2026-09-22 09:51	SPOT	SPOT261120P00440000	put	440.0000	2026-11-20	9.6000	8.5500	10.3500	515.2300	20162.00	11567.00	8595.00	21	11	29	26	1.11538461538462	0.473265347865783	0.473265347865783	false	false	false	true
feee3fb5-6a77-41f1-b15d-32dcdfb8306e	2026-09-21 15:43	2026-09-21 15:43	2026-09-21 15:43	SPOT	SPOT261120P00530000	put	530.0000	2026-11-20	42.4500	41.6500	44.6000	519.4444	101880.00	4245.00	97635.00	24	5	25	4	6.25	0.459998400131723	0.459998400131723	false	false	false	true