DAY | WXDAI Deposit | WXDAI Deposit USD | FOX Deposit | FOX Deposit USD | WXDAI Withdraw | WXDAI Withdraw USD | FOX Withdraw | FOX Withdraw USD | WXDAI Net Change | FOX Net Change | WXDAI Net Deposit USD | FOX Net Deposit USD | Net Deposit USD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-17 00:00:00.000 | 0 | 0 | 0 | 0 | -13.388684988 | -13.406142717 | -478.42074384 | -13.155820531 | -13.388684988 | -478.42074384 | -13.406142717 | -13.155820531 | -26.561963248 |
2 | 2025-03-11 00:00:00.000 | 76.391606111 | 76.475423618 | 2842.744478825 | 74.196270515 | 0 | 0 | 0 | 0 | 76.391606111 | 2842.744478825 | 76.475423618 | 74.196270515 | 150.671694133 |
3 | 2025-01-03 00:00:00.000 | 0 | 0 | 0 | 0 | -17.799080154 | -17.767609155 | -294.565033692 | -18.065403498 | -17.799080154 | -294.565033692 | -17.767609155 | -18.065403498 | -35.833012654 |
4 | 2024-12-09 00:00:00.000 | 0 | 0 | 0 | 0 | -213.371982252 | -212.413541979 | -2598.812266309 | -217.581550495 | -213.371982252 | -2598.812266309 | -212.413541979 | -217.581550495 | -429.995092473 |
5 | 2024-11-14 00:00:00.000 | 0 | 0 | 0 | 0 | -481.463654277 | -481.544439866 | -8923.010112177 | -466.252188431 | -481.463654277 | -8923.010112177 | -481.544439866 | -466.252188431 | -947.796628297 |
6 | 2024-10-29 00:00:00.000 | 0 | 0 | 0 | 0 | -5.211558612 | -5.222388448 | -81.032072611 | -5.310548298 | -5.211558612 | -81.032072611 | -5.222388448 | -5.310548298 | -10.532936746 |
7 | 2024-10-08 00:00:00.000 | 0 | 0 | 0 | 0 | -5.211525739 | -5.214058323 | -149.960304022 | -5.093306376 | -5.211525739 | -149.960304022 | -5.214058323 | -5.093306376 | -10.3073647 |
8 | 2024-07-21 00:00:00.000 | 0 | 0 | 0 | 0 | -58.014571135 | -57.909245681 | -932.574279503 | -57.436783587 | -58.014571135 | -932.574279503 | -57.909245681 | -57.436783587 | -115.346029269 |
9 | 2024-07-01 00:00:00.000 | 0.03025115859 | 0.03024200258 | 0.5 | 0.03001372917 | 0 | 0 | 0 | 0 | 0.03025115859 | 0.5 | 0.03024200258 | 0.03001372917 | 0.06025573174 |
10 | 2024-06-30 00:00:00.000 | 0.06524046451 | 0.0652372922 | 1.12 | 0.06656048 | 0 | 0 | 0 | 0 | 0.06524046451 | 1.12 | 0.0652372922 | 0.06656048 | 0.1317977722 |
11 | 2024-06-19 00:00:00.000 | 0 | 0 | 0 | 0 | -763.859351512 | -764.087045253 | -13175.263435207 | -763.320964444 | -763.859351512 | -13175.263435207 | -764.087045253 | -763.320964444 | -1527.408009697 |
12 | 2024-06-11 00:00:00.000 | 0.2807024407 | 0.2808557978 | 4.1 | 0.2735885583 | 0 | 0 | 0 | 0 | 0.2807024407 | 4.1 | 0.2808557978 | 0.2735885583 | 0.5544443561 |
13 | 2024-05-23 00:00:00.000 | 0 | 0 | 0 | 0 | -0.009520163138 | -0.00951926983 | -0.1136291774 | -0.009195573746 | -0.009520163138 | -0.1136291774 | -0.00951926983 | -0.009195573746 | -0.01871484358 |
14 | 2024-05-22 00:00:00.000 | 0.009454594098 | 0.009457421415 | 0.1144040861 | 0.009460917609 | 0 | 0 | 0 | 0 | 0.009454594098 | 0.1144040861 | 0.009457421415 | 0.009460917609 | 0.01891833902 |
15 | 2024-04-16 00:00:00.000 | 58.933788775 | 58.96565771 | 658.746163238 | 58.767569363 | -11.589195684 | -11.595462637 | -133.346051904 | -11.895968116 | 47.344593092 | 525.400111333 | 47.370195072 | 46.871601247 | 94.241796319 |
16 | 2024-03-29 00:00:00.000 | 93.043084032 | 93.095837321 | 867.443309116 | 88.143528091 | 0 | 0 | 0 | 0 | 93.043084032 | 867.443309116 | 93.095837321 | 88.143528091 | 181.239365412 |
17 | 2024-03-20 00:00:00.000 | 0 | 0 | 0 | 0 | -50.461399116 | -50.223972246 | -529.576823054 | -48.506222819 | -50.461399116 | -529.576823054 | -50.223972246 | -48.506222819 | -98.730195065 |
18 | 2024-03-15 00:00:00.000 | 4e-18 | 3.972073408e-18 | 4.5e-17 | 4.792238137e-18 | -1.918098572 | -1.904707083 | -18.47769432 | -1.96776692 | -1.918098572 | -18.47769432 | -1.904707083 | -1.96776692 | -3.872474003 |
19 | 2024-03-14 00:00:00.000 | 22 | 21.952176511 | 202.877298059 | 22.868607021 | 0 | 0 | 0 | 0 | 22 | 202.877298059 | 21.952176511 | 22.868607021 | 44.820783532 |
20 | 2024-03-12 00:00:00.000 | 4e-18 | 3.976856565e-18 | 4e-17 | 4.795605276e-18 | -2.53373912 | -2.519079264 | -21.253477807 | -2.548082258 | -2.53373912 | -21.253477807 | -2.519079264 | -2.548082258 | -5.067161521 |
RayyykGnosis wxDAI/FOX Pool (Asset Net Change)
Updated 8 hours ago
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 deposit as (select date_trunc('day', block_timestamp) as date,
sum(decoded_log:amount0/1e18) as fox_deposits,
sum(decoded_log:amount1/1e18) as dai_deposits
from gnosis.core.ez_decoded_event_logs
where contract_address = '0xc22313fd39f7d4d73a89558f9e8e444c86464bac'
and event_name = 'Mint'
group by 1),
withdraw as (select date_trunc('day', block_timestamp) as date,
sum(decoded_log:amount0/1e18) as fox_withdraws,
sum(decoded_log:amount1/1e18) as dai_withdraws
from gnosis.core.ez_decoded_event_logs
where contract_address = '0xc22313fd39f7d4d73a89558f9e8e444c86464bac'
and event_name = 'Burn'
group by 1),
wxdai as (select date_trunc('day', hour) as day,
avg(price) as wxdai_price
from gnosis.price.ez_prices_hourly
where symbol = 'WXDAI'
group by 1),
fox as (select date_trunc('day', hour) as day,
avg(price) as fox_price
from ethereum.price.ez_prices_hourly
where token_address = '0xc770eefad204b5180df6a14ee197d99d808ee52d' --fox
group by 1),
final as (select ifnull(a.date, b.date) as day,
ifnull(dai_deposits, 0) as "WXDAI Deposit",
ifnull(fox_deposits, 0) as "FOX Deposit",
ifnull(dai_withdraws, 0) * -1 as "WXDAI Withdraw",
ifnull(fox_withdraws, 0) * -1 as "FOX Withdraw",
"WXDAI Deposit" + "WXDAI Withdraw" as "WXDAI Net Change",
"FOX Deposit" + "FOX Withdraw" as "FOX Net Change"
from deposit a
Last run: about 8 hours agoAuto-refreshes every 24 hours
...
463
80KB
58s