isabelhendrickjop3-1
Updated 2022-09-02
999
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 staker_30_days_pusdc as (
SELECT
origin_from_address as staker
, block_timestamp
, tx_hash
, raw_amount/1e8 as pusdc_stake_amount
FROM
optimism.core.fact_token_transfers
WHERE
-- tx_hash = '0x1ba43f1c727ba7fc4a6edf6bf6cdc3175edc16b87f404220d2c92e316fe2ff0b'
origin_function_signature = '0xa694fc3a' -- Stake
and origin_to_address = '0x3ce5af2d1455c581d95b979ab7e64b1a7d1b5537' -- 30 Days LockDrop Pool Address
and contract_address = '0x811cd5cb4cc43f44600cfa5ee3f37a402c82aec2' -- pUSDC Address 0x6f620ec89b8479e97a6985792d0c64f237566746
) , staker_30_days_wpc as (
SELECT
tx_hash
, raw_amount/1e18 as wpc_reward_amount
FROM
optimism.core.fact_token_transfers
WHERE
-- tx_hash = '0x1ba43f1c727ba7fc4a6edf6bf6cdc3175edc16b87f404220d2c92e316fe2ff0b'
origin_function_signature = '0xa694fc3a' -- Stake
and origin_to_address = '0x3ce5af2d1455c581d95b979ab7e64b1a7d1b5537' -- 30 Days LockDrop Pool Address
and contract_address = '0x6f620ec89b8479e97a6985792d0c64f237566746' -- WPC Address
) , stakers_30_days_info as (
select
*
from
staker_30_days_pusdc left outer join staker_30_days_wpc using(tx_hash)
) , daily_30_days_stats as (
select
distinct block_timestamp::date as DAY
, '30 Days Pool' as pool
, sum(pusdc_stake_amount) over(partition by DAY) as daily_stake_amount
Run a query to Download Data