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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 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 = SPOT×

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

ff916880-feea-4a28-a4fc-02e8f16e541f	2026-09-24 15:38	2026-09-24 15:38	2026-09-24 15:38	SPOT	SPOT261023C00510000	call	510.0000	2026-10-23	30.7500	30.4500	31.6000	508.0000	18450.00	3075.00	15375.00	6	6	14	7	2	0.536592931064356	0.535715986182546	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Communication Services	105056921781.00	2026-11-03	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
5fa19ff0-7ac7-47e5-8ec9-703774ae16c1	2026-09-24 15:06	2026-09-24 15:05	2026-09-24 15:05	SPOT	SPOT261023C00580000	call	580.0000	2026-10-23	6.8400	6.4500	7.2000	504.4000	13675.00	10275.00	3400.00	20	6	99	18	5.5	0.503395283638328	0.503395283638328	true	false	false	true
a0df7f49-a9ac-4be7-aca0-5aa0a754e88d	2026-09-24 14:05	2026-09-24 14:05	2026-09-24 14:05	SPOT	SPOT261030P00490000	put	490.0000	2026-10-30	23.0000	21.6000	23.7500	505.8000	20700.00	20700.00	0.00	9	6	183	206	0.888349514563107	0.499830758213493	0.499830758213493	false	false	false	true
1040c609-ff49-413c-a426-5d64fadcaede	2026-09-24 14:01	2026-09-24 14:01	2026-09-24 14:01	SPOT	SPOT261030P00475000	put	475.0000	2026-10-30	17.0000	15.1000	19.5000	505.0000	71400.00	15300.00	56100.00	42	9	42	103	0.407766990291262	0.499940803981644	0.499940803981644	false	false	false	true
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
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	true
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	true
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	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
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	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
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
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
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	true
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
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
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	true
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	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
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
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	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
f69e6878-f859-46f9-901b-7f954a280896	2026-09-21 15:35	2026-09-21 15:35	2026-09-21 15:35	SPOT	SPOT261016P00465000	put	465.0000	2026-10-16	3.7000	3.6000	4.2000	519.7100	52540.00	0.00	52540.00	142	45	188	0	0	0.403374772305453	0.403374772305453	false	false	false	true
9d4be1ed-3921-4b38-915c-3fa1d2e196a5	2026-09-21 15:18	2026-09-21 15:18	2026-09-21 15:18	SPOT	SPOT261016C00470000	call	470.0000	2026-10-16	55.2000	53.8500	56.6000	519.0850	138000.00	132480.00	5520.00	25	5	25	30	0.833333333333333	0.410216923016479	0.410216923016479	false	false	false	true
aa8da8b2-3b22-4bca-94ed-c9c41ff2e6e7	2026-09-21 14:38	2026-09-21 14:38	2026-09-21 14:38	SPOT	SPOT260925C00525000	call	525.0000	2026-09-25	5.6000	5.6000	6.1500	515.9500	21280.00	0.00	21280.00	38	5	74	14	5.28571428571429	0.430595356033277	0.430595356033277	true	false	false	true
91d41f7f-c7f0-4e5c-b344-6028567ee04f	2026-09-21 13:04	2026-09-21 13:04	2026-09-21 13:04	SPOT	SPOT261016P00465000	put	465.0000	2026-10-16	3.9000	3.9000	4.2500	518.2700	16380.00	0.00	16380.00	42	14	44	0	0	0.403734033978394	0.403734033978394	false	false	false	true
cde91e0a-735b-4c41-a068-543492c9b086	2026-09-21 12:02	2026-09-21 12:02	2026-09-21 12:02	SPOT	SPOT261016P00480000	put	480.0000	2026-10-16	7.6500	6.8500	7.8000	514.5200	22950.00	22950.00	0.00	30	6	50	424	0.117924528301887	0.402405946954387	0.402405946954387	true	false	false	true
14120aba-83be-4c35-91c5-52c447872dca	2026-09-21 11:36	2026-09-21 11:35	2026-09-21 11:35	SPOT	SPOT261218C00540000	call	540.0000	2026-12-18	34.7500	34.7500	35.6000	513.0000	218925.00	0.00	218925.00	63	24	65	172	0.377906976744186	0.434250605194564	0.434250605194564	false	false	false	true
5aca4895-8895-4225-b03d-251132dd2f74	2026-09-21 10:51	2026-09-21 10:51	2026-09-21 10:51	SPOT	SPOT260925C00522500	call	522.5000	2026-09-25	4.5000	4.5000	5.4000	509.7800	10800.00	0.00	10800.00	24	6	60	49	1.22448979591837	0.439184004596896	0.439184004596896	false	false	false	true
7449b818-e8fa-4a42-9bd1-30916d3b23f8	2026-09-21 10:36	2026-09-21 10:36	2026-09-21 10:36	SPOT	SPOT261218P00420000	put	420.0000	2026-12-18	10.0000	9.9500	10.4500	509.9700	74005.00	2005.00	72000.00	74	15	74	168	0.44047619047619	0.454299761302071	0.454299761302071	false	false	false	true
1ab60e6d-4a1f-4be8-ba28-b006b002e7f1	2026-09-21 10:18	2026-09-21 10:18	2026-09-21 10:18	SPOT	SPOT261218C00610000	call	610.0000	2026-12-18	14.8000	14.0500	14.8000	511.3200	14800.00	14800.00	0.00	10	10	10	322	0.031055900621118	0.435714551429029	0.435714551429029	false	false	false	true
77b4b13e-96fc-49fb-81bf-a995b9703389	2026-09-18 12:52	2026-09-18 12:52	2026-09-18 12:52	SPOT	SPOT261030C00575000	call	575.0000	2026-10-30	10.0000	9.5000	10.0000	517.6300	52000.00	52000.00	0.00	52	6	195	3	65	0.402803969982742	0.402803969982742	true	false	false	true
eb8f01ab-4d16-4e7d-b33c-9c8cc5d3d218	2026-09-18 12:51	2026-09-18 12:51	2026-09-18 12:51	SPOT	SPOT261218P00500000	put	500.0000	2026-12-18	33.3000	32.4500	33.3000	518.8100	486180.00	486180.00	0.00	146	19	148	467	0.316916488222698	0.439716904012036	0.439716904012036	false	false	false	true
62ab9aef-79e9-4f9b-8df7-0604f133a2c4	2026-09-17 14:36	2026-09-17 14:36	2026-09-17 14:36	SPOT	SPOT261120C00560000	call	560.0000	2026-11-20	30.3500	30.3500	35.0000	534.0000	94085.00	0.00	94085.00	31	7	34	0	0	0.444232315404136	0.444232315404136	false	false	false	true
95a86ad2-ded0-4c94-b843-e31bd3c2b79b	2026-09-17 14:24	2026-09-17 14:24	2026-09-17 14:24	SPOT	SPOT261218C00550000	call	550.0000	2026-12-18	42.1500	42.1500	43.0500	536.5400	105375.00	0.00	105375.00	25	17	26	213	0.122065727699531	0.424517867929617	0.424517867929617	false	false	false	true
34d52f8f-7177-4d19-bbb1-8c098ef1706d	2026-09-17 13:18	2026-09-17 13:18	2026-09-17 13:18	SPOT	SPOT261023C00500000	call	500.0000	2026-10-23	47.2000	47.2000	49.0500	534.3650	174640.00	0.00	174640.00	37	16	37	6	6.16666666666667	0.385498418673492	0.385498418673492	false	false	false	true
1477a671-cb1e-4b52-a345-9b786d209b5d	2026-09-17 13:18	2026-09-17 13:18	2026-09-17 13:18	SPOT	SPOT261023C00495000	call	495.0000	2026-10-23	50.7500	50.7500	52.7500	534.3650	137025.00	0.00	137025.00	27	10	27	0	0	0.385459071286249	0.385459071286249	false	false	false	true
153cc35c-4ca5-48eb-878b-7c2b4d80623e	2026-09-17 12:01	2026-09-17 12:00	2026-09-17 12:00	SPOT	SPOT261218C00600000	call	600.0000	2026-12-18	24.2000	24.2000	24.9000	536.2025	135520.00	0.00	135520.00	56	11	60	333	0.18018018018018	0.42086444075132	0.42086444075132	false	false	false	true
b95bd3e7-79d5-4a20-9d03-624d5191e498	2026-09-17 11:04	2026-09-17 11:04	2026-09-17 11:04	SPOT	SPOT260925P00525000	put	525.0000	2026-09-25	6.7500	6.0000	7.0000	538.2089	60075.00	14850.00	45225.00	89	5	189	38	4.97368421052632	0.395281998240628	0.395281998240628	false	false	false	true
085a0c70-6ce9-4548-bbfc-85e5d1adbf21	2026-09-17 09:59	2026-09-17 09:59	2026-09-17 09:59	SPOT	SPOT261016C00540000	call	540.0000	2026-10-16	26.1000	24.1000	26.9000	543.3750	57420.00	54810.00	2610.00	22	6	22	208	0.105769230769231	0.386218652390209	0.386218652390209	false	false	false	true