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

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

8ec8603f-80d2-44dd-9d04-b1d3761fb4c6	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	TMF	TMF270115P00026000	put	26.0000	2027-01-15	0.9100	0.9100	0.9300	30.6100	41318.00	276.00	40950.00	454	17	3714	54	68.7777777777778	0.383208946553012	0.385071176443028	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	2146141516.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T13:35:10.222979Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a99e3ada-6e7e-4db6-98d8-bae22823f842	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	TMF	TMF270115P00026000	put	26.0000	2027-01-15	0.9100	0.9000	0.9100	30.6100	19019.00	4368.00	0.00	209	18	2863	54	53.0185185185185	0.383208946553012	0.383208946553012	false	false	false	true	false
2ad15dd0-e876-48b5-8195-9aade57fdd38	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	TMF	TMF270115P00026000	put	26.0000	2027-01-15	0.9200	0.9000	0.9200	30.6100	36512.00	36512.00	0.00	397	19	3260	54	60.3703703703704	0.383208946553012	0.385071176443028	false	false	false	true	false
440d0a6b-0b3b-4082-959e-2b7a4e5a0580	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	TMF	TMF270115P00026000	put	26.0000	2027-01-15	0.9400	0.8900	0.9400	30.6100	30604.00	30604.00	0.00	325	16	2652	54	49.1111111111111	0.388781655665636	0.388781655665636	false	false	false	true	false
78e4e5b8-5d27-4e3d-9c73-770a38d3a2b8	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	TMF	TMF270115P00026000	put	26.0000	2027-01-15	0.9200	0.9000	0.9300	30.6050	60916.00	28890.00	1274.00	664	43	2274	54	42.1111111111111	0.383026709009873	0.386745879691753	false	false	false	true	false
c37d8906-42a6-4a6e-ae4a-012ecce93ff3	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	TMF	TMF270115P00026000	put	26.0000	2027-01-15	0.9300	0.8900	0.9800	30.6100	96451.00	30259.00	26975.00	1037	73	1610	54	29.8148148148148	0.385071176443028	0.39063008805738	true	false	false	true	false
a4ee7443-4b52-471b-a1e4-3811e26832d3	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	TMF	TMF270115P00026000	put	26.0000	2027-01-15	0.9600	0.5700	1.0200	30.6300	21504.00	9984.00	1248.00	224	17	224	54	4.14814814814815	0.393208244306536	0.393208244306536	false	false	false	true	false
35cbd14f-f7a8-4efa-a5cd-117cd5f6d49a	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	TMF	TMF270115P00026000	put	26.0000	2027-01-15	0.9700	0.5700	1.0200	30.6300	33840.00	33840.00	0.00	349	15	573	54	10.6111111111111	0.393208244306536	0.39504905708479	false	false	false	true	false
d333343f-ee66-4d8d-930c-6f147f6044bf	2026-08-20 13:03	2026-08-20 13:03	2026-08-20 13:03	TMF	TMF261002P00028000	put	28.0000	2026-10-02	0.4600	0.4600	0.5100	30.8550	14950.00	0.00	12512.00	325	12	494	31	15.9354838709677	0.374363180682434	0.374363180682434	false	false	false	true	false
e9b47ab7-383c-4ebb-9101-408e57b38336	2026-08-20 11:06	2026-08-20 11:06	2026-08-20 11:06	TMF	TMF260918C00032000	call	32.0000	2026-09-18	0.7500	0.6300	0.7500	31.0550	13500.00	13500.00	0.00	180	10	383	782	0.489769820971867	0.317636293051036	0.317636293051036	false	false	false	true	false
eb0d9613-1ee7-4b88-a611-7042ac4e5883	2026-08-20 09:35	2026-08-20 09:35	2026-08-20 09:35	TMF	TMF260828C00030000	call	30.0000	2026-08-28	1.1100	1.0400	1.1100	30.7600	26529.00	26529.00	0.00	239	15	239	234	1.02136752136752	0.358476667922281	0.358476667922281	false	false	false	true	false
17d19c6e-1aff-410e-bdeb-ea58283b4e42	2026-08-19 11:01	2026-08-19 11:01	2026-08-19 11:01	TMF	TMF260828C00028000	call	28.0000	2026-08-28	3.6200	3.6000	3.7000	31.5850	13756.00	0.00	13756.00	38	8	100	170	0.588235294117647	0.356693177313862	0.356693177313862	false	false	false	true	false
930aa5a6-0965-41f6-b71e-83b98e2517d3	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	TMF	TMF260828P00031000	put	31.0000	2026-08-28	0.4700	0.4100	0.4700	31.2950	23453.00	23453.00	0.00	499	24	501	757	0.661822985468956	0.317158574525836	0.317158574525836	false	false	false	true	false
e0ffc156-e975-4930-be88-014f05fc7f55	2026-08-18 15:20	2026-08-18 15:20	2026-08-18 15:20	TMF	TMF260821C00030000	call	30.0000	2026-08-21	0.4500	0.4400	0.4800	30.1850	21195.00	315.00	5175.00	471	16	1858	500	3.716	0.316246025333903	0.316246025333903	true	false	false	true	false
af5f3a4f-9e2f-4f66-9c1c-befb9c9bf681	2026-08-18 10:16	2026-08-18 10:15	2026-08-18 10:15	TMF	TMF260828P00029500	put	29.5000	2026-08-28	0.4200	0.4200	0.4500	29.9800	10752.00	0.00	10752.00	256	13	336	417	0.805755395683453	0.327802406064346	0.327802406064346	true	false	false	true	false
f10de32b-e37f-42a7-aaac-cb972941c8b4	2026-08-17 15:10	2026-08-17 15:10	2026-08-17 15:10	TMF	TMF260828C00028000	call	28.0000	2026-08-28	2.0400	1.9800	2.0400	29.8550	10200.00	8976.00	0.00	50	6	151	21	7.19047619047619	0.372703336175643	0.372703336175643	false	false	false	true	false
176eae2e-40bf-4126-af3c-c7472ea31ad8	2026-08-17 14:57	2026-08-17 14:57	2026-08-17 14:57	TMF	TMF261002C00029000	call	29.0000	2026-10-02	1.7800	1.7800	1.8500	29.8150	14062.00	0.00	14062.00	79	22	427	0	0	0.296642325864447	0.299888274873455	true	false	false	true	false
258daddc-2031-4f21-991e-924a67c65748	2026-08-17 14:22	2026-08-17 14:22	2026-08-17 14:22	TMF	TMF260821P00030000	put	30.0000	2026-08-21	0.5100	0.5100	0.5300	29.7850	58752.00	0.00	58752.00	1152	40	7330	1965	3.73027989821883	0.320978310016287	0.320978310016287	true	false	false	true	false
fcc80e07-9080-482e-a909-3f752b85896a	2026-08-17 14:22	2026-08-17 14:22	2026-08-17 14:22	TMF	TMF260821P00030000	put	30.0000	2026-08-21	0.5100	0.5000	0.5100	29.7950	12240.00	12240.00	0.00	240	20	5886	1965	2.99541984732824	0.325639736633625	0.325639736633625	false	false	false	true	false
f784e7a7-f582-4e2e-98c1-3c52b956cf25	2026-08-17 14:22	2026-08-17 14:22	2026-08-17 14:22	TMF	TMF260821P00030000	put	30.0000	2026-08-21	0.5100	0.5000	0.5100	29.7950	16830.00	16830.00	0.00	330	11	5556	1965	2.82748091603053	0.325639736633625	0.325639736633625	false	false	false	true	false
8f96dd0e-e122-4fe7-a340-dda562bc3e90	2026-08-17 14:22	2026-08-17 14:22	2026-08-17 14:22	TMF	TMF260821P00030000	put	30.0000	2026-08-21	0.5100	0.5100	0.5200	29.7950	24888.00	0.00	24888.00	488	27	5092	1965	2.59134860050891	0.325639736633625	0.325639736633625	false	false	false	true	false
1dfc3a2e-5f51-4b32-8808-10e506bb94c4	2026-08-17 14:22	2026-08-17 14:22	2026-08-17 14:22	TMF	TMF260821P00030000	put	30.0000	2026-08-21	0.5100	0.5100	0.5300	29.7803	17034.00	0.00	17034.00	334	8	4604	1965	2.34300254452926	0.318768501237187	0.318768501237187	false	false	false	true	false
28390e3b-4862-483d-b798-fa17fb9d3024	2026-08-17 14:22	2026-08-17 14:22	2026-08-17 14:22	TMF	TMF260821P00030000	put	30.0000	2026-08-21	0.5100	0.5100	0.5200	29.7850	18870.00	0.00	18870.00	370	18	4210	1965	2.14249363867684	0.320978310016287	0.320978310016287	false	false	false	true	false
77710493-c75d-4322-9554-8eae2f9c18e8	2026-08-17 14:22	2026-08-17 14:22	2026-08-17 14:22	TMF	TMF260821P00030000	put	30.0000	2026-08-21	0.5200	0.5100	0.5300	29.7850	19604.00	0.00	19552.00	377	16	3840	1965	1.95419847328244	0.329151921933594	0.329151921933594	false	false	false	true	false
1a24d217-1347-49b3-be31-4c4cdee2577c	2026-08-17 14:22	2026-08-17 14:22	2026-08-17 14:22	TMF	TMF260821P00030000	put	30.0000	2026-08-21	0.5200	0.5200	0.5300	29.7800	40248.00	0.00	40248.00	774	11	3463	1965	1.76234096692112	0.326811933069651	0.326811933069651	false	false	false	true	false
0b127bcc-5373-4d49-8003-48cef66ac77e	2026-08-17 14:22	2026-08-17 14:22	2026-08-17 14:22	TMF	TMF260821P00030000	put	30.0000	2026-08-21	0.5200	0.5200	0.5300	29.7800	22724.00	0.00	22724.00	437	12	2689	1965	1.36844783715013	0.326811933069651	0.326811933069651	false	false	false	true	false
9f0f8b5c-7faf-460c-b6ab-149c40edd6c4	2026-08-17 14:22	2026-08-17 14:22	2026-08-17 14:22	TMF	TMF260821P00030000	put	30.0000	2026-08-21	0.5200	0.5200	0.5400	29.7800	34008.00	0.00	34008.00	654	11	2252	1965	1.14605597964377	0.326811933069651	0.326811933069651	false	false	false	true	false
3fb5078e-4e00-4061-94a7-44fe96c190f5	2026-08-17 14:22	2026-08-17 14:22	2026-08-17 14:22	TMF	TMF260821P00030000	put	30.0000	2026-08-21	0.5300	0.5300	0.5500	29.7750	36835.00	0.00	36835.00	695	38	1598	1965	0.81323155216285	0.332646027233931	0.332646027233931	false	false	false	true	false
c486f0c7-58dd-4079-8104-29493e37a714	2026-08-17 14:22	2026-08-17 14:21	2026-08-17 14:21	TMF	TMF260821P00030000	put	30.0000	2026-08-21	0.5300	0.5200	0.5300	29.7800	11925.00	318.00	0.00	225	28	903	1965	0.459541984732824	0.337317744857084	0.334988453703098	true	false	false	true	false
1051a37a-1db4-4495-b5e7-0534599b7ac6	2026-08-17 14:18	2026-08-17 14:18	2026-08-17 14:18	TMF	TMF261002C00029000	call	29.0000	2026-10-02	1.8000	1.7900	1.8400	29.8150	55440.00	0.00	55440.00	308	11	342	0	0	0.304935612385187	0.304935612385187	true	false	false	true	false
11cbd72c-37d8-4186-a28a-a284606ea94d	2026-08-17 14:18	2026-08-17 14:18	2026-08-17 14:18	TMF	TMF261002C00028000	call	28.0000	2026-10-02	2.4600	2.4500	2.5300	29.8200	28290.00	20418.00	7872.00	115	16	115	0	0	0.305504141887227	0.305504141887227	true	false	false	true	false
5c6fd113-5058-4271-88a1-5cef0b566dcf	2026-08-17 13:45	2026-08-17 13:45	2026-08-17 13:45	TMF	TMF260904C00030500	call	30.5000	2026-09-04	0.6500	0.5900	0.6500	29.0000	16250.00	16250.00	0.00	250	25	773	75	10.3066666666667	0.334275485853706	0.334275485853706	false	false	false	true	false
e1029734-2aea-4678-8857-8000522dda5c	2026-08-17 13:40	2026-08-17 13:39	2026-08-17 13:39	TMF	TMF260904C00030000	call	30.0000	2026-09-04	0.8500	0.8200	0.8500	29.8550	33973.00	31705.00	2268.00	400	38	440	30	14.6666666666667	0.33749838160862	0.33371757383676	false	false	false	true	false
79f4caf8-576b-4820-bb6d-c633d1dbfced	2026-08-17 13:28	2026-08-17 13:28	2026-08-17 13:28	TMF	TMF260918P00031000	put	31.0000	2026-09-18	1.7200	1.6800	1.7300	29.9550	11180.00	11180.00	0.00	65	20	110	122	0.901639344262295	0.331376665863495	0.331376665863495	true	false	false	true	false
339aa09f-2e5a-4326-92ee-d1f17e09d554	2026-08-17 11:04	2026-08-17 11:04	2026-08-17 11:04	TMF	TMF260821C00027000	call	27.0000	2026-08-21	3.2600	3.2000	3.3500	30.2200	34181.00	28639.00	5542.00	105	7	265	3	88.3333333333333	0.569929251143192	0.568561999577817	false	false	false	true	false
0a4a3bb9-dcc6-466e-b85b-77752d160b15	2026-08-17 09:31	2026-08-17 09:30	2026-08-17 09:30	TMF	TMF260925C00031500	call	31.5000	2026-09-25	0.7400	0.6600	0.9200	30.2700	11098.00	11025.00	73.00	150	12	150	205	0.731707317073171	0.301741038866806	0.299078801054244	true	false	false	true	false
0d01b861-8d4a-4a80-bbb8-399ae20b8fed	2026-08-17 09:30	2026-08-17 09:30	2026-08-17 09:30	TMF	TMF260925C00032500	call	32.5000	2026-09-25	0.4500	0.3700	0.5000	30.2670	13728.00	13635.00	49.00	305	28	305	41	7.4390243902439	0.300007386131146	0.31229465054759	true	false	false	true	false