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:endpoint = /api/option-trades/flow-alerts×ticker = TEAM×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

ff38a9f5-4498-4db8-9084-9427a822fd8f	2026-08-17 09:42	2026-08-17 09:42	2026-08-17 09:42	TEAM	TEAM260828P00157500	put	157.5000	2026-08-28	6.0000	4.7000	6.0000	158.8400	30000.00	30000.00	0.00	50	5	50	54	0.925925925925926	0.615256574908067	0.615256574908067	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	30651432018.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
d97c10ed-8838-4239-bc8d-a950c9b399ea	2026-08-17 09:47	2026-08-17 09:47	2026-08-17 09:47	TEAM	TEAM260828P00140000	put	140.0000	2026-08-28	1.2500	1.0000	1.2500	156.8300	12250.00	12250.00	0.00	98	28	98	60	1.63333333333333	0.633648908804051	0.633648908804051	false	false	false
49bd4191-d467-4899-8cf7-e7211653263b	2026-08-17 09:51	2026-08-17 09:51	2026-08-17 09:51	TEAM	TEAM260918P00130000	put	130.0000	2026-09-18	1.6000	1.5500	2.0000	157.7600	24000.00	10720.00	8640.00	150	6	150	5146	0.0291488534784298	0.587722629517603	0.587722629517603	false	false	false
d7671898-90c6-4acd-acea-d0e53ee97238	2026-08-17 10:55	2026-08-17 10:55	2026-08-17 10:55	TEAM	TEAM260911P00145000	put	145.0000	2026-09-11	4.2000	3.8000	4.2000	157.0550	66360.00	66360.00	0.00	158	13	159	16	9.9375	0.578450393440373	0.578450393440373	false	false	false
6e74fd32-0566-430b-85be-26574f78716f	2026-08-17 12:18	2026-08-17 12:18	2026-08-17 12:18	TEAM	TEAM260911C00152500	call	152.5000	2026-09-11	12.4000	11.9000	12.4000	157.8500	45880.00	45880.00	0.00	37	20	37	6	6.16666666666667	0.571929522493101	0.571929522493101	false	false	false
a18c0e40-a739-4591-a21a-a7e26e952795	2026-08-17 15:01	2026-08-17 15:01	2026-08-17 15:01	TEAM	TEAM261120C00160000	call	160.0000	2026-11-20	21.3000	21.3000	21.9000	157.6300	172530.00	0.00	172530.00	81	27	81	4	20.25	0.677462062415398	0.677462062415398	false	false	false
79150e2d-0133-451d-b1c7-4ed5a330f7d2	2026-08-18 10:23	2026-08-18 10:23	2026-08-18 10:23	TEAM	TEAM260918P00160000	put	160.0000	2026-09-18	9.8000	9.8000	10.1000	161.6200	12740.00	0.00	12740.00	13	5	25	1064	0.0234962406015038	0.581192349074846	0.581192349074846	false	false	false
4f552e9a-5cd0-4a77-9047-934b4c6ad639	2026-08-18 12:46	2026-08-18 12:46	2026-08-18 12:46	TEAM	TEAM270115P00160000	put	160.0000	2027-01-15	22.4000	22.1000	22.4000	167.4100	22400.00	22400.00	0.00	10	8	35	245	0.142857142857143	0.657482818478908	0.657482818478908	false	false	false
af5786de-9719-48a0-bff1-9f980176aa6b	2026-08-18 14:00	2026-08-18 14:00	2026-08-18 14:00	TEAM	TEAM260918P00145000	put	145.0000	2026-09-18	3.0000	3.0000	3.3000	166.7504	15000.00	0.00	15000.00	50	17	71	317	0.22397476340694	0.587914401591597	0.587914401591597	false	false	false
db4a86d1-a6f1-4eb5-b0d1-1e2dea34b0c9	2026-08-18 14:04	2026-08-18 14:04	2026-08-18 14:04	TEAM	TEAM260918P00145000	put	145.0000	2026-09-18	3.0000	3.0000	3.3000	166.6200	15000.00	0.00	15000.00	50	20	121	317	0.381703470031546	0.586076818344508	0.586076818344508	false	false	false
1aed913e-8ad0-4b4b-b9b5-63e1dd39928a	2026-08-18 14:18	2026-08-18 14:18	2026-08-18 14:18	TEAM	TEAM270115P00150000	put	150.0000	2027-01-15	18.1900	17.0000	18.2000	166.5000	36370.00	36370.00	0.00	20	6	44	664	0.0662650602409639	0.668027203639687	0.668027203639687	false	false	false
db86e4c1-a585-4d95-85c2-b5327b39488b	2026-08-19 12:44	2026-08-19 12:44	2026-08-19 12:44	TEAM	TEAM260821C00175000	call	175.0000	2026-08-21	3.0100	2.8000	3.3000	173.8150	30074.00	7800.00	22274.00	100	7	926	1667	0.555488902219556	0.688400246792004	0.688400246792004	false	false	false
85aba3d9-f088-43c0-a5e2-57cd39016c7c	2026-08-19 13:00	2026-08-19 12:59	2026-08-19 12:59	TEAM	TEAM260918C00175000	call	175.0000	2026-09-18	11.0900	10.7000	11.1000	173.1700	347272.00	332972.00	14300.00	313	17	335	1012	0.33102766798419	0.591660252459585	0.585824590927453	false	false	false
43f37d50-bf92-4e02-84e9-80385ee3610f	2026-08-19 13:01	2026-08-19 13:01	2026-08-19 13:01	TEAM	TEAM260918P00140000	put	140.0000	2026-09-18	1.3500	1.3000	1.5500	172.6900	40529.00	0.00	40529.00	300	9	368	448	0.821428571428571	0.596149653124165	0.596149653124165	false	false	false
2fefe9ec-10a0-4ea4-8c98-4bba8bb996af	2026-08-19 13:02	2026-08-19 13:02	2026-08-19 13:02	TEAM	TEAM260918P00175000	put	175.0000	2026-09-18	12.5000	11.9000	12.5000	172.5950	250000.00	250000.00	0.00	200	6	215	7	30.7142857142857	0.582390965984697	0.582390965984697	false	false	false
d0659054-6312-4301-a5bf-2b5b6f47cf8b	2026-08-19 13:02	2026-08-19 13:02	2026-08-19 13:02	TEAM	TEAM260918C00175000	call	175.0000	2026-09-18	10.8000	10.8000	11.1000	172.6950	81000.00	0.00	81000.00	75	7	411	1012	0.406126482213439	0.588027953648906	0.588027953648906	false	false	false
e5929d06-43a4-45e6-b72d-3e96a57f4cac	2026-08-19 13:43	2026-08-19 13:43	2026-08-19 13:43	TEAM	TEAM270917C00185000	call	185.0000	2027-09-17	45.7000	41.0000	45.7000	172.7500	297050.00	219360.00	0.00	65	10	65	0	0	0.671945780603678	0.671945780603678	false	false	false
7d0774c6-a822-4527-a260-062f34b91d1e	2026-08-19 13:43	2026-08-19 13:43	2026-08-19 13:43	TEAM	TEAM270917P00185000	put	185.0000	2027-09-17	50.9000	48.8000	50.9000	172.7600	305400.00	218870.00	0.00	60	12	60	0	0	0.688573003276207	0.688627851305806	false	false	false
77c58e71-0f4a-41eb-ab1e-caa56a77e64e	2026-08-19 13:43	2026-08-19 13:43	2026-08-19 13:43	TEAM	TEAM270917P00180000	put	180.0000	2027-09-17	47.8000	44.0000	51.0000	172.7500	339380.00	253340.00	86040.00	71	8	71	0	0	0.688291751415944	0.688291751415944	false	false	false
45012bf8-896e-4598-ae58-c8a7614b8759	2026-08-19 13:43	2026-08-19 13:43	2026-08-19 13:43	TEAM	TEAM270917P00185000	put	185.0000	2027-09-17	50.9000	48.8000	50.9000	172.7150	66170.00	66170.00	0.00	13	7	73	0	0	0.688380976741942	0.688380976741942	false	false	false
1a1e5386-bbee-477f-9d75-be59844dd3d9	2026-08-19 13:43	2026-08-19 13:43	2026-08-19 13:43	TEAM	TEAM270917C00220000	call	220.0000	2027-09-17	35.4000	31.7000	38.8000	172.7000	184080.00	184080.00	0.00	52	6	70	0	0	0.671166129514042	0.671166129514042	false	false	false
03148de4-f008-4d71-8efa-0034e8f72057	2026-08-19 13:43	2026-08-19 13:43	2026-08-19 13:43	TEAM	TEAM270917P00190000	put	190.0000	2027-09-17	54.0000	52.4000	54.7000	172.7500	356400.00	64800.00	291600.00	66	8	76	0	0	0.687875765654441	0.687875765654441	false	false	false
eb95387d-3ef4-4907-a0d4-657d67e20b6d	2026-08-19 13:47	2026-08-19 13:47	2026-08-19 13:47	TEAM	TEAM260918P00175000	put	175.0000	2026-09-18	12.4000	12.1000	12.4000	172.7900	62000.00	62000.00	0.00	50	6	265	7	37.8571428571429	0.582175464073939	0.582175464073939	false	false	false
8a440519-770c-42b2-8129-c179b715e692	2026-08-19 13:58	2026-08-19 13:57	2026-08-19 13:57	TEAM	TEAM260821C00175000	call	175.0000	2026-08-21	2.8000	2.8000	2.9000	173.3750	10640.00	0.00	10640.00	38	6	1086	1667	0.651469706058788	0.683741371169789	0.687902544086617	false	false	false
e93d109b-4f07-4f6a-8bb3-a9508542a3cb	2026-08-19 14:30	2026-08-19 14:30	2026-08-19 14:30	TEAM	TEAM260821C00175000	call	175.0000	2026-08-21	3.4000	3.1000	3.4000	174.5100	32295.00	32295.00	0.00	95	8	1391	1667	0.834433113377325	0.702064605590654	0.692359471440313	false	false	false
ad04c2bb-595d-4c5f-bd7c-2af0bf5d3222	2026-08-19 14:41	2026-08-19 14:40	2026-08-19 14:40	TEAM	TEAM261016C00150000	call	150.0000	2026-10-16	31.6000	31.3000	31.8000	174.7200	316000.00	312840.00	3160.00	100	23	931	91	10.2307692307692	0.606239695925184	0.606239695925184	true	false	false
c6487eb7-0885-4c69-9952-9ef7e5972107	2026-08-19 14:44	2026-08-19 14:44	2026-08-19 14:44	TEAM	TEAM260828P00182500	put	182.5000	2026-08-28	11.2500	11.2000	12.0000	174.8200	14625.00	0.00	14625.00	13	7	59	0	0	0.612661102605616	0.612661102605616	false	false	false
6628b948-a7e2-4495-b664-1e6b604b5a3c	2026-08-19 14:49	2026-08-19 14:49	2026-08-19 14:49	TEAM	TEAM270617P00170000	put	170.0000	2027-06-17	36.1900	35.5000	36.2000	174.7900	170101.00	159271.00	10830.00	47	17	104	0	0	0.679338630572996	0.679338630572996	false	false	false
e6723080-f3a4-4195-8bb6-09b4f5059fad	2026-08-19 14:51	2026-08-19 14:51	2026-08-19 14:51	TEAM	TEAM260828P00182500	put	182.5000	2026-08-28	11.2000	10.3000	12.0000	175.1200	28001.00	19001.00	9000.00	25	11	90	0	0	0.627234199531604	0.615046006515549	false	false	false
7de322bb-b4f6-4a5a-b22f-374e05b361ad	2026-08-19 15:17	2026-08-19 15:17	2026-08-19 15:17	TEAM	TEAM260821C00170000	call	170.0000	2026-08-21	7.2100	7.2000	7.5000	176.0500	19480.00	0.00	19480.00	27	11	424	1820	0.232967032967033	0.672103344735214	0.646713239062804	false	false	false
483cb766-fbba-4930-8c64-88f2ffec15da	2026-08-19 15:17	2026-08-19 15:17	2026-08-19 15:17	TEAM	TEAM260821C00170000	call	170.0000	2026-08-21	7.2700	7.2000	7.5000	176.0931	82853.00	0.00	58373.00	114	18	397	1820	0.218131868131868	0.633610012486	0.663719023076014	false	false	false
d3d4b497-50d8-4740-8230-9da7348f4626	2026-08-19 15:17	2026-08-19 15:17	2026-08-19 15:17	TEAM	TEAM260821C00170000	call	170.0000	2026-08-21	7.1000	7.0000	7.5000	175.9100	22010.00	0.00	21300.00	31	6	457	1820	0.251098901098901	0.650759477868211	0.648813301635181	false	false	false
a824a099-78a8-4082-982c-598340a19211	2026-08-19 15:18	2026-08-19 15:18	2026-08-19 15:18	TEAM	TEAM260821P00165000	put	165.0000	2026-08-21	0.4000	0.4000	0.4500	176.0800	16106.00	0.00	16106.00	400	6	1287	316	4.07278481012658	0.687107328981404	0.687107328981404	false	false	false
9e1b7622-6c3d-4f41-a301-e0e52d2125a8	2026-08-19 15:23	2026-08-19 15:23	2026-08-19 15:23	TEAM	TEAM261016C00150000	call	150.0000	2026-10-16	32.0000	32.0000	32.9000	175.2000	153600.00	0.00	153600.00	48	21	1438	91	15.8021978021978	0.607419051193828	0.607419051193828	false	false	false
a010f58a-cdc7-4601-9a06-5df25202e671	2026-08-19 15:26	2026-08-19 15:25	2026-08-19 15:25	TEAM	TEAM261016C00150000	call	150.0000	2026-10-16	31.7200	31.5000	32.2000	174.8300	25373.00	0.00	25373.00	8	5	1459	91	16.032967032967	0.605505051000424	0.608869433224927	false	false	false
fa0f9061-f245-451b-b74e-b0376214d4bd	2026-08-19 15:33	2026-08-19 15:33	2026-08-19 15:33	TEAM	TEAM261016C00150000	call	150.0000	2026-10-16	32.0000	32.0000	32.2000	175.2700	73600.00	0.00	73600.00	23	8	1517	91	16.6703296703297	0.604725760096507	0.604725760096507	false	false	false
7ad75784-f8db-4079-ad94-9e85b6022502	2026-08-19 15:47	2026-08-19 15:46	2026-08-19 15:46	TEAM	TEAM261016C00150000	call	150.0000	2026-10-16	30.7000	30.7000	31.3000	173.7450	30700.00	0.00	30700.00	10	5	1648	91	18.1098901098901	0.599424266377981	0.599424266377981	false	false	false
090391aa-2e6d-47d2-9e86-f61b59a1ab33	2026-08-20 09:30	2026-08-20 09:30	2026-08-20 09:30	TEAM	TEAM261016C00150000	call	150.0000	2026-10-16	30.6000	30.0000	31.8000	173.9000	24480.00	0.00	24480.00	8	6	56	1647	0.0340012143290832	0.594480117043754	0.594480117043754	false	false	false
d63480f3-bd72-4643-8070-501c8ee64def	2026-08-20 09:30	2026-08-20 09:30	2026-08-20 09:30	TEAM	TEAM261016C00150000	call	150.0000	2026-10-16	30.8000	30.0000	32.0000	173.9000	40040.00	0.00	40040.00	13	11	86	1647	0.0522161505768063	0.604275600638537	0.604275600638537	false	false	false
b011569a-e093-4951-9bac-357f46c8fbb8	2026-08-20 09:34	2026-08-20 09:34	2026-08-20 09:34	TEAM	TEAM261016C00150000	call	150.0000	2026-10-16	32.0000	32.0000	33.4000	175.4300	22400.00	0.00	22400.00	7	5	162	1647	0.0983606557377049	0.60438908250923	0.60438908250923	false	false	false
46db5356-3419-4501-99bc-47f6e4b46ef1	2026-08-20 09:38	2026-08-20 09:38	2026-08-20 09:38	TEAM	TEAM261016C00150000	call	150.0000	2026-10-16	30.0000	30.0000	31.6000	172.7750	30000.00	0.00	30000.00	10	5	192	1647	0.116575591985428	0.607641766095835	0.607641766095835	false	false	false
a343ed75-86f3-4fbd-9a87-63f6db05cb10	2026-08-20 09:41	2026-08-20 09:41	2026-08-20 09:41	TEAM	TEAM261016C00170000	call	170.0000	2026-10-16	18.1000	17.1000	18.1000	173.1050	362000.00	362000.00	0.00	200	5	403	403	1	0.593197594344827	0.593197594344827	false	false	false
c95437c9-1d80-40de-b972-2f63a90538ae	2026-08-20 10:58	2026-08-20 10:58	2026-08-20 10:58	TEAM	TEAM270115C00160000	call	160.0000	2027-01-15	36.9000	35.7000	38.5000	174.1200	147600.00	140220.00	7380.00	40	14	40	357	0.112044817927171	0.665111440445241	0.665111440445241	true	false	false
fcb69b48-51ac-405b-9aaf-b7521341bba5	2026-08-20 11:00	2026-08-20 11:00	2026-08-20 11:00	TEAM	TEAM270115C00150000	call	150.0000	2027-01-15	42.4000	41.5000	43.5000	174.1900	334960.00	318000.00	16960.00	79	10	94	6663	0.0141077592675972	0.668710042564406	0.668710042564406	true	false	false
bf545147-8c10-439a-b631-7611fc06a09f	2026-08-20 11:15	2026-08-20 11:15	2026-08-20 11:15	TEAM	TEAM261016C00190000	call	190.0000	2026-10-16	11.0000	9.0000	11.2000	175.3501	42890.00	3290.00	39600.00	39	6	41	31	1.32258064516129	0.590523220828055	0.590523220828055	true	false	false
5677b3ce-da92-41cd-a7fb-5619c0dec7d4	2026-08-20 13:40	2026-08-20 13:39	2026-08-20 13:39	TEAM	TEAM261120C00175000	call	175.0000	2026-11-20	25.0000	23.7000	25.0000	175.1800	502462.00	499972.00	2490.00	201	9	202	11	18.3636363636364	0.692534607366686	0.692534607366686	false	false	false
c90f44be-af1f-4533-8b88-6fd37bca4f3f	2026-08-20 14:05	2026-08-20 14:05	2026-08-20 14:05	TEAM	TEAM260918C00185000	call	185.0000	2026-09-18	8.0000	7.3000	8.0000	175.8200	16000.00	16000.00	0.00	20	17	39	1020	0.0382352941176471	0.584082317652212	0.584082317652212	false	false	false
b825a99a-c27d-4094-ae7c-8671a2e0843c	2026-08-20 15:38	2026-08-20 15:37	2026-08-20 15:37	TEAM	TEAM260821C00170000	call	170.0000	2026-08-21	6.4000	6.1000	6.4000	175.9050	13440.00	13440.00	0.00	21	5	657	1951	0.336750384418247	0.647009441073516	0.647009441073516	false	false	false
24f06ed6-a89f-48b0-ab41-e8e70e2ccf74	2026-08-20 15:38	2026-08-20 15:37	2026-08-20 15:37	TEAM	TEAM260821C00170000	call	170.0000	2026-08-21	6.4000	6.1000	6.7000	175.9050	10880.00	2560.00	8320.00	17	5	636	1951	0.325986673500769	0.647009441073516	0.647009441073516	false	false	false
15b4439a-b99b-461c-a138-98bed7a2c500	2026-08-21 09:48	2026-08-21 09:48	2026-08-21 09:48	TEAM	TEAM261016P00165000	put	165.0000	2026-10-16	12.7000	10.3000	13.1000	169.6500	670507.00	669237.00	1270.00	528	50	528	26	20.3076923076923	0.594002586347715	0.589754768733822	false	false	false