TRANSACTIONS | TOTAL_DEPOSITORS | TOTAL_AMOUNT_STAKED | TOTAL_AMOUNT_USD_STAKED | TOTAL_AMOUNT_OUT | |
|---|---|---|---|---|---|
1 | 2590 | 575 | 27306732.0548173 | 2790690.33200358 | 11706709.6189467 |
pepperatzitotal deposits of $GRND in USD
Updated 2025-02-24
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 raw AS (
SELECT
block_timestamp,
tx_hash,
from_address,
to_address,
left(input, 10) AS function_signature,
input,
output
FROM kaia.core.fact_traces
WHERE to_address = '0x9bcb2efc545f89986cf70d3adc39079a1b730d63'
AND identifier = 'CALL_ORIGIN'
AND tx_succeeded = 'true'
),
base AS (
SELECT
block_timestamp,
tx_hash,
from_address AS user,
to_address AS token_out,
regexp_substr_all(substr(input, 11), '.{64}') AS segmented,
'0x' || substr(segmented[0], 25)::string AS first,
'0x' || substr(segmented[1], 25)::string AS second,
livequery.utils.udf_hex_to_int(output) AS amount
FROM raw
WHERE function_signature = '0x6e553f65'
),
finals AS (
SELECT
date_trunc('hour', block_timestamp) AS date,
tx_hash,
user,
'0x84f8c3c8d6ee30a559d73ec570d574f671e82647' AS token_in,
'GRND' AS symbol_in,
Last run: 2 months ago
1
63B
43s