SocioCryptobalances
Updated 2023-05-09Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT avg(balance)/pow(10,18) as ETH_balance
FROM
(SELECT block_timestamp,
origin_from_address
FROM ethereum.core.fact_event_logs
WHERE contract_address = '0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'
AND event_name = 'VoteCast'
AND tx_status = 'SUCCESS'
) a
LEFT JOIN ethereum.core.fact_eth_balances b
ON date_trunc('day', a.block_timestamp) = date_trunc('day', b.block_timestamp) AND a.origin_from_address = b.user_address
Run a query to Download Data