syedccomos-activity copy-messari
Updated 2024-06-11
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
›
⌄
-- forked from messari / comos-activity @ https://flipsidecrypto.xyz/messari/q/6fyvS-_RtZiZ/comos-activity
with base as (
SELECT
date(block_timestamp) as date,
fee,
fee_denom,
tx_from,
tx_succeeded
from
cosmos.core.fact_transactions
),
fees as (
select
date,
sum(fee/1000000) as fees,
'atom' as fee_denom
from
base
where
fee_denom = 'uatom'
group by
1
),
activity as (
select
date,
count(distinct tx_from) as active_addresses,
count(*) as total_transactions,
sum(
case
tx_succeeded
when true then 1
else 0
end
) as successful_transactions,
QueryRunArchived: QueryRun has been archived