TIME | DEPOSIT_AMOUNT | DEPOSIT_CUM | WITHDRAW_AMOUNT | WITHDRAW_CUM | CUMULATIVE_TVL | |
|---|---|---|---|---|---|---|
1 | 2023-07-11 00:00:00.000 | 0.103 | 0.103 | 0.001 | 0.001 | 0.102 |
2 | 2023-07-12 00:00:00.000 | 21.224100845 | 21.327100845 | 19.184100845 | 19.185100845 | 2.142 |
3 | 2023-07-14 00:00:00.000 | 14.02 | 35.347100845 | 0.02 | 19.205100845 | 16.142 |
4 | 2023-07-15 00:00:00.000 | 1.6 | 36.947100845 | 0 | 19.205100845 | 17.742 |
5 | 2023-07-17 00:00:00.000 | 80 | 116.947100845 | 0 | 19.205100845 | 97.742 |
6 | 2023-07-18 00:00:00.000 | 28.09409 | 145.041190845 | 0 | 19.205100845 | 125.83609 |
7 | 2023-07-20 00:00:00.000 | 0.7662 | 145.807390845 | 0 | 19.205100845 | 126.60229 |
8 | 2023-07-21 00:00:00.000 | 2.958 | 148.765390845 | 20 | 39.205100845 | 109.56029 |
9 | 2023-07-22 00:00:00.000 | 0 | 148.765390845 | 80 | 119.205100845 | 29.56029 |
10 | 2023-07-23 00:00:00.000 | 0 | 148.765390845 | 0.8 | 120.005100845 | 28.76029 |
11 | 2023-07-24 00:00:00.000 | 0.5 | 149.265390845 | 0.14529 | 120.150390845 | 29.115 |
12 | 2023-07-25 00:00:00.000 | 0.06 | 149.325390845 | 18 | 138.150390845 | 11.175 |
13 | 2023-07-26 00:00:00.000 | 0.271 | 149.596390845 | 0 | 138.150390845 | 11.446 |
14 | 2023-07-27 00:00:00.000 | 8.0001 | 157.596490845 | 0 | 138.150390845 | 19.4461 |
15 | 2023-07-29 00:00:00.000 | 0.00051 | 157.597000845 | 0 | 138.150390845 | 19.44661 |
16 | 2023-08-06 00:00:00.000 | 0 | 157.597000845 | 0.7 | 138.850390845 | 18.74661 |
17 | 2023-08-08 00:00:00.000 | 0.04522 | 157.642220845 | 0 | 138.850390845 | 18.79183 |
18 | 2023-08-09 00:00:00.000 | 16.5 | 174.142220845 | 8.8 | 147.650390845 | 26.49183 |
19 | 2023-08-11 00:00:00.000 | 0 | 174.142220845 | 0.06 | 147.710390845 | 26.43183 |
20 | 2023-08-16 00:00:00.000 | 50 | 224.142220845 | 4.35457 | 152.064960845 | 72.07726 |
freemartianBolide BNB v2 Cummulative
Updated 2024-01-30
999
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 BNB_table as (
select
tx_hash,
block_timestamp,
decoded_log:depositor as actor,
decoded_log:amount / pow(10, 18) as amount,
'Deposit' as action
from
bsc.core.ez_decoded_event_logs
where
event_name = 'Deposit'
and contract_address = '0xac4a30d5343fd28afea2ea70b1dea93f35183b18'
and origin_function_signature = '0x6e553f65'
and decoded_log:token = '0x0000000000000000000000000000000000000000'
and tx_status = 'SUCCESS'
and block_timestamp > '2023-07-10'
UNION
select
tx_hash,
block_timestamp,
decoded_log:depositor as actor,
decoded_log:amount / pow(10, 18) as amount,
'Withdraw' as action
from
bsc.core.ez_decoded_event_logs
where
event_name = 'Withdraw'
and contract_address = '0xac4a30d5343fd28afea2ea70b1dea93f35183b18'
and origin_function_signature = '0x00f714ce'
and decoded_log:token = '0x0000000000000000000000000000000000000000'
and tx_status = 'SUCCESS'
and block_timestamp > '2023-07-10'
),
data AS (
select
block_timestamp :: date AS day,
Last run: about 1 year agoAuto-refreshes every 3 hours
71
5KB
16s