binhachonActive Wallet Addresses - Rune balance
    Updated 2022-06-21
    with rune_transfer as (
    select
    block_timestamp,
    from_address as address,
    -rune_amount as amount
    from flipside_prod_db.thorchain.transfers
    where asset = 'THOR.RUNE'
    union all
    select
    block_timestamp,
    to_address as address,
    rune_amount as amount
    from flipside_prod_db.thorchain.transfers
    where asset = 'THOR.RUNE'
    ),
    rune_transfer_1 as (
    select
    date_trunc('week', block_timestamp) as time,
    address,
    sum(amount) as received_amount
    from rune_transfer
    group by 1, 2
    ),
    date_list as (
    select
    distinct time
    from rune_transfer_1
    ),
    address_list as (
    select
    distinct address
    from rune_transfer_1
    ),
    full_list as (
    select
    time,
    Run a query to Download Data