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:option_symbol = AS261002C00027000×ticker = AS×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	expiry

f68b5dd5-f463-4551-8342-ea5e3445ec6d	2026-09-03 12:40	2026-09-03 12:40	2026-09-03 12:40	AS	AS261002C00027000	call	27.0000	2026-10-02	2.3600	2.0000	2.4500	28.4200	1177746.00	833989.00	334122.00	5001	51	5001	0	0	0.485361527951175	0.475900776754573	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Consumer Cyclical	15363736512.00	2026-11-17	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
618cc997-f898-4e92-8ce2-17c03d4e563f	2026-09-03 12:41	2026-09-03 12:41	2026-09-03 12:41	AS	AS261002C00027000	call	27.0000	2026-10-02	2.4500	2.2000	2.5500	28.4430	575248.00	569368.00	5880.00	2348	56	7349	0	0	0.505305292365669	0.505305292365669	false	false	false	true
8baa06ab-60f2-4932-96e5-0231926527c3	2026-09-03 13:02	2026-09-03 13:02	2026-09-03 13:02	AS	AS261002C00027000	call	27.0000	2026-10-02	2.4500	2.4000	2.5000	28.5600	649005.00	0.00	324380.00	2649	6	10410	0	0	0.477204917491722	0.477204917491722	false	false	false	true
195e5347-efe4-4d27-a74b-7c75de77ff73	2026-09-04 12:16	2026-09-04 12:16	2026-09-04 12:16	AS	AS261002C00027000	call	27.0000	2026-10-02	3.2000	3.2000	3.3000	29.5900	1010435.00	4564.00	998721.00	3157	56	3578	11690	0.306073567151411	0.474430875852569	0.482206041538029	false	false	false	true
1390b5bf-1620-4eaa-972b-0b5fefc68cef	2026-09-04 14:36	2026-09-04 14:36	2026-09-04 14:36	AS	AS261002C00027000	call	27.0000	2026-10-02	3.2000	3.1000	3.2000	29.5950	13760.00	13760.00	0.00	43	7	3713	11690	0.317621899059025	0.480591327177518	0.480591327177518	false	false	false	true
4326f7d7-d33a-40e4-9025-b8275b013f08	2026-09-04 14:58	2026-09-04 14:58	2026-09-04 14:58	AS	AS261002C00027000	call	27.0000	2026-10-02	3.2000	3.1000	3.2000	29.6250	27520.00	27520.00	0.00	86	16	4795	11690	0.410179640718563	0.470770302630846	0.470770302630846	true	false	false	true
f298dd46-acfd-4ec0-8d3d-1ec42097d9f3	2026-09-04 15:10	2026-09-04 15:10	2026-09-04 15:10	AS	AS261002C00027000	call	27.0000	2026-10-02	3.2000	3.1000	3.2000	29.6350	134400.00	134400.00	0.00	420	6	5286	11690	0.452181351582549	0.467443571472343	0.467443571472343	false	false	false	true
eb9283ed-d61e-42b4-a9be-3362f1c21a3c	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	AS	AS261002C00027000	call	27.0000	2026-10-02	1.9500	1.9500	2.0000	28.0600	140400.00	0.00	140400.00	720	17	760	6530	0.116385911179173	0.500335541787823	0.500335541787823	true	false	false	true
ccf3f93f-b40f-473d-bace-c6eeb05dfba1	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	AS	AS261002C00027000	call	27.0000	2026-10-02	2.0000	1.7000	2.0500	28.0000	395959.00	387959.00	8000.00	1981	76	2741	6530	0.419754977029096	0.492262536400206	0.509919211196692	false	false	false	true
b98fc242-b04f-4436-a3c2-786864028093	2026-09-11 09:31	2026-09-11 09:30	2026-09-11 09:30	AS	AS261002C00027000	call	27.0000	2026-10-02	2.0000	2.0000	2.1000	28.0000	43800.00	0.00	43800.00	219	12	3000	6530	0.459418070444104	0.4938007702335	0.4938007702335	false	false	false	true
99a09449-c8e9-4b79-909b-dbf07c48d58b	2026-09-11 09:59	2026-09-11 09:59	2026-09-11 09:59	AS	AS261002C00027000	call	27.0000	2026-10-02	1.9000	1.6000	1.9500	28.0000	576645.00	563540.00	12535.00	3035	74	6036	6530	0.924349157733538	0.485445917315384	0.490724389901096	false	false	false	true
ec6b7dc5-f1ae-4ec3-a2b2-49a2fe0c4a7e	2026-09-11 11:51	2026-09-11 11:51	2026-09-11 11:51	AS	AS261002C00027000	call	27.0000	2026-10-02	2.0000	1.7500	2.0000	28.0100	300000.00	300000.00	0.00	1500	34	11558	6530	1.76998468606432	0.533414744099667	0.533414744099667	false	false	false	true
a9b78fcf-109d-4210-a07a-b48474e63d20	2026-09-14 11:29	2026-09-14 11:29	2026-09-14 11:29	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6100	1.6000	1.7000	27.7800	10304.00	0.00	10304.00	64	6	4436	17971	0.246842134550109	0.47352807599647	0.47352807599647	false	false	false	true
d531e59a-3937-4ac2-8859-2c7eaa077973	2026-09-14 11:45	2026-09-14 11:45	2026-09-14 11:45	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6700	1.6500	1.8000	27.9000	10354.00	0.00	10354.00	62	5	5153	17971	0.286739747370764	0.466148568572953	0.466148568572953	false	false	false	true
a93e769d-98a4-4e23-adc2-b080ef5a7941	2026-09-14 11:59	2026-09-14 11:58	2026-09-14 11:58	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6100	1.6000	1.7000	27.8100	10465.00	0.00	10465.00	65	5	5775	17971	0.321351065605698	0.46529174761833	0.46529174761833	false	false	false	true
389ab986-9900-4821-8d96-d3c0ac57155e	2026-09-14 12:00	2026-09-14 12:00	2026-09-14 12:00	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6000	1.6000	1.7000	27.8000	10908.00	0.00	10908.00	68	7	5843	17971	0.325134939624951	0.472365102052037	0.472365102052037	false	false	false	true
8622a308-fc14-4623-94e1-e38854363bb7	2026-09-14 12:06	2026-09-14 12:06	2026-09-14 12:06	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6000	1.6000	1.6500	27.7750	10560.00	0.00	10560.00	66	17	6171	17971	0.343386567247232	0.470585325009277	0.470585325009277	false	false	false	true
429f1e9e-e653-483d-a6cf-bdb6bcca3080	2026-09-14 12:08	2026-09-14 12:08	2026-09-14 12:08	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6000	1.5500	1.6500	27.7900	10258.00	2898.00	0.00	64	5	6235	17971	0.346947860441823	0.470794177134931	0.466480300340563	false	false	false	true
8cc75f43-d3b3-40a8-9391-e26ec5ee1373	2026-09-14 12:20	2026-09-14 12:19	2026-09-14 12:19	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6200	1.6000	1.7000	27.8200	10825.00	0.00	10825.00	67	9	6717	17971	0.373768849813589	0.466851052052614	0.466851052052614	false	false	false	true
e8a2d966-f2da-436c-a8de-944c89e51d66	2026-09-14 12:21	2026-09-14 12:21	2026-09-14 12:21	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6200	1.6000	1.7000	27.8450	10072.00	0.00	10072.00	62	9	6779	17971	0.377218852595849	0.464231299088627	0.459890710999125	false	false	false	true
bee181b4-59ca-4b04-bd56-1d515e3a230c	2026-09-14 12:31	2026-09-14 12:30	2026-09-14 12:30	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6300	1.6000	1.7000	27.8450	12560.00	0.00	12560.00	77	5	7201	17971	0.400701129597685	0.468567919800479	0.468567919800479	false	false	false	true
84f37688-ddd3-4a1c-a1d1-63d62bb9222b	2026-09-14 12:33	2026-09-14 12:33	2026-09-14 12:33	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6500	1.6500	1.7000	27.8650	10560.00	0.00	10560.00	64	19	7340	17971	0.408435813254688	0.467315854160921	0.467315854160921	false	false	false	true
d3b3d191-ec55-4a66-b745-060e7470490f	2026-09-14 12:35	2026-09-14 12:35	2026-09-14 12:35	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6300	1.6000	1.7000	27.8497	10603.00	0.00	10603.00	65	5	7407	17971	0.412164042067776	0.467256880235009	0.467256880235009	false	false	false	true
54c20708-78f4-4729-9c5e-b5174c25466a	2026-09-14 12:37	2026-09-14 12:37	2026-09-14 12:37	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6200	1.6000	1.7000	27.8450	10558.00	0.00	10558.00	65	7	7472	17971	0.415780980468533	0.464231299088627	0.464231299088627	false	false	false	true
2de29829-6747-4697-a449-056248df98bd	2026-09-14 12:38	2026-09-14 12:38	2026-09-14 12:38	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6200	1.6000	1.7000	27.8450	10558.00	0.00	10558.00	65	8	7537	17971	0.419397918869289	0.468567919800479	0.468567919800479	false	false	false	true
0a6ad91b-b100-482b-baf2-c81cae1d75ef	2026-09-14 12:43	2026-09-14 12:43	2026-09-14 12:43	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6200	1.6000	1.7000	27.8400	11673.00	0.00	11673.00	72	6	7749	17971	0.431194702576373	0.465626272053524	0.465626272053524	false	false	false	true
34259416-d04f-46bb-94c2-505d9ffe757a	2026-09-14 12:44	2026-09-14 12:44	2026-09-14 12:44	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6100	1.6000	1.7000	27.8200	10626.00	0.00	10626.00	66	5	7815	17971	0.434867286183295	0.462522714486619	0.462522714486619	false	false	false	true
d12e1704-940e-4548-b848-66fa8639dfda	2026-09-14 12:46	2026-09-14 12:46	2026-09-14 12:46	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6100	1.6000	1.7000	27.8200	10638.00	0.00	10638.00	66	6	7881	17971	0.438539869790218	0.466851052052614	0.466851052052614	false	false	false	true
4df9cd83-b918-400d-a3d3-b70576e6b962	2026-09-14 12:51	2026-09-14 12:51	2026-09-14 12:51	AS	AS261002C00027000	call	27.0000	2026-10-02	1.7100	1.7000	1.8000	27.9700	13509.00	0.00	13509.00	79	5	8110	17971	0.451282622002114	0.463581724198646	0.463581724198646	false	false	false	true
2439a030-10a6-4b66-8333-c9d6ab95fc9b	2026-09-14 12:54	2026-09-14 12:54	2026-09-14 12:54	AS	AS261002C00027000	call	27.0000	2026-10-02	1.7000	1.7000	1.8000	27.9600	11397.00	0.00	11397.00	67	11	8249	17971	0.459017305659117	0.466474593943179	0.466474593943179	false	false	false	true
2d085b4d-8e2f-49f8-8711-cb884ec9593a	2026-09-14 12:55	2026-09-14 12:55	2026-09-14 12:55	AS	AS261002C00027000	call	27.0000	2026-10-02	1.7000	1.7000	1.7500	27.9650	12077.00	0.00	12077.00	71	8	8320	17971	0.462968115296867	0.465029906031808	0.460637514638781	false	false	false	true
2680cd78-81e6-447b-904f-97c68ae81442	2026-09-14 12:56	2026-09-14 12:56	2026-09-14 12:56	AS	AS261002C00027000	call	27.0000	2026-10-02	1.7000	1.7000	1.7500	27.9450	11390.00	0.00	11390.00	67	24	8387	17971	0.466696344109955	0.466411540621628	0.466411540621628	false	false	false	true
b4ba178c-b90e-4c1e-9e63-31dc74f399e9	2026-09-14 13:00	2026-09-14 13:00	2026-09-14 13:00	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6600	1.6500	1.7500	27.9150	12304.00	0.00	12304.00	74	8	8539	17971	0.475154415447109	0.461880306667823	0.461880306667823	false	false	false	true
34617635-5112-491e-88b1-2e332f22d49b	2026-09-14 13:01	2026-09-14 13:01	2026-09-14 13:01	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6500	1.6500	1.7500	27.8950	11723.00	0.00	11723.00	71	10	8610	17971	0.479105225084859	0.463206596993756	0.463206596993756	false	false	false	true
4ce70715-06fc-4edd-ab8f-bd8094617331	2026-09-14 13:03	2026-09-14 13:03	2026-09-14 13:03	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6100	1.6000	1.7000	27.8400	13049.00	0.00	13049.00	81	6	8691	17971	0.483612486784264	0.461288981655838	0.461288981655838	false	false	false	true
91786d17-1303-47b0-9b6f-a89053ce2aad	2026-09-14 13:14	2026-09-14 13:13	2026-09-14 13:13	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6200	1.6000	1.7000	27.8350	11664.00	0.00	11664.00	72	6	9196	17971	0.511713315897835	0.462684116755747	0.462684116755747	false	false	false	true
dd6f5b1e-849e-44a3-9846-07ab69055cd7	2026-09-14 13:17	2026-09-14 13:17	2026-09-14 13:17	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6200	1.6000	1.7000	27.8350	10988.00	0.00	10988.00	68	7	9343	17971	0.519893161204162	0.462684116755747	0.462684116755747	false	false	false	true
1ba4f757-aed2-47b6-ad69-c795328afdc8	2026-09-14 13:22	2026-09-14 13:22	2026-09-14 13:22	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5800	1.5500	1.6500	27.7900	11399.00	0.00	11399.00	72	5	9566	17971	0.532302042179066	0.457842239384635	0.457842239384635	false	false	false	true
9bee816f-2763-4a7c-b2c2-36bd8247929b	2026-09-14 13:25	2026-09-14 13:25	2026-09-14 13:25	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5700	1.5500	1.6500	27.7750	11950.00	0.00	11950.00	76	5	9718	17971	0.540760113516221	0.461964741988068	0.457649436676642	false	false	false	true
b53e476d-a1d4-4c30-b6db-2dcec2a70676	2026-09-14 13:30	2026-09-14 13:30	2026-09-14 13:30	AS	AS261002C00027000	call	27.0000	2026-10-02	1.6000	1.6000	1.6500	27.8001	11040.00	0.00	11040.00	69	11	9937	17971	0.552946413666463	0.463701508548468	0.463701508548468	false	false	false	true
c307e86f-6c5f-4d48-84f7-9a8544e38a4f	2026-09-14 13:32	2026-09-14 13:32	2026-09-14 13:32	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5600	1.5500	1.6000	27.7450	12792.00	0.00	12792.00	82	5	10019	17971	0.557509320572033	0.461531317274191	0.461531317274191	false	false	false	true
6f1ec68b-cdfd-4392-9bdc-847b1ed9a093	2026-09-14 13:35	2026-09-14 13:35	2026-09-14 13:35	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5200	1.5000	1.6000	27.6950	10488.00	0.00	10488.00	69	7	10166	17971	0.56568916587836	0.457841236973357	0.457841236973357	false	false	false	true
e8bb18ab-f5a9-401c-b1b0-1ecb4a4d45fb	2026-09-14 13:37	2026-09-14 13:36	2026-09-14 13:36	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5200	1.5000	1.6000	27.7050	10813.00	0.00	10813.00	71	5	10237	17971	0.569639975516109	0.459446811070111	0.459446811070111	false	false	false	true
bf26fff0-19e4-42d5-a2f6-737e924595aa	2026-09-14 13:44	2026-09-14 13:44	2026-09-14 13:44	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5500	1.5500	1.6000	27.7250	12400.00	0.00	12400.00	80	9	10614	17971	0.590618218240499	0.462647037064861	0.462647037064861	false	false	false	true
49d80103-2beb-4e49-bef5-36ad224848d4	2026-09-14 13:49	2026-09-14 13:48	2026-09-14 13:48	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5600	1.5500	1.6500	27.7450	10764.00	0.00	10764.00	69	6	10753	17971	0.598352901897502	0.461531317274191	0.461531317274191	false	false	false	true
1b501993-edd4-4727-9d0c-3802c720c412	2026-09-14 13:51	2026-09-14 13:51	2026-09-14 13:51	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5200	1.5000	1.6000	27.7000	10512.00	0.00	10512.00	69	7	10903	17971	0.606699682822325	0.465075963917734	0.465075963917734	false	false	false	true
d14bd006-731f-4f88-b73e-7851ee02eee7	2026-09-14 13:52	2026-09-14 13:52	2026-09-14 13:52	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5500	1.5500	1.6000	27.7000	12710.00	0.00	12710.00	82	9	10985	17971	0.611262589727895	0.469360242735043	0.469360242735043	false	false	false	true
b08913cd-f986-4452-a7c0-4123681cc062	2026-09-14 13:57	2026-09-14 13:57	2026-09-14 13:57	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5500	1.5500	1.6000	27.7150	10540.00	0.00	10540.00	68	7	11207	17971	0.623615825496633	0.465340457750861	0.465340457750861	false	false	false	true
e1e1f363-636c-4cba-b775-1abeb0e04a00	2026-09-14 13:58	2026-09-14 13:58	2026-09-14 13:58	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5500	1.5500	1.6000	27.7150	11005.00	0.00	11005.00	71	6	11278	17971	0.627566635134383	0.465340457750861	0.465340457750861	false	false	false	true
39f28921-6571-48db-8c20-a3976714020e	2026-09-14 14:00	2026-09-14 13:59	2026-09-14 13:59	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5500	1.5500	1.6000	27.7050	10540.00	0.00	10540.00	68	8	11346	17971	0.631350509153636	0.468022989928447	0.468022989928447	false	false	false	true