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:option_symbol = SMH260918P00550000×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

4a3cd4a1-27a9-4bdf-9fdc-aa1f37c8b589	2026-08-14 15:57	2026-08-14 15:57	2026-08-14 15:57	SMH	SMH260918P00550000	put	550.0000	2026-09-18	11.7700	11.2500	11.8000	586.7400	542640.00	423600.00	12840.00	461	41	3931	10090	0.389593657086224	0.383320844731907	0.38247670645864	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	66248124771.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
eeaa1d32-9b4b-47f1-831d-dd055784d49c	2026-08-17 15:02	2026-08-17 15:02	2026-08-17 15:02	SMH	SMH260918P00550000	put	550.0000	2026-09-18	9.5900	9.4500	9.6000	596.0500	138090.00	138090.00	0.00	144	21	1062	11896	0.0892737054472091	0.400044392149014	0.400996280545648	false	false	false	true
4df6511e-3ab0-4ffa-9d1f-82d7f5ca9f39	2026-08-17 15:02	2026-08-17 15:02	2026-08-17 15:02	SMH	SMH260918P00550000	put	550.0000	2026-09-18	9.6000	9.5000	9.6500	596.0500	79646.00	78686.00	960.00	83	5	1168	11896	0.0981842636180229	0.400615659570401	0.400996280545648	false	false	false	true
86850f1d-31a0-403d-ace5-8a92b15bfec2	2026-08-18 11:56	2026-08-18 11:56	2026-08-18 11:56	SMH	SMH260918P00550000	put	550.0000	2026-09-18	16.7500	16.7500	17.0000	568.5000	182575.00	0.00	162475.00	109	22	582	13281	0.0438220013553196	0.393596365243152	0.394978055859265	false	false	false	true
1ae25529-cc69-4d97-89dc-72dd3112727b	2026-08-18 11:56	2026-08-18 11:55	2026-08-18 11:55	SMH	SMH260918P00550000	put	550.0000	2026-09-18	16.7500	16.7500	17.0500	568.3000	75375.00	0.00	75375.00	45	8	473	13281	0.035614788043069	0.393826867942224	0.393826867942224	false	false	false	true
0ce183e2-0bba-4af1-8b16-d54fe84fbb60	2026-08-18 11:56	2026-08-18 11:56	2026-08-18 11:56	SMH	SMH260918P00550000	put	550.0000	2026-09-18	16.7500	16.6000	17.0000	568.4100	244550.00	0.00	244550.00	146	7	728	13281	0.0548151494616369	0.394460294212851	0.394460294212851	false	false	false	true
ae56f306-840a-4b53-af85-0119a8b9d726	2026-08-19 11:44	2026-08-19 11:44	2026-08-19 11:44	SMH	SMH260918P00550000	put	550.0000	2026-09-18	18.2000	18.2000	18.7000	562.8950	145600.00	0.00	145600.00	80	9	1420	14020	0.101283880171184	0.390817786833042	0.390817786833042	false	false	false	true
b98c8b75-cdae-4ba6-9397-fe06e850246c	2026-08-19 11:44	2026-08-19 11:44	2026-08-19 11:44	SMH	SMH260918P00550000	put	550.0000	2026-09-18	18.2000	17.9500	18.7000	563.0700	118300.00	7280.00	109200.00	65	13	1485	14020	0.105920114122682	0.391598389786427	0.391910334431782	false	false	false	true
8d6954cc-fced-4672-9539-c145e593d970	2026-08-19 11:44	2026-08-19 11:44	2026-08-19 11:44	SMH	SMH260918P00550000	put	550.0000	2026-09-18	18.2000	18.2000	18.6500	563.0600	91000.00	0.00	91000.00	50	5	1535	14020	0.109486447931526	0.39184795902848	0.39184795902848	false	false	false	true
be697d06-11b1-4312-8e31-0ffa9fcb5dcb	2026-08-19 13:55	2026-08-19 13:54	2026-08-19 13:54	SMH	SMH260918P00550000	put	550.0000	2026-09-18	18.2500	18.2500	18.5000	561.7400	229950.00	0.00	229950.00	126	6	2189	14020	0.156134094151213	0.38436224644772	0.38436224644772	false	false	false	true
25fed8e5-9206-4c94-a4a8-49e393726743	2026-08-19 13:55	2026-08-19 13:54	2026-08-19 13:54	SMH	SMH260918P00550000	put	550.0000	2026-09-18	18.2000	18.2000	18.5000	561.8600	251160.00	0.00	245700.00	138	10	2327	14020	0.165977175463623	0.384313027146469	0.384313027146469	false	false	false	true
a58cebdb-cd3b-4641-be0b-f1eda2c45d92	2026-08-20 11:36	2026-08-20 11:36	2026-08-20 11:36	SMH	SMH260918P00550000	put	550.0000	2026-09-18	18.6000	18.6000	18.7000	560.1871	50220.00	0.00	50220.00	27	6	2266	14502	0.156254309750379	0.386135730398244	0.386135730398244	true	false	false	true
9e759be0-1b44-463f-bdfd-b8801002d6e5	2026-08-21 15:27	2026-08-21 15:27	2026-08-21 15:27	SMH	SMH260918P00550000	put	550.0000	2026-09-18	16.7500	16.7000	17.1000	561.0082	1765520.00	20170.00	1745350.00	1054	40	1704	14170	0.120254057868737	0.367178846360239	0.367178846360239	false	false	false	true
09782c52-1ac6-4f56-b5bf-89f036cd8f4f	2026-08-24 13:16	2026-08-24 13:16	2026-08-24 13:16	SMH	SMH260918P00550000	put	550.0000	2026-09-18	21.4900	20.7500	21.5000	547.7500	83825.00	79540.00	4285.00	39	10	1209	15350	0.0787622149837134	0.368593740284479	0.367718987434474	false	false	false	true
9e82aa4d-91f1-4a02-b435-80561acaa464	2026-08-25 14:46	2026-08-25 14:46	2026-08-25 14:46	SMH	SMH260918P00550000	put	550.0000	2026-09-18	17.1500	16.7000	17.6000	555.9389	579670.00	452760.00	126910.00	338	10	484	14550	0.0332646048109966	0.364716805614614	0.364716805614614	false	false	false	true
806dfb2a-4279-497b-b5db-d5d7d42ed23a	2026-08-26 09:32	2026-08-26 09:32	2026-08-26 09:32	SMH	SMH260918P00550000	put	550.0000	2026-09-18	16.6000	16.2500	16.7500	556.7350	175960.00	48140.00	127820.00	106	7	166	14786	0.011226836196402	0.368170908416504	0.368170908416504	true	false	false	true
f2610641-d9c7-4b27-9071-ced3d838746b	2026-08-26 09:56	2026-08-26 09:56	2026-08-26 09:56	SMH	SMH260918P00550000	put	550.0000	2026-09-18	16.1000	16.1000	16.5000	556.8400	130410.00	0.00	130410.00	81	5	250	14786	0.0169078858379548	0.359816083970053	0.359816083970053	false	false	false	true
cef4a400-9dfd-4db3-bfff-c2729800f9d6	2026-08-26 15:58	2026-08-26 15:58	2026-08-26 15:58	SMH	SMH260918P00550000	put	550.0000	2026-09-18	16.9900	16.7500	17.0500	555.1500	118930.00	73100.00	37330.00	70	17	1003	14786	0.0678344379818747	0.36316552101005	0.36316552101005	true	false	false	true
4ed79d6d-9152-4b8a-ad04-455c464efa40	2026-08-26 15:58	2026-08-26 15:58	2026-08-26 15:58	SMH	SMH260918P00550000	put	550.0000	2026-09-18	17.0000	16.7500	17.0500	555.1500	90085.00	66285.00	6800.00	53	24	1073	14786	0.0725686460165021	0.36316552101005	0.362252427285523	true	false	false	true
8cd2fb8f-458e-480b-b17b-49d1a6fa5a9a	2026-08-28 12:08	2026-08-28 12:08	2026-08-28 12:08	SMH	SMH260918P00550000	put	550.0000	2026-09-18	13.9000	13.9000	14.5500	556.4852	69510.00	0.00	2790.00	50	6	447	14941	0.0299176761930259	0.330561223180059	0.330561223180059	false	false	false	true
b65b3bb7-a18a-47de-b36c-db6ec3cbbb12	2026-08-28 12:19	2026-08-28 12:19	2026-08-28 12:19	SMH	SMH260918P00550000	put	550.0000	2026-09-18	14.8900	14.6500	14.9000	554.7650	251648.00	224918.00	26730.00	169	7	691	14941	0.0462485777391072	0.335788928810775	0.335788928810775	false	false	false	true
d8c6236c-9579-488d-9a11-30f1d30a4811	2026-09-01 09:49	2026-09-01 09:49	2026-09-01 09:49	SMH	SMH260918P00550000	put	550.0000	2026-09-18	17.7500	17.5500	18.5500	543.0350	102955.00	1780.00	101175.00	58	23	93	15644	0.00594477115827154	0.30988666870063	0.310965173881786	true	false	false	true
18719222-a3a3-47e8-808d-4c201e0cf95e	2026-09-01 13:16	2026-09-01 13:16	2026-09-01 13:16	SMH	SMH260918P00550000	put	550.0000	2026-09-18	15.7900	15.7500	17.0000	544.6200	80509.00	1695.00	78814.00	51	7	779	15644	0.049795448734339	0.28502681674415	0.311191918543827	false	false	false	true
d8f36f9f-91ca-4991-b46a-c5e5549035b0	2026-09-01 15:14	2026-09-01 15:14	2026-09-01 15:14	SMH	SMH260918P00550000	put	550.0000	2026-09-18	17.1500	17.1500	18.5000	544.6900	70315.00	0.00	70315.00	41	11	1067	15644	0.0682050626438251	0.316271065948182	0.316271065948182	false	false	false	true
60fc8abd-bbbf-48e6-9e0a-dba5906ae7c6	2026-09-01 15:51	2026-09-01 15:50	2026-09-01 15:50	SMH	SMH260918P00550000	put	550.0000	2026-09-18	17.1000	16.5500	17.5000	544.7400	107745.00	104300.00	3445.00	63	11	1140	15644	0.0728713883917157	0.314973242102747	0.318979322780583	false	false	false	true
8bb81613-a2cf-46ab-a708-65b5a7879946	2026-09-02 15:23	2026-09-02 15:23	2026-09-02 15:23	SMH	SMH260918P00550000	put	550.0000	2026-09-18	13.3500	12.9500	13.3500	550.3850	100125.00	100125.00	0.00	75	13	3122	15494	0.20149735381438	0.304873012625064	0.304873012625064	false	false	false	true
56198be6-7a98-49e3-b1b4-0a105a50b0e1	2026-09-03 09:42	2026-09-03 09:42	2026-09-03 09:42	SMH	SMH260918P00550000	put	550.0000	2026-09-18	15.8000	15.0000	15.8000	544.9850	129560.00	129560.00	0.00	82	5	238	13272	0.0179324894514768	0.307855372151437	0.307855372151437	false	false	false	true
dc8ac240-4693-4c38-b3f2-783ae133f812	2026-09-03 09:43	2026-09-03 09:42	2026-09-03 09:42	SMH	SMH260918P00550000	put	550.0000	2026-09-18	15.7500	15.0000	15.7500	545.1550	127575.00	127575.00	0.00	81	6	338	13272	0.0254671488848704	0.308788090178318	0.308788090178318	false	false	false	true
95c46769-f84b-431f-a91e-f61abc270b37	2026-09-03 09:43	2026-09-03 09:42	2026-09-03 09:42	SMH	SMH260918P00550000	put	550.0000	2026-09-18	15.7500	15.0500	15.7500	545.1550	129150.00	99225.00	0.00	82	5	420	13272	0.0316455696202532	0.308788090178318	0.308788090178318	false	false	false	true
476d5265-04a0-43aa-affb-547613bbe3d4	2026-09-03 15:04	2026-09-03 15:04	2026-09-03 15:04	SMH	SMH260918P00550000	put	550.0000	2026-09-18	11.3500	11.3500	11.6000	552.7200	1316661.00	0.00	1316661.00	1160	34	1766	13272	0.133062085593731	0.293137195359896	0.293137195359896	false	false	false	true
5ba6c138-af5e-4177-9bf4-9361e747cbc7	2026-09-03 15:32	2026-09-03 15:32	2026-09-03 15:32	SMH	SMH260918P00550000	put	550.0000	2026-09-18	11.5000	11.2500	11.7500	552.4100	440450.00	0.00	439300.00	383	37	2155	13272	0.162371910789632	0.293397694088017	0.293397694088017	false	false	false	true
862ca291-4c61-48be-9ccf-88dc17092de7	2026-09-04 09:39	2026-09-04 09:39	2026-09-04 09:39	SMH	SMH260918P00550000	put	550.0000	2026-09-18	7.5500	6.8500	7.5500	563.4101	51330.00	51330.00	0.00	68	17	76	13140	0.00578386605783866	0.311977729823927	0.310177461108311	true	false	false	true
db57e5be-891d-4515-8ee0-55aeb7ee20a0	2026-09-04 15:04	2026-09-04 15:04	2026-09-04 15:04	SMH	SMH260918P00550000	put	550.0000	2026-09-18	7.7500	7.2000	7.8000	564.1140	55010.00	53470.00	1540.00	71	7	1904	13140	0.144901065449011	0.320966500067574	0.319706425681361	false	false	false	true
74f3090a-ce0e-46f8-97b0-4f56260531f9	2026-09-09 10:30	2026-09-09 10:30	2026-09-09 10:30	SMH	SMH260918P00550000	put	550.0000	2026-09-18	4.3500	4.3500	4.4500	576.0000	64380.00	0.00	64380.00	148	6	264	12968	0.0203578038247995	0.390356365913722	0.390356365913722	false	false	false	true
1f34f182-d81c-4a32-a33f-31c6ce7cd336	2026-09-10 11:03	2026-09-10 11:03	2026-09-10 11:03	SMH	SMH260918P00550000	put	550.0000	2026-09-18	5.8500	5.7500	5.9500	563.6300	95355.00	77805.00	5850.00	163	13	847	12887	0.0657251493753395	0.351481542461266	0.351481542461266	false	false	false	true
77b876d4-d1b4-4456-82a0-cf6dd4baa82b	2026-09-10 11:04	2026-09-10 11:03	2026-09-10 11:03	SMH	SMH260918P00550000	put	550.0000	2026-09-18	5.9000	5.7000	5.9500	563.5600	124490.00	4130.00	6490.00	211	8	1058	12887	0.0820982385349577	0.352462447692748	0.352462447692748	false	false	false	true
2b9b0670-2407-4af0-931d-7b5d8d52c09b	2026-09-10 11:04	2026-09-10 11:04	2026-09-10 11:04	SMH	SMH260918P00550000	put	550.0000	2026-09-18	5.8500	5.7000	5.9000	563.6600	100035.00	585.00	8190.00	171	6	1229	12887	0.0953674245363545	0.351794063139916	0.351794063139916	false	false	false	true
c1c820ba-ef70-498d-a2db-04e7200160dc	2026-09-11 15:41	2026-09-11 15:41	2026-09-11 15:41	SMH	SMH260918P00550000	put	550.0000	2026-09-18	3.0000	2.8800	3.0500	568.8300	57300.00	45900.00	11400.00	191	13	1395	13313	0.104784796815143	0.315468286991322	0.315468286991322	false	false	false	true
94d0b3a4-17a9-4a97-b450-b571f87825b5	2026-09-14 09:58	2026-09-14 09:58	2026-09-14 09:58	SMH	SMH260918P00550000	put	550.0000	2026-09-18	14.0000	12.8500	14.0000	541.9650	245000.00	245000.00	0.00	175	15	2211	12995	0.170142362447095	0.421204003991515	0.421204003991515	false	false	false	true
039f8a17-1741-4c6b-8618-6e399b87ac12	2026-09-16 14:35	2026-09-16 14:35	2026-09-16 14:35	SMH	SMH260918P00550000	put	550.0000	2026-09-18	7.6000	6.9000	7.6000	547.4350	126160.00	126160.00	0.00	166	11	1078	12015	0.0897211818560133	0.388922711270559	0.388922711270559	true	false	false	true