thisone89number of pump users with >=$25k bridged and min txs in last 30 days
Updated 2024-06-04
99999
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 Pump users txs within last 30 days on Blast @ https://flipsidecrypto.xyz/edit/queries/7efe6dad-a744-43c8-b570-f98a79dca738
with
pump_user_tx as (
select
from_address as pump_user,
count(distinct tx_hash) as nof_tx
from blast.core.fact_transactions
where status='SUCCESS'
and block_timestamp::date>= current_date - interval '30 days'
and from_address IN (
'0x6a88871f78c79f213626146659c56f79cc0256e5',
'0xfa12ed0688cff4ecf55ee7ab451e035b504685be',
'0x3bb647b2118a5d2d02c7a806a7ae55200da70737',
'0x8de44e90aabc222446e61facf6687aac0ffb7269',
'0xcb3e6f6c8d1db2a4dfcb6badcd13bd615c300f4b',
'0x66e72d7bb4e675558dd222745685eb2f57941dde',
'0x11b8e7beadc246959668ba3eff854ea9a8ee7587',
'0x4474acb17306f99ecde5330b964197681e6f580f',
'0x69325ff117b012d6c86c7160719748fa9a331b51',
'0x3f3d049b71091efc411db2754951055a45064d42',
'0x6c095335bf9095326705fa869015bb769804e0e8',
'0x026c7aa21ec422f15996d8c77348bd1a103e7159',
'0x1314989787524b13e9a9d41224d2facd66f77b28',
'0x5877a2100851abe1c00ef90950052fea168ae09d',
'0xc01117594749a68aab0d9ce62fc3eb97148adf22',
'0x38a301cfdc19b0d639cc360b228121d25957d9b5',
'0x198ca285d82887ce6803c7c1d581cbd668b6822f',
'0x77be0b7a0b7eabe4d1523e23535ae1c8d529fa0e',
'0x9671c80ffc8edf0b02f0bdcd22bf9703e9d485b5',
'0xf2d3b3187746a2d364b446472b1bd4c12932c3ab',
'0x1589dfefece5a927a64802e51968078dba3ccb60',
'0xfd826bbc9120e81097da803fecc5e610b6559815',
'0x92acaea6593badd94f764d1ef8be935d97eed197',
'0x1b6e84e6fa110a06aa9e06ff3d758323b001fa90',
'0x544575b6b7932b537daece95eeafedb56a0d0734',
QueryRunArchived: QueryRun has been archived