sinahosseinzadehUntitled Query
Updated 2022-09-03
9
1
2
3
4
5
6
7
›
⌄
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