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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 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

29627910-1882-48be-9593-976ecc5d10c3	2026-09-03 12:37	2026-09-03 12:37	2026-09-03 12:37	SPXW	SPXW260918C07850000	call	7850.0000	2026-09-18	27.9000	28.3000	28.6000	7742.2300	5580000.00	0.00	0.00	2000	11	4404	3568	1.23430493273543	0.102830964243845	0.102830964243845	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
3755eacf-a9a5-4da7-849a-42cdb740f8e2	2026-09-03 12:39	2026-09-03 12:39	2026-09-03 12:39	SPXW	SPXW260903P07735000	put	7735.0000	2026-09-03	3.2900	3.1000	3.5000	7746.1800	166010.00	1650.00	160640.00	505	66	26567	136	195.345588235294	0.128840929525328	0.126935761898457	false	false	false	true	false
5951adbf-34e0-42a6-bae0-b4bd4ca340f2	2026-09-03 12:41	2026-09-03 12:41	2026-09-03 12:41	SPXW	SPXW260904C07750000	call	7750.0000	2026-09-04	17.1000	20.3000	20.5000	7747.3400	1026000.00	0.00	0.00	600	10	8780	5368	1.63561847988077	0.11133454463036	0.11133454463036	false	false	false	true	false
564495dd-6643-4873-aee1-a2066094eec4	2026-09-03 12:41	2026-09-03 12:41	2026-09-03 12:41	SPXW	SPXW260910C07875000	call	7875.0000	2026-09-10	2.8000	3.3000	3.4000	7747.3400	672000.00	0.00	0.00	2400	10	2507	636	3.94182389937107	0.0780473610669013	0.0780473610669013	false	false	false	true	false
80a21bcc-4115-43e8-8c92-4f07e61d9df0	2026-09-03 12:41	2026-09-03 12:41	2026-09-03 12:41	SPXW	SPXW260904P07690000	put	7690.0000	2026-09-04	5.1300	4.9000	5.5000	7747.2100	252980.00	118500.00	134480.00	493	40	2989	509	5.87229862475442	0.148288608665596	0.145285035058597	false	false	false	true	false
01ab32d3-f8f8-41b9-93de-738fcbddebfb	2026-09-03 12:41	2026-09-03 12:41	2026-09-03 12:41	SPXW	SPXW260903C07750000	call	7750.0000	2026-09-03	5.8800	5.7000	6.0000	7747.2600	119950.00	119950.00	0.00	204	32	95239	3813	24.9774455809074	0.117158415155591	0.118841726003784	false	false	false	true	false
e627c721-24e3-4e16-b2c8-87d0fdae5041	2026-09-03 12:42	2026-09-03 12:41	2026-09-03 12:41	SPXW	SPXW260903P07735000	put	7735.0000	2026-09-03	3.0000	2.9500	3.2000	7748.3800	123130.00	3100.00	119720.00	410	52	28161	136	207.066176470588	0.135539250615244	0.133454809809874	false	false	false	true	false
431ef365-ca55-4665-b0bf-13a062ad8291	2026-09-03 12:47	2026-09-03 12:47	2026-09-03 12:47	SPXW	SPXW260903P07745000	put	7745.0000	2026-09-03	5.9000	5.9000	6.0000	7748.1500	114460.00	0.00	114460.00	194	23	29581	167	177.131736526946	0.125374503749138	0.125374503749138	false	false	false	true	false
f3c5b0b0-78ed-4cd0-886d-cc9e58927960	2026-09-03 12:47	2026-09-03 12:47	2026-09-03 12:47	SPXW	SPXW260911C07785000	call	7785.0000	2026-09-11	32.0000	31.8000	32.1000	7748.3300	160000.00	80000.00	80000.00	50	8	129	194	0.664948453608247	0.0992846271763385	0.0992846271763385	false	false	false	true	false
46c0da73-71a4-41bc-a3ab-bd0444878be1	2026-09-03 12:49	2026-09-03 12:49	2026-09-03 12:49	SPXW	SPXW260903P07755000	put	7755.0000	2026-09-03	11.4000	11.3000	11.5000	7747.7300	111720.00	0.00	110580.00	98	28	4727	92	51.3804347826087	0.123232944220261	0.123232944220261	false	false	false	true	false
63bcc4b7-7a4b-43e0-8d2c-824fd04c810c	2026-09-03 13:07	2026-09-03 13:07	2026-09-03 13:07	SPXW	SPXW260904P07740000	put	7740.0000	2026-09-04	18.1000	18.0000	18.1000	7742.9600	269690.00	269690.00	0.00	149	8	2590	661	3.91830559757943	0.123258878456524	0.123258878456524	false	false	false	true	false
d2af5280-e05f-4757-ad05-acd4f59bf089	2026-09-03 13:09	2026-09-03 13:09	2026-09-03 13:09	SPXW	SPXW260903P07740000	put	7740.0000	2026-09-03	5.3200	5.2000	5.4000	7741.1400	106470.00	99050.00	0.00	200	45	43910	311	141.189710610932	0.106004507159523	0.106004507159523	true	false	false	true	false
42852dad-3ff3-4302-93f2-63c859437137	2026-09-03 13:12	2026-09-03 13:12	2026-09-03 13:12	SPXW	SPXW260908P07750000	put	7750.0000	2026-09-08	31.6000	31.5000	31.6000	7740.0500	158000.00	158000.00	0.00	50	7	1379	482	2.86099585062241	0.0789197188751069	0.0789197188751069	false	false	false	true	false
853a49ab-480a-4a52-814a-a38ec7718a9c	2026-09-03 13:15	2026-09-03 13:15	2026-09-03 13:15	SPXW	SPXW260903C07720000	call	7720.0000	2026-09-03	23.2000	23.1000	23.4000	7741.5400	116000.00	64960.00	9280.00	50	9	85164	5150	16.5366990291262	0.150983791002469	0.150983791002469	false	false	false	true	false
fd74a82e-ae82-4843-8cb9-e1959607ac15	2026-09-03 13:20	2026-09-03 13:20	2026-09-03 13:20	SPXW	SPXW260903P07740000	put	7740.0000	2026-09-03	5.9000	5.8000	5.9000	7739.5200	118000.00	118000.00	0.00	200	12	49314	311	158.565916398714	0.105860704504079	0.105860704504079	false	false	false	true	false
ddce0ba5-8de8-40fd-8554-8bdf7ea6bc36	2026-09-03 13:20	2026-09-03 13:20	2026-09-03 13:20	SPXW	SPXW260903C07715000	call	7715.0000	2026-09-03	25.2000	25.1000	25.4000	7738.6800	128520.00	80640.00	47880.00	51	13	57701	2994	19.2722110888444	0.158695275750909	0.158695275750909	false	false	false	true	false
155f8c79-33a8-4a33-ba27-73d534758018	2026-09-03 13:21	2026-09-03 13:21	2026-09-03 13:21	SPXW	SPXW260908C07800000	call	7800.0000	2026-09-08	6.2200	6.0000	6.5000	7738.8700	155580.00	0.00	155580.00	250	30	4144	3685	1.12455902306649	0.0694848468744558	0.0690690061146968	false	false	false	true	false
9d882449-e9e5-448a-934b-8708448ac540	2026-09-03 13:22	2026-09-03 13:22	2026-09-03 13:22	SPXW	SPXW260903P07740000	put	7740.0000	2026-09-03	6.6200	6.5000	6.8000	7738.2400	132300.00	0.00	131630.00	200	53	51271	311	164.858520900322	0.108871802081047	0.106990503749749	true	false	false	true	false
4b5d9342-69e0-41d0-9fba-e20b8df9c64b	2026-09-03 13:27	2026-09-03 13:27	2026-09-03 13:27	SPXW	SPXW260903P07735000	put	7735.0000	2026-09-03	3.0000	2.9500	3.2000	7741.3100	120180.00	0.00	120180.00	400	45	43619	136	320.727941176471	0.109086376425306	0.106984380872007	false	false	false	true	false
487dc2e0-c82c-4756-9260-916c45a8e164	2026-09-03 13:27	2026-09-03 13:27	2026-09-03 13:27	SPXW	SPXW260903C07730000	call	7730.0000	2026-09-03	14.0000	13.8000	14.0000	7741.3100	209990.00	209990.00	0.00	150	10	73592	2283	32.2347787998248	0.127785060965322	0.130164868829976	false	false	false	true	false
46e3a862-33f6-4df3-a51a-0d31d05372b1	2026-09-03 13:32	2026-09-03 13:32	2026-09-03 13:32	SPXW	SPXW260909P07745000	put	7745.0000	2026-09-09	31.8000	31.6000	31.8000	7744.8300	101760.00	101760.00	0.00	32	6	134	36	3.72222222222222	0.0860312109313501	0.0860312109313501	false	false	false	true	false
2d8486a3-b0fd-4486-8c2f-12fc7ecc5db6	2026-09-03 13:32	2026-09-03 13:32	2026-09-03 13:32	SPXW	SPXW260903P07760000	put	7760.0000	2026-09-03	16.0000	15.9000	16.1000	7744.8800	105600.00	100800.00	1600.00	66	13	4283	194	22.0773195876289	0.106060710011387	0.106060710011387	false	false	false	true	false
6b45cec9-acf8-4ede-8392-9d3438f36530	2026-09-03 13:34	2026-09-03 13:34	2026-09-03 13:34	SPXW	SPXW260903P07740000	put	7740.0000	2026-09-03	3.0300	2.8000	3.2000	7745.1400	151365.00	9570.00	141485.00	500	73	58548	311	188.257234726688	0.105507143342558	0.0990405654524857	false	false	false	true	false
2384cff3-e3c4-4af4-8bd1-1ce0dfd74a5f	2026-09-03 13:38	2026-09-03 13:38	2026-09-03 13:38	SPXW	SPXW260903P07750000	put	7750.0000	2026-09-03	7.3000	7.2000	7.5000	7745.7300	109500.00	83220.00	18250.00	150	12	24940	873	28.5681557846506	0.0970750321818933	0.0970750321818933	false	false	false	true	false
95d249be-67ed-4436-9ede-f6cd03350be8	2026-09-03 13:49	2026-09-03 13:49	2026-09-03 13:49	SPXW	SPXW260903P07735000	put	7735.0000	2026-09-03	1.8800	1.7500	2.0000	7746.0000	198840.00	69500.00	95910.00	1056	99	56885	136	418.272058823529	0.11719089597754	0.122658003294971	false	false	false	true	false
857df079-58a0-4a69-95ae-1646a09c037e	2026-09-03 13:53	2026-09-03 13:52	2026-09-03 13:52	SPXW	SPXW260909P07745000	put	7745.0000	2026-09-09	29.4000	29.3000	29.6000	7750.3900	293980.00	246960.00	47020.00	100	7	276	36	7.66666666666667	0.086477084309973	0.086477084309973	true	false	false	true	false
1115367c-5217-44ef-9876-09a520cc4b8a	2026-09-03 13:53	2026-09-03 13:53	2026-09-03 13:53	SPXW	SPXW260909P07755000	put	7755.0000	2026-09-09	33.6000	33.4000	33.7000	7750.6200	336000.00	137760.00	198240.00	100	9	113	13	8.69230769230769	0.0853077975472213	0.0853077975472213	false	false	false	true	false
ad412491-133f-4a1e-b04e-23f8886d92ce	2026-09-03 13:55	2026-09-03 13:55	2026-09-03 13:55	SPXW	SPXW260904C07750000	call	7750.0000	2026-09-04	21.2000	21.0000	21.3000	7750.7300	105990.00	82670.00	23320.00	50	14	11925	5368	2.22149776453055	0.125590810420022	0.126209018385363	false	false	false	true	false
cee39907-aa79-4b08-805a-bdc9d7920049	2026-09-03 13:57	2026-09-03 13:57	2026-09-03 13:57	SPXW	SPXW260909P07755000	put	7755.0000	2026-09-09	34.4000	34.2000	34.5000	7749.7900	172000.00	172000.00	0.00	50	9	313	13	24.0769230769231	0.0862838362298375	0.0862838362298375	false	false	false	true	false
e9d3579e-26d3-45b1-b145-ed2585c5af18	2026-09-03 13:59	2026-09-03 13:59	2026-09-03 13:59	SPXW	SPXW260911P07400000	put	7400.0000	2026-09-11	2.1500	2.0500	2.1500	7748.6100	586305.00	586305.00	0.00	2727	7	3442	1928	1.78526970954357	0.167758175215638	0.167758175215638	false	false	false	true	false
3d8439ad-21a0-4bb0-9334-425b1c3689a0	2026-09-03 14:00	2026-09-03 14:00	2026-09-03 14:00	SPXW	SPXW260911P07770000	put	7770.0000	2026-09-11	53.0500	52.9000	53.3000	7748.6900	159140.00	0.00	159140.00	30	7	108	210	0.514285714285714	0.0988323661666985	0.0983919779751353	false	false	false	true	false
9ae2783b-f4da-4520-8e1f-f61c8b200959	2026-09-03 14:00	2026-09-03 14:00	2026-09-03 14:00	SPXW	SPXW260903C07755000	call	7755.0000	2026-09-03	4.9400	4.8000	5.1000	7753.5200	107110.00	39420.00	60240.00	217	99	99213	894	110.976510067114	0.126062582427881	0.11977446716373	false	false	false	true	false
3036a23b-3e7f-45da-8b9c-14351c1796ff	2026-09-03 14:01	2026-09-03 14:00	2026-09-03 14:00	SPXW	SPXW260903P07745000	put	7745.0000	2026-09-03	2.2200	2.1000	2.4000	7753.6700	116835.00	1135.00	114315.00	527	69	60987	167	365.191616766467	0.122100718789707	0.119496019043705	false	false	false	true	false
02293021-f4c6-4f4b-800d-c51ac4ef3b4b	2026-09-03 14:02	2026-09-03 14:02	2026-09-03 14:02	SPXW	SPXW260909P07750000	put	7750.0000	2026-09-09	30.2000	29.9000	30.3000	7754.1500	302000.00	302000.00	0.00	100	8	283	710	0.398591549295775	0.087028107314792	0.087028107314792	false	false	false	true	false
a112a6e9-48ed-4d6d-bfa2-c0ccb7df84ca	2026-09-03 14:03	2026-09-03 14:03	2026-09-03 14:03	SPXW	SPXW260904P07695000	put	7695.0000	2026-09-04	3.9100	3.8000	4.1000	7754.5700	183540.00	110370.00	73170.00	470	31	3652	562	6.49822064056939	0.13836376826052	0.137248732525209	false	false	false	true	false
16eaf91c-7a20-4065-87b0-0a17760d57b8	2026-09-03 14:07	2026-09-03 14:07	2026-09-03 14:07	SPXW	SPXW260903C07750000	call	7750.0000	2026-09-03	7.9000	7.7000	8.0000	7754.5200	174580.00	68730.00	105850.00	221	31	154921	3813	40.6296879097823	0.117069588960733	0.117069588960733	false	false	false	true	false
d2e4db5f-713e-4b90-b9c6-1f948f6877c3	2026-09-03 14:09	2026-09-03 14:08	2026-09-03 14:08	SPXW	SPXW260909C07755000	call	7755.0000	2026-09-09	35.1000	34.9000	35.2000	7754.3200	175500.00	136890.00	38610.00	50	10	600	104	5.76923076923077	0.0831991119341668	0.0831991119341668	false	false	false	true	false
72929548-31d3-4717-b00a-323a1c2e6a5e	2026-09-03 14:10	2026-09-03 14:10	2026-09-03 14:10	SPXW	SPXW260909C07755000	call	7755.0000	2026-09-09	35.6000	35.5000	35.6000	7754.6600	174440.00	174440.00	0.00	49	6	650	104	6.25	0.0840128918710857	0.0840128918710857	false	false	false	true	false
14b1abab-8379-4c41-a8d7-39a951e8907b	2026-09-03 14:10	2026-09-03 14:10	2026-09-03 14:10	SPXW	SPXW260908P07755000	put	7755.0000	2026-09-08	27.2000	27.2000	27.3000	7754.3900	272000.00	0.00	272000.00	100	5	412	19	21.6842105263158	0.0797540101515772	0.0797540101515772	false	false	false	true	false
7a287dfd-0a95-4b9c-9b53-236cf205524e	2026-09-03 14:16	2026-09-03 14:16	2026-09-03 14:16	SPXW	SPXW260911P07740000	put	7740.0000	2026-09-11	37.9000	37.9000	38.0000	7756.3300	189500.00	0.00	189500.00	50	5	242	276	0.876811594202899	0.105858365045759	0.105858365045759	false	false	false	true	false
be8331d8-d4d1-483a-9726-4dcad0ae44f7	2026-09-03 14:17	2026-09-03 14:17	2026-09-03 14:17	SPXW	SPXW260903C07730000	call	7730.0000	2026-09-03	26.3000	26.2000	26.6000	7756.4100	331380.00	0.00	331380.00	126	12	76804	2283	33.6416995181778	0.103011618511249	0.125562067141449	false	false	false	true	false
0400f194-2f6b-45fb-9146-e473359b6b57	2026-09-03 14:18	2026-09-03 14:18	2026-09-03 14:18	SPXW	SPXW260911P07740000	put	7740.0000	2026-09-11	38.1000	38.0000	38.1000	7756.3500	190500.00	190500.00	0.00	50	6	294	276	1.06521739130435	0.106322124671189	0.106322124671189	false	false	false	true	false
521baa07-21b9-42f0-ad6d-b6420ef2ba46	2026-09-03 14:18	2026-09-03 14:18	2026-09-03 14:18	SPXW	SPXW260908C07760000	call	7760.0000	2026-09-08	27.0000	27.0000	27.1000	7755.7300	189000.00	0.00	189000.00	70	6	1026	693	1.48051948051948	0.074905298699569	0.074905298699569	false	false	false	true	false
0f0bc7e2-8c8f-44ba-a5cb-aba1b1825982	2026-09-03 14:18	2026-09-03 14:18	2026-09-03 14:18	SPXW	SPXW260903C07750000	call	7750.0000	2026-09-03	7.5000	7.4000	7.7000	7755.2400	135810.00	100500.00	35310.00	181	19	159397	3813	41.8035667453449	0.103683194719977	0.101075002280992	false	false	false	true	false
3149c22d-fb9c-4cf5-ad3a-7597e62ff07d	2026-09-03 14:19	2026-09-03 14:18	2026-09-03 14:18	SPXW	SPXW260918P07795000	put	7795.0000	2026-09-18	85.4200	83.8000	85.8000	7754.8700	307520.00	239120.00	68400.00	36	5	53	112	0.473214285714286	0.112370636348221	0.112209454491757	false	false	false	true	false
3c3af52d-fca2-454b-a78e-2872a1b30f28	2026-09-03 14:19	2026-09-03 14:19	2026-09-03 14:19	SPXW	SPXW260908P07755000	put	7755.0000	2026-09-08	27.8000	27.7000	27.8000	7753.5200	250200.00	250200.00	0.00	90	13	729	19	38.3684210526316	0.080387753303284	0.0802539618761586	false	false	false	true	false
0e3dd599-f8d2-415a-b78d-719f353a4e3b	2026-09-03 14:20	2026-09-03 14:19	2026-09-03 14:19	SPXW	SPXW260903C07750000	call	7750.0000	2026-09-03	6.5000	6.4000	6.7000	7753.4100	102090.00	99450.00	0.00	157	8	160474	3813	42.0860215053763	0.106835215608927	0.109286341216273	false	false	false	true	false
0700e85b-d34f-4c31-8a49-23d258da5f94	2026-09-03 14:26	2026-09-03 14:26	2026-09-03 14:26	SPXW	SPXW260908C07695000	call	7695.0000	2026-09-08	72.0000	70.9000	72.0000	7754.6900	381600.00	381600.00	0.00	53	7	276	1642	0.168087697929354	0.0832275209432077	0.0832275209432077	false	false	false	true	false
b4afff75-7f51-44af-8a1c-414593af3fe7	2026-09-03 14:27	2026-09-03 14:27	2026-09-03 14:27	SPXW	SPXW260903P07755000	put	7755.0000	2026-09-03	5.1600	5.0000	5.3000	7753.1900	104330.00	78630.00	0.00	202	51	20772	92	225.782608695652	0.101613121184108	0.104088856091693	true	false	false	true	false
ee6f4cb9-8635-4d27-9f6c-5b474d0b95e5	2026-09-03 14:31	2026-09-03 14:31	2026-09-03 14:31	SPXW	SPXW260908P07755000	put	7755.0000	2026-09-08	27.8200	27.8000	28.1000	7752.5900	217030.00	0.00	217030.00	78	14	1132	19	59.5789473684211	0.079279231294413	0.0790028793071181	false	false	false	true	false