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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = TLRY×

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

6370356f-e7f7-4044-afdb-358f228aaa14	2026-09-28 11:56	2026-09-28 11:56	2026-09-28 11:56	TLRY	TLRY261009C00004000	call	4.0000	2026-10-09	0.2600	0.2400	0.2600	3.9950	10400.00	10400.00	0.00	400	21	521	222	2.34684684684685	0.950619004116262	0.940985528544328	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	547538388.00	2026-10-08	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T15:58:21.684493Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
de36f91c-7a00-40f7-8f07-81511ec1d83e	2026-09-21 10:19	2026-09-21 10:19	2026-09-21 10:19	TLRY	TLRY261218P00004000	put	4.0000	2026-12-18	0.5900	0.4700	0.6000	4.0350	58884.00	58884.00	0.00	1000	5	1000	2689	0.371885459278542	0.792448307537735	0.792448307537735	false	false	false	true	false
03c337e4-795f-4982-ab22-e76cf1998566	2026-09-17 11:22	2026-09-17 11:22	2026-09-17 11:22	TLRY	TLRY261218P00004000	put	4.0000	2026-12-18	0.6100	0.6100	0.6500	3.9350	30439.00	0.00	30439.00	499	17	515	2483	0.207410390656464	0.762091478146583	0.762091478146583	false	false	false	true	false
62e6d89c-a4b8-4590-9602-3710d8acb881	2026-09-16 13:12	2026-09-16 13:12	2026-09-16 13:12	TLRY	TLRY270115C00004500	call	4.5000	2027-01-15	0.5100	0.5100	0.5500	3.9400	11628.00	0.00	11628.00	228	16	243	169	1.43786982248521	0.768160363179294	0.768160363179294	false	false	false	true	false
da0ea06c-0aa7-46f1-8ebf-a815b533607d	2026-09-16 10:54	2026-09-16 10:54	2026-09-16 10:54	TLRY	TLRY260925P00004500	put	4.5000	2026-09-25	0.6000	0.1700	0.8000	3.9200	12540.00	3600.00	8940.00	209	5	209	218	0.958715596330275	0.707150703439207	0.707150703439207	false	false	false	true	false
770df7a2-99d1-4adc-a378-a0407ad9a2d8	2026-09-08 15:54	2026-09-08 15:54	2026-09-08 15:54	TLRY	TLRY260911C00004000	call	4.0000	2026-09-11	0.3400	0.1200	0.3800	4.2800	33614.00	33614.00	0.00	1000	9	1015	59	17.2033898305085	0.90478231941855	0.90478231941855	false	false	false	true	false
712b512b-1760-4d61-bc06-880029e54c80	2026-09-08 12:43	2026-09-08 12:43	2026-09-08 12:43	TLRY	TLRY261023C00004500	call	4.5000	2026-10-23	0.4500	0.4200	0.4500	4.4150	10305.00	10305.00	0.00	229	16	229	73	3.13698630136986	0.774674813924997	0.774674813924997	false	false	false	true	false
5eaae154-19f0-4fdd-b16a-a0fff3c51e01	2026-09-04 15:15	2026-09-04 15:15	2026-09-04 15:15	TLRY	TLRY260911P00005000	put	5.0000	2026-09-11	0.5200	0.5100	0.6100	4.5050	21736.00	0.00	21736.00	418	5	500	419	1.19331742243437	0.665774779256748	0.665774779256748	true	false	false	true	false
9a491510-7595-4196-9154-305c351d0f53	2026-09-02 11:25	2026-09-02 11:24	2026-09-02 11:24	TLRY	TLRY270115C00005000	call	5.0000	2027-01-15	0.7200	0.6800	0.7300	4.6000	14400.00	12672.00	1728.00	200	11	1158	7177	0.161348752960847	0.76299627759141	0.76299627759141	false	false	false	true	false
729f146e-4389-4f8e-93c9-abf8d1805193	2026-09-02 11:14	2026-09-02 11:14	2026-09-02 11:14	TLRY	TLRY270115C00005000	call	5.0000	2027-01-15	0.7000	0.6800	0.7200	4.5750	53060.00	47250.00	5180.00	758	18	758	7177	0.105615159537411	0.756927423473845	0.756927423473845	false	false	false	true	false
66bb134b-3ce7-4f8f-b90c-a12ae51797c5	2026-09-01 14:25	2026-09-01 14:25	2026-09-01 14:25	TLRY	TLRY280121C00005500	call	5.5000	2028-01-21	1.5500	1.3100	1.5500	4.5150	10075.00	10075.00	0.00	65	13	65	296	0.219594594594595	0.853393244927944	0.853393244927944	false	false	false	true	false
030a5bbf-bfc4-4250-b23e-fc76c2e8ce8b	2026-09-01 14:11	2026-09-01 14:11	2026-09-01 14:11	TLRY	TLRY270115C00005000	call	5.0000	2027-01-15	0.7000	0.6700	0.7100	4.5250	12950.00	420.00	12530.00	185	20	246	6928	0.0355080831408776	0.777788439923922	0.777788439923922	false	false	false	true	false
53fce306-4db8-46c0-a4c0-415f6b6d7c1e	2026-08-31 14:02	2026-08-31 14:02	2026-08-31 14:02	TLRY	TLRY261218C00007000	call	7.0000	2026-12-18	0.2500	0.2100	0.2500	4.0000	12500.00	12500.00	0.00	500	16	603	4255	0.14171562867215	0.837099415431434	0.837099415431434	false	false	false	true	false
aa405c64-7825-4ba2-9e76-7f29cd2d7fe4	2026-08-26 12:43	2026-08-26 12:43	2026-08-26 12:43	TLRY	TLRY270115C00005000	call	5.0000	2027-01-15	0.7400	0.7400	0.8200	4.6250	13764.00	0.00	13764.00	186	18	623	6101	0.102114407474185	0.748839625582744	0.748839625582744	false	false	false	true	false
881d6154-8b23-4f01-926c-9a2ff49210a0	2026-08-26 11:06	2026-08-26 11:06	2026-08-26 11:06	TLRY	TLRY270115C00005000	call	5.0000	2027-01-15	0.8600	0.8200	0.9000	4.7600	10750.00	0.00	9718.00	125	18	414	6101	0.0678577282412719	0.787802307107629	0.787802307107629	false	false	false	true	false
f9168f94-2681-4169-a18c-327a7592ef99	2026-08-26 10:00	2026-08-26 10:00	2026-08-26 10:00	TLRY	TLRY260918C00006000	call	6.0000	2026-09-18	0.0800	0.0600	0.0800	4.8000	15992.00	15992.00	0.00	1999	5	2006	5403	0.371275217471775	0.821160505577238	0.821160505577238	false	false	false	true	false
ea0131ca-f9f6-4093-ad3d-5547bdcbbc4c	2026-08-25 15:44	2026-08-25 15:44	2026-08-25 15:44	TLRY	TLRY270115C00005000	call	5.0000	2027-01-15	0.9300	0.8100	0.9300	4.9300	34503.00	34503.00	0.00	371	8	1525	4180	0.364832535885167	0.760257288697291	0.760257288697291	false	false	false	true	false
f1de3fd4-8702-4782-88bb-bcd6ce1cbacc	2026-08-25 15:41	2026-08-25 15:41	2026-08-25 15:41	TLRY	TLRY270115C00005000	call	5.0000	2027-01-15	0.9000	0.8100	0.9000	4.8700	15660.00	15660.00	0.00	174	11	525	4180	0.125598086124402	0.767278312711923	0.764812679549485	false	false	false	true	false
aab6ae88-c0a2-4e0c-b7e6-0a3552efae4c	2026-08-25 11:02	2026-08-25 11:02	2026-08-25 11:02	TLRY	TLRY260911P00005000	put	5.0000	2026-09-11	0.4100	0.3700	0.4200	4.8200	13037.00	11193.00	81.00	318	22	320	83	3.85542168674699	0.75164703271613	0.75164703271613	true	false	false	true	false
cceb31b8-154a-45e2-8922-a84bcc95dff6	2026-08-17 11:17	2026-08-17 11:17	2026-08-17 11:17	TLRY	TLRY260904P00005000	put	5.0000	2026-09-04	0.5600	0.5100	0.5600	4.5950	19264.00	19264.00	0.00	344	29	344	19	18.1052631578947	0.765627770097777	0.765627770097777	true	false	false	true	false