Query editor
WITH cloud_data AS (SELECTDate(date) AS date,total_users,total_vms,running_vms,total_vcpuFROMdune.phala_network.dataset_phala_cloudWHEREtotal_users > 0),price_data AS (SELECTday,priceFROMprices.usd_dailyWHEREblockchain = 'ethereum'AND contract_address = 0x6c5bA91642F10282b576d91922Ae6448C9d52f4EAND day IN (SELECTdateFROMcloud_data))SELECTc.date,c.total_users,c.total_vms,c.running_vms,c.total_vcpu,p.price,(c.total_vcpu * 12 * 50.0 / NULLIF(p.price, 0)) as capturedFROMcloud_data cLEFT JOIN price_data p ON c.date = p.dayORDER BYc.date DESC