flipside

defi__joshVitalik.eth

Updated 2024-11-28

---------Native transfers (ETH)

---------using the (any evm compactible blockcahin).core.ez_native_transfers gives you the results of ETH native token

-- with raw AS

-- (

-- select

-- block_timestamp,

-- tx_hash,

-- from_address,

-- to_address,

-- amount,

-- amount_usd

-- from ethereum.core.ez_native_transfers

-- where from_address = lower ('0xd8dA6BF26964aF9D7eEd9e03E53415D37aA96045')

-- and block_timestamp :: date between '2024-08-01' and '2024-08-20'

-- )

-- select

-- sum(amount),

-- sum(amount_usd)

-- from raw

-- ;

------amount of ETH transferred from 1st to 20th August by Vitalik

-- with raw AS

-- (

-- select

-- block_timestamp,

-- tx_hash,

-- from_address,

-- to_address,

-- amount,

-- amount_usd

-- from ethereum.core.ez_native_transfers

-- where to_address = lower ('0xd8dA6BF26964aF9D7eEd9e03E53415D37aA96045')

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

QueryRunArchived: QueryRun has been archived