TOP CRYPTO TOOL: Dune Analytics 📈 (Intro & Deep Dive)

Summary

In this 'Encrypto' video, Tom introduces June Analytics, a free tool for visualizing blockchain data. June allows users to explore, create, and share crypto analytics with thousands of pre-built dashboards or custom SQL queries. The platform offers insights into DEX trading volumes, NFT market trends, and gas prices, making complex blockchain data accessible and easily digestible through interactive charts. June Analytics is praised for its user-friendly interface and the ability to track key metrics across various projects, making it a valuable resource for the crypto community.

Takeaways

• 🌐 June Analytics is a free tool for visualizing blockchain data and interacting with charts.
• 🔍 Users can explore, create, and share crypto analytics with thousands of dashboards available for various projects.
• 📊 June Analytics allows for querying blockchain data in a human-readable format using SQL.
• 👁️ Beginners can view thousands of pre-built dashboards sorted by themes like DeFi, NFTs, and more.
• 🛠 Experienced users can create custom charts and dashboards using plain SQL queries.
• 📈 An example provided is the DEX trading volume over time, showcasing the change in volume across various DEX platforms.
• 🔎 The platform features popular dashboards, allowing users to delve deeper into specific topics like NFT market trends or DEX metrics.
• 📊 June Analytics connects to various DEXes and protocols to pull blockchain data for analysis.
• 💬 A quote from Andre Cronje highlights June Analytics as a unique tool for charting on-chain data in an easily understandable way.
• 🔍 Users can discover dashboards by searching or browsing popular tags, and can rank and save favorites.
• 📝 The platform also provides documentation for users interested in building their own dashboards with SQL queries.

Q & A

What is June Analytics and what does it offer to its users?

June Analytics is a free crypto analytics tool designed for the community. It allows users to visualize blockchain data and interact with various charts, making it easier to understand and analyze on-chain activities.

How can a beginner utilize June Analytics?

A beginner can view thousands of pre-built dashboards created by others, sorted into various themes such as DeFi, NFTs, and more. This provides an easy way to explore and understand blockchain data without needing to build their own queries.

What is the significance of the SQL query feature in June Analytics?

The SQL query feature allows users with experience in building SQL to directly query the blockchain and create their own custom charts and dashboards, providing a high level of customization and deeper insights into the data.

Can you provide an example of a chart that can be found on June Analytics?

An example of a chart on June Analytics is the 'DEX Trading Volume Over Time', which shows the trading volume across all DEXes that June is connected to and tracks over time, providing a visual representation of volume changes.

What are some of the features available on the June Analytics homepage?

The homepage features options to explore, create, and share crypto analytics, with thousands of dashboards available for hundreds of projects. Users can follow key metrics, query data with SQL, and interact with community-created analytics.

How can users find and rank dashboards on June Analytics?

Users can find dashboards by searching or browsing through categories such as 'What's Trending' and 'What's New'. They can also rank dashboards by favorites by creating an account and using the star feature to save and organize their preferred dashboards.

What is the purpose of the 'Discover' section on June Analytics?

The 'Discover' section allows users to explore pre-built dashboards created by other users. It provides a way to find and analyze various blockchain data sets, such as NFT market trends, DEX metrics, and gas prices.

What kind of data can be found in the 'OpenC' dashboard on June Analytics?

The 'OpenC' dashboard on June Analytics provides data on Ethereum and Polygon trades, including monthly volume, daily volume, the number of individual NFTs sold, fees, and active traders over time.

How does June Analytics help users understand gas prices on the Ethereum blockchain?

June Analytics offers a 'Gas Prices' dashboard that provides a visual breakdown of the cost of different interactions with the Ethereum blockchain, such as ETH transfers, ERC-20 transfers, and Uni-swap trades, helping users understand the varying costs associated with these actions.

What additional resources does June Analytics provide for users who want to build their own dashboards?

For users interested in building their own dashboards, June Analytics provides a 'New Query' section where they can write and run SQL queries. Additionally, there is a 'Docs' section that offers more information on how to use the platform effectively.

How can users save their favorite dashboards on June Analytics for easy access?

