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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 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×er_time = unknown×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

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	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	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-23T19:57:58.068578Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
60747e80-53bf-479e-9cde-a286f24208f9	2026-09-21 15:32	2026-09-21 15:32	2026-09-21 15:32	SPOT	SPOT261120C00670000	call	670.0000	2026-11-20	4.6200	3.7000	5.0000	519.0000	55475.00	51050.00	4425.00	120	7	120	1	120	0.458635730972806	0.459402230289606	false	false	false
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
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
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
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
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
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
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
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
d3978db7-686a-4282-81a2-aa44f8a37dcf	2026-09-21 10:04	2026-09-21 10:04	2026-09-21 10:04	SPOT	SPOT261002P00515000	put	515.0000	2026-10-02	16.3500	15.9000	20.9000	510.2500	71925.00	36065.00	35860.00	44	7	44	137	0.321167883211679	0.398511769809902	0.401350995882082	true	false	false
5c1651b5-ce00-4fda-8aa1-1f550b6f877d	2026-09-21 10:04	2026-09-21 10:04	2026-09-21 10:04	SPOT	SPOT261002P00517500	put	517.5000	2026-10-02	17.7300	17.3500	22.2500	510.2500	47870.00	1790.00	46080.00	27	10	27	40	0.675	0.397568497017376	0.403293002722445	true	false	false
4aa2510e-c82d-42cd-b0ff-f3b1bcc74708	2026-09-18 15:30	2026-09-18 15:30	2026-09-18 15:30	SPOT	SPOT261016P00540000	put	540.0000	2026-10-16	37.6000	37.2000	38.0500	512.0600	56400.00	41320.00	15080.00	15	11	19	124	0.153225806451613	0.378300464687058	0.382165935147759	true	false	false
35af4584-a263-44b6-b7c9-ca867ac66873	2026-09-18 15:30	2026-09-18 15:30	2026-09-18 15:30	SPOT	SPOT261016P00520000	put	520.0000	2026-10-16	25.0400	21.8000	25.3500	512.0600	105170.00	80220.00	24950.00	42	13	57	596	0.0956375838926175	0.382812846307685	0.379970270149068	false	false	false
5e58909e-6c89-4304-ae8c-2fd80577f796	2026-09-18 14:35	2026-09-18 14:34	2026-09-18 14:34	SPOT	SPOT261120C00520000	call	520.0000	2026-11-20	37.5800	37.0500	40.1500	513.5700	180400.00	3760.00	176640.00	48	9	49	0	0	0.452430010219901	0.457139563095731	false	false	false
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