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:ticker = XP×

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

53937624-1538-4bb6-b399-e8d5632f98f9	2026-08-26 12:11	2026-08-26 12:11	2026-08-26 12:11	XP	XP261016P00019000	put	19.0000	2026-10-16	1.9000	1.8000	1.9500	17.8450	14250.00	9500.00	4560.00	75	14	75	1	75	0.477314649947221	0.477314649947221	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	8139142289.00	2026-11-16	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
3187997d-5ca8-491a-b67b-d60eda2a2ab9	2026-08-26 11:54	2026-08-26 11:54	2026-08-26 11:54	XP	XP270219P00020000	put	20.0000	2027-02-19	3.6000	2.1500	4.0000	17.8100	13320.00	5400.00	7920.00	37	9	37	6	6.16666666666667	0.502006784803717	0.502006784803717	false	false	false	true	false
54715aa7-9b6b-4d53-95e0-c2017ee7135d	2026-08-25 14:52	2026-08-25 14:52	2026-08-25 14:52	XP	XP260918C00017000	call	17.0000	2026-09-18	1.0000	1.0000	1.0500	17.5600	15400.00	0.00	15400.00	154	25	555	5861	0.0946937382699198	0.371321787424605	0.371321787424605	false	false	false	true	false
6aefce70-c105-451e-8870-9127f0c24c41	2026-08-25 14:52	2026-08-25 14:52	2026-08-25 14:52	XP	XP260918C00017000	call	17.0000	2026-09-18	1.0000	0.9500	1.0500	17.5700	39905.00	12800.00	27105.00	399	31	401	5861	0.06841835864187	0.367297505974261	0.367297505974261	false	false	false	true	false
c23b22ed-646a-42bd-805e-5643636a0899	2026-08-25 11:57	2026-08-25 11:57	2026-08-25 11:57	XP	XP280121P00020000	put	20.0000	2028-01-21	5.2000	4.5000	5.4500	17.4150	244400.00	244400.00	0.00	470	10	470	94	5	0.527365139796906	0.527365139796906	false	false	false	true	false
4232469b-26a7-4f5a-8f9c-df7abcd07755	2026-08-25 11:57	2026-08-25 11:57	2026-08-25 11:57	XP	XP280121P00020000	put	20.0000	2028-01-21	5.2000	4.5000	5.2000	17.4150	11960.00	11960.00	0.00	23	5	493	94	5.24468085106383	0.527365139796906	0.527365139796906	false	false	false	true	false
eb7b7884-cbb9-4a6a-a0ed-7425777b0612	2026-08-25 11:24	2026-08-25 11:24	2026-08-25 11:24	XP	XP261120P00018000	put	18.0000	2026-11-20	2.1000	2.0000	2.1500	17.1600	15120.00	10500.00	4620.00	72	12	72	997	0.0722166499498496	0.512516907344605	0.512516907344605	false	false	false	true	false
da7e5abd-b822-4306-ad8e-26bc4a801218	2026-08-25 11:06	2026-08-25 11:06	2026-08-25 11:06	XP	XP261016P00017000	put	17.0000	2026-10-16	1.1000	0.9000	1.1500	17.1550	20240.00	110.00	20130.00	184	6	184	16	11.5	0.476128327004566	0.476128327004566	false	false	false	true	false
23b80764-d9ba-4535-8d17-67cf7201119a	2026-08-24 14:39	2026-08-24 14:39	2026-08-24 14:39	XP	XP261120P00017000	put	17.0000	2026-11-20	1.5500	1.5500	1.6000	17.1350	10385.00	0.00	10385.00	67	16	420	70	6	0.509967208578467	0.509967208578467	false	false	false	true	false
3a6a5231-ee46-4947-abc4-02b97f251e82	2026-08-24 13:31	2026-08-24 13:31	2026-08-24 13:31	XP	XP270219P00017000	put	17.0000	2027-02-19	2.1600	2.0000	2.2500	17.2150	12942.00	1505.00	11437.00	60	9	126	51	2.47058823529412	0.512062587231352	0.512062587231352	false	false	false	true	false
098dddfb-17eb-45d5-9f47-38063e0bc277	2026-08-24 13:20	2026-08-24 13:19	2026-08-24 13:19	XP	XP270219P00019000	put	19.0000	2027-02-19	3.3000	3.3000	3.4000	17.2500	18814.00	0.00	18814.00	57	9	71	48	1.47916666666667	0.51117502050605	0.51117502050605	false	false	false	true	false
ad839ae9-1d3f-4958-9058-374f0ece66a8	2026-08-24 10:42	2026-08-24 10:42	2026-08-24 10:42	XP	XP260918C00018000	call	18.0000	2026-09-18	0.4500	0.3500	0.4500	17.3600	22005.00	22005.00	0.00	489	9	657	4537	0.144809345382411	0.383917358237475	0.383917358237475	true	false	false	true	false
ed786100-c018-4dad-ae95-1108bfe7f4eb	2026-08-21 10:55	2026-08-21 10:55	2026-08-21 10:55	XP	XP260918P00019000	put	19.0000	2026-09-18	2.4000	2.3000	3.7000	16.7450	98640.00	64800.00	33840.00	411	5	411	23	17.8695652173913	0.459981077958249	0.459981077958249	false	false	false	true	false
c263a5e7-1f66-4c98-8c69-12df627ffd3c	2026-08-19 14:02	2026-08-19 14:01	2026-08-19 14:01	XP	XP260918P00017000	put	17.0000	2026-09-18	1.1500	1.0000	1.3500	16.2650	43470.00	28635.00	14835.00	378	5	407	146	2.78767123287671	0.400785163161018	0.400785163161018	false	false	false	true	false
ff842dfe-b289-4528-b7f1-03b9d473d353	2026-08-18 12:50	2026-08-18 12:50	2026-08-18 12:50	XP	XP260918C00017000	call	17.0000	2026-09-18	0.3000	0.3000	0.3500	15.9150	249810.00	0.00	249810.00	8327	2	8427	2113	3.98816848083294	0.36532742891933	0.36532742891933	false	true	true	false	true
f3f6cf91-9e8c-41b8-926b-39bdf539a80e	2026-08-18 09:50	2026-08-18 09:50	2026-08-18 09:50	XP	XP261002C00014500	call	14.5000	2026-10-02	2.0000	1.9000	2.0000	16.1550	10200.00	10200.00	0.00	51	14	101	65	1.55384615384615	0.413349628047215	0.413349628047215	false	false	false	true	false
cbdb159e-6a0e-4496-ae6a-31b3d201160f	2026-08-17 14:44	2026-08-17 14:44	2026-08-17 14:44	XP	XP270115C00015000	call	15.0000	2027-01-15	2.3000	2.1500	2.4000	15.6200	26220.00	25990.00	230.00	114	10	116	293	0.395904436860068	0.473102968495138	0.473102968495138	false	false	false	true	false
2d8b7a09-1ccb-49d9-b022-8d0744161acc	2026-08-17 14:00	2026-08-17 13:59	2026-08-17 13:59	XP	XP260821P00015000	put	15.0000	2026-08-21	0.2900	0.2500	0.3000	15.0000	29000.00	29000.00	0.00	1000	21	1147	586	1.95733788395904	0.801585174511501	0.801585174511501	false	false	false	true	false
1a79fa6d-6ba0-419f-8524-d13e21dcca16	2026-08-17 11:57	2026-08-17 11:57	2026-08-17 11:57	XP	XP260821C00015500	call	15.5000	2026-08-21	0.5200	0.5000	0.6000	15.6350	10088.00	0.00	10088.00	194	5	202	113	1.78761061946903	0.685852593007583	0.685852593007583	false	false	false	true	false