Pine Analyticsslow-coral
Updated 2025-03-08
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc('week', block_timestamp) as week,
count(distinct from_address) as swappers,
count(Distinct tx_id) as transactions,
sum(case when not FROM_AMOUNT_USD is null then FROM_AMOUNT_USD else to_AMOUNT_USD end) as swap_volume_Usd
from maya.defi.fact_swaps
group by 1
QueryRunArchived: QueryRun has been archived