DB_Reward distributions
Updated 2024-06-02
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
select
date_trunc('day', block_timestamp) as date,
sum(
case
when currency = 'uluna' then amount / 1000000
else 0
end
) as luna,
sum(
case
when currency = 'ibc/C17F17047DCB2187CA917A5C9FE99E9AF5B17760BF7D0C2274B5AE0961F02E15' then amount / 1000000
else 0
end
) as GUPPY,
sum(
case
when currency = 'ibc/517E13F14A1245D4DE8CF467ADD4DA0058974CDCC880FA6AE536DBCA1D16D84E' then amount / 1000000
else 0
end
) as bWHALE,
sum(
case
when currency = 'ibc/B3F639855EE7478750CC8F82072307ED6E131A8EFF20345E1D136B50C4E5EC36' then amount / 1000000
else 0
end
) as ampWHALE,
sum(
case
when currency = 'ibc/05D299885B07905B6886F554B39346EA6761246076A1120B1950049B92B922DD' then amount / 1000000
else 0
end
) as wBTC,
sum(
case
when currency = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp' then amount / 1000000
else 0
QueryRunArchived: QueryRun has been archived