csbnative

sdfs555csbnative

Updated 2022-12-13

-- SELECT BNB_ADDRESS, COALESCE(SUM(AMOUNT_USD), 0) AS NET_BALANCE

-- FROM (

-- SELECT BNB_FROM_ADDRESS AS BNB_ADDRESS, -SUM(AMOUNT_USD) AS AMOUNT_USD

-- FROM bsc.core.ez_bnb_transfers

-- GROUP BY BNB_FROM_ADDRESS

-- UNION ALL

-- SELECT BNB_TO_ADDRESS, SUM(AMOUNT_USD)

-- FROM bsc.core.ez_bnb_transfers

-- GROUP BY BNB_TO_ADDRESS

-- )

-- WHERE BNB_ADDRESS LIKE '%cafe%' AND REGEXP_COUNT(BNB_ADDRESS, 'cafe') >= 1

-- GROUP BY BNB_ADDRESS

-- ORDER BY NET_BALANCE DESC

-- -- LIMIT 100;

-- -- SELECT DISTINCT

-- -- ORIGIN_FROM_ADDRESS,

-- -- ORIGIN_TO_ADDRESS,

-- -- AMOUNT_USD,

-- -- BLOCK_TIMESTAMP

-- -- FROM bsc.core.ez_bnb_transfers AS T

-- -- WHERE T.ORIGIN_TO_ADDRESS LIKE '%8%'

-- -- AND REGEXP_COUNT(T.ORIGIN_TO_ADDRESS, '8') >= 10

-- -- AND T.ORIGIN_TO_ADDRESS NOT LIKE '0x0000000000000000000000000000000000%'

-- -- AND T.ORIGIN_TO_ADDRESS NOT LIKE '0x1111111254fb6c44bac0bed2854e76f90643097d'

-- -- AND T.ORIGIN_TO_ADDRESS NOT LIKE '0x11111112542d85b3ef69ae05771c2dccff4faa26'

-- -- AND T.AMOUNT_USD IS NOT NULL

-- -- AND T.AMOUNT_USD > 1000

-- -- GROUP BY

-- -- ORIGIN_FROM_ADDRESS,

-- -- ORIGIN_TO_ADDRESS,

-- -- AMOUNT_USD,

Run a query to Download Data

flipside