freemartianDaily Stablecoins - Mainnet >>> Optimism
Updated 2022-09-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
sum(amount_usd) as stablecoin_volume,
count(distinct origin_from_address) as bridgoors_count,
count(distinct tx_hash) as bridge_count,
date_trunc('day', block_timestamp::date) as TIME,
sum(stablecoin_volume) over (order by TIME) as cumulative_volume,
sum(bridgoors_count) over (order by TIME) as cumulative_bridgoors_count,
sum(bridge_count) over (order by TIME) as cumulative_bridge_count,
symbol
from ethereum.core.ez_token_transfers
where origin_to_address in ('0x99c9fc46f92e8a1c0dec1b1747d010903e884be1', '0x10e6593cdda8c58a1d0f14c5164b376352a55f2f')
and block_timestamp > CURRENT_DATE - 120
and symbol in ('USDC','USDT', 'DAI')
group by TIME, symbol
Run a query to Download Data