DAY | SYMBOL | TRANSFERS | WALLETS | TOTAL_AMOUNT | |
|---|---|---|---|---|---|
1 | 2023-11-28 00:00:00.000 | USDA | 27 | 15 | 1675.342848733 |
2 | 2023-11-28 00:00:00.000 | USDD | 12 | 8 | 587.700357769 |
3 | 2023-11-28 00:00:00.000 | DAI | 38 | 13 | 8528.640838707 |
4 | 2023-11-28 00:00:00.000 | USDT | 8684 | 3252 | 24202484.8114283 |
5 | 2023-11-28 00:00:00.000 | BUSD | 35 | 23 | 154593.484521438 |
6 | 2023-11-29 00:00:00.000 | USDD | 2 | 2 | 0.04412425838 |
7 | 2023-11-29 00:00:00.000 | DAI | 42 | 20 | 36349.145954898 |
8 | 2023-11-29 00:00:00.000 | USDA | 25 | 17 | 982.192038698 |
9 | 2023-11-29 00:00:00.000 | BUSD | 28 | 20 | 59536.319703557 |
10 | 2023-11-29 00:00:00.000 | USDT | 7922 | 3252 | 66424618.6223374 |
11 | 2023-11-30 00:00:00.000 | BUSD | 20 | 11 | 99272.478156657 |
12 | 2023-11-30 00:00:00.000 | USDD | 6 | 4 | 24.394588105 |
13 | 2023-11-30 00:00:00.000 | USDC | 26586 | 9869 | 176048760.885705 |
14 | 2023-11-30 00:00:00.000 | USDA | 32 | 17 | 2387.704453931 |
15 | 2023-11-30 00:00:00.000 | USDT | 9814 | 4370 | 16716800.5724118 |
16 | 2023-11-30 00:00:00.000 | DAI | 42 | 24 | 11110.770793895 |
17 | 2023-12-01 00:00:00.000 | USDT | 6213 | 3222 | 15179066.3039225 |
18 | 2023-12-01 00:00:00.000 | BUSD | 19 | 12 | 40291.315144357 |
19 | 2023-12-01 00:00:00.000 | USDC | 21990 | 10000 | 101553356.928411 |
20 | 2023-12-01 00:00:00.000 | USDA | 30 | 25 | 1103.067899754 |
omer93aptos stabelcoin transfers
Updated 2024-02-02
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
›
⌄
with
prices as (
SELECT
hour,
x.token_address,
price/pow(10,decimals) as price
from aptos.price.fact_hourly_token_prices x
join aptos.price.dim_asset_metadata y on x.token_address=y.token_address
),
totals as (
SELECT
trunc(block_timestamp,'day') as day,
symbol,
count(distinct tx_hash) as transfers,
count(distinct account_address) as wallets,
SUM(AMOUNT*price) AS TOTAL_AMOUNT
FROM aptos.core.fact_transfers x
join aptos.core.dim_tokens y on x.token_address=y.token_address
join prices z on x.token_address=y.token_address and trunc(x.block_timestamp,'hour')=z.hour
GROUP BY 1,2
order by 1 asc
)
select * from totals where symbol in ('USDC','USDT','BUSD','TUSD','DAI','FRAX','USDA','USDbC','USDD') and total_amount<1e9
and day<current_date
order by 1 asc
Last run: about 1 year ago
...
404
23KB
9s