0xgabeGetting Started
Updated 2024-07-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- 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
solana.core.fact_transfers
WHERE
MINT = 'METAewgxyPbgwsseH8T16a39CQ5VyVxZi9zXiDPY18m'
-- This is the amount of MPLX 30000 ~ $10k
AND AMOUNT > 30000
AND BLOCK_TIMESTAMP >= date_trunc('month', DATEADD('month', -6, CURRENT_DATE))
QueryRunArchived: QueryRun has been archived