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:source = uw_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	expirydate

c9a0c9cc-3fd7-433f-b837-ff2733bf7abe	2026-10-01 12:02	2026-10-01 12:01	2026-10-01 12:01	IWM	IWM261120P00264000	put	264.0000	2026-11-20	3.5500	3.5100	3.5500	277.6500	886790.00	886790.00	0.00	2498	8	22945	30942	0.741548704026889	0.231089082883183	0.231089082883183	false	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-01T16:03:15.684068Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
c8e169e3-0fac-480c-a8fc-76af044cef04	2026-10-01 12:02	2026-10-01 12:01	2026-10-01 12:01	IWM	IWM261120P00264000	put	264.0000	2026-11-20	3.5500	3.5200	3.5600	277.6500	145613.00	145613.00	0.00	410	6	26447	30942	0.85472820115054	0.231089082883183	0.231400374189076	false	false	false	true
b04d41df-ece4-4a03-b650-9481205376f4	2026-10-01 12:02	2026-10-01 12:01	2026-10-01 12:01	IWM	IWM261120P00264000	put	264.0000	2026-11-20	3.5500	3.5100	3.5500	277.6500	1097660.00	1097660.00	0.00	3092	26	26037	30942	0.841477603257708	0.231089082883183	0.231089082883183	false	false	false	true
e2985ca1-464b-4988-aa87-39eb2826effe	2026-10-01 12:01	2026-10-01 12:01	2026-10-01 12:01	IWM	IWM261016P00265000	put	265.0000	2026-10-16	1.1000	1.1000	1.1300	277.5807	90666.00	0.00	90666.00	822	13	7639	51414	0.148578208270121	0.238871206872073	0.23812357101609	false	false	false	true
4606cab6-d4ff-473a-9c18-d166bc1414bf	2026-10-01 12:01	2026-10-01 12:01	2026-10-01 12:01	IWM	IWM261016P00265000	put	265.0000	2026-10-16	1.1000	1.1000	1.1300	277.5807	54450.00	0.00	54450.00	495	24	8134	51414	0.158205936126347	0.23812357101609	0.23812357101609	false	false	false	true
397747b1-5dcc-4e26-ac08-a8bf43cdd26a	2026-10-01 12:01	2026-10-01 12:01	2026-10-01 12:01	IWM	IWM261016P00265000	put	265.0000	2026-10-16	1.1100	1.1100	1.1300	277.5807	42624.00	0.00	42624.00	384	14	6708	51414	0.13047029991831	0.238871206872073	0.238871206872073	false	false	false	true
1bceb914-cb2f-46db-8d5d-8780b39b95ee	2026-10-01 12:01	2026-10-01 12:01	2026-10-01 12:01	IWM	IWM261016P00265000	put	265.0000	2026-10-16	1.1100	1.1100	1.1300	277.5807	12099.00	0.00	12099.00	109	7	6817	51414	0.132590345042206	0.238871206872073	0.238871206872073	false	false	false	true
55661e4d-af1e-4411-a1bd-8333250e2b23	2026-10-01 12:01	2026-10-01 12:01	2026-10-01 12:01	IWM	IWM261016C00284000	call	284.0000	2026-10-16	1.9500	1.9200	1.9600	277.5200	97500.00	97500.00	0.00	500	5	900	3207	0.280636108512629	0.189742739647066	0.189742739647066	false	false	false	true
e898a4da-eca5-4c79-8367-bca5922b2a2f	2026-10-01 11:59	2026-10-01 11:59	2026-10-01 11:59	IWM	IWM261009C00273000	call	273.0000	2026-10-09	6.4600	6.3800	6.4900	277.4550	58786.00	31654.00	27132.00	91	6	98	223	0.439461883408072	0.224083599266971	0.224083599266971	false	false	false	true
d11878d7-6727-4788-870b-325cb1a61a80	2026-10-01 11:59	2026-10-01 11:59	2026-10-01 11:59	IWM	IWM261009C00273000	call	273.0000	2026-10-09	6.4500	6.3800	6.4600	277.4400	112168.00	36120.00	76048.00	174	13	370	223	1.65919282511211	0.222677111533837	0.224120845386763	true	false	false	true
50d2a8ac-f338-4b25-99f6-595b5dffcdf8	2026-10-01 11:59	2026-10-01 11:59	2026-10-01 11:59	IWM	IWM261218P00250000	put	250.0000	2026-12-18	2.7500	2.7500	2.7900	277.4300	171325.00	0.00	171325.00	623	24	7509	67382	0.111439256774806	0.254088589159791	0.254088589159791	false	false	false	true
bee53c1c-5305-4424-a7f8-09d73b143923	2026-10-01 11:58	2026-10-01 11:58	2026-10-01 11:58	IWM	IWM261218P00250000	put	250.0000	2026-12-18	2.7700	2.7700	2.8000	277.3850	75344.00	0.00	75344.00	272	5	6750	67382	0.100175120952183	0.254518606844791	0.254518606844791	false	false	false	true
dfe36512-2913-47ca-bb3d-d436077d9c2b	2026-10-01 11:58	2026-10-01 11:58	2026-10-01 11:58	IWM	IWM261005C00280000	call	280.0000	2026-10-05	1.1600	1.1400	1.1600	277.5750	34800.00	34800.00	0.00	300	18	4420	469	9.42430703624733	0.181657884054915	0.181657884054915	true	false	false	true
5cb6d534-7433-4c71-82a0-d3a45f5668dc	2026-10-01 11:55	2026-10-01 11:55	2026-10-01 11:55	IWM	IWM261001C00277000	call	277.0000	2026-10-01	0.6800	0.6600	0.6800	277.2000	17000.00	17000.00	0.00	250	17	66628	373	178.627345844504	0.239762798703658	0.239762798703658	false	false	false	true
963efea1-1530-4cd2-b003-be805b02fba0	2026-10-01 11:55	2026-10-01 11:55	2026-10-01 11:55	IWM	IWM261120C00280000	call	280.0000	2026-11-20	7.5700	7.5700	7.6100	277.1050	105980.00	0.00	105980.00	140	17	847	2176	0.389246323529412	0.200119923298599	0.200119923298599	false	false	false	true
54f9d1ca-23db-42b0-8ba1-e1e06c0af107	2026-10-01 11:55	2026-10-01 11:55	2026-10-01 11:55	IWM	IWM261016P00266000	put	266.0000	2026-10-16	1.3600	1.3400	1.3600	276.9950	132736.00	132736.00	0.00	976	32	20187	56295	0.3585931254996	0.236764821484263	0.236764821484263	false	false	false	true
8f587b19-4732-4e9d-910d-783246eaea38	2026-10-01 11:53	2026-10-01 11:53	2026-10-01 11:53	IWM	IWM261001C00277000	call	277.0000	2026-10-01	0.5600	0.5600	0.5700	276.9850	18032.00	0.00	18032.00	322	13	66040	373	177.050938337802	0.235829786542802	0.235829786542802	true	false	false	true
38a952a6-7af6-4332-a8f8-601108c9d0f8	2026-10-01 11:52	2026-10-01 11:52	2026-10-01 11:52	IWM	IWM261218C00282000	call	282.0000	2026-12-18	8.6300	8.6300	8.6700	277.0500	23301.00	0.00	23301.00	27	9	63	51	1.23529411764706	0.19097487184794	0.19097487184794	false	false	false	true
ae614bc7-c061-4230-a8d3-61b5c8f63558	2026-10-01 11:52	2026-10-01 11:52	2026-10-01 11:52	IWM	IWM261001C00277000	call	277.0000	2026-10-01	0.5500	0.5500	0.5700	276.9600	21184.00	0.00	21184.00	384	29	65574	373	175.801608579088	0.236352696907735	0.236352696907735	true	false	false	true
4fba1eb8-5373-4e50-924c-34521e855f13	2026-10-01 11:51	2026-10-01 11:51	2026-10-01 11:51	IWM	IWM261120C00285000	call	285.0000	2026-11-20	5.1400	5.1400	5.1900	276.7700	17476.00	0.00	17476.00	34	6	1301	11195	0.116212594908441	0.193574085602996	0.193868992941178	false	false	false	true
866932db-d4b9-44d9-842f-0891c57cbcd8	2026-10-01 11:51	2026-10-01 11:51	2026-10-01 11:51	IWM	IWM261120C00285000	call	285.0000	2026-11-20	5.1500	5.1500	5.1900	276.8200	20600.00	0.00	20600.00	40	7	1267	11195	0.113175524787852	0.193632642410399	0.193632642410399	false	false	false	true
c1caac22-0581-48d3-88cf-5a2d04fe45ff	2026-10-01 11:51	2026-10-01 11:51	2026-10-01 11:51	IWM	IWM261016P00271000	put	271.0000	2026-10-16	2.4100	2.3400	2.4100	276.8200	15183.00	15183.00	0.00	63	13	555	43176	0.0128543635352974	0.222396034969053	0.222396034969053	false	false	false	true
e92f767b-c42b-4cd8-af39-df184eb9d6b3	2026-10-01 11:50	2026-10-01 11:50	2026-10-01 11:50	IWM	IWM261016P00269000	put	269.0000	2026-10-16	1.9100	1.8800	1.9100	276.8800	49087.00	49087.00	0.00	257	6	1090	56579	0.019265098358048	0.227190602788413	0.227190602788413	false	false	false	true
5a4d09fa-3aad-4a4f-8e09-5f78c69b6a05	2026-10-01 11:50	2026-10-01 11:50	2026-10-01 11:50	IWM	IWM261218C00260000	call	260.0000	2026-12-18	23.1200	23.1000	23.4200	276.9100	25428.00	4622.00	20806.00	11	11	116	16229	0.00714769856429848	0.221286302806856	0.223105203937925	false	false	false	true
5baef335-0728-4041-ba1b-d5ae26de7f39	2026-10-01 11:49	2026-10-01 11:49	2026-10-01 11:49	IWM	IWM261016P00279000	put	279.0000	2026-10-16	5.2700	5.2300	5.2900	277.0000	35309.00	527.00	34782.00	67	5	725	64007	0.0113268861218304	0.200177843351295	0.200177843351295	false	false	false	true
9398d83d-8658-4358-a60b-10f45cb7a869	2026-10-01 11:48	2026-10-01 11:48	2026-10-01 11:48	IWM	IWM261001P00277000	put	277.0000	2026-10-01	0.5600	0.5500	0.5700	277.0000	11200.00	9856.00	1344.00	200	7	36571	1659	22.044002411091	0.24603926892991	0.24603926892991	false	false	false	true
8d94f454-b79e-40fa-a0f2-f29dcfb33d4f	2026-10-01 11:48	2026-10-01 11:48	2026-10-01 11:48	IWM	IWM261005C00278000	call	278.0000	2026-10-05	1.7800	1.7700	1.7800	277.0000	14596.00	14596.00	0.00	82	11	1752	111	15.7837837837838	0.186769686152573	0.186769686152573	false	false	false	true
7676d439-8388-4df4-a73f-fac855ad69cb	2026-10-01 11:48	2026-10-01 11:48	2026-10-01 11:48	IWM	IWM261001C00277000	call	277.0000	2026-10-01	0.7000	0.6900	0.7100	277.0000	18412.00	18412.00	0.00	263	7	64595	373	173.176943699732	0.23767355960545	0.239489117764947	false	false	false	true
de32f140-f7ad-4f54-9c01-0deed40e494f	2026-10-01 11:48	2026-10-01 11:48	2026-10-01 11:48	IWM	IWM261007C00280000	call	280.0000	2026-10-07	1.5100	1.5100	1.5700	277.0000	40015.00	0.00	40015.00	265	8	5134	2125	2.416	0.187582403366125	0.187582403366125	false	false	false	true
aa2a40b9-6ea7-4ccc-ac8e-fca0d710e4ab	2026-10-01 11:48	2026-10-01 11:48	2026-10-01 11:48	IWM	IWM261007C00280000	call	280.0000	2026-10-07	1.5100	1.5100	1.5200	277.0000	35493.00	1216.00	34277.00	235	9	4869	2125	2.29129411764706	0.187319328998542	0.187319328998542	true	false	false	true
0b347142-86af-4e26-a1ad-f3d386264a7c	2026-10-01 11:48	2026-10-01 11:48	2026-10-01 11:48	IWM	IWM261007C00280000	call	280.0000	2026-10-07	1.5300	1.5300	1.5700	277.0000	76500.00	0.00	76500.00	500	19	4634	2125	2.18070588235294	0.187395137533507	0.187395137533507	false	false	false	true
7692e3ce-1671-4c47-a89f-993dd0e4545a	2026-10-01 11:48	2026-10-01 11:48	2026-10-01 11:48	IWM	IWM261007C00280000	call	280.0000	2026-10-07	1.5500	1.5500	1.6000	277.0000	46500.00	0.00	46500.00	300	16	3934	2125	1.85129411764706	0.187989428289936	0.187989428289936	false	false	false	true
c54e4ccc-7aa0-4e49-a1e1-57aa2ec267b1	2026-10-01 11:48	2026-10-01 11:47	2026-10-01 11:47	IWM	IWM261016C00283000	call	283.0000	2026-10-16	2.1600	2.1000	2.1600	277.0000	26784.00	26784.00	0.00	124	13	469	2078	0.225697786333013	0.191635753675652	0.191635753675652	false	false	false	true
14f7ca24-8e72-4492-ac44-31733502a360	2026-10-01 11:47	2026-10-01 11:47	2026-10-01 11:47	IWM	IWM261001C00278000	call	278.0000	2026-10-01	0.2500	0.2400	0.2500	277.0000	19925.00	19925.00	0.00	797	8	52405	761	68.8633377135348	0.245793449104915	0.245793449104915	true	false	false	true
b9fce9c2-4e53-44ed-b981-b89507587d9d	2026-10-01 11:47	2026-10-01 11:47	2026-10-01 11:47	IWM	IWM261016P00270000	put	270.0000	2026-10-16	2.1200	2.1200	2.1500	277.0000	26924.00	0.00	26924.00	127	14	4838	87509	0.0552857420379618	0.226067564755016	0.226646054346367	true	false	false	true
0eff6d53-a9e5-4f18-ab99-920dfc158a64	2026-10-01 11:47	2026-10-01 11:47	2026-10-01 11:47	IWM	IWM261001P00284000	put	284.0000	2026-10-01	7.0200	6.9900	7.0200	277.0000	11934.00	11934.00	0.00	17	6	109	154	0.707792207792208	0.608852170647691	0.608852170647691	true	false	false	true
9abd8b61-429a-41ac-84be-980ef91ebf86	2026-10-01 11:47	2026-10-01 11:47	2026-10-01 11:47	IWM	IWM261016P00270000	put	270.0000	2026-10-16	2.1200	2.1200	2.1600	277.0000	18656.00	0.00	18656.00	88	10	4673	87509	0.0534002216914832	0.225633254015989	0.225633254015989	false	false	false	true
c7292b8a-13f3-4543-ab76-5bf1841a8ecc	2026-10-01 11:46	2026-10-01 11:46	2026-10-01 11:46	IWM	IWM261001C00277000	call	277.0000	2026-10-01	0.5700	0.5600	0.5700	276.0000	14127.00	7239.00	6888.00	250	5	64013	373	171.616621983914	0.246069935789726	0.241944793638795	false	false	false	true
75a2915a-e9ac-45d2-b0d0-55c9b54ee4f7	2026-10-01 11:46	2026-10-01 11:46	2026-10-01 11:46	IWM	IWM261218C00300000	call	300.0000	2026-12-18	2.5900	2.5900	2.6000	276.0000	108262.00	0.00	108262.00	418	10	1153	45048	0.0255949209731842	0.179207491169075	0.179207491169075	true	false	false	true
7813608a-e51f-4455-8c04-2ea108b31207	2026-10-01 11:46	2026-10-01 11:46	2026-10-01 11:46	IWM	IWM261001C00277000	call	277.0000	2026-10-01	0.5800	0.5700	0.5800	276.0000	14430.00	10440.00	3990.00	250	9	63568	373	170.423592493298	0.243899397169159	0.239780489378867	false	false	false	true
3ffd8c59-7af8-4bfa-880d-78cb9257cdd8	2026-10-01 11:46	2026-10-01 11:45	2026-10-01 11:45	IWM	IWM261016P00270000	put	270.0000	2026-10-16	2.1200	2.1000	2.1600	277.0000	41983.00	1491.00	40492.00	198	17	4569	87509	0.0522117725033997	0.225488398976577	0.226028794745423	true	false	false	true
b0c4d247-6ae6-41e9-8a8b-a688d98c572b	2026-10-01 11:45	2026-10-01 11:45	2026-10-01 11:45	IWM	IWM261001P00276000	put	276.0000	2026-10-01	0.2900	0.2800	0.2900	276.0000	11600.00	11600.00	0.00	400	16	114378	2781	41.1283710895361	0.255620276544528	0.255620276544528	false	false	false	true
5dd3396b-9b02-4f49-9fdc-7e2e9dfc5a35	2026-10-01 11:44	2026-10-01 11:44	2026-10-01 11:44	IWM	IWM261015C00274000	call	274.0000	2026-10-15	6.3400	6.3400	6.4700	276.7900	23458.00	0.00	23458.00	37	7	37	0	0	0.210363022209545	0.211864400159652	false	false	false	true	false
c35ae84f-91bc-4405-85ca-d6085a77a4b6	2026-10-01 11:44	2026-10-01 11:44	2026-10-01 11:44	IWM	IWM261001C00277000	call	277.0000	2026-10-01	0.5100	0.5100	0.5200	276.8150	12752.00	104.00	12648.00	250	23	62620	373	167.882037533512	0.248415460412493	0.24428388176302	true	false	false	true
8df0b24d-174d-4aa4-8301-23bc73e3aa01	2026-10-01 11:44	2026-10-01 11:43	2026-10-01 11:43	IWM	IWM261002C00279000	call	279.0000	2026-10-02	0.8200	0.8100	0.8200	276.8450	18532.00	18532.00	0.00	226	12	7129	3204	2.22503121098627	0.289001154134485	0.288094167730756	false	false	false	true
60856feb-227c-48c3-84b9-fa83ded4001d	2026-10-01 11:43	2026-10-01 11:43	2026-10-01 11:43	IWM	IWM261001C00277000	call	277.0000	2026-10-01	0.5600	0.5500	0.5600	276.9000	14000.00	14000.00	0.00	250	29	62296	373	167.013404825737	0.248484191904856	0.248484191904856	false	false	false	true
e1fdf618-bc34-441a-b4b5-4f0dd0ddf531	2026-10-01 11:43	2026-10-01 11:43	2026-10-01 11:43	IWM	IWM261016C00280000	call	280.0000	2026-10-16	3.2900	3.2700	3.3000	276.9300	42770.00	10528.00	32242.00	130	5	3084	22600	0.13646017699115	0.1988189752644	0.1988189752644	false	false	false	true
c9bf26d3-5829-4ca4-a994-21c81a4f956b	2026-10-01 11:43	2026-10-01 11:43	2026-10-01 11:43	IWM	IWM261016C00280000	call	280.0000	2026-10-16	3.3000	3.2700	3.3100	276.9300	61023.00	25080.00	8883.00	185	10	2954	22600	0.13070796460177	0.1988189752644	0.199275632022469	true	false	false	true
1bc32d2c-cf18-40d4-9af4-f770961415b3	2026-10-01 11:43	2026-10-01 11:43	2026-10-01 11:43	IWM	IWM261001C00278000	call	278.0000	2026-10-01	0.2100	0.2100	0.2200	276.9300	10563.00	0.00	10563.00	503	14	50314	761	66.1156373193167	0.246290313795602	0.244401151873178	false	false	false	true
ce833ac3-74bd-4c3b-9d65-ebb41b67142f	2026-10-01 11:43	2026-10-01 11:43	2026-10-01 11:43	IWM	IWM261001C00277000	call	277.0000	2026-10-01	0.5600	0.5500	0.5700	276.9250	28446.00	28171.00	275.00	508	5	61777	373	165.621983914209	0.242353478025288	0.247611158848246	false	false	false	true