MLDZMNSummary of contribution and matched funds
Updated 2023-07-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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