lasotez
Algorand Week: New User Bounty
May 18, 2022 - Methodology -> Tables used: account table, block table, and account_asset table. ASA stands for: Algorand Standard Assets
Polygon Price + Circulating Supply
Jun 3, 2022 - This dashboard was created using the ethereum.erc20_balances and ethereum.token_prices_hourly tables. Matic token address: lower('0x7D1AfA7B718fb893dB30A3aBc0Cfc608AaCfeBB0')
Swaps to $THOR
May 26, 2022 - Information was taken from the thorchain.swaps table. General token info: https://www.runebase.org/ More token clasification info: https://cointelegraph.com/news/rune-rally-a-closer-look-at-thorchain-s-new-synthetic-assets
$RUNE Movement from Crypto.com
Jun 17, 2022 - Methodology: The thorchain.transfers table was used. Crypto.com address used: thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6
$RUNE Upgrades
Jun 24, 2022 - Methodology: The thorchain.upgrades table was mainly used for this dashboard. The token being upgraded would be the 'burn_asset' with only BNB.rune and ETH.rune existing in the table (which makes sense since those are the ones ebing depreciated). The to_address is the one now recievieng the upgraded rune. These were the two main columns involved when creating this chart. Chart color coding: Purple = General trend; Orange/Brown= BNB.rune; Blue = ETH.rune
Algorand Wallets in May
Jun 14, 2022 - Methodology: The algorand.account, algorand.transaction_participation, algorand.swaps, algorand.block and account.asset tables were used for this dashboard.
Algorand -> Wildlife Warriors NFT Drop
Jun 21, 2022 - Methodology: For this dashboard the algorand.asset, algorand.account and algorand.block tables were used. Creator addresses: 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU' or 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ' Collection Twitter: https://twitter.com/wildwarriors
Agrotoken
May 23, 2022 - Tables used: Ethereum_core.Fact_token_transfers & etherum_core.fact_transactions On Ethereum: (Corn) token address = '0x891Fde3771F8095E437754FC1A4aaD6937378491' (SOYA) token address = lower('0xb99c9E436a630202E40C90BA9B65dCB610200066') (Wheat) token address = lower('0x1D48257386165d44e303c579386c46089B2775F5') Blank Ethereum address (burning tokens) info = https://crypto.news/ethereum-genesis-address-black-hole-520-million-worth-tokens/ Eth GWei gas tracker = https://ycharts.com/indicators/ethereum_average_gas_price The gas fees are joines between the two mentioned tables via from address given a certain contract address, so I think the data is valid but I will re check. In order to meassure real user addresses when looking at the sender/reciever distibution charts, I recomend eliminating (by touching on the first 3 colored squares) the first three addresses, since the first is generally the contract address, the second it the blanck genesis address used for burning tokens, and the third is also a repeat between all charts, signaling its probably a company asset too. PS: This company also runs token transfers on Polygon and Algorand, so this would not be the whole picture:
Solana Volume on Jupiter (Feb 1 - 28)
May 3, 2022 - Methodology: Solana and USDC volume analysis on Orca. The updated solana.fact_swaps and dim_labels were the main tables used. Previousley I did the same dashboard for these dates on Orca. Orca was chosen due to being the most popular, and volume intensive of Solana exchanges. Therefore I beleive it is the most represntative of comunity trends. Yet this dashboard is for Jupiter, it serves as a comparison between exchanges.
Ethereum NFTs -->Quantum Access Pass
May 13, 2022 - Ethereum NFT Dashboard, focused on Quantum Access Pass The tables used for this dashboard were: ethereum_core.ez_nft_mints ethereum_core.ez_nft_sales
Sushi Noobs II
Jun 22, 2022 - Methodology: For this dashboard the ethereum.sushi.ez_swaps and the ethereum.core.fact_event_logs.event_name were used. News Aritcle on Suhsi 25/12/21 Spike -> https://decrypt.co/89260/defi-tokens-post-double-digit-gains-crypto-market-recovery
Applications on Algorand
Jun 28, 2022 - Methodology: In the process of creating this dashboard the algorand.application_call_transaction and algorand.block tables were queried. Information on how application calls work on Algorand and the changes since the implementation of AVM 1.0: https://www.algorand.com/resources/blog/hello-contract-calling Amv 1.0 details & implementation dates = https://developer.algorand.org/articles/discover-avm-10/
Anchor Protocol Claim
Apr 6, 2022 - 24 - 31 weekly total = 3069,92 M 31 - 6 weekly total = 3666.74 M My claim is that there was a increase in total weekly deposits from last week to this week. The main factor in this increase seems to have happened on April 3, yet, it seems to be a steady increase since the base level of the second week is more or less on par with the ending point (second highest point) of the previous week.
Eth Staking on Lido
Jun 13, 2022 - Methodology: For this dashboard the ethereum.udm_events table was used. stETH: Token address -> 0xae7ab96520de3a18e5e111b5eaab095312d7fe84
From adress (Wallets) Algorand vs Polygon (25-31 of March).
Mar 31, 2022 - We can see an incredibly similar trend of distinct transaction senders on both chains this week, with more volume but the same structure trend on Polygon (>Algorand) PS: Polygon chart says 30, but it is actually 31
ETH Dashboard 1
Apr 26, 2022 - Methodology: In this dashboard we will be comparing two aspects (Price & %Ownership) of two DAO's functioning on the Ethereum blockchain. These two variables were taken from the ethereum_core.fact_hourly_token_prices and ethereum.erc20_balances tables respectivley. And represent the graphical evolution of token market price and % of total circulating token ownership for the top wallets, in each of these proyects. First is the very well known metaverse, Decentaland, and its Token MANA (Larger of the two) Second is Machi X DAO a member run DAO, thought as collective of artists and patrons, curating and trading digital art. (Quite smaller)
Data History Museum NFT on Algorand
Jun 24, 2022 - Methodology: For the creation of this dashboards the following tables were used: algorand.transactions, algorand.asset, algorand.block, algorand.account and algorand.asset_transfer_transaction. DHM webpage: https://museum.datahistory.org Link to Highest vale NFT: https://algoxnft.com/buy-it-now-listing/32759 The specific dates of each event were also querried but I did not find them relevant to the collection information.
Solana Volume on Orca
Apr 28, 2022 - Methodology: Solana and USDC volume analysis on Orca. Orca was chosen due to being the most popular, and volume intensive of Solana exchanges. Therefore I beleive it is the most represntative of comunity trends. For the first graphs the Solana.swaps tables were used, as for the later or newer charts, the tables were changed to Solana.Fact_swaps due to the replacement of the firstly named table for the second.
Solana NFTs
May 12, 2022 - This dashboard was made using the Solana.Dim_labels and Solana.fact_nft_sales tables. It looks into the Solana NFT ecosystem and some key/unique players.
Terra Dashboard
May 12, 2022 - A simple a collection of charts to evaluate this weekends Luna/UST crash, as seen through terra wallets and Anchor Protocol.