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

59fbdc4e-026d-47d0-b413-4792f007b9ac	2026-09-09 15:04	2026-09-09 15:04	2026-09-09 15:04	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3000	1.3000	1.3100	10.1050	161590.00	0.00	161590.00	1243	62	10008	65080	0.153779963122311	0.456843241408988	0.456843241408988	false	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-09-09T19:27:55.926703Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
74faa8eb-632b-4163-901a-47871e07f51d	2026-09-09 15:02	2026-09-09 15:02	2026-09-09 15:02	UNG	UNG270115P00010000	put	10.0000	2027-01-15	1.2500	1.2500	1.2900	10.1050	14000.00	0.00	14000.00	112	27	141	3044	0.0463206307490145	0.583249547553089	0.583249547553089	false	false	false	true
be1ba606-ef8a-4348-a8e0-8aa6c40058a7	2026-09-09 13:28	2026-09-09 13:28	2026-09-09 13:28	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3300	1.3300	1.3400	10.1550	21413.00	0.00	21413.00	161	5	7985	65080	0.122695144437615	0.443592580302873	0.443592580302873	false	false	false	true
ce57d300-4a31-4e95-b5e4-1a8b942c8049	2026-09-09 13:01	2026-09-09 13:01	2026-09-09 13:01	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3500	1.3450	1.3700	10.0000	485730.00	0.00	485730.00	3598	98	7664	65080	0.117762753534112	0.452798190599417	0.452798190599417	false	false	false	true
3c4bac62-f3a3-4bfe-a002-ec9cafb9bd95	2026-09-09 13:01	2026-09-09 13:01	2026-09-09 13:01	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3500	1.3500	1.3700	10.0000	12960.00	0.00	12960.00	96	11	3997	65080	0.0614167178856792	0.442702536708916	0.442702536708916	false	false	false	true
8de6b5d6-b027-4a06-8151-050341d0ef76	2026-09-09 12:32	2026-09-09 12:32	2026-09-09 12:32	UNG	UNG270115C00017000	call	17.0000	2027-01-15	0.2800	0.2800	0.3300	10.2172	82488.00	0.00	82488.00	2946	40	2952	670	4.40597014925373	0.683921634285291	0.683921634285291	false	false	false	true
e5d89587-8412-40ef-bdc4-16a781413ca4	2026-09-09 10:25	2026-09-09 10:25	2026-09-09 10:25	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.4300	1.4000	1.4300	10.0000	12584.00	12584.00	0.00	88	10	2423	65080	0.0372311001843884	0.448170722621006	0.448170722621006	false	false	false	true
98ffdb2a-9e52-4f91-8b5e-4d0612be3ddd	2026-09-09 10:01	2026-09-09 10:01	2026-09-09 10:01	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.3500	1.3500	1.3600	10.2001	22275.00	0.00	22275.00	165	9	2158	65080	0.033159188690842	0.421027188071495	0.421027188071495	false	false	false	true
399c5391-e79a-4f4b-8e50-5791fafd7b36	2026-09-09 09:47	2026-09-09 09:46	2026-09-09 09:46	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.4000	1.3900	1.4200	10.2400	48020.00	0.00	47740.00	343	13	932	65080	0.014320835894284	0.442099161756965	0.442099161756965	true	false	false	true
4539afd3-366b-432a-b692-3bf7ac674bfd	2026-09-08 11:26	2026-09-08 11:25	2026-09-08 11:25	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.4700	1.4700	1.5000	10.3474	60858.00	0.00	60858.00	414	6	1456	65866	0.0221054868976407	0.404506880110883	0.404506880110883	false	false	false	true
27918bcc-a618-450e-a81e-3dc34f7cb969	2026-09-08 10:09	2026-09-08 10:09	2026-09-08 10:09	UNG	UNG270115C00009000	call	9.0000	2027-01-15	2.2500	2.2500	2.3200	10.4550	33750.00	0.00	33750.00	150	9	161	5320	0.0302631578947368	0.575950198741703	0.575950198741703	false	false	false	true
dbd352e1-32d4-4237-8dac-7463bfd96a63	2026-09-04 15:34	2026-09-04 15:34	2026-09-04 15:34	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.7100	1.6800	1.7100	10.5772	10260.00	8208.00	0.00	60	7	666	65910	0.0101046882111971	0.433182299860474	0.433182299860474	false	false	false	true
88df7893-9676-4eb3-877e-df58d4dd1642	2026-09-04 11:02	2026-09-04 11:02	2026-09-04 11:02	UNG	UNG270115C00012000	call	12.0000	2027-01-15	1.1700	1.1400	1.2000	10.7050	11700.00	1287.00	10413.00	100	13	228	12442	0.0183250281305256	0.620368959307353	0.620368959307353	false	false	false	true
5ed12820-cba2-494c-a748-ef2a6d513d34	2026-09-03 12:55	2026-09-03 12:55	2026-09-03 12:55	UNG	UNG261016C00010000	call	10.0000	2026-10-16	0.9000	0.8800	0.9000	10.5050	13500.00	13500.00	0.00	150	8	3987	19001	0.209831061523078	0.418167178999953	0.418167178999953	false	false	false	true
fa8574db-a9e5-4f89-b822-2e0da78b090e	2026-09-03 11:57	2026-09-03 11:57	2026-09-03 11:57	UNG	UNG261023P00010000	put	10.0000	2026-10-23	0.4500	0.4100	0.4900	10.4200	152730.00	90.00	152640.00	3394	24	3419	0	0	0.438659695876702	0.438659695876702	false	false	false	true
5fb8731f-c9dc-4cc8-9a87-9d485decfcf2	2026-09-03 11:22	2026-09-03 11:22	2026-09-03 11:22	UNG	UNG270115C00012000	call	12.0000	2027-01-15	1.0400	1.0400	1.1100	10.4050	26000.00	0.00	26000.00	250	15	757	12202	0.0620390099983609	0.622092226677541	0.622092226677541	false	false	false	true
1ec3034f-4261-40e8-a420-279ba8e6e3a7	2026-09-03 11:22	2026-09-03 11:21	2026-09-03 11:21	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.5700	1.5500	1.5900	10.4000	10990.00	9106.00	0.00	70	5	1110	65774	0.0168759692279624	0.447609710378404	0.447609710378404	true	false	false	true
1efd9a67-d64b-4ba6-a821-e33939091103	2026-09-03 09:34	2026-09-03 09:34	2026-09-03 09:34	UNG	UNG270115C00010000	call	10.0000	2027-01-15	2.0000	1.9600	2.0400	10.7533	43200.00	0.00	0.00	216	10	226	11634	0.0194258208698642	0.61237565620544	0.61237565620544	false	false	false	true
5dee307a-3bba-4361-aae4-9d20ccd6b1f1	2026-09-02 11:50	2026-09-02 11:50	2026-09-02 11:50	UNG	UNG270416C00014000	call	14.0000	2027-04-16	1.4600	0.7100	1.4600	10.6801	102200.00	102200.00	0.00	700	23	700	62	11.2903225806452	0.716232516306047	0.716232516306047	false	false	false	true
d57342da-1e4c-4f7a-af49-f49a6f35d630	2026-09-02 10:10	2026-09-02 10:09	2026-09-02 10:09	UNG	UNG261016C00010000	call	10.0000	2026-10-16	1.0000	0.9800	1.0000	10.6000	10000.00	10000.00	0.00	100	5	295	19619	0.0150364442632142	0.438948637555239	0.438948637555239	false	false	false	true
eb693457-ac8a-49f9-a0d8-cf9ba6f72655	2026-09-02 09:56	2026-09-02 09:55	2026-09-02 09:55	UNG	UNG270416C00010000	call	10.0000	2027-04-16	2.0600	2.0600	2.5200	10.5899	103000.00	0.00	103000.00	500	13	500	2271	0.220167327168648	0.505510250527502	0.505510250527502	false	false	false	true
fcc335c5-f879-4c74-8f52-a5ab10a4411a	2026-09-01 14:55	2026-09-01 14:55	2026-09-01 14:55	UNG	UNG270115C00011000	call	11.0000	2027-01-15	1.4600	1.4000	1.4700	10.5350	10965.00	10965.00	0.00	75	12	1994	6551	0.304381010532743	0.625114900486032	0.617267446047992	false	false	false	true
9304cf6f-71c3-4870-bd13-46b80ab7087c	2026-09-01 14:53	2026-09-01 14:53	2026-09-01 14:53	UNG	UNG261016C00010000	call	10.0000	2026-10-16	0.9700	0.9700	0.9800	10.5301	97000.00	0.00	97000.00	1000	7	2121	19276	0.11003320190911	0.446717585620811	0.446717585620811	true	false	false	true
d600be1a-cbde-497c-aff2-cf678f06890c	2026-09-01 12:31	2026-09-01 12:31	2026-09-01 12:31	UNG	UNG270115C00012000	call	12.0000	2027-01-15	1.1200	1.0600	1.1200	10.4499	24468.00	24468.00	0.00	219	16	526	11590	0.0453839516824849	0.639076252685921	0.631155689878022	false	false	false	true
1cb29d21-e30f-4f7c-9279-5281c992c823	2026-09-01 10:49	2026-09-01 10:49	2026-09-01 10:49	UNG	UNG261016C00011000	call	11.0000	2026-10-16	0.4100	0.4100	0.4200	10.3529	14145.00	0.00	14145.00	345	30	1282	14610	0.0877481177275838	0.446638411304869	0.446638411304869	false	false	false	true
55202b74-251d-4969-a1e8-3bf86ff84d79	2026-09-01 09:40	2026-09-01 09:40	2026-09-01 09:40	UNG	UNG261016C00011000	call	11.0000	2026-10-16	0.4000	0.3900	0.4200	10.2850	20000.00	15680.00	4320.00	500	13	676	14610	0.0462696783025325	0.45828872965586	0.45828872965586	false	false	false	true
3b3a3be3-7984-4a09-83c6-ca76a6fa30c8	2026-08-31 15:47	2026-08-31 15:46	2026-08-31 15:46	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.7000	1.7000	1.7500	10.5350	85000.00	0.00	85000.00	500	11	1356	66094	0.0205162344539595	0.445377526737671	0.445377526737671	false	false	false	true
ebd84120-72d2-4cfc-8162-7cce3531094b	2026-08-31 15:03	2026-08-31 15:02	2026-08-31 15:02	UNG	UNG270115C00012000	call	12.0000	2027-01-15	1.1500	1.0900	1.1500	10.5250	36455.00	36455.00	0.00	317	7	1277	10515	0.121445553970518	0.634781148034208	0.634781148034208	false	false	false	true
7ff0b92b-2413-4523-bd2e-e46b34cbd625	2026-08-31 15:02	2026-08-31 15:02	2026-08-31 15:02	UNG	UNG270416C00010000	call	10.0000	2027-04-16	2.2600	2.2200	2.3600	10.5300	11300.00	0.00	11300.00	50	6	611	1559	0.391917896087235	0.58115653257916	0.58115653257916	false	false	false	true
c71754c7-75f9-4753-8017-cf1748c8dd66	2026-08-31 14:10	2026-08-31 14:10	2026-08-31 14:10	UNG	UNG270115P00011000	put	11.0000	2027-01-15	1.7600	1.7500	1.8400	10.0000	17646.00	0.00	17646.00	100	5	112	2306	0.0485689505637468	0.611394637249901	0.611394637249901	false	false	false	true
8164c9ee-6840-4e54-9764-473e405c55be	2026-08-31 12:32	2026-08-31 12:31	2026-08-31 12:31	UNG	UNG261016C00011000	call	11.0000	2026-10-16	0.5000	0.5000	0.5200	10.5701	10000.00	0.00	10000.00	200	10	934	14738	0.0633735920749084	0.441229580914397	0.441229580914397	false	false	false	true
66f53216-bd4d-49ce-895f-0472018cd88e	2026-08-28 12:13	2026-08-28 12:13	2026-08-28 12:13	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.5000	1.5000	1.5200	10.2800	25800.00	0.00	25800.00	172	13	1050	65695	0.0159829515183804	0.446485907447065	0.446485907447065	false	false	false	true
c6be6fb4-b5c7-497d-8896-4890da746b0a	2026-08-28 11:21	2026-08-28 11:21	2026-08-28 11:21	UNG	UNG261002C00011000	call	11.0000	2026-10-02	0.2900	0.2700	0.3100	10.3203	101529.00	232.00	101297.00	3501	24	3547	245	14.4775510204082	0.420243022610477	0.420243022610477	false	false	false	true
1875e014-fd26-4ce7-a048-6f371f1cf3d6	2026-08-28 11:08	2026-08-28 11:08	2026-08-28 11:08	UNG	UNG260828C00010000	call	10.0000	2026-08-28	0.3600	0.3500	0.3600	10.3674	25884.00	25884.00	0.00	719	11	2167	1964	1.10336048879837	0.948553724307434	0.948553724307434	true	false	false	true
86480997-2d47-46bd-82e3-b362fdd99abf	2026-08-28 11:02	2026-08-28 11:02	2026-08-28 11:02	UNG	UNG261002C00010500	call	10.5000	2026-10-02	0.4800	0.4400	0.4900	10.3500	18048.00	18048.00	0.00	376	7	388	390	0.994871794871795	0.415687038813472	0.415687038813472	true	false	false	true
19025931-dc77-42af-9511-f5c7f827e834	2026-08-28 10:57	2026-08-28 10:57	2026-08-28 10:57	UNG	UNG270115C00010000	call	10.0000	2027-01-15	1.7600	1.7100	1.7600	10.3350	88000.00	88000.00	0.00	500	8	1121	9726	0.115258071149496	0.607256271734846	0.607256271734846	false	false	false	true
81cb6c8e-8d7f-4ec3-a8d4-dfd5ef3e31ee	2026-08-28 10:46	2026-08-28 10:46	2026-08-28 10:46	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.5500	1.5000	1.5900	10.3581	12400.00	12400.00	0.00	80	5	678	65695	0.0103204201232971	0.430663468600872	0.430663468600872	false	false	false	true
d8b9fd84-8a27-42b8-a663-98c31b35a08f	2026-08-28 10:16	2026-08-28 10:16	2026-08-28 10:16	UNG	UNG260918C00009500	call	9.5000	2026-09-18	0.9500	0.9500	0.9900	10.3457	19000.00	0.00	19000.00	200	14	755	1205	0.62655601659751	0.383983442202008	0.383983442202008	false	false	false	true
7dfbe91e-4c57-47bd-861a-d7d2b823bd42	2026-08-28 10:16	2026-08-28 10:16	2026-08-28 10:16	UNG	UNG260918C00009500	call	9.5000	2026-09-18	0.9500	0.9500	1.0600	10.3575	19000.00	0.00	19000.00	200	10	555	1205	0.460580912863071	0.366964552272002	0.366964552272002	false	false	false	true
acac62d2-6e38-444f-ab41-bd0d2373c1db	2026-08-28 10:15	2026-08-28 10:15	2026-08-28 10:15	UNG	UNG260918C00009500	call	9.5000	2026-09-18	0.9500	0.9500	1.0600	10.3450	14250.00	0.00	14250.00	150	6	155	1205	0.128630705394191	0.384957060790128	0.384957060790128	false	false	false	true
c3b6e29c-ccdd-4ca1-83b0-c07f94a3af3e	2026-08-28 10:11	2026-08-28 10:11	2026-08-28 10:11	UNG	UNG270115C00010000	call	10.0000	2027-01-15	1.7700	1.7600	1.8000	10.3800	20500.00	12036.00	8464.00	116	6	429	9726	0.0441085749537323	0.599779680843754	0.599779680843754	false	false	false	true
52d192b6-e8ec-4ab0-9c41-521c5ba9b8eb	2026-08-28 09:48	2026-08-28 09:48	2026-08-28 09:48	UNG	UNG261016C00013000	call	13.0000	2026-10-16	0.1200	0.1200	0.1400	10.3950	14124.00	0.00	14124.00	1177	47	1180	11055	0.106739032112166	0.499256740596133	0.499256740596133	false	false	false	true
54d4de64-000a-447a-b0f5-a2b257c469e4	2026-08-28 09:43	2026-08-28 09:43	2026-08-28 09:43	UNG	UNG261016C00010000	call	10.0000	2026-10-16	0.9300	0.9000	0.9300	10.3800	10230.00	10230.00	0.00	110	22	444	19131	0.0232084052062098	0.467254902718897	0.467254902718897	false	false	false	true
71a0396b-34e2-4a36-9174-8e6e37b5558a	2026-08-27 15:40	2026-08-27 15:40	2026-08-27 15:40	UNG	UNG260904C00010500	call	10.5000	2026-09-04	0.2400	0.2200	0.2400	10.4450	11928.00	11928.00	0.00	497	5	1168	1776	0.657657657657658	0.424645970309689	0.424645970309689	false	false	false	true
34726e63-ce69-4e56-8a93-69908899aa84	2026-08-27 12:38	2026-08-27 12:38	2026-08-27 12:38	UNG	UNG261016P00010000	put	10.0000	2026-10-16	0.4300	0.4300	0.4600	10.5350	50826.00	0.00	50826.00	1182	41	1340	9354	0.143254222792388	0.452502569023721	0.452502569023721	false	false	false	true
8b01fa70-e1bd-43c1-9afc-2b31566cae3c	2026-08-27 12:38	2026-08-27 12:38	2026-08-27 12:38	UNG	UNG261016C00009000	call	9.0000	2026-10-16	1.7400	1.6500	1.7400	10.5250	17922.00	17922.00	0.00	103	6	1537	65851	0.0233405718971618	0.479504874802026	0.479504874802026	false	false	false	true
238f9131-3849-4370-a316-10ebeb336e7f	2026-08-27 12:02	2026-08-27 12:01	2026-08-27 12:01	UNG	UNG270115C00011000	call	11.0000	2027-01-15	1.4600	1.4500	1.4900	10.4623	29401.00	9536.00	19865.00	201	5	577	5743	0.100470137558767	0.63640094476066	0.6208948494107	false	false	false	true
d9f70aca-5b97-4a16-b705-7b4be29175ac	2026-08-27 11:20	2026-08-27 11:19	2026-08-27 11:19	UNG	UNG260918C00009500	call	9.5000	2026-09-18	1.1400	1.0700	1.1400	10.5300	22800.00	22800.00	0.00	200	25	1153	776	1.48582474226804	0.43004516540575	0.43004516540575	false	false	false	true
5d1f2abd-0b34-4672-a549-ef0b25b971bf	2026-08-27 11:17	2026-08-27 11:17	2026-08-27 11:17	UNG	UNG261016C00012000	call	12.0000	2026-10-16	0.2600	0.2600	0.2900	10.5250	34008.00	0.00	34008.00	1308	9	2683	8206	0.326955885937119	0.464790901850101	0.464790901850101	false	false	false	true
fb85022d-2adb-4992-9ead-75afd3bd816b	2026-08-27 11:06	2026-08-27 11:06	2026-08-27 11:06	UNG	UNG260904C00011000	call	11.0000	2026-09-04	0.1100	0.1000	0.1200	10.5250	54120.00	0.00	53944.00	4920	37	5447	3042	1.79059829059829	0.44752812668714	0.44752812668714	false	false	false	true