rajsOpensea Polygon Daily Fees
Updated 2022-08-01
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
›
⌄
with prices as
(
SELECT
hour,
price,
decimals,
symbol
from ethereum.core.fact_hourly_token_prices
where symbol in ('WETH', 'DAI', 'USDC', 'REVV', 'MATIC')
and hour >= '2022-06-05'
-- group by 1,3,4
)
,
fees as
(
SELECT
block_timestamp,
contract_address,
case when contract_address = '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' then 'WETH'
when contract_address = '0x8f3cf7ad23cd3cadbd9735aff958023239c6a063' then 'DAI'
when contract_address = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then 'USDC'
when contract_address = '0x70c006878a5a50ed185ac4c87d837633923de296' then 'REVV'
-- when contract_address = '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' then 'WETH'
end as symbol,
raw_amount
from polygon.core.fact_token_transfers
where to_address IN ('0x5b3256965e7c3cf26e11fcaf296dfc8807c01073', '0x8de9c5a032463c561423387a9648c5c7bcc5bc90')
and block_timestamp >= '2022-06-07'
and contract_address not IN
(
'0x92face859e48c5d70510bf9bbc60a4b4c4fc8b98'
,'0x0f1f17e4260515d9bfe805cff323374eb771eae6'
,'0xe62bdf96630a7e08854039f1abc9a8db477170e8'
,'0x259ba1bc783da697f20fb25793bcc46cc39e5e30'
,'0xa2ff8015636c8c763c05fe30e9f8fcbe6dde6374'
Run a query to Download Data