freemartianDaily Deposits & Withdrawal
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
temps AS (
SELECT
block_timestamp::date AS temp_day,
symbol AS temp_symbol
FROM ethereum.core.ez_token_transfers
WHERE block_timestamp::date >= '2024-06-11'
AND symbol IN ('WBTC','tBTC','LsETH','wBETH','ETHx','wstETH','osETH','sfrxETH','sUSDe','ENA','swETH','rETH','ETHFI','cbETH','FXS','mETH')
GROUP BY 1,2
ORDER BY 1 ASC
),
deposits AS(
SELECT
block_timestamp::date AS deposit_day,
symbol AS deposit_token,
count(tx_hash) AS deposit_transactions,
count(DISTINCT origin_from_address) AS depositors,
SUM(amount) AS deposit_amount,
SUM(amount_usd) AS deposit_amount_usd,
FROM ethereum.core.ez_token_transfers
WHERE
to_address IN (
'0xc329400492c6ff2438472d4651ad17389fcb843a',
'0xb26ff591f44b04e78de18f43b46f8b70c6676984',
'0x422f5accc812c396600010f224b320a743695f85',
'0x03bf48b8a1b37fbead1ecabcf15b98b924ffa5ac',
'0x475d3eb031d250070b63fa145f0fcfc5d97c304a',
'0x38b86004842d3fa4596f0b7a0b53de90745ab654',
'0x5198cb44d7b2e993ebdda9cad3b9a0eaa32769d2',
'0xbdea8e677f9f7c294a4556005c640ee505be6925',
'0xe39b5f5638a209c1a6b6cdffe5d37f7ac99fcc84',
'0x19d0d8e6294b7a04a2733fe433444704b791939a',
'0x971e5b5d4baa5607863f3748febf287c7bf82618',
'0x0c969cec0729487d264716e55f232b404299032c',
'0xb09a50acfff7d12b7d18adef3d1027bc149bad1c',
'0x52cb8a621610cc3ccf498a1981a8ae7ad6b8ab2a',
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived