rezarwzTX count Transfer
    Updated 8 days ago
    WITH token_transfer_data AS (
    SELECT
    DATE_TRUNC('{{Time_Frame}}', CREATED_AT) AS Date,
    lower(SOURCE_CHAIN) as SOURCE_CHAIN,
    SUM(COALESCE(send:value, 0)) AS token_transfer_USD,
    COUNT(id) AS token_transfer_txs
    FROM
    axelar.axelscan.fact_transfers
    WHERE
    NOT (
    (
    TYPEOF(link:price) = 'ARRAY'
    AND ARRAY_SIZE(link:price) = 0
    )
    OR (
    TYPEOF(SEND_AMOUNT) = 'ARRAY'
    AND ARRAY_SIZE(SEND_AMOUNT) = 0
    )
    OR link:price IS NULL
    OR SEND_AMOUNT IS NULL
    )
    GROUP BY
    1,
    2
    ),
    AggregatedData AS (
    SELECT
    token_transfer.Date AS Date,
    token_transfer.SOURCE_CHAIN AS source_chain,
    SUM(COALESCE(token_transfer.token_transfer_txs, 0)) AS tx_count
    FROM
    token_transfer_data token_transfer
    GROUP BY
    1,
    2
    ),
    Last run: 8 days ago
    DATE
    SOURCE_CHAIN
    Transaction Count
    1
    2024-10-01 00:00:00.000polygon93
    2
    2023-04-01 00:00:00.000ethereum1035
    3
    2023-06-01 00:00:00.000ethereum723
    4
    2024-06-01 00:00:00.000kujira240
    5
    2025-02-01 00:00:00.000kujira19
    6
    2023-08-01 00:00:00.000terra-2500
    7
    2023-10-01 00:00:00.000binance864
    8
    2024-05-01 00:00:00.000ethereum141
    9
    2023-11-01 00:00:00.000kujira1682
    10
    2024-01-01 00:00:00.000terra-2485
    11
    2023-06-01 00:00:00.000kujira1127
    12
    2023-03-01 00:00:00.000fantom148
    13
    2023-08-01 00:00:00.000binance6660
    14
    2022-08-01 00:00:00.000fantom226
    15
    2024-05-01 00:00:00.000Others2016
    16
    2024-12-01 00:00:00.000binance174
    17
    2024-02-01 00:00:00.000polygon944
    18
    2023-10-01 00:00:00.000kujira1006
    19
    2024-07-01 00:00:00.000avalanche44
    20
    2023-11-01 00:00:00.000avalanche411
    ...
    331
    14KB
    84s