Due to the way CNAMEs work, no. The HOST header (eg static.example.com) is directly proxied to S3, but S3 uses the HOST header to determine which bucket to access. Only enterprise plan members have an “override HOST header” page rule option which would make this possible since said page rule would be ripe for abuse on non-contract plans.