adambalathor
Updated 2022-06-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with a as
(select
*
from flipside_prod_db.thorchain.transfers
where lower(FROM_ADDRESS)=lower('thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6')
and ASSET='THOR.RUNE'
and RUNE_AMOUNT > 0 )
select
date(block_timestamp) as date,
sum( RUNE_AMOUNT ) as RUNE_AMOUNT,
count( distinct TO_ADDRESS) as wallet,
sum( RUNE_AMOUNT_usd ) as RUNE_AMOUNT_USD
from a
group by 1
Run a query to Download Data