mo115bebop transactions
Updated 2023-06-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
'Polygon' as Network ,min(BLOCK_TIMESTAMP)as first_transaction ,count(distinct TX_HASH) as transactions, count(distinct from_address) as wallets , sum(AMOUNT_USD) as USD
from polygon.core.ez_token_transfers
WHERE to_address = lower('0xAF0B0000f0210D0f421F0009C72406703B50506B')
and ORIGIN_TO_ADDRESS in ('0xbeb09beb09e95e6febf0d6eeb1d0d46d1013cc3c', '0x29fbd00940df70cfc5dad3f2370686991e2bbf5c','0xaf0b0000f0210d0f421f0009c72406703b50506b')
union
SELECT
'Arbitrum' as Network ,min(BLOCK_TIMESTAMP)as first_transaction ,count(distinct TX_HASH) as transactions, count(distinct from_address) as wallets , sum(AMOUNT_USD) as USD
from arbitrum.core.ez_token_transfers
WHERE to_address = lower('0x0087BB802D9C0e343F00510000729031ce00bf27')
and ORIGIN_TO_ADDRESS in ('0xbeb09beb09e95e6febf0d6eeb1d0d46d1013cc3c', '0x29fbd00940df70cfc5dad3f2370686991e2bbf5c','0xaf0b0000f0210d0f421f0009c72406703b50506b')
union
SELECT
'ethereum' as Network ,min(BLOCK_TIMESTAMP)as first_transaction ,count(distinct TX_HASH) as transactions, count(distinct from_address) as wallets , sum(AMOUNT_USD) as USD
from ethereum.core.ez_token_transfers
WHERE to_address = lower('0xAF0B0000f0210D0f421F0009C72406703B50506B')
and ORIGIN_TO_ADDRESS in ('0xbeb09beb09e95e6febf0d6eeb1d0d46d1013cc3c', '0x29fbd00940df70cfc5dad3f2370686991e2bbf5c','0xaf0b0000f0210d0f421f0009c72406703b50506b')
Run a query to Download Data