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 = ETSY×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

d5f24a7d-25a3-44b0-af21-275619616396	2026-08-17 10:44	2026-08-17 10:44	2026-08-17 10:44	ETSY	ETSY270115C00095000	call	95.0000	2027-01-15	5.1500	5.1500	5.4000	79.4900	12875.00	0.00	12875.00	25	7	237	2833	0.0836569008118602	0.486044458528366	0.486044458528366	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	6834068956.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
4aaab494-fc34-4b4a-9db2-6e31c99a09d4	2026-08-18 12:52	2026-08-18 12:52	2026-08-18 12:52	ETSY	ETSY261218C00080000	call	80.0000	2026-12-18	9.9500	9.9500	10.2000	80.6000	171142.00	0.00	171142.00	172	32	174	300	0.58	0.496373465515635	0.496373465515635	false	false	false	true
b2aef067-843d-4e5e-a32e-674f967fb1d6	2026-08-18 13:56	2026-08-18 13:56	2026-08-18 13:56	ETSY	ETSY261218C00085000	call	85.0000	2026-12-18	7.5500	7.5500	7.8000	80.2600	32465.00	0.00	32465.00	43	15	50	301	0.166112956810631	0.490355385751331	0.490355385751331	false	false	false	true
140cf99d-d3c2-4254-b51f-52025d20616e	2026-08-20 12:30	2026-08-20 12:30	2026-08-20 12:30	ETSY	ETSY261218C00090000	call	90.0000	2026-12-18	6.2500	6.0500	6.3000	80.9650	13126.00	11875.00	1251.00	21	6	240	444	0.540540540540541	0.50094949150557	0.501498256394084	true	false	false	true
4c7a5dc5-898e-4d0f-9b0f-7bbf7e2a9dde	2026-08-20 12:44	2026-08-20 12:44	2026-08-20 12:44	ETSY	ETSY271217P00085000	put	85.0000	2027-12-17	18.6000	18.6000	19.3000	81.5250	243665.00	1865.00	241800.00	131	8	132	70	1.88571428571429	0.522760306049952	0.52416743185065	false	false	false	true
f7a1c605-745c-40e4-9d67-fa018627e707	2026-08-20 12:45	2026-08-20 12:44	2026-08-20 12:44	ETSY	ETSY261218C00090000	call	90.0000	2026-12-18	6.5000	6.2000	6.7000	81.5500	18850.00	18850.00	0.00	29	8	316	444	0.711711711711712	0.500757592641389	0.500757592641389	true	false	false	true
dc728d10-8ac6-4a2b-a528-52311c8f5d9d	2026-08-20 12:53	2026-08-20 12:53	2026-08-20 12:53	ETSY	ETSY261218C00090000	call	90.0000	2026-12-18	6.5000	6.3000	6.6000	81.5600	48750.00	41600.00	7150.00	75	15	410	444	0.923423423423423	0.500519798035245	0.500519798035245	true	false	false	true
11ea22fa-5ae7-4624-afaa-68b0368d76e4	2026-08-21 10:21	2026-08-21 10:21	2026-08-21 10:21	ETSY	ETSY260828C00090000	call	90.0000	2026-08-28	0.1800	0.1200	0.2900	80.9000	15552.00	15210.00	342.00	864	25	886	25	35.44	0.507326016819199	0.512017887917658	false	false	false	true
7d63a3d4-e6f6-48e8-9440-42d40359d5ec	2026-08-21 10:40	2026-08-21 10:40	2026-08-21 10:40	ETSY	ETSY260828C00090000	call	90.0000	2026-08-28	0.2700	0.2100	0.2700	81.7100	12528.00	12528.00	0.00	464	37	3061	25	122.44	0.523838207126512	0.523838207126512	false	false	false	true
7336d506-e95a-49ce-86b5-967b0955d6dd	2026-08-21 10:41	2026-08-21 10:41	2026-08-21 10:41	ETSY	ETSY261016C00090000	call	90.0000	2026-10-16	2.7600	2.7300	2.7900	81.8753	24288.00	14904.00	9384.00	88	18	88	266	0.330827067669173	0.432816896645965	0.432816896645965	true	false	false	true
5c336018-85df-40d4-8152-b19ff12fb311	2026-08-24 10:20	2026-08-24 10:20	2026-08-24 10:20	ETSY	ETSY261218C00105000	call	105.0000	2026-12-18	3.3500	3.1500	3.5500	83.6600	69670.00	69000.00	0.00	208	27	210	273	0.769230769230769	0.499792929002398	0.499792929002398	false	false	false	true
edd90278-fb7f-407c-a934-7292f0aadb49	2026-08-24 10:29	2026-08-24 10:29	2026-08-24 10:29	ETSY	ETSY260904C00082000	call	82.0000	2026-09-04	4.0500	3.8000	4.0500	84.2100	20244.00	20244.00	0.00	50	15	114	27	4.22222222222222	0.477482061192053	0.466425737510073	true	false	false	true
6b00e875-23fa-4dbd-87e0-fc179fd03fdd	2026-08-24 10:32	2026-08-24 10:32	2026-08-24 10:32	ETSY	ETSY260918P00083000	put	83.0000	2026-09-18	3.2500	3.0500	3.2500	83.9750	10400.00	10400.00	0.00	32	11	42	0	0	0.43857367274003	0.43857367274003	false	false	false	true
0840bd50-9477-4841-8995-771afbf9988b	2026-08-24 10:45	2026-08-24 10:45	2026-08-24 10:45	ETSY	ETSY270115C00080000	call	80.0000	2027-01-15	13.0000	12.9000	13.1000	84.2900	11700.00	2600.00	3900.00	9	5	11	441	0.0249433106575964	0.491352600963781	0.491352600963781	false	false	false	true
d37a7536-f5ba-41fc-b658-d3becbdf9441	2026-08-24 14:59	2026-08-24 14:59	2026-08-24 14:59	ETSY	ETSY261218C00095000	call	95.0000	2026-12-18	6.6500	6.3500	6.6500	85.5700	10640.00	10640.00	0.00	16	16	77	515	0.149514563106796	0.510451173238951	0.510451173238951	false	false	false	true
2cf9ce9b-e128-4d0c-9cd4-2b1a18043e9b	2026-08-24 15:01	2026-08-24 15:00	2026-08-24 15:00	ETSY	ETSY261218C00085000	call	85.0000	2026-12-18	10.5000	10.5000	10.7000	85.5750	18900.00	0.00	17850.00	18	18	19	368	0.0516304347826087	0.508865666822045	0.508865666822045	false	false	false	true
1fcc73ea-7d99-4846-993e-8895980a42d6	2026-08-24 15:23	2026-08-24 15:23	2026-08-24 15:23	ETSY	ETSY260904C00088000	call	88.0000	2026-09-04	1.9300	1.6900	1.9300	85.9450	74883.00	74691.00	0.00	388	24	396	16	24.75	0.46514645230277	0.46514645230277	false	false	false	true
1bed96fc-e9b3-4950-9928-8c56e3e4486e	2026-08-27 10:14	2026-08-27 10:13	2026-08-27 10:13	ETSY	ETSY260904C00084000	call	84.0000	2026-09-04	1.8600	1.8000	2.1200	83.0500	120156.00	558.00	119598.00	646	55	646	11	58.7272727272727	0.46104043994388	0.46104043994388	false	false	false	true
7e46d7f1-6312-4cbc-8c71-bfb6ef22e971	2026-08-28 09:39	2026-08-28 09:39	2026-08-28 09:39	ETSY	ETSY260918C00080000	call	80.0000	2026-09-18	6.1000	5.6500	6.1000	84.2100	23180.00	23180.00	0.00	38	5	39	2285	0.0170678336980306	0.443243874472499	0.443243874472499	false	false	false	true
8706941e-6b25-4190-a97f-da684167bd72	2026-09-01 12:02	2026-09-01 12:02	2026-09-01 12:02	ETSY	ETSY261016C00095000	call	95.0000	2026-10-16	1.3500	1.3400	1.3500	81.9450	19912.00	10800.00	9112.00	148	19	149	261	0.57088122605364	0.44500544836953	0.44500544836953	false	false	false	true
087d8add-c574-4128-ab2c-4ce02b70f5fc	2026-09-04 10:57	2026-09-04 10:57	2026-09-04 10:57	ETSY	ETSY261016C00080000	call	80.0000	2026-10-16	4.6800	4.6500	5.1500	80.1200	14035.00	7990.00	6045.00	30	5	37	414	0.0893719806763285	0.407936206096801	0.407936206096801	false	false	false	true
145250d6-2d7d-4190-8e2b-34e8c8898e03	2026-09-04 11:37	2026-09-04 11:37	2026-09-04 11:37	ETSY	ETSY261016C00085000	call	85.0000	2026-10-16	2.6100	2.4400	3.0500	79.0400	13572.00	1566.00	12006.00	52	6	52	341	0.152492668621701	0.443309655303489	0.443309655303489	false	false	false	true
bd3a9e22-d7f8-458b-9de5-ce34ac6578f2	2026-09-04 11:48	2026-09-04 11:48	2026-09-04 11:48	ETSY	ETSY261016C00085000	call	85.0000	2026-10-16	2.4200	2.3200	2.5600	78.3600	10164.00	3146.00	7018.00	42	5	174	341	0.510263929618768	0.447718852617172	0.447718852617172	true	false	false	true
e591cfa4-4481-4b45-b8bd-092fdf0ab075	2026-09-08 09:45	2026-09-08 09:44	2026-09-08 09:44	ETSY	ETSY261016P00072500	put	72.5000	2026-10-16	3.4000	3.1000	3.4000	74.3200	37740.00	37740.00	0.00	111	18	121	6558	0.018450747179018	0.464473967053441	0.464473967053441	false	false	false	true
f8236cff-1da4-4504-b61d-c5658cd51666	2026-09-08 10:30	2026-09-08 10:30	2026-09-08 10:30	ETSY	ETSY260918P00070000	put	70.0000	2026-09-18	1.4500	1.1000	1.6900	72.1950	33640.00	145.00	33495.00	232	8	259	2210	0.117194570135747	0.515165600495136	0.515165600495136	false	false	false	true
d49762b2-6a07-48f1-9dba-2deeee5cf7c8	2026-09-08 13:47	2026-09-08 13:47	2026-09-08 13:47	ETSY	ETSY271217P00080000	put	80.0000	2027-12-17	19.0500	18.2000	19.0500	71.5500	15240.00	15240.00	0.00	8	8	8	25	0.32	0.502247865502613	0.502247865502613	false	false	false	true
af9b91e8-73b0-40e9-adb1-be1163adbf2e	2026-09-09 13:58	2026-09-09 13:57	2026-09-09 13:57	ETSY	ETSY261016C00077500	call	77.5000	2026-10-16	1.9100	1.9100	1.9400	70.7400	44805.00	21312.00	23493.00	234	26	236	39	6.05128205128205	0.470871166123117	0.470871166123117	false	false	false	true
1328de73-2386-41a6-896d-a63217154a6c	2026-09-09 15:48	2026-09-09 15:48	2026-09-09 15:48	ETSY	ETSY260918P00075000	put	75.0000	2026-09-18	4.7900	4.6000	4.8000	70.9350	12454.00	12454.00	0.00	26	5	50	3701	0.0135098621994056	0.492945266878428	0.492945266878428	false	false	false	true
a1d67db0-e981-4b4c-a158-c0e606ae8fc3	2026-09-14 11:20	2026-09-14 11:20	2026-09-14 11:20	ETSY	ETSY261218P00070000	put	70.0000	2026-12-18	5.3000	5.0000	5.3000	74.3400	20140.00	20140.00	0.00	38	11	49	84	0.583333333333333	0.517394109747596	0.517394109747596	false	false	false	true
0526f5fe-c497-4740-9645-6df6b1a614b9	2026-09-14 11:20	2026-09-14 11:20	2026-09-14 11:20	ETSY	ETSY261218P00067500	put	67.5000	2026-12-18	4.3000	4.1000	4.3000	74.3400	28810.00	28810.00	0.00	67	24	67	73	0.917808219178082	0.520552010654047	0.520552010654047	false	false	false	true
05c73823-18c8-4ea4-830f-90bc67a461b5	2026-09-14 14:05	2026-09-14 14:05	2026-09-14 14:05	ETSY	ETSY260925C00066500	call	66.5000	2026-09-25	8.3000	8.1000	9.9000	74.4250	17430.00	0.00	17430.00	21	11	21	0	0	0.513096665556258	0.513096665556258	false	false	false	true
f4275dc9-8daf-4997-b814-8f6c1dd591be	2026-09-15 09:33	2026-09-15 09:33	2026-09-15 09:33	ETSY	ETSY261016C00075000	call	75.0000	2026-10-16	4.3000	4.0000	4.4000	75.2600	43860.00	42990.00	870.00	102	17	435	47	9.25531914893617	0.470999716032857	0.468914319631483	true	false	false	true
7d147e2f-d536-4090-8a0c-b7ceee157b82	2026-09-15 09:34	2026-09-15 09:33	2026-09-15 09:33	ETSY	ETSY261016C00075000	call	75.0000	2026-10-16	4.3400	4.0000	4.3500	74.8700	19970.00	19140.00	0.00	46	5	483	47	10.2765957446809	0.493180574439161	0.470126274399477	false	false	false	true
828c28ab-7a9e-4be8-9fcd-09fc40aacf1f	2026-09-16 15:12	2026-09-16 15:12	2026-09-16 15:12	ETSY	ETSY261016P00072500	put	72.5000	2026-10-16	3.2500	3.1000	3.2500	73.1500	47450.00	47450.00	0.00	146	21	264	6614	0.0399153311158149	0.442228509234626	0.442228509234626	false	false	false	true
2cb123fb-c50b-4000-9c2b-38c038de9711	2026-09-17 12:21	2026-09-17 12:21	2026-09-17 12:21	ETSY	ETSY261218C00075000	call	75.0000	2026-12-18	6.8000	6.8000	6.8500	72.7700	399840.00	0.00	399840.00	588	6	588	179	3.28491620111732	0.510604535082993	0.510604535082993	false	false	false	true
7d137e24-db1a-4d85-a029-a84d0a286de2	2026-09-17 15:24	2026-09-17 15:24	2026-09-17 15:24	ETSY	ETSY261016P00072500	put	72.5000	2026-10-16	3.3500	3.2500	3.3500	72.7400	14740.00	14740.00	0.00	44	13	72	6625	0.0108679245283019	0.439242626271477	0.439242626271477	false	false	false	true
134c5e07-6da8-46af-99ff-5d645aea7345	2026-09-18 14:59	2026-09-18 14:59	2026-09-18 14:59	ETSY	ETSY261023C00078000	call	78.0000	2026-10-23	2.0300	1.8800	2.0300	72.8300	39991.00	39991.00	0.00	197	31	197	0	0	0.430341242734176	0.430751204477547	false	false	false	true
711318e3-69c7-4475-968a-b4eae5628238	2026-09-21 12:19	2026-09-21 12:18	2026-09-21 12:18	ETSY	ETSY261120C00077500	call	77.5000	2026-11-20	4.6000	4.3000	4.8500	72.0000	10580.00	460.00	10120.00	23	7	26	0	0	0.5339380044328	0.5339380044328	false	false	false	true
f885ed42-aa78-4df4-94af-95239e2663de	2026-09-21 12:37	2026-09-21 12:37	2026-09-21 12:37	ETSY	ETSY261218P00062500	put	62.5000	2026-12-18	2.6200	2.6200	2.7500	72.9000	13100.00	0.00	13100.00	50	20	50	188	0.265957446808511	0.513558621007046	0.513558621007046	false	false	false	true
a460e75b-b909-4859-b88d-0b3ba3746f26	2026-09-21 14:00	2026-09-21 14:00	2026-09-21 14:00	ETSY	ETSY261030C00075000	call	75.0000	2026-10-30	4.0600	4.0500	4.1000	73.0000	49970.00	12710.00	37260.00	123	9	127	23	5.52173913043478	0.498933431326504	0.493690019923047	false	false	false	true
d00aba85-ab23-42ed-b621-4031feccb284	2026-09-21 15:05	2026-09-21 15:05	2026-09-21 15:05	ETSY	ETSY261218C00095000	call	95.0000	2026-12-18	1.7000	1.5300	1.7000	73.0000	11560.00	11560.00	0.00	68	17	68	30779	0.0022092985477111	0.507868905908149	0.507868905908149	false	false	false	true
402bbece-00d5-490d-8b0b-dacca25262d3	2026-09-21 15:05	2026-09-21 15:05	2026-09-21 15:05	ETSY	ETSY261218C00090000	call	90.0000	2026-12-18	2.4400	2.1800	2.4400	73.0000	20496.00	20496.00	0.00	84	20	86	851	0.101057579318449	0.505986995046296	0.505986995046296	false	false	false	true
80268a72-1e4b-4e64-9538-c371c0c7c2f8	2026-09-22 10:07	2026-09-22 10:07	2026-09-22 10:07	ETSY	ETSY270319C00100000	call	100.0000	2027-03-19	3.6000	3.6000	4.0500	73.7750	37440.00	0.00	37440.00	104	6	307	102	3.00980392156863	0.507452795117543	0.508004601416687	false	false	false	true
55522863-462b-4805-b064-687259acf77a	2026-09-22 10:11	2026-09-22 10:11	2026-09-22 10:11	ETSY	ETSY261120C00090000	call	90.0000	2026-11-20	2.0500	1.6200	2.5200	73.5100	62730.00	27470.00	35260.00	306	12	413	22	18.7727272727273	0.570679929114728	0.57337806668029	true	false	false	true
322df9be-476a-4f5f-bc25-7277928b5b03	2026-09-22 10:31	2026-09-22 10:31	2026-09-22 10:31	ETSY	ETSY260925P00071000	put	71.0000	2026-09-25	0.4900	0.4200	0.5300	73.8950	19404.00	147.00	19257.00	396	19	472	410	1.15121951219512	0.582283747712423	0.582283747712423	false	false	false	true
990bf97c-dee7-4fc0-96ee-1cc096a42af2	2026-09-22 10:58	2026-09-22 10:58	2026-09-22 10:58	ETSY	ETSY260925C00074000	call	74.0000	2026-09-25	1.6500	1.5500	1.8200	74.1900	10560.00	0.00	10560.00	64	10	441	138	3.19565217391304	0.575035520713928	0.575035520713928	false	false	false	true
3120d252-8839-40eb-aa97-2695bcf1f6f2	2026-09-22 12:40	2026-09-22 12:40	2026-09-22 12:40	ETSY	ETSY261016C00080000	call	80.0000	2026-10-16	1.4800	1.3800	1.4800	74.0650	42032.00	42032.00	0.00	284	49	289	451	0.64079822616408	0.464430863764898	0.464430863764898	false	false	false	true
e36ec64a-7edc-4f5a-8b5f-07825949fadb	2026-09-22 13:51	2026-09-22 13:51	2026-09-22 13:51	ETSY	ETSY261218C00070000	call	70.0000	2026-12-18	9.8000	9.5500	9.8000	73.8500	38220.00	38220.00	0.00	39	13	39	98	0.397959183673469	0.525608196833617	0.525608196833617	false	false	false	true