flipside

    sc 2n all
    Hessishsc 2n all
    Updated 2025-03-30
    with tk_ids as
    (select
    INSTRUCTION:parsed:info:mint as mint_tk,case
    when INSTRUCTION:parsed:info:mintAuthority = 'Hv5stMw2f5G4xmogQMX7BJ1Fyn5TWUEHEv5ZaackXS5C' then 'Nebula'
    when INSTRUCTION:parsed:info:mintAuthority = '23buSpWBskpcVtkQsWtcugmbfqsYqHpsDLe4tj5mmAqN' then 'The Odyssey'
    when INSTRUCTION:parsed:info:mintAuthority = 'CrSPztLxSBkPdqdgoU54TVd9cyfZXCBRkYiCXZET2gwL' then 'Solar Companions'
    when INSTRUCTION:parsed:info:mintAuthority = 'GC6VtWCJR8MNtDRZXaPnD5CzbUx6NsUNQ89VBpdJ8uPK' then 'Stars among us'
    when INSTRUCTION:parsed:info:mintAuthority = '8Nga3QCpWiXjZrF8ap7e8ceWVQocdQbW6GdZMubfQ17n' then 'Blue'
    when INSTRUCTION:parsed:info:mintAuthority = '8gtjn4LumJ3Yo9tCbL7GdR8mexvmFuGfTLzi1S4EZqSe' then 'Starborn'
    when INSTRUCTION:parsed:info:mintAuthority = 'Fgs3auKevWQeECXasoZ1aCyuNr2cXK7rP9eKQFC3kZJv' then 'Andromeda'
    when INSTRUCTION:parsed:info:mintAuthority = '6wBjjwmWAZzuzAYt9N7EbhPsthE6m2LStNAxZUbViqQb' then 'Over Open Land'
    when INSTRUCTION:parsed:info:mintAuthority = '3x6Gqc2qFTgwq87LEe1wmybPJLFZPiE8QnSXxDkrAC9E' then 'ASC'
    when INSTRUCTION:parsed:info:mintAuthority = '3bHD7zQGmxVJnxJaSCkzrZyPRUH9Tx5RjkMjUN8fyRTU' then 'AOFE'
    when INSTRUCTION:parsed:info:mintAuthority = '3ncJNLpzwEHvywrMqUNdWi1sBWNsGty4zeKizxLUhYLm' then 'The flight'
    when INSTRUCTION:parsed:info:mintAuthority = 'Adnpk55cbQ4RVQKagRn2Sk6zgJW2V3VYoApeG57JzQET' then 'Not a Destination'
    when INSTRUCTION:parsed:info:mintAuthority = '4ydiJnQR37wRrsz3V7bfc5ep3AXbp9oozDixmin2DyFN' then 'To the Stars'
    when INSTRUCTION:parsed:info:mintAuthority = 'HQCBx2im8GPZqgmH4bEfPSnjLgrDfUF8DfetShPvZLTE' then 'Stargazing Slimes'
    when INSTRUCTION:parsed:info:mintAuthority = '7eTFu5MGgAP22i8nyHE6LnMNz7kXyA2DQ7w44wDmxZGu' then 'The Architect'
    when INSTRUCTION:parsed:info:mintAuthority = 'J7DSmUaeEqLnQGcWbVsQb869gQuxWL5NRJXBQeNzdEM9' then 'Nanieko’s Galactic Mission'
    when INSTRUCTION:parsed:info:mintAuthority = '2B495htUXTpyLp4mEwFwc6nuTwmjr7yk7unbWB5c7sfM' then 'Childhood Memories'
    when INSTRUCTION:parsed:info:mintAuthority = 'ominBdos7eEbvBoMNbqGkB6LepFD2gD5hRikyHQtbrC' then 'Lounging Eclipse'
    when INSTRUCTION:parsed:info:mintAuthority = 'AKkD7mfLZ4ACtPkCXSWaa2zePxmNmoSdkUx5MxUx9ucw' then 'Flowers For Essy'
    when INSTRUCTION:parsed:info:mintAuthority = 'PZhifQvqdk5YUaioahEB2Sf8fAGf1v6iLscxm5JqwgQ' then 'Turbo at the Edge of the Universe'
    when INSTRUCTION:parsed:info:mintAuthority = 'Dcs6MbpdFGfQ32apNE8q1X8j1XuA8ntuTEamCXiLnnyG' then 'Moon Odyssey Club'
    when INSTRUCTION:parsed:info:mintAuthority = '6a2j92TFyYecYKncxR8K4KZB7ggp8aiz7AJaQEEv6deP' then '𝐒𝐞𝐫𝐩𝐞𝐧𝐭𝐬 𝐃𝐚𝐧𝐜𝐞'
    when INSTRUCTION:parsed:info:mintAuthority = '2JFkkx4XmM6Wdir5Uuk3XBdjA1UydKwLGcqQmHts5wdy' then 'Eclipse Blossoms'
    when INSTRUCTION:parsed:info:mintAuthority = 'BFjg5TDwtd2aEPxmvoYQeivuP98AGGkYyEutmzN4TRcw' then 'Serenity'
    when INSTRUCTION:parsed:info:mintAuthority = 'GC3iKa4ZtLvKRqXpvpTxPzzz2VKEZ419vghUZ8DeNLqo' then 'Cosmic Drift'
    when INSTRUCTION:parsed:info:mintAuthority = '555KqB11Tc99FnAPuSmctnzxnWbCRUKqXLM2CSbFAFBp' then 'Cosmic Ascent'
    when INSTRUCTION:parsed:info:mintAuthority = '636B1zQtn5iqAphJUmy1sUJUFysXnTDvbQyhxJYhAmAt' then 'Dark Side of the Eclipse'
    when INSTRUCTION:parsed:info:mintAuthority = 'DDDMvFetwnLHtmed89NUqgbLpZDnnb4ys2nwe4xb1PSn' then 'eGang' --10000
    when INSTRUCTION:parsed:info:mintAuthority = '3oF3uHWw9ciBPnf5ohzQUvvFYwT2xMgufCPiFC1oWA1N' then 'Trench Warriors' --6969
    when INSTRUCTION:parsed:info:mintAuthority = 'Cns71V62nZEVuRVBtkRuGvEbRRNUicqGpvNWcp3o7j7r' then 'Turbo Pass'
    when INSTRUCTION:parsed:info:mintAuthority = 'CUm8o3cNGdRuyis6EpKKGWa2iDLd8CCGmibk9SrB5LY8' then '蛇年 - Coil'
    when INSTRUCTION:parsed:info:mintAuthority = '4iZW7Rt29gBTDB9b3NNsmxBpKSEvYRrjYLDHCbaYmPb3' then 'The Cycle'
    when INSTRUCTION:parsed:info:mintAuthority = '3vjEnv9XJsVyVEsuzbTthn8YTeoGAPg9ZTSumQhdwSSw' then 'Defectus Solis'
    Last run: 26 days ago
    COLLECTION
    Total volume (USD)
    Total volume (ETH)
    Total trades
    Last trading time
    First trading time
    1
    		ASC $8,573,314 2,629.785 6,2642025-03-30 12:52:53.0002024-12-05 15:03:21.000
    2
    		validators $871,705 256.29 1,5322025-03-30 13:02:41.0002024-12-06 13:13:48.000
    3
    		Solar Companions $343,585 101.536 4,6062025-03-30 07:29:04.0002024-12-18 02:17:04.000
    4
    		AOFE $161,294 50.043 7,9642025-03-30 13:10:09.0002024-12-04 20:12:00.000
    5
    		NeuroGuardians $67,013 21.708 9002025-03-29 21:32:24.0002025-01-21 13:02:03.000
    6
    		Dark Side of the Eclipse $29,406 9.027 6262025-03-29 16:01:45.0002025-01-15 17:15:12.000
    7
    		Over Open Land $27,525 9.272 4,5052025-03-30 13:00:40.0002024-12-05 15:23:55.000
    8
    		Trench Warriors $20,240 6.689 1862025-03-27 04:00:24.0002025-01-21 10:08:17.000
    9
    		Not a Destination $14,566 6.06 3,5542025-03-30 10:57:09.0002024-12-24 19:37:45.000
    10
    		Nanieko’s Galactic Mission $14,479 6.098 3,5692025-03-30 10:13:15.0002025-01-02 14:09:17.000
    11
    		Stargazing Slimes $13,034 5.404 3,2242025-03-30 09:17:11.0002024-12-31 15:54:59.000
    12
    		To the Stars $11,580 4.835 2,8162025-03-30 10:13:47.0002024-12-26 14:59:35.000
    13
    		Moon Odyssey Club $11,355 3.906 3252025-03-29 22:07:40.0002025-01-14 14:36:21.000
    14
    		9AMpeBVH32X1m4NAczsdFv9K11hJKzxhtnzfkHQu884Y $9,633 3.681 2242025-03-29 18:52:52.0002025-02-11 12:14:05.000
    15
    		The Architect $8,962 3.587 2,2782025-03-30 08:16:24.0002025-01-02 15:06:50.000
    16
    		The Odyssey $8,419 2.914 1,5462025-03-29 17:58:34.0002024-12-18 14:47:00.000
    17
    		Turbo Pass $7,325 2.637 1902025-03-13 09:52:13.0002025-01-27 22:00:00.000
    18
    		𝐒𝐞𝐫𝐩𝐞𝐧𝐭𝐬 𝐃𝐚𝐧𝐜𝐞 $7,018 2.308 5802025-03-30 12:58:46.0002025-01-16 15:14:21.000
    19
    		Andromeda $6,869 2.021 7542025-03-30 10:35:22.0002024-12-05 15:41:30.000
    20
    		The flight $6,309 2.451 1,4422025-03-30 10:29:22.0002024-12-20 14:59:09.000
    89
    13KB
    6s