kasadeghUntitled Query
    Updated 2022-12-03
    with receive_axelar as
    (
    select block_timestamp::date as date,
    tx_id,
    receiver,
    amount / pow (10,decimal) as Receive_Volume
    from axelar.core.fact_transfers
    where currency = 'uaxl'
    and transfer_type in ('AXELAR','IBC_TRANSFER_IN')
    ),

    send_axelar as
    (
    select block_timestamp::date as date,
    tx_id,
    sender,
    amount / pow (10,decimal) as Send_Volume
    from axelar.core.fact_transfers
    where currency = 'uaxl'
    and transfer_type in ('AXELAR','IBC_TRANSFER_OUT')
    ),

    holder_daily_info as
    (
    select t1.date,
    receiver as AXL_Holder,
    sum (Send_Volume) as Daily_Send_Volume,
    sum (Receive_Volume) as Daily_Receive_Volume
    from receive_axelar t1 join send_axelar t2 on t1.Date = t2.Date and t1.Receiver = t2.Sender
    group by 1,2
    ),

    holder_balance as
    (
    select date,
    AXL_Holder,
    Run a query to Download Data