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 = 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

cdfdf9f1-7057-446c-8e07-dbbb908e0001	2026-08-21 09:50	2026-08-21 09:50	2026-08-21 09:50	SPXW	SPXW260824P07650000	put	7650.0000	2026-08-24	14.5800	14.3000	14.6000	7670.4200	128320.00	128320.00	0.00	88	19	741	2020	0.366831683168317	0.087414100748135	0.0878013899340617	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T13:52:23.943774Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
d665177e-93c3-4e9d-8b09-9ba72840339b	2026-08-21 09:51	2026-08-21 09:51	2026-08-21 09:51	SPXW	SPXW260821C07680000	call	7680.0000	2026-08-21	6.3000	6.3000	6.4000	7668.9700	109620.00	0.00	109620.00	174	26	7912	1741	4.54451464675474	0.134019323365846	0.134019323365846	false	false	false	true	false
c3c5f5d9-34b3-40c2-80b0-7dba61dcc851	2026-08-21 09:52	2026-08-21 09:52	2026-08-21 09:52	SPXW	SPXW260821C07600000	call	7600.0000	2026-08-21	66.0000	66.0000	66.4000	7665.8100	132000.00	0.00	132000.00	20	10	74	1940	0.0381443298969072	0.172398120292417	0.172402695022148	false	false	false	true	false
bfe0723a-744b-4fff-8e48-e5b30148796e	2026-08-21 09:54	2026-08-21 09:54	2026-08-21 09:54	SPXW	SPXW260824P07650000	put	7650.0000	2026-08-24	17.6100	17.5000	17.9000	7661.5100	264200.00	0.00	264200.00	150	30	994	2020	0.492079207920792	0.086733457596421	0.0859913480279164	false	false	false	true	false
f3485682-a3f0-43f6-9095-fc08f12c810d	2026-08-21 09:56	2026-08-21 09:56	2026-08-21 09:56	SPXW	SPXW260828C07785000	call	7785.0000	2026-08-28	8.7000	8.6000	8.9000	7662.6300	281880.00	171390.00	32190.00	324	11	347	353	0.98300283286119	0.105115145647138	0.105115145647138	false	false	false	true	false
fd5fe3d7-2531-4e24-92c4-173ccd9a3d73	2026-08-21 09:56	2026-08-21 09:56	2026-08-21 09:56	SPXW	SPXW260821P07650000	put	7650.0000	2026-08-21	7.2900	7.1000	7.4000	7662.3600	123860.00	118750.00	4380.00	170	64	9773	3444	2.8376887340302	0.155427823095891	0.156779352777676	false	false	false	true	false
5c0f901c-414d-4674-938b-b699e33060f8	2026-08-21 09:57	2026-08-21 09:57	2026-08-21 09:57	SPXW	SPXW260821P07655000	put	7655.0000	2026-08-21	8.2500	8.1000	8.4000	7663.9200	146830.00	146010.00	0.00	178	66	6070	1433	4.23586880669923	0.152313367682613	0.152313367682613	false	false	false	true	false
2b2f0c94-7c1a-49d7-b451-fdca9e6f32b1	2026-08-21 10:02	2026-08-21 10:02	2026-08-21 10:02	SPXW	SPXW260824C07700000	call	7700.0000	2026-08-24	7.8000	7.6000	7.9000	7666.1800	194960.00	57720.00	134160.00	250	21	724	2042	0.354554358472086	0.070243676105919	0.0706854505771987	false	false	false	true	false
479b3102-d67a-4aed-b7dc-4f3980ea451d	2026-08-21 10:03	2026-08-21 10:03	2026-08-21 10:03	SPXW	SPXW260825C07675000	call	7675.0000	2026-08-25	23.2000	23.1000	23.4000	7664.4100	213440.00	106720.00	106720.00	92	14	182	576	0.315972222222222	0.0834822772634495	0.0834822772634495	false	false	false	true	false
79eb561a-dd0f-4d3d-b425-d1261e564ac5	2026-08-21 10:06	2026-08-21 10:06	2026-08-21 10:06	SPXW	SPXW260821P07650000	put	7650.0000	2026-08-21	4.2100	4.1000	4.4000	7672.0300	105190.00	8400.00	88620.00	250	29	13689	3444	3.97473867595819	0.15595349005517	0.154317557695736	false	false	false	true	false
78668786-bdb4-40f6-8b7d-1fdff250def4	2026-08-21 10:06	2026-08-21 10:06	2026-08-21 10:06	SPXW	SPXW260825P07670000	put	7670.0000	2026-08-25	26.0000	25.7000	26.0000	7673.9600	119580.00	119580.00	0.00	46	12	158	422	0.374407582938389	0.0915844587991462	0.0915844587991462	false	false	false	true	false
004a89da-7d44-4009-b7dc-94108e4f00cb	2026-08-21 10:10	2026-08-21 10:10	2026-08-21 10:10	SPXW	SPXW260825P07670000	put	7670.0000	2026-08-25	26.9600	26.9000	27.3000	7670.6200	272280.00	0.00	272280.00	101	20	337	422	0.798578199052133	0.090445202581349	0.0898198544670946	false	false	false	true	false
3aad5876-4052-4325-84e5-869ce91c1336	2026-08-21 10:13	2026-08-21 10:13	2026-08-21 10:13	SPXW	SPXW260821C07680000	call	7680.0000	2026-08-21	5.2000	5.2000	5.3000	7668.2100	123240.00	0.00	123240.00	237	20	16172	1741	9.28891441700172	0.126430816154438	0.126433897175517	false	false	false	true	false
93aa5169-e4c9-49f0-bb6f-dbb82093bb68	2026-08-21 10:13	2026-08-21 10:13	2026-08-21 10:13	SPXW	SPXW260821C07630000	call	7630.0000	2026-08-21	38.6800	38.4000	38.8000	7666.6200	193420.00	193420.00	0.00	50	6	426	351	1.21367521367521	0.15800172947522	0.160554065057662	false	false	false	true	false
e696ddb9-a290-4a4e-9466-a87361aacc7e	2026-08-21 10:20	2026-08-21 10:20	2026-08-21 10:20	SPXW	SPXW260821P07705000	put	7705.0000	2026-08-21	41.1000	40.7000	41.1000	7664.2800	411000.00	411000.00	0.00	100	5	1464	1283	1.141075604053	0.128759866705238	0.128759866705238	false	false	false	true	false
437b9652-93ae-44b4-9a54-c8f931b76171	2026-08-21 10:22	2026-08-21 10:21	2026-08-21 10:21	SPXW	SPXW260821P07705000	put	7705.0000	2026-08-21	41.0000	41.0000	41.2000	7663.7800	282900.00	0.00	282900.00	69	18	1567	1283	1.22135619641465	0.104700979576284	0.0920730905112432	false	false	false	true	false
72914888-0bce-4ca2-95e4-e2a7270cbfc7	2026-08-21 10:22	2026-08-21 10:22	2026-08-21 10:22	SPXW	SPXW260821C07670000	call	7670.0000	2026-08-21	9.6500	9.4000	9.7000	7667.4900	101330.00	96630.00	4700.00	105	18	18620	976	19.077868852459	0.135734821163205	0.138325010225348	false	false	false	true	false
7f15f19b-3b8f-47ae-9545-5c395e1a0ea0	2026-08-21 10:36	2026-08-21 10:36	2026-08-21 10:36	SPXW	SPXW260821P07660000	put	7660.0000	2026-08-21	9.3200	9.1000	9.4000	7661.5700	188280.00	188280.00	0.00	202	42	19363	1346	14.3855869242199	0.132564475489521	0.135208726874602	true	false	false	true	false
747652fa-1444-4f24-ad7d-58120ec0f745	2026-08-21 10:39	2026-08-21 10:39	2026-08-21 10:39	SPXW	SPXW260828C07675000	call	7675.0000	2026-08-28	46.1200	46.0000	46.4000	7663.9100	285970.00	0.00	285970.00	62	10	381	620	0.614516129032258	0.115450619039726	0.11521428137401	false	false	false	true	false
9e95cd48-a462-429c-a941-376c3f1dc0c2	2026-08-21 10:43	2026-08-21 10:43	2026-08-21 10:43	SPXW	SPXW260821C07660000	call	7660.0000	2026-08-21	12.5000	12.4000	12.7000	7664.4800	104960.00	78750.00	26210.00	84	17	9819	1554	6.31853281853282	0.132513054259398	0.133324339057152	false	false	false	true	false
25b72759-3ebd-45cf-8c16-2dc72a11a1fa	2026-08-21 10:44	2026-08-21 10:44	2026-08-21 10:44	SPXW	SPXW260824P07600000	put	7600.0000	2026-08-24	5.4000	5.3000	5.6000	7664.5000	108000.00	64260.00	43740.00	200	16	1155	4296	0.268854748603352	0.0956319421147371	0.0956319421147371	false	false	false	true	false
aed3fb6b-09a1-415c-a920-14ba1ff0f628	2026-08-21 10:45	2026-08-21 10:45	2026-08-21 10:45	SPXW	SPXW260821P07660000	put	7660.0000	2026-08-21	7.5000	7.5000	7.6000	7665.2900	108000.00	0.00	108000.00	144	12	23065	1346	17.1359583952452	0.133668858785676	0.133668858785676	false	false	false	true	false
87db327a-23a9-4415-b17a-c2ba33ba75c9	2026-08-21 10:47	2026-08-21 10:47	2026-08-21 10:47	SPXW	SPXW260821P07690000	put	7690.0000	2026-08-21	24.9000	24.8000	25.0000	7667.7200	104580.00	2490.00	49800.00	42	8	1695	1257	1.34844868735084	0.137541965820053	0.137541965820053	false	false	false	true	false
6d6458d6-a597-4734-a578-0a5264f2de2f	2026-08-21 10:47	2026-08-21 10:47	2026-08-21 10:47	SPXW	SPXW260821P07660000	put	7660.0000	2026-08-21	6.6400	6.6000	6.8000	7667.8100	132780.00	0.00	132780.00	200	37	24121	1346	17.9205052005944	0.136716869627102	0.136716869627102	false	false	false	true	false
8b097b00-143f-4df9-8e88-e8b2a925c004	2026-08-21 10:51	2026-08-21 10:51	2026-08-21 10:51	SPXW	SPXW260918P07600000	put	7600.0000	2026-09-18	75.2000	74.2000	74.6000	7669.1300	955040.00	0.00	0.00	127	5	154	3259	0.0472537588217245	0.136670532473324	0.136670532473324	false	false	false	true	false
88a4a837-d5cf-47ea-9b2a-e6c98b312753	2026-08-21 10:51	2026-08-21 10:51	2026-08-21 10:51	SPXW	SPXW260918C07785000	call	7785.0000	2026-09-18	54.6000	55.2000	55.5000	7669.1300	1244880.00	0.00	0.00	228	5	230	105	2.19047619047619	0.110192145779413	0.110192145779413	false	false	false	true	false
88a3f46e-52a4-42ca-8d7d-3b47524e87ed	2026-08-21 10:51	2026-08-21 10:51	2026-08-21 10:51	SPXW	SPXW260917P07300000	put	7300.0000	2026-09-17	25.0000	24.7000	25.1000	7669.1300	275000.00	0.00	0.00	110	5	110	168	0.654761904761905	0.175855231644235	0.175855231644235	false	false	false	true	false
7ee30bc8-a855-4d24-8bc3-ff437da4e44b	2026-08-21 10:51	2026-08-21 10:51	2026-08-21 10:51	SPXW	SPXW260918P07275000	put	7275.0000	2026-09-18	24.8000	24.3000	24.6000	7669.1300	314960.00	0.00	0.00	127	5	143	421	0.339667458432304	0.1802765982404	0.1802765982404	false	false	false	true	false
6b55d27a-d3ec-47a4-94c9-d47bc520d674	2026-08-21 10:51	2026-08-21 10:51	2026-08-21 10:51	SPXW	SPXW260917P07575000	put	7575.0000	2026-09-17	66.5000	65.4000	66.0000	7669.1300	731500.00	0.00	0.00	110	5	113	79	1.43037974683544	0.139393887681363	0.139393887681363	false	false	false	true	false
56471a92-36f1-4295-95c2-5e308a3fb38a	2026-08-21 10:51	2026-08-21 10:51	2026-08-21 10:51	SPXW	SPXW260918C07885000	call	7885.0000	2026-09-18	24.4000	24.6000	24.9000	7669.1300	134200.00	0.00	0.00	55	5	58	64	0.90625	0.104593300815725	0.104593300815725	false	false	false	true	false
1608d897-4e08-4517-948c-1fd49241128c	2026-08-21 10:51	2026-08-21 10:51	2026-08-21 10:51	SPXW	SPXW260917C07825000	call	7825.0000	2026-09-17	36.9000	37.3000	37.7000	7669.1300	730620.00	0.00	0.00	198	5	201	101	1.99009900990099	0.105012941886727	0.105012941886727	false	false	false	true	false
a32752ad-3a42-4561-a288-59bfb37318ae	2026-08-21 10:55	2026-08-21 10:55	2026-08-21 10:55	SPXW	SPXW260824P07665000	put	7665.0000	2026-08-24	18.5000	18.3000	18.6000	7668.7800	185000.00	99900.00	85100.00	100	10	1518	615	2.46829268292683	0.0773503392864691	0.0773503392864691	false	false	false	true	false
59147527-8fd8-4272-a476-50c14ddb3c73	2026-08-21 10:56	2026-08-21 10:56	2026-08-21 10:56	SPXW	SPXW260821C07670000	call	7670.0000	2026-08-21	10.6300	10.4000	10.8000	7671.5900	354130.00	343690.00	8320.00	333	80	30196	976	30.9385245901639	0.129174822097685	0.134480493619438	false	false	false	true	false
a728f307-8e20-4846-a621-c6afbe5b67db	2026-08-21 10:57	2026-08-21 10:57	2026-08-21 10:57	SPXW	SPXW260821C07670000	call	7670.0000	2026-08-21	11.6000	11.5000	11.8000	7673.7800	258680.00	207640.00	51040.00	223	21	31425	976	32.1977459016393	0.129232867014763	0.129236494287584	false	false	false	true	false
4edaeeca-df7c-4832-9cdb-5c9001a2066b	2026-08-21 10:58	2026-08-21 10:57	2026-08-21 10:57	SPXW	SPXW260904P07500000	put	7500.0000	2026-09-04	23.8000	23.5000	23.8000	7673.9700	238000.00	238000.00	0.00	100	11	174	5855	0.0297181895815542	0.146215286632288	0.146215286632288	false	false	false	true	false
3c7da142-d59f-418f-b357-1b63bfff298a	2026-08-21 10:58	2026-08-21 10:58	2026-08-21 10:58	SPXW	SPXW260904C07850000	call	7850.0000	2026-09-04	10.3000	10.1000	10.4000	7673.5100	103000.00	88580.00	14420.00	100	11	143	1971	0.0725520040588534	0.098799117932754	0.098799117932754	false	false	false	true	false
53c19a25-9bf2-4898-93ca-83b39d106e58	2026-08-21 11:00	2026-08-21 11:00	2026-08-21 11:00	SPXW	SPXW260821C07690000	call	7690.0000	2026-08-21	3.6000	3.5000	3.7000	7676.5800	108360.00	108000.00	0.00	301	5	27698	2301	12.0373750543242	0.118353181375765	0.118353181375765	false	false	false	true	false
28085ce6-0bb2-45ea-a517-984c661c1579	2026-08-21 11:00	2026-08-21 11:00	2026-08-21 11:00	SPXW	SPXW260821C07655000	call	7655.0000	2026-08-21	25.0000	24.9000	25.3000	7677.6800	187500.00	0.00	187500.00	75	14	4019	705	5.70070921985816	0.132611874611236	0.132611874611236	false	false	false	true	false
352ccc6b-10c2-4f59-b5b2-9ea8f6a563ce	2026-08-21 11:03	2026-08-21 11:03	2026-08-21 11:03	SPXW	SPXW260821P07710000	put	7710.0000	2026-08-21	34.5500	34.0000	34.6000	7676.1400	103650.00	103650.00	0.00	30	6	451	990	0.455555555555556	0.128752906031062	0.132462428870326	true	false	false	true	false
6e5da687-cca8-44e4-b533-0a67b9899e08	2026-08-21 11:04	2026-08-21 11:04	2026-08-21 11:04	SPXW	SPXW260821P07670000	put	7670.0000	2026-08-21	5.0000	5.0000	5.1000	7680.1500	119500.00	0.00	119500.00	239	39	25823	1623	15.9106592729513	0.127548917610154	0.127548917610154	false	false	false	true	false
59fd8b48-15ba-44f0-b19d-e6be28c142e8	2026-08-21 11:07	2026-08-21 11:07	2026-08-21 11:07	SPXW	SPXW260821C07680000	call	7680.0000	2026-08-21	9.5100	9.5000	9.7000	7680.4200	118930.00	0.00	110290.00	125	29	39049	1741	22.4290637564618	0.128659676169128	0.127276661229252	true	false	false	true	false
f160fe0a-a94f-4eb2-90d1-40428b9e9e19	2026-08-21 11:07	2026-08-21 11:07	2026-08-21 11:07	SPXW	SPXW260824P07680000	put	7680.0000	2026-08-24	20.2000	20.0000	20.3000	7679.9300	111100.00	64640.00	0.00	55	7	553	503	1.09940357852883	0.0770261700111331	0.0768528414364637	false	false	false	true	false
75674970-4d0b-45be-8236-54b67a1f93c0	2026-08-21 11:09	2026-08-21 11:09	2026-08-21 11:09	SPXW	SPXW260821C07670000	call	7670.0000	2026-08-21	13.4600	13.3000	13.8000	7677.9400	409280.00	139360.00	264440.00	304	36	35531	976	36.4047131147541	0.126147523389792	0.121696959765967	false	false	false	true	false
1920d23a-188a-4ac6-bd03-7c5ca23a0e63	2026-08-21 11:14	2026-08-21 11:14	2026-08-21 11:14	SPXW	SPXW260821C07670000	call	7670.0000	2026-08-21	12.3000	12.1000	12.4000	7675.7300	109470.00	34440.00	73800.00	89	14	36430	976	37.3258196721311	0.126924707776606	0.126924707776606	false	false	false	true	false
f8760ac6-3e75-4c64-9020-4043e7b148ae	2026-08-21 11:15	2026-08-21 11:15	2026-08-21 11:15	SPXW	SPXW260821C07670000	call	7670.0000	2026-08-21	12.1000	11.9000	12.2000	7675.2000	107690.00	64130.00	43560.00	89	10	36552	976	37.4508196721311	0.128720840230447	0.128720840230447	false	false	false	true	false
6ea5d44b-2272-4fb8-9b85-717cd74557fa	2026-08-21 11:15	2026-08-21 11:15	2026-08-21 11:15	SPXW	SPXW260821C07670000	call	7670.0000	2026-08-21	13.5100	13.4000	13.7000	7676.9800	118910.00	51300.00	60810.00	88	14	36699	976	37.6014344262295	0.134928344406975	0.133460971776602	false	false	false	true	false
f0f73d21-fd7d-45cd-9b20-7151d3baacda	2026-08-21 11:15	2026-08-21 11:15	2026-08-21 11:15	SPXW	SPXW260821C07670000	call	7670.0000	2026-08-21	12.5000	12.4000	12.7000	7675.8600	125000.00	107500.00	17500.00	100	6	36916	976	37.8237704918033	0.128957471257629	0.128957471257629	false	false	false	true	false
f2dd0c1a-1480-4d67-8105-0a4cae43010d	2026-08-21 11:16	2026-08-21 11:16	2026-08-21 11:16	SPXW	SPXW260821P07710000	put	7710.0000	2026-08-21	34.7400	34.6000	35.3000	7675.3800	104230.00	0.00	104230.00	30	5	561	990	0.566666666666667	0.111510923295893	0.111510923295893	false	false	false	true	false
41d71371-7e2b-4a09-84e1-b1baf4abef51	2026-08-21 11:28	2026-08-21 11:27	2026-08-21 11:27	SPXW	SPXW260821C07680000	call	7680.0000	2026-08-21	6.3000	6.2000	6.4000	7677.2900	123480.00	108360.00	0.00	196	34	47326	1741	27.1832280298679	0.107765017738814	0.107765017738814	true	false	false	true	false
a5265766-ae0d-4a07-b922-ce56370f004a	2026-08-21 11:30	2026-08-21 11:30	2026-08-21 11:30	SPXW	SPXW260831P07600000	put	7600.0000	2026-08-31	26.6000	26.4000	26.7000	7677.5900	119700.00	119700.00	0.00	45	5	1800	6898	0.260945201507683	0.118797156661873	0.118797156661873	false	false	false	true	false