# EC2
This query creates the table. Then to populate it, I use the EC2 pricing data from the [[AWS Pricing API - study#CSV]] script.
```SQL
CREATE TABLE ec2_pricing (
"SKU" TEXT,
"OfferTermCode" TEXT,
"RateCode" TEXT,
"TermType" TEXT,
"PriceDescription" TEXT,
"EffectiveDate" TEXT,
"StartingRange" TEXT,
"EndingRange" TEXT,
"Unit" TEXT,
"PricePerUnit" numeric,
"Currency" TEXT,
"LeaseContractLength" TEXT,
"PurchaseOption" TEXT,
"OfferingClass" TEXT,
"Product Family" TEXT,
"serviceCode" TEXT,
"Location" TEXT,
"Location Type" TEXT,
"Instance Type" TEXT,
"Current Generation" TEXT,
"Instance Family" TEXT,
"vCPU" numeric,
"Physical Processor" TEXT,
"Clock Speed" TEXT,
"Memory" TEXT,
"Storage" TEXT,
"Network Performance" TEXT,
"Processor Architecture" TEXT,
"Storage Media" TEXT,
"Volume Type" TEXT,
"Max Volume Size" TEXT,
"Max IOPS/volume" TEXT,
"Max IOPS Burst Performance" TEXT,
"Max throughput/volume" TEXT,
"Provisioned" TEXT,
"Tenancy" TEXT,
"EBS Optimized" TEXT,
"Operating System" TEXT,
"License Model" TEXT,
"Group" TEXT,
"Group Description" TEXT,
"Transfer Type" TEXT,
"From Location" TEXT,
"From Location Type" TEXT,
"To Location" TEXT,
"To Location Type" TEXT,
"usageType" TEXT,
"operation" TEXT,
"AvailabilityZone" TEXT,
"CapacityStatus" TEXT,
"ClassicNetworkingSupport" TEXT,
"Dedicated EBS Throughput" TEXT,
"ECU" TEXT,
"Elastic Graphics Type" TEXT,
"Enhanced Networking Supported" TEXT,
"From Region Code" TEXT,
"GPU" TEXT,
"GPU Memory" TEXT,
"Instance" TEXT,
"Instance Capacity - 10xlarge" TEXT,
"Instance Capacity - 12xlarge" TEXT,
"Instance Capacity - 16xlarge" TEXT,
"Instance Capacity - 18xlarge" TEXT,
"Instance Capacity - 24xlarge" TEXT,
"Instance Capacity - 2xlarge" TEXT,
"Instance Capacity - 32xlarge" TEXT,
"Instance Capacity - 4xlarge" TEXT,
"Instance Capacity - 8xlarge" TEXT,
"Instance Capacity - 9xlarge" TEXT,
"Instance Capacity - large" TEXT,
"Instance Capacity - medium" TEXT,
"Instance Capacity - metal" TEXT,
"Instance Capacity - xlarge" TEXT,
"instanceSKU" TEXT,
"Intel AVX Available" TEXT,
"Intel AVX2 Available" TEXT,
"Intel Turbo Available" TEXT,
"MarketOption" TEXT,
"Normalization Size Factor" TEXT,
"Physical Cores" TEXT,
"Pre Installed S/W" TEXT,
"Processor Features" TEXT,
"Product Type" TEXT,
"Region Code" TEXT,
"Resource Type" TEXT,
"serviceName" TEXT,
"SnapshotArchiveFeeType" TEXT,
"To Region Code" TEXT,
"Volume API Name" TEXT,
"VPCNetworkingSupport"
)
```