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×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

ab25e2db-f64c-4144-abdb-27359e9df038	2026-09-08 11:14	2026-09-08 11:14	2026-09-08 11:14	SMH	SMH270219C00685000	call	685.0000	2027-02-19	23.2000	21.8000	23.5500	577.2900	171710.00	85845.00	85865.00	74	5	75	21	3.57142857142857	0.355795740344492	0.35728541228634	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	66248124771.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-08T15:14:28.726538Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
856e22ed-5cbb-4d89-900a-7ccb6368ccfb	2026-09-08 09:43	2026-09-08 09:42	2026-09-08 09:42	SMH	SMH260918C00600000	call	600.0000	2026-09-18	5.2500	5.2000	5.8500	574.1450	157540.00	1575.00	155965.00	300	16	499	17591	0.0283667784662612	0.374545114353777	0.374873590755645	true	false	false	true
0d9bffc7-7cbf-4742-9a3c-c9ebfc527ef9	2026-09-04 15:58	2026-09-04 15:58	2026-09-04 15:58	SMH	SMH260908P00565000	put	565.0000	2026-09-08	4.0300	3.7000	4.2000	567.3100	55168.00	48818.00	6350.00	137	51	262	9	29.1111111111111	0.216846072707491	0.220978900432632	false	false	false	true
fb8d7ebd-f587-4827-b247-54b8dfee984f	2026-09-04 10:45	2026-09-04 10:45	2026-09-04 10:45	SMH	SMH260911P00550000	put	550.0000	2026-09-11	2.9800	2.9800	3.5000	565.7200	77229.00	640.00	76589.00	259	43	1122	2634	0.425968109339408	0.285256027001705	0.285256027001705	false	false	false	true
f2a8bb66-f810-4861-8a48-f7918464a907	2026-09-04 10:45	2026-09-04 10:45	2026-09-04 10:45	SMH	SMH260911P00555000	put	555.0000	2026-09-11	4.1000	4.1000	4.6000	565.7200	202232.00	0.00	202232.00	493	35	503	182	2.76373626373626	0.275803927382959	0.275803927382959	false	false	false	true
07d14a63-6937-4c9e-9874-ed4dc9282283	2026-09-04 10:43	2026-09-04 10:43	2026-09-04 10:43	SMH	SMH260910P00562500	put	562.5000	2026-09-10	5.5500	5.5500	5.6000	565.6996	143835.00	560.00	143275.00	259	35	459	2	229.5	0.249123093266855	0.249123093266855	false	false	false	true
13dfafea-1673-469d-9ec1-270e16dec05d	2026-09-04 10:29	2026-09-04 10:28	2026-09-04 10:28	SMH	SMH260904C00570000	call	570.0000	2026-09-04	0.9900	0.8900	1.0600	567.1800	56999.00	14949.00	42050.00	576	11	3462	3405	1.01674008810573	0.362138908041807	0.363123713639856	false	false	false	true
ae4b27e8-1452-4c38-88b3-5499e0f5ac0f	2026-09-04 10:25	2026-09-04 10:24	2026-09-04 10:24	SMH	SMH260904C00570000	call	570.0000	2026-09-04	0.8500	0.8400	0.9700	567.3250	66592.00	7626.00	58966.00	783	56	2607	3405	0.765638766519824	0.334682624078243	0.346219376043205	true	false	false	true
73b2188a-8f90-4b46-8aff-8ab65510001b	2026-09-04 09:48	2026-09-04 09:47	2026-09-04 09:47	SMH	SMH270617C00600000	call	600.0000	2027-06-17	65.6600	63.6500	66.6500	566.7050	164161.00	164161.00	0.00	25	6	50	1972	0.0253549695740365	0.358170018760837	0.358170018760837	false	false	false	true
7839f6c0-7904-4f6e-91c1-0129cb4a765e	2026-09-04 09:39	2026-09-04 09:39	2026-09-04 09:39	SMH	SMH260918P00570000	put	570.0000	2026-09-18	16.2100	15.2000	16.9000	563.8000	1620852.00	1587158.00	1594.00	1000	5	1005	8635	0.11638679791546	0.295510441608345	0.295510441608345	false	false	false	true
f74944b4-8a14-4b31-8322-9e735b23e72a	2026-09-03 15:46	2026-09-03 15:46	2026-09-03 15:46	SMH	SMH260908C00557500	call	557.5000	2026-09-08	3.5000	3.4000	3.6000	552.2900	52878.00	1400.00	51478.00	151	12	167	36	4.63888888888889	0.216965157335248	0.216965157335248	false	false	false	true
061179f2-e196-4dfd-9f87-4401723fecb1	2026-09-03 15:43	2026-09-03 15:43	2026-09-03 15:43	SMH	SMH260918P00515000	put	515.0000	2026-09-18	2.7100	2.6500	2.7800	551.9400	130346.00	127370.00	2976.00	481	22	1876	1705	1.10029325513196	0.331990219165503	0.332393974431998	false	false	false	true
40d870c1-e1f6-4995-b9db-96e994a78594	2026-09-03 14:33	2026-09-03 14:33	2026-09-03 14:33	SMH	SMH260911P00525000	put	525.0000	2026-09-11	1.6800	1.5400	1.7000	552.9250	67379.00	67210.00	169.00	401	48	576	192	3	0.31821166901653	0.31879840374736	true	false	false	true
536b06ff-b4b0-4a57-8bb0-93cf60b72314	2026-09-02 15:33	2026-09-02 15:33	2026-09-02 15:33	SMH	SMH280121C00870000	call	870.0000	2028-01-21	26.2300	25.4000	28.4500	550.2050	199370.00	125940.00	73430.00	76	6	76	6	12.6666666666667	0.359528528844675	0.359528528844675	true	false	false	true
313a074f-aaf0-4baf-bc9f-9864fb064fff	2026-09-02 15:22	2026-09-02 15:22	2026-09-02 15:22	SMH	SMH260918P00510000	put	510.0000	2026-09-18	2.7100	2.7100	2.8300	550.3700	73445.00	274.00	73171.00	271	28	597	3731	0.160010720986331	0.343837035902519	0.345053217787891	true	false	false	true
e02989b5-4509-40d9-8e88-06280769bd1f	2026-09-02 14:06	2026-09-02 14:06	2026-09-02 14:06	SMH	SMH260918P00570000	put	570.0000	2026-09-18	25.3400	25.3000	25.9500	550.0000	1117397.00	27885.00	1089512.00	441	44	3153	7734	0.407680372381691	0.29465134799335	0.29465134799335	true	false	false	true
7376247f-f690-47f7-b2f0-e3375a7cc16f	2026-09-02 14:00	2026-09-02 14:00	2026-09-02 14:00	SMH	SMH260918P00570000	put	570.0000	2026-09-18	25.5800	25.5000	26.3000	549.5600	764770.00	0.00	764770.00	299	7	1444	7734	0.186708042410137	0.290662659677138	0.294941753786807	true	false	false	true
03a0390e-9049-4082-927c-4d5a8e233a8c	2026-09-02 10:48	2026-09-02 10:47	2026-09-02 10:47	SMH	SMH260918C00550000	call	550.0000	2026-09-18	14.4100	14.1500	15.5000	549.5200	60535.00	8695.00	51840.00	42	16	989	5931	0.166750969482381	0.309010605453424	0.311191490480694	true	false	false	true
ea7532df-872a-4ec2-8f00-cce4d018f0c5	2026-09-02 09:32	2026-09-02 09:32	2026-09-02 09:32	SMH	SMH260904P00547500	put	547.5000	2026-09-04	6.7400	6.6000	8.3000	546.3500	52595.00	23390.00	29205.00	78	22	78	271	0.287822878228782	0.375794469373218	0.378897942478011	true	false	false	true
bcb67ecf-5abf-4ab8-978d-d119875b7613	2026-09-02 09:30	2026-09-02 09:30	2026-09-02 09:30	SMH	SMH261016P00535000	put	535.0000	2026-10-16	19.9100	18.4500	19.9500	544.0000	300635.00	272850.00	17845.00	151	24	410	5696	0.0719803370786517	0.33732450198268	0.339373678906062	true	false	false	true
ba003b39-3609-4a5f-be13-5f27ced7100c	2026-09-01 15:25	2026-09-01 15:25	2026-09-01 15:25	SMH	SMH260910P00587500	put	587.5000	2026-09-10	42.6800	42.4500	44.9000	545.2200	136570.00	68180.00	68390.00	32	7	32	0	0	0.324398103714323	0.318401434873798	true	false	false	true
c2b0ca5f-9277-4c35-ab02-e019a26735b8	2026-09-01 15:01	2026-09-01 15:01	2026-09-01 15:01	SMH	SMH260918P00520000	put	520.0000	2026-09-18	6.4400	6.3500	7.0000	543.4950	197715.00	38400.00	159315.00	307	20	2885	7182	0.401698691172375	0.342906737953007	0.344232885853016	false	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
b84fdae2-eae6-4750-8aa2-063e17fab8e2	2026-09-01 13:09	2026-09-01 13:09	2026-09-01 13:09	SMH	SMH260918P00555000	put	555.0000	2026-09-18	18.2500	18.1500	19.6500	545.0500	91234.00	0.00	91234.00	50	11	77	2260	0.034070796460177	0.279296791016852	0.282147110310383	false	false	false	true
3638f298-84cb-4134-ac83-b1f52aa89694	2026-09-01 12:36	2026-09-01 12:35	2026-09-01 12:35	SMH	SMH261016C00575000	call	575.0000	2026-10-16	13.4900	13.4500	13.8000	544.9400	60720.00	0.00	60720.00	45	5	405	398	1.01758793969849	0.316487387826794	0.317192527151841	true	false	false	true
d38e9969-9f68-40ee-a98c-17e92a12acae	2026-09-01 11:28	2026-09-01 11:28	2026-09-01 11:28	SMH	SMH260908P00542500	put	542.5000	2026-09-08	5.8700	5.6500	8.0000	546.6700	66915.00	33575.00	33340.00	114	12	114	19	6	0.261855539285982	0.263563158341601	true	false	false	true
bf612765-47d0-4dd5-9776-fb8cff298bdd	2026-09-01 11:28	2026-09-01 11:28	2026-09-01 11:28	SMH	SMH260904P00542500	put	542.5000	2026-09-04	4.4000	4.4000	4.6500	546.6700	566045.00	4075.00	561970.00	1286	66	1859	2037	0.912616593028964	0.321720308444002	0.321720308444002	true	false	false	true
d7aeed9e-5d11-47c0-af6b-3d1d0807531d	2026-09-01 10:27	2026-09-01 10:27	2026-09-01 10:27	SMH	SMH260904P00535000	put	535.0000	2026-09-04	3.4500	3.4500	3.7000	543.1400	482670.00	355.00	482315.00	1399	60	1694	519	3.26396917148362	0.349555356892098	0.355319352788202	false	false	false	true
e9e405af-e599-4e33-8eb5-9e7730bd611a	2026-09-01 10:25	2026-09-01 10:25	2026-09-01 10:25	SMH	SMH270219C00630000	call	630.0000	2027-02-19	25.2400	24.9500	27.1000	542.5300	63095.00	22755.00	40340.00	25	7	33	40	0.825	0.350318406692952	0.349947676945552	false	false	false	true
b5ba3318-5d67-40fe-a70b-72ece7da7e2b	2026-09-01 10:16	2026-09-01 10:15	2026-09-01 10:15	SMH	SMH270115P00510000	put	510.0000	2027-01-15	29.2000	29.2000	30.0000	542.8800	376713.00	0.00	376713.00	129	15	132	312	0.423076923076923	0.367421968523514	0.367421968523514	false	false	false	true
212c6285-d9a2-4cb9-8524-2423c749112a	2026-09-01 09:38	2026-09-01 09:38	2026-09-01 09:38	SMH	SMH260911P00532500	put	532.5000	2026-09-11	6.6100	5.4000	6.9500	543.1250	188444.00	175459.00	11635.00	285	30	285	55	5.18181818181818	0.319110422976521	0.326711532033581	true	false	false	true
d50ebb01-73cf-431a-927b-1b0be04baa58	2026-09-01 09:35	2026-09-01 09:35	2026-09-01 09:35	SMH	SMH260903C00550000	call	550.0000	2026-09-03	3.9600	3.5000	5.8000	544.4100	60170.00	30150.00	30020.00	152	8	152	8	19	0.390897138800115	0.387488129737847	true	false	false	true
963b5603-fb22-4f1f-a5fc-1ce64d012031	2026-08-31 15:50	2026-08-31 15:49	2026-08-31 15:49	SMH	SMH260918P00570000	put	570.0000	2026-09-18	21.5100	21.5000	22.6000	555.5700	3226631.00	0.00	3224426.00	1500	18	4409	6661	0.661912625731872	0.277293905578488	0.289158482954086	true	false	false	true
7a7ffc2d-bda3-4b64-a7e8-231ac045d0da	2026-08-31 15:42	2026-08-31 15:41	2026-08-31 15:41	SMH	SMH260918P00570000	put	570.0000	2026-09-18	22.0600	21.5500	22.3000	555.6300	291214.00	291214.00	0.00	132	22	2909	6661	0.436721213031076	0.28889867622159	0.28889867622159	false	false	false	true
ee1551dc-a128-4953-a523-9207fbc36819	2026-08-31 15:37	2026-08-31 15:37	2026-08-31 15:37	SMH	SMH260918P00570000	put	570.0000	2026-09-18	22.0600	22.0500	22.3000	555.4200	2205631.00	0.00	1874881.00	1000	22	2607	6661	0.391382675273983	0.287111658997949	0.287111658997949	true	false	false	true
1d93bbca-16d8-4587-874f-13c899d79cd8	2026-08-31 13:39	2026-08-31 13:38	2026-08-31 13:38	SMH	SMH261002C00600000	call	600.0000	2026-10-02	5.8500	5.8000	6.4500	554.5450	597295.00	590.00	596705.00	1021	51	1069	51	20.9607843137255	0.304533094902777	0.305575585115927	false	false	false	true
d2637456-b237-4c66-bdb4-59a04aee8742	2026-08-31 13:28	2026-08-31 13:28	2026-08-31 13:28	SMH	SMH260911C00570000	call	570.0000	2026-09-11	5.1500	5.1500	5.6000	554.3695	411050.00	7800.00	403250.00	798	60	845	99	8.53535353535353	0.284393914442742	0.284393914442742	true	false	false	true
610481f0-910f-452b-9344-44950f1cbb51	2026-08-31 11:37	2026-08-31 11:36	2026-08-31 11:36	SMH	SMH260904C00577500	call	577.5000	2026-09-04	1.2300	1.2200	1.4200	554.4150	154986.00	128.00	154858.00	1260	55	1274	77	16.5454545454545	0.335094799088198	0.339167002438793	true	false	false	true
0f66d745-6282-413b-9a9c-8da62ac62027	2026-08-31 11:11	2026-08-31 11:11	2026-08-31 11:11	SMH	SMH260925C00557500	call	557.5000	2026-09-25	17.5000	17.2000	18.9500	553.9200	75260.00	3510.00	71750.00	43	15	43	13	3.30769230769231	0.320217089646132	0.321081644835588	true	false	false	true
64a7f6e7-3ce3-49ed-ac7c-28b2601f75a7	2026-08-31 10:31	2026-08-31 10:31	2026-08-31 10:31	SMH	SMH260904C00552500	call	552.5000	2026-09-04	9.9500	9.7500	11.3000	555.0001	152245.00	995.00	151250.00	153	28	153	83	1.8433734939759	0.368253247571594	0.368253247571594	true	false	false	true
8adfbb34-ec35-4dcb-8e5b-a29e8ca365b4	2026-08-31 10:18	2026-08-31 10:18	2026-08-31 10:18	SMH	SMH271217P00400000	put	400.0000	2027-12-17	27.5300	27.3500	30.2000	556.8900	145935.00	8430.00	137505.00	53	22	53	581	0.0912220309810671	0.432729768475922	0.437674657009391	false	false	false	true
302fe1a4-ab19-42d1-8642-ed2040966d0d	2026-08-28 14:58	2026-08-28 14:58	2026-08-28 14:58	SMH	SMH261016C00575000	call	575.0000	2026-10-16	19.3000	19.3000	20.0000	552.7250	140896.00	1935.00	138961.00	73	11	155	289	0.536332179930796	0.339829135121148	0.339903186983424	true	false	false	true
c787199b-69c9-4471-bbf0-65f00abea47c	2026-08-28 14:04	2026-08-28 14:04	2026-08-28 14:04	SMH	SMH260918P00555000	put	555.0000	2026-09-18	16.4300	16.4000	17.0000	555.1420	1375519.00	145025.00	1230494.00	837	51	1055	2043	0.516397454723446	0.321807728945006	0.325581949638431	false	false	false	true
4084bea1-0f19-4b2f-ae1c-485185c9783d	2026-08-28 12:01	2026-08-28 12:01	2026-08-28 12:01	SMH	SMH260911C00547500	call	547.5000	2026-09-11	18.4900	18.3500	18.5500	554.0000	51760.00	42560.00	9200.00	28	8	36	9	4	0.330636493007799	0.334206985328142	true	false	false	true
0c921e14-32ee-4ca2-bd76-51f003f2bd9a	2026-08-28 11:46	2026-08-28 11:46	2026-08-28 11:46	SMH	SMH260904P00550000	put	550.0000	2026-09-04	5.3000	4.6500	5.3000	560.0000	101165.00	97505.00	3660.00	191	12	422	1031	0.409311348205626	0.314392181140807	0.317990397326448	true	false	false	true
acfd4b57-7916-4b0a-8a7b-65d77f54a6ee	2026-08-28 11:14	2026-08-28 11:14	2026-08-28 11:14	SMH	SMH261016P00595000	put	595.0000	2026-10-16	44.2400	44.0000	45.5000	564.5800	141575.00	0.00	141575.00	32	15	32	206	0.155339805825243	0.333958202935602	0.337310821796686	false	false	false	true
24c48c74-61c3-438f-b752-4da21f679742	2026-08-28 10:22	2026-08-28 10:22	2026-08-28 10:22	SMH	SMH260918P00555000	put	555.0000	2026-09-18	12.2500	12.1500	12.9500	566.1100	55140.00	2460.00	52680.00	45	14	68	2043	0.0332843857072932	0.331093544368243	0.331093544368243	false	false	false	true
979689a3-4e84-48bc-a83a-320c991d3b29	2026-08-28 09:35	2026-08-28 09:35	2026-08-28 09:35	SMH	SMH260828P00565000	put	565.0000	2026-08-28	2.7600	2.7300	3.5000	566.2800	68186.00	4994.00	63192.00	247	38	281	1622	0.17324290998767	0.520766319593304	0.551622940051556	true	false	false	true
bc568bb6-a0a4-4410-a8e2-22cc0dd59586	2026-08-28 09:31	2026-08-28 09:31	2026-08-28 09:31	SMH	SMH260918P00565000	put	565.0000	2026-09-18	16.6700	16.4000	17.3000	566.6900	76680.00	38500.00	38180.00	46	11	46	547	0.0840950639853748	0.333360868068775	0.333360868068775	true	false	false	true
13a92c6c-9d56-4a6c-85e6-f64273a8abfc	2026-08-27 14:47	2026-08-27 14:47	2026-08-27 14:47	SMH	SMH260918P00570000	put	570.0000	2026-09-18	18.6000	18.5500	19.1500	568.1000	944908.00	1860.00	943048.00	508	29	2171	2858	0.75962211336599	0.328456340087544	0.327916974777665	true	false	false	true