PoolTogether

PoolTogether is a crypto-powered savings protocol based on Premium Bonds. Save money and have a chance to win every week.

• Deposit money for a chance to win
• Prizes are awarded every day
• Even if you don't win, keep all of your money!

PoolTogether Links

• PoolTogether
• Tools
• Docs
• App

Description of work

In this Ethereum Bounties we want to check the USDC amount deposited to PoolTogether in the last month (last 30 days). To do this, we examine the following:

• How much USDC did users deposit into PoolTogether in the last month?
• What’s the average deposit amount per user?

Note

• We use the [ethereum.core] schema and [ez_token_transfers] table.
• PoolTogether contract address for deposit is 0xd89a09084555a7D0ABe7B111b1f78DFEdDd638Be
  • etherscan
  • Sample transaction
• To be able to get the list of transfers related to USDC deposit to PoolTogether, we use:
  • to_address = '0xd89a09084555a7d0abe7b111b1f78dfeddd638be' ---> PoolTogether
  • contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' ---> USDC Coin
    • etherscan
  • origin_function_signature = '0xffaad6a5' ---> Deposit To Method

1 ---> How much USDC did users deposit into PoolTogether in the last month?

To do this, we firs get all raw transfer for USDC deposit to PoolTogether in the last month and compare with etherscan transaction

According to the results, it is clear that:

• In the last month, 11 transactions have been registered to deposit USDC to PoolTogether, which is exactly the same as etherscan transactions. So we will continue the analysis

According to the results, it is clear that:

• In last months, the total amount of USDC deposited to PoolTogether is 1915808.367948 USDC
• The highest amount of USDC deposited to PoolTogether is on Jun 2 with 848854.13647 USDC. Approximately 44.3% of the total amount

2 ---> What’s the average deposit amount per user?

According to the results, it is clear that:

• The highest amount of USDC deposited to PoolTogether is related to the wallet address 0x8558f502887a9a52c4b265d72327e0e529ff790d with 848854.13647 USDC. Approximately 44.3% of the total amount ---> Interestingly, this happened on Jun 2, where the highest value is observed
• The total amount of USDC deposited to PoolTogether is 1915808.367948 USDC and total distinct wallet that deposited USDC to PoolTogether is 8 wallet. so Average deposited amount per user is 239476.0459935