CryptoIcicleIn the News - 11. New Year, New Activity? - Flow Swap Metrics - To Flow
    Updated 2023-02-09
    -- The holidays and New Year are often chaotic in the crypto and DEFI space, as users make a spree of new transactions and wallets as they receive (and give) some cash and coins as holiday gifts.
    -- How has this activity impacted the crypto and DEFI ecosystems? Are users creating new wallets or buying tokens with their newfound holiday wealth? Are they staking all those new tokens once they
    -- get them? Or are they selling tokens to pay for their own gifts and holiday travel? Create a dashboard that captures activity across metrics such as new user onboarding, token prices, NFT prices,
    -- or any other notable trends or events. Feel free to examine multiple chains or ecosystems in your dashboard. NOTE: Dashboards submitted for this bounty should not cover the Terra ecosystem, or
    -- any Ethereum chain, fork or Layer 2 including BSC, Polygon, Arbitrum, Optimism or Ethereum Mainnet.
    -- Basis of Payment:
    -- To be eligible for payment. The submission must be sent before the deadline indicated on the bounty page.
    -- The submission must score a minimum of 6 points according to the Evaluation Criteria.
    -- 💰 Payout
    -- Rank Based Payout
    -- Payout is in USDC and xMETRIC, where the top eligible scorers are paid the amounts below.

    -- The first, second and third place submissions must have a score of 10 or higher to be eligible for higher payout amounts. If there are not enough eligible submissions for a category,
    -- remaining funds will either be paid to lower tier submissions or reserved for future bounty programs.
    -- Final determination of payouts and rankings are at the discretion of the MetricsDAO Bounty Operations Team.
    -- USDC Payouts: Rank USDC amount
    -- First place 400
    -- Second place 150
    -- Third place 150
    -- 4th through 15th place 75
    -- 16th through 21st place 50
    -- Payments are issued on the Ethereum mainnet network.
    -- xMETRIC Payouts: Rank
    -- xMETRIC amount Grand Prize Winner 1000
    -- Following Top 20 Submissions 500
    -- score of 9 or higher 150
    -- score of 8 or higher 100
    -- score of 7 or higher 75
    -- score of 6 or higher 50

    with txns as(
    select
    date_trunc('{{date_range}}',block_timestamp) as date,
    year(block_timestamp) as year,
    count(distinct tx_id) as n_txns,
    Run a query to Download Data