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:er_time = unknown×ticker = SNPS×

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

0412d346-ac33-4606-9572-e4b9fb565d1c	2026-09-10 12:58	2026-09-10 12:58	2026-09-10 12:58	SNPS	SNPS261120C00400000	call	400.0000	2026-11-20	33.8000	32.3000	33.8000	398.0000	223080.00	23660.00	0.00	66	6	761	51	14.921568627451	0.470718333839761	0.470718333839761	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	73095965884.00	2026-12-09	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-10T17:02:16.286608Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
6a81be9f-d063-4465-b1d2-e33dddf3d3e9	2026-09-10 12:57	2026-09-10 12:57	2026-09-10 12:57	SNPS	SNPS261120C00400000	call	400.0000	2026-11-20	32.9300	31.9000	33.1000	398.0000	128440.00	42660.00	79200.00	39	15	671	51	13.156862745098	0.458279616007889	0.463557091413936	false	false	false	true
c3e9d517-31db-468e-af8d-b1bebf1b04b1	2026-09-10 12:57	2026-09-10 12:57	2026-09-10 12:57	SNPS	SNPS261120C00400000	call	400.0000	2026-11-20	32.5700	30.7000	32.7000	397.0000	146560.00	101060.00	45500.00	45	12	594	51	11.6470588235294	0.460005053636535	0.458567538539288	false	false	false	true
44272d18-7de0-4fe4-a101-1e389685ec8e	2026-09-10 12:57	2026-09-10 12:57	2026-09-10 12:57	SNPS	SNPS261120C00400000	call	400.0000	2026-11-20	32.5900	30.7000	32.6000	397.0000	198827.00	198827.00	0.00	61	20	549	51	10.7647058823529	0.455536000829261	0.459848299947143	false	false	false	true
1de24c1c-893a-4a3f-84c1-7c39084c3c7d	2026-09-10 12:57	2026-09-10 12:57	2026-09-10 12:57	SNPS	SNPS261120C00400000	call	400.0000	2026-11-20	32.2500	30.7000	32.4000	397.0000	70950.00	70950.00	0.00	22	13	488	51	9.56862745098039	0.454963648080363	0.456401194204823	false	false	false	true
1c0702a1-deae-4da5-aa6b-e3b98b842a6f	2026-09-10 12:57	2026-09-10 12:57	2026-09-10 12:57	SNPS	SNPS261120C00400000	call	400.0000	2026-11-20	32.2000	30.9000	32.3000	397.0000	132020.00	32200.00	38640.00	41	5	466	51	9.13725490196078	0.454131547364836	0.454131547364836	false	false	false	true
d41ad9fa-8dca-4489-9a33-aeb0853f8736	2026-09-10 12:57	2026-09-10 12:57	2026-09-10 12:57	SNPS	SNPS261120C00400000	call	400.0000	2026-11-20	31.9000	30.9000	31.9000	397.0000	92510.00	92510.00	0.00	29	17	370	51	7.25490196078431	0.450178102545125	0.450178102545125	false	false	false	true
c66adc9b-c7d5-4f85-b69f-e10f56b3b21f	2026-09-10 12:57	2026-09-10 12:57	2026-09-10 12:57	SNPS	SNPS261120C00400000	call	400.0000	2026-11-20	32.2000	30.9000	32.2000	397.0000	177100.00	177100.00	0.00	55	15	425	51	8.33333333333333	0.454133113495488	0.454133113495488	false	false	false	true
072a08b6-5751-4a3c-a160-beb7fa84b00b	2026-09-10 12:57	2026-09-10 12:56	2026-09-10 12:56	SNPS	SNPS261120C00400000	call	400.0000	2026-11-20	31.4300	30.0000	31.9000	397.0000	578337.00	204747.00	160070.00	184	23	243	51	4.76470588235294	0.444736060997242	0.447612331464599	false	false	false	true
f6c6aa64-54f0-453c-8976-48c538f324d6	2026-09-10 12:57	2026-09-10 12:56	2026-09-10 12:56	SNPS	SNPS261120C00400000	call	400.0000	2026-11-20	30.7000	30.7000	31.1000	396.0000	122800.00	0.00	73680.00	40	8	53	51	1.03921568627451	0.440939485737009	0.440939485737009	false	false	false	true
8c6b983d-99bd-456c-9943-da1dba00104b	2026-09-09 15:27	2026-09-09 15:27	2026-09-09 15:27	SNPS	SNPS260918C00410000	call	410.0000	2026-09-18	5.3000	5.3000	5.8000	394.4000	55120.00	0.00	55120.00	104	25	107	413	0.2590799031477	0.449554075986208	0.449554075986208	false	false	false	true
1022ca44-bed8-4908-8627-a46064828cf2	2026-09-09 11:46	2026-09-09 11:46	2026-09-09 11:46	SNPS	SNPS260918P00390000	put	390.0000	2026-09-18	10.2000	10.2000	11.4000	392.1700	66300.00	0.00	66300.00	65	14	76	309	0.245954692556634	0.466593410604478	0.466593410604478	false	false	false	true
26f40962-8757-452f-95dc-5fc138aae5ac	2026-09-09 11:32	2026-09-09 11:32	2026-09-09 11:32	SNPS	SNPS270319C00500000	call	500.0000	2027-03-19	21.3000	19.2000	23.4000	391.2300	53250.00	44730.00	8520.00	25	8	27	137	0.197080291970803	0.456577820250645	0.456577820250645	false	false	false	true
87126ab4-1be9-45d0-9be9-ac40b8c06bdb	2026-09-08 12:44	2026-09-08 12:44	2026-09-08 12:44	SNPS	SNPS261218C00400000	call	400.0000	2026-12-18	42.0000	40.5000	42.0000	401.3600	365400.00	365400.00	0.00	87	22	89	214	0.41588785046729	0.468171770592355	0.468171770592355	false	false	false	true
16f0aa72-eb57-4ba5-bd5b-6e475687119a	2026-09-08 12:02	2026-09-08 12:02	2026-09-08 12:02	SNPS	SNPS261016C00410000	call	410.0000	2026-10-16	19.3000	18.5000	20.0000	398.6800	196850.00	194930.00	1920.00	102	31	104	175	0.594285714285714	0.459007456707474	0.459007456707474	false	false	false	true
a00ca12f-6611-46f0-b926-e251a2532c68	2026-09-04 13:42	2026-09-04 13:42	2026-09-04 13:42	SNPS	SNPS261016P00390000	put	390.0000	2026-10-16	19.8000	19.6000	20.8000	392.9150	162360.00	0.00	162360.00	82	21	163	191	0.853403141361257	0.417601569098046	0.417601569098046	false	false	false	true
510f06b0-6b3b-4661-9657-7bcf53a96d6a	2026-09-04 11:13	2026-09-04 11:13	2026-09-04 11:13	SNPS	SNPS261120P00340000	put	340.0000	2026-11-20	10.9000	10.6000	11.0000	385.0973	76300.00	2180.00	74120.00	70	5	81	9	9	0.435179911696007	0.435179911696007	false	false	false	true	false
0d181a51-efc1-4c22-a2ff-f9f347216a0f	2026-09-04 11:13	2026-09-04 11:13	2026-09-04 11:13	SNPS	SNPS261016P00360000	put	360.0000	2026-10-16	10.7900	10.7000	11.0000	385.0973	58290.00	19770.00	38520.00	54	13	79	99	0.797979797979798	0.433972410036433	0.433972410036433	false	false	false	true
0d7d8222-7925-4ef3-875b-d0197dff1642	2026-09-04 11:11	2026-09-04 11:11	2026-09-04 11:11	SNPS	SNPS261023P00350000	put	350.0000	2026-10-23	9.0700	7.8000	10.9000	383.3200	53540.00	24840.00	28700.00	59	5	2979	0	0	0.42028585469283	0.415710563248082	false	false	false	true	false
b0ec86fc-d4bb-47c9-8b6e-db7c01b65e0f	2026-09-04 10:19	2026-09-04 10:19	2026-09-04 10:19	SNPS	SNPS261120P00380000	put	380.0000	2026-11-20	19.9500	19.2000	20.6000	394.8250	67830.00	53900.00	13930.00	34	8	40	217	0.184331797235023	0.397470739889132	0.396003138284981	false	false	false	true
2399e2a5-d84c-4a90-8b1e-75f8b81511e5	2026-09-04 10:03	2026-09-04 10:03	2026-09-04 10:03	SNPS	SNPS261016P00400000	put	400.0000	2026-10-16	18.6000	16.7000	18.6000	405.0000	87420.00	87420.00	0.00	47	14	53	258	0.205426356589147	0.401984999904574	0.401984999904574	false	false	false	true
102c2624-8cd9-4ba5-aac2-7aca916bd34f	2026-09-02 13:14	2026-09-02 13:14	2026-09-02 13:14	SNPS	SNPS261002C00370000	call	370.0000	2026-10-02	47.2000	45.3000	50.6000	411.6200	245450.00	51920.00	155770.00	52	12	202	0	0	0.413256781613348	0.413256781613348	false	false	false	true
65c71124-54e1-48d4-9a6d-d28f2eb1230a	2026-09-01 10:43	2026-09-01 10:43	2026-09-01 10:43	SNPS	SNPS261120P00420000	put	420.0000	2026-11-20	27.0500	26.6000	28.6000	421.6200	64920.00	0.00	64920.00	24	8	29	45	0.644444444444444	0.377815091064021	0.379101082888992	false	false	false	true
18fdbe46-ab31-4d55-8f06-488e4e0944c5	2026-08-28 13:01	2026-08-28 13:01	2026-08-28 13:01	SNPS	SNPS261016C00480000	call	480.0000	2026-10-16	11.5000	10.8000	11.5000	441.7600	57499.00	57499.00	0.00	50	9	56	1718	0.0325960419091967	0.380015076732745	0.380015076732745	false	false	false	true
6e328ab9-c5fd-4677-b823-28e75d878fe3	2026-08-28 12:53	2026-08-28 12:53	2026-08-28 12:53	SNPS	SNPS260911P00440000	put	440.0000	2026-09-11	9.5000	8.3000	9.5000	444.2700	71250.00	71250.00	0.00	75	16	90	3	30	0.341721745040809	0.341721745040809	false	false	false	true	false
be8fc888-b8e9-4d55-9560-e266ff3f8d35	2026-08-28 11:17	2026-08-28 11:17	2026-08-28 11:17	SNPS	SNPS260918C00460000	call	460.0000	2026-09-18	10.5000	9.3000	10.5000	447.9600	148050.00	148050.00	0.00	141	36	165	288	0.572916666666667	0.358880678203126	0.354813172006982	false	false	false	true
320ff6ba-9413-4394-a1e9-eaf86abc582c	2026-08-27 14:38	2026-08-27 14:38	2026-08-27 14:38	SNPS	SNPS260918C00410000	call	410.0000	2026-09-18	53.5000	53.5000	54.7000	459.3617	112350.00	0.00	112350.00	21	10	49	421	0.116389548693587	0.432318813760563	0.432318813760563	false	false	false	true
da26d194-ffe6-4c9c-90d4-c65d4d86d1c7	2026-08-27 13:20	2026-08-27 13:20	2026-08-27 13:20	SNPS	SNPS260828C00410000	call	410.0000	2026-08-28	45.1000	41.4000	45.1000	454.9700	54120.00	54120.00	0.00	12	5	152	1492	0.101876675603217	0.888256869925721	0.888256869925721	false	false	false	true
3ae65b89-5410-4b42-b66c-07e5e5a6ad06	2026-08-27 10:11	2026-08-27 10:11	2026-08-27 10:11	SNPS	SNPS261016P00430000	put	430.0000	2026-10-16	18.7000	18.7000	19.7000	449.0700	162693.00	0.00	162693.00	87	33	89	51	1.74509803921569	0.434240508311526	0.434240508311526	false	false	false	true
f7eea49b-e5cc-4d76-bd13-b0bd0f40c072	2026-08-27 09:55	2026-08-27 09:55	2026-08-27 09:55	SNPS	SNPS270115C00410000	call	410.0000	2027-01-15	68.1000	65.0000	68.1000	441.0150	68100.00	68100.00	0.00	10	5	11	151	0.0728476821192053	0.455186520991853	0.455186520991853	false	false	false	true
389ff485-e5f0-4d5c-90d6-688880601551	2026-08-27 09:45	2026-08-27 09:45	2026-08-27 09:45	SNPS	SNPS260918C00400000	call	400.0000	2026-09-18	41.8000	41.8000	43.6000	434.1000	71060.00	0.00	54340.00	17	5	47	669	0.070254110612855	0.478230657617525	0.478230657617525	true	false	false	true
ab621ca6-70d1-4584-9934-3723d50f9f1e	2026-08-27 09:36	2026-08-27 09:36	2026-08-27 09:36	SNPS	SNPS260904C00412500	call	412.5000	2026-09-04	20.0000	16.2000	22.6000	424.2550	200000.00	40000.00	76000.00	100	17	101	709	0.142454160789845	0.524283843013617	0.529302196585455	false	false	false	true
bc330783-78eb-4b1d-b128-d3170b54a041	2026-08-26 14:33	2026-08-26 14:32	2026-08-26 14:32	SNPS	SNPS260918P00400000	put	400.0000	2026-09-18	18.1000	17.6000	18.1000	412.9100	52490.00	52490.00	0.00	29	5	157	7388	0.0212506767731456	0.600976208037335	0.600976208037335	false	false	false	true
6b3c2b74-b850-4f24-90dd-250964b26f42	2026-08-26 13:03	2026-08-26 13:03	2026-08-26 13:03	SNPS	SNPS260904C00405000	call	405.0000	2026-09-04	21.3000	20.0000	21.3000	407.7850	138450.00	138450.00	0.00	65	17	104	13	8	0.773783647444295	0.773783647444295	false	false	false	true	false
9c8b0641-54b9-4f94-99c8-5b6f65786af5	2026-08-26 11:03	2026-08-26 11:03	2026-08-26 11:03	SNPS	SNPS260904C00405000	call	405.0000	2026-09-04	21.2100	20.3000	21.3000	408.1600	72130.00	72130.00	0.00	34	5	38	13	2.92307692307692	0.761683326987939	0.761683326987939	false	false	false	true
970a97c9-0116-4809-aa01-f08cbc03bcae	2026-08-26 10:30	2026-08-26 10:30	2026-08-26 10:30	SNPS	SNPS260828C00405000	call	405.0000	2026-08-28	18.1000	16.1000	18.9000	408.0200	117650.00	34390.00	83260.00	65	5	80	73	1.0958904109589	1.37533434327398	1.37533434327398	false	false	false	true
0d6db6ec-4491-4ed0-a845-78bae84a4ed2	2026-08-26 09:51	2026-08-26 09:51	2026-08-26 09:51	SNPS	SNPS260828C00420000	call	420.0000	2026-08-28	15.1200	14.7000	17.4000	417.5000	75600.00	0.00	75600.00	50	7	103	261	0.39463601532567	1.28455041396118	1.34132947652093	false	false	false	true
f642ec4a-6841-4933-b5b5-3fee4a307374	2026-08-25 10:38	2026-08-25 10:38	2026-08-25 10:38	SNPS	SNPS270115C00500000	call	500.0000	2027-01-15	20.1000	17.3000	20.1000	401.4800	68340.00	68340.00	0.00	34	9	34	305	0.111475409836066	0.485090072554552	0.485090072554552	false	false	false	true
4faa8175-c198-43ce-bb1e-f097aa674a15	2026-08-24 11:58	2026-08-24 11:58	2026-08-24 11:58	SNPS	SNPS261218C00560000	call	560.0000	2026-12-18	7.3500	5.4000	8.1000	390.5400	73548.00	43740.00	29808.00	100	11	100	113	0.884955752212389	0.526000473877208	0.493380636733585	false	false	false	true
fbf53347-6353-4861-8360-837eb53a6a9b	2026-08-24 11:55	2026-08-24 11:55	2026-08-24 11:55	SNPS	SNPS260918P00370000	put	370.0000	2026-09-18	12.4000	12.0000	12.4000	391.3950	96720.00	96720.00	0.00	78	28	81	327	0.247706422018349	0.549202962380059	0.549202962380059	false	false	false	true
5d96cbcf-24cc-4040-82b7-e3987800f099	2026-08-24 10:39	2026-08-24 10:39	2026-08-24 10:39	SNPS	SNPS260904P00365000	put	365.0000	2026-09-04	7.6000	6.5000	7.6000	390.7800	69920.00	69920.00	0.00	92	28	92	7	13.1428571428571	0.677342559797801	0.677342559797801	false	false	false	true
282ce5a2-c7bb-47a7-8e08-77f29b32a5d0	2026-08-20 14:01	2026-08-20 14:01	2026-08-20 14:01	SNPS	SNPS261016P00380000	put	380.0000	2026-10-16	21.1000	21.1000	21.8000	395.2100	50640.00	0.00	50640.00	24	8	35	65	0.538461538461538	0.476733337946669	0.476733337946669	false	false	false	true
12cd9284-9ebe-4f81-b23e-61af1325b8c7	2026-08-20 12:14	2026-08-20 12:14	2026-08-20 12:14	SNPS	SNPS261016P00390000	put	390.0000	2026-10-16	25.1000	25.1000	26.0000	397.5850	60240.00	0.00	60240.00	24	12	28	80	0.35	0.481979076575917	0.481979076575917	false	false	false	true	false
29a8445c-2da9-479f-99b6-075a9d9e78e8	2026-08-18 15:21	2026-08-18 15:21	2026-08-18 15:21	SNPS	SNPS261120C00430000	call	430.0000	2026-11-20	31.3000	31.3000	32.5000	407.3100	128330.00	0.00	128330.00	41	15	41	0	0	0.473519182348369	0.473519182348369	false	false	false	true	false
fac26570-9588-410c-af06-6c53f053e503	2026-08-17 14:08	2026-08-17 14:08	2026-08-17 14:08	SNPS	SNPS260918C00470000	call	470.0000	2026-09-18	8.2000	8.2000	8.8000	413.0000	68880.00	0.00	68880.00	84	14	89	435	0.204597701149425	0.524495946898232	0.524495946898232	false	false	false	true
3bd8fa9d-d165-445d-9321-741ceef0793c	2026-08-17 11:36	2026-08-17 11:36	2026-08-17 11:36	SNPS	SNPS260821C00427500	call	427.5000	2026-08-21	4.8000	4.8000	5.5000	418.6850	51360.00	0.00	51360.00	107	14	108	516	0.209302325581395	0.476892346523548	0.476892346523548	false	false	false	true
8ce3816a-71c6-442b-94b2-f19ea3472e10	2026-08-17 10:26	2026-08-17 10:26	2026-08-17 10:26	SNPS	SNPS261016C00430000	call	430.0000	2026-10-16	29.9900	27.5000	30.0000	419.3600	53980.00	53980.00	0.00	18	9	75	80	0.9375	0.493408621247599	0.494882910051387	false	false	false	true	false
f6a32711-58ac-4635-a2b7-7ca11180fa6c	2026-08-17 10:05	2026-08-17 10:05	2026-08-17 10:05	SNPS	SNPS261016C00430000	call	430.0000	2026-10-16	29.0000	28.9000	31.3000	418.9300	159510.00	2910.00	156600.00	55	18	57	80	0.7125	0.483308484229965	0.483308484229965	false	false	false	true