--date(t.block_timestamp) as date,

l.label,

count(DISTINCT t.tx_hash) as txs,

count(distinct t.sender) as daa

from aptos.core.fact_transactions t

left join

aptos.core.fact_events e

on t.tx_hash = e.tx_hash

left join

aptos.core.dim_labels l

on l.address = e.event_address

where t.tx_type = 'user_transaction'

and t.block_timestamp between '2024-01-01' and '2024-03-31'

group by 1 order by 2 desc

select

t.

count(DISTINCT t.tx_hash) as txs,

count(distinct t.sender) as daa

from aptos.core.fact_transactions t

select * from aptos.core.fact_events e where account_address = '0x8d2d7bcde13b2513617df3f98cdd5d0e4b9f714c6308b9204fe18ad900d92609'

select * from aptos.core.fact_transactions t where t.tx_type = 'user_transaction' limit 5

select address, label, address_name from aptos.core.dim_labels

where address in ('0x17f1e926a81639e9557f4e4934df93452945ec30bc962e11351db59eb0d78c33', '0x7e783b349d3e89cf5931af376ebeadbfab855b3fa239b7ada8f5a92fbea6b387', '0xc0deb00c405f84c85dc13442e305df75d1288100cdd82675695f6148c7ece51c', '0x7d7e436f0b2aafde60774efb26ccc432cf881b677aca7faaf2a01879bd19fb8', '0xb1421c3d524a353411aa4e3cce0f0ce7f404a12da91a2889e1bc3cea6ffb17da', '0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06', '0x9eb421ef46d7dc759409b9541d9c0bd3ffff975177a227eb4df4ad36d20ed991', '0xc7efb4076dbe143cbcd98cfaaa929ecfc8f299203dfff63b95ccb6bfe19850fa', '0x190d44266241744264b964a37b8f09863167a12d3e70cda39376cfb4e3561e12', '0xc7ea756470f72ae761b7986e4ed6fd409aad183b1b2d3d2f674d979852f45c4b', '0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1', '0x890812a6bbe27dd59188ade3bbdbe40a544e6e104319b7ebc6617d3eb947ac07')