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:option_symbol = XOP260918P00180000×ticker = XOP×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	expiry

3882e80c-62b9-4ee9-b8aa-a2d696dc0840	2026-08-17 12:41	2026-08-17 12:41	2026-08-17 12:41	XOP	XOP260918P00180000	put	180.0000	2026-09-18	5.6000	5.4000	5.6000	181.4200	119840.00	119840.00	0.00	214	39	224	572	0.391608391608392	0.307967522875438	0.307967522875438	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	4170340047.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c538bab4-abfa-4077-b15c-fe634d2534bd	2026-08-18 10:21	2026-08-18 10:20	2026-08-18 10:20	XOP	XOP260918P00180000	put	180.0000	2026-09-18	4.6000	4.5500	4.8000	183.9000	503700.00	373520.00	73600.00	1095	10	1098	743	1.47779273216689	0.312652493976055	0.312652493976055	true	false	false	true
1d5a34fb-4429-4faa-afdc-ba394a723b01	2026-08-18 10:21	2026-08-18 10:21	2026-08-18 10:21	XOP	XOP260918P00180000	put	180.0000	2026-09-18	4.6500	4.6500	4.7000	184.0200	93930.00	0.00	93930.00	202	5	1436	743	1.93270524899058	0.317325830070857	0.317325830070857	true	false	false	true
450b9555-be0f-4886-8720-9468ccfb02ec	2026-08-18 10:22	2026-08-18 10:22	2026-08-18 10:22	XOP	XOP260918P00180000	put	180.0000	2026-09-18	4.7000	4.5000	4.7000	184.1400	69530.00	69530.00	0.00	148	31	1804	743	2.42799461641992	0.321993373156745	0.321993373156745	false	false	false	true
fbcabea9-bcdc-49a6-93b1-2c50fdd85c41	2026-08-19 13:51	2026-08-19 13:51	2026-08-19 13:51	XOP	XOP260918P00180000	put	180.0000	2026-09-18	3.6000	3.5000	3.6500	186.9250	36000.00	28800.00	6480.00	100	13	208	4242	0.049033474776049	0.319278101760917	0.319278101760917	false	false	false	true
57d1a7c3-3193-4651-9449-51ed5fa5436d	2026-08-20 11:20	2026-08-20 11:20	2026-08-20 11:20	XOP	XOP260918P00180000	put	180.0000	2026-09-18	3.1000	2.8600	3.1000	188.8700	380934.00	380934.00	0.00	1229	68	1301	4325	0.300809248554913	0.328190918229441	0.328190918229441	false	false	false	true
dcf2a855-dd15-4a45-b555-13f8c5a0bd8d	2026-08-20 11:21	2026-08-20 11:21	2026-08-20 11:21	XOP	XOP260918P00180000	put	180.0000	2026-09-18	3.1000	3.1000	3.1500	188.9300	310000.00	0.00	310000.00	1000	10	2314	4325	0.535028901734104	0.329118570612228	0.329118570612228	false	false	false	true
4426fa61-9af1-4693-8a28-166ab6a5801f	2026-08-20 15:07	2026-08-20 15:07	2026-08-20 15:07	XOP	XOP260918P00180000	put	180.0000	2026-09-18	3.7500	3.6500	3.7500	186.8600	28125.00	28125.00	0.00	75	17	3341	4325	0.772485549132948	0.331303837736142	0.331303837736142	true	false	false	true
2b5534aa-a5ba-4022-bfae-1770509abfdc	2026-08-20 15:07	2026-08-20 15:07	2026-08-20 15:07	XOP	XOP260918P00180000	put	180.0000	2026-09-18	3.7500	3.6500	3.7500	186.8600	11625.00	11625.00	0.00	31	8	3266	4325	0.75514450867052	0.331303837736142	0.331303837736142	true	false	false	true
5e22857d-7c72-4f90-a3d5-9f66dd3d11e5	2026-08-21 10:14	2026-08-21 10:14	2026-08-21 10:14	XOP	XOP260918P00180000	put	180.0000	2026-09-18	3.2000	3.0500	3.2500	188.5600	10880.00	2880.00	2240.00	34	6	94	7468	0.0125870380289234	0.334534341930651	0.334534341930651	true	false	false	true
25cd678f-d1f1-41e0-a7d4-a1e2668ff2ef	2026-08-21 12:33	2026-08-21 12:33	2026-08-21 12:33	XOP	XOP260918P00180000	put	180.0000	2026-09-18	2.7200	2.6800	2.7700	189.7900	21511.00	10671.00	10840.00	79	5	459	7468	0.0614622388859132	0.325155397628759	0.325750234387379	false	false	false	true
7bef139f-74c0-4771-a315-d0e9cbfb290d	2026-08-25 15:58	2026-08-25 15:58	2026-08-25 15:58	XOP	XOP260918P00180000	put	180.0000	2026-09-18	4.5000	3.9500	4.5000	183.1600	326700.00	326700.00	0.00	726	43	797	8188	0.0973375671714704	0.330303089327295	0.330845346695872	false	false	false	true
9d61d858-5b7c-4cfc-83df-dfe367989591	2026-09-11 12:15	2026-09-11 12:15	2026-09-11 12:15	XOP	XOP260918P00180000	put	180.0000	2026-09-18	0.1900	0.1900	0.3900	196.4000	28215.00	0.00	27930.00	1485	49	1491	8214	0.181519357195033	0.378468952358366	0.378468952358366	false	false	false	true