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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×ticker = AAPL×

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

d6bb49ee-1b59-4fd4-a230-51b438f4de93	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL261120C00365000	call	365.0000	2026-11-20	3.8200	3.6000	3.9000	337.0950	57296.00	57296.00	0.00	150	8	433	8041	0.0538490237532645	0.2448320494163	0.2448320494163	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Technology	4807322892000.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T14:01:58.194953Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
80d5b88d-cb32-4e6a-b0bc-7eeb5ea42cef	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	2.7000	2.6400	2.7600	337.2000	10541.00	274.00	8100.00	39	11	82516	11968	6.8947192513369	0.384156140713637	0.377554277116313	true	false	false	true
43eb89c1-a300-435d-b81e-f8e66101c76e	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.1600	1.1300	1.1900	337.1050	15429.00	6036.00	9393.00	133	21	43260	14542	2.97483152248659	0.382485426106935	0.376740861007076	false	false	false	true
f5b6ce73-bc70-43e6-a40d-929ecd65f840	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL261002C00340000	call	340.0000	2026-10-02	1.8500	1.7900	1.8500	337.1352	27750.00	27750.00	0.00	150	12	10314	14358	0.718345173422482	0.304450221292718	0.304450221292718	false	false	false	true
dadcedb0-6f71-4d37-abc1-d70ca4f62ec8	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL261009C00345000	call	345.0000	2026-10-09	2.0300	2.0300	2.2000	337.1550	29435.00	0.00	29435.00	145	9	1630	5273	0.309121941968519	0.229141062035676	0.229141062035676	false	false	false	true
bd942ca6-a07e-4f59-b6ae-792433c0f237	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL260930C00332500	call	332.5000	2026-09-30	4.8000	4.6500	4.9500	337.2094	10080.00	7200.00	0.00	21	6	40111	9581	4.18651497755975	0.357960151305432	0.349911706624953	false	false	false	true
97f784e5-5aee-4d75-bb1e-4486099912dd	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.1700	1.1200	1.2000	337.2157	10921.00	8593.00	1402.00	93	34	43006	14542	2.95736487415761	0.388300923931351	0.379232915809337	false	false	false	true
768a6eb1-c792-42d7-9393-5e4f17ac27e9	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL261002C00332500	call	332.5000	2026-10-02	6.0000	5.7500	6.0500	337.1200	12000.00	12000.00	0.00	20	5	5799	4971	1.16656608328304	0.316746891525478	0.314099819720265	false	false	false	true
3bd0f350-6f94-49ad-8a94-33d245d06c55	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.0900	1.0700	1.1300	337.0000	11084.00	4607.00	4640.00	102	24	42754	14542	2.94003575849264	0.37870031263262	0.381632570871699	true	false	false	true
31d79b94-0ede-4367-b7e1-1f90504c81fd	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL261016C00340000	call	340.0000	2026-10-16	5.3700	5.3500	5.4500	337.0000	107348.00	31378.00	75970.00	200	6	1370	107357	0.0127611613588308	0.230950261869645	0.229368392528369	false	false	false	true
f71dc3a7-7cd0-4c40-bded-2fdb0d824f71	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.0900	1.0700	1.1000	336.9550	12851.00	12100.00	751.00	118	7	42465	14542	2.92016228854353	0.387581621389416	0.381556049615067	false	false	false	true
0a1f5e67-269f-4ccb-8eee-593b7bf22593	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.0900	1.0600	1.1000	336.9301	18095.00	7650.00	9687.00	166	49	42347	14542	2.91204786136707	0.386202811584487	0.384696952501383	true	false	false	true
aad20b27-78c7-47e1-aecf-94485816d97b	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL260930P00337500	put	337.5000	2026-09-30	1.6600	1.6100	1.6600	337.0100	39175.00	39175.00	0.00	236	16	774	2108	0.367172675521822	0.39732366311242	0.400195573267398	true	false	false	true
afd03d31-e5fa-424e-b8f4-0f63026bcfb7	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.0100	0.9800	1.0300	336.8500	12602.00	12502.00	100.00	125	10	41960	14542	2.88543529088158	0.373473641075885	0.368581801756622	true	false	false	true
4792fb92-d2f4-419b-a78a-8cb338a2edac	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	2.4900	2.4600	2.5400	336.9200	10208.00	6751.00	2465.00	41	21	82231	11968	6.8709057486631	0.384726559976319	0.376030185558023	false	false	false	true
28437d87-c15a-4bb3-83cb-85a83739299b	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	2.4200	2.3900	2.4900	336.8500	27372.00	1466.00	25171.00	113	15	82190	11968	6.86747994652406	0.362655817300539	0.376132901271866	true	false	false	true
34c470de-6ea4-4088-8884-e77bbe4eabc2	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	0.9800	0.9800	1.0000	336.7751	19938.00	200.00	15778.00	203	11	41642	14542	2.86356759730436	0.375513157438301	0.371877662377278	false	false	false	true
c06b2c53-2a0f-4f4d-9ea0-9e4d699a3b78	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.0000	0.9700	1.0000	336.7931	21767.00	20678.00	0.00	218	41	41266	14542	2.83771145647091	0.374171217631834	0.375490261152857	true	false	false	true
45b804f1-bfe9-4776-a2b5-05e002d24ad7	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	4.0000	3.9000	4.0000	336.7500	13590.00	13590.00	0.00	34	14	11138	9663	1.15264410638518	0.304720221212732	0.301469081874524	false	false	false	true
2e546341-a19f-47e1-ab00-7889e4f6e751	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	0.9700	0.9400	0.9800	336.6600	15651.00	9318.00	5751.00	162	36	40874	14542	2.8107550543254	0.379724924745316	0.376836763793875	false	false	false	true
f5a7d4d5-df7b-42fb-b5b7-6c17e2e1f14a	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	0.9000	0.8600	0.9200	336.5450	14561.00	12856.00	0.00	162	33	40643	14542	2.79487003163251	0.379287319445643	0.378474524236802	true	false	false	true
6a817f6b-bf2e-4429-a44e-9a3afb26d282	2026-09-30 10:01	2026-09-30 10:01	2026-09-30 10:01	AAPL	AAPL261009C00335000	call	335.0000	2026-10-09	6.0000	5.7500	6.0500	336.4600	12000.00	12000.00	0.00	20	9	920	2517	0.365514501390544	0.240373429052429	0.240373429052429	true	false	false	true
6307479f-9522-4452-b9e5-8812e6fb7dda	2026-09-30 10:01	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	1.9700	1.9000	2.1000	336.1600	72843.00	9697.00	60102.00	370	93	81305	11968	6.7935327540107	0.377205287909115	0.36924199900324	true	false	false	true
99fcb619-1650-4613-b85b-7506a747cb8b	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	0.8100	0.7500	0.8500	336.0800	12058.00	6429.00	5397.00	149	50	39372	14542	2.70746802365562	0.385879482578773	0.396699008011687	true	false	false	true
b7aeab5a-ad8d-4bb4-9e56-80fcdc25fe88	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL260930P00335000	put	335.0000	2026-09-30	0.7600	0.7500	0.7700	336.3400	15575.00	15200.00	375.00	205	22	4761	3066	1.55283757338552	0.379590252126282	0.375958253436741	false	false	false	true
05130995-9790-43f6-a413-479e4df2987d	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	0.8400	0.8400	0.8600	336.3100	15798.00	86.00	15457.00	188	17	38474	14542	2.64571585751616	0.386870356625679	0.383847323346112	true	false	false	true
e60fa8ef-cc75-43d5-ae81-da9f8ac79a83	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL261106C00340000	call	340.0000	2026-11-06	10.1000	9.4000	10.1000	336.3500	24240.00	24240.00	0.00	24	9	68	336	0.202380952380952	0.260705178752081	0.260705178752081	true	false	false	true
30179b9c-8a31-4b30-bd34-15662aa6b87b	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	0.8800	0.8500	0.8900	336.3100	24069.00	13307.00	10154.00	275	56	38049	14542	2.61649016641452	0.391421687389004	0.389863292120958	false	false	false	true
f3944d98-e48a-4793-93ec-bf8eaf55e8ee	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL261002C00340000	call	340.0000	2026-10-02	1.5000	1.4400	1.5000	336.3400	10950.00	10950.00	0.00	73	13	9717	14358	0.676765566234852	0.295705797103043	0.295705797103043	false	false	false	true
b1a3243a-4544-4d60-86ac-418b65c1f8cf	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	0.8400	0.8300	0.8700	336.2630	10628.00	4603.00	5771.00	126	30	37122	14542	2.55274377664695	0.390872558269218	0.385872362667125	true	false	false	true
1f495575-adb3-4751-9b01-a24c07f91e10	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	0.8400	0.8000	0.8800	336.2450	13647.00	6672.00	6376.00	162	46	36996	14542	2.54407921881447	0.387841163240975	0.390872558269218	true	false	false	true
83335e37-8194-4626-bcf0-87d6f826493c	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	2.0000	1.9600	2.0000	336.2500	26765.00	24786.00	1581.00	134	33	80299	11968	6.70947526737968	0.375046078865812	0.363319668990653	false	false	false	true
6ff95a89-f1b1-4e37-94d8-508e5a071b3b	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL261218C00330000	call	330.0000	2026-12-18	20.8000	20.1500	20.8000	336.2300	20800.00	20800.00	0.00	10	8	2324	18730	0.124079017618793	0.255970153503898	0.255970153503898	false	false	false	true
f6db403d-1632-4895-8f6a-9ab52211253e	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL261120C00370000	call	370.0000	2026-11-20	2.6400	2.4700	2.6500	336.1300	250537.00	250537.00	0.00	949	54	1047	10044	0.104241338112306	0.241217838855951	0.241532366462884	true	false	false	true
9a9b62d8-55f7-4a14-94f2-8e30c4edc21a	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	0.6900	0.6600	0.7300	335.9600	11238.00	7373.00	2917.00	163	33	35475	14542	2.43948562783661	0.382441526806134	0.37762343161283	false	false	false	true
21c83dd4-e913-49c3-a51c-7b0a08529995	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL261002C00340000	call	340.0000	2026-10-02	1.3100	1.3100	1.3700	335.9600	26200.00	0.00	26200.00	200	12	9474	14358	0.659841203510238	0.287266345141678	0.287266345141678	false	false	false	true
39919a56-58fa-499f-851b-526d8a99e408	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	1.7700	1.7200	1.7800	335.8000	18535.00	16454.00	2081.00	105	9	79795	11968	6.66736296791444	0.369938244748604	0.378819156885052	false	false	false	true
5d98f99d-eb73-4f36-8fe2-39be57916e4e	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	1.7800	1.7500	1.8100	335.9100	20685.00	20147.00	178.00	116	17	79458	11968	6.63920454545455	0.367460050063667	0.367945636558527	false	false	false	true
e8753558-c37c-4b4b-8082-e4ac1cc74aee	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL261002C00335000	call	335.0000	2026-10-02	3.4400	3.3500	3.5000	335.8900	10326.00	8971.00	335.00	30	7	10514	9663	1.08806788781952	0.297097897139743	0.297112742591255	false	false	false	true
34084d6d-6e8f-4db9-9859-e4c4105b9739	2026-09-30 10:00	2026-09-30 10:00	2026-09-30 10:00	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	1.7200	1.6700	1.7400	335.7636	39831.00	35619.00	4212.00	231	44	79220	11968	6.61931818181818	0.365487590812432	0.358675646104333	true	false	false	true
b1ed7d68-163d-450a-adf1-3274d909f6e4	2026-09-30 10:00	2026-09-30 09:59	2026-09-30 09:59	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	1.7300	1.7200	1.7500	335.8400	29074.00	26134.00	172.00	168	13	78940	11968	6.59592245989305	0.367510500087568	0.365730096096274	true	false	false	true
9fa71fdb-bef7-4a8c-9221-3aea131e5c26	2026-09-30 10:00	2026-09-30 09:59	2026-09-30 09:59	AAPL	AAPL261002C00342500	call	342.5000	2026-10-02	0.7100	0.7100	0.7300	335.8401	24921.00	0.00	24921.00	351	12	3618	12295	0.294265961773079	0.287711911454339	0.287711911454339	false	false	false	true
9ea12a0b-d733-4900-8cbe-f4b4a27f0e3d	2026-09-30 10:00	2026-09-30 09:59	2026-09-30 09:59	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	0.6600	0.6400	0.6700	335.8201	17769.00	2613.00	15024.00	269	38	34320	14542	2.36006051437216	0.37467795478205	0.37889320616004	false	false	false	true
82664a28-7fee-4dc4-ab7c-6ab9ee5729c5	2026-09-30 10:00	2026-09-30 09:59	2026-09-30 09:59	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	1.7200	1.7000	1.7300	335.7700	10147.00	9977.00	170.00	59	9	78610	11968	6.56834893048128	0.360726587490239	0.369255685593807	false	false	false	true
7ae7f8f8-57a4-4013-8aba-6cf5e6a5f63b	2026-09-30 10:00	2026-09-30 09:59	2026-09-30 09:59	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	0.6700	0.6400	0.6700	335.8300	15579.00	13702.00	1877.00	234	26	34051	14542	2.34156237106313	0.377391108369881	0.37467795478205	false	false	false	true
ceb22cdf-63e0-4fee-9a26-17615cbb1fd6	2026-09-30 09:59	2026-09-30 09:59	2026-09-30 09:59	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	1.7000	1.7000	1.7500	335.7801	10731.00	350.00	10381.00	63	10	78506	11968	6.55965909090909	0.360718164430235	0.364529115570322	false	false	false	true
2febef72-2647-4434-9a32-ac1013b937fe	2026-09-30 09:59	2026-09-30 09:59	2026-09-30 09:59	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	1.7400	1.7000	1.7600	335.8201	16567.00	8612.00	7266.00	95	7	78435	11968	6.55372660427807	0.369231619755654	0.360374017068468	false	false	false	true
7b72e6ca-d571-4f10-a1cd-4b5109afefb5	2026-09-30 09:59	2026-09-30 09:59	2026-09-30 09:59	AAPL	AAPL270319C00430000	call	430.0000	2027-03-19	2.4100	2.2600	2.4100	335.8300	14460.00	14460.00	0.00	60	5	90	1026	0.087719298245614	0.242062244477562	0.242062244477562	false	false	false	true
a378e41d-4ba3-43a8-8809-b9abfb3fbc25	2026-09-30 09:59	2026-09-30 09:59	2026-09-30 09:59	AAPL	AAPL261002P00332500	put	332.5000	2026-10-02	1.5800	1.5400	1.5800	335.7750	24806.00	24806.00	0.00	157	10	1644	2879	0.571031608197291	0.299778118829982	0.299778118829982	false	false	false	true
0c2da642-8fcb-4fc0-ae2b-285c18726a3a	2026-09-30 09:59	2026-09-30 09:59	2026-09-30 09:59	AAPL	AAPL261002C00332500	call	332.5000	2026-10-02	5.0000	4.8000	5.0000	335.7650	12500.00	12500.00	0.00	25	8	5652	4971	1.13699456849728	0.308523544968774	0.308523544968774	false	false	false	true