0xHaM-dvalue of the Lil Nouns DAO to Nouns DAO
    Updated 2022-07-03
    select
    block_timestamp::date as date,
    'Lil Nouns in the Nouns DAO treasury' as status,
    event_inputs:winner as winner,
    count(DISTINCT tx_hash) as tx_count,
    sum(tx_count) over (order by date asc) as cum_growth_tx_count,
    sum(event_inputs:amount/1e18) as mint_value,
    sum(mint_value) over (order by date asc) as cum_growth_mint_value
    from ethereum.core.fact_event_logs
    where event_inputs:nounId in (select tokenid from ethereum.core.ez_nft_transfers
    where nft_address = lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')
    and nft_to_address = '0x0bc3807ec262cb779b38d65b38158acc3bfede10')
    and event_name = 'AuctionSettled'
    and tx_status = 'SUCCESS'
    group by 1, 2, 3

    UNION
    select
    block_timestamp::date as date,
    'Lil Nouns DAO to Nouns DAO' as status,
    event_inputs:winner as winner,
    count(DISTINCT tx_hash) as tx_count,
    sum(tx_count) over (order by date asc) as cum_growth_tx_count,
    sum(event_inputs:amount/1e18) as mint_value,
    sum(mint_value) over (order by date asc) as cum_growth_mint_value
    from ethereum.core.fact_event_logs
    where event_inputs:nounId in (select tokenid from ethereum.core.ez_nft_transfers
    where nft_address = lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')
    and nft_from_address = '0x0000000000000000000000000000000000000000')
    and event_name = 'AuctionSettled'
    and tx_status = 'SUCCESS'
    group by 1, 2, 3
    Run a query to Download Data