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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = XLF×

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

fcab97fc-7eac-417f-bd51-c82eb60b02c7	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	XLF	XLF270319C00070000	call	70.0000	2027-03-19	0.1400	0.1000	0.1700	54.8500	14000.00	14000.00	0.00	1000	17	1000	13497	0.0740905386382159	0.18775537845841	0.18775537845841	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	51629252822.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:54:56.567521Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
6247fa82-cc2e-4eb4-bd0a-b5579cae8d5c	2026-09-25 15:37	2026-09-25 15:37	2026-09-25 15:37	XLF	XLF261009P00053500	put	53.5000	2026-10-09	0.2200	0.2200	0.2300	54.0000	11352.00	0.00	11352.00	516	40	790	250	3.16	0.166355470280747	0.166355470280747	false	false	false	true
c066b180-8f22-4711-bf77-b46934c22416	2026-09-25 15:34	2026-09-25 15:34	2026-09-25 15:34	XLF	XLF261030C00052000	call	52.0000	2026-10-30	3.2500	3.2500	3.4000	54.7699	56895.00	0.00	56895.00	175	25	179	28	6.39285714285714	0.186476762371252	0.186476762371252	true	false	false	true
1e202dcb-b8c1-43e4-932b-3b70aaa8806c	2026-09-25 15:12	2026-09-25 15:12	2026-09-25 15:12	XLF	XLF261120P00053000	put	53.0000	2026-11-20	0.6700	0.6600	0.6700	54.8300	16348.00	16348.00	0.00	244	27	476	23220	0.0204995693367786	0.180288770533846	0.180288770533846	false	false	false	true
0bbe18c1-df17-4374-9185-e4cebbbc084a	2026-09-25 15:03	2026-09-25 15:03	2026-09-25 15:03	XLF	XLF261218C00056000	call	56.0000	2026-12-18	1.3800	1.3700	1.4400	54.0000	10074.00	9108.00	966.00	73	6	293	12617	0.0232226361258619	0.160887710651876	0.160887710651876	false	false	false	true
f71b4e89-50b3-4c0b-83c1-a8fd1084e32e	2026-09-25 14:55	2026-09-25 14:55	2026-09-25 14:55	XLF	XLF261120P00051000	put	51.0000	2026-11-20	0.3500	0.3400	0.3500	54.0000	12250.00	12250.00	0.00	350	44	1769	1867	0.947509373326192	0.200990451383497	0.200990451383497	false	false	false	true
08dfd9ff-c893-40ce-9373-8281c7c61509	2026-09-25 14:25	2026-09-25 14:25	2026-09-25 14:25	XLF	XLF261120P00052000	put	52.0000	2026-11-20	0.4800	0.4700	0.4900	54.8035	13248.00	12864.00	384.00	276	39	438	2721	0.160970231532525	0.189537471924829	0.189537471924829	false	false	false	true
9ec29b59-04e8-4960-af93-f979e70d0408	2026-09-25 13:19	2026-09-25 13:19	2026-09-25 13:19	XLF	XLF261002C00055500	call	55.5000	2026-10-02	0.1500	0.1500	0.1600	54.0000	18960.00	0.00	18960.00	1264	36	1928	560	3.44285714285714	0.132695325125021	0.132695325125021	false	false	false	true
cb0542c1-5b7a-4884-869a-982717479de9	2026-09-25 13:18	2026-09-25 13:17	2026-09-25 13:17	XLF	XLF261002C00055000	call	55.0000	2026-10-02	0.3300	0.3200	0.3600	54.0000	14817.00	0.00	14751.00	449	38	1145	997	1.14844533600802	0.138351779326116	0.138351779326116	true	false	false	true
75966d48-d8eb-4d3b-8ace-784958592bae	2026-09-25 13:03	2026-09-25 13:03	2026-09-25 13:03	XLF	XLF261016C00056000	call	56.0000	2026-10-16	0.3900	0.3800	0.3900	54.7800	49530.00	49530.00	0.00	1270	11	1786	18518	0.0964467005076142	0.155468678717581	0.155468678717581	false	false	false	true
c365e27a-9bbf-42fe-9820-fcfb06eb7a7d	2026-09-25 12:07	2026-09-25 12:07	2026-09-25 12:07	XLF	XLF261016C00054500	call	54.5000	2026-10-16	1.0400	1.0100	1.0400	54.7450	10400.00	10400.00	0.00	100	7	1038	1928	0.538381742738589	0.161238244117717	0.161238244117717	false	false	false	true
ed22080b-5737-4ba0-a519-372f8a478cf8	2026-09-25 12:07	2026-09-25 12:07	2026-09-25 12:07	XLF	XLF261016C00054500	call	54.5000	2026-10-16	1.0400	1.0100	1.0800	54.7500	10400.00	2080.00	2080.00	100	5	938	1928	0.486514522821577	0.160675988821827	0.160675988821827	false	false	false	true
447b6bae-846c-4d06-aeb2-77ccb8b9424e	2026-09-25 11:27	2026-09-25 11:27	2026-09-25 11:27	XLF	XLF270115P00052000	put	52.0000	2027-01-15	0.9200	0.9200	0.9700	54.0000	28980.00	0.00	28980.00	315	8	350	35867	0.00975827362199236	0.18500873017323	0.18500873017323	false	false	false	true
13e5818c-24c2-499e-8c1a-a81a1df8e072	2026-09-25 09:58	2026-09-25 09:58	2026-09-25 09:58	XLF	XLF280121C00057000	call	57.0000	2028-01-21	4.6500	4.6000	4.8500	54.5050	33015.00	1395.00	28830.00	71	11	71	5643	0.012581959950381	0.165654231758742	0.165654231758742	false	false	false	true
2442d4c1-5520-47db-9f55-13f1f7ae5878	2026-09-25 09:42	2026-09-25 09:42	2026-09-25 09:42	XLF	XLF270115C00058000	call	58.0000	2027-01-15	0.9000	0.9000	0.9000	54.6850	44910.00	0.00	0.00	499	6	499	14978	0.0333155294431833	0.154537227434597	0.154537227434597	false	false	false	true
e7d3a6dd-edc4-4381-a8e0-6a84ccfb2bd4	2026-09-24 15:42	2026-09-24 15:42	2026-09-24 15:42	XLF	XLF270617C00055000	call	55.0000	2027-06-17	3.8500	3.7500	3.8500	54.0000	11550.00	11550.00	0.00	30	5	55	4318	0.0127373784159333	0.171748399983761	0.171748399983761	false	false	false	true
a2608bdb-d2af-4067-83ee-637c43e8f0de	2026-09-24 15:40	2026-09-24 15:40	2026-09-24 15:40	XLF	XLF261002P00052500	put	52.5000	2026-10-02	0.0700	0.0600	0.0800	54.0000	11039.00	0.00	10857.00	1577	10	5701	1914	2.978578892372	0.199670704207226	0.199670704207226	false	false	false	true
9477d7bd-39dd-4e86-970b-03c344702a17	2026-09-24 14:33	2026-09-24 14:32	2026-09-24 14:32	XLF	XLF270115P00040000	put	40.0000	2027-01-15	0.1000	0.1000	0.1100	54.4600	22720.00	0.00	22720.00	2272	19	11476	66042	0.173768208109991	0.312097092313094	0.312097092313094	false	false	false	true
489e87e9-062f-4803-b132-b8335cc80191	2026-09-24 14:31	2026-09-24 14:31	2026-09-24 14:31	XLF	XLF270115P00040000	put	40.0000	2027-01-15	0.1000	0.1000	0.1100	54.4750	11780.00	0.00	11780.00	1178	21	7179	66042	0.10870355228491	0.312310358689258	0.312310358689258	false	false	false	true
4dea87a6-5ad2-400b-be3c-e918228f0ebc	2026-09-24 14:31	2026-09-24 14:31	2026-09-24 14:31	XLF	XLF270115P00040000	put	40.0000	2027-01-15	0.1000	0.1000	0.1200	54.4750	12230.00	0.00	12230.00	1223	33	5518	66042	0.0835528905847794	0.312310358689258	0.312310358689258	false	false	false	true
66481a9e-f423-4eab-bd77-063a6f105b9e	2026-09-24 14:31	2026-09-24 14:31	2026-09-24 14:31	XLF	XLF270115P00040000	put	40.0000	2027-01-15	0.1000	0.1000	0.1300	54.4800	11820.00	0.00	11820.00	1182	41	4295	66042	0.0650343720662609	0.312381427620342	0.312381427620342	false	false	false	true
d83d9f65-da9e-4d63-9a71-8e7e3bb1d2fe	2026-09-24 14:31	2026-09-24 14:31	2026-09-24 14:31	XLF	XLF270115P00040000	put	40.0000	2027-01-15	0.1000	0.1000	0.1200	54.4850	22510.00	0.00	22510.00	2251	48	3113	66042	0.0471366706035553	0.312452486626303	0.312452486626303	false	false	false	true
2e978e8d-82f7-4831-9cf5-26406e2d8673	2026-09-24 14:02	2026-09-24 14:02	2026-09-24 14:02	XLF	XLF261016C00055500	call	55.5000	2026-10-16	0.4700	0.4700	0.4800	54.0000	15040.00	0.00	15040.00	320	8	499	3025	0.16495867768595	0.159285327351937	0.159285327351937	false	false	false	true
70b40dde-1260-4191-ab81-52da95c117f2	2026-09-24 13:14	2026-09-24 13:14	2026-09-24 13:14	XLF	XLF261120P00050000	put	50.0000	2026-11-20	0.2800	0.2800	0.3000	54.4300	10500.00	0.00	10500.00	375	20	384	40048	0.00958849380743108	0.206409803889001	0.206409803889001	false	false	false	true
8842306c-2918-46ff-b8a1-f76a584a5f29	2026-09-24 13:11	2026-09-24 13:11	2026-09-24 13:11	XLF	XLF261218C00056000	call	56.0000	2026-12-18	1.2300	1.2300	1.4700	54.3550	22632.00	0.00	22632.00	184	14	5417	15824	0.342328109201213	0.163237171888847	0.163237171888847	false	false	false	true
2179c617-a856-4d48-a54b-6de21ef0e3c3	2026-09-24 12:59	2026-09-24 12:58	2026-09-24 12:58	XLF	XLF261008P00055000	put	55.0000	2026-10-08	0.9300	0.8400	0.9300	54.0000	15345.00	15345.00	0.00	165	26	167	0	0	0.1629521355805	0.1629521355805	true	false	false	true
512538c8-1e9d-40f2-b68f-bde50eb19ae4	2026-09-24 12:40	2026-09-24 12:40	2026-09-24 12:40	XLF	XLF261120P00049000	put	49.0000	2026-11-20	0.2100	0.2100	0.2300	54.5250	11382.00	0.00	11382.00	542	19	643	3165	0.203159557661927	0.222083327348651	0.222083327348651	false	false	false	true
ce1f06db-0d0d-4f43-9abc-3e109f7a2691	2026-09-24 12:28	2026-09-24 12:28	2026-09-24 12:28	XLF	XLF270319P00053000	put	53.0000	2027-03-19	1.6000	1.5900	1.6600	54.4800	79802.00	48320.00	31482.00	500	8	550	5154	0.106713232440823	0.182112732221427	0.182112732221427	false	false	false	true
74e5017e-a1b9-473a-9cf1-c1a8ce33345a	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3600	0.3600	0.4100	54.0000	17280.00	0.00	17280.00	480	18	1086	31683	0.0342770570968658	0.182240663779112	0.182240663779112	true	false	false	true
af09f61c-eb5b-44b8-ab6c-864c4cbcbdaf	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	XLF	XLF261120C00056000	call	56.0000	2026-11-20	0.8900	0.8200	0.9000	54.0000	13440.00	13440.00	0.00	151	5	753	35484	0.0212208319242475	0.16142138186969	0.16264035297452	false	false	false	true
26c38593-dc75-4c2a-8e41-1b202f43d864	2026-09-24 11:44	2026-09-24 11:44	2026-09-24 11:44	XLF	XLF261016C00056500	call	56.5000	2026-10-16	0.2200	0.2100	0.2300	54.3144	22308.00	286.00	20658.00	1014	17	2416	4466	0.540976265114196	0.165240196645586	0.165240196645586	false	false	false	true
ec6d679d-0a9f-4645-80a3-b4c707443252	2026-09-24 11:29	2026-09-24 11:29	2026-09-24 11:29	XLF	XLF261016C00055000	call	55.0000	2026-10-16	0.6300	0.6300	0.6600	54.3150	15687.00	0.00	15687.00	249	15	611	34678	0.0176192398638907	0.164391223992635	0.164391223992635	false	false	false	true
8e1ebeda-4a53-4945-84a7-a8f665cda846	2026-09-24 11:29	2026-09-24 11:29	2026-09-24 11:29	XLF	XLF261016C00055000	call	55.0000	2026-10-16	0.6300	0.6300	0.6600	54.3200	15498.00	0.00	15498.00	246	10	358	34678	0.010323548070823	0.163996465551212	0.163996465551212	false	false	false	true
f6cf1ba7-e3fc-4d9a-b0fb-2ed798c6520a	2026-09-24 11:05	2026-09-24 11:05	2026-09-24 11:05	XLF	XLF261218P00053000	put	53.0000	2026-12-18	1.0500	1.0300	1.0600	54.3300	10395.00	6195.00	4200.00	99	6	462	10195	0.0453163315350662	0.177664577323416	0.177664577323416	false	false	false	true
7dfa70ae-5e4d-437a-9566-48c103d0aca4	2026-09-24 11:03	2026-09-24 11:03	2026-09-24 11:03	XLF	XLF270115C00058000	call	58.0000	2027-01-15	0.8400	0.8400	0.9200	54.3450	21000.00	0.00	21000.00	250	11	275	14605	0.0188291680931188	0.157858058000714	0.157858058000714	false	false	false	true
45159da6-e592-4b05-9140-811b6e749727	2026-09-24 10:58	2026-09-24 10:58	2026-09-24 10:58	XLF	XLF260930C00055000	call	55.0000	2026-09-30	0.1700	0.1500	0.1900	54.3450	11900.00	0.00	7973.00	700	23	1543	3420	0.451169590643275	0.145499683009578	0.145499683009578	true	false	false	true
88cc16d0-f222-4258-8fe8-1bc8a9ea021c	2026-09-24 10:44	2026-09-24 10:44	2026-09-24 10:44	XLF	XLF261218C00056000	call	56.0000	2026-12-18	1.2600	1.2600	1.3300	54.4150	23310.00	0.00	23310.00	185	17	186	15824	0.0117542972699697	0.163719163250699	0.163719163250699	false	false	false	true
1f37cbee-03be-44ce-8da7-6f33191c4b03	2026-09-24 10:38	2026-09-24 10:38	2026-09-24 10:38	XLF	XLF270115P00052000	put	52.0000	2027-01-15	0.9400	0.9400	0.9700	54.5400	80840.00	0.00	80840.00	860	39	993	36223	0.0274135217955443	0.186128346494061	0.186128346494061	false	false	false	true
771f95b1-75d6-4456-8a70-2f802cb4f51c	2026-09-24 10:33	2026-09-24 10:33	2026-09-24 10:33	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3600	0.3400	0.3600	54.4650	13068.00	13068.00	0.00	363	10	450	31683	0.0142032004545024	0.181076163385499	0.181076163385499	false	false	false	true
592f0650-c1f5-4f69-973b-256c886f640b	2026-09-24 10:25	2026-09-24 10:25	2026-09-24 10:25	XLF	XLF270115C00055000	call	55.0000	2027-01-15	2.0400	2.0400	2.1700	54.4999	23664.00	0.00	23664.00	116	18	236	83758	0.00281764129993553	0.159445673934403	0.159445673934403	false	false	false	true
2f2c43f2-fb85-473f-8c63-ab99abf066e1	2026-09-24 10:05	2026-09-24 10:05	2026-09-24 10:05	XLF	XLF270617C00062000	call	62.0000	2027-06-17	1.1200	1.1200	1.1300	54.6200	13012.00	0.00	10752.00	116	6	116	1436	0.0807799442896936	0.159473214480366	0.158820068857718	false	false	false	true
98cae36d-226e-4835-ad68-9967cb6e860e	2026-09-24 10:05	2026-09-24 10:05	2026-09-24 10:05	XLF	XLF261023P00054000	put	54.0000	2026-10-23	0.6800	0.6800	0.7500	54.6050	12580.00	0.00	12580.00	185	9	227	385	0.58961038961039	0.167551724893665	0.167551724893665	false	false	false	true
04c768ea-53f3-45d7-88ac-58f73aa41ce1	2026-09-24 10:03	2026-09-24 10:03	2026-09-24 10:03	XLF	XLF261120C00056000	call	56.0000	2026-11-20	0.9400	0.8900	0.9400	54.5750	16423.00	15604.00	819.00	175	8	550	35484	0.0154999436365686	0.162319531209981	0.15869962636002	false	false	false	true
cfc4726a-e327-4d41-8db2-8827933cf3bd	2026-09-24 09:51	2026-09-24 09:51	2026-09-24 09:51	XLF	XLF260928C00054500	call	54.5000	2026-09-28	0.3000	0.2700	0.3000	54.4250	10080.00	10080.00	0.00	336	14	373	10	37.3	0.142895733111645	0.142895733111645	true	false	false	true
a37f48b9-b45d-4b38-8f10-0fd2aaaacb5a	2026-09-24 09:45	2026-09-24 09:45	2026-09-24 09:45	XLF	XLF270115C00055000	call	55.0000	2027-01-15	1.9700	1.9700	2.1000	54.3400	15366.00	0.00	15366.00	78	7	109	83758	0.0013013682275126	0.160668385799066	0.160668385799066	false	false	false	true
5a655f12-da0b-4e06-b071-b514b9435005	2026-09-23 15:37	2026-09-23 15:37	2026-09-23 15:37	XLF	XLF270115P00055000	put	55.0000	2027-01-15	1.9600	1.9500	1.9700	54.6350	39602.00	39602.00	0.00	202	6	1313	44736	0.0293499642346209	0.176841848810042	0.176015295508076	false	false	false	true
a7b28e7d-54dc-4f07-9402-99283349bab4	2026-09-23 15:34	2026-09-23 15:34	2026-09-23 15:34	XLF	XLF261120C00056000	call	56.0000	2026-11-20	1.0200	1.0100	1.0400	54.6250	12036.00	102.00	11934.00	118	7	625	35011	0.0178515323755391	0.167818834227011	0.167818834227011	false	false	false	true
3a88e7b6-57b6-4cf1-83b0-7c327eab83b6	2026-09-23 15:19	2026-09-23 15:18	2026-09-23 15:18	XLF	XLF270115C00057000	call	57.0000	2027-01-15	1.2600	1.2300	1.2600	54.6350	45864.00	45864.00	0.00	364	39	3078	18081	0.170233947237432	0.158739875864133	0.158739875864133	false	false	false	true
ae68e033-fea9-4a30-a724-77357a923cc2	2026-09-23 14:51	2026-09-23 14:51	2026-09-23 14:51	XLF	XLF261023C00058000	call	58.0000	2026-10-23	0.1600	0.1600	0.1700	54.6450	14336.00	0.00	14336.00	896	15	919	160	5.74375	0.167496338900788	0.167496338900788	false	false	false	true
36da2e95-b614-4b09-b1fa-6f680f631092	2026-09-23 14:49	2026-09-23 14:49	2026-09-23 14:49	XLF	XLF270115C00057000	call	57.0000	2027-01-15	1.2700	1.2300	1.2700	54.6650	69469.00	69469.00	0.00	547	32	2714	18081	0.150102317349704	0.158595833783533	0.158595833783533	false	false	false	true