freemartianECLP_USDC_TUSD
Updated 2023-03-17
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
›
⌄
-- SELECT * FROM polygon.core.fact_token_transfers
-- WHERE tx_hash = '0x23a62bb883fb9c7cbb3129ab23fdcb45edec63e3c1b8628351a36a0974c0cd5f'
with join_tx AS (
SELECT tx_hash
FROM polygon.core.fact_token_transfers
WHERE from_address = '0x0000000000000000000000000000000000000000'
AND contract_address = '0x97469e6236bd467cd147065f77752b00efadce8a'
AND origin_function_signature = '0xb95cac28'
),
exit_tx AS (
SELECT tx_hash
FROM polygon.core.fact_token_transfers
WHERE to_address = '0x0000000000000000000000000000000000000000'
AND contract_address = '0x97469e6236bd467cd147065f77752b00efadce8a'
AND origin_function_signature = '0x8bdb3913'
),
pool_join AS (
SELECT
CASE
when contract_address = '0x2e1ad108ff1d8c782fcbbb89aad783ac49586756' then sum(raw_amount)/pow(10,18)
when contract_address = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then sum(raw_amount)/pow(10,6)
end AS ECLP_USDC_TUSD_stake_amount,
CASE
when contract_address = '0x2e1ad108ff1d8c782fcbbb89aad783ac49586756' then 'TUSD'
when contract_address = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then 'USDC'
end AS Asset
FROM polygon.core.fact_token_transfers
WHERE tx_hash IN (select tx_hash from join_tx)
AND contract_address IN (
'0x2e1ad108ff1d8c782fcbbb89aad783ac49586756',
'0x2791bca1f2de4661ed88a30c99a7a9449aa84174')
AND to_address = '0xba12222222228d8ba445958a75a0704d566bf2c8'
Run a query to Download Data