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 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts728,802 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×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

14977880-8efd-4b5b-af90-2dbef8f202e5	2026-10-01 12:51	2026-10-01 12:51	2026-10-01 12:51	SPX	SPX261218C07705000	call	7705.0000	2026-12-18	201.0000	199.0000	200.0000	7646.2300	1025100.00	0.00	0.00	51	10	1018	7523	0.135318357038416	0.139054066725651	0.139054066725651	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-10-01T16:54:14.233260Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
115122ec-3cac-4180-8540-2ccd9ba74497	2026-10-01 12:38	2026-10-01 12:38	2026-10-01 12:38	SPX	SPX261120C09400000	call	9400.0000	2026-11-20	0.1000	0.0500	0.2000	7647.5100	47000.00	0.00	47000.00	4700	14	4701	5098	0.922126324048646	0.169644467360721	0.169644467360721	false	true	false	true
189c72cb-2bdd-493d-8418-2b03981aebe0	2026-10-01 12:36	2026-10-01 12:36	2026-10-01 12:36	SPX	SPX261016P07500000	put	7500.0000	2026-10-16	34.0000	33.9000	34.4000	7651.4300	34000.00	0.00	34000.00	10	6	473	36375	0.0130034364261168	0.153689212273394	0.153689212273394	false	false	false	true
4477fa10-5143-4821-af40-f6cbb4e1fc62	2026-10-01 12:21	2026-10-01 12:21	2026-10-01 12:21	SPX	SPX270917C09400000	call	9400.0000	2027-09-17	47.9000	47.9000	48.5000	7620.0000	28740.00	0.00	28740.00	6	5	24	513	0.0467836257309941	0.128697794094395	0.128697794094395	true	false	false	true
e0df345d-e0ae-429b-87dc-6e9408b9a6b6	2026-10-01 12:02	2026-10-01 12:02	2026-10-01 12:02	SPX	SPX270917P08000000	put	8000.0000	2027-09-17	512.6200	509.0000	510.6000	7639.3600	20248490.00	0.00	0.00	395	7	396	17023	0.0232626446572285	0.168327356122238	0.168327356122238	false	false	false	true
c2e3a1dc-b57d-4745-8fd0-4c06c0dd3163	2026-10-01 12:02	2026-10-01 12:02	2026-10-01 12:02	SPX	SPX261016P07800000	put	7800.0000	2026-10-16	173.6000	168.3000	170.0000	7639.3600	659680.00	0.00	0.00	38	7	41	12964	0.00316260413452638	0.125993019148939	0.125993019148939	false	false	false	true
a7d62061-ef37-44f1-b0e5-475d717bb7dc	2026-10-01 12:02	2026-10-01 12:02	2026-10-01 12:02	SPX	SPX261218P07690000	put	7690.0000	2026-12-18	202.2000	198.6000	199.4000	7639.3600	1112100.00	0.00	0.00	55	7	1933	8048	0.240183896620278	0.150054037472852	0.150054037472852	false	false	false	true
8f709595-c415-406a-a89a-52bf66f5b80b	2026-10-01 12:02	2026-10-01 12:02	2026-10-01 12:02	SPX	SPX261218C07690000	call	7690.0000	2026-12-18	202.2000	204.1000	205.0000	7639.3600	1112100.00	0.00	0.00	55	7	1933	8086	0.239055157061588	0.137196478289623	0.137196478289623	false	false	false	true
459d8bc0-7474-46bf-b8e6-56547240c02e	2026-10-01 12:02	2026-10-01 12:02	2026-10-01 12:02	SPX	SPX261016P07450000	put	7450.0000	2026-10-16	30.5400	29.1000	29.6000	7639.3600	183240.00	0.00	0.00	60	7	933	10921	0.0854317370204194	0.165502037563088	0.165502037563088	false	false	false	true
4286fec5-db03-4fd3-85a0-b2f8029e385f	2026-10-01 12:02	2026-10-01 12:02	2026-10-01 12:02	SPX	SPX261016P07700000	put	7700.0000	2026-10-16	108.1600	104.4000	105.4000	7639.3600	4207424.00	0.00	0.00	389	7	1840	22938	0.0802162350684454	0.132272685513191	0.132272685513191	false	false	false	true
27868832-c32a-49be-8750-144165d8df7e	2026-10-01 12:02	2026-10-01 12:02	2026-10-01 12:02	SPX	SPX261016P06750000	put	6750.0000	2026-10-16	2.9800	2.8000	2.9500	7639.3600	11324.00	0.00	0.00	38	7	43	6932	0.00620311598384305	0.297812037201083	0.297812037201083	false	false	false	true
274ae9c6-4bcd-4a91-8dae-2be4c6fbbe94	2026-10-01 12:02	2026-10-01 12:02	2026-10-01 12:02	SPX	SPX270319P07800000	put	7800.0000	2027-03-19	323.4400	320.2000	321.2000	7639.3600	24387376.00	0.00	0.00	754	7	819	9084	0.0901585204755614	0.154571303653029	0.154571303653029	false	false	false	true
0d7e4199-7dcd-4cd5-ac4b-678576a17120	2026-10-01 12:02	2026-10-01 12:02	2026-10-01 12:02	SPX	SPX261016P07000000	put	7000.0000	2026-10-16	5.1800	4.9000	5.1000	7639.3600	18130.00	0.00	0.00	35	7	2035	223819	0.0090921682252177	0.24423225911085	0.24423225911085	false	false	false	true
275f7a83-6b5e-4881-bcf4-f2d5b836bae6	2026-10-01 11:54	2026-10-01 11:54	2026-10-01 11:54	SPX	SPX261218P07685000	put	7685.0000	2026-12-18	204.5000	203.4000	204.3000	7626.4200	5521500.00	0.00	0.00	270	11	1715	3422	0.501168907071888	0.149085576970097	0.149085576970097	false	false	false	true
101562a3-c3d4-4bee-824b-fd3c88ff7985	2026-10-01 11:54	2026-10-01 11:54	2026-10-01 11:54	SPX	SPX261218C07685000	call	7685.0000	2026-12-18	201.0000	201.2000	202.2000	7626.4200	5427000.00	0.00	0.00	270	11	1658	3231	0.513153822346023	0.139411646433729	0.139411646433729	false	false	false	true
52eb1f60-01b4-4447-967e-27c4f522ec45	2026-10-01 11:41	2026-10-01 11:41	2026-10-01 11:41	SPX	SPX261016P07500000	put	7500.0000	2026-10-16	40.3000	40.0000	40.3000	7632.9300	96720.00	96720.00	0.00	24	5	184	36375	0.00505841924398625	0.156952154016587	0.156952154016587	false	false	false	true
7cd9f081-d159-4723-91c1-cf82fa8e79b3	2026-10-01 11:35	2026-10-01 11:35	2026-10-01 11:35	SPX	SPX270917P06950000	put	6950.0000	2027-09-17	226.0000	226.9000	227.7000	7600.0000	15820000.00	0.00	0.00	700	6	700	405	1.72839506172839	0.211363765719782	0.211363765719782	false	false	false	true
74dee2db-92dc-4ed9-9b58-4d7b5eee70ce	2026-10-01 11:35	2026-10-01 11:35	2026-10-01 11:35	SPX	SPX261218C07695000	call	7695.0000	2026-12-18	199.0000	194.6000	195.6000	7600.0000	1393000.00	0.00	0.00	70	6	458	3584	0.127790178571429	0.142403833895811	0.142403833895811	false	false	false	true
62453038-5a63-4d59-9ea0-0cf7bb07ebd4	2026-10-01 11:35	2026-10-01 11:35	2026-10-01 11:35	SPX	SPX270917P07900000	put	7900.0000	2027-09-17	475.0000	477.6000	478.5000	7600.0000	23750000.00	0.00	0.00	500	6	500	2633	0.189897455374098	0.170217645863671	0.170217645863671	false	false	false	true
1cbffb0b-d0b2-4a7e-85d4-66e99ca29fec	2026-10-01 11:35	2026-10-01 11:35	2026-10-01 11:35	SPX	SPX261218P07695000	put	7695.0000	2026-12-18	206.0000	210.1000	210.9000	7600.0000	1442000.00	0.00	0.00	70	6	460	3233	0.142282709557686	0.145652853962622	0.145652853962622	false	false	false	true
711df7ed-9d0f-4c69-a1a6-bd825e8c3246	2026-10-01 11:34	2026-10-01 11:34	2026-10-01 11:34	SPX	SPX261218P07500000	put	7500.0000	2026-12-18	143.4000	143.0000	143.4000	7610.0000	587940.00	587940.00	0.00	41	5	2175	36862	0.0590038522055233	0.164350265501953	0.164350265501953	false	false	false	true
9c6696fd-7496-4551-aaef-8e6d54316419	2026-10-01 11:33	2026-10-01 11:33	2026-10-01 11:33	SPX	SPX261120P07400000	put	7400.0000	2026-11-20	84.6000	84.2000	85.0000	7610.0000	84600.00	0.00	0.00	10	6	1407	19606	0.0717637457921045	0.172292198239965	0.172292198239965	false	false	false	true
f29ab159-6167-4f2f-9a0e-bc9a565e1a9d	2026-10-01 11:27	2026-10-01 11:27	2026-10-01 11:27	SPX	SPX261016P07100000	put	7100.0000	2026-10-16	7.3000	6.6000	6.9000	7620.0000	29200.00	29200.00	0.00	40	2	2455	23525	0.104357066950053	0.226516202827937	0.226516202827937	false	true	false	true
b758a44d-7846-4b7c-8c0b-975963d74efe	2026-10-01 11:27	2026-10-01 11:27	2026-10-01 11:27	SPX	SPX261218P06500000	put	6500.0000	2026-12-18	30.1400	29.7000	30.2000	7620.0000	3014000.00	0.00	0.00	1000	6	1401	27585	0.0507884719956498	0.261020644712983	0.261020644712983	false	false	false	true
a69f942e-bb19-4bcc-b048-60dbf03918b6	2026-10-01 11:27	2026-10-01 11:27	2026-10-01 11:27	SPX	SPX261218P04000000	put	4000.0000	2026-12-18	2.2300	2.1000	2.3000	7620.0000	669000.00	0.00	0.00	3000	6	4000	80756	0.0495319233245827	0.551707769235799	0.551707769235799	false	false	false	true
a57cf56b-8b22-41ca-b72f-917d16892d39	2026-10-01 11:27	2026-10-01 11:27	2026-10-01 11:27	SPX	SPX261218P05000000	put	5000.0000	2026-12-18	6.2200	6.1000	6.3000	7620.0000	1866000.00	0.00	0.00	3000	6	3262	117198	0.0278332394750764	0.428793080400348	0.428793080400348	false	false	false	true
59ce57e4-5ef5-4bc1-97ed-ac742b33e948	2026-10-01 11:27	2026-10-01 11:27	2026-10-01 11:27	SPX	SPX261218C07685000	call	7685.0000	2026-12-18	207.0000	208.0000	208.7000	7620.0000	621000.00	0.00	0.00	30	6	381	3231	0.117920148560817	0.138903009052153	0.138903009052153	false	false	false	true
0b840ab5-4949-4b58-ba08-34e5b1cad9fb	2026-10-01 11:27	2026-10-01 11:27	2026-10-01 11:27	SPX	SPX261218P07685000	put	7685.0000	2026-12-18	199.0000	197.3000	198.3000	7620.0000	597000.00	0.00	0.00	30	6	438	3422	0.127995324371712	0.149473827927374	0.149473827927374	false	false	false	true
6a9cb82b-42cb-4a3d-8936-d321eda1dad9	2026-10-01 11:16	2026-10-01 11:16	2026-10-01 11:16	SPX	SPX261218P04000000	put	4000.0000	2026-12-18	2.2500	2.1000	2.3000	7632.6500	225000.00	225000.00	0.00	1000	11	1000	80756	0.0123829808311457	0.551632767725878	0.551632767725878	false	true	false	true
bb71ec5d-9c71-4095-a9e0-ba27040abced	2026-10-01 11:15	2026-10-01 11:14	2026-10-01 11:14	SPX	SPX261218P05000000	put	5000.0000	2026-12-18	6.4000	6.1000	6.4000	7631.4400	167680.00	167680.00	0.00	262	7	262	117198	0.00223553302957388	0.429668465043918	0.429668465043918	true	false	false	true
3b34dda5-428a-4c65-af7b-75aab2fedead	2026-10-01 11:13	2026-10-01 11:12	2026-10-01 11:12	SPX	SPX311219P05800000	put	5800.0000	2031-12-19	321.0000	228.2000	414.4000	7622.4700	642000.00	0.00	642000.00	20	2	20	1655	0.0120845921450151	0.252363229569755	0.252363229569755	false	true	false	true
69e54b76-ee29-427d-9430-73985548919d	2026-10-01 11:10	2026-10-01 11:10	2026-10-01 11:10	SPX	SPX270319P07350000	put	7350.0000	2027-03-19	192.7800	192.3000	193.0000	7618.3700	308450.00	308450.00	0.00	16	5	20	3742	0.00534473543559594	0.180560376775347	0.180560376775347	false	false	false	true
236751db-63dd-4532-961f-cfccebee88d0	2026-10-01 11:10	2026-10-01 11:10	2026-10-01 11:10	SPX	SPX270319P07350000	put	7350.0000	2027-03-19	192.8000	192.3000	193.0000	7618.4500	385600.00	385600.00	0.00	20	6	40	3742	0.0106894708711919	0.180560376775347	0.180573758998106	false	false	false	true
fac18606-c653-4fcf-9d95-7cba6702c5e1	2026-10-01 11:09	2026-10-01 11:09	2026-10-01 11:09	SPX	SPX261016P06900000	put	6900.0000	2026-10-16	4.7000	4.4000	4.7000	7600.0000	56400.00	56400.00	0.00	120	2	158	18373	0.00859957546399608	0.267062970989013	0.267062970989013	false	true	false	true
2f2a1aac-f662-4549-8b5d-9bae17c20f24	2026-10-01 11:04	2026-10-01 11:04	2026-10-01 11:04	SPX	SPX261016P07600000	put	7600.0000	2026-10-16	72.4000	71.8000	72.6000	7624.2400	376480.00	166520.00	209960.00	52	5	243	15621	0.0155559823314769	0.145658519494788	0.145658519494788	false	false	false	true
ab7f54dd-060f-4b6b-9b70-8a96d8a83b4d	2026-10-01 11:01	2026-10-01 11:01	2026-10-01 11:01	SPX	SPX261218P05300000	put	5300.0000	2026-12-18	8.5000	8.5000	8.7000	7627.4400	13600.00	0.00	13600.00	16	5	16	11896	0.00134498991257566	0.393506508473907	0.393506508473907	false	false	false	true
f7a0bda5-3b9f-4dda-8826-0fd4e81d0b62	2026-10-01 10:50	2026-10-01 10:50	2026-10-01 10:50	SPX	SPX261120P07150000	put	7150.0000	2026-11-20	47.3000	46.5000	47.0000	7641.9300	2010250.00	0.00	0.00	425	16	572	4746	0.120522545301306	0.199605964462403	0.199605964462403	false	false	false	true
b4f2403e-3c54-4929-9243-9773df9b9ef1	2026-10-01 10:50	2026-10-01 10:50	2026-10-01 10:50	SPX	SPX261218C07690000	call	7690.0000	2026-12-18	206.4000	206.6000	207.4000	7641.9300	1403520.00	0.00	0.00	68	16	1205	8086	0.149023002720752	0.139218279819024	0.139218279819024	false	false	false	true
75d06f61-2f8e-4444-bc9f-376f84668333	2026-10-01 10:50	2026-10-01 10:50	2026-10-01 10:50	SPX	SPX261218P07690000	put	7690.0000	2026-12-18	198.9000	198.0000	198.9000	7641.9300	1352520.00	0.00	0.00	68	16	1208	8048	0.150099403578529	0.148568464644604	0.148568464644604	false	false	false	true
d97bf06e-ab22-4345-8b08-7127eefc4123	2026-10-01 10:48	2026-10-01 10:47	2026-10-01 10:47	SPX	SPX271217C09550000	call	9550.0000	2027-12-17	76.5000	76.5000	76.9000	7640.3000	765000.00	0.00	765000.00	100	5	101	586	0.172354948805461	0.131277517489749	0.131277517489749	false	false	false	true
eae01644-8e3a-4195-91f2-68fa68fbd079	2026-10-01 10:46	2026-10-01 10:46	2026-10-01 10:46	SPX	SPX261016P07425000	put	7425.0000	2026-10-16	25.0000	24.5000	25.0000	7648.2300	50000.00	50000.00	0.00	20	8	57	4403	0.0129457188280718	0.168247817754582	0.168247817754582	false	false	false	true
f7f664fe-7073-443d-90d8-8d477264f9c7	2026-10-01 10:39	2026-10-01 10:39	2026-10-01 10:39	SPX	SPX261120C08000000	call	8000.0000	2026-11-20	35.7000	35.3000	35.7000	7647.7100	121380.00	121380.00	0.00	34	6	1803	81010	0.022256511541785	0.119990185408086	0.119990185408086	false	false	false	true
69d38042-01fe-43a8-b6ef-af6bdcb262cf	2026-10-01 10:22	2026-10-01 10:22	2026-10-01 10:22	SPX	SPX261016P07550000	put	7550.0000	2026-10-16	52.8000	52.6000	53.1000	7615.0000	26400.00	5280.00	21120.00	5	5	45	6476	0.00694873378628783	0.152003651219827	0.152003651219827	false	false	false	true
0cbe2559-f795-4b63-a68f-941bd864f882	2026-10-01 10:21	2026-10-01 10:21	2026-10-01 10:21	SPX	SPX261016P06950000	put	6950.0000	2026-10-16	4.8000	4.8000	5.1000	7615.0000	50400.00	0.00	50400.00	105	7	480	6287	0.0763480197232384	0.255901122556078	0.255901122556078	true	false	false	true
65976ece-3564-4473-a571-4103ef014faa	2026-10-01 10:15	2026-10-01 10:15	2026-10-01 10:15	SPX	SPX261218P07690000	put	7690.0000	2026-12-18	206.0000	202.1000	203.0000	7636.6600	947600.00	0.00	0.00	46	6	285	8048	0.0354125248508946	0.151847943988315	0.151847943988315	false	false	false	true
4e6e608a-7b53-45cf-b1de-65471b79a1c2	2026-10-01 10:15	2026-10-01 10:15	2026-10-01 10:15	SPX	SPX261218C07690000	call	7690.0000	2026-12-18	203.0000	204.9000	205.9000	7636.6600	933800.00	0.00	0.00	46	6	282	8086	0.0348750927529063	0.13877690109067	0.13877690109067	false	false	false	true
ab8929ca-0e84-43fd-b76c-7e327934815a	2026-10-01 10:12	2026-10-01 10:12	2026-10-01 10:12	SPX	SPX270319C08750000	call	8750.0000	2027-03-19	24.7000	24.2000	24.7000	7639.7300	71630.00	71630.00	0.00	29	5	29	1324	0.0219033232628399	0.121584941508864	0.121632583271304	false	false	false	true
c2672456-423e-4581-81b8-298fd05c7172	2026-10-01 10:12	2026-10-01 10:12	2026-10-01 10:12	SPX	SPX261120P07150000	put	7150.0000	2026-11-20	48.2000	47.7000	48.2000	7638.0200	120500.00	120500.00	0.00	25	7	109	4746	0.0229667088074168	0.200033188868499	0.200033188868499	false	false	false	true
d787fbfa-d808-4f58-b481-4ed5ea2f09a4	2026-10-01 10:09	2026-10-01 10:09	2026-10-01 10:09	SPX	SPX261120P07800000	put	7800.0000	2026-11-20	218.9900	218.3000	219.6000	7620.0000	1423440.00	656870.00	766570.00	65	5	65	6500	0.01	0.1365278434392	0.136619727869468	false	false	false	true
051870ad-351f-4630-9991-a32cddf42b04	2026-10-01 10:09	2026-10-01 10:09	2026-10-01 10:09	SPX	SPX261120P06200000	put	6200.0000	2026-11-20	10.2000	10.2000	10.6000	7620.0000	25500.00	0.00	25500.00	25	6	124	7696	0.0161122661122661	0.314470682697473	0.314470682697473	false	false	false	true