Hessishtabtrb - pls ldrb new
    Updated 2025-01-26
    SELECT
    TO_VARCHAR(count(DISTINCT tx_id) , '999,999,999,999') as "Total taps",
    signers[0] as "In-game address",
    round(
    count(DISTINCT tx_id) / count(DISTINCT date_trunc('second', block_timestamp))
    ) as avg_sec,
    round(
    count(DISTINCT tx_id) / count(DISTINCT date_trunc('minute', block_timestamp))
    ) as avg_min,
    round(
    count(DISTINCT tx_id) / count(DISTINCT date_trunc('hour', block_timestamp))
    ) as avg_hour,
    max(block_timestamp::date) as "last playing date"
    from
    eclipse.core.fact_transactions
    where SIGNERS[0] in ( SELECT
    DISTINCT SIGNERS[1]
    from eclipse.core.fact_transactions
    where
    block_timestamp::date >= '2024-12-01' and
    SUCCEEDED = 'TRUE'
    and LOG_MESSAGES[0] like '%turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxN%'
    and LOG_MESSAGES[1] = 'Program log: Instruction: GrantClicker'
    ) and
    block_timestamp::date >= '2024-12-01'
    and SUCCEEDED = 'TRUE'
    GROUP by all
    order by 1 desc
    limit 50000
    Last run: 20 days ago
    Total taps
    In-game address
    AVG_SEC
    AVG_MIN
    AVG_HOUR
    last playing date
    1
    4,059,915
    4beaZ4KgbZxHjX8Rw9QsetLNnC9ZDsrykGBaDYB7PCoy
    13478163052025-01-20 00:00:00.000
    2
    3,385,288
    DuXPK1DznL94cDDwEqeJcePQ6S5rWXdtUksaW1KW8fZs
    415983382025-01-20 00:00:00.000
    3
    3,206,771
    C366eBRYtmVV1caib2VxxrQqqsQ7Sh5ZHJYD5GNRutBp
    921171742025-01-26 00:00:00.000
    4
    3,115,031
    GWkzBdMKjk2Akv2XXrRfEU6GwNmALPVHB3caCa5X4E6F
    514653802025-01-24 00:00:00.000
    5
    3,086,977
    FMgSWdg3BpwG51ydGxSCmuHi9vExsX4VpGPcQThG6bLu
    413868002025-01-23 00:00:00.000
    6
    3,002,667
    HGU4jDP13yXE1hENtwGrsAGgYGpwyDadXwG47c1rYsEP
    621080722025-01-19 00:00:00.000
    7
    2,965,421
    6mqEFHtzz7cV6dtoM1PHYTtjs29cXJkfX8M3TbsnkgMx
    9209102262025-01-20 00:00:00.000
    8
    2,854,668
    2xMMhuouhnhgQvu6CJW4qFeKEnJSZ82xzBuzAgkeTjKx
    415357792025-01-26 00:00:00.000
    9
    2,724,029
    4DL34JUzTQ5uVYJtHSUPy4bqH3roiiKYev1G6PrF5hw2
    518279422025-01-26 00:00:00.000
    10
    2,602,591
    DGG7MDko9wLcdgcdHnLVkU92vxGLRPBZ7rQ3r67vhJYo
    416579592025-01-26 00:00:00.000
    11
    2,542,805
    GgYVRoqAW5xHG11vYRPbEzm6yzs4PP63Di8HcmzeHrfe
    610850452025-01-26 00:00:00.000
    12
    2,412,784
    6yWRb7MA4PTputZS2GgQ1BKQHC5pu1124HqpKroLs2LG
    616262352025-01-26 00:00:00.000
    13
    2,411,858
    58VRQbj4NfkzcG2bV7Gf73MQvyBys9dwPFtDraoutuGw
    5214100492025-01-26 00:00:00.000
    14
    2,379,232
    EymWUr3z1efxqMqLJwx2Nr8SNvbEfevSbBNMvtbroQUC
    518270602025-01-18 00:00:00.000
    15
    2,330,283
    2BEUyNpkzo4cpcL7RDLpXsxWjhq2iTafdk8auKs2tfQ3
    411551332025-01-26 00:00:00.000
    16
    2,288,852
    474exJdF1wbNWytvKbSPy52tNgArGfFUwvMNF2pqD3Yy
    514164842025-01-26 00:00:00.000
    17
    2,282,688
    4pqRK67YYgtKu6SQ59N6LKnmV77qeX5paQN9bkUen1ta
    311653212025-01-26 00:00:00.000
    18
    2,249,658
    3BtWv8uGQ2KHFQqMk5XPSR7PK8zZZvVK88hAdCG4ifVm
    515877842025-01-11 00:00:00.000
    19
    2,186,903
    6aykxxJhpZitkxtmH1586oGxQYudkRWj7vwKLqE27aKi
    716963942025-01-25 00:00:00.000
    20
    2,183,661
    traNBSTQKsND8F6Zo9d2W87nHGzDTmoDvnUgKbureHX
    13419117402025-01-24 00:00:00.000
    ...
    50000
    5MB
    1011s