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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:sector = Consumer Defensive×ticker = PM×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

ac8655a7-321f-4d28-b027-1e2cb06ac882	2026-08-17 10:14	2026-08-17 10:14	2026-08-17 10:14	PM	PM260918P00180000	put	180.0000	2026-09-18	2.9000	2.5500	2.9000	186.9200	157974.00	157974.00	0.00	545	34	555	585	0.948717948717949	0.273514257287282	0.273514257287282	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	303711414724.00	2026-10-20	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
9c80eebe-8f6a-4601-a2bd-581706804c7a	2026-08-17 13:22	2026-08-17 13:22	2026-08-17 13:22	PM	PM260828P00190000	put	190.0000	2026-08-28	6.3000	5.8000	6.3000	185.4900	67410.00	67410.00	0.00	107	11	107	53	2.0188679245283	0.290236374460978	0.290236374460978	false	false	false	true
a79a438d-218f-45bf-8afd-98c789fa7010	2026-08-19 10:46	2026-08-19 10:45	2026-08-19 10:45	PM	PM261120C00210000	call	210.0000	2026-11-20	4.0000	3.9000	4.2000	188.5900	82000.00	800.00	81200.00	205	6	208	728	0.285714285714286	0.279124012814925	0.278230182187863	false	false	false	true
866d0b11-8b83-4e5c-86f7-a05f30a46c8b	2026-08-19 12:02	2026-08-19 12:02	2026-08-19 12:02	PM	PM260828P00190000	put	190.0000	2026-08-28	4.6000	4.3000	4.6000	187.5500	88780.00	88780.00	0.00	193	17	212	133	1.59398496240601	0.282694983913419	0.282694983913419	false	false	false	true
aa9bc850-748b-47d9-afc4-8fd0eff40e23	2026-08-19 12:41	2026-08-19 12:41	2026-08-19 12:41	PM	PM260828P00190000	put	190.0000	2026-08-28	4.2000	3.9000	4.2000	187.9750	73080.00	73080.00	0.00	174	7	626	133	4.70676691729323	0.269698343003407	0.269698343003407	false	false	false	true
99e1f2f6-ff3b-4f75-bb9e-1924251e985b	2026-08-20 10:59	2026-08-20 10:59	2026-08-20 10:59	PM	PM260828P00187500	put	187.5000	2026-08-28	1.8500	1.8500	2.6500	190.4000	64010.00	0.00	64010.00	346	23	346	43	8.04651162790698	0.281881761627111	0.281881761627111	false	false	false	true
8f4307c0-58c4-4cbf-91a7-0a4a4126aae7	2026-08-20 14:18	2026-08-20 14:18	2026-08-20 14:18	PM	PM260904C00192500	call	192.5000	2026-09-04	4.9000	4.9000	5.3000	193.3850	62230.00	0.00	62230.00	127	16	130	10	13	0.274697476481365	0.274697476481365	false	false	false	true
c7ba4177-779b-4eac-a531-fea64da4674d	2026-08-21 09:54	2026-08-21 09:54	2026-08-21 09:54	PM	PM260918C00190000	call	190.0000	2026-09-18	5.8000	5.8000	6.7000	189.7950	72500.00	0.00	72500.00	125	6	126	1657	0.076041038020519	0.268495112389785	0.268495112389785	false	false	false	true
5fe33151-19dc-47ca-b780-b74ed55c630a	2026-08-21 11:27	2026-08-21 11:27	2026-08-21 11:27	PM	PM260918P00190000	put	190.0000	2026-09-18	6.0000	6.0000	6.4000	188.5200	167438.00	0.00	167438.00	279	28	336	531	0.632768361581921	0.264604650643364	0.264604650643364	false	false	false	true
efa1be53-724b-4006-a6ff-8e7cb0d21ead	2026-08-24 13:00	2026-08-24 12:59	2026-08-24 12:59	PM	PM270617P00185000	put	185.0000	2027-06-17	16.0500	15.5000	16.5000	191.6750	51360.00	1610.00	44920.00	32	11	32	88	0.363636363636364	0.328778036312927	0.328778036312927	false	false	false	true
5c9b50cd-f2af-4dc9-bb2c-8b452393613f	2026-08-25 14:50	2026-08-25 14:50	2026-08-25 14:50	PM	PM261120C00210000	call	210.0000	2026-11-20	5.2000	5.2000	5.5000	193.8500	57223.00	0.00	57223.00	110	26	154	1285	0.119844357976654	0.277833198033811	0.277833198033811	false	false	false	true
0fe483e6-a6ef-4e13-bd27-8b45f9db6eb0	2026-08-26 12:00	2026-08-26 12:00	2026-08-26 12:00	PM	PM261218P00185000	put	185.0000	2026-12-18	7.8000	7.8000	8.2000	195.5200	67080.00	0.00	67080.00	86	16	556	106	5.24528301886792	0.313750355013369	0.313750355013369	false	false	false	true
4c8474ad-5f85-4023-9127-0e41160e6262	2026-08-28 13:13	2026-08-28 13:13	2026-08-28 13:13	PM	PM261218P00200000	put	200.0000	2026-12-18	16.4400	16.2000	16.8000	192.3099	50965.00	0.00	50965.00	31	8	70	19	3.68421052631579	0.315900220308469	0.315900220308469	false	false	false	true
0c2f720e-957f-4dad-8171-b671978cb19e	2026-08-28 13:14	2026-08-28 13:14	2026-08-28 13:14	PM	PM261218P00200000	put	200.0000	2026-12-18	16.4900	16.4000	16.8000	192.2700	65969.00	0.00	65969.00	40	6	115	19	6.05263157894737	0.316111383098971	0.317290950350547	false	false	false	true
1b60278f-5ca4-470c-b413-7836886fbd87	2026-08-28 15:42	2026-08-28 15:42	2026-08-28 15:42	PM	PM261218P00200000	put	200.0000	2026-12-18	16.3000	16.3000	16.9000	191.5500	58680.00	0.00	58680.00	36	5	530	19	27.8947368421053	0.303460623831931	0.303460623831931	false	false	false	true
57259575-529e-4f7b-b679-c65f9b1030a1	2026-08-31 11:51	2026-08-31 11:51	2026-08-31 11:51	PM	PM261218P00180000	put	180.0000	2026-12-18	7.7000	7.7000	8.0000	188.9250	77000.00	0.00	77000.00	100	11	100	460	0.217391304347826	0.311716720558172	0.311716720558172	false	false	false	true
0005c0f6-5f9f-48e0-a239-12c44c507d47	2026-09-02 10:24	2026-09-02 10:24	2026-09-02 10:24	PM	PM261218C00180000	call	180.0000	2026-12-18	15.7000	15.6000	16.3000	186.5400	50240.00	1570.00	48670.00	32	7	32	354	0.0903954802259887	0.275900054193986	0.275900054193986	false	false	false	true
c16546ac-444a-4972-8a85-e98a8c57f5a0	2026-09-02 14:09	2026-09-02 14:09	2026-09-02 14:09	PM	PM260911P00187500	put	187.5000	2026-09-11	2.2500	2.1000	2.2500	189.1550	90217.00	90217.00	0.00	401	6	494	8	61.75	0.261216122657562	0.261216122657562	false	false	false	true
193ca53c-4b6e-415e-99cd-7775537024bb	2026-09-02 15:50	2026-09-02 15:50	2026-09-02 15:50	PM	PM261218P00180000	put	180.0000	2026-12-18	7.8000	7.8000	8.3000	188.3500	54610.00	790.00	53820.00	70	15	125	493	0.253549695740365	0.311901871167012	0.311901871167012	false	false	false	true
fed3def5-95fa-47c7-9f10-a90c8f703d05	2026-09-04 11:41	2026-09-04 11:41	2026-09-04 11:41	PM	PM261016C00180000	call	180.0000	2026-10-16	8.8000	8.8000	9.0000	184.2250	88000.00	0.00	44000.00	100	5	228	123	1.85365853658537	0.24195721682616	0.24195721682616	false	false	false	true
cff227de-1b72-4b10-8c43-43f5be721746	2026-09-09 09:31	2026-09-09 09:31	2026-09-09 09:31	PM	PM270115C00200000	call	200.0000	2027-01-15	6.8000	6.2000	6.8000	184.8700	79560.00	12240.00	0.00	117	15	117	2460	0.0475609756097561	0.265654598851379	0.265654598851379	false	false	false	true
081a0800-3541-45fa-b4dd-06c10344cf2f	2026-09-09 09:31	2026-09-09 09:31	2026-09-09 09:31	PM	PM270115C00200000	call	200.0000	2027-01-15	6.5000	6.0000	6.5000	184.2700	81900.00	9100.00	0.00	126	18	243	2460	0.0987804878048781	0.263687411629565	0.263687411629565	false	false	false	true
d529e5e3-450b-47ef-ac2f-1879d5d697f6	2026-09-09 09:31	2026-09-09 09:31	2026-09-09 09:31	PM	PM270115C00200000	call	200.0000	2027-01-15	6.0900	5.9000	6.7000	183.6500	81030.00	5490.00	6000.00	133	13	832	2460	0.338211382113821	0.256764034193206	0.259250988949308	false	false	false	true
30b49a33-89cf-4e37-a076-8008d7b58981	2026-09-09 09:31	2026-09-09 09:31	2026-09-09 09:31	PM	PM270115C00200000	call	200.0000	2027-01-15	5.9400	5.5000	6.0000	183.6500	270810.00	141600.00	0.00	456	46	699	2460	0.284146341463415	0.254271917025223	0.256764034193206	false	false	false	true
3352f066-59fc-4c47-aaad-668fde94c24a	2026-09-09 09:31	2026-09-09 09:31	2026-09-09 09:31	PM	PM270115C00200000	call	200.0000	2027-01-15	6.1000	5.9000	6.1000	183.0925	104310.00	11590.00	0.00	171	19	1003	2460	0.407723577235772	0.264079958056171	0.264079958056171	false	false	false	true
635e334b-34b9-4b14-b55f-84d4924ba416	2026-09-09 09:31	2026-09-09 09:31	2026-09-09 09:31	PM	PM270115C00200000	call	200.0000	2027-01-15	6.1000	5.9000	6.1000	183.6700	108580.00	13420.00	0.00	178	17	1181	2460	0.480081300813008	0.259077447689409	0.259077447689409	false	false	false	true
ce2ca9c1-130e-433e-adee-6f23916f8889	2026-09-09 15:17	2026-09-09 15:17	2026-09-09 15:17	PM	PM270115C00195000	call	195.0000	2027-01-15	8.9000	8.9000	9.2000	185.8950	187790.00	0.00	187790.00	211	8	211	632	0.333860759493671	0.264906365943875	0.264906365943875	false	false	false	true
34fadfc9-a5d2-4513-bfff-17c24754d309	2026-09-11 12:39	2026-09-11 12:39	2026-09-11 12:39	PM	PM261120C00195000	call	195.0000	2026-11-20	10.1700	9.9000	10.4000	194.7100	56956.00	45827.00	8084.00	56	31	65	820	0.0792682926829268	0.284225860422155	0.282907905519111	true	false	false	true
b9be0979-eb9f-4a5c-95bb-982132cee8ec	2026-09-15 12:45	2026-09-15 12:45	2026-09-15 12:45	PM	PM261120C00210000	call	210.0000	2026-11-20	4.1800	4.0000	4.6000	194.0000	2069100.00	0.00	2069100.00	4950	2	5055	1984	2.54788306451613	0.277006600298032	0.277006600298032	false	true	false	true
7c73c564-8697-4025-8c89-4bf1207dec6f	2026-09-17 14:50	2026-09-17 14:50	2026-09-17 14:50	PM	PM270115P00180000	put	180.0000	2027-01-15	8.5000	8.5000	8.8000	189.7600	141950.00	0.00	141950.00	167	20	172	708	0.242937853107345	0.324979722749445	0.324979722749445	false	false	false	true
dab389d0-a554-4bbf-9008-47af970195de	2026-09-21 11:11	2026-09-21 11:11	2026-09-21 11:11	PM	PM261218C00210000	call	210.0000	2026-12-18	3.2000	3.2000	3.5000	186.0000	13120.00	0.00	13120.00	41	7	46	736	0.0625	0.272470175308659	0.272470175308659	false	false	false	true
78067cc9-8303-4628-b2f7-7149ddabc5ba	2026-09-21 12:11	2026-09-21 12:11	2026-09-21 12:11	PM	PM261016C00190000	call	190.0000	2026-10-16	3.9000	3.6000	3.9000	187.8550	86580.00	86580.00	0.00	222	34	243	537	0.452513966480447	0.237080387954888	0.237080387954888	false	false	false	true
4e34c902-4ba0-4197-97b6-ae6d5ba06ad8	2026-09-21 12:13	2026-09-21 12:13	2026-09-21 12:13	PM	PM261120P00170000	put	170.0000	2026-11-20	3.0000	2.9000	3.2000	187.7450	30600.00	1200.00	13200.00	102	29	123	1020	0.120588235294118	0.334829886382389	0.334829886382389	false	false	false	true