lj1024wormhole
Updated 2024-11-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
date_trunc('month', block_timestamp) date,
sum(amount) volume,
count(*) count
from solana.defi.fact_bridge_activity
where 1 = 1
and succeeded = true
and date_trunc('day', block_timestamp) between '2024-01-01' and '2024-11-01'
and mint = 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn'
group by date_trunc('month', block_timestamp)
order by date_trunc('month', block_timestamp) desc
limit 10
QueryRunArchived: QueryRun has been archived