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:alert_rule = RepeatedHitsAscendingFill×endpoint = /api/option-trades/flow-alerts×ticker = MSTR×

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

13b3da15-57e5-42bb-a3c7-1c0e1fd003d5	2026-10-02 15:17	2026-10-02 15:17	2026-10-02 15:17	MSTR	MSTR261016P00150000	put	150.0000	2026-10-16	4.1600	4.1500	4.2000	156.2200	78950.00	0.00	78950.00	190	11	3191	5988	0.532899131596526	0.577793638008802	0.578691949761125	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Technology	58337326015.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T19:23:39.651516Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
c6f3c749-8cbe-4692-9af6-b472fbde4629	2026-10-02 14:55	2026-10-02 14:54	2026-10-02 14:54	MSTR	MSTR261009P00137000	put	137.0000	2026-10-09	0.2800	0.2800	0.3200	156.5150	10258.00	0.00	10258.00	365	32	819	236	3.47033898305085	0.603242367661561	0.606909007085142	false	false
d7a1f483-372d-4998-a3c7-ab33c45faf9a	2026-10-02 14:41	2026-10-02 14:41	2026-10-02 14:41	MSTR	MSTR261002P00157500	put	157.5000	2026-10-02	1.5000	1.4600	1.5400	156.0000	14118.00	4950.00	9168.00	94	9	19872	3039	6.53899308983218	0.870306049311551	0.870306049311551	true	false
610b8fa9-a779-4c63-a137-53c1f485d242	2026-10-02 14:39	2026-10-02 14:39	2026-10-02 14:39	MSTR	MSTR270917C00220000	call	220.0000	2027-09-17	27.5800	27.5000	28.9000	156.3401	16545.00	8280.00	8265.00	6	6	26	289	0.0899653979238754	0.719125482993834	0.719946269733136	false	false
ba0d6a2e-5aa3-45c9-afcb-2b370c601924	2026-10-02 14:36	2026-10-02 14:36	2026-10-02 14:36	MSTR	MSTR280121C00320000	call	320.0000	2028-01-21	21.3500	21.2000	22.3500	156.5500	160156.00	19230.00	140926.00	75	18	76	958	0.0793319415448852	0.730763640499059	0.731512749122041	false	false
dd8a01a8-c01a-4007-acab-fa9a2c8afe36	2026-10-02 14:35	2026-10-02 14:35	2026-10-02 14:35	MSTR	MSTR281215C00340000	call	340.0000	2028-12-15	36.3200	36.2000	36.4500	156.5100	134400.00	65430.00	68970.00	37	7	153	1641	0.093235831809872	0.734562008044735	0.734562008044735	false	false
5efdbd4a-4138-489e-96f8-7ee8a4f6a055	2026-10-02 14:35	2026-10-02 14:35	2026-10-02 14:35	MSTR	MSTR261002P00160000	put	160.0000	2026-10-02	3.4900	3.2500	3.5000	156.5100	13626.00	13626.00	0.00	39	14	25593	5435	4.70892364305428	0.829059327804295	0.829059327804295	false	false
fd58ce71-af0d-4ede-bcf6-3d320b01aea7	2026-10-02 14:35	2026-10-02 14:34	2026-10-02 14:34	MSTR	MSTR281215C00340000	call	340.0000	2028-12-15	36.3800	35.9000	37.1500	156.5600	25466.00	7301.00	18165.00	7	7	82	1641	0.0499695307739183	0.734306694420089	0.737116045987822	false	false
5296ede1-6c1e-4b2d-80f1-81b4b53d090f	2026-10-02 14:34	2026-10-02 14:34	2026-10-02 14:34	MSTR	MSTR290119C00270000	call	270.0000	2029-01-19	47.1500	47.0500	48.4000	156.6000	23575.00	4725.00	18850.00	5	5	21	826	0.0254237288135593	0.734049793676253	0.734049793676253	false	false
5b17634e-0afc-44ec-a4c9-3a89133dd24a	2026-10-02 14:06	2026-10-02 14:05	2026-10-02 14:05	MSTR	MSTR270416C00200000	call	200.0000	2027-04-16	20.0200	20.0000	20.5000	157.0000	18014.00	0.00	18014.00	9	5	47	582	0.0807560137457045	0.704919761201691	0.705359955817576	false	false
8b685923-e69e-4224-a43d-e666e8a73b12	2026-10-02 13:30	2026-10-02 13:29	2026-10-02 13:29	MSTR	MSTR261016C00175000	call	175.0000	2026-10-16	2.3400	2.3300	2.4000	157.0000	11684.00	0.00	11684.00	50	5	2203	5353	0.411544928077713	0.637009453392364	0.639200367733791	false	false
69d903d4-4e6d-4ae9-b78a-92e8afe0a288	2026-10-02 13:29	2026-10-02 13:29	2026-10-02 13:29	MSTR	MSTR261016C00170000	call	170.0000	2026-10-16	3.2100	3.2000	3.3000	157.0000	16055.00	0.00	12480.00	50	7	2665	4136	0.644342359767892	0.621821830212772	0.626596052776077	false	false
398c3725-1920-4945-bbd5-dbe31b2e3cbf	2026-10-02 13:19	2026-10-02 13:19	2026-10-02 13:19	MSTR	MSTR261002C00157500	call	157.5000	2026-10-02	1.2900	1.2200	1.3300	158.1000	12036.00	5842.00	6194.00	93	21	2543	3330	0.763663663663664	0.871461645403476	0.899560955043222	true	false
c5e5248f-caf6-4e0f-85a3-752f821ee920	2026-10-02 13:18	2026-10-02 13:18	2026-10-02 13:18	MSTR	MSTR261002C00157500	call	157.5000	2026-10-02	1.1600	1.1000	1.2100	157.8900	34742.00	3654.00	31088.00	300	5	2358	3330	0.708108108108108	0.880381800783925	0.862649009517161	false	false
86eba38e-87cd-42c4-9ff8-33df322b1d87	2026-10-02 13:11	2026-10-02 13:11	2026-10-02 13:11	MSTR	MSTR261002C00145000	call	145.0000	2026-10-02	14.2300	13.9500	14.3000	159.0000	213420.00	32665.00	180755.00	150	13	2986	2642	1.13020439061317	2.94954639255368	2.82301779870609	true	false
e748ec12-ab91-4a72-971c-067c47e4d94b	2026-10-02 13:11	2026-10-02 13:11	2026-10-02 13:11	MSTR	MSTR261002C00145000	call	145.0000	2026-10-02	14.1300	13.9000	14.2000	159.0000	53704.00	4244.00	48045.00	38	6	2288	2642	0.866010598031794	2.97269329230934	2.89813260220737	false	false
2867747d-6d29-4e42-a6fc-50defde7a50d	2026-10-02 12:41	2026-10-02 12:41	2026-10-02 12:41	MSTR	MSTR270416C00170000	call	170.0000	2027-04-16	29.6200	29.5000	30.5500	159.1000	62195.00	29650.00	32545.00	21	5	42	169	0.248520710059172	0.697771680622898	0.701852540882954	false	false
61027efc-90a1-4855-8c4c-af0ac4cb3d49	2026-10-02 12:18	2026-10-02 12:18	2026-10-02 12:18	MSTR	MSTR261002C00160000	call	160.0000	2026-10-02	0.8600	0.8400	0.9000	159.6400	17142.00	5394.00	11748.00	200	7	16384	9192	1.78241949521323	0.771190163391018	0.794353024872507	false	false
b690fff3-1687-4f75-b30d-c0124d60409b	2026-10-02 11:14	2026-10-02 11:14	2026-10-02 11:14	MSTR	MSTR270115C00175000	call	175.0000	2027-01-15	18.6300	18.1000	19.1500	160.7000	46565.00	0.00	46565.00	25	5	101	4853	0.0208118689470431	0.682752021197438	0.683042880165459	false	false
5a92d67c-efb5-494c-be72-c40b7a79d737	2026-10-02 11:08	2026-10-02 11:07	2026-10-02 11:07	MSTR	MSTR261016C00165000	call	165.0000	2026-10-16	5.9100	5.8000	5.9500	159.0000	29532.00	29532.00	0.00	50	8	2115	2732	0.77415812591508	0.639096612461194	0.639096612461194	false	false
bdf16a4b-6bb7-4334-86ee-9c1226518be4	2026-10-02 11:06	2026-10-02 11:06	2026-10-02 11:06	MSTR	MSTR261002C00160000	call	160.0000	2026-10-02	1.4800	1.4200	1.5100	160.0000	15798.00	14165.00	1484.00	107	31	9501	9192	1.03361618798956	0.919525298956462	0.931639636323146	true	false
36cde31d-6b9b-4d05-8726-319b778971bf	2026-10-02 11:06	2026-10-02 11:06	2026-10-02 11:06	MSTR	MSTR261002C00160000	call	160.0000	2026-10-02	1.5200	1.4400	1.5200	160.0000	11242.00	11242.00	0.00	74	23	9378	9192	1.02023498694517	0.914985619350484	0.921649163110994	false	false
767fd09c-62e1-4766-a93b-10394dbe4690	2026-10-02 10:42	2026-10-02 10:42	2026-10-02 10:42	MSTR	MSTR261002C00165000	call	165.0000	2026-10-02	0.7700	0.7300	0.7800	163.0000	23356.00	23125.00	231.00	303	8	16221	29836	0.543672074004558	0.960499019467515	0.957182742835381	false	false
cacdac31-bb53-4b0b-bf02-1b3bd096dd4f	2026-10-02 10:34	2026-10-02 10:34	2026-10-02 10:34	MSTR	MSTR261009P00160000	put	160.0000	2026-10-09	4.8400	4.7000	4.8500	161.4750	168866.00	168866.00	0.00	349	31	1986	2082	0.953890489913545	0.624637764850435	0.632582750224887	false	false
9508b61f-6473-4167-b1f9-25e4bdc577a7	2026-10-02 10:32	2026-10-02 10:32	2026-10-02 10:32	MSTR	MSTR261009C00160000	call	160.0000	2026-10-09	6.8700	6.8000	6.9500	162.2200	68675.00	22770.00	44525.00	100	10	881	6334	0.139090622039785	0.62957940079053	0.635282758868217	false	false
7d04b573-77ec-4cf3-ad42-e50a93afd28f	2026-10-02 10:31	2026-10-02 10:31	2026-10-02 10:31	MSTR	MSTR261009C00182500	call	182.5000	2026-10-09	1.0600	1.0300	1.0700	162.4920	31786.00	15301.00	0.00	300	13	11713	1980	5.91565656565657	0.719884072201877	0.723980534337095	false	false
4f038551-438f-42d2-a8d6-ca87325f7923	2026-10-02 10:29	2026-10-02 10:29	2026-10-02 10:29	MSTR	MSTR261016C00172500	call	172.5000	2026-10-16	4.8500	4.8500	5.0000	163.6100	242656.00	0.00	242656.00	500	64	1427	2232	0.639336917562724	0.644487325671402	0.646309669217643	true	false
53292ec0-c365-4688-81c5-8fbd12b197d5	2026-10-02 10:21	2026-10-02 10:21	2026-10-02 10:21	MSTR	MSTR261002C00170000	call	170.0000	2026-10-02	0.2300	0.2000	0.2300	164.0000	11498.00	11498.00	0.00	500	16	28075	30531	0.919557171399561	1.01662245432991	1.02933888302807	false	false
35553364-0fb4-423a-9854-43b2036ffca4	2026-10-02 10:15	2026-10-02 10:15	2026-10-02 10:15	MSTR	MSTR261009C00170000	call	170.0000	2026-10-09	3.3100	3.3000	3.4000	163.3401	66168.00	0.00	66168.00	200	21	13050	3964	3.29212916246216	0.652215022608969	0.655433737811131	false	false
18341c5b-53f4-4dde-8baa-593f78644917	2026-10-02 10:03	2026-10-02 10:03	2026-10-02 10:03	MSTR	MSTR261002C00165000	call	165.0000	2026-10-02	2.5700	2.4700	2.5700	166.5000	23123.00	23123.00	0.00	90	28	6789	29836	0.227543906689905	1.01068700519779	0.99525486587034	false	false
24cb47f8-a7e1-4763-b1c4-84624677544b	2026-10-02 10:02	2026-10-02 10:02	2026-10-02 10:02	MSTR	MSTR261023P00165000	put	165.0000	2026-10-23	9.6500	9.3500	9.7000	165.8100	27984.00	27019.00	965.00	29	17	52	1707	0.0304628002343292	0.648792680453986	0.648141095257968	true	false
48d40c1b-9868-41ea-b6d9-19d700f1083a	2026-10-02 10:01	2026-10-02 10:01	2026-10-02 10:01	MSTR	MSTR261016C00165000	call	165.0000	2026-10-16	8.8900	8.8500	9.1500	166.0000	44450.00	0.00	44450.00	50	9	1098	2732	0.40190336749634	0.630623148654029	0.633865098902975	false	false
50a6c232-1652-47bb-abb9-57e2721427eb	2026-10-02 09:57	2026-10-02 09:57	2026-10-02 09:57	MSTR	MSTR261002C00167500	call	167.5000	2026-10-02	1.4700	1.4700	1.6300	166.7850	14897.00	151.00	14746.00	101	5	23650	23569	1.00343671772243	1.03004470215377	1.05317655022556	true	false
3e2b0e57-bb57-4304-bca6-66e71ba1c774	2026-10-02 09:49	2026-10-02 09:49	2026-10-02 09:49	MSTR	MSTR261016C00155000	call	155.0000	2026-10-16	16.5700	16.3500	17.5000	168.5850	11601.00	0.00	11601.00	7	5	78	10367	0.00752387383042346	0.593953301186665	0.642876405341254	false	false
89d6acc3-9a8e-49f3-818f-b4ce593bf958	2026-10-02 09:49	2026-10-02 09:49	2026-10-02 09:49	MSTR	MSTR261023C00185000	call	185.0000	2026-10-23	5.4300	5.2500	5.5500	168.9400	40758.00	40758.00	0.00	75	7	121	380	0.318421052631579	0.686902586996545	0.686902586996545	false	false
399a9c2c-16c2-4374-b55d-3e8fabed16c8	2026-10-02 09:48	2026-10-02 09:48	2026-10-02 09:48	MSTR	MSTR270115C00200000	call	200.0000	2027-01-15	15.0200	14.7500	15.9500	167.0000	21030.00	10540.00	10490.00	14	6	106	14808	0.00715829281469476	0.702316299214892	0.704427894414928	false	false
3496a96d-0fe8-44dc-b383-56313e029aef	2026-10-02 09:44	2026-10-02 09:44	2026-10-02 09:44	MSTR	MSTR261009C00165000	call	165.0000	2026-10-09	8.1300	8.1000	8.3500	168.8000	40635.00	0.00	40635.00	50	8	1416	8085	0.175139146567718	0.643588369229224	0.649209965038818	false	false
927f257d-38b3-4636-b0c2-1a05ec25dcdb	2026-10-02 09:42	2026-10-02 09:41	2026-10-02 09:41	MSTR	MSTR261002C00160000	call	160.0000	2026-10-02	9.0500	8.8500	9.0500	169.0400	162888.00	160185.00	2703.00	180	6	4304	9192	0.468233246301131	0.792499733020602	0.792499733020602	false	false
a81540f3-b9be-4e03-bf5e-8dd028be9922	2026-10-02 09:36	2026-10-02 09:36	2026-10-02 09:36	MSTR	MSTR261002P00170000	put	170.0000	2026-10-02	3.0000	2.9000	3.0500	168.7100	13220.00	13220.00	0.00	44	14	284	412	0.689320388349515	1.26117533163433	1.28926111329761	true	false
269919c1-d73a-4414-929e-2469e26d418f	2026-10-02 09:35	2026-10-02 09:35	2026-10-02 09:35	MSTR	MSTR261016C00160000	call	160.0000	2026-10-16	14.2100	14.0500	14.4500	169.4300	17050.00	15625.00	1425.00	12	5	205	8673	0.0236365732733771	0.661477679412681	0.665796071309905	false	false
2ff7b512-f1bc-4808-98be-ef6b9f3f96f1	2026-10-02 09:35	2026-10-02 09:35	2026-10-02 09:35	MSTR	MSTR261002C00170000	call	170.0000	2026-10-02	2.1800	2.0400	2.1900	169.5050	22466.00	22466.00	0.00	103	8	4932	30531	0.161540729095018	1.29744214354266	1.31935096993167	false	false
89646539-c778-4680-9cdf-a80aaab606b1	2026-10-02 09:32	2026-10-02 09:32	2026-10-02 09:32	MSTR	MSTR261002C00165000	call	165.0000	2026-10-02	5.0100	4.8500	5.1000	169.0000	14020.00	14020.00	0.00	28	10	1402	29836	0.0469902131653037	1.38515500961108	1.45231538726156	false	false
fa4a05eb-a501-4f0b-b380-ab77d5bfbe4b	2026-10-02 09:32	2026-10-02 09:32	2026-10-02 09:32	MSTR	MSTR261002C00160000	call	160.0000	2026-10-02	8.8600	8.6500	9.2500	168.7800	177212.00	0.00	177212.00	200	5	1482	9192	0.161227154046997	1.38378117888112	1.18298311282407	false	false
ae1d1189-8a9f-4bdc-9085-a3c734850fb3	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	MSTR	MSTR261002C00162500	call	162.5000	2026-10-02	6.3900	6.3500	7.4000	169.1600	42795.00	1400.00	41395.00	67	6	416	30920	0.0134540750323415	1.63630237963495	1.25906555990168	false	false
75c31862-7b25-4b68-a312-f3c2bf2edd45	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	MSTR	MSTR261016C00172500	call	172.5000	2026-10-16	7.7200	7.4500	7.8500	168.8200	193111.00	186249.00	5332.00	250	15	540	2232	0.241935483870968	0.692224046620931	0.692224046620931	false	false
fc17bbc5-5ce2-4fe9-84c8-5b892df89ced	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	MSTR	MSTR261002C00167500	call	167.5000	2026-10-02	3.0000	2.6800	3.4500	168.6500	10800.00	7530.00	3270.00	36	13	1358	23569	0.0576180576180576	1.43311925486773	1.33248461713447	true	false
80bf3d88-d56b-4cd9-8e6f-e7190eae8095	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	MSTR	MSTR261016C00170000	call	170.0000	2026-10-16	8.4700	8.0500	8.7500	168.7600	12710.00	12710.00	0.00	15	5	157	4136	0.0379593810444874	0.691124099293537	0.683331147751919	false	false
2a0cde25-8fa4-4578-a110-e7d3833bd922	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	MSTR	MSTR261002C00170000	call	170.0000	2026-10-02	1.9500	1.6000	2.0500	168.7600	32996.00	32829.00	0.00	169	29	1743	30531	0.0570895155743343	1.39015635468397	1.4269563245272	true	false
08fefe66-4c86-46b0-abb4-94107f3e8965	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	MSTR	MSTR261002C00165000	call	165.0000	2026-10-02	4.3600	4.0000	4.8000	168.7600	19601.00	10853.00	1693.00	45	13	995	29836	0.0333489743933503	1.17667821662851	1.36771885969823	true	false
aa7b5e68-37e5-4353-84c0-de5e17b14a06	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	MSTR	MSTR261023C00165000	call	165.0000	2026-10-23	12.2700	12.2000	12.5500	167.7400	27000.00	12300.00	14700.00	22	5	59	1943	0.0303654143077715	0.668965772572891	0.671407556155742	false	false