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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×option_symbol = AAPL260918C00330000×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

5ed64e64-95d2-4e8d-ba31-e6d4dc73511e	2026-08-18 10:10	2026-08-18 10:09	2026-08-18 10:09	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	2.3800	2.3100	2.3800	309.6300	105196.00	105196.00	0.00	442	10	1410	24367	0.0578651454836459	0.23959862798851	0.23959862798851	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	4861029474400.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
5d426f75-d160-4d2e-b2b2-1ab1be4298ae	2026-08-18 10:10	2026-08-18 10:10	2026-08-18 10:10	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	2.4400	2.3700	2.4400	309.8003	122000.00	122000.00	0.00	500	11	1993	24367	0.081790946772274	0.240580776709244	0.240580776709244	false	false	false
c7a4b78a-b1d9-4ce7-81f8-c033cb6c6a58	2026-08-18 10:10	2026-08-18 10:10	2026-08-18 10:10	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	2.4500	2.3700	2.4500	309.8400	122500.00	122500.00	0.00	500	8	2493	24367	0.102310501908319	0.240650667949765	0.240650667949765	false	false	false
9762e604-c7ff-4bb5-bd7d-e7075b48e809	2026-08-19 09:53	2026-08-19 09:52	2026-08-19 09:52	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.4500	3.3500	3.4500	314.3100	172500.00	172500.00	0.00	500	15	2729	27225	0.100238751147842	0.242907793372203	0.242907793372203	false	false	false
39ea49f7-a2d8-425a-97fc-1ad928083f7e	2026-08-19 09:53	2026-08-19 09:53	2026-08-19 09:53	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.5000	3.3500	3.5000	314.4900	174975.00	174975.00	0.00	500	35	3250	27225	0.119375573921028	0.242960988200157	0.242960988200157	false	false	false
55538124-5acf-44d8-b7f3-624f94deff8e	2026-08-19 09:53	2026-08-19 09:53	2026-08-19 09:53	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.6000	3.3500	3.6000	314.6650	180000.00	180000.00	0.00	500	31	3761	27225	0.138145087235996	0.244707281728961	0.244707281728961	false	false	false
f0fad22f-6284-4116-9443-a6306e7a5fb4	2026-08-19 09:58	2026-08-19 09:58	2026-08-19 09:58	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.9200	3.8500	3.9500	316.0300	195876.00	195876.00	0.00	500	13	5786	27225	0.212525252525253	0.243174470961048	0.242175663086045	false	false	false
3af1ad0f-ed01-4066-bb0e-685f454bd8e5	2026-08-19 10:04	2026-08-19 10:04	2026-08-19 10:04	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	4.4500	4.3000	4.4500	317.4436	222500.00	222500.00	0.00	500	5	8858	27225	0.325362718089991	0.245551242000775	0.245551242000775	false	false	false
e1920087-ede2-4b13-b534-381d980ed707	2026-08-19 10:55	2026-08-19 10:55	2026-08-19 10:55	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	4.5500	4.5000	4.5500	317.5900	221585.00	221585.00	0.00	487	6	12173	27225	0.44712580348944	0.247181575947682	0.247181575947682	false	false	false
4d11c430-2beb-4375-a1f2-1f730053735d	2026-08-19 10:55	2026-08-19 10:55	2026-08-19 10:55	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	4.6000	4.5000	4.6000	317.6100	223100.00	223100.00	0.00	485	14	12674	27225	0.465528007346189	0.248513918451629	0.248513918451629	false	false	false
804ee68f-6ace-41ca-9f0f-e050ba877da4	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	4.6000	4.5500	4.6000	317.6800	223100.00	223100.00	0.00	485	10	13165	27225	0.48356290174472	0.24782131709975	0.24782131709975	false	false	false
ae29773d-6d26-4bde-a794-16b7415a4ced	2026-08-19 10:58	2026-08-19 10:58	2026-08-19 10:58	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	4.8000	4.7000	4.8000	318.2220	144000.00	144000.00	0.00	300	8	14746	27225	0.541634527089073	0.248484563935364	0.248484563935364	false	false	false
ef2a67c7-0b8e-4353-b236-8f53af464388	2026-08-19 10:59	2026-08-19 10:59	2026-08-19 10:59	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	4.8000	4.7000	4.8000	318.0700	234240.00	234240.00	0.00	488	5	15556	27225	0.571386593204775	0.25001030892821	0.25001030892821	false	false	false
c7523b79-131a-41d6-9086-94c346611486	2026-08-19 11:02	2026-08-19 11:02	2026-08-19 11:02	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	4.9000	4.8000	4.9000	318.4899	222950.00	222950.00	0.00	455	15	16624	27225	0.610615243342516	0.248788566369904	0.248788566369904	false	false	false
a5f1d261-683a-4fed-a5d3-1d2a6fb84d15	2026-08-19 14:19	2026-08-19 14:19	2026-08-19 14:19	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.6000	3.6000	3.8000	314.8400	180000.00	0.00	180000.00	500	14	21463	27225	0.788356290174472	0.242833940229568	0.243108314459423	false	false	false
641faf82-df36-4393-a396-a4ff8e900b85	2026-08-19 14:19	2026-08-19 14:19	2026-08-19 14:19	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.6000	3.6000	3.8000	314.9600	180000.00	0.00	180000.00	500	8	21963	27225	0.806721763085399	0.242010346417964	0.242010346417964	false	false	false
fab8e775-b977-4152-ab65-9c078ce0339e	2026-08-20 09:31	2026-08-20 09:31	2026-08-20 09:31	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	5.2500	4.9500	5.2500	319.0500	262500.00	262500.00	0.00	500	6	651	32252	0.0201847947414114	0.258157203165858	0.258157203165858	false	false	false
2057e8cd-a2c1-49ac-affa-17a5113cd02a	2026-08-20 09:31	2026-08-20 09:31	2026-08-20 09:31	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	5.1500	5.1500	5.3500	319.0800	257500.00	0.00	257500.00	500	6	1166	32252	0.0361527967257844	0.254837050701688	0.254837050701688	true	false	false
39ad1765-bda1-49ee-8143-329a326c3a7b	2026-08-20 09:33	2026-08-20 09:33	2026-08-20 09:33	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	5.4000	5.2500	5.4000	319.7000	270000.00	270000.00	0.00	500	6	1771	32252	0.0549113233287858	0.255762870106384	0.255762870106384	false	false	false
0242c2ab-e3ff-4c32-b28d-8b9bb5f3bb92	2026-08-20 14:25	2026-08-20 14:25	2026-08-20 14:25	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.6000	3.6000	3.7000	315.1950	180000.00	0.00	180000.00	500	18	5101	32252	0.158160734218033	0.244271354915122	0.244271354915122	false	false	false
dc28af60-9d4d-4e15-9a15-7f802a0ae151	2026-08-20 14:25	2026-08-20 14:25	2026-08-20 14:25	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.6000	3.6000	3.7000	315.1900	162720.00	0.00	162720.00	452	14	5601	32252	0.173663648765968	0.244317995246059	0.244317995246059	false	false	false
8335ab39-3517-4ffc-8e9e-458449f9088a	2026-08-24 12:46	2026-08-24 12:46	2026-08-24 12:46	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	2.4300	2.3600	2.4400	312.4393	183708.00	16038.00	167670.00	756	11	6670	29599	0.225345450859826	0.245451432647498	0.245493081869006	false	false	false
f51a9aa7-8edf-4fb4-b370-ba42973f620a	2026-08-27 10:02	2026-08-27 10:02	2026-08-27 10:02	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	2.0000	1.9900	2.0000	311.8100	200000.00	38600.00	0.00	1000	6	4028	33615	0.119827457980068	0.248866656602404	0.248866656602404	true	false	false
db02b620-72e7-489b-b251-3c039b264448	2026-08-27 10:03	2026-08-27 10:03	2026-08-27 10:03	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	1.9500	1.9500	2.0400	311.6850	195000.00	0.00	195000.00	1000	23	6031	33615	0.179413952104715	0.247636434433669	0.247636434433669	false	false	false
74447a39-dd1e-4537-a04c-4d1bfb3ea421	2026-08-27 10:03	2026-08-27 10:03	2026-08-27 10:03	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	1.9300	1.9300	2.0300	311.4700	181613.00	0.00	181613.00	941	35	6973	33615	0.207437156031534	0.248646684865524	0.248646684865524	false	false	false
19bbad7c-98d5-4829-957a-c332ac1c41e1	2026-09-01 09:49	2026-09-01 09:48	2026-09-01 09:48	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.5500	3.5500	3.7000	320.8700	110050.00	0.00	110050.00	310	7	998	32211	0.0309832044953587	0.25049550059104	0.25049550059104	false	false	false
14c1e8a5-fd04-4bb3-ae96-9b8817f1cd35	2026-09-01 10:50	2026-09-01 10:50	2026-09-01 10:50	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	5.3000	5.3000	5.4000	325.1650	126140.00	0.00	126140.00	238	13	3671	32211	0.11396727825898	0.256572972808513	0.256572972808513	true	false	false
b4ba0f53-9a47-47dd-b2f6-673d7371db0c	2026-09-01 12:08	2026-09-01 12:08	2026-09-01 12:08	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	5.7500	5.7500	5.8000	326.2305	123625.00	0.00	123625.00	215	5	5468	32211	0.169755673527677	0.256295971465338	0.256295971465338	false	false	false
de633209-9fbc-4418-abdf-20bef72b13df	2026-09-03 11:38	2026-09-03 11:38	2026-09-03 11:38	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	7.1500	7.1500	7.2500	329.9900	593450.00	0.00	593450.00	830	47	5537	29487	0.187777664733611	0.258136178274348	0.258622300594477	false	false	false
4c6bd89a-9b82-4c03-9a9d-41a9c3b4294f	2026-09-04 10:01	2026-09-04 10:01	2026-09-04 10:01	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.5000	3.5000	3.6000	322.7200	145250.00	0.00	145250.00	415	12	1711	29034	0.058930908589929	0.248287874989738	0.248287874989738	false	false	false
9cb0b765-83f1-4943-a2fe-abfced7784bf	2026-09-04 12:19	2026-09-04 12:19	2026-09-04 12:19	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.1500	3.0500	3.1500	321.2600	147735.00	147735.00	0.00	469	24	8074	29034	0.278087759178894	0.253957711314088	0.253957711314088	false	false	false
04ad3251-7ed3-4651-a465-d5a1725d0a26	2026-09-04 12:19	2026-09-04 12:19	2026-09-04 12:19	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.2000	3.1000	3.2000	321.3000	141760.00	141760.00	0.00	443	14	8598	29034	0.296135565199421	0.255631711288753	0.255631711288753	false	false	false
99283dda-e9f1-46b7-ae83-eca6677bfb5e	2026-09-10 12:43	2026-09-10 12:43	2026-09-10 12:43	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.0000	2.9400	3.0000	323.0000	303000.00	303000.00	0.00	1010	9	16621	33611	0.494510725655291	0.281153426805073	0.281153426805073	false	false	false
e3915435-6ea0-4a2c-a1c1-46de248dea6f	2026-09-10 12:45	2026-09-10 12:45	2026-09-10 12:45	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.1500	3.1000	3.1500	324.0000	141750.00	141750.00	0.00	450	5	17430	33611	0.518580226711493	0.279602089909653	0.279602089909653	false	false	false
5bccbcb5-df4e-462f-a6c7-89ccbe84c38b	2026-09-10 13:00	2026-09-10 13:00	2026-09-10 13:00	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	2.5900	2.5900	2.6600	323.0000	116550.00	0.00	116550.00	450	25	18811	33611	0.559667965844515	0.270488247103625	0.272064780080897	false	false	false
1760f5cb-79b5-4743-94dc-a5eb425885b9	2026-09-10 15:12	2026-09-10 15:12	2026-09-10 15:12	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.5000	3.4500	3.5500	325.5700	355250.00	351050.00	0.00	1015	7	26278	33611	0.781827377941745	0.275042757487565	0.275042757487565	false	false	false
25751114-79dc-44d2-ae20-6247e0cd5e14	2026-09-11 09:36	2026-09-11 09:36	2026-09-11 09:36	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	7.0000	6.8500	7.0000	333.0000	193200.00	193200.00	0.00	276	13	3809	36643	0.103948912479873	0.283164226991371	0.283164226991371	false	false	false
61f7a313-fe9e-4ef3-b2bb-08f8f4e5157d	2026-09-11 09:46	2026-09-11 09:46	2026-09-11 09:46	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	6.7000	6.7000	6.8500	332.0000	420773.00	0.00	420773.00	628	15	6459	36643	0.176268318642033	0.269491114710298	0.269491114710298	false	false	false
7e8789bb-d6ca-4ae0-badc-1b47fbacfd1c	2026-09-11 11:50	2026-09-11 11:50	2026-09-11 11:50	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	7.5000	7.5000	7.6000	334.6100	750000.00	0.00	750000.00	1000	6	15786	36643	0.430805337990885	0.255096217367015	0.255096217367015	false	false	false
85b4b8fb-3444-4f42-a8f3-7693d38361fe	2026-09-11 13:10	2026-09-11 13:10	2026-09-11 13:10	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	7.3500	7.3500	7.4000	334.3800	110250.00	0.00	110250.00	150	19	16995	36643	0.463799361405998	0.254467231512596	0.255245301516973	true	false	false
fc21cab8-d644-4e99-bcea-4467444ed8e6	2026-09-11 13:42	2026-09-11 13:42	2026-09-11 13:42	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	6.5000	6.4500	6.5000	333.1550	137791.00	135850.00	1941.00	212	6	17624	36643	0.480964986491281	0.251501977976799	0.251501977976799	true	false	false
74087369-7684-4d45-9f09-b2baa320d0fa	2026-09-15 10:07	2026-09-15 10:07	2026-09-15 10:07	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.4000	3.3000	3.4000	329.6400	432140.00	432140.00	0.00	1271	52	4367	29139	0.149867874669687	0.295567824722123	0.295567824722123	false	false	false
10a65de8-f3d3-4c8c-878d-f6d156f34b46	2026-09-15 15:15	2026-09-15 15:15	2026-09-15 15:15	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	3.6000	3.6000	3.7000	330.1800	735128.00	0.00	735128.00	2042	62	16252	29139	0.557740485260304	0.289423675413296	0.289423675413296	false	false	false
a287fec5-4a63-41dc-93a1-8ae0a10447c0	2026-09-16 09:41	2026-09-16 09:41	2026-09-16 09:41	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	6.3000	6.3000	6.5500	334.7500	315000.00	0.00	315000.00	500	10	3147	27366	0.114996711247533	0.341597552081233	0.341597552081233	false	false	false
0338bfa1-ce07-44f6-8892-46f55b09d81d	2026-09-17 12:34	2026-09-17 12:34	2026-09-17 12:34	AAPL	AAPL260918C00330000	call	330.0000	2026-09-18	6.2000	6.2000	6.3500	335.7400	111600.00	0.00	111600.00	180	6	10436	25976	0.40175546658454	0.317709192654909	0.317709192654909	false	false	false