alitaslimiCategories
Updated 2024-05-20
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
-------------------- Tokens --------------------
tokens as (
select
ft.value:SYMBOL as symbol,
ft.value:CONTRACT_ADDRESS as contract_address,
ft.value:CATEGORY as category
from (
select
livequery.live.udf_api (
'https://flipsidecrypto.xyz/api/v1/queries/2a812653-c1ee-44b0-9240-3f7d9ef5c0db/data/latest'
):data as data
) lq,
table(flatten(input => lq.data)) ft
),
-------------------- Prices --------------------
prices as (
select
symbol,
price
from
avalanche.price.ez_hourly_token_prices
where
token_address in (select contract_address from tokens)
qualify
hour = last_value(hour) over (order by hour)
),
-------------------- Transfers --------------------
transfers as (
select
to_address as address,
symbol,
sum(amount) as volume
from
avalanche.core.ez_token_transfers
where