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:ticker = SOC×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	price

8d2ba836-00b2-4b72-a9cf-547a5b08caf3	2026-08-19 13:37	2026-08-19 13:37	2026-08-19 13:37	SOC	SOC261016C00004000	call	4.0000	2026-10-16	0.9600	0.7200	0.9600	4.1050	35232.00	35232.00	0.00	367	15	518	1481	0.349763673193788	1.40965696995022	1.40965696995022	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	924811337.00	2026-11-12	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
131ab30c-6a1b-437b-822b-c0c2fbe54fe6	2026-08-19 13:38	2026-08-19 13:38	2026-08-19 13:38	SOC	SOC260821C00004000	call	4.0000	2026-08-21	0.5900	0.5900	0.6300	4.3400	18516.00	2940.00	15576.00	313	12	786	4537	0.173242230548821	3.31624609552106	3.22956405413016	true	false	false	true	false
e4e68922-df0e-43d8-9feb-f68c9e0def91	2026-08-19 13:39	2026-08-19 13:38	2026-08-19 13:38	SOC	SOC270115C00006000	call	6.0000	2027-01-15	0.9000	0.6500	0.9000	4.6000	13410.00	13410.00	0.00	149	5	231	28756	0.00803310613437196	1.11998262031836	1.11998262031836	true	false	false	true	false
ab863489-d1fe-4c37-a0fd-8839fadea736	2026-08-19 13:49	2026-08-19 13:49	2026-08-19 13:49	SOC	SOC260918P00005000	put	5.0000	2026-09-18	0.7300	0.7000	0.7300	4.7450	118002.00	117092.00	910.00	1617	9	1621	700	2.31571428571429	1.03254558055924	1.03254558055924	false	false	false	true	false
e434a741-5f24-4664-9a82-7ac0b1572472	2026-08-19 14:00	2026-08-19 13:59	2026-08-19 13:59	SOC	SOC260821C00005000	call	5.0000	2026-08-21	0.3500	0.2000	0.5000	4.8900	26180.00	3430.00	11830.00	748	10	2314	11780	0.196434634974533	2.7933519380214	2.75895216439563	false	false	false	true	false
da113361-a05c-4930-a702-1d082a564d6a	2026-08-19 14:00	2026-08-19 14:00	2026-08-19 14:00	SOC	SOC260821C00005000	call	5.0000	2026-08-21	0.3500	0.2000	0.5000	4.8800	12005.00	0.00	6195.00	343	5	3731	11780	0.316723259762309	2.7933519380214	2.7933519380214	false	false	false	true	false
c3b02137-48e3-4f34-a789-47ecbbd63179	2026-08-19 14:00	2026-08-19 13:59	2026-08-19 13:59	SOC	SOC260821C00005000	call	5.0000	2026-08-21	0.3500	0.2000	0.5000	4.8800	27510.00	6475.00	16765.00	786	16	1566	11780	0.132937181663837	2.84471730595071	2.7933519380214	false	false	false	true	false
9619c1f1-3542-4fa7-8ab6-1529030b3d5f	2026-08-19 14:00	2026-08-19 13:59	2026-08-19 13:59	SOC	SOC260821C00005000	call	5.0000	2026-08-21	0.3500	0.2000	0.5000	4.8900	30345.00	2170.00	23310.00	867	9	3181	11780	0.270033955857385	2.75895216439563	2.75895216439563	false	false	false	true	false
db8802a4-dde6-4df8-8587-44eff59e01e9	2026-08-19 14:42	2026-08-19 14:42	2026-08-19 14:42	SOC	SOC260821C00004500	call	4.5000	2026-08-21	0.5800	0.2500	0.7200	4.8100	11946.00	11568.00	378.00	207	21	1358	2216	0.612815884476534	3.87112443586538	2.65032112072533	false	false	false	true	false
dde327a5-8349-4491-a733-402425c6d92f	2026-08-19 14:50	2026-08-19 14:50	2026-08-19 14:50	SOC	SOC260918C00005000	call	5.0000	2026-09-18	0.7800	0.7800	0.9300	5.0800	13104.00	0.00	13104.00	168	6	2080	3903	0.532923392262362	1.27766450777338	1.27766450777338	false	false	false	true	false
68d871a1-7785-490a-bcb4-209cc3f1fa01	2026-08-20 09:43	2026-08-20 09:43	2026-08-20 09:43	SOC	SOC261002P00003500	put	3.5000	2026-10-02	0.1500	0.0800	0.3100	5.0400	11300.00	0.00	11300.00	750	6	750	4	187.5	1.13947154924939	1.16692580048746	false	false	false	true	false
ee3c83bf-f3f9-42e4-aae9-32cc0d00a0c5	2026-08-20 09:47	2026-08-20 09:47	2026-08-20 09:47	SOC	SOC261016P00005000	put	5.0000	2026-10-16	0.8100	0.8100	0.9000	5.0700	40650.00	0.00	40650.00	500	9	513	835	0.61437125748503	1.08340499673007	1.13261154938028	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false