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:option_symbol = SOFI260918C00020000×ticker = SOFI×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	expiry

bc8cf61b-1481-4f1f-9806-d35f1dd4fa20	2026-08-18 09:30	2026-08-18 09:30	2026-08-18 09:30	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.3700	0.3500	0.3800	18.0399	43215.00	33300.00	9915.00	1171	53	1456	35904	0.0405525846702317	0.485606532154758	0.480289847626134	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	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-18T13:38:24.498702Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
cc52ecc6-7f6e-4aaf-80e6-1a053e60d113	2026-08-19 10:12	2026-08-19 10:12	2026-08-19 10:12	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.3300	0.3200	0.3300	17.9809	14091.00	14091.00	0.00	427	12	1306	38038	0.0343340869656659	0.473322734519231	0.473322734519231	true	false	false	true
35d434e0-62f9-44f5-9f7f-5386247b0eb1	2026-08-19 10:17	2026-08-19 10:17	2026-08-19 10:17	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.3500	0.3400	0.3500	18.1150	22120.00	22120.00	0.00	632	7	2187	38038	0.0574951364425049	0.465067158506466	0.465067158506466	false	false	false	true
2c40d249-cebc-4c55-858b-d4d05e169a79	2026-08-19 11:03	2026-08-19 11:03	2026-08-19 11:03	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.4900	0.4800	0.4900	18.5150	36750.00	36750.00	0.00	750	18	5286	38038	0.138966296861034	0.478956150449964	0.478956150449964	false	false	false	true
0c85a9c5-6ecd-4919-a8e5-4daa528ada38	2026-08-20 12:09	2026-08-20 12:08	2026-08-20 12:08	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.3200	0.3100	0.3200	17.8450	34227.00	27872.00	6355.00	1076	59	5064	38866	0.130293830082849	0.496061797295999	0.496061797295999	false	false	false	true
a31ef96f-593f-4776-9cac-9f6df815b17c	2026-08-21 09:48	2026-08-21 09:48	2026-08-21 09:48	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5500	0.5400	0.5500	18.6750	12210.00	12210.00	0.00	222	6	2291	40235	0.0569404747110724	0.500122326119646	0.500122326119646	false	false	false	true
1d8d03ce-0810-440b-8d95-9dfa9891d386	2026-08-21 09:52	2026-08-21 09:52	2026-08-21 09:52	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.6200	0.6100	0.6200	18.7650	16430.00	16430.00	0.00	265	10	3239	40235	0.0805020504535852	0.519965290576069	0.519965290576069	false	false	false	true
d3e18db7-71a6-475a-bd30-67244fc47ffe	2026-08-21 09:53	2026-08-21 09:53	2026-08-21 09:53	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.6600	0.6400	0.6700	18.8200	43949.00	38539.00	3200.00	669	34	4261	40235	0.105902820927054	0.521756563306907	0.530016045483607	true	false	false	true
36736d46-04b2-4c25-bfed-d80dd885f9b5	2026-08-21 09:53	2026-08-21 09:53	2026-08-21 09:53	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.6600	0.6400	0.6600	18.8050	72270.00	72270.00	0.00	1095	44	5372	40235	0.133515595874239	0.532855493298876	0.532855493298876	true	false	false	true
af2808a4-e3c2-478e-8331-cfe76eee7518	2026-08-21 09:53	2026-08-21 09:53	2026-08-21 09:53	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.6600	0.6500	0.6600	18.8003	17556.00	17556.00	0.00	266	15	5801	40235	0.144177954517211	0.533744482005471	0.533744482005471	true	false	false	true
83414298-3bd1-48ae-a0fb-27fde3b3ced7	2026-08-21 09:58	2026-08-21 09:58	2026-08-21 09:58	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.7700	0.7700	0.7800	19.0350	19404.00	0.00	19404.00	252	5	7704	40235	0.191475083882192	0.542923906062822	0.542923906062822	false	false	false	true
9c25ebcf-7200-4ec3-8dbc-789d3f6225a3	2026-08-21 10:04	2026-08-21 10:04	2026-08-21 10:04	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.7300	0.7200	0.7500	18.9800	13286.00	0.00	13286.00	182	8	8888	40235	0.220902199577482	0.534152176876562	0.534152176876562	false	false	false	true
c6b6b594-7dca-401b-b9a6-7cc033c14174	2026-08-21 10:04	2026-08-21 10:04	2026-08-21 10:04	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.7200	0.7200	0.7300	18.9752	11376.00	0.00	11376.00	158	8	9047	40235	0.224853982850752	0.530155400052778	0.530155400052778	true	false	false	true
7066178c-3968-4fe8-92f1-b6ef10de4b93	2026-08-21 13:43	2026-08-21 13:43	2026-08-21 13:43	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.6600	0.6400	0.6600	18.9380	50094.00	50094.00	0.00	759	7	15431	40235	0.383521809369952	0.507552025654156	0.507552025654156	false	false	false	true
35e7eba0-a05c-4fd5-895b-df142f523d0a	2026-08-21 14:38	2026-08-21 14:38	2026-08-21 14:38	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.6400	0.6300	0.6400	18.9400	19264.00	19264.00	0.00	301	14	16280	40235	0.40462284081024	0.497169503215557	0.497169503215557	false	false	false	true
99ed52a4-27b8-4397-a764-7019eec762f4	2026-08-24 09:35	2026-08-24 09:35	2026-08-24 09:35	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5200	0.5100	0.5300	18.6450	96377.00	60027.00	26418.00	1858	120	2375	41744	0.0568944039862016	0.523481414619465	0.52480358917682	true	false	false	true
ea48c443-fc04-41d4-bc9b-8b1183573579	2026-08-24 09:36	2026-08-24 09:36	2026-08-24 09:36	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5100	0.5000	0.5100	18.5789	15299.00	15249.00	50.00	300	8	3039	41744	0.0728008815638176	0.527548441995238	0.520182541130275	false	false	false	true
6ceda546-2d1c-45c2-909b-e27a9936d51d	2026-08-24 09:59	2026-08-24 09:59	2026-08-24 09:59	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5700	0.5600	0.5700	18.8253	11400.00	11400.00	0.00	200	7	5449	41744	0.130533729398237	0.512362503892409	0.512362503892409	false	false	false	true
1470c241-fcab-447a-a125-2328cb1aea98	2026-08-24 10:00	2026-08-24 10:00	2026-08-24 10:00	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5800	0.5800	0.5900	18.8500	11716.00	0.00	11716.00	202	5	5938	41744	0.142247987734764	0.512970109023679	0.512970109023679	false	false	false	true
cf91951c-1d11-4997-acf9-7edad97015b1	2026-08-24 14:01	2026-08-24 14:01	2026-08-24 14:01	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.4200	0.4100	0.4200	18.3699	12516.00	12516.00	0.00	298	19	15125	41744	0.362327520122652	0.511004462254375	0.511004462254375	false	false	false	true
4b61a81d-b0b3-4a26-84ed-7e9a64870120	2026-08-25 09:37	2026-08-25 09:37	2026-08-25 09:37	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.4100	0.3900	0.4200	18.3950	56002.00	40962.00	2760.00	1367	77	1912	47235	0.0404784587699799	0.515640138045036	0.517351943802241	false	false	false	true
d7c02166-8902-454c-b392-4c1d5d51e1cf	2026-08-25 09:37	2026-08-25 09:37	2026-08-25 09:37	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.4200	0.3900	0.4200	18.3999	18119.00	18119.00	0.00	436	21	2360	47235	0.0499629512014396	0.517351943802241	0.510291594146086	false	false	false	true
993d6412-c625-4020-bedc-9b960b904a48	2026-08-25 09:38	2026-08-25 09:38	2026-08-25 09:38	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.4200	0.4100	0.4200	18.4050	12600.00	12600.00	0.00	300	12	2715	47235	0.0574785646236901	0.515546404080321	0.515546404080321	false	false	false	true
c302d0a7-a6c0-4d52-91b0-091886b38900	2026-08-25 10:28	2026-08-25 10:28	2026-08-25 10:28	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5300	0.5300	0.5400	18.7201	11872.00	0.00	11872.00	224	6	5767	47235	0.122091669313009	0.521480834823805	0.521480834823805	false	false	false	true
a9a312c0-35ae-4d29-9bbc-bd59795affeb	2026-08-25 11:00	2026-08-25 10:59	2026-08-25 10:59	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5800	0.5800	0.5900	18.8550	13429.00	5251.00	8178.00	230	54	7648	47235	0.16191383507992	0.528445721164825	0.528445721164825	false	false	false	true
fd108fb0-32e1-479d-b7ee-2d25f7c9c7d1	2026-08-25 11:08	2026-08-25 11:08	2026-08-25 11:08	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5400	0.5400	0.5500	18.7600	24300.00	0.00	24300.00	450	11	9989	47235	0.211474542182704	0.519378839327381	0.519378839327381	false	false	false	true
d99eb30f-0754-4789-ab38-31f21f2b279d	2026-08-25 12:21	2026-08-25 12:21	2026-08-25 12:21	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5400	0.5400	0.5500	18.7999	10638.00	0.00	10638.00	197	12	13975	47235	0.295861119932254	0.511580637672743	0.511580637672743	false	false	false	true
36fc6990-8d81-442d-afa5-831ca491fc45	2026-08-25 12:21	2026-08-25 12:21	2026-08-25 12:21	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5400	0.5400	0.5500	18.7850	30785.00	3245.00	27540.00	569	72	14759	47235	0.312458981687308	0.51351797751315	0.514495811095613	false	false	false	true
864a0ef5-5f06-4932-b48c-e53b107534e7	2026-08-25 12:21	2026-08-25 12:21	2026-08-25 12:21	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5400	0.5300	0.5500	18.7750	33092.00	8360.00	20304.00	610	66	15895	47235	0.33650894463851	0.521066574456036	0.516450242065411	false	false	false	true
0dd20a69-d236-4bec-a723-f858ba0bce64	2026-08-25 12:21	2026-08-25 12:21	2026-08-25 12:21	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5400	0.5400	0.5500	18.7701	10801.00	55.00	10746.00	200	7	16753	47235	0.354673441304118	0.516450242065411	0.523027636449086	false	false	false	true
ddca0d1b-b96b-48c6-852e-09cb7fba9057	2026-08-25 12:43	2026-08-25 12:43	2026-08-25 12:43	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5500	0.5500	0.5700	18.8563	13750.00	0.00	13750.00	250	6	17670	47235	0.374087011749762	0.506067920861751	0.506067920861751	false	false	false	true
0606b8cf-3794-4b3a-b0d9-aa826fa439eb	2026-08-25 14:16	2026-08-25 14:16	2026-08-25 14:16	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5600	0.5600	0.5700	18.0000	11928.00	0.00	11928.00	213	6	18755	47235	0.397057266857203	0.516820330815319	0.516820330815319	false	false	false	true
6110f131-6c81-40b9-b293-7c4db9cbdfc5	2026-08-25 14:37	2026-08-25 14:36	2026-08-25 14:36	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5100	0.5100	0.5400	18.7400	16137.00	0.00	16137.00	316	11	19243	47235	0.407388588970043	0.517622342801195	0.506269883542549	true	false	false	true
e89b04be-fa9c-4cc5-8a6c-4d75dfc7b348	2026-08-25 14:53	2026-08-25 14:53	2026-08-25 14:53	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5800	0.5800	0.5900	18.9000	15370.00	0.00	15370.00	265	9	20521	47235	0.434444797290145	0.513929196254509	0.513929196254509	false	false	false	true
97fe1b75-f438-41f2-b49e-1de881a2c6f2	2026-08-25 15:00	2026-08-25 15:00	2026-08-25 15:00	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5900	0.5800	0.6000	18.9400	18113.00	12213.00	0.00	307	9	21608	47235	0.457457393881656	0.511351235627271	0.511351235627271	false	false	false	true
39cbe062-e629-472d-9266-dfc7e8bf675e	2026-08-25 15:28	2026-08-25 15:27	2026-08-25 15:27	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5900	0.5800	0.5900	18.8750	26432.00	26432.00	0.00	448	11	23706	47235	0.501873610670054	0.524435635395268	0.524435635395268	false	false	false	true
ca169c8b-ad97-45d1-a2c3-764fe3434fdb	2026-08-26 15:12	2026-08-26 15:12	2026-08-26 15:12	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5500	0.5500	0.5600	18.9050	11660.00	0.00	11660.00	212	8	8755	48188	0.181684236739437	0.507470390518833	0.507470390518833	true	false	false	true
18f9bb4f-c1c8-412d-ba4a-b359d16d43fb	2026-08-27 09:36	2026-08-27 09:36	2026-08-27 09:36	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.5500	0.5300	0.5600	18.9300	94824.00	62863.00	6512.00	1728	111	2259	47303	0.0477559562818426	0.512427796850223	0.514043595593965	true	false	false	true
3cd3d85b-3365-40ba-b120-edcfcbd19e14	2026-08-27 09:51	2026-08-27 09:51	2026-08-27 09:51	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.7500	0.7300	0.7700	19.4350	11025.00	10950.00	75.00	147	20	4303	47303	0.090966746295161	0.512553741667099	0.512553741667099	false	false	false	true
54dbdf23-5b05-42c4-8063-83eb185159ea	2026-08-27 09:51	2026-08-27 09:51	2026-08-27 09:51	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.7500	0.7500	0.7800	19.4350	11070.00	3420.00	7650.00	147	43	4459	47303	0.0942646343783692	0.511380467530685	0.517862821287148	false	false	false	true
5da4a547-495a-4ae3-9e2d-e5f0e0e3747c	2026-08-27 11:10	2026-08-27 11:10	2026-08-27 11:10	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.6900	0.6800	0.6900	19.3000	14250.00	7314.00	6936.00	208	41	7666	47303	0.16206160285817	0.505029038893342	0.511561557153154	false	false	false	true
5438b156-8d76-4c37-a45d-dbb9b8a301ce	2026-08-27 11:18	2026-08-27 11:18	2026-08-27 11:18	SOFI	SOFI260918C00020000	call	20.0000	2026-09-18	0.6800	0.6800	0.6900	19.3150	27200.00	0.00	27200.00	400	24	8437	47303	0.17836078050018	0.502765140020317	0.502765140020317	true	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
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
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
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
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
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
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