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 = COIN×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	price

687d1181-80e0-4c65-92d9-02fa0069b856	2026-08-19 10:29	2026-08-19 10:28	2026-08-19 10:28	COIN	COIN261120C00170000	call	170.0000	2026-11-20	16.6500	16.3000	17.1000	155.0200	16650.00	1665.00	14985.00	10	6	20	353	0.056657223796034	0.696989146151357	0.700821119739927	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	42655640476.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a0a052d7-7f9b-4271-970b-6dd4a4d04d9d	2026-08-19 10:33	2026-08-19 10:33	2026-08-19 10:33	COIN	COIN260821P00150000	put	150.0000	2026-08-21	1.4900	1.4900	1.6000	155.0650	14006.00	0.00	14006.00	94	16	2384	4949	0.481713477470196	0.767685132691328	0.767685132691328	false	false	false	true	false
1d823d32-0076-46fa-8c28-5fefb3d13f8b	2026-08-19 10:35	2026-08-19 10:35	2026-08-19 10:35	COIN	COIN260918C00160000	call	160.0000	2026-09-18	10.0000	9.7000	10.0500	155.8000	25000.00	15000.00	0.00	25	6	388	3670	0.105722070844687	0.653139601773974	0.653139601773974	false	false	false	true	false
40a46dba-6746-4ad0-9b8c-9f30e26f4196	2026-08-19 10:35	2026-08-19 10:35	2026-08-19 10:35	COIN	COIN260828C00157500	call	157.5000	2026-08-28	5.9000	5.7000	6.0000	156.0000	29520.00	29520.00	0.00	50	5	116	405	0.28641975308642	0.669131480037518	0.669131480037518	false	false	false	true	false
44dd6cf9-37ff-4b63-a38d-561eedacf436	2026-08-19 10:36	2026-08-19 10:36	2026-08-19 10:36	COIN	COIN260821C00160000	call	160.0000	2026-08-21	2.5000	2.4400	2.5100	156.8600	17251.00	17251.00	0.00	69	8	10375	19846	0.522775370351708	0.841991654431114	0.826653472576409	false	false	false	true	false
aa5a168b-dac5-4ab8-9ea4-68f4ac830a06	2026-08-19 10:37	2026-08-19 10:36	2026-08-19 10:36	COIN	COIN260918C00150000	call	150.0000	2026-09-18	15.2500	14.7500	15.4000	156.6400	62525.00	62525.00	0.00	41	5	433	1733	0.249855741488748	0.649003910812604	0.649003910812604	false	false	false	true	false
a7a38cd2-1c74-4bb6-a304-fc4d1c5111c7	2026-08-19 10:37	2026-08-19 10:37	2026-08-19 10:37	COIN	COIN260821C00160000	call	160.0000	2026-08-21	2.5000	2.4400	2.5000	156.7200	12250.00	12250.00	0.00	49	7	10508	19846	0.529476972689711	0.836524086477896	0.836524086477896	false	false	false	true	false
565ee6e5-896b-4e4e-a93d-72812ba3add9	2026-08-19 10:37	2026-08-19 10:37	2026-08-19 10:37	COIN	COIN261120C00170000	call	170.0000	2026-11-20	17.7400	17.1500	17.8000	156.9795	15965.00	10655.00	5310.00	9	6	39	353	0.110481586402266	0.707150865945256	0.705568932058003	true	false	false	true	false
3bfb933a-61fd-4bd2-b67c-44a450159398	2026-08-19 10:38	2026-08-19 10:38	2026-08-19 10:38	COIN	COIN260918C00170000	call	170.0000	2026-09-18	7.0100	6.9500	7.0500	156.4900	29424.00	16824.00	8400.00	42	14	1546	17417	0.0887638514095424	0.669374133533625	0.668641435348524	false	false	false	true	false
2d1e9909-dbfb-401d-8016-fd494792eb89	2026-08-19 10:42	2026-08-19 10:41	2026-08-19 10:41	COIN	COIN270115P00135000	put	135.0000	2027-01-15	15.3000	15.1000	15.8500	156.1900	50490.00	48960.00	1530.00	33	5	90	6376	0.0141154328732748	0.693273739938732	0.693273739938732	false	false	false	true	false
42047b01-e34b-4fd5-8a8f-49fb41eaf294	2026-08-19 10:43	2026-08-19 10:43	2026-08-19 10:43	COIN	COIN260821C00150000	call	150.0000	2026-08-21	7.5000	7.5000	7.7500	156.1850	64500.00	0.00	64500.00	86	77	2313	12531	0.184582236054585	0.788177526329689	0.788177526329689	false	false	false	true	false
8d0e91a6-eca7-4d9a-8f76-ff91bb4f0010	2026-08-19 10:44	2026-08-19 10:44	2026-08-19 10:44	COIN	COIN260904C00187500	call	187.5000	2026-09-04	1.4200	1.4200	1.6100	156.2400	42600.00	0.00	42600.00	300	38	305	57	5.35087719298246	0.716119609949251	0.716119609949251	true	false	false	true	false
636cf2ae-add3-4f3d-b812-4a0e21ba3888	2026-08-19 10:45	2026-08-19 10:44	2026-08-19 10:44	COIN	COIN261120C00200000	call	200.0000	2026-11-20	9.7000	9.7000	9.9000	156.5200	513141.00	1950.00	511191.00	529	38	609	1235	0.493117408906883	0.71305765406018	0.714831405848971	false	false	false	true	false
bdf35cd7-1b8e-425c-9c9a-edaa7a0b0fbd	2026-08-19 10:45	2026-08-19 10:45	2026-08-19 10:45	COIN	COIN260904C00177500	call	177.5000	2026-09-04	2.8600	2.5700	2.8600	156.6425	42900.00	42900.00	0.00	150	11	153	34	4.5	0.714118058779977	0.714118058779977	true	false	false	true	false
2f6882ec-0171-4506-a701-731250594098	2026-08-19 10:46	2026-08-19 10:46	2026-08-19 10:46	COIN	COIN260821C00160000	call	160.0000	2026-08-21	2.5000	2.4100	2.5800	157.0000	10000.00	7250.00	750.00	40	9	11776	19846	0.593368940844503	0.822664334269498	0.81220977053902	false	false	false	true	false
d63eaeb2-6b0d-47b2-8931-f38e940139e2	2026-08-19 10:47	2026-08-19 10:47	2026-08-19 10:47	COIN	COIN260821C00149000	call	149.0000	2026-08-21	9.1000	8.7000	9.1000	157.1499	10920.00	10920.00	0.00	12	12	325	525	0.619047619047619	0.804687442541474	0.804687442541474	false	false	false	true	false
3ff89f9b-d35f-41d2-97f3-b3184390d14f	2026-08-19 10:47	2026-08-19 10:47	2026-08-19 10:47	COIN	COIN260821C00162500	call	162.5000	2026-08-21	1.9800	1.8400	1.9800	157.2800	42174.00	42174.00	0.00	213	33	713	1526	0.467234600262123	0.861370963669413	0.859463090471264	false	false	false	true	false
15a1a87c-b626-4b0a-b204-69904657d6d6	2026-08-19 10:47	2026-08-19 10:47	2026-08-19 10:47	COIN	COIN260821C00157500	call	157.5000	2026-08-21	3.8000	3.4500	3.8000	157.2550	61940.00	61940.00	0.00	163	16	1924	7782	0.247237214083783	0.840514275261384	0.840514275261384	false	false	false	true	false
e596aea2-b8fa-4927-a7ee-1524403c782f	2026-08-19 10:47	2026-08-19 10:47	2026-08-19 10:47	COIN	COIN260828C00172500	call	172.5000	2026-08-28	2.3900	2.1700	2.4000	157.4800	123555.00	123323.00	232.00	517	38	588	738	0.796747967479675	0.737417159200956	0.729743130683173	true	false	false	true	false
a5e842ee-ba7f-485d-b4c4-07bc5f8b5e1f	2026-08-19 10:47	2026-08-19 10:47	2026-08-19 10:47	COIN	COIN260828C00160000	call	160.0000	2026-08-28	5.8000	5.6000	5.8000	157.4800	188480.00	188480.00	0.00	325	31	2058	1789	1.15036333147009	0.694283618961891	0.696661979060062	false	false	false	true	false
f10e71c4-de44-4991-aac8-78354d628582	2026-08-19 10:48	2026-08-19 10:48	2026-08-19 10:48	COIN	COIN260821C00160000	call	160.0000	2026-08-21	2.9100	2.8800	2.9500	157.7400	15132.00	3492.00	11640.00	52	5	12278	19846	0.6186637105714	0.836469401949636	0.836469401949636	true	false	false	true	false
386427f6-4246-4ca1-a049-c8892e7428ba	2026-08-19 10:48	2026-08-19 10:48	2026-08-19 10:48	COIN	COIN270319C00220000	call	220.0000	2027-03-19	17.4800	16.2000	17.7000	157.7700	26220.00	24475.00	1745.00	15	9	24	1392	0.0172413793103448	0.715254423930752	0.714165547859033	false	false	false	true	false
15b40076-dbda-4d7e-a67a-74bc18efffd8	2026-08-19 10:48	2026-08-19 10:48	2026-08-19 10:48	COIN	COIN260828C00160000	call	160.0000	2026-08-28	5.9500	5.8000	6.0000	157.7350	26775.00	23205.00	3570.00	45	7	2113	1789	1.18110676355506	0.699712130446066	0.699712130446066	true	false	false	true	false
16a77156-d723-49b1-8bb4-1830f62fb783	2026-08-19 10:48	2026-08-19 10:48	2026-08-19 10:48	COIN	COIN260828C00160000	call	160.0000	2026-08-28	5.9500	5.8000	6.0000	157.7400	73184.00	58309.00	14875.00	123	8	2236	1789	1.24986025712689	0.699471963798371	0.699471963798371	true	false	false	true	false
26726eef-7d5f-4917-a330-5e9bcf6e3aa7	2026-08-19 10:48	2026-08-19 10:48	2026-08-19 10:48	COIN	COIN260821C00160000	call	160.0000	2026-08-21	3.0000	2.9500	3.0000	157.8400	30295.00	30000.00	295.00	101	13	12411	19846	0.625365312909402	0.846843672277382	0.835934102279827	false	false	false	true	false
cf5d7ec1-7635-4798-81d3-057e8c5864ea	2026-08-19 10:49	2026-08-19 10:49	2026-08-19 10:49	COIN	COIN260821C00160000	call	160.0000	2026-08-21	3.0000	3.0000	3.1000	157.7818	12000.00	0.00	12000.00	40	7	12559	19846	0.632822735059962	0.852266055064926	0.852266055064926	false	false	false	true	false
d0ec3109-e8fd-4adf-983f-6ecfb898ef83	2026-08-19 10:50	2026-08-19 10:49	2026-08-19 10:49	COIN	COIN260821P00160000	put	160.0000	2026-08-21	4.9500	4.9000	5.3500	158.0700	18315.00	0.00	18315.00	37	15	218	3411	0.0639108765757842	0.828190274490214	0.836799080095946	false	false	false	true	false
bd8a75df-8b5e-46a4-8ba8-6bcd9662cfdd	2026-08-19 10:51	2026-08-19 10:51	2026-08-19 10:51	COIN	COIN260821C00160000	call	160.0000	2026-08-21	3.5000	3.4000	3.5000	158.8800	10500.00	10500.00	0.00	30	5	13122	19846	0.661191172024589	0.854037524432874	0.854037524432874	false	false	false	true	false
fbb1f3e8-e3ad-4f0b-abdc-2dc792d19946	2026-08-19 10:52	2026-08-19 10:51	2026-08-19 10:51	COIN	COIN260821C00162500	call	162.5000	2026-08-21	2.6900	2.5700	2.6900	158.8900	37929.00	37929.00	0.00	141	31	939	1526	0.615334207077326	0.893854234108466	0.893854234108466	false	false	false	true	false
e81f3a8c-8dc1-4dfc-97f9-481c69688139	2026-08-19 10:52	2026-08-19 10:51	2026-08-19 10:51	COIN	COIN260821C00165000	call	165.0000	2026-08-21	1.9600	1.9000	1.9600	158.8900	41748.00	41748.00	0.00	213	18	2031	8439	0.240668325630999	0.907400752865445	0.907400752865445	false	false	false	true	false
92222d9a-7ca6-45a7-bac6-e4610cbf02fb	2026-08-19 10:52	2026-08-19 10:52	2026-08-19 10:52	COIN	COIN260828C00182500	call	182.5000	2026-08-28	1.4900	1.3600	1.4900	159.0376	18922.00	18774.00	0.00	127	40	181	140	1.29285714285714	0.798115054042137	0.798115054042137	false	false	false	true	false
39edfb70-e94a-4b38-9ac1-63bb97fe85a9	2026-08-19 10:52	2026-08-19 10:52	2026-08-19 10:52	COIN	COIN260918C00200000	call	200.0000	2026-09-18	2.5700	2.5500	2.6000	158.8750	11308.00	0.00	11308.00	44	13	3607	6079	0.593354170093765	0.725281484593039	0.725281484593039	false	false	false	true	false
fccce451-a7dd-4419-97d1-2e35ba679a72	2026-08-19 10:52	2026-08-19 10:52	2026-08-19 10:52	COIN	COIN270319C00220000	call	220.0000	2027-03-19	17.9800	16.7000	18.3000	159.0000	89900.00	51995.00	37905.00	50	5	79	1392	0.0567528735632184	0.716783063094849	0.71685212608926	false	false	false	true	false
81ea706d-de58-4464-bc7c-e173057d1773	2026-08-19 10:52	2026-08-19 10:52	2026-08-19 10:52	COIN	COIN260821C00160000	call	160.0000	2026-08-21	3.6100	3.6000	3.7000	159.1100	18778.00	2562.00	16216.00	52	6	13352	19846	0.672780409150459	0.856369200288024	0.852106632753337	false	false	false	true	false
9c692653-a10b-4520-9e1a-ccaa7efe1070	2026-08-19 10:53	2026-08-19 10:53	2026-08-19 10:53	COIN	COIN260821C00160000	call	160.0000	2026-08-21	3.8000	3.7500	3.8500	159.4700	46680.00	0.00	46680.00	123	13	13597	19846	0.685125466088884	0.857442506103845	0.846823569139328	false	false	false	true	false
6d261641-5d20-4dd1-86c3-f3e871fdf18b	2026-08-19 10:54	2026-08-19 10:54	2026-08-19 10:54	COIN	COIN260821C00162500	call	162.5000	2026-08-21	2.7500	2.7500	2.8500	159.2550	28875.00	0.00	28875.00	105	9	1071	1526	0.701834862385321	0.875888982645683	0.875888982645683	true	false	false	true	false
9c21d093-34da-41ef-bf0c-94dc2deea441	2026-08-19 10:54	2026-08-19 10:54	2026-08-19 10:54	COIN	COIN260918C00160000	call	160.0000	2026-09-18	12.0000	11.8000	12.0000	159.2050	10800.00	10800.00	0.00	9	5	530	3670	0.14441416893733	0.667289835000796	0.667584334893297	false	false	false	true	false
55b916f1-682c-4e1d-8fab-8daa32f47306	2026-08-19 10:54	2026-08-19 10:54	2026-08-19 10:54	COIN	COIN261016C00200000	call	200.0000	2026-10-16	6.2000	5.8500	6.2000	159.2150	275840.00	275840.00	0.00	445	44	762	3384	0.225177304964539	0.711298348313875	0.710729482153902	false	false	false	true	false
763ca508-28d6-49b4-b9aa-d8889ba5b28e	2026-08-19 10:54	2026-08-19 10:54	2026-08-19 10:54	COIN	COIN260828C00160000	call	160.0000	2026-08-28	7.0000	6.8500	7.0000	159.5734	11900.00	11900.00	0.00	17	6	2466	1789	1.37842370039128	0.713798558819758	0.713798558819758	false	false	false	true	false
ec088c58-5650-466d-a906-a30fcba17bb9	2026-08-19 10:55	2026-08-19 10:54	2026-08-19 10:54	COIN	COIN260821C00160000	call	160.0000	2026-08-21	4.0000	3.9500	4.0500	159.8800	26397.00	8400.00	397.00	66	14	13835	19846	0.697117807114784	0.872380705085308	0.856280694107054	false	false	false	true	false
d7968b7f-c4cc-4201-a210-ebb7db2f1f3b	2026-08-19 10:55	2026-08-19 10:54	2026-08-19 10:54	COIN	COIN260821P00160000	put	160.0000	2026-08-21	4.1000	4.1000	4.3000	159.8800	60680.00	0.00	60270.00	148	39	388	3411	0.113749633538552	0.843364633794656	0.85906371751715	true	false	false	true	false
cd8d91e3-bb19-4b0a-96f9-dbbadceda908	2026-08-19 10:55	2026-08-19 10:54	2026-08-19 10:54	COIN	COIN260821P00165000	put	165.0000	2026-08-21	7.3000	7.3000	7.7500	159.8800	94901.00	0.00	94901.00	130	32	195	2627	0.074229158736201	0.869915502697456	0.893711127458288	true	false	false	true	false
e0c37e05-3aa3-455a-aafe-f862fb2dbeea	2026-08-19 10:55	2026-08-19 10:55	2026-08-19 10:55	COIN	COIN260828C00155000	call	155.0000	2026-08-28	9.4900	9.4000	9.9000	159.7650	32272.00	0.00	32272.00	34	5	768	1092	0.703296703296703	0.676127305086758	0.68885162141841	false	false	false	true	false
5f50924f-c92c-431b-92a0-d930790cb056	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	COIN	COIN260821C00160000	call	160.0000	2026-08-21	4.0000	3.9500	4.0000	159.7600	17196.00	16800.00	396.00	43	12	14291	19846	0.720094729416507	0.860694707152368	0.869173686100742	true	false	false	true	false
ab744568-23e3-472c-aeb7-d7bbbf063190	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	COIN	COIN260828P00160000	put	160.0000	2026-08-28	6.9500	6.9500	7.2000	159.7800	460100.00	0.00	460100.00	662	56	677	212	3.19339622641509	0.690984497493964	0.690984497493964	false	false	false	true	false
42dec6e3-2910-4718-8e3c-00bf36d50db5	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	COIN	COIN260821C00160000	call	160.0000	2026-08-21	4.0100	3.9500	4.0500	159.8400	83768.00	83368.00	0.00	209	10	14521	19846	0.731683966542376	0.867032113057305	0.862708999454132	false	false	false	true	false
0625f186-4f11-4d79-a269-669cdca83ba7	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	COIN	COIN260828C00160000	call	160.0000	2026-08-28	7.0000	6.9500	7.1000	159.7800	22390.00	3550.00	18840.00	32	5	2589	1789	1.44717719396311	0.701082017955066	0.713086689585083	false	false	false	true	false
4d630c0b-c793-4749-9330-bc608f784d73	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	COIN	COIN260828P00160000	put	160.0000	2026-08-28	6.9500	6.8000	7.1000	159.9600	22240.00	7645.00	4865.00	32	11	709	212	3.34433962264151	0.699585401802978	0.699585401802978	true	false	false	true	false
5e55f50e-b86c-48ff-9132-b469c7c9448e	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	COIN	COIN260821C00160000	call	160.0000	2026-08-21	4.0000	3.9500	4.1500	159.8500	10400.00	0.00	10400.00	26	5	14591	19846	0.735211125667641	0.859513830351645	0.859513830351645	true	false	false	true	false
061b4aac-732f-47a4-94d9-3219fe11e2aa	2026-08-19 10:57	2026-08-19 10:56	2026-08-19 10:56	COIN	COIN260828C00160000	call	160.0000	2026-08-28	7.2000	7.0000	7.2500	160.2950	40330.00	38890.00	720.00	56	8	2672	1789	1.49357182783678	0.71105126730839	0.695989329645239	false	false	false	true	false