YakuzaThe total volume of fees
Updated 2022-07-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH price AS (
select avg(Price) AS Daily_Price
from flipside_prod_db.ethereum.token_prices_hourly
where TOKEN_ADDRESS = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
AND HOUR::DATE >= '2022-06-06'
),
fees AS(
SELECT sum(RAW_AMOUNT/pow(10,18)) AS fee
FROM polygon.core.fact_token_transfers
WHERE TO_ADDRESS IN (lower('0x8De9C5A032463C561423387a9648c5C7BCC5BC90'), '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073')
AND CONTRACT_ADDRESS = '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619'
AND BLOCK_TIMESTAMP::DATE >= '2022-06-06'
)
SELECT (fee * Daily_Price) AS vol_fee
FROM price INNER JOIN fees
Run a query to Download Data