theweb3galAurora Deep dive
Updated 2025-02-13
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
27
28
29
30
31
32
33
34
35
36
›
⌄
-- Get started with Flipside by running your first query:
-- the SQL statement below will get you a list of NFT
-- platforms on Ethereum, ranked by how many sales
-- they've had in the past month.
-- Be sure to see our documentation for more guidance,
-- including a full walkthrough of the app:
-- https://docs.flipsidecrypto.xyz/our-app/getting-started
select
count(DISTINCT tx_hash) as txs,
count(DISTINCT from_address) as users,
sum(tx_fee) as fees,
extract(
month
from
BLOCK_TIMESTAMP
) as month,
extract(
year
from
BLOCK_TIMESTAMP
) as year,
extract(
day
from
BLOCK_TIMESTAMP
) as day
from
aurora.core.fact_transactions
where
status = 'SUCCESS'
and block_number >= 37157757
and extract(
year
from
BLOCK_TIMESTAMP
) >= 2021
QueryRunArchived: QueryRun has been archived