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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×ticker = URA×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

db1374ed-7130-48e9-9982-fe13698f2690	2026-08-17 10:38	2026-08-17 10:38	2026-08-17 10:38	URA	URA260904C00050000	call	50.0000	2026-09-04	0.5000	0.5000	0.6000	45.4400	117050.00	0.00	117050.00	2341	16	2342	52	45.0384615384615	0.469897054720497	0.469897054720497	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	2922340149.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
dc805b18-b95c-44ad-9256-efa9925300f5	2026-08-17 10:56	2026-08-17 10:55	2026-08-17 10:55	URA	URA260918C00050000	call	50.0000	2026-09-18	1.1000	1.0000	1.1000	45.9587	109996.00	109996.00	0.00	1000	46	2047	26879	0.0761561069980282	0.459410470233051	0.458228259486313	true	false	false	true
f4cf1d78-9735-4330-962c-ab2361a50f92	2026-08-17 11:32	2026-08-17 11:31	2026-08-17 11:31	URA	URA260904C00048000	call	48.0000	2026-09-04	1.0500	0.9500	1.0500	45.8082	105008.00	105008.00	0.00	1000	15	1001	153	6.54248366013072	0.468284657648973	0.460327916797232	true	false	false	true
41069a3c-169a-4816-96bd-e3582d4e6903	2026-08-18 11:10	2026-08-18 11:09	2026-08-18 11:09	URA	URA261016P00040000	put	40.0000	2026-10-16	1.5500	1.4500	1.6000	43.1800	313420.00	31465.00	148500.00	2022	46	2039	1594	1.27917189460477	0.444227867747323	0.444716556075996	false	false	false	true
52c51a81-eaa9-4fc8-980b-42d72c35ba9d	2026-08-18 11:10	2026-08-18 11:10	2026-08-18 11:10	URA	URA261016P00040000	put	40.0000	2026-10-16	1.5200	1.4500	1.7500	43.1900	366705.00	34640.00	146960.00	2418	118	4458	1594	2.79673776662484	0.445204859871289	0.436779514231281	true	false	false	true
3cd5fd9a-a29b-4a32-8edd-7be1102ed9a4	2026-08-18 11:10	2026-08-18 11:10	2026-08-18 11:10	URA	URA261016P00040000	put	40.0000	2026-10-16	1.5000	1.5000	1.6500	43.2100	304958.00	0.00	304958.00	2033	65	6491	1594	4.07214554579674	0.436779514231281	0.437750556363911	false	false	false	true
d4ad8d83-44a0-480c-b8d1-c048a3eed12c	2026-08-18 11:10	2026-08-18 11:10	2026-08-18 11:10	URA	URA261016P00040000	put	40.0000	2026-10-16	1.5000	1.4500	1.6500	43.2150	360900.00	174750.00	183000.00	2406	106	8902	1594	5.58469259723965	0.437750556363911	0.437993078286681	true	false	false	true
5033f351-695d-42db-a280-a28625730580	2026-08-19 10:48	2026-08-19 10:48	2026-08-19 10:48	URA	URA261218C00050000	call	50.0000	2026-12-18	2.9000	2.9000	3.1000	44.4550	729350.00	0.00	729350.00	2515	32	2517	175	14.3828571428571	0.463014335779244	0.463014335779244	false	false	false	true
81b39fb5-6a60-45a2-8635-030d3833c437	2026-08-20 11:06	2026-08-20 11:06	2026-08-20 11:06	URA	URA280121P00039000	put	39.0000	2028-01-21	5.8000	5.8000	6.2000	43.9800	406000.00	0.00	406000.00	700	28	3303	1028	3.21303501945525	0.473958001281125	0.473958001281125	false	false	false	true
5b76f380-d9db-4156-a4a3-6eceb9d86ccd	2026-08-21 09:57	2026-08-21 09:57	2026-08-21 09:57	URA	URA261016P00035000	put	35.0000	2026-10-16	0.2200	0.1500	0.2500	46.0601	330000.00	150000.00	0.00	15000	2	15012	15385	0.975755606109847	0.46783608584806	0.46783608584806	false	true	false	true
7a7580b7-14c1-49d4-b1f7-14aeab63d86e	2026-08-21 11:23	2026-08-21 11:23	2026-08-21 11:23	URA	URA260918C00051000	call	51.0000	2026-09-18	0.5500	0.5000	0.5500	45.2900	12980.00	12980.00	0.00	236	23	249	243	1.02469135802469	0.444602840064388	0.444602840064388	false	false	false	true
0df30bf7-7c87-4f9b-a4e9-2e2d14f69aeb	2026-08-21 12:06	2026-08-21 12:06	2026-08-21 12:06	URA	URA260918C00045000	call	45.0000	2026-09-18	2.6500	2.4500	2.6500	45.5800	15900.00	15900.00	0.00	60	6	103	605	0.170247933884298	0.455950419954343	0.455950419954343	false	false	false	true
40fc9334-33ef-4bef-a8e7-5cb68f4bce4d	2026-08-24 14:05	2026-08-24 14:04	2026-08-24 14:04	URA	URA261218C00045000	call	45.0000	2026-12-18	5.2000	5.2000	5.6000	45.7700	17680.00	0.00	17680.00	34	6	51	108	0.472222222222222	0.445456881851346	0.445456881851346	false	false	false	true
7a41f8ea-6e67-4d3e-a950-169f062fd59f	2026-08-25 10:10	2026-08-25 10:10	2026-08-25 10:10	URA	URA261016P00043000	put	43.0000	2026-10-16	1.3000	1.2000	1.3000	47.1300	89700.00	89700.00	0.00	690	7	696	1111	0.626462646264626	0.442353207931909	0.442353207931909	false	false	false	true
ab6e16d6-d140-4ca2-9e8b-26762866b2b9	2026-08-25 10:37	2026-08-25 10:37	2026-08-25 10:37	URA	URA261016P00040000	put	40.0000	2026-10-16	0.6000	0.5500	0.6500	47.4200	36720.00	12480.00	5400.00	612	10	1017	11394	0.0892575039494471	0.456533815984466	0.456533815984466	false	false	false	true
03888849-c90a-46e4-a0d7-7808686a77f5	2026-08-25 10:40	2026-08-25 10:40	2026-08-25 10:40	URA	URA261016P00040000	put	40.0000	2026-10-16	0.6000	0.5500	0.6500	47.6100	16560.00	7560.00	8280.00	276	15	2013	11394	0.176671932596103	0.463098288205683	0.463098288205683	false	false	false	true
e19b647b-2ea2-4532-87ff-4bdd6d32aecd	2026-08-25 10:40	2026-08-25 10:40	2026-08-25 10:40	URA	URA261016P00040000	put	40.0000	2026-10-16	0.6000	0.5500	0.6500	47.5800	22440.00	0.00	2580.00	374	7	2387	11394	0.209496226083904	0.462065653966148	0.462065653966148	false	false	false	true
d4ef65c6-1aba-47e9-bf6c-b885344a4441	2026-08-25 10:43	2026-08-25 10:43	2026-08-25 10:43	URA	URA261016C00045000	call	45.0000	2026-10-16	4.9000	4.7000	4.9000	47.6400	196000.00	196000.00	0.00	400	35	1111	705	1.57588652482269	0.469037894101135	0.469037894101135	false	false	false	true
f7ad01fd-79d6-45cb-8142-53da1d1379ff	2026-08-25 10:43	2026-08-25 10:43	2026-08-25 10:43	URA	URA261016P00040000	put	40.0000	2026-10-16	0.6000	0.5500	0.6500	47.6800	33840.00	0.00	32040.00	564	9	3619	11394	0.317623310514306	0.465502199917031	0.465502199917031	true	false	false	true
eeb60b49-15e9-4f72-923b-5a51b33e151a	2026-08-25 10:47	2026-08-25 10:47	2026-08-25 10:47	URA	URA261016P00040000	put	40.0000	2026-10-16	0.6000	0.5500	0.6500	47.7000	16440.00	60.00	16260.00	274	13	4355	11394	0.382218711602598	0.466187607360334	0.466187607360334	false	false	false	true
5d13f5eb-74bb-4868-b160-666633d290ac	2026-08-25 10:50	2026-08-25 10:50	2026-08-25 10:50	URA	URA261016P00040000	put	40.0000	2026-10-16	0.6000	0.5500	0.6500	47.7350	51000.00	4500.00	840.00	850	13	5361	11394	0.470510795155345	0.467385555091561	0.467385555091561	false	false	false	true
99986e1c-b2c6-4c9a-843c-33e34c6664da	2026-08-25 10:51	2026-08-25 10:51	2026-08-25 10:51	URA	URA261016P00040000	put	40.0000	2026-10-16	0.6000	0.6000	0.6500	47.7700	10080.00	0.00	10080.00	168	8	5556	11394	0.487625065824118	0.468581581615946	0.468581581615946	true	false	false	true
8d7d6e5c-42d9-4fec-947f-88a1eca46f86	2026-08-25 10:51	2026-08-25 10:51	2026-08-25 10:51	URA	URA261016P00040000	put	40.0000	2026-10-16	0.6000	0.5500	0.6000	47.7850	89998.00	89998.00	0.00	1500	33	7056	11394	0.619273301737757	0.469093578398663	0.469093578398663	false	false	false	true
5e06cc18-2870-4fef-a40d-27f3ede969e1	2026-08-25 10:51	2026-08-25 10:51	2026-08-25 10:51	URA	URA261016P00040000	put	40.0000	2026-10-16	0.6000	0.5500	0.6000	47.7850	212160.00	212100.00	0.00	3536	32	10592	11394	0.929612076531508	0.469093578398663	0.469093578398663	false	false	false	true
0f3ac96d-6ca1-4122-af8c-22e48712b037	2026-08-25 12:00	2026-08-25 11:59	2026-08-25 11:59	URA	URA260911P00048500	put	48.5000	2026-09-11	2.0000	1.9500	2.0000	47.9800	28800.00	28800.00	0.00	144	24	144	0	0	0.427736480252226	0.427736480252226	false	false	false	true
98c37bf5-5ac8-41a6-a9a9-ac1a63f59fef	2026-08-25 12:37	2026-08-25 12:37	2026-08-25 12:37	URA	URA261016C00043000	call	43.0000	2026-10-16	6.4100	6.2000	6.5000	47.8800	19225.00	19225.00	0.00	30	5	299	446	0.670403587443946	0.49059164383685	0.470917927493182	false	false	false	true
1c924ebc-804c-4768-9910-cb8c351e9db7	2026-08-25 12:47	2026-08-25 12:47	2026-08-25 12:47	URA	URA261016C00049000	call	49.0000	2026-10-16	3.0000	2.9500	3.0000	48.1000	12000.00	12000.00	0.00	40	17	44	510	0.0862745098039216	0.454292628992811	0.454292628992811	false	false	false	true
64bf11e6-af42-4909-8556-4416fbfc2f98	2026-08-25 13:21	2026-08-25 13:21	2026-08-25 13:21	URA	URA260904C00048500	call	48.5000	2026-09-04	1.3500	1.2500	1.3500	48.2399	20925.00	20925.00	0.00	155	26	156	14	11.1428571428571	0.455090871858957	0.455090871858957	false	false	false	true
422b42d9-121f-46e1-b736-56ba5d0f23f0	2026-08-25 13:25	2026-08-25 13:25	2026-08-25 13:25	URA	URA260828C00045000	call	45.0000	2026-08-28	3.3000	3.3000	3.4000	48.2700	104940.00	0.00	104940.00	318	19	1053	1111	0.947794779477948	0.397185800545512	0.397185800545512	true	false	false	true
6287e0b3-684e-4ff4-be0b-e6ece5bca4d5	2026-08-25 14:03	2026-08-25 14:03	2026-08-25 14:03	URA	URA261218C00054000	call	54.0000	2026-12-18	3.2000	3.0000	3.2000	48.0000	16000.00	16000.00	0.00	50	5	106	2	53	0.466685191744832	0.466685191744832	false	false	false	true
82ceda38-1d93-4719-bbbe-7330a49d4a06	2026-08-25 14:04	2026-08-25 14:04	2026-08-25 14:04	URA	URA261218C00054000	call	54.0000	2026-12-18	3.2000	3.0000	3.2000	48.0000	16000.00	16000.00	0.00	50	6	156	2	78	0.467332133803455	0.467332133803455	false	false	false	true
858f594a-ada2-49d6-ade8-4cc986081134	2026-08-25 14:37	2026-08-25 14:37	2026-08-25 14:37	URA	URA261016C00052000	call	52.0000	2026-10-16	2.0500	1.9500	2.0500	48.3200	13095.00	13095.00	0.00	64	11	93	146	0.636986301369863	0.464049119590616	0.464049119590616	false	false	false	true
41c30bad-e10b-433a-a036-620113b5e721	2026-08-25 15:50	2026-08-25 15:49	2026-08-25 15:49	URA	URA261016C00052000	call	52.0000	2026-10-16	1.8500	1.8500	2.0000	48.0550	17020.00	0.00	17020.00	92	23	270	146	1.84931506849315	0.44935021098106	0.44935021098106	true	false	false	true
3d896245-304f-4166-919d-b4275d08e390	2026-08-26 09:35	2026-08-26 09:35	2026-08-26 09:35	URA	URA260904C00048000	call	48.0000	2026-09-04	2.1500	2.0000	2.1500	49.1763	17845.00	17845.00	0.00	83	10	83	1081	0.0767807585568918	0.479668046009273	0.479668046009273	false	false	false	true
19b0343c-d024-4670-8d30-37feda7acaa9	2026-08-26 09:45	2026-08-26 09:45	2026-08-26 09:45	URA	URA260918C00050000	call	50.0000	2026-09-18	2.2000	2.0000	2.2000	49.7400	20460.00	20460.00	0.00	93	5	181	28979	0.00624590220504503	0.455281929432578	0.455281929432578	false	false	false	true
e0cf4147-9904-4361-b3ae-6a37edc538e0	2026-08-26 09:49	2026-08-26 09:49	2026-08-26 09:49	URA	URA270115P00045000	put	45.0000	2027-01-15	3.0300	2.7500	3.1000	50.0700	14566.00	14566.00	0.00	48	9	72	5886	0.0122324159021407	0.463625952904612	0.463625952904612	false	false	false	true
bceba0ff-a006-4220-a721-b77817e71e6e	2026-08-26 09:52	2026-08-26 09:52	2026-08-26 09:52	URA	URA260828C00048000	call	48.0000	2026-08-28	2.0000	2.0000	2.2500	49.8200	12005.00	205.00	11800.00	60	9	77	397	0.193954659949622	0.525301040450638	0.525301040450638	false	false	false	true
280cc2e8-bd0d-4db2-851a-8f89ea552222	2026-08-26 10:35	2026-08-26 10:35	2026-08-26 10:35	URA	URA280121P00040000	put	40.0000	2028-01-21	5.3800	3.7000	6.7000	48.6052	26344.00	26344.00	0.00	49	16	55	2865	0.0191972076788831	0.490796202645278	0.490796202645278	false	false	false	true
4420a4ae-7e1b-4f18-b0bd-1c8ddd232ff5	2026-08-27 10:14	2026-08-27 10:14	2026-08-27 10:14	URA	URA260904C00050000	call	50.0000	2026-09-04	0.6000	0.6000	0.7000	48.0150	175380.00	0.00	175380.00	2923	22	2926	2538	1.15287628053586	0.468813533985043	0.468813533985043	false	false	false	true
4c478f44-53dd-49d9-8c08-c48e52905104	2026-08-27 14:35	2026-08-27 14:35	2026-08-27 14:35	URA	URA261016C00060000	call	60.0000	2026-10-16	0.5000	0.4500	0.6000	48.2450	25000.00	0.00	20000.00	500	8	522	5191	0.100558659217877	0.470807072847117	0.470807072847117	false	false	false	true
f914f67c-9a93-42ba-96d1-24ca436203fe	2026-08-28 10:11	2026-08-28 10:10	2026-08-28 10:10	URA	URA261218C00048000	call	48.0000	2026-12-18	4.4000	4.2000	4.7000	46.5500	22000.00	21560.00	440.00	50	8	200	34	5.88235294117647	0.466242229074583	0.466242229074583	false	false	false	true
31b2163c-18c8-4d0e-8526-c04449c0117e	2026-08-28 10:29	2026-08-28 10:29	2026-08-28 10:29	URA	URA261218C00050000	call	50.0000	2026-12-18	3.4600	3.4000	4.0000	46.3500	17300.00	10500.00	6800.00	50	5	60	2999	0.0200066688896299	0.452535910040139	0.452535910040139	false	false	false	true
6224a546-a35f-4213-9a7e-509e75cf7119	2026-08-28 11:05	2026-08-28 11:05	2026-08-28 11:05	URA	URA261016C00060000	call	60.0000	2026-10-16	0.3500	0.2500	0.4000	46.4450	35000.00	21000.00	14000.00	1000	18	1002	5963	0.168036223377495	0.490936499737775	0.490936499737775	false	false	false	true
eabf7efa-7bf5-4fd5-a138-93be71a70722	2026-08-28 11:08	2026-08-28 11:08	2026-08-28 11:08	URA	URA261016C00060000	call	60.0000	2026-10-16	0.3500	0.2500	0.3500	46.2900	34996.00	34996.00	0.00	1000	20	2002	5963	0.335737045111521	0.496073827715742	0.496073827715742	false	false	false	true
fabb3050-8915-49e1-9c5d-b81f477d9bcb	2026-08-28 12:23	2026-08-28 12:23	2026-08-28 12:23	URA	URA260918C00045000	call	45.0000	2026-09-18	2.2000	2.2000	2.5500	45.6300	33000.00	0.00	33000.00	150	13	179	688	0.260174418604651	0.418621966473184	0.418621966473184	false	false	false	true
71f85367-db05-46cb-bec8-97990f019c0d	2026-08-28 14:45	2026-08-28 14:45	2026-08-28 14:45	URA	URA261016C00045000	call	45.0000	2026-10-16	3.3000	3.3000	3.5000	45.6150	66000.00	0.00	66000.00	200	18	408	1485	0.274747474747475	0.433092605403198	0.433092605403198	false	false	false	true
7e09fd09-5670-421a-8db5-60dee34afce1	2026-08-28 14:46	2026-08-28 14:46	2026-08-28 14:46	URA	URA261016C00045000	call	45.0000	2026-10-16	3.3100	3.3000	3.5000	45.6220	34777.00	0.00	34777.00	105	8	708	1485	0.476767676767677	0.438590334641211	0.432473515615943	false	false	false	true
58227957-19b8-43e4-a57c-c7de93de2a6e	2026-08-28 14:46	2026-08-28 14:46	2026-08-28 14:46	URA	URA261016C00045000	call	45.0000	2026-10-16	3.3100	3.3000	3.5000	45.6220	64542.00	0.00	64542.00	195	16	603	1485	0.406060606060606	0.432473515615943	0.432473515615943	false	false	false	true
34bca3d1-e611-46b8-b0fc-d22063b6bc28	2026-08-28 15:52	2026-08-28 15:52	2026-08-28 15:52	URA	URA261218C00050000	call	50.0000	2026-12-18	3.1000	3.1000	3.2000	45.6500	28221.00	0.00	28221.00	91	14	352	2999	0.117372457485829	0.453097283959496	0.455115425239838	false	false	false	true
d4098e47-4e87-4a59-b26b-27d4a98e1985	2026-08-31 10:07	2026-08-31 10:07	2026-08-31 10:07	URA	URA261016P00043000	put	43.0000	2026-10-16	1.6000	1.5500	1.6500	45.4950	211360.00	160.00	211200.00	1321	30	1330	1635	0.813455657492355	0.43924122924577	0.43924122924577	false	false	false	true