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:alert_rule = RepeatedHits×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	expirydate

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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
9cc07002-62c8-45d1-8367-b6cb1b183a43	2026-08-21 10:39	2026-08-21 10:39	2026-08-21 10:39	TEAM	TEAM270617P00190000	put	190.0000	2027-06-17	49.7900	46.2000	52.3000	170.7800	408250.00	353580.00	54670.00	82	21	82	15	5.46666666666667	0.680431926999887	0.680431926999887	false	false	false	true
c16785cd-0ccd-43a7-aa51-c4a1c0c9c8ac	2026-08-21 10:46	2026-08-21 10:45	2026-08-21 10:45	TEAM	TEAM270617C00190000	call	190.0000	2027-06-17	36.9000	35.8000	39.5000	170.5850	239850.00	188190.00	51660.00	65	9	82	3	27.3333333333333	0.685416593390741	0.685416593390741	false	false	false	true
a012007c-6f57-4e8d-91ab-da8879ffb0b2	2026-08-21 10:46	2026-08-21 10:46	2026-08-21 10:46	TEAM	TEAM270617C00210000	call	210.0000	2027-06-17	31.0000	29.9000	31.0000	170.5600	251100.00	251100.00	0.00	81	16	81	76	1.06578947368421	0.685386361107313	0.685386361107313	false	false	false	true
d22b28d6-3bda-46fd-ad73-ec3bec05ea46	2026-08-21 10:48	2026-08-21 10:48	2026-08-21 10:48	TEAM	TEAM261218C00230000	call	230.0000	2026-12-18	9.7100	9.6000	10.0000	170.6600	245600.00	132300.00	113300.00	253	23	253	37	6.83783783783784	0.669194446638348	0.669194446638348	false	false	false	true
82299b6b-3b67-45f8-8a44-021224b9623f	2026-08-21 10:53	2026-08-21 10:53	2026-08-21 10:53	TEAM	TEAM260911P00170000	put	170.0000	2026-09-11	8.6000	8.6000	9.4000	170.7000	56760.00	0.00	56760.00	66	12	66	14	4.71428571428571	0.560853761737018	0.560853761737018	false	false	false	true
8bae0821-8870-4e9e-9996-d524a77169bd	2026-08-21 12:06	2026-08-21 12:06	2026-08-21 12:06	TEAM	TEAM261218C00250000	call	250.0000	2026-12-18	7.3000	6.5000	7.3000	171.8500	15330.00	15330.00	0.00	21	9	59	0	0	0.674206823407238	0.674206823407238	false	false	false	true
f54a4389-149f-43d0-ba84-ac7276222471	2026-08-21 13:53	2026-08-21 13:53	2026-08-21 13:53	TEAM	TEAM260828P00160000	put	160.0000	2026-08-28	1.8000	1.4500	1.8000	170.3350	32939.00	32939.00	0.00	183	26	196	29	6.75862068965517	0.605786368405893	0.605786368405893	false	false	false	true
f33c74d8-f559-4887-853c-0661c7edbd63	2026-08-21 15:37	2026-08-21 15:37	2026-08-21 15:37	TEAM	TEAM260821C00165000	call	165.0000	2026-08-21	7.4000	7.1000	7.4000	172.3500	14060.00	5180.00	0.00	19	5	99	1509	0.0656063618290258	3.58197059713262	3.58197059713262	false	false	false	true
e8279585-567d-4f9f-9d30-59a2a339165a	2026-08-21 15:37	2026-08-21 15:37	2026-08-21 15:37	TEAM	TEAM260821C00165000	call	165.0000	2026-08-21	7.4000	7.0000	7.5000	172.2725	14060.00	8880.00	2220.00	19	7	118	1509	0.0781974817760106	4.27082137702834	4.27082137702834	false	false	false	true