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: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

87ae16ae-309e-406f-aacc-209f71bdafe8	2026-09-30 10:41	2026-09-30 10:41	2026-09-30 10:41	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.8600	0.8400	0.8800	339.1100	17016.00	5690.00	11326.00	199	18	116680	11310	10.316534040672	0.368230365215497	0.372468153978598	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	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:42:27.796047Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
e8f9075c-8c4c-48f0-b6b7-5f48370b2709	2026-09-30 10:41	2026-09-30 10:41	2026-09-30 10:41	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.8800	0.8600	0.9100	339.2050	10150.00	5748.00	1732.00	115	16	116369	11310	10.2890362511052	0.371938550481159	0.370085187047136	true	false	false	true
b56e90bc-769d-43fc-a3b8-01c0c9ae71d5	2026-09-30 10:41	2026-09-30 10:41	2026-09-30 10:41	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.9000	0.8700	0.9200	339.2800	15429.00	10748.00	4590.00	172	29	116241	11310	10.2777188328912	0.368207686920004	0.369935561398021	true	false	false	true
f5dff447-f427-47a3-ad7c-bde3175a9077	2026-09-30 10:41	2026-09-30 10:41	2026-09-30 10:41	AAPL	AAPL260930P00337500	put	337.5000	2026-09-30	0.6000	0.5900	0.6300	339.1500	16285.00	540.00	15685.00	271	18	28232	2108	13.392789373814	0.376171743341904	0.379174774659414	false	false	false	true
dba9ae01-e22f-47e2-be25-a250b98671ed	2026-09-30 10:41	2026-09-30 10:41	2026-09-30 10:41	AAPL	AAPL261002C00337500	call	337.5000	2026-10-02	4.0000	3.9000	4.0000	339.1650	13200.00	13200.00	0.00	33	9	9116	2850	3.19859649122807	0.305462439765004	0.305462439765004	true	false	false	true
873a6c60-9703-45f9-8a76-3987352933fe	2026-09-30 10:41	2026-09-30 10:41	2026-09-30 10:41	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.8500	0.8300	0.8500	339.0600	11729.00	11645.00	0.00	138	13	115555	11310	10.2170645446508	0.372370105412718	0.378438900035198	false	false	false	true
7b680aa4-7361-42e3-b2bf-5afbc9117f60	2026-09-30 10:41	2026-09-30 10:41	2026-09-30 10:41	AAPL	AAPL261120P00300000	put	300.0000	2026-11-20	2.1400	2.1400	2.2400	339.1100	52218.00	0.00	52218.00	244	36	582	19647	0.0296228431821652	0.296078711731236	0.296078711731236	true	false	false	true
705c99f9-3e46-4186-ad07-6b5a75d71a9a	2026-09-30 10:41	2026-09-30 10:41	2026-09-30 10:41	AAPL	AAPL270115C00400000	call	400.0000	2027-01-15	2.6200	2.4700	2.7500	339.1100	14672.00	14672.00	0.00	56	5	299	11111	0.026910269102691	0.235239855585866	0.235123186911208	false	false	false	true
d07ed139-5470-4d09-aa4e-f7ce9abf7772	2026-09-30 10:41	2026-09-30 10:41	2026-09-30 10:41	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.8400	0.8200	0.8500	339.0806	26105.00	84.00	25853.00	311	17	115286	11310	10.1932802829355	0.371029780743659	0.366509230519246	true	false	false	true
48a7a7e6-38af-496a-8a73-9464be1103db	2026-09-30 10:41	2026-09-30 10:41	2026-09-30 10:41	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.8000	0.7900	0.8500	339.0300	11548.00	254.00	11294.00	144	13	114672	11310	10.1389920424403	0.379567177688934	0.366253243788755	true	false	false	true
4646ff44-341e-4b43-8097-fad39ea0094b	2026-09-30 10:41	2026-09-30 10:41	2026-09-30 10:41	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.8400	0.8100	0.8500	339.0800	29945.00	23649.00	2731.00	358	50	114405	11310	10.1153846153846	0.371467747670815	0.375927972659516	true	false	false	true
7fac41db-2551-4ea9-9f79-4e2682ba6554	2026-09-30 10:41	2026-09-30 10:41	2026-09-30 10:41	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.8200	0.8000	0.8300	339.0650	51980.00	27716.00	11673.00	634	65	114007	11310	10.0801945181256	0.370723844859191	0.365191337738238	true	false	false	true
1dcb4b98-f774-45ff-a44a-0dc85fec5564	2026-09-30 10:41	2026-09-30 10:41	2026-09-30 10:41	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.7500	0.7300	0.7600	338.8500	10350.00	300.00	10050.00	138	15	112472	11310	9.94447391688771	0.368864841611555	0.37116617827531	true	false	false	true
8280b119-e73f-4445-a4f8-9deca171e024	2026-09-30 10:40	2026-09-30 10:40	2026-09-30 10:40	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.7800	0.7600	0.8300	338.8900	15780.00	3090.00	11677.00	203	36	111752	11310	9.88081343943413	0.370796346019334	0.372760153471523	true	false	false	true
f00554cf-ba65-4aa7-9f90-04b994f7dbe3	2026-09-30 10:40	2026-09-30 10:40	2026-09-30 10:40	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.8000	0.7800	0.8100	339.0562	11348.00	8308.00	0.00	142	31	111500	11310	9.85853227232537	0.369742666775948	0.362665050431187	false	false	false	true
1ac2e94d-e294-4e42-b76e-7b2ff527cef7	2026-09-30 10:40	2026-09-30 10:40	2026-09-30 10:40	AAPL	AAPL261002P00340000	put	340.0000	2026-10-02	3.5000	3.5000	3.5500	338.9800	14352.00	0.00	14352.00	41	6	5446	3920	1.38928571428571	0.298483578313879	0.299677370588175	false	false	false	true
0a8357c2-d363-46a0-b595-47efe91245c4	2026-09-30 10:40	2026-09-30 10:40	2026-09-30 10:40	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.7500	0.7400	0.7550	338.9050	12225.00	12225.00	0.00	163	24	110528	11310	9.77259062776304	0.364477421436441	0.364477421436441	false	false	false	true
c33ab534-967e-42ce-8ea5-95f3a467b5aa	2026-09-30 10:40	2026-09-30 10:40	2026-09-30 10:40	AAPL	AAPL261002P00340000	put	340.0000	2026-10-02	3.5800	3.5500	3.6000	338.8150	26520.00	12240.00	14280.00	74	6	5405	3920	1.37882653061224	0.297586115768766	0.297586115768766	false	false	false	true
514157e2-69b0-44ff-9b86-95c8d6f2dd6d	2026-09-30 10:39	2026-09-30 10:39	2026-09-30 10:39	AAPL	AAPL261120C00340000	call	340.0000	2026-11-20	13.3500	13.2000	13.5000	338.7300	10680.00	2670.00	5340.00	8	5	755	10710	0.0704948646125117	0.257569237514585	0.257569237514585	false	false	false	true
9eb9378b-8f26-47c5-95d2-c1cef2c1b75b	2026-09-30 10:39	2026-09-30 10:39	2026-09-30 10:39	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.9900	1.9400	2.0300	338.7900	10351.00	10351.00	0.00	52	5	82723	14542	5.68855728235456	0.373465199503557	0.37020361972268	true	false	false	true
b4d3d571-4351-4832-8890-dce9f74cb524	2026-09-30 10:39	2026-09-30 10:39	2026-09-30 10:39	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.7300	0.7100	0.7300	338.8204	14521.00	14235.00	0.00	199	19	108596	11310	9.60176834659593	0.360540989410278	0.363760751727134	false	false	false	true
509e832a-509f-4606-b5e8-c34ddffaf899	2026-09-30 10:39	2026-09-30 10:38	2026-09-30 10:38	AAPL	AAPL261007C00345000	call	345.0000	2026-10-07	2.0300	1.5700	2.0800	338.8650	144941.00	144536.00	405.00	714	55	1008	242	4.16528925619835	0.230301403657373	0.230301403657373	false	false	false	true
3e6ead26-39a4-4143-9514-7b3d64fa8424	2026-09-30 10:39	2026-09-30 10:38	2026-09-30 10:38	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.7400	0.7300	0.7500	338.8750	10428.00	150.00	9834.00	141	14	107983	11310	9.54756852343059	0.367018136815621	0.363834959289221	false	false	false	true
05c8c5e5-4000-4b2f-bf30-84a9ec564d28	2026-09-30 10:38	2026-09-30 10:38	2026-09-30 10:38	AAPL	AAPL260930P00345000	put	345.0000	2026-09-30	6.4000	6.1500	6.8000	338.7100	29440.00	19200.00	10240.00	46	5	128	45	2.84444444444444	0.491486416415237	0.491486416415237	false	false	false	true
bd60576f-5fff-4ec4-b204-d272160bb5ab	2026-09-30 10:38	2026-09-30 10:38	2026-09-30 10:38	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	1.8600	1.8000	1.9300	338.6800	12817.00	554.00	12263.00	69	21	82286	14542	5.65850639526888	0.376775652049039	0.347826586976126	true	false	false	true
12cd4f45-06c5-4f3f-919d-973da196dac3	2026-09-30 10:38	2026-09-30 10:38	2026-09-30 10:38	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.7300	0.7000	0.7300	338.8300	15464.00	14744.00	0.00	212	7	105454	11310	9.32396109637489	0.362086593216148	0.362086593216148	false	false	false	true
ca8ead46-a403-4b91-b35f-67eae0976ae9	2026-09-30 10:38	2026-09-30 10:38	2026-09-30 10:38	AAPL	AAPL270115C00370000	call	370.0000	2027-01-15	8.0000	7.9000	8.0000	338.7750	12800.00	12800.00	0.00	16	6	76	10363	0.00733378365338223	0.240984300939353	0.240984300939353	false	false	false	true
0818f300-1014-4fdc-a414-8f695e06c6b6	2026-09-30 10:38	2026-09-30 10:37	2026-09-30 10:37	AAPL	AAPL260930P00337500	put	337.5000	2026-09-30	0.7000	0.7000	0.7300	338.8400	21910.00	0.00	21910.00	313	6	25877	2108	12.2756166982922	0.37767031407985	0.37767031407985	false	false	false	true
56536a80-8965-4976-aa16-5bdc1806787c	2026-09-30 10:38	2026-09-30 10:37	2026-09-30 10:37	AAPL	AAPL260930C00337500	call	337.5000	2026-09-30	2.0000	1.9800	2.0500	338.8500	11023.00	2662.00	8159.00	55	6	81926	14542	5.63375051574749	0.377072223334436	0.366113823489371	false	false	false	true
bbb21d2e-c4e7-4c75-bfb7-a07e0204212e	2026-09-30 10:37	2026-09-30 10:37	2026-09-30 10:37	AAPL	AAPL261002C00340000	call	340.0000	2026-10-02	2.5000	2.4300	2.5000	338.8600	19979.00	19979.00	0.00	80	11	19593	14358	1.36460509820309	0.303833969397807	0.299566500442547	true	false	false	true
18f4f4a6-5a22-4fa8-8e11-445930002104	2026-09-30 10:37	2026-09-30 10:37	2026-09-30 10:37	AAPL	AAPL261002P00335000	put	335.0000	2026-10-02	1.5300	1.5100	1.5400	338.7250	46052.00	39015.00	7037.00	301	25	7063	5847	1.20796989909355	0.307840844750282	0.307840844750282	false	false	false	true
f6304292-1867-4c81-a535-a9336bda3086	2026-09-30 10:37	2026-09-30 10:37	2026-09-30 10:37	AAPL	AAPL261002P00340000	put	340.0000	2026-10-02	3.6000	3.6000	3.6500	338.6800	29160.00	0.00	29160.00	81	5	5197	3920	1.32576530612245	0.292994590961363	0.292994590961363	true	false	false	true
d4ef0b4e-665e-48a7-8fb7-59bda5547b8c	2026-09-30 10:37	2026-09-30 10:37	2026-09-30 10:37	AAPL	AAPL290119P00380000	put	380.0000	2029-01-19	63.2000	63.2000	64.2000	338.6250	284405.00	0.00	284405.00	45	28	82	387	0.211886304909561	0.30838991948238	0.30838991948238	false	false	false	true
f216295f-977a-4c3d-8de2-66267468f1e3	2026-09-30 10:37	2026-09-30 10:37	2026-09-30 10:37	AAPL	AAPL261002P00335000	put	335.0000	2026-10-02	1.5700	1.5300	1.5800	338.5300	42076.00	40506.00	0.00	268	20	6715	5847	1.14845219770823	0.305525959815689	0.305525959815689	false	false	false	true
d8b6886f-3cdb-4b22-9d14-4429973c7551	2026-09-30 10:36	2026-09-30 10:36	2026-09-30 10:36	AAPL	AAPL260930P00337500	put	337.5000	2026-09-30	1.0200	1.0000	1.0500	337.9500	15780.00	0.00	12548.00	155	20	24502	2108	11.623339658444	0.357191750855963	0.363607886083601	false	false	false	true
73e3de1a-3ad4-4ce1-a305-1db7e1329e0c	2026-09-30 10:35	2026-09-30 10:35	2026-09-30 10:35	AAPL	AAPL270917C00420000	call	420.0000	2027-09-17	13.7500	13.4000	14.1000	338.1400	11000.00	8250.00	2750.00	8	7	9	1798	0.0050055617352614	0.258357073447852	0.258357073447852	false	false	false	true
d1e1f6f9-a647-4d49-bc7f-66aae6dd5913	2026-09-30 10:34	2026-09-30 10:34	2026-09-30 10:34	AAPL	AAPL260930C00335000	call	335.0000	2026-09-30	3.4000	3.3000	3.4500	338.1400	12580.00	7140.00	2040.00	37	10	94067	11968	7.8598763368984	0.37035702208314	0.37035702208314	true	false	false	true
b42b5b53-20b6-4b68-b4f0-dd23c50093bc	2026-09-30 10:33	2026-09-30 10:33	2026-09-30 10:33	AAPL	AAPL260930P00337500	put	337.5000	2026-09-30	0.9400	0.9200	0.9400	338.1608	18988.00	18988.00	0.00	202	15	23279	2108	11.0431688804554	0.371055965554679	0.371055965554679	true	false	false	true
a6169369-4c90-44b7-bace-e763388a53cf	2026-09-30 10:33	2026-09-30 10:33	2026-09-30 10:33	AAPL	AAPL261002P00335000	put	335.0000	2026-10-02	1.6800	1.6400	1.6800	338.1608	10080.00	10080.00	0.00	60	5	6269	5847	1.07217376432358	0.304522608269837	0.304522608269837	true	false	false	true
265aba0b-f53f-4a8c-af11-7b47f3a32f2b	2026-09-30 10:33	2026-09-30 10:33	2026-09-30 10:33	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.5000	0.4800	0.5200	338.0300	21271.00	570.00	20701.00	425	11	100070	11310	8.84792219274978	0.364919539008305	0.368424882703107	true	false	false	true
b831e794-dc63-4cf6-902d-3bec8128cecb	2026-09-30 10:33	2026-09-30 10:32	2026-09-30 10:32	AAPL	AAPL270319P00320000	put	320.0000	2027-03-19	13.9000	13.8500	14.0500	338.1600	13900.00	11120.00	2780.00	10	10	109	6721	0.016217824728463	0.273714183102456	0.273714183102456	false	false	false	true
40b31b28-f723-470e-b5ea-f6fca25be768	2026-09-30 10:33	2026-09-30 10:32	2026-09-30 10:32	AAPL	AAPL261002P00337500	put	337.5000	2026-10-02	2.6200	2.6000	2.6200	338.1200	24628.00	24628.00	0.00	94	5	6133	1830	3.35136612021858	0.296189365106139	0.296189365106139	false	false	false	true
96dee3e6-4151-4a95-8f67-fa745c90fc9b	2026-09-30 10:33	2026-09-30 10:32	2026-09-30 10:32	AAPL	AAPL270319P00320000	put	320.0000	2027-03-19	13.9600	13.9000	14.2500	338.0810	113080.00	1395.00	111685.00	81	20	99	6721	0.0147299509001637	0.274765025883682	0.274028014019276	false	false	false	true
cab3cf8f-0ade-46d9-ad74-587f4dfdd680	2026-09-30 10:32	2026-09-30 10:32	2026-09-30 10:32	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.5200	0.5000	0.5200	338.1300	10400.00	10400.00	0.00	200	7	99205	11310	8.77144120247569	0.365588963348904	0.365588963348904	false	false	false	true
6baef417-2822-41e4-9fd4-e972fc572a88	2026-09-30 10:32	2026-09-30 10:32	2026-09-30 10:32	AAPL	AAPL270917C00360000	call	360.0000	2027-09-17	32.8000	32.5500	32.8000	338.1200	16400.00	9840.00	0.00	5	5	8	3404	0.00235017626321974	0.269094247369094	0.269094247369094	false	false	false	true
9cc91a0e-c0ad-47aa-9224-489aef163492	2026-09-30 10:32	2026-09-30 10:32	2026-09-30 10:32	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.5700	0.5600	0.5700	338.3300	11172.00	11172.00	0.00	196	18	98358	11310	8.69655172413793	0.362986364232888	0.362986364232888	false	false	false	true
5ba08880-c972-4af6-850c-823c4ef4fa61	2026-09-30 10:32	2026-09-30 10:32	2026-09-30 10:32	AAPL	AAPL261106C00335000	call	335.0000	2026-11-06	13.9500	13.9500	14.3500	338.3698	11160.00	0.00	11160.00	8	5	87	261	0.333333333333333	0.267156651388875	0.267156651388875	false	false	false	true
e15e68a2-026a-40fe-923a-2978ef8503bf	2026-09-30 10:32	2026-09-30 10:32	2026-09-30 10:32	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.5300	0.5200	0.5600	338.1800	26137.00	0.00	24544.00	490	16	97097	11310	8.58505747126437	0.360404587617056	0.360331479875279	true	false	false	true
6aa0a8f7-7136-433d-a902-bdaf6f9e720b	2026-09-30 10:32	2026-09-30 10:32	2026-09-30 10:32	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.5400	0.5300	0.5500	338.2595	34294.00	25709.00	53.00	635	23	96532	11310	8.53510167992927	0.362379117235748	0.355960817772375	true	false	false	true
05a46356-1541-4026-974f-b90005728af9	2026-09-30 10:32	2026-09-30 10:32	2026-09-30 10:32	AAPL	AAPL260930C00340000	call	340.0000	2026-09-30	0.5200	0.5200	0.5300	338.2500	15236.00	0.00	15236.00	293	5	95727	11310	8.46392572944297	0.353367650504146	0.353367650504146	true	false	false	true