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×ticker = TQQQ×

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

72c67ea9-057a-4ecc-97ca-79c5a849338d	2026-10-01 13:32	2026-10-01 13:31	2026-10-01 13:31	TQQQ	TQQQ261009C00080000	call	80.0000	2026-10-09	2.1800	2.0400	2.2000	79.0000	13517.00	13298.00	219.00	62	6	1597	2300	0.694347826086957	0.530021371994628	0.531145726052942	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	37728790395.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T17:35:38.726751Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
513f3d38-4d34-4e0d-97b9-e9a9e714baa1	2026-10-01 13:30	2026-10-01 13:30	2026-10-01 13:30	TQQQ	TQQQ261009C00078500	call	78.5000	2026-10-09	3.0000	2.7300	3.2000	79.0000	19500.00	19500.00	0.00	65	5	184	557	0.330341113105925	0.549550013728301	0.549550013728301	true	false	false	true
ebaa8f94-a465-4ac9-96db-e6f0857151cf	2026-10-01 13:30	2026-10-01 13:30	2026-10-01 13:30	TQQQ	TQQQ261002C00080000	call	80.0000	2026-10-02	0.6600	0.6500	0.6800	79.0199	11748.00	264.00	11418.00	178	7	24279	8664	2.80228531855956	0.648550143104436	0.648550143104436	false	false	false
a910fb46-e152-452d-bc91-280d1b9fb9a7	2026-10-01 13:28	2026-10-01 13:28	2026-10-01 13:28	TQQQ	TQQQ261002C00077000	call	77.0000	2026-10-02	2.3300	2.3300	2.4200	78.8275	10252.00	0.00	10252.00	44	6	1738	2328	0.746563573883162	0.734106038461983	0.734106038461983	false	false	false	true
2b912d43-1ef6-4ee9-91e6-e0e7465be450	2026-10-01 13:23	2026-10-01 13:23	2026-10-01 13:23	TQQQ	TQQQ261030C00081000	call	81.0000	2026-10-30	3.9500	3.7000	4.0000	78.5700	24885.00	23305.00	1580.00	63	13	131	1614	0.0811648079306072	0.554904612936125	0.554374541104743	true	false	false
5e7d8533-57c9-4304-bffc-37990c836757	2026-10-01 13:20	2026-10-01 13:20	2026-10-01 13:20	TQQQ	TQQQ261218C00076000	call	76.0000	2026-12-18	10.2000	9.3500	10.2000	78.3300	51000.00	51000.00	0.00	50	9	55	3509	0.0156739811912226	0.609925213668692	0.609925213668692	false	false	false	true
5522d33b-ae2c-40a9-aead-a74a38e03292	2026-10-01 13:13	2026-10-01 13:13	2026-10-01 13:13	TQQQ	TQQQ261009C00076000	call	76.0000	2026-10-09	3.6800	3.6500	3.7000	77.0000	18412.00	7769.00	10643.00	50	8	212	1526	0.138925294888598	0.581034639716376	0.574137590276794	false	false	false
787db7dd-7a2e-4625-9887-bfa4d4e8ea9a	2026-10-01 13:09	2026-10-01 13:08	2026-10-01 13:08	TQQQ	TQQQ261218P00075000	put	75.0000	2026-12-18	7.2500	7.2000	7.4000	77.0000	18125.00	725.00	17400.00	25	5	85	2866	0.0296580600139567	0.634380442013903	0.634380442013903	true	false	false	true
667aed6c-1b5f-4f0d-a61d-08b4881fca83	2026-10-01 13:05	2026-10-01 13:05	2026-10-01 13:05	TQQQ	TQQQ261009P00075500	put	75.5000	2026-10-09	1.6400	1.6200	1.9800	77.7500	22796.00	163.00	22633.00	139	12	291	437	0.665903890160183	0.580938466654549	0.581029364247012	true	false	false	true
0c041d96-7abc-49b8-8e29-69414b598d26	2026-10-01 13:04	2026-10-01 13:04	2026-10-01 13:04	TQQQ	TQQQ261002C00080000	call	80.0000	2026-10-02	0.2700	0.2700	0.2900	77.5700	27000.00	0.00	27000.00	1000	20	23073	8664	2.66308864265928	0.652317386368179	0.652317386368179	true	false	false
487c7a5b-968e-48ca-b25d-ab3105f7804e	2026-10-01 13:02	2026-10-01 13:02	2026-10-01 13:02	TQQQ	TQQQ261023P00073000	put	73.0000	2026-10-23	2.5100	2.4400	2.7600	77.6700	18572.00	248.00	18324.00	74	5	301	831	0.362214199759326	0.614758186181971	0.61051107132488	true	false	false	true
e397807d-7f26-40f4-af51-1c286c0538e9	2026-10-01 13:02	2026-10-01 13:02	2026-10-01 13:02	TQQQ	TQQQ261016P00070000	put	70.0000	2026-10-16	1.2500	1.2400	1.3400	77.5500	16875.00	0.00	16875.00	135	5	1087	4803	0.226316885280033	0.664723790562603	0.664723790562603	false	false	false	true
65d9f953-1e3e-473f-9085-b4f40049cff5	2026-10-01 12:57	2026-10-01 12:57	2026-10-01 12:57	TQQQ	TQQQ261030P00074000	put	74.0000	2026-10-30	3.8000	3.8000	3.9000	77.1925	25840.00	0.00	25840.00	68	6	276	796	0.346733668341709	0.63009186474458	0.63009186474458	true	false	false	true
b75f2fc8-78d1-4d39-8d1a-ef200b9d8a69	2026-10-01 12:56	2026-10-01 12:56	2026-10-01 12:56	TQQQ	TQQQ261106P00068000	put	68.0000	2026-11-06	2.6500	2.4300	2.6600	77.1300	28620.00	25440.00	530.00	108	7	137	405	0.338271604938272	0.692400716524894	0.692400716524894	true	false	false	true
5e1e7307-4adb-4535-82f4-50f1c6f251fc	2026-10-01 12:55	2026-10-01 12:55	2026-10-01 12:55	TQQQ	TQQQ261023P00073000	put	73.0000	2026-10-23	2.6600	2.4400	2.7000	77.2450	28728.00	28461.00	267.00	108	10	225	831	0.270758122743682	0.61812348657924	0.618886788338527	true	false	false	true
56ae4222-6d75-4069-a3c7-d6366fca61d5	2026-10-01 12:54	2026-10-01 12:54	2026-10-01 12:54	TQQQ	TQQQ261016P00075000	put	75.0000	2026-10-16	2.5800	2.4200	2.5900	77.3300	29154.00	29154.00	0.00	113	10	1364	5806	0.234929383396486	0.599780645993881	0.599587017854501	true	false	false	true
e3bb30e7-1b51-4a51-b871-97f99fc28db8	2026-10-01 12:53	2026-10-01 12:52	2026-10-01 12:52	TQQQ	TQQQ261106P00055000	put	55.0000	2026-11-06	0.7600	0.7600	0.7700	77.5400	30552.00	0.00	30552.00	402	8	488	899	0.542825361512792	0.843182210527146	0.843073699775152	false	false	false	true
3e3ac12e-eca0-4f90-9767-bf81fb0b52e8	2026-10-01 12:52	2026-10-01 12:51	2026-10-01 12:51	TQQQ	TQQQ261218C00066000	call	66.0000	2026-12-18	16.1500	16.1500	16.5000	77.5100	37145.00	0.00	37145.00	23	7	23	422	0.0545023696682464	0.67279133768097	0.67279133768097	false	false	false	true
115d4557-1a1e-40b6-935a-040398ad9bbc	2026-10-01 12:51	2026-10-01 12:51	2026-10-01 12:51	TQQQ	TQQQ261016P00078000	put	78.0000	2026-10-16	3.7000	3.6500	3.7000	77.5400	37740.00	37740.00	0.00	102	12	376	1418	0.265162200282087	0.562319392176335	0.562319392176335	true	false	false	true
b33ebde2-375d-411c-8462-f4f9aa3250f6	2026-10-01 12:49	2026-10-01 12:49	2026-10-01 12:49	TQQQ	TQQQ261005P00078000	put	78.0000	2026-10-05	1.7400	1.7200	1.7900	77.7300	10422.00	0.00	10422.00	60	5	339	466	0.727467811158798	0.492005056698312	0.49816926004292	false	false	false	true
c3fbe581-4ed6-4480-9471-e2fc7a3a2e40	2026-10-01 12:40	2026-10-01 12:40	2026-10-01 12:40	TQQQ	TQQQ261113P00073500	put	73.5000	2026-11-13	4.5500	4.5500	4.8000	77.6301	80990.00	0.00	80990.00	178	7	193	0	0	0.636121849483496	0.636121849483496	false	false	false	true
45878548-e22d-4f24-a53f-1e5f9851ef57	2026-10-01 12:38	2026-10-01 12:38	2026-10-01 12:38	TQQQ	TQQQ261016C00080000	call	80.0000	2026-10-16	2.3900	2.3800	2.5300	77.5900	11473.00	239.00	11234.00	48	7	444	5070	0.0875739644970414	0.53461655969287	0.535633902174167	true	false	false	true
10a5fbac-a344-4013-88e5-8a636f03e546	2026-10-01 12:38	2026-10-01 12:38	2026-10-01 12:38	TQQQ	TQQQ261023C00074000	call	74.0000	2026-10-23	6.6000	6.6000	6.8500	77.6901	38285.00	0.00	38285.00	58	15	61	218	0.279816513761468	0.593291544533122	0.593291544533122	false	false	false	true
a684064e-cbd7-46bf-9161-20f81b0ea895	2026-10-01 12:37	2026-10-01 12:37	2026-10-01 12:37	TQQQ	TQQQ261002C00080000	call	80.0000	2026-10-02	0.3300	0.3200	0.3500	77.8600	20295.00	0.00	20262.00	615	22	20479	8664	2.36368882733149	0.651232088757896	0.653055175390135	true	false	false
5a532b2c-00d9-4091-9796-679d0d2adc62	2026-10-01 12:37	2026-10-01 12:37	2026-10-01 12:37	TQQQ	TQQQ261030C00081000	call	81.0000	2026-10-30	3.6500	3.4500	3.7000	77.9200	21900.00	21535.00	365.00	60	8	68	1614	0.0421313506815366	0.553591494831639	0.553591494831639	false	false	false
ace2e179-7ffe-4563-a5b3-aa567fb6ceb5	2026-10-01 12:33	2026-10-01 12:33	2026-10-01 12:33	TQQQ	TQQQ261002C00078000	call	78.0000	2026-10-02	1.0700	1.0600	1.0700	77.8150	21400.00	21400.00	0.00	200	13	6261	9967	0.628172970803652	0.710702617053021	0.710702617053021	false	false	false
65743513-e7ec-4a9c-a6b2-398d485f59fb	2026-10-01 12:17	2026-10-01 12:17	2026-10-01 12:17	TQQQ	TQQQ261016P00075000	put	75.0000	2026-10-16	2.5000	2.4500	2.6000	77.6300	19748.00	247.00	19501.00	79	9	1208	5806	0.208060626937651	0.602957723922551	0.597863821852646	true	false	false	true
eda90f5d-9a2e-45f8-ba63-af959e4850ac	2026-10-01 12:07	2026-10-01 12:07	2026-10-01 12:07	TQQQ	TQQQ261120P00062000	put	62.0000	2026-11-20	2.1600	2.1600	2.2200	77.6700	19872.00	0.00	19872.00	92	7	104	249	0.417670682730924	0.748776901530575	0.74889264398842	true	false	false	true
310238af-15e1-4111-bfdf-8cc791a509ae	2026-10-01 11:56	2026-10-01 11:55	2026-10-01 11:55	TQQQ	TQQQ261106P00074000	put	74.0000	2026-11-06	4.3500	4.3000	4.6500	77.3800	61338.00	435.00	60903.00	141	9	147	98	1.5	0.636512808125329	0.636512808125329	true	false	false	true
f682eb54-3a5c-4bdb-bd62-8b1eefcef829	2026-10-01 11:53	2026-10-01 11:53	2026-10-01 11:53	TQQQ	TQQQ270115C00080000	call	80.0000	2027-01-15	8.8000	8.8000	9.1500	77.0050	2705120.00	0.00	2705120.00	3074	36	3141	9624	0.326371571072319	0.584980881258161	0.584980881258161	false	false	false
1139f978-b185-47f9-8480-a423e7605f24	2026-10-01 11:48	2026-10-01 11:48	2026-10-01 11:48	TQQQ	TQQQ261106P00073000	put	73.0000	2026-11-06	4.0500	4.0500	4.2500	77.0000	26325.00	0.00	26325.00	65	6	103	70	1.47142857142857	0.644676486910276	0.644676486910276	false	false	false	true
e1c068aa-571b-4b5d-9fc0-090e95bb8edc	2026-10-01 11:36	2026-10-01 11:36	2026-10-01 11:36	TQQQ	TQQQ261218C00070000	call	70.0000	2026-12-18	13.2000	13.2000	14.2500	77.0000	191400.00	0.00	191400.00	145	5	183	4665	0.0392282958199357	0.6565189493471	0.6565189493471	false	false	false
a5d8478f-bf14-405d-a21e-a7a4355d723f	2026-10-01 11:32	2026-10-01 11:32	2026-10-01 11:32	TQQQ	TQQQ261016P00069000	put	69.0000	2026-10-16	1.1800	1.0500	1.3700	77.4000	12390.00	12271.00	119.00	105	17	173	1653	0.104658197217181	0.695735162408946	0.698120610025898	true	false	false	true
7a9e02c2-9983-460c-b4e4-b11174666170	2026-10-01 11:30	2026-10-01 11:30	2026-10-01 11:30	TQQQ	TQQQ261023P00078000	put	78.0000	2026-10-23	4.5000	3.9500	4.5000	77.5600	36000.00	36000.00	0.00	80	6	123	195	0.630769230769231	0.575239046829294	0.575239046829294	false	false	false	true
016960e6-bb9a-41ca-a57c-0a1be415cebe	2026-10-01 11:29	2026-10-01 11:29	2026-10-01 11:29	TQQQ	TQQQ261009P00077000	put	77.0000	2026-10-09	2.3100	1.9700	2.3700	77.6600	34881.00	34650.00	231.00	151	11	650	361	1.8005540166205	0.582421037276243	0.582421037276243	true	false	false	true
e0dc2ca3-b121-4a67-88c1-5b2282f47dd9	2026-10-01 11:16	2026-10-01 11:16	2026-10-01 11:16	TQQQ	TQQQ261016P00077000	put	77.0000	2026-10-16	3.3000	3.3000	3.7000	77.6499	108240.00	0.00	108240.00	328	7	438	1106	0.396021699819168	0.588570462211671	0.588570462211671	true	false	false	true
4e989ba3-3914-4a4f-b6da-4263dc3d8432	2026-10-01 11:10	2026-10-01 11:10	2026-10-01 11:10	TQQQ	TQQQ261120P00060000	put	60.0000	2026-11-20	2.0000	1.9900	2.0000	76.9500	11200.00	11200.00	0.00	56	7	147	8987	0.0163569600534105	0.777202600740628	0.777202600740628	false	false	false	true
08fe2482-1c25-4886-8ab9-65988982a71c	2026-10-01 11:08	2026-10-01 11:08	2026-10-01 11:08	TQQQ	TQQQ261016P00071500	put	71.5000	2026-10-16	1.8000	1.5000	1.8500	77.0000	20342.00	20160.00	182.00	113	6	115	217	0.529953917050691	0.669229079628401	0.673503910687538	true	false	false	true
a9920216-017d-409d-afd1-8be83fdc63c4	2026-10-01 11:08	2026-10-01 11:07	2026-10-01 11:07	TQQQ	TQQQ261016P00077000	put	77.0000	2026-10-16	3.5500	3.5000	3.6000	77.0000	12070.00	10295.00	1775.00	34	11	102	1106	0.0922242314647378	0.599754111281082	0.599754111281082	true	false	false	true
abd5e2a0-bdf7-48a3-9498-0b4afd25788c	2026-10-01 11:05	2026-10-01 11:05	2026-10-01 11:05	TQQQ	TQQQ261120P00056000	put	56.0000	2026-11-20	1.3900	1.3900	1.4100	77.5281	54071.00	0.00	54071.00	389	28	418	3308	0.126360338573156	0.821219114509393	0.821219114509393	false	false	false	true
1df4f0ad-980e-4036-b549-3cafd6fcdc79	2026-10-01 11:03	2026-10-01 11:02	2026-10-01 11:02	TQQQ	TQQQ261106P00066000	put	66.0000	2026-11-06	2.2500	1.9600	2.2800	77.3500	32851.00	32625.00	226.00	146	9	154	131	1.17557251908397	0.724544115655854	0.725998590412211	true	false	false	true
0aa281d6-7f08-4fb7-8862-b5394df85452	2026-10-01 11:01	2026-10-01 11:01	2026-10-01 11:01	TQQQ	TQQQ261023P00077500	put	77.5000	2026-10-23	4.3500	3.9500	4.4000	77.4350	43935.00	43935.00	0.00	101	6	275	112	2.45535714285714	0.582558331912629	0.582558331912629	false	false	false	true
72dc9490-ddba-4b13-b54e-9eb1bd1f6973	2026-10-01 10:59	2026-10-01 10:59	2026-10-01 10:59	TQQQ	TQQQ261009P00076500	put	76.5000	2026-10-09	2.2300	2.0500	2.2700	77.4800	10926.00	10703.00	223.00	49	14	214	241	0.887966804979253	0.59994679300344	0.599007798173507	true	false	false	true
3e5e7f1c-0746-417a-b1d4-fbc294033435	2026-10-01 10:59	2026-10-01 10:59	2026-10-01 10:59	TQQQ	TQQQ261016P00078000	put	78.0000	2026-10-16	3.8500	3.4000	3.9000	77.4900	19250.00	17325.00	1925.00	50	8	238	1418	0.167842031029619	0.582321219487531	0.582321219487531	true	false	false	true
c2bbdefd-13e2-4410-bab7-840b1aefea26	2026-10-01 10:53	2026-10-01 10:53	2026-10-01 10:53	TQQQ	TQQQ270319P00048000	put	48.0000	2027-03-19	3.0900	2.9700	3.1000	77.5400	46290.00	46290.00	0.00	150	15	451	91	4.95604395604396	0.795812504123401	0.795812504123401	false	false	false	true
e73f0095-32cc-4c15-8fa8-95caef251fee	2026-10-01 10:51	2026-10-01 10:51	2026-10-01 10:51	TQQQ	TQQQ261016P00076000	put	76.0000	2026-10-16	2.8700	2.8300	2.8800	77.7800	46494.00	45920.00	0.00	162	10	178	516	0.344961240310078	0.603280719611777	0.603280719611777	false	false	false	true
cff81c5b-7d0b-40e5-a899-0043ddcf4f6b	2026-10-01 10:51	2026-10-01 10:51	2026-10-01 10:51	TQQQ	TQQQ261016P00075000	put	75.0000	2026-10-16	2.5100	2.4000	2.5300	77.7800	73552.00	73300.00	0.00	293	15	933	5806	0.160695831898037	0.613795905055857	0.615496791905978	true	false	false	true
02d3f5b3-ba9c-4636-960d-6e2733be0315	2026-10-01 10:51	2026-10-01 10:51	2026-10-01 10:51	TQQQ	TQQQ261120P00057000	put	57.0000	2026-11-20	1.4400	1.3000	1.4400	77.8100	23904.00	23904.00	0.00	166	10	169	1089	0.155188246097337	0.803615445430376	0.803615445430376	true	false	false	true
7f266a85-12ae-4623-bcb2-f3c31b6cf76c	2026-10-01 10:50	2026-10-01 10:50	2026-10-01 10:50	TQQQ	TQQQ261030P00063500	put	63.5000	2026-10-30	1.3000	1.2900	1.3000	77.8500	17420.00	17420.00	0.00	134	8	274	1668	0.164268585131894	0.753604570886832	0.753604570886832	false	false	false	true
58d59988-7238-44f0-a037-cb65b357421d	2026-10-01 10:41	2026-10-01 10:41	2026-10-01 10:41	TQQQ	TQQQ261005C00078000	call	78.0000	2026-10-05	1.7000	1.5400	1.9400	77.9920	21420.00	11560.00	2040.00	126	12	455	504	0.902777777777778	0.51801679485978	0.51801679485978	false	false	false