Drsimononchain gaias
    Updated 2025-01-17
    --https://warpcast.com/~/channel/ogs
    --https://warpcast.com/hony
    --https://warpcast.com/ciniz

    select
    PLATFORM_NAME,
    DATE_TRUNC('{{Time_frame}}', block_timestamp) AS DATE,
    count (DISTINCT tx_hash) as "Total trades",

    count(DISTINCT ORIGIN_FROM_ADDRESS) as "Total users",

    min(price_usd) as "Min trading volume (USD)",
    avg(price_usd) as "Avg trading volume (USD)",
    max(price_usd) as "Max trading volume (USD)",
    sum(price_usd) as "Total trading volume (USD)",

    min(price) as "Min trading volume (ETH)",
    avg(price) as "Avg trading volume (ETH)",
    max(price) as "Max trading volume (ETH)",
    sum(price) as "Total trading volume (ETH)"

    from base.nft.ez_nft_sales
    where nft_address = lower('0xA449b4f43D9A33FcdCF397b9cC7Aa909012709fD')
    and price <= '10'
    and price <> '0'
    group by 1,2
    order by 1 desc
    Last run: about 1 month agoAuto-refreshes every 12 hours
    PLATFORM_NAME
    DATE
    Total trades
    Total users
    Min trading volume (USD)
    Avg trading volume (USD)
    Max trading volume (USD)
    Total trading volume (USD)
    Min trading volume (ETH)
    Avg trading volume (ETH)
    Max trading volume (ETH)
    Total trading volume (ETH)
    1
    opensea2024-12-08 00:00:00.00062492603.720074457.09522895416898.3825432338.2372085590.6511.1178327414.25108.42977588
    2
    opensea2024-12-03 00:00:00.00047241902.1452752653.97279718810020.927191086.0413975430.52110.73425488172.7852.86635148
    3
    opensea2024-10-11 00:00:00.00055484.708708.29238068791.2737613457.5552329240.20.29294157950.3285.56589001
    4
    opensea2024-07-03 00:00:00.00044650.68112871.863439851411.90295043487.45375940.19720.25962250.420691.03849
    5
    opensea2025-01-04 00:00:00.00030262404.722084626.65862517916084.375999634222079.614008610.67151.2731151234.461.1095259
    6
    opensea2024-09-07 00:00:00.00022513.6153556.85691600.098521113.713820.230.24850.2670.497
    7
    opensea2024-04-25 00:00:00.00019162523.4752593922970.1939077863282.266436428103956.786772520.80.94298371431.03933.00443
    8
    opensea2024-05-27 00:00:00.0002219794.80591009.5015816672918.107526247.041123330.2030.25808953850.756.710328
    9
    opensea2024-09-10 00:00:00.00085463.22898491.771582031582.0299832513934.1726562510.19450.20767499750.248999981.66139998
    10
    opensea2024-10-25 00:00:00.00018161116.545051575.7991532734269.14240970.7779850960.4450.63145692231.716.41787998
    11
    opensea2024-12-27 00:00:00.0001381469.34482531.0157727787699.232445558.283910.440.75852777782.2613.6535
    12
    opensea2024-08-04 00:00:00.00065569.605455629.76755935726.96737813778.60535610.21150.23057166670.269931.38343
    13
    opensea2024-11-08 00:00:00.000881034.6618881123.5159533291254.807828988.1276266310.35360.38508124870.4273.08064999
    14
    opensea2024-11-07 00:00:00.00014141065.5647381336.2989233613872.07729824053.3806204920.38010.47166872781.34718.4900371
    15
    opensea2024-04-20 00:00:00.00024222058.5463232012699.1710511956006.44931189264780.1052286720.670.87571945831.921.017267
    16
    opensea2024-03-25 00:00:00.00080632419.2159346013078.6138097437999.386386356304782.7671645260.67050.87492161612.286.61723999
    17
    opensea2024-12-29 00:00:00.00014131390.9785452447.6452822168381.67534267.0339510190.41030.7259777852.510.16368899
    18
    opensea2024-08-13 00:00:00.0001212504.71472567.349616067645.817766808.19539280.1860.21097833330.2382.53174
    19
    opensea2024-04-11 00:00:00.00041343745.0567430584281.14284087810487.293462278209775.9992030081.0691.2111128162.9959.344528
    20
    opensea2024-12-05 00:00:00.00040252387.33484902.14793000719255.432215694.5089203270.621.2534871054.955.15343261
    ...
    345
    43KB
    877s