binhachonTop Kashi Pairs III
    Updated 2022-05-22
    with contract_address as (
    select
    address,
    decimals,
    symbol,
    lower(contract_metadata:asset::string) as asset,
    lower(contract_metadata:collateral::string) as collateral
    from flipside_prod_db.ethereum_core.dim_contracts
    where symbol like '%km%'
    and symbol like '%/%-%'
    ),
    token_balance as (
    select
    contract_address,
    sum(case when from_address = '0x0000000000000000000000000000000000000000' then raw_amount else -raw_amount end) as raw_amount
    from flipside_prod_db.ethereum_core.fact_token_transfers
    where contract_address in (select address from contract_address)
    and (from_address = '0x0000000000000000000000000000000000000000' or to_address = '0x0000000000000000000000000000000000000000')
    group by 1
    ),
    token_balance_1 as (
    select
    contract_address,
    symbol,
    asset,
    collateral,
    raw_amount --/pow(10, decimals) as amount
    from token_balance
    left join contract_address on (contract_address = address)
    ),
    mint_burn_transactions as (
    select
    block_timestamp,
    tx_hash,
    contract_address as kashi_token,
    raw_amount as raw_kashi_amount
    Run a query to Download Data