cheeyoung-kekAlgorand wallets differences
Updated 2022-07-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with first_half_2022 as(
SELECT
count(distinct sender) as first_half2022
FROM algorand.application_call_transaction
WHERE BLOCK_TIMESTAMP >='2022-01-01' and BLOCK_TIMESTAMP <'2022-06-30'
),
second_half_2021 as (
SELECT
count(distinct sender) as second_half2021
FROM algorand.application_call_transaction
WHERE BLOCK_TIMESTAMP >='2021-07-01' and BLOCK_TIMESTAMP <'2021-12-30'
)
select first_half2022 - second_half2021 as Differences, first_half2022, second_half2021 from first_half_2022 join second_half_2021
Run a query to Download Data