kyuchoiGetting Started copy
Updated 2024-02-22
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
›
⌄
w-- forked from Getting Started @ https://flipsidecrypto.xyz/edit/queries/676e6ab9-f9d8-49c8-bd43-242ff3133d4e
-- 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.com/our-app/getting-started
-- select
-- *
-- from ethereum.uniswapv3.ez_swaps
-- where block_timestamp > current_date - interval '30 days'
-- and pool_address = '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640'
-- order by block_timestamp DESC
-- limit 50;
-- select count(1), 'stats' as project
-- from ethereum.uniswapv3.ez_pool_stats
-- UNION all
-- select count(1), 'swaps' as project
-- from ethereum.uniswapv3.ez_swaps
select count(*), 'stats' as project
from ethereum.uniswapv3.ez_pool_stats
where pool_address = '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640'
UNION all
select count(*), 'swaps' as project
from ethereum.uniswapv3.ez_swaps
where pool_address = '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640'
QueryRunArchived: QueryRun has been archived