RhoninUser Behavior flow swaps
Updated 2022-06-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with swaps as (
SELECT
tx_id,
block_timestamp,
swap_contract,
trader,
token_out_amount,
token_out_contract,
token_in_amount,
token_in_contract,
contract_name
FROM flow.core.fact_swaps a
INNER JOIN flow.core.dim_contract_labels b on a.token_out_contract = b.event_contract
)
SELECT
date_trunc('day', block_timestamp) as day,
contract_name,
sum(token_out_amount) as swap_volume,
count(tx_id) as swap_tx
FROM swaps
GROUP BY 1,2
Run a query to Download Data