axl final 3-1 copy copy copy copy

Pine Analyticsaxl final 3-1 copy copy copy copy

Updated 2024-01-29

-- forked from axl final 3-1 copy copy copy @ https://flipsidecrypto.xyz/edit/queries/ede8711a-34f1-4cdf-8cb2-53b7d36579eb

-- forked from axl final 3-1 copy copy @ https://flipsidecrypto.xyz/edit/queries/d309e960-66ec-49bc-84f6-2969d03e600a

-- forked from axl final 3-1 copy @ https://flipsidecrypto.xyz/edit/queries/23e286f8-4e16-4e08-b0d0-31013daf676d

-- forked from axl final 3-1 @ https://flipsidecrypto.xyz/edit/queries/4d80f96c-682b-4efe-bdd9-4e0c9976619c

-- forked from axl final 3 @ https://flipsidecrypto.xyz/edit/queries/49a05644-47ac-401b-8af4-34cec2fb6e5e

-- forked from axl final 2 @ https://flipsidecrypto.xyz/edit/queries/618d2628-3bc0-48c1-a6ab-941435cf654f

with tab2 as (

SELECT

block_timestamp,

tx_hash,

user,

sum(CASE when flow like 'out' then -1 * amount else amount end) as net_flow

FROM (

SELECT

block_timestamp,

tx_hash,

from_address as user,

'out' as flow,

RAW_AMOUNT_PRECISE::NUMBER(38, 0) as AMOUNT

from arbitrum.core.fact_token_transfers

WHERE contract_address LIKE lower('0x23ee2343B892b1BB63503a4FAbc840E0e2C6810f')

UNION

SELECT

block_timestamp,

tx_hash,

to_address as user,

'in' as flow,

Last run: about 1 year agoAuto-refreshes every 6 hours

	HOLD_DURATION	CHAIN	HOLDER_TYPE	HOLDERS
1	a/ Below 7 Days	Arbitrum	Current Holder	28
2	e/ 180 - 360 Days	Arbitrum	Past Holder	10
3	b/ 7 - 30 Days	Arbitrum	Current Holder	74
4	c/ 30 - 90 Days	Arbitrum	Current Holder	169
5	a/ Below 7 Days	Arbitrum	Past Holder	409
6	d/ 90 - 180 Days	Arbitrum	Current Holder	161
7	e/ 180 - 360 Days	Arbitrum	Current Holder	88
8	d/ 90 - 180 Days	Arbitrum	Past Holder	47
9	f/ 360+ Days	Arbitrum	Current Holder	2
10	f/ 360+ Days	Arbitrum	Past Holder	1
11	c/ 30 - 90 Days	Arbitrum	Past Holder	116
12	b/ 7 - 30 Days	Arbitrum	Past Holder	95

595B

27s