Abbas_ra21increasing volume
Updated 2022-06-28
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
›
⌄
select
sum(value_asset),
case
when CONTRACT_ADDRESS='0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then 'USDC'
when CONTRACT_ADDRESS='0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' then 'WETH'
when CONTRACT_ADDRESS='0xc2132d05d31c914a87c6611c10748aeb04b58e8f' then 'USDT'
when CONTRACT_ADDRESS='0x8f3cf7ad23cd3cadbd9735aff958023239c6a063' then 'DAI'
when CONTRACT_ADDRESS='0xa3fa99a148fa48d14ed51d610c367c61876997f1' then 'miMatic'
end asset
from (
select TX_HASH,
RAW_AMOUNT,
CONTRACT_ADDRESS,
CASE
when CONTRACT_ADDRESS='0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then RAW_AMOUNT/1e6
when CONTRACT_ADDRESS='0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' then RAW_AMOUNT/1e18
when CONTRACT_ADDRESS='0xc2132d05d31c914a87c6611c10748aeb04b58e8f' then RAW_AMOUNT/1e6
when CONTRACT_ADDRESS='0x8f3cf7ad23cd3cadbd9735aff958023239c6a063' then RAW_AMOUNT/1e18
when CONTRACT_ADDRESS='0xa3fa99a148fa48d14ed51d610c367c61876997f1' then RAW_AMOUNT/1e18
end as value_asset
FROM polygon.core.fact_token_transfers
WHERE ORIGIN_FUNCTION_SIGNATURE='0xded700a6' AND ORIGIN_TO_ADDRESS='0x059d306a25c4ce8d7437d25743a8b94520536bd5'
AND BLOCK_TIMESTAMP > DateAdd(d, -29, GetDate()))
group by asset
Run a query to Download Data