AWS Cost and Usage Report Details

http://docs.aws.amazon.com/awsaccountbilling/latest/aboutv2/detailed-billing-reports.html
aws s3 cp s3://programmatic-billing-bucket/AWSUsageDaily/*AWSUsageDaily/20160501-20160601/*AWSUsageDaily-Manifest.json AWSUsageDaily-Manifest.json
tail -1 AWSUsageDaily-Manifest.json
aws s3 cp s3://programmatic-billing-bucket/AWSUsageDaily/*AWSUsageDaily/20160501-20160601/067ef9f8-d528-4adc-ad7d-e003ecaddac5/*AWSUsageDaily-1.csv.zip AWSUsageDaily-1.csv.zip
unzip  AWSUsageDaily-1.csv.zip
grep name AWSUsageDaily-Manifest.json | cat -n # to list all columns

grep name AWSUsageDaily-Manifest.json | cat -n | tr '\t' ',' | egrep ' 2,|13,|14,|15,|16,|17,|18'
     2,    "name":"TimeInterval"
    13,    "name":"ProductCode"
    14,    "name":"UsageType"
    15,    "name":"Operation"
    16,    "name":"AvailabilityZone"
    17,    "name":"ResourceId"
    18,    "name":"UsageAmount"


grep AmazonS3 *AWSUsageDaily-1.csv | grep mybucket | grep '2016-05-10T00:00:00Z/2016-05-11T00:00:00Z' | cut -d',' -f2,13-18
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-DataTransfer-Out-Bytes,GetObject,,mybucket,0.00003379
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-Requests-Tier2,ReadBucketPolicy,,mybucket,2.00000000
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-DataTransfer-Out-Bytes,ReadLocation,,mybucket,0.00000054
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-USW2-AWS-Out-Bytes,GetObject,,mybucket,0.00000480
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-APS1-AWS-Out-Bytes,GetObject,,mybucket,0.00000480
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-USE1-AWS-Out-Bytes,ReadLocation,,mybucket,0.00000502
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-Requests-Tier2,ReadLogProps,,mybucket,1.00000000
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-Requests-Tier2,ReadLocation,,mybucket,47.00000000
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-Requests-Tier1,PutObject,,mybucket,5199.00000000
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-DataTransfer-In-Bytes,PutObject,,mybucket,10.63990941
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-Requests-Tier2,ReadCostAllocation,,mybucket,96.00000000
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-Requests-Tier2,ReadACL,,mybucket,2.00000000
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-Requests-Tier2,ReadVersioningProps,,mybucket,1.00000000
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-SAE1-AWS-Out-Bytes,GetObject,,mybucket,0.00000478
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-USE1-AWS-Out-Bytes,ReadACL,,mybucket,0.00000106
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-USE1-AWS-Out-Bytes,GetObject,,mybucket,0.00000481
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-Requests-Tier1,ListBucket,,mybucket,4.00000000
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-USE1-AWS-Out-Bytes,ReadVersioningProps,,mybucket,0.00000011
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-USE1-AWS-Out-Bytes,ReadLogProps,,mybucket,0.00000027
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-TimedStorage-ByteHrs,StandardStorage,,mybucket,251.55385479
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-Requests-Tier2,HeadBucket,,mybucket,2.00000000
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-USE1-AWS-Out-Bytes,ReadCostAllocation,,mybucket,0.00003521
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-USE1-AWS-Out-Bytes,ListBucket,,mybucket,0.00000098
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,Requests-Tier2,HeadBucket,,mybucket,16.00000000
2016-05-10T00:00:00Z/2016-05-11T00:00:00Z,AmazonS3,APS2-Requests-Tier2,GetObject,,mybucket,25889.00000000