FLIPSIDE 1

Updated 2024-09-23

--SELECt count(tx_hash)as no_of_txns

--from ethereum.core.fact_transactions

--where block_timestamp > '2024-07-01'

--SELECt date_trunc(day, block_timestamp) as date,

--select block_timestamp:: date as date, [TOTAL NO OF TXNS BY DAY IN JANUARY]

--count(tx_hash)as no_of_txns

--from ethereum.core.fact_transactions

--where block_timestamp between '2024-01-01' and '2024-02-01'

--group by date

--order by datE desc

--with lilpudgys as --(top buyers of lilpudgys)

--(

--select *

--from ethereum.nft.ez_nft_sales

--where nft_address = lower ('0x524cAB2ec69124574082676e6F654a18df49A048')

--and block_timestamp :: date >= '2024-01-01'

--)

--select buyer_address,

--count (distinct tokenid) as n_nfts

--from lilpudgys

--group by buyer_address

--order by n_nfts desc

--limit 10

--Identifying the Most Active Liquidity Pool by txns for Each Platform Since January 2024

With pools as (

select

Count(distinct tx_hash) as No_txn,

Platform,

Pool_name

from ethereum.defi.ez_dex_swaps

where block_timestamp >= '2024-01-01'

Group by 2,3

)

SELECT

Platform,

QueryRunArchived: QueryRun has been archived

flipside