mlhUntitled Query
Updated 2022-08-11
9
1
2
3
4
5
6
7
8
›
⌄
SELECT count(DISTINCT tx_hash) as trxs,
count(DISTINCT origin_from_address) as users,
count(DISTINCT symbol)
FROM ethereum.core.fact_token_transfers
LEFT outer JOIN ethereum.core.dim_contracts on address = contract_address
WHERE to_address LIKE lower('0x3ee18B2214AFF97000D974cf647E7C347E8fa585')
AND NOT symbol is NULL
Run a query to Download Data