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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = LQD×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

fb5b465d-db62-4037-8818-ce45049247cf	2026-08-24 10:01	2026-08-24 10:01	2026-08-24 10:01	LQD	LQD260925P00106000	put	106.0000	2026-09-25	0.8000	0.8000	0.8500	106.1800	27760.00	0.00	27760.00	347	31	353	143	2.46853146853147	0.0835088621609098	0.0835088621609098	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	27583004809.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
09f601ac-f357-477a-b9f2-d3595aefe029	2026-08-21 15:24	2026-08-21 15:24	2026-08-21 15:24	LQD	LQD261218P00106000	put	106.0000	2026-12-18	2.1800	2.1800	2.2300	105.9050	65182.00	0.00	65182.00	299	8	1500	24027	0.0624297665126732	0.114876914803936	0.114876914803936	false	false	false	true
587404e6-e074-4324-a4e8-e0755fbdaf18	2026-08-21 15:23	2026-08-21 15:23	2026-08-21 15:23	LQD	LQD261218P00106000	put	106.0000	2026-12-18	2.1800	2.1800	2.2300	105.9050	261600.00	0.00	261600.00	1200	5	1201	24027	0.0499854330544804	0.114876914803936	0.114876914803936	false	false	false	true
155f4422-f332-4e06-978e-0f4e865200e2	2026-08-21 10:56	2026-08-21 10:56	2026-08-21 10:56	LQD	LQD260918P00106000	put	106.0000	2026-09-18	0.9200	0.8800	0.9200	105.9103	25116.00	24748.00	0.00	273	18	1007	44710	0.0225229255200179	0.0877412013759686	0.0877412013759686	false	false	false	true
470b6993-9663-45c1-8b41-81b26e211d51	2026-08-21 10:56	2026-08-21 10:55	2026-08-21 10:55	LQD	LQD260918P00106000	put	106.0000	2026-09-18	0.9200	0.9000	0.9400	105.9100	12880.00	7084.00	5796.00	140	34	734	44710	0.0164169089689108	0.087531154478051	0.087729320293814	true	false	false	true
75e8721d-6630-4d7d-aa04-0d3a8272ad05	2026-08-21 10:31	2026-08-21 10:31	2026-08-21 10:31	LQD	LQD260904C00106000	call	106.0000	2026-09-04	0.4400	0.4400	0.4800	105.9200	12628.00	0.00	12628.00	287	22	681	623	1.09309791332263	0.0485582064044394	0.0485582064044394	false	false	false	true
4dc05dbd-1461-4828-9ab3-375c6004e2e2	2026-08-21 10:12	2026-08-21 10:12	2026-08-21 10:12	LQD	LQD260904C00106000	call	106.0000	2026-09-04	0.4700	0.4700	0.5200	105.9603	17437.00	0.00	17437.00	371	25	388	623	0.622792937399679	0.0495636883782497	0.0495636883782497	false	false	false	true
81c533ba-8bfa-4da1-8122-7c97c5432f03	2026-08-21 09:55	2026-08-21 09:54	2026-08-21 09:54	LQD	LQD260828P00106000	put	106.0000	2026-08-28	0.3700	0.3600	0.4000	105.9600	78921.00	555.00	78366.00	2133	24	2138	1189	1.79814970563499	0.0663468769250715	0.0663468769250715	false	false	false	true
b7a9d3a6-6943-4f21-89c0-61ef3266d7bd	2026-08-20 15:32	2026-08-20 15:32	2026-08-20 15:32	LQD	LQD261218C00104000	call	104.0000	2026-12-18	2.8600	2.6900	3.1000	106.1250	36036.00	35464.00	572.00	126	26	126	27	4.66666666666667	0.0602464403354525	0.0602464403354525	false	false	false	true
18852916-d197-45de-ae75-2a3022104022	2026-08-20 14:29	2026-08-20 14:29	2026-08-20 14:29	LQD	LQD260918C00106000	call	106.0000	2026-09-18	0.7300	0.7300	0.7400	106.0350	10001.00	0.00	10001.00	137	13	160	12341	0.0129649137022932	0.04500055485402	0.04500055485402	false	false	false	true
cec5d696-d70a-458c-8d17-758e464c9bf8	2026-08-20 10:45	2026-08-20 10:45	2026-08-20 10:45	LQD	LQD270115P00108000	put	108.0000	2027-01-15	3.3000	3.1000	3.3500	106.1434	33000.00	26730.00	6270.00	100	6	200	29	6.89655172413793	0.119625460520946	0.119625460520946	false	false	false	true
2fe96381-3dbf-42b3-ace1-d85b6b4b9998	2026-08-19 15:45	2026-08-19 15:45	2026-08-19 15:45	LQD	LQD260821C00106500	call	106.5000	2026-08-21	0.2500	0.2100	0.2600	106.5350	10820.00	10700.00	120.00	433	42	4861	25219	0.192751496887268	0.0700413152125786	0.0700413152125786	false	false	false	true
d42be934-2c1d-4493-a9d6-3112028e9a92	2026-08-19 15:22	2026-08-19 15:22	2026-08-19 15:22	LQD	LQD260918C00106000	call	106.0000	2026-09-18	1.0600	1.0200	1.0600	106.5050	22790.00	22790.00	0.00	215	31	4417	9579	0.461112851028291	0.0448787521289842	0.0448787521289842	false	false	false	true
62b5b8e0-4af3-41b7-936f-23d4763dc31c	2026-08-19 14:47	2026-08-19 14:47	2026-08-19 14:47	LQD	LQD260918P00104000	put	104.0000	2026-09-18	0.2100	0.2000	0.2100	106.4850	13671.00	13671.00	0.00	651	7	2162	84643	0.0255425729239276	0.0898614850841749	0.0898614850841749	false	false	false	true
7005042f-1b74-4bb9-a2c5-f731fccdcc62	2026-08-19 14:31	2026-08-19 14:30	2026-08-19 14:30	LQD	LQD260918C00106000	call	106.0000	2026-09-18	1.0300	0.9700	1.0300	106.4550	41200.00	41200.00	0.00	400	39	4093	9579	0.427288861050214	0.0454870936958152	0.0454870936958152	false	false	false	true
ec15a1be-0385-43e0-82a3-71aeb922f887	2026-08-19 12:50	2026-08-19 12:50	2026-08-19 12:50	LQD	LQD260918C00105000	call	105.0000	2026-09-18	1.7700	1.6900	1.7700	106.4050	42834.00	42834.00	0.00	242	41	242	5444	0.044452608376194	0.0394780640539534	0.0394780640539534	false	false	false	true
cb96b79e-d648-41ce-85f3-4c02312de4eb	2026-08-19 11:12	2026-08-19 11:12	2026-08-19 11:12	LQD	LQD260918C00106000	call	106.0000	2026-09-18	1.0700	1.0100	1.0700	106.5100	59920.00	59920.00	0.00	560	48	3206	9579	0.334690468733688	0.0455081708240944	0.0455081708240944	false	false	false	true
d10d593e-1b14-47a2-948e-3e32b6ff0e44	2026-08-19 10:52	2026-08-19 10:52	2026-08-19 10:52	LQD	LQD260918C00106000	call	106.0000	2026-09-18	1.0700	1.0100	1.0700	106.5300	76291.00	76291.00	0.00	713	51	1639	9579	0.171103455475519	0.0440356743239677	0.0440356743239677	false	false	false	true
d687aeed-4bfd-43ff-8594-cf95e4d82541	2026-08-19 10:47	2026-08-19 10:47	2026-08-19 10:47	LQD	LQD260918C00106000	call	106.0000	2026-09-18	1.0800	1.0200	1.0800	106.5550	60912.00	60912.00	0.00	564	46	883	9579	0.0921808121933396	0.0431499682473403	0.0431499682473403	false	false	false	true
e33fec8a-3c21-4bb6-9d32-fe1b5dfe7086	2026-08-19 10:03	2026-08-19 10:03	2026-08-19 10:03	LQD	LQD260918C00106000	call	106.0000	2026-09-18	1.0600	1.0500	1.0900	106.5950	10600.00	1590.00	9010.00	100	11	100	9579	0.0104395030796534	0.0376532793951514	0.0376532793951514	false	false	false	true
aa5f1798-65b7-4908-a7b7-37092fc86206	2026-08-18 14:52	2026-08-18 14:52	2026-08-18 14:52	LQD	LQD260918C00106000	call	106.0000	2026-09-18	0.7100	0.6800	0.7200	105.8800	65320.00	65320.00	0.00	920	7	3084	7307	0.422061037361434	0.0481119836788649	0.0481119836788649	false	false	false	true
f03daa08-93e9-497e-8aeb-31c27abf4153	2026-08-18 14:44	2026-08-18 14:44	2026-08-18 14:44	LQD	LQD260918P00104000	put	104.0000	2026-09-18	0.3300	0.3100	0.3300	105.8650	33000.00	33000.00	0.00	1000	6	1458	83365	0.0174893540454627	0.0900574017643763	0.0900574017643763	false	false	false	true
43cf5948-5341-4fa1-9050-4de967cef748	2026-08-18 14:30	2026-08-18 14:30	2026-08-18 14:30	LQD	LQD260918C00106000	call	106.0000	2026-09-18	0.7300	0.6800	0.8300	105.8850	29638.00	28616.00	1022.00	406	30	2128	7307	0.291227589982209	0.0495255483037443	0.0495255483037443	false	false	false	true
e40f8708-b3ed-444f-b44e-60343982ad43	2026-08-18 14:22	2026-08-18 14:22	2026-08-18 14:22	LQD	LQD260918C00106000	call	106.0000	2026-09-18	0.7300	0.6800	0.7300	105.8950	13870.00	13870.00	0.00	190	22	1052	7307	0.14397153414534	0.049061585747094	0.049061585747094	false	false	false	true
32f7c789-99c9-4c61-b474-340f854b730b	2026-08-18 13:21	2026-08-18 13:21	2026-08-18 13:21	LQD	LQD260918C00107000	call	107.0000	2026-09-18	0.2700	0.2400	0.2700	105.8363	24624.00	24624.00	0.00	912	14	1061	10138	0.104655750641152	0.0478329160582123	0.0478329160582123	false	false	false	true
620efdb7-af53-44e6-aa26-f7bc0a3bab8a	2026-08-18 12:20	2026-08-18 12:20	2026-08-18 12:20	LQD	LQD260904C00105500	call	105.5000	2026-09-04	0.8000	0.7400	0.9500	105.7750	21600.00	21440.00	160.00	270	34	270	0	0	0.0592436575251034	0.0592436575251034	false	false	false	true
b62b37cd-8b8a-4b78-9e66-cf5d4adf59df	2026-08-18 11:42	2026-08-18 11:42	2026-08-18 11:42	LQD	LQD260918C00106000	call	106.0000	2026-09-18	0.6400	0.6000	0.6400	105.6750	24192.00	24192.00	0.00	378	36	386	7307	0.0528260572054195	0.0513458773522207	0.0513458773522207	false	false	false	true
3464ca22-b0f3-4828-8409-ff802f6aba0f	2026-08-18 10:27	2026-08-18 10:27	2026-08-18 10:27	LQD	LQD260918C00105000	call	105.0000	2026-09-18	1.2400	1.1700	1.2400	105.6550	55056.00	55056.00	0.00	444	34	446	5006	0.0890930882940471	0.0506640685212994	0.0506640685212994	false	false	false	true
06576d61-4f75-455b-ab2b-879f067ec8d8	2026-08-17 14:57	2026-08-17 14:57	2026-08-17 14:57	LQD	LQD261218C00106000	call	106.0000	2026-12-18	1.3700	1.3700	1.5100	105.6850	95900.00	0.00	95900.00	700	7	4683	11729	0.399266774661096	0.02857904002883	0.02857904002883	false	false	false	true
e962e82f-b34a-499c-a85c-344103794876	2026-08-17 12:41	2026-08-17 12:40	2026-08-17 12:40	LQD	LQD260821P00106000	put	106.0000	2026-08-21	0.2800	0.2600	0.2800	105.8950	13972.00	13972.00	0.00	499	7	1542	45894	0.0335991632893189	0.0561324865344227	0.0561324865344227	false	false	false	true
1287eca7-c559-4f06-959c-ca986b726d34	2026-08-17 12:09	2026-08-17 12:09	2026-08-17 12:09	LQD	LQD260821P00106000	put	106.0000	2026-08-21	0.2700	0.2600	0.2700	105.9050	10800.00	10800.00	0.00	400	6	1043	45894	0.0227262823026975	0.0550770347943466	0.0550770347943466	false	false	false	true
ae515136-14d8-4d1e-8833-f82afb4b28d3	2026-08-17 10:40	2026-08-17 10:40	2026-08-17 10:40	LQD	LQD260821C00106000	call	106.0000	2026-08-21	0.2900	0.2800	0.2900	106.0150	13282.00	13282.00	0.00	458	6	1155	1243	0.929203539823009	0.058609817642824	0.058609817642824	false	false	false	true
ee31d02a-3b9b-4749-a95e-87b0e3bbb7e0	2026-08-17 10:30	2026-08-17 10:30	2026-08-17 10:30	LQD	LQD260821C00106000	call	106.0000	2026-08-21	0.2800	0.2700	0.2800	105.9900	15372.00	14000.00	0.00	549	7	697	1243	0.560740144810941	0.0593436449899234	0.0593436449899234	false	false	false	true