dan-smithCurve frxETH LP Owned by Frax
Updated 2023-05-18
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
dates AS (
SELECT
*
FROM (
SELECT
dateadd(
day
,'-' || row_number() over (order by null)
,dateadd(day, '+1', date_trunc('day',current_timestamp()))
) as dt
FROM table (GENERATOR(rowcount => 3000))
)
WHERE dt >= '2022-10-13'
),
pool AS (
SELECT
date_trunc('day',dt) AS dt
,SUM(amount) AS total_lp
FROM (
SELECT
block_timestamp AS dt
,amount
,'mint' AS action
FROM ethereum.core.ez_token_transfers
WHERE
contract_address = lower('0xf43211935C781D5ca1a41d2041F397B8A7366C7A')
AND from_address = '0x0000000000000000000000000000000000000000'
UNION ALL
SELECT
block_timestamp AS dt
,-amount
,'burn' AS action
FROM ethereum.core.ez_token_transfers
WHERE
Run a query to Download Data