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

607f40ee-e8fe-497a-a6cf-28d232eb534d	2026-09-18 16:00	2026-09-18 16:00	2026-09-18 16:00	SPX	SPX261120P06000000	put	6000.0000	2026-11-20	10.3500	10.2000	10.5000	7630.0000	488520.00	0.00	0.00	472	6	690	16266	0.0424197713021025	0.319718193532141	0.319718193532141	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
2d953a96-66c0-4592-93eb-e2b72cd1f55e	2026-09-18 16:00	2026-09-18 16:00	2026-09-18 16:00	SPX	SPX261218P07600000	put	7600.0000	2026-12-18	166.4300	165.3000	166.3000	7630.0000	4526896.00	0.00	0.00	272	6	1538	31553	0.0487433841473077	0.149234324446874	0.149234324446874	false	false	false	true	false
0753e4bd-b71c-481f-906f-34283f7ea20e	2026-09-18 16:00	2026-09-18 16:00	2026-09-18 16:00	SPX	SPX261016P07200000	put	7200.0000	2026-10-16	18.1400	17.8000	18.2000	7630.0000	428104.00	0.00	0.00	236	6	1811	21086	0.0858863701033861	0.181374134536944	0.181374134536944	false	false	false	true	false
3918ccf6-3d4e-4b5c-be9b-6e81315228db	2026-09-18 15:59	2026-09-18 15:59	2026-09-18 15:59	SPX	SPX261016C07700000	call	7700.0000	2026-10-16	79.4700	79.0000	79.6000	7625.0000	333790.00	294060.00	39730.00	42	31	4102	18831	0.217832297806808	0.10985862773905	0.109924655765105	false	false	false	true	false
4abfefd9-c06c-4476-b605-130afa87bdbd	2026-09-18 15:58	2026-09-18 15:58	2026-09-18 15:58	SPX	SPX270617C08550000	call	8550.0000	2027-06-17	126.9000	125.8000	126.9000	7625.0000	101520.00	101520.00	0.00	8	6	333	2953	0.112766677954622	0.13007089186646	0.13007089186646	false	false	false	true	false
3cefef8d-1ff4-467f-bb38-f12f327aefb0	2026-09-18 15:58	2026-09-18 15:58	2026-09-18 15:58	SPX	SPX270617C08550000	call	8550.0000	2027-06-17	127.0000	126.0000	127.0000	7625.0000	127000.00	127000.00	0.00	10	5	325	2953	0.110057568574331	0.130048596505466	0.130048596505466	false	false	false	true	false
b4631a8d-d367-4c0d-bd8e-697271235101	2026-09-18 15:56	2026-09-18 15:56	2026-09-18 15:56	SPX	SPX261218P07410000	put	7410.0000	2026-12-18	119.0000	118.7000	119.4000	7625.0000	595000.00	523600.00	71400.00	50	7	75	150	0.5	0.164142669400633	0.164142669400633	false	false	false	true	false
d7f1b70c-f878-4340-ab7a-32fb932b9fc0	2026-09-18 15:56	2026-09-18 15:56	2026-09-18 15:56	SPX	SPX270617C08550000	call	8550.0000	2027-06-17	126.7000	125.9000	126.7000	7625.0000	266070.00	266070.00	0.00	21	5	110	2953	0.0372502539790044	0.129913051377627	0.129913051377627	false	false	false	true	false
a0bd5d0b-3b47-43e7-a735-52bc01fe4bcb	2026-09-18 15:56	2026-09-18 15:55	2026-09-18 15:55	SPX	SPX270617C08550000	call	8550.0000	2027-06-17	126.8000	126.6000	127.0000	7625.0000	240920.00	114120.00	88760.00	19	8	85	2953	0.0287842871655943	0.129901686880123	0.129901686880123	false	false	false	true	false
e3579fb8-116f-4045-bb7d-2a4f6e948b29	2026-09-18 15:55	2026-09-18 15:55	2026-09-18 15:55	SPX	SPX270617C08550000	call	8550.0000	2027-06-17	127.3000	127.0000	127.5000	7630.0000	280050.00	229140.00	38190.00	22	8	42	2953	0.014222824246529	0.129892924865483	0.129846209224361	false	false	false	true	false
a9272f34-f429-409c-971b-6046cdc1672b	2026-09-18 15:55	2026-09-18 15:55	2026-09-18 15:55	SPX	SPX270617C08550000	call	8550.0000	2027-06-17	127.7000	126.5000	127.7000	7630.0000	242630.00	242630.00	0.00	19	6	20	2953	0.00677277345072807	0.129836853327866	0.129836853327866	false	false	false	true	false
61be308b-06c7-407b-9543-96cf48555892	2026-09-18 15:50	2026-09-18 15:50	2026-09-18 15:50	SPX	SPX261120P07365000	put	7365.0000	2026-11-20	78.6000	78.6000	79.3000	7643.0800	117900.00	0.00	117900.00	15	5	100	447	0.223713646532438	0.1632621881538	0.1632621881538	false	false	false	true	false
4a2519a4-a920-414a-8ad0-301c25496453	2026-09-18 15:49	2026-09-18 15:48	2026-09-18 15:48	SPX	SPX270617C08600000	call	8600.0000	2027-06-17	114.2000	114.0000	114.7000	7646.0300	205560.00	0.00	205560.00	18	5	178	8921	0.0199529200762246	0.129027362871032	0.129027362871032	false	false	false	true	false
c5579d0c-5690-4e72-9ab7-ddf218fee2fd	2026-09-18 15:29	2026-09-18 15:29	2026-09-18 15:29	SPX	SPX270917C08700000	call	8700.0000	2027-09-17	170.6000	170.2000	172.1000	7638.9600	3412000.00	1791300.00	1620700.00	200	8	504	1877	0.268513585508791	0.135293866007251	0.135293866007251	false	false	false	true	false
a27fdf19-3a8a-4b52-88f0-86bc8e6174a5	2026-09-18 15:28	2026-09-18 15:28	2026-09-18 15:28	SPX	SPX261218P07500000	put	7500.0000	2026-12-18	140.9900	141.4000	141.9000	7640.3200	4229700.00	0.00	0.00	300	5	1549	33169	0.0467002321444722	0.156299823359946	0.156299823359946	false	false	false	true	false
64564137-f31f-4e0c-b153-92d323a28dfb	2026-09-18 15:28	2026-09-18 15:28	2026-09-18 15:28	SPX	SPX270319P07500000	put	7500.0000	2027-03-19	220.8900	221.5000	222.1000	7640.3200	6626700.00	0.00	0.00	300	5	811	12739	0.0636627678781694	0.16690316263968	0.16690316263968	false	false	false	true	false
f12a0f22-d23a-4a94-8cc8-cbbaa0f87d1a	2026-09-18 15:11	2026-09-18 15:11	2026-09-18 15:11	SPX	SPX271217P06800000	put	6800.0000	2027-12-17	233.8000	233.1000	234.3000	7641.7800	2922500.00	0.00	0.00	125	6	129	6486	0.0198889916743756	0.217540722821685	0.217540722821685	false	false	false	true	false
e68c8612-fa16-4cfe-a54c-648e9a2118d2	2026-09-18 15:11	2026-09-18 15:11	2026-09-18 15:11	SPX	SPX261218C07700000	call	7700.0000	2026-12-18	213.0000	213.2000	213.9000	7641.7800	1278000.00	0.00	0.00	60	6	21889	56437	0.387848397327994	0.132605309016338	0.132605309016338	false	false	false	true	false
1addfd05-6f08-459e-8f6e-7aa92f014588	2026-09-18 15:08	2026-09-18 15:08	2026-09-18 15:08	SPX	SPX261218P06100000	put	6100.0000	2026-12-18	21.3000	20.9000	21.5000	7641.6100	764670.00	764670.00	0.00	359	7	413	14395	0.0286905175408128	0.289991544045486	0.289991544045486	false	false	false	true	false
fb2aad74-ab74-4bda-a10e-a26ff14ddd40	2026-09-18 15:04	2026-09-18 15:04	2026-09-18 15:04	SPX	SPX261218C07705000	call	7705.0000	2026-12-18	210.0000	211.1000	212.0000	7643.6300	15330000.00	0.00	0.00	730	5	1277	6682	0.191110445974259	0.131624479838279	0.131624479838279	false	false	false	true	false
c8bb7f9c-6b9d-4a35-b1be-6d84ed51604e	2026-09-18 15:04	2026-09-18 15:04	2026-09-18 15:04	SPX	SPX270820P07500000	put	7500.0000	2027-08-20	325.5700	324.1000	325.3000	7643.6300	16278500.00	0.00	0.00	500	5	763	1032	0.739341085271318	0.182077187943676	0.182077187943676	false	false	false	true	false
a1e126d7-ac78-424f-919a-d5a8f672c6ea	2026-09-18 15:04	2026-09-18 15:04	2026-09-18 15:04	SPX	SPX270319P06800000	put	6800.0000	2027-03-19	102.8600	102.2000	102.8000	7643.6300	12857500.00	0.00	0.00	1250	5	2110	15108	0.139661106698438	0.212901615328092	0.212901615328092	false	false	false	true	false
66447fb4-55e2-4281-8741-00bb8f17116c	2026-09-18 15:04	2026-09-18 15:04	2026-09-18 15:04	SPX	SPX261218P07705000	put	7705.0000	2026-12-18	207.0000	205.3000	206.0000	7643.6300	15111000.00	0.00	0.00	730	7	1275	6729	0.189478377173428	0.142462753776191	0.142462753776191	false	false	false	true	false
3676cb32-c9f0-4c2a-a483-0955d496a381	2026-09-18 15:04	2026-09-18 15:04	2026-09-18 15:04	SPX	SPX270319C08200000	call	8200.0000	2027-03-19	127.2400	127.7000	128.2000	7643.6300	15905000.00	0.00	0.00	1250	7	1480	9397	0.157497073534107	0.125231093201142	0.125231093201142	false	false	false	true	false
2c35aa16-53f2-41dd-97f9-7c5eb9dfa298	2026-09-18 15:00	2026-09-18 15:00	2026-09-18 15:00	SPX	SPX270115C08200000	call	8200.0000	2027-01-15	58.2000	58.2000	58.9000	7642.1700	116400.00	0.00	116400.00	20	7	83	9796	0.00847284605961617	0.117215587514614	0.117215587514614	false	false	false	true	false
ee131951-1930-499d-8310-6e0f4c7630e2	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261218P07800000	put	7800.0000	2026-12-18	248.0000	247.1000	248.0000	7642.9100	793600.00	0.00	0.00	32	6	695	12491	0.0556400608438075	0.136115149398444	0.136115149398444	false	false	false	true	false
e5f01d0c-66f3-4b9b-81d4-0e7b8d6f612b	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261218P07705000	put	7705.0000	2026-12-18	206.0000	205.6000	206.5000	7642.9100	185400.00	0.00	0.00	9	5	545	6729	0.0809927180858969	0.141580629117224	0.141580629117224	false	false	false	true	false
e1d35413-3d75-4ef9-bbb9-4e0a7c648540	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261016C07900000	call	7900.0000	2026-10-16	14.0000	14.2000	14.6000	7642.9100	442400.00	0.00	0.00	316	6	2715	18533	0.146495440565478	0.0974389428718924	0.0974389428718924	false	false	false	true	false
e13fbec7-01ef-42c7-91b2-9a3e5685a4ef	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261120P07600000	put	7600.0000	2026-11-20	135.0000	134.3000	135.1000	7642.9100	1188000.00	0.00	0.00	88	6	102	11509	0.00886262924667651	0.142420171172003	0.142420171172003	false	false	false	true	false
c93b46be-ad48-41ed-b177-306dbb57e80e	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261016C07700000	call	7700.0000	2026-10-16	77.9000	78.2000	78.8000	7642.9100	1776120.00	0.00	0.00	228	6	3928	18831	0.208592214964686	0.11080445840841	0.11080445840841	false	false	false	true	false
c7720308-615d-4777-81a4-47034aac2e9c	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261016C07800000	call	7800.0000	2026-10-16	36.5000	36.3000	36.9000	7642.9100	233600.00	0.00	0.00	64	6	1466	24513	0.0598050014278138	0.102705461295167	0.102705461295167	false	false	false	true	false
c385a47d-5533-476e-8939-44281acceb9b	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261016P06300000	put	6300.0000	2026-10-16	3.4000	3.4000	3.6000	7642.9100	201280.00	0.00	0.00	592	6	1128	7819	0.144263972374984	0.327503903957178	0.327503903957178	false	false	false	true	false
c173653a-ca31-4528-bba6-5d66baf5768d	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261016P07600000	put	7600.0000	2026-10-16	76.0000	75.6000	76.3000	7642.9100	1672000.00	0.00	0.00	220	6	5404	15459	0.349569829872566	0.125768326947089	0.125768326947089	false	false	false	true	false
acb43536-1f17-47b4-b86a-164e401b9768	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261016P07500000	put	7500.0000	2026-10-16	51.5000	51.0000	51.7000	7642.9100	1071200.00	0.00	0.00	208	6	5442	24359	0.22340818588612	0.138896436023833	0.138896436023833	false	false	false	true	false
a570d29c-3834-429a-9ba4-2791da081e48	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261218P07000000	put	7000.0000	2026-12-18	63.5000	63.2000	63.8000	7642.9100	762000.00	0.00	0.00	120	6	22354	293777	0.0760917294410386	0.201478402212967	0.201478402212967	false	false	false	true	false
9eb30b83-a9ad-4a33-80b7-2b2005fdef1e	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261120C07600000	call	7600.0000	2026-11-20	223.5000	223.4000	224.1000	7642.9100	894000.00	0.00	0.00	40	6	49	5454	0.00898423175650898	0.135690461300224	0.135690461300224	false	false	false	true	false
960b7be9-582a-45dc-b859-38969c9eab8c	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261120P07100000	put	7100.0000	2026-11-20	47.5000	47.3000	47.8000	7642.9100	266000.00	0.00	0.00	56	6	653	11807	0.0553061743033793	0.191898919686563	0.191898919686563	false	false	false	true	false
7e75219f-a700-46c1-865c-bde73cbf8391	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX270115P05400000	put	5400.0000	2027-01-15	15.9000	15.9000	16.2000	7642.9100	419760.00	0.00	0.00	264	6	266	5168	0.0514705882352941	0.343031443818162	0.343031443818162	false	false	false	true	false
61659228-2040-4d51-8140-c7bdb1c810ad	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261120P07200000	put	7200.0000	2026-11-20	57.5000	57.0000	57.6000	7642.9100	437000.00	0.00	0.00	76	6	747	14839	0.0503403194285329	0.181615216938961	0.181615216938961	false	false	false	true	false
5572fb81-d383-46b5-ae0c-e51d8792315e	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261218P07700000	put	7700.0000	2026-12-18	204.0000	203.6000	204.5000	7642.9100	326400.00	0.00	0.00	16	6	21677	52562	0.412408203645219	0.141887634489606	0.141887634489606	false	false	false	true	false
4ea1d442-a40d-4793-a87a-324e9ff802ab	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261120P07800000	put	7800.0000	2026-11-20	218.0000	217.4000	218.5000	7642.9100	1744000.00	0.00	0.00	80	6	86	3281	0.0262115208777812	0.127075962261988	0.127075962261988	false	false	false	true	false
3eccb8b3-3d97-4472-b572-8c85cc4951c4	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX270115C08100000	call	8100.0000	2027-01-15	82.9000	83.1000	84.0000	7642.9100	596880.00	0.00	0.00	72	6	96	4437	0.0216362407031778	0.119479853247085	0.119479853247085	false	false	false	true	false
13e92297-9753-4b1d-9cd6-c998f7ea344a	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261218P07100000	put	7100.0000	2026-12-18	73.5000	73.1000	73.8000	7642.9100	823200.00	0.00	0.00	112	6	908	23723	0.0382750916831767	0.192189799575028	0.192189799575028	false	false	false	true	false
11cc47ec-a247-41e2-85c1-3b7ecc08c656	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261218C07705000	call	7705.0000	2026-12-18	211.0000	210.9000	211.8000	7642.9100	189900.00	0.00	0.00	9	5	547	6682	0.0818617180484885	0.132533384918009	0.132533384918009	false	false	false	true	false
088ed6e9-f0b1-4ab6-b34b-493018d8a096	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261016P07400000	put	7400.0000	2026-10-16	35.6000	35.4000	35.9000	7642.9100	2121760.00	0.00	0.00	596	6	3156	19375	0.162890322580645	0.152310134166618	0.152310134166618	false	false	false	true	false
f1aafd43-505c-4ee4-a176-d7cd8873611d	2026-09-18 14:55	2026-09-18 14:55	2026-09-18 14:55	SPX	SPX261120P07355000	put	7355.0000	2026-11-20	77.7000	77.7000	78.4000	7643.5500	116550.00	0.00	116550.00	15	6	134	494	0.271255060728745	0.165127412590797	0.165127412590797	false	false	false	true	false
3b7400a6-6255-4e2f-8624-0c647952f98b	2026-09-18 14:49	2026-09-18 14:49	2026-09-18 14:49	SPX	SPX261016C07800000	call	7800.0000	2026-10-16	36.5000	35.8000	36.6000	7643.1100	365000.00	365000.00	0.00	100	8	1389	24513	0.0566638110390405	0.102627401098976	0.102627401098976	false	false	false	true	false
dbc1e536-e47b-4d1e-9177-e78672561a8c	2026-09-18 14:44	2026-09-18 14:44	2026-09-18 14:44	SPX	SPX261218C08000000	call	8000.0000	2026-12-18	74.6500	74.6000	75.3000	7635.1600	4620835.00	0.00	4620835.00	619	2	18666	268395	0.0695467501257475	0.1172631069668	0.1172631069668	false	true	false	true	false
f7227045-8a43-4618-b35b-5bbad52db632	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	SPX	SPX270820C10000000	call	10000.0000	2027-08-20	11.5000	11.2000	11.7000	7633.7900	148350.00	17250.00	131100.00	129	5	129	418	0.308612440191388	0.126047996221302	0.126047996221302	false	false	false	true	false
fc901fc5-5776-4be1-a14c-1e69bab95479	2026-09-18 14:17	2026-09-18 14:16	2026-09-18 14:16	SPX	SPX270917P06025000	put	6025.0000	2027-09-17	109.8000	109.7000	110.3000	7630.3500	1328580.00	581940.00	746640.00	121	5	351	82	4.28048780487805	0.251113572866551	0.251113572866551	false	false	false	true	false