nitinpatel17hsUntitled Query
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 * from cosmos.core.dim_labels limit 10
select * from cosmos.core.dim_tokens limit 10
select * from cosmos.core.fact_blocks limit 10
select * from cosmos.core.fact_msg_attributes limit 10
select * from cosmos.core.fact_msgs limit 10
select * from cosmos.core.fact_transactions where tx_id = '12BED3A3CE6E3F2DA57596DD83E33E9A66430338E53701D6023AA99EF8421702'
select * from cosmos.core.fact_transactions where fee <> 0
cosmos.core.fact_transactions
select date(date_trunc('month' , ft.block_timestamp)) as mnth,
count(distinct ft.UNIQUE_KEY) as transactions
from cosmos.core.fact_transactions ft
where date(ft.block_timestamp) >= date('2021-01-01')
group by 1
order by 1
select date(date_trunc('month' , ft.block_timestamp)) as mnth,
Run a query to Download Data