par_rnavalanche 01
    Updated 2025-01-29
    select
    count(DISTINCT tx_hash) as stakes,
    count(DISTINCT FROM_ADDRESS) as stakers,
    sum(amount) as amount_arena,
    sum(amount_usd) as amount_usd
    Last run: 25 days ago
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    TX_HASH
    EVENT_INDEX
    ORIGIN_FUNCTION_SIGNATURE
    ORIGIN_FROM_ADDRESS
    ORIGIN_TO_ADDRESS
    CONTRACT_ADDRESS
    FROM_ADDRESS
    TO_ADDRESS
    RAW_AMOUNT_PRECISE
    RAW_AMOUNT
    AMOUNT_PRECISE
    AMOUNT
    AMOUNT_USD
    DECIMALS
    SYMBOL
    TOKEN_PRICE
    HAS_DECIMAL
    HAS_PRICE
    _LOG_ID
    _INSERTED_TIMESTAMP
    EZ_TOKEN_TRANSFERS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    91158042022-01-04 07:36:12.0000x091dbacaa4291b54768630f324a76c32901fa47bd14b222af93d9a6019b61e99170x33c6b7250x98cba71602c77565299627452332080f4916151f0x60ae616a2155ee3d9a68541ba4544862310933d40xff579d6259dedcc80488c9b89d2820bcb56091600x482b272af360fdfbf2d6f9b688ce949ae6adc1170x60ae616a2155ee3d9a68541ba4544862310933d4782632239789974927092977.82632239789975e+2278263.22397899749270929778263.22397899718LVTtruefalse0x091dbacaa4291b54768630f324a76c32901fa47bd14b222af93d9a6019b61e99-172023-04-07 16:56:57.843bf756c32f671867f43d7687cf952b2fa2024-06-03 21:43:15.5562024-06-03 21:43:15.556
    2
    91322662022-01-04 16:50:27.0000x7c99e1b4c4d9e415abb5286057c921055f51be9d71c726b6b8cf0ba86ee47189550x441a3e700xdfbe12391491d4be121d6cf3c05107ff260ad23c0xd6a4f121ca35509af06a0be99093d08462f530520x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd0x00000000000000000000000000000000000000000xaff90532e2937ff290009521e7e120ed062d4f34165095541401273885316509554140127400001.6509554140127388531.6509554143.19405626518JOE1.934671426truetrue0x7c99e1b4c4d9e415abb5286057c921055f51be9d71c726b6b8cf0ba86ee47189-552023-04-07 17:00:38.3911478dae2c17d048e83a24541afb010af2024-06-03 21:43:15.5562024-06-03 21:43:15.556
    3
    91256002022-01-04 13:05:40.0000xa824d9057b2786cd3ae5621ad1bffb5e8290f5cf2e2f7c6cb85fc97a6c2e023d480xd1abb9070x8b17f6e57eb609392b59a6af6e7c2deffcf5a3770x256040dc7b3cecf73a759634fc68aa60ea0d68cb0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd0xd6a4f121ca35509af06a0be99093d08462f530520x188bed1968b795d5c9022f6a0bb5931ac4c18f00364585987261146496836458598726114700003.6458598726114649683.6458598736.83167902318JOE1.87381832truetrue0xa824d9057b2786cd3ae5621ad1bffb5e8290f5cf2e2f7c6cb85fc97a6c2e023d-482023-04-07 16:59:22.1804a18d9db86ee904e5c34b6ed17bbab222024-06-03 21:43:15.5562024-06-03 21:43:15.556
    4
    91408682022-01-04 21:38:31.0000x01f3b72480e1dc331e5ab17c0c0dfe3a7d0663cde602112db02c94bb59397ca450x1801fbe50x70f9e9c25c735cdbf29293b72d1a5f9c5c7253a50xf48c4a0394dd9f27117a43dbb6400872399ab7e70xf48c4a0394dd9f27117a43dbb6400872399ab7e70x00000000000000000000000000000000000000000x70f9e9c25c735cdbf29293b72d1a5f9c5c7253a555550XPOW.CPUtruefalse0x01f3b72480e1dc331e5ab17c0c0dfe3a7d0663cde602112db02c94bb59397ca4-52023-04-07 17:02:04.80207a92d75bfdfe5341e1aaf971e719b4d2024-06-03 21:43:15.5562024-06-03 21:43:15.556
    5
    91311862022-01-04 16:13:44.0000x37bbe1f566ed57328308ad79774e2ce3e5105b34dc7e0213c179f3a839ca95f1870xe2bbb1580xc50b1173542112d5d33f4c7ed498b08c873615cf0x188bed1968b795d5c9022f6a0bb5931ac4c18f000x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd0x00000000000000000000000000000000000000000x66fb02746d72bc640643fdba3aefe9c126f0aa4f802089171974522292980208917197452200008.0208917197452229298.0208917215.51779001818JOE1.934671426truetrue0x37bbe1f566ed57328308ad79774e2ce3e5105b34dc7e0213c179f3a839ca95f1-872023-04-07 17:00:38.391b8fa8ef5f9e41aee1c80222a89e32d862024-06-03 21:43:15.5562024-06-03 21:43:15.556
    6
    91263842022-01-04 13:32:08.0000x50a268020ab4eadf6885126a5447befd1b499936bf3cc8b32905353e216851cb400xe2bbb1580x58d0d4a2aac209d9ab99665032d1b457994123860x188bed1968b795d5c9022f6a0bb5931ac4c18f000x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd0x00000000000000000000000000000000000000000x66fb02746d72bc640643fdba3aefe9c126f0aa4f109375796178343949010937579617834400001.093757961783439491.0937579622.04950370718JOE1.87381832truetrue0x50a268020ab4eadf6885126a5447befd1b499936bf3cc8b32905353e216851cb-402023-04-07 16:59:29.87037458c5c85964a83a4401d290a780a5e2024-06-03 21:43:15.5562024-06-03 21:43:15.556
    7
    91406082022-01-04 21:29:46.0000x2304843b52e78793e89f5e9b2c202682bf17f3a0b9f734ac547fb64e1541e97580x1801fbe50x70f9e9c25c735cdbf29293b72d1a5f9c5c7253a50xf48c4a0394dd9f27117a43dbb6400872399ab7e70xf48c4a0394dd9f27117a43dbb6400872399ab7e70x00000000000000000000000000000000000000000xa0ce71b4ed736f02c269498f870dcbb0c8ec257c22220XPOW.CPUtruefalse0x2304843b52e78793e89f5e9b2c202682bf17f3a0b9f734ac547fb64e1541e975-82023-04-07 17:03:17.9502804a2de66b3bced5d7d9c606919d9302024-06-03 21:43:15.5562024-06-03 21:43:15.556
    8
    91319992022-01-04 16:41:26.0000x54aaf7b96fc644066614198ad869989da2d7bd32c21206f03c8d816ce2add128360x441a3e700xbd3420e8104486b8bb782166379e6678ade9d94e0x188bed1968b795d5c9022f6a0bb5931ac4c18f000x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd0x00000000000000000000000000000000000000000xaff90532e2937ff290009521e7e120ed062d4f34182292993630573248418229299363057300001.8229299363057324841.8229299363.52677045918JOE1.934671426truetrue0x54aaf7b96fc644066614198ad869989da2d7bd32c21206f03c8d816ce2add128-362023-04-07 17:00:45.666547a0b20ce3a8eb37faf002187a678ab2024-06-03 21:43:15.5562024-06-03 21:43:15.556
    9
    91263842022-01-04 13:32:08.0000x50a268020ab4eadf6885126a5447befd1b499936bf3cc8b32905353e216851cb410xe2bbb1580x58d0d4a2aac209d9ab99665032d1b457994123860x188bed1968b795d5c9022f6a0bb5931ac4c18f000x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd0x00000000000000000000000000000000000000000xc13b1c927565c5af8fcaf9ef7387172c447f67965468789808917197455468789808917200000.5468789808917197450.54687898091.02475185318JOE1.87381832truetrue0x50a268020ab4eadf6885126a5447befd1b499936bf3cc8b32905353e216851cb-412023-04-07 16:59:29.8703663a3087ef9735cd2bd0d0f9066ad1d2024-06-03 21:43:15.5562024-06-03 21:43:15.556
    10
    91406082022-01-04 21:29:46.0000x2304843b52e78793e89f5e9b2c202682bf17f3a0b9f734ac547fb64e1541e97570x1801fbe50x70f9e9c25c735cdbf29293b72d1a5f9c5c7253a50xf48c4a0394dd9f27117a43dbb6400872399ab7e70xf48c4a0394dd9f27117a43dbb6400872399ab7e70x00000000000000000000000000000000000000000x70f9e9c25c735cdbf29293b72d1a5f9c5c7253a555550XPOW.CPUtruefalse0x2304843b52e78793e89f5e9b2c202682bf17f3a0b9f734ac547fb64e1541e975-72023-04-07 17:03:17.9500f9eab296669eff472111692ae523a7c2024-06-03 21:43:15.5562024-06-03 21:43:15.556
    11
    91308272022-01-04 16:01:41.0000xbf82f6628d868a567d6c817e4a5579fdb9d7bfba3811929955107168a327f4352160xe2bbb1580x1c508cb68f6b8582f5797c035e0fa668b1372ac50xd6a4f121ca35509af06a0be99093d08462f530520x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd0xd6a4f121ca35509af06a0be99093d08462f530520x1c508cb68f6b8582f5797c035e0fa668b1372ac5155379973896953635911553799738969540000015.53799738969536359115.5379973930.06091956218JOE1.934671426truetrue0xbf82f6628d868a567d6c817e4a5579fdb9d7bfba3811929955107168a327f435-2162023-04-07 17:00:38.3918907e2996fcfd80be8d668320dc910402024-06-03 21:43:15.5562024-06-03 21:43:15.556
    12
    91263842022-01-04 13:32:08.0000x50a268020ab4eadf6885126a5447befd1b499936bf3cc8b32905353e216851cb420xe2bbb1580x58d0d4a2aac209d9ab99665032d1b457994123860x188bed1968b795d5c9022f6a0bb5931ac4c18f000x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd0x00000000000000000000000000000000000000000xd6a4f121ca35509af06a0be99093d08462f53052273439490445859872627343949044586000002.7343949044585987262.7343949045.12375926718JOE1.87381832truetrue0x50a268020ab4eadf6885126a5447befd1b499936bf3cc8b32905353e216851cb-422023-04-07 16:59:29.870f3414195951bb8ac99d7b884ea7995722024-06-03 21:43:15.5562024-06-03 21:43:15.556
    13
    91408772022-01-04 21:38:49.0000x1cb9a3c527400d96fb3c2a5e354a961a729f82839aaa84c7d7f7d9206a8e004c180x1801fbe50x70f9e9c25c735cdbf29293b72d1a5f9c5c7253a50xf48c4a0394dd9f27117a43dbb6400872399ab7e70xf48c4a0394dd9f27117a43dbb6400872399ab7e70x00000000000000000000000000000000000000000x70f9e9c25c735cdbf29293b72d1a5f9c5c7253a555550XPOW.CPUtruefalse0x1cb9a3c527400d96fb3c2a5e354a961a729f82839aaa84c7d7f7d9206a8e004c-182023-04-07 17:02:04.802825d4c5e8f0badb7b614ca55de8739f32024-06-03 21:43:15.5562024-06-03 21:43:15.556
    14
    91315262022-01-04 16:25:03.0000xe05e99f53ff46dd1d75c5ecb44fdda43166c10554704855555d98b341fd0f02b1170x18fccc760x3e95bf6df91a0593333f550b6e1485299dfb86be0x256040dc7b3cecf73a759634fc68aa60ea0d68cb0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd0xd6a4f121ca35509af06a0be99093d08462f530520x188bed1968b795d5c9022f6a0bb5931ac4c18f000000018JOE1.934671426truetrue0xe05e99f53ff46dd1d75c5ecb44fdda43166c10554704855555d98b341fd0f02b-1172023-04-07 16:59:28.035afe86214826bec9badfb38b93466bb7c2024-06-03 21:43:15.5562024-06-03 21:43:15.556
    15
    91269942022-01-04 13:52:47.0000x13da38950e1e3d5dc435196baa2b98ea5ca3186c718a2b1e675f6c5c3024a581570x2e1a7d4d0x9c2b95d040e569f595f34c71b077493658dcdbea0xdd65bb46a7c4a9ccb8d3dd7caa40d75e0622e4450x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd0x00000000000000000000000000000000000000000x66fb02746d72bc640643fdba3aefe9c126f0aa4f133910828025477707001339108280254780000013.391082802547770713.39108280325.09245628518JOE1.87381832truetrue0x13da38950e1e3d5dc435196baa2b98ea5ca3186c718a2b1e675f6c5c3024a581-572023-04-07 16:59:28.0357e3f70a42b3a13130d5357fa665a59f52024-06-03 21:43:15.5562024-06-03 21:43:15.556
    16
    91436762022-01-04 23:13:17.0000x83d3a2ec22def8b0f13d8e6b8a485a2745e20081a9559102abaaa580cc6aa451410xe2bbb1580xb2bedcec7da7101439adc08808696e24974fc21d0x2cb3ff6894a07a9957cf6797a29218cebe13f42f0x43c812ba28cb061b1be7514145a15c9e18a273420x00000000000000000000000000000000000000000x2cb3ff6894a07a9957cf6797a29218cebe13f42f19135529411764705882351.91355294117647e+211913.5529411764705882351913.55294117618GTRtruefalse0x83d3a2ec22def8b0f13d8e6b8a485a2745e20081a9559102abaaa580cc6aa451-412023-04-07 17:02:04.8029e098ac7b131b4eed88023ee424983352024-06-03 21:43:15.5562024-06-03 21:43:15.556
    17
    91315262022-01-04 16:25:03.0000xe05e99f53ff46dd1d75c5ecb44fdda43166c10554704855555d98b341fd0f02b1280x18fccc760x3e95bf6df91a0593333f550b6e1485299dfb86be0x256040dc7b3cecf73a759634fc68aa60ea0d68cb0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd0x9d41630e80e416b033e371989e2727de45b7472f0x0043aaaaf96dcf7ecff8ac4908a05663f806adaf4490373507186727854490373507186730000.4490373507186727850.44903735070.868739731518JOE1.934671426truetrue0xe05e99f53ff46dd1d75c5ecb44fdda43166c10554704855555d98b341fd0f02b-1282023-04-07 16:59:28.03515f541779208f36796b1a476adf8969e2024-06-03 21:43:15.5562024-06-03 21:43:15.556
    18
    91269942022-01-04 13:52:47.0000x13da38950e1e3d5dc435196baa2b98ea5ca3186c718a2b1e675f6c5c3024a581590x2e1a7d4d0x9c2b95d040e569f595f34c71b077493658dcdbea0xdd65bb46a7c4a9ccb8d3dd7caa40d75e0622e4450x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd0x00000000000000000000000000000000000000000xd6a4f121ca35509af06a0be99093d08462f53052334777070063694267513347770700636940000033.47770700636942675133.47770700662.73114071218JOE1.87381832truetrue0x13da38950e1e3d5dc435196baa2b98ea5ca3186c718a2b1e675f6c5c3024a581-592023-04-07 16:59:28.035d153ffa4dc1ba07fb5eecef2eded58a02024-06-03 21:43:15.5562024-06-03 21:43:15.556
    19
    91150072022-01-04 07:09:29.0000x25433d84da16edee35d61d4bcdf6b29cc17feaa25d5872cf48c18ee56d75197b160x8a657e670x7ebfb0697c0ee1171d40e559feac4cabe31c61800x60ae616a2155ee3d9a68541ba4544862310933d40xff579d6259dedcc80488c9b89d2820bcb56091600x482b272af360fdfbf2d6f9b688ce949ae6adc1170x7ebfb0697c0ee1171d40e559feac4cabe31c618020000000000000000000020000000000000000000020020018LVTtruefalse0x25433d84da16edee35d61d4bcdf6b29cc17feaa25d5872cf48c18ee56d75197b-162023-04-07 16:56:57.843be907250eeed14581e0fbf6c8e8e3b062024-06-03 21:43:15.5562024-06-03 21:43:15.556
    20
    91316492022-01-04 16:29:18.0000x1880070a14f44f97a19f4167f3e2b4c101ce9ac6ed7f8bec3f79e5e0ab208c83470x38ed17390xf489c3607b73d09cd1ab343262cb3796cd306a400x60ae616a2155ee3d9a68541ba4544862310933d40x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd0xf489c3607b73d09cd1ab343262cb3796cd306a400x67926d973cd8ee876ad210faaf7dffa99e414acf1126403597800476771126403597800480000.1126403597800476770.11264035980.217922085418JOE1.934671426truetrue0x1880070a14f44f97a19f4167f3e2b4c101ce9ac6ed7f8bec3f79e5e0ab208c83-472023-04-07 17:00:38.391fe0238d4e0946b3111d091521bb732312024-06-03 21:43:15.5562024-06-03 21:43:15.556
    100
    63KB
    2s