freemartianDeposit new
Updated 2022-08-08
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
tx_hash,
count(distinct origin_from_address) as depositors_count,
sum(amount_usd) as amount_usd,
block_timestamp::date as TIME
from ethereum.core.ez_token_transfers
where origin_to_address in ('0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9', '0x135896de8421be2ec868e0b811006171d9df802a')
and to_address = '0xffc97d72e13e01096502cb8eb52dee56f74dad7b'
and contract_address = '0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9'
and block_timestamp > CURRENT_DATE -365
group by TIME, tx_hash
Run a query to Download Data