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:alert_rule = RepeatedHitsAscendingFill×ticker = SPX×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	expiry

4d8530eb-39cd-4633-8874-f4978fa36a6d	2026-08-14 16:36	2026-08-14 16:24	2026-08-14 16:24	SPX	SPX260918C08000000	call	8000.0000	2026-09-18	35.1100	33.7000	37.7000	7785.7600	200100.00	0.00	200100.00	57	5	1679	266469	0.00630092055736315	0.10470585638541	0.105106293312822	false	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-17T13:32:33.788843Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e4e47d72-e997-40f7-b586-c908b9ad73b7	2026-08-17 09:56	2026-08-17 09:55	2026-08-17 09:55	SPX	SPX261218P07400000	put	7400.0000	2026-12-18	135.8900	135.0000	136.5000	7777.4800	5027950.00	1383150.00	3644800.00	370	22	371	24615	0.0150721105017266	0.182428416610065	0.182770851668547	false	false	false
fa9f9184-7eec-46db-8463-043254627165	2026-08-17 10:07	2026-08-17 10:07	2026-08-17 10:07	SPX	SPX270917C08500000	call	8500.0000	2027-09-17	350.7900	349.3000	350.7000	7773.8100	9471412.00	0.00	0.00	270	18	272	3659	0.0743372506149221	0.153607338049075	0.153610493388033	false	false	false	true
a4427e0b-ea0c-42db-9e45-e7205ba1305d	2026-08-17 10:16	2026-08-17 10:16	2026-08-17 10:16	SPX	SPX270917C08500000	call	8500.0000	2027-09-17	351.7400	349.7000	351.1000	7775.9200	9497074.00	0.00	0.00	270	18	812	3659	0.221918556982782	0.153560149399334	0.153628701137174	false	false	false	true
2afff304-8759-469e-bf04-a411dfbffdb4	2026-08-17 10:31	2026-08-17 10:30	2026-08-17 10:30	SPX	SPX270917C08500000	call	8500.0000	2027-09-17	348.5400	349.4000	350.9000	7775.4000	9236430.00	0.00	0.00	265	18	1082	3659	0.295709210166712	0.152685500677607	0.152688655900748	false	false	false	true
d8b2ca10-f7b5-45e6-a8c2-16626a190a88	2026-08-17 15:17	2026-08-17 15:17	2026-08-17 15:17	SPX	SPX260918P07000000	put	7000.0000	2026-09-18	12.3300	12.3000	12.6000	7754.4600	106010.00	0.00	106010.00	86	10	1083	330343	0.00327841062168716	0.227202891705737	0.227597737790058	false	false	false	true
6b2e0d18-8ae2-4020-bde2-4675bb1f7a7e	2026-08-18 10:11	2026-08-18 10:11	2026-08-18 10:11	SPX	SPX260821P07700000	put	7700.0000	2026-08-21	29.7600	28.1000	31.2000	7699.3300	297600.00	184360.00	113240.00	100	10	1877	7735	0.242663219133807	0.109260190144275	0.110101685694963	false	false	false
0c906e02-91f4-4c38-a3e2-7585c6231cd0	2026-08-18 10:22	2026-08-18 10:22	2026-08-18 10:22	SPX	SPX260821P07650000	put	7650.0000	2026-08-21	13.7000	13.4000	13.8000	7702.4600	683520.00	505530.00	163030.00	499	6	898	8984	0.0999554764024933	0.123434623343921	0.123876018535394	true	false	false	true
2f1c0dcb-a213-4df2-a56e-fb30065536ba	2026-08-18 10:54	2026-08-18 10:54	2026-08-18 10:54	SPX	SPX260821P07600000	put	7600.0000	2026-08-21	6.6700	6.4000	7.3000	7701.5600	325340.00	94830.00	230510.00	488	10	2630	17015	0.154569497502204	0.137007330015466	0.137662891886335	false	false	false	true
9592458c-c96b-4235-a06d-0e6119f275f0	2026-08-19 11:40	2026-08-19 11:40	2026-08-19 11:40	SPX	SPX260918C07950000	call	7950.0000	2026-09-18	26.3700	26.1000	26.5000	7723.5000	532620.00	76560.00	456060.00	202	7	1550	8109	0.191145640646196	0.105825669712105	0.106325566776132	false	false	false
44d6b3a0-30c7-4f86-8711-083c2ab79978	2026-08-19 12:03	2026-08-19 12:03	2026-08-19 12:03	SPX	SPX260821C07730000	call	7730.0000	2026-08-21	24.1400	23.1000	24.6000	7731.7800	195560.00	86950.00	108610.00	81	9	384	1045	0.367464114832536	0.0976665708701341	0.0993067088773654	false	false	false
a022d5a2-aa93-476a-be95-83a37167263c	2026-08-19 12:27	2026-08-19 12:27	2026-08-19 12:27	SPX	SPX260821P07730000	put	7730.0000	2026-08-21	20.9600	20.0000	21.6000	7730.5000	209560.00	188660.00	20900.00	100	11	656	477	1.37526205450734	0.096094874113855	0.096094874113855	false	false	false	true
477bcbab-e4ec-4cf7-88b5-7c112b381c5d	2026-08-19 15:56	2026-08-19 15:56	2026-08-19 15:56	SPX	SPX270617C08450000	call	8450.0000	2027-06-17	218.9000	218.4000	219.3000	7701.7000	131340.00	43820.00	87520.00	6	5	81	450	0.18	0.143590403131353	0.143590403131353	false	false	false	true
29540a73-1041-47da-b5e4-3e0e4eb848d1	2026-08-19 16:53	2026-08-19 16:31	2026-08-19 16:31	SPX	SPX260821C07750000	call	7750.0000	2026-08-21	5.9500	5.4000	8.5000	7707.9800	104140.00	0.00	104140.00	175	6	9934	15886	0.625330479667632	0.0866538660490724	0.0878700895825863	false	false	false	true
4fab111e-2e8f-4107-bfbe-6c2aafd68f79	2026-08-20 09:31	2026-08-20 09:31	2026-08-20 09:31	SPX	SPX261120C08200000	call	8200.0000	2026-11-20	46.2900	46.0000	47.0000	7686.7700	694380.00	0.00	694380.00	150	12	150	6527	0.0229814616209591	0.11915819371883	0.11944668326155	false	false	false	true
cb70c94b-6e04-4bfd-8250-d9692b2fa304	2026-08-20 10:00	2026-08-20 10:00	2026-08-20 10:00	SPX	SPX260918P07750000	put	7750.0000	2026-09-18	127.2000	126.9000	127.7000	7688.4700	1068440.00	152760.00	737460.00	84	12	91	20013	0.00454704442112627	0.123263693901995	0.123263693901995	false	false	false
d3224f51-2469-43e7-a79a-b0ac7d6210f9	2026-08-20 10:06	2026-08-20 10:06	2026-08-20 10:06	SPX	SPX261120C08100000	call	8100.0000	2026-11-20	68.7700	68.4000	69.2000	7680.3100	206320.00	192560.00	0.00	30	9	30	8557	0.0035059016010284	0.122871120628174	0.122952642368445	false	false	false	true
e6301caa-aa56-403a-a64e-57940b9b3d0a	2026-08-20 10:07	2026-08-20 10:07	2026-08-20 10:07	SPX	SPX261218P07600000	put	7600.0000	2026-12-18	200.5300	199.7000	200.7000	7682.3600	4010560.00	1404020.00	2606540.00	200	14	216	17173	0.0125778838874978	0.161761815307569	0.161821340994973	false	false	false
4b7d30eb-a9bb-4582-8454-02258066fbff	2026-08-20 12:15	2026-08-20 12:15	2026-08-20 12:15	SPX	SPX270115C07750000	call	7750.0000	2027-01-15	312.7200	312.2000	313.5000	7673.7500	156360.00	31290.00	93790.00	5	5	92	1447	0.0635798203178991	0.14860960895774	0.148764464162206	false	false	false
0383b288-df96-4505-83f1-0edc19e70eb3	2026-08-20 14:55	2026-08-20 14:55	2026-08-20 14:55	SPX	SPX270115P07700000	put	7700.0000	2027-01-15	261.0700	260.7000	261.6000	7655.5400	182750.00	78390.00	104360.00	7	5	473	2182	0.216773602199817	0.154117278372329	0.154117278372329	false	false	false	true
3d16ba6c-5f9f-4296-a54e-82e40a7a2f1d	2026-08-20 15:57	2026-08-20 15:57	2026-08-20 15:57	SPX	SPX260918C07700000	call	7700.0000	2026-09-18	87.3000	86.7000	87.6000	7640.0800	1920660.00	1920660.00	0.00	220	8	15968	26276	0.607702846704217	0.121515037892978	0.121477089349158	false	false	false
ebaa87cb-18b8-41aa-8e78-2ce0c368e055	2026-08-21 10:26	2026-08-21 10:26	2026-08-21 10:26	SPX	SPX260918C07735000	call	7735.0000	2026-09-18	76.3000	76.2000	76.7000	7669.2700	877440.00	0.00	877440.00	115	9	243	4357	0.0557723204039477	0.113287319259771	0.113526494261956	false	false	false	true
9b3994ab-adea-4338-9ae2-02d670205cf7	2026-08-24 09:46	2026-08-24 09:46	2026-08-24 09:46	SPX	SPX260918P07750000	put	7750.0000	2026-09-18	144.5000	144.4000	145.0000	7644.4000	621370.00	72300.00	549070.00	43	5	152	20474	0.00742405001465273	0.119195626359412	0.119461152526461	false	false	false
f4396deb-8f14-4454-8bad-a80625499ddd	2026-08-24 15:11	2026-08-24 15:11	2026-08-24 15:11	SPX	SPX261120C07750000	call	7750.0000	2026-11-20	195.1800	194.7000	195.3000	7658.0600	156140.00	156140.00	0.00	8	6	91	3064	0.0296997389033943	0.1363980732629	0.136464735782191	false	false	false	true
a1473b28-bad3-44bd-91a1-970637ed5362	2026-08-24 15:42	2026-08-24 15:42	2026-08-24 15:42	SPX	SPX261120P07750000	put	7750.0000	2026-11-20	224.9400	224.6000	225.2000	7654.3500	179950.00	134970.00	0.00	8	6	152	2734	0.055596196049744	0.141835081401915	0.141835081401915	false	false	false	true
ca639a7f-80ca-4313-9404-e80c55f6e802	2026-08-25 10:01	2026-08-25 10:01	2026-08-25 10:01	SPX	SPX260918C07700000	call	7700.0000	2026-09-18	91.2000	91.0000	91.6000	7674.3000	793460.00	18260.00	775200.00	87	9	408	34741	0.011744048818399	0.120237913843074	0.120365300554935	false	false	false
813ef549-74f7-47ce-804f-c94acee008e7	2026-08-25 10:01	2026-08-25 10:01	2026-08-25 10:01	SPX	SPX260918C07700000	call	7700.0000	2026-09-18	91.2600	90.9000	91.6000	7673.5600	1441860.00	1368820.00	0.00	158	23	321	34741	0.00923980311447569	0.120704136445631	0.120831540565163	false	false	false
5a8e1437-82bb-467d-bb77-d59fa8083bd9	2026-08-25 10:36	2026-08-25 10:36	2026-08-25 10:36	SPX	SPX260918C07475000	call	7475.0000	2026-09-18	246.3100	244.5000	246.3000	7663.4200	738938.00	0.00	0.00	30	20	30	9926	0.00302236550473504	0.147631545721774	0.147648347809047	false	false	false	true
dfa75073-60f4-4725-a700-d2df17eab183	2026-08-25 11:10	2026-08-25 11:10	2026-08-25 11:10	SPX	SPX260918C07700000	call	7700.0000	2026-09-18	85.4800	85.0000	85.4000	7664.4900	17095000.00	0.00	0.00	2000	18	4059	34741	0.116836015083043	0.119160050002935	0.119032368597202	false	false	false	true
1e42a628-3c0a-452c-a2c6-a11e8a252a50	2026-08-25 15:29	2026-08-25 15:29	2026-08-25 15:29	SPX	SPX261120C07750000	call	7750.0000	2026-11-20	198.4500	198.0000	198.6000	7669.6400	119070.00	79370.00	39700.00	6	5	168	3247	0.0517400677548506	0.135814374335811	0.135881324429026	false	false	false
1aac5cc4-2f46-4249-b8d5-85e86a7a30c9	2026-08-25 15:55	2026-08-25 15:55	2026-08-25 15:55	SPX	SPX270617C08650000	call	8650.0000	2027-06-17	143.7300	143.1000	144.0000	7677.3600	158100.00	158100.00	0.00	11	5	39	3024	0.0128968253968254	0.138218912991904	0.138307489008235	false	false	false	true
b1467459-3771-4435-8491-09aac3b1b29c	2026-08-27 10:12	2026-08-27 10:12	2026-08-27 10:12	SPX	SPX260918P07800000	put	7800.0000	2026-09-18	128.6300	128.1000	128.8000	7705.2200	1955220.00	1955220.00	0.00	152	26	194	24089	0.00805346838806094	0.111583992581349	0.111724807597949	false	false	false
1e154038-7398-48ec-a6fe-74047aaad855	2026-08-28 15:56	2026-08-28 15:56	2026-08-28 15:56	SPX	SPX270617C08475000	call	8475.0000	2027-06-17	198.8400	198.8000	199.1000	7714.5300	159070.00	0.00	139180.00	8	5	59	1233	0.0478507704785077	0.139530386931182	0.139570165626938	false	false	false	true
0a3d6469-12dd-48a4-9ec5-1f8b9a9404c6	2026-08-31 13:27	2026-08-31 13:27	2026-08-31 13:27	SPX	SPX260918P07000000	put	7000.0000	2026-09-18	5.4900	5.2000	5.6000	7672.4900	822470.00	216920.00	605550.00	1497	25	6436	347794	0.0185052071053555	0.233948475876854	0.234726524768556	false	false	false
e1dfbf66-9463-4477-8f12-4ba10aa5bfaf	2026-08-31 15:50	2026-08-31 15:50	2026-08-31 15:50	SPX	SPX261120P07000000	put	7000.0000	2026-11-20	49.4500	49.0000	49.6000	7690.2900	494490.00	494490.00	0.00	100	5	1439	31787	0.0452700789630981	0.201671082680177	0.201671082680177	false	false	false	true
baefe598-3a5c-46f8-9cf2-eda8403c459e	2026-09-01 09:40	2026-09-01 09:40	2026-09-01 09:40	SPX	SPX261016P07500000	put	7500.0000	2026-10-16	83.7400	84.4000	85.3000	7634.2100	3718016.00	0.00	0.00	444	14	445	16360	0.027200488997555	0.145686343311877	0.145696766026634	false	false	false	true
1797dbf3-cc72-458e-88f2-ab56c62b65c1	2026-09-01 09:48	2026-09-01 09:48	2026-09-01 09:48	SPX	SPX261016P05900000	put	5900.0000	2026-10-16	5.4500	5.3000	5.6000	7635.4400	233392.00	0.00	0.00	428	14	428	7858	0.0544667854415882	0.356583574808411	0.35667992793042	false	false	false	true
2e8b6669-91d8-45a4-9b94-333f93dc1e93	2026-09-01 12:35	2026-09-01 12:35	2026-09-01 12:35	SPX	SPX261016P07475000	put	7475.0000	2026-10-16	80.0400	79.5000	80.2000	7634.6500	160070.00	160070.00	0.00	20	6	70	2971	0.0235610905419051	0.150563558667094	0.150670407281138	false	false	false	true
4e686198-e57a-4053-879d-80cec215897d	2026-09-01 14:27	2026-09-01 14:27	2026-09-01 14:27	SPX	SPX260918C07775000	call	7775.0000	2026-09-18	24.3300	23.3000	23.8000	7631.0100	255425.00	0.00	0.00	105	14	410	12422	0.033005957172758	0.107535300069182	0.107554975356658	false	false	false	true
677dfb47-eb9d-4b68-b378-cceef3b77127	2026-09-02 09:54	2026-09-02 09:54	2026-09-02 09:54	SPX	SPX260918C07700000	call	7700.0000	2026-09-18	52.4600	52.0000	52.6000	7641.3800	262320.00	262320.00	0.00	50	5	566	42690	0.0132583743265402	0.113971060835543	0.114293357496933	false	false	false	true
bfa180b5-ff4b-426a-96a8-fcb954854f8b	2026-09-02 15:55	2026-09-02 15:55	2026-09-02 15:55	SPX	SPX270617C08575000	call	8575.0000	2027-06-17	136.2500	135.9000	136.6000	7665.3200	109000.00	27280.00	81720.00	8	5	40	400	0.1	0.130669125512587	0.130758562994049	false	false	false	true
fee9512f-52f1-4dea-9c2e-6995cce734c7	2026-09-02 15:56	2026-09-02 15:56	2026-09-02 15:56	SPX	SPX270617C08575000	call	8575.0000	2027-06-17	136.3500	135.7000	136.6000	7664.8200	109080.00	95440.00	13640.00	8	6	69	400	0.1725	0.130773411305779	0.130862853032387	false	false	false	true
50658f43-1446-46a0-8ea1-d6171f49261b	2026-09-03 09:48	2026-09-03 09:48	2026-09-03 09:48	SPX	SPX261016C07900000	call	7900.0000	2026-10-16	58.6200	57.7000	60.0000	7714.0000	1172370.00	415140.00	757230.00	200	10	744	15624	0.0476190476190476	0.111691360237784	0.112011176248196	false	false	false
5b8a7080-709b-45a8-a7d2-8805960aead1	2026-09-03 10:17	2026-09-03 10:17	2026-09-03 10:17	SPX	SPX270115P07100000	put	7100.0000	2027-01-15	96.1800	96.1000	96.8000	7698.5400	1442740.00	0.00	1442740.00	150	10	154	6556	0.023489932885906	0.188240013819653	0.188319348024849	false	false	false	true
0f9faaf5-e91f-48ac-8ca3-300afde3e7e4	2026-09-03 11:25	2026-09-03 11:25	2026-09-03 11:25	SPX	SPX261016C07900000	call	7900.0000	2026-10-16	67.5800	66.9000	67.6000	7736.9200	1351700.00	1351700.00	0.00	200	5	1553	15624	0.0993983614951357	0.113345847952905	0.113448260440398	false	false	false
27d6ff0a-8a63-4b20-948c-ffbef1620a42	2026-09-03 11:44	2026-09-03 11:44	2026-09-03 11:44	SPX	SPX261218P06700000	put	6700.0000	2026-12-18	44.4900	44.0000	44.6000	7741.9300	284760.00	266960.00	17800.00	64	18	182	29793	0.0061088175074682	0.229634028341776	0.229776789714442	false	false	false
c99d8a30-ac1e-475f-bd60-c8fccadda10e	2026-09-03 15:55	2026-09-03 15:55	2026-09-03 15:55	SPX	SPX270617C08625000	call	8625.0000	2027-06-17	147.5000	146.8000	147.9000	7746.0900	132750.00	117980.00	14770.00	9	6	21	700	0.03	0.135675338824818	0.135806577928558	false	false	false	true
253d40bf-5690-44fa-9375-4d5a98e4a655	2026-09-04 11:28	2026-09-04 11:28	2026-09-04 11:28	SPX	SPX261120P07700000	put	7700.0000	2026-11-20	158.5500	158.5000	159.1000	7710.4100	332960.00	79300.00	253660.00	21	8	1032	10066	0.102523345916948	0.137251570073106	0.137323546984685	false	false	false
16b20412-ba86-4409-a688-2775a6ccebea	2026-09-04 11:48	2026-09-04 11:48	2026-09-04 11:48	SPX	SPX270219P06400000	put	6400.0000	2027-02-19	55.5300	55.4000	55.9000	7713.0200	3287184.00	0.00	0.00	592	18	592	950	0.623157894736842	0.239084630743849	0.239096444495311	false	false	false	true
e1664c42-b7d5-4416-bf23-a93d8390a07d	2026-09-04 13:34	2026-09-04 13:34	2026-09-04 13:34	SPX	SPX260918C07600000	call	7600.0000	2026-09-18	144.8400	144.3000	145.8000	7710.8400	144840.00	0.00	144840.00	10	5	268	55350	0.00484191508581752	0.111802778435918	0.111802778435918	false	false	false