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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsDescendingFill×ticker = SPXW×

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

7829130b-9c6f-43b5-aa6e-61f0492d1e13	2026-10-02 10:47	2026-10-02 10:46	2026-10-02 10:46	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	10.2500	10.1000	10.3000	7749.5900	10250.00	5150.00	2040.00	10	6	22728	805	28.2335403726708	0.166310047588502	0.164973063005655	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-10-02T14:49:11.588051Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
2ad36bab-9b9d-4a23-8cb7-942190aaa44d	2026-10-02 10:46	2026-10-02 10:46	2026-10-02 10:46	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	11.1300	11.1000	11.3000	7747.7700	11130.00	0.00	7770.00	10	5	22594	805	28.0670807453416	0.167163273424162	0.165833233816179	false	false	false	true
0f26f92e-ff7f-4990-ae32-c48e82658a08	2026-10-02 10:45	2026-10-02 10:45	2026-10-02 10:45	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	10.3000	10.2000	10.4000	7749.3100	12360.00	7260.00	5100.00	12	6	22491	805	27.9391304347826	0.160709508361607	0.164321275801677	false	false	false	true
12c326ec-932b-436b-996c-cf4259789727	2026-10-02 10:45	2026-10-02 10:45	2026-10-02 10:45	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	11.1000	11.0000	11.2000	7747.9000	13320.00	1120.00	12200.00	12	6	22450	805	27.888198757764	0.167824690064439	0.165165785706302	false	false	false	true
64a14f74-03a0-4a03-ab5b-ecd09ce10a74	2026-10-02 10:45	2026-10-02 10:45	2026-10-02 10:45	SPXW	SPXW261002C07755000	call	7755.0000	2026-10-02	8.5100	8.5000	8.6000	7725.0000	15310.00	860.00	14450.00	18	5	36770	3267	11.2549739822467	0.148291208361878	0.146942402091808	false	false	false	true
648db9c1-3001-41ba-9288-ddff4dfca983	2026-10-02 10:45	2026-10-02 10:45	2026-10-02 10:45	SPXW	SPXW261002P07750000	put	7750.0000	2026-10-02	13.4900	13.4000	13.6000	7725.0000	20230.00	17550.00	2680.00	15	8	16280	2330	6.98712446351931	0.173658133956991	0.173658133956991	false	false	false	true
9f575637-d273-41ac-b25c-82a6eda790cc	2026-10-02 10:45	2026-10-02 10:44	2026-10-02 10:44	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	11.8400	11.8000	12.0000	7730.0000	20130.00	0.00	14180.00	17	7	47030	9660	4.86853002070393	0.156089247070689	0.15476816922309	false	false	false	true
320c694f-789c-4091-a6fd-98502a3ba931	2026-10-02 10:45	2026-10-02 10:44	2026-10-02 10:44	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	9.9800	9.9000	10.1000	7730.0000	16960.00	0.00	16960.00	17	9	22085	805	27.4347826086957	0.16404058986003	0.16404058986003	false	false	false	true
0af8a0b6-bacb-4ed5-988a-dd2c8790a0e5	2026-10-02 10:44	2026-10-02 10:44	2026-10-02 10:44	SPXW	SPXW261002P07750000	put	7750.0000	2026-10-02	13.4500	13.4000	13.6000	7725.0000	17490.00	0.00	17490.00	13	8	16112	2330	6.91502145922747	0.166598740228023	0.165276153870933	false	false	false	true
84a4e17c-0801-4897-86b2-615ef8ad091c	2026-10-02 10:44	2026-10-02 10:44	2026-10-02 10:44	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	8.5700	8.5000	8.7000	7725.0000	21420.00	0.00	8520.00	25	5	24513	627	39.0956937799043	0.168621110288058	0.168621110288058	false	false	false	true
f599f97d-8371-4d18-a212-bbc40de30069	2026-10-02 10:44	2026-10-02 10:44	2026-10-02 10:44	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	11.7000	11.6000	11.9000	7730.0000	534740.00	0.00	522970.00	457	90	46828	9660	4.84761904761905	0.154991729049971	0.153672123640434	false	false	false	true
5d33b8db-8337-4308-89cc-82773359e94f	2026-10-02 10:44	2026-10-02 10:44	2026-10-02 10:44	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	11.3300	11.3000	11.5000	7725.0000	37400.00	0.00	37400.00	33	10	46336	9660	4.79668737060041	0.153742443231995	0.152422973608539	false	false	false	true
423b6b48-e701-4f7c-8b66-58d52bb078b2	2026-10-02 10:44	2026-10-02 10:44	2026-10-02 10:44	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	10.4400	10.3000	10.5000	7725.0000	13570.00	5250.00	1040.00	13	7	21754	805	27.0236024844721	0.165258682874267	0.163926659567656	false	false	false	true
3c329965-975e-477b-b9a0-351beef189eb	2026-10-02 10:43	2026-10-02 10:43	2026-10-02 10:43	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	8.9900	8.9000	9.1000	7725.0000	13480.00	0.00	13480.00	15	6	24250	627	38.6762360446571	0.170696495992843	0.169326935469143	false	false	false	true
c8d85ba7-c995-4830-88f4-13c8ace112bc	2026-10-02 10:43	2026-10-02 10:43	2026-10-02 10:43	SPXW	SPXW261002P07750000	put	7750.0000	2026-10-02	13.2300	13.2000	13.4000	7725.0000	14550.00	1330.00	11890.00	11	6	15686	2330	6.73218884120172	0.167167457721972	0.167167457721972	false	false	false	true
025b98bd-b07f-491b-816f-2d3c2a610e84	2026-10-02 10:43	2026-10-02 10:43	2026-10-02 10:43	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	10.9000	10.9000	11.0000	7725.0000	26170.00	1100.00	25070.00	24	13	21576	805	26.8024844720497	0.16754774302843	0.166220605198386	false	false	false	true
02255a6d-4fe4-46a7-b987-cc082eedcc68	2026-10-02 10:43	2026-10-02 10:43	2026-10-02 10:43	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	10.2900	10.2000	10.5000	7730.0000	152300.00	0.00	145020.00	148	35	21432	805	26.623602484472	0.170335507125756	0.167662160293288	false	false	false	true
cf8e529c-4401-4006-98e8-536284a15628	2026-10-02 10:43	2026-10-02 10:43	2026-10-02 10:43	SPXW	SPXW261002P07750000	put	7750.0000	2026-10-02	11.8300	11.8000	12.0000	7730.0000	27210.00	2400.00	21240.00	23	7	15316	2330	6.57339055793991	0.168950583088001	0.166312614450287	false	false	false	true
1cd903e7-93e2-4d73-87b0-c33519f784c8	2026-10-02 10:43	2026-10-02 10:43	2026-10-02 10:43	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	12.5700	12.5000	12.7000	7730.0000	16340.00	1260.00	11300.00	13	8	45913	9660	4.75289855072464	0.150372677406603	0.150245163507375	false	false	false	true
ae737673-4740-4470-86d5-c3d09d3bdbff	2026-10-02 10:43	2026-10-02 10:43	2026-10-02 10:43	SPXW	SPXW261002C07760000	call	7760.0000	2026-10-02	7.9500	7.8000	8.0000	7730.0000	17500.00	9600.00	4740.00	22	11	35196	2912	12.0865384615385	0.149956531868556	0.148592816500536	false	false	false	true
4aa09c32-ce9f-416a-a591-66699ab2c129	2026-10-02 10:42	2026-10-02 10:42	2026-10-02 10:42	SPXW	SPXW261002C07765000	call	7765.0000	2026-10-02	7.0000	7.0000	7.1000	7735.0000	69330.00	2130.00	67200.00	99	8	39715	2162	18.3695652173913	0.151344080402776	0.149942838717608	false	false	false	true
e8c00916-7917-4aad-ab01-84094b892ae0	2026-10-02 10:42	2026-10-02 10:42	2026-10-02 10:42	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	14.4800	14.3000	14.6000	7735.0000	24610.00	17390.00	1430.00	17	9	45486	9660	4.70869565217391	0.158367032578945	0.155704059789309	false	false	false	true
c2648f9e-667c-48d6-8274-b7b573c61246	2026-10-02 10:42	2026-10-02 10:42	2026-10-02 10:42	SPXW	SPXW261002C07755000	call	7755.0000	2026-10-02	11.3200	11.2000	11.4000	7735.0000	28300.00	5700.00	21470.00	25	10	35405	3267	10.8371594735231	0.152272604853073	0.150957425780117	false	false	false	true
f9598cb9-4904-40b1-902b-3253e5a59523	2026-10-02 10:42	2026-10-02 10:42	2026-10-02 10:42	SPXW	SPXW261002C07755000	call	7755.0000	2026-10-02	10.6600	10.6000	10.8000	7730.0000	10660.00	2140.00	7450.00	10	7	35159	3267	10.7618610345883	0.151178539412496	0.15118256516195	false	false	false	true
f69fb766-8b12-4d8d-8632-c96aa8ee1f03	2026-10-02 10:42	2026-10-02 10:42	2026-10-02 10:42	SPXW	SPXW261002C07755000	call	7755.0000	2026-10-02	11.0200	10.4000	11.2000	7730.0000	20940.00	2170.00	17660.00	19	8	35126	3267	10.7517600244873	0.158011645488989	0.149857940841554	false	false	false	true
807ed418-5eba-4abf-b6e6-285b43796afa	2026-10-02 10:40	2026-10-02 10:39	2026-10-02 10:39	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	10.8700	10.8000	11.0000	7748.8500	10870.00	0.00	8690.00	10	6	43620	9660	4.51552795031056	0.149065393417441	0.147753921502788	false	false	false	true
08235591-44da-4c60-89ad-aee6488dbdcd	2026-10-02 10:39	2026-10-02 10:39	2026-10-02 10:39	SPXW	SPXW261002C07770000	call	7770.0000	2026-10-02	4.0600	3.9000	4.1000	7749.1200	40560.00	22960.00	13600.00	100	13	31072	4210	7.38052256532066	0.152139158232588	0.150456283057321	false	false	false	true
f34afd4c-f1de-421a-b42b-314cb3f508ac	2026-10-02 10:38	2026-10-02 10:38	2026-10-02 10:38	SPXW	SPXW261002P07710000	put	7710.0000	2026-10-02	2.5900	2.5500	2.6500	7749.4900	29515.00	3640.00	25355.00	114	34	15268	626	24.3897763578275	0.191758954336012	0.191758954336012	true	false	false	true
608d90d5-df24-4cf7-b09f-da9a4a7f1e6c	2026-10-02 10:38	2026-10-02 10:38	2026-10-02 10:38	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	10.4100	10.4000	10.6000	7749.2100	21870.00	0.00	18720.00	21	5	19727	805	24.5055900621118	0.164600506241534	0.1632790201556	false	false	false	true
17bb59f6-e3d0-433b-8677-53aa4280d4a1	2026-10-02 10:38	2026-10-02 10:38	2026-10-02 10:38	SPXW	SPXW261002P07730000	put	7730.0000	2026-10-02	5.9200	5.9000	6.1000	7749.1000	118400.00	0.00	117800.00	200	33	22408	487	46.0123203285421	0.176958920866829	0.176958920866829	false	false	false	true
3d4e71dc-8c93-426e-bf7e-34e4845e8892	2026-10-02 10:38	2026-10-02 10:37	2026-10-02 10:37	SPXW	SPXW261002C07740000	call	7740.0000	2026-10-02	16.6200	16.5000	16.7000	7748.6900	21610.00	5010.00	14940.00	13	7	23553	3290	7.15896656534954	0.153335830750136	0.151970703029264	false	false	false	true
52ced35f-7159-4499-94da-0d8033bd9272	2026-10-02 10:37	2026-10-02 10:37	2026-10-02 10:37	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	11.1100	11.1000	11.3000	7749.0400	15560.00	0.00	13320.00	14	5	42903	9660	4.44130434782609	0.151262199107333	0.149955443839954	false	false	false	true
ad81cf51-0d05-4435-a150-58cb9e3ef479	2026-10-02 10:35	2026-10-02 10:35	2026-10-02 10:35	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	11.7900	11.8000	12.0000	7747.3200	23590.00	0.00	23590.00	20	6	18965	805	23.5590062111801	0.170913289229787	0.169606620898973	false	false	false	true
fc87a2c3-bccd-455c-b9f2-0777cf121455	2026-10-02 10:35	2026-10-02 10:35	2026-10-02 10:35	SPXW	SPXW261002P07700000	put	7700.0000	2026-10-02	2.0000	2.0000	2.1000	7747.9400	60270.00	0.00	60270.00	301	41	43778	4177	10.4807277950682	0.203562830670371	0.202159754994538	false	false	false	true
125d1ca0-3422-4d6c-b6b3-4488322dfce4	2026-10-02 10:35	2026-10-02 10:35	2026-10-02 10:35	SPXW	SPXW261002C07745000	call	7745.0000	2026-10-02	14.0100	14.0000	14.2000	7748.1300	15410.00	0.00	14000.00	11	5	24790	1571	15.7797581158498	0.161090429557306	0.159780267346338	false	false	false	true
d4077f90-b319-4737-af4e-752d023fdb70	2026-10-02 10:35	2026-10-02 10:35	2026-10-02 10:35	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	11.2200	11.2000	11.4000	7747.1600	23570.00	1140.00	22430.00	21	8	41759	9660	4.32287784679089	0.163767079306063	0.165073585219479	false	false	false	true
c7b7b12f-80a6-4011-8952-816ac7a3ec91	2026-10-02 10:35	2026-10-02 10:35	2026-10-02 10:35	SPXW	SPXW261002C07750000	call	7750.0000	2026-10-02	10.4500	10.4000	10.6000	7746.7400	24040.00	0.00	19840.00	23	11	41580	9660	4.30434782608696	0.15581670304854	0.154508148719954	false	false	false	true
8e8fcd9a-e9f4-4623-9615-414a03c781f1	2026-10-02 10:35	2026-10-02 10:35	2026-10-02 10:35	SPXW	SPXW261002C07745000	call	7745.0000	2026-10-02	13.0600	12.9000	13.1000	7746.7400	20900.00	14410.00	5190.00	16	7	24576	1571	15.6435391470401	0.157662683467494	0.15505309086119	false	false	false	true
df67e051-c998-4fc5-9ac9-156a2c56f0e6	2026-10-02 10:35	2026-10-02 10:35	2026-10-02 10:35	SPXW	SPXW261002C07745000	call	7745.0000	2026-10-02	13.2100	13.2000	13.3000	7746.4600	11890.00	1330.00	10560.00	9	5	24349	1571	15.4990451941439	0.161828432863352	0.160797372525145	false	false	false	true
8759380e-c117-492e-92c4-e298d6a560f9	2026-10-02 10:35	2026-10-02 10:34	2026-10-02 10:34	SPXW	SPXW261002P07735000	put	7735.0000	2026-10-02	8.5700	8.5000	8.6000	7746.2800	11140.00	7740.00	3400.00	13	6	16761	711	23.5738396624473	0.176746366435142	0.175367287272191	false	false	false	true
da89948b-ff0e-4fbc-9735-ffa6a91663cd	2026-10-02 10:34	2026-10-02 10:34	2026-10-02 10:34	SPXW	SPXW261002P07750000	put	7750.0000	2026-10-02	16.0100	15.9000	16.2000	7743.7900	11210.00	0.00	9610.00	7	6	13037	2330	5.59527896995708	0.168020956220996	0.166016230348561	false	false	false	true
7f3f3220-1b11-452e-ad37-b72620eeb93b	2026-10-02 10:34	2026-10-02 10:34	2026-10-02 10:34	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	13.4700	13.3000	13.6000	7743.7900	25600.00	0.00	20240.00	19	7	18543	805	23.0347826086957	0.168911559269479	0.167610203139986	false	false	false	true
948532a1-e476-442f-8b16-e9be2ef9dc4b	2026-10-02 10:34	2026-10-02 10:34	2026-10-02 10:34	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	13.9600	13.9000	14.1000	7744.2200	25130.00	7000.00	9730.00	18	6	18414	805	22.8745341614907	0.178132723874286	0.176832816155886	false	false	false	true
0c719640-cc5e-4d52-9b22-4c790a9ace77	2026-10-02 10:34	2026-10-02 10:33	2026-10-02 10:33	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	11.4800	11.3000	11.5000	7743.4700	12630.00	10350.00	1140.00	11	6	21320	627	34.0031897926635	0.172274461057889	0.172278804743904	false	false	false	true
3ca154be-da6d-472c-958f-86bd19e65ff3	2026-10-02 10:33	2026-10-02 10:33	2026-10-02 10:33	SPXW	SPXW261002P07735000	put	7735.0000	2026-10-02	9.4900	9.4000	9.7000	7744.0900	189780.00	0.00	154630.00	200	41	16424	711	23.0998593530239	0.177310119648461	0.175961267162382	false	false	false	true
39aac027-da23-4b0b-b1b3-2ced6ae873da	2026-10-02 10:33	2026-10-02 10:33	2026-10-02 10:33	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	13.9500	13.9000	14.1000	7743.4100	33490.00	1410.00	32080.00	24	10	18217	805	22.6298136645963	0.172608959549554	0.171309121990678	false	false	false	true
d2d41894-52d0-4059-8588-c043dc1a1a05	2026-10-02 10:33	2026-10-02 10:33	2026-10-02 10:33	SPXW	SPXW261002C07770000	call	7770.0000	2026-10-02	3.4700	3.4000	3.6000	7743.1600	34670.00	0.00	34670.00	100	18	29408	4210	6.98527315914489	0.162051545596866	0.161228092946066	false	false	false	true
a9896f74-b53f-4ba7-8ada-b4462334c79b	2026-10-02 10:33	2026-10-02 10:33	2026-10-02 10:33	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	14.5800	14.5000	14.7000	7743.4100	18960.00	7300.00	4360.00	13	5	18068	805	22.4447204968944	0.180357746105512	0.180357746105512	false	false	false	true
5f3a8750-487b-4b8f-8134-98461f9313d4	2026-10-02 10:33	2026-10-02 10:33	2026-10-02 10:33	SPXW	SPXW261002P07740000	put	7740.0000	2026-10-02	12.1500	12.1000	12.3000	7742.9600	26740.00	2440.00	12100.00	22	5	20982	627	33.4641148325359	0.178174200392817	0.176870031624699	false	false	false	true
9e0c7de7-d1d2-4433-afea-4d9dc4efa193	2026-10-02 10:33	2026-10-02 10:33	2026-10-02 10:33	SPXW	SPXW261002P07745000	put	7745.0000	2026-10-02	14.5100	14.4000	14.6000	7743.4200	23210.00	1460.00	20300.00	16	6	17918	805	22.2583850931677	0.180370264525046	0.179071303367904	false	false	false	true