ally arbitrum supply retention final copy
    Updated 2023-03-20
    -- forked from 51ff097b-fa8f-4795-9952-a27b74d09226

    -- forked from 21fe6edd-a630-4e44-8115-d1f5d88f497d

    -- forked from cc615954-5f31-4776-9330-cc12ba946556

    -- forked from a7156281-99ea-4adf-8b70-92b82f236596

    -- forked from 4161d707-4d84-4c83-bf75-ebf25311e922

    -- forked from b1694198-bc1d-4e38-93f4-7f3bd8690220

    with
    nft_transfers as (
    select
    BLOCK_TIMESTAMP,
    tx_hash,
    ORIGIN_TO_ADDRESS as router_addrs,
    ORIGIN_FROM_ADDRESS as user
    from
    arbitrum.core.fact_event_logs
    where
    BLOCK_TIMESTAMP >= CURRENT_TIMESTAMP() - INTERVAL '13 months'
    and EVENT_NAME = 'Supply'
    ),
    gas_fees as (
    select
    tx_hash,
    BLOCK_TIMESTAMP,
    TX_FEE as fees
    from
    arbitrum.core.fact_transactions
    WHERE
    BLOCK_TIMESTAMP >= CURRENT_TIMESTAMP() - INTERVAL '13 months'
    group by
    1,
    Run a query to Download Data