Mrfti2023-06-30 12:18 AM
    Updated 2023-07-29
    (
    select
    'After KYC announcemt' kyc,
    'Kucoin to Arbitrum' path,
    date_trunc(hour, block_timestamp) as "Date",
    count(distinct tx_hash) as "Total transfers",
    count(distinct from_address) as "Total users",
    sum(raw_amount) as "Total volume"
    from
    avalanche.core.fact_token_transfers
    inner join avalanche.core.dim_labels on from_address = address
    where
    address_name like '%kucoin%'
    and block_timestamp > '2023-06-28 14:00:00.000'
    GROUP by
    3
    order by
    3
    )
    union all
    (
    select
    'Before KYC announcemt' kyc,
    'Kucoin to Arbitrum' path,
    date_trunc(hour, block_timestamp) as "Date",
    count(distinct tx_hash) as "Total transfers",
    count(distinct from_address) as "Total users",
    sum(raw_amount) as "Total volume"
    from
    avalanche.core.fact_token_transfers
    inner join avalanche.core.dim_labels on from_address = address
    where
    address_name like '%kucoin%'
    and block_timestamp between '2023-06-20 14:00:00.000' and '2023-06-28 14:00:00.000'
    GROUP by
    3
    Run a query to Download Data