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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = FRPT×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	expirydate	pricenumeric

58ebce9e-b242-4236-b6ed-b0046ccd9cd1	2026-08-17 12:56	2026-08-17 12:55	2026-08-17 12:55	FRPT	FRPT260918C00075000	call	75.0000	2026-09-18	3.1000	3.1000	3.4000	72.6100	64791.00	0.00	64791.00	209	34	221	157	1.40764331210191	0.469306403038659	0.469306403038659	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	3064663379.00	2026-11-02	unknown	—	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
134483dc-87e6-4c6b-8fad-33a372732904	2026-08-18 13:51	2026-08-18 13:51	2026-08-18 13:51	FRPT	FRPT261120P00072500	put	72.5000	2026-11-20	7.6000	7.6000	7.9000	72.7200	53200.00	0.00	53200.00	70	18	88	3	29.3333333333333	0.553026432387835	0.553026432387835	false	false	false	true	false
fc19ddba-2c67-40fb-aae6-7134a8ac8d5e	2026-08-19 12:07	2026-08-19 12:07	2026-08-19 12:07	FRPT	FRPT260821C00075000	call	75.0000	2026-08-21	1.2500	1.2500	1.4000	75.0000	19260.00	0.00	19260.00	154	28	249	551	0.451905626134301	0.560962950035379	0.560962950035379	false	false	false	true	false
dda07c03-cda3-4dbe-b5a5-9145343ac938	2026-08-20 11:51	2026-08-20 11:51	2026-08-20 11:51	FRPT	FRPT261016P00072500	put	72.5000	2026-10-16	4.3000	4.3000	4.8000	75.0500	18923.00	0.00	18923.00	44	9	44	0	0	0.489386091347861	0.489386091347861	false	false	false	true	false
c57c5b3c-98b0-46ab-91a1-cd4f7e1383ba	2026-08-20 12:59	2026-08-20 12:58	2026-08-20 12:58	FRPT	FRPT261016P00072500	put	72.5000	2026-10-16	4.2000	4.2000	4.7000	74.8800	15540.00	0.00	15540.00	37	8	82	0	0	0.47478881108944	0.47478881108944	false	false	false	true	false
74d275b7-5e15-49fd-85e4-1ff2b38ae9e9	2026-08-21 11:16	2026-08-21 11:16	2026-08-21 11:16	FRPT	FRPT270115P00082500	put	82.5000	2027-01-15	14.3000	13.3000	15.8000	73.6700	30030.00	8580.00	21450.00	21	7	21	5	4.2	0.517407913123061	0.517407913123061	false	false	false	true	false
89a72e86-63fe-4869-a7ae-6e6b6b240c28	2026-08-21 14:56	2026-08-21 14:56	2026-08-21 14:56	FRPT	FRPT260918C00072500	call	72.5000	2026-09-18	4.7000	4.2000	4.8000	73.6900	86010.00	3290.00	470.00	183	31	183	309	0.592233009708738	0.491419189989149	0.491419189989149	false	false	false	true	false
3272ccd1-5038-4292-80e2-8522a1053d71	2026-08-21 14:56	2026-08-21 14:56	2026-08-21 14:56	FRPT	FRPT260918P00072500	put	72.5000	2026-09-18	3.1000	3.1000	3.4000	73.9100	32550.00	0.00	21700.00	105	19	110	51	2.15686274509804	0.477817478869884	0.477817478869884	false	false	false	true	false
df5dce94-aeaa-4720-9ad9-5e7ed6f17f43	2026-08-21 14:56	2026-08-21 14:56	2026-08-21 14:56	FRPT	FRPT260918P00072500	put	72.5000	2026-09-18	3.2000	3.0750	3.3000	73.8650	24960.00	6400.00	1920.00	78	18	188	51	3.68627450980392	0.48808122690783	0.48808122690783	false	false	false	true	false
c74f1118-181d-4717-951c-3a72b2f12519	2026-08-24 11:06	2026-08-24 11:06	2026-08-24 11:06	FRPT	FRPT261218C00085000	call	85.0000	2026-12-18	5.7500	5.4000	6.9000	75.7100	360530.00	0.00	360530.00	627	2	627	9	69.6666666666667	0.523066308372874	0.523066308372874	false	true	false	true	false
fc19058c-3677-4dd1-8af0-53de8a4ffeab	2026-08-24 14:20	2026-08-24 14:19	2026-08-24 14:19	FRPT	FRPT261016P00077500	put	77.5000	2026-10-16	6.0000	6.0000	6.1000	76.1600	22201.00	0.00	22201.00	37	16	37	0	0	0.475548516482508	0.475548516482508	false	false	false	true	false
2144c47c-5b19-48a4-8e97-d23ad2f277ab	2026-09-03 15:21	2026-09-03 15:21	2026-09-03 15:21	FRPT	FRPT261016P00055000	put	55.0000	2026-10-16	0.3900	0.1500	0.4000	69.4500	17375.00	13000.00	4375.00	450	24	1156	14	82.5714285714286	0.501145617031843	0.500269421383535	false	false	false	true	false
c1545d91-6e87-4afd-a6b0-24a89f7c2a0e	2026-09-03 15:22	2026-09-03 15:22	2026-09-03 15:22	FRPT	FRPT261016P00067500	put	67.5000	2026-10-16	3.2900	3.2000	3.6000	69.3000	34540.00	14960.00	18560.00	105	20	237	251	0.944223107569721	0.468570171044406	0.468570171044406	false	false	false	true	false
f9e659fc-0493-4871-a9c0-967ab9ba5a4a	2026-09-17 10:14	2026-09-17 10:14	2026-09-17 10:14	FRPT	FRPT260918P00062500	put	62.5000	2026-09-18	1.0300	0.0500	2.4000	62.9100	82400.00	0.00	82400.00	800	2	800	13	61.5384615384615	0.914205455634129	0.914205455634129	false	true	false	true	true
12e9c1a4-b6ea-47de-960f-68e8002ff605	2026-09-17 10:14	2026-09-17 10:14	2026-09-17 10:14	FRPT	FRPT260918P00062500	put	62.5000	2026-09-18	1.0300	0.0500	2.4000	62.9100	82400.00	0.00	82400.00	800	2	800	13	61.5384615384615	0.914205455634129	0.914205455634129	false	true	false	true	true
349ce881-ce7f-4bbf-9ba1-9d8b8e934704	2026-09-18 15:44	2026-09-18 15:44	2026-09-18 15:44	FRPT	FRPT261016P00055000	put	55.0000	2026-10-16	0.8000	0.7500	0.8500	61.5000	11840.00	0.00	11760.00	148	17	189	1027	0.184031158714703	0.473609928470033	0.473609928470033	false	false	false	true	false