drone-mostafaMonthly Swap Volume by DEX
Updated 2022-05-07
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with swap_in as ( select date_trunc('month',block_timestamp) as month, platform, count(distinct tx_id) as tx_count from ethereum.dex_swaps
where to_address in ('0xdef171fe48cf0115b1d80b88dc8eab59176fee57','0x1bd435f3c054b6e901b7b108a0ab7617c808677b','0xf90e98f3d8dce44632e5020abf2e122e0f99dfab','0x9509665d015bfe3c77aa5ad6ca20c8afa1d98989')--Paraswap v5/v4/v3/v2
and block_timestamp >= DATEADD(year, -1, CURRENT_TIMESTAMP()) group by 1,2
), swap_out as (
select date_trunc('month',block_timestamp) as month, platform, count(distinct tx_id) as tx_count from ethereum.dex_swaps
where from_address in ('0xdef171fe48cf0115b1d80b88dc8eab59176fee57','0x1bd435f3c054b6e901b7b108a0ab7617c808677b','0xf90e98f3d8dce44632e5020abf2e122e0f99dfab','0x9509665d015bfe3c77aa5ad6ca20c8afa1d98989')
and block_timestamp >= DATEADD(year, -1, CURRENT_TIMESTAMP()) group by 1,2
)
select a.month, a.platform, a.tx_count + b.tx_count as total_swap_count from swap_in a left join swap_out b on a.month = b.MONTH
Run a query to Download Data