Users can save their favorite dashboards by clicking the star button next to a dashboard. These starred dashboards will then be accessible in the 'Favorites' section for quick reference and revisiting.

Outlines

00:00

📊 Introduction to June Analytics for Blockchain Visualization

This paragraph introduces June Analytics, a free tool for visualizing and interacting with blockchain data. The speaker, Tom, highlights the platform's ability to create and share crypto analytics, mentioning its user-friendly interface for both beginners and those with SQL experience. The homepage of June Analytics is showcased, with features like exploring thousands of pre-built dashboards, creating custom charts with SQL, and querying blockchain data in a human-readable format. The video also includes a demonstration of a DEX trading volume chart, illustrating the platform's capability to present complex data in an easily digestible, graphical format.

05:02

🔍 Exploring Pre-built Dashboards and Data on June Analytics

In this paragraph, the focus is on exploring the pre-built dashboards available on June Analytics. The platform offers a wide range of dashboards that users can sort by themes such as DEX, NFTs, and more. The speaker demonstrates how to search for specific dashboards, rank them by favorites, and view trending and new dashboards. Examples of popular dashboards like 'DEX Metrics' and 'OpenC' are provided, showing various statistics such as trading volumes, market shares, and project rankings. The paragraph also touches on the ability to view data over time, such as weekly and monthly volume trends, and how June Analytics can be used to analyze data from specific blockchain applications like OpenC.

10:03

🛠 Building Custom Dashboards with SQL on June Analytics

The final paragraph discusses the process of building custom dashboards using SQL queries on June Analytics. The platform allows users to write their own SQL queries and run them to create personalized charts and analytics. The speaker mentions the availability of documentation for those unfamiliar with SQL, guiding them on how to use the platform effectively. Additionally, the paragraph highlights the platform's connectivity options, such as Ethereum, XDI, Polygon, and other blockchains, which can be selected to tailor the data being queried. The video concludes with a call to action for viewers to explore June Analytics and follow Encrypto for more reviews of useful crypto tools.

Keywords

💡Encrypto

Encrypto appears to be the name of the channel or the host of the video, which is focused on crypto-related content. It is a key term as it sets the context for the video's theme of discussing and reviewing crypto tools and platforms. In the script, 'Encrypto' is mentioned at the beginning as the source of the video content.

💡June Analytics

June Analytics is the main subject of the video, described as a free crypto analytics tool. It is central to the video's theme as it is the platform being reviewed and explained. The script discusses its features, such as visualizing blockchain data and creating custom charts using SQL.

💡Blockchain Data

Blockchain data refers to the information stored within a blockchain, which is a decentralized ledger of transactions. In the video, June Analytics is highlighted for its ability to visualize this data, making it accessible and understandable through charts and graphs.

💡Dashboards

Dashboards in the context of June Analytics are pre-built or user-created interfaces that display data in a visual format. They are key to the video's message as they allow users to view and analyze blockchain data easily, with examples given such as 'DEX metrics' and 'NFT market trends'.

💡SQL

SQL, or Structured Query Language, is a programming language used to manage and manipulate databases. In the video, it is mentioned as the method by which users can query the blockchain and create custom charts on June Analytics, emphasizing the platform's flexibility and power for users with SQL knowledge.

💡DEX Trading Volume

DEX, or Decentralized Exchange, trading volume refers to the total value of trades executed on a DEX within a given time frame. The script uses this as an example of the type of data that can be visualized on June Analytics, showing how trading volume changes over time.

💡NFTs

NFTs, or Non-Fungible Tokens, are unique digital assets that represent ownership of a particular item or piece of content on the blockchain. The video mentions NFTs as one of the many areas where June Analytics can provide data visualization, indicating the platform's broad application in the crypto space.

💡OpenC

OpenC is mentioned as an example of a blockchain application that June Analytics can pull data from. The script discusses how users can view trading volumes and other statistics related to OpenC, demonstrating the platform's ability to provide detailed insights into specific blockchain applications.

💡ENS

ENS stands for Ethereum Naming Service, which is a system for registering and managing domain names on the Ethereum blockchain. The video script references a dashboard that tracks ENS-related data, such as the release and registration of names, showcasing June Analytics' versatility in tracking different types of blockchain data.

