_DATE | BLOCKCHAIN | GROSS_AMOUNT_USD | |
|---|---|---|---|
1 | 2024-11-05 00:00:00.000 | near | 19.26680598 |
2 | 2024-11-06 00:00:00.000 | base | 18.284736 |
3 | 2024-11-06 00:00:00.000 | eth | 117.066088852 |
4 | 2024-11-06 00:00:00.000 | near | 21.188919617 |
5 | 2024-11-07 00:00:00.000 | arb1 | 365.776564259 |
6 | 2024-11-07 00:00:00.000 | base | 74.484724323 |
7 | 2024-11-07 00:00:00.000 | btc | 30.55590549 |
8 | 2024-11-07 00:00:00.000 | eth | 521.816357897 |
9 | 2024-11-07 00:00:00.000 | near | 66.973712073 |
10 | 2024-11-08 00:00:00.000 | arb1 | 3.732692101 |
11 | 2024-11-08 00:00:00.000 | base | 7.278455369 |
12 | 2024-11-08 00:00:00.000 | btc | 8.03001982 |
13 | 2024-11-08 00:00:00.000 | eth | 228.300293806 |
14 | 2024-11-08 00:00:00.000 | near | 18.677499504 |
15 | 2024-11-09 00:00:00.000 | arb1 | 2.688661013 |
16 | 2024-11-09 00:00:00.000 | base | 49.930091969 |
17 | 2024-11-09 00:00:00.000 | btc | 59.78706266 |
18 | 2024-11-09 00:00:00.000 | eth | 283.709536953 |
19 | 2024-11-09 00:00:00.000 | near | 10.066867373 |
20 | 2024-11-10 00:00:00.000 | arb1 | 205.328884985 |
Flipside TeamNEP245 - Transfer Volume
Updated 8 hours ago
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
›
⌄
-- forked from NEP245 - Net Chain Mint Volume, over time @ https://flipsidecrypto.xyz/studio/queries/b93dd1a6-4386-4c6c-80dc-be2ae64d4765
with source_data AS (
SELECT
*
from
near.defi.ez_intents
where
log_event = 'mt_transfer'
-- there are multiple transfers per receipt as the intent is solved
qualify(row_number() over (partition by receipt_id order by block_id desc, amount_usd is not null desc) = 1)
)
select
date_trunc('day', block_timestamp) as _date,
blockchain,
sum(zeroifnull(amount_usd)) as gross_amount_usd
from
source_data
group by
1,
2
order by
1,
2
Last run: about 8 hours agoAuto-refreshes every 24 hours
...
1376
65KB
6s