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:ticker = SMH×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	pricenumeric

479a3bdf-fb80-44a7-9a2f-db709574105d	2026-08-18 13:58	2026-08-18 13:58	2026-08-18 13:58	SMH	SMH261120C00875000	call	875.0000	2026-11-20	0.9500	0.8100	1.0000	565.7900	53422.00	47689.00	5733.00	563	16	564	135	4.17777777777778	0.401954119937134	0.400690014522128	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-18T18:16:58.911276Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c88f7b58-c25e-4237-a2d8-6c3fb982416c	2026-08-18 14:10	2026-08-18 14:10	2026-08-18 14:10	SMH	SMH260819P00560000	put	560.0000	2026-08-19	3.4000	2.8100	3.4000	564.3950	132882.00	132882.00	0.00	391	21	943	158	5.96835443037975	0.454345452928545	0.454345452928545	false	false	false	true	false
3cd36edc-d289-4459-902d-2aa205449dc2	2026-08-18 14:10	2026-08-18 14:10	2026-08-18 14:10	SMH	SMH260820P00560000	put	560.0000	2026-08-20	5.3500	4.0500	5.3500	564.2700	131610.00	131610.00	0.00	246	26	433	10	43.3	0.441948364818444	0.441948364818444	false	false	false	true	false
e0cae6b6-d7f4-419b-9896-0965670b50fb	2026-08-18 14:16	2026-08-18 14:16	2026-08-18 14:16	SMH	SMH260918P00575000	put	575.0000	2026-09-18	28.9500	28.7500	29.1500	565.6600	83955.00	14475.00	23160.00	29	5	2542	2550	0.996862745098039	0.378347290318958	0.378347290318958	false	false	false	true	false
4e7ffd36-25f1-44b6-be47-6c77633993de	2026-08-18 14:59	2026-08-18 14:59	2026-08-18 14:59	SMH	SMH261016P00525000	put	525.0000	2026-10-16	18.2500	17.8000	18.2500	566.6300	62035.00	60220.00	1815.00	34	5	41	262	0.156488549618321	0.417469310836734	0.41602367836625	false	false	false	true	false
6614abc0-a348-4909-a742-c940c04e8797	2026-08-18 15:00	2026-08-18 14:59	2026-08-18 14:59	SMH	SMH260918P00575000	put	575.0000	2026-09-18	28.5000	28.4500	28.7500	566.8200	74095.00	0.00	74095.00	26	7	2702	2550	1.05960784313725	0.380706107897516	0.379946635613801	true	false	false	true	false
28b80b12-0b1b-461d-9918-d6dbade151be	2026-08-18 15:00	2026-08-18 14:59	2026-08-18 14:59	SMH	SMH260918P00575000	put	575.0000	2026-09-18	28.5500	28.4500	28.7500	566.8200	62810.00	8565.00	54245.00	22	5	2676	2550	1.04941176470588	0.381465569723292	0.381465569723292	false	false	false	true	false
ab4913cc-df57-4edb-ab17-a733fa36da73	2026-08-18 15:27	2026-08-18 15:27	2026-08-18 15:27	SMH	SMH260918C00550000	call	550.0000	2026-09-18	36.8900	36.2000	36.9000	567.9400	55340.00	51655.00	3685.00	15	6	130	3754	0.0346297282898242	0.398683808903261	0.397875158233479	false	false	false	true	false
a2f8a255-9690-43ec-8460-2e7ddfd83721	2026-08-18 15:34	2026-08-18 15:34	2026-08-18 15:34	SMH	SMH260828C00625000	call	625.0000	2026-08-28	1.2000	1.1900	1.4900	567.9300	227633.00	0.00	227633.00	1897	39	1924	667	2.88455772113943	0.389031651859959	0.388279488731506	true	false	false	true	false
091d2112-fc5c-4879-83af-07876896d95f	2026-08-18 16:02	2026-08-18 16:00	2026-08-18 16:00	SMH	SMH261016P00500000	put	500.0000	2026-10-16	11.5000	11.5000	12.1500	571.0000	57500.00	0.00	57500.00	50	17	5838	7392	0.789772727272727	0.436522958244746	0.438998271591575	false	false	false	true	false
f21db713-17c4-49e3-9210-00b609a0c840	2026-08-19 09:33	2026-08-19 09:33	2026-08-19 09:33	SMH	SMH260821P00590000	put	590.0000	2026-08-21	16.8500	16.5000	17.4500	575.2950	84250.00	67400.00	16850.00	50	5	52	1749	0.0297312750142939	0.428785988459464	0.428785988459464	false	false	false	true	false
d2cd257c-ec5c-4a90-ab01-1043aa524346	2026-08-19 09:34	2026-08-19 09:34	2026-08-19 09:34	SMH	SMH260918P00575000	put	575.0000	2026-09-18	24.5500	24.1000	24.5500	574.4400	56465.00	56465.00	0.00	23	5	51	4105	0.0124238733252132	0.383506974999414	0.383506974999414	false	false	false	true	false
38d86c20-b0f2-4ac2-9ac4-7936549d8c9a	2026-08-19 09:34	2026-08-19 09:34	2026-08-19 09:34	SMH	SMH260918P00575000	put	575.0000	2026-09-18	24.6000	24.1000	24.7500	574.3000	68880.00	68880.00	0.00	28	5	28	4105	0.00682095006090134	0.383264096471822	0.383264096471822	false	false	false	true	false
4d5afc7c-1036-4986-a846-41d970e691dd	2026-08-19 09:37	2026-08-19 09:37	2026-08-19 09:37	SMH	SMH260831P00550000	put	550.0000	2026-08-31	8.0000	6.5500	8.7500	569.0000	116000.00	116000.00	0.00	145	6	145	63	2.3015873015873	0.394374037453708	0.394374037453708	false	false	false	true	false
2c40d46e-6aab-4844-ae96-0129c4dd3d99	2026-08-19 09:38	2026-08-19 09:38	2026-08-19 09:38	SMH	SMH260904P00550000	put	550.0000	2026-09-04	11.0000	10.6000	11.4000	568.8000	73700.00	3300.00	3300.00	67	44	84	614	0.136807817589577	0.412988881179942	0.412988881179942	false	false	false	true	false
17e10ae4-2c3b-45f6-b392-1435dff2bc2c	2026-08-19 09:44	2026-08-19 09:44	2026-08-19 09:44	SMH	SMH260821P00565000	put	565.0000	2026-08-21	6.4500	6.4500	6.5000	567.8000	56115.00	0.00	45150.00	87	5	114	2447	0.046587658357172	0.467723318922774	0.467723318922774	true	false	false	true	false
c81af5dd-c05f-45d2-8432-2ce4ff5e0c7d	2026-08-19 09:49	2026-08-19 09:49	2026-08-19 09:49	SMH	SMH260825P00560000	put	560.0000	2026-08-25	9.2000	7.5000	9.4000	563.1050	178570.00	136300.00	42270.00	194	32	201	2	100.5	0.382049864226583	0.379274666367303	true	false	false	true	false
66245fad-d42b-41cb-9b1d-153d33c8abc6	2026-08-19 09:51	2026-08-19 09:51	2026-08-19 09:51	SMH	SMH260828P00570000	put	570.0000	2026-08-28	18.9500	18.8000	18.9500	561.5600	246350.00	176235.00	0.00	130	29	159	509	0.31237721021611	0.413814886821539	0.413814886821539	false	false	false	true	false
de254770-9edd-470b-90f5-afdc68fb6436	2026-08-19 09:53	2026-08-19 09:52	2026-08-19 09:52	SMH	SMH260918P00575000	put	575.0000	2026-09-18	31.6000	31.4000	31.6500	561.0000	53720.00	15800.00	37920.00	17	5	295	4105	0.071863580998782	0.385932914378006	0.385932914378006	false	false	false	true	false
96102586-68f6-44f5-80f3-1729f800e303	2026-08-19 09:53	2026-08-19 09:52	2026-08-19 09:52	SMH	SMH260918P00575000	put	575.0000	2026-09-18	31.6000	31.6000	31.6500	561.0000	88480.00	0.00	88480.00	28	5	272	4105	0.0662606577344702	0.385932914378006	0.385932914378006	false	false	false	true	false
5379a0b7-d4ce-4676-a6ba-6074231ff21f	2026-08-19 09:53	2026-08-19 09:52	2026-08-19 09:52	SMH	SMH260918P00575000	put	575.0000	2026-09-18	31.6000	31.6000	31.6500	561.0000	72680.00	0.00	72680.00	23	5	337	4105	0.082095006090134	0.385932914378006	0.385932914378006	false	false	false	true	false
4a50235d-969d-4520-9a27-f74ed467d0d8	2026-08-19 09:59	2026-08-19 09:59	2026-08-19 09:59	SMH	SMH260826P00542500	put	542.5000	2026-08-26	4.9000	4.8000	5.0000	562.6700	75900.00	0.00	75900.00	155	6	497	12	41.4166666666667	0.411372870891819	0.408974640481309	false	false	false	true	false
21d4fff7-55db-4771-b494-ba9d7e320f9b	2026-08-19 10:07	2026-08-19 10:07	2026-08-19 10:07	SMH	SMH260821C00570000	call	570.0000	2026-08-21	4.1000	4.1000	4.3500	560.7701	505120.00	0.00	505120.00	1232	19	2029	4482	0.452699687639447	0.468842853633162	0.468842853633162	false	false	false	true	false
066f7c0b-1e9f-4a9c-aa6a-803698f731f8	2026-08-19 10:08	2026-08-19 10:08	2026-08-19 10:08	SMH	SMH261218C00570000	call	570.0000	2026-12-18	51.5000	50.8500	51.5000	561.0300	257500.00	257500.00	0.00	50	18	50	2482	0.0201450443190975	0.40606691870111	0.40606691870111	false	false	false	true	false
45a005cd-b047-42dd-9d50-a9172fa11893	2026-08-19 10:09	2026-08-19 10:09	2026-08-19 10:09	SMH	SMH260918P00500000	put	500.0000	2026-09-18	6.4500	6.2500	6.5000	559.0000	65820.00	64530.00	1290.00	102	19	160	19406	0.00824487271977739	0.436948937370389	0.436948937370389	false	false	false	true	false
2d6cbe96-1d60-454b-84f1-00c708f96dd5	2026-08-19 10:10	2026-08-19 10:10	2026-08-19 10:10	SMH	SMH260826P00550000	put	550.0000	2026-08-26	8.2000	6.0500	8.2000	558.4406	56575.00	56575.00	0.00	69	9	69	242	0.285123966942149	0.395694523747451	0.395694523747451	false	false	false	true	false
1758278f-b7d7-4a17-8f4e-15d7dcd11033	2026-08-19 10:11	2026-08-19 10:11	2026-08-19 10:11	SMH	SMH260821C00562500	call	562.5000	2026-08-21	5.4000	4.9500	5.5000	556.6250	269963.00	269418.00	0.00	500	13	1005	226	4.44690265486726	0.484315417287142	0.481160576668071	false	false	false	true	false
dd5138ca-f989-46bd-982f-4f514d4a6c86	2026-08-19 10:13	2026-08-19 10:13	2026-08-19 10:13	SMH	SMH260918P00480000	put	480.0000	2026-09-18	4.1500	3.7500	4.2000	556.6000	55195.00	54780.00	0.00	133	8	135	5100	0.0264705882352941	0.45662818531745	0.45662818531745	false	false	false	true	false
e849b5d8-ea5d-4eca-ae4c-d9d2bb80b062	2026-08-19 10:14	2026-08-19 10:13	2026-08-19 10:13	SMH	SMH260918P00575000	put	575.0000	2026-09-18	33.8000	33.7000	34.3500	557.0250	84510.00	6770.00	77740.00	25	8	383	4105	0.0933008526187576	0.38500257935228	0.385803915507248	true	false	false	true	false
611f803e-f302-41d5-b441-621f4188ac08	2026-08-19 10:14	2026-08-19 10:13	2026-08-19 10:13	SMH	SMH260918P00575000	put	575.0000	2026-09-18	33.8000	33.8000	34.0500	557.0499	169000.00	0.00	169000.00	50	12	453	4105	0.110353227771011	0.385234378844884	0.385234378844884	true	false	false	true	false
efb87ebd-653d-48f0-96c9-74774ebdaa43	2026-08-19 10:17	2026-08-19 10:17	2026-08-19 10:17	SMH	SMH260821P00562500	put	562.5000	2026-08-21	10.0000	9.0000	10.0000	558.0650	50000.00	50000.00	0.00	50	11	451	1356	0.33259587020649	0.46227720643875	0.46227720643875	false	false	false	true	false
805cf4d8-294a-4ee6-9f58-7e8f6f18e6de	2026-08-19 10:27	2026-08-19 10:27	2026-08-19 10:27	SMH	SMH260918C00640000	call	640.0000	2026-09-18	3.4000	3.3500	3.4500	559.9200	121720.00	100640.00	0.00	358	14	388	3856	0.100622406639004	0.372047499029778	0.372047499029778	false	false	false	true	false
b21ef407-2ae8-4353-942d-54e8663d2f4d	2026-08-19 10:28	2026-08-19 10:27	2026-08-19 10:27	SMH	SMH260821P00560000	put	560.0000	2026-08-21	8.0000	8.0000	8.8500	559.8650	157600.00	0.00	149600.00	197	33	308	7959	0.038698328935796	0.483311321683224	0.483311321683224	true	false	false	true	false
954512ee-ed51-4263-939a-bfecab5facd1	2026-08-19 10:33	2026-08-19 10:33	2026-08-19 10:33	SMH	SMH260821P00550000	put	550.0000	2026-08-21	3.3500	3.3000	3.8000	561.6925	69085.00	2800.00	66285.00	206	13	722	6813	0.105973873477176	0.480586513609996	0.491468641749155	false	false	false	true	false
0544304e-94f4-49c0-98e3-4543cb9b2e0f	2026-08-19 10:38	2026-08-19 10:38	2026-08-19 10:38	SMH	SMH260918C00550000	call	550.0000	2026-09-18	33.5000	33.4500	34.0500	563.5400	83750.00	13400.00	70350.00	25	6	68	3805	0.0178712220762155	0.395608406860484	0.395708557462832	true	false	false	true	false
2b873e78-3af4-4927-87df-9c9062923e99	2026-08-19 10:40	2026-08-19 10:40	2026-08-19 10:40	SMH	SMH260918P00575000	put	575.0000	2026-09-18	29.4100	29.4000	29.6500	564.7000	258786.00	0.00	247026.00	88	10	683	4105	0.166382460414129	0.383004664665369	0.383160009227294	true	false	false	true	false
4d1ceaed-8ed3-412e-94be-042699924bae	2026-08-19 10:47	2026-08-19 10:46	2026-08-19 10:46	SMH	SMH261016P00545000	put	545.0000	2026-10-16	26.0500	26.0500	26.4500	562.7400	153695.00	0.00	153695.00	59	13	60	809	0.0741656365883807	0.405684138065164	0.405684138065164	false	false	false	true	false
b07c5103-6221-4e8a-b173-de783f388f87	2026-08-19 10:47	2026-08-19 10:47	2026-08-19 10:47	SMH	SMH261016P00545000	put	545.0000	2026-10-16	26.1500	26.1500	26.4000	562.8105	57530.00	0.00	57530.00	22	6	100	809	0.123609394313968	0.407170125586702	0.407170125586702	false	false	false	true	false
e4f03eb7-92d1-4b32-a2c7-50a81fed435a	2026-08-19 10:47	2026-08-19 10:47	2026-08-19 10:47	SMH	SMH261016P00545000	put	545.0000	2026-10-16	26.2000	26.2000	26.4000	562.9900	117900.00	0.00	117900.00	45	8	151	809	0.186650185414091	0.408549315299197	0.408549315299197	false	false	false	true	false
257e6b29-98be-4db6-960d-c51b2e616408	2026-08-19 10:47	2026-08-19 10:47	2026-08-19 10:47	SMH	SMH261016P00545000	put	545.0000	2026-10-16	26.2500	26.2500	26.4000	562.9800	97125.00	0.00	97125.00	37	6	208	809	0.257107540173053	0.409136738148424	0.409092647860366	false	false	false	true	false
05f0dead-1577-47e3-93dc-15fb1d56e17f	2026-08-19 10:47	2026-08-19 10:47	2026-08-19 10:47	SMH	SMH261016P00500000	put	500.0000	2026-10-16	12.8000	12.3000	12.8000	562.2900	136960.00	136960.00	0.00	107	6	357	6823	0.0523230250622893	0.434946655410258	0.434946655410258	true	false	false	true	false
b4c24ae2-147a-4bfe-9bef-6f275aa69b28	2026-08-19 10:49	2026-08-19 10:49	2026-08-19 10:49	SMH	SMH261016P00545000	put	545.0000	2026-10-16	26.8000	26.8000	27.0500	561.0200	150080.00	0.00	150080.00	56	11	313	809	0.386897404202719	0.406825147905608	0.406825147905608	false	false	false	true	false
2f04aba0-9ca5-4363-8335-a3e1b3fa9b27	2026-08-19 10:56	2026-08-19 10:55	2026-08-19 10:55	SMH	SMH261120P00560000	put	560.0000	2026-11-20	42.0000	41.3500	42.0000	562.6255	2100000.00	2100000.00	0.00	500	7	1001	228	4.39035087719298	0.409276207876163	0.409276207876163	false	false	false	true	false
331159e9-a23f-4626-af04-0bb2bede91dc	2026-08-19 11:00	2026-08-19 10:59	2026-08-19 10:59	SMH	SMH260918C00550000	call	550.0000	2026-09-18	34.1500	33.4000	34.1500	564.2300	71710.00	71710.00	0.00	21	8	94	3805	0.0247043363994744	0.399225436125747	0.399326296196231	true	false	false	true	false
8d776eb6-eb8d-4f2d-852e-b208f8f8a9ff	2026-08-19 11:00	2026-08-19 11:00	2026-08-19 11:00	SMH	SMH261016P00500000	put	500.0000	2026-10-16	12.3500	12.1500	12.3500	563.2950	107445.00	107445.00	0.00	87	5	1149	6823	0.168400996629049	0.431248666760355	0.431248666760355	false	false	false	true	false
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	false
dc3b9f1f-a6ef-4afd-a6d5-02c57b2fc29e	2026-08-19 11:44	2026-08-19 11:44	2026-08-19 11:44	SMH	SMH260821P00550000	put	550.0000	2026-08-21	2.7000	2.7000	2.8900	563.0800	152013.00	273.00	151740.00	563	7	1386	6813	0.203434610303831	0.458150512134617	0.458150512134617	false	false	false	true	false
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	false
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	false
45cb30f6-419a-4f07-9ffc-e5991beb149a	2026-08-19 12:06	2026-08-19 12:05	2026-08-19 12:05	SMH	SMH261218P00430000	put	430.0000	2026-12-18	9.7000	9.6500	10.0000	563.8550	69840.00	6790.00	63050.00	72	7	77	305	0.252459016393443	0.46585900765006	0.46585900765006	false	false	false	true	false