longshotGetting Started
    Updated 2024-05-06

    -- Get started with Flipside by running your first query:
    -- the SQL statement below will get you a list of NFT
    -- platforms on Ethereum, ranked by how many sales
    -- they've had in the past month.

    -- Be sure to see our documentation for more guidance,
    -- including a full walkthrough of the app:
    -- https://docs.flipsidecrypto.com/our-app/getting-started

    -- select
    -- s.marketplace,
    -- count(1) as sales_count
    -- from solana.nft.fact_nft_sales s
    -- join solana.nft.dim_nft_metadata m
    -- on s.mint = m.mint
    -- where s.block_timestamp > current_date - interval '90 days'
    -- and s.succeeded = TRUE
    -- and m.collection_id = 'J6RJFQfLgBTcoAt3KoZFiTFW9AbufsztBNDgZ7Znrp1Q'
    -- group by s.marketplace
    -- order by sales_count desc
    -- limit 8

    -- "all" geckos (missing 660 for some reason)
    -- select count(*)
    -- from solana.core. .nft.dim_nft_metadata
    -- where collection_id = 'J6RJFQfLgBTcoAt3KoZFiTFW9AbufsztBNDgZ7Znrp1Q'


    -- select *
    -- from solana.nft.dim_nft_metadata
    -- where mint IN
    -- ('1257AGGiM3zaYMj6LycLM1PaG8aVnk1DXHxda7X2LB2H', '12Ca1cpymTdMKS5kQomrec5Gm9bESVqm3fZSrAjVuRfh', '12KCzgD4WepbLBZbuEXsqcpC6XjnbPo6MucdFzeGysH5', '12PeLR28RPQw1oppQcFCtsH5SJbrz4Tc4HKhZ8P1gze', '12ajpAKu4kHVmLZ5gF9JpoyLyoNgzqoTo5jnJcgTickt', '12ja148WingCxPjqBfuzrATBGNu2QFfWXp2K2yXSCDYJ', '12z8iCptjppfw8BUdvqowyV6n66JWD4VCq2Gz6LAqRmd', '135oN1n6KrkaWhhgLaZYDuNWuBg6mYrnXYZc6humCgUL', '13DSAv2EdCtR56oCuAMqVN9LxvAAjCF8bx553j4UiNsj', '13PPTomZZkgBkR8yMT6VxZ7y8ktCEoT3G8Wvi93Xa4VG', '13VYL5R9cGAxnwnUWk2sPHmVKsAYYv6Cmv4ZkQFy1EcU', '13VfTYSdEybw8tBjVHErBgqUQPCwr9L3hrhQGtTjHAW6', '13dtPGG7XE3NZJpWXcsmoWdWkuC1pDpbqfXPwurGNrG5', '13kgWUmJFK4yYzD4Gduv2S2iEBN1HAp8rYkA6uJsqR3Y', '13sFj5uG8vgvvDBuxrxJGAQ9omF9AYpDaVLzx9SXCcWM', '13zkVEmB9z1yegt2rqPb7nwfUmUHxHq8WcL9LUWKSnG2', '142931NkTpPB7xAAuJeKUFAaA74AEtgnva9TmifJgkiD', '1453H96uhW7D6wsbmq9R9HJcG5YMqyJ3XGnWi2S41Zpp', '148Ssd6APqJxHBwbwjcHz7kuFdgypneMM8vgJDrVWJyL', '14AXASPVVUURpGGwgEXK5XnxP7aLdB47sHywEJ4CABap', '14VbstRDWpxQLTAvkdCzwKX47UQaVFa3prQ3VYPrUM3H', '14aj3U2C1Dwg4RimrMZ49vSvcoYbcFiXPsn3axDRQcbM', '14ceBpusS9neNXriBvknQZg1PyR2bx5zerRFugvyAX6e', '14k8PDAm6pt4nVDQM3ucqVxVuCxubaDDbQrLoUA4epU8', '14u2r9XmKcCoFHHN5f48MU3tZhiuoST8FpLWNv4otUtc', '171XmjJPayPmcVxy4w93QPRzuK7CzRcBxpSCmWLtND8', '178ujc9URtLBjPx8fEh17oqfStQW7yzbKghiJM9Cqcg', '19E7Y9XMypW6xMJzmvmUGyabTSm2eULzPeDrLvWXxDS', '1KzdWS9UwwgSvMEAHbgYMvZjsER4LwiCQNbe7TQnG5f', '1d28jtDj4QJaKyanAjpHyJftanMneVkTTbVdqFJEy7N', '1f8C39r1uZbRWTP8xdk7bgELD7PbkRovWv2L6aFdZre', '1fZBnTdzVAzNLr97AMaSjRYenv7L89q5LTFo5raP2Zj', '1q1YDRZBffSFGLGrmZwBh4MRXeaZ4T96Wvj1D8QmbbN', '1zxN8SoYwD7km4a9PfKRbmGxXb9sYWiHMapd4vk7a15', '21Fnavkv7KuitBof3XPCh8ucXKWZqVAdsadVfzvvQXM5', '21GX1LBYS3ZnR4NsW28DdfBy2UBXz89KGEamEJD9ryzD', '21HZnkDM7BdaGMugjEp4PzXkbmorTbz9L5Tbg5vEViBX', '21MnbhnC2oEVWVZxTB7XVQhPCyS2DDoXKPh2W8NW6m1E', '21Ns6SSVEJZXC1r5aimD6LMii75prgnc1CMygPmQVUoJ', '21QjaY1EeexRsWLPk7GUpTyQQcBJqxr9kpYhfCZ8bKio', '21Yi5JxbQiUMTAi9pnGcuqeK4srvuNZ89fLbJPseeG8D', '21Zp4fCVj9zCC5xvkAWpQnHW5wQkNmpLAungsVYY5zKu', '21fx2uBDQbuRG5w91pYeY2DbNa7N92MHnjyZDfgR8uWn', '21iJkAT4XaNvV7N8bdakCxvDj1T7ihLCv4yc9Ub2UkyQ', '21j7zdEXVDXRcANQ7QetMgpnhUAsRGmTx4VizikBC5wB', '21qsYt5gMZMtsexGs9K9FKSt4aJ
    -- ;

    -- select *
    QueryRunArchived: QueryRun has been archived