Getstancollective-lavender
Updated 2024-11-21
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
›
⌄
-- aptos.core.fact_transactions---1.UAW DOD-----------------
with base AS
(
select
date(e.BLOCK_TIMESTAMP) as date,
e.tx_hash as txn
from aptos.core.fact_events e
where e.ACCOUNT_ADDRESS in ('0x34ca84470e8d2907562f9a2f144c6c780282953b8b025ba220b0ecc5fc0aead9')
and e.EVENT_TYPE = '0x1::coin::DepositEvent'
AND date(e.BLOCK_TIMESTAMP)>=CURRENT_DATE()-01
)
select
date(t.BLOCK_TIMESTAMP) as Date,
t.SENDER
-- count(DISTINCT(t.SENDER)) as signers
FROM aptos.core.fact_transactions t
where t.tx_hash in (select txn from base )
AND date(t.BLOCK_TIMESTAMP)>=CURRENT_DATE()-01
-- GROUP BY 1
ORDER by 1
;
QueryRunArchived: QueryRun has been archived