Zanyar_98Polygon Total
Updated 2022-09-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH Project_On_Polygon AS (
SELECT Contract_Address
FROM polygon.core.fact_event_logs
WHERE ORIGIN_TO_ADDRESS='0xc040f84cf7046409f92d578ef9040fe45e6ef4be' AND
ORIGIN_FUNCTION_SIGNATURE = '0xfa18022c' AND EVENT_NAME='AuctionTimeUpdated'),
Matics AS (
SELECT sum(amount_usd) AS ETH
FROM polygon.core.ez_matic_transfers
WHERE ORIGIN_TO_ADDRESS IN (SELECT Contract_Address FROM Project_On_Polygon ) AND ORIGIN_TO_ADDRESS = MATIC_TO_ADDRESS
),
OTHER_ERC20S AS (
SELECT sum(RAW_AMOUNT) AS ERC20s
FROM polygon.core.fact_token_transfers
WHERE ORIGIN_TO_ADDRESS IN (SELECT Contract_Address FROM Project_On_Polygon ) AND ORIGIN_TO_ADDRESS = TO_ADDRESS
)
SELECT * FROM Matics
-- SELECT ((SELECT ETH FROM ETHs ) + (SELECT ERC20s FROM OTHER_ERC20S))
Run a query to Download Data