BLOCK_TIMESTAMP::date as date,

REPLACE(

LEFT(

REPLACE(CONTRACT_ADDRESS, 'https://', ''),

POSITION('.' IN REPLACE(CONTRACT_ADDRESS, 'https://', '')) - 1

),

'-' || SPLIT_PART(CONTRACT_ADDRESS, '-', 2), ''

) as token,

sum(AMOUNT_RAW/pow(10,18)) as volume,

count(DISTINCT TO_ADDRESS) as claimers,

count(DISTINCT TX_HASH) as txs

FROM

near.core.ez_token_transfers

WHERE

FROM_ADDRESS like '%meme-cooking.near%'

AND memo = 'claim'

group by all