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:endpoint = /api/option-trades/flow-alerts×ticker = IWM×

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

6bcb9d83-3afe-4d6d-ad95-f73945207669	2026-10-01 14:41	2026-10-01 14:41	2026-10-01 14:41	IWM	IWM261001C00278000	call	278.0000	2026-10-01	1.3400	1.3200	1.3500	279.2975	48106.00	32026.00	0.00	359	14	86474	761	113.632063074901	0.284596415204174	0.284596415204174	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	78041729433.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T18:43:39.301035Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
fb2dd4de-14e3-48cc-a37c-d61535295ac5	2026-10-01 14:41	2026-10-01 14:41	2026-10-01 14:41	IWM	IWM261002C00284000	call	284.0000	2026-10-02	0.2600	0.2600	0.2700	279.2800	15600.00	0.00	15600.00	600	33	3641	8878	0.410114890741158	0.278823078978057	0.278823078978057	false	false	false	true
7f8a59fa-75d7-4916-9c77-312694bd371a	2026-10-01 14:39	2026-10-01 14:39	2026-10-01 14:39	IWM	IWM261009C00283000	call	283.0000	2026-10-09	1.7300	1.7300	1.7600	279.3300	24912.00	0.00	24912.00	144	13	1016	883	1.15062287655719	0.189735013647373	0.189735013647373	true	false	false	true
78dc725a-bd59-449d-8212-d702cacc7a2a	2026-10-01 14:39	2026-10-01 14:39	2026-10-01 14:39	IWM	IWM261016C00285000	call	285.0000	2026-10-16	2.1700	2.1700	2.2000	279.3800	25389.00	0.00	25389.00	117	8	5103	19123	0.266851435444229	0.186776136508503	0.186776136508503	true	false	false	true
6bd5cdec-5e51-4526-b8e4-112c30b092b2	2026-10-01 14:39	2026-10-01 14:39	2026-10-01 14:39	IWM	IWM261016C00283000	call	283.0000	2026-10-16	2.9400	2.9400	2.9700	279.3800	29988.00	0.00	29988.00	102	5	1744	2078	0.839268527430221	0.190446225712358	0.190807493043925	true	false	false	true
01c4c2ba-87b0-42dc-be6e-8156175c6d3b	2026-10-01 14:39	2026-10-01 14:39	2026-10-01 14:39	IWM	IWM261016C00280000	call	280.0000	2026-10-16	4.3900	4.3900	4.4200	279.3800	35120.00	0.00	35120.00	80	9	6658	22600	0.294601769911504	0.197279170739605	0.197724153466994	true	false	false	true
4db2dde9-a1fe-4886-9981-4b2d7987fc54	2026-10-01 14:39	2026-10-01 14:39	2026-10-01 14:39	IWM	IWM261002C00279000	call	279.0000	2026-10-02	1.9000	1.9000	1.9100	279.3800	13110.00	0.00	13110.00	69	8	12085	3204	3.77184769038702	0.289333247585446	0.289333247585446	true	false	false	true
7139810b-8054-42fd-938f-06703fa0e4c3	2026-10-01 14:38	2026-10-01 14:38	2026-10-01 14:38	IWM	IWM261002P00279000	put	279.0000	2026-10-02	1.4100	1.4100	1.4200	279.4425	10293.00	0.00	10293.00	73	9	9039	8562	1.05571128241065	0.280561182341627	0.280561182341627	true	false	false	true
e013cc5d-f0b4-4b93-956d-ce3b609764df	2026-10-01 14:37	2026-10-01 14:37	2026-10-01 14:37	IWM	IWM261002P00279000	put	279.0000	2026-10-02	1.4200	1.4100	1.4400	279.4300	15764.00	0.00	14911.00	111	14	8952	8562	1.04555010511563	0.283038586586826	0.281312573310375	true	false	false	true
cbfe69dd-e8ee-4f5e-ba15-13146b64a7a1	2026-10-01 14:37	2026-10-01 14:37	2026-10-01 14:37	IWM	IWM261002P00278000	put	278.0000	2026-10-02	1.0400	1.0400	1.0500	279.4300	11336.00	0.00	11336.00	109	12	17029	20798	0.818780651985768	0.286899433554465	0.286899433554465	true	false	false	true
7d1af3df-4bbc-4aba-905a-7ec97d8fd1b2	2026-10-01 14:37	2026-10-01 14:37	2026-10-01 14:37	IWM	IWM261002C00284000	call	284.0000	2026-10-02	0.3000	0.3000	0.3100	279.5000	14730.00	0.00	14730.00	491	18	3030	8878	0.341293084027934	0.282011004428615	0.282011004428615	false	false	false	true
a3ba83b0-ae65-4066-a975-957474b936cc	2026-10-01 14:36	2026-10-01 14:36	2026-10-01 14:36	IWM	IWM261006P00278000	put	278.0000	2026-10-06	1.7200	1.6900	1.7300	279.0000	12556.00	10836.00	0.00	73	9	540	413	1.30750605326877	0.195572992376835	0.195572992376835	true	false	false	true
86a6ee4e-80a6-4cc7-8f7a-f3bab4a65d62	2026-10-01 14:36	2026-10-01 14:36	2026-10-01 14:36	IWM	IWM261002P00278000	put	278.0000	2026-10-02	0.9700	0.9500	0.9700	279.0000	11058.00	11058.00	0.00	114	14	16878	20798	0.811520338494086	0.292364045483089	0.292364045483089	true	false	false	true
331bfd6f-20f5-498a-8063-6643a9acf73d	2026-10-01 14:36	2026-10-01 14:36	2026-10-01 14:36	IWM	IWM261002P00279000	put	279.0000	2026-10-02	1.3200	1.3100	1.3300	279.0000	18893.00	18893.00	0.00	143	16	8780	8562	1.02546134080822	0.285678408917976	0.287420182646849	true	false	false	true
e9909bcf-1d33-421c-93d1-46c98c7fe6b6	2026-10-01 14:35	2026-10-01 14:35	2026-10-01 14:35	IWM	IWM261013P00278000	put	278.0000	2026-10-13	2.8900	2.8400	2.9000	279.0000	22542.00	22542.00	0.00	78	11	175	220	0.795454545454545	0.189547954978813	0.189547954978813	true	false	false	true
51bb6bc9-7b2f-45c3-9c4f-c9159df4f95c	2026-10-01 14:35	2026-10-01 14:35	2026-10-01 14:35	IWM	IWM261013P00277000	put	277.0000	2026-10-13	2.5400	2.5000	2.5400	279.0000	23114.00	23114.00	0.00	91	7	343	84	4.08333333333333	0.192254160727613	0.192254160727613	true	false	false	true
bf603a92-69f2-41e9-ad99-40bbd62dd6ac	2026-10-01 14:35	2026-10-01 14:35	2026-10-01 14:35	IWM	IWM261002P00280000	put	280.0000	2026-10-02	1.7400	1.7300	1.7400	279.0000	13050.00	13050.00	0.00	75	12	4402	19995	0.22015503875969	0.274127482977725	0.274127482977725	true	false	false	true
d87d4f88-6d45-425c-8283-f1aaa7283125	2026-10-01 14:35	2026-10-01 14:35	2026-10-01 14:35	IWM	IWM261005C00280000	call	280.0000	2026-10-05	2.0600	2.0400	2.0600	279.0000	41200.00	41200.00	0.00	200	6	12244	469	26.1066098081023	0.183760413555238	0.183760413555238	false	false	false	true
03a5c635-b253-48b4-9a03-6480568cdc60	2026-10-01 14:35	2026-10-01 14:35	2026-10-01 14:35	IWM	IWM261002C00284000	call	284.0000	2026-10-02	0.3100	0.3000	0.3100	279.0000	18600.00	18600.00	0.00	600	26	2538	8878	0.285875197116468	0.275403729802967	0.275403729802967	false	false	false	true
6cdc4e1f-a5ac-4b35-bbe6-c0002600b205	2026-10-01 14:35	2026-10-01 14:35	2026-10-01 14:35	IWM	IWM261001C00280000	call	280.0000	2026-10-01	0.3100	0.2800	0.3200	279.0000	16675.00	15353.00	1140.00	541	58	125701	4463	28.165135559041	0.29047992775541	0.300475002813034	false	false	false	true
d9607c90-db80-4a5b-995d-c18bc9399127	2026-10-01 14:35	2026-10-01 14:34	2026-10-01 14:34	IWM	IWM261001C00280000	call	280.0000	2026-10-01	0.2500	0.2400	0.2500	279.0000	20225.00	20225.00	0.00	809	11	124740	4463	27.949809545149	0.27629952868357	0.270765349551487	true	false	false	true
0edf4b4a-c3a9-4b65-ab41-666220fe6a5c	2026-10-01 14:35	2026-10-01 14:34	2026-10-01 14:34	IWM	IWM261016C00272000	call	272.0000	2026-10-16	10.0500	9.9700	10.0500	279.0000	25125.00	25125.00	0.00	25	17	365	197	1.85279187817259	0.220964943824457	0.220964943824457	false	false	false	true
cd2eca74-1e2e-40a8-b44a-e829f5161f8e	2026-10-01 14:34	2026-10-01 14:34	2026-10-01 14:34	IWM	IWM261016C00284000	call	284.0000	2026-10-16	2.5600	2.5300	2.5600	279.0000	58624.00	58624.00	0.00	229	14	8433	3207	2.62956033676333	0.18752005686473	0.18752005686473	true	false	false	true
8c03915b-5a2f-4c10-9676-9f45479309be	2026-10-01 14:34	2026-10-01 14:34	2026-10-01 14:34	IWM	IWM261016C00280000	call	280.0000	2026-10-16	4.4400	4.4100	4.4500	279.0000	15097.00	15097.00	0.00	34	7	6563	22600	0.290398230088496	0.196809124876887	0.197251561610183	true	false	false	true
5676718d-56ec-4719-9772-29f102a02afa	2026-10-01 14:34	2026-10-01 14:34	2026-10-01 14:34	IWM	IWM261006C00280000	call	280.0000	2026-10-06	2.2500	2.2300	2.2500	279.0000	56250.00	56250.00	0.00	250	5	2304	340	6.77647058823529	0.185797496000812	0.185797496000812	false	false	false	true
4c8e5610-81b8-476b-8fdd-fa951998d683	2026-10-01 14:33	2026-10-01 14:33	2026-10-01 14:33	IWM	IWM261120C00258000	call	258.0000	2026-11-20	25.1700	25.1100	25.1700	279.4700	20136.00	20136.00	0.00	8	8	18	26	0.692307692307692	0.244562005903574	0.244562005903574	false	false	false	true
1511e81b-22f9-402c-a41f-848f48d47518	2026-10-01 14:33	2026-10-01 14:33	2026-10-01 14:33	IWM	IWM261120C00259000	call	259.0000	2026-11-20	24.3000	24.2200	24.3300	279.4700	29160.00	29160.00	0.00	12	8	44	21	2.0952380952381	0.242111827011798	0.242111827011798	false	false	false	true
ce5034dc-302a-49f7-aa3e-b9b376efca97	2026-10-01 14:33	2026-10-01 14:33	2026-10-01 14:33	IWM	IWM270115C00300000	call	300.0000	2027-01-15	4.3600	4.3000	4.3600	279.3400	29648.00	29648.00	0.00	68	10	601	22760	0.0264059753954306	0.174329657781994	0.174329657781994	false	false	false	true
ecde39bb-0e0a-48fe-9744-0fe6a19e5740	2026-10-01 14:33	2026-10-01 14:32	2026-10-01 14:32	IWM	IWM261014P00276000	put	276.0000	2026-10-14	2.6300	2.6300	2.6900	279.3500	31297.00	0.00	31297.00	119	12	515	28	18.3928571428571	0.203069887848627	0.203069887848627	true	false	false	true
9827ed31-9648-4401-9dd2-842b2cb8c4a8	2026-10-01 14:33	2026-10-01 14:32	2026-10-01 14:32	IWM	IWM261014P00277000	put	277.0000	2026-10-14	2.9600	2.9600	3.0300	279.3500	15392.00	0.00	15392.00	52	10	183	4	45.75	0.200252208562863	0.200252208562863	false	false	false	true
85f38ed3-30e6-44a2-b1a7-0c4efc16e761	2026-10-01 14:33	2026-10-01 14:32	2026-10-01 14:32	IWM	IWM261023P00280000	put	280.0000	2026-10-23	5.2700	5.2600	5.3200	279.3500	13702.00	527.00	13175.00	26	5	224	2445	0.0916155419222904	0.193145619662017	0.193145619662017	false	false	false	true
51d3f4be-8c8f-4e1c-bc83-49ca1d1f0a1d	2026-10-01 14:33	2026-10-01 14:32	2026-10-01 14:32	IWM	IWM261015P00277000	put	277.0000	2026-10-15	3.1400	3.1400	3.2200	279.3500	13502.00	0.00	13502.00	43	9	189	0	0	0.202124335464992	0.202124335464992	true	false	false	true
28896d3b-e95f-4499-86b9-2747839549c4	2026-10-01 14:33	2026-10-01 14:32	2026-10-01 14:32	IWM	IWM261015P00280000	put	280.0000	2026-10-15	4.3600	4.3600	4.4400	279.3500	15696.00	0.00	15696.00	36	11	216	0	0	0.194647735238118	0.194647735238118	true	false	false	true
c115e32d-9133-4df7-8494-4188eddb0c39	2026-10-01 14:32	2026-10-01 14:32	2026-10-01 14:32	IWM	IWM261016P00280000	put	280.0000	2026-10-16	4.5900	4.5800	4.6200	279.2600	68827.00	0.00	68827.00	150	9	5966	94582	0.0630775411811973	0.196494198115952	0.196936977528017	false	false	false	true
66748156-af90-44b7-8f3d-f16a23116780	2026-10-01 14:32	2026-10-01 14:32	2026-10-01 14:32	IWM	IWM261014C00285000	call	285.0000	2026-10-14	1.7300	1.7300	1.7900	279.1350	16435.00	0.00	16435.00	95	7	364	37	9.83783783783784	0.18192949858078	0.18192949858078	false	false	false	true
f465db89-900e-45ef-b4af-3063a83a99fd	2026-10-01 14:31	2026-10-01 14:31	2026-10-01 14:31	IWM	IWM261218P00244000	put	244.0000	2026-12-18	1.9700	1.9500	1.9700	279.1700	15957.00	15957.00	0.00	81	8	99	39	2.53846153846154	0.268435742465591	0.268435742465591	false	false	false	true
23f64214-3b4b-44c9-a927-8ae24236323d	2026-10-01 14:31	2026-10-01 14:31	2026-10-01 14:31	IWM	IWM261120C00261000	call	261.0000	2026-11-20	22.3700	22.3100	22.3700	279.1900	15659.00	15659.00	0.00	7	5	13	92	0.141304347826087	0.237771140984857	0.237771140984857	false	false	false	true
547579b3-2257-4b1a-912b-25033951d365	2026-10-01 14:31	2026-10-01 14:31	2026-10-01 14:31	IWM	IWM261008P00280000	put	280.0000	2026-10-08	3.3000	3.2600	3.3200	279.1500	10560.00	1320.00	7920.00	32	5	204	361	0.565096952908587	0.192502974949867	0.192502974949867	true	false	false	true
d9a0da89-acae-4593-bd3f-60205ddeefcd	2026-10-01 14:30	2026-10-01 14:30	2026-10-01 14:30	IWM	IWM261218P00268000	put	268.0000	2026-12-18	5.6900	5.6800	5.7300	279.2899	14794.00	6259.00	8535.00	26	6	65	11093	0.00585955106824123	0.223668689947566	0.223668689947566	false	false	false	true
ae469274-e4e9-4ee0-9c2d-d6aea9326633	2026-10-01 14:30	2026-10-01 14:30	2026-10-01 14:30	IWM	IWM261218P00271000	put	271.0000	2026-12-18	6.5300	6.5200	6.5700	279.2899	27426.00	1306.00	26120.00	42	10	185	24	7.70833333333333	0.219020220528103	0.219267178259915	false	false	false	true
91055f01-104a-400d-b9ce-9d62cf0cc968	2026-10-01 14:30	2026-10-01 14:30	2026-10-01 14:30	IWM	IWM261016P00273000	put	273.0000	2026-10-16	2.1900	2.1900	2.2200	279.2899	19710.00	0.00	19710.00	90	5	3084	66818	0.0461552276332725	0.215986296856594	0.216500660954768	false	false	false	true
520d5d05-dd89-468a-9b99-358c68270185	2026-10-01 14:30	2026-10-01 14:30	2026-10-01 14:30	IWM	IWM261218P00270000	put	270.0000	2026-12-18	6.2400	6.2300	6.2800	279.2550	11233.00	0.00	11233.00	18	8	401	79781	0.00502625938506662	0.220516053317755	0.220516053317755	false	false	false	true
ef4e9d0c-dc32-41c4-950e-878ceb6c0f8c	2026-10-01 14:30	2026-10-01 14:30	2026-10-01 14:30	IWM	IWM261120C00259000	call	259.0000	2026-11-20	24.2100	24.1200	24.2100	279.3250	41157.00	41157.00	0.00	17	9	32	21	1.52380952380952	0.243267002792512	0.243267002792512	false	false	false	true
08947229-91dc-40bd-8c09-e26071231330	2026-10-01 14:29	2026-10-01 14:29	2026-10-01 14:29	IWM	IWM261001P00279000	put	279.0000	2026-10-01	0.2800	0.2800	0.2900	279.2550	12600.00	0.00	12600.00	450	30	55156	2210	24.9574660633484	0.269903883414003	0.269903883414003	false	false	false	true
f45201c7-6a6a-42f6-b88d-2215a748cbcc	2026-10-01 14:28	2026-10-01 14:28	2026-10-01 14:28	IWM	IWM261008C00279000	call	279.0000	2026-10-08	3.2400	3.2400	3.3000	279.2900	10044.00	0.00	10044.00	31	6	479	111	4.31531531531532	0.193354439924278	0.193354439924278	false	false	false	true
cbeed9ac-4bd9-403d-ab85-c41c4891c83d	2026-10-01 14:28	2026-10-01 14:28	2026-10-01 14:28	IWM	IWM261002P00276000	put	276.0000	2026-10-02	0.5400	0.5400	0.5500	279.2600	16686.00	0.00	16686.00	309	20	14374	8079	1.77918059165738	0.293759611777013	0.293759611777013	false	false	false	true
b91c7a49-0a66-43da-b432-68d1f9a20bcd	2026-10-01 14:27	2026-10-01 14:27	2026-10-01 14:27	IWM	IWM261002C00280000	call	280.0000	2026-10-02	1.3400	1.3400	1.3500	279.3300	14874.00	0.00	14874.00	111	13	28906	9640	2.99854771784232	0.280812296597338	0.280812296597338	true	false	false	true
d409bbfb-3a9e-421d-aa4b-d2d9348a842d	2026-10-01 14:26	2026-10-01 14:26	2026-10-01 14:26	IWM	IWM261016C00285000	call	285.0000	2026-10-16	2.1900	2.1900	2.2200	279.3850	16425.00	0.00	16425.00	75	5	4720	19123	0.246823197197093	0.187681693028099	0.187681693028099	false	false	false	true
bab71092-3d6e-4d16-8701-090d1e0e6f33	2026-10-01 14:26	2026-10-01 14:26	2026-10-01 14:26	IWM	IWM261023C00284000	call	284.0000	2026-10-23	3.4300	3.4300	3.4400	279.3850	14406.00	0.00	14406.00	42	6	129	667	0.193403298350825	0.187187275550793	0.187187275550793	false	false	false	true
364aa6a9-1cb4-4993-b406-05191f256f71	2026-10-01 14:26	2026-10-01 14:26	2026-10-01 14:26	IWM	IWM261005C00278000	call	278.0000	2026-10-05	3.0700	3.0700	3.0900	279.4300	14429.00	0.00	14429.00	47	13	2942	111	26.5045045045045	0.18968923895924	0.18968923895924	true	false	false	true