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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = SHOP261016C00150000×ticker = SHOP×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	expiry

4d1847bb-31fc-46ac-b8d1-7a3420900617	2026-09-08 15:58	2026-09-08 15:58	2026-09-08 15:58	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	3.1500	3.1000	3.1500	134.2400	59535.00	59535.00	0.00	189	12	1850	1272	1.45440251572327	0.477974781591357	0.477974781591357	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	161815483760.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T13:30:57.501605Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
87e12625-3260-4cb6-ae85-e87511a7f067	2026-09-09 13:20	2026-09-09 13:20	2026-09-09 13:20	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.1500	2.1500	2.2500	129.6000	66220.00	0.00	66220.00	308	19	1005	1864	0.539163090128755	0.491693962687323	0.491693962687323	false	false	false	true
b05bec13-312b-4c0a-bfe6-05391ceb8a0b	2026-09-21 10:11	2026-09-21 10:11	2026-09-21 10:11	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	1.1000	1.0000	1.1000	129.0000	34100.00	34100.00	0.00	310	26	459	2633	0.174325864033422	0.489421941231613	0.489421941231613	false	false	false	true
0a51eb7b-43fb-4597-8d64-b9626bf6665e	2026-09-21 13:41	2026-09-21 13:41	2026-09-21 13:41	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	1.5300	1.1800	1.5600	131.9560	26593.00	13406.00	13187.00	174	7	1090	2633	0.413976452715534	0.488636501671275	0.485309985782162	false	false	false	true
aa481166-e413-41cd-bffb-eabe95f39648	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.3900	2.3900	2.4900	134.0000	47083.00	0.00	47083.00	197	6	1561	2633	0.592859855677934	0.529239598147232	0.529457586863507	false	false	false	true
dc2742ac-2c64-4246-88d5-39e5186b7d77	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.4500	2.2200	2.5000	134.0000	100940.00	85750.00	15190.00	412	15	2675	2633	1.01595138625142	0.535114409069971	0.53347075733205	false	false	false	true
5a51ecb1-7837-4079-bc05-1e2306b48812	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.4300	2.2200	2.5000	134.0000	118578.00	39524.00	79054.00	488	7	2207	2633	0.838207368021268	0.532722187557547	0.534128267280053	false	false	false	true
2d381593-cf83-46ac-8cc2-15022030320b	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.4100	2.4000	2.4900	134.0000	37876.00	0.00	37876.00	157	5	1718	2633	0.652487656665401	0.531039112639659	0.531798529544902	false	false	false	true
4c56657d-5c5c-4d1c-8017-7728e76c17be	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.5000	2.1800	3.0000	134.0000	85500.00	0.00	85500.00	342	5	3169	2633	1.20357007216103	0.537840113366564	0.537840113366564	false	false	false	true
a74fd9fe-ddf6-4a52-8e08-90a611105dac	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.6300	2.1800	3.0000	134.0000	249624.00	110784.00	138840.00	950	22	4383	2633	1.66464109380934	0.548996129480697	0.548996129480697	true	false	false	true
179a2fb3-df86-4691-a6f7-6021b7ed19f2	2026-09-21 13:47	2026-09-21 13:47	2026-09-21 13:47	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.6300	2.6300	2.8000	134.4900	19995.00	1057.00	18938.00	76	18	6827	2633	2.59285985567793	0.541648221295933	0.542545140586248	false	false	false	true
2b1a922a-9921-4914-a0f0-8db079d33927	2026-09-21 14:09	2026-09-21 14:09	2026-09-21 14:09	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.4500	2.4500	2.5500	133.0000	11515.00	0.00	11515.00	47	9	8025	2633	3.04785415875427	0.535333531771889	0.536319495079213	true	false	false	true
3233dc01-d136-4835-827a-6aa12c277e8e	2026-09-21 14:12	2026-09-21 14:11	2026-09-21 14:11	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	3.0000	2.8500	3.0000	135.6300	77679.00	72900.00	4779.00	259	24	8787	2633	3.3372578807444	0.549394651578316	0.547288328690499	false	false	false	true
c6c59430-a95f-4ed8-be34-fc3162e7ee9c	2026-09-21 15:41	2026-09-21 15:41	2026-09-21 15:41	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	3.1500	3.1000	3.2500	137.1000	437850.00	243180.00	194670.00	1390	9	15048	2633	5.71515381693885	0.524276934130202	0.52650588187823	false	false	false	true
c93b07e7-3857-4d1e-9596-4b9b9b8c466f	2026-09-22 09:33	2026-09-22 09:33	2026-09-22 09:33	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	8.2400	7.8500	8.4000	148.5000	54410.00	27225.00	27185.00	66	17	353	8713	0.0405141742224263	0.577245058352214	0.577245058352214	false	false	false	true
8a21862e-ba13-4c33-9b94-5bc6ee2e2b13	2026-09-22 15:58	2026-09-22 15:58	2026-09-22 15:58	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	7.4500	6.8500	7.4500	147.7850	21605.00	21605.00	0.00	29	8	3208	8713	0.368185469987375	0.548112990614849	0.548112990614849	false	false	false	true
f3e1f069-1c35-4622-a5cf-ae5a76685c64	2026-09-23 15:39	2026-09-23 15:39	2026-09-23 15:39	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	5.1000	5.1000	5.2000	143.2000	13260.00	0.00	3060.00	26	11	5103	7429	0.686902678691614	0.539316492600773	0.539316492600773	false	false	false	true
543f6b3e-1a4b-4615-9765-0226fe7d1a40	2026-09-23 15:40	2026-09-23 15:40	2026-09-23 15:40	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	5.1000	5.1000	5.2000	143.2250	10200.00	0.00	2040.00	20	10	5128	7429	0.690267869161394	0.538597923007251	0.538597923007251	false	false	false	true
b9ba4684-5d19-4729-a582-e40f812ad85a	2026-09-23 15:40	2026-09-23 15:40	2026-09-23 15:40	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	5.1000	5.0000	5.2000	143.2100	24990.00	3060.00	1020.00	49	19	5185	7429	0.697940503432494	0.53902909685945	0.53902909685945	false	false	false	true
474cae8a-8662-4ded-b5a3-ec9e44713318	2026-09-23 15:40	2026-09-23 15:40	2026-09-23 15:40	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	5.1000	5.1000	5.1500	143.1800	11220.00	0.00	1020.00	22	11	5217	7429	0.702247947233813	0.539891156046853	0.539891156046853	false	false	false	true
c5b56d5b-4089-46d1-9ff0-c018f8b5bd35	2026-09-23 15:41	2026-09-23 15:41	2026-09-23 15:41	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	5.0700	4.9000	5.1000	142.9300	20805.00	12220.00	0.00	41	24	5262	7429	0.708305290079418	0.547060284701818	0.543441297688707	false	false	false	true
4a30c5e4-3009-4c38-b7c2-21b7aa9d69d2	2026-09-24 12:32	2026-09-24 12:32	2026-09-24 12:32	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	5.1000	5.1000	5.6500	143.5150	10710.00	0.00	10710.00	21	9	403	9471	0.0425509449899694	0.540909179386807	0.542533207173818	false	false	false	true
97b9c086-a4b6-409d-8634-9829dcb9a30a	2026-09-24 15:37	2026-09-24 15:37	2026-09-24 15:37	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	5.7500	5.5500	5.9500	145.0000	11500.00	7475.00	4025.00	20	5	873	9471	0.0921761165663605	0.543907828848334	0.543907828848334	false	false	false	true