emferonsGetting Started
Updated 2024-10-30
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
›
⌄
-- 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
-- platform_name,
-- count(*) as sales_count
--from ethereum.nft.ez_nft_sales
--where block_timestamp > current_date - interval '30 days'
--group by platform_name
--order by sales_count desc
--limit 8
--select *
--from ethereum.core.dim_contracts
--limit 10
SELECT *
FROM solana.core.fact_transfers
where TX_TO = 'br1xwubggTiEZ6b7iNZUwfA3psygFfaXGfZ1heaN9AW'
QueryRunArchived: QueryRun has been archived