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

460d8d27-36d9-4ee7-a6da-67fbdcb00b4c	2026-08-18 15:30	2026-08-18 15:30	2026-08-18 15:30	BLSH	BLSH280121C00030000	call	30.0000	2028-01-21	7.7000	7.7000	8.0000	24.8900	40810.00	0.00	40810.00	53	6	153	171	0.894736842105263	0.75947838003768	0.75947838003768	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	5674371920.00	2026-11-18	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
5c444f5a-dbb4-4f52-a369-ab49cec381a1	2026-08-19 10:37	2026-08-19 10:36	2026-08-19 10:36	BLSH	BLSH261218C00030000	call	30.0000	2026-12-18	3.6000	3.2000	3.8000	27.1300	12950.00	10435.00	2515.00	36	10	59	336	0.175595238095238	0.73283074796515	0.73283074796515	false	false	false	true	false
e093e597-0056-4684-9eb2-b14481fe7b1a	2026-08-19 12:33	2026-08-19 12:33	2026-08-19 12:33	BLSH	BLSH260918C00030000	call	30.0000	2026-09-18	1.5200	1.3500	1.5400	28.0800	15222.00	1694.00	0.00	100	8	414	1170	0.353846153846154	0.707373179085302	0.707373179085302	false	false	false	true	false
c032bb13-b1d4-4eae-8d73-56ea292cf726	2026-08-19 12:34	2026-08-19 12:34	2026-08-19 12:34	BLSH	BLSH260918C00030000	call	30.0000	2026-09-18	1.5000	1.3700	1.5500	28.1400	15118.00	12300.00	2818.00	101	5	615	1170	0.525641025641026	0.689347489249335	0.686702205334601	true	false	false	true	false
eca70524-8157-4837-966e-3723c552dfb5	2026-08-19 14:15	2026-08-19 14:14	2026-08-19 14:14	BLSH	BLSH260918C00030000	call	30.0000	2026-09-18	1.2000	0.9700	1.3100	27.3700	19018.00	16858.00	2160.00	159	6	1373	1170	1.17350427350427	0.686655413377154	0.686655413377154	true	false	false	true	false
e3b3cd43-067f-4bc4-b515-624568dcc822	2026-08-19 15:14	2026-08-19 15:14	2026-08-19 15:14	BLSH	BLSH260821C00023500	call	23.5000	2026-08-21	3.6500	3.6500	4.9500	27.3600	392010.00	0.00	392010.00	1074	25	1076	160	6.725	3.43590628014531	0	false	false	false	true	false
e24654dc-9ea4-4ee1-bf9b-bbe9af5989be	2026-08-20 09:31	2026-08-20 09:31	2026-08-20 09:31	BLSH	BLSH260918C00030000	call	30.0000	2026-09-18	1.8500	1.8500	2.0000	28.7800	17760.00	0.00	17760.00	96	5	215	2399	0.0896206752813672	0.720262402065255	0.720262402065255	false	false	false	true	false
ab1732b0-6559-4f27-be3e-160fcbc657a7	2026-08-20 11:04	2026-08-20 11:04	2026-08-20 11:04	BLSH	BLSH260828C00034000	call	34.0000	2026-08-28	0.1300	0.0100	0.1300	28.1650	10010.00	10010.00	0.00	770	35	778	22	35.3636363636364	0.87162440455214	0.87162440455214	false	false	false	true	false
23cecbbb-354d-45c3-8901-8c6fa9af748d	2026-08-20 12:10	2026-08-20 12:10	2026-08-20 12:10	BLSH	BLSH260918P00030000	put	30.0000	2026-09-18	3.2500	2.9300	3.4000	28.2527	83525.00	51025.00	32500.00	257	10	257	884	0.290723981900453	0.71324178212741	0.71324178212741	false	false	false	true	false
e78bebc2-3bd0-44f8-8451-16c6cf3e87a7	2026-08-21 11:49	2026-08-21 11:49	2026-08-21 11:49	BLSH	BLSH260918C00030000	call	30.0000	2026-09-18	2.5000	2.3500	2.6000	30.4500	50000.00	48000.00	2000.00	200	8	835	2571	0.324776351614158	0.666954546579792	0.666954546579792	false	false	false	true	false
00cdce91-0d06-48b3-87bc-4571c4ec85d7	2026-08-21 12:01	2026-08-21 12:01	2026-08-21 12:01	BLSH	BLSH260918C00030000	call	30.0000	2026-09-18	2.5000	2.4800	2.6000	30.4000	25022.00	0.00	25022.00	100	11	1245	2571	0.484247374562427	0.675624507446787	0.675624507446787	false	false	false	true	false
76fca252-2b85-4bc8-8623-1eb684eab458	2026-08-21 12:29	2026-08-21 12:29	2026-08-21 12:29	BLSH	BLSH261218C00030000	call	30.0000	2026-12-18	5.3500	5.2000	5.3500	30.3200	14980.00	14980.00	0.00	28	13	42	438	0.0958904109589041	0.736871215237058	0.736871215237058	false	false	false	true	false
1d6c81b8-d6f4-4492-b091-1ce395313688	2026-08-21 14:29	2026-08-21 14:29	2026-08-21 14:29	BLSH	BLSH261218P00030000	put	30.0000	2026-12-18	4.7000	4.5000	4.7000	30.3850	42770.00	42770.00	0.00	91	29	99	236	0.419491525423729	0.747775229440713	0.747775229440713	false	false	false	true	false
9119bc21-bec9-4781-bef1-0c5291881b20	2026-08-21 15:36	2026-08-21 15:36	2026-08-21 15:36	BLSH	BLSH260828C00030000	call	30.0000	2026-08-28	1.3000	1.1400	1.3000	30.2050	19110.00	19110.00	0.00	147	11	258	955	0.270157068062827	0.711945101746124	0.711945101746124	false	false	false	true	false
6eb4baab-5c5c-4e52-ae42-e549cdf95712	2026-08-24 09:54	2026-08-24 09:54	2026-08-24 09:54	BLSH	BLSH261016P00030000	put	30.0000	2026-10-16	3.1500	2.8000	3.1500	30.3800	791575.00	791575.00	0.00	2513	50	2513	64	39.265625	0.748819251362926	0.748819251362926	false	false	false	true	false
2d01130b-43b8-4f6d-9f4d-aeb4d67710fc	2026-08-24 13:21	2026-08-24 13:21	2026-08-24 13:21	BLSH	BLSH261218P00025000	put	25.0000	2026-12-18	2.3300	2.2000	2.3300	30.5100	215504.00	210632.00	4872.00	925	57	945	205	4.60975609756098	0.767866757123756	0.761616765714092	false	false	false	true	false
07662f61-8e48-40bb-9bb1-58e91c380618	2026-08-24 15:39	2026-08-24 15:39	2026-08-24 15:39	BLSH	BLSH261218C00030000	call	30.0000	2026-12-18	5.5000	5.2500	5.5000	30.4700	110000.00	110000.00	0.00	200	22	238	403	0.590570719602978	0.7557874389123	0.7557874389123	false	false	false	true	false
44820abe-12e1-49f5-835c-711507f8182a	2026-08-25 12:47	2026-08-25 12:47	2026-08-25 12:47	BLSH	BLSH260918C00030000	call	30.0000	2026-09-18	3.4500	3.4500	3.5000	32.1000	28290.00	0.00	28290.00	82	9	120	2055	0.0583941605839416	0.692523617282437	0.692523617282437	false	false	false	true	false
1de0faae-04c3-4de2-a941-baef967f02e5	2026-08-25 14:15	2026-08-25 14:15	2026-08-25 14:15	BLSH	BLSH260911P00029000	put	29.0000	2026-09-11	0.7100	0.7100	0.8200	32.0000	10295.00	0.00	10295.00	145	15	145	16	9.0625	0.743740950700456	0.743740950700456	false	false	false	true	false
615816ff-bc15-4112-a659-a32df5e76949	2026-08-26 14:24	2026-08-26 14:24	2026-08-26 14:24	BLSH	BLSH261016C00040000	call	40.0000	2026-10-16	1.4000	1.3400	1.5000	32.7100	47460.00	39900.00	7560.00	339	10	599	113	5.30088495575221	0.743091757099742	0.740347316302021	false	false	false	true	false
52002d32-788d-43ea-84b8-1cdba814c08f	2026-08-26 14:55	2026-08-26 14:55	2026-08-26 14:55	BLSH	BLSH261016C00040000	call	40.0000	2026-10-16	1.4700	1.2500	1.5000	32.9600	14700.00	7500.00	7200.00	100	5	1001	113	8.85840707964602	0.734784722507463	0.746860975140707	false	false	false	true	false
9bb1046e-c3aa-46c7-9e61-6012ee11a02f	2026-08-27 11:06	2026-08-27 11:06	2026-08-27 11:06	BLSH	BLSH260828C00032000	call	32.0000	2026-08-28	2.0000	1.8100	2.2700	33.8900	27467.00	13400.00	14067.00	137	73	141	356	0.396067415730337	0.919652608811856	0.967509783274642	true	false	false	true	false
c994d44c-f07d-47f2-9f8a-e200114f9eed	2026-08-27 11:08	2026-08-27 11:08	2026-08-27 11:08	BLSH	BLSH260828C00032000	call	32.0000	2026-08-28	2.0000	1.8000	2.1800	33.9000	18400.00	5200.00	13200.00	92	37	254	356	0.713483146067416	0.942609329830857	0.942609329830857	true	false	false	true	false
db31bc74-e202-445b-b4f7-e01db5d94160	2026-08-28 11:04	2026-08-28 11:03	2026-08-28 11:03	BLSH	BLSH270319P00035000	put	35.0000	2027-03-19	8.1000	7.9500	8.1000	33.3700	12960.00	12960.00	0.00	16	10	394	4	98.5	0.773054071915957	0.773054071915957	false	false	false	true	false
554afc41-fdba-46ad-8536-61db41fc4287	2026-08-28 11:04	2026-08-28 11:03	2026-08-28 11:03	BLSH	BLSH270319P00035000	put	35.0000	2027-03-19	8.1000	7.9500	8.1000	33.3800	12960.00	12960.00	0.00	16	5	366	4	91.5	0.773472572431853	0.773472572431853	false	false	false	true	false
43399767-bcf2-48a2-8427-d5560d1a400c	2026-08-28 11:04	2026-08-28 11:03	2026-08-28 11:03	BLSH	BLSH270319P00035000	put	35.0000	2027-03-19	8.1000	7.9500	8.1000	33.3900	12960.00	12960.00	0.00	16	8	340	4	85	0.773890738616044	0.773890738616044	false	false	false	true	false
cbfa27ad-c330-46b1-965a-d035d622b435	2026-08-28 12:38	2026-08-28 12:38	2026-08-28 12:38	BLSH	BLSH270319P00035000	put	35.0000	2027-03-19	8.5000	8.3000	8.5000	32.4900	16998.00	16998.00	0.00	20	5	699	4	174.75	0.776969137067406	0.775913759117153	false	false	false	true	false
6794542a-265f-4e26-a565-2211bcb08ca0	2026-08-28 12:38	2026-08-28 12:38	2026-08-28 12:38	BLSH	BLSH270319P00035000	put	35.0000	2027-03-19	8.5000	8.3500	8.5000	32.4550	15298.00	15298.00	0.00	18	5	679	4	169.75	0.774356722396915	0.774356722396915	false	false	false	true	false
0d026ec1-7297-45de-b8a8-b555f9674ca5	2026-08-31 11:43	2026-08-31 11:43	2026-08-31 11:43	BLSH	BLSH260925C00036000	call	36.0000	2026-09-25	1.2400	1.2350	1.4800	32.6700	24800.00	0.00	24800.00	200	31	500	11	45.4545454545455	0.709992331348089	0.709992331348089	true	false	false	true	false
e51d0c9c-40e1-475d-b7ad-cc823f924042	2026-08-31 15:00	2026-08-31 15:00	2026-08-31 15:00	BLSH	BLSH261002C00035000	call	35.0000	2026-10-02	2.3000	2.1700	2.5500	33.8000	38410.00	17940.00	20470.00	167	7	219	3	73	0.698851738609373	0.693443318211624	false	false	false	true	false
8be22d37-384e-4951-b8cf-b1689cee6fd7	2026-09-02 14:59	2026-09-02 14:58	2026-09-02 14:58	BLSH	BLSH270115C00050000	call	50.0000	2027-01-15	1.7200	1.5000	2.0300	32.8650	66564.00	0.00	66564.00	387	9	500	2561	0.195236235845373	0.72854895304261	0.72854895304261	false	false	false	true	false
e985f547-479a-4b48-8333-e3c983d76a0f	2026-09-03 11:09	2026-09-03 11:09	2026-09-03 11:09	BLSH	BLSH260911P00038000	put	38.0000	2026-09-11	2.7300	2.5400	2.7300	35.9700	10374.00	10374.00	0.00	38	13	38	0	0	0.700081738532931	0.700081738532931	false	false	false	true	false
6201543b-4165-45af-a1f1-475d2389c16d	2026-09-03 11:10	2026-09-03 11:10	2026-09-03 11:10	BLSH	BLSH260918C00036000	call	36.0000	2026-09-18	2.0200	1.7900	2.3600	36.1600	388128.00	353368.00	34760.00	1923	34	1945	24	81.0416666666667	0.698265332218992	0.71053973558085	true	false	false	true	false
d0c0b22e-17e9-4217-81ab-91123243492a	2026-09-03 11:48	2026-09-03 11:48	2026-09-03 11:48	BLSH	BLSH260911C00037000	call	37.0000	2026-09-11	1.3500	1.2300	1.5400	36.5650	26985.00	26858.00	127.00	200	5	222	43	5.16279069767442	0.674054656768777	0.711156526241102	false	false	false	true	false
42c7f443-243a-4c58-8327-03136be920a5	2026-09-08 10:16	2026-09-08 10:16	2026-09-08 10:16	BLSH	BLSH261218C00055000	call	55.0000	2026-12-18	1.4000	1.4000	1.4700	35.5250	13160.00	0.00	3360.00	94	17	94	269	0.349442379182156	0.784257624558274	0.784257624558274	false	false	false	true	false
28f9081e-c07e-4334-bb26-3e6b7a26e3f0	2026-09-08 10:56	2026-09-08 10:56	2026-09-08 10:56	BLSH	BLSH260911P00034000	put	34.0000	2026-09-11	0.4700	0.4700	0.5600	35.8200	18236.00	0.00	18236.00	388	29	390	12	32.5	0.914651760999514	0.921956545880776	false	false	false	true	false
7b5c5c9e-d5be-4c7f-a077-25977d92ef54	2026-09-14 10:34	2026-09-14 10:34	2026-09-14 10:34	BLSH	BLSH260918C00036000	call	36.0000	2026-09-18	2.1800	2.1800	2.8500	37.9800	44254.00	0.00	44254.00	203	22	265	2043	0.129711209006363	0.535266458164992	0.535266458164992	false	false	false	true	false
4da78def-a3ce-4a95-b8c0-035c490190a2	2026-09-14 11:19	2026-09-14 11:19	2026-09-14 11:19	BLSH	BLSH260918P00035000	put	35.0000	2026-09-18	0.6000	0.4800	0.6000	37.1500	39960.00	39960.00	0.00	666	37	677	523	1.29445506692161	0.949361028523932	0.949361028523932	false	false	false	true	false
8d1573ce-e46d-4bb2-96e4-70e2a0993c69	2026-09-14 12:19	2026-09-14 12:19	2026-09-14 12:19	BLSH	BLSH260925C00039500	call	39.5000	2026-09-25	1.5000	1.3300	1.5000	38.1950	35999.00	35850.00	149.00	240	31	256	20	12.8	0.769941748426289	0.769941748426289	false	false	false	true	false
ff749b48-3a87-481c-9016-312456238ad3	2026-09-15 14:49	2026-09-15 14:49	2026-09-15 14:49	BLSH	BLSH260918P00034500	put	34.5000	2026-09-18	1.0800	0.7800	1.0800	34.6700	11340.00	11340.00	0.00	105	22	167	3	55.6666666666667	0.934462889142305	0.934462889142305	false	false	false	true	false
c2425653-d39a-458d-94e7-6c87705e5285	2026-09-15 15:48	2026-09-15 15:47	2026-09-15 15:47	BLSH	BLSH261016C00040000	call	40.0000	2026-10-16	1.5400	1.3300	1.5400	35.0000	17094.00	17094.00	0.00	111	22	148	792	0.186868686868687	0.758179731855916	0.758179731855916	false	false	false	true	false
29d63a9f-dc0d-434f-b317-8b19d19c806b	2026-09-17 13:36	2026-09-17 13:36	2026-09-17 13:36	BLSH	BLSH261009P00038000	put	38.0000	2026-10-09	4.0500	3.8000	4.0500	35.5800	16200.00	16200.00	0.00	40	8	40	0	0	0.759517078529609	0.759517078529609	false	false	false	true	false
8b6c4ea5-8f2f-4869-9432-7b8de3a5c266	2026-09-18 09:37	2026-09-18 09:37	2026-09-18 09:37	BLSH	BLSH260918C00036000	call	36.0000	2026-09-18	0.7700	0.7100	1.2000	36.5600	24728.00	2013.00	22715.00	322	37	388	1540	0.251948051948052	1.06337560810281	1.04928870846421	false	false	false	true	false
b44a5e09-92c1-496c-ba21-8929f2c205a9	2026-09-18 09:37	2026-09-18 09:37	2026-09-18 09:37	BLSH	BLSH260925C00037500	call	37.5000	2026-09-25	1.1000	1.1000	1.5600	36.4400	11000.00	0.00	11000.00	100	5	250	51	4.90196078431373	0.741644128193986	0.765370602759625	false	false	false	true	false
c9175f26-9605-4ac7-a22c-f0a580bac3d3	2026-09-18 10:42	2026-09-18 10:42	2026-09-18 10:42	BLSH	BLSH260925C00037000	call	37.0000	2026-09-25	1.7300	1.7300	2.0000	37.5005	89268.00	0.00	89268.00	516	36	519	63	8.23809523809524	0.705308046048849	0.705308046048849	false	false	false	true	false
20c97dd3-5154-4632-8410-7936613a7546	2026-09-18 11:14	2026-09-18 11:14	2026-09-18 11:14	BLSH	BLSH260918C00036000	call	36.0000	2026-09-18	1.4300	1.0100	1.6800	37.4800	52195.00	5148.00	47047.00	365	17	1024	1540	0.664935064935065	1.42481152450457	2.0661986547356	false	false	false	true	false
543677f1-f1c9-4608-a2da-fa980d6b8884	2026-09-18 11:34	2026-09-18 11:34	2026-09-18 11:34	BLSH	BLSH261009C00041000	call	41.0000	2026-10-09	1.4100	1.2100	1.4100	37.7000	12971.00	12971.00	0.00	92	20	99	21	4.71428571428571	0.723887804681928	0.72090324697188	false	false	false	true	false
2e2d0a06-2259-404c-bfb5-a9585f3a0b7b	2026-09-18 13:33	2026-09-18 13:33	2026-09-18 13:33	BLSH	BLSH260925P00038000	put	38.0000	2026-09-25	1.5600	1.3800	1.5600	37.9400	15288.00	15288.00	0.00	98	12	117	1	117	0.736823377677918	0.736823377677918	false	false	false	true	false
25b1f5e3-45a4-424a-8504-c0fbb541023c	2026-09-18 15:37	2026-09-18 15:36	2026-09-18 15:36	BLSH	BLSH261016P00030000	put	30.0000	2026-10-16	0.4200	0.4200	0.5100	38.0900	21294.00	0.00	21294.00	507	32	531	2673	0.198653198653199	0.749070752169385	0.749070752169385	false	false	false	true	false
0243df36-a76e-4de3-97cf-6708098ebe0f	2026-09-21 15:06	2026-09-21 15:06	2026-09-21 15:06	BLSH	BLSH270115C00035000	call	35.0000	2027-01-15	9.3000	9.3000	9.4500	40.0100	38130.00	0.00	24180.00	41	6	69	599	0.115191986644407	0.743795958818138	0.743795958818138	false	false	false	true	false