Moetera cont 1
Updated 2022-12-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with base as (
select * from
(
select
distinct tx:body:messages[0]:contract as contract_name,
block_timestamp::date as date,
row_number()over(partition by contract_name order by block_timestamp ) as n
from terra.core.fact_transactions
) where n = 1 )
SELECT
count(distinct contract_name) as new_cntct
from base
Run a query to Download Data