Date | Gas Station Visits | Gas Station Visitors | Total Gas Supplied | |
|---|---|---|---|---|
1 | 2024-11-06 00:00:00.000 | 3 | 1 | 0.4857095047 |
2 | 2024-11-07 00:00:00.000 | 58 | 31 | 327.492348974 |
3 | 2024-11-08 00:00:00.000 | 36 | 34 | 238.948123974 |
4 | 2024-11-09 00:00:00.000 | 87 | 66 | 906.79690355 |
5 | 2024-11-10 00:00:00.000 | 97 | 81 | 502.501909928 |
6 | 2024-11-11 00:00:00.000 | 77 | 68 | 375.681617743 |
7 | 2024-11-12 00:00:00.000 | 126 | 120 | 859.160563162 |
8 | 2024-11-13 00:00:00.000 | 56 | 54 | 349.613125855 |
9 | 2024-11-14 00:00:00.000 | 37 | 36 | 264.664105486 |
10 | 2024-11-15 00:00:00.000 | 80 | 70 | 484.184735701 |
11 | 2024-11-16 00:00:00.000 | 121 | 98 | 696.251475322 |
12 | 2024-11-17 00:00:00.000 | 88 | 80 | 435.705456423 |
13 | 2024-11-18 00:00:00.000 | 115 | 96 | 916.212371965 |
14 | 2024-11-19 00:00:00.000 | 104 | 91 | 454.948043439 |
15 | 2024-11-20 00:00:00.000 | 105 | 90 | 588.58202396 |
16 | 2024-11-21 00:00:00.000 | 119 | 86 | 903.179263118 |
17 | 2024-11-22 00:00:00.000 | 159 | 141 | 1473.263070888 |
18 | 2024-11-23 00:00:00.000 | 75 | 70 | 1082.48277615 |
19 | 2024-11-24 00:00:00.000 | 101 | 79 | 840.643597563 |
20 | 2024-11-25 00:00:00.000 | 84 | 69 | 2734.256803094 |
hbd199402 - Daily Usage
Updated 2025-01-19
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
›
⌄
----------------------------------------------------- Adding Tokens and Symbols -----------------------------------------------------
WITH tokens AS (
select
token_address as token,
name,
symbol,
uri
FROM $query('b227b22d-94d7-49d7-951a-309cb1755c73')),
----------------------------------------------------- Pool Creations -----------------------------------------------------
pools as (
select
BLOCK_TIMESTAMP as creation_date,
INSTRUCTION:accounts[1] as tokenMintA,
b.symbol as tokenMintA_symbol,
INSTRUCTION:accounts[2] as tokenMintB,
c.symbol as tokenMintB_symbol,
tokenMintB_symbol || ' - ' || tokenMintA_symbol as pool_name,
INSTRUCTION:accounts[5] as pool_funder,
INSTRUCTION:accounts[6] as pool_address,
INSTRUCTION:accounts[7] as tokenVaultA,
INSTRUCTION:accounts[8] as tokenVaultB,
case
when INSTRUCTION:accounts[9] = '9ZhzuqjANw7T8Q8KWErXELrx9ZMArUdXAUmoJ9qBGuUS' then '0.01' when INSTRUCTION:accounts[9] = 'BWhUdrPPor8gxya47efretmwTtkCpFQxDiK8eRDV4ibE' then '0.02'
when INSTRUCTION:accounts[9] = '9uqkUhxV5Gu3yMKSQ9Baavj3ky8MkVDp925XNfCng1dy' then '0.05' when INSTRUCTION:accounts[9] = 'ELt2ABgf4BpXZhKLcxKCg3QJb7WGtcz9ACGcHc6pFvaG' then '0.1'
when INSTRUCTION:accounts[9] = '2G1aYAbxbwHLUV74HZ1gFdj6eftPiwKx9yRsSsMeCXSq' then '0.15' when INSTRUCTION:accounts[9] = 'DT3cBTV8RMkNRLGV4S7Xj7QbbxrZvPG3kPYq2YnstEnn' then '0.3'
when INSTRUCTION:accounts[9] = 'Cu433u9MsEH57ZFJC4Pw9DT97PSgeVF4EY1YoLfUwRze' then '0.65' when INSTRUCTION:accounts[9] = '7wAquQD66tK61wzM45uG8S3cHTKho1gknydE8qzDnV18' then '1'
when INSTRUCTION:accounts[9] = '8ESd9eMrLUGveZGSKg2Fw9wKGD5oWzy41RAPfeZQNUrQ' then '1' when INSTRUCTION:accounts[9] = 'Hb1U1qAm1ZQYR4rJgDhGusPGUzkW4yjF3Ak7J9fZ8VHG' then '2'
end as fee_percent
from eclipse.core.fact_events a
left join tokens b on b.TOKEN = a.INSTRUCTION:accounts[1]
left join tokens c on c.TOKEN = a.INSTRUCTION:accounts[2]
where substr(replace(substr(utils.udf_base58_to_hex(INSTRUCTION:data),3,1000), ''),0,16) = 'cf2d57f21b3fcc43'
order by 1, INDEX),
Last run: 3 months ago
75
4KB
71s