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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 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

587bbeed-0249-417f-b040-e53270b0478d	2026-08-21 14:25	2026-08-21 14:25	2026-08-21 14:25	SPXW	SPXW260821P07705000	put	7705.0000	2026-08-21	33.0000	32.8000	33.0000	7672.5600	148500.00	148500.00	0.00	45	7	4732	1283	3.68823070927514	0.208300336160926	0.208300336160926	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-21T18:49:22.677317Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
1581a6bf-0ef7-43f2-b24d-bf87fbda56c8	2026-08-21 14:26	2026-08-21 14:26	2026-08-21 14:26	SPXW	SPXW260821P07675000	put	7675.0000	2026-08-21	5.9000	5.8000	6.0000	7672.1600	112690.00	600.00	83770.00	191	37	80357	2161	37.1850994909764	0.109164871091628	0.10411745332736	false	false	false	true	false
a0835908-14ef-4b1e-9fb1-c87d3038a492	2026-08-21 14:29	2026-08-21 14:29	2026-08-21 14:29	SPXW	SPXW260821P07675000	put	7675.0000	2026-08-21	6.1000	6.0000	6.3000	7671.7200	109800.00	1220.00	70760.00	180	15	81161	2161	37.557149467839	0.106588715372976	0.106588715372976	false	false	false	true	false
606918c0-9d94-440b-91c3-947f1c8b0af6	2026-08-21 14:31	2026-08-21 14:30	2026-08-21 14:30	SPXW	SPXW260824P07675000	put	7675.0000	2026-08-24	20.2000	20.1000	20.4000	7670.1900	105030.00	0.00	105030.00	52	13	5774	1094	5.27787934186472	0.0683667995423712	0.0683667995423712	false	false	false	true	false
8d5dc816-3a00-4c96-be0f-aa140209c5bb	2026-08-21 14:31	2026-08-21 14:31	2026-08-21 14:31	SPXW	SPXW260824P07670000	put	7670.0000	2026-08-24	18.0000	17.8000	18.1000	7670.0500	140400.00	73800.00	66600.00	78	11	4253	940	4.52446808510638	0.069214854110534	0.069214854110534	true	false	false	true	false
2c2f9a50-f21d-4f63-984b-eb39cac04be0	2026-08-21 14:37	2026-08-21 14:37	2026-08-21 14:37	SPXW	SPXW260821P07690000	put	7690.0000	2026-08-21	18.5800	18.4000	19.1000	7670.8400	278740.00	0.00	278740.00	150	24	26003	1257	20.6865552903739	0.0718098364196251	0.114998178248287	false	false	false	true	false
09b3d683-06c7-4ee7-a231-5b1d78c04385	2026-08-21 14:51	2026-08-21 14:51	2026-08-21 14:51	SPXW	SPXW260824P07675000	put	7675.0000	2026-08-24	17.2000	17.1000	17.4000	7676.0600	168560.00	101480.00	67080.00	98	8	6215	1094	5.68098720292505	0.0680130858173828	0.0680130858173828	false	false	false	true	false
64641bf7-9574-4914-9035-bb55a4f26ae3	2026-08-21 14:51	2026-08-21 14:51	2026-08-21 14:51	SPXW	SPXW260824P07670000	put	7670.0000	2026-08-24	14.9500	14.9000	15.2000	7676.2000	149460.00	0.00	149460.00	100	18	4959	940	5.27553191489362	0.0684339557673786	0.0680676077826635	false	false	false	true	false
8b675c95-b284-4d48-8b20-14dd213786bb	2026-08-21 14:58	2026-08-21 14:58	2026-08-21 14:58	SPXW	SPXW260821C07680000	call	7680.0000	2026-08-21	3.5500	3.3000	3.7000	7678.6500	118340.00	84290.00	32260.00	333	208	129631	1741	74.4577828834003	0.121872061473961	0.130901523898575	false	false	false	true	false
ab214abb-6161-4add-9e93-6e69485018ef	2026-08-21 14:59	2026-08-21 14:59	2026-08-21 14:59	SPXW	SPXW260821C07670000	call	7670.0000	2026-08-21	10.4400	10.1000	10.6000	7678.8200	166980.00	96260.00	70720.00	160	19	63180	976	64.733606557377	0.139479244127128	0.151539337197128	true	false	false	true	false
e0d5685e-122d-4f35-b2d8-417dfb8a9f12	2026-08-21 15:00	2026-08-21 14:59	2026-08-21 14:59	SPXW	SPXW260821C07685000	call	7685.0000	2026-08-21	2.3300	2.1500	2.5000	7679.5300	112015.00	48915.00	58075.00	480	241	112264	2194	51.1686417502279	0.13488238784161	0.139210335633562	false	false	false	true	false
83f0b438-f341-4f30-8296-b5c01d641474	2026-08-21 15:00	2026-08-21 15:00	2026-08-21 15:00	SPXW	SPXW260824C07680000	call	7680.0000	2026-08-24	19.1600	18.9000	19.2000	7681.0500	191570.00	178270.00	0.00	100	20	3534	318	11.1132075471698	0.0619640691534135	0.0627249378375702	false	false	false	true	false
ccd62e5e-b91e-4c57-9822-e9baa1169296	2026-08-21 15:10	2026-08-21 15:10	2026-08-21 15:10	SPXW	SPXW260821P07720000	put	7720.0000	2026-08-21	40.7000	40.6000	41.3000	7679.3600	411070.00	122100.00	288970.00	101	5	3606	871	4.14006888633754	0.245200981905694	0.245200981905694	false	false	false	true	false
df7dbff0-45e6-4230-ad53-0a90709ba0ad	2026-08-21 15:16	2026-08-21 15:16	2026-08-21 15:16	SPXW	SPXW260904C07800000	call	7800.0000	2026-09-04	20.6000	20.6000	20.9000	7677.5300	160680.00	0.00	160680.00	78	8	491	1579	0.310956301456618	0.100364627461601	0.100364627461601	true	false	false	true	false
17c4a70c-1622-4d4e-b697-241912f5a7fb	2026-08-21 15:20	2026-08-21 15:20	2026-08-21 15:20	SPXW	SPXW260824C07680000	call	7680.0000	2026-08-24	17.1000	17.0000	17.3000	7678.5600	171000.00	0.00	171000.00	100	11	4262	318	13.4025157232704	0.0598358900983615	0.0598358900983615	true	false	false	true	false
3618b01a-bfa3-4e93-bbe7-9c9e690c2e57	2026-08-21 15:27	2026-08-21 15:27	2026-08-21 15:27	SPXW	SPXW260918P07650000	put	7650.0000	2026-09-18	86.4400	85.9000	87.8000	7678.8400	855720.00	224270.00	631450.00	99	7	164	5192	0.0315870570107858	0.129928190010245	0.130289151184433	false	false	false	true	false
53c81f44-57a9-442c-8023-a8d8784f3e14	2026-08-21 15:33	2026-08-21 15:32	2026-08-21 15:32	SPXW	SPXW260828C07705000	call	7705.0000	2026-08-28	36.2000	35.9000	36.3000	7680.3700	144800.00	25340.00	119460.00	40	5	333	197	1.69035532994924	0.106089752643283	0.106089752643283	false	false	false	true	false
45b1c8ff-0373-4998-a5d0-9eb783d213be	2026-08-21 15:33	2026-08-21 15:32	2026-08-21 15:32	SPXW	SPXW260828C07705000	call	7705.0000	2026-08-28	36.2000	36.2000	36.3000	7680.3700	181000.00	0.00	181000.00	50	6	293	197	1.48730964467005	0.106089752643283	0.106089752643283	false	false	false	true	false
3b2d0e2c-50e8-4d6e-af6c-6f9fbc04639c	2026-08-21 15:33	2026-08-21 15:33	2026-08-21 15:33	SPXW	SPXW260828P07675000	put	7675.0000	2026-08-28	43.4000	43.3500	43.5000	7679.2300	217000.00	0.00	217000.00	50	7	1128	604	1.86754966887417	0.113569066458918	0.113569066458918	false	false	false	true	false
d9d1b366-9366-4b7e-b52b-8c4f29a785da	2026-08-21 15:35	2026-08-21 15:35	2026-08-21 15:35	SPXW	SPXW260904C07820000	call	7820.0000	2026-09-04	15.9000	15.8000	15.9000	7679.5100	201930.00	201930.00	0.00	127	6	875	619	1.41357027463651	0.0982295451133499	0.0982295451133499	false	false	false	true	false
03837f9a-2956-4eee-a8f2-feb1f12c401f	2026-08-21 15:44	2026-08-21 15:44	2026-08-21 15:44	SPXW	SPXW260828C07850000	call	7850.0000	2026-08-28	2.3500	2.2500	2.4000	7683.0200	118205.00	17625.00	100580.00	503	20	2177	1994	1.09177532597793	0.0938102888097109	0.0938102888097109	false	false	false	true	false
901de014-dfe0-415f-b7fc-7b44d5091823	2026-08-21 15:46	2026-08-21 15:46	2026-08-21 15:46	SPXW	SPXW260824P07690000	put	7690.0000	2026-08-24	20.5000	20.3000	20.6000	7683.2500	102500.00	49200.00	53300.00	50	10	2070	1008	2.05357142857143	0.0656314159137536	0.0656314159137536	false	false	false	true	false
050856c6-1018-48fe-84f4-fcb0634d7f94	2026-08-21 15:48	2026-08-21 15:48	2026-08-21 15:48	SPXW	SPXW260821C07685000	call	7685.0000	2026-08-21	3.3500	3.1000	3.5000	7685.4200	104770.00	74360.00	21100.00	313	178	155690	2194	70.9617137648131	0.202871377076014	0.2173650797869	false	false	false	true	false
4a1af9a9-929d-4e99-a03b-b51fb5138f07	2026-08-21 15:48	2026-08-21 15:48	2026-08-21 15:48	SPXW	SPXW260831P07670000	put	7670.0000	2026-08-31	43.5000	43.4000	43.8000	7685.4200	195750.00	0.00	195750.00	45	6	263	301	0.87375415282392	0.107361109774548	0.107361109774548	false	false	false	true	false
6fe0da68-a3e2-4095-a9c5-6d223217c106	2026-08-21 15:50	2026-08-21 15:50	2026-08-21 15:50	SPXW	SPXW260904P07575000	put	7575.0000	2026-09-04	32.4000	32.4000	32.8000	7682.7700	171720.00	0.00	171720.00	53	6	607	708	0.857344632768362	0.130615239637426	0.130615239637426	false	false	false	true	false
46dc0b6e-b396-4504-9a1b-7356f836e2b3	2026-08-21 15:55	2026-08-21 15:55	2026-08-21 15:55	SPXW	SPXW260821P07680000	put	7680.0000	2026-08-21	5.9100	5.7000	6.1000	7673.6500	264680.00	41960.00	220360.00	448	104	121481	1521	79.8691650230112	0	0	false	false	false	true	false
cafe5dd1-9040-45a0-af26-39e95f795e6a	2026-08-21 15:55	2026-08-21 15:55	2026-08-21 15:55	SPXW	SPXW260821P07675000	put	7675.0000	2026-08-21	2.1800	1.8500	2.4500	7673.3700	316260.00	80540.00	224575.00	1449	550	151147	2161	69.9430819065248	0.138327275926406	0.105041608427553	true	false	false	true	false
5d00fbbf-db59-4b33-b574-c7fddc7bd309	2026-08-21 16:00	2026-08-21 16:00	2026-08-21 16:00	SPXW	SPXW261030C08600000	call	8600.0000	2026-10-30	2.7500	2.6000	2.7500	7674.3000	1375000.00	0.00	0.00	5000	12	5000	884	5.65610859728507	0.116377202989647	0.116377202989647	false	false	false	true	false
02fd5a4a-9ade-4fe4-9852-d42965a9eb64	2026-08-21 16:00	2026-08-21 16:00	2026-08-21 16:00	SPXW	SPXW261030C09000000	call	9000.0000	2026-10-30	0.7000	0.6000	0.8000	7674.3000	350000.00	0.00	0.00	5000	11	5003	7272	0.687981298129813	0.133267171095172	0.133267171095172	false	false	false	true	false
a743e475-da4f-4cfa-8d85-f415445f26bc	2026-08-21 16:01	2026-08-21 16:01	2026-08-21 16:01	SPXW	SPXW260824C07720000	call	7720.0000	2026-08-24	2.9400	2.8500	3.2000	7674.3000	116880.00	45530.00	71350.00	398	25	5687	637	8.92778649921507	0.0583359335835475	0.057699491175655	false	false	false	true	false
d11b0139-0551-4bad-9051-10b8ae143800	2026-08-21 16:02	2026-08-21 16:01	2026-08-21 16:01	SPXW	SPXW260831P07600000	put	7600.0000	2026-08-31	26.9900	26.6000	27.0000	7674.3000	126870.00	126870.00	0.00	47	11	2614	6898	0.378950420411714	0.117556815431922	0.117556815431922	false	false	false	true	false
7b7fd518-e9b7-4089-9c88-245f48a8a70c	2026-08-21 16:02	2026-08-21 16:01	2026-08-21 16:01	SPXW	SPXW260831P07600000	put	7600.0000	2026-08-31	26.8400	26.4000	27.9000	7674.3000	491220.00	318950.00	172270.00	183	31	2567	6898	0.372136851261235	0.116862435706261	0.117094036598295	false	false	false	true	false
5be761e7-0e69-4568-94c8-ababad26bbc3	2026-08-21 16:02	2026-08-21 16:02	2026-08-21 16:02	SPXW	SPXW260831P07600000	put	7600.0000	2026-08-31	26.9300	26.6000	27.0000	7674.3000	102330.00	102330.00	0.00	38	11	2672	6898	0.387358654682517	0.117325496171547	0.117556815431922	false	false	false	true	false
0b0b8184-f4a0-4083-9e19-e7bfaf3cafdb	2026-08-21 16:02	2026-08-21 16:02	2026-08-21 16:02	SPXW	SPXW260831P07600000	put	7600.0000	2026-08-31	26.9800	26.6000	27.5000	7674.3000	167300.00	132200.00	35100.00	62	10	2751	6898	0.398811249637576	0.117556815431922	0.117556815431922	false	false	false	true	false
db9bf95a-3180-4fcd-b9b8-73ca11da027a	2026-08-21 16:05	2026-08-21 16:05	2026-08-21 16:05	SPXW	SPXW260824C07710000	call	7710.0000	2026-08-24	4.5600	4.0000	4.8000	7674.3700	141010.00	4140.00	122450.00	309	39	7639	480	15.9145833333333	0.0581016853504923	0.0570893022440985	false	false	false	true	false
34ee2664-44af-4826-9c45-1be147f5be40	2026-08-21 16:08	2026-08-21 16:07	2026-08-21 16:07	SPXW	SPXW260824C07710000	call	7710.0000	2026-08-24	4.3100	4.2000	4.6000	7674.3700	128540.00	68370.00	60170.00	298	27	7955	480	16.5729166666667	0.056578423211354	0.0560642511499509	false	false	false	true	false
f89154d2-2db7-4a1e-84db-feae7362c2ad	2026-08-21 16:09	2026-08-21 16:09	2026-08-21 16:09	SPXW	SPXW260824C07710000	call	7710.0000	2026-08-24	4.1000	4.0000	4.4000	7674.3700	122860.00	0.00	122860.00	300	37	8281	480	17.2520833333333	0.0555466500734866	0.0545005720941426	false	false	false	true	false
3ef2fec0-e5d0-4afe-9165-091785384719	2026-08-21 16:14	2026-08-21 16:14	2026-08-21 16:14	SPXW	SPXW260824P07635000	put	7635.0000	2026-08-24	5.8000	5.6000	5.9000	7674.3700	145000.00	18560.00	126440.00	250	12	2262	360	6.28333333333333	0.0728382553235972	0.0728382553235972	false	false	false	true	false
b227a27d-e9b1-4270-bbec-af37d8f7318d	2026-08-24 09:31	2026-08-24 09:31	2026-08-24 09:31	SPXW	SPXW260918P07650000	put	7650.0000	2026-09-18	93.1200	93.0000	94.0000	7654.6600	465620.00	0.00	465620.00	50	6	50	5211	0.00959508731529457	0.131870007123839	0.131366448499129	false	false	false	true	false
8e5219c2-d5af-43f3-bfd0-b53b65a69ecc	2026-08-24 09:34	2026-08-24 09:34	2026-08-24 09:34	SPXW	SPXW260825P07650000	put	7650.0000	2026-08-25	19.1000	19.0000	19.2000	7651.2600	105050.00	19100.00	85950.00	55	8	121	1678	0.0721096543504172	0.125894378713954	0.125894378713954	false	false	false	true	false
164ccfc2-1627-41cd-88d0-3c7f97b54475	2026-08-24 09:39	2026-08-24 09:39	2026-08-24 09:39	SPXW	SPXW260828P07615000	put	7615.0000	2026-08-28	29.6800	29.4000	29.8000	7650.6800	124650.00	124650.00	0.00	42	11	68	357	0.19047619047619	0.145791240036018	0.146122929272341	false	false	false	true	false
f1aac8b3-0037-46b0-9381-de5e49018b87	2026-08-24 09:39	2026-08-24 09:39	2026-08-24 09:39	SPXW	SPXW260828C07675000	call	7675.0000	2026-08-28	35.2000	35.1000	35.2000	7650.7500	204160.00	204160.00	0.00	58	7	206	1872	0.110042735042735	0.140471225959503	0.140471225959503	false	false	false	true	false
fb0f6731-5d5b-4e3e-b34d-29b3557c5a33	2026-08-24 09:40	2026-08-24 09:40	2026-08-24 09:40	SPXW	SPXW260828P07670000	put	7670.0000	2026-08-28	50.2600	51.5000	51.9000	7650.5300	2613520.00	0.00	0.00	520	9	531	2068	0.256769825918762	0.130112340927528	0.130112340927528	false	false	false	true	false
cc24d66c-379e-463c-984c-91018156f56e	2026-08-24 09:40	2026-08-24 09:40	2026-08-24 09:40	SPXW	SPXW260828P07690000	put	7690.0000	2026-08-28	60.5500	62.4000	62.6500	7650.5300	4844000.00	0.00	0.00	800	9	857	2939	0.29159578087785	0.124320227428425	0.124320227428425	false	false	false	true	false
3a53fbe9-430e-49ed-9496-4b22f23e603d	2026-08-24 09:40	2026-08-24 09:40	2026-08-24 09:40	SPXW	SPXW260828P07660000	put	7660.0000	2026-08-28	45.6400	46.7000	47.1000	7650.5300	2373280.00	0.00	0.00	520	9	576	2309	0.249458640103941	0.13272988117787	0.13272988117787	false	false	false	true	false
31551af9-1eac-4430-a1fa-aae0cc8c4a3b	2026-08-24 09:40	2026-08-24 09:40	2026-08-24 09:40	SPXW	SPXW260828P07640000	put	7640.0000	2026-08-28	37.1400	38.2000	38.6000	7650.5300	742800.00	0.00	0.00	200	9	232	1388	0.167146974063401	0.136749030292659	0.136749030292659	false	false	false	true	false
a30c96ba-907f-4d97-ba64-2428698cd9c4	2026-08-24 09:41	2026-08-24 09:41	2026-08-24 09:41	SPXW	SPXW260824C07650000	call	7650.0000	2026-08-24	14.2000	14.1000	14.3000	7653.6600	142000.00	109340.00	0.00	100	24	2255	887	2.54227733934611	0.148491600790685	0.148491600790685	false	false	false	true	false
00006476-56a1-49fe-a3b7-47e7b950b3d3	2026-08-24 09:42	2026-08-24 09:42	2026-08-24 09:42	SPXW	SPXW260828C07675000	call	7675.0000	2026-08-28	35.2000	35.0000	35.3000	7651.4700	116160.00	116160.00	0.00	33	5	292	1872	0.155982905982906	0.1394875818246	0.1394875818246	false	false	false	true	false
114916c8-d79d-4a42-8e14-181800bdbc24	2026-08-24 09:42	2026-08-24 09:42	2026-08-24 09:42	SPXW	SPXW260930C08075000	call	8075.0000	2026-09-30	7.6500	7.5000	7.7000	7650.9600	139250.00	71610.00	47880.00	182	9	186	585	0.317948717948718	0.104644676923095	0.104954388667931	false	false	false	true	false
79a7d95e-f777-4357-a483-219e678be7a0	2026-08-24 09:43	2026-08-24 09:43	2026-08-24 09:43	SPXW	SPXW260824P07640000	put	7640.0000	2026-08-24	8.7300	8.5000	8.8000	7645.6300	174640.00	153760.00	0.00	200	29	4181	1978	2.11375126390293	0.139444978053852	0.140695853621411	false	false	false	true	false