alessio9567Opensea Payment methods on Polygon
Updated 2022-07-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT contract_address
,CASE WHEN contract_address = '0x8f3cf7ad23cd3cadbd9735aff958023239c6a063' THEN 'DAI' -- DAI on Polygon token address
WHEN contract_address = '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' THEN 'WETH' -- WETH on Polygon token address
WHEN contract_address = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' THEN 'USDC' -- USDC on Polygon token address
END AS token
,date_trunc('day',block_timestamp)
,COUNT(*)
FROM polygon.core.fact_token_transfers
WHERE to_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
AND block_timestamp > CURRENT_TIMESTAMP - interval '1 month'
GROUP BY 1,2,3
Run a query to Download Data