headitmanagerswap volume by users over time
Updated 2022-06-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with metamask as (select distinct origin_from_address from ethereum.core.ez_dex_swaps
where origin_to_address=lower('0x881D40237659C251811CEC9c364ef91dC08D300C'))
, coinbase as (select distinct origin_from_address from ethereum.core.ez_dex_swaps
where origin_to_address=lower('0xe66B31678d6C16E9ebf358268a790B763C133750'))
,metamask_users as (select count(distinct ethereum.core.ez_dex_swaps.origin_from_address) as results from ethereum.core.ez_dex_swaps inner join metamask
on metamask.origin_from_address=ethereum.core.ez_dex_swaps.origin_from_address)
,coinbase_users as (select count(distinct ethereum.core.ez_dex_swaps.origin_from_address) as results from ethereum.core.ez_dex_swaps inner join coinbase
on coinbase.origin_from_address=ethereum.core.ez_dex_swaps.origin_from_address)
,metamask_transactionvolume as (select sum(eth_value) as results from ethereum.core.fact_transactions inner join metamask
on metamask.origin_from_address=ethereum.core.fact_transactions.from_address)
,coinbase_transactionvolume as (select sum(eth_value) as results from ethereum.core.fact_transactions inner join coinbase
on coinbase.origin_from_address=ethereum.core.fact_transactions.from_address)
,metamask_transactionvolume_overtime as (select sum(eth_value) as val,block_timestamp::date from ethereum.core.fact_transactions inner join metamask
on metamask.origin_from_address=ethereum.core.fact_transactions.from_address
where year(block_timestamp::date)=2022
group by block_timestamp::date)
,coinbase_transactionvolume_overtime as (select sum(eth_value) as val,block_timestamp::date from ethereum.core.fact_transactions inner join coinbase
on coinbase.origin_from_address=ethereum.core.fact_transactions.from_address
where year(block_timestamp::date)=2022
group by block_timestamp::date)
,metamask_avgswapamount_overtime as (select avg(amount_in_usd) as val,block_timestamp::date from ethereum.core.ez_dex_swaps inner join metamask
on metamask.origin_from_address=ethereum.core.ez_dex_swaps.origin_from_address
where year(block_timestamp::date)=2022 and amount_in_usd < 10000000000
group by block_timestamp::date)
,coinbase_avgswapamount_overtime as (select avg(amount_in_usd) as val,block_timestamp::date from ethereum.core.ez_dex_swaps inner join coinbase
on coinbase.origin_from_address=ethereum.core.ez_dex_swaps.origin_from_address
where year(block_timestamp::date)=2022 and amount_in_usd < 10000000000
group by block_timestamp::date)
,metamask_fee_overtime as (select sum(tx_fee) as val,block_timestamp::date from ethereum.core.fact_transactions inner join metamask
on metamask.origin_from_address=ethereum.core.fact_transactions.from_address
where year(block_timestamp::date)=2022
Run a query to Download Data