MrftiGyroscope Proto Version (Transactions)
Updated 2024-01-16
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
›
⌄
-- forked from Protocol mint and redeem analysis @ https://flipsidecrypto.xyz/edit/queries/c05c3db8-d25a-48e3-964e-a5586b51cdf1
(
SELECT
'3clp usdt/busd/usdc redeem transactions' as task,
count (DISTINCT tx_hash) as "Transaction count"
from
polygon.core.fact_token_transfers
where
contract_address = '0x17f1ef81707811ea15d9ee7c741179bbe2a63887' -- 3clp contract
and from_address = '0x68bdee1bf95ad730f379a05eb8c51fb5dfa07748'
and to_address = origin_from_address
)
union all
(
SELECT
'P-GYD mint from 3clp usdt/busd/usdc transactions' as task,
count (DISTINCT tx_hash) as "Transaction count"
from
polygon.core.fact_token_transfers
where
contract_address = '0x17f1ef81707811ea15d9ee7c741179bbe2a63887' -- 3clp contract
and from_address = '0x68bdee1bf95ad730f379a05eb8c51fb5dfa07748'
and to_address = '0x1e6aff38a1a908b71ad36834895515c9cf3b786b' --3clp vault contract
)
union all
(
SELECT
'E-clp tusd/usdc redeem transactions' as task,
count (DISTINCT tx_hash) as "Transaction count"
from
polygon.core.fact_token_transfers
where
QueryRunArchived: QueryRun has been archived