
Forget Market Cap — Here’s the Real Size of BTC, ETH & SOL
Exchange-liquidity data sourced from CoinGlass (https://coinglass.com/).

"Simon Tadros": A Lebanese Tech Entrepreneur's Harrowing Journey Through Belgian Justice: The Untold…
There is no crueler tyranny than that which is perpetuated under the shield of law and in the name of justice." ~ Baron de Montesquieu NIHDay 764 …ArabnetMy name is Simon Tadros, a Lebanese serial crypto entrepreneur and layer 2 engineer, and I have endured numerous injustices and unfair treatment on Belgian soil. In this blog post, I aim to shed light on the profound challenges I have faced and the inhuman conditions imposed upon me. From my unjust detention to the deprivation of my basic hu...

ETHIQ AIRDROP
How to Earn Your Share of the $500,000 USDC + 50,000,000 $ETHIQ Reward ETHIQ’s Proof of Solidarity Airdrop is officially live.
<100 subscribers

Forget Market Cap — Here’s the Real Size of BTC, ETH & SOL
Exchange-liquidity data sourced from CoinGlass (https://coinglass.com/).

"Simon Tadros": A Lebanese Tech Entrepreneur's Harrowing Journey Through Belgian Justice: The Untold…
There is no crueler tyranny than that which is perpetuated under the shield of law and in the name of justice." ~ Baron de Montesquieu NIHDay 764 …ArabnetMy name is Simon Tadros, a Lebanese serial crypto entrepreneur and layer 2 engineer, and I have endured numerous injustices and unfair treatment on Belgian soil. In this blog post, I aim to shed light on the profound challenges I have faced and the inhuman conditions imposed upon me. From my unjust detention to the deprivation of my basic hu...

ETHIQ AIRDROP
How to Earn Your Share of the $500,000 USDC + 50,000,000 $ETHIQ Reward ETHIQ’s Proof of Solidarity Airdrop is officially live.


http://dune.com is an online solution that anyone can create SQL queries on blockchain data for free. The results are visualized as charts.
In this example i compare zksync vs arbitrum vs optimism vs polygon by size of daily depositor you can find the sql query at
https://dune.com/queries/1493205
Code Sample :
with zksync_summary as (
with depositors as (SELECT date, count(USER) AS deposits
FROM
(SELECT min(date) AS date,
account AS USER
FROM
(SELECT date_trunc('day', min(evt_block_time)) AS date, "from" AS account
FROM erc20."ERC20_evt_Transfer"
where (
"to" = '\xaBEA9132b05A70803a4E85094fD0e1800777fBEF' )
and evt_block_time >'2020-06-01'
and evt_block_time >= now() - interval '{{in _ days}} days'
-- AND evt_block_time >= '{{date}}'
-- AND evt_block_time < (DATE_TRUNC('day',CURRENT_TIMESTAMP))
GROUP BY 2) AS a
GROUP BY 2) AS b
GROUP BY 1
ORDER BY 1),
depositors_eth as (SELECT date, count(USER) AS deposits_eth
FROM
(SELECT min(date) AS date,
account AS USER
FROM
(SELECT date_trunc('day', min(block_time)) AS date, "from" AS account
FROM ethereum.transactions
WHERE ("to" = '\xaBEA9132b05A70803a4E85094fD0e1800777fBEF' )
and block_time >'2020-06-01'
and block_time >= now() - interval '{{in _ days}} days'
-- AND evt_block_time >= '{{date}}'
-- AND evt_block_time < (DATE_TRUNC('day',CURRENT_TIMESTAMP))
GROUP BY 2) AS a
GROUP BY 2) AS b
GROUP BY 1
ORDER BY 1),
bridge_interactions as (
select COALESCE(depositors.date, depositors_eth.date) AS "date", deposits+deposits_eth as total_deposits, sum(deposits+deposits_eth) over (order by depositors.date) as cumlative_deposits
from depositors FULL OUTER JOIN depositors_eth on depositors_eth.date = depositors.date
)
SELECT 'zksync' as bridge_name, *
FROM bridge_interactions
order by date DESC
)
You can Find the comparison here but setting the duration by day and query the blockchain .
https://dune.com/spuriousdragon/zkrollups
Dune is the best product to query the blockchain it gives u the ability to visualize nfts defi bridges lending platforms on multiple chain .
it a must try powerfull product
http://dune.com is an online solution that anyone can create SQL queries on blockchain data for free. The results are visualized as charts.
In this example i compare zksync vs arbitrum vs optimism vs polygon by size of daily depositor you can find the sql query at
https://dune.com/queries/1493205
Code Sample :
with zksync_summary as (
with depositors as (SELECT date, count(USER) AS deposits
FROM
(SELECT min(date) AS date,
account AS USER
FROM
(SELECT date_trunc('day', min(evt_block_time)) AS date, "from" AS account
FROM erc20."ERC20_evt_Transfer"
where (
"to" = '\xaBEA9132b05A70803a4E85094fD0e1800777fBEF' )
and evt_block_time >'2020-06-01'
and evt_block_time >= now() - interval '{{in _ days}} days'
-- AND evt_block_time >= '{{date}}'
-- AND evt_block_time < (DATE_TRUNC('day',CURRENT_TIMESTAMP))
GROUP BY 2) AS a
GROUP BY 2) AS b
GROUP BY 1
ORDER BY 1),
depositors_eth as (SELECT date, count(USER) AS deposits_eth
FROM
(SELECT min(date) AS date,
account AS USER
FROM
(SELECT date_trunc('day', min(block_time)) AS date, "from" AS account
FROM ethereum.transactions
WHERE ("to" = '\xaBEA9132b05A70803a4E85094fD0e1800777fBEF' )
and block_time >'2020-06-01'
and block_time >= now() - interval '{{in _ days}} days'
-- AND evt_block_time >= '{{date}}'
-- AND evt_block_time < (DATE_TRUNC('day',CURRENT_TIMESTAMP))
GROUP BY 2) AS a
GROUP BY 2) AS b
GROUP BY 1
ORDER BY 1),
bridge_interactions as (
select COALESCE(depositors.date, depositors_eth.date) AS "date", deposits+deposits_eth as total_deposits, sum(deposits+deposits_eth) over (order by depositors.date) as cumlative_deposits
from depositors FULL OUTER JOIN depositors_eth on depositors_eth.date = depositors.date
)
SELECT 'zksync' as bridge_name, *
FROM bridge_interactions
order by date DESC
)
You can Find the comparison here but setting the duration by day and query the blockchain .
https://dune.com/spuriousdragon/zkrollups
Dune is the best product to query the blockchain it gives u the ability to visualize nfts defi bridges lending platforms on multiple chain .
it a must try powerfull product
Share Dialog
Share Dialog
No comments yet