ymseok-db2Y8CGetting Started
Updated 2024-09-12
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
›
⌄
-- 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
WITH DATA AS (
select
DATE(block_timestamp) tx_date,
origin_from_address
from kaia.core.ez_token_transfers
where block_timestamp > current_date - interval '30 days'
AND SYMBOL='MBX'
),
CHART_DATA AS (
SELECT tx_date, COUNT(DISTINCT origin_from_address) active_address
FROM DATA
GROUP BY tx_date
)
SELECT * FROM CHART_DATA
ORDER BY tx_date
QueryRunArchived: QueryRun has been archived