zakkisyedBlast - Top 500 LP Providers
Updated 2024-06-25
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 LP_contracts AS (
SELECT LOWER('0x5fc21bdb763f0a84c1dec5223817b92bbabdd8e3') AS pool_address, 'Blast' AS platform
UNION
SELECT LOWER('0x4cc9959ae7a4d380c1100b271bc63d9961ca162f') AS pool_address, 'Blast' AS platform
UNION
SELECT LOWER('0x40214EDef589149b9cebb7BE7025197d885D6CB1') AS pool_address, 'Blast' AS platform
UNION
SELECT LOWER('0x3e1B017D21ad613c58F8eE2f78987b3c9F14f643') AS pool_address, 'Blast' AS platform
UNION
SELECT LOWER('0xb15911aea7e22e0f43aada43b387a84f2b56a1aa') AS pool_address, 'Blast' AS platform
UNION
SELECT LOWER('0x9bbba6322fe5f3968c1f27c8b860727d683194c8') AS pool_address, 'Blast' AS platform
UNION
SELECT LOWER('0x17f18794ece38ee3f17ab7bcc41cf99486a3b85c') AS pool_address, 'Blast' AS platform
UNION
SELECT LOWER('0xc28EffdfEF75448243c1d9bA972b97e32dF60d06') AS pool_address, 'Blast' AS platform
UNION
SELECT LOWER('0xeFdb5C31d5e1a48fC8f4856ecc922B38619b1bFf') AS pool_address, 'Blast' AS platform
)
SELECT
origin_from_address AS user_address,
SUM(amount) AS total_rseth_provided
FROM
blast.core.ez_token_transfers
WHERE
to_address IN (SELECT pool_address FROM LP_contracts)
AND contract_address = lower('0xe7903B1F75C534Dd8159b313d92cDCfbC62cB3Cd')
--,lower('0x4186bfc76e2e237523cbc30fd220fe055156b41f'))
--AND block_timestamp < '2024-05-02'
GROUP BY
origin_from_address
ORDER BY
QueryRunArchived: QueryRun has been archived