flipside

    Vultisig 1inch (Volume & Fee)
    RayyykVultisig 1inch (Volume & Fee)
    Updated 16 hours ago
    with table_1 as (select block_timestamp,
    'Ethereum' as chain,
    tx_hash,
    origin_from_address,
    amount_usd
    from ethereum.core.ez_token_transfers
    where from_address in (lower('0xE37e799D5077682FA0a244D46E5649F71457BD09'),
    lower('0x3451B6b219478037a1AC572706627FC2BDa1e812'),
    lower('0x5141B82f5fFDa4c6fE1E372978F1C5427640a190'))
    and to_address = '0xa4a4f610e89488eb4ecc6c63069f241a54485269' --Vultisig
    and block_timestamp >= '2024-04-01'
    union
    select block_timestamp,
    'Ethereum' as chain,
    tx_hash,
    origin_from_address,
    amount_usd
    from ethereum.core.ez_native_transfers
    where from_address in (lower('0xE37e799D5077682FA0a244D46E5649F71457BD09'),
    lower('0x3451B6b219478037a1AC572706627FC2BDa1e812'),
    lower('0x5141B82f5fFDa4c6fE1E372978F1C5427640a190'))
    and to_address = '0xa4a4f610e89488eb4ecc6c63069f241a54485269'
    and block_timestamp >= '2024-04-01'

    union

    select block_timestamp,
    'Optimism' as chain,
    tx_hash,
    origin_from_address,
    amount_usd
    from optimism.core.ez_token_transfers
    where from_address = lower('0xB63AaE6C353636d66Df13b89Ba4425cfE13d10bA')
    and to_address = '0xa4a4f610e89488eb4ecc6c63069f241a54485269'
    and block_timestamp >= '2024-10-01'
    union
    Last run: about 16 hours ago
    DATE
    CHAIN
    TX_HASH
    USD_VOLUME
    USD_FEE
    TOTAL_VOLUME
    TOTAL_FEE
    TOTAL_TX
    START_DATE
    END_DATE
    1
    		2025-04-01 00:00:00.000Ethereum0x00e98c68fb5e25d8ecb52974eb14adbcd6d9d3e6c39bda9d6d45bc72ebd155cb999.9974.9999851151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    2
    		2025-04-01 00:00:00.000Ethereum0xd17f16f6a993d05565c1aef37ab62905158371202ba702fd39dedce8e82aa506509.472.551151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    3
    		2025-03-01 00:00:00.000Arbitrum0x0c171eb8196802b3c67c602d28e9161daaa5754281ce6f61bc5a9b9daef72a3a2460.2712.31151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    4
    		2025-03-01 00:00:00.000Arbitrum0xb67f0a3438c93276f057265def5055a1aa22e4f43fee80f8ad89ac2772557f675921.7929.611151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    5
    		2025-03-01 00:00:00.000Arbitrum0x2dbfa129b83f856ba4294a2bf2d1fb408b76ae3811235a3f78b5987a89ae10ab1012.095.061151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    6
    		2025-03-01 00:00:00.000BSC0x0418691d154efb607273106f7d8b2e43a274122c8be94d4c3d4390481826ef7b1023.625.11811151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    7
    		2025-03-01 00:00:00.000Ethereum0xc25604cb2063be3e6bf9e694d2a7de7e89179a0ec742d8caaa8a58fbdfee1bd5801.9929963574.0099649821151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    8
    		2025-03-01 00:00:00.000Ethereum0xc9e325065347221ec6e6445cbf2dad59c1cd1101bb1fe007504b81bf0db9da19380.161.91151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    9
    		2025-03-01 00:00:00.000Ethereum0xe1f5694a6f8bd5d62bffc11383ec448c4b63d412fa059ab1f9187f238bc177ad3365.2216.831151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    10
    		2025-03-01 00:00:00.000Ethereum0xc8be04889a9ab0a9a2d3148d6bb6929af914ed4d2dbe5c8e85a15f8ae758b3622935.7314.681151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    11
    		2025-03-01 00:00:00.000Ethereum0x221cb1f12f38bfe14e389a823980f0c97bbe782fac2ed7ea6be55fa4b828d6e51367.919139866.8395956991151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    12
    		2025-03-01 00:00:00.000Ethereum0xcde7608dc553f2f6707e111286e390e9c57b0c274340cbc61b1ab38efc7115c05239.83626.199181151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    13
    		2025-03-01 00:00:00.000Ethereum0xfcf0d1ca29193b888d373d597e26757d875fd4e5c0dbdc265b17680c741ade531025.295.131151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    14
    		2025-03-01 00:00:00.000Ethereum0x6101f3b62508198750361396aa32630491035a3c1ae4e136dd3667cdd68567ab9458.447.291151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    15
    		2025-03-01 00:00:00.000Ethereum0x571c5c5d4647d42a4176c14eb1d6c36d6fb64241d40d37b585bf9c41d61f0bcd2171.9810.861151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    16
    		2025-02-01 00:00:00.000Arbitrum0xdef2231ba16b5f3a9433bc70a66806caa72f748f52f5b7c5a9e4af30cff204392394.0111.971151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    17
    		2025-02-01 00:00:00.000Arbitrum0xe0295ee4c381d9becefb374c536b41dd7595730cb7c0b8bb57abc3ed1b9ba465349.98321.7499161151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    18
    		2025-02-01 00:00:00.000Arbitrum0x6a1fc98bb03d2cd5191e89d039d8d34fcbf9e2362c25d4a7db73f6f84567b755210.88987681.0544493841151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    19
    		2025-02-01 00:00:00.000Arbitrum0xc6c9b3847a4fe780d676e23f29daef0f09ec150975740ccf11aa354631c8fe032394.0111.971151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    20
    		2025-02-01 00:00:00.000Arbitrum0x4168e8fc0094483cb15c384731aed2f023c6286cb0a982f040cec9f9777445552420.312.11151645.470693935761.06228473217901/01/20242025-04-11 00:00:00.000
    ...
    179
    34KB
    211s