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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 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 = SYM×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

5c4d7255-c4b8-4fa7-b00d-cb6886366489	2026-08-18 09:50	2026-08-18 09:50	2026-08-18 09:50	SYM	SYM260821C00040500	call	40.5000	2026-08-21	1.0000	1.0000	1.1500	40.5100	42800.00	0.00	42800.00	428	16	529	62	8.53225806451613	0.675065450638504	0.675065450638504	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Industrials	5402732650.00	2026-11-23	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
8f22ce55-f863-4ce4-ad1c-59f14464019a	2026-08-18 09:50	2026-08-18 09:50	2026-08-18 09:50	SYM	SYM260821C00040500	call	40.5000	2026-08-21	1.0000	0.9500	1.1000	40.3800	15700.00	0.00	15700.00	157	7	686	62	11.0645161290323	0.720052932171682	0.720052932171682	true	false	false
9e2671d3-3ee1-4c0a-a205-ce094413adb1	2026-08-18 09:51	2026-08-18 09:51	2026-08-18 09:51	SYM	SYM260821C00040500	call	40.5000	2026-08-21	1.0000	0.8000	1.1500	40.4100	12500.00	5900.00	6600.00	125	5	825	62	13.3064516129032	0.709809085395764	0.709809085395764	false	false	false
ccbb8336-f7a6-4db9-8e4d-80200fd83804	2026-08-18 09:56	2026-08-18 09:55	2026-08-18 09:55	SYM	SYM260821C00040500	call	40.5000	2026-08-21	1.0000	0.8500	1.0000	40.3050	11400.00	11400.00	0.00	114	11	1386	62	22.3548387096774	0.745335551593009	0.745335551593009	false	false	false
6cdf0382-e228-4182-9f46-a48ae6b29393	2026-08-18 11:45	2026-08-18 11:45	2026-08-18 11:45	SYM	SYM270115P00037500	put	37.5000	2027-01-15	4.8000	4.7000	5.1000	40.5600	12000.00	0.00	12000.00	25	14	87	176	0.494318181818182	0.658315986305861	0.658315986305861	false	false	false
5604fff5-a025-43f1-8808-f1e3e273944d	2026-08-18 11:46	2026-08-18 11:46	2026-08-18 11:46	SYM	SYM270115P00037500	put	37.5000	2027-01-15	4.8000	4.7000	5.1000	40.6050	31200.00	1920.00	29280.00	65	18	174	176	0.988636363636364	0.660771164522199	0.659895547071438	false	false	false
e444bd30-0bce-4110-8126-a69930b48776	2026-08-18 13:45	2026-08-18 13:45	2026-08-18 13:45	SYM	SYM260918P00040000	put	40.0000	2026-09-18	2.3500	2.2500	2.4000	40.3400	85780.00	240.00	85540.00	365	17	394	261	1.5095785440613	0.553489852071172	0.564276698878889	false	false	false
65b9155e-5e8f-45f0-85f8-0df0dcff1377	2026-08-19 14:40	2026-08-19 14:40	2026-08-19 14:40	SYM	SYM261120C00040000	call	40.0000	2026-11-20	6.4000	6.1000	6.5000	41.8200	12160.00	5120.00	7040.00	19	9	63	661	0.0953101361573374	0.639458199723185	0.639458199723185	false	false	false
d6d4a062-435d-4b13-954b-0b290409febd	2026-08-19 14:48	2026-08-19 14:48	2026-08-19 14:48	SYM	SYM260918C00042500	call	42.5000	2026-09-18	2.5000	2.4000	2.5000	41.9300	17245.00	17245.00	0.00	69	26	131	112	1.16964285714286	0.553062393860027	0.563489657361631	false	false	false
6a399acc-6026-4ee0-8eb5-c0564b8e85c3	2026-08-20 10:51	2026-08-20 10:51	2026-08-20 10:51	SYM	SYM270115C00047500	call	47.5000	2027-01-15	4.8000	4.7000	4.9000	40.7000	21600.00	15840.00	3840.00	45	11	45	218	0.206422018348624	0.675678016366211	0.675678016366211	false	false	false
75679eb0-3c9d-4869-8d75-09fec3bbdbfd	2026-08-20 12:18	2026-08-20 12:18	2026-08-20 12:18	SYM	SYM261016P00035000	put	35.0000	2026-10-16	1.2500	1.2000	1.3000	40.9200	19750.00	1750.00	18000.00	158	13	165	0	0	0.587143286104947	0.587591915923972	false	false	false	true
23c5faa3-8a71-4838-b381-b2faa29fa3f5	2026-08-20 15:40	2026-08-20 15:40	2026-08-20 15:40	SYM	SYM270219P00045000	put	45.0000	2027-02-19	9.7000	9.5000	9.8000	41.2000	13580.00	1940.00	11640.00	14	5	17	72	0.236111111111111	0.684530434332285	0.684530434332285	false	false	false
ead4c81e-f4e2-4cc4-9703-edb11cb45e0f	2026-08-21 10:57	2026-08-21 10:57	2026-08-21 10:57	SYM	SYM261120P00042500	put	42.5000	2026-11-20	5.3000	5.1000	5.4000	42.4600	63070.00	6360.00	50880.00	119	17	572	112	5.10714285714286	0.655478174465418	0.65394644252779	true	false	false
48b00ecc-b94f-4c69-a075-6f7349837f38	2026-08-21 10:58	2026-08-21 10:58	2026-08-21 10:58	SYM	SYM261120P00042500	put	42.5000	2026-11-20	5.4000	5.2000	5.8000	42.3300	10260.00	1080.00	6480.00	19	6	732	112	6.53571428571429	0.659318042561224	0.659318042561224	false	false	false
77dccae0-848e-4661-bbcd-72049f2af5ad	2026-08-21 10:58	2026-08-21 10:58	2026-08-21 10:58	SYM	SYM261120P00042500	put	42.5000	2026-11-20	5.4000	5.1000	5.5000	42.3600	19980.00	2700.00	17280.00	37	8	936	112	8.35714285714286	0.659318042561224	0.660863728690301	false	false	false
73cf4f60-a11f-41f0-b465-5ed46eac6094	2026-08-21 11:18	2026-08-21 11:18	2026-08-21 11:18	SYM	SYM261120P00042500	put	42.5000	2026-11-20	5.3700	5.3000	5.4000	42.3100	18248.00	13478.00	4770.00	34	6	1279	112	11.4196428571429	0.657079504489471	0.646229106252805	false	false	false
8677e280-285f-43d0-ad35-a3328c6edc46	2026-08-21 11:22	2026-08-21 11:22	2026-08-21 11:22	SYM	SYM261016C00045000	call	45.0000	2026-10-16	3.0000	2.8500	3.0000	42.3900	13500.00	13500.00	0.00	45	15	45	2	22.5	0.598947773897888	0.598947773897888	false	false	false	true
90beaea2-ddda-4b54-add1-a0852a33276f	2026-08-21 11:33	2026-08-21 11:32	2026-08-21 11:32	SYM	SYM261120P00042500	put	42.5000	2026-11-20	5.4000	5.3000	5.6000	42.4700	23220.00	5940.00	16740.00	43	12	2029	112	18.1160714285714	0.667262281625139	0.666497976967688	true	false	false
29158177-fdf0-4161-bd52-dc28be5f3319	2026-08-21 11:39	2026-08-21 11:38	2026-08-21 11:38	SYM	SYM261120P00042500	put	42.5000	2026-11-20	5.4000	5.4000	5.7000	42.5100	14040.00	0.00	14040.00	26	6	2392	112	21.3571428571429	0.668534012926351	0.668534012926351	false	false	false
6415077a-0e26-472b-b27e-d6b262171e9d	2026-08-21 11:45	2026-08-21 11:45	2026-08-21 11:45	SYM	SYM261120P00042500	put	42.5000	2026-11-20	5.4000	5.1000	5.6000	42.6300	34020.00	20520.00	8100.00	63	5	2523	112	22.5267857142857	0.674602056113328	0.674602056113328	false	false	false
67f55d82-cc64-4f0a-a695-8b420f48da03	2026-08-21 11:48	2026-08-21 11:47	2026-08-21 11:47	SYM	SYM261120P00042500	put	42.5000	2026-11-20	5.4000	5.2000	5.4000	42.5500	18360.00	18360.00	0.00	34	6	3454	112	30.8392857142857	0.669914676351456	0.670563330939668	false	false	false
8b07dfd3-5fc1-40d9-bca7-8a47313d731e	2026-08-21 12:24	2026-08-21 12:24	2026-08-21 12:24	SYM	SYM261120P00042500	put	42.5000	2026-11-20	5.6000	5.5000	5.9000	42.0850	15120.00	0.00	15120.00	27	5	3823	112	34.1339285714286	0.670725083779016	0.670725083779016	false	false	false
7f956729-3aa4-4340-a82c-a54dfa0d3d02	2026-08-21 12:33	2026-08-21 12:33	2026-08-21 12:33	SYM	SYM261120P00042500	put	42.5000	2026-11-20	5.7000	5.5000	5.8000	42.0750	31350.00	19950.00	7980.00	55	9	4516	112	40.3214285714286	0.683085950341066	0.682300681655825	false	false	false
95f3cbca-5ba7-46cb-a4a3-c7f2c9c173e3	2026-08-21 14:58	2026-08-21 14:57	2026-08-21 14:57	SYM	SYM260821C00040500	call	40.5000	2026-08-21	2.0000	1.6500	2.0000	42.4900	57800.00	57800.00	0.00	289	6	299	2985	0.100167504187605	2.26122996431754	2.26122996431754	false	false	false
389f267a-b216-4628-923c-7fd33f39c6c8	2026-08-21 14:58	2026-08-21 14:58	2026-08-21 14:58	SYM	SYM260821C00040500	call	40.5000	2026-08-21	2.0000	1.6500	2.0000	42.5600	39600.00	8000.00	0.00	198	5	497	2985	0.166499162479062	1.52049597494677	1.52049597494677	false	false	false
ce826262-44e9-450f-a15e-2e0478876557	2026-08-24 09:56	2026-08-24 09:56	2026-08-24 09:56	SYM	SYM261120P00037500	put	37.5000	2026-11-20	3.6000	3.2000	3.8000	40.4700	11880.00	1080.00	720.00	33	18	33	178	0.185393258426966	0.67274535448895	0.67274535448895	false	false	false
c91fb981-ce48-4088-9403-81980c38cde3	2026-08-24 09:56	2026-08-24 09:56	2026-08-24 09:56	SYM	SYM261120P00037500	put	37.5000	2026-11-20	3.6000	3.5000	3.8000	40.4700	15480.00	2160.00	1440.00	43	18	76	178	0.426966292134831	0.67274535448895	0.67274535448895	false	false	false
ef6fdc13-3e9a-4d1d-a8ac-6ab2858cec8b	2026-08-24 09:56	2026-08-24 09:56	2026-08-24 09:56	SYM	SYM261120P00037500	put	37.5000	2026-11-20	3.6000	3.5000	3.8000	40.4700	15120.00	6480.00	720.00	42	18	118	178	0.662921348314607	0.67274535448895	0.67274535448895	false	false	false
30191876-5128-458d-ba66-f7eedbc395c3	2026-08-24 09:56	2026-08-24 09:56	2026-08-24 09:56	SYM	SYM261120P00037500	put	37.5000	2026-11-20	3.6000	3.5000	3.8000	40.5200	18000.00	7200.00	720.00	50	20	179	178	1.00561797752809	0.675057985703962	0.675057985703962	false	false	false
e5e510dc-784b-4032-9e9d-5340c91b67a9	2026-08-24 10:56	2026-08-24 10:56	2026-08-24 10:56	SYM	SYM270115C00052500	call	52.5000	2027-01-15	3.2000	3.2000	3.5000	40.6350	10249.00	0.00	10249.00	32	5	34	195	0.174358974358974	0.652577707925699	0.652577707925699	false	false	false
9a51e5fb-0c53-42b0-b715-aaf3eb71b90b	2026-08-24 15:41	2026-08-24 15:40	2026-08-24 15:40	SYM	SYM261120P00037500	put	37.5000	2026-11-20	3.6000	3.4000	3.7000	40.1100	27360.00	25920.00	0.00	76	26	276	178	1.55056179775281	0.658696742458381	0.655850535436503	false	false	false
5b4550f5-1321-4236-b353-12a9c165b0ba	2026-08-25 12:42	2026-08-25 12:42	2026-08-25 12:42	SYM	SYM280121P00030000	put	30.0000	2028-01-21	6.2000	6.2000	6.8000	40.7750	31000.00	0.00	31000.00	50	11	50	886	0.0564334085778781	0.726203923093911	0.725917012374079	false	false	false
d9dd8637-a94e-496e-9733-c1e2f5052fd4	2026-08-25 12:42	2026-08-25 12:42	2026-08-25 12:42	SYM	SYM280121P00030000	put	30.0000	2028-01-21	6.2000	6.1000	6.8000	40.8050	76261.00	620.00	75641.00	123	21	223	886	0.251693002257336	0.726063423758123	0.726356069302268	false	false	false
36b2add3-edc4-4b9f-a5a2-d60d2362fc3a	2026-08-26 13:04	2026-08-26 13:04	2026-08-26 13:04	SYM	SYM261016P00037500	put	37.5000	2026-10-16	1.9500	1.8500	1.9500	40.6300	11115.00	11115.00	0.00	57	21	58	34	1.70588235294118	0.578834434827675	0.578834434827675	false	false	false
048a1e8e-db3b-447b-86fa-e4d5e5e8fcce	2026-08-26 15:24	2026-08-26 15:24	2026-08-26 15:24	SYM	SYM261016P00040000	put	40.0000	2026-10-16	3.0000	2.8500	3.0000	40.7200	13800.00	13800.00	0.00	46	20	73	48	1.52083333333333	0.575170174511839	0.575170174511839	false	false	false
41c5c0a5-97b2-4575-86fb-a4fa57e72c98	2026-08-27 14:37	2026-08-27 14:37	2026-08-27 14:37	SYM	SYM261120P00042500	put	42.5000	2026-11-20	5.3000	5.2000	5.5000	41.6900	21730.00	530.00	3180.00	41	6	1113	3218	0.345866998135488	0.632351626964551	0.632351626964551	true	false	false
20ae4bf6-6c62-4ffd-ade8-6cae8be9791d	2026-08-27 14:39	2026-08-27 14:38	2026-08-27 14:38	SYM	SYM261120P00042500	put	42.5000	2026-11-20	5.3000	5.2000	5.5000	41.6800	22260.00	21200.00	1060.00	42	8	1219	3218	0.37880671224363	0.631783346973532	0.631783346973532	false	false	false
795e6499-e2b1-4266-a645-26e9c34c4e83	2026-08-27 14:39	2026-08-27 14:39	2026-08-27 14:39	SYM	SYM270115P00040000	put	40.0000	2027-01-15	5.4000	5.3000	5.5000	41.7300	33485.00	1080.00	32405.00	62	15	69	827	0.0834340991535671	0.650907135351211	0.650907135351211	false	false	false
7e5cb3c5-beac-49cc-9a76-aef924d83fe5	2026-08-27 14:39	2026-08-27 14:39	2026-08-27 14:39	SYM	SYM270115P00042500	put	42.5000	2027-01-15	6.7000	6.5000	6.8000	41.7300	51596.00	1340.00	50256.00	77	19	87	221	0.393665158371041	0.6446178197717	0.6446178197717	false	false	false
c5f6444e-2d0f-434d-9d1a-5732936f9292	2026-08-31 11:46	2026-08-31 11:46	2026-08-31 11:46	SYM	SYM270115P00035000	put	35.0000	2027-01-15	3.4000	3.4000	3.6000	39.6200	17000.00	0.00	17000.00	50	14	50	274	0.182481751824818	0.621830881739922	0.623227133550483	false	false	false
ea22ec64-00a6-4cdc-a6d1-b277ad09b692	2026-08-31 11:46	2026-08-31 11:46	2026-08-31 11:46	SYM	SYM270115P00035000	put	35.0000	2027-01-15	3.4000	3.4000	3.6000	39.6300	11900.00	0.00	11900.00	35	15	91	274	0.332116788321168	0.622878388194059	0.62357566770137	false	false	false
d1bd5719-fd10-4f5e-ba64-b5f48789ea7c	2026-08-31 14:11	2026-08-31 14:11	2026-08-31 14:11	SYM	SYM261120P00042500	put	42.5000	2026-11-20	6.0000	5.9000	6.3000	39.0000	55800.00	54600.00	600.00	93	12	1084	2004	0.540918163672655	0.604155764242127	0.602732243070082	true	false	false
dcca2fc7-0e50-4487-90fd-d23eb080c3c9	2026-09-01 12:32	2026-09-01 12:32	2026-09-01 12:32	SYM	SYM260918C00040000	call	40.0000	2026-09-18	1.0000	1.0000	1.1000	38.2400	10002.00	0.00	10002.00	100	5	121	384	0.315104166666667	0.51595862568151	0.509533084410416	false	false	false
95c15a71-b914-452a-8c90-3da34df90b2f	2026-09-01 15:16	2026-09-01 15:16	2026-09-01 15:16	SYM	SYM261120C00055000	call	55.0000	2026-11-20	0.7000	0.7000	0.7500	37.7950	14140.00	0.00	14140.00	202	13	256	1946	0.131551901336074	0.634523601404956	0.634523601404956	false	false	false
d7f66ad5-de4c-438d-9ac4-0c4eac004c23	2026-09-02 11:00	2026-09-02 11:00	2026-09-02 11:00	SYM	SYM261120P00045000	put	45.0000	2026-11-20	7.7000	7.5000	7.7000	39.7100	62364.00	62364.00	0.00	81	19	81	233	0.347639484978541	0.623297112236271	0.623297112236271	false	false	false
6a43c752-f4ea-480d-b3dd-d3d8336706b3	2026-09-03 10:34	2026-09-03 10:33	2026-09-03 10:33	SYM	SYM261016P00042500	put	42.5000	2026-10-16	4.0000	3.8000	4.1000	40.6300	25600.00	25600.00	0.00	64	16	64	21	3.04761904761905	0.54507947832598	0.54507947832598	false	false	false
bb3502bf-0a7c-4d31-8559-72b7ab23f756	2026-09-03 13:34	2026-09-03 13:34	2026-09-03 13:34	SYM	SYM260918C00046000	call	46.0000	2026-09-18	0.4000	0.1500	0.4000	41.1500	27579.00	27579.00	0.00	690	49	693	23	30.1304347826087	0.545866552070322	0.543031174826395	false	false	false
2f4b7c61-4694-4900-84d2-d10cf1cfda3e	2026-09-03 14:33	2026-09-03 14:33	2026-09-03 14:33	SYM	SYM261120C00040000	call	40.0000	2026-11-20	5.4000	5.2000	5.4000	41.1000	22140.00	22140.00	0.00	41	8	118	736	0.160326086956522	0.626349501339701	0.626349501339701	false	false	false
470ba422-e97b-4160-ade3-4d8bbf6c0aa6	2026-09-03 15:16	2026-09-03 15:15	2026-09-03 15:15	SYM	SYM260911C00044000	call	44.0000	2026-09-11	0.4000	0.3000	0.4000	41.3200	27917.00	27917.00	0.00	698	54	713	54	13.2037037037037	0.526481990404685	0.525258115068793	false	false	false
e6452558-0981-4053-aea2-5f7b8d929705	2026-09-04 11:23	2026-09-04 11:23	2026-09-04 11:23	SYM	SYM260911C00045000	call	45.0000	2026-09-11	0.4000	0.3000	0.4500	42.6000	27556.00	27396.00	0.00	689	24	707	82	8.62195121951219	0.51305251219827	0.51305251219827	false	false	false