No Data to Display
pepperatzi24 hrs Volume of your Favourite Ai Agent
Updated 2025-06-04
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
›
⌄
-- this metrics of this query was inspired from the dashboard of pumpfun.token by hrst
-- link to his dashboard: https://flipsidecrypto.xyz/hrst79/pumpfun-tokens-screener-Ws12uc
with launched as (
SELECT
date_trunc('day',block_timestamp) as launched_date,
decoded_log:token::string as launched_token
FROM base.core.ez_decoded_event_logs
where contract_address = lower('0xF66DeA7b3e897cD44A5a231c61B6B4423d613259')
and event_name = 'Launched'
),
graduated as (
SELECT
date_trunc('day', block_timestamp) as graduation_date,
decoded_log:agentToken::string as graduated_token
FROM base.core.ez_decoded_event_logs
where contract_address = lower('0xF66DeA7b3e897cD44A5a231c61B6B4423d613259')
and event_name = 'Graduated'
),
names as (
SELECT
graduated_token,
name,
symbol,
datediff('day', graduation_date, current_Date()) as days_since_graduation
from graduated left join base.core.dim_contracts on graduated_token = address
),
virtual_price as (
SELECT
hour,
token_address,
price
from base.price.ez_prices_hourly
Last run: 14 days ago
0
2B
1s