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

b8128f84-dff1-44c6-b621-a16a675dc11d	2026-08-17 15:40	2026-08-17 15:40	2026-08-17 15:40	SOXX	SOXX270115P00400000	put	400.0000	2027-01-15	11.0000	11.0000	11.3000	561.0300	55000.00	0.00	55000.00	50	25	124	3110	0.0398713826366559	0.511715954078867	0.51179641796614	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	41370759630.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T19:59:29.758034Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
24fffd2a-8fc9-45f2-b4a5-f85bc5a84c6e	2026-08-18 09:30	2026-08-18 09:30	2026-08-18 09:30	SOXX	SOXX260918C00555000	call	555.0000	2026-09-18	17.2400	17.2000	21.6000	537.5700	110360.00	0.00	110360.00	64	6	64	131	0.488549618320611	0.382152001368829	0.382152001368829	false	false	false	true	false
2eaf7366-15f5-4fb1-8864-2a557b57524f	2026-08-18 09:31	2026-08-18 09:31	2026-08-18 09:31	SOXX	SOXX260821C00580000	call	580.0000	2026-08-21	0.8000	0.8000	1.2000	539.7850	36000.00	0.00	31680.00	450	5	453	5897	0.0768187213837545	0.52885815735132	0.52885815735132	false	false	false	true	false
1d3427f9-bdc4-421b-b030-60df7ace09a7	2026-08-18 09:45	2026-08-18 09:45	2026-08-18 09:45	SOXX	SOXX270319P00420000	put	420.0000	2027-03-19	24.8000	24.8000	26.5000	535.0000	171120.00	0.00	171120.00	69	6	69	820	0.0841463414634146	0.493700343390118	0.493700343390118	false	false	false	true	false
4419d364-30c0-4a81-a966-04028333518d	2026-08-18 09:46	2026-08-18 09:46	2026-08-18 09:46	SOXX	SOXX260918P00530000	put	530.0000	2026-09-18	24.8000	23.8000	24.9000	534.0000	86800.00	71920.00	7440.00	35	7	97	623	0.15569823434992	0.447903115962722	0.447903115962722	true	false	false	true	false
ace7ab99-2ba3-4276-bd50-d6e6c6bc4ca2	2026-08-18 09:46	2026-08-18 09:46	2026-08-18 09:46	SOXX	SOXX260828P00500000	put	500.0000	2026-08-28	5.1000	4.0000	5.1000	533.0000	17850.00	17850.00	0.00	35	6	43	705	0.0609929078014184	0.500651693128645	0.500651693128645	true	false	false	true	false
cade0608-a44a-4b52-9ae5-0a84c9d5f380	2026-08-18 09:55	2026-08-18 09:55	2026-08-18 09:55	SOXX	SOXX261016P00500000	put	500.0000	2026-10-16	23.6000	23.3000	23.8000	530.5701	51920.00	47200.00	4720.00	22	5	236	1906	0.123819517313746	0.462985633693799	0.462985633693799	true	false	false	true	false
e189dd60-71aa-433f-94c0-7bbd73a5bcc0	2026-08-18 09:56	2026-08-18 09:55	2026-08-18 09:55	SOXX	SOXX260918P00530000	put	530.0000	2026-09-18	26.5000	25.5000	26.9000	530.8900	55650.00	15900.00	39750.00	21	7	174	623	0.279293739967897	0.450223977985916	0.451570985339922	false	false	false	true	false
81024bf6-a748-46c5-9105-8d0c77c0147a	2026-08-18 09:56	2026-08-18 09:55	2026-08-18 09:55	SOXX	SOXX260918P00530000	put	530.0000	2026-09-18	26.5000	26.0000	26.9000	530.7600	71550.00	15900.00	55650.00	27	9	153	623	0.245585874799358	0.450598467494961	0.450598467494961	false	false	false	true	false
a89645e1-34b8-49b1-bfed-e8ba49880348	2026-08-18 09:57	2026-08-18 09:57	2026-08-18 09:57	SOXX	SOXX260828C00545000	call	545.0000	2026-08-28	11.5000	10.3000	12.1000	533.3318	46000.00	44850.00	1150.00	40	10	43	45	0.955555555555556	0.462661610980854	0.462661610980854	false	false	false	true	false
ff39918e-6808-4683-bd3e-b834c1ca3a6d	2026-08-18 10:10	2026-08-18 10:10	2026-08-18 10:10	SOXX	SOXX260828P00445000	put	445.0000	2026-08-28	0.8000	0.8000	0.8500	530.2650	12880.00	0.00	12880.00	161	16	170	668	0.254491017964072	0.610146595003866	0.610146595003866	true	false	false	true	false
359d3d03-0678-45e9-9932-c4043e9fbe79	2026-08-18 10:11	2026-08-18 10:10	2026-08-18 10:10	SOXX	SOXX260828P00445000	put	445.0000	2026-08-28	0.8000	0.6500	0.8500	530.3201	28240.00	25120.00	3120.00	353	7	523	668	0.782934131736527	0.610432657290999	0.610432657290999	false	false	false	true	false
e8fc6ef0-e19f-45e0-8569-fafc6e185beb	2026-08-18 10:26	2026-08-18 10:26	2026-08-18 10:26	SOXX	SOXX261016C00535000	call	535.0000	2026-10-16	38.1000	35.5000	38.1000	532.0600	114300.00	114300.00	0.00	30	11	33	61	0.540983606557377	0.445404019072605	0.445119595234205	true	false	false	true	false
c3a90508-6602-44db-8b01-3f063967d24a	2026-08-18 10:41	2026-08-18 10:41	2026-08-18 10:41	SOXX	SOXX260918P00495000	put	495.0000	2026-09-18	12.9000	12.9000	13.2000	530.5750	36120.00	0.00	36120.00	28	8	120	484	0.247933884297521	0.464168514895763	0.464168514895763	false	false	false	true	false
7febe3c3-a878-41d6-ad05-13b0af46e450	2026-08-18 10:41	2026-08-18 10:41	2026-08-18 10:41	SOXX	SOXX261016C00600000	call	600.0000	2026-10-16	14.3000	14.0000	14.7000	530.4800	14300.00	12870.00	1430.00	10	5	84	4312	0.0194805194805195	0.428301758672185	0.428301758672185	false	false	false	true	false
24ef49d2-0c3f-4d17-a89c-9dc138b97e38	2026-08-18 10:43	2026-08-18 10:43	2026-08-18 10:43	SOXX	SOXX260904P00462500	put	462.5000	2026-09-04	3.3000	2.4500	3.3000	529.5000	1122329.00	1122329.00	0.00	3401	52	3402	21	162	0.535697092952634	0.535697092952634	false	false	false	true	false
2c5dd06e-ec48-4392-a26b-ae2218bc8b7b	2026-08-18 10:45	2026-08-18 10:45	2026-08-18 10:45	SOXX	SOXX260918P00495000	put	495.0000	2026-09-18	13.4900	12.9000	13.8000	528.8450	39112.00	39112.00	0.00	29	6	858	484	1.77272727272727	0.465732208058456	0.465732208058456	false	false	false	true	false
32a20a86-c8f5-412b-8f3f-ece81f93a49f	2026-08-18 10:45	2026-08-18 10:45	2026-08-18 10:45	SOXX	SOXX260918P00495000	put	495.0000	2026-09-18	13.6500	13.4000	13.8000	528.6300	341243.00	276005.00	57078.00	250	9	1108	484	2.28925619834711	0.467065009245913	0.467065009245913	false	false	false	true	false
7698cf0b-8588-4036-9d83-70639908cd2c	2026-08-18 10:46	2026-08-18 10:46	2026-08-18 10:46	SOXX	SOXX260918P00495000	put	495.0000	2026-09-18	13.7000	13.3000	13.9000	528.0000	34252.00	34252.00	0.00	25	5	1287	484	2.65909090909091	0.465361683042903	0.466127023444286	false	false	false	true	false
0ec933cc-67d3-4a7c-ab6c-f03e81ec8d43	2026-08-18 10:46	2026-08-18 10:46	2026-08-18 10:46	SOXX	SOXX260918P00495000	put	495.0000	2026-09-18	13.5900	13.1000	13.9000	528.1050	29902.00	29902.00	0.00	22	5	1333	484	2.75413223140496	0.463827462176028	0.463827462176028	false	false	false	true	false
84a73753-0fc9-4a09-a7bc-389ed188030a	2026-08-18 10:47	2026-08-18 10:47	2026-08-18 10:47	SOXX	SOXX260918P00495000	put	495.0000	2026-09-18	13.5400	13.2000	13.9000	528.4000	36571.00	9493.00	18948.00	27	5	1386	484	2.86363636363636	0.464664816919624	0.464664816919624	false	false	false	true	false
2d50d89c-391f-4b75-9d62-74e587aec2a9	2026-08-18 10:49	2026-08-18 10:49	2026-08-18 10:49	SOXX	SOXX260911P00500000	put	500.0000	2026-09-11	12.5000	11.1000	12.6000	528.0000	3799990.00	3762500.00	37490.00	3040	25	3043	542	5.61439114391144	0.46468336518202	0.464469411854064	false	false	false	true	false
b72ce300-062c-4159-913d-bc8d98aec2fd	2026-08-18 10:50	2026-08-18 10:49	2026-08-18 10:49	SOXX	SOXX260911P00500000	put	500.0000	2026-09-11	12.6000	12.1000	13.1000	527.3899	17640.00	3780.00	13860.00	14	5	3200	542	5.90405904059041	0.462951860314211	0.462951860314211	true	false	false	true	false
1d693a32-3ce3-41a3-879f-4e52e3bc1bb3	2026-08-18 10:50	2026-08-18 10:50	2026-08-18 10:50	SOXX	SOXX260911P00500000	put	500.0000	2026-09-11	12.6000	11.6000	12.7000	527.7600	326340.00	105840.00	207900.00	259	34	3516	542	6.48708487084871	0.465301739488223	0.465301739488223	true	false	false	true	false
fd16edf4-ffe0-4b3a-b713-717bdf80311b	2026-08-18 10:52	2026-08-18 10:52	2026-08-18 10:52	SOXX	SOXX260918P00490000	put	490.0000	2026-09-18	12.2600	11.8000	12.6000	527.6500	82136.00	82136.00	0.00	67	8	783	949	0.825079030558483	0.466772916191989	0.467371458019475	false	false	false	true	false
3ae1e621-71c8-4dc2-8e5d-860339984544	2026-08-18 10:53	2026-08-18 10:53	2026-08-18 10:53	SOXX	SOXX260918P00490000	put	490.0000	2026-09-18	12.6300	11.8000	12.8000	526.6275	126304.00	126304.00	0.00	100	11	883	949	0.9304531085353	0.46656179331829	0.470915752321156	false	false	false	true	false
06778196-1262-447f-af5d-0a9750251b63	2026-08-18 10:53	2026-08-18 10:53	2026-08-18 10:53	SOXX	SOXX260918P00495000	put	495.0000	2026-09-18	14.0800	13.6000	14.3000	526.7600	211219.00	211219.00	0.00	150	17	1998	484	4.12809917355372	0.465034008213655	0.465034008213655	false	false	false	true	false
a7620270-5aa1-445b-9173-629648b7b278	2026-08-18 10:54	2026-08-18 10:54	2026-08-18 10:54	SOXX	SOXX260918P00495000	put	495.0000	2026-09-18	14.0300	13.9000	15.1000	526.8800	18234.00	0.00	18234.00	13	6	2036	484	4.20661157024793	0.465316939603966	0.465316939603966	false	false	false	true	false
3fc02d57-1884-4519-916c-a619be1aece5	2026-08-18 10:59	2026-08-18 10:59	2026-08-18 10:59	SOXX	SOXX270115P00450000	put	450.0000	2027-01-15	26.9000	26.6000	27.0000	524.7200	40350.00	5380.00	34970.00	15	6	125	1090	0.114678899082569	0.480381548668536	0.480381548668536	false	false	false	true	false
97bf31d0-fa57-436d-a590-cc6957606c21	2026-08-18 11:01	2026-08-18 11:01	2026-08-18 11:01	SOXX	SOXX260918C00525000	call	525.0000	2026-09-18	27.5000	27.5000	29.8000	524.9500	200750.00	0.00	200750.00	73	13	73	96	0.760416666666667	0.437908640343953	0.437908640343953	false	false	false	true	false
7b236a85-89a5-468b-9c4b-39eea6e9e21a	2026-08-18 11:01	2026-08-18 11:01	2026-08-18 11:01	SOXX	SOXX260918C00555000	call	555.0000	2026-09-18	15.0000	15.0000	17.1000	524.8201	337579.00	0.00	337579.00	225	15	303	131	2.31297709923664	0.42780974742604	0.428626799186537	false	false	false	true	false
46f8b1a7-7e65-4af2-8e31-ac12f451d929	2026-08-18 11:01	2026-08-18 11:01	2026-08-18 11:01	SOXX	SOXX260918C00530000	call	530.0000	2026-09-18	25.0000	25.0000	27.3000	524.8201	392500.00	0.00	392500.00	157	16	163	340	0.479411764705882	0.435292126770056	0.436367313172684	false	false	false	true	false
1e073483-7fe8-4e7a-95c0-3b907d6f44b0	2026-08-18 11:02	2026-08-18 11:02	2026-08-18 11:02	SOXX	SOXX260918C00535000	call	535.0000	2026-09-18	23.1000	22.3000	23.1000	524.9600	32340.00	32340.00	0.00	14	8	19	51	0.372549019607843	0.440040774602292	0.440040774602292	true	false	false	true	false
fd957801-fb60-4061-a169-d496edd343ea	2026-08-18 11:07	2026-08-18 11:07	2026-08-18 11:07	SOXX	SOXX261016P00525000	put	525.0000	2026-10-16	35.9000	35.9000	35.9000	525.7800	17950.00	0.00	0.00	5	5	14	424	0.0330188679245283	0.451422624917982	0.451422624917982	false	false	false	true	false
00544086-df02-41f7-a877-25fc34abf460	2026-08-18 11:29	2026-08-18 11:29	2026-08-18 11:29	SOXX	SOXX260828P00522500	put	522.5000	2026-08-28	14.0000	14.0000	15.8000	527.0000	11200.00	0.00	11200.00	8	6	9	2	4.5	0.47359945404553	0.47359945404553	true	false	false	true	false
70f599b3-5cab-406d-b47a-0d7af2a76581	2026-08-18 11:31	2026-08-18 11:31	2026-08-18 11:31	SOXX	SOXX260918C00550000	call	550.0000	2026-09-18	18.0000	18.0000	18.3000	527.9500	32400.00	0.00	32400.00	18	8	61	319	0.191222570532915	0.430791370407431	0.430791370407431	true	false	false	true	false
9ec8df03-4ebf-4b47-975d-531177d6bfc4	2026-08-18 11:31	2026-08-18 11:31	2026-08-18 11:31	SOXX	SOXX260918C00550000	call	550.0000	2026-09-18	18.0000	17.1000	18.3000	527.7500	34200.00	5400.00	28800.00	19	7	91	319	0.285266457680251	0.431111254991556	0.432152081792794	false	false	false	true	false
adc68861-6e98-46c1-bfa4-c0197bfa93b2	2026-08-18 11:36	2026-08-18 11:36	2026-08-18 11:36	SOXX	SOXX260821C00530000	call	530.0000	2026-08-21	7.8800	7.8000	9.4000	527.0000	78757.00	0.00	78757.00	100	10	472	1597	0.295554164057608	0.479204506977778	0.483950478036798	true	false	false	true	false
16ace40c-d061-4a60-9001-ed7291cf4802	2026-08-18 11:36	2026-08-18 11:36	2026-08-18 11:36	SOXX	SOXX260918P00490000	put	490.0000	2026-09-18	12.4000	11.6000	12.4000	527.0000	104160.00	104160.00	0.00	84	10	1002	949	1.05584826132771	0.467898653941076	0.466345721803783	false	false	false	true	false
b4b82ff6-26fe-4c9d-8010-9ee578dec1b6	2026-08-18 11:40	2026-08-18 11:40	2026-08-18 11:40	SOXX	SOXX260918P00490000	put	490.0000	2026-09-18	12.7000	11.6000	12.7000	526.0300	127000.00	127000.00	0.00	100	19	1118	949	1.17808219178082	0.467147294284431	0.467147294284431	false	false	false	true	false
905ed005-c35c-4976-8cef-bf82742eea95	2026-08-18 11:49	2026-08-18 11:49	2026-08-18 11:49	SOXX	SOXX260828P00515000	put	515.0000	2026-08-28	10.1000	10.1000	11.7000	528.6900	31310.00	0.00	31310.00	31	9	43	73	0.589041095890411	0.469120632050082	0.471386468998179	true	false	false	true	false
74a6369e-d147-4349-8feb-758ed1a1c0fb	2026-08-18 11:53	2026-08-18 11:53	2026-08-18 11:53	SOXX	SOXX260821P00515000	put	515.0000	2026-08-21	4.3000	4.3000	5.0000	528.7950	39130.00	0.00	39130.00	91	9	271	1558	0.173940949935815	0.515437860173119	0.515437860173119	true	false	false	true	false
8525a033-0dce-46e3-ba31-57f8e5de399e	2026-08-18 11:53	2026-08-18 11:53	2026-08-18 11:53	SOXX	SOXX260918P00500000	put	500.0000	2026-09-18	14.7000	14.4000	15.2000	528.8200	149940.00	105840.00	44100.00	102	17	1027	6328	0.162294563843236	0.456965178113299	0.456965178113299	true	false	false	true	false
0506aa14-9e3e-4297-a460-b330d29d9021	2026-08-18 11:57	2026-08-18 11:57	2026-08-18 11:57	SOXX	SOXX260828P00500000	put	500.0000	2026-08-28	5.6800	5.6000	6.6000	528.7950	113523.00	62700.00	50823.00	200	8	330	705	0.468085106382979	0.478189316312817	0.481623726613247	false	false	false	true	false
9502c7ff-fdfd-49cf-8402-fb8f2436c6d7	2026-08-18 12:03	2026-08-18 12:02	2026-08-18 12:02	SOXX	SOXX260925P00500000	put	500.0000	2026-09-25	16.8000	16.5000	18.0000	529.6210	36960.00	0.00	36960.00	22	5	64	24	2.66666666666667	0.453989205625674	0.453989205625674	true	false	false	true	false
4316197f-90e1-40a6-a479-cad7b8e98b32	2026-08-18 12:08	2026-08-18 12:07	2026-08-18 12:07	SOXX	SOXX260828C00590000	call	590.0000	2026-08-28	1.3000	1.3000	1.7000	529.0000	286658.00	0.00	286658.00	2205	62	2316	6519	0.355269213069489	0.445262612766302	0.445262612766302	false	false	false	true	false
8a475065-7ff2-4d8f-825b-3fc240098b6a	2026-08-18 12:19	2026-08-18 12:19	2026-08-18 12:19	SOXX	SOXX260918P00450000	put	450.0000	2026-09-18	5.1000	4.5000	5.1000	527.2100	931768.00	931768.00	0.00	1827	51	1908	2591	0.73639521420301	0.510741039438457	0.510741039438457	false	false	false	true	false
237df0ed-cdbd-4934-9927-218150b63dcd	2026-08-18 12:41	2026-08-18 12:41	2026-08-18 12:41	SOXX	SOXX270115P00330000	put	330.0000	2027-01-15	5.7000	5.6000	5.7000	527.5200	11400.00	11400.00	0.00	20	5	135	12646	0.0106753123517318	0.553138768923581	0.553138768923581	false	false	false	true	false
f248a8c5-e3e7-43ee-9fc7-2bee7d1c3436	2026-08-18 13:06	2026-08-18 13:06	2026-08-18 13:06	SOXX	SOXX260918C00510000	call	510.0000	2026-09-18	37.6000	36.0000	38.6000	527.9500	135360.00	131600.00	3760.00	36	6	90	1155	0.0779220779220779	0.44246876255091	0.442913319407032	false	false	false	true	false
69e331b0-5c40-40b6-9ceb-c9d106eb9c68	2026-08-18 14:18	2026-08-18 14:18	2026-08-18 14:18	SOXX	SOXX260918P00515000	put	515.0000	2026-09-18	20.6000	20.6000	21.7000	526.7000	72100.00	0.00	72100.00	35	10	409	2829	0.144574054436197	0.442850816443174	0.442850816443174	false	false	false	true	false