Query editor
with eth_price as (select date_trunc('day', minute) as day, avg(price) as pricefrom prices.usdwhere symbol = 'ETH'and contract_address is nullgroup by 1having date_trunc('day', minute) >= date '2024-12-01'),sol_price as (select day, pricefrom prices.usd_dailywhere blockchain = 'solana'and symbol = 'SOL'and day >= date '2025-05-10'),fart_price as (select day, pricefrom prices.usd_dailywhere blockchain = 'solana'and symbol = 'FARTCOIN'and day >= date '2025-05-10'),btc as (select day, amount, amount_usdfrom balances_bitcoin.satoshi_daywhere wallet_address = 'bc1pdwu79dady576y3fupmm82m3g7p2p9f6hgyeqy0tdg7ztxg7xrayqlkl8j9'),eth as (select date_trunc('day', block_time) as day, max(balance) as amountfrom tokens_ethereum.balanceswhere 1=1and address = 0xBEa9f7FD27f4EE20066F18DEF0bc586eC221055Aand token_standard = 'native'group by 1),sol as (select day, sol_balance as amountfrom solana_utils.daily_balanceswhere 1=1and address = '9SLPTL41SPsYkgdsMzdfJsxymEANKr5bYoBsQzJyKpKS'),fart as (select day, token_balance as amountfrom solana_utils.daily_balanceswhere 1=1and address = 'ErJLDKQy1Jna9m1LpbLJEXGiEc6yDFxkBu1mXAEZea5o'