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 = RepeatedHitsDescendingFill×sector = Real Estate×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

e3696318-5971-4f11-a7a4-7fc1714ceb4f	2026-08-17 13:19	2026-08-17 13:19	2026-08-17 13:19	LODE	LODE270115C00004000	call	4.0000	2027-01-15	0.6500	0.6000	0.7500	3.5400	165291.00	0.00	165291.00	2551	17	10953	25	438.12	0.876827712674379	0.825470653470979	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Real Estate	203661366.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
28c4aac0-4e83-4832-9d72-d7f64d881144	2026-08-17 13:19	2026-08-17 13:19	2026-08-17 13:19	LODE	LODE270115C00004000	call	4.0000	2027-01-15	0.6000	0.6000	0.7500	3.5250	14645.00	0.00	14645.00	244	24	11323	25	452.92	0.889641293181593	0.834189434127765	false	false	false
f30316be-90e6-40d0-a132-f6ea33741a66	2026-08-17 13:26	2026-08-17 13:25	2026-08-17 13:25	LODE	LODE270115C00004000	call	4.0000	2027-01-15	0.5400	0.5000	0.6500	3.4250	42393.00	55.00	42338.00	788	29	12511	25	500.44	0.832823004900945	0.778944917617791	true	false	false
7cf3501b-5af9-4879-90ce-1d435795f9ad	2026-08-17 13:26	2026-08-17 13:25	2026-08-17 13:25	LODE	LODE270115C00004000	call	4.0000	2027-01-15	0.5400	0.5000	0.6500	3.4150	96126.00	77606.00	18520.00	1781	40	14328	25	573.12	0.825833149538906	0.841584373092423	false	false	false
8cc86610-9914-4dd2-a98a-781238b34d89	2026-08-17 13:46	2026-08-17 13:46	2026-08-17 13:46	LODE	LODE270115C00004000	call	4.0000	2027-01-15	0.5000	0.5000	0.5500	3.0000	25020.00	0.00	25020.00	500	8	14835	25	593.4	0.815624495143827	0.815624495143827	false	false	false
ec5e159f-0b20-4c52-ba29-a1c5f0d49803	2026-08-17 14:58	2026-08-17 14:58	2026-08-17 14:58	OPEN	OPEN280121C00015000	call	15.0000	2028-01-21	0.4400	0.4400	0.4900	3.4800	14675.00	0.00	14405.00	333	7	907	28430	0.0319029194512839	1.00530611930538	0.998217367246282	false	false	false
48e836c4-2863-4f87-a18e-0a94c7f8a671	2026-08-17 15:00	2026-08-17 15:00	2026-08-17 15:00	FRMI	FRMI261016C00010000	call	10.0000	2026-10-16	0.2600	0.2500	0.3000	6.1350	13054.00	0.00	13054.00	503	16	589	7741	0.0760883606769151	1.12033510454828	1.12322147200969	false	false	false
69d2079c-a3cf-4b28-bcbd-1cbcfa682e0b	2026-08-18 09:44	2026-08-18 09:44	2026-08-18 09:44	VICI	VICI270617P00027500	put	27.5000	2027-06-17	3.1000	2.8000	3.1000	26.0000	30378.00	30378.00	0.00	98	11	139	3326	0.0417919422730006	0.30252879578161	0.30252879578161	false	false	false
5191c235-1109-41e1-871f-9076cab11d52	2026-08-18 10:37	2026-08-18 10:37	2026-08-18 10:37	HASI	HASI261120C00040000	call	40.0000	2026-11-20	3.6600	3.5000	4.5000	41.7600	25590.00	0.00	25590.00	70	5	70	353	0.198300283286119	0.295341602627734	0.295341602627734	false	false	false
73d9ab67-4d5f-44cd-8371-900dbfc7c69f	2026-08-18 10:52	2026-08-18 10:52	2026-08-18 10:52	FRMI	FRMI280121C00010000	call	10.0000	2028-01-21	2.0900	2.0500	2.2000	5.9300	10440.00	0.00	10440.00	50	6	68	5689	0.011952891545087	1.0660701818938	1.0660701818938	false	false	false
749506b7-0372-49b5-985f-b6906c5f85fc	2026-08-18 14:37	2026-08-18 14:37	2026-08-18 14:37	OPEN	OPEN280121C00005000	call	5.0000	2028-01-21	1.1900	1.1700	1.1900	3.4100	52174.00	52174.00	0.00	439	13	879	35971	0.0244363515053793	0.973446936406397	0.971452806638371	true	false	false
9f885fae-3ab7-4bea-94ae-fccbccde96eb	2026-08-18 15:36	2026-08-18 15:36	2026-08-18 15:36	FRMI	FRMI260821C00005500	call	5.5000	2026-08-21	0.4000	0.3500	0.4000	5.7850	19995.00	19995.00	0.00	500	56	516	65	7.93846153846154	1.14067856851862	1.12110954938917	false	false	false
b63bdaea-5a5a-405b-b29d-f265c10e971a	2026-08-19 09:33	2026-08-19 09:33	2026-08-19 09:33	BEKE	BEKE280121C00015000	call	15.0000	2028-01-21	4.7500	4.7000	5.1000	17.1700	18994.00	0.00	18994.00	40	8	90	211	0.42654028436019	0.409126161978137	0.409126161978137	false	false	false
768bdd91-c97d-49b7-9ffa-f44de3b38f68	2026-08-19 09:39	2026-08-19 09:39	2026-08-19 09:39	OPEN	OPEN270219C00006000	call	6.0000	2027-02-19	0.4300	0.3500	0.4300	3.5400	12780.00	12780.00	0.00	300	10	302	938	0.321961620469083	0.994127172891679	0.961920916764973	false	false	false
0612a684-0dca-4ab4-ae12-95389588ad4c	2026-08-19 09:48	2026-08-19 09:48	2026-08-19 09:48	FRMI	FRMI270115C00010000	call	10.0000	2027-01-15	0.6500	0.6000	0.7000	5.5275	399136.00	395762.00	3374.00	6144	60	6198	49428	0.125394513231367	1.16570242094966	1.15544113348618	false	false	false
c08b543a-8360-4291-bf39-dd600da7df50	2026-08-19 09:49	2026-08-19 09:49	2026-08-19 09:49	FRMI	FRMI270115C00010000	call	10.0000	2027-01-15	0.7000	0.6000	0.7500	5.5450	962286.00	959626.00	0.00	13756	98	20054	49428	0.405721453427207	1.18907807641185	1.18907807641185	false	false	false
d0710229-c20c-4853-9e34-80d3881d6693	2026-08-19 10:59	2026-08-19 10:59	2026-08-19 10:59	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.3000	2.2500	2.3500	33.3800	80855.00	0.00	9325.00	352	20	675	11689	0.0577465993669262	0.535213089682498	0.529695171173916	false	false	false
6e0f4de8-e8f3-4313-bbef-38f6178db3bf	2026-08-19 11:01	2026-08-19 11:01	2026-08-19 11:01	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.3800	2.2500	2.4500	33.5200	78810.00	1680.00	30405.00	331	26	2404	11689	0.205663444263838	0.541217036743902	0.535773444198979	false	false	false
858f5ef3-c8dc-4420-873c-4f2eabe55eea	2026-08-19 11:01	2026-08-19 11:01	2026-08-19 11:01	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	2.4000	2.2000	2.4000	33.5800	84795.00	77040.00	7755.00	354	19	2888	11689	0.247069894772863	0.539094450692146	0.533662958696721	false	false	false
ff9eec29-94a6-47d9-9043-3d93f531a645	2026-08-19 11:44	2026-08-19 11:44	2026-08-19 11:44	GEO	GEO260918C00030000	call	30.0000	2026-09-18	2.1700	1.7500	2.2000	30.7900	26070.00	26070.00	0.00	120	11	268	2597	0.103195995379284	0.496722020335047	0.48196603863336	false	false	false
89526c72-dd01-495f-86c6-b7de557f377b	2026-08-19 12:46	2026-08-19 12:46	2026-08-19 12:46	CSGP	CSGP260918P00030000	put	30.0000	2026-09-18	0.7500	0.6500	0.7500	33.4850	17232.00	17232.00	0.00	230	28	512	4651	0.110083852934853	0.570664816282012	0.570664816282012	true	false	false
7daa24c0-dac7-4499-bc31-96c19155fab2	2026-08-19 15:06	2026-08-19 15:06	2026-08-19 15:06	CSGP	CSGP260918P00030000	put	30.0000	2026-09-18	0.7000	0.6000	0.7000	33.6650	17278.00	17278.00	0.00	247	42	909	4651	0.195441840464416	0.566604021619459	0.566604021619459	true	false	false
25f5de8d-1ea2-4a68-850e-fdbc9e70c932	2026-08-19 15:37	2026-08-19 15:36	2026-08-19 15:36	ARE	ARE261016C00052500	call	52.5000	2026-10-16	2.1800	2.1500	2.2500	50.6400	45461.00	23301.00	22160.00	209	29	323	696	0.464080459770115	0.355791041861623	0.355791041861623	false	false	false
8485f920-4811-4dd9-83a0-8a61a214ca66	2026-08-19 15:48	2026-08-19 15:48	2026-08-19 15:48	FRMI	FRMI261218C00015000	call	15.0000	2026-12-18	0.3000	0.2500	0.3000	5.7750	111239.00	111239.00	0.00	3709	40	3710	7480	0.495989304812834	1.27088858029609	1.26677948296697	false	false	false
ae6f40be-5354-421f-89ba-9e054c23fe0c	2026-08-20 09:42	2026-08-20 09:41	2026-08-20 09:41	AGNC	AGNC261218C00010000	call	10.0000	2026-12-18	1.1400	0.9200	1.1800	11.0650	64946.00	64605.00	341.00	569	61	1065	6698	0.159002687369364	0.122639120176442	0.122639120176442	true	false	false
3b555414-f058-490d-9796-02bc76dd00c1	2026-08-20 09:42	2026-08-20 09:41	2026-08-20 09:41	AGNC	AGNC261016C00010000	call	10.0000	2026-10-16	1.1900	1.1400	1.5400	11.0650	83186.00	28548.00	42738.00	699	45	4307	0	0	0.252650006863596	0.217219868706236	true	false	false
5411c56f-c404-4d67-8e62-a678375b91e7	2026-08-20 09:42	2026-08-20 09:42	2026-08-20 09:42	AGNC	AGNC261016C00010000	call	10.0000	2026-10-16	1.1800	0.3400	1.5500	11.0700	20785.00	4522.00	16263.00	176	7	5088	0	0	0.236500048425441	0.268997426881726	true	false	false
669a0f64-4e8d-4eb9-80cc-a297c9b0c9b7	2026-08-20 09:42	2026-08-20 09:42	2026-08-20 09:42	AGNC	AGNC261016C00011000	call	11.0000	2026-10-16	0.4600	0.1700	0.7000	11.0650	32395.00	6042.00	26353.00	702	12	5397	0	0	0.266511005503409	0.266511005503409	true	false	false
271c2fcc-41f9-489b-a202-352dfe711e53	2026-08-20 10:30	2026-08-20 10:30	2026-08-20 10:30	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7600	1.7500	1.8000	31.8800	12839.00	3564.00	9275.00	73	6	19171	14624	1.3109272428884	0.528954572408575	0.523992723552048	false	false	false
4c5e6d80-f706-4d7a-be0c-aad8b41e1bf2	2026-08-20 10:34	2026-08-20 10:34	2026-08-20 10:34	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7600	1.7500	1.8000	31.8200	10392.00	2672.00	7720.00	59	15	19406	14624	1.32699671772429	0.530995186709554	0.530995186709554	false	false	false
d02950b9-b7bd-4524-9bdc-7db4fe3ad2b2	2026-08-20 10:42	2026-08-20 10:42	2026-08-20 10:42	OHI	OHI260918P00045000	put	45.0000	2026-09-18	0.5000	0.2500	0.6000	47.0100	55524.00	55524.00	0.00	1111	59	1118	189	5.91534391534392	0.251876251730196	0.251876251730196	false	false	false
4521c85c-fb8a-4b23-a61a-ee91950eddff	2026-08-20 11:08	2026-08-20 11:08	2026-08-20 11:08	CSGP	CSGP270319C00045000	call	45.0000	2027-03-19	1.7500	1.7000	1.8000	31.8600	74921.00	1246.00	21875.00	428	7	20684	14624	1.41438730853392	0.527716754517745	0.524668677006807	false	false	false
4b755a9c-f467-4f6b-bdd4-51de03d12786	2026-08-20 13:10	2026-08-20 13:10	2026-08-20 13:10	CSGP	CSGP270319P00035000	put	35.0000	2027-03-19	6.1600	6.0000	6.4000	32.2900	83839.00	0.00	83839.00	136	5	200	118	1.69491525423729	0.515001262727215	0.515001262727215	false	false	false
2ac9b650-b38b-4770-8bfb-1ee6bd9f569f	2026-08-20 13:11	2026-08-20 13:11	2026-08-20 13:11	CSGP	CSGP270319P00035000	put	35.0000	2027-03-19	6.1400	6.0000	6.3000	32.2800	80416.00	30800.00	42236.00	131	6	400	118	3.38983050847458	0.513487364239824	0.513487364239824	false	false	false
0a869f14-0ba0-4572-80ff-63ab19d19551	2026-08-20 14:44	2026-08-20 14:43	2026-08-20 14:43	ARE	ARE261016P00050000	put	50.0000	2026-10-16	2.4900	2.3000	2.5000	51.6600	32428.00	32428.00	0.00	130	15	1086	3849	0.282151208106002	0.424675618743649	0.423385641438778	false	false	false
0fb6466e-884e-43c5-9104-c76f5de25a99	2026-08-21 09:43	2026-08-21 09:43	2026-08-21 09:43	OPEN	OPEN280915C00007000	call	7.0000	2028-09-15	1.2500	1.2300	1.3700	3.4900	21193.00	1750.00	19443.00	170	5	180	5549	0.0324382771670571	0.960410871367283	0.943462787578497	true	false	false
1af5e372-5623-4ca9-be62-7aed342377fd	2026-08-21 09:46	2026-08-21 09:45	2026-08-21 09:45	SLG	SLG260821C00052500	call	52.5000	2026-08-21	5.8700	5.1000	7.4000	58.8700	82138.00	0.00	82138.00	140	14	140	653	0.214395099540582	5.53624726147049	5.53624726147049	false	false	false
ab557b32-e8c7-4f61-89b2-550e735822bc	2026-08-21 11:44	2026-08-21 11:43	2026-08-21 11:43	FRMI	FRMI261016C00006000	call	6.0000	2026-10-16	1.0500	1.0000	1.0500	6.0650	20019.00	20019.00	0.00	191	13	369	916	0.402838427947598	1.07170760466387	1.06010901389655	false	false	false
256025c4-ef84-45d5-a59a-0703f4da4ef0	2026-08-21 14:01	2026-08-21 14:01	2026-08-21 14:01	GEO	GEO260821C00029000	call	29.0000	2026-08-21	3.4000	3.2000	3.6000	32.4400	276471.00	48840.00	198391.00	812	60	1038	2530	0.410276679841897	5.40699772302236	1.09723600550926	true	false	false
524cf2a8-29a1-419e-a180-644bc55734dc	2026-08-21 14:47	2026-08-21 14:47	2026-08-21 14:47	GEO	GEO260821C00029000	call	29.0000	2026-08-21	3.3700	3.1000	3.4000	32.4000	180490.00	88365.00	0.00	536	48	1575	2530	0.622529644268775	4.94846925357097	1.93211433629042	false	false	false
9277e10c-7fd5-43e4-8432-a5d290681747	2026-08-21 15:32	2026-08-21 15:32	2026-08-21 15:32	FRMI	FRMI260821C00005500	call	5.5000	2026-08-21	0.4000	0.4000	0.4500	5.9250	12850.00	0.00	12850.00	321	19	754	785	0.960509554140127	9.14943661371336	9.14943661371336	false	false	false
b7d5278a-894c-4a84-b15c-092d66a4b936	2026-08-21 15:51	2026-08-21 15:51	2026-08-21 15:51	FRMI	FRMI260904P00005500	put	5.5000	2026-09-04	0.2100	0.2000	0.2500	5.9499	21002.00	0.00	21002.00	1000	8	2011	150	13.4066666666667	0.916294114292504	0.916294114292504	false	false	false
0ec8dc24-93e8-4653-afe1-ff8343c2fa8c	2026-08-24 09:43	2026-08-24 09:43	2026-08-24 09:43	FRMI	FRMI260828C00005500	call	5.5000	2026-08-28	0.3300	0.3000	0.5500	5.6750	14038.00	0.00	14038.00	420	9	422	1600	0.26375	1.07854303394546	1.07854303394546	false	false	false
df69fdc8-3554-4497-81d4-5f2d143001d3	2026-08-24 13:59	2026-08-24 13:59	2026-08-24 13:59	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.6400	0.5900	0.6400	3.4800	31900.00	31900.00	0.00	500	8	1218	8753	0.139152290643208	0.928140837891308	0.905144030050411	false	false	false
772b3abf-22d2-4aa4-a728-d0456cdee32c	2026-08-24 14:42	2026-08-24 14:42	2026-08-24 14:42	O	O260918P00062500	put	62.5000	2026-09-18	0.8100	0.8000	0.9000	62.8950	81012.00	172.00	80840.00	1000	7	1401	3326	0.421226698737222	0.17081966357098	0.17081966357098	false	false	false
270848dc-a6a9-4a24-aed3-e135d0e139ab	2026-08-25 10:14	2026-08-25 10:14	2026-08-25 10:14	VICI	VICI260918P00027500	put	27.5000	2026-09-18	1.5000	1.2500	1.5000	26.4500	14091.00	14091.00	0.00	94	9	275	1897	0.144965735371639	0.336786388179833	0.332811621201571	false	false	false
c2313c48-b03b-4e8f-a77a-51ae7ed11416	2026-08-25 12:05	2026-08-25 12:05	2026-08-25 12:05	DLR	DLR261016P00190000	put	190.0000	2026-10-16	6.3000	5.9000	6.3000	192.9300	200326.00	200326.00	0.00	318	43	319	227	1.40528634361233	0.282723665874125	0.282723665874125	false	false	false
43b903a0-67c5-40fb-b948-fb2914c81a4c	2026-08-25 13:35	2026-08-25 13:35	2026-08-25 13:35	FRMI	FRMI260828C00006000	call	6.0000	2026-08-28	0.2500	0.2000	0.3000	6.0100	10565.00	10425.00	140.00	423	11	2752	2517	1.09336511720302	1.12419915594269	1.12419915594269	false	false	false
9ff089da-f6a5-44b5-95b4-37d7d0a7da16	2026-08-26 11:02	2026-08-26 11:02	2026-08-26 11:02	VICI	VICI280121P00025000	put	25.0000	2028-01-21	2.4400	2.4000	2.5000	26.1300	16810.00	12250.00	4560.00	69	10	199	2044	0.0973581213307241	0.306743874300193	0.302235438109546	false	false	false
dacbae12-6df0-4904-811e-14b71bf61a11	2026-08-26 14:12	2026-08-26 14:12	2026-08-26 14:12	VICI	VICI270617P00027500	put	27.5000	2027-06-17	3.2000	3.0000	3.3000	26.0700	18865.00	18233.00	632.00	59	6	557	4671	0.119246414044102	0.309511870259171	0.309511870259171	false	false	false