binhachonUser Activity - #1
    Updated 2022-06-11
    with vault_data as (
    select
    event_inputs:assetAddress::string as assetAddress,
    event_inputs:vaultAddress::string as vaultAddress,
    event_inputs:vaultId::int as vaultId
    from ethereum.core.fact_event_logs
    where event_name = 'NewVault'
    and contract_address = '0xbe86f647b167567525ccaafcd6f881f1ee558216'
    and tx_status = 'SUCCESS'
    ),
    vault_transactions as (
    select
    vault_data.*,
    tx_hash,
    'Provide liquidity' as actions
    from ethereum.core.fact_token_transfers
    inner join vault_data on (vaultAddress = contract_address)
    where from_address = '0x0000000000000000000000000000000000000000'
    and block_timestamp::date >= getdate() - interval'60 days'
    union all
    select
    vault_data.*,
    tx_hash,
    'Remove liquidity' as actions
    from ethereum.core.fact_token_transfers
    inner join vault_data on (vaultAddress = contract_address)
    where to_address = '0x0000000000000000000000000000000000000000'
    and block_timestamp::date >= getdate() - interval'60 days'
    ),
    top3_vaults as (
    select
    vaultID,
    count(distinct tx_hash) as number_of_actions
    from vault_transactions
    group by 1
    order by 2 desc
    Run a query to Download Data