MLDZMNSummary of contribution and matched funds
    Updated 2023-07-26
    with projects as (
    select 'EJLdiLBgdZQ8j8ANawZqpb9iB2t3NP3iVCeh3JA8Ft3s' as address, 'CAVYAR' as project union all
    select 'xoEhFjEinwKbAtPWRUGePcvbd8ZnQ3gYynyguHwrBr9' as address, 'Cubik' as project union all
    select '4wdY2XpJKRRxWmDdEHPKgHSPaE5bUJnCSjjw65eFf2x4' as address, 'Fetcch' as project union all
    select '5yWszmTvoiWhJ2X1gdvkUtwzowxeDuCQSeSwwZqpx7oA' as address, 'Soda' as project union all
    select '2LYpAa2F55jimCbdKrKjZE4AFTbAs4r3oBTUY2QjFe6g' as address, 'Re:naissance' as project union all
    select 'B7NTVBcFpXvuT3K6Lk54vmkemNhWwr7VAtGTVNnSyXhS' as address, 'Session Keys' as project union all
    select 'Ea6sE5JYweU7W6wRkwfRw74HrNC36RJhttXk7r4wGkcs' as address, 'Solsend' as project union all
    select '73AJG869PUntaUyZ8H2tDKd74wZ6QVYHqMD3n6on9PAS' as address, 'Arsnal' as project union all
    select '9LDTG2zYanqvxHiGQsGxCvAxsAfBcGhdCwFjtWiDhZjY' as address, 'StartOnWormhole' as project union all
    select '8ijGsQBJqy8H2BFHsafRARth9LQSiXNjTdautKsvbtDY' as address, 'Tinydancer' as project union all
    select 'HtfqrZ6CY1VMbfJtRxXzZkp9a74eLKHdt6Bc7vasj2Kk' as address, 'OpenBook' as project union all
    select '6eiQJAjq8Vo2WyCaoP35uTSbCzggV4av83uj2VdDayDQ' as address, 'GraphQLana' as project union all
    select 'DRYFVFfBBcavxRZEtKUz9oAt7TPJ9W17AX2bSJZUpzXB' as address, 'SIMD research' as project union all
    select '9tusixcaw3Qv6ZbFGQGxz5G5Jeh7k26RqegkRbEZo1CA' as address, 'Solex' as project union all
    select 'xoEhFjEinwKbAtPWRUGePcvbd8ZnQ3gYynyguHwrBr9' as address, 'Solana Unity SDK' as project union all
    select '5TtrUDiHGP3TjeQmcBZu2FLCzBeUzUgsaPBh9THrbYGT' as address, 'Saganize' as project union all
    select 'CEfbK6rugjYyEzzfUissPiGNbBvZGXymuVomxvXNLp1m' as address, 'HotKeys' as project union all
    select '6vBdbXsaetZpuqFvAW4m9VktjikKKhowQk6PkSU9SduN' as address, 'SolDisperse' as project union all
    select 'GBA264tMDtgypmMgb5DZuzQW2aBx4cgzsD8JvCnZtjSF' as address, 'Phase Labs' as project union all
    select '7Eammqr9HC5HhaRhy6XoFZSyXcWmWugLrykXaeBbxaC1' as address, 'AnchorPy' as project union all
    select 'G2rz6P2figvjyoueX22AkqgL8vJCAoURTeTSzF8LRNK9' as address, 'Solathon' as project union all
    select '5dUakZngdms3U87mYa2H4tNkdr6ueLvhK5adhjuvFy1J' as address, 'Espresso Cash' as project
    ),


    t1 as (select
    RECORDED_HOUR as hour,
    avg(close) as price_sol
    from solana.core.fact_token_prices_hourly
    where SYMBOL ilike 'sol'
    group by 1),

    t2 as (select
    count(distinct tx_id) as "Contributors",
    sum(transfer.amount) as "Total Contribution in SOL",
    Run a query to Download Data