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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×option_symbol = TLT270617P00080000×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

25b26f13-e2b8-406a-bf57-536a6d46d9ac	2026-08-19 10:32	2026-08-19 10:31	2026-08-19 10:31	TLT	TLT270617P00080000	put	80.0000	2027-06-17	2.2100	2.2100	2.2700	82.9815	110500.00	0.00	110500.00	500	10	551	85781	0.0064233338384957	0.153274912381113	0.153274912381113	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	47711923102.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
0092b333-f351-4d9f-b697-f3e46d8921d7	2026-08-19 10:33	2026-08-19 10:33	2026-08-19 10:33	TLT	TLT270617P00080000	put	80.0000	2027-06-17	2.2100	2.2100	2.2600	82.9950	94367.00	0.00	94367.00	427	13	978	85781	0.0114011261235005	0.153424922655922	0.153424922655922	false	false	false
67ebc28a-882a-4933-aea2-ad16ccd22027	2026-08-24 09:55	2026-08-24 09:55	2026-08-24 09:55	TLT	TLT270617P00080000	put	80.0000	2027-06-17	2.4800	2.4500	2.4900	82.5700	49698.00	37101.00	247.00	200	21	415	84233	0.00492681015753921	0.160521816429357	0.159752045717689	true	false	false
20fcb952-0c7d-481f-8710-251b5aceb759	2026-08-26 12:48	2026-08-26 12:48	2026-08-26 12:48	TLT	TLT270617P00080000	put	80.0000	2027-06-17	2.2600	2.1600	2.2800	83.1550	91982.00	15142.00	226.00	407	6	853	84051	0.0101486002546073	0.158388768348064	0.158388768348064	false	false	false
0b85772e-4de9-4375-bee8-706e2a1e10e2	2026-09-11 14:14	2026-09-11 14:13	2026-09-11 14:13	TLT	TLT270617P00080000	put	80.0000	2027-06-17	2.8700	2.8300	2.8700	81.0000	37310.00	37310.00	0.00	130	6	288	80851	0.00356210807534848	0.16049358079606	0.16049358079606	false	false	false
9735a9f4-a836-4e48-a06e-41875063c43f	2026-09-22 16:00	2026-09-22 16:00	2026-09-22 16:00	TLT	TLT270617P00080000	put	80.0000	2027-06-17	2.4200	2.3900	2.4300	81.0000	12100.00	12100.00	0.00	50	5	65	83268	0.000780611999807849	0.15579718617505	0.15579718617505	false	false	false
50d7a745-4ae1-4fc7-a170-06994304e13f	2026-09-23 10:09	2026-09-23 10:08	2026-09-23 10:08	TLT	TLT270617P00080000	put	80.0000	2027-06-17	2.7000	2.6600	2.7000	81.0801	25920.00	25920.00	0.00	96	19	105	83268	0.00126098861507422	0.158112096435628	0.158112096435628	false	false	false
55f425e0-502d-47de-b308-7840a7946e83	2026-09-23 10:09	2026-09-23 10:09	2026-09-23 10:09	TLT	TLT270617P00080000	put	80.0000	2027-06-17	2.6900	2.6600	2.6900	81.0950	12105.00	12105.00	0.00	45	5	152	83268	0.0018254311380122	0.157919461514764	0.157919461514764	false	false	false
f629e67a-0e10-4ede-ab7b-81524ba78f05	2026-09-23 10:10	2026-09-23 10:10	2026-09-23 10:10	TLT	TLT270617P00080000	put	80.0000	2027-06-17	2.7000	2.6800	2.7000	81.0750	21870.00	21870.00	0.00	81	9	281	83268	0.00337464572224624	0.158043568113801	0.158043568113801	false	false	false
252ab566-e103-472e-948f-42eac1d8040c	2026-09-23 10:10	2026-09-23 10:10	2026-09-23 10:10	TLT	TLT270617P00080000	put	80.0000	2027-06-17	2.7000	2.6800	2.7000	81.0850	18090.00	18090.00	0.00	67	14	366	83268	0.00439544602968728	0.1581779183496	0.1581779183496	false	false	false
52eff6fc-6566-43df-bc87-d41a7b98fdca	2026-09-23 10:10	2026-09-23 10:10	2026-09-23 10:10	TLT	TLT270617P00080000	put	80.0000	2027-06-17	2.7100	2.6800	2.7100	81.0750	36314.00	36314.00	0.00	134	13	500	83268	0.00600470769082961	0.158436069314165	0.158436069314165	false	false	false
42e11f5c-26f0-423d-8679-694f61524734	2026-09-24 13:41	2026-09-24 13:41	2026-09-24 13:41	TLT	TLT270617P00080000	put	80.0000	2027-06-17	3.4600	3.4500	3.5000	79.8400	345608.00	0.00	345608.00	1000	7	1024	83822	0.0122163632459259	0.171064088348574	0.170298349840628	false	false	false
e488eac1-bd9c-416f-9c86-8be30a1d852d	2026-09-29 09:30	2026-09-29 09:30	2026-09-29 09:30	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.2700	4.2500	4.3500	78.5200	196370.00	3440.00	175730.00	460	49	1331	86245	0.0154327787118094	0.181961789240842	0.183876458658029	false	false	false
c30c6622-ccb6-4eff-b7a9-4ba412e51ab1	2026-09-29 09:30	2026-09-29 09:30	2026-09-29 09:30	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.3000	4.3000	4.3500	78.5200	110510.00	0.00	110510.00	257	5	1588	86245	0.0184126616035712	0.183876458658029	0.183876458658029	false	false	false
49228823-f14a-461a-8067-5d874c8772ce	2026-09-29 09:30	2026-09-29 09:30	2026-09-29 09:30	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.3000	4.3000	4.3500	78.4901	197370.00	0.00	197370.00	459	21	2054	86245	0.0238158733839643	0.183380151649431	0.183380151649431	false	false	false
4c70e403-f463-476b-9216-2a3fbcd14aa3	2026-09-29 09:30	2026-09-29 09:30	2026-09-29 09:30	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.3000	4.3000	4.3500	78.5000	299710.00	0.00	299710.00	697	29	2751	86245	0.0318975013044234	0.183544600114157	0.183544600114157	true	false	false
46cd61ce-2e3c-4aff-9093-380fc37976a9	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.3000	4.3000	4.3500	78.4850	36550.00	0.00	36550.00	85	6	2836	86245	0.0328830656849672	0.183295389511254	0.183295389511254	false	false	false
20082770-4717-4784-bd50-76c35ec8e2c0	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.3000	4.3000	4.3500	78.4900	46010.00	0.00	46010.00	107	7	3363	86245	0.0389935648443388	0.183378489949344	0.183378489949344	false	false	false
6b16b675-50a2-4f49-ae23-2fe6137550ed	2026-09-29 11:58	2026-09-29 11:57	2026-09-29 11:57	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.7500	4.7000	4.8000	77.9300	93575.00	16150.00	76950.00	197	18	4268	86245	0.049486926778364	0.191027703059834	0.191114241545331	true	false	false
97e98647-03e6-4766-90a4-026f608f7ee1	2026-09-29 11:58	2026-09-29 11:58	2026-09-29 11:58	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.7900	4.7000	4.8000	77.9450	95800.00	95800.00	0.00	200	8	5336	86245	0.0618702533480202	0.192906432593372	0.192906432593372	false	false	false
52f16135-11d3-4e2d-b4c3-3d18bfc92d80	2026-09-29 11:58	2026-09-29 11:58	2026-09-29 11:58	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.7900	4.7000	4.8000	77.9550	95800.00	95800.00	0.00	200	6	5537	86245	0.0642008232361296	0.193079175560231	0.193079175560231	false	false	false
39440315-01f4-4210-97da-b1308ed6e967	2026-09-29 12:05	2026-09-29 12:05	2026-09-29 12:05	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.8500	4.8000	4.8500	77.0000	96920.00	96920.00	0.00	200	10	6273	86245	0.0727346512841324	0.195292058822792	0.195292058822792	true	false	false
89daed80-8a04-40ca-aac6-822c1b6928da	2026-09-29 12:08	2026-09-29 12:08	2026-09-29 12:08	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.9000	4.8500	4.9000	77.0000	75950.00	75950.00	0.00	155	14	6828	86245	0.0791698069453302	0.197725509018187	0.197725509018187	true	false	false
c06aefd0-9ceb-43ec-ad12-b8c3695d60c9	2026-09-29 12:11	2026-09-29 12:11	2026-09-29 12:11	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.9500	4.9000	4.9500	77.0000	99000.00	99000.00	0.00	200	5	7228	86245	0.0838077569714186	0.199727669359991	0.199727669359991	false	false	false
c9c0532c-dd0a-4bd4-abd0-31d6f716532e	2026-09-29 12:11	2026-09-29 12:11	2026-09-29 12:11	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.9500	4.9000	4.9500	77.0000	99000.00	99000.00	0.00	200	9	7428	86245	0.0861267319844629	0.199813720810969	0.199813720810969	true	false	false
64dba89b-c837-49f3-bd5e-1d37728917e1	2026-09-29 12:16	2026-09-29 12:15	2026-09-29 12:15	TLT	TLT270617P00080000	put	80.0000	2027-06-17	5.0500	4.9500	5.0500	77.9980	10100.00	10100.00	0.00	20	5	8529	86245	0.0988926894312714	0.203783600468369	0.203783600468369	false	false	false
670faf46-25bd-4383-b17f-391b71099216	2026-09-29 12:22	2026-09-29 12:22	2026-09-29 12:22	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.9500	4.9000	5.0500	77.9700	424215.00	0.00	424215.00	857	26	10290	86245	0.119311264421126	0.199469327190395	0.199469327190395	true	false	false
a05e3953-9092-4ab7-ab02-83ee796cee54	2026-09-30 15:40	2026-09-30 15:40	2026-09-30 15:40	TLT	TLT270617P00080000	put	80.0000	2027-06-17	5.0800	5.0000	5.1000	77.6950	15250.00	15250.00	0.00	30	5	124	79975	0.0015504845264145	0.199744667352378	0.200129016502801	false	false	false
ed7dd610-d900-4971-a61e-728d03160e2d	2026-10-02 09:30	2026-10-02 09:30	2026-10-02 09:30	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.8100	4.8000	4.9000	77.9300	132260.00	13700.00	69600.00	275	20	1162	78102	0.0148779800773348	0.191927398465866	0.193852539051502	false	false	false
3f3436f8-362d-4a65-8332-aa28a4bdd3b6	2026-10-02 09:30	2026-10-02 09:30	2026-10-02 09:30	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.8000	4.8000	4.9000	77.9500	49000.00	1960.00	47040.00	102	11	1264	78102	0.0161839645591662	0.191927398465866	0.19227759665543	false	false	false
caab0175-4473-450d-b26d-2e2672657468	2026-10-02 09:30	2026-10-02 09:30	2026-10-02 09:30	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.8200	4.8000	4.9000	77.9101	17370.00	1455.00	10095.00	36	24	1558	78102	0.0199482727715039	0.191578419060509	0.193503691573019	false	false	false
7c2de5cd-0c6b-4b2f-b7c5-b4c97d5f3353	2026-10-02 09:30	2026-10-02 09:30	2026-10-02 09:30	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.8300	4.8000	4.9000	77.9100	42980.00	22795.00	17760.00	89	22	1522	78102	0.019487337072034	0.191576664049906	0.193501937235935	false	false	false
37518f9f-eee7-480e-a177-29c03d2d2604	2026-10-02 09:30	2026-10-02 09:30	2026-10-02 09:30	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.8200	4.8000	4.9000	77.9150	11565.00	3395.00	7200.00	24	10	1582	78102	0.0202555632378172	0.191664398079098	0.193589637719042	false	false	false
9476d3be-152d-4517-942d-84baa45f8c12	2026-10-02 09:30	2026-10-02 09:30	2026-10-02 09:30	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.8000	4.8000	4.9000	77.9200	24960.00	0.00	24960.00	52	6	1634	78102	0.0209213592481627	0.191752098462055	0.191752098462055	false	false	false
23c807cb-e5c7-4f7d-9e65-1bb8fd1463c9	2026-10-02 09:30	2026-10-02 09:30	2026-10-02 09:30	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.8100	4.8000	4.8500	77.9200	113409.00	0.00	113409.00	236	5	1870	78102	0.0239430488335766	0.191752098462055	0.19213713113951	false	false	false
3f410919-3f1f-480a-81ce-d2f6cef0c88a	2026-10-02 09:30	2026-10-02 09:30	2026-10-02 09:30	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.8000	4.8000	4.8500	77.9310	340800.00	0.00	340800.00	710	16	2719	78102	0.034813449079409	0.19194492108736	0.19194492108736	true	false	false
1252108f-e8e2-4b94-a86f-c040efd85078	2026-10-02 09:30	2026-10-02 09:30	2026-10-02 09:30	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.8000	4.8000	4.8500	77.9300	20160.00	0.00	20160.00	42	5	2761	78102	0.0353512073954572	0.191927398465866	0.191927398465866	false	false	false
b1a61d54-fc40-4d88-bb90-de0f3a311ee3	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.8000	4.7500	4.8000	77.9470	15840.00	7680.00	0.00	33	12	2894	78102	0.03705410872961	0.192225101001159	0.192225101001159	false	false	false
5d8dff2d-8872-4336-b21c-518bf06cdee8	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.8000	4.7500	4.8000	77.9470	27360.00	27360.00	0.00	57	11	2951	78102	0.037783923587104	0.192225101001159	0.192225101001159	false	false	false
efbeb8c8-9df9-40ad-89b8-f0e31570d5cc	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.8000	4.7500	4.8500	77.9450	82560.00	4320.00	49440.00	172	48	3123	78102	0.0399861719290159	0.192190097225833	0.192190097225833	true	false	false
8f2d8366-0f3d-4532-bccb-23f905372ee3	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.8000	4.8000	4.8500	77.9350	72960.00	0.00	72960.00	152	8	3275	78102	0.0419323448823334	0.192014998174758	0.192014998174758	false	false	false
573156d2-4669-41ae-85e7-1444fff6050f	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.8000	4.8000	4.8500	77.9400	53280.00	0.00	53280.00	111	8	3386	78102	0.0433535632890323	0.192102564413495	0.192102564413495	false	false	false
651d0805-5450-443a-a6df-4806d7e7ccec	2026-10-02 09:31	2026-10-02 09:31	2026-10-02 09:31	TLT	TLT270617P00080000	put	80.0000	2027-06-17	4.8000	4.8000	4.8500	77.9400	34560.00	0.00	34560.00	72	8	3458	78102	0.0442754346879721	0.192102564413495	0.192102564413495	false	false	false