maybeyonascons_dao_top_contribute
    Updated 2022-01-23
    with
    cons_deposits as (
    select
    block_timestamp,
    tx_id,
    event_inputs:caller::string as user,
    event_inputs:amount/pow(10,18) as eth_deposit
    from ethereum.events_emitted
    where event_removed = 'FALSE'
    and event_name = 'Pay'
    and event_inputs:projectId = 36
    and tx_to_address = '0xd569d3cce55b71a8a3f3c418c329a66e5f714431'
    ),
    people_redeems as (
    select
    block_timestamp,
    tx_id,
    event_inputs:holder::string as user,
    event_inputs:amount/pow(10,18) as people
    from ethereum.events_emitted
    where event_removed = 'FALSE'
    and event_name = 'Redeem'
    and event_inputs:preferUnstaked::string = 'false'
    and event_inputs:projectId = 36
    and tx_to_address = '0xd569d3cce55b71a8a3f3c418c329a66e5f714431'
    ),
    eth_withdraws as (
    select
    block_timestamp,
    tx_id,
    event_inputs:caller::string as user,
    event_inputs:amount/pow(10,18) as amount
    from ethereum.events_emitted
    where event_removed = 'FALSE'
    and event_name = 'Tap'
    and event_inputs:projectId = 36
    Run a query to Download Data