BLOCK_NUMBER | BLOCK_TIMESTAMP | VERSION | TX_HASH | SUCCESS | TX_TYPE | PAYLOAD_FUNCTION | EVENT_INDEX | EVENT_TYPE | EVENT_ADDRESS | EVENT_MODULE | EVENT_RESOURCE | EVENT_DATA | ACCOUNT_ADDRESS | CREATION_NUMBER | SEQUENCE_NUMBER | FACT_EVENTS_ID | INSERTED_TIMESTAMP | MODIFIED_TIMESTAMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 277786467 | 2025-01-16 07:06:51.404 | 2209899094 | 0xecd378a5bf7ee7e466229e5a709285c07331b4875dacc9068b74511f87992141 | TRUE | user_transaction | 0xd095c52a639b34eb1bcf5043eb2083851ee7c325d645202fc34351dd591e4a0b::vest... | 0 | 0x1::fungible_asset::Withdraw | 0x1 | fungible_asset | Withdraw | {"amount":"10000000000","store":"0xb8a8fc94c486cf905eb67582f8aaf64bc0e60... | 0x0 | 0 | 0 | c361220f8133f3078cfffdaad4ffcd2c | 2025-01-16 07:32:35.395 | 2025-01-16 07:52:33.184 |
2 | 277786467 | 2025-01-16 07:06:51.404 | 2209899094 | 0xecd378a5bf7ee7e466229e5a709285c07331b4875dacc9068b74511f87992141 | TRUE | user_transaction | 0xd095c52a639b34eb1bcf5043eb2083851ee7c325d645202fc34351dd591e4a0b::vest... | 3 | 0x1::transaction_fee::FeeStatement | 0x1 | transaction_fee | FeeStatement | {"execution_gas_units":"6","io_gas_units":"8","storage_fee_octas":"53240... | 0x0 | 0 | 0 | ef2cebcfa578c7c1d2a703eb006071fa | 2025-01-16 07:32:35.395 | 2025-01-16 07:52:33.184 |
3 | 277786467 | 2025-01-16 07:06:51.404 | 2209899094 | 0xecd378a5bf7ee7e466229e5a709285c07331b4875dacc9068b74511f87992141 | TRUE | user_transaction | 0xd095c52a639b34eb1bcf5043eb2083851ee7c325d645202fc34351dd591e4a0b::vest... | 1 | 0x1::fungible_asset::Deposit | 0x1 | fungible_asset | Deposit | {"amount":"10000000000","store":"0x7dbac84735635754a117679b6377922d8f5c6... | 0x0 | 0 | 0 | f10a52775aad3469aab6df294241be15 | 2025-01-16 07:32:35.395 | 2025-01-16 07:52:33.184 |
4 | 277786467 | 2025-01-16 07:06:51.404 | 2209899094 | 0xecd378a5bf7ee7e466229e5a709285c07331b4875dacc9068b74511f87992141 | TRUE | user_transaction | 0xd095c52a639b34eb1bcf5043eb2083851ee7c325d645202fc34351dd591e4a0b::vest... | 2 | 0xd095c52a639b34eb1bcf5043eb2083851ee7c325d645202fc34351dd591e4a0b::vest... | 0xd095c52a639b34eb1bcf5043eb2083851ee7c325d645202fc34351dd591e4a0b | vesting | Claimed | {"address":"0x7b3f26e5238e7928255b54c0eb9b269be875a2b6c83215a8e1c6ef9c23... | 0x0 | 0 | 0 | 43f7128c7df88027e4d12531ce7927d3 | 2025-01-16 07:32:35.395 | 2025-01-16 07:52:33.184 |
SocioAnalyticaVIBE Claims distribution
Updated 2025-01-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- forked from SocioCrypto / VIBE Claimers @ https://flipsidecrypto.xyz/SocioCrypto/q/5BPUtS905GYv/vibe-claimers
-- forked from VIB Claims @ https://flipsidecrypto.xyz/studio/queries/3faced41-7c47-4598-a0c4-e5fb555ff995
SELECT *
FROM aptos.core.fact_events
where tx_hash = '0xecd378a5bf7ee7e466229e5a709285c07331b4875dacc9068b74511f87992141'
-- SELECT
-- sum(event_data:amount/pow(10,8)) as volume,
-- count(DISTINCT event_data:address) as n_claimers
-- FROM aptos.core.fact_events
-- WHERE event_module = 'vesting' and event_resource = 'Claimed' and event_data:vesting_name = 'Airdrop'
Last run: 3 months ago
4
2KB
2s