HolonymzkMe vs. Holonym - Gas
    Updated 2024-11-30
    with matic_price_usd as (
    select
    hour::date as date,
    avg(price) as price_usd
    from polygon.price.ez_prices_hourly
    where token_address = '0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270'
    group by 1
    ),
    eth_daily_price as (
    select
    hour::date as date,
    avg(price) as price_usd
    from ethereum.price.ez_prices_hourly
    where symbol = 'WETH'
    group by 1
    ),
    bnb_daily_price as (
    select
    hour::date as date,
    avg(price) as price_usd
    from bsc.price.ez_prices_hourly
    where token_address = '0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c'
    and blockchain = 'bsc'
    group by 1
    ),
    zkMe_delegate_mint_on_polygon as (
    select
    block_timestamp,
    tx_hash,
    nft_to_address as wallet
    from polygon.nft.ez_nft_mints
    where nft_address = '0x3b3364656bbb7a23133e3f26d7f6850acfaac394'
    ),
    zkMe_delegate_mint_on_polygon_gas as (
    select
    mint.*,
    QueryRunArchived: QueryRun has been archived