flipside

    Overall of Dokyo' tokens are holding
    StangFASTOverall of Dokyo' tokens are holding
    Updated 2024-01-29


    with

    price1 AS
    (
    SELECT
    date_trunc( 'day' , a.hour ) AS date
    , avg( a.price ) AS price
    , a.token_address AS token
    , a.symbol AS symbol
    , a.decimals AS decimal
    FROM
    avalanche.price.ez_hourly_token_prices a
    WHERE
    a.symbol = 'WAVAX'
    GROUP BY 1 , 3 , 4 , 5
    ORDER BY 1 DESC
    )
    ,
    --- mint
    tab1 AS
    (
    SELECT
    a.block_timestamp
    , a.tx_hash
    , b.origin_to_address
    , b.avax_from_address
    , b.avax_to_address
    , a.nft_from_address
    , a.nft_to_address
    , a.project_name
    , a.tokenid
    , b.amount_precise
    , b.amount_usd
    FROM
    Last run: about 1 year ago
    token
    max price sold
    avg price sold
    min price sold
    date of first sale
    price sold of first sale
    date of last sale
    price sold of last sale
    change in % of price sold
    owner address
    1
    		DKY #4403000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    2
    		DKY #4404000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    3
    		DKY #4416000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    4
    		DKY #4417000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    5
    		DKY #4418000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    6
    		DKY #4419000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    7
    		DKY #4421000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    8
    		DKY #4424000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    9
    		DKY #4425000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    10
    		DKY #4427000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    11
    		DKY #4429000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    12
    		DKY #4431000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    13
    		DKY #4436000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    14
    		DKY #4438000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    15
    		DKY #4440000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    16
    		DKY #4443000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    17
    		DKY #4444000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    18
    		DKY #4919000---0---0❌ no activity for selling0x9b4ee212fa55ad775802c4d21698c89cca9628f7
    18
    2KB
    113s