KaskoazulUntitled Query
    Updated 2022-03-20
    with ALLOCATIONS as (
    select block_timestamp,
    tx_id,
    origin_function_name,
    from_address,
    to_address,
    to_label_type,
    event_type,
    event_id,
    contract_address,
    symbol,
    amount
    from ethereum.udm_events
    where to_address = '0x66f4856f1bbd1eb09e1c8d9d646f5a3a193da569' --USDC Pool
    and symbol = 'USDC'
    and amount > 0
    and block_timestamp >= '2022-01-01'
    )

    select to_address,
    case to_address
    when '0x53de5a7b03dc24ff5d25ccf7ad337a0425dfd8d1' then 'pool7 - tetranode#39'
    when '0x6447026fe96363669b5be2ee135843a5e4d15b50' then 'pool14 - dai'
    when '0x241056eb034BEA7482290f4a9E3e4dd7269D4329' then 'pool11 - '
    else NULL
    end as pool_name,
    count(distinct tx_id)
    from ALLOCATIONS
    group by 1,2
    order by 3 desc



    --tx_id = '0x0da59251949251154ab0e3e8c078cf2ef1a2a28f29e08014142697235ea268ae'
    --tx_to_label = 'rari_capital'
    Run a query to Download Data