Sandeshbera eth users each chain
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
›
⌄
-- forked from bera eth users @ https://flipsidecrypto.xyz/edit/queries/d5f82f81-611e-49f6-a1b1-94dcb8b87c15
-- forked from bera badge holders and minted @ https://flipsidecrypto.xyz/edit/queries/732b7e37-46ed-4665-b25d-fe0f4b1a0f5d
-- forked from Sandesh / 2024-05-20 02:24 PM @ https://flipsidecrypto.xyz/Sandesh/q/2fnIDGjjkqai/2024-05-20-02-24-pm
with res AS (
SELECT
livequery.live.udf_api(
'GET',
'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
{ 'Content-Type': 'application/json' },
{
'sheets_id' : '1_5p8UV_Ybs7yucbUJnWf5zH-ql966pO8odXSk6RHyEQ',
'tab_name' : 'addresses'
}
) as resp
),
data AS (
select resp:data as json_result_must_pivot
from res
),
bera_users AS (
SELECT
d.value:"Address"::VARCHAR as address
FROM
data,
LATERAL FLATTEN(input => data.json_result_must_pivot) d
),
number_of_eth_users as
(
select 'ethereum' as chain, count(distinct b.address) as number_of_users
from bera_users b inner join ethereum.core.fact_transactions e
on b.address=e.from_address
QueryRunArchived: QueryRun has been archived