jackguyUntitled Query
Updated 2022-12-06
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT *
-- date_trunc('day', block_timestamp) as day,
-- contract_address as symbol,
-- count(DISTINCT tx_hash) as events,
-- count(DISTINCT CASE WHEN to_address LIKE lower('0x94D3E62151B12A12A4976F60EdC18459538FaF08') THEN origin_from_address ELSE to_address END) as users,
-- sum(raw_amount / power(10, 18) * CASE WHEN symbol LIKE '0x2170Ed0880ac9A755fd29B2688956BD959F933F8' THEN price ELSE 1 END) as volume
FROM bsc.core.fact_token_transfers
WHERE to_address LIKE lower('0x94D3E62151B12A12A4976F60EdC18459538FaF08')
LIMIT 100
Run a query to Download Data