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 = IP×sorted by created_at ↑×

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

227e2838-906f-4b03-a472-102ac7c57a18	2026-08-20 15:48	2026-08-20 15:48	2026-08-20 15:48	IP	IP260828P00040000	put	40.0000	2026-08-28	0.7500	0.7000	0.7500	40.2110	19723.00	19723.00	0.00	263	28	291	13	22.3846153846154	0.366030629679921	0.366030629679921	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	18137768904.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T19:59:19.634890Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c28090df-4b20-4186-b2e8-468bed5625a8	2026-08-25 11:34	2026-08-25 11:33	2026-08-25 11:33	IP	IP270416P00032500	put	32.5000	2027-04-16	1.8000	1.5000	2.1000	40.8150	90000.00	0.00	0.00	500	1	500	0	0	0.44760533856132	0.44760533856132	false	true	false	true	true
9cdf7ed2-c130-4384-aa9c-6f11dec0870c	2026-09-02 10:45	2026-09-02 10:45	2026-09-02 10:45	IP	IP270115P00032500	put	32.5000	2027-01-15	1.6000	1.5500	1.6000	37.2845	14880.00	14880.00	0.00	93	6	291	4174	0.0697172975563009	0.435296783315719	0.435296783315719	false	false	false	true
89d4839e-aa04-4eff-b2fe-f92896e707b6	2026-09-02 10:48	2026-09-02 10:48	2026-09-02 10:48	IP	IP270115P00032500	put	32.5000	2027-01-15	1.6000	1.5000	1.6000	37.2700	14880.00	14880.00	0.00	93	5	477	4174	0.114278869190225	0.435483927606085	0.434803076482739	false	false	false	true
acaf0019-a1f8-401a-ac27-5eca883eeef7	2026-09-02 15:20	2026-09-02 15:20	2026-09-02 15:20	IP	IP270115C00035000	call	35.0000	2027-01-15	4.0000	3.9000	4.7000	36.1600	11200.00	2000.00	9200.00	28	6	28	567	0.0493827160493827	0.361481203156144	0.361481203156144	false	false	false	true
5b692348-1fe3-4cbc-ab3e-85afc32b744c	2026-09-02 15:54	2026-09-02 15:54	2026-09-02 15:54	IP	IP270115C00037500	call	37.5000	2027-01-15	3.1000	2.9000	3.1000	36.3400	51150.00	51150.00	0.00	165	5	440	276	1.59420289855072	0.382833729225254	0.382833729225254	false	false	false	true
03d3acec-0c63-4780-839b-df0fda4b65fd	2026-09-09 11:48	2026-09-09 11:48	2026-09-09 11:48	IP	IP261218C00037500	call	37.5000	2026-12-18	2.1000	2.1000	2.4000	35.8700	10500.00	0.00	10500.00	50	7	50	137	0.364963503649635	0.350422222169127	0.350422222169127	false	false	false	true
5c135d9b-07b4-49f6-be86-c2541612f432	2026-09-11 13:33	2026-09-11 13:33	2026-09-11 13:33	IP	IP260918P00035000	put	35.0000	2026-09-18	0.9000	0.9000	0.9500	34.5100	12690.00	0.00	12690.00	141	23	143	1573	0.0909090909090909	0.334319129249451	0.334319129249451	false	false	false	true
342e1945-9e42-475f-84d9-7ddbdbab8776	2026-09-17 12:27	2026-09-17 12:27	2026-09-17 12:27	IP	IP261218C00037500	call	37.5000	2026-12-18	1.7500	1.6500	1.7500	34.8800	18550.00	18550.00	0.00	106	7	107	184	0.581521739130435	0.377660872856139	0.377660872856139	false	false	false	true
4c99bc54-f641-44e3-bb2c-0d780d28c48a	2026-09-17 14:23	2026-09-17 14:23	2026-09-17 14:23	IP	IP290119P00035000	put	35.0000	2029-01-19	7.0000	5.2000	8.8000	35.6100	407400.00	203000.00	204400.00	582	32	586	1	586	0.44842620394723	0.448820804966218	true	false	false	true
2ce0ad5f-8a3f-415e-a76f-a47450b1ef6c	2026-09-18 14:41	2026-09-18 14:41	2026-09-18 14:41	IP	IP261016C00032500	call	32.5000	2026-10-16	2.6500	2.6500	2.8000	34.5400	12720.00	0.00	12720.00	48	12	50	247	0.202429149797571	0.355186424644138	0.355186424644138	false	false	false	true
29ea8a74-7f93-44a4-9287-ef04e74fad57	2026-09-18 14:41	2026-09-18 14:41	2026-09-18 14:41	IP	IP261002C00033000	call	33.0000	2026-10-02	1.9200	1.9000	1.9500	34.5400	21685.00	8385.00	13300.00	113	8	113	1	113	0.336656864905478	0.336656864905478	false	false	false	true
ec3e303a-055e-4d90-b40c-9a86d4e0b5f8	2026-09-22 10:53	2026-09-22 10:53	2026-09-22 10:53	IP	IP270416C00035000	call	35.0000	2027-04-16	4.3000	4.3000	4.6000	35.5050	24080.00	0.00	24080.00	56	5	87	3	29	0.34324657983258	0.34324657983258	false	false	false	true	false