forgashBeer is NEAR, Aggregations by Customer
Updated 2022-09-14
999
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
›
⌄
WITH txs AS (
SELECT
*
FROM
near.core.fact_transactions
WHERE
block_timestamp :: DATE >= '2022-09-11'
),
usn AS (
SELECT
*
FROM
near.core.ez_usn_supply
WHERE
block_timestamp :: DATE >= '2022-09-11'
),
prices AS (
SELECT
DATE_TRUNC(
'm',
TIMESTAMP
) AS block_timestamp,
symbol,
AVG(price_usd) AS price_usd
FROM
near.core.fact_prices
WHERE
symbol = 'NEAR'
AND TIMESTAMP :: DATE >= '2022-09-11'
GROUP BY
1,
2
),
transfers AS (
SELECT
*
Run a query to Download Data