tkvresearchconceptual-salmon
    Updated 2025-05-20
    with list_contract as (
    select *
    from (values
    ('0x7712c34205737192402172409a8F7ccef8aA2AEc'),
    ('0xA6525Ae43eDCd03dC08E775774dCAbd3bb925872'),
    ('0xa1CDAb15bBA75a80dF4089CaFbA013e376957cF5'),
    ('0x2893Ef551B6dD69F661Ac00F11D93E5Dc5Dc0e99'),
    ('0x53FC82f14F009009b440a706e31c9021E1196A2F')
    ) as l(address)
    ),
    --ethereum, optimism, arbitrum, polygon, avalanche

    pre_data as
    (select datetime,
    chain,
    sum(amt) as bal
    from
    (select date(block_timestamp) as datetime,
    'Ethereum' as chain,
    symbol,
    amount as amt
    from ethereum.core.ez_token_transfers
    where contract_address in (select lower(address) from list_contract)
    and
    from_address = '0x0000000000000000000000000000000000000000'
    union all
    select date(block_timestamp) as datetime,
    'Ethereum',
    symbol,
    -amount
    from ethereum.core.ez_token_transfers
    where contract_address in (select lower(address) from list_contract)
    and
    to_address = '0x0000000000000000000000000000000000000000'
    union all
    select date(block_timestamp) as datetime,
    Last run: 2 months ago
    DATE
    CHAIN
    FULLY_BAL
    1
    2025-05-20 00:00:00.000Aptos53526483.24
    2
    2025-05-20 00:00:00.000Polygon23472102.41
    3
    2025-05-20 00:00:00.000Avalanche52948567.59
    4
    2025-05-20 00:00:00.000Arbitrum31065866.25
    5
    2025-05-20 00:00:00.000Optimism26235986.42
    6
    2025-05-20 00:00:00.000Ethereum-75586857.136146
    7
    2025-05-19 00:00:00.000Aptos53526483.24
    8
    2025-05-19 00:00:00.000Polygon23472102.41
    9
    2025-05-19 00:00:00.000Avalanche52948567.59
    10
    2025-05-19 00:00:00.000Arbitrum31065866.25
    11
    2025-05-19 00:00:00.000Optimism26235986.42
    12
    2025-05-19 00:00:00.000Ethereum-75586857.136146
    13
    2025-05-18 00:00:00.000Aptos53508331.71
    14
    2025-05-18 00:00:00.000Polygon23464142.6
    15
    2025-05-18 00:00:00.000Avalanche52930611.95
    16
    2025-05-18 00:00:00.000Arbitrum31056096.72
    17
    2025-05-18 00:00:00.000Optimism26227735.88
    18
    2025-05-18 00:00:00.000Ethereum-86234597.236146
    19
    2025-05-17 00:00:00.000Aptos53508331.71
    20
    2025-05-17 00:00:00.000Polygon23464142.6
    ...
    1800
    84KB
    68s