dr1888Inflow active users Arbitrum
Updated 2023-04-29
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 Inflow active users Ethereum @ https://flipsidecrypto.xyz/edit/queries/c996da4c-9a30-4e50-96b8-d33cbb41d183
-- forked from Inflow active users polygon @ https://flipsidecrypto.xyz/edit/queries/4b9794fc-2aec-4182-b1b8-c50fbce144f6
-- forked from Inflow amount Polygon @ https://flipsidecrypto.xyz/edit/queries/bc14126d-e398-43b3-b213-fe25def371a3
-- forked from Inflow amount @ https://flipsidecrypto.xyz/edit/queries/89b88d15-2706-4abc-a55b-2be0326b18df
with
A AS (
SELECT
TRUNC(block_timestamp, '{{Trunc}}') AS BTD,
tx_hash,
from_address,
origin_from_address,
origin_to_address,
amount_usd
FROM arbitrum.core.ez_token_transfers
WHERE block_timestamp BETWEEN '{{Start_day}}' AND '{{End_day}}'
AND
from_address
in (
lower('0x892785f33CdeE22A30AEF750F285E18c18040c3e'), lower('0xB6CfcF89a7B22988bfC96632aC2A9D6daB60d641')
)
)
select
BTD,
count(distinct origin_from_address)
FROM (
SELECT
BTD,
tx_hash,
origin_from_address,
amount_usd
FROM A
)
Run a query to Download Data