datavortexavalanche Gaming
    Updated 2025-03-15
    SELECT tx_hash, tx_fee FROM avalanche.core.fact_transactions
    limit 20




    /*
    SELECT distinct address from avalanche.core.dim_labels
    where label_type = 'games'
    and project_name = 'cryptoblades'
    and address = LOWER('0x483416eB3aFA601B9C6385f63CeC0C82B6aBf1fb')
    */

    /*
    SELECT distinct * FROM avalanche.core.ez_decoded_event_logs
    where origin_to_address = LOWER('0xe3b3f75f99da4ff26aa867ef70b48f8f6b2d4958')
    and event_name = 'Transfer'
    */
    --Approval
    --0xe3b3f75f99da4ff26aa867ef70b48f8f6b2d4958

    --monsterra 0xe397784960f814ba35c9ee0bc4c9dffdf86925f9
    -- cryptoblades 0x483416eB3aFA601B9C6385f63CeC0C82B6aBf1fb
    -- megaweapon 0xe3b3f75f99da4ff26aa867ef70b48f8f6b2d4958
    -- getfit mining 0xef0cdae2ffeeefa539a244a16b3f46ba75b8c810


    Last run: 3 months ago
    TX_HASH
    TX_FEE
    1
    0x26eec0e54384d706a1b7ea053bd9949fd50b8022f84e21d29bfef717eca9eb8e0.004789716
    2
    0xdac81dd2f96aec407bc64a60bc7f697c6408e6d8afdefa9a3ed0dd48909ff9850.0005565
    3
    0x839f145d5f3125fac6b00f28a71ce976d86544f220b280e52774e06cbc008ab50.000525
    4
    0x98535ab96192b7ab0f68a7944340a300372f718042c1cef3df6397fa2a1cede60.001969131005
    5
    0x48ffb22c97a0665ec2c7d0661d4123398202fa339edb926d62ec21abb518269a0.002694414
    6
    0x640e9ec84f9e4731ef7b5a01c90a81e56fa755d92c9808a67f2ab121627649dc0.003692691177
    7
    0x32f55f0c4896ab4c321eb52974960efc63739f21c892d2cb80432a128f1477c80.007176836
    8
    0xe1e3c8881f26bf311cb11e6eb7a44e8b9b923b0ba2c912dc397afc4d5b0c50930.0046618
    9
    0x8c4e5d8c864872f3bc78fbb6208d63e54e614dc399362b675c4dae762159ac420.0044802755
    10
    0x99a9498d0dae81340b13caee5f817eeea9eb6de4ac04f139c691ac115f5057270.0030922055
    11
    0x7095a8e915140c025f94ce01c7829e861e1a90ffe93d51014386ecefe4a0969a0.0037957275
    12
    0x9689b1898a01266655851a5d09ab95e7cf6372ce0db1e3eb125f2072f7b6ffc70.003452925
    13
    0x9b84d2b8416b09f320c864817e0a598107afba392510154c25259eb6d7adc2580.0046811985
    14
    0x8822c0b11c8138d307e5b709b08ca1e305520c135e36ad61dc0eeaad26e4210a0.0012515685
    15
    0xfd62553f64cd70a0aeac754cbdb4845c835e969f46e45ff5f39424ecbfd426f50.00893496
    16
    0x53a4d14622c67c00aa0525361f5e7bca9c4c7426225f463faf0061664aaa04ca0.00105
    17
    0x8505043592685641d2f4d25b7a0b6858f6a3f2f0db8552037251c1c3b3c1b9be0.0005565
    18
    0x8f6a33d6e6d97ab602c6127e878bcdb0a8c7902e88a72dfa8949f65af2c870150.0005565
    19
    0xa4f704f63c97f6b7a2bb81b2d6363183ba97d60e98b9dbeea80c72f21df7f18f0.003148075
    20
    0x1fa81cc9c0ddecd0d66b08a754a543d8dc685017033629eefc233d72ceba35ea0.0008598425
    20
    2KB
    1s