check_skedAVERAGE USDT TRANSFER SIZE
Updated 2023-05-11Copy Reference Fork
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
›
⌄
WITH daily_avg AS (
SELECT
DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS dt,
CASE
WHEN DATE_TRUNC('DAY', BLOCK_TIMESTAMP) >= '2023-03-08' AND DATE_TRUNC('DAY', BLOCK_TIMESTAMP) <= '2023-03-13' THEN 'SVB_COLLAPSE'
ELSE 'USDT_VOLUME'
END AS bar_name,
AVG(AMOUNT_USD) AS avg_transfer
FROM
ethereum.core.ez_token_transfers
WHERE
DATE_TRUNC('DAY', BLOCK_TIMESTAMP) >= '2023-01-01'
AND CONTRACT_ADDRESS = '0xdac17f958d2ee523a2206206994597c13d831ec7'
GROUP BY
dt,
bar_name
)
SELECT
dt,
bar_name,
avg_transfer,
AVG(avg_transfer) OVER (ORDER BY dt ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) AS avg_transfer_30sma
FROM
daily_avg
ORDER BY
dt;
Run a query to Download Data