bbashGetting Started
Updated 2024-12-23
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
›
⌄
-- 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 * from ethereum.core.ez_current_balances
--where user_address='0x845e4DEB40087675A5225Eae22E18D92883C7A19'
select
block_timestamp :: DATE as date,
count(*) as txhash
from ethereum.core.fact_transactions
where block_timestamp :: DATE between '2024-12-01' and '2024-12-15'
group by date
order by txhash ASC
QueryRunArchived: QueryRun has been archived