nitsMoonbords MInt
    Updated 2022-04-25
    -- select from_address, count (*) as minted_count from ethereum_core.fact_transactions where ETH_VALUE = '2.5' and status = 'SUCCESS' and to_address = lower('0x23581767a106ae21c074b2276D25e5C3e136a68b') group by from_address order by minted_count desc
    -- select from_address, count (*) as minted_count
    SELECT date(block_timestamp) as day, count(*) as total_mints, count(DISTINCT from_address) as number_of_addresses_minting, sum(number_of_addresses_minting) over (order by day) as
    cumulative_number_of_addresses_minting , sum(total_mints) over (order by day) as cumulative_mints
    -- SELECT *
    from ethereum_core.fact_transactions
    -- where tx_hash = '0x0518e5800df5d52f6e968638761f472afecabdea1654ccb9a6d63128a2227890'
    where
    (ORIGIN_FUNCTION_SIGNATURE='0x0dfd025a' or origin_function_signature = '0x63a782f5' )and
    status = 'SUCCESS' and to_address = lower('0x23581767a106ae21c074b2276D25e5C3e136a68b')
    -- and tx_hash = '0x096ab395b1b1372c37e99bcde753ccf79513ad55e5a68345be1c7f46b8a4cecd'
    group by 1
    -- LIMIT 10
    Run a query to Download Data