freemartianTotal Deposits & Withdrawal (per Token)
Updated 2024-09-02
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
›
⌄
with
prices AS (
SELECT symbol, price
FROM ethereum.price.ez_prices_hourly
WHERE
-- symbol IN ('WBTC','tBTC','LsETH','wBETH','ETHx','wstETH','osETH','sfrxETH','sUSDe','ENA','swETH','rETH','ETHFI','cbETH','FXS','mETH')
-- AND
hour = TO_CHAR(DATEADD(hour, -2, current_timestamp), 'YYYY-MM-DD HH24:00:00.000')
),
deposits AS(
SELECT
t.symbol,
count(tx_hash) AS deposit_transactions,
count(DISTINCT origin_from_address) AS depositors,
SUM(amount) AS deposit_amount,
SUM(amount*price) AS deposit_amount_usd,
FROM ethereum.core.ez_token_transfers t
INNER JOIN prices p ON (p.symbol = UPPER(t.symbol))
WHERE
to_address IN (
'0xc329400492c6ff2438472d4651ad17389fcb843a',
'0xb26ff591f44b04e78de18f43b46f8b70c6676984',
'0x422f5accc812c396600010f224b320a743695f85',
'0x03bf48b8a1b37fbead1ecabcf15b98b924ffa5ac',
'0x475d3eb031d250070b63fa145f0fcfc5d97c304a',
'0x38b86004842d3fa4596f0b7a0b53de90745ab654',
'0x5198cb44d7b2e993ebdda9cad3b9a0eaa32769d2',
'0xbdea8e677f9f7c294a4556005c640ee505be6925',
'0xe39b5f5638a209c1a6b6cdffe5d37f7ac99fcc84',
'0x19d0d8e6294b7a04a2733fe433444704b791939a',
'0x971e5b5d4baa5607863f3748febf287c7bf82618',
'0x0c969cec0729487d264716e55f232b404299032c',
'0xb09a50acfff7d12b7d18adef3d1027bc149bad1c',
'0x52cb8a621610cc3ccf498a1981a8ae7ad6b8ab2a',
'0x21dbba985eea6ba7f27534a72ccb292eba1d2c7c',
'0x940750a267c64f3bbce31b948b67cd168f0843fa'
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived