SUM(VOLUME_USD) | |
---|---|
1 | 80513202.664364 |
rain_syndicadeBridge FINAL QUERY CORRECT
Updated 2024-01-23
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
-- base_sol_tx as (
-- select distinct tx_id, index
-- from solana.core.fact_events
-- where block_timestamp >= '2023-07-01' and block_timestamp < CURRENT_DATE
-- and program_id = 'src5qyZHqTqecJV4aY6Cb6zDZLMDzrDKKezs22MPHr4'
-- )
base_sol_to as (
select distinct tx_id, index
from solana.core.fact_events
where block_timestamp >= '2023-07-01' and block_timestamp < CURRENT_DATE
and program_id = 'dst5MGcFPoBeREFAA5E3tU5ij8m5uVYwkzkSAbsLbNo'
and signers[0] in ('7FfB2zQRYUQwpPzkRxAeg2mCBGeCRKp4PCEeULJA9xTo', '2r8DCWwEeaUHNMoDzTPj7v2qnT5jtw4U4UiKu1aMXyVG', 'EePcPwmz8o2jxNd1xqyfzn2TwKN6gZv6TfAtEVi94M2u', 'BWf3qqNtJoAQxVvpggn8yW1HXXfZ4Rxc6dwYADUBEHme', '4pfzS9HmDxs4AMbbAUYjWvpfLoNKYMk4B75nerNZC2bB', '6qPkNbWQmyufAtgKD37NFTRzBomd4pMav35ia3xUzsYe', 'E3Z9rpFKgBU7dAUixHccdHkMM6H2FfBdeMHANVP7brA5')
)
, solana_price as (
select recorded_hour::date as price_date,
upper(symbol) as symbol,
token_address,
avg(close) as price
from solana.price.ez_token_prices_hourly
group by 1,2,3
)
, sol_price as (
select recorded_hour::date as price_date,
upper(symbol) as symbol,
token_address,
avg(close) as sol_price
from solana.price.ez_token_prices_hourly
where upper(symbol) = 'SOL'
group by 1,2,3
)
-- , from_solana as (
-- select block_timestamp::date as date,
-- 'From' as route_type,
-- 'Solana' as chain,
Last run: about 1 year ago
1
19B
54s