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 = PBR×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	expirydate

6146cc34-d12c-4b54-9d51-91e7ee8b74de	2026-08-18 12:40	2026-08-18 12:39	2026-08-18 12:39	PBR	PBR261120C00020000	call	20.0000	2026-11-20	0.6700	0.6200	0.7100	18.1605	60166.00	3752.00	56414.00	898	33	945	3768	0.250796178343949	0.347447249987529	0.347447249987529	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Energy	78701596865.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
34656116-3d85-437d-816b-7ef26aefccee	2026-08-21 15:02	2026-08-21 15:02	2026-08-21 15:02	PBR	PBR261016P00018000	put	18.0000	2026-10-16	0.7000	0.6800	0.7000	19.2000	70000.00	70000.00	0.00	1000	6	1431	5655	0.253050397877984	0.430237073759261	0.430237073759261	false	false	false	true
0f422a30-dcdb-49c7-b568-1c23b9f04aa6	2026-08-24 11:43	2026-08-24 11:42	2026-08-24 11:42	PBR	PBR261016P00018000	put	18.0000	2026-10-16	0.9100	0.9100	0.9600	18.6350	53508.00	0.00	53508.00	588	39	593	7081	0.0837452337240503	0.448076489010765	0.448076489010765	true	false	false	true
c4d19e81-6d9b-4679-9125-0aab89d06fa7	2026-08-24 12:04	2026-08-24 12:04	2026-08-24 12:04	PBR	PBR261120P00018000	put	18.0000	2026-11-20	1.3000	1.2200	1.3000	18.6450	73320.00	73320.00	0.00	564	17	5608	6969	0.804706557612283	0.469955832779805	0.469955832779805	false	false	false	true
521f748f-c9b5-4083-9feb-2a276d135ff2	2026-08-27 10:55	2026-08-27 10:55	2026-08-27 10:55	PBR	PBR261120C00018000	call	18.0000	2026-11-20	1.3100	1.3100	1.3800	17.7051	75980.00	0.00	75980.00	580	21	590	7168	0.0823102678571429	0.402822197666589	0.402822197666589	false	false	false	true
08a5eec3-c5d6-41a5-b087-b42a92d19a34	2026-08-31 10:28	2026-08-31 10:28	2026-08-31 10:28	PBR	PBR280218C00025000	call	25.0000	2028-02-18	1.2500	1.2100	1.3400	19.1400	50750.00	3250.00	47500.00	406	15	654	2065	0.316707021791768	0.285165399446671	0.285365061854284	false	false	false	true
4acf7691-eb34-462b-8aa3-c949034ea97c	2026-08-31 14:06	2026-08-31 14:06	2026-08-31 14:06	PBR	PBR260918C00018000	call	18.0000	2026-09-18	1.3700	1.2900	1.4000	19.0000	68500.00	6850.00	61650.00	500	6	1443	39454	0.0365742383535256	0.31920529787681	0.31920529787681	true	false	false	true
e4d446ad-9923-4fca-812b-350bc3497268	2026-09-01 09:40	2026-09-01 09:40	2026-09-01 09:40	PBR	PBR261016C00017000	call	17.0000	2026-10-16	3.1500	3.1500	3.2000	19.8800	216405.00	0.00	43155.00	687	6	728	1266	0.575039494470774	0.420908599959022	0.420908599959022	false	false	false	true
f6a70066-c0b8-4972-a2fd-04cfea8441b5	2026-09-01 12:38	2026-09-01 12:38	2026-09-01 12:38	PBR	PBR261016C00020000	call	20.0000	2026-10-16	1.2500	1.2400	1.2600	20.0650	123250.00	46000.00	77250.00	986	30	13213	25214	0.524034266677243	0.417613258234325	0.417613258234325	false	false	false	true
d2fad3a1-6ef1-41f8-a975-6e6b59813dfe	2026-09-01 13:48	2026-09-01 13:48	2026-09-01 13:48	PBR	PBR260918C00020000	call	20.0000	2026-09-18	0.8200	0.7800	0.8200	20.2715	81908.00	74456.00	7452.00	1000	39	9218	57551	0.160170978784035	0.378206134957695	0.378206134957695	false	false	false	true
38550771-6813-45b7-ace2-de7a951d14fd	2026-09-01 14:34	2026-09-01 14:34	2026-09-01 14:34	PBR	PBR270617C00022000	call	22.0000	2027-06-17	1.9300	1.7500	1.9300	20.2450	386000.00	386000.00	0.00	2000	26	2042	252	8.1031746031746	0.334411454305764	0.334411454305764	false	false	false	true
6c260f2d-0e4e-44ad-9c5f-b67cec074234	2026-09-01 14:36	2026-09-01 14:36	2026-09-01 14:36	PBR	PBR270617C00022000	call	22.0000	2027-06-17	1.9400	1.9300	1.9400	20.2950	388000.00	388000.00	0.00	2000	7	10334	252	41.0079365079365	0.332418586495639	0.332418586495639	false	false	false	true
d6315cf4-ecc2-4384-998c-0a4948330f18	2026-09-02 10:10	2026-09-02 10:10	2026-09-02 10:10	PBR	PBR261218C00022000	call	22.0000	2026-12-18	1.3300	1.2100	1.3300	20.3700	130340.00	130340.00	0.00	980	26	1147	26254	0.0436885807876895	0.427766461716818	0.427766461716818	false	false	false	true
7e604645-4672-473a-a808-2ec15c7e1171	2026-09-02 10:21	2026-09-02 10:21	2026-09-02 10:21	PBR	PBR261218C00022000	call	22.0000	2026-12-18	1.3500	1.2500	1.3500	20.4050	135000.00	135000.00	0.00	1000	25	3177	26254	0.121010131789442	0.428860199230727	0.428860199230727	false	false	false	true
d0ae865e-055e-4264-8072-d045a180670b	2026-09-02 11:43	2026-09-02 11:43	2026-09-02 11:43	PBR	PBR270115C00020000	call	20.0000	2027-01-15	2.5200	2.5200	2.5800	20.8800	73584.00	0.00	73584.00	292	6	1446	88522	0.0163349223921737	0.381779000903958	0.381779000903958	false	false	false	true
050bff5f-c814-44ac-bad5-1dbc3f3618eb	2026-09-02 11:50	2026-09-02 11:50	2026-09-02 11:50	PBR	PBR261016P00021000	put	21.0000	2026-10-16	1.2900	1.2200	1.3000	20.8850	129768.00	19092.00	110676.00	1006	30	1007	68	14.8088235294118	0.444102337227577	0.439820459143103	true	false	false	true
c8f703db-d5af-45a4-9cd1-6a883a7bd31e	2026-09-02 12:52	2026-09-02 12:52	2026-09-02 12:52	PBR	PBR261120C00021000	call	21.0000	2026-11-20	1.8200	1.8200	1.8800	20.8650	54600.00	0.00	54600.00	300	8	646	141428	0.004567695223011	0.465861744127784	0.465861744127784	false	false	false	true
1c709b18-46d9-4488-b038-d6eca2a26b7e	2026-09-02 15:27	2026-09-02 15:27	2026-09-02 15:27	PBR	PBR261120C00021000	call	21.0000	2026-11-20	1.8800	1.8800	1.9400	20.9550	61664.00	0.00	61664.00	328	12	1026	141428	0.00725457476595865	0.468568509158444	0.468568509158444	false	false	false	true
7954c2c5-fe9c-428f-bf17-22aae33e8f3e	2026-09-02 15:33	2026-09-02 15:33	2026-09-02 15:33	PBR	PBR260918C00021000	call	21.0000	2026-09-18	0.6800	0.6800	0.6900	20.9600	55760.00	0.00	55760.00	820	7	2858	20828	0.137219128096793	0.389787859576526	0.389787859576526	true	false	false	true
fb6eba55-c753-43f1-895d-59f92326280b	2026-09-02 15:34	2026-09-02 15:34	2026-09-02 15:34	PBR	PBR260918C00021000	call	21.0000	2026-09-18	0.6900	0.6400	0.6900	20.9550	65688.00	65688.00	0.00	952	38	3866	20828	0.185615517572499	0.396975843528737	0.396975843528737	false	false	false	true
8a4d3cb7-e38b-471b-bbbd-4d4071c9014c	2026-09-03 13:09	2026-09-03 13:09	2026-09-03 13:09	PBR	PBR261218C00021000	call	21.0000	2026-12-18	1.8100	1.7800	1.8200	20.5550	88147.00	88147.00	0.00	487	6	921	2781	0.331175836030205	0.430839737007739	0.430839737007739	false	false	false	true
766dbd41-f853-4add-a197-a9bcd48bfc99	2026-09-04 09:49	2026-09-04 09:49	2026-09-04 09:49	PBR	PBR261218C00021000	call	21.0000	2026-12-18	1.6200	1.5700	1.6500	20.2650	52326.00	12960.00	39366.00	323	15	324	4461	0.0726294552790854	0.425876789496474	0.425876789496474	false	false	false	true
f27ce709-1906-4c50-9f00-0bc24dd55c3d	2026-09-04 10:51	2026-09-04 10:51	2026-09-04 10:51	PBR	PBR261120C00024000	call	24.0000	2026-11-20	0.6000	0.5600	0.6100	20.3316	59520.00	5760.00	53760.00	992	13	1022	140954	0.00725059239184415	0.456775499710784	0.456775499710784	true	false	false	true
491c4575-560d-4b71-a636-dc5c961c6a53	2026-09-08 09:49	2026-09-08 09:49	2026-09-08 09:49	PBR	PBR270115C00025000	call	25.0000	2027-01-15	0.8400	0.7800	0.8400	20.9650	173796.00	173796.00	0.00	2069	31	2069	23749	0.0871194576613752	0.410695996822967	0.410695996822967	false	false	false	true
1cfa1cbd-cf71-46f7-9307-fd27c1498002	2026-09-09 12:03	2026-09-09 12:03	2026-09-09 12:03	PBR	PBR261218C00018000	call	18.0000	2026-12-18	3.8500	3.7000	3.8500	21.0750	57750.00	57750.00	0.00	150	6	400	342	1.16959064327485	0.432553350059401	0.432553350059401	false	false	false	true
72718c61-465d-4651-92c6-ce4a828ae170	2026-09-09 12:07	2026-09-09 12:06	2026-09-09 12:06	PBR	PBR270416C00019000	call	19.0000	2027-04-16	3.5000	3.5000	4.2000	21.0950	70000.00	0.00	70000.00	200	6	200	10	20	0.321046683394143	0.321046683394143	false	false	false	true
bccecbd6-3c09-4515-b525-b942292019c1	2026-09-10 10:34	2026-09-10 10:34	2026-09-10 10:34	PBR	PBR260918C00021500	call	21.5000	2026-09-18	0.3000	0.2900	0.3200	20.9750	66780.00	60.00	66720.00	2226	23	2573	832	3.09254807692308	0.410273414505614	0.410273414505614	false	false	false	true
78ab76d9-eb53-4665-9a77-2a0247251e78	2026-09-10 11:01	2026-09-10 11:01	2026-09-10 11:01	PBR	PBR261016C00022000	call	22.0000	2026-10-16	1.0100	1.0100	1.0200	21.4100	61408.00	0.00	61408.00	608	7	810	23332	0.0347162695011144	0.460273871375804	0.460273871375804	false	false	false	true
4ca22d25-3360-4e42-af2b-079f7ca75099	2026-09-10 12:07	2026-09-10 12:07	2026-09-10 12:07	PBR	PBR261120P00020000	put	20.0000	2026-11-20	1.0800	1.0800	1.1600	21.3873	58968.00	0.00	58968.00	546	14	753	8646	0.0870922970159611	0.480451789116542	0.480451789116542	false	false	false	true
9c351871-a37d-48f2-8b87-6e07f62ae505	2026-09-10 12:19	2026-09-10 12:18	2026-09-10 12:18	PBR	PBR261120P00021000	put	21.0000	2026-11-20	1.6000	1.5300	1.6000	21.3050	80158.00	80000.00	158.00	501	20	2049	1642	1.24786845310597	0.491960292782411	0.485939427729986	false	false	false	true
2376d194-d95d-484c-8eea-caaa0586cd3d	2026-09-10 14:44	2026-09-10 14:44	2026-09-10 14:44	PBR	PBR261009P00022500	put	22.5000	2026-10-09	1.8200	1.7600	1.8200	21.3950	106288.00	106288.00	0.00	584	25	584	1	584	0.500766197988229	0.500766197988229	false	false	false	true
a8e99f54-a32f-422d-b8eb-5d802f855d3c	2026-09-11 09:51	2026-09-11 09:51	2026-09-11 09:51	PBR	PBR261016C00022000	call	22.0000	2026-10-16	0.8800	0.8800	0.8900	21.0000	57024.00	0.00	57024.00	648	15	648	24952	0.0259698621352998	0.46346606003009	0.46346606003009	true	false	false	true
9aea6ace-629c-47ee-a2eb-d3e3d21babe5	2026-09-11 10:56	2026-09-11 10:55	2026-09-11 10:55	PBR	PBR270115P00020000	put	20.0000	2027-01-15	1.5600	1.5600	1.6100	21.0850	60684.00	0.00	60684.00	389	30	946	19966	0.0473805469297806	0.456781382841688	0.455636505375499	false	false	false	true
6be62842-9e2f-4a50-a80b-517c30679afc	2026-09-11 10:56	2026-09-11 10:55	2026-09-11 10:55	PBR	PBR270115P00020000	put	20.0000	2027-01-15	1.5600	1.5400	1.6100	21.1000	86892.00	62244.00	24648.00	557	22	557	19966	0.0278974256235601	0.456781382841688	0.456781382841688	false	false	false	true
d7c7b2f7-ea99-489d-bc15-bfd404e3177c	2026-09-11 11:00	2026-09-11 11:00	2026-09-11 11:00	PBR	PBR261016C00022000	call	22.0000	2026-10-16	0.8700	0.8500	0.8900	21.1550	197577.00	2871.00	188964.00	2271	15	3316	24952	0.132895158704713	0.456242893777634	0.457076012584369	false	false	false	true
636cb39c-268d-4363-a431-e53be601f689	2026-09-11 14:35	2026-09-11 14:34	2026-09-11 14:34	PBR	PBR261120C00022000	call	22.0000	2026-11-20	1.3800	1.3600	1.3900	20.9550	223836.00	276.00	223560.00	1622	20	2060	40193	0.0512527056950215	0.48090369579684	0.47963396379608	false	false	false	true
0b04343a-67f8-421f-8192-4164755010c9	2026-09-11 15:03	2026-09-11 15:03	2026-09-11 15:03	PBR	PBR270115P00015000	put	15.0000	2027-01-15	0.2800	0.2700	0.2900	21.0000	84000.00	34860.00	0.00	3000	14	3952	79906	0.0494581132831077	0.49345211129604	0.49345211129604	false	false	false	true
d382f1b1-f094-4aec-b114-28d57e5bbb7a	2026-09-11 15:16	2026-09-11 15:16	2026-09-11 15:16	PBR	PBR270115P00015000	put	15.0000	2027-01-15	0.2800	0.2300	0.2900	21.0850	51464.00	35084.00	700.00	1838	30	7839	79906	0.0981027707556379	0.497235874044239	0.497235874044239	false	false	false	true
5af5f1e2-2a3f-49a9-9db4-69ad0517b609	2026-09-11 15:55	2026-09-11 15:55	2026-09-11 15:55	PBR	PBR270115P00015000	put	15.0000	2027-01-15	0.2800	0.2700	0.2900	21.1700	114800.00	71876.00	21224.00	4100	18	30352	79906	0.379846319425325	0.501435073699007	0.500994515062277	true	false	false	true
69755c9b-1493-4216-81f7-006c704969c7	2026-09-11 15:57	2026-09-11 15:57	2026-09-11 15:57	PBR	PBR270115P00015000	put	15.0000	2027-01-15	0.2800	0.2700	0.2800	21.1800	112000.00	112000.00	0.00	4000	10	34352	79906	0.429905138537782	0.501435073699007	0.501435073699007	false	false	false	true
9ca9718e-b22b-4611-a826-eb91eab6f513	2026-09-11 15:59	2026-09-11 15:59	2026-09-11 15:59	PBR	PBR270115P00015000	put	15.0000	2027-01-15	0.2800	0.2200	0.2800	21.2150	104972.00	104972.00	0.00	3749	18	38101	79906	0.476822766750932	0.502974339459292	0.502974339459292	false	false	false	true
adeec40f-6776-4fa0-8a91-8020f47b2e60	2026-09-14 12:48	2026-09-14 12:48	2026-09-14 12:48	PBR	PBR260918C00018000	call	18.0000	2026-09-18	3.1000	3.1000	3.1500	21.0900	69440.00	0.00	69440.00	224	17	255	36419	0.00700183969905818	0.864601259051531	0.600321467099379	false	false	false	true
f9d0fc76-8c9d-4856-85e8-069e35279237	2026-09-15 10:55	2026-09-15 10:55	2026-09-15 10:55	PBR	PBR270319C00025000	call	25.0000	2027-03-19	1.3500	1.2700	1.3700	21.0000	67500.00	60750.00	6750.00	500	6	500	12679	0.0394352866945343	0.388939209651829	0.388939209651829	false	false	false	true
499191a0-2f96-49fb-b4ce-abc5e3a7d666	2026-09-15 11:09	2026-09-15 11:09	2026-09-15 11:09	PBR	PBR270115P00022000	put	22.0000	2027-01-15	2.4000	2.3900	2.6000	21.0000	484800.00	218400.00	266400.00	2020	7	2100	4309	0.487352053840798	0.481205400643819	0.481205400643819	false	false	false	true
966a2f74-c84b-4df8-a85a-397f9bb2e986	2026-09-15 11:17	2026-09-15 11:17	2026-09-15 11:17	PBR	PBR261016C00022000	call	22.0000	2026-10-16	1.1800	1.1500	1.1900	21.7950	117528.00	117528.00	0.00	996	20	2220	27535	0.0806246595242419	0.489723662947706	0.489723662947706	true	false	false	true
3b0d486b-4ae3-442f-ae49-3fac64c8dee6	2026-09-16 11:09	2026-09-16 11:09	2026-09-16 11:09	PBR	PBR261030P00020000	put	20.0000	2026-10-30	1.0000	0.9500	1.5100	20.9350	125100.00	49200.00	13400.00	1251	10	1251	23	54.3913043478261	0.515844247608569	0.516500555774686	false	false	false	true
9728221a-9965-47a3-b0c1-a9a7238e3e88	2026-09-16 13:47	2026-09-16 13:47	2026-09-16 13:47	PBR	PBR260918C00018000	call	18.0000	2026-09-18	3.0500	3.0500	3.1000	21.0000	91500.00	0.00	49410.00	300	8	313	36564	0.00856033256755278	0.634294044416956	1.19067573565338	false	false	false	true
acb31c4e-c6ec-4107-9d3d-6bec1c83e70c	2026-09-17 09:31	2026-09-17 09:31	2026-09-17 09:31	PBR	PBR260918C00018000	call	18.0000	2026-09-18	2.7900	2.7000	2.9500	20.7598	70029.00	53568.00	837.00	251	24	251	36552	0.00686692930619392	1.5891978068558	1.5891978068558	false	false	false	true
e2b80797-10c7-48d2-9608-fc78fd743c7f	2026-09-17 10:37	2026-09-17 10:37	2026-09-17 10:37	PBR	PBR261218C00019000	call	19.0000	2026-12-18	2.8500	2.7800	2.9300	20.7350	71535.00	28785.00	29355.00	251	38	251	729	0.344307270233196	0.433073924879986	0.433073924879986	false	false	false	true
b50a98f8-944a-4613-b5de-0521439333a4	2026-09-17 11:17	2026-09-17 11:17	2026-09-17 11:17	PBR	PBR261030P00020000	put	20.0000	2026-10-30	1.0000	0.8300	1.2000	20.8100	104100.00	98000.00	400.00	1041	30	1223	1349	0.906597479614529	0.505356164742014	0.505356164742014	false	false	false	true