danhanUntitled Query
Updated 2022-06-18
9
1
2
3
4
5
6
7
›
⌄
select
date_trunc('day',BLOCK_TIMESTAMP) as "DATE", --to group number of unique address we need to use this
count (distinct FROM_ADDRESS) as "Distinct Wallets", --count total number of individual wallets that used hop bridge
from flipside_prod_db.polygon.transactions
where to_address =lower ('0x76b22b8C1079A44F1211D867D68b1eda76a635A7')
GROUP by "DATE"
order by "DATE" desc
Run a query to Download Data