flyingfish1 - Meteora Volume
Updated 2025-04-15
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 meteora_pools as (
select
'Meteora' as program_name
, account_address as pool_address
from solana.core.fact_token_account_owners
where 1 = 1
and owner = 'LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo'
)
/* with meteora_pools as (
select
'Meteora' as program_name
, '9d9mb8kooFfaD3SctgZtkxQypkshx6ezhbKio89ixyy2' as pool_address -- TRUMP-USDC
union all
select
'Meteora' as program_name
, '7bGcnxwxHhWKtE7L7opZPqzJH6aU3HbRbuQnrGKf8779' as pool_address -- JAILSTOOL-SOL
union all
select
'Meteora' as program_name
, 'BGm1tav58oGcsQJehL9WXBFXF7D27vZsKefj4xJKD5Y' as pool_address -- SOL-USDC
) */
, pools_tvl_init as (
select
block_timestamp
, date_trunc(week, block_timestamp) as week_
, program_name
, account_address
, owner
QueryRunArchived: QueryRun has been archived