GOLD as (

select

*

from

base.core.fact_token_transfers

where

CONTRACT_ADDRESS = LOWER('0xbeFD5C25A59ef2C1316c5A4944931171F30Cd3E4')

AND BLOCK_NUMBER < 2400846

-- ORDER BY

-- BLOCK_NUMBER ASC

-- GROUP BY

-- TO_ADDRESS

)

SUM(RAW_AMOUNT_PRECISE) as AMOUNT_IN,

GOLD.TO_ADDRESS

GOLD

-- SELECT

-- TO_ADDRESS

-- -- COUNT(*)

-- -- SUM(RAW_AMOUNT_PRECISE) as AMOUNT_IN

-- FROM

-- GOLD

GROUP BY

TO_ADDRESS

-- GOLD 0xbeFD5C25A59ef2C1316c5A4944931171F30Cd3E4 deployed at 2396993

-- 0x36cc7b13029b5dee4034745fb4f24034f3f2ffc6 - gold contract owner