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

961e0968-a3b3-49ac-8ee3-149d54058fde	2026-08-17 13:26	2026-08-17 13:25	2026-08-17 13:25	SPX	SPX261016P07375000	put	7375.0000	2026-10-16	65.1700	64.8000	65.3000	7757.2400	195510.00	136920.00	0.00	30	6	182	1552	0.117268041237113	0.176109684154087	0.175976515656044	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
1b4f114e-318f-4389-9905-15d5ae4e5362	2026-08-17 13:57	2026-08-17 13:57	2026-08-17 13:57	SPX	SPX260918P07600000	put	7600.0000	2026-09-18	59.5900	59.4000	59.7000	7735.0000	393300.00	232650.00	160650.00	66	8	886	53791	0.0164711568849808	0.144073831610701	0.143816624078272	false	false	false
091c4888-4777-4b14-9708-a8eafa24fa4f	2026-08-17 14:51	2026-08-17 14:51	2026-08-17 14:51	SPX	SPX261016P07000000	put	7000.0000	2026-10-16	32.5600	32.5000	32.8000	7758.6200	276780.00	0.00	276780.00	85	8	1746	101914	0.0171320917636439	0.21569213888576	0.215508439803397	false	false	false	true
f5b2c788-b5fb-4a1b-be0b-f6e3259992fe	2026-08-17 15:51	2026-08-17 15:51	2026-08-17 15:51	SPX	SPX270617C08450000	call	8450.0000	2027-06-17	249.3500	248.7000	249.6000	7749.8600	149610.00	149610.00	0.00	6	5	33	284	0.116197183098592	0.148021378471617	0.147983986273204	false	false	false	true
9514491b-3b33-4186-9459-122a85dd9afa	2026-08-17 15:55	2026-08-17 15:55	2026-08-17 15:55	SPX	SPX270617C08450000	call	8450.0000	2027-06-17	248.4400	247.7000	248.8000	7746.1300	124220.00	99370.00	0.00	5	5	82	284	0.288732394366197	0.148202619193641	0.148165172131645	false	false	false	true
d3ec13d8-4d34-4830-a0e6-5b604c3eeda1	2026-08-18 10:55	2026-08-18 10:55	2026-08-18 10:55	SPX	SPX260821C07700000	call	7700.0000	2026-08-21	31.4600	31.4000	31.9000	7699.0900	113240.00	0.00	113240.00	36	5	576	11905	0.0483830323393532	0.110440261974218	0.110440261974218	false	false	false
ec9abc7b-767f-48bb-81e1-6dcad0b79fc0	2026-08-19 12:04	2026-08-19 12:04	2026-08-19 12:04	SPX	SPX261120P07575000	put	7575.0000	2026-11-20	147.0100	146.6000	147.1000	7732.0200	411640.00	411640.00	0.00	28	5	144	779	0.184852374839538	0.160259801557301	0.160119717846765	false	false	false	true
0f6bd49b-6d56-4fd2-b812-d62d6c4068c3	2026-08-19 12:07	2026-08-19 12:07	2026-08-19 12:07	SPX	SPX260821C07730000	call	7730.0000	2026-08-21	23.7400	23.3000	25.0000	7732.8300	192310.00	0.00	192310.00	81	9	532	1045	0.509090909090909	0.0950443268559915	0.0929112005376411	false	false	false
a9917256-01d9-4eac-8d84-5f27e008e27d	2026-08-19 12:11	2026-08-19 12:11	2026-08-19 12:11	SPX	SPX260821C07735000	call	7735.0000	2026-08-21	22.9600	22.3000	23.4000	7735.5300	185940.00	71090.00	114850.00	81	6	520	1448	0.359116022099448	0.0959585631868201	0.0959585631868201	false	false	false
f83d015e-0860-4e2c-8e10-73f083bc3238	2026-08-19 12:22	2026-08-19 12:22	2026-08-19 12:22	SPX	SPX260821C07740000	call	7740.0000	2026-08-21	19.8300	19.2000	20.8000	7734.9200	180410.00	45510.00	134900.00	91	8	1939	1069	1.81384471468662	0.0945151649115559	0.0936379520144817	false	false	false
d5fa78bf-3c91-4670-86d3-ddd98bc8bc3b	2026-08-19 12:29	2026-08-19 12:29	2026-08-19 12:29	SPX	SPX260821P07730000	put	7730.0000	2026-08-21	22.0500	21.5000	22.5000	7727.7600	220470.00	44200.00	176270.00	100	5	763	477	1.59958071278826	0.0954306208371376	0.0954306208371376	false	false	false
eb3723cf-4cb5-4702-9f75-e5558fcb290c	2026-08-20 09:32	2026-08-20 09:32	2026-08-20 09:32	SPX	SPX260821C07480000	call	7480.0000	2026-08-21	206.1800	205.8000	207.2000	7684.3100	865970.00	0.00	865970.00	42	11	110	6802	0.0161717142017054	0.272933782427914	0.250814899719085	false	false	false
3e2866ef-2beb-4856-95ed-91e736a941f2	2026-08-20 09:50	2026-08-20 09:50	2026-08-20 09:50	SPX	SPX260918P07385000	put	7385.0000	2026-09-18	34.1700	34.0000	34.3000	7691.1400	382680.00	126540.00	256140.00	112	5	324	565	0.573451327433628	0.167590177115741	0.167409071204002	false	false	false
7e2070ff-3451-46e2-871e-5dd3a09cb9af	2026-08-20 10:00	2026-08-20 10:00	2026-08-20 10:00	SPX	SPX260918P07750000	put	7750.0000	2026-09-18	127.2100	127.1000	127.4000	7688.4700	114490.00	12730.00	101760.00	9	5	100	20013	0.00499675211112777	0.123496855798388	0.123380275960971	false	false	false
5be911c2-fac2-493d-b4c0-075621c8c540	2026-08-20 13:15	2026-08-20 13:15	2026-08-20 13:15	SPX	SPX270219C07875000	call	7875.0000	2027-02-19	294.9400	294.6000	295.8000	7673.1900	206460.00	0.00	206460.00	7	6	185	366	0.505464480874317	0.14597845971607	0.145932323563584	false	false	false	true
1d13f1ba-912b-46d2-b436-57e0eebd1f8b	2026-08-20 15:59	2026-08-20 15:59	2026-08-20 15:59	SPX	SPX260821P07640000	put	7640.0000	2026-08-21	13.2400	12.9000	14.6000	7641.8200	259560.00	28560.00	231000.00	196	5	2968	927	3.2017259978425	0.0931901862682242	0.0906767452947486	false	false	false
bd74863a-bedd-4212-bbfd-545acba5d3f3	2026-08-24 15:30	2026-08-24 15:30	2026-08-24 15:30	SPX	SPX261120P07750000	put	7750.0000	2026-11-20	223.3300	222.9000	223.5000	7658.2200	134000.00	111670.00	22330.00	6	5	136	2734	0.049743964886613	0.1421307637929	0.142064103397493	false	false	false
8491639f-6544-4520-969e-54ed1e72e483	2026-08-24 15:36	2026-08-24 15:35	2026-08-24 15:35	SPX	SPX261120C07750000	call	7750.0000	2026-11-20	193.8600	193.3000	194.0000	7656.0300	135700.00	135700.00	0.00	7	6	122	3064	0.0398172323759791	0.13627092606983	0.136204243964899	false	false	false
7aa935ed-f538-4997-98a9-62c118383622	2026-08-24 15:47	2026-08-24 15:47	2026-08-24 15:47	SPX	SPX261120C07750000	call	7750.0000	2026-11-20	192.9300	192.4000	193.0000	7653.7700	135050.00	96470.00	38580.00	7	6	136	3064	0.0443864229765013	0.136417572328736	0.136350867289276	false	false	false
a56b4b36-4937-4b80-9b11-b4aab02d0ee8	2026-08-24 15:53	2026-08-24 15:53	2026-08-24 15:53	SPX	SPX261120C07750000	call	7750.0000	2026-11-20	191.9600	191.5000	192.2000	7652.0600	134370.00	134370.00	0.00	7	6	274	3064	0.0894255874673629	0.136380695007632	0.13624724830753	false	false	false
ee105c2e-e7de-433e-b201-d38f8cc42e0c	2026-08-25 10:02	2026-08-25 10:02	2026-08-25 10:02	SPX	SPX261016C07700000	call	7700.0000	2026-10-16	157.9500	157.4000	158.2000	7674.7600	2337720.00	205270.00	2132450.00	148	6	407	5259	0.0773911389998098	0.129680220697139	0.129593489746871	false	false	false
2a3e9908-b30e-454a-88dc-96b3421bed1c	2026-08-25 10:02	2026-08-25 10:02	2026-08-25 10:02	SPX	SPX261016C07700000	call	7700.0000	2026-10-16	158.1900	158.1000	158.7000	7674.7600	2198870.00	110740.00	2088130.00	139	19	207	5259	0.0393610952652596	0.129881109908364	0.129766951572265	false	false	false
0cdcc2aa-68ce-43b5-8931-193d955e4d3b	2026-08-25 14:23	2026-08-25 14:23	2026-08-25 14:23	SPX	SPX261120C07750000	call	7750.0000	2026-11-20	196.8300	196.4000	196.9000	7645.0000	118100.00	98420.00	19680.00	6	5	107	3247	0.0329534955343394	0.135702631474263	0.135635662719417	false	false	false
41ecfc38-c746-4cda-86fe-f69f69f2cd49	2026-08-25 14:35	2026-08-25 14:35	2026-08-25 14:35	SPX	SPX261120P07750000	put	7750.0000	2026-11-20	215.6300	215.1000	215.8000	7671.7100	129380.00	107820.00	21560.00	6	5	454	2781	0.163250629270047	0.141919886284726	0.141852946795398	false	false	false
cb37e104-84de-4a43-a8de-ed312e8e16c3	2026-08-25 14:41	2026-08-25 14:41	2026-08-25 14:41	SPX	SPX261120C07750000	call	7750.0000	2026-11-20	199.8300	199.4000	200.0000	7671.7700	119900.00	59960.00	59940.00	6	5	127	3247	0.0391130274099168	0.13609578293615	0.136028846520561	false	false	false
43548a44-b7ec-4a33-a9a8-e514683622c2	2026-08-25 14:47	2026-08-25 14:47	2026-08-25 14:47	SPX	SPX261120C07750000	call	7750.0000	2026-11-20	202.4300	201.9000	202.6000	7676.2900	121460.00	121460.00	0.00	6	5	134	3247	0.041268863566369	0.136294577253166	0.136227666038499	false	false	false
cafb18e8-f3ae-44f8-8155-9c7cf6d75842	2026-08-25 15:06	2026-08-25 15:06	2026-08-25 15:06	SPX	SPX261120P07750000	put	7750.0000	2026-11-20	215.4300	215.0000	215.5000	7672.8800	129260.00	107720.00	21540.00	6	5	484	2781	0.174038115785689	0.14217059893567	0.142103666236744	false	false	false
180004e9-577c-4c0b-9c81-39a6b0ae428d	2026-08-25 15:23	2026-08-25 15:23	2026-08-25 15:23	SPX	SPX261120P07750000	put	7750.0000	2026-11-20	217.6300	217.1000	217.8000	7667.7800	130580.00	130580.00	0.00	6	5	496	2781	0.178353110391945	0.141961738284346	0.141894773153674	false	false	false	true
ef6caf72-585b-423b-8061-22561123bdfb	2026-08-25 15:36	2026-08-25 15:36	2026-08-25 15:36	SPX	SPX261120P07750000	put	7750.0000	2026-11-20	216.3300	215.9000	216.5000	7670.7600	129800.00	129800.00	0.00	6	5	508	2781	0.182668104998202	0.142075674619458	0.142008729201991	false	false	false	true
de1872b9-6a35-4451-89ad-e73c12d75b01	2026-08-26 14:33	2026-08-26 14:33	2026-08-26 14:33	SPX	SPX261016P07750000	put	7750.0000	2026-10-16	164.5600	164.4000	165.1000	7676.7700	1974680.00	0.00	1974680.00	120	17	337	2953	0.114121232644768	0.128977929885571	0.128890405908677	false	false	false
54c81db7-51f0-45b5-9ad4-e412b6c354a0	2026-08-26 14:34	2026-08-26 14:34	2026-08-26 14:34	SPX	SPX260918P07750000	put	7750.0000	2026-09-18	122.1100	122.0000	122.4000	7675.6700	1013550.00	818190.00	195360.00	83	5	1221	20474	0.0596366122887565	0.118715297904495	0.11858176337096	false	false	false
78974d2c-d478-4ab6-894c-e76868649722	2026-08-26 15:55	2026-08-26 15:55	2026-08-26 15:55	SPX	SPX270617C08450000	call	8450.0000	2027-06-17	200.0000	199.6000	200.9000	7677.9000	120000.00	39960.00	80040.00	6	5	22	498	0.0441767068273092	0.141667011163727	0.141667011163727	false	false	false
8e1baeef-39f7-4597-a04a-8390cafb29e3	2026-08-26 15:56	2026-08-26 15:55	2026-08-26 15:55	SPX	SPX270617C08450000	call	8450.0000	2027-06-17	200.6300	200.3000	201.5000	7679.4000	120380.00	20050.00	100330.00	6	5	39	498	0.0783132530120482	0.141707469316546	0.141707469316546	false	false	false
c16954c2-6806-4ba6-b2ae-35eec423fcfe	2026-08-26 15:56	2026-08-26 15:56	2026-08-26 15:56	SPX	SPX270617C08450000	call	8450.0000	2027-06-17	200.9600	200.7000	201.9000	7680.2800	140670.00	20090.00	120580.00	7	5	46	498	0.0923694779116466	0.141789985093771	0.141590742019626	false	false	false
7f6a4a04-37f8-45b8-8c4d-5ad0def48054	2026-08-27 09:30	2026-08-27 09:30	2026-08-27 09:30	SPX	SPX261120C07775000	call	7775.0000	2026-11-20	198.4700	198.1000	199.9000	7704.9800	1309920.00	0.00	1309920.00	66	6	66	820	0.0804878048780488	0.134046206444717	0.134046206444717	false	false	false
0e7d838c-6f4f-45a4-863f-8f1ce13a02c8	2026-08-27 10:13	2026-08-27 10:13	2026-08-27 10:13	SPX	SPX261016P07800000	put	7800.0000	2026-10-16	169.8600	169.6000	170.4000	7705.2400	2870630.00	0.00	2870630.00	169	37	217	10421	0.0208233374916035	0.123606243934956	0.123517596119928	false	false	false
76288320-5414-44c0-841e-199be401e680	2026-08-27 10:13	2026-08-27 10:13	2026-08-27 10:13	SPX	SPX261016P07800000	put	7800.0000	2026-10-16	169.7900	169.5000	170.1000	7705.9000	1579040.00	424500.00	1154540.00	93	11	412	10421	0.0395355532098647	0.123840212318446	0.123751597373623	false	false	false
5205ef6d-634a-4be5-a462-d7a1b1404266	2026-08-27 11:59	2026-08-27 11:59	2026-08-27 11:59	SPX	SPX261016P07300000	put	7300.0000	2026-10-16	41.3300	41.0000	41.4000	7725.2900	119870.00	82790.00	0.00	29	13	106	14297	0.00741414282716654	0.171221966806974	0.171076297601415	false	false	false	true
f5f2b973-8e27-4ee4-b667-8d411285bf9f	2026-08-27 15:52	2026-08-27 15:52	2026-08-27 15:52	SPX	SPX260918C07610000	call	7610.0000	2026-09-18	172.3300	171.3000	173.0000	7726.2400	120630.00	120630.00	0.00	7	6	8	9053	0.000883684966309511	0.120338300309126	0.120338300309126	false	false	false
2f4f54f8-ad39-40a9-800a-069690faa81b	2026-08-27 15:57	2026-08-27 15:57	2026-08-27 15:57	SPX	SPX270617C08450000	call	8450.0000	2027-06-17	217.1700	216.7000	217.8000	7729.7900	152020.00	21710.00	130310.00	7	5	94	434	0.216589861751152	0.14549581675575	0.145456686788163	false	false	false
24e6b525-1e7c-4523-8a54-25dfa64ca0ea	2026-08-28 13:21	2026-08-28 13:21	2026-08-28 13:21	SPX	SPX261016C07800000	call	7800.0000	2026-10-16	106.7800	106.3000	107.4000	7706.9800	170850.00	0.00	170850.00	16	6	2638	16869	0.15638152824708	0.116518400568033	0.116428759626867	false	false	false
73ce7cbb-430b-4397-a534-9dc403cf2b56	2026-08-28 15:55	2026-08-28 15:55	2026-08-28 15:55	SPX	SPX270617C08475000	call	8475.0000	2027-06-17	197.9800	197.8000	198.8000	7712.7700	158380.00	19790.00	138590.00	8	5	12	1233	0.0097323600973236	0.139445353620195	0.139445353620195	false	false	false
d64df6a5-3126-4071-855a-a1c25a99e26c	2026-08-28 15:57	2026-08-28 15:57	2026-08-28 15:57	SPX	SPX270617C08475000	call	8475.0000	2027-06-17	199.6300	199.6000	200.3000	7715.1600	119780.00	0.00	119780.00	6	5	110	1233	0.089213300892133	0.139804620329062	0.139764871903949	false	false	false
d588ee1c-456b-472d-81f9-a54eba4bddb7	2026-08-31 14:42	2026-08-31 14:42	2026-08-31 14:42	SPX	SPX270319C08200000	call	8200.0000	2027-03-19	160.7300	160.5000	161.8000	7671.4400	3519960.00	0.00	3519960.00	219	12	236	9195	0.0256661228928766	0.130553071303869	0.130505139189167	false	false	false
c5ba6958-8d20-4738-a1ad-3ffb9a6ed119	2026-08-31 15:55	2026-08-31 15:55	2026-08-31 15:55	SPX	SPX270617C08650000	call	8650.0000	2027-06-17	131.3500	130.7000	131.7000	7688.1000	105080.00	91950.00	13130.00	8	6	15	3700	0.00405405405405405	0.132710146041431	0.132710146041431	false	false	false
fbbf09d4-5677-4e12-a1e9-3ef7b2e7be8a	2026-09-01 12:35	2026-09-01 12:35	2026-09-01 12:35	SPX	SPX261016P07475000	put	7475.0000	2026-10-16	80.1200	79.6000	80.3000	7634.7800	160240.00	160240.00	0.00	20	6	20	2971	0.00673174015483002	0.150819301539484	0.150712462259351	false	false	false	true
bf88f72b-9fea-4efd-9e89-bccd38278e91	2026-09-01 12:35	2026-09-01 12:35	2026-09-01 12:35	SPX	SPX261016P07475000	put	7475.0000	2026-10-16	79.9100	79.5000	80.1000	7634.5400	159830.00	159830.00	0.00	20	6	50	2971	0.0168293503870751	0.15052797655111	0.150421117225235	false	false	false	true
730416a5-de5d-4dff-9ea5-b823708e6ca7	2026-09-03 10:02	2026-09-03 10:02	2026-09-03 10:02	SPX	SPX261016C07900000	call	7900.0000	2026-10-16	53.0500	52.2000	53.9000	7701.1300	1060980.00	662980.00	398000.00	200	9	1036	15624	0.0663082437275986	0.110188453181339	0.110078759644613	false	false	false
4a4acb10-fcdf-41e7-a80c-56ebb8b299fa	2026-09-03 10:02	2026-09-03 10:02	2026-09-03 10:02	SPX	SPX261218C08050000	call	8050.0000	2026-12-18	101.7600	101.6000	102.5000	7700.8900	1007380.00	254250.00	753130.00	99	8	102	6501	0.0156898938624827	0.123295912053566	0.123228336855527	false	false	false
59c2daaa-50c3-4a52-9714-bb9e26bc1474	2026-09-03 11:41	2026-09-03 11:41	2026-09-03 11:41	SPX	SPX261218C07825000	call	7825.0000	2026-12-18	223.6600	222.1000	225.0000	7740.5200	3354840.00	2481960.00	872880.00	150	14	158	4836	0.032671629445823	0.135078782087186	0.134838279752942	false	false	false