Updated 2025-02-13
    with

    pricet as (
    select
    hour::date as date,
    avg(price) as token_price_usd
    from
    ronin.price.ez_prices_hourly
    where
    symbol = 'RON'
    group by 1
    ),

    main as (
    select
    tx_hash,
    block_timestamp,
    from_address as user,
    value as amount,
    utils.udf_hex_to_string(right(input_data, 128)) as domain_name
    from
    ronin.core.fact_transactions
    where
    tx_succeeded
    and to_address = '0x662852853614cbbb5d04bf2e29955b97e3c50b69'
    and domain_name is not null
    ),

    final as (
    select
    main.*,
    amount * token_price_usd as amount_usd
    from
    main
    left join
    QueryRunArchived: QueryRun has been archived