brian-terraNEAR Combined Bridges - Daily Stats
Updated 2024-12-14
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
pricet as (
select
hour::date as date,
decimals,
token_address,
symbol,
avg(price) as price_usd
from
near.price.ez_prices_hourly
group by 1, 2, 3, 4
),
main as (
select
tx_hash,
block_timestamp,
args:amount as amount_unadj,
args:receiver_id::string as user,
receiver_id as token_address
from
near.core.fact_actions_events_function_call
where
predecessor_id = 'aurora'
and signer_id = 'relay.aurora'
and receipt_succeeded
and tx_hash in (select distinct tx_hash from near.core.fact_actions_events_function_call where logs::string ilike '%0xe93685f3bba03016f02bd1828badd6195988d950%')
),
final as (
select
main.tx_hash,
main.block_timestamp,
main.amount_unadj::float,
main.user,
QueryRunArchived: QueryRun has been archived