winnie-fsSupply copy
Updated 2024-09-18
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
›
⌄
-- forked from alitaslimi / Supply @ https://flipsidecrypto.xyz/alitaslimi/q/7ye9c5cHVeLo/supply
with
------------------------------ Prices ------------------------------
prices as (
select
response as price
from
(
select
live.udf_api(
'https://api.coingecko.com/api/v3/simple/price?ids=coinbase-wrapped-btc&vs_currencies=usd'
):data:"coinbase-wrapped-btc":usd as response
)
),
------------------------------ Base ------------------------------
base as (
select
sum(amount) as volume
from
base.core.ez_token_transfers
where
contract_address = '0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf'
and from_address = '0x0000000000000000000000000000000000000000'
and to_address != '0x0000000000000000000000000000000000000000'
union all
select
-sum(amount) as volume
from
base.core.ez_token_transfers
where
contract_address = '0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf'
and from_address != '0x0000000000000000000000000000000000000000'
and to_address = '0x0000000000000000000000000000000000000000'
),
------------------------------ Ethereum ------------------------------
QueryRunArchived: QueryRun has been archived