Query editor
/*Table(s): erc20_ethereum.evt_TransferReason: Based on standards mentionedTable(s): floki_bnb.FLOKI_evt_Transfer, floki_ethereum.FLOKI_evt_TransferReason: Based on contract addresses or possible project names*/WITH FirstTransactions AS (SELECT"from" AS wallet,MIN(evt_block_time) AS first_tx_timeFROM floki_ethereum.FLOKI_evt_TransferWHEREcontract_address = FROM_HEX('cf0c122c6b73ff809c693db761e7baebe62b6a2e')GROUP BY"from"HAVINGMIN(evt_block_time) >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '6' month), NewWalletTransactions AS (SELECT"from" AS wallet,value,evt_block_timeFROM floki_ethereum.FLOKI_evt_TransferWHEREcontract_address = FROM_HEX('cf0c122c6b73ff809c693db761e7baebe62b6a2e')AND "from" IN (SELECTwalletFROM FirstTransactions)), DailyNewWalletVolume AS (SELECTDATE_TRUNC('day', evt_block_time) AS day,SUM(TRY_CAST(value AS DECIMAL(38, 0))) AS new_wallet_volumeFROM NewWalletTransactionsGROUP BY1), DailyTotalVolume AS (SELECTDATE_TRUNC('day', evt_block_time) AS day,SUM(TRY_CAST(value AS DECIMAL(38, 0))) AS total_volumeFROM floki_ethereum.FLOKI_evt_TransferWHEREcontract_address = FROM_HEX('cf0c122c6b73ff809c693db761e7baebe62b6a2e')GROUP BY1)SELECTdnv.day,dnv.new_wallet_volume,dtv.total_volume,(dnv.new_wallet_volume / dtv.total_volume) * 100 AS new_wallet_percentageFROM DailyNewWalletVolume AS dnvJOIN DailyTotalVolume AS dtvON dnv.day = dtv.day