rajsMirror Crowdfund Origin Function Signatures
    Updated 2022-06-24
    select
    -- tx_json:receipt:logs[2]:decoded:inputs:editionId,
    -- tx_json:receipt:logs[2]:decoded:inputs:numSold,
    -- tx_json:receipt:logs[2]:decoded:inputs:receiver,
    -- tx_json:receipt:logs[2]:decoded:inputs:tokenId,
    -- eth_value,
    origin_function_signature,
    -- tx_hash,
    -- block_timestamp,
    count(*),
    sum(eth_value),
    min(block_timestamp)
    from ethereum.core.fact_transactions
    where to_address = '0x9f6f91078a5072a8b54695dafa2374ab3ccd603b'
    group by 1
    order by 2 desc
    -- order by block_timestamp desc
    Run a query to Download Data