flipside

daniel_onchaincrowded-lime

Updated 2024-09-27

-- --Native Transfers

-- with raw as

-- (

-- Select

-- block_timestamp,

-- tx_hash,

-- from_address,

-- to_address,

-- amount

-- FROM ethereum.core.ez_native_transfers

-- where

-- from_address = lower('0xd8dA6BF26964aF9D7eEd9e03E53415D37aA96045')

-- and

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

-- )

-- SELECT

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

-- sum(amount)

-- from raw

-- group by all

--TOKEN TRANSFERS--

-- SELECT

-- block_timestamp,

-- tx_hash,

-- from_address,

-- to_address,

-- contract_address, --usdc, usdt, weth

-- amount

-- FROM ethereum.core.ez_token_transfers

-- where block_timestamp::date >= '2024-08-01'

-- limit 10

QueryRunArchived: QueryRun has been archived