Updated 2024-11-29
    with

    pricet as (
    select
    hour::date as date,
    avg(price) as price_usd
    from
    flow.price.ez_prices_hourly
    where
    symbol = 'FLOW'
    group by 1
    ),

    main as (
    select
    tx_hash,
    block_timestamp,
    from_address as user,
    value as amount,
    'Stake' as event_name
    from
    flow.core_evm.fact_transactions
    where
    status = 'SUCCESS'
    and to_address = '0xFE8189A3016cb6A3668b8ccdAC520CE572D4287a'
    and tx_succeeded

    union all

    select
    tx_hash,
    block_timestamp,
    origin_from_address as user,
    utils.udf_hex_to_int('s2c', substring(data, 0, 66))::bigint / 1e18 as amount,
    'Unstake' as event_name
    from
    QueryRunArchived: QueryRun has been archived