DrsimonKem 1
    Updated 2024-12-30
    --0xee7d1b184be8185adc7052635329152a4d0cdefa
    --https://warpcast.com/hony

    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('0xee7d1b184be8185adc7052635329152a4d0cdefa')
    and price <= '10'
    and price <> '0'
    group by 1,2
    order by 1 desc

    Last run: about 2 months 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-07-01 00:00:00.000394248231.676716428.0087345763468.12295326.0268572650.06740.1233080228185.082535698
    2
    opensea2024-08-19 00:00:00.000141496.38537132.361034112262.3212382.4986140180.0370.050626988330.10.9112857899
    3
    opensea2024-12-15 00:00:00.0003331472.870504553.269769779766.5207222130.7907911430.12230.14237403740.1965.694961498
    4
    opensea2024-08-17 00:00:00.000181589.76797121.419081073390.09153763.9915132520.03460.046640767360.151.445863788
    5
    opensea2024-08-11 00:00:00.000211273.05376591.562501758183.544777021922.8125369280.02820.034515618570.0699490.72482799
    6
    opensea2024-11-08 00:00:00.0002012148.544902187.474922913285.8554311.9232270.05060.064221739130.09691.4771
    7
    opensea2024-12-17 00:00:00.0006557432.1207578.3379718811202.26241640.3339754390.110.14497951220.310.438524877
    8
    opensea2024-12-21 00:00:00.0004642528.162943656.320943618939.705330847.0843500410.15890.19021786890.278.94023984
    9
    opensea2024-12-04 00:00:00.00087238.807761278.275290821296.0176280732226.202326570.06590.07519855750.078760.60158846
    10
    opensea2024-09-29 00:00:00.0002112139.229475153.131315025170.698473664287.6768206930.05250.057567256430.0639211.61188318
    11
    opensea2024-07-22 00:00:00.0003619157.3344193.645191293349.63210069.5499472310.0450.055391249990.12.880344999
    12
    opensea2024-08-02 00:00:00.000139105.041322124.048781381176.548351612.6341579580.03410.039826413410.05685590.5177433743
    13
    opensea2024-07-03 00:00:00.000185124249.891619456.8161254035671.9104111006.3184728760.07310.13632689041.6933.127434371
    14
    opensea2024-09-13 00:00:00.000211476.91424110.220242422294.943196.3870302430.0320.046420982760.1251.3462085
    15
    opensea2024-09-19 00:00:00.0002520151.132346162.45454104188.1896164386.272608090.0630.067016259260.07621.809439
    16
    opensea2024-12-03 00:00:00.0002917248.9305300.784971525511.03511730.6138894770.06930.082908202560.143.2334199
    17
    opensea2024-10-21 00:00:00.0001714216.92529242.41699193301.1600697272.50975790.07950.0892920.10992.67876
    18
    opensea2024-08-30 00:00:00.0003387.486681101.854071667109.119744305.5622150.03470.04040.04330.1212
    19
    opensea2024-10-07 00:00:00.0008886.790755113.334378234149.20621473.346917040.03550.045753230770.060.594792
    20
    opensea2024-10-09 00:00:00.000292077.89952112.57455864535.55926416.7498424980.0320.046255210180.222.63654698
    ...
    208
    26KB
    3s