amelia-leeUntitled Query
    Updated 2022-08-01
    with
    transactions as
    (
    select
    origin_from_address,
    block_timestamp
    from ethereum.core.fact_event_logs
    where origin_to_address in ('0x401f6c983ea34274ec46f84d70b31c151321188b','0xa0c68c638235ee32657e8f720a23cec1bfc77c77')
    and tx_status='SUCCESS'
    )
    select
    address_name,
    --project_name,
    --label_type,
    --label_subtype,
    count(distinct tx_hash) as counts
    from polygon.core.fact_event_logs x
    join transactions y on x.origin_from_address=y.origin_from_address
    join polygon.core.dim_labels z on x.contract_address=z.address
    and trunc(x.block_timestamp,'day')=trunc(y.block_timestamp,'day') and x.block_timestamp > y.block_timestamp
    group by 1
    order by 2 desc
    limit 10

    --adriaparcerisas
    Run a query to Download Data