Flipside and build some Polygon statistics.
About this topic:
This topic is about how to use Flipside to build some Polygon blockchain statistics
Flipside link: https://flipsidecrypto.xyz/
To learn more about Polygon blockchain, visit https://polygon.technology/.
Polygon transactions by day
How do you find a suitable table for this query?
By using Explore Data, we will choose Polygon
We will search for tables and select the required table.
By clicking on the table we want, we can browse and display the fields in it.
Now back to Polygon Transactions Day.
The suggested SQL statement is the following:
SELECT
date_trunc('day', block_timestamp) as day
COUNT(DISTINCT tx_hash) as transactions_count
FROM polygon.core.fact_transactions
WHERE day >= CURRENT_DATE - 90
GROUP BY 1
We will work on the polygon.core.fact_transactions table and make the query for 90 days only.
After adding the query, a graphic form can be added based on it.
Polygon addresses day
The suggested SQL statement is the following:
SELECT
date_trunc('day', block_timestamp) as day
COUNT(DISTINCT from_address) as unique_addresses
FROM polygon.core.fact_transactions
WHERE day >= CURRENT_DATE - 90
GROUP BY 1
Polygon gas price
The suggested SQL statement is the following:
select
date_trunc('day',block_timestamp) as day,
Avg(gas_price) as
gas_price
From polygon.core.fact_transactions
Where day >=
CURRENT_DATE - 90
Group by 1 Order by 1 asc
Polygon fees last 3 months.
The suggested SQL statement is the following:
select sum(tx_fee) as fee_tx
from
polygon.core.fact_transactions
where block_timestamp >=
CURRENT_DATE – 90
Polygon fee day
The suggested SQL statement is the following:
select date_trunc('day', block_timestamp) as day, sum(tx_fee) as
fee_tx
from polygon.core.fact_transactions
where day >=
CURRENT_DATE - 90
group by 1
Now build a dashboard.
We can build dashboards.
Just add the queries to the dashboard and coordinate and arrange.
