flipside

    Try Quests to earn cryptoTry Quests to earn crypto
    Share

    Transactions fee per asset on Mirror

    In this analytics, I will attempt to visualize the fee per asset transaction on Mirror. We are only condisering 5 mAsset for simplification; mBABA, mTWTR, mSLV, mGME, and mQQQ. This SQL is failed to visualize as chart due to failure of converting variable to real values(FEE)

    Loading...

    Methodology

    Part 1: Identifying tx_id, contract address for mAsset, block_timestamp

          1- Extract tx_id,contract_address,block_timestamp from terra.msgs
      2- identify the contract address for these study; mBABA, mTWTR,mQQQ, mSLV, mGME
       3- use block_timestamp>'2021-10-21' to consider 30 day range

    Part 2: Gathering Fee metrics for each transaction

       1- use terra.transactions
    2- use flatten table to be able to extract fee value

    Part 3 : Part 1 + Part 2

      1- use inner join to combine the two data from part1 and part 2
   2- use tx_id on both part 1 and part 2 to combine the transaction data and its fee