freemartianTGE Contributors copy
Updated 2023-06-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- forked from TGE Contributors @ https://flipsidecrypto.xyz/edit/queries/5960a8ef-76af-48dc-8c0f-94de1fb1f46c
-- SELECT * from optimism.core.ez_eth_transfers
-- WHERE tx_hash = '0x1f0222e7ee88acdf657a379e94c6a211b8516b28ce59d1e29dcd945772b471f4'
select
ETH_FROM_ADDRESS as Contributor,
sum(amount) as Contribution_Amount,
sum(amount_usd) as Contribution_Amount_USD,
count(tx_hash) as Contribution_count
FROM optimism.core.ez_eth_transfers
where ETH_TO_ADDRESS in('0xc67ce28d0343e5972f3b1711c32e206ab5a238d6', '0x824026ca57bca5c7c0b98f62e5d0173cd1630dad')
and ORIGIN_FUNCTION_SIGNATURE in ('0xa2e4f607', '0x2b2d4b68')
and ETH_FROM_ADDRESS = '{{Contributor_Wallet}}'
group by 1
order by Contribution_Amount DESC
Run a query to Download Data