banterlyticscom-sales
    Updated 22 hours ago
    SELECT block_timestamp::date as date,sum(price) as vol,avg(price) as average,count(*) as sales
    FROM ethereum.nft.ez_nft_sales
    WHERE block_timestamp > '2021-04-01'
    and nft_address in (lower('0x57a204AA1042f6E66DD7730813f4024114d74f37'), lower('0x7EA3Cca10668B8346aeC0bf1844A49e995527c8B') , lower('0x1F7c16FCe4fC894143aFB5545Bf04f676bf7DCf3'))
    and CURRENCY_SYMBOL in ('ETH', 'WETH')
    group by 1
    order by 1 DESC


    Last run: about 22 hours agoAuto-refreshes every 24 hours
    DATE
    VOL
    AVERAGE
    SALES
    1
    2025-02-16 00:00:00.0003.663.661
    2
    2025-02-15 00:00:00.0000.0459500010.0459500011
    3
    2025-02-14 00:00:00.0001.2670860.105590512
    4
    2025-02-13 00:00:00.0005.0627860.72325514297
    5
    2025-02-12 00:00:00.0000.338820.169412
    6
    2025-02-11 00:00:00.0001.4166880.1770868
    7
    2025-02-10 00:00:00.0001.1244650.2248935
    8
    2025-02-09 00:00:00.0000.810.273
    9
    2025-02-08 00:00:00.0002.3960980.140946941217
    10
    2025-02-07 00:00:00.0001.2301190.13667988899
    11
    2025-02-06 00:00:00.0000.1809940.060331333333
    12
    2025-02-05 00:00:00.0000.8830.29433333333
    13
    2025-02-04 00:00:00.0001.24050.1240510
    14
    2025-02-03 00:00:00.0000.4904750.16349166673
    15
    2025-02-02 00:00:00.0001.15060.1438258
    16
    2025-02-01 00:00:00.0000.2527480.05054965
    17
    2025-01-31 00:00:00.0000.5499660.0916616
    18
    2025-01-30 00:00:00.0000.9420980.117762258
    19
    2025-01-29 00:00:00.0001.2095460.2015916
    20
    2025-01-28 00:00:00.0000.54329900020.18109966673
    ...
    1381
    70KB
    3s