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

243ca62e-c579-49b8-b9da-f3f5899b86f8	2026-10-01 14:26	2026-10-01 14:26	2026-10-01 14:26	IWM	IWM261012C00280000	call	280.0000	2026-10-12	3.4400	3.3800	3.4400	279.4200	10312.00	10312.00	0.00	30	7	409	421	0.971496437054632	0.183850725170811	0.182817155778213	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	78041729433.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T18:27:19.305635Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
48ff2230-b4cf-43b7-bbd6-1e25733dae0a	2026-10-01 14:24	2026-10-01 14:24	2026-10-01 14:24	IWM	IWM261002P00275000	put	275.0000	2026-10-02	0.3500	0.3500	0.3600	279.4640	11025.00	0.00	11025.00	315	8	16684	15772	1.05782399188435	0.302699596919339	0.302699596919339	false	false	false	true
179d9565-3acd-44e4-b5a7-14de32ab9e5a	2026-10-01 14:23	2026-10-01 14:22	2026-10-01 14:22	IWM	IWM261002P00281000	put	281.0000	2026-10-02	2.6500	2.6500	2.6700	279.1600	10600.00	0.00	10600.00	40	5	2222	4015	0.553424657534247	0.270826887487707	0.270826887487707	false	false	false	true
be11bab6-da04-4e11-9361-97d36a902e45	2026-10-01 14:22	2026-10-01 14:22	2026-10-01 14:22	IWM	IWM261009C00281000	call	281.0000	2026-10-09	2.5000	2.5000	2.5400	279.0000	14000.00	0.00	14000.00	56	9	1002	1225	0.817959183673469	0.196388935491028	0.196388935491028	true	false	false	true
3766ac92-eb38-48c2-9227-438ab79be9d7	2026-10-01 14:20	2026-10-01 14:20	2026-10-01 14:20	IWM	IWM261007C00281000	call	281.0000	2026-10-07	1.9800	1.9600	1.9900	279.0000	26136.00	26136.00	0.00	132	6	2997	545	5.49908256880734	0.189295314127699	0.190179560296256	true	false	false	true
0db32c72-4286-4965-8a67-4751ad8498ce	2026-10-01 14:20	2026-10-01 14:20	2026-10-01 14:20	IWM	IWM261012P00279000	put	279.0000	2026-10-12	3.3600	3.3200	3.3600	279.0000	20496.00	20496.00	0.00	61	7	211	158	1.33544303797468	0.187532660147358	0.187532660147358	false	false	false	true
13b3a7a7-01e4-418c-87a7-a129011b9d40	2026-10-01 14:19	2026-10-01 14:19	2026-10-01 14:19	IWM	IWM261009P00275000	put	275.0000	2026-10-09	1.7100	1.6800	1.7100	279.0000	33516.00	33516.00	0.00	196	16	2676	6648	0.402527075812274	0.214643969745495	0.214643969745495	false	false	false	true
8db01faf-7054-4842-bce7-830abb6a4bcf	2026-10-01 14:19	2026-10-01 14:19	2026-10-01 14:19	IWM	IWM261014C00283000	call	283.0000	2026-10-14	2.5200	2.4400	2.5300	279.0000	21672.00	21420.00	0.00	86	10	220	0	0	0.186603527542907	0.186509437634478	true	false	false	true
74c6c33d-bb7d-47e9-9a0a-bb08dc17a365	2026-10-01 14:19	2026-10-01 14:19	2026-10-01 14:19	IWM	IWM261014C00282000	call	282.0000	2026-10-14	2.9500	2.8600	2.9500	279.0000	33040.00	33040.00	0.00	112	21	232	75	3.09333333333333	0.188947098670359	0.188947098670359	true	false	false	true
5505b8b7-4ba3-4b0a-a968-079630e63e15	2026-10-01 14:19	2026-10-01 14:19	2026-10-01 14:19	IWM	IWM261016P00275000	put	275.0000	2026-10-16	2.7600	2.7400	2.7600	279.0000	10764.00	10764.00	0.00	39	5	8329	136912	0.0608346967395115	0.212675636687323	0.212675636687323	true	false	false	true
1d0b1668-634c-496f-b8b4-e87fe14a0401	2026-10-01 14:19	2026-10-01 14:19	2026-10-01 14:19	IWM	IWM261014C00285000	call	285.0000	2026-10-14	1.7900	1.7200	1.7900	279.0000	23449.00	23449.00	0.00	131	15	152	37	4.10810810810811	0.182383258161263	0.182383258161263	true	false	false	true
bdc4a860-35d6-4e8b-b2df-b40724965cce	2026-10-01 14:18	2026-10-01 14:18	2026-10-01 14:18	IWM	IWM261002C00280000	call	280.0000	2026-10-02	1.3500	1.3400	1.3500	279.0000	14715.00	14715.00	0.00	109	14	28249	9640	2.93039419087137	0.287875094811052	0.287875094811052	false	false	false	true
6fa70925-3ab0-4734-85b6-e3d8c81fa321	2026-10-01 14:18	2026-10-01 14:18	2026-10-01 14:18	IWM	IWM261005C00280000	call	280.0000	2026-10-05	1.8700	1.8500	1.8700	279.0000	65450.00	65450.00	0.00	350	22	11498	469	24.5159914712154	0.186167206541908	0.186167206541908	false	false	false	true
b7ca4e07-86af-4638-b2ab-0636a3db7fad	2026-10-01 14:18	2026-10-01 14:18	2026-10-01 14:18	IWM	IWM261002C00277000	call	277.0000	2026-10-02	3.1500	3.1100	3.1500	279.0000	166730.00	157310.00	9420.00	530	24	8858	665	13.3203007518797	0.307709849426472	0.309664239903021	false	false	false	true
776d3cd8-70c8-4d61-a874-5a4706dac1ec	2026-10-01 14:18	2026-10-01 14:18	2026-10-01 14:18	IWM	IWM261002C00279000	call	279.0000	2026-10-02	1.8400	1.8300	1.8400	279.0000	10672.00	10672.00	0.00	58	5	11781	3204	3.67696629213483	0.29053346170525	0.29053346170525	true	false	false	true
d42d9ea8-e570-4597-b0b0-6c61bc230c97	2026-10-01 14:16	2026-10-01 14:16	2026-10-01 14:16	IWM	IWM261009C00280000	call	280.0000	2026-10-09	2.9200	2.8900	2.9300	278.0000	116883.00	54979.00	61904.00	400	8	9372	2891	3.24178484953303	0.200423650763893	0.19981479237631	false	false	false	true
1c419137-aa0d-461d-ae03-e95ecba13ce8	2026-10-01 14:15	2026-10-01 14:15	2026-10-01 14:15	IWM	IWM261001C00278000	call	278.0000	2026-10-01	1.0900	1.0900	1.1200	278.9900	10900.00	0.00	10900.00	100	5	85081	761	111.801576872536	0.2684070416192	0.2684070416192	false	false	false	true
034728b2-afc0-4b57-93c3-1cea6124d29b	2026-10-01 14:15	2026-10-01 14:15	2026-10-01 14:15	IWM	IWM261002C00280000	call	280.0000	2026-10-02	1.1700	1.1700	1.1800	278.8800	11700.00	0.00	11700.00	100	8	27895	9640	2.89367219917012	0.284153069632606	0.284153069632606	false	false	false	true
577ffcd6-97d4-40cc-a3ba-6df8b7abfbd8	2026-10-01 14:15	2026-10-01 14:14	2026-10-01 14:14	IWM	IWM261001C00278000	call	278.0000	2026-10-01	1.0200	1.0000	1.0200	278.8699	10200.00	10200.00	0.00	100	5	84800	761	111.432325886991	0.291490113255959	0.291490113255959	false	false	false	true
f355c412-46e5-4c7a-92c1-4cde6de1768b	2026-10-01 14:13	2026-10-01 14:13	2026-10-01 14:13	IWM	IWM261005C00280000	call	280.0000	2026-10-05	1.6800	1.6600	1.6800	278.8000	83999.00	83832.00	167.00	500	50	11105	469	23.6780383795309	0.186534227335548	0.186534227335548	false	false	false	true
b504e11d-6904-49b4-8b74-1cada3ec31fd	2026-10-01 14:13	2026-10-01 14:13	2026-10-01 14:13	IWM	IWM261006C00281000	call	281.0000	2026-10-06	1.5800	1.5400	1.5800	278.8200	23700.00	23700.00	0.00	150	12	3522	352	10.0056818181818	0.188369858274409	0.188369858274409	false	false	false	true
ee6640c6-9f74-4995-b792-738624e5ac28	2026-10-01 14:13	2026-10-01 14:13	2026-10-01 14:13	IWM	IWM261218P00250000	put	250.0000	2026-12-18	2.6200	2.5900	2.6200	278.8900	20960.00	20960.00	0.00	80	11	14346	67382	0.212905523730373	0.25704096173788	0.25704096173788	false	false	false	true
933baa5f-af44-46ea-a930-c6425dd26bfd	2026-10-01 14:10	2026-10-01 14:10	2026-10-01 14:10	IWM	IWM261016P00272000	put	272.0000	2026-10-16	2.1800	2.1800	2.2200	278.5400	98754.00	0.00	98754.00	453	22	4292	90596	0.0473751600512164	0.220416995196766	0.220416995196766	true	false	false	true
f97a8509-fc75-4c56-9554-fdf0d7f3ea4d	2026-10-01 14:09	2026-10-01 14:09	2026-10-01 14:09	IWM	IWM261013P00276000	put	276.0000	2026-10-13	2.6700	2.6700	2.7200	278.5900	16554.00	0.00	16554.00	62	9	247	118	2.09322033898305	0.19825064723856	0.19825064723856	false	false	false	true
c46e4f82-1cab-481c-92c5-7ebc3b56f67d	2026-10-01 14:09	2026-10-01 14:09	2026-10-01 14:09	IWM	IWM261014P00278000	put	278.0000	2026-10-14	3.7400	3.7400	3.8300	278.5900	18326.00	0.00	18326.00	49	5	165	28	5.89285714285714	0.201345724652696	0.201345724652696	true	false	false	true
7954c7cc-610f-47c8-a1f7-1225a3176454	2026-10-01 14:08	2026-10-01 14:08	2026-10-01 14:08	IWM	IWM261009P00272000	put	272.0000	2026-10-09	1.2400	1.2400	1.2700	278.4800	27900.00	0.00	27900.00	225	8	771	6196	0.124435119431892	0.225239253621309	0.225239253621309	false	false	false	true
20e04114-4a66-4695-b3dd-93d88d694c2d	2026-10-01 14:08	2026-10-01 14:08	2026-10-01 14:08	IWM	IWM261009P00272000	put	272.0000	2026-10-09	1.2400	1.2400	1.2700	278.4800	26288.00	0.00	26288.00	212	11	983	6196	0.158650742414461	0.225239253621309	0.225239253621309	false	false	false	true
631ff72d-2264-4cf6-82af-99061987bae6	2026-10-01 14:08	2026-10-01 14:08	2026-10-01 14:08	IWM	IWM261001P00279000	put	279.0000	2026-10-01	0.8000	0.8000	0.8200	278.4200	10561.00	0.00	10480.00	132	9	48240	2210	21.8280542986425	0.286679025938159	0.279692114892094	false	false	false	true
7061eca9-f068-493e-94b9-cc600eea9897	2026-10-01 14:07	2026-10-01 14:07	2026-10-01 14:07	IWM	IWM261016P00280000	put	280.0000	2026-10-16	5.1600	5.1100	5.1700	278.3250	186358.00	173483.00	12875.00	361	10	5800	94582	0.0613224503605337	0.20028222247687	0.200728154705409	false	false	false	true
5b20dd6b-0e9d-4b41-9296-c5a745cc3815	2026-10-01 14:07	2026-10-01 14:07	2026-10-01 14:07	IWM	IWM261016P00270000	put	270.0000	2026-10-16	1.8400	1.8100	1.8400	278.3700	18400.00	18400.00	0.00	100	8	15865	87509	0.181295638162932	0.229136669677699	0.229136669677699	false	false	false	true
3920b3fe-dfd1-499b-a20b-ba18c685b4b7	2026-10-01 14:07	2026-10-01 14:06	2026-10-01 14:06	IWM	IWM261120P00266000	put	266.0000	2026-11-20	3.8400	3.8300	3.8600	278.4250	58368.00	4608.00	53760.00	152	22	18817	14115	1.33312079348211	0.228976462647279	0.228976462647279	true	false	false	true
babaae06-5f94-49b3-a2a5-70fd676c9526	2026-10-01 14:06	2026-10-01 14:06	2026-10-01 14:06	IWM	IWM261030P00270000	put	270.0000	2026-10-30	3.1800	3.1400	3.1900	278.4600	175593.00	159057.00	16536.00	552	16	2406	12460	0.193097913322632	0.222738362043106	0.223114745365069	false	false	false	true
e307ab9d-b3b8-4932-a8c0-9d85b41449ac	2026-10-01 14:06	2026-10-01 14:06	2026-10-01 14:06	IWM	IWM261005P00280000	put	280.0000	2026-10-05	2.9600	2.9400	2.9600	278.4950	22496.00	22496.00	0.00	76	7	1640	1540	1.06493506493506	0.188729285863047	0.188729285863047	false	false	false	true
6e582c47-2dea-4b2d-a269-bfbd9d2d32d1	2026-10-01 14:06	2026-10-01 14:06	2026-10-01 14:06	IWM	IWM261002C00278000	call	278.0000	2026-10-02	2.0500	2.0400	2.0500	278.4950	12095.00	12095.00	0.00	59	9	11600	990	11.7171717171717	0.305483534736501	0.305483534736501	false	false	false	true
a2df6d94-6407-4d77-a3fd-262924c89e2e	2026-10-01 14:06	2026-10-01 14:06	2026-10-01 14:06	IWM	IWM261016C00284000	call	284.0000	2026-10-16	2.3000	2.3000	2.3300	278.5725	103535.00	0.00	103535.00	450	17	8126	3207	2.53383224197069	0.190767318424552	0.191255506014787	false	false	false	true
d4d887c2-4859-4544-b374-e160e771b254	2026-10-01 14:05	2026-10-01 14:05	2026-10-01 14:05	IWM	IWM261030C00280000	call	280.0000	2026-10-30	6.0500	6.0000	6.0600	278.6150	10285.00	10285.00	0.00	17	7	927	544	1.70404411764706	0.200708105666752	0.200708105666752	true	false	false	true
1d398623-631a-4c60-9259-216f10fbf5a6	2026-10-01 14:05	2026-10-01 14:05	2026-10-01 14:05	IWM	IWM261030C00278000	call	278.0000	2026-10-30	7.1800	7.1300	7.1800	278.6150	13642.00	13642.00	0.00	19	5	211	348	0.60632183908046	0.204894436758308	0.204894436758308	true	false	false	true
7d8e2803-08d4-4588-8f51-563f4b3da757	2026-10-01 14:05	2026-10-01 14:05	2026-10-01 14:05	IWM	IWM261023P00273000	put	273.0000	2026-10-23	3.1500	3.1000	3.1500	278.6950	15120.00	15120.00	0.00	48	14	141	541	0.260628465804067	0.21424493534735	0.21424493534735	true	false	false	true
601c6c3a-e736-406d-9f4d-8b6409bd9db9	2026-10-01 14:05	2026-10-01 14:05	2026-10-01 14:05	IWM	IWM261016P00280000	put	280.0000	2026-10-16	5.0000	4.9500	5.0000	278.6950	51000.00	51000.00	0.00	102	10	4921	94582	0.0520289272800321	0.202298786868062	0.202298786868062	false	false	false	true
0d418900-809c-4ace-9382-6c3e1aae8baa	2026-10-01 14:04	2026-10-01 14:04	2026-10-01 14:04	IWM	IWM261016P00275000	put	275.0000	2026-10-16	2.9900	2.9900	3.0000	278.6450	13156.00	0.00	1794.00	44	19	7826	136912	0.0571608040201005	0.212873493287657	0.212873493287657	false	false	false	true
37caade1-542d-4b3f-ad92-08e1612a9f14	2026-10-01 14:04	2026-10-01 14:04	2026-10-01 14:04	IWM	IWM261005C00280000	call	280.0000	2026-10-05	1.6700	1.6600	1.6700	278.7500	16700.00	16700.00	0.00	100	9	9973	469	21.2643923240938	0.187514079884548	0.187514079884548	false	false	false	true
9e51da6c-fb59-4fcb-bde7-2f1469c68307	2026-10-01 14:03	2026-10-01 14:03	2026-10-01 14:03	IWM	IWM261023C00280000	call	280.0000	2026-10-23	5.1200	5.1100	5.1200	278.8900	10240.00	6144.00	0.00	20	5	717	668	1.07335329341317	0.195119776506189	0.195119776506189	false	false	false	true
a4cdf2cb-246e-4d22-9783-05fef864bc52	2026-10-01 14:03	2026-10-01 14:02	2026-10-01 14:02	IWM	IWM261218P00250000	put	250.0000	2026-12-18	2.6200	2.5800	2.6200	278.9150	44016.00	44016.00	0.00	168	16	14258	67382	0.21159953696833	0.257164490889512	0.257164490889512	false	false	false	true
88c8e4a1-fbd2-42c5-b8c7-8110253d38eb	2026-10-01 14:03	2026-10-01 14:02	2026-10-01 14:02	IWM	IWM261218P00250000	put	250.0000	2026-12-18	2.6100	2.5800	2.6100	278.9300	30015.00	30015.00	0.00	115	10	14090	67382	0.20910628951352	0.256898956063786	0.256898956063786	false	false	false	true
349a9404-d50e-40c7-b350-5b4aab121580	2026-10-01 14:02	2026-10-01 14:02	2026-10-01 14:02	IWM	IWM261218P00250000	put	250.0000	2026-12-18	2.6100	2.6100	2.6200	278.9100	75951.00	0.00	75951.00	291	7	13975	67382	0.207399602267668	0.256800212662614	0.256800212662614	true	false	false	true
6e361002-26c8-4ff7-9ed7-7e9a7158ed65	2026-10-01 14:02	2026-10-01 14:02	2026-10-01 14:02	IWM	IWM261005P00282000	put	282.0000	2026-10-05	3.9100	3.8700	3.9200	278.9600	22312.00	22312.00	0.00	57	12	503	258	1.94961240310078	0.183084323745636	0.184072870158799	false	false	false	true
9d9884c3-342a-42c8-a587-4c6e09f148ae	2026-10-01 14:02	2026-10-01 14:02	2026-10-01 14:02	IWM	IWM261016C00290000	call	290.0000	2026-10-16	0.8600	0.8400	0.8600	278.9400	17200.00	17200.00	0.00	200	5	3037	24848	0.122223116548616	0.182117202468669	0.182117202468669	false	false	false	true
4b3158d4-170f-448e-8c0b-3257d6891d52	2026-10-01 14:02	2026-10-01 14:02	2026-10-01 14:02	IWM	IWM261218P00250000	put	250.0000	2026-12-18	2.6100	2.5800	2.6100	278.9500	29493.00	29493.00	0.00	113	12	13684	67382	0.203080941497729	0.256997680045063	0.256997680045063	false	false	false	true
82496089-9de7-4969-86af-675910eaf361	2026-10-01 14:02	2026-10-01 14:02	2026-10-01 14:02	IWM	IWM261218P00250000	put	250.0000	2026-12-18	2.6100	2.5800	2.6100	278.9300	79866.00	79866.00	0.00	306	10	13571	67382	0.201403935769197	0.256898956063786	0.256898956063786	false	false	false	true
e0d6dcb5-6655-4c71-9174-93c7c478ccb9	2026-10-01 14:02	2026-10-01 14:02	2026-10-01 14:02	IWM	IWM261030C00283000	call	283.0000	2026-10-30	4.6500	4.6500	4.6800	278.8700	51150.00	0.00	51150.00	110	13	218	361	0.60387811634349	0.19434775697059	0.19434775697059	true	false	false	true