flipside

    User's First Interaction DefI copy copy copy
    Kruys-CollinsUser's First Interaction DefI copy copy copy
    Updated 2024-10-17

    WITH base AS (
    SELECT
    ft.block_timestamp,
    ft.from_address,
    ft.tx_hash,
    ft.gas_price,
    ft.gas_used,
    ft.to_address,
    dl.address,
    dl.address_name,
    dl.project_name,
    dl.label_subtype,
    dl.label_type,
    el.contract_address,
    el.contract_name,
    el.decoded_log,
    el.event_name,
    el.event_index
    FROM avalanche.core.fact_transactions ft
    LEFT JOIN avalanche.core.dim_labels dl
    ON ft.to_address = dl.address
    LEFT JOIN avalanche.core.ez_decoded_event_logs el ON ft.tx_hash = el.tx_hash
    WHERE
    status = 'SUCCESS'
    AND contract_address = '0x483416eb3afa601b9c6385f63cec0c82b6abf1fb'
    ),
    trans as (
    SELECT
    *,
    decoded_log:value::int as Value,
    Value/1e18 as amount
    FROM base
    where event_name = 'Transfer'
    ),

    QueryRunArchived: QueryRun has been archived