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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×sector = Real Estate×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

1222b7b7-30fc-4ea9-8999-79293aab5aac	2026-08-26 15:16	2026-08-26 15:16	2026-08-26 15:16	WELL	WELL261218C00250000	call	250.0000	2026-12-18	10.7000	10.7000	11.7000	242.6600	95230.00	0.00	95230.00	89	15	89	416	0.213942307692308	0.233649277933421	0.233649277933421	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	168805674974.00	2026-10-26	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-26T19:41:15.773512Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
5f3455c2-f140-4996-87b8-dd46a083bb61	2026-08-26 15:06	2026-08-26 15:06	2026-08-26 15:06	FRMI	FRMI261120C00006000	call	6.0000	2026-11-20	1.0500	1.0500	1.1500	5.6650	10500.00	0.00	10500.00	100	5	148	8461	0.0174920222195958	1.066120661229	1.066120661229	false	false	false	true
6e9061e3-8e05-4315-b7f0-97aff8f7e76f	2026-08-26 14:48	2026-08-26 14:48	2026-08-26 14:48	AGNC	AGNC261002C00011000	call	11.0000	2026-10-02	0.1400	0.1400	0.1800	10.8400	13986.00	0.00	13986.00	999	11	1100	4022	0.273495773247141	0.13981619597219	0.13981619597219	false	false	false	true
1e670b57-1433-4112-8dcf-3e6596e72118	2026-08-26 13:49	2026-08-26 13:49	2026-08-26 13:49	WELL	WELL270521C00230000	call	230.0000	2027-05-21	29.2000	29.2000	30.2000	242.0950	151840.00	0.00	151840.00	52	25	160	5	32	0.230609964416302	0.230609964416302	true	false	false	true
ca178da6-0ed8-4ec3-a906-726e791d1a10	2026-08-26 13:44	2026-08-26 13:44	2026-08-26 13:44	WELL	WELL270319C00220000	call	220.0000	2027-03-19	32.6000	32.6000	34.2000	242.1000	146700.00	0.00	146700.00	45	21	157	2	78.5	0.227349311872208	0.227349311872208	true	false	false	true
0fcf7615-c57a-44bf-be3c-b5e64e14bb1b	2026-08-26 13:43	2026-08-26 13:43	2026-08-26 13:43	FRMI	FRMI261120C00015000	call	15.0000	2026-11-20	0.1200	0.1000	0.2000	5.7273	13441.00	0.00	13441.00	1126	7	1127	48055	0.0234522942461763	1.17527170965676	1.2410530395286	false	false	false	true
61d54708-cf8e-42ae-8c4e-ff0fb650f726	2026-08-26 13:10	2026-08-26 13:10	2026-08-26 13:10	O	O261016P00060000	put	60.0000	2026-10-16	0.6500	0.6000	0.7000	62.4750	74360.00	130.00	74230.00	1144	33	1201	428	2.80607476635514	0.185868245424183	0.185868245424183	false	false	false	true
18626589-071f-418d-8719-1fdecda6db9b	2026-08-26 13:06	2026-08-26 13:06	2026-08-26 13:06	WELL	WELL261218C00260000	call	260.0000	2026-12-18	6.8000	6.8000	8.8000	241.8900	103360.00	0.00	103360.00	152	15	153	172	0.88953488372093	0.232787940794407	0.232787940794407	false	false	false	true
7be8378c-3a4a-4536-8cf4-0f659a683883	2026-08-26 13:06	2026-08-26 13:05	2026-08-26 13:05	OPEN	OPEN280915C00007000	call	7.0000	2028-09-15	1.2100	1.2000	1.2800	3.4200	12221.00	0.00	12221.00	101	11	563	7288	0.0772502744237102	0.963067452773444	0.963067452773444	true	false	false	true
117426bb-fb99-4376-a984-e8bf5da0868c	2026-08-26 13:06	2026-08-26 13:05	2026-08-26 13:05	OPEN	OPEN280915C00007000	call	7.0000	2028-09-15	1.2100	1.1900	1.2800	3.4300	12221.00	1210.00	11011.00	101	11	674	7288	0.0924807903402854	0.959985043984324	0.959985043984324	true	false	false	true
9b07b044-ba5b-4a17-b5fe-8db277d19d8d	2026-08-26 13:06	2026-08-26 13:05	2026-08-26 13:05	OPEN	OPEN280915C00007000	call	7.0000	2028-09-15	1.2100	1.1600	1.2900	3.4300	14520.00	1210.00	13310.00	120	12	453	7288	0.0621569703622393	0.959985043984324	0.959985043984324	true	false	false	true
aef72b7a-54c7-4581-8aa2-e584aafa535c	2026-08-26 12:04	2026-08-26 12:04	2026-08-26 12:04	BEKE	BEKE261218P00020000	put	20.0000	2026-12-18	2.7500	2.6000	2.7500	17.9250	46475.00	46475.00	0.00	169	6	169	260	0.65	0.39760860506005	0.39760860506005	false	false	false	true
f3fa89d3-4ed0-4da5-b002-2f1a03b72b44	2026-08-26 11:57	2026-08-26 11:57	2026-08-26 11:57	OPEN	OPEN260828C00003000	call	3.0000	2026-08-28	0.4300	0.4300	0.4500	3.4300	12384.00	0.00	12384.00	288	8	908	1202	0.75540765391015	1.49454377921652	1.49454377921652	false	false	false	true
cfd32bc6-4e9a-47a0-b9f7-975ea6f15673	2026-08-26 11:47	2026-08-26 11:47	2026-08-26 11:47	WELL	WELL270521P00220000	put	220.0000	2027-05-21	9.2000	9.2000	9.9000	241.7300	57980.00	940.00	57040.00	63	6	498	21	23.7142857142857	0.260264030459757	0.263737078707971	true	false	false	true
2c1d6699-fdb0-4780-a116-d56737689ef6	2026-08-26 11:45	2026-08-26 11:45	2026-08-26 11:45	EQIX	EQIX261120C01170000	call	1170.0000	2026-11-20	35.6000	33.7000	35.6000	1078.2675	121040.00	121040.00	0.00	34	13	34	0	0	0.317445065292623	0.317445065292623	false	false	false	true
396d0ba5-910f-401b-b24f-d2297e8f6232	2026-08-26 11:39	2026-08-26 11:39	2026-08-26 11:39	IRM	IRM261016C00135000	call	135.0000	2026-10-16	1.5000	1.3000	1.5000	121.6250	45750.00	45750.00	0.00	305	34	307	765	0.401307189542484	0.301504059576064	0.301504059576064	false	false	false	true
a605d4d8-ccb5-4c4c-9dd6-964147100d86	2026-08-26 11:37	2026-08-26 11:37	2026-08-26 11:37	WELL	WELL270521P00220000	put	220.0000	2027-05-21	9.1000	9.1000	10.7000	241.7750	52780.00	0.00	52780.00	58	13	99	21	4.71428571428571	0.259383215187811	0.259383215187811	true	false	false	true
32183c8f-5eab-4107-88e5-d023a89a9f0c	2026-08-26 11:37	2026-08-26 11:37	2026-08-26 11:37	WELL	WELL270521P00240000	put	240.0000	2027-05-21	16.2100	16.2000	17.9000	241.8250	121550.00	0.00	121550.00	75	21	587	0	0	0.250518980833683	0.250518980833683	true	false	false	true
b558e2c4-40a1-4a21-9f4c-4808e97e6e82	2026-08-26 11:36	2026-08-26 11:36	2026-08-26 11:36	WELL	WELL270319C00230000	call	230.0000	2027-03-19	25.9000	25.9000	27.6000	241.4800	176120.00	0.00	176120.00	68	11	70	3	23.3333333333333	0.233760221954196	0.233760221954196	true	false	false	true
787a39d1-ace1-4e04-a20b-5f163dd84b3a	2026-08-26 11:36	2026-08-26 11:36	2026-08-26 11:36	WELL	WELL270521C00250000	call	250.0000	2027-05-21	18.8000	18.8000	20.1000	241.4800	295160.00	0.00	295160.00	157	20	268	80	3.35	0.235116890203204	0.235116890203204	true	false	false	true
0a0a51b2-3481-464a-ada3-f37b41c65cf4	2026-08-26 11:36	2026-08-26 11:36	2026-08-26 11:36	WELL	WELL270319P00230000	put	230.0000	2027-03-19	10.8000	10.8000	11.8000	241.4800	64800.00	0.00	64800.00	60	12	106	2	53	0.257101824558185	0.257101824558185	true	false	false	true
b67d26fb-2322-4a89-8376-481fe3d00c99	2026-08-26 11:32	2026-08-26 11:32	2026-08-26 11:32	WELL	WELL270521P00240000	put	240.0000	2027-05-21	16.8000	16.8000	19.1000	241.6000	164640.00	0.00	164640.00	98	15	98	0	0	0.256957931271017	0.256957931271017	true	false	false	true
51587f52-7877-476d-8a70-ef5f50e685a3	2026-08-26 11:10	2026-08-26 11:10	2026-08-26 11:10	UNIT	UNIT260918C00012000	call	12.0000	2026-09-18	0.1000	0.0500	0.1000	10.1200	34320.00	34320.00	0.00	3432	28	3433	2	1716.5	0.592476839673341	0.582545942359776	false	false	false	true
bd9a25cc-744f-44b1-97fb-e5613e5a19ae	2026-08-26 11:04	2026-08-26 11:04	2026-08-26 11:04	REAX	REAX270115C00030000	call	30.0000	2027-01-15	4.0000	3.8000	4.8000	26.4450	50000.00	0.00	50000.00	125	28	137	0	0	0.784958320136674	0.784958320136674	true	false	false	true
6443b818-eafa-4e60-a610-625859136876	2026-08-26 10:21	2026-08-26 10:20	2026-08-26 10:20	STWD	STWD261218P00017000	put	17.0000	2026-12-18	1.4000	1.3500	1.4000	16.0650	19600.00	1680.00	0.00	140	18	210	4218	0.0497866287339972	0.271322332061382	0.271322332061382	false	false	false	true
e5619a2e-3a65-46fe-8683-f6d5c73477e1	2026-08-25 15:57	2026-08-25 15:57	2026-08-25 15:57	FRMI	FRMI261016C00007000	call	7.0000	2026-10-16	0.6500	0.6000	0.6500	5.9750	26000.00	26000.00	0.00	400	5	1249	3885	0.321492921492921	1.11086611693659	1.11086611693659	false	false	false	true
0fcc4b16-dbc8-4213-a604-124ad6d94282	2026-08-25 15:57	2026-08-25 15:57	2026-08-25 15:57	OPEN	OPEN260918C00003500	call	3.5000	2026-09-18	0.3000	0.2900	0.3000	3.5700	15000.00	15000.00	0.00	500	5	1802	102	17.6666666666667	0.717418259755688	0.717418259755688	false	false	false	true
a7c761c3-6fb2-42ec-96dc-cde0e03cedb2	2026-08-25 15:31	2026-08-25 15:31	2026-08-25 15:31	DOC	DOC280121C00022500	call	22.5000	2028-01-21	2.2500	0.9000	2.5000	21.7000	15750.00	2700.00	13050.00	70	9	171	395	0.432911392405063	0.196216973598256	0.196216973598256	false	false	false	true
0858f3bc-8459-43d1-8d58-56479db47002	2026-08-25 15:31	2026-08-25 15:31	2026-08-25 15:31	DOC	DOC280121C00022500	call	22.5000	2028-01-21	2.2600	2.2500	2.5000	21.7000	22776.00	0.00	22776.00	101	12	101	395	0.255696202531646	0.196216973598256	0.196216973598256	false	false	false	true
79a1fee5-5b8c-4bba-b3a9-3401a4143757	2026-08-25 15:27	2026-08-25 15:27	2026-08-25 15:27	SKYH	SKYH270115C00010000	call	10.0000	2027-01-15	1.4000	1.4000	1.5500	10.6000	10360.00	0.00	10360.00	74	15	209	311	0.672025723472669	0.383853262420735	0.383853262420735	false	false	false	true
96047ed7-8310-4bd4-8156-03948770cc99	2026-08-25 15:19	2026-08-25 15:19	2026-08-25 15:19	EQIX	EQIX261218C01140000	call	1140.0000	2026-12-18	54.7000	52.8000	54.9000	1076.3800	443070.00	443070.00	0.00	81	20	181	25	7.24	0.312746165066492	0.312746165066492	false	false	false	true
ef5816f0-a6c9-428f-a81b-255713f786bc	2026-08-25 15:12	2026-08-25 15:11	2026-08-25 15:11	CXW	CXW270319P00035000	put	35.0000	2027-03-19	5.3000	5.1000	5.3000	33.1000	21200.00	21200.00	0.00	40	8	52	4	13	0.470792830768278	0.470792830768278	true	false	false	true
b8a322cc-beb9-45a5-9c0c-d9c268aa5cbe	2026-08-25 15:10	2026-08-25 15:10	2026-08-25 15:10	FRMI	FRMI261120P00006000	put	6.0000	2026-11-20	1.2000	1.2000	1.3000	5.9850	11520.00	0.00	11520.00	96	6	513	9201	0.0557548092598631	1.06182111895973	1.06182111895973	false	false	false	true
c929a516-2b7e-4468-a9a1-be2018ac152f	2026-08-25 15:09	2026-08-25 15:09	2026-08-25 15:09	SUI	SUI261016P00120000	put	120.0000	2026-10-16	2.0000	1.9000	4.5000	125.6725	64400.00	2000.00	62400.00	322	13	611	5	122.2	0.242271791341102	0.242271791341102	false	false	false	true
02a4007c-b8b2-41e8-bc96-88b98faafdc4	2026-08-25 15:08	2026-08-25 15:08	2026-08-25 15:08	SUI	SUI261016P00120000	put	120.0000	2026-10-16	2.0000	1.7000	4.5000	125.4700	44800.00	1800.00	43000.00	224	13	289	5	57.8	0.238765977928377	0.238765977928377	false	false	false	true
3ef62cea-a672-436d-bffd-737b2d0c6875	2026-08-25 15:00	2026-08-25 15:00	2026-08-25 15:00	OPEN	OPEN270115P00004000	put	4.0000	2027-01-15	1.0200	1.0000	1.0300	3.5650	26826.00	26826.00	0.00	263	5	503	5771	0.0871599376191301	0.887054921975403	0.887054921975403	false	false	false	true
e9e6fe27-a2d7-4b0e-b9a2-d9e52d85e51c	2026-08-25 14:42	2026-08-25 14:42	2026-08-25 14:42	PLD	PLD261016P00135000	put	135.0000	2026-10-16	2.2000	2.0500	2.3000	143.3500	64900.00	8360.00	56540.00	295	13	311	486	0.639917695473251	0.268559600983668	0.268559600983668	false	false	false	true
eb97c05f-f8ca-4cbb-b5c4-ba54a55a053a	2026-08-25 14:22	2026-08-25 14:22	2026-08-25 14:22	OPEN	OPEN261120C00004000	call	4.0000	2026-11-20	0.4600	0.4400	0.4800	3.0000	55798.00	32844.00	11638.00	1213	15	2363	12772	0.185014093329158	0.890339100538043	0.890339100538043	false	false	false	true
266d7821-dd25-4422-9a8f-4246fd9012a6	2026-08-25 14:10	2026-08-25 14:10	2026-08-25 14:10	WPC	WPC261016C00075000	call	75.0000	2026-10-16	0.5000	0.4500	0.5000	71.0000	28900.00	19400.00	0.00	578	17	1926	534	3.60674157303371	0.140772450123511	0.140772450123511	false	false	false	true
52cb2a25-3c37-4a3a-8211-d2cc60c84d87	2026-08-25 14:10	2026-08-25 14:10	2026-08-25 14:10	WPC	WPC261016C00075000	call	75.0000	2026-10-16	0.5000	0.5000	0.7500	71.0000	23750.00	0.00	15800.00	475	40	1348	534	2.52434456928839	0.139507102286395	0.139507102286395	true	false	false	true
255ea248-eece-40f6-85fd-1cdc8363adce	2026-08-25 14:00	2026-08-25 14:00	2026-08-25 14:00	DEI	DEI261016C00012500	call	12.5000	2026-10-16	0.4000	0.2000	0.5500	12.0000	30880.00	1920.00	28960.00	772	18	772	4340	0.177880184331797	0.281039772095093	0.278845083722022	false	false	false	true
223579a2-55f2-4748-885a-6c0056d03c94	2026-08-25 13:57	2026-08-25 13:57	2026-08-25 13:57	FRMI	FRMI261120P00006000	put	6.0000	2026-11-20	1.2500	1.2500	1.3000	5.9650	10750.00	0.00	10750.00	86	5	307	9201	0.0333659384849473	1.09942304332232	1.09942304332232	false	false	false	true
f603db61-927b-43f4-ad91-6121c36bb4aa	2026-08-25 13:40	2026-08-25 13:40	2026-08-25 13:40	BEKE	BEKE261218C00017000	call	17.0000	2026-12-18	2.1500	2.0000	2.1500	17.8750	34830.00	34830.00	0.00	162	7	162	458	0.353711790393013	0.400001984043809	0.400001984043809	false	false	false	true
3467327b-ecce-49a6-b884-c574cc495edc	2026-08-25 13:39	2026-08-25 13:39	2026-08-25 13:39	DLR	DLR270319P00160000	put	160.0000	2027-03-19	5.7000	5.2000	5.8000	192.2900	82650.00	31920.00	17670.00	145	34	900	21	42.8571428571429	0.352880548733045	0.352880548733045	false	false	false	true
7169dd1d-2cfa-4158-ada8-78ab05285a52	2026-08-25 13:35	2026-08-25 13:35	2026-08-25 13:35	GEO	GEO260918C00033000	call	33.0000	2026-09-18	1.2000	1.0000	1.2000	32.1600	30000.00	30000.00	0.00	250	5	2135	1189	1.79562657695542	0.469222938930472	0.465805742171627	false	false	false	true
4331e76b-1ad6-44e4-9e77-20a0898a22b7	2026-08-25 13:24	2026-08-25 13:24	2026-08-25 13:24	ADC	ADC260918C00075000	call	75.0000	2026-09-18	0.9500	0.9000	1.2500	74.3900	18905.00	0.00	18905.00	199	7	203	161	1.26086956521739	0.150603648211048	0.150603648211048	false	false	false	true
83a907a8-8a6f-4bed-85ef-f430514777df	2026-08-25 13:19	2026-08-25 13:19	2026-08-25 13:19	CSGP	CSGP261218C00035000	call	35.0000	2026-12-18	3.1000	3.0000	3.1000	32.8650	12400.00	12400.00	0.00	40	16	79	175	0.451428571428571	0.517689550228654	0.517689550228654	false	false	false	true
d38a24e8-cd47-48d6-a7fc-8a679456e3c1	2026-08-25 13:17	2026-08-25 13:16	2026-08-25 13:16	DLR	DLR270617P00160000	put	160.0000	2027-06-17	7.9000	7.9000	8.9000	192.4600	73470.00	0.00	73470.00	93	8	600	200	3	0.350999649246715	0.350999649246715	false	false	false	true
a873ac51-4898-4662-925b-a3802137761c	2026-08-25 13:06	2026-08-25 13:06	2026-08-25 13:06	DLR	DLR280121P00160000	put	160.0000	2028-01-21	12.4000	12.4000	13.0000	192.2500	101680.00	0.00	101680.00	82	27	107	10	10.7	0.355072235278072	0.355072235278072	false	false	false	true
fd2a2d32-e79c-4263-9ea2-c1eb9e19a281	2026-08-25 13:06	2026-08-25 13:06	2026-08-25 13:06	DLR	DLR270617P00160000	put	160.0000	2027-06-17	7.9000	7.9000	9.0000	192.2800	55300.00	0.00	7110.00	70	41	496	200	2.48	0.350258831253404	0.350258831253404	false	false	false	true