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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = SMH×

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

45a98f07-eddc-457e-b709-d93fb9291c0e	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	SMH	SMH261218P00600000	put	600.0000	2026-12-18	36.0100	36.0000	37.3500	607.0000	867810.00	7210.00	716400.00	241	40	347	2987	0.116170070304653	0.368282167581323	0.368722153152599	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	74129314174.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
d56fc6e8-5be5-4783-9b29-9e9093fd26c2	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SMH	SMH261002P00607500	put	607.5000	2026-10-02	10.4000	10.0000	10.4000	606.6800	11440.00	11440.00	0.00	11	8	273	37	7.37837837837838	0.304924479709451	0.304924479709451	false	false	false	true
920da23d-950b-4d3a-b556-7333bf9f8be0	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SMH	SMH261023C00640000	call	640.0000	2026-10-23	9.6500	9.4500	9.9500	606.9600	17370.00	965.00	16405.00	18	7	99	159	0.622641509433962	0.316325610475924	0.316325610475924	true	false	false	true
f61f916e-46a8-4b51-9131-1d9be4c12c82	2026-09-25 15:55	2026-09-25 15:54	2026-09-25 15:54	SMH	SMH260928C00625000	call	625.0000	2026-09-28	0.3800	0.3100	0.4000	607.5550	11438.00	11400.00	38.00	301	45	1232	20	61.6	0.21153713070625	0.21153713070625	true	false	false	true
d510b15a-9c7f-4fa1-aaa1-51a25a6aae5e	2026-09-25 15:54	2026-09-25 15:54	2026-09-25 15:54	SMH	SMH260925C00562500	call	562.5000	2026-09-25	45.0000	44.5000	46.2000	607.5000	188994.00	0.00	188994.00	42	6	102	369	0.276422764227642	17.0697381158324	16.8668196753619	true	false	false	true
46be10be-ceaf-497a-a80f-741624361d2f	2026-09-25 15:53	2026-09-25 15:52	2026-09-25 15:52	SMH	SMH261016P00560000	put	560.0000	2026-10-16	4.3000	4.3000	4.3500	607.7000	25800.00	0.00	25800.00	60	6	959	5159	0.185888738127544	0.356920681697595	0.356920681697595	false	false	false	true
71eb73a6-1722-428f-ad13-91c0ebffbd1a	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	SMH	SMH261016P00560000	put	560.0000	2026-10-16	4.3000	4.3000	4.3500	607.7000	41710.00	0.00	41710.00	97	9	899	5159	0.174258577243652	0.356920681697595	0.356920681697595	false	false	false	true
8cffccac-dd9f-47ef-bcaa-8ea687355547	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	SMH	SMH261016P00600000	put	600.0000	2026-10-16	14.4000	14.3500	14.4000	607.8500	118080.00	118080.00	0.00	82	6	1286	6175	0.208259109311741	0.323241707105813	0.323241707105813	true	false	false	true
a10a3d2c-9c88-4e1d-bb0e-dfe587220dd2	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	SMH	SMH261016P00600000	put	600.0000	2026-10-16	14.4000	14.3000	14.5000	607.8350	95040.00	2880.00	2880.00	66	5	1201	6175	0.194493927125506	0.323133862036676	0.323133862036676	false	false	false	true
60d7b114-356b-491a-a0d8-2f95d0adc09e	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	SMH	SMH261016P00600000	put	600.0000	2026-10-16	14.3500	14.3000	14.3500	607.9310	121975.00	121975.00	0.00	85	6	1135	6175	0.183805668016194	0.322939523736031	0.322939523736031	false	false	false	true
25bd8613-e1a5-4a3a-b37f-b3885b93183e	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	SMH	SMH261016P00600000	put	600.0000	2026-10-16	14.3500	14.2500	14.5500	607.9300	91840.00	4305.00	4305.00	64	7	1050	6175	0.17004048582996	0.32293234537706	0.32293234537706	false	false	false	true
45bcc2ec-9a25-4d3a-87c4-f7fb4a620890	2026-09-25 15:51	2026-09-25 15:50	2026-09-25 15:50	SMH	SMH260925C00607500	call	607.5000	2026-09-25	0.7500	0.7400	0.7500	607.0000	26625.00	26625.00	0.00	355	11	2562	1110	2.30810810810811	0.706327826410145	0.706327826410145	false	false	false	true
42053db5-3a75-403c-901f-dfafaf95b7a7	2026-09-25 15:51	2026-09-25 15:50	2026-09-25 15:50	SMH	SMH261009P00590000	put	590.0000	2026-10-09	7.6000	6.8500	7.6000	607.0000	19760.00	19760.00	0.00	26	9	115	192	0.598958333333333	0.322532106635049	0.322532106635049	false	false	false	true
ff4faf5f-1c02-49a1-8638-facddc37c6d5	2026-09-25 15:49	2026-09-25 15:49	2026-09-25 15:49	SMH	SMH261120P00450000	put	450.0000	2026-11-20	2.0300	2.0200	2.1000	607.0000	12194.00	0.00	12194.00	60	7	193	3396	0.056831566548881	0.475878444316165	0.475878444316165	false	false	false	true
a6da1ea7-bc28-465b-8d03-d135a6a5203a	2026-09-25 15:49	2026-09-25 15:49	2026-09-25 15:49	SMH	SMH261009C00612500	call	612.5000	2026-10-09	12.5000	12.0500	12.5000	607.0000	12500.00	12500.00	0.00	10	6	224	21	10.6666666666667	0.305199871531379	0.305199871531379	false	false	false	true
997f58d2-36a6-4163-a0b8-84f4bcb4ca25	2026-09-25 15:48	2026-09-25 15:48	2026-09-25 15:48	SMH	SMH261009P00560000	put	560.0000	2026-10-09	2.3800	2.3800	2.4600	607.0000	29988.00	0.00	29988.00	126	5	246	1648	0.149271844660194	0.356425438296384	0.356425438296384	true	false	false	true
45347a8f-3280-4990-b495-9c7b8d34580f	2026-09-25 15:47	2026-09-25 15:47	2026-09-25 15:47	SMH	SMH261218C00905000	call	905.0000	2026-12-18	0.8400	0.1700	1.5200	607.0000	10920.00	0.00	10920.00	130	24	132	210	0.628571428571429	0.383903960769455	0.383903960769455	true	false	false	true
30eda350-c7ab-465f-bf3f-ed8e5fa4c48d	2026-09-25 15:46	2026-09-25 15:46	2026-09-25 15:46	SMH	SMH261120P00450000	put	450.0000	2026-11-20	2.0300	2.0200	2.1100	607.0000	10135.00	0.00	10135.00	50	7	133	3396	0.0391637220259128	0.475348455820891	0.47487221259034	false	false	false	true
6b1100a2-4ea6-49c2-9624-4441442c5fb9	2026-09-25 15:45	2026-09-25 15:45	2026-09-25 15:45	SMH	SMH261120C00600000	call	600.0000	2026-11-20	40.0000	38.9000	40.0000	607.0000	120000.00	120000.00	0.00	30	8	113	2643	0.0427544457056375	0.364152153471678	0.364152153471678	false	false	false	true
456989bf-54cb-4593-b8db-e6077e862352	2026-09-25 15:40	2026-09-25 15:40	2026-09-25 15:40	SMH	SMH261023P00597500	put	597.5000	2026-10-23	17.1500	16.8000	17.1500	606.0000	36015.00	36015.00	0.00	21	5	145	43	3.37209302325581	0.331903392472855	0.331903392472855	false	false	false	true
87f47d74-16f3-41ae-85fb-65560a217c2e	2026-09-25 15:38	2026-09-25 15:38	2026-09-25 15:38	SMH	SMH261002P00597500	put	597.5000	2026-10-02	6.3500	6.3500	6.6500	606.0000	17145.00	0.00	17145.00	27	7	441	75	5.88	0.311911133958941	0.311911133958941	true	false	false	true
dba4d1bf-4e4a-41e9-ae43-61239494fb47	2026-09-25 15:36	2026-09-25 15:36	2026-09-25 15:36	SMH	SMH261002P00595000	put	595.0000	2026-10-02	5.8500	5.8000	5.8500	605.0000	31605.00	31605.00	0.00	54	10	480	178	2.69662921348315	0.316048004325865	0.316048004325865	true	false	false	true
c8e322e6-5c80-4d95-b4d8-baf6207b4c73	2026-09-25 15:36	2026-09-25 15:36	2026-09-25 15:36	SMH	SMH261002P00585000	put	585.0000	2026-10-02	3.4000	3.2000	3.4000	605.0000	92756.00	92756.00	0.00	273	34	1455	1275	1.14117647058824	0.329535790727378	0.329535790727378	true	false	false	true
68355b08-03f3-4fe3-b28d-1ac97d76524a	2026-09-25 15:36	2026-09-25 15:36	2026-09-25 15:36	SMH	SMH261002P00587500	put	587.5000	2026-10-02	3.9000	3.8500	3.9000	605.0000	49914.00	49914.00	0.00	128	19	276	952	0.289915966386555	0.325723908863617	0.325723908863617	true	false	false	true
267bcea6-2182-483f-a729-122e2192e508	2026-09-25 15:29	2026-09-25 15:29	2026-09-25 15:29	SMH	SMH261120C00690000	call	690.0000	2026-11-20	9.1500	8.7500	9.1500	606.6000	39332.00	39332.00	0.00	43	14	96	151	0.635761589403974	0.352475611578513	0.352475611578513	false	false	false	true
b7bab5f1-49ee-4f40-90ff-71638754f7a2	2026-09-25 15:27	2026-09-25 15:27	2026-09-25 15:27	SMH	SMH260928C00620000	call	620.0000	2026-09-28	0.6500	0.6500	0.7100	606.6300	16120.00	0.00	16120.00	248	29	568	153	3.71241830065359	0.200517937601192	0.200517937601192	false	false	false	true
a8b51800-8cf8-493a-8cef-859640c85454	2026-09-25 15:27	2026-09-25 15:27	2026-09-25 15:27	SMH	SMH260928C00622500	call	622.5000	2026-09-28	0.4500	0.4500	0.4900	606.6300	25740.00	0.00	25740.00	572	54	858	1	858	0.205528435910934	0.205528435910934	false	false	false	true
f1310d4d-ff98-4840-a063-2323b9437629	2026-09-25 15:25	2026-09-25 15:25	2026-09-25 15:25	SMH	SMH261005C00610000	call	610.0000	2026-10-05	9.9000	8.9500	9.9000	606.7650	39600.00	39600.00	0.00	40	11	43	51	0.843137254901961	0.277364972807565	0.277364972807565	true	false	false	true
f66f007e-fb6d-4789-9f69-d912282e74fb	2026-09-25 15:22	2026-09-25 15:22	2026-09-25 15:22	SMH	SMH261023P00597500	put	597.5000	2026-10-23	17.2000	16.7500	17.2000	606.5608	43000.00	43000.00	0.00	25	5	124	43	2.88372093023256	0.334730769530704	0.334730769530704	true	false	false	true
f55df06e-4034-4990-af12-0dc70452cc37	2026-09-25 15:22	2026-09-25 15:22	2026-09-25 15:22	SMH	SMH261016P00600000	put	600.0000	2026-10-16	15.0800	14.7500	15.2000	606.5608	92000.00	90485.00	1515.00	61	20	981	6175	0.158866396761134	0.325770014788447	0.327095330461018	true	false	false	true
d9505ce1-45a4-4d9e-95c0-9d1672f1f357	2026-09-25 15:22	2026-09-25 15:22	2026-09-25 15:22	SMH	SMH261009P00597500	put	597.5000	2026-10-09	10.4000	10.3500	10.4000	606.5608	16640.00	16640.00	0.00	16	6	193	104	1.85576923076923	0.316203297623409	0.316203297623409	false	false	false	true
bc7ae530-bc64-45ad-a43d-7ee5197d829e	2026-09-25 15:22	2026-09-25 15:22	2026-09-25 15:22	SMH	SMH261002P00607500	put	607.5000	2026-10-02	10.5000	10.2500	10.5000	606.6200	69300.00	69300.00	0.00	66	13	249	37	6.72972972972973	0.307017576929854	0.307017576929854	true	false	false	true
7909b9c0-e0fd-4cec-a1f1-f5561972f141	2026-09-25 15:22	2026-09-25 15:22	2026-09-25 15:22	SMH	SMH261016P00605000	put	605.0000	2026-10-16	17.3000	17.2500	17.3500	606.6200	48440.00	31140.00	0.00	28	5	185	177	1.04519774011299	0.324214419562122	0.324214419562122	false	false	false	true
19d79d7d-53bf-44cd-b8c2-3069f43f9abe	2026-09-25 15:22	2026-09-25 15:22	2026-09-25 15:22	SMH	SMH261009P00597500	put	597.5000	2026-10-09	10.4000	10.3500	10.4000	606.5608	84240.00	71760.00	0.00	81	9	177	104	1.70192307692308	0.316702729591776	0.316203297623409	false	false	false	true
2886abf7-6614-4293-91a9-d3c7449a1b01	2026-09-25 15:21	2026-09-25 15:21	2026-09-25 15:21	SMH	SMH261016C00650000	call	650.0000	2026-10-16	5.0500	4.8500	5.1000	606.6700	50515.00	50515.00	0.00	100	16	605	4796	0.126146788990826	0.319115446224525	0.31838380120948	false	false	false	true
463fc2ef-3db7-4425-9ead-5df048e61272	2026-09-25 15:16	2026-09-25 15:16	2026-09-25 15:16	SMH	SMH261016C00645000	call	645.0000	2026-10-16	6.1000	5.7500	6.1000	607.0400	122000.00	122000.00	0.00	200	7	442	3134	0.141033822590938	0.318211157108166	0.318211157108166	false	false	false	true
ec48f9f7-6e6b-44c0-b1d1-996c052cb785	2026-09-25 15:14	2026-09-25 15:14	2026-09-25 15:14	SMH	SMH261002C00617500	call	617.5000	2026-10-02	5.9000	5.6000	5.9000	606.9600	45430.00	45430.00	0.00	77	7	194	336	0.577380952380952	0.300179972712696	0.300179972712696	false	false	false	true
d8e22f54-5df7-4c95-b47f-9ec6d7d129df	2026-09-25 15:14	2026-09-25 15:14	2026-09-25 15:14	SMH	SMH261002C00615000	call	615.0000	2026-10-02	6.8000	6.5000	6.8000	606.9600	34000.00	34000.00	0.00	50	8	775	1780	0.435393258426966	0.300463503133065	0.300463503133065	true	false	false	true
7eca340a-533c-4a7e-946b-17fe8d26b4dc	2026-09-25 15:14	2026-09-25 15:14	2026-09-25 15:14	SMH	SMH261023C00605000	call	605.0000	2026-10-23	23.8500	22.7500	23.9000	606.9600	28620.00	19080.00	0.00	12	7	32	109	0.293577981651376	0.32750656295227	0.32750656295227	false	false	false	true
03171549-28b3-43d0-9db8-9db127127b44	2026-09-25 15:14	2026-09-25 15:14	2026-09-25 15:14	SMH	SMH261023C00612500	call	612.5000	2026-10-23	20.0100	19.5500	20.1000	606.9600	38010.00	38010.00	0.00	19	6	137	42	3.26190476190476	0.323895329159325	0.325386753588332	true	false	false	true
6bae7a12-99d8-48bc-8d37-96f932f10c77	2026-09-25 15:14	2026-09-25 15:14	2026-09-25 15:14	SMH	SMH261030P00555000	put	555.0000	2026-10-30	8.0000	8.0000	8.1500	606.9000	27200.00	0.00	27200.00	34	5	72	16	4.5	0.374705270836758	0.374705270836758	false	false	false	true
278ad6f0-725a-4efa-9ce9-04d0dd35ff4f	2026-09-25 15:11	2026-09-25 15:10	2026-09-25 15:10	SMH	SMH270319C00875000	call	875.0000	2027-03-19	6.8400	6.5500	6.8500	606.7850	106044.00	106044.00	0.00	155	18	1369	131	10.4503816793893	0.360988442728546	0.360988442728546	false	false	false	true
9fbde0e2-2aff-4dcd-9b3d-8924bd2e1d58	2026-09-25 15:10	2026-09-25 15:10	2026-09-25 15:10	SMH	SMH270319C00875000	call	875.0000	2027-03-19	6.8900	6.5500	6.9000	606.0000	51690.00	51690.00	0.00	75	17	1214	131	9.26717557251908	0.361272133689443	0.361534015048078	false	false	false	true
7e318a19-9f25-4084-8a38-83d5c099b72f	2026-09-25 15:10	2026-09-25 15:10	2026-09-25 15:10	SMH	SMH261023C00660000	call	660.0000	2026-10-23	5.3500	5.1500	5.3500	606.0000	23005.00	23005.00	0.00	43	10	324	103	3.14563106796116	0.316964776795396	0.316964776795396	false	false	false	true
22aaa714-3a79-46bc-8aa7-2b4e9968a1fb	2026-09-25 15:10	2026-09-25 15:10	2026-09-25 15:10	SMH	SMH270319C00875000	call	875.0000	2027-03-19	6.8500	6.5500	6.8500	606.0000	51370.00	50690.00	680.00	75	6	1139	131	8.69465648854962	0.360407431221421	0.361065312282226	false	false	false	true
8ccc853f-ddec-48bc-84b1-0b26a7f46631	2026-09-25 15:10	2026-09-25 15:10	2026-09-25 15:10	SMH	SMH270319C00875000	call	875.0000	2027-03-19	6.8500	6.5500	6.9000	606.0000	51375.00	50690.00	685.00	75	5	1064	131	8.12213740458015	0.361118849575014	0.361118849575014	false	false	false	true
669be73b-5aae-4f7d-8cbb-9cd1839684b2	2026-09-25 15:10	2026-09-25 15:10	2026-09-25 15:10	SMH	SMH260930P00570000	put	570.0000	2026-09-30	0.5300	0.5200	0.6600	606.0000	61329.00	216.00	61113.00	1157	67	1181	866	1.36374133949192	0.335325552351912	0.336639764017698	true	false	false	true
bdf0db2f-d4d1-4a6e-95b2-fd76a0a4eac5	2026-09-25 15:10	2026-09-25 15:09	2026-09-25 15:09	SMH	SMH270319C00875000	call	875.0000	2027-03-19	6.8500	6.5500	6.8500	606.0000	50690.00	50690.00	0.00	74	9	839	131	6.40458015267176	0.361201219675506	0.361201219675506	false	false	false	true
ea901960-ff4f-4a5e-bcf3-743db75a5824	2026-09-25 15:06	2026-09-25 15:06	2026-09-25 15:06	SMH	SMH261030C00655000	call	655.0000	2026-10-30	9.0500	8.7500	9.0500	606.0000	45250.00	45250.00	0.00	50	12	140	311	0.45016077170418	0.33020420462923	0.33020420462923	true	false	false	true
c235a594-fa0d-48a3-b8f3-1c422bb94ab4	2026-09-25 15:06	2026-09-25 15:06	2026-09-25 15:06	SMH	SMH261030C00650000	call	650.0000	2026-10-30	10.2500	9.9000	10.2500	606.0000	21525.00	21525.00	0.00	21	13	95	369	0.257452574525745	0.330668435270743	0.330204548695223	true	false	false	true