blocmates researchTotal Volume Last 10 days
    Updated 2025-04-11
    SELECT
    CAST(Date AS DATE) AS date,
    CAST(sum(total_volume) AS NUMBER) AS volume,
    CAST(project AS VARCHAR) AS project,
    'Solana' as chain
    FROM
    $query('031cbd70-8165-4955-9500-d4378a46d14d')
    where
    date >= DATEADD(DAY, -10, CURRENT_DATE)
    and total_volume>0
    group by date,project,chain
    union all
    SELECT
    CAST(Date AS DATE) AS date,
    CAST(sum(total_volume) AS NUMBER) AS volume,
    CAST(project AS VARCHAR) AS project,
    'Base' as chain
    FROM
    $query('d7b9c130-5d37-4f3b-8837-630e55bbb4bd')
    where
    date >= DATEADD(DAY, -10, CURRENT_DATE)
    and total_volume>0
    group by date,project,chain
    Last run: 16 days ago
    DATE
    VOLUME
    PROJECT
    CHAIN
    1
    2025-04-04 00:00:00.0009197VvaifuSolana
    2
    2025-04-02 00:00:00.0009252VvaifuSolana
    3
    2025-04-03 00:00:00.00042875TopHatSolana
    4
    2025-04-09 00:00:00.00014483TopHatSolana
    5
    2025-04-06 00:00:00.00018741TopHatSolana
    6
    2025-04-11 00:00:00.0002038TopHatSolana
    7
    2025-04-02 00:00:00.00021585TopHatSolana
    8
    2025-04-07 00:00:00.00011848VvaifuSolana
    9
    2025-04-08 00:00:00.00041762TopHatSolana
    10
    2025-04-04 00:00:00.00011007TopHatSolana
    11
    2025-04-03 00:00:00.0008641VvaifuSolana
    12
    2025-04-10 00:00:00.0007970VvaifuSolana
    13
    2025-04-11 00:00:00.0002998VvaifuSolana
    14
    2025-04-09 00:00:00.00010653VvaifuSolana
    15
    2025-04-05 00:00:00.0005697TopHatSolana
    16
    2025-04-05 00:00:00.0007162VvaifuSolana
    17
    2025-04-08 00:00:00.00013667VvaifuSolana
    18
    2025-04-06 00:00:00.00015293VvaifuSolana
    19
    2025-04-07 00:00:00.00026691TopHatSolana
    20
    2025-04-01 00:00:00.00011289VvaifuSolana
    44
    2KB
    1s