Moesqsq4 BSC sym
Updated 2023-02-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select * from
(
SELECT
address_name symbol,
COUNT(DISTINCT TX_HASH) as txns
FROM Bsc.core.fact_token_transfers
LEFT outer JOIN bsc.core.dim_labels
ON address = contract_address
WHERE tx_hash in (
SELECT tx_hash
FROM Bsc.core.fact_token_transfers
WHERE origin_to_address ilike '0xce16f69375520ab01377ce7b88f5ba8c48f8d666')
GROUP BY 1
)
where
SYMBOL not ilike '%USDC%'
Run a query to Download Data