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:ticker = AS×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	pricenumeric

fd27cddb-774d-4b5b-a735-f728fc8ae7ad	2026-08-20 15:52	2026-08-20 15:52	2026-08-20 15:52	AS	AS260918C00035000	call	35.0000	2026-09-18	0.8500	0.8000	0.8500	32.7400	10769.00	10769.00	0.00	127	23	20581	33146	0.620919567972003	0.448899539484787	0.451890107384269	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Consumer Cyclical	15363736512.00	2026-11-17	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
f0ef219e-ffb7-4629-a05d-d12a773c4817	2026-08-20 15:52	2026-08-20 15:52	2026-08-20 15:52	AS	AS260918C00035000	call	35.0000	2026-09-18	0.8500	0.8000	0.8500	32.7610	10540.00	10540.00	0.00	124	6	20714	33146	0.624932118506004	0.44991038616345	0.449811351806374	false	false	false	true	false
6f57608e-201c-439d-bd12-fa66a8dcb8fa	2026-08-20 15:53	2026-08-20 15:52	2026-08-20 15:52	AS	AS260918C00035000	call	35.0000	2026-09-18	0.8500	0.8000	0.8500	32.7600	10540.00	10540.00	0.00	124	6	20856	33146	0.62921619501599	0.44991038616345	0.44991038616345	false	false	false	true	false
1a9d37a7-9aa4-4277-b7ed-89d7d5e3577b	2026-08-21 12:24	2026-08-21 12:24	2026-08-21 12:24	AS	AS260918C00035000	call	35.0000	2026-09-18	0.7500	0.7500	0.8000	32.6200	10425.00	0.00	10425.00	139	11	951	27309	0.0348236844996155	0.441185057714396	0.441185057714396	false	false	false	true	false
2fe1cb24-3e65-4495-bff9-31adf198a761	2026-08-21 14:34	2026-08-21 14:34	2026-08-21 14:34	AS	AS260918C00030000	call	30.0000	2026-09-18	3.2900	3.2000	3.3000	32.5700	56842.00	56842.00	0.00	173	7	272	3227	0.0842888131391385	0.468587531160735	0.468587531160735	false	false	false	true	false
b9adde71-eaf5-43e7-9f15-4b34bf57d56e	2026-08-24 10:21	2026-08-24 10:21	2026-08-24 10:21	AS	AS260918P00030000	put	30.0000	2026-09-18	0.6000	0.5500	0.6500	32.0100	38294.00	7800.00	29234.00	638	44	640	7017	0.0912070685478125	0.432707918683682	0.43461640853763	false	false	false	true	false
840690c3-667f-456f-b77d-6f029d764244	2026-08-24 10:31	2026-08-24 10:30	2026-08-24 10:30	AS	AS260918C00032500	call	32.5000	2026-09-18	1.2500	1.1500	1.3000	31.9700	38125.00	7625.00	18000.00	305	10	320	11048	0.0289645184648805	0.438042980733828	0.435199245189991	false	false	false	true	false
9bef11d4-6be1-4fac-ab89-fca4bfe09307	2026-08-24 10:53	2026-08-24 10:53	2026-08-24 10:53	AS	AS261218P00035000	put	35.0000	2026-12-18	5.0400	5.0000	5.2000	31.7400	151700.00	0.00	55750.00	301	7	455	850	0.535294117647059	0.464659702145633	0.457515949579226	false	false	false	true	false
70171a79-b2cf-41cf-aebf-2fd6c4759a35	2026-08-24 11:11	2026-08-24 11:11	2026-08-24 11:11	AS	AS260918C00032500	call	32.5000	2026-09-18	1.0900	1.0000	1.1000	31.5600	21890.00	21890.00	0.00	200	10	2693	11048	0.24375452570601	0.439900066346656	0.446060901403654	false	false	false	true	false
26b4bb29-50f5-4209-86d9-79b55891e08c	2026-08-24 11:58	2026-08-24 11:58	2026-08-24 11:58	AS	AS260918C00030000	call	30.0000	2026-09-18	2.2000	2.1500	2.2500	31.2500	211420.00	88000.00	35420.00	961	23	4852	3409	1.42329128776767	0.451138111876647	0.451138111876647	false	false	false	true	false
037ba0a8-f47e-4489-aec0-f7f829e549f2	2026-08-24 12:00	2026-08-24 12:00	2026-08-24 12:00	AS	AS260918C00032500	call	32.5000	2026-09-18	1.0000	0.9000	1.0000	31.3300	49999.00	49999.00	0.00	500	22	3213	11048	0.290821868211441	0.444989607368589	0.444989607368589	false	false	false	true	false
7b3cef7c-41ba-4e87-8a47-3b3ce4c4ce20	2026-08-24 12:04	2026-08-24 12:04	2026-08-24 12:04	AS	AS260918C00030000	call	30.0000	2026-09-18	2.2500	2.2000	2.2500	31.3550	120375.00	118575.00	0.00	535	15	5517	3409	1.61836315635084	0.444220646623911	0.444220646623911	false	false	false	true	false
9ddd47e4-9769-49a5-8cce-2c73fda8cc26	2026-08-24 12:42	2026-08-24 12:42	2026-08-24 12:42	AS	AS260918C00030000	call	30.0000	2026-09-18	2.3500	2.3500	2.4000	31.4750	192935.00	0.00	192935.00	821	7	6695	3409	1.96391903784101	0.450400774145203	0.450400774145203	false	false	false	true	false
fdb4e17e-a7be-495a-9d62-e47d0f882e38	2026-08-24 15:49	2026-08-24 15:49	2026-08-24 15:49	AS	AS260918C00032500	call	32.5000	2026-09-18	0.9500	0.9500	1.0000	31.2750	22705.00	0.00	22705.00	239	8	6886	11048	0.623280231716148	0.436213710056903	0.436213710056903	false	false	false	true	false
020cb1ad-ee49-4072-b511-c51a40db9270	2026-08-24 15:49	2026-08-24 15:49	2026-08-24 15:49	AS	AS260918C00032500	call	32.5000	2026-09-18	1.0000	0.8500	1.0000	31.2810	76100.00	76100.00	0.00	761	13	7647	11048	0.692161477190442	0.451248024855243	0.451248024855243	false	false	false	true	false
e3fec532-a2aa-4e81-8c87-ea3eab615d79	2026-08-25 09:45	2026-08-25 09:44	2026-08-25 09:44	AS	AS260918C00032500	call	32.5000	2026-09-18	0.8000	0.6500	0.8000	30.7700	72240.00	72240.00	0.00	903	23	1115	17055	0.0653767223688068	0.458513354387335	0.458513354387335	false	false	false	true	false
d5f0e9fa-65c7-42f2-81ba-8b13542aeb41	2026-08-25 09:48	2026-08-25 09:48	2026-08-25 09:48	AS	AS261218C00040000	call	40.0000	2026-12-18	0.9000	0.7500	0.9000	30.9850	43020.00	43020.00	0.00	478	21	500	1205	0.4149377593361	0.472665834050992	0.472665834050992	false	false	false	true	false
5f6ab3b5-f662-475c-8192-d6a86d8b2aba	2026-08-25 09:50	2026-08-25 09:49	2026-08-25 09:49	AS	AS260918C00030000	call	30.0000	2026-09-18	2.0400	1.6500	2.0500	31.0000	86711.00	86711.00	0.00	426	8	526	10287	0.0511324973267231	0.455449738570612	0.455449738570612	false	false	false	true	false
74f7b03e-733a-4861-8137-5aeeeb24dc3b	2026-08-25 11:10	2026-08-25 11:09	2026-08-25 11:09	AS	AS261016C00032500	call	32.5000	2026-10-16	1.5500	1.4500	1.5500	31.1100	15480.00	15480.00	0.00	100	14	415	78	5.32051282051282	0.438451906571969	0.440610070539879	false	false	false	true	false
8ac1b96b-4797-4ccc-a150-e4a08ef6edfb	2026-08-25 11:12	2026-08-25 11:12	2026-08-25 11:12	AS	AS261016C00032500	call	32.5000	2026-10-16	1.5300	1.4500	1.5500	31.1000	15292.00	15292.00	0.00	100	9	515	78	6.6025641025641	0.437243510521773	0.441562533812024	false	false	false	true	false
f0f95447-5a9f-4693-9886-2da420ebf35e	2026-08-25 11:26	2026-08-25 11:26	2026-08-25 11:26	AS	AS261016P00030000	put	30.0000	2026-10-16	1.4000	1.3000	1.4500	31.0700	15960.00	140.00	15820.00	114	23	122	196	0.622448979591837	0.426734327556144	0.426734327556144	false	false	false	true	false
9b840d20-f6b9-4092-b2c9-721ee663017a	2026-08-25 11:45	2026-08-25 11:44	2026-08-25 11:44	AS	AS261016C00032500	call	32.5000	2026-10-16	1.5400	1.4500	1.5500	31.1250	15433.00	15433.00	0.00	100	7	620	78	7.94871794871795	0.432709232048012	0.439180274204446	false	false	false	true	false
f1bfee40-71ed-48e4-b3e4-35c47b78778d	2026-08-25 13:56	2026-08-25 13:56	2026-08-25 13:56	AS	AS260918C00032500	call	32.5000	2026-09-18	1.0000	1.0000	1.0500	31.3850	16300.00	0.00	4000.00	163	5	1570	17055	0.0920551158018176	0.447382122512354	0.447382122512354	false	false	false	true	false
f1c315d1-016a-4172-90a2-1e844e341712	2026-08-25 13:58	2026-08-25 13:58	2026-08-25 13:58	AS	AS260918C00032500	call	32.5000	2026-09-18	1.0500	0.9500	1.0500	31.4650	68953.00	68953.00	0.00	657	56	2446	17055	0.143418352389329	0.452702345085576	0.452702345085576	false	false	false	true	false
802727cb-7091-4516-9ee6-22f535012cfc	2026-08-25 13:59	2026-08-25 13:58	2026-08-25 13:58	AS	AS260918C00035000	call	35.0000	2026-09-18	0.3500	0.3500	0.4500	31.4900	30660.00	0.00	8960.00	876	13	1571	27595	0.0569306033701758	0.433026265115159	0.433026265115159	false	false	false	true	false
683dd409-3568-469b-b431-58d4562288a6	2026-08-25 14:02	2026-08-25 14:02	2026-08-25 14:02	AS	AS260918C00032500	call	32.5000	2026-09-18	1.0500	0.9500	1.0500	31.0000	20790.00	20790.00	0.00	198	8	2655	17055	0.155672823218997	0.454702179406867	0.454702179406867	false	false	false	true	false
129f6c2a-0cdc-4c26-8326-89aa4249601d	2026-08-25 14:06	2026-08-25 14:06	2026-08-25 14:06	AS	AS260918C00032500	call	32.5000	2026-09-18	1.0500	1.0000	1.1000	31.0000	165371.00	156656.00	0.00	1575	34	4246	17055	0.248959249486954	0.454702179406867	0.454702179406867	true	false	false	true	false
72fff5a1-1454-427c-aa77-d2f729419419	2026-08-25 14:09	2026-08-25 14:09	2026-08-25 14:09	AS	AS260918C00035000	call	35.0000	2026-09-18	0.4500	0.4000	0.4500	31.0000	15255.00	15255.00	0.00	339	11	2229	27595	0.0807755028084798	0.464827409219139	0.464827409219139	true	false	false	true	false
0d6b39d6-c170-4866-94c5-ca431eab6402	2026-08-25 14:12	2026-08-25 14:11	2026-08-25 14:11	AS	AS260918C00032500	call	32.5000	2026-09-18	1.1500	1.0500	1.2000	31.0000	54050.00	50485.00	3565.00	470	44	5642	17055	0.330812078569335	0.460412901575893	0.456268944700526	true	false	false	true	false
d3f43697-4e5a-439f-b6ae-7ad3a642f8ac	2026-08-25 14:12	2026-08-25 14:12	2026-08-25 14:12	AS	AS260918C00035000	call	35.0000	2026-09-18	0.4000	0.4000	0.5000	31.0000	11520.00	0.00	11520.00	288	7	2539	27595	0.0920094219967385	0.440982648564166	0.440982648564166	false	false	false	true	false
a8b77caa-ce44-4a11-abf4-33ad3c59948d	2026-08-25 14:25	2026-08-25 14:25	2026-08-25 14:25	AS	AS261218C00045000	call	45.0000	2026-12-18	0.5000	0.4500	0.5500	31.0000	34750.00	32250.00	2500.00	695	7	1054	12344	0.0853856124432923	0.483763157320022	0.483936717517389	false	false	false	true	false
46501cd4-a0a4-432e-ab21-680066a7c947	2026-08-25 14:48	2026-08-25 14:48	2026-08-25 14:48	AS	AS260918C00032500	call	32.5000	2026-09-18	1.0500	1.0000	1.0500	31.4750	38102.00	38102.00	0.00	363	18	6079	17055	0.356435063031369	0.452194059155162	0.451367454321291	false	false	false	true	false
3ce77701-4306-46af-aaf7-704b3e0d5ec9	2026-08-25 14:55	2026-08-25 14:55	2026-08-25 14:55	AS	AS261218C00040000	call	40.0000	2026-12-18	0.9000	0.9000	1.0500	31.4681	27000.00	0.00	27000.00	300	8	996	1205	0.82655601659751	0.452240303467416	0.452240303467416	false	false	false	true	false
37b1296e-3302-4c3b-b169-dd13c8f7660d	2026-08-25 15:00	2026-08-25 15:00	2026-08-25 15:00	AS	AS261016C00035000	call	35.0000	2026-10-16	0.9500	0.8500	0.9500	31.4800	47296.00	47296.00	0.00	498	47	11882	1384	8.58526011560694	0.447921353062531	0.447921353062531	false	false	false	true	false
168d30ac-b4d9-4c3e-a10f-8529aadd524b	2026-08-25 15:09	2026-08-25 15:09	2026-08-25 15:09	AS	AS261016C00035000	call	35.0000	2026-10-16	1.0000	0.9500	1.0000	31.5250	12479.00	11800.00	679.00	125	25	12079	1384	8.72760115606936	0.457658968864977	0.449405146097409	false	false	false	true	false
0c4eff94-6e36-45c8-9e3c-66c1aa98eb42	2026-08-26 10:55	2026-08-26 10:55	2026-08-26 10:55	AS	AS260918C00030000	call	30.0000	2026-09-18	1.9000	1.7500	2.0500	30.9900	322795.00	302275.00	19380.00	1699	65	1712	10854	0.157729869172655	0.426721697835973	0.426721697835973	false	false	false	true	false
c249bf62-b2f8-464d-bb4e-d0780439731c	2026-08-26 11:03	2026-08-26 11:03	2026-08-26 11:03	AS	AS260918C00030000	call	30.0000	2026-09-18	2.0500	1.9000	2.0500	31.0200	61705.00	61705.00	0.00	301	5	2015	10854	0.185645844849825	0.4717871652468	0.4717871652468	false	false	false	true	false
a8b19f37-198a-4217-88aa-eb10bb5253e7	2026-08-26 11:34	2026-08-26 11:34	2026-08-26 11:34	AS	AS261016C00032500	call	32.5000	2026-10-16	1.4000	1.4000	1.4500	30.8750	22120.00	0.00	22120.00	158	9	307	748	0.410427807486631	0.434002962944498	0.434468506599631	false	false	false	true	false
7fd4b10c-02e1-4570-975b-edc839686da4	2026-08-26 11:46	2026-08-26 11:46	2026-08-26 11:46	AS	AS260918C00030000	call	30.0000	2026-09-18	1.9000	1.8000	1.9500	30.9100	322509.00	316169.00	1900.00	1699	42	3714	10854	0.342177998894417	0.440259147723342	0.444392417352057	false	false	false	true	false
86224d4c-05de-403c-a73b-ccfa4556f4f0	2026-08-26 11:47	2026-08-26 11:46	2026-08-26 11:46	AS	AS260918C00030000	call	30.0000	2026-09-18	1.9400	1.8000	1.9500	30.9100	58500.00	58500.00	0.00	301	11	4015	10854	0.369909710705731	0.451245608033356	0.461510319844365	false	false	false	true	false
2cc1317d-1bb2-4692-88c8-4eeed8cc376a	2026-08-26 13:02	2026-08-26 13:01	2026-08-26 13:01	AS	AS261016C00032500	call	32.5000	2026-10-16	1.4000	1.4000	1.4500	30.9500	16240.00	0.00	16240.00	116	24	555	748	0.741978609625668	0.42747135837742	0.42747135837742	false	false	false	true	false
20c9a3c0-2836-46fb-b05d-21420b8a7e79	2026-08-27 11:40	2026-08-27 11:40	2026-08-27 11:40	AS	AS261016C00035000	call	35.0000	2026-10-16	0.5000	0.5000	0.6500	30.6200	18889.00	0.00	18829.00	376	48	429	14544	0.029496699669967	0.393727568425722	0.416965380139335	false	false	false	true	false
afc5c6a1-9044-42b6-b040-13cc71bd5d65	2026-08-27 11:45	2026-08-27 11:45	2026-08-27 11:45	AS	AS260918C00032500	call	32.5000	2026-09-18	0.6000	0.6000	0.6500	30.5850	22680.00	0.00	22680.00	378	23	385	22979	0.0167544279559598	0.428582266057263	0.428582266057263	false	false	false	true	false
04667f34-3dde-4ec5-b138-edba480e6232	2026-08-27 11:52	2026-08-27 11:52	2026-08-27 11:52	AS	AS260918C00030000	call	30.0000	2026-09-18	1.6000	1.5000	1.6000	30.4400	75040.00	75040.00	0.00	469	17	472	14886	0.0317076447668951	0.450244536803623	0.450244536803623	false	false	false	true	false
1febef8c-a3fd-48a1-8c23-5a76e7b2ecf3	2026-08-27 13:05	2026-08-27 13:05	2026-08-27 13:05	AS	AS260918C00031000	call	31.0000	2026-09-18	1.1500	1.1500	1.2500	30.6700	11500.00	0.00	11500.00	100	8	168	0	0	0.423024970312803	0.423024970312803	false	false	false	true	false
f2eab4e1-e173-4fd8-88d9-cb5324eaab43	2026-08-27 13:58	2026-08-27 13:57	2026-08-27 13:57	AS	AS260918C00030000	call	30.0000	2026-09-18	1.5500	1.4000	1.5500	30.4400	58590.00	58590.00	0.00	378	17	915	14886	0.0614671503426038	0.433101667122005	0.433101667122005	false	false	false	true	false
c5a6f308-221c-4a1c-a04f-51737f543568	2026-08-27 14:04	2026-08-27 14:04	2026-08-27 14:04	AS	AS260918C00030000	call	30.0000	2026-09-18	1.6000	1.5500	1.6000	30.4450	18880.00	18880.00	0.00	118	24	1033	14886	0.0693940615343276	0.449246164013381	0.449246164013381	false	false	false	true	false
51ca1865-0ea7-4fdf-b836-14655a11e7eb	2026-08-27 14:28	2026-08-27 14:28	2026-08-27 14:28	AS	AS260904C00031000	call	31.0000	2026-09-04	0.6000	0.6000	2.5500	30.3250	60000.00	0.00	60000.00	1000	5	1000	0	0	0.490178118063088	0.490178118063088	false	false	false	true	false
e5de8e75-bd91-43fe-9001-f119af40f76d	2026-08-27 14:28	2026-08-27 14:28	2026-08-27 14:28	AS	AS260918C00031000	call	31.0000	2026-09-18	1.1000	1.0500	1.3000	30.3400	20680.00	9680.00	11000.00	188	12	417	0	0	0.458404814802105	0.458404814802105	false	false	false	true	false
67092c7a-c32f-4f85-900a-5bd08bf7cf76	2026-08-27 14:37	2026-08-27 14:37	2026-08-27 14:37	AS	AS260918C00030500	call	30.5000	2026-09-18	1.3500	1.3000	1.3500	30.3600	26589.00	26589.00	0.00	197	29	416	0	0	0.468944959762178	0.458756602928788	false	false	false	true	false