terencelzwURA token holders
Updated 2023-11-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
with raw as (
select
sender, receiver, sum(amount) amt
from terra.core.ez_transfers
where currency= 'factory/terra1kkv72sv5zfx539garpych7x5xuq9m9d2a9dnvt863gk3n3g02husc2vxeu/URA'
group by 1,2),
inflow as (
select
receiver as address, amt
from raw),
outflow as (
select
sender as address, amt * -1
from raw
),
total as (
(select * from inflow) union all (select * from outflow)
),
balances as (
select
address, sum(amt) balance
from total
group by 1 order by 2 desc)
select * from balances
Run a query to Download Data