tkvresearchfine-ivory
Updated 2024-12-02
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
›
⌄
select
sum(time_nudged) as total_nudge,
sum(time_nudged)/count(distinct datetime) as nudge_per_day,
count(distinct user_nudged) as total_user_nudged,
count(distinct user_be_nudged) as total_user_be_nudged
from
(select date(block_timestamp) as datetime,
sender as user_nudged,
--coalesce(sum(events[1]:data:amount/1e8),0) as amt_emoji,
events[0]:data:initial_recipient as user_be_nudged,
events[0]:data:times_nudged as time_nudged
from aptos.core.fact_transactions
where payload_function like '%0xd0995d57c9d4839dcecfdbb34a2650172a69fcfe0444f3229fec90eddf945141%'
and
success = 'TRUE'
union all
select date(block_timestamp) as datetime,
sender as user_nudged,
--coalesce(sum(events[1]:data:amount/1e8),0) as amt_emoji,
events[1]:data:initial_recipient as user_be_nudged,
events[1]:data:times_nudged as time_nudged
from aptos.core.fact_transactions
where payload_function like '%0xd0995d57c9d4839dcecfdbb34a2650172a69fcfe0444f3229fec90eddf945141%'
and
success = 'TRUE'
)
-- select *
-- from aptos.core.fact_transactions
-- where payload_function like '%0xd0995d57c9d4839dcecfdbb34a2650172a69fcfe0444f3229fec90eddf945141%'
-- and
-- success = 'TRUE'
QueryRunArchived: QueryRun has been archived