💡Gas Prices

Gas prices in the context of Ethereum refer to the fees required to perform transactions on the blockchain. The script discusses a dashboard that visualizes gas prices for different types of transactions, providing a practical example of how June Analytics can help users understand the costs associated with blockchain interactions.

💡Custom Charts

Custom charts are user-generated visualizations of data on June Analytics. The video emphasizes the ability for users to create their own charts using SQL, allowing for personalized analysis and insights into the blockchain data that interests them.

Highlights

June Analytics is a free crypto analytics tool designed for the community.

It is excellent for visualizing blockchain data and interacting with charts.

The homepage of June Analytics is at june.xyz with a link provided below the video.

Users can explore, create, and share crypto analytics with thousands of dashboards for various projects.

June Analytics allows querying blockchain data with SQL for human-readable results.

Beginners can view thousands of pre-built dashboards sorted by themes like DeFi and NFTs.

Experienced users can create custom charts and dashboards using SQL.

An example dashboard shows DEX trading volume over time for all connected platforms.

June Analytics provides a visual and digestible way to view blockchain data.

Users can discover popular dashboards and deep dive into specific topics.

Community-created analytics include a wide range of DEXes and protocols.

Andre Cronje praises June Analytics as a lifesaver for its unique charting capabilities.

Dashboards can be ranked by favorites and saved for easy access.

Users can search for specific dashboards and filter by trending or new.

A popular dashboard example includes DEX metrics with detailed statistics and rankings.

June Analytics offers insights into blockchain data through various visual representations.

The platform allows users to explore data on gas prices and Ethereum blockchain interactions.

Users can sign up for a free account to build and save their own dashboards.

June Analytics provides documentation for users to learn how to use the platform effectively.

The platform is a valuable resource for tracking on-chain activities and crypto trends.

Transcripts

hello and welcome to encrypto my name's

tom and in this video we're going to

take a look at june analytics which they

describe as free crypto analytics by and

for the community

and essentially

this is a tool which you can use and

it's really amazing for visualizing

blockchain data and interacting with

these charts

[Music]

so here i am on the homepage of june

analytics which is at

june.xyz and a link to this will be just

below the video and they say

explore create and share crypto

analytics thousands of dashboards for

hundreds of projects follow key metrics

for d5 nfts and more

and query human readable data with sql

so if you're a complete beginner you can

view the thousands of dashboards which

others have built and these are sorted

into a range of themes d5 nfts and more

and if you've got experience with

building in sql you can also

query the blockchain

using june to create your own charts and

right here is an example of one of them

which is dex trading volume over time so

all the dexes which june is connected to

and can track over time and you can see

all the volume

and how that's changed which is just the

best way to view

blockchain data when it's graphed like

this

in a really easily digestible way

what else we have here we have popular

dashboards

and we're going to deep dive into this

in a second

create your own custom charts and

dashboards using plain sql a little

example of how you can actually create

using sql

community created analytics here are

some of the dexes and protocols which

you can connect to to pull data off the

blockchain

and they've even got a quote here from

andre himself saying june analytics is a

lifesaver because there really is no

other tool out there like this which

will

chart on chain data in a ways that you

just would have no idea

what was going on unless you could

visually see it

so let's have a look

if i come into discover

here are some of the dashboards which

have been built by other users

nft market trends are they mega

dashboard

ohm rebates tracker open c

um on the top right here you can rank

these dashboards by favorites if you

create an account you can save them to

your favorites by clicking the stars

what's trending and what's new

you can also search for dashboards so i

can type in here defy and it's going to

sort the d5 dashboards

and

just below we've got some of the most

popular dashboard tags so i can just

click d5 if i want to view define

so let's take a look

here we have quite a popular one with a

thousand plus favorites dex metrics

which was created two years ago

and we come into here

so

here we have

dex 24 hour volume

total volume across all these dexes the

7 day volume and a bunch of other

statistics

coming down

you can see

projects ranked by their volume uni swap

sushi shop curve

you can see the market share which they

occupy in a nice pie chart

and you can see

just a range of graphs and data actually

sorted in ways which which makes sense

things which give you information about

