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

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

6e2cf264-0185-46a8-b565-35c3a87839f6	2026-08-27 10:16	2026-08-27 10:15	2026-08-27 10:15	UNG	UNG261016C00010000	call	10.0000	2026-10-16	1.1500	1.1400	1.1600	10.7150	11040.00	0.00	10925.00	96	31	871	19429	0.0448298934582325	0.460653425416598	0.460653425416598	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	Financial Services	822871397.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
042e5f7a-b8a6-4a84-a105-a6a96dbc8009	2026-08-26 15:43	2026-08-26 15:43	2026-08-26 15:43	UNG	UNG270115C00010000	call	10.0000	2027-01-15	1.7800	1.7700	1.8000	10.4050	178000.00	4272.00	156640.00	1000	11	1762	9605	0.183446121811556	0.592702753498444	0.592702753498444	false	false	false	true
50716320-a4b0-42de-8ae9-21fe96f56355	2026-08-26 14:21	2026-08-26 14:20	2026-08-26 14:20	UNG	UNG261016C00010000	call	10.0000	2026-10-16	0.9300	0.9200	0.9300	10.3500	18600.00	18600.00	0.00	200	19	4114	19691	0.208927936620791	0.470501978112466	0.470501978112466	false	false	false	true
2410a0f8-9e08-4a43-8ae8-6c29f03c8da9	2026-08-26 13:53	2026-08-26 13:53	2026-08-26 13:53	UNG	UNG261016C00010000	call	10.0000	2026-10-16	0.9300	0.9300	0.9500	10.3901	17209.00	190.00	17019.00	185	36	3754	19691	0.190645472550912	0.45331848877099	0.466988726270683	false	false	false	true
5751b3c1-ad99-4b64-b09c-466186389067	2026-08-26 11:50	2026-08-26 11:50	2026-08-26 11:50	UNG	UNG261016C00012000	call	12.0000	2026-10-16	0.2800	0.2600	0.3000	10.4300	25760.00	196.00	25564.00	920	26	2754	6286	0.438116449252307	0.495203976662288	0.495203976662288	false	false	false	true
394e914d-0078-4634-a457-5c1ed840decf	2026-08-26 11:44	2026-08-26 11:44	2026-08-26 11:44	UNG	UNG270115C00010000	call	10.0000	2027-01-15	1.8000	1.8000	1.8500	10.4499	14400.00	0.00	14400.00	80	6	487	9605	0.0507027589796981	0.589266177146601	0.589266177146601	false	false	false	true
d8cb70e7-e4b1-42f0-8bef-225486ccadd2	2026-08-26 11:31	2026-08-26 11:30	2026-08-26 11:30	UNG	UNG260918C00009500	call	9.5000	2026-09-18	1.0900	1.0000	1.0900	10.4350	21800.00	21800.00	0.00	200	8	600	20	30	0.463515578165952	0.463515578165952	false	false	false	true
eaab5aad-1b6b-4e03-93c9-66b785f93cbf	2026-08-26 09:58	2026-08-26 09:58	2026-08-26 09:58	UNG	UNG261016C00011000	call	11.0000	2026-10-16	0.4900	0.4900	0.5200	10.3301	45227.00	0.00	45227.00	923	14	1173	11255	0.104220346512661	0.47821226321482	0.47821226321482	false	false	false	true
57e9e39d-15c2-4453-a5b8-bb154e2aad4d	2026-08-26 09:34	2026-08-26 09:34	2026-08-26 09:34	UNG	UNG270115C00010000	call	10.0000	2027-01-15	1.7300	1.7300	1.7800	10.3250	20760.00	0.00	20760.00	120	10	161	9605	0.016762103071317	0.592761391935299	0.592761391935299	false	false	false	true
2a3c94b9-b9c9-42f8-b2b2-26ce16b9a828	2026-08-25 15:22	2026-08-25 15:22	2026-08-25 15:22	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.5000	1.4900	1.5100	10.2250	27000.00	9300.00	13650.00	180	7	73569	4761	15.4524259609326	0.473909144150919	0.473909144150919	true	false	false	true
5f4902da-793d-48e1-9599-f32e61dee795	2026-08-25 14:52	2026-08-25 14:52	2026-08-25 14:52	UNG	UNG261002C00009500	call	9.5000	2026-10-02	1.0300	0.9200	1.0300	10.1879	41200.00	41200.00	0.00	400	9	934	19	49.1578947368421	0.474044368216543	0.474044368216543	false	false	false	true
3dde2f07-fd35-405c-a494-5e2570a77429	2026-08-25 14:03	2026-08-25 14:03	2026-08-25 14:03	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.4500	1.4400	1.4500	10.0000	25230.00	25230.00	0.00	174	7	71976	4761	15.1178323881537	0.470013955416724	0.470013955416724	true	false	false	true
39432cea-cd98-48e6-9a9e-69cca7b514ac	2026-08-25 12:20	2026-08-25 12:20	2026-08-25 12:20	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3600	1.3500	1.3600	10.0550	25840.00	25840.00	0.00	190	10	68235	4761	14.3320730938878	0.468074216895263	0.468074216895263	true	false	false	true
3e6fe097-3dc3-4f85-8093-44a4e8f36b6f	2026-08-25 12:15	2026-08-25 12:14	2026-08-25 12:14	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3600	1.3500	1.3700	10.0550	22440.00	0.00	21760.00	165	8	67484	4761	14.1743331232934	0.468074216895263	0.468074216895263	false	false	false	true
20a97c81-f16d-4fde-88a3-e563ed462216	2026-08-25 12:00	2026-08-25 11:59	2026-08-25 11:59	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3700	1.3600	1.3700	10.0450	27400.00	27400.00	0.00	200	15	66517	4761	13.9712245326612	0.483381095561794	0.483381095561794	false	false	false	true
c775128c-bc10-43dc-b69f-f4c3dca8618f	2026-08-25 11:55	2026-08-25 11:55	2026-08-25 11:55	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3600	1.3600	1.3700	10.0500	10880.00	0.00	10880.00	80	6	65430	4761	13.7429111531191	0.471431461458348	0.471431461458348	false	false	false	true
552ce7d2-58eb-4f73-b59a-1dd535497782	2026-08-25 11:48	2026-08-25 11:48	2026-08-25 11:48	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3500	1.3500	1.3600	10.0300	72225.00	0.00	72225.00	535	21	64443	4761	13.5356017643352	0.476058089088428	0.476058089088428	false	false	false	true
887f9859-922c-4a89-a2c4-85ae86f8972f	2026-08-25 11:47	2026-08-25 11:47	2026-08-25 11:47	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3500	1.3500	1.3600	10.0400	25110.00	0.00	25110.00	186	11	63746	4761	13.3892039487503	0.469432588938085	0.469432588938085	false	false	false	true
15b1c3ff-8ab4-4c3a-a217-1fb452be016e	2026-08-25 11:39	2026-08-25 11:39	2026-08-25 11:39	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3400	1.3400	1.3500	10.0307	66866.00	0.00	66866.00	499	29	61579	4761	12.9340474690191	0.46696189655479	0.46696189655479	false	false	false	true
c532c187-a9bf-4f7d-bc1e-6fde332defb3	2026-08-25 11:38	2026-08-25 11:38	2026-08-25 11:38	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3500	1.3400	1.3600	10.0500	120825.00	0.00	119475.00	895	51	60756	4761	12.7611846250788	0.46271121666946	0.46271121666946	false	false	false	true
058edb1f-87c8-4828-89b1-804e9bb19590	2026-08-25 11:31	2026-08-25 11:31	2026-08-25 11:31	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3600	1.3600	1.3700	10.0550	359584.00	0.00	359584.00	2644	28	58269	4761	12.2388153749212	0.468074216895263	0.468074216895263	false	false	false	true
553012a7-b8d5-4dd2-a5b6-66ec105f5662	2026-08-25 11:30	2026-08-25 11:30	2026-08-25 11:30	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3500	1.3500	1.3600	10.0401	155115.00	0.00	155115.00	1149	63	55519	4761	11.6612056290695	0.469365859897784	0.469365859897784	false	false	false	true
9bd11542-7750-44db-b3c6-dfe54aa6a285	2026-08-25 11:25	2026-08-25 11:25	2026-08-25 11:25	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3400	1.3300	1.3400	10.0195	26800.00	26800.00	0.00	200	10	52472	4761	11.0212140306658	0.47436378350476	0.47436378350476	false	false	false	true
7d9e3680-364c-4a49-809a-226a0de2b737	2026-08-25 11:24	2026-08-25 11:24	2026-08-25 11:24	UNG	UNG261016C00010000	call	10.0000	2026-10-16	0.7700	0.7400	0.7700	10.0141	10010.00	10010.00	0.00	130	19	5627	16665	0.337653765376538	0.490091606473993	0.490091606473993	false	false	false	true
25c32a9c-0af8-4149-9fe9-e7a3bd71a498	2026-08-25 11:19	2026-08-25 11:19	2026-08-25 11:19	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3300	1.3300	1.3400	9.9956	69958.00	0.00	69958.00	526	14	48036	4761	10.0894770006301	0.481341659388632	0.481341659388632	false	false	false	true
f943d359-04fa-405c-9476-026c702c2bc9	2026-08-25 11:18	2026-08-25 11:18	2026-08-25 11:18	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3500	1.3400	1.3500	10.0000	27000.00	27000.00	0.00	200	5	46532	4761	9.77357697962613	0.495414579679135	0.495414579679135	false	false	false	true
50647c07-ade4-4e91-b1c1-7314d01562e8	2026-08-25 11:17	2026-08-25 11:17	2026-08-25 11:17	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3400	1.3400	1.3500	10.0100	34840.00	0.00	34840.00	260	8	45254	4761	9.50514597773577	0.474101408753214	0.480553891961108	true	false	false	true
e18f4608-a9b1-4a8d-b9cc-5e4cc38032f1	2026-08-25 11:15	2026-08-25 11:15	2026-08-25 11:15	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3300	1.3200	1.3300	10.0000	31652.00	31388.00	264.00	238	10	43343	4761	9.10375971434573	0.478508307292374	0.478508307292374	false	false	false	true
04c441d0-0868-4fb5-93da-fd517c359066	2026-08-25 11:13	2026-08-25 11:13	2026-08-25 11:13	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3300	1.3200	1.3300	9.9901	12901.00	12901.00	0.00	97	6	40085	4761	8.41944969544213	0.484861068951901	0.484861068951901	false	false	false	true
a11552eb-7576-4923-b845-3caf72117a84	2026-08-25 11:12	2026-08-25 11:12	2026-08-25 11:12	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3300	1.3200	1.3300	10.0000	13566.00	13566.00	0.00	102	5	37323	4761	7.83931947069943	0.478508307292374	0.478508307292374	false	false	false	true
5838e121-1a2a-4522-9277-2d1703163afc	2026-08-25 11:12	2026-08-25 11:12	2026-08-25 11:12	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3300	1.3200	1.3300	10.0000	13167.00	13167.00	0.00	99	7	37221	4761	7.81789540012602	0.478508307292374	0.478508307292374	false	false	false	true
bf780074-b78a-4a9f-ad80-b65b867a7f3e	2026-08-25 11:09	2026-08-25 11:09	2026-08-25 11:09	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3100	1.3000	1.3100	9.9950	13100.00	13100.00	0.00	100	9	31606	4761	6.63852131905062	0.464667550196562	0.464667550196562	false	false	false	true
3565016b-855f-4eb0-8aa1-0bbf3b95ec07	2026-08-25 11:09	2026-08-25 11:09	2026-08-25 11:09	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3000	1.3000	1.3100	9.9999	65000.00	0.00	65000.00	500	12	31372	4761	6.58937198067633	0.452787141541732	0.452787141541732	false	false	false	true
8a99da5a-ee9c-4003-afc2-b13c4a9cdfa8	2026-08-25 11:09	2026-08-25 11:08	2026-08-25 11:08	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3100	1.3000	1.3100	10.0000	13100.00	13100.00	0.00	100	7	30726	4761	6.45368620037807	0.461378938006589	0.461378938006589	false	false	false	true
ce47ab65-9509-473a-a5f4-c9f6803bc6c7	2026-08-25 11:09	2026-08-25 11:08	2026-08-25 11:08	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3100	1.3000	1.3100	9.9997	11266.00	11266.00	0.00	86	5	30495	4761	6.40516698172653	0.461576912387697	0.461576912387697	false	false	false	true
1bb27dc9-5db7-4ec2-8f4c-60244074d591	2026-08-25 11:08	2026-08-25 11:08	2026-08-25 11:08	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3000	1.2900	1.3000	9.9901	11050.00	11050.00	0.00	85	7	29448	4761	6.18525519848771	0.459284895715167	0.459284895715167	false	false	false	true
c32ad43a-6069-4592-a424-c5633f6af0fe	2026-08-25 11:08	2026-08-25 11:08	2026-08-25 11:08	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3000	1.2900	1.3000	9.9901	36660.00	36660.00	0.00	282	9	28679	4761	6.02373450955682	0.459284895715167	0.459284895715167	false	false	false	true
ab4a3797-490e-4237-81be-f45e404c39e5	2026-08-25 11:08	2026-08-25 11:08	2026-08-25 11:08	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3000	1.2900	1.3000	9.9901	13000.00	13000.00	0.00	100	5	28391	4761	5.96324301617307	0.459284895715167	0.459284895715167	true	false	false	true
b63f60ec-3cab-4c5a-8d92-a4216331edd3	2026-08-25 11:07	2026-08-25 11:07	2026-08-25 11:07	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3000	1.2900	1.3000	10.0000	26000.00	26000.00	0.00	200	9	25601	4761	5.37723167401806	0.452720352521186	0.452720352521186	false	false	false	true
4cf22613-8deb-4998-8475-b30d4972102b	2026-08-25 11:07	2026-08-25 11:07	2026-08-25 11:07	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3000	1.2900	1.3000	10.0000	50180.00	50180.00	0.00	386	5	25306	4761	5.31526990128124	0.452720352521186	0.452720352521186	false	false	false	true
05a0981b-dce7-4481-a23a-d4524f8646a6	2026-08-25 11:06	2026-08-25 11:06	2026-08-25 11:06	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3000	1.2900	1.3000	10.0000	19500.00	19500.00	0.00	150	7	23482	4761	4.93215710985087	0.452720352521186	0.452720352521186	false	false	false	true
479a6668-98e5-44b7-a162-3dcdfcf6738d	2026-08-25 11:04	2026-08-25 11:04	2026-08-25 11:04	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.2900	1.2800	1.2900	9.9850	27348.00	25800.00	0.00	212	15	19150	4761	4.02226423020374	0.454022602494657	0.454022602494657	false	false	false	true
c1769f6d-cfe9-4be0-a795-089f0d0f107e	2026-08-25 11:04	2026-08-25 11:04	2026-08-25 11:04	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3000	1.2900	1.3000	9.9814	10400.00	10400.00	0.00	80	10	18053	4761	3.7918504515858	0.464977448269889	0.464977448269889	false	false	false	true
9aa7c186-10fa-4372-8049-2054db84cf27	2026-08-25 11:04	2026-08-25 11:04	2026-08-25 11:04	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.2900	1.2900	1.3000	9.9814	25800.00	0.00	25800.00	200	8	17951	4761	3.77042638101239	0.456396586261288	0.456396586261288	false	false	false	true
a1265f28-93da-431e-941b-461d6d497db7	2026-08-25 11:03	2026-08-25 11:03	2026-08-25 11:03	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3000	1.2900	1.3100	9.9850	17940.00	4420.00	11440.00	138	17	16492	4761	3.46397815584961	0.462630294357508	0.462630294357508	true	false	false	true
b72b0328-fde8-4919-a03e-4715a637405e	2026-08-25 11:03	2026-08-25 11:03	2026-08-25 11:03	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3000	1.3000	1.3100	9.9850	22230.00	0.00	22230.00	171	5	16303	4761	3.42428061331653	0.462630294357508	0.462630294357508	false	false	false	true
c539223a-0122-4b40-b892-6c6762dc573f	2026-08-25 11:03	2026-08-25 11:03	2026-08-25 11:03	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3000	1.3000	1.3100	9.9800	65000.00	0.00	65000.00	500	10	15846	4761	3.32829237555135	0.465887099510323	0.465887099510323	false	false	false	true
a343cf88-15c0-4043-88b5-118750249b51	2026-08-25 11:03	2026-08-25 11:03	2026-08-25 11:03	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3000	1.2900	1.3100	9.9899	40430.00	4810.00	1300.00	311	32	15159	4761	3.18399495904222	0.459416543365864	0.459416543365864	true	false	false	true
5c1c0720-3889-4a10-b0a6-6026f87317ef	2026-08-25 11:03	2026-08-25 11:02	2026-08-25 11:02	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3000	1.2900	1.3000	9.9850	11310.00	11310.00	0.00	87	8	14507	4761	3.04704893929847	0.462630294357508	0.462630294357508	false	false	false	true
2d1ef6a3-f3b8-4e60-bd08-30b30939b39d	2026-08-25 11:02	2026-08-25 11:02	2026-08-25 11:02	UNG	UNG261016P00010000	put	10.0000	2026-10-16	0.6000	0.5100	0.6000	9.9850	105119.00	105119.00	0.00	1752	40	1768	7482	0.236300454423951	0.413120598749075	0.406434482874552	false	false	false	true