flipside

    2024-05-31 PAC dex fees
    nasdfajsklj2024-05-31 PAC dex fees
    Updated 2024-05-31
    with addresses as (
    select lower(address) as address from (
    values
    ('0x6460D14DbAeb27AEfec8eBeF85dB35DefA31c3b9'),
    ('0x27213E28D7fDA5c57Fe9e5dD923818DBCcf71c47'),
    ('0x163c5e051049e92915017fe7bb9b8ce6182bcbb1'),
    ('0x37a8f295612602f2774d331e562be9e61B83a327'),
    ('0x7ffc3dbf3b2b50ff3a1d5523bc24bb5043837b14'),
    ('0x067170777ba8027ced27e034102d54074d062d71'),
    ('0x34eCdAd9090CD133e63Cf6670f3A03Aa7F04fa74'),
    ('0X5a509e3fbf5eFCdfE9c3E9a0eb56B1a036AB8e23'),
    ('0xe9F2DCfDbb31149b02A520f8bABD89227A0C6568'),
    ('0xd4ce1f1b8640c1988360a6729d9a73c85a0c80a3'),
    ('0xce946931adf7afc0797de2a76270a28458f487ed'),
    ('0x000000fee13a103A10D593b9AE06b3e05F2E7E1c')
    ) as t(address)
    )
    ,pacholders as (
    select lower(address) as address from (
    values
    -- ('0x1dd4fb074e9f28ca9d21c93e0aa915b487893b1c') ,('0x14c5766f8556683af2d8023e389837044794795a') ,('0x0301079dabdc9a2c70b856b2c51aca02bac10c3a') ,('0x38834c50d271b8b755493f9845b9f9b64920638a') ,('0x000000000000000000000000000000000000dead') ,('0x35cffd490fa1f20c7fadb669067e4cf289bd61a2') ,('0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7') ,('0x6e3d09ffd8d35604652e74f7128f08c8474365d6') ,('0xebb74b95f8598e56db85c8e0ac1160b62d012776') ,('0x046299143a880c4d01a318bc6c9f2c0a5c1ed355') ,('0x02df485037c08c3743c182636987c1452cf2e7f9') ,('0x937237c6cef410395825fd431a702be7f785f24d') ,('0x11ddd59c33c73c44733b4123a86ea5ce57f6e854') ,('0x72ff64fb5176d245e6f52585c20dbce67544c9c0') ,('0x6a372dbc1968f4a07cf2ce352f410962a972c257') ,('0xd973506bf52c2cfa89f92deb75f2d85b139e35fa') ,('0xf39cfb4997a8b23248f64a3cd88027d61229d840') ,('0x6ed9ba4dc8985e949742482df288f92b156b331a') ,('0xe0104fcbcf4346fb07df05b51f04cbba6a210ed5') ,('0x798de49488a1d4642d80dee1b700802fd1953060') ,('0xf8b1ee004c9b133064011bc6cc50fc6648fda05d') ,('0xea51c9153918dd95ba7111217894a039bde0bcf3') ,('0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e') ,('0x275a8d31bc87d5664249db312001310a058b800e') ,('0xc972fae6b524e8a6e0af21875675bf58a3133e60') ,('0xa418b2d220a080f38eb11c6eb462a44e505b26f1') ,('0x4d08a6fe192bc9059c9db5d9e9b33b12711f7966') ,('0x3301e6962d352a4f36c1932affbad736023a4ce5') ,('0x791742d6adcdac361b1ab061fe8998055e46e46b') ,('0x55aeff15b1f37c5d180f3350a56cc9cd6a6a6602') ,('0x384877cbe1d3187c34fff2b7d699902820a7a190') ,('0xab9d0066b928d0dbd0abf5d402167412b7010d24') ,('0xf4a1430b733cf5666054c6d735423c37a448d0c6') ,('0x13a22a2130dabeb69da14ed2cf8b6348430490e2') ,('0x064be19d55d34dc276ee2a754c26a6ddc7dfb750') ,('0x7802d4044d38b41235e553939aa8afb9bf301fab') ,('0x1711d0178c219f33428614163f50275a8954793b') ,('0x6131b5fae19ea4f9d964eac0408e4408b66337b5') ,('0x14928c304c54b3003a7f575ee8249c55281aad6e') ,('0xb46e33870a3c3fd65d926f480a51e34c60a2bdcb') ,('0x69d3158a17e11fbbdb2a0e7e8bd05ac3628e3630') ,('0x6aabc8c425ddda3371d9fa7230f1ab77fad4d366') ,('0xbebebeb035351f58602e0c1c8b59ecbff5d5f47b') ,('0xaada4bf9e31dbe3d3de04ff90c4a670b88483e0a') ,('0xe82e60015d957f9881439d63508101e0ee26673f') ,('0x08ce2914e6d86b46a0e1f96815b21cec831d6790') ,('0x90649222cbd82ea2fbd6f99848cf474dac51f71b') ,('0x301810bc9e485f18ae64a3e0fbed5cb3feb37679'
    ) as t(address)
    )
    ,data as (
    select
    block_timestamp::date as date,
    date_trunc('week', block_timestamp)::date as week,
    chain,
    amount_usd,
    origin_to_address
    from (
    select block_timestamp, amount_usd, origin_to_address, 'ETH' as chain
    from ethereum.core.ez_token_transfers
    where to_address in (select address from addresses)
    and origin_from_address not in (select address from addresses)
    QueryRunArchived: QueryRun has been archived