sinahosseinzadehUntitled Query
    Updated 2022-09-03
    SELECT count(DISTINCT TO_ADDRESS) as "Unique user",count(DISTINCT Tx_hash) as "Total Tx", sum(RAW_AMOUNT/ pow(10,18)) as "Total Eth staked",
    max(RAW_AMOUNT/ pow(10,18)) as "Max Stake Amount", min(RAW_AMOUNT/ pow(10,18)) as "Min Stake Amount", avg(RAW_AMOUNT/ pow(10,18)) as "Average Stake Amount",
    median(RAW_AMOUNT/ pow(10,18)) as "Median"
    from ethereum.core.fact_token_transfers
    where ORIGIN_TO_ADDRESS = '0x4d05e3d48a938db4b7a9a59a802d5b45011bde58'
    and CONTRACT_ADDRESS = '0xae78736cd615f374d3085123a210448e74fc6393'
    and FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
    Run a query to Download Data