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:alert_rule = RepeatedHitsDescendingFill×ticker = SHOP×

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

5f15c617-f8f6-418e-8248-e673f0ff8e65	2026-09-22 14:58	2026-09-22 14:58	2026-09-22 14:58	SHOP	SHOP270917C00210000	call	210.0000	2027-09-17	17.9400	17.8000	17.9500	147.6750	32300.00	28720.00	3580.00	18	5	37	153	0.241830065359477	0.575930793397922	0.575048320632289	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Technology	178554183066.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:02:38.336545Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
117d3efc-2b86-422a-8868-3c81638a6aac	2026-09-22 11:17	2026-09-22 11:17	2026-09-22 11:17	SHOP	SHOP260925C00143000	call	143.0000	2026-09-25	6.3900	6.3000	6.4000	147.5600	74760.00	67200.00	7560.00	117	7	747	1625	0.459692307692308	0.652784249110493	0.67183076696767	true	false	false	true
da4d9d1a-180d-4157-9954-ad20a83e41dc	2026-09-22 11:09	2026-09-22 11:09	2026-09-22 11:09	SHOP	SHOP270617C00180000	call	180.0000	2027-06-17	20.4400	19.1000	20.4500	148.0000	79715.00	75645.00	2035.00	39	7	99	257	0.385214007782101	0.580290536052606	0.580290536052606	false	false	false	true
94c76e18-3c6c-4690-a514-3028ab30c7af	2026-09-22 10:09	2026-09-22 10:08	2026-09-22 10:08	SHOP	SHOP270115P00140000	put	140.0000	2027-01-15	13.3900	13.1500	13.6000	149.2300	180751.00	91306.00	89445.00	135	9	143	1126	0.126998223801066	0.575561189933535	0.576858196406415	false	false	false	true
d1ecb3f4-401e-4b31-838f-d2d21965774f	2026-09-22 10:06	2026-09-22 10:05	2026-09-22 10:05	SHOP	SHOP270115C00200000	call	200.0000	2027-01-15	5.7500	5.0500	5.7500	149.0300	100035.00	99470.00	565.00	174	6	687	2683	0.256056653000373	0.572601416436896	0.572050043740669	true	false	false	true
4a33b5aa-fde1-4247-b826-38eb88abe388	2026-09-22 09:57	2026-09-22 09:57	2026-09-22 09:57	SHOP	SHOP261023C00148000	call	148.0000	2026-10-23	9.9600	9.4000	10.4500	148.5550	23905.00	12025.00	11880.00	24	6	34	4	8.5	0.550037137108288	0.54420183650909	false	false	false	true
96b8a8c5-132f-4cc0-8717-340b60e8cb5b	2026-09-22 09:55	2026-09-22 09:55	2026-09-22 09:55	SHOP	SHOP260925C00160000	call	160.0000	2026-09-25	1.1600	1.1500	1.2500	149.6150	27719.00	4443.00	23276.00	239	45	6507	645	10.0883720930233	0.825869238291486	0.825869238291486	false	false	false	true
79d13bc0-6a88-4537-9d34-5a96b58af2eb	2026-09-22 09:52	2026-09-22 09:52	2026-09-22 09:52	SHOP	SHOP260925C00160000	call	160.0000	2026-09-25	1.1200	1.1000	1.1600	149.0000	10440.00	1150.00	9290.00	93	21	4010	645	6.21705426356589	0.828909774768719	0.835968641637408	false	false	false	true
4d845432-c353-4557-a396-4a44091a5d74	2026-09-22 09:52	2026-09-22 09:52	2026-09-22 09:52	SHOP	SHOP260925C00160000	call	160.0000	2026-09-25	1.1100	1.1000	1.1600	149.2000	12804.00	226.00	12578.00	115	16	3508	645	5.43875968992248	0.832910554513606	0.833943428747009	false	false	false	true
cde84ef5-2f8e-4cb0-a7ca-7b07260eda5b	2026-09-22 09:51	2026-09-22 09:51	2026-09-22 09:51	SHOP	SHOP261016C00155000	call	155.0000	2026-10-16	5.9400	5.7000	6.4000	148.6000	148440.00	0.00	148440.00	250	8	411	4108	0.100048685491723	0.555608037614108	0.555608037614108	false	false	false	true
6d953213-0755-454d-9266-1278e050d16c	2026-09-22 09:46	2026-09-22 09:45	2026-09-22 09:45	SHOP	SHOP261002C00150000	call	150.0000	2026-10-02	4.9100	4.7000	5.3500	147.0000	21098.00	0.00	21098.00	43	6	391	975	0.401025641025641	0.607843877151972	0.607843877151972	false	false	false	true
8cd59ea4-b14a-45cf-9d95-61bfd39cf663	2026-09-22 09:44	2026-09-22 09:44	2026-09-22 09:44	SHOP	SHOP260925C00152500	call	152.5000	2026-09-25	2.6000	2.5800	2.7500	148.0000	25438.00	12745.00	12693.00	98	6	4898	176	27.8295454545455	0.77193800837025	0.773651129481392	true	false	false	true
2420dbcd-e4c2-4d14-9415-78e8ddf44e10	2026-09-22 09:37	2026-09-22 09:37	2026-09-22 09:37	SHOP	SHOP260925C00155000	call	155.0000	2026-09-25	2.1500	1.9600	2.2600	148.7800	86423.00	44933.00	41490.00	402	6	1037	572	1.81293706293706	0.813173470916718	0.831817497314299	false	false	false	true
e1e33dbd-348d-46f9-a445-acf76e91231c	2026-09-22 09:36	2026-09-22 09:36	2026-09-22 09:36	SHOP	SHOP261120C00200000	call	200.0000	2026-11-20	3.0900	2.0500	3.4500	149.1500	37660.00	19060.00	18600.00	122	6	122	713	0.171107994389902	0.652592758227259	0.647547595519937	false	false	false	true
4527bb7e-d1af-4c90-922b-0e009aaa382a	2026-09-22 09:34	2026-09-22 09:34	2026-09-22 09:34	SHOP	SHOP260925C00145000	call	145.0000	2026-09-25	5.6000	5.5000	6.0000	147.7900	28580.00	560.00	27440.00	51	19	372	983	0.378433367243133	0.797305197597555	0.760140689424819	false	false	false	true
39e46036-a01d-4599-80df-0665de9b0a26	2026-09-22 09:34	2026-09-22 09:34	2026-09-22 09:34	SHOP	SHOP260925C00130000	call	130.0000	2026-09-25	17.6000	17.1500	18.2500	147.6400	140765.00	137255.00	3510.00	80	33	1055	1830	0.576502732240437	0.734521330998507	0.409033623894323	true	false	false	true
e4a35baa-b889-48f9-9a2c-0a93d4039269	2026-09-22 09:33	2026-09-22 09:33	2026-09-22 09:33	SHOP	SHOP260925C00130000	call	130.0000	2026-09-25	18.8900	18.4500	18.9000	148.5500	152985.00	152985.00	0.00	81	19	635	1830	0.346994535519126	0.896883681104261	0.913097139765477	true	false	false	true
c472f49d-a5f3-42b1-939c-98b5601defa0	2026-09-22 09:33	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP261023C00175000	call	175.0000	2026-10-23	2.3000	1.4300	2.8800	148.6500	28538.00	14750.00	13788.00	124	6	124	3	41.3333333333333	0.572001997711992	0.558690388337788	false	false	false	true
85ebc624-7e06-4d0b-820e-64ee719743d9	2026-09-22 09:33	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP261023C00180000	call	180.0000	2026-10-23	1.7600	0.9900	2.1000	148.6500	36972.00	19310.00	17662.00	210	5	210	6	35	0.57458186357401	0.574389813908436	false	false	false	true
77190051-a9b8-44c5-8135-1fe43edee594	2026-09-22 09:33	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP261023C00185000	call	185.0000	2026-10-23	1.2800	0.6600	1.6300	148.6549	36230.00	24212.00	12018.00	284	5	285	11	25.9090909090909	0.579554234747559	0.573564076802123	false	false	false	true
1231ca72-eed3-4cb9-8dd2-c5e73170ed35	2026-09-22 09:33	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP261023C00162500	call	162.5000	2026-10-23	4.7800	3.1500	5.1500	148.6450	61160.00	31830.00	29330.00	128	10	128	0	0	0.559389700969923	0.556194658534475	true	false	false	true
4427db7d-a1df-43fa-ab4d-44a73fee090d	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP261002C00148000	call	148.0000	2026-10-02	7.1700	5.0000	7.2500	148.0750	14340.00	14340.00	0.00	20	6	40	83	0.481927710843373	0.730388620753242	0.648364747861209	false	false	false	true
4ce996da-1b63-45ab-a304-8d086fbaa293	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP260925C00130000	call	130.0000	2026-09-25	18.2100	17.8000	18.2500	147.9800	156570.00	156570.00	0.00	86	20	238	1830	0.130054644808743	0.898297482640711	0.828818311943428	false	false	false	true
d2c2805f-0183-4630-87b0-c070db416a8f	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SHOP	SHOP260925C00143000	call	143.0000	2026-09-25	6.5400	5.6500	6.6500	146.7350	18300.00	9170.00	9130.00	28	7	317	1625	0.195076923076923	0.849933580493734	0.840779921895316	true	false	false	true
fb09a80a-08d2-491b-ac7b-61e7d18fa315	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	SHOP	SHOP260925C00147000	call	147.0000	2026-09-25	3.9100	2.5100	4.4500	146.4000	15625.00	13675.00	1950.00	40	8	40	111	0.36036036036036	0.795715658836491	0.786271466672934	false	false	false	true
d8a0973a-d5ed-49b1-9c9c-f3521962aa44	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	SHOP	SHOP260925C00149000	call	149.0000	2026-09-25	3.0900	1.8700	3.4000	146.5450	21915.00	11210.00	10705.00	71	6	88	114	0.771929824561403	0.816025644830962	0.784995050179592	true	false	false	true
33c6b225-3782-4d75-bb2b-4641c12628cf	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	SHOP	SHOP260925C00146000	call	146.0000	2026-09-25	4.0300	2.7800	5.1500	146.0500	26575.00	17055.00	9110.00	66	24	83	358	0.231843575418994	0.806031922859166	0.767317537665161	true	false	false	true
ace99e02-c9b4-4a19-941a-8e33d40ffd15	2026-09-21 15:47	2026-09-21 15:47	2026-09-21 15:47	SHOP	SHOP260925C00142000	call	142.0000	2026-09-25	1.7200	1.5500	1.7300	137.0000	20120.00	19780.00	169.00	117	25	983	48	20.4791666666667	0.618867107135039	0.612032172419792	true	false	false	true
91ee85da-ba7b-4a14-a97d-85c45a4c4ed0	2026-09-21 15:22	2026-09-21 15:22	2026-09-21 15:22	SHOP	SHOP280121C00155000	call	155.0000	2028-01-21	33.4000	33.3500	34.2500	137.7299	93516.00	0.00	93516.00	28	16	33	159	0.207547169811321	0.579973792859733	0.579323027149823	false	false	false	true
c6f15fc0-81d4-41b5-8dbd-c3c28bfbd8c7	2026-09-21 14:47	2026-09-21 14:46	2026-09-21 14:46	SHOP	SHOP261016C00145000	call	145.0000	2026-10-16	3.7700	3.5500	3.8000	134.0000	28250.00	28250.00	0.00	75	7	8072	1591	5.073538654934	0.531541585349515	0.527629403998013	false	false	false	true
d353632e-4f22-45ed-ad75-1a6ea40de3d1	2026-09-21 14:21	2026-09-21 14:21	2026-09-21 14:21	SHOP	SHOP270115P00095000	put	95.0000	2027-01-15	2.5100	2.1100	2.4900	135.1300	13034.00	12789.00	245.00	52	18	251	2917	0.0860473088789853	0.591028259201971	0.582910085716749	true	false	false	true
3233dc01-d136-4835-827a-6aa12c277e8e	2026-09-21 14:12	2026-09-21 14:11	2026-09-21 14:11	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	3.0000	2.8500	3.0000	135.6300	77679.00	72900.00	4779.00	259	24	8787	2633	3.3372578807444	0.549394651578316	0.547288328690499	false	false	false	true
0c3befb4-060c-4baf-bac6-d2c1cb939393	2026-09-21 14:09	2026-09-21 14:09	2026-09-21 14:09	SHOP	SHOP261218C00145000	call	145.0000	2026-12-18	11.4100	11.2000	11.5500	134.0000	34240.00	17175.00	17065.00	30	14	43555	340	128.102941176471	0.581282886656586	0.579369764614249	true	false	false	true
8691d6d2-737c-4c18-b11c-8479c53d5c06	2026-09-21 14:07	2026-09-21 14:07	2026-09-21 14:07	SHOP	SHOP261218C00145000	call	145.0000	2026-12-18	11.6000	11.0500	11.6000	134.0000	59150.00	57995.00	1155.00	51	17	43521	340	128.002941176471	0.582062366681251	0.57953504620132	false	false	false	true
b69056e6-959b-426d-ac68-e573d285716b	2026-09-21 14:01	2026-09-21 14:01	2026-09-21 14:01	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	7.1600	6.9500	7.4500	134.0000	10025.00	1440.00	8585.00	14	7	47593	46336	1.02712793508287	0.524579753896586	0.521009623732846	true	false	false	true
3de224f4-65b9-4c90-9775-db450f22adcc	2026-09-21 13:58	2026-09-21 13:58	2026-09-21 13:58	SHOP	SHOP260925C00140000	call	140.0000	2026-09-25	1.8900	1.8600	1.9900	135.0300	12124.00	0.00	12124.00	64	12	5486	1924	2.85135135135135	0.679130325261229	0.672099925977184	false	false	false	true
b746a5b9-19c4-4b21-9df3-5d82638d501d	2026-09-21 13:54	2026-09-21 13:54	2026-09-21 13:54	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	7.0600	7.0000	7.2000	133.8050	49422.00	0.00	49422.00	70	5	47374	46336	1.02240158839779	0.533983775680655	0.533983775680655	false	false	false	true
a776dd5c-4e69-4e3b-8cde-ec9f7592b38c	2026-09-21 13:52	2026-09-21 13:52	2026-09-21 13:52	SHOP	SHOP261002C00135000	call	135.0000	2026-10-02	5.3300	5.3000	6.2000	134.4801	45850.00	9810.00	36040.00	86	20	303	174	1.74137931034483	0.603687195932421	0.587576303002802	true	false	false	true
bcc7f49b-997f-43dd-823b-7275da9ef018	2026-09-21 13:52	2026-09-21 13:52	2026-09-21 13:52	SHOP	SHOP260925C00143000	call	143.0000	2026-09-25	1.3800	1.3500	1.4900	134.5400	19361.00	18138.00	1223.00	140	9	1502	298	5.04026845637584	0.755574171939793	0.753255816983537	true	false	false	true
bf1912d7-cfb9-4378-8ad6-e839860ee9d7	2026-09-21 13:51	2026-09-21 13:50	2026-09-21 13:50	SHOP	SHOP261016C00155000	call	155.0000	2026-10-16	2.1500	1.9400	2.1500	135.0900	39911.00	24221.00	210.00	186	7	2064	6329	0.326117870121662	0.570212799384969	0.570212799384969	true	false	false	true
6d9bcb39-3da5-43d2-9d14-f40e0417ec8b	2026-09-21 13:49	2026-09-21 13:49	2026-09-21 13:49	SHOP	SHOP260925C00140000	call	140.0000	2026-09-25	2.3300	2.1600	2.5000	134.9500	12586.00	936.00	0.00	54	5	4437	1924	2.30613305613306	0.765258882091463	0.765258882091463	false	false	false	true
b7452b3c-e1d5-4fd2-be5f-22ab1ba74a9e	2026-09-21 13:48	2026-09-21 13:48	2026-09-21 13:48	SHOP	SHOP260925C00139000	call	139.0000	2026-09-25	2.6600	2.3800	2.7300	135.0200	25816.00	17547.00	8269.00	97	12	642	66	9.72727272727273	0.755366538103737	0.760967795936319	true	false	false	true
a2401c04-80a0-4ee3-8453-5e6c5d3cd1cc	2026-09-21 13:48	2026-09-21 13:48	2026-09-21 13:48	SHOP	SHOP260925C00140000	call	140.0000	2026-09-25	2.3600	2.2000	2.4100	135.0200	102303.00	80632.00	21671.00	434	50	4245	1924	2.20634095634096	0.770289572940675	0.756799707214257	true	false	false	true
e12efaad-a979-4388-b39f-8e085647fb0d	2026-09-21 13:46	2026-09-21 13:46	2026-09-21 13:46	SHOP	SHOP261120P00130000	put	130.0000	2026-11-20	10.7300	9.9000	10.8000	133.9700	12870.00	6450.00	6420.00	12	6	63	1132	0.0556537102473498	0.613492575949972	0.611568243366538	true	false	false	true
7e514994-5ee9-4c97-a81b-4fd23760c28e	2026-09-21 13:46	2026-09-21 13:46	2026-09-21 13:46	SHOP	SHOP261120P00130000	put	130.0000	2026-11-20	10.7300	9.8000	11.1500	133.9200	10730.00	7520.00	3210.00	10	6	51	1132	0.0450530035335689	0.61541645936157	0.61062736724656	false	false	false	true
a094d8a0-0a64-4f63-b344-4cba0c798500	2026-09-21 13:46	2026-09-21 13:46	2026-09-21 13:46	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	7.3200	7.2000	7.5000	134.0000	79021.00	8886.00	70135.00	108	26	46770	46336	1.00936636740331	0.533890521547874	0.529610579226662	true	false	false	true
6700f0a9-9831-4c6b-bc93-a812919a4f3c	2026-09-21 13:45	2026-09-21 13:45	2026-09-21 13:45	SHOP	SHOP261016C00145000	call	145.0000	2026-10-16	4.3700	3.7000	4.4500	134.0000	220835.00	163085.00	57750.00	505	18	7226	1591	4.54179761156505	0.578477459547524	0.576445206734896	true	false	false	true
306fed5f-69f4-4506-9add-8be1b05d33d2	2026-09-21 13:45	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP261016C00145000	call	145.0000	2026-10-16	4.3600	3.8000	4.4500	135.0000	353635.00	96575.00	257060.00	811	13	5706	1591	3.58642363293526	0.576321832964485	0.570887251290967	false	false	false	true
fcb3c13a-c2c4-4ab9-91de-2370d8b308f0	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP261002C00141000	call	141.0000	2026-10-02	2.9900	1.8700	3.0500	134.0000	51690.00	26615.00	25075.00	173	10	208	15	13.8666666666667	0.590361550113928	0.592197459276061	true	false	false	true
a74fd9fe-ddf6-4a52-8e08-90a611105dac	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.6300	2.1800	3.0000	134.0000	249624.00	110784.00	138840.00	950	22	4383	2633	1.66464109380934	0.548996129480697	0.548996129480697	true	false	false	true