azad2raul
New DEX Users
Mar 31, 2022 - Q40. Let's use the algorand.swap table to look at users who are using the new DEXes(Decentralized Exchange): PactFi, AlgoFi, WagmiSwap and whether or not they previously used the Tinyman exchange?
15. New User Challenge - Exclusive
Mar 27, 2023 - Find the top 10 projects on Ethereum mainnet by volume during the past 7 days analyst will learn to observe different ethereum tables will learn to filter by only 10 projects with the most volume will learn to truncate dates to find past 7 days
EVM - 17. Avalanche Gas Fees ..
Mar 27, 2023 - Create a dashboard to analyze gas usage on the Avalanche network. The dashboard should have two tabs: one for contracts and one for dApps. Each tab should show which ones generate the most network fees and use the most gas over a user-selectable time period. This query calculates the total network fees and gas usage for each contract during the time period from 2023-01-01 to 2023-03-27 and sorts them by network fees. It also selects the top 11 contracts with the highest network fees using LIMIT 11. You can replace the date values with your preferred date.
EVM - 17. Avalanche Gas Fees .
Mar 25, 2023 - Create a dashboard to analyze gas usage on the Avalanche network. The dashboard should have two tabs: one for contracts and one for dApps. Each tab should show which ones generate the most network fees and use the most gas over a user-selectable time period. This query calculates the total network fees and gas usage for each contract during the time period from 2023-01-01 to 2023-03-27 and sorts them by network fees. It also selects the top 11 contracts with the highest network fees using LIMIT 11. You can replace the date values with your preferred date.
15. New User Challenge - Exclusive .
Mar 27, 2023 - Find the top 10 projects on Ethereum mainnet by volume during the past 7 days