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

7622e5c2-3aa0-43e7-bc2e-5f7881f5f71e	2026-08-28 14:44	2026-08-28 14:43	2026-08-28 14:43	SOFI	SOFI270416C00035000	call	35.0000	2027-04-16	0.5600	0.5600	0.6100	18.1050	11872.00	0.00	11872.00	212	17	333	146	2.28082191780822	0.618590580207365	0.618590580207365	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	22796216219.00	2026-10-27	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-28T18:46:22.896033Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
8dd66fee-24b5-4067-82aa-fe9c91e49ad5	2026-08-28 14:41	2026-08-28 14:40	2026-08-28 14:40	SOFI	SOFI270115C00025000	call	25.0000	2027-01-15	0.8100	0.8000	0.8200	18.1163	23030.00	8774.00	0.00	283	7	2287	99839	0.0229068800769238	0.577305296023675	0.577305296023675	false	false	false	true
830c152c-c4ba-4a7b-a486-96d8ea36ec14	2026-08-28 14:37	2026-08-28 14:37	2026-08-28 14:37	SOFI	SOFI261218C00019000	call	19.0000	2026-12-18	2.0200	1.9800	2.0200	18.1050	20200.00	20200.00	0.00	100	12	236	3775	0.0625165562913907	0.576682268236386	0.576682268236386	false	false	false	true
9a385f58-48ce-4da7-a4ae-eeaeb0a8b43f	2026-08-28 14:26	2026-08-28 14:26	2026-08-28 14:26	SOFI	SOFI261218P00015000	put	15.0000	2026-12-18	0.8400	0.8300	0.8400	18.0954	25200.00	25200.00	0.00	300	11	919	10631	0.0864453014768131	0.576048566500796	0.576048566500796	false	false	false	true
8a9678d8-3e7c-4f3e-b4ab-e6efc8f85740	2026-08-28 14:20	2026-08-28 14:20	2026-08-28 14:20	SOFI	SOFI260918C00022000	call	22.0000	2026-09-18	0.0900	0.0900	0.1000	18.1250	13473.00	0.00	13473.00	1497	23	3871	148753	0.0260230045780589	0.556221434638288	0.556221434638288	false	false	false	true
48f6b396-3ec7-4182-b724-658152786aa0	2026-08-28 14:07	2026-08-28 14:07	2026-08-28 14:07	SOFI	SOFI270617C00020000	call	20.0000	2027-06-17	3.3500	3.3500	3.4000	18.1300	10720.00	0.00	10720.00	32	5	415	27261	0.0152232126481054	0.594476201222228	0.594476201222228	false	false	false	true
bd47234b-3080-4a89-8880-b3dba2da3b27	2026-08-28 14:05	2026-08-28 14:05	2026-08-28 14:05	SOFI	SOFI260904C00019000	call	19.0000	2026-09-04	0.2000	0.2000	0.2100	18.1600	121220.00	0.00	121220.00	6061	9	24309	10168	2.39073564122738	0.497354027021594	0.497354027021594	false	false	false	true
5b2ffd55-5a96-4e07-b3d6-8acb8a047f68	2026-08-28 13:58	2026-08-28 13:58	2026-08-28 13:58	SOFI	SOFI270115C00019000	call	19.0000	2027-01-15	2.3100	2.3100	2.3400	18.1950	46662.00	0.00	46662.00	202	15	1215	4656	0.260953608247423	0.564088610349913	0.564689203181613	false	false	false	true
8ba6fa06-45a1-401c-8b60-13a88b6e0989	2026-08-28 13:52	2026-08-28 13:51	2026-08-28 13:51	SOFI	SOFI270319C00022000	call	22.0000	2027-03-19	2.0200	2.0000	2.0200	18.1999	19392.00	19392.00	0.00	96	10	297	4570	0.0649890590809628	0.585570949728904	0.585570949728904	false	false	false	true
9e3857e5-27f0-4ac1-b17c-011ddd84f263	2026-08-28 13:51	2026-08-28 13:50	2026-08-28 13:50	SOFI	SOFI270115C00021000	call	21.0000	2027-01-15	1.6500	1.6200	1.6500	18.1827	41250.00	41250.00	0.00	250	8	847	4875	0.17374358974359	0.570209988375873	0.570209988375873	false	false	false	true
44993d62-7b01-4e01-b22d-89724c896eba	2026-08-28 13:48	2026-08-28 13:48	2026-08-28 13:48	SOFI	SOFI270115C00025000	call	25.0000	2027-01-15	0.8400	0.8300	0.8500	18.1800	11424.00	0.00	0.00	136	5	1717	99839	0.0171976882781278	0.581219898599797	0.581219898599797	false	false	false	true
6f24529f-8224-445f-88e0-1b6a66d8f6aa	2026-08-28 13:43	2026-08-28 13:43	2026-08-28 13:43	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.0700	2.0300	2.0700	18.1850	124200.00	124200.00	0.00	600	11	6256	22512	0.277896233120114	0.59825694450358	0.597941959522881	false	false	false	true
7a0f5e46-5f0d-4a51-8c72-9a580c0d3185	2026-08-28 13:40	2026-08-28 13:40	2026-08-28 13:40	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.0700	2.0300	2.0700	18.1850	51750.00	51750.00	0.00	250	16	5604	22512	0.248933901918977	0.597941959522881	0.597941959522881	false	false	false	true
ccb908ff-2b8c-47bd-a7ae-07461ee0a798	2026-08-28 13:40	2026-08-28 13:39	2026-08-28 13:39	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.0700	2.0300	2.0800	18.1901	20700.00	20700.00	0.00	100	8	5354	22512	0.237828713574982	0.597620743108221	0.597620743108221	false	false	false	true
4f7b96f2-409e-4c75-82bf-dd172cd2362e	2026-08-28 13:39	2026-08-28 13:39	2026-08-28 13:39	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.0800	2.0300	2.0800	18.2040	34320.00	23920.00	0.00	165	10	5169	22512	0.229610874200426	0.598337107609298	0.598337107609298	false	false	false	true
196ba8c4-300b-42c2-b037-f2b1f1acb7c5	2026-08-28 13:39	2026-08-28 13:39	2026-08-28 13:39	SOFI	SOFI270115P00016000	put	16.0000	2027-01-15	1.3200	1.3200	1.3300	18.2150	118800.00	0.00	118800.00	900	14	1440	3490	0.412607449856734	0.562750269579276	0.562750269579276	false	false	false	true
8847aeeb-fd1d-4454-b3fe-7bf61902dd56	2026-08-28 13:34	2026-08-28 13:34	2026-08-28 13:34	SOFI	SOFI261016P00017000	put	17.0000	2026-10-16	0.7300	0.7300	0.7400	18.2350	14600.00	0.00	14600.00	200	5	1798	4769	0.377018242818201	0.50081401153334	0.50081401153334	false	false	false	true
2c57fce6-df57-4f5f-bd41-16995fcf1a69	2026-08-28 13:31	2026-08-28 13:31	2026-08-28 13:31	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.0800	2.0200	2.0800	18.2150	10400.00	8320.00	0.00	50	9	4652	22512	0.206645344705046	0.597643879782743	0.597643879782743	false	false	false	true
34db9aa1-b9a8-4093-b0d9-d23dac6289d8	2026-08-28 13:28	2026-08-28 13:28	2026-08-28 13:28	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.0900	2.0800	2.1000	18.2400	41800.00	35530.00	6270.00	200	7	4602	22512	0.204424307036247	0.597656731414217	0.597656731414217	false	false	false	true
1472749d-a278-486b-8871-6d1f45bbbd2a	2026-08-28 13:28	2026-08-28 13:28	2026-08-28 13:28	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.0900	2.0800	2.1000	18.2400	41800.00	33440.00	0.00	200	10	4402	22512	0.195540156361052	0.597656731414217	0.597656731414217	false	false	false	true
c1640ebe-6bb3-49ba-bca5-da35711a816c	2026-08-28 13:25	2026-08-28 13:25	2026-08-28 13:25	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.2900	0.2800	0.3000	18.2450	24389.00	0.00	24360.00	841	39	17729	47013	0.377108459362304	0.491869751756885	0.491869751756885	false	false	false	true
8e8a9402-a004-46c2-8422-2324a1b0e8cd	2026-08-28 13:23	2026-08-28 13:23	2026-08-28 13:23	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.0900	2.0800	2.1000	18.2401	62698.00	52250.00	416.00	300	11	4202	22512	0.186656005685856	0.597650427916492	0.596063254070261	false	false	false	true
a575ef2c-d965-4134-a474-ac8347776a74	2026-08-28 13:21	2026-08-28 13:21	2026-08-28 13:21	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.0900	2.0100	2.0900	18.2500	10450.00	10450.00	0.00	50	7	3852	22512	0.171108742004264	0.597026511732391	0.597026511732391	false	false	false	true
872b2ced-787e-4cd4-9e3e-20f7bc89fd81	2026-08-28 13:20	2026-08-28 13:20	2026-08-28 13:20	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.1000	2.0100	2.1000	18.2750	84000.00	84000.00	0.00	400	9	3802	22512	0.168887704335466	0.597035115060044	0.597035115060044	false	false	false	true
1c7cdf4a-9dd1-41bf-9b24-4cc63f8cb347	2026-08-28 13:20	2026-08-28 13:20	2026-08-28 13:20	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.1000	2.0100	2.1000	18.2800	10500.00	9030.00	0.00	50	11	3402	22512	0.151119402985075	0.596719959176362	0.596719959176362	false	false	false	true
5bb2a3e6-705f-4ab0-96d7-c39fd2cb3255	2026-08-28 13:19	2026-08-28 13:18	2026-08-28 13:18	SOFI	SOFI270115C00030000	call	30.0000	2027-01-15	0.4100	0.4000	0.4100	18.2550	10250.00	10250.00	0.00	250	12	986	76891	0.012823347335839	0.607537945686805	0.607537945686805	false	false	false	true
b02d1543-fa72-47b7-be7f-0678a916cf97	2026-08-28 13:11	2026-08-28 13:10	2026-08-28 13:10	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.0900	2.0100	2.0900	18.2550	73150.00	73150.00	0.00	350	9	3302	22512	0.146677327647477	0.596711500323492	0.596711500323492	false	false	false	true
d058e01d-2912-43ed-ac13-79e5ea92b789	2026-08-28 13:10	2026-08-28 13:10	2026-08-28 13:10	SOFI	SOFI260925P00018000	put	18.0000	2026-09-25	0.8200	0.8100	0.8500	18.2300	16400.00	0.00	16400.00	200	6	597	1523	0.39198949441891	0.477975328574433	0.477975328574433	false	false	false	true
eec32d61-7c22-4343-ae99-7236110c0a8b	2026-08-28 13:09	2026-08-28 13:09	2026-08-28 13:09	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.0900	2.0100	2.0900	18.2400	52250.00	52250.00	0.00	250	15	2902	22512	0.128909026297086	0.597656731414217	0.597656731414217	false	false	false	true
5b1e6d0c-fa6c-4ebc-bd5f-e140dc5283e1	2026-08-28 13:09	2026-08-28 13:09	2026-08-28 13:09	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.0900	2.0100	2.1300	18.2301	31350.00	25707.00	418.00	150	10	2652	22512	0.117803837953092	0.598280907993603	0.598280907993603	false	false	false	true
9e64cdf0-1ca4-4ef1-8614-31b50802250f	2026-08-28 12:58	2026-08-28 12:57	2026-08-28 12:57	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.1300	2.1000	2.1400	18.3100	21300.00	18744.00	2556.00	100	5	2021	22512	0.08977434257285	0.599558138775545	0.599564461526541	false	false	false	true
01ff7085-fc59-48e1-9ad1-6f8147fcf3d7	2026-08-28 12:55	2026-08-28 12:55	2026-08-28 12:55	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.1300	2.1000	2.1600	18.3250	31950.00	28755.00	0.00	150	6	1471	22512	0.0653429282160626	0.598616340790149	0.598616340790149	false	false	false	true
48d3b35b-9372-4c73-8a55-b510d255b7de	2026-08-28 12:50	2026-08-28 12:50	2026-08-28 12:50	SOFI	SOFI270617C00025000	call	25.0000	2027-06-17	2.1400	2.1100	2.1500	18.3700	58850.00	58850.00	0.00	275	7	1221	22512	0.0542377398720682	0.597346268295862	0.597346268295862	false	false	false	true
c4900cba-c1a0-404b-a8eb-526fdab2af2d	2026-08-28 12:40	2026-08-28 12:40	2026-08-28 12:40	SOFI	SOFI270115C00018000	call	18.0000	2027-01-15	2.8600	2.8600	2.9000	18.3600	18018.00	0.00	18018.00	63	33	276	5922	0.0466058763931104	0.571052752894439	0.571052752894439	false	false	false	true
a0326d4e-2875-448e-979a-40e161a4b732	2026-08-28 12:38	2026-08-28 12:38	2026-08-28 12:38	SOFI	SOFI260918C00018000	call	18.0000	2026-09-18	1.0800	1.0700	1.0800	18.3899	21600.00	21600.00	0.00	200	15	1149	16220	0.0708384710234279	0.487939097191718	0.487939097191718	false	false	false	true
9294b57a-153b-4148-84c1-faf66fb6e6a9	2026-08-28 12:34	2026-08-28 12:34	2026-08-28 12:34	SOFI	SOFI261120C00018000	call	18.0000	2026-11-20	2.2600	2.2600	2.3000	18.3700	10396.00	0.00	10396.00	46	5	341	5292	0.0644368858654573	0.574595936014176	0.574595936014176	false	false	false	true
45d38ccf-914c-4ec2-b5ea-9af4e5e22659	2026-08-28 12:30	2026-08-28 12:30	2026-08-28 12:30	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.3200	0.3200	0.3300	18.3400	20352.00	0.00	20352.00	636	26	15168	47013	0.322634165018186	0.496369605669753	0.496369605669753	false	false	false	true
fbb13f2d-36a7-415c-9b21-97d7ba4196d0	2026-08-28 12:30	2026-08-28 12:30	2026-08-28 12:30	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.3200	0.3200	0.3300	18.3302	18176.00	0.00	18176.00	568	25	14532	47013	0.309105991959671	0.498147867237808	0.498147867237808	false	false	false	true
4d401122-e5dc-4d70-ab25-a796fa40ef43	2026-08-28 12:27	2026-08-28 12:27	2026-08-28 12:27	SOFI	SOFI260911P00018500	put	18.5000	2026-09-11	0.7600	0.7500	0.7600	18.3250	19684.00	19684.00	0.00	259	15	1931	1762	1.09591373439274	0.475609434567321	0.475609434567321	false	false	false	true
4ac9ae31-8a80-4372-bee9-117860411dda	2026-08-28 12:27	2026-08-28 12:27	2026-08-28 12:27	SOFI	SOFI260911C00018500	call	18.5000	2026-09-11	0.6100	0.6000	0.6100	18.3250	13603.00	13603.00	0.00	223	14	1237	1939	0.637957710159876	0.474200537728292	0.474200537728292	false	false	false	true
972769b1-a016-474a-ac53-36cba431e620	2026-08-28 12:26	2026-08-28 12:26	2026-08-28 12:26	SOFI	SOFI261218C00020000	call	20.0000	2026-12-18	1.7300	1.7300	1.7600	18.3250	34600.00	0.00	34600.00	200	5	722	15957	0.04524660023814	0.568195321529537	0.568195321529537	false	false	false	true
9f2d7a90-0352-45d6-8d44-3441503e2c5f	2026-08-28 12:24	2026-08-28 12:24	2026-08-28 12:24	SOFI	SOFI260904C00020000	call	20.0000	2026-09-04	0.0900	0.0900	0.1000	18.3300	40932.00	0.00	40932.00	4548	37	14253	22381	0.636834815245074	0.544142526725079	0.544142526725079	false	false	false	true
59a7a073-ea2a-402e-8c25-efcb1559572e	2026-08-28 12:19	2026-08-28 12:19	2026-08-28 12:19	SOFI	SOFI260904C00020000	call	20.0000	2026-09-04	0.1000	0.0900	0.1000	18.4000	15000.00	15000.00	0.00	1500	22	9537	22381	0.42612036995666	0.544593552956015	0.544593552956015	true	false	false	true
5fcc2fc9-3b10-4d15-b651-5bcaa159f5fa	2026-08-28 12:18	2026-08-28 12:18	2026-08-28 12:18	SOFI	SOFI280616P00020000	put	20.0000	2028-06-16	5.9500	5.7500	5.9500	18.3800	70210.00	70210.00	0.00	118	11	199	2977	0.066845817937521	0.610151219903573	0.610151219903573	false	false	false	true
3be7ab2b-dd08-455a-a44e-4c39bbf8192c	2026-08-28 12:16	2026-08-28 12:16	2026-08-28 12:16	SOFI	SOFI261016P00018000	put	18.0000	2026-10-16	1.1000	1.0600	1.1000	18.4220	10890.00	10890.00	0.00	99	14	691	4698	0.14708386547467	0.505907681441561	0.505907681441561	false	false	false	true
91528dad-07e0-4708-8515-c60cd2f00169	2026-08-28 12:15	2026-08-28 12:15	2026-08-28 12:15	SOFI	SOFI270115C00019000	call	19.0000	2027-01-15	2.4600	2.4600	2.5000	18.4700	17220.00	0.00	17220.00	70	9	712	4656	0.152920962199313	0.564650825938104	0.564650825938104	false	false	false	true
fd8ae974-2b5b-407e-9826-69867f8d0e17	2026-08-28 12:14	2026-08-28 12:14	2026-08-28 12:14	SOFI	SOFI270115C00018000	call	18.0000	2027-01-15	2.9300	2.9300	2.9500	18.4600	29300.00	0.00	29300.00	100	10	209	5922	0.0352921310368119	0.573076978161193	0.573076978161193	false	false	false	true
0634cc07-05e0-41d1-be62-d09346e7c1b0	2026-08-28 12:05	2026-08-28 12:05	2026-08-28 12:05	SOFI	SOFI261218C00018000	call	18.0000	2026-12-18	2.6700	2.6600	2.6900	18.0000	10146.00	0.00	10146.00	38	5	822	5855	0.140392826643894	0.576658748535083	0.576658748535083	false	false	false	true
0072ea34-0c12-4dcd-8a1e-e381fdc7449c	2026-08-28 12:02	2026-08-28 12:01	2026-08-28 12:01	SOFI	SOFI260918P00019000	put	19.0000	2026-09-18	1.0900	1.0900	1.1100	18.0000	11336.00	0.00	11336.00	104	6	1601	16749	0.0955877962863455	0.479111493599806	0.479111493599806	false	false	false	true
cfa41511-bb56-4515-bd56-b8dadd9f0631	2026-08-28 11:56	2026-08-28 11:56	2026-08-28 11:56	SOFI	SOFI260904C00019000	call	19.0000	2026-09-04	0.3200	0.3200	0.3300	18.0000	192000.00	0.00	192000.00	6000	10	14894	10168	1.46479150275374	0.484780331146339	0.484780331146339	false	false	false	true