Bridge From Aptos User Activity per token and chain

freemartianBridge From Aptos User Activity per token and chain

Updated 2024-05-05

-- with

-- arbitrum AS(

-- SELECT

-- block_timestamp,

-- tx_hash,

-- to_address,

-- 'WETH' AS symbol,

-- amount_usd,

-- 'Arbitrum' AS chain

-- FROM arbitrum.core.ez_native_transfers

-- WHERE

-- origin_from_address = '0xe93685f3bba03016f02bd1828badd6195988d950'

-- AND origin_to_address = '0x177d36dbe2271a4ddb2ad8304d82628eb921d790'

-- AND from_address = '0x1bacc2205312534375c8d1801c27d28370656cff'

-- -- AND origin_function_signature = '0x252f7b01'

-- AND to_address = '{{EVM_Wallet}}'

-- UNION

-- SELECT

-- block_timestamp,

-- tx_hash,

-- to_address,

-- symbol,

-- amount_usd,

-- 'Arbitrum' AS chain

-- FROM arbitrum.core.ez_token_transfers

-- WHERE

-- origin_from_address = '0xe93685f3bba03016f02bd1828badd6195988d950'

-- AND origin_to_address = '0x177d36dbe2271a4ddb2ad8304d82628eb921d790'

-- AND from_address = '0x1bacc2205312534375c8d1801c27d28370656cff'

-- -- AND origin_function_signature = '0x252f7b01'

-- AND to_address <> '0x0000000000000000000000000000000000000000'

-- AND to_address = '{{EVM_Wallet}}'

-- ),

QueryRunArchived: QueryRun has been archived

flipside