TOTAL_ORE_BRIDGED | |
|---|---|
1 | 15153.049279 |
MetaLightTotal Ore Bridged
Updated 2025-02-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
SUM(b.burn_amount / 1e9) AS total_ore_bridged
FROM
solana.defi.fact_token_burn_actions b
JOIN
solana.core.fact_events e
ON
b.tx_id = e.tx_id
WHERE
b.succeeded
AND e.program_id = 'oreV2ZymfyeXgNgBdqMkumTqqAprVqgBWQfoYkrtKWQ'
AND e.instruction:accounts[2] = 'oreoU2P8bN6jkk3jbaiVxYnG1dCXcYxwhwyK9jSybcp'
AND e.instruction:accounts[3] = 'oreoN2tQbHXVaZsr3pf66A48miqcBXCDJozganhEJgz'
AND CAST(e.block_timestamp AS DATE) > CURRENT_DATE - INTERVAL '365 days';
Last run: about 2 months ago
1
16B
43s