mmdrezaDaily Transactions of users after bridged to Polygon
    Updated 2022-07-30
    select date_trunc('day',block_timestamp)as date,project_name,count(tx_hash) as transactions
    from polygon.core.fact_token_transfers
    join polygon.core.dim_labels on address = contract_address
    where origin_from_address = lower('0x0000000000000000000000000000000000000000')
    or origin_to_address = lower('0x0000000000000000000000000000000000000000')
    group by date,project_name
    order by date asc


    Run a query to Download Data