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:ticker = SPXW×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	price

39874082-f2f2-4403-a44e-730d4dff5a22	2026-08-26 15:33	2026-08-26 15:33	2026-08-26 15:33	SPXW	SPXW260827C07690000	call	7690.0000	2026-08-27	22.3200	22.3000	22.5000	7685.7700	158450.00	0.00	140530.00	71	14	2564	300	8.54666666666667	0.149986812334755	0.149362847174871	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-26T19:41:15.773512Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
39782803-5f97-4ef6-9a2f-a7e964061228	2026-08-26 15:40	2026-08-26 15:40	2026-08-26 15:40	SPXW	SPXW260827P07685000	put	7685.0000	2026-08-27	23.0000	23.0000	23.2000	7684.9100	101200.00	0.00	101200.00	44	7	2029	265	7.65660377358491	0.145528331134871	0.145528331134871	false	false	false	true	false
dbec08df-5468-4e52-986e-c58243cca460	2026-08-26 15:40	2026-08-26 15:40	2026-08-26 15:40	SPXW	SPXW260827P07685000	put	7685.0000	2026-08-27	22.9000	22.8000	23.1000	7685.2700	109920.00	0.00	109920.00	48	7	2077	265	7.8377358490566	0.146009967724563	0.146009967724563	false	false	false	true	false
0aa321b2-7b8f-4c40-959c-7fe8a7b75c9b	2026-08-26 15:40	2026-08-26 15:40	2026-08-26 15:40	SPXW	SPXW260827P07685000	put	7685.0000	2026-08-27	22.9000	22.8000	23.0000	7685.4700	116790.00	50380.00	43510.00	51	7	2148	265	8.10566037735849	0.146621490744725	0.146621490744725	false	false	false	true	false
b85544d8-044c-443a-8a61-3eee946421ef	2026-08-26 15:40	2026-08-26 15:40	2026-08-26 15:40	SPXW	SPXW260827C07685000	call	7685.0000	2026-08-27	24.6000	24.5000	24.8000	7685.8900	127920.00	0.00	127920.00	52	9	2953	187	15.7914438502674	0.147975671054512	0.147975671054512	false	false	false	true	false
93b6d182-6e35-4c7b-ac4a-a437b0648a00	2026-08-26 15:41	2026-08-26 15:40	2026-08-26 15:40	SPXW	SPXW260827C07685000	call	7685.0000	2026-08-27	24.6000	24.5000	24.7000	7685.6100	130380.00	0.00	103320.00	53	6	3037	187	16.2406417112299	0.148869141540032	0.148869141540032	false	false	false	true	false
6c17d668-1420-4175-9dcc-a21a3257ba6a	2026-08-26 15:52	2026-08-26 15:52	2026-08-26 15:52	SPXW	SPXW260904C07710000	call	7710.0000	2026-09-04	47.4000	47.4000	47.5000	7684.7800	237000.00	0.00	237000.00	50	6	134	173	0.774566473988439	0.116082125456762	0.116082125456762	false	false	false	true	false
ee50c77a-135d-4a53-b829-5b74d3e424d3	2026-08-26 15:54	2026-08-26 15:54	2026-08-26 15:54	SPXW	SPXW260828C07000000	call	7000.0000	2026-08-28	684.0000	684.0000	686.3000	7681.2100	29685600.00	0.00	29685600.00	434	8	437	2727	0.16024935826916	0.561828677381127	0.561828677381127	false	false	false	true	false
11a80378-833f-4242-9094-6fd168fcc53a	2026-08-26 15:54	2026-08-26 15:54	2026-08-26 15:54	SPXW	SPXW260826P07680000	put	7680.0000	2026-08-26	2.7800	2.3500	3.0000	7678.8000	321020.00	214640.00	100065.00	1156	438	120610	2547	47.3537495092265	0.216855120152325	0.174773755232714	true	false	false	true	false
3070ebaf-fe22-43cb-8dde-810699a7c12a	2026-08-26 15:59	2026-08-26 15:59	2026-08-26 15:59	SPXW	SPXW260827P07700000	put	7700.0000	2026-08-27	38.3600	38.3000	38.8000	7673.5700	176460.00	0.00	176460.00	46	15	2209	2261	0.977001326846528	0.147104850911089	0.145692550043916	false	false	false	true	false
8b0f6f55-da33-4163-bd5d-46b0b6f91d62	2026-08-26 16:00	2026-08-26 15:59	2026-08-26 15:59	SPXW	SPXW260902P07670000	put	7670.0000	2026-09-02	43.0400	43.0000	43.6000	7676.3800	284050.00	0.00	284050.00	66	5	153	46	3.32608695652174	0.115261399500407	0.115261399500407	false	false	false	true	false
51bc90fe-69bc-4afd-a317-862aec0d352d	2026-08-26 16:06	2026-08-26 16:06	2026-08-26 16:06	SPXW	SPXW260831C07775000	call	7775.0000	2026-08-31	9.0000	9.0000	9.1000	7675.7000	111600.00	0.00	111600.00	124	5	474	1980	0.239393939393939	0.110145018302382	0.110145018302382	false	false	false	true	false
6d748d1d-f52e-402d-bbe3-e04369e730e1	2026-08-26 16:25	2026-08-26 16:22	2026-08-26 16:22	SPXW	SPXW260827C07685000	call	7685.0000	2026-08-27	18.8900	18.5000	19.9000	7675.7000	188930.00	86480.00	102450.00	100	10	3872	187	20.7058823529412	0.144688421279149	0.142166896397516	false	false	false	true	false
3109eb16-5dfa-4da7-8fde-2f8bf1e49f28	2026-08-26 16:42	2026-08-26 16:25	2026-08-26 16:25	SPXW	SPXW260831C07775000	call	7775.0000	2026-08-31	7.5000	7.1000	7.6000	7675.7000	112500.00	18750.00	93750.00	150	11	757	1980	0.382323232323232	0.10337158444246	0.10337158444246	false	false	false	true	false
eab398be-6908-4f41-8f98-04c3de7ae355	2026-08-26 16:50	2026-08-26 16:42	2026-08-26 16:42	SPXW	SPXW260827C07745000	call	7745.0000	2026-08-27	2.7000	2.6500	2.7500	7675.7000	135000.00	0.00	0.00	500	8	5846	215	27.1906976744186	0.134803065768834	0.134803065768834	false	false	false	true	false
e9f440f7-348c-41cf-ac00-959acc8d91fa	2026-08-26 16:50	2026-08-26 16:42	2026-08-26 16:42	SPXW	SPXW260827P07630000	put	7630.0000	2026-08-27	4.7400	4.6000	4.9000	7675.7000	237038.00	0.00	109263.00	500	8	5382	498	10.8072289156626	0.124802961328809	0.124802961328809	false	false	false	true	false
bcbe7610-81ef-4470-a26f-2dac427cc5bc	2026-08-26 16:50	2026-08-26 16:42	2026-08-26 16:42	SPXW	SPXW260827P07620000	put	7620.0000	2026-08-27	3.4500	3.3000	3.6000	7675.7000	172731.00	79926.00	0.00	500	8	3061	357	8.57422969187675	0.127446120650182	0.127446120650182	false	false	false	true	false
b6a9a94b-7d37-4197-b76e-a1e2c9e69972	2026-08-26 16:50	2026-08-26 16:42	2026-08-26 16:42	SPXW	SPXW260827C07735000	call	7735.0000	2026-08-27	3.8400	3.7000	4.0000	7675.7000	192038.00	0.00	88473.00	500	8	3627	2399	1.51187994997916	0.134125198952696	0.134125198952696	false	false	false	true	false
5b47e295-c6cd-4c7d-8212-1fee0a548a92	2026-08-26 16:50	2026-08-26 16:50	2026-08-26 16:50	SPXW	SPXW260828C07590000	call	7590.0000	2026-08-28	106.1000	105.0000	106.9000	7675.7000	371350.00	318300.00	53050.00	35	7	71	632	0.112341772151899	0.226385785977137	0.226385785977137	false	false	false	true	false
f294dd6a-d72f-466e-9386-4413f6f996b3	2026-08-26 16:52	2026-08-26 16:50	2026-08-26 16:50	SPXW	SPXW260831C07775000	call	7775.0000	2026-08-31	7.7000	7.6000	8.0000	7675.7000	110880.00	85470.00	25410.00	144	5	908	1980	0.458585858585859	0.104299879275554	0.104299879275554	false	false	false	true	false
8e62891e-9bbe-4e83-bfe7-b541b122c060	2026-08-27 09:30	2026-08-26 16:52	2026-08-26 16:52	SPXW	SPXW260827C07700000	call	7700.0000	2026-08-27	14.7100	14.5000	15.0000	7675.7000	147100.00	0.00	147100.00	100	8	8640	1747	4.94562106468231	0.153883001599671	0.153883001599671	false	false	false	true	false
062ed98a-c8ce-4724-8ea0-c0023c5457c7	2026-08-27 09:30	2026-08-26 16:52	2026-08-26 16:52	SPXW	SPXW260827C07690000	call	7690.0000	2026-08-27	19.5100	19.2000	19.7000	7675.7000	195100.00	195100.00	0.00	100	8	4380	300	14.6	0.160192852515706	0.160192852515706	false	false	false	true	false
af94022d-ad81-4121-a0a0-71b564089ea4	2026-08-27 09:32	2026-08-27 09:32	2026-08-27 09:32	SPXW	SPXW260828C07705000	call	7705.0000	2026-08-28	22.9100	22.8000	23.3000	7695.7300	114560.00	0.00	114560.00	50	12	185	566	0.326855123674912	0.168694247579718	0.166813720843138	false	false	false	true	false
a63e1d9c-5b9f-43e2-82e1-3f9c8dfe9b50	2026-08-27 09:34	2026-08-27 09:34	2026-08-27 09:34	SPXW	SPXW260915P07600000	put	7600.0000	2026-09-15	43.6000	43.4000	43.8000	7697.4300	104640.00	21800.00	0.00	24	7	68	496	0.137096774193548	0.12752507665126	0.12752507665126	false	false	false	true	false
ff2d2558-683e-4ed1-8165-be6aee6d5ef2	2026-08-27 09:36	2026-08-27 09:35	2026-08-27 09:35	SPXW	SPXW260828C07695000	call	7695.0000	2026-08-28	27.0100	26.9000	27.3000	7695.7100	202610.00	0.00	202610.00	75	15	212	348	0.609195402298851	0.163910657016331	0.163910657016331	false	false	false	true	false
67d55b51-a060-4a3a-b34f-4034c0d657d4	2026-08-27 09:40	2026-08-27 09:39	2026-08-27 09:39	SPXW	SPXW260827C07690000	call	7690.0000	2026-08-27	20.0000	20.0000	20.1000	7700.9800	100000.00	0.00	100000.00	50	10	1671	1186	1.40893760539629	0.165752433084325	0.165752433084325	false	false	false	true	false
9db64fea-3901-4e13-a0b0-cd68510ca3f0	2026-08-27 09:40	2026-08-27 09:40	2026-08-27 09:40	SPXW	SPXW260827C07725000	call	7725.0000	2026-08-27	4.5600	4.4000	4.6000	7702.1800	114050.00	114050.00	0.00	250	34	3984	4314	0.923504867872045	0.153974706568851	0.155523992126019	false	false	false	true	false
047a7de6-63b7-4a4e-a0b4-f558a8155699	2026-08-27 09:40	2026-08-27 09:40	2026-08-27 09:40	SPXW	SPXW260827C07710000	call	7710.0000	2026-08-27	9.4000	9.3000	9.5000	7701.8000	131600.00	57340.00	0.00	140	10	4550	1324	3.43655589123867	0.157397983509826	0.157397983509826	false	false	false	true	false
7feca4e4-bc88-4b1d-bcfb-b550a28a0476	2026-08-27 09:41	2026-08-27 09:41	2026-08-27 09:41	SPXW	SPXW260827C07705000	call	7705.0000	2026-08-27	13.2900	13.2000	13.4000	7703.9100	111610.00	0.00	14520.00	84	7	4359	914	4.7691466083151	0.166792262903518	0.166494933521799	true	false	false	true	false
c17937b0-00ba-4a36-86f7-91454d59fb78	2026-08-27 09:42	2026-08-27 09:41	2026-08-27 09:41	SPXW	SPXW260827C07710000	call	7710.0000	2026-08-27	10.4000	10.4000	10.5000	7703.6500	446160.00	0.00	446160.00	429	70	5859	1324	4.42522658610272	0.160613860583113	0.160617449331097	false	false	false	true	false
ba36cd8b-3407-4c7c-a411-06a5c0515b05	2026-08-27 09:45	2026-08-27 09:44	2026-08-27 09:44	SPXW	SPXW260827C07715000	call	7715.0000	2026-08-27	10.8000	10.7000	10.9000	7710.1600	220280.00	196560.00	4280.00	204	24	4367	1803	2.42207432057682	0.158150598783218	0.157986837134825	false	false	false	true	false
8468787f-f6b4-4b5e-91fb-545d212ae632	2026-08-27 09:47	2026-08-27 09:47	2026-08-27 09:47	SPXW	SPXW260827P07660000	put	7660.0000	2026-08-27	3.3000	3.2000	3.4000	7702.3000	102230.00	99660.00	2570.00	310	20	7730	700	11.0428571428571	0.200825753465132	0.202908281629202	false	false	false	true	false
e530fea2-ca16-4933-b852-bf2389cab7e0	2026-08-27 09:51	2026-08-27 09:51	2026-08-27 09:51	SPXW	SPXW260828C07715000	call	7715.0000	2026-08-28	21.6000	21.5000	21.7000	7706.3600	108020.00	108020.00	0.00	50	7	469	618	0.758899676375405	0.157925853270294	0.157300009109594	false	false	false	true	false
c4de3318-5cc0-42db-8f40-145bd7f97b01	2026-08-27 09:51	2026-08-27 09:51	2026-08-27 09:51	SPXW	SPXW260827C07695000	call	7695.0000	2026-08-27	20.0600	20.0000	20.4000	7706.3600	100300.00	0.00	100300.00	50	11	3895	610	6.38524590163934	0.166395529194533	0.166395529194533	false	false	false	true	false
9b96d11e-d40f-4a04-96e6-89c5efb3ace6	2026-08-27 09:54	2026-08-27 09:54	2026-08-27 09:54	SPXW	SPXW260827C07705000	call	7705.0000	2026-08-27	16.0000	16.0000	16.2000	7710.8500	112000.00	0.00	112000.00	70	19	10173	914	11.1301969365427	0.157241631818491	0.157241631818491	false	false	false	true	false
47b9fd0c-ce76-45e1-a9d9-d54f52e817b8	2026-08-27 09:55	2026-08-27 09:55	2026-08-27 09:55	SPXW	SPXW260827C07710000	call	7710.0000	2026-08-27	10.8000	10.6000	11.0000	7704.2200	430870.00	422270.00	4320.00	399	32	13367	1324	10.0959214501511	0.164347252367233	0.165599912233507	false	false	false	true	false
edb89ac7-08e4-4f0f-bd41-001b7f174ac2	2026-08-27 09:55	2026-08-27 09:55	2026-08-27 09:55	SPXW	SPXW260828C07715000	call	7715.0000	2026-08-28	21.3500	21.3000	21.7000	7706.0200	213550.00	0.00	213550.00	100	24	687	618	1.11165048543689	0.159687224890376	0.156382380239667	false	false	false	true	false
f9a1f2bc-ed39-4912-b1d0-be1761fcbeec	2026-08-27 09:59	2026-08-27 09:59	2026-08-27 09:59	SPXW	SPXW260827C07705000	call	7705.0000	2026-08-27	11.3100	11.1000	11.4000	7699.9300	108550.00	101770.00	0.00	96	42	11739	914	12.8435448577681	0.16883577776194	0.168839726552576	false	false	false	true	false
e9edc10a-46d4-4f26-bd7c-9ef2e7da25dd	2026-08-27 10:01	2026-08-27 10:01	2026-08-27 10:01	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	103.4500	103.2000	103.6000	7704.6000	5172500.00	0.00	0.00	500	6	502	21793	0.0230349194695544	0.126775447169356	0.126775447169356	false	false	false	true	false
4ffaeb7d-bf7f-44ec-abbf-46307f3b1e5b	2026-08-27 10:01	2026-08-27 10:01	2026-08-27 10:01	SPXW	SPXW260930P07500000	put	7500.0000	2026-09-30	51.0800	50.7000	51.1000	7704.6000	3192500.00	0.00	0.00	625	6	705	26968	0.0261420943340255	0.147916813848983	0.147916813848983	false	false	false	true	false
988c4c16-da38-4cec-be57-aa7c2a495580	2026-08-27 10:04	2026-08-27 10:04	2026-08-27 10:04	SPXW	SPXW260827C07715000	call	7715.0000	2026-08-27	8.2800	8.1000	8.4000	7706.1600	250110.00	195740.00	830.00	302	56	12578	1803	6.97615085967831	0.150381750648247	0.151683687880194	false	false	false	true	false
6a56ddd9-45f0-4f21-a58b-4efa36d938e8	2026-08-27 10:04	2026-08-27 10:04	2026-08-27 10:04	SPXW	SPXW260902C07805000	call	7805.0000	2026-09-02	6.3000	6.2000	6.5000	7705.7200	204120.00	160020.00	44100.00	324	15	329	93	3.53763440860215	0.0882145216415097	0.0882145216415097	false	false	false	true	false
88a5d87e-23a8-4892-9499-ed6fe5333075	2026-08-27 10:09	2026-08-27 10:09	2026-08-27 10:09	SPXW	SPXW260904C07705000	call	7705.0000	2026-09-04	52.1000	51.8000	52.2000	7702.7100	208400.00	208400.00	0.00	40	5	119	110	1.08181818181818	0.109959074637476	0.109959074637476	true	false	false	true	false
0dd810c7-5570-402c-8fcd-8a2448a41e8b	2026-08-27 10:12	2026-08-27 10:12	2026-08-27 10:12	SPXW	SPXW260827C07715000	call	7715.0000	2026-08-27	8.4000	8.3000	8.5000	7706.6600	273740.00	203280.00	8300.00	326	43	14400	1803	7.98668885191348	0.152113574156639	0.150802564786071	false	false	false	true	false
60b13750-9298-4823-b52f-3ae91b190be4	2026-08-27 10:14	2026-08-27 10:14	2026-08-27 10:14	SPXW	SPXW260828P07725000	put	7725.0000	2026-08-28	34.1000	33.9000	34.2000	7704.5100	255750.00	17050.00	238700.00	75	6	343	1539	0.222871994801819	0.142313320969524	0.142313320969524	false	false	false	true	false
2a906530-c693-4900-9eb2-3d9b8267bf64	2026-08-27 10:16	2026-08-27 10:16	2026-08-27 10:16	SPXW	SPXW260827P07710000	put	7710.0000	2026-08-27	14.1000	14.0000	14.2000	7706.0400	107170.00	88840.00	0.00	76	13	8023	202	39.7178217821782	0.154229117418962	0.155511170194449	false	false	false	true	false
0801b493-d05f-4428-a164-3b3b269e262d	2026-08-27 10:24	2026-08-27 10:24	2026-08-27 10:24	SPXW	SPXW260827C07710000	call	7710.0000	2026-08-27	11.6000	11.5000	11.8000	7709.7400	124140.00	0.00	116020.00	107	23	23041	1324	17.4025679758308	0.151022337246958	0.149735603895619	false	false	false	true	false
4bf9b2dc-685e-4c1c-bbdc-e57e1bcd806d	2026-08-27 10:25	2026-08-27 10:25	2026-08-27 10:25	SPXW	SPXW260828C07600000	call	7600.0000	2026-08-28	114.8000	114.5000	115.5000	7712.0700	539560.00	0.00	459200.00	47	5	146	916	0.15938864628821	0.182470908203865	0.182470908203865	false	false	false	true	false
1737b024-71db-4cbb-87a9-dbf1a3583230	2026-08-27 10:25	2026-08-27 10:25	2026-08-27 10:25	SPXW	SPXW260827C07710000	call	7710.0000	2026-08-27	12.1000	12.1000	12.3000	7711.3700	124670.00	2460.00	122210.00	103	28	23391	1324	17.666918429003	0.145602806149505	0.145602806149505	false	false	false	true	false
5de45a7f-acfb-44da-902a-b04ed3a05ed5	2026-08-27 10:30	2026-08-27 10:30	2026-08-27 10:30	SPXW	SPXW260918P07700000	put	7700.0000	2026-09-18	77.5000	77.4000	77.8000	7710.5300	480500.00	232500.00	248000.00	62	5	794	800	0.9925	0.120849939481191	0.120564596255242	false	false	false	true	false