mo115NEAR Stablecoins Prices
Updated 2024-08-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select date_trunc('day', Hour)as "Date"
, avg(PRICE) as "Price"
, case
when TOKEN_ADDRESS = 'usdt.tether-token.near' then 'USDt'
when TOKEN_ADDRESS = 'dac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.near' then 'USDT.e'
when TOKEN_ADDRESS = 'a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near' then 'USDC.e'
when TOKEN_ADDRESS = '17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1' then 'USDC'
when TOKEN_ADDRESS in ('3.contract.portalbridge.near','16.contract.portalbridge.near') then 'PortalBridge USDC'
end as "Token"
from near.price.ez_prices_hourly
where TOKEN_ADDRESS in ('usdt.tether-token.near' , 'dac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.near' ,'a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near' ,'17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1')
group by 1,3
QueryRunArchived: QueryRun has been archived