Squidtoken transfers over time
    Updated 2025-04-04
    with token_transfers as (with tab1 as (WITH filtered_transfers AS (
    SELECT
    data:link:height::string AS block_number,
    data:link:txhash AS tx_hash,
    data:send:original_source_chain AS original_source_chain,
    data:send:original_destination_chain AS original_destination_chain,
    data:time_spent:destination_chain_type AS destination_chain_type,
    data:time_spent:source_chain_type AS source_chain_type,
    sender_address,
    created_at::date AS date,
    (data:send:amount) * (data:link:price) as usd_amount_sent,
    data:send:fee_value as fee_usd,
    id
    FROM axelar.axelscan.fact_transfers
    WHERE sender_address = '0xce16F69375520ab01377ce7B88f5BA8C48F8D666'
    AND simplified_status = 'received')
    SELECT
    date,
    CASE
    WHEN ft.original_source_chain = 'base' THEN base_tx.from_address
    WHEN ft.original_source_chain = 'arbitrum' THEN arbitrum_tx.from_address
    WHEN ft.original_source_chain = 'ethereum' THEN ethereum_tx.from_address
    WHEN ft.original_source_chain = 'avalanche' THEN avalanche_tx.from_address
    WHEN ft.original_source_chain = 'optimism' THEN optimism_tx.from_address
    WHEN ft.original_source_chain = 'binance' THEN binance_tx.from_address
    WHEN ft.original_source_chain = 'polygon' THEN polygon_tx.from_address
    END AS sender,
    ft.original_source_chain as source_chain,
    ft.source_chain_type,
    ft.original_destination_chain as destination_chain,
    ft.destination_chain_type,
    ft.usd_amount_sent as usd_amount,
    ft.fee_usd,
    ft.tx_hash as id

    FROM filtered_transfers ft
    Last run: 19 days ago
    Date
    Users Count
    Transfers Count
    Transfers Volume
    Transfers Fee
    Transfer Type
    1
    2023-12-01 00:00:00.0002324894481299.391845487746.737464912Token Transfers
    2
    2025-04-01 00:00:00.0003570598817546031.47649312106.352767461GMP
    3
    2024-05-01 00:00:00.00047088106341121658333.012967109726.648495407GMP
    4
    2023-08-01 00:00:00.0003469263906132289229.736379134458.521219439GMP
    5
    2024-01-01 00:00:00.0002493873397756.660638195712.864071104Token Transfers
    6
    2023-08-01 00:00:00.0001995151068506.492096681339.419834577Token Transfers
    7
    2024-09-01 00:00:00.000299346682587099188.61722150989.183815983GMP
    8
    2023-02-01 00:00:00.00076163128518.08602685506.441588231Token Transfers
    9
    2023-03-01 00:00:00.000186339344403.106515358869.642756333Token Transfers
    10
    2024-04-01 00:00:00.00044499101526173901121.426727171195.724356776GMP
    11
    2023-01-01 00:00:00.000377745561.760922645299.747107931Token Transfers
    12
    2024-11-01 00:00:00.0003339478660172876899.874666120702.04984955GMP
    13
    2024-01-01 00:00:00.00069103110537149532489.980312286634.770944827GMP
    14
    2023-01-01 00:00:00.00011980524782.712669711926.773161027GMP
    15
    2023-05-01 00:00:00.000253369729164.2924191051974.959992703Token Transfers
    16
    2024-07-01 00:00:00.00070899131520129900715.01882778939.624962931GMP
    17
    2024-10-01 00:00:00.0003883679594104012006.01957773933.240615967GMP
    18
    2024-08-01 00:00:00.000393438123897652934.380320744946.244608237GMP
    19
    2024-12-01 00:00:00.0004418193668174603311.159079153407.135731128GMP
    20
    2023-03-01 00:00:00.00012793255547689207.7771074726909.837191809GMP
    42
    3KB
    473s