Getstan2024-04-26 05:07 PM
Updated 2024-04-26
999
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
›
⌄
select
date
,event_type
, sum(transaction) as transaction
-- ,sum(transaction) over (order by date) as cumulative_transactions
from
(
-- Daily NFT
(select
date(inserted_timestamp) as date
,event_type
,count(*) as transaction
from aptos.core.fact_events
where event_type in (
'0x4::collection::MintEvent'
,'0x1::coin::WithdrawEvent'
,'0x4::collection::Mint'
,'0x1::coin::DepositEvent')
and (account_address in (
'0x89ec88201ecc9e3d1604b09f3c599353357284188d5a71f8953e660a14f17475'
,'0xbdead289e28d12e4819bc17f45d979c0cf2753a28f3cd425322e1caa48e9d159'
,'0x2bed7aeca079697ec1700cc48bee658b2331d80996b05e56dfcb39fae22cbb63'
,'0x778adb39026a14009cf5aa93eb53d81299e40c7a8dbcdbf7b490cbc29749d259'
,'0xfceefe7c83abbe577f606a7fa5b98cfed37d941f38721dede6ca601b61ddc59c'
,'0x3e2a44bed17e0b360398a98b576107f0737ff848ad0095422a91fc74f64e5449'
,'0x6897d148141c9faf0c5a62a5439d4ff2739017333e052b4f10710eee5afc8640'
,'0x43d4ecfa6e82aafbf95fa6f09079e583fd8ab64a1d73264a95ea1d8928be534f'
,'0x37d8d4d6cf6145c0e3bda2b03eeec6b3966298829892acee5f01ff7731930e44'
,'0xfa92d116233c4bd7efb5dc704d48626a7bade1125bd242d6b8865e9d57bde4a6'
,'0x98d5a2b8bd1fceb874f9461d61e12e9f4472104fdeec3920f680f927453d48be'
,'0xf78ca227f4aaa9c5c5787e71d8b12b6563ed9bb32740bdaa9d6a3c7de6226640'
,'0xd87009eff7a93ee5266680fe78b32a2b83ccca3b25a98e3b56b3799a34bd9694'
,'0x4264140b14df5822d92bfbaeac90686851d7a526fdda2153c07c62eac3efb21c'
,'0x0a79561c62c2eac5f008e13aa4c2e13f67c9bd538ef7d9df54fe9215da0a0bc0'
,'0xc8bf23d3c14f22df8ef0b9ea2a59ba2ee6f6c3cabf55526c9c99cf3e160cecd0'
,'0x54af3af02278e2b36f8e72a9578a3ee968ccc5e18bcd19f99841ad4b5ec12faa'
QueryRunArchived: QueryRun has been archived