nitinpatel17hsUntitled Query
    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