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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = SPX×

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

398daf7a-8595-463c-9a92-ead67ed01980	2026-09-21 11:28	2026-09-21 11:28	2026-09-21 11:28	SPX	SPX261218P07800000	put	7800.0000	2026-12-18	206.5000	206.5000	207.1000	7729.9500	10531500.00	0.00	0.00	510	11	2040	12316	0.165638194218902	0.138905245272158	0.138905245272158	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-21T15:32:21.239106Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
ae0d161c-963e-4356-8db6-adc85d407419	2026-09-21 11:27	2026-09-21 11:27	2026-09-21 11:27	SPX	SPX261016P07780000	put	7780.0000	2026-10-16	106.0000	106.0000	106.7000	7729.8800	572400.00	0.00	572400.00	54	5	159	166	0.957831325301205	0.11226002469369	0.11226002469369	false	false	false	true	false
523a6aca-1f7e-40a2-9436-5d7364bacaf2	2026-09-21 11:24	2026-09-21 11:24	2026-09-21 11:24	SPX	SPX261218P07795000	put	7795.0000	2026-12-18	204.0000	204.3000	205.0000	7730.0900	6630000.00	0.00	0.00	325	11	525	12	43.75	0.138953016734524	0.138953016734524	false	false	false	true	false
3c23bb29-d403-40d7-aa35-d8214b4d86c1	2026-09-21 11:24	2026-09-21 11:24	2026-09-21 11:24	SPX	SPX261218C07795000	call	7795.0000	2026-12-18	208.0000	207.0000	207.7000	7730.0900	6760000.00	0.00	0.00	325	10	633	212	2.98584905660377	0.133325097644274	0.133325097644274	false	false	false	true	false
38079c0b-60bb-48e0-a0ba-75646b53bb9c	2026-09-21 11:24	2026-09-21 11:24	2026-09-21 11:24	SPX	SPX261218C08100000	call	8100.0000	2026-12-18	76.2400	75.8000	76.5000	7730.0900	9530000.00	0.00	0.00	1250	11	1433	23363	0.0613363009887429	0.120791577507712	0.120791577507712	false	false	false	true	false
376e0ffd-56cf-4f7a-9d1f-fa5b59823849	2026-09-21 11:08	2026-09-21 11:08	2026-09-21 11:08	SPX	SPX270219C08300000	call	8300.0000	2027-02-19	93.6000	92.9000	93.6000	7725.3500	1357200.00	1357200.00	0.00	145	6	156	3537	0.0441051738761662	0.12402048343203	0.12402048343203	false	false	false	true	false
6060f4a1-aa83-49f9-86d2-214e869938ed	2026-09-21 11:01	2026-09-21 11:01	2026-09-21 11:01	SPX	SPX261218P05550000	put	5550.0000	2026-12-18	10.4000	10.4000	10.6000	7722.8400	28080.00	0.00	28080.00	27	5	42	1396	0.0300859598853868	0.352297044916635	0.352297044916635	false	false	false	true	false
9bd25839-90e1-4594-985c-6903fcaff1fc	2026-09-21 10:52	2026-09-21 10:52	2026-09-21 10:52	SPX	SPX261218P06000000	put	6000.0000	2026-12-18	16.3000	16.2000	16.3000	7719.6900	329260.00	329260.00	0.00	202	6	966	154443	0.00625473475651211	0.304683659369667	0.304683659369667	false	false	false	true	false
f24d0b4d-3bd5-457e-a126-f710345764d6	2026-09-21 10:44	2026-09-21 10:44	2026-09-21 10:44	SPX	SPX270319C08100000	call	8100.0000	2027-03-19	197.5700	197.1000	197.8000	7700.0000	1185400.00	1185400.00	0.00	60	11	125	8683	0.0143959461015778	0.1337148757074	0.1337148757074	false	false	false	true	false
0c772334-22e1-400d-a0fe-ecffa5e09c7a	2026-09-21 10:42	2026-09-21 10:42	2026-09-21 10:42	SPX	SPX270319C09300000	call	9300.0000	2027-03-19	7.7000	7.6000	8.1000	7722.2900	385000.00	129360.00	255640.00	500	8	500	2774	0.180245133381399	0.123167556465778	0.123167556465778	false	false	false	true	false
f0108dbc-f813-4444-a9fb-158cd28b0bb5	2026-09-21 10:31	2026-09-21 10:31	2026-09-21 10:31	SPX	SPX261218P07200000	put	7200.0000	2026-12-18	71.7000	71.4000	71.7000	7721.6400	78870.00	78870.00	0.00	11	5	1841	26199	0.0702698576281537	0.186545453176082	0.186545453176082	false	false	false	true	false
d19526e0-2d48-4de4-b7c4-db9b721db89d	2026-09-21 10:29	2026-09-21 10:29	2026-09-21 10:29	SPX	SPX261120P07700000	put	7700.0000	2026-11-20	138.3000	138.0000	138.5000	7720.5400	802130.00	193620.00	608510.00	58	8	217	12017	0.0180577515186819	0.138417592026259	0.138417592026259	false	false	false	true	false
8799c8e8-705c-4f11-b1b6-806e3a9b9ea9	2026-09-21 10:25	2026-09-21 10:25	2026-09-21 10:25	SPX	SPX261218C07770000	call	7770.0000	2026-12-18	213.0000	215.8000	216.6000	7720.7200	1107600.00	0.00	0.00	52	5	1459	161	9.06211180124224	0.1316894050759	0.131671643416192	false	false	false	true	false
fa3bce09-7af3-496f-8b4d-4f2455822fc2	2026-09-21 10:25	2026-09-21 10:25	2026-09-21 10:25	SPX	SPX270115P07700000	put	7700.0000	2027-01-15	196.1000	195.4000	196.1000	7720.6200	980500.00	980500.00	0.00	50	6	66	4032	0.0163690476190476	0.147012805385349	0.147012805385349	false	false	false	true	false
9ab083fd-53a9-43dc-b3d2-e4d0c08ce086	2026-09-21 10:23	2026-09-21 10:23	2026-09-21 10:23	SPX	SPX261218P06940000	put	6940.0000	2026-12-18	49.0000	48.5000	49.0000	7700.0000	73500.00	73500.00	0.00	15	5	17	135	0.125925925925926	0.210656368794839	0.210656368794839	false	false	false	true	false
7d0f1d54-9449-48c4-bacc-3db110a0aeb9	2026-09-21 10:22	2026-09-21 10:22	2026-09-21 10:22	SPX	SPX261120P06075000	put	6075.0000	2026-11-20	9.1000	9.1000	9.3000	7700.0000	14560.00	0.00	14560.00	16	8	129	1968	0.0655487804878049	0.316138761563944	0.316138761563944	false	false	false	true	false
71781aac-8871-4039-a065-03a9eb65f3f3	2026-09-21 10:21	2026-09-21 10:21	2026-09-21 10:21	SPX	SPX261016P07250000	put	7250.0000	2026-10-16	13.9000	13.7000	14.0000	7715.1100	63940.00	63940.00	0.00	46	5	149	8526	0.0174759558996012	0.18116223051599	0.18116223051599	false	false	false	true	false
f76615e5-76e3-43ec-b301-66f29718ceaa	2026-09-21 10:20	2026-09-21 10:19	2026-09-21 10:19	SPX	SPX261218C07775000	call	7775.0000	2026-12-18	209.0000	208.3000	209.0000	7714.9400	1254000.00	0.00	0.00	60	9	470	1973	0.238215914850481	0.132712307165525	0.132712307165525	false	false	false	true	false
2a4063dc-332d-4780-8d34-1e0ae4be5578	2026-09-21 10:20	2026-09-21 10:19	2026-09-21 10:19	SPX	SPX261218P07775000	put	7775.0000	2026-12-18	202.0000	201.7000	202.4000	7714.9400	1212000.00	0.00	0.00	60	9	470	1133	0.414827890556046	0.13944961422189	0.13944961422189	false	false	false	true	false
9fad0802-5359-4e57-b8d9-8cc51fa38987	2026-09-21 10:19	2026-09-21 10:19	2026-09-21 10:19	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	99.1200	101.2000	102.0000	7714.4200	1239000.00	0.00	0.00	125	7	209	280174	0.00074596500745965	0.120258108163585	0.120258108163585	false	false	false	true	false
9d646ae7-780b-4a4b-a667-b7a99886deb9	2026-09-21 10:19	2026-09-21 10:19	2026-09-21 10:19	SPX	SPX261218C07770000	call	7770.0000	2026-12-18	208.0000	211.3000	212.1000	7714.2800	332800.00	0.00	0.00	16	8	1407	161	8.73913043478261	0.130580495869658	0.130629751619312	false	false	false	true	false
6d1e3074-1dc7-4333-a869-49fd95d5ebf7	2026-09-21 10:19	2026-09-21 10:19	2026-09-21 10:19	SPX	SPX261218C08500000	call	8500.0000	2026-12-18	12.1900	12.4000	12.8000	7714.2800	487600.00	0.00	0.00	400	8	400	14441	0.0276989128176719	0.115096643463507	0.115115615697753	false	false	false	true	false
163dc2dc-5c55-43fe-a963-d21e4ba6fc06	2026-09-21 10:19	2026-09-21 10:19	2026-09-21 10:19	SPX	SPX261218P07770000	put	7770.0000	2026-12-18	202.0000	199.6000	200.3000	7714.4200	323200.00	0.00	0.00	16	7	1417	175	8.09714285714286	0.140926139471216	0.140926139471216	false	false	false	true	false
a5c08ca0-d484-4071-84f6-3aee3aeac8a0	2026-09-21 10:19	2026-09-21 10:19	2026-09-21 10:19	SPX	SPX261120P07100000	put	7100.0000	2026-11-20	37.6100	37.6000	38.1000	7714.5900	112840.00	0.00	112840.00	30	8	236	11112	0.0212383009359251	0.195507189616158	0.195507189616158	false	false	false	true	false
5be27b46-b493-4f0c-a7bd-dfef229b4c5b	2026-09-21 10:17	2026-09-21 10:16	2026-09-21 10:16	SPX	SPX270219P07500000	put	7500.0000	2027-02-19	175.1000	175.1000	175.4000	7713.3900	3677100.00	0.00	3677100.00	210	5	210	1950	0.107692307692308	0.164362409876796	0.164362409876796	false	false	false	true	false
116dbffc-7994-40b0-8a0b-d222240fe47e	2026-09-21 10:14	2026-09-21 10:14	2026-09-21 10:14	SPX	SPX261016P07515000	put	7515.0000	2026-10-16	35.7000	35.5000	35.8000	7709.5500	264180.00	264180.00	0.00	74	6	92	286	0.321678321678322	0.140893656679426	0.140893656679426	false	false	false	true	false
65c8a686-5800-4668-8cc4-8159a86a52c2	2026-09-21 10:12	2026-09-21 10:12	2026-09-21 10:12	SPX	SPX261120C08100000	call	8100.0000	2026-11-20	33.2000	33.2000	33.8000	7685.0000	66400.00	0.00	66400.00	20	9	37	11737	0.00315242395842208	0.112315554442846	0.112315554442846	false	false	false	true	false
3dadb191-4aaf-4264-9e54-378ab3171a50	2026-09-21 10:12	2026-09-21 10:12	2026-09-21 10:12	SPX	SPX261016P07000000	put	7000.0000	2026-10-16	7.8000	7.6000	7.8000	7685.0000	66300.00	66300.00	0.00	85	6	335	186348	0.00179771180801511	0.222035065827711	0.222035065827711	false	false	false	true	false
853e890c-0e24-47e2-b793-3ab906d640d1	2026-09-21 10:05	2026-09-21 10:05	2026-09-21 10:05	SPX	SPX270319P07225000	put	7225.0000	2027-03-19	148.8000	148.4000	149.2000	7703.9300	104160.00	89280.00	0.00	7	5	10	1387	0.00720980533525595	0.186084077704788	0.186084077704788	false	false	false	true	false
4cc0b6e5-e82e-48b4-9356-1eb980a3a901	2026-09-21 10:05	2026-09-21 10:05	2026-09-21 10:05	SPX	SPX261218P07610000	put	7610.0000	2026-12-18	149.9000	149.6000	150.3000	7705.0600	89940.00	74950.00	14990.00	6	6	8	1032	0.00775193798449612	0.150783545875729	0.150783545875729	false	false	false	true	false
4cf53751-4ac5-4242-809e-3b546b4e7c51	2026-09-18 16:33	2026-09-18 16:31	2026-09-18 16:31	SPX	SPX261016C07700000	call	7700.0000	2026-10-16	85.3000	84.7000	86.0000	7630.0000	127950.00	51180.00	76770.00	15	9	4147	18831	0.220221974403908	0.115488591363406	0.115488591363406	false	false	false	true	false
aeae3cc9-68e1-4a33-9664-b9a0eb0f799a	2026-09-18 16:18	2026-09-18 16:14	2026-09-18 16:14	SPX	SPX270917C07650000	call	7650.0000	2027-09-17	689.7000	687.8000	690.1000	7630.0000	2069100.00	2069100.00	0.00	30	6	491	5648	0.0869334277620397	0.170700170926851	0.170700170926851	false	false	false	true	false
98a4a063-998d-4583-bccd-5c4738ff675d	2026-09-18 16:18	2026-09-18 16:14	2026-09-18 16:14	SPX	SPX270917C07650000	call	7650.0000	2027-09-17	690.0000	687.8000	690.1000	7630.0000	1656000.00	1656000.00	0.00	24	5	515	5648	0.0911827195467422	0.170804561225994	0.170804561225994	false	false	false	true	false
a495ed1f-9d6c-419a-bd96-4b1ed131e4a5	2026-09-18 16:13	2026-09-18 16:13	2026-09-18 16:13	SPX	SPX261218P07000000	put	7000.0000	2026-12-18	61.6300	60.9000	61.5000	7630.0000	1540750.00	0.00	0.00	250	12	22946	293777	0.0781068633691542	0.20065964450946	0.20065964450946	false	false	false	true	false
76340eb5-6198-4e3b-bd40-7b564e5c40ef	2026-09-18 16:13	2026-09-18 16:13	2026-09-18 16:13	SPX	SPX261218P06300000	put	6300.0000	2026-12-18	25.8200	25.5000	25.9000	7630.0000	1291000.00	0.00	0.00	500	12	975	26892	0.036256135653726	0.269376005211711	0.269376005211711	false	false	false	true	false
2b13b093-3dd4-4407-8c8f-889fecadd4b2	2026-09-18 16:13	2026-09-18 16:13	2026-09-18 16:13	SPX	SPX270319P06500000	put	6500.0000	2027-03-19	75.1600	74.3000	75.1000	7630.0000	3758000.00	0.00	0.00	500	12	609	13061	0.0466273639078172	0.233216033363612	0.233216033363612	false	false	false	true	false
141d012e-dda4-40b4-819f-c4e2f366649d	2026-09-18 16:13	2026-09-18 16:13	2026-09-18 16:13	SPX	SPX270319P07000000	put	7000.0000	2027-03-19	124.5000	123.1000	124.0000	7630.0000	3423750.00	0.00	0.00	275	12	415	91225	0.00454919155933132	0.19894440285766	0.19894440285766	false	false	false	true	false
fb1ee4c7-9744-4ff7-8ef4-6a69d9fc518d	2026-09-18 16:12	2026-09-18 16:11	2026-09-18 16:11	SPX	SPX270319P07500000	put	7500.0000	2027-03-19	217.2800	214.7000	215.9000	7630.0000	21728000.00	0.00	0.00	1000	10	1512	12739	0.118690635057697	0.166836350705777	0.166836350705777	false	false	false	true	false
810a3a3d-38c4-446b-8a50-6a3a6064a96f	2026-09-18 16:12	2026-09-18 16:11	2026-09-18 16:11	SPX	SPX261218C07720000	call	7720.0000	2026-12-18	208.2000	211.0000	212.7000	7630.0000	15406800.00	0.00	0.00	740	10	970	697	1.39167862266858	0.132938778383748	0.132938778383748	false	false	false	true	false
2fa62135-13fe-4ec7-a8f6-400a59f98dfa	2026-09-18 16:12	2026-09-18 16:11	2026-09-18 16:11	SPX	SPX270319C08000000	call	8000.0000	2027-03-19	211.4800	213.6000	215.0000	7630.0000	21148000.00	0.00	0.00	1000	10	1160	59272	0.0195707922796599	0.13354580885625	0.13354580885625	false	false	false	true	false
008e7585-ebf7-4b78-9866-fa0c6f55f988	2026-09-18 16:12	2026-09-18 16:11	2026-09-18 16:11	SPX	SPX261218P07720000	put	7720.0000	2026-12-18	206.2000	202.5000	203.8000	7630.0000	15258800.00	0.00	0.00	740	10	969	702	1.38034188034188	0.139174149580218	0.139174149580218	false	false	false	true	false
0051d614-09cc-4334-90c2-0e33eb8bddb4	2026-09-18 16:02	2026-09-18 16:02	2026-09-18 16:02	SPX	SPX261016C07625000	call	7625.0000	2026-10-16	129.8000	128.6000	129.8000	7630.0000	246620.00	246620.00	0.00	19	6	302	2198	0.137397634212921	0.123239897725793	0.123239897725793	true	false	false	true	false
0d943e34-f125-4b1c-8f88-bb6f196ac394	2026-09-18 16:02	2026-09-18 16:01	2026-09-18 16:01	SPX	SPX261016C07640000	call	7640.0000	2026-10-16	113.2000	116.5000	117.8000	7630.0000	3611080.00	0.00	3611080.00	319	8	452	469	0.963752665245203	0.113347274583802	0.113347274583802	false	true	false	true	false
e6dc6c74-09b6-4c93-b2ab-4e365d79533e	2026-09-18 16:00	2026-09-18 16:00	2026-09-18 16:00	SPX	SPX270115P06500000	put	6500.0000	2027-01-15	45.3600	45.0000	45.5000	7630.0000	2268000.00	0.00	0.00	500	6	772	11029	0.0699972798984495	0.241085577685812	0.241085577685812	false	false	false	true	false
c2176785-1978-4b22-b7fe-5a6d58180d04	2026-09-18 16:00	2026-09-18 16:00	2026-09-18 16:00	SPX	SPX261120P05900000	put	5900.0000	2026-11-20	9.2500	9.1000	9.4000	7630.0000	462500.00	0.00	0.00	500	6	2214	4093	0.540923527974591	0.331698936623168	0.331698936623168	false	false	false	true	false
a6d25cc9-d3f8-4639-801d-8940c94de778	2026-09-18 16:00	2026-09-18 16:00	2026-09-18 16:00	SPX	SPX261016P08500000	put	8500.0000	2026-10-16	830.1300	819.9000	838.0000	7630.0000	1660260.00	0.00	0.00	20	6	217	86	2.52325581395349	0.20268400522324	0.20268400522324	false	false	false	true	false
9a616f88-2fa7-489b-807f-51335ebd226d	2026-09-18 16:00	2026-09-18 16:00	2026-09-18 16:00	SPX	SPX261016P07400000	put	7400.0000	2026-10-16	34.0000	33.4000	34.0000	7630.0000	1088000.00	0.00	0.00	320	6	3789	19375	0.195561290322581	0.151935196680541	0.151935196680541	false	false	false	true	false
93d8848d-254b-494c-b47d-c75ef32ff412	2026-09-18 16:00	2026-09-18 16:00	2026-09-18 16:00	SPX	SPX270115P06600000	put	6600.0000	2027-01-15	50.6100	50.3000	50.8000	7630.0000	850248.00	0.00	0.00	168	6	171	3852	0.044392523364486	0.232289675049084	0.232289675049084	false	false	false	true	false
8f6d6478-ed96-430f-8640-68593752cb83	2026-09-18 16:00	2026-09-18 16:00	2026-09-18 16:00	SPX	SPX261016C07800000	call	7800.0000	2026-10-16	37.0900	37.5000	38.1000	7630.0000	815980.00	0.00	0.00	220	6	1730	24513	0.0705747970464651	0.100702242079445	0.100702242079445	false	false	false	true	false
81eafb73-5bfd-423f-a6fb-ae56d871f248	2026-09-18 16:00	2026-09-18 16:00	2026-09-18 16:00	SPX	SPX261016P06300000	put	6300.0000	2026-10-16	3.5000	3.4000	3.6000	7630.0000	175000.00	0.00	0.00	500	6	1628	7819	0.208210768640491	0.330183323634824	0.330183323634824	false	false	false	true	false