Native_Token_Transfers

bobby_danielNative_Token_Transfers

Updated 2025-02-27

-- select

-- sum(amount) as Amount_ETH

-- From ethereum.core.ez_native_transfers

-- Where tx_hash = '0x0909b9b94909d90f170c2bf59d5efb107438242b3729c6518b55191982000562'

-- Limit 10

-- ETH transfer for Jan-Feb 2025

-- with raw as (

-- select

-- block_timestamp,

-- tx_hash,

-- from_address,

-- to_address,

-- contract_address,

-- amount,

-- case

-- When contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' then 'USDC'

-- When contract_address = '0xdac17f958d2ee523a2206206994597c13d831ec7' then 'USDT'

-- When contract_address = '0x6b175474e89094c44da98b954eedeac495271d0f' then 'DAI'

-- End as Symbols

-- from ethereum.core.ez_token_transfers

-- where

-- block_timestamp::date >= '2025-01-01'

-- and contract_address IN (

-- '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48',

-- '0xdac17f958d2ee523a2206206994597c13d831ec7',

-- '0x6b175474e89094c44da98b954eedeac495271d0f'

-- )

-- select

-- date_trunc('month',block_timestamp) as Month,

-- symbols,

-- sum(amount) as monthly_sum

-- from raw

-- group by all

Last run: 3 months ago

311B

flipside