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:er_time = unknown×ticker = SOFI×

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

d1741043-91b1-45b3-9df3-82707c5de5f6	2026-08-28 11:54	2026-08-28 11:54	2026-08-28 11:54	SOFI	SOFI271217C00025000	call	25.0000	2027-12-17	3.4500	3.4500	3.5500	18.0000	24840.00	0.00	24840.00	72	8	91	15398	0.00590985842317184	0.600457610361701	0.600457610361701	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	22796216219.00	2026-10-27	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
172b7336-d8d8-49cf-8acc-59a84af8dd3a	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	SOFI	SOFI260918P00018000	put	18.0000	2026-09-18	0.5500	0.5400	0.5500	18.0000	11605.00	11605.00	0.00	211	10	880	18530	0.0474905558553697	0.475277257322156	0.473125109961326	true	false	false	true
113d023f-5715-4adc-a17c-04d92522c82e	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	SOFI	SOFI260904C00019000	call	19.0000	2026-09-04	0.3500	0.3400	0.3500	18.0000	12915.00	12915.00	0.00	369	22	8530	10168	0.838906372934697	0.493345555718472	0.493345555718472	false	false	false	true
bbd94f6e-0872-4496-a347-78f96c1896a0	2026-08-28 11:50	2026-08-28 11:49	2026-08-28 11:49	SOFI	SOFI270115C00020000	call	20.0000	2027-01-15	2.1600	2.1600	2.2100	18.0000	21600.00	0.00	21600.00	100	7	1055	89358	0.0118064415049576	0.565494835167413	0.565494835167413	false	false	false	true
c2ff7d2c-519e-4111-b73c-c5d6fb7d2834	2026-08-28 11:46	2026-08-28 11:46	2026-08-28 11:46	SOFI	SOFI270617C00030000	call	30.0000	2027-06-17	1.4500	1.4300	1.4800	18.0000	29870.00	0.00	29870.00	206	8	391	21132	0.0185027446526595	0.606312010825711	0.606312010825711	false	false	false	true
9f166b9c-d8af-4718-a6a8-e617f0cf468a	2026-08-28 11:39	2026-08-28 11:38	2026-08-28 11:38	SOFI	SOFI261218C00018000	call	18.0000	2026-12-18	2.8100	2.8100	2.9300	18.0000	140500.00	0.00	140500.00	500	10	691	5855	0.11801878736123	0.576109665935323	0.576109665935323	false	false	false	true
eb90ae94-703f-4f29-9298-00d2d6c7d768	2026-08-28 11:38	2026-08-28 11:38	2026-08-28 11:38	SOFI	SOFI260828C00019000	call	19.0000	2026-08-28	0.0400	0.0300	0.0500	18.0000	12760.00	0.00	96.00	3190	9	25962	31162	0.833130094345677	0.787394073659629	0.796176942705463	false	false	false	true
fa911411-59de-44d5-ac0e-3951ccbce85c	2026-08-28 11:36	2026-08-28 11:36	2026-08-28 11:36	SOFI	SOFI260904C00019500	call	19.5000	2026-09-04	0.2400	0.2400	0.2500	18.0000	12792.00	0.00	12792.00	533	10	5257	9562	0.549780380673499	0.48704981921155	0.48704981921155	false	false	false	true
be7f4e37-88de-4dfe-8646-fc7dfee7b285	2026-08-28 11:27	2026-08-28 11:27	2026-08-28 11:27	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.4800	0.4600	0.4800	18.9100	12000.00	12000.00	0.00	250	10	11593	47013	0.246591368344926	0.489176711943947	0.489176711943947	false	false	false	true
9da6e7cd-b9f4-46b2-99ae-e3bb4337764b	2026-08-28 11:26	2026-08-28 11:26	2026-08-28 11:26	SOFI	SOFI280616C00020000	call	20.0000	2028-06-16	6.2000	6.0500	6.2000	18.9250	21700.00	21700.00	0.00	35	5	74	27032	0.00273749630068067	0.615688636468599	0.615688636468599	false	false	false	true
9d62c0da-59ab-4aca-9299-265349fb226b	2026-08-28 11:22	2026-08-28 11:21	2026-08-28 11:21	SOFI	SOFI260911C00019000	call	19.0000	2026-09-11	0.6300	0.6100	0.6400	18.8700	13041.00	13041.00	0.00	207	6	2685	2875	0.933913043478261	0.460066594456111	0.460066594456111	false	false	false	true
d3bed75e-80d0-40bf-ad68-29057f22f427	2026-08-28 11:11	2026-08-28 11:10	2026-08-28 11:10	SOFI	SOFI260918C00021000	call	21.0000	2026-09-18	0.2300	0.2200	0.2400	18.7850	27830.00	1771.00	24794.00	1210	59	1742	18740	0.0929562433297759	0.496891650641861	0.496891650641861	false	false	false	true
b5fb03b6-63c7-462f-896c-4d3de67a6c50	2026-08-28 11:01	2026-08-28 11:01	2026-08-28 11:01	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.4600	0.4600	0.4700	18.8650	11684.00	0.00	11684.00	254	6	10459	47013	0.222470380533044	0.486351049314398	0.486351049314398	false	false	false	true
23e66f68-e433-4bad-a30d-6648fe2fe41c	2026-08-28 11:01	2026-08-28 11:01	2026-08-28 11:01	SOFI	SOFI281215C00020000	call	20.0000	2028-12-15	7.0900	6.8500	7.1000	18.8800	99200.00	99200.00	0.00	140	14	219	2571	0.0851808634772462	0.623239089100192	0.621242249093135	false	false	false	true
276c58f4-ddb3-4090-b247-6bc0e956e3ff	2026-08-28 11:00	2026-08-28 11:00	2026-08-28 11:00	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.4700	0.4600	0.4700	18.8682	14193.00	14147.00	46.00	302	12	10015	47013	0.21302618424691	0.491747926716041	0.491747926716041	false	false	false	true
29116ef9-f929-4111-b614-3f995d1e7428	2026-08-28 10:59	2026-08-28 10:59	2026-08-28 10:59	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.4700	0.4600	0.4800	18.8850	58709.00	50151.00	8558.00	1250	53	9077	47013	0.193074256056835	0.490356828378117	0.494326368103651	false	false	false	true
64591cdb-84b5-472d-b6b2-8ccdad3c7354	2026-08-28 10:56	2026-08-28 10:55	2026-08-28 10:55	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.4400	0.4300	0.4400	18.7850	10252.00	10252.00	0.00	233	8	6901	47013	0.146789185969838	0.490269727270606	0.490269727270606	false	false	false	true
38232c84-91fb-4ca2-84cc-4893a4c9400a	2026-08-28 10:56	2026-08-28 10:55	2026-08-28 10:55	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.4400	0.4300	0.4400	18.7850	16368.00	16368.00	0.00	372	6	7273	47013	0.154701890966328	0.490269727270606	0.490269727270606	false	false	false	true
21c9933d-9bc5-41b0-91e1-74077142b1a7	2026-08-28 10:52	2026-08-28 10:52	2026-08-28 10:52	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.4300	0.4300	0.4400	18.7750	10062.00	0.00	10062.00	234	8	6629	47013	0.141003552208963	0.486079561146561	0.486079561146561	false	false	false	true
2798b319-60df-4806-a592-5de65a057ca2	2026-08-28 10:44	2026-08-28 10:44	2026-08-28 10:44	SOFI	SOFI260904C00019000	call	19.0000	2026-09-04	0.3800	0.3800	0.3900	18.7200	26600.00	0.00	26600.00	700	5	4982	10168	0.489968528717545	0.481975944981937	0.481933772024168	false	false	false	true
96e9822f-65b0-46f0-923d-87ee9f7d48eb	2026-08-28 10:44	2026-08-28 10:44	2026-08-28 10:44	SOFI	SOFI260904C00019000	call	19.0000	2026-09-04	0.3800	0.3800	0.3900	18.7150	15922.00	0.00	15922.00	419	16	4281	10168	0.421026750590087	0.484040474142171	0.484040474142171	false	false	false	true
62cd1f97-4957-4bf6-a28c-ee5172441142	2026-08-28 10:25	2026-08-28 10:25	2026-08-28 10:25	SOFI	SOFI260828C00018000	call	18.0000	2026-08-28	0.8600	0.8000	0.8700	18.8300	20656.00	20656.00	0.00	239	20	1409	9247	0.152373742835514	1.06631955809811	1.49876691894338	true	false	false	true
e9c075f2-c1af-43f1-bc30-e2c7e858c28b	2026-08-28 10:25	2026-08-28 10:25	2026-08-28 10:25	SOFI	SOFI260828C00018000	call	18.0000	2026-08-28	0.8600	0.8000	0.8600	18.8300	39732.00	39732.00	0.00	462	23	1170	9247	0.12652752243971	1.57877929376073	1.3819106619281	false	false	false	true
bd0e6406-d4e7-4752-adcd-63667e024dce	2026-08-28 10:19	2026-08-28 10:18	2026-08-28 10:18	SOFI	SOFI261016C00020000	call	20.0000	2026-10-16	0.9900	0.9800	1.0000	18.8950	102911.00	72107.00	30705.00	1040	73	2759	23458	0.117614459885753	0.508151538982997	0.511048641559464	true	false	false	true
909ef9ef-cdc4-4726-bbb5-721491dc51ca	2026-08-28 10:19	2026-08-28 10:18	2026-08-28 10:18	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.4800	0.4700	0.4900	18.9100	69383.00	48467.00	18324.00	1438	102	4150	47013	0.0882734562780507	0.493297472691744	0.495156447368224	false	false	false	true
b8885209-4a70-430e-acfb-b9eb707c0719	2026-08-28 10:17	2026-08-28 10:16	2026-08-28 10:16	SOFI	SOFI261002P00019000	put	19.0000	2026-10-02	1.2000	1.1300	1.2600	18.8201	12600.00	4080.00	8520.00	105	12	124	307	0.403908794788274	0.491011811470552	0.491011811470552	false	false	false	true
6481d16c-fe7d-42ba-95be-59bba7aac366	2026-08-28 10:10	2026-08-28 10:10	2026-08-28 10:10	SOFI	SOFI270115C00017000	call	17.0000	2027-01-15	3.7000	3.6500	3.7500	18.8500	18500.00	11100.00	1850.00	50	5	74	20349	0.00363654233623274	0.571522812366495	0.574076904329614	false	false	false	true
2d424ecc-a1f3-4e6f-83fe-29767421c5b1	2026-08-28 09:50	2026-08-28 09:49	2026-08-28 09:49	SOFI	SOFI271217P00015000	put	15.0000	2027-12-17	2.4000	2.4000	2.4900	19.0350	48480.00	0.00	48480.00	202	5	207	18325	0.0112960436562074	0.596855193423554	0.596855193423554	false	false	false	true
1655b890-ff31-4947-a6f4-ffb851318260	2026-08-28 09:43	2026-08-28 09:43	2026-08-28 09:43	SOFI	SOFI261016C00019000	call	19.0000	2026-10-16	1.5700	1.5200	1.5700	19.1390	15700.00	15700.00	0.00	100	7	352	8999	0.0391154572730303	0.521954741313715	0.521954741313715	false	false	false	true
a8e11553-1e8f-4068-84b4-fe10809c3bc2	2026-08-28 09:38	2026-08-28 09:38	2026-08-28 09:38	SOFI	SOFI260828C00019500	call	19.5000	2026-08-28	0.1400	0.1300	0.1500	19.3700	14070.00	0.00	56.00	1005	5	6310	43142	0.146261183997033	0.948347272253677	0.948347272253677	false	false	false	true
f0f09f43-666f-4f99-9e31-71364fd2d649	2026-08-28 09:31	2026-08-28 09:31	2026-08-28 09:31	SOFI	SOFI261016C00018000	call	18.0000	2026-10-16	2.3400	2.2400	2.3400	19.4750	37908.00	37908.00	0.00	162	14	162	7709	0.0210143987547023	0.521307970477584	0.521307970477584	true	false	false	true
46de9c1c-3331-4732-8dca-d4da9cfc58cc	2026-08-28 09:31	2026-08-28 09:31	2026-08-28 09:31	SOFI	SOFI261016C00019000	call	19.0000	2026-10-16	1.7700	1.7000	1.7800	19.4799	17700.00	6018.00	11682.00	100	8	115	8999	0.0127791976886321	0.522548501441443	0.522548501441443	false	false	false	true
fa495807-af02-40aa-882f-39511a5fb2d4	2026-08-27 15:59	2026-08-27 15:59	2026-08-27 15:59	SOFI	SOFI261120C00020000	call	20.0000	2026-11-20	1.8500	1.8300	1.8500	19.1883	14985.00	14985.00	0.00	81	8	1554	19741	0.078719416442936	0.574690702243964	0.574924847743272	false	false	false	true
f70d26d7-6328-43db-88ec-565b1dc5b9eb	2026-08-27 15:59	2026-08-27 15:59	2026-08-27 15:59	SOFI	SOFI261120C00020000	call	20.0000	2026-11-20	1.8500	1.8300	1.8500	19.1850	16650.00	16650.00	0.00	90	7	1473	19741	0.074616280836837	0.575379308835402	0.575379308835402	false	false	false	true
ef728199-116a-4350-8495-03847ea46dd1	2026-08-27 15:48	2026-08-27 15:48	2026-08-27 15:48	SOFI	SOFI260828C00019000	call	19.0000	2026-08-28	0.2800	0.2800	0.2900	19.0900	14336.00	0.00	14336.00	512	25	15740	32626	0.482437319928891	0.58116986352571	0.58116986352571	false	false	false	true
2945afe4-2de9-4936-b992-142407bed258	2026-08-27 15:11	2026-08-27 15:11	2026-08-27 15:11	SOFI	SOFI261016C00020000	call	20.0000	2026-10-16	1.1800	1.1700	1.1800	19.2300	11328.00	11328.00	0.00	96	5	6911	21889	0.315729361779889	0.516461509306385	0.516461509306385	false	false	false	true
4bfa2320-90c2-4e68-abbf-96e158b84ced	2026-08-27 15:10	2026-08-27 15:10	2026-08-27 15:10	SOFI	SOFI281215C00025000	call	25.0000	2028-12-15	5.9000	5.7000	5.9000	19.1950	24190.00	24190.00	0.00	41	7	1182	1279	0.92415949960907	0.62308472937488	0.623286993853134	false	false	false	true
41a6352a-5bf0-4c28-9feb-ddb85bdeae65	2026-08-27 15:09	2026-08-27 15:09	2026-08-27 15:09	SOFI	SOFI270617C00030000	call	30.0000	2027-06-17	1.6000	1.5500	1.6100	19.1750	28799.00	24089.00	4710.00	180	13	665	21268	0.0312676321233778	0.607193078461558	0.607193078461558	false	false	false	true
7a3e2842-d935-41a8-8636-0fe153f4723e	2026-08-27 14:27	2026-08-27 14:27	2026-08-27 14:27	SOFI	SOFI260828C00019000	call	19.0000	2026-08-28	0.2500	0.2400	0.2500	19.0200	12500.00	12500.00	0.00	500	27	13819	32626	0.423557898608472	0.60175577527072	0.60175577527072	false	false	false	true
7dd0cc47-e3e2-4901-802f-1783dc76f0f1	2026-08-27 14:14	2026-08-27 14:14	2026-08-27 14:14	SOFI	SOFI260828C00019500	call	19.5000	2026-08-28	0.0900	0.0800	0.1000	19.0502	11929.00	10548.00	1372.00	1326	46	23446	42049	0.557587576398963	0.6219951863384	0.597387316345527	true	false	false	true
fd703764-4b68-40bb-a9e2-ac55b2758f38	2026-08-27 14:04	2026-08-27 14:03	2026-08-27 14:03	SOFI	SOFI261016C00021000	call	21.0000	2026-10-16	0.7900	0.7700	0.7900	19.0850	11850.00	11850.00	0.00	150	15	733	6741	0.108737576027296	0.518198072762717	0.518198072762717	false	false	false	true
0bf0918d-f7d0-494e-945a-7292fc865d90	2026-08-27 13:55	2026-08-27 13:55	2026-08-27 13:55	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.6000	0.5900	0.6000	19.1130	19588.00	10620.00	8968.00	329	23	10821	47303	0.228759275310234	0.497595635834573	0.503594819033804	false	false	false	true
4e24e82d-bb1c-452c-a3a4-1265f7f22d62	2026-08-27 13:51	2026-08-27 13:51	2026-08-27 13:51	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.6000	0.6000	0.6100	19.1450	10080.00	0.00	10080.00	168	35	10269	47303	0.217089825169651	0.496684549409496	0.496684549409496	false	false	false	true
9b354b2f-85d4-4450-a884-f6922c737710	2026-08-27 13:35	2026-08-27 13:35	2026-08-27 13:35	SOFI	SOFI280121C00030000	call	30.0000	2028-01-21	3.0000	2.9500	3.0500	19.1550	22500.00	0.00	0.00	75	7	9646	20158	0.478519694414128	0.612421757692703	0.612421757692703	false	false	false	true
af5e409b-7598-42ec-8b13-5b0518e7d522	2026-08-27 13:31	2026-08-27 13:31	2026-08-27 13:31	SOFI	SOFI261120C00022000	call	22.0000	2026-11-20	1.1700	1.1600	1.1900	19.1700	11700.00	0.00	11700.00	100	5	1198	17016	0.0704043253408557	0.571899667844179	0.571899667844179	false	false	false	true
4683df64-ccf4-4e91-b999-01bc815479bf	2026-08-27 13:25	2026-08-27 13:25	2026-08-27 13:25	SOFI	SOFI260904C00020000	call	20.0000	2026-09-04	0.2800	0.2700	0.2900	19.1700	42000.00	0.00	41972.00	1500	25	10730	17305	0.620052008090147	0.520141038223781	0.520141038223781	true	false	false	true
ccb5fe5d-7ec5-4b9b-b9fb-d0ffe09d8e1f	2026-08-27 13:25	2026-08-27 13:25	2026-08-27 13:25	SOFI	SOFI260904C00020000	call	20.0000	2026-09-04	0.2800	0.2800	0.2900	19.1750	41916.00	0.00	41916.00	1497	55	9195	17305	0.53134932100549	0.518597554767027	0.518597554767027	true	false	false	true
bdaf5ad6-e43a-41b7-9036-92b267990741	2026-08-27 13:24	2026-08-27 13:24	2026-08-27 13:24	SOFI	SOFI260904C00019000	call	19.0000	2026-09-04	0.6700	0.6600	0.6700	19.1800	10787.00	10787.00	0.00	161	6	4127	10245	0.402830649097121	0.502961070603144	0.502961070603144	false	false	false	true
e9523abb-48d5-4e2e-a2ef-388d006966ee	2026-08-27 12:47	2026-08-27 12:47	2026-08-27 12:47	SOFI	SOFI260918C00019500	call	19.5000	2026-09-18	0.8400	0.8400	0.8600	19.2300	12516.00	0.00	12516.00	149	5	1061	886	1.19751693002257	0.500949745060494	0.500949745060494	false	false	false	true
1fc96c8a-f8fc-4074-b214-0bb7ec46706c	2026-08-27 12:35	2026-08-27 12:34	2026-08-27 12:34	SOFI	SOFI260904C00019000	call	19.0000	2026-09-04	0.7500	0.7300	0.7600	19.3000	25725.00	25650.00	0.00	343	6	3797	10245	0.37061981454368	0.511753955529103	0.511753955529103	false	false	false	true