Flipside Community2a) Backup : popular apps among new users polygon copy
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
›
⌄
-- forked from 2a) popular apps among new users polygon @ https://flipsidecrypto.xyz/edit/queries/6aa328a2-f647-4d89-8d83-520e67d6e9c6
-- forked from 2a) popular apps among new users Arbitrum @ https://flipsidecrypto.xyz/edit/queries/d16c95d1-0b28-41b3-a220-5ab32e440800
-- forked from 2a) popular apps among new users optimism @ https://flipsidecrypto.xyz/edit/queries/2dac8520-2500-49d6-861a-52244ead6f7c
-- forked from 2a) popular apps among new users optimism @ https://flipsidecrypto.xyz/edit/queries/81e6f7eb-8f38-475a-b4c1-a77e1a549069
-- forked from 2a) popular apps among new users @ https://flipsidecrypto.xyz/edit/queries/55a92b86-1d0c-4bd8-920d-4c95a2745bce
-- forked from 2a) popular apps among new users @ https://flipsidecrypto.xyz/edit/queries/956394e3-fe4f-4801-b8b3-68e508994b63
with addresses as
(
select from_address, min(block_timestamp) as first_transaction_sent
from polygon.core.fact_transactions
group by from_address
having first_transaction_sent >= '{{Start_date}}'
),
all_transactions as
(
select * from polygon.core.fact_transactions
where 1=1
and block_timestamp >= '{{Start_date}}'
and from_address in ( select from_address from addresses)
),
top_apps as (
select to_address, count(distinct from_address) as new_user
from all_transactions ft
group by to_address
order by new_user desc
limit 200
),
top_200 as
(
Run a query to Download Data