ujawalToken price copy
Updated 2024-03-25
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
›
⌄
-- To get the historical daily new users count of an ERC 20 token on the Ethereum chan,
-- go to https://etherscan.io/ and search for the token name.
-- Enter the contract address in the parameter field in this query: https://flipsidecrypto.xyz/edit/queries/95491bac-d3cb-4bb2-b361-b5bc6de59456
with first_transaction as (
select
from_address,
min(to_date(block_timestamp)) as first_transaction_date
from
ethereum.core.fact_transactions
where
to_address = lower('{{param_UGz5}}')
group by
1
)
select
first_transaction_date,
count(*)
from
first_transaction
group by
1
order by
1;
QueryRunArchived: QueryRun has been archived