buzzresearchUsers daily by transaction type
Updated 2024-09-24
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 FilteredTransfers AS (
-- Withdrawal: User sends funds to the pool
SELECT
DATE_TRUNC('week', block_timestamp) AS week,
from_address AS user,
'withdrawal' AS transaction_type
FROM ethereum.core.ez_native_transfers
WHERE
to_address IN (
'0xaa0A1EfD35d6578ea6B5704dbc2c40B36A55B590',
'0xACB886b75D76d1c8d9248cFdDfA09b70C71c5393',
'0xdDa53E23f8a32640b04D7256e651C1db98dB11C1',
'0x994e3B01D130944a3E67BFd3B8Fc73069b959FEc',
'0x5557408ab14013ce9Dbb300dE0D87D386BB09cb6',
'0x59191bD38EBA4a642C9FEc308dc188731b229822',
'0xE3d981643b806FB8030CDB677D6E60892E547EdA',
'0xF2dc77c697e892542cC53336178a78Bb313DFDC7',
'0x0d9f416260598313Be6FDf6B010f2FbC34957Cd0',
'0x5fF93263D5181b2A826f8c51d54BC0da2d20D50a',
'0x0640c9377a4fAC00225097EACbB0295f4D5fbd76',
'0xEEAfA156A5dd3811Ee0D9F91db57A77eA53A8d31',
'0xA67fc05D295d2Be6bC4cBfad4f880c1c58734212',
'0x3f6ce1b36e5120bbc59d0cfe8a5ac8b6464ac1f7',
'0x091df5e1284e49fa682407096ad34cfd42b95b72',
'0x8adee124447435fe03e3cd24df3f4cae32e65a3e',
'0x450d55a4b4136805b0e5a6bb59377c71fc4facbb'
)
UNION ALL
-- Deposit: User receives funds from the pool
SELECT
DATE_TRUNC('week', block_timestamp) AS week,
to_address AS user,
'deposit' AS transaction_type
FROM ethereum.core.ez_native_transfers