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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 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 = EWJ×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

3bc1e974-e35c-4e8d-8e61-d9ae670da877	2026-08-20 12:55	2026-08-20 12:55	2026-08-20 12:55	EWJ	EWJ260828P00098000	put	98.0000	2026-08-28	3.6000	3.4000	3.7000	94.5800	15480.00	720.00	14760.00	43	12	43	50	0.86	0.229304619449946	0.229304619449946	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	23313950423.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
97c7f968-c328-42b7-8ca2-170ae8ed0c8f	2026-08-24 10:08	2026-08-24 10:08	2026-08-24 10:08	EWJ	EWJ261016C00097000	call	97.0000	2026-10-16	2.3000	2.3000	2.5000	94.4550	17940.00	0.00	17940.00	78	5	90	96	0.9375	0.220976203902269	0.220976203902269	false	false	false	true
d9e5d7db-34e6-4bbf-83d9-ff723d842240	2026-08-26 13:01	2026-08-26 13:01	2026-08-26 13:01	EWJ	EWJ260918P00092000	put	92.0000	2026-09-18	0.8500	0.8000	0.9000	95.3500	82705.00	0.00	82195.00	973	27	1093	782	1.39769820971867	0.233443067220001	0.233443067220001	false	false	false
361dc5ed-1211-4c0f-9e21-03a96470550c	2026-08-26 13:57	2026-08-26 13:57	2026-08-26 13:57	EWJ	EWJ261218P00084840	put	84.8400	2026-12-18	1.7300	1.4000	2.4500	95.3799	865000.00	0.00	865000.00	5000	1	5000	579	8.63557858376511	0.288875914129574	0.288875914129574	false	true	true
2eefa605-0803-4075-8fd1-102fdd6cd666	2026-09-01 13:18	2026-09-01 13:18	2026-09-01 13:18	EWJ	EWJ280121C00130000	call	130.0000	2028-01-21	1.6500	1.6000	5.0000	95.3100	82500.00	0.00	82500.00	500	17	500	3010	0.166112956810631	0.191903984866297	0.191903984866297	false	false	false
dd2bd07c-f922-43fb-a128-e2bc3f4dffa4	2026-09-01 13:56	2026-09-01 13:56	2026-09-01 13:56	EWJ	EWJ280121C00130000	call	130.0000	2028-01-21	1.6500	1.6500	3.8000	95.3150	16500.00	0.00	16500.00	100	14	600	3010	0.199335548172757	0.191874688707286	0.191874688707286	false	false	false
0cd3737b-3b0f-48e5-ba74-3701837b3500	2026-09-02 10:29	2026-09-02 10:29	2026-09-02 10:29	EWJ	EWJ261120C00099000	call	99.0000	2026-11-20	2.5500	2.3500	2.5500	95.8400	40797.00	40797.00	0.00	160	38	160	4	40	0.199646650695922	0.199646650695922	false	false	false	true
a0b5750a-d704-4d6a-96e6-cf282f5e7ea1	2026-09-03 10:00	2026-09-03 09:59	2026-09-03 09:59	EWJ	EWJ260918P00096000	put	96.0000	2026-09-18	0.8500	0.8000	0.8500	97.5800	98345.00	98345.00	0.00	1157	8	1169	646	1.80959752321981	0.200182413948235	0.200182413948235	false	false	false
0455021a-461f-4c11-b68b-7462e0ffcd5f	2026-09-03 11:01	2026-09-03 11:01	2026-09-03 11:01	EWJ	EWJ261218C00099840	call	99.8400	2026-12-18	3.7000	3.3000	3.7000	97.8200	41070.00	41070.00	0.00	111	27	118	3285	0.0359208523592085	0.194963929921069	0.194963929921069	false	false	false
8412ebbc-03cf-4b8e-bff0-39e93d60dba4	2026-09-03 12:58	2026-09-03 12:57	2026-09-03 12:57	EWJ	EWJ261016C00100000	call	100.0000	2026-10-16	1.9500	1.8500	1.9500	98.3000	122459.00	122459.00	0.00	628	27	648	191	3.39267015706806	0.186285419885063	0.186285419885063	false	false	false
9d74862e-e8ca-474d-a45e-9bdcb274af5a	2026-09-03 14:58	2026-09-03 14:58	2026-09-03 14:58	EWJ	EWJ261016C00100000	call	100.0000	2026-10-16	1.8500	1.8000	1.8500	98.0900	91760.00	91760.00	0.00	496	15	1149	191	6.01570680628272	0.185518462055529	0.185518462055529	false	false	false
12d6fad0-df7f-4835-acd9-5d35fa1dea44	2026-09-04 11:27	2026-09-04 11:27	2026-09-04 11:27	EWJ	EWJ261016C00100000	call	100.0000	2026-10-16	1.9000	1.7500	1.9000	98.2100	157510.00	157510.00	0.00	829	29	829	1334	0.62143928035982	0.187895458232282	0.187895458232282	false	false	false
c493d3c5-799e-4db2-9945-76b380ff1819	2026-09-04 13:53	2026-09-04 13:53	2026-09-04 13:53	EWJ	EWJ261016C00098000	call	98.0000	2026-10-16	2.9000	2.7500	3.0000	98.0900	44370.00	44370.00	0.00	153	34	156	18	8.66666666666667	0.198439175768754	0.198439175768754	false	false	false
3239cb4d-e7aa-4f81-a826-e319fcf7f8c8	2026-09-09 11:38	2026-09-09 11:37	2026-09-09 11:37	EWJ	EWJ270115C00099840	call	99.8400	2027-01-15	4.0000	3.6000	4.0000	97.3350	39600.00	39600.00	0.00	99	28	100	3607	0.0277238702522872	0.196221009421416	0.196221009421416	false	false	false
865eeaaf-1a5d-40ce-a1f1-96a85a3ec655	2026-09-09 13:14	2026-09-09 13:14	2026-09-09 13:14	EWJ	EWJ270115C00104840	call	104.8400	2027-01-15	2.2500	1.8000	2.4000	97.2500	14400.00	11025.00	3375.00	64	12	118	142	0.830985915492958	0.198138289586612	0.198138289586612	false	false	false
82875ea2-67f1-44c5-b341-115f5cc8d32a	2026-09-09 14:27	2026-09-09 14:27	2026-09-09 14:27	EWJ	EWJ260918C00100000	call	100.0000	2026-09-18	0.4500	0.3500	0.5000	97.2050	70695.00	11115.00	59580.00	1571	36	1574	8237	0.191088988709482	0.227907137595209	0.227907137595209	false	false	false
5a668477-a943-4989-bbe4-3603f6df2de7	2026-09-09 15:04	2026-09-09 15:04	2026-09-09 15:04	EWJ	EWJ260918P00097000	put	97.0000	2026-09-18	1.4000	1.1000	1.8000	96.9950	53340.00	7140.00	46200.00	381	20	381	412	0.924757281553398	0.237541600500732	0.237541600500732	false	false	false
d9168eea-a907-40d6-8870-2e6cf2d633ca	2026-09-11 10:08	2026-09-11 10:08	2026-09-11 10:08	EWJ	EWJ260918P00100000	put	100.0000	2026-09-18	1.9500	1.8500	1.9500	98.5200	177450.00	177450.00	0.00	910	18	921	10	92.1	0.202266767703218	0.202266767703218	false	false	false
8cd779f2-9938-4f31-9bea-753bec991356	2026-09-11 12:53	2026-09-11 12:53	2026-09-11 12:53	EWJ	EWJ261016P00094000	put	94.0000	2026-10-16	1.0500	0.9500	1.1000	98.6600	127785.00	126630.00	1155.00	1217	40	1279	1052	1.21577946768061	0.243715491401047	0.243715491401047	false	false	false
f38845e7-e23d-47af-85e7-d572480ba9de	2026-09-16 14:52	2026-09-16 14:52	2026-09-16 14:52	EWJ	EWJ260925P00100000	put	100.0000	2026-09-25	2.9000	2.9000	3.0000	97.4200	127600.00	0.00	127600.00	440	7	450	7	64.2857142857143	0.209974827346945	0.209974827346945	false	false	false
021032ce-baad-4bd4-9c16-9c3eb69f15c0	2026-09-16 15:19	2026-09-16 15:19	2026-09-16 15:19	EWJ	EWJ260925P00094000	put	94.0000	2026-09-25	0.6500	0.4000	0.6500	96.3200	12991.00	12991.00	0.00	200	29	201	19	10.5789473684211	0.263476293234453	0.263476293234453	false	false	false
f004a4e0-57cd-43da-8b93-51b0afe1abcb	2026-09-17 12:29	2026-09-17 12:28	2026-09-17 12:28	EWJ	EWJ260925C00096000	call	96.0000	2026-09-25	2.5500	2.5500	2.7000	97.9150	18360.00	0.00	18360.00	72	28	72	23	3.1304347826087	0.230034641086817	0.230034641086817	false	false	false
6ef97e43-9cfc-4877-a732-0423e141efa4	2026-09-18 10:08	2026-09-18 10:08	2026-09-18 10:08	EWJ	EWJ261218P00094840	put	94.8400	2026-12-18	3.6500	3.0000	5.4000	96.3400	5475000.00	0.00	5475000.00	15000	2	15000	6	2500	0.247455575319678	0.247455575319678	false	true	false
576684d2-d397-4189-baa9-005eba266944	2026-09-18 10:08	2026-09-18 10:08	2026-09-18 10:08	EWJ	EWJ261218P00094840	put	94.8400	2026-12-18	3.6500	3.0000	5.4000	96.3400	5475000.00	0.00	5475000.00	15000	2	15000	6	2500	0.247455575319678	0.247455575319678	false	true	false
0b2c05dd-b256-4112-9b8f-492847c7a3b0	2026-09-18 10:09	2026-09-18 10:08	2026-09-18 10:08	EWJ	EWJ260925P00094000	put	94.0000	2026-09-25	0.4000	0.3500	0.4500	96.3200	58200.00	360.00	57840.00	1455	21	2572	1371	1.87600291757841	0.237456167416919	0.237456167416919	false	false	false
f2e4b626-5a65-46df-ac31-cc8ed01378ae	2026-09-21 12:16	2026-09-21 12:16	2026-09-21 12:16	EWJ	EWJ261120P00093000	put	93.0000	2026-11-20	1.5000	1.5000	1.6500	97.8950	11700.00	0.00	11700.00	78	23	80	20	4	0.234621811946852	0.234621811946852	false	false	false	true
e4a54664-72dd-4950-b3f6-5f6621ee599b	2026-09-21 14:10	2026-09-21 14:09	2026-09-21 14:09	EWJ	EWJ261120P00087000	put	87.0000	2026-11-20	0.6500	0.6500	0.8000	97.9401	39780.00	0.00	39780.00	612	29	614	36	17.0555555555556	0.272197224151893	0.272197224151893	false	false	false
410c1aa9-0671-4bab-93a4-62a9471a36e0	2026-09-23 12:56	2026-09-23 12:56	2026-09-23 12:56	EWJ	EWJ261016C00094500	call	94.5000	2026-10-16	3.8000	3.8000	4.0000	96.9300	24700.00	0.00	24700.00	65	15	65	0	0	0.23157555237144	0.23157555237144	false	false	false	true
814e47a7-3251-4969-9467-2896a8be4faa	2026-09-23 14:42	2026-09-23 14:42	2026-09-23 14:42	EWJ	EWJ261218P00089840	put	89.8400	2026-12-18	1.5000	1.5000	1.9500	97.1000	11400.00	0.00	11400.00	76	5	96	1010	0.0950495049504951	0.246164525749999	0.246164525749999	false	false	false
94fbde33-a59d-46da-993f-2c351958d53c	2026-09-24 14:47	2026-09-24 14:47	2026-09-24 14:47	EWJ	EWJ261120P00094000	put	94.0000	2026-11-20	2.3500	2.0000	2.7000	95.0000	11275.00	0.00	230.00	48	5	51	2302	0.0221546481320591	0.226967576284645	0.223480450231814	false	false	false