z927lvl-2023-04-12 11:51 PM
Updated 2023-04-12
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT * FROM (-- SELECT tx.TO_ADDRESS, tx.FROM_ADDRESS, SUM(tx.RAW_AMOUNT / POW(10, 18)) AS total_amount
SELECT tx.TO_ADDRESS, SUM(tx.RAW_AMOUNT / POW(10, 18)) AS total_amount
FROM bsc.core.ez_token_transfers tx
WHERE tx.block_timestamp BETWEEN to_date('2022-12-11') AND to_date('2023-01-15')
AND tx.contract_address = '0xb64e280e9d1b5dbec4accedb2257a87b400db149' -- unidex
-- GROUP BY tx.TO_ADDRESS, tx.FROM_ADDRESS;
GROUP BY tx.TO_ADDRESS) t
WHERE t.total_amount > 99
ORDER BY t.total_amount DESC;
Run a query to Download Data