Abbas_ra21increasing volume
    Updated 2022-06-28
    select
    sum(value_asset),
    case
    when CONTRACT_ADDRESS='0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then 'USDC'
    when CONTRACT_ADDRESS='0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' then 'WETH'
    when CONTRACT_ADDRESS='0xc2132d05d31c914a87c6611c10748aeb04b58e8f' then 'USDT'
    when CONTRACT_ADDRESS='0x8f3cf7ad23cd3cadbd9735aff958023239c6a063' then 'DAI'
    when CONTRACT_ADDRESS='0xa3fa99a148fa48d14ed51d610c367c61876997f1' then 'miMatic'
    end asset
    from (
    select TX_HASH,
    RAW_AMOUNT,
    CONTRACT_ADDRESS,
    CASE
    when CONTRACT_ADDRESS='0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then RAW_AMOUNT/1e6
    when CONTRACT_ADDRESS='0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' then RAW_AMOUNT/1e18
    when CONTRACT_ADDRESS='0xc2132d05d31c914a87c6611c10748aeb04b58e8f' then RAW_AMOUNT/1e6
    when CONTRACT_ADDRESS='0x8f3cf7ad23cd3cadbd9735aff958023239c6a063' then RAW_AMOUNT/1e18
    when CONTRACT_ADDRESS='0xa3fa99a148fa48d14ed51d610c367c61876997f1' then RAW_AMOUNT/1e18
    end as value_asset
    FROM polygon.core.fact_token_transfers
    WHERE ORIGIN_FUNCTION_SIGNATURE='0xded700a6' AND ORIGIN_TO_ADDRESS='0x059d306a25c4ce8d7437d25743a8b94520536bd5'
    AND BLOCK_TIMESTAMP > DateAdd(d, -29, GetDate()))
    group by asset
    Run a query to Download Data