BaseMC- Supply- Price- 1 token
Updated 2024-09-08
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 pricetbl as
(
SELECT price
from base.price.ez_prices_hourly
where token_address = lower ('0x4ed4E862860beD51a9570b96d89aF5E1B0Efefed')
order by hour DESC
limit 1
),
supplytbl as
(
with database as
(
with general as (
with tbl3 as (
with tbl as (
select
to_address as "Address",
sum(amount) as "Input"
from
base.core.ez_token_transfers
where
contract_address = lower ('0x4ed4E862860beD51a9570b96d89aF5E1B0Efefed')
group by
1
),
tbl2 as (
select
from_address as "Address",
sum(amount) as "Output"
from
base.core.ez_token_transfers
where
contract_address = lower ('0x4ed4E862860beD51a9570b96d89aF5E1B0Efefed')
group by 1
)
select
QueryRunArchived: QueryRun has been archived