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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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

60ccabab-3e19-4e7a-8999-8e539de0ca3d	2026-08-31 15:43	2026-08-31 15:43	2026-08-31 15:43	SPXW	SPXW260930P07550000	put	7550.0000	2026-09-30	56.5000	56.4000	56.7000	7686.4300	197750.00	0.00	197750.00	35	5	963	3606	0.267054908485857	0.13792318892084	0.13792318892084	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-08-31T19:54:15.623665Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
af46f6f0-b083-4787-9a59-e340ab4413b1	2026-08-31 15:44	2026-08-31 15:44	2026-08-31 15:44	SPXW	SPXW260831C07685000	call	7685.0000	2026-08-31	6.0600	5.8000	6.1000	7687.8700	125380.00	121870.00	1740.00	207	38	152689	554	275.611913357401	0.252505368526368	0.26495036582445	false	false	false	true	false
70116bee-969b-4660-987e-c80c219a89c0	2026-08-31 15:48	2026-08-31 15:48	2026-08-31 15:48	SPXW	SPXW260831C07680000	call	7680.0000	2026-08-31	6.4000	6.3000	6.6000	7684.5800	122880.00	45440.00	77440.00	192	22	157558	384	410.307291666667	0.252285884465743	0.252285884465743	false	false	false	true	false
1a20402c-caa1-48c3-b342-ea73fd068a61	2026-08-31 15:49	2026-08-31 15:49	2026-08-31 15:49	SPXW	SPXW260902C07670000	call	7670.0000	2026-09-02	31.4600	31.2000	31.6000	7683.1800	157310.00	157310.00	0.00	50	10	1195	52	22.9807692307692	0.102607436676376	0.103518379059201	false	false	false	true	false
d8ddad75-298e-4fec-aaec-0ffb7481d804	2026-08-31 15:50	2026-08-31 15:50	2026-08-31 15:50	SPXW	SPXW260831C07695000	call	7695.0000	2026-08-31	2.4400	2.2500	2.9000	7690.7500	100530.00	7155.00	92865.00	412	128	99014	1368	72.3786549707602	0.317408678452484	0.313348970291455	false	false	false	true	false
db45a69f-7b50-4d26-ad6f-132dea544750	2026-08-31 15:50	2026-08-31 15:50	2026-08-31 15:50	SPXW	SPXW260831C07685000	call	7685.0000	2026-08-31	8.5300	7.7000	9.2000	7691.2700	316520.00	118500.00	187840.00	371	266	157634	554	284.537906137184	0.34137673799882	0.344750627544963	true	false	false	true	false
a72e1d5a-5c43-40e3-ae5d-05ab719d9b88	2026-08-31 15:50	2026-08-31 15:50	2026-08-31 15:50	SPXW	SPXW260831C07690000	call	7690.0000	2026-08-31	4.9300	4.6000	5.5000	7691.2700	171390.00	33840.00	122580.00	348	155	148711	735	202.327891156463	0.338019144994727	0.332360273997363	true	false	false	true	false
951b170a-e968-48f1-85d3-7b0334793bad	2026-08-31 15:50	2026-08-31 15:50	2026-08-31 15:50	SPXW	SPXW260831C07695000	call	7695.0000	2026-08-31	2.7100	2.5500	3.2000	7691.7400	115920.00	27690.00	85600.00	428	88	99610	1368	72.8143274853801	0.31495381190434	0.340765304695087	false	false	false	true	false
00cb0b06-7654-48a8-96c6-0e28b5ca8b38	2026-08-31 15:50	2026-08-31 15:50	2026-08-31 15:50	SPXW	SPXW260831C07685000	call	7685.0000	2026-08-31	9.4300	8.8000	9.8000	7692.6300	129140.00	93620.00	33640.00	137	34	157832	554	284.895306859206	0.394247722535654	0.364549164757698	false	false	false	true	false
cedd3ccc-d627-4b64-91a7-6a5ddfdb0942	2026-08-31 15:50	2026-08-31 15:50	2026-08-31 15:50	SPXW	SPXW260831C07690000	call	7690.0000	2026-08-31	6.5600	6.1000	6.9000	7693.1500	117500.00	43870.00	53190.00	179	107	149333	735	203.174149659864	0.365638080446573	0.334069445401668	true	false	false	true	false
5f8ffc3b-a710-4b0e-8ee2-6d570e54a1a7	2026-08-31 15:50	2026-08-31 15:50	2026-08-31 15:50	SPXW	SPXW260831C07690000	call	7690.0000	2026-08-31	6.1800	5.7000	6.8000	7692.6300	131050.00	48500.00	80720.00	212	157	149148	735	202.922448979592	0.342254095871361	0.380996516834755	true	false	false	true	false
14a170f4-bd3b-4473-b422-c8bf4514dc8c	2026-08-31 15:50	2026-08-31 15:50	2026-08-31 15:50	SPXW	SPXW260831C07700000	call	7700.0000	2026-08-31	1.8600	1.7500	2.0000	7693.1500	106910.00	10725.00	95235.00	575	145	151978	7651	19.8638086524637	0.34286488223293	0.33510634239832	false	false	false	true	false
5fa2aee7-20a3-467e-afce-16bfa612a132	2026-08-31 15:50	2026-08-31 15:50	2026-08-31 15:50	SPXW	SPXW260831C07695000	call	7695.0000	2026-08-31	2.8700	2.5000	3.3000	7692.2000	170105.00	24725.00	139230.00	593	216	101139	1368	73.9320175438596	0.301498874834626	0.281586357987206	true	false	false	true	false
e5ef3144-ba0d-43b6-a010-eadb94701fb2	2026-08-31 15:50	2026-08-31 15:50	2026-08-31 15:50	SPXW	SPXW260901P07680000	put	7680.0000	2026-09-01	11.7000	11.4000	11.8000	7691.5400	233930.00	195320.00	38610.00	200	9	7293	363	20.0909090909091	0.106354192731907	0.107003652345994	true	false	false	true	false
1aaf0247-f4f3-4215-ba4d-cc3a42410617	2026-08-31 15:50	2026-08-31 15:50	2026-08-31 15:50	SPXW	SPXW261030C08000000	call	8000.0000	2026-10-30	47.3100	48.2000	48.8000	7692.0600	2365500.00	0.00	0.00	500	5	560	5274	0.106181266590823	0.110627806158917	0.110627806158917	false	false	false	true	false
98c24c70-743e-452c-81e8-03c95364cb20	2026-08-31 15:52	2026-08-31 15:52	2026-08-31 15:52	SPXW	SPXW260901P07680000	put	7680.0000	2026-09-01	11.7000	11.7000	11.8000	7690.6800	237510.00	0.00	237510.00	203	14	7662	363	21.1074380165289	0.104836968440511	0.104836968440511	false	false	false	true	false
3d8c8915-eee6-47ad-8d81-8b7abdbc0cb5	2026-08-31 15:52	2026-08-31 15:52	2026-08-31 15:52	SPXW	SPXW260901P07680000	put	7680.0000	2026-09-01	11.4000	11.2000	11.5000	7692.1100	114000.00	27360.00	86640.00	100	9	7794	363	21.4710743801653	0.106472968417345	0.106472968417345	false	false	false	true	false
2ac1517a-28b2-4844-90f6-5da2418496d4	2026-08-31 15:54	2026-08-31 15:54	2026-08-31 15:54	SPXW	SPXW260901P07690000	put	7690.0000	2026-09-01	16.5400	16.3000	16.7000	7688.9900	165360.00	59760.00	105600.00	100	9	2842	1386	2.05050505050505	0.102760783660232	0.102137955678917	true	false	false	true	false
a694d253-648b-439c-9d88-bd2530fe7567	2026-08-31 15:55	2026-08-31 15:55	2026-08-31 15:55	SPXW	SPXW260901P07680000	put	7680.0000	2026-09-01	13.1000	13.0000	13.4000	7686.9300	262000.00	191260.00	70740.00	200	16	8267	363	22.7741046831956	0.103993911015324	0.103993911015324	false	false	false	true	false
3dbd6477-4d78-4830-af41-de93b4f4ab8f	2026-08-31 15:59	2026-08-31 15:59	2026-08-31 15:59	SPXW	SPXW260831C07690000	call	7690.0000	2026-08-31	5.5300	5.1000	6.5000	7696.3300	101220.00	52900.00	47730.00	183	44	167996	735	228.565986394558	0.553225792040143	0	false	false	false	true	false
4c871f2d-9b5e-410f-af78-e75e91baea03	2026-08-31 15:59	2026-08-31 15:59	2026-08-31 15:59	SPXW	SPXW260911P07690000	put	7690.0000	2026-09-11	53.0600	53.0000	53.8000	7688.4600	201640.00	0.00	201640.00	38	6	182	536	0.33955223880597	0.106726737479446	0.106726737479446	false	false	false	true	false
22388585-fc97-4c7f-8453-349f54116d5a	2026-08-31 16:07	2026-08-31 16:07	2026-08-31 16:07	SPXW	SPXW260903P07560000	put	7560.0000	2026-09-03	3.5000	3.4000	3.6000	7686.1400	165900.00	155050.00	0.00	474	8	1209	386	3.13212435233161	0.134141775578778	0.134141775578778	false	false	false	true	false
550964b6-b838-4607-a7d3-49da204610a3	2026-08-31 16:17	2026-08-31 16:13	2026-08-31 16:13	SPXW	SPXW260901P07690000	put	7690.0000	2026-09-01	15.3000	15.2000	15.5000	7686.1400	160650.00	117810.00	42840.00	105	16	4502	1386	3.24819624819625	0.0854699517702881	0.0854699517702881	false	false	false	true	false
d070a92b-e4b0-4284-8630-5cc1190b6dab	2026-08-31 16:19	2026-08-31 16:17	2026-08-31 16:17	SPXW	SPXW260930P07600000	put	7600.0000	2026-09-30	67.4000	66.9000	67.5000	7686.1400	8425000.00	0.00	0.00	1250	13	3119	8628	0.361497450162262	0.130733161812172	0.130733161812172	false	false	false	true	false
4b21c50e-fbdd-46c5-92d5-1fd7cbaa5ec5	2026-08-31 16:19	2026-08-31 16:17	2026-08-31 16:17	SPXW	SPXW260930C08000000	call	8000.0000	2026-09-30	9.4000	9.3000	9.7000	7686.1400	1175000.00	0.00	0.00	1250	12	4960	15787	0.314182555266992	0.0970480473145185	0.0970480473145185	false	false	false	true	false
e8c1694c-3dec-4438-bb07-d9010401315c	2026-09-01 09:30	2026-08-31 16:19	2026-08-31 16:19	SPXW	SPXW260930P07600000	put	7600.0000	2026-09-30	67.2400	67.0000	67.5000	7686.1400	5043000.00	0.00	0.00	750	8	3869	8628	0.448423736671303	0.130535684424223	0.130535684424223	false	false	false	true	false
94c7483c-6960-4e7d-a027-bc4279d8b45f	2026-09-01 09:30	2026-08-31 16:19	2026-08-31 16:19	SPXW	SPXW260930C08000000	call	8000.0000	2026-09-30	9.5000	9.3000	9.7000	7686.1400	712500.00	0.00	0.00	750	8	5710	15787	0.361689998099702	0.0973160953154299	0.0973160953154299	false	false	false	true	false
a7a1e552-0bd5-4287-960e-6036622a617f	2026-09-01 09:30	2026-09-01 09:30	2026-09-01 09:30	SPXW	SPXW260901P07690000	put	7690.0000	2026-09-01	57.8000	0.0000	0.0000	7632.7000	589560.00	589560.00	0.00	102	7	102	2264	0.0450530035335689	0.166106437006521	0.166106437006521	false	false	false	true	false
b3a8f026-13a4-45b0-99e9-acc248a0ad98	2026-09-01 09:30	2026-09-01 09:30	2026-09-01 09:30	SPXW	SPXW260903C07625000	call	7625.0000	2026-09-03	35.9700	35.5000	36.4000	7630.8700	345330.00	10740.00	334590.00	96	12	100	330	0.303030303030303	0.14172461947537	0.14261644761087	false	false	false	true	false
46145473-4005-4b55-b997-702a02d02007	2026-09-01 09:31	2026-09-01 09:31	2026-09-01 09:31	SPXW	SPXW260901C07635000	call	7635.0000	2026-09-01	12.8000	12.7000	12.9000	7629.6200	398090.00	1290.00	396800.00	311	42	640	265	2.41509433962264	0.184046984311112	0.185269480462715	false	false	false	true	false
7326a065-5d16-4655-994b-5debd4c5bbfa	2026-09-01 09:32	2026-09-01 09:32	2026-09-01 09:32	SPXW	SPXW260901P07675000	put	7675.0000	2026-09-01	42.0300	42.0000	42.9000	7633.3500	109270.00	0.00	109270.00	26	5	470	2480	0.189516129032258	0.131263949053373	0.131263949053373	false	false	false	true	false
729b2c9a-3a57-4ca0-a5c0-14124802edef	2026-09-01 09:33	2026-09-01 09:32	2026-09-01 09:32	SPXW	SPXW260901C07635000	call	7635.0000	2026-09-01	13.7000	13.6000	13.7000	7633.9900	117820.00	117820.00	0.00	86	9	1313	265	4.95471698113208	0.170514334690492	0.170514334690492	false	false	false	true	false
40c63b1e-97c6-42b7-9dd6-75a858a5caa5	2026-09-01 09:33	2026-09-01 09:32	2026-09-01 09:32	SPXW	SPXW260901C07635000	call	7635.0000	2026-09-01	13.7000	13.6000	13.8000	7633.9000	291830.00	45230.00	0.00	213	12	1526	265	5.75849056603774	0.170514334690492	0.172259943703734	false	false	false	true	false
a83916a4-60a3-49ea-8b5b-807903bc790e	2026-09-01 09:35	2026-09-01 09:35	2026-09-01 09:35	SPXW	SPXW260901C07695000	call	7695.0000	2026-09-01	0.8000	0.7500	0.8500	7638.8500	185120.00	22160.00	162960.00	2314	16	4099	981	4.17838939857289	0.168914291215681	0.167983618713741	false	false	false	true	false
8c4c3272-23e3-4489-89cb-2ac69e6a288f	2026-09-01 09:38	2026-09-01 09:38	2026-09-01 09:38	SPXW	SPXW260901C07640000	call	7640.0000	2026-09-01	11.3000	11.1000	11.4000	7635.7700	289280.00	83620.00	205660.00	256	40	3906	232	16.8362068965517	0.160919018138989	0.160919018138989	false	false	false	true	false
7d706c8e-a871-4be6-a46d-1d82cdb21c68	2026-09-01 09:38	2026-09-01 09:38	2026-09-01 09:38	SPXW	SPXW260901C07640000	call	7640.0000	2026-09-01	11.3100	11.3000	11.5000	7636.0700	171950.00	19380.00	150290.00	152	24	3634	232	15.6637931034483	0.157219165244357	0.16046676581631	false	false	false	true	false
1b2cbc34-ce03-4cee-bb90-dd9e435a278e	2026-09-01 09:39	2026-09-01 09:39	2026-09-01 09:39	SPXW	SPXW260901P07630000	put	7630.0000	2026-09-01	11.2800	11.0000	11.3000	7633.7200	108310.00	104950.00	0.00	96	20	4400	1689	2.60509177027827	0.158302174010839	0.15953143928601	false	false	false	true	false
e29198c4-45a1-44b1-ab26-dcc702668b50	2026-09-01 09:39	2026-09-01 09:39	2026-09-01 09:39	SPXW	SPXW260901C07640000	call	7640.0000	2026-09-01	10.4000	10.4000	10.5000	7634.5000	209040.00	0.00	209040.00	201	28	4463	232	19.2370689655172	0.157012702309962	0.157012702309962	false	false	false	true	false
88124abe-1079-48c5-9c72-2fe93093ca4d	2026-09-01 09:41	2026-09-01 09:41	2026-09-01 09:41	SPXW	SPXW260908P07600000	put	7600.0000	2026-09-08	31.9500	31.6000	32.0000	7631.3800	319490.00	319490.00	0.00	100	15	329	1812	0.181567328918322	0.11423593478804	0.114734334072263	false	false	false	true	false
c4385d1e-e15f-4917-9130-2b5bb657f2c7	2026-09-01 09:41	2026-09-01 09:41	2026-09-01 09:41	SPXW	SPXW260930C07830000	call	7830.0000	2026-09-30	30.5000	30.0000	30.7000	7631.2500	451400.00	42700.00	408700.00	148	7	148	301	0.491694352159468	0.107036647494141	0.107036647494141	false	false	false	true	false
28919240-a7b6-4000-9b13-00feec2b8dd9	2026-09-01 09:42	2026-09-01 09:42	2026-09-01 09:42	SPXW	SPXW260904C07645000	call	7645.0000	2026-09-04	34.2000	34.1000	34.2000	7633.3100	171000.00	171000.00	0.00	50	6	134	132	1.01515151515152	0.139942803985894	0.139942803985894	false	false	false	true	false
717cc78e-dc6d-4e80-8ae4-ad1867a6335d	2026-09-01 09:42	2026-09-01 09:42	2026-09-01 09:42	SPXW	SPXW260925C07875000	call	7875.0000	2026-09-25	15.0000	14.9000	15.2000	7634.5900	102000.00	100500.00	1500.00	68	6	70	436	0.160550458715596	0.103775727615398	0.103775727615398	false	false	false	true	false
ce862a8a-ed7b-4d7b-ad57-c58d399f561d	2026-09-01 09:44	2026-09-01 09:43	2026-09-01 09:43	SPXW	SPXW260901P07630000	put	7630.0000	2026-09-01	9.9000	9.9000	10.0000	7634.2400	196040.00	2000.00	194040.00	198	29	6601	1689	3.90822972172883	0.147267824185461	0.147271036527103	false	false	false	true	false
504bb59d-b2cc-4485-aacd-101cc46b8dfc	2026-09-01 09:46	2026-09-01 09:45	2026-09-01 09:45	SPXW	SPXW260902P07600000	put	7600.0000	2026-09-02	9.3000	9.2000	9.4000	7636.7700	132990.00	27900.00	0.00	143	7	711	1473	0.482688391038697	0.147431179166913	0.147431179166913	false	false	false	true	false
2b31c1ee-e88b-4296-9ec7-bfca217b9621	2026-09-01 09:46	2026-09-01 09:46	2026-09-01 09:46	SPXW	SPXW260901C07640000	call	7640.0000	2026-09-01	10.6000	10.5000	10.8000	7638.3600	111350.00	0.00	104990.00	105	19	6572	232	28.3275862068966	0.140433269550894	0.13908254710346	false	false	false	true	false
79dcd9e1-2d06-41d3-990d-1263b2609f86	2026-09-01 09:52	2026-09-01 09:52	2026-09-01 09:52	SPXW	SPXW260901P07630000	put	7630.0000	2026-09-01	9.0000	8.9000	9.1000	7635.1100	101730.00	47730.00	54000.00	113	15	9906	1689	5.86500888099467	0.142424028629708	0.14368785984791	false	false	false	true	false
9b42169f-953a-4bf2-b2cf-476b64562fea	2026-09-01 09:53	2026-09-01 09:53	2026-09-01 09:53	SPXW	SPXW260901P07630000	put	7630.0000	2026-09-01	9.5000	9.4000	9.5000	7634.6100	106400.00	106400.00	0.00	112	11	10277	1689	6.08466548253404	0.146139683490885	0.146139683490885	false	false	false	true	false
15f6b187-382a-4eb4-824f-eccff43ae129	2026-09-01 09:54	2026-09-01 09:54	2026-09-01 09:54	SPXW	SPXW260901C07630000	call	7630.0000	2026-09-01	13.8500	13.7000	13.9000	7632.3900	277010.00	268730.00	0.00	200	35	4393	806	5.45037220843672	0.155164150795654	0.156413735206167	true	false	false	true	false
6024e1a5-8f30-4eef-8d47-7d45babdbf3a	2026-09-01 09:55	2026-09-01 09:54	2026-09-01 09:54	SPXW	SPXW260901P07670000	put	7670.0000	2026-09-01	37.6600	37.6000	37.9000	7633.0900	112970.00	45240.00	67730.00	30	10	809	1192	0.678691275167785	0.131107643474551	0.131107643474551	false	false	false	true	false
dff99605-1f75-49f5-b443-63c49b6a2ed5	2026-09-01 09:55	2026-09-01 09:55	2026-09-01 09:55	SPXW	SPXW260908P07625000	put	7625.0000	2026-09-08	40.2000	40.1000	40.4000	7631.5400	100500.00	4020.00	96480.00	25	5	68	510	0.133333333333333	0.109257135905419	0.109257135905419	false	false	false	true	false