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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Communication Services	103183845785.00	2026-11-03	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
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
38a5a0c3-2f10-408f-95e6-4f64c7c8daf9	2026-09-17 09:43	2026-09-17 09:43	2026-09-17 09:43	SPOT	SPOT270617C00720000	call	720.0000	2027-06-17	35.2100	35.2000	40.4000	541.4600	80985.00	0.00	80985.00	23	6	23	42	0.547619047619048	0.439604639179936	0.439604639179936	true	false	false	true
e59df356-9aeb-4832-bc85-f43b3be6cc21	2026-09-16 13:28	2026-09-16 13:28	2026-09-16 13:28	SPOT	SPOT270416P00420000	put	420.0000	2027-04-16	16.9000	15.3000	17.1500	553.1400	76050.00	76050.00	0.00	45	5	45	17	2.64705882352941	0.449650399847072	0.449650399847072	false	false	false	true
605b3606-8837-4a93-aac8-ed32ac128e66	2026-09-16 10:19	2026-09-16 10:19	2026-09-16 10:19	SPOT	SPOT270416C00630000	call	630.0000	2027-04-16	51.8300	51.1000	52.3500	559.0000	82935.00	72590.00	10345.00	16	6	16	6	2.66666666666667	0.429515452965292	0.428033576429764	true	false	false	true
813c7970-a7d9-479d-8623-02d3bfbea1ba	2026-09-16 09:30	2026-09-16 09:30	2026-09-16 09:30	SPOT	SPOT261218C00610000	call	610.0000	2026-12-18	29.0000	28.1500	29.0000	560.5050	52200.00	2900.00	0.00	18	6	18	308	0.0584415584415584	0.405641923963342	0.405641923963342	false	false	false	true
0ee7fd73-fd85-474c-b04c-0d129675c1fd	2026-09-15 13:23	2026-09-15 13:22	2026-09-15 13:22	SPOT	SPOT270319P00460000	put	460.0000	2027-03-19	23.6000	22.8000	23.6000	558.6200	73160.00	73160.00	0.00	31	6	31	105	0.295238095238095	0.448685751416374	0.448685751416374	false	false	false	true
b8861c3c-6eef-45e4-97df-3f973e6db502	2026-09-15 09:39	2026-09-15 09:39	2026-09-15 09:39	SPOT	SPOT261016C00610000	call	610.0000	2026-10-16	7.0500	7.0500	7.2500	554.0300	92368.00	0.00	91663.00	131	48	546	678	0.805309734513274	0.37648490200753	0.37648490200753	false	false	false	true
3b3ab3c5-7d19-414a-81b5-84a30284103d	2026-09-15 09:37	2026-09-15 09:36	2026-09-15 09:36	SPOT	SPOT261009C00490000	call	490.0000	2026-10-09	65.8000	62.9500	69.4500	550.4400	59220.00	6580.00	52640.00	9	9	9	1	9	0.430038153787263	0.430038153787263	false	false	false	true
5277438b-64ff-4a4b-b4b0-ba17cfeedf1f	2026-09-14 13:12	2026-09-14 13:12	2026-09-14 13:12	SPOT	SPOT261218P00580000	put	580.0000	2026-12-18	57.8000	57.8000	61.7000	557.6850	121380.00	0.00	121380.00	21	6	21	44	0.477272727272727	0.429414078338382	0.429414078338382	false	false	false	true
c903f840-1c07-44f9-88d8-6eaf6a6ca109	2026-09-14 11:49	2026-09-14 11:49	2026-09-14 11:49	SPOT	SPOT270115C00640000	call	640.0000	2027-01-15	25.6400	21.6500	25.6500	552.0800	58980.00	58980.00	0.00	23	9	38	264	0.143939393939394	0.414909724372964	0.41447969707927	false	false	false	true
6307b039-3bfc-4352-9b4d-6fbe271c31f6	2026-09-11 14:13	2026-09-11 14:13	2026-09-11 14:13	SPOT	SPOT270319C00520000	call	520.0000	2027-03-19	72.5500	70.9500	73.1500	523.5550	159610.00	152355.00	7255.00	22	13	22	60	0.366666666666667	0.439233210226655	0.439233210226655	false	false	false	true
9942eee7-15cf-4af1-9340-f78055a9b38e	2026-09-10 12:28	2026-09-10 12:28	2026-09-10 12:28	SPOT	SPOT261002P00530000	put	530.0000	2026-10-02	21.3000	20.4000	21.3000	526.9200	238560.00	238560.00	0.00	112	37	112	43	2.6046511627907	0.393856406712999	0.393856406712999	false	false	false	true
66f6656f-317f-4dc3-b738-6e4ac188705e	2026-09-10 10:36	2026-09-10 10:36	2026-09-10 10:36	SPOT	SPOT260925C00527500	call	527.5000	2026-09-25	16.7500	16.7500	18.3000	526.8700	97150.00	0.00	97150.00	58	18	58	0	0	0.390978032860803	0.390978032860803	false	false	false	true
7d0e9fcc-0b79-496d-afa9-503cb34e3c3a	2026-09-09 14:05	2026-09-09 14:04	2026-09-09 14:04	SPOT	SPOT270115C00520000	call	520.0000	2027-01-15	59.5000	57.5500	59.5000	526.6700	148750.00	148750.00	0.00	25	10	25	111	0.225225225225225	0.426701141382922	0.426701141382922	false	false	false	true
fbcbece2-36e0-41ef-890f-b4a37c8dc1bb	2026-09-09 13:55	2026-09-09 13:55	2026-09-09 13:55	SPOT	SPOT270319P00560000	put	560.0000	2027-03-19	79.2500	79.0500	81.0500	526.3100	182275.00	15850.00	166425.00	23	8	26	22	1.18181818181818	0.439745670447915	0.439745670447915	false	false	false	true
3c911e11-1e57-4842-b23f-d77e53ac40e2	2026-09-09 10:06	2026-09-09 10:06	2026-09-09 10:06	SPOT	SPOT261218C00760000	call	760.0000	2026-12-18	3.6500	3.6000	4.5000	531.9200	70812.00	0.00	70812.00	194	43	194	162	1.19753086419753	0.425764528347215	0.425764528347215	false	false	false	true
1d716088-ed7e-4083-8308-76b52c8c0305	2026-09-09 09:37	2026-09-09 09:37	2026-09-09 09:37	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	16.8500	16.0000	16.8500	525.8600	124690.00	37070.00	0.00	74	18	326	955	0.341361256544503	0.414336270897241	0.414336270897241	false	false	false	true
ddf9a191-ab28-4c29-9904-fd85cbfa1b36	2026-09-09 09:37	2026-09-09 09:37	2026-09-09 09:37	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	17.3000	15.4500	18.1500	527.0400	266420.00	31140.00	15570.00	154	17	210	955	0.219895287958115	0.41591584738146	0.41591584738146	false	false	false	true
53382c87-89f8-4283-a14c-b855ed73ba4a	2026-09-09 09:37	2026-09-09 09:37	2026-09-09 09:37	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	18.0000	15.3500	18.0000	527.0400	100800.00	57600.00	0.00	56	7	56	955	0.0586387434554974	0.422922654838936	0.422922654838936	false	false	false	true
7c416bb3-c2b6-455f-958f-747062fbc07c	2026-09-08 13:42	2026-09-08 13:42	2026-09-08 13:42	SPOT	SPOT261009C00485000	call	485.0000	2026-10-09	54.4000	52.7500	56.0000	530.2100	81600.00	76160.00	5440.00	15	6	15	11	1.36363636363636	0.40950253658889	0.40950253658889	false	false	false	true