SocioCryptoATOM Transfer
Updated 2023-02-21
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT date_trunc('week',block_timestamp) as date,
transfer_type,
count(DISTINCT sender) as sender,
count(DISTINCT receiver) as receiver,
sum(amount)/pow(10,6) as t_amnt,
avg(amount)/pow(10,6) as avg_amnt
FROM cosmos.core.fact_transfers
WHERE currency = 'uatom' AND transfer_type != 'COSMOS'
AND date>='2023-01-01'
GROUP BY date, transfer_type
--WHERE tx_hash in ('Cd39zdNasmjbL2zoNGr6EMULECx6VLsrirHaujS1ZrG2')
Run a query to Download Data