sinahosseinzadehUntitled Query
Updated 2022-08-21
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
date_trunc('day', block_timestamp) as day,
sum(amount) as volume,
count(DISTINCT tx_hash) as events,
COUNT(DISTINCT to_address) as users
FROM ethereum.core.ez_token_transfers
WHERE contract_address LIKE lower('0x55b1e2D8b13E7acad03353FAD58fc3FA065C5822')
AND from_address LIKE lower('0xb27198a99e3ae693f4dd14cfee89e98eaf413263')
AND ORIGIN_FUNCTION_SIGNATURE LIKE '0x2e7ba6ef'
GROUP BY 1
Run a query to Download Data