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:endpoint = /api/option-trades/flow-alerts×sector = Energy×ticker = PBF×

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

30d80bd0-4b89-4be8-ab6f-313e066fc590	2026-09-24 14:13	2026-09-24 14:13	2026-09-24 14:13	PBF	PBF261016P00080000	put	80.0000	2026-10-16	9.2000	9.2000	9.6000	73.6900	469200.00	0.00	469200.00	510	6	510	79	6.45569620253165	0.748980060720073	0.748980060720073	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	8353290974.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T18:15:40.223371Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
104a1663-77c4-4eab-9f0d-634f89f16197	2026-09-24 14:13	2026-09-24 14:13	2026-09-24 14:13	PBF	PBF261016C00065000	call	65.0000	2026-10-16	10.7000	10.7000	11.6000	73.8275	49221.00	0.00	49221.00	46	12	63	205	0.307317073170732	0.733713589644487	0.733713589644487	false	false	false
116bbe3a-e5a8-4a45-a7d9-63a6dd6d5397	2026-09-24 12:00	2026-09-24 12:00	2026-09-24 12:00	PBF	PBF261120C00072500	call	72.5000	2026-11-20	9.0000	8.7000	9.0000	72.9300	78300.00	78300.00	0.00	87	20	88	29	3.03448275862069	0.750634527061549	0.750634527061549	false	false	false
149d41e2-4246-4dbf-942e-100d9cda38e4	2026-09-23 14:15	2026-09-23 14:15	2026-09-23 14:15	PBF	PBF261016P00070000	put	70.0000	2026-10-16	4.9000	4.9000	5.5000	70.2400	24500.00	0.00	24500.00	50	20	210	651	0.32258064516129	0.728878194514998	0.728878194514998	false	false	false
b0afff14-7e49-4625-91a7-d42edc8f9f8f	2026-09-23 13:59	2026-09-23 13:59	2026-09-23 13:59	PBF	PBF261120C00080000	call	80.0000	2026-11-20	4.5600	4.5000	5.1000	70.1750	71590.00	25300.00	46290.00	157	7	181	423	0.42789598108747	0.704082728866763	0.713454493664618	false	false	false
67b00618-7ed6-4527-9914-5d661d70e4f5	2026-09-23 13:47	2026-09-23 13:47	2026-09-23 13:47	PBF	PBF261218P00067500	put	67.5000	2026-12-18	8.4000	7.9000	8.4000	70.0000	70560.00	70560.00	0.00	84	18	85	61	1.39344262295082	0.753452866100439	0.753452866100439	false	false	false
c11e52b7-f3b8-45bf-8895-8ab9f19591f2	2026-09-23 12:49	2026-09-23 12:49	2026-09-23 12:49	PBF	PBF261016P00060000	put	60.0000	2026-10-16	1.5500	1.4500	1.6000	69.3100	64480.00	9920.00	54560.00	416	14	473	1021	0.463271302644466	0.758992710686959	0.758992710686959	false	false	false
6aebaa4f-e191-4f00-b7ae-fc1611fb591d	2026-09-23 12:49	2026-09-23 12:49	2026-09-23 12:49	PBF	PBF261016P00065000	put	65.0000	2026-10-16	3.0600	3.0000	3.2000	69.3050	43403.00	21373.00	18310.00	142	17	158	3657	0.0432048126879956	0.748851233139	0.748851233139	false	false	false
c993c9b6-2f26-4621-b61b-fb4ce9b59522	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	PBF	PBF261016C00060000	call	60.0000	2026-10-16	11.6000	11.6000	13.5000	70.5019	133400.00	0.00	133400.00	115	13	115	78	1.47435897435897	0.668494147819132	0.668494147819132	false	false	false
76bf2ad1-9a59-4713-aa58-5acc02080437	2026-09-22 12:31	2026-09-22 12:31	2026-09-22 12:31	PBF	PBF261016C00077500	call	77.5000	2026-10-16	4.6000	4.3000	4.6000	74.4800	54280.00	54280.00	0.00	118	35	146	1894	0.0770855332629356	0.76159316360379	0.76159316360379	false	false	false
571d2041-9e08-4083-9101-acde8b47a28e	2026-09-22 12:06	2026-09-22 12:05	2026-09-22 12:05	PBF	PBF261218C00085000	call	85.0000	2026-12-18	6.8000	6.4000	6.8000	74.2000	212840.00	212840.00	0.00	313	25	313	159	1.9685534591195	0.722783614106679	0.722783614106679	false	false	false
f04a6deb-1eb1-449a-99bf-a6d95239d2cf	2026-09-22 10:26	2026-09-22 10:26	2026-09-22 10:26	PBF	PBF261016C00075000	call	75.0000	2026-10-16	4.6000	4.4000	4.6000	72.0000	92000.00	92000.00	0.00	200	15	305	1349	0.226093402520385	0.756780631379977	0.756780631379977	false	false	false
90d5cbbe-0768-49f9-a749-ffa7873a6273	2026-09-22 09:42	2026-09-22 09:42	2026-09-22 09:42	PBF	PBF261016P00072500	put	72.5000	2026-10-16	5.7000	5.7000	6.3000	71.7755	10260.00	0.00	10260.00	18	5	30	355	0.0845070422535211	0.737580149493788	0.737580149493788	false	false	false
3c19ab7c-143e-437d-b424-636bda727fcd	2026-09-18 15:50	2026-09-18 15:50	2026-09-18 15:50	PBF	PBF261016C00080000	call	80.0000	2026-10-16	4.9000	4.9000	5.3000	76.9100	12250.00	0.00	12250.00	25	8	1834	3393	0.540524609490127	0.71988942907938	0.71988942907938	false	false	false
2deaeb9c-ca13-4f5d-a92b-30c19961d1e2	2026-09-18 15:48	2026-09-18 15:48	2026-09-18 15:48	PBF	PBF261016C00080000	call	80.0000	2026-10-16	5.0000	4.9000	5.1000	77.0400	13000.00	12000.00	500.00	26	7	1683	3393	0.496021220159151	0.72449022110125	0.72449022110125	false	false	false
1546515a-a554-4750-94c3-c72988769587	2026-09-18 15:43	2026-09-18 15:43	2026-09-18 15:43	PBF	PBF260918C00075000	call	75.0000	2026-09-18	1.7000	1.4500	1.9500	76.7000	10030.00	2550.00	7480.00	59	5	2329	4431	0.525614985330625	2.13896013910779	4.9258978490014	false	false	false
f3fa41b0-de9d-4537-a4b4-2918262beb17	2026-09-18 15:19	2026-09-18 15:19	2026-09-18 15:19	PBF	PBF261016C00080000	call	80.0000	2026-10-16	4.9000	4.8000	5.1000	76.9000	43610.00	0.00	43610.00	89	6	1574	3393	0.463896256999705	0.720440884617857	0.720440884617857	false	false	false
facdde3e-186d-4519-a37d-b6c42c0084b2	2026-09-18 14:52	2026-09-18 14:52	2026-09-18 14:52	PBF	PBF260918C00075000	call	75.0000	2026-09-18	1.8000	1.3000	1.8000	76.7900	15300.00	15300.00	0.00	85	6	995	4431	0.224554276686978	1.08116368338082	1.08116368338082	false	false	false
c88941e5-a9f1-4f5a-bfb9-c071d5633b29	2026-09-18 13:18	2026-09-18 13:18	2026-09-18 13:18	PBF	PBF260918C00075000	call	75.0000	2026-09-18	1.8000	1.5000	1.8500	76.7700	18000.00	18000.00	0.00	100	5	382	4431	0.0862107876325886	0.954934111399996	0.85291273453715	false	false	false
04ff8d3c-b569-4135-a876-cb19fb46cebf	2026-09-18 13:12	2026-09-18 13:12	2026-09-18 13:12	PBF	PBF260918C00075000	call	75.0000	2026-09-18	1.7000	1.4000	1.8000	76.6900	17000.00	17000.00	0.00	100	11	182	4431	0.0410742496050553	0.648527487972747	0.648527487972747	false	false	false
abab520c-5cd4-41b2-9a03-d692fdd3d1e1	2026-09-18 11:09	2026-09-18 11:09	2026-09-18 11:09	PBF	PBF261016C00080000	call	80.0000	2026-10-16	5.6700	5.6000	5.7000	78.2000	56710.00	32980.00	0.00	100	18	303	3393	0.0893015030946065	0.74025435948248	0.734467706434564	false	false	false
dc8fe826-329c-41ba-b01a-c30adb86d608	2026-09-17 11:03	2026-09-17 11:03	2026-09-17 11:03	PBF	PBF261016C00080000	call	80.0000	2026-10-16	5.1700	4.8000	5.2000	76.3500	104940.00	104940.00	0.00	203	29	1030	2066	0.498547918683446	0.760609931535468	0.772308427231001	false	false	false
74dcb2ad-c0c4-4430-a651-505f7ac8cf13	2026-09-17 11:03	2026-09-17 11:03	2026-09-17 11:03	PBF	PBF261016C00080000	call	80.0000	2026-10-16	5.0000	4.8000	5.1000	76.3500	77000.00	17500.00	59500.00	154	5	808	2066	0.39109390125847	0.748906074276937	0.748906074276937	false	false	false
536807c6-995c-41a6-ad20-e757781da326	2026-09-17 11:03	2026-09-17 11:03	2026-09-17 11:03	PBF	PBF261016C00080000	call	80.0000	2026-10-16	5.1000	4.7000	5.1000	76.2200	106080.00	106080.00	0.00	208	18	654	2066	0.316553727008712	0.767626778814448	0.767626778814448	false	false	false
3f83e3aa-0e08-419b-9e2f-bc3d11e8e3a6	2026-09-17 11:03	2026-09-17 11:03	2026-09-17 11:03	PBF	PBF261016C00080000	call	80.0000	2026-10-16	5.0000	5.0000	5.1000	76.2200	89000.00	0.00	36000.00	178	8	446	2066	0.215876089060987	0.755896964576202	0.755896964576202	false	false	false
157ba408-b2cc-4297-9b38-a251c2e12c59	2026-09-17 11:03	2026-09-17 11:03	2026-09-17 11:03	PBF	PBF261016C00080000	call	80.0000	2026-10-16	4.9000	4.6000	5.0000	76.2200	116130.00	41160.00	66150.00	237	14	268	2066	0.1297192642788	0.751110293002803	0.744160998867159	false	false	false
dc427e6b-f323-4125-81a3-6c51e241c653	2026-09-16 15:05	2026-09-16 15:05	2026-09-16 15:05	PBF	PBF270115P00080000	put	80.0000	2027-01-15	14.7000	14.2000	14.7000	76.2400	58800.00	58800.00	0.00	40	18	41	11	3.72727272727273	0.753901535397362	0.753901535397362	false	false	false
40087839-960f-4b4e-9929-9278567f4e92	2026-09-16 15:05	2026-09-16 15:05	2026-09-16 15:05	PBF	PBF270115P00075000	put	75.0000	2027-01-15	11.8000	11.3000	11.8000	76.2400	84960.00	84960.00	0.00	72	25	72	28	2.57142857142857	0.753873561267068	0.753873561267068	false	false	false
71e145a2-c5af-4901-b4ff-c37c836fc2f5	2026-09-16 14:43	2026-09-16 14:43	2026-09-16 14:43	PBF	PBF260918C00070000	call	70.0000	2026-09-18	7.0000	6.4000	7.3000	76.7500	71400.00	9800.00	61600.00	102	9	326	1459	0.223440712816998	1.02104607626582	0.956932077390828	false	false	false
e5bcbbfd-72b1-45fa-8c29-971bdaf492bf	2026-09-16 14:01	2026-09-16 14:01	2026-09-16 14:01	PBF	PBF261016C00085000	call	85.0000	2026-10-16	3.5000	2.0000	4.0000	76.0000	11550.00	1050.00	10500.00	33	5	125	252	0.496031746031746	0.749628124883283	0.749628124883283	false	false	false
f1a32867-258e-4565-af7e-0f64099afed5	2026-09-16 10:20	2026-09-16 10:20	2026-09-16 10:20	PBF	PBF261016C00085000	call	85.0000	2026-10-16	2.9000	2.9000	3.2000	74.0000	25230.00	0.00	25230.00	87	20	88	252	0.349206349206349	0.762028607118451	0.762028607118451	false	false	false
1096e046-7095-4b98-8b81-132da2c94c3d	2026-09-16 10:20	2026-09-16 10:20	2026-09-16 10:20	PBF	PBF261016C00090000	call	90.0000	2026-10-16	1.9500	1.9500	2.2000	74.0000	161084.00	0.00	161084.00	826	47	841	130	6.46923076923077	0.769288736931854	0.769288736931854	false	false	false
fc333fd3-378c-47d5-83a1-8065a36c86cc	2026-09-15 15:16	2026-09-15 15:16	2026-09-15 15:16	PBF	PBF260918C00085000	call	85.0000	2026-09-18	0.3500	0.2000	0.3500	74.5900	20090.00	20090.00	0.00	574	41	1078	3153	0.341896606406597	1.09510882660487	1.09510882660487	true	false	false
abc948a4-646a-40bf-bb8a-922d69c506bb	2026-09-15 14:06	2026-09-15 14:06	2026-09-15 14:06	PBF	PBF260918C00080000	call	80.0000	2026-09-18	1.0500	0.9000	1.1500	75.2601	10080.00	105.00	8820.00	96	15	295	11930	0.0247275775356245	0.99723917452677	0.99723917452677	true	false	false
27e15f99-426d-4c94-8616-a0e54499e67c	2026-09-15 14:00	2026-09-15 14:00	2026-09-15 14:00	PBF	PBF260918C00080000	call	80.0000	2026-09-18	1.0500	1.0500	1.2000	75.5900	10395.00	0.00	10395.00	99	9	198	11930	0.0165968147527242	0.957928530455523	0.957928530455523	false	false	false
b143ecb2-462c-403a-a1bf-c85afe0a4cf9	2026-09-15 11:07	2026-09-15 11:07	2026-09-15 11:07	PBF	PBF270115P00035000	put	35.0000	2027-01-15	0.5000	0.5000	0.7500	73.0000	21916.00	0.00	21916.00	438	32	439	131	3.35114503816794	0.798700849148955	0.798700849148955	false	false	false
376f527d-2a71-4d7a-baa7-0258774e47cb	2026-09-14 15:48	2026-09-14 15:48	2026-09-14 15:48	PBF	PBF261016P00055000	put	55.0000	2026-10-16	0.9500	0.7500	1.0500	71.0000	41990.00	1330.00	40660.00	442	33	589	248	2.375	0.784562037799776	0.784562037799776	false	false	false
e3548ad6-4d52-47e5-8faf-9313ad5b10cb	2026-09-14 15:00	2026-09-14 15:00	2026-09-14 15:00	PBF	PBF261016C00077500	call	77.5000	2026-10-16	4.1000	3.8000	4.1000	71.3000	27880.00	27880.00	0.00	68	5	887	88	10.0795454545455	0.759698512315587	0.759698512315587	true	false	false
098213b3-596d-4dc3-9dd9-1ddf20a4f400	2026-09-14 13:24	2026-09-14 13:24	2026-09-14 13:24	PBF	PBF261016C00075000	call	75.0000	2026-10-16	5.4000	5.4000	5.6000	72.0600	183060.00	0.00	183060.00	339	15	702	128	5.484375	0.768956051024112	0.768956051024112	true	false	false
b0042660-23c1-4376-bc77-715bc9d5a85a	2026-09-14 13:17	2026-09-14 13:17	2026-09-14 13:17	PBF	PBF261016C00075000	call	75.0000	2026-10-16	5.3000	5.1000	5.5000	72.0800	182320.00	179140.00	3180.00	344	23	363	128	2.8359375	0.756065037080159	0.756065037080159	false	false	false
e597f741-0c5a-4276-9393-8ad5345881b2	2026-09-14 11:52	2026-09-14 11:52	2026-09-14 11:52	PBF	PBF261016C00077500	call	77.5000	2026-10-16	4.9900	4.0000	5.2000	73.1300	150290.00	121290.00	29000.00	301	43	811	88	9.21590909090909	0.76358570209576	0.773682882929501	false	false	false
809252b0-f217-429e-b639-befa007251b0	2026-09-14 11:45	2026-09-14 11:45	2026-09-14 11:45	PBF	PBF261218C00075000	call	75.0000	2026-12-18	10.3000	10.3000	10.5000	72.5700	12360.00	0.00	12360.00	12	6	14	114	0.12280701754386	0.747279165854613	0.747279165854613	true	false	false
fd203b67-e2a2-443b-9762-35d810deb95a	2026-09-14 11:14	2026-09-14 11:14	2026-09-14 11:14	PBF	PBF261016P00075000	put	75.0000	2026-10-16	7.5000	6.7000	7.5000	73.0700	18000.00	18000.00	0.00	24	10	31	86	0.36046511627907	0.761667721762287	0.761667721762287	false	false	false
07d19fe4-5fc0-44d5-bb59-ba5a58417b16	2026-09-14 11:13	2026-09-14 11:13	2026-09-14 11:13	PBF	PBF261016C00077500	call	77.5000	2026-10-16	5.1000	4.6000	5.3000	73.4450	25500.00	5100.00	20400.00	50	5	505	88	5.73863636363636	0.768673896480962	0.768673896480962	false	false	false
ff1febb0-fa5b-4a18-b798-2a30e6faccf0	2026-09-14 11:13	2026-09-14 11:13	2026-09-14 11:13	PBF	PBF261016C00077500	call	77.5000	2026-10-16	5.1000	4.6000	5.2000	73.6050	157590.00	151980.00	5610.00	309	12	432	88	4.90909090909091	0.760178288712021	0.760178288712021	true	false	false
56c6f298-457b-4e1b-bef2-3d5557bc26ee	2026-09-14 11:13	2026-09-14 11:13	2026-09-14 11:13	PBF	PBF261016C00077500	call	77.5000	2026-10-16	5.1000	4.6000	5.2000	73.6050	57630.00	51510.00	6120.00	113	13	122	88	1.38636363636364	0.760178288712021	0.760178288712021	true	false	false
e490b3bd-35d1-40f6-87f2-1e9c93ffacab	2026-09-11 15:56	2026-09-11 15:56	2026-09-11 15:56	PBF	PBF261016C00080000	call	80.0000	2026-10-16	6.3000	6.3000	6.7000	78.1400	16380.00	0.00	16380.00	26	6	604	725	0.833103448275862	0.725574705902148	0.725574705902148	false	false	false
516b66f0-eaa6-45ab-9439-bd617fc42a44	2026-09-11 15:23	2026-09-11 15:23	2026-09-11 15:23	PBF	PBF261218P00065000	put	65.0000	2026-12-18	4.7300	4.6000	5.6000	78.3600	23658.00	0.00	18508.00	50	13	50	59	0.847457627118644	0.689990921223194	0.733929931984189	false	false	false
84972f1f-c95a-4c40-8a3a-6027a97a0ec0	2026-09-11 09:56	2026-09-11 09:56	2026-09-11 09:56	PBF	PBF260918C00080000	call	80.0000	2026-09-18	4.0900	3.7000	4.7000	81.0000	490800.00	0.00	490800.00	1200	2	2443	13417	0.18208243273459	0.710267623010531	0.710267623010531	false	true	true
9531b3a6-d432-401b-9ce1-a8ab15e9537c	2026-09-10 12:28	2026-09-10 12:28	2026-09-10 12:28	PBF	PBF260918C00085000	call	85.0000	2026-09-18	1.3000	1.3000	1.5000	77.5800	15990.00	0.00	15990.00	123	29	693	1888	0.367055084745763	0.819715707746851	0.819715707746851	true	false	false