the blockchain uh all in one place and

all in a very beautiful attractive

visual way to look at

we've got weekly decks volume so you can

see over time how things are changing

we've got some monthly data here

and lots to look at

let's go back to discover

what else do we have here open c another

thousand

likes favorites

in open c what do we have so this says

we are looking at ethereum

the primary blockchain on openc

openc monthly volume so here we've got a

chart and you can see that in the

beginning of 2021 january

this began with about eight

million dollars of volume and then it

ramps up and absolutely exploded in

about august of this year

openc daily volume so we've got chart of

daily

daily volume we've got the amount of

nfts actual individual nfts sold another

chart very similar to volume

um

the monthly fees active traders traders

over time

um and then beneath we also have the

same data for polygon

and the and the amount of polygon trades

on um

on openc

so

you can interrogate all this data

for not only the blockchain but for all

but also for apps on the blockchain such

as openc

let's come back

into discover so there are a wide range

of dashboards and these have all been

pre-built and you can go through and

search you can go through and look at

the data

there's one here for

ens the ethereum naming service release

slash registered names

so if you're interested in the ethereum

naming service here's a chart

of released slash to be released names

monthly registration how that's ramped

up over time ens names to be released

you've got some data here on which names

are coming out

you've got each names registered

here you can actually see

literally the names which have been

registered the price

how long for

uh it's just amazing you can interrogate

all this data through

june

back on discover

what else do we have here so if i look

in the popular dashboard tags

gas

let's see what's being built here so gas

prices this is a popular dashboard if i

come into gas prices

so here we have gas costs for typical

actions at recent gas prices

this is a really interesting chart

because as you can see here so we have

eath transfer

so that would be

sending eth

over the network

about 1144 and when was this so gas cost

for typical transactions at recent gas

prices i don't know what the time scale

is on this one

maybe it's an average

but it's telling me

eat transfer 1144 erc 20 transfer so

that would be

a a token that was built on ethereum

that's

22.46 so about double the price in gas

then you've got erc 20 approval in this

box so slightly more 24

and i believe that is when you authorize

a dex to be able to spend your tokens

and then a uni-swap trade shoots up to

69

and compound deposit which i'm not

entirely sure what that is but that's

103

so so here you can see

a breakdown a charted a visual chart of

how different interactions with the

ethereum blockchain are costing you

difference amounts different amounts in

gas and until i saw this chart

i i didn't really know

what you would expect to pay for one of

these different

interactions with the ethereum

blockchain sometimes it's more sometimes

it's less here it shows you

so the median guest price

last 24 hours this is

77 median cost of transfer

six dollars and here we have over time

so this is over the last 24 hours the

median gas price

swinging up and down

cost of an ethereum transfer by our

median gas price over the last 90 days

so a lot higher time scale because it's

peaked out in october and has been

falling since

um

you're getting all kinds of data about

gas prices and this is life

as you can see these charts come right

up to the current day and you can see

how it's changing over time so just an

incredible thing to refer to on

literally almost anything you want to

know about the blockchain

so

what else can we do here

so if you sign up for an account

which is free and very easy to do

then you can come into new query

and if you're interested in building

your own dashboards this is where you

would come

it says here write your sql query above

and then click run

on the side here you can click this drop

down you can see ethereum xdi polygon

and optimism and finance smart chain so

so the so this is what you can actually

connect to currently with june analytics

and

as you change

these you will get

different commands that you can click

here you can then click here it's going

to fill this

i'm i'm not familiar with sql myself so

i don't really know how this works but

this is how users will build your own

charts which which you can then put onto

the platform

and interrogate all your own stats

which is really cool

up here there is a docs section

docs.june which is going to break down

way more information about how to

actually use the platform

and what else do we have we have the

favorite section up here at the top

so when you click

the star button next to a dashboard

something you want to come back to and

refer to click the start it's going to

go into your favorite section so you can

keep this as a dashboard you could

always cut back to it if i give that a

refresh now it's going to show the one i

just starred

so yeah go and explore dune analytics if

you want to keep track of what's

happening on chain

and do give us a follow at encrypto if

you want to see us review more very

useful crypto tools until next time

goodbye