saadiqToobins Run: Txns/day
Updated 2023-08-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
-- forked from Toobins Run @ https://flipsidecrypto.xyz/edit/queries/e82d764c-a81d-48ed-b02b-d5123c718e68
WITH
txns AS (
select
ROW_NUMBER() OVER (
ORDER BY
block_timestamp ASC
) AS row_num,
block_timestamp,
nft_to_address,
nft_from_address
from
ethereum.core.ez_nft_transfers t
where
t.nft_address = lower('0xd6059164237F6dC4dF777714437c37CC85256089')
and t.tokenid = 0
)
select
left(t.block_timestamp, 10) as day,
count(1) as txns
from
txns t
group by
day
order by
day desc
Run a query to Download Data