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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:sector = Energy×source = uw_flow_alerts×ticker = SOC×

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

81db4f44-c935-403d-a8d1-64225f4cb1aa	2026-09-21 13:04	2026-09-21 13:04	2026-09-21 13:04	SOC	SOC260925C00004500	call	4.5000	2026-09-25	0.1600	0.1500	0.1800	4.4286	20144.00	0.00	6432.00	1259	13	1453	246	5.90650406504065	1.03449107531709	1.03449107531709	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	830795247.00	2026-11-12	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T17:07:15.058898Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
62383cf3-90a3-4574-b66d-d4f9943290c2	2026-09-16 14:12	2026-09-16 14:12	2026-09-16 14:12	SOC	SOC270115C00006000	call	6.0000	2027-01-15	0.7600	0.6700	0.7900	4.6700	10225.00	10225.00	0.00	135	7	266	27723	0.00959492118457598	1.07500472690203	1.0914941722678	false	false	false	true
8c145c63-13fd-459c-b8f1-3905ecca2151	2026-09-16 11:10	2026-09-16 11:10	2026-09-16 11:10	SOC	SOC261016C00006000	call	6.0000	2026-10-16	0.2200	0.2000	0.2200	4.6650	28952.00	28952.00	0.00	1316	17	7844	11655	0.673015873015873	1.1382732276778	1.1382732276778	false	false	false	true
d6aec028-a58b-49a8-8b5e-0b2628893078	2026-09-16 10:20	2026-09-16 10:20	2026-09-16 10:20	SOC	SOC261016C00006000	call	6.0000	2026-10-16	0.2200	0.2000	0.2400	4.0000	28380.00	17424.00	10956.00	1290	6	3000	11655	0.257400257400257	1.11062114519407	1.11062114519407	false	false	false	true
c8e2cefd-c4ad-4045-9cd7-17e7456b84f6	2026-09-16 10:05	2026-09-16 10:05	2026-09-16 10:05	SOC	SOC261016C00006000	call	6.0000	2026-10-16	0.2200	0.2000	0.2400	4.7500	17754.00	15884.00	1650.00	807	15	1092	11655	0.0936936936936937	1.08615693264423	1.08615693264423	false	false	false	true
b46be711-f471-4a16-bff7-600f8b59407b	2026-09-15 15:22	2026-09-15 15:22	2026-09-15 15:22	SOC	SOC270115C00006000	call	6.0000	2027-01-15	0.9200	0.8200	0.9200	4.9350	34592.00	34592.00	0.00	376	31	432	27697	0.0155973571144889	1.10387652216675	1.10387652216675	false	false	false	true
6e127205-7012-46ea-9c6f-4d51ac3c6b77	2026-09-15 14:12	2026-09-15 14:12	2026-09-15 14:12	SOC	SOC261016C00005000	call	5.0000	2026-10-16	0.6500	0.6500	0.7300	5.0000	16185.00	0.00	16185.00	249	5	1077	13880	0.0775936599423631	1.11000411840854	1.11000411840854	true	false	false	true
762d1e9b-b0bc-451b-abc0-e8cd9c07f336	2026-09-15 14:07	2026-09-15 14:07	2026-09-15 14:07	SOC	SOC261016C00005000	call	5.0000	2026-10-16	0.6400	0.6400	0.6500	5.0000	10240.00	0.00	10240.00	160	8	577	13880	0.0415706051873199	1.10244137927948	1.09254785375102	true	false	false	true
b23adc53-2e5b-41e8-9263-368da4d2d881	2026-09-14 15:36	2026-09-14 15:35	2026-09-14 15:35	SOC	SOC270115C00006000	call	6.0000	2027-01-15	0.7900	0.7900	0.9000	4.8750	13825.00	0.00	13825.00	175	11	285	27804	0.0102503236944325	1.01384841853659	1.01384841853659	false	false	false	true
f89933fe-861f-4b3c-abca-e8c4ddf3212d	2026-09-14 15:34	2026-09-14 15:34	2026-09-14 15:34	SOC	SOC261002P00004000	put	4.0000	2026-10-02	0.1000	0.0900	0.1300	4.9000	10000.00	0.00	10000.00	1000	7	1004	474	2.11814345991561	1.02232988604572	1.02232988604572	false	false	false	true
2e3b9e23-48c8-4327-8902-3e4048a3d0df	2026-09-14 10:16	2026-09-14 10:16	2026-09-14 10:16	SOC	SOC260918C00005500	call	5.5000	2026-09-18	0.2000	0.1300	0.2500	5.0000	23740.00	540.00	23200.00	1187	11	1331	9168	0.145178883071553	1.15446488607601	1.15446488607601	false	false	false	true
2d6a76cc-955f-4b29-a681-67ea1e33d6d0	2026-09-11 11:31	2026-09-11 11:30	2026-09-11 11:30	SOC	SOC261016C00006000	call	6.0000	2026-10-16	0.3000	0.2200	0.3000	4.8500	17880.00	17880.00	0.00	596	14	2304	9926	0.232117670763651	1.09945708128567	1.09945708128567	false	false	false	true
2b4457f3-c0f8-4170-b38c-e3e1d23971b7	2026-09-11 10:48	2026-09-11 10:48	2026-09-11 10:48	SOC	SOC261016C00006000	call	6.0000	2026-10-16	0.3000	0.2600	0.3000	4.8550	11760.00	11760.00	0.00	392	13	1276	9926	0.128551279468064	1.09643116335247	1.09643116335247	false	false	false	true
df52941f-5a53-44d6-95b3-ffb505a081df	2026-09-11 09:31	2026-09-11 09:31	2026-09-11 09:31	SOC	SOC261016C00006000	call	6.0000	2026-10-16	0.3000	0.3000	0.3300	4.0000	13080.00	0.00	13080.00	436	15	650	9926	0.0654845859359258	1.08434110592112	1.08434110592112	false	false	false	true
7c0d6bc8-cd05-4c15-8761-050703b498ff	2026-09-10 14:49	2026-09-10 14:49	2026-09-10 14:49	SOC	SOC261016C00006000	call	6.0000	2026-10-16	0.3000	0.2900	0.3100	4.8317	15510.00	13590.00	750.00	517	12	967	9393	0.102949004577877	1.09493858761976	1.09493858761976	false	false	false	true
93e7c57f-475c-49e6-a2a9-fe938b405598	2026-09-08 10:09	2026-09-08 10:09	2026-09-08 10:09	SOC	SOC260918P00004500	put	4.5000	2026-09-18	0.1500	0.1100	0.2000	4.9050	11250.00	0.00	8310.00	750	7	761	103	7.38834951456311	1.0005609080613	1.01070197828417	false	false	false	true
74e41b3e-82e9-4c80-89a3-bceacac05fc4	2026-09-02 15:10	2026-09-02 15:10	2026-09-02 15:10	SOC	SOC260925C00005000	call	5.0000	2026-09-25	0.4500	0.4500	0.5500	4.8900	20745.00	0.00	20745.00	461	8	1092	7865	0.138842975206612	1.00838327150575	1.00838327150575	false	false	false	true
f80cf610-01f5-456c-bbfa-33e2f21d68b8	2026-09-02 14:08	2026-09-02 14:07	2026-09-02 14:07	SOC	SOC261016C00005000	call	5.0000	2026-10-16	0.6000	0.6000	0.7700	4.7600	27660.00	0.00	27660.00	461	16	828	12272	0.067470664928292	1.04845969809497	1.04845969809497	false	false	false	true
f22090b3-9747-41f6-959d-af4a9ba5bb63	2026-09-02 14:07	2026-09-02 14:06	2026-09-02 14:06	SOC	SOC261016C00005000	call	5.0000	2026-10-16	0.6000	0.6000	0.6200	4.7550	16200.00	0.00	16200.00	270	18	347	12272	0.0282757496740548	1.05243856304591	1.05243856304591	false	false	false	true
505cc35d-5d52-4640-bc29-abf43091f9cf	2026-09-02 10:32	2026-09-02 10:31	2026-09-02 10:31	SOC	SOC261016P00005000	put	5.0000	2026-10-16	0.9000	0.8500	1.0800	4.5800	13680.00	6840.00	6210.00	152	40	2393	1459	1.64016449623029	1.03884169532508	1.03884169532508	false	false	false	true
252ebc99-02d8-40fc-85aa-54d156fba3cb	2026-09-02 10:24	2026-09-02 10:24	2026-09-02 10:24	SOC	SOC261016P00005000	put	5.0000	2026-10-16	0.8900	0.8900	0.9100	4.6300	16020.00	0.00	16020.00	180	10	2058	1459	1.41055517477724	1.05541608025772	1.0633172854598	false	false	false	true
6789f31b-deea-4346-8b20-3aa7e17bbe37	2026-09-02 10:24	2026-09-02 10:24	2026-09-02 10:24	SOC	SOC261016P00005000	put	5.0000	2026-10-16	0.8800	0.8800	0.9100	4.6250	13974.00	0.00	13974.00	158	6	1877	1459	1.28649760109664	1.05937575071808	1.0437633271731	false	false	false	true
cc60dcbd-a6c1-41ec-a5f7-4ef7087babba	2026-09-02 09:40	2026-09-02 09:39	2026-09-02 09:39	SOC	SOC261016P00005000	put	5.0000	2026-10-16	0.8700	0.8700	0.9300	4.6601	46806.00	0.00	46806.00	538	14	1402	1459	0.960932145305003	1.05568881040978	1.05568881040978	false	false	false	true
f4265c88-1dd2-4285-ab94-9f0510ba5009	2026-09-01 15:51	2026-09-01 15:50	2026-09-01 15:50	SOC	SOC270115C00012500	call	12.5000	2027-01-15	0.1800	0.1400	0.2000	4.7750	10782.00	9270.00	1512.00	599	10	725	1097	0.660893345487694	1.10452209021088	1.10452209021088	false	false	false	true
66016a50-f52b-4583-abb3-bfdb945cd583	2026-09-01 15:11	2026-09-01 15:11	2026-09-01 15:11	SOC	SOC261016P00005000	put	5.0000	2026-10-16	0.8700	0.8700	0.9000	4.7150	33076.00	1408.00	31668.00	380	20	398	984	0.404471544715447	1.08527636469269	1.10043716456972	false	false	false	true
094e99eb-dd59-4709-be37-bc4115275b49	2026-09-01 09:49	2026-09-01 09:49	2026-09-01 09:49	SOC	SOC260918C00005500	call	5.5000	2026-09-18	0.2000	0.1600	0.2300	4.8450	19580.00	6040.00	13540.00	979	16	987	10031	0.0983949755757153	1.0172092108541	1.0172092108541	false	false	false	true
3d76ef7b-a832-414d-b9a9-ca4717c7900e	2026-08-31 15:51	2026-08-31 15:51	2026-08-31 15:51	SOC	SOC260925C00005000	call	5.0000	2026-09-25	0.4400	0.4400	0.4800	4.8000	21516.00	0.00	21516.00	489	6	687	10227	0.0671751246699912	1.03725763827678	1.03725763827678	false	false	false	true
ddbb9450-22a2-460d-abcc-b5b70e7c608d	2026-08-31 13:43	2026-08-31 13:43	2026-08-31 13:43	SOC	SOC270115C00007500	call	7.5000	2027-01-15	0.5000	0.5000	0.5500	4.5750	26450.00	0.00	22750.00	529	11	537	1650	0.325454545454545	1.07074240404593	1.07074240404593	false	false	false	true
29e57a7b-3d86-486a-be00-fef0096a233e	2026-08-27 12:44	2026-08-27 12:44	2026-08-27 12:44	SOC	SOC260925C00005000	call	5.0000	2026-09-25	0.3900	0.3600	0.3900	4.5100	25557.00	24531.00	1026.00	656	7	9033	469	19.2601279317697	1.12523773459336	1.10526134240298	false	false	false	true
f134bb84-e6e3-4bd3-b64b-fbfbf413726a	2026-08-27 12:30	2026-08-27 12:30	2026-08-27 12:30	SOC	SOC260925C00005000	call	5.0000	2026-09-25	0.3900	0.2400	0.4300	4.5150	20709.00	17160.00	3549.00	531	5	8067	469	17.2004264392324	1.12086988584793	1.12086988584793	false	false	false	true
e54a6628-04d6-41dd-be86-2e7d121987ff	2026-08-27 12:22	2026-08-27 12:22	2026-08-27 12:22	SOC	SOC280121C00010000	call	10.0000	2028-01-21	1.1900	1.1500	1.4500	4.5550	73780.00	59024.00	14756.00	620	5	752	7315	0.102802460697198	1.01613992632957	1.01613992632957	false	false	false	true
ac39af47-6d99-43b8-b757-cac1b460759e	2026-08-27 11:16	2026-08-27 11:16	2026-08-27 11:16	SOC	SOC260925C00005000	call	5.0000	2026-09-25	0.3900	0.3300	0.4000	4.5050	44967.00	41964.00	0.00	1153	17	7485	469	15.9594882729211	1.12960505377757	1.12960505377757	false	false	false	true
47624435-4ddd-4ee7-aa15-b88c31d267eb	2026-08-27 11:11	2026-08-27 11:11	2026-08-27 11:11	SOC	SOC260918C00005000	call	5.0000	2026-09-18	0.3000	0.2700	0.3000	4.4700	28560.00	28560.00	0.00	952	6	1720	4611	0.373021036651486	1.12417820657907	1.12417820657907	false	false	false	true
6068e6d6-a79c-4f40-a402-13de0ffaf8d7	2026-08-27 11:01	2026-08-27 11:01	2026-08-27 11:01	SOC	SOC270115C00006000	call	6.0000	2027-01-15	0.8400	0.8400	1.0000	4.5150	11928.00	0.00	11928.00	142	5	234	27620	0.00847212165097755	1.13817154684227	1.13817154684227	false	false	false	true
5cd3eff6-7d78-40cb-91ce-6b1705c1dc1a	2026-08-27 10:56	2026-08-27 10:56	2026-08-27 10:56	SOC	SOC260925C00005000	call	5.0000	2026-09-25	0.3900	0.2800	0.4100	4.5200	41333.00	38883.00	929.00	1060	24	5977	469	12.7441364605544	1.12960505377757	1.09657997127597	true	false	false	true
87ca6811-607c-491e-8dd9-6b2f258df345	2026-08-27 10:46	2026-08-27 10:46	2026-08-27 10:46	SOC	SOC260925C00005000	call	5.0000	2026-09-25	0.3900	0.3400	0.4200	4.5450	54988.00	49842.00	1129.00	1410	37	4356	469	9.28784648187633	1.09902080177179	1.09464862877327	true	false	false	true
513a5591-332b-4fba-bbd7-befc969e2019	2026-08-27 09:51	2026-08-27 09:51	2026-08-27 09:51	SOC	SOC260918C00005500	call	5.5000	2026-09-18	0.2000	0.1400	0.2300	4.5600	48460.00	41920.00	6540.00	2423	10	4539	2992	1.51704545454545	1.1083785954677	1.1083785954677	false	false	false	true
6186c56f-ea0d-4c02-ad34-793f67831150	2026-08-27 09:41	2026-08-27 09:41	2026-08-27 09:41	SOC	SOC260918C00005500	call	5.5000	2026-09-18	0.1900	0.1100	0.1900	4.5400	13490.00	13490.00	0.00	710	8	897	2992	0.299799465240642	1.09731943394025	1.09731943394025	true	false	false	true
28ea4e54-1a64-42f1-a9b3-9f5ba4497b28	2026-08-26 10:09	2026-08-26 10:09	2026-08-26 10:09	SOC	SOC261016P00005000	put	5.0000	2026-10-16	1.0500	0.7600	1.0500	4.7450	52500.00	52500.00	0.00	500	20	500	1377	0.363108206245461	1.298029890916	1.298029890916	false	false	false	true
4229fdbc-1784-4879-a6d7-2cfde12dfeae	2026-08-25 14:03	2026-08-25 14:03	2026-08-25 14:03	SOC	SOC261016C00006000	call	6.0000	2026-10-16	0.3100	0.3000	0.3600	4.0000	12252.00	5828.00	6424.00	400	12	509	6829	0.0745350710206472	0.953930684421385	0.953930684421385	false	false	false	true
47c69e9b-3210-494e-b57a-8ac9211acc17	2026-08-24 11:12	2026-08-24 11:12	2026-08-24 11:12	SOC	SOC261016C00008000	call	8.0000	2026-10-16	0.2000	0.1500	0.2000	5.0050	29960.00	29960.00	0.00	1498	18	1523	1584	0.961489898989899	1.14436185029415	1.14436185029415	false	false	false	true
495034cd-3f50-480b-bfbb-d9a9a784a8fe	2026-08-21 11:35	2026-08-21 11:35	2026-08-21 11:35	SOC	SOC270115C00015000	call	15.0000	2027-01-15	0.1800	0.1000	0.1900	5.1850	10512.00	8352.00	2160.00	584	6	586	2995	0.195659432387312	1.11211690052252	1.11211690052252	false	false	false	true
849cb08c-e63d-4d76-b7d6-8839a7ad6bc8	2026-08-21 10:28	2026-08-21 10:28	2026-08-21 10:28	SOC	SOC260821C00005000	call	5.0000	2026-08-21	0.3000	0.2700	0.3000	5.2750	14640.00	14640.00	0.00	488	11	5235	13992	0.374142367066895	2.19617929322292	2.19617929322292	false	false	false	true
8e8822e3-b490-422a-bc21-d62f4174547c	2026-08-21 10:10	2026-08-21 10:10	2026-08-21 10:10	SOC	SOC260821C00005000	call	5.0000	2026-08-21	0.3000	0.2800	0.3800	5.2850	25170.00	6810.00	18360.00	839	19	4077	13992	0.291380789022298	1.84993182195596	1.84993182195596	true	false	false	true
e93490bb-d64d-4767-82d9-07cae926727e	2026-08-21 10:08	2026-08-21 10:08	2026-08-21 10:08	SOC	SOC260821C00005000	call	5.0000	2026-08-21	0.3000	0.2600	0.3400	5.2800	25380.00	3870.00	21510.00	846	15	3119	13992	0.222913093196112	2.13015705661595	1.99617701477121	false	false	false	true
26e237d3-07c1-413e-a0d7-dd5db55b877e	2026-08-21 10:07	2026-08-21 10:07	2026-08-21 10:07	SOC	SOC260821C00005000	call	5.0000	2026-08-21	0.3000	0.2600	0.3000	5.2750	16530.00	16530.00	0.00	551	11	1766	13992	0.126214979988565	2.12778327281189	2.12778327281189	false	false	false	true
48749721-9fcb-4779-827c-0a87f68e0b0a	2026-08-21 10:04	2026-08-21 10:04	2026-08-21 10:04	SOC	SOC260821C00005000	call	5.0000	2026-08-21	0.2900	0.2600	0.3000	5.2800	28900.00	16860.00	0.00	992	14	1124	13992	0.0803316180674671	2.14095226842408	1.98647620590405	false	false	false	true
fad267c1-2a42-4ad4-b88e-3a38930d3e63	2026-08-20 15:56	2026-08-20 15:56	2026-08-20 15:56	SOC	SOC270115C00007500	call	7.5000	2027-01-15	0.8600	0.6500	0.8600	5.0450	51600.00	1720.00	0.00	600	23	609	1057	0.576158940397351	1.17514750452881	1.17514750452881	true	false	false	true
74662854-1874-45f2-aa00-bca6cc0616c5	2026-08-20 11:33	2026-08-20 11:33	2026-08-20 11:33	SOC	SOC270115C00006000	call	6.0000	2027-01-15	1.2000	1.0700	1.2000	5.0150	12000.00	12000.00	0.00	100	7	5408	28325	0.190926743159753	1.18808431035229	1.18808431035229	false	false	false	true
670bd98d-8109-4a7c-8755-c499a5a76cf9	2026-08-20 10:37	2026-08-20 10:37	2026-08-20 10:37	SOC	SOC260821C00005000	call	5.0000	2026-08-21	0.3500	0.2700	0.3500	5.0900	14560.00	14560.00	0.00	416	6	748	13909	0.0537781292688188	2.87523143852647	2.87523143852647	false	false	false	true