数据 | 数据分析之Dune Analytics（四） - 一点儿知识

视频:https://youtu.be/Mkup27k3iqE
TheGraph:https://dune.com/drethereum/RabbitHole:-theGraph
Compound:https://dune.com/drethereum/RabbitHole:-Compound-v2

下面的例子主要是为了求出The Graph的新用户以及其增长率。

这里是对去中心应用The Graph的讲解，有兴趣了解该产品的用户可以前往The Graph官方文档查看:https://thegraph.com/docs/zh/about/introduction/

此时，我们点击theGraph:New Curator Growth进入该图表的代码页面（该图表是Dune的其它用户构建的可视化图表并公开分享出来的，如果你不愿意自己创建数据表，也可以使用其他用户已经创建好的图表来获取自己需要的数据）

WITH rh AS (
SELECT DISTINCT "nameCurator" AS users, MIN(evt_block_time) AS time, COUNT(evt_tx_hash) AS volume
FROM thegraph."GNS_evt_NSignalMinted"
WHERE "nameCurator" IN ('\x708621fea6a3e127f775886f4fcc5a7edc6cc736','\x918116c0a7ea9e9c0226c41aa4f13c538dda4380','\x16ffca9747cdd39bfda6663c102c816ec4041f63','\xfa9ddbc61be8e89e85ffbf330efbdb999ffe7b74'
)
GROUP BY 1
)
SELECT date_trunc('day', time) AS day, COUNT(*) AS new_users, COALESCE(100 * (COUNT(*) - lag(COUNT(*), 1)
over (order by date_trunc('day', time))) / lag(COUNT(*), 1)
over (order by date_trunc('day', time)),0) || '%' AS growth_rate
FROM rh
GROUP BY 1
ORDER BY 1 ASC

注意:源代码的钱包地址非常多，我略微做了一下删减，保留了4个钱包地址。

这里前半部分的代码，我们前面已经讲过了，就是将括号里面的代码命名为rh，方便我们后面直接调用它的数据，此外这里的SELECT DISTINCT前面讲过就是去除掉重复的内容，Min函数的内容我们可以直接查手册https://www.w3school.com.cn/sql/sql_func_min.asp 可知是取evt_block_time中的最小值，而GROUP BY是将所有重复的nameCurator放在一起。

data_trunc函数就是取当日0时作为day的内容，因为前面的order by已经对所有的交易都去重了，所以这里的COUNT(*)可以作为每一个独立的钱包地址，接下来，我们直接去搜索coalesce、Lag和over在SQL中的应用，详细信息可访问:

coalesce():https://docs.microsoft.com/zh-cn/azure/databricks/sql/language-manual/functions/coalesce

lag():https://www.begtut.com/mysql/mysql-lag-function.html

over():https://juejin.cn/post/6942749484040323102

lag(COUNT(*),1)的意思就是返回COUNT()值前1行的值，若前一行没有值，且没有默认的Value，则返回Null，Coalesce函数就是返回参数中的第一个非空值，全是Null，则返回Null。

这里不太好解释，我直接通过数字计算的方式就能够更好理解：100*（4-5）/ 5 = -20 因为-20不是Null ，所以取值为-20，然后 || %就是-20% ，(order by date_trunc('day', time))一次是对除号前面的内容排序，一次是对除号后面的内容排序，实际上-20%是第二次的计算结果，因为第一次的值有Null，所以我就没有取第一次的参数来进行计算，最后，把day的重复内容合并，并对其升序排列。

接下来这个例子是为了找出Compound V2中的几种代币供应量

SELECT
CASE
WHEN "contract_address" = '\x158079ee67fce2f58472a96584a73c7ab9ac95c1' THEN 'cREP'
WHEN "contract_address" = '\x35a18000230da775cac24873d00ff85bccded550' THEN 'cUNI'
WHEN "contract_address" = '\x39aa39c021dfbae8fac545936693ac917d5e7563' THEN 'cUSDC'
WHEN "contract_address" = '\x4ddc2d193948926d02f9b1fe9e1daa0718270ed5' THEN 'cETH'
WHEN "contract_address" = '\x5d3a536e4d6dbd6114cc1ead35777bab948e3643' THEN 'cDAI'
WHEN "contract_address" = '\x6c8c6b02e7b2be14d4fa6022dfd6d75921d90e4e' THEN 'cBAT'
WHEN "contract_address" = '\x70e36f6bf80a52b3b46b3af8e106cc0ed743e8e4' THEN 'cCOMP'
WHEN "contract_address" = '\xb3319f5d18bc0d84dd1b4825dcde5d5f7266d407' THEN 'cZRX'
WHEN "contract_address" = '\xc11b1268c1a384e55c48c2391d8d480264a3a7f4' THEN 'cWBTC'
WHEN "contract_address" = '\xccf4429db6322d5c611ee964527d42e5d685dd6a' THEN 'cWBTC'
WHEN "contract_address" = '\xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9' THEN 'cUSDT'
WHEN "contract_address" = '\xf5dce57282a584d2746faf1593d3121fcac444dc' THEN 'cSAI'
WHEN "contract_address" = '\xface851a4921ce59e912d19329929ce6da6eb0c7' THEN 'cLINK'
WHEN "contract_address" = '\x12392f67bdf24fae0af363c24ac620a2f67dad86' THEN 'cTUSD'
END AS symbol2,
CASE
WHEN "contract_address" = '\x158079ee67fce2f58472a96584a73c7ab9ac95c1' THEN 'cREP'
WHEN "contract_address" = '\x35a18000230da775cac24873d00ff85bccded550' THEN 'cUNI'
WHEN "contract_address" = '\x39aa39c021dfbae8fac545936693ac917d5e7563' THEN 'cUSDC'
WHEN "contract_address" = '\x4ddc2d193948926d02f9b1fe9e1daa0718270ed5' THEN 'cETH'
WHEN "contract_address" = '\x5d3a536e4d6dbd6114cc1ead35777bab948e3643' THEN 'cDAI'
WHEN "contract_address" = '\x6c8c6b02e7b2be14d4fa6022dfd6d75921d90e4e' THEN 'cBAT'
WHEN "contract_address" = '\x70e36f6bf80a52b3b46b3af8e106cc0ed743e8e4' THEN 'cCOMP'
WHEN "contract_address" = '\xb3319f5d18bc0d84dd1b4825dcde5d5f7266d407' THEN 'cZRX'
WHEN "contract_address" = '\xc11b1268c1a384e55c48c2391d8d480264a3a7f4' THEN 'cWBTC'
WHEN "contract_address" = '\xccf4429db6322d5c611ee964527d42e5d685dd6a' THEN 'cWBTC'
WHEN "contract_address" = '\xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9' THEN 'cUSDT'
WHEN "contract_address" = '\xf5dce57282a584d2746faf1593d3121fcac444dc' THEN 'cSAI'
WHEN "contract_address" = '\xface851a4921ce59e912d19329929ce6da6eb0c7' THEN 'cLINK'
WHEN "contract_address" = '\x12392f67bdf24fae0af363c24ac620a2f67dad86' THEN 'cTUSD'
END AS symbol, COUNT(DISTINCT "minter") AS suppliers
FROM (
SELECT * FROM compound_v2."cErc20_evt_Mint"
UNION ALL
SELECT * FROM compound_v2."cEther_evt_Mint"
UNION ALL
SELECT * FROM compound_v2."CErc20Delegator_evt_Mint"
) t
WHERE "minter" IN ('\x626ba06f879e00f53919416d53a728d8a7ae728f','\x355931a6c24183a7fc71b9d6ae9c996313e01f14','\xec360a3b85a2229e2b9d0d965baa224fadd455fe','\x832eb85f72bfc98a119f70974672e7f15798e7e7','\xbceaa1b2e31e7f5307b2d1f546a51b3e84065584','\x906c136b56c1dc78b4336beac0cb0a1684224c94','\x0d1456a83ce96e010db1fcba4e71bbc6c3a18452','\xf30be05aea41c2fdc3216b58f4f7ed10f96d71e6','\xc21a7fcc250cf5ca58708ca3c80889e7076c6ada','\x294fba5623df0e351ac814b1cbc5d2a3d53774e3','\xc9970cebe6dfee370b862326e06d393fd0f907db','\xb9e62c014d644aebde25c253d0d8e3a40c83de47','\x9b72e01e74b8ca9b5d341d0feb80b2324dfe99c7','\x66c844593c4d4859ae3cca5cf23040506f8ea801','\x375c7072d3b30eadc72fc95ffd6063f35b8c9e78','\xdc6657a6e3ee8ec7004dadd99a7a030b975556f8','\x13dda63c28bb95fe9822fea43ad5feaa966636a9','\x4daf43e8141df32787137f969c00c9a1548722b1','\x1f4dc26f26262fe6431c6ff1bd304affdf600289','\x9888a6b952e282471fe248fd63a7bef5115359fd','\x781e73df8b09a6e7cc8cc2293a59ba2dfd2b5380','\xee843d6a71dc12307ec4f3a4a7ad1875ba8d28f6','\xbb0be77494ad33cc37b6e117265cecdd720dd4ce','\xbb7b3649f0da7eaf2728f55f3667c9947fd1046f','\x978ee9c737b2e761d8f3d94efca4057bf655c1f2','\x1a27881e041737bc7ef5c616a8af08ec7e51db40','\x4b9890743d8f6601a4c5780dc47cf2ba2c571a43','\xf6b5fd8e2cac43987de603ce7942e09e2dc8a2c9','\x94aaf5ceb457057ac4d1588257988d487272984f','\x696d181a7961ee66c42f1ebeddc0b48b106c45ad','\x0ec2109724ad84a73477cd75d01fa2d403a3f682','\xd9d44223b176df065b1c63c7cf9278f5c9f7a2dd','\xa9816ac65481dfc3abe65ad26a3aa8bab618e8d4','\xb313fbf1a9f01e1a727b1f2e181a4de8bc21bfa7','\x518f13dbfebc39f79f0b6cef3e8479bdb9b050d6','\x971bbbf3d2aed41756aa7e67a04116c3d98ffcf4','\x464e626adbc2967b241bf77debfe08671e3e3b24','\x1b08b595efcf4afd9f8ce2b9f1660793895cf0fd','\xae3dfacbb7d98518fcc1a7e1ada992ab2def3b62','\xa1457afa30b8e396cde5bac320ed7c8e7b521bc8','\xd6e107eb156b3f056caf06cc373ef3fad934dad1','\x27a4b36bda9a448e429087c3d07159ac443920a4','\x51d74cb637b82394d6b63b90e2cc7abb357da078','\x271251cabf03b575ce374a636248697c52469542','\xcdd293efe9cb183dfe01e4c5386f1fd9f32198cb','\x103b73cabfbd85c5461b532267401998a27f5b3b','\xeb9d74fdfabc1467fb4e79dd40e55c9a52b8578b','\xa9d89a5caf6480496acc8f4096fe254f24329ef0','\xc72aa47c9ae5c72520f6aad34f24ba166cca46f8','\xccb23a9bbae99909b1102549f9a96c2b137a60ec','\xa53c72174ce109676c852b44135e7f2792968b0e','\x83fe5c3e4c020d80ab35b25cd40bc7cd3c66640f','\x8d6a531cf61f8182346f50d5beb79461cb58d5fb','\xaa6444dbaf86f16b894ef29d2fddff7ab7cfcd43','\xc073ccd0679f81c9d0f8ec028f98ad76554a5570','\x3df2630437dbf3f69066f899164ad8b500f1b4e1','\x24230b429dd84a5085bb9919e16492e9a137fcca','\xf17860a609bbf56a51e52ab6677d6adc14b1ce20','\xf16dd2cb327ed8fb5a76de9788dd2fbe8a99d43c','\x327b9dee1830f8201efa751fd96f7b1ad0b300a1','\x041e4e6dc46800b04288290eeff516da715869fb','\x9ea8ab9e1c3fc1cb4c4a21b129500ab08ed49464','\xee9972a02f37f0f16da5ee7e48382f2a072c52c1','\x1f807cbbabd010226771dc28900b001b08f630a4','\x1eff71ee5463f7dd88a36a5674021f1e94f5166c','\x7aab1f7cdcacb474b7bf3c8e19accbaaceb8284b','\xc37816cd659eeba56c86b158da79390aed2400e5','\xb957603c8bf51183266792ea34877f7803726864','\xb43bc8e4c7c5bc7daa439b9f659128a9fc486e5b','\x1f69ee6c9db214362368608cd7d886cc64142270','\xbb37868971982822218a10d750603dbc5ed7386f','\x5880b4146eaa5ca63f12e6e051e2f227dc3d80ff','\xcd7a0680c14b13618bf119ff899ed10ca4dbcccc','\x77da681c2aee7969b0903d0eef49ba51efc5c394','\x9503b823a21e113af3477aeab5bed9d17b4e1b56','\xdda3f65b9676bdb5c309d761deef65f4e1da8678','\xb8a631473d398582c6754f683c32464e76a8ad60','\xe2a2f60ed248cde54fc2e3f5d4c00fdf3138cbbb','\x9fd0302685041a2da452a69af947d3fcc8db75de','\x315e1a5c796b734585c27e615b774441372fbd08','\xbbdd026bde4eb28d5827b12f2067a16997f847c2','\x1dcff44c2364a43ef6c248ac20dd66050c77daa6','\x3db01ee8918012ec0050cd81fefaf1ca44804fd1','\x2231bec9c6479e4ce9c6aa5e7b997584523987cf','\x17712ed0cdb349b91168d736a7f30887e1e395dc','\x37a08ba506e5f66838988ba5df9a7a3764ac3eb0','\xa77ac7dc1acf5c49afaabab517995cc4876dbe6d','\x16cf7468faa76285f5ea809aa072312f30ee9567','\x65887b5be71ea341883e4b7ba5a183fb9715d63c','\xfc0280cf387b7e81b2547f288a42ec6f2d3c62c6','\x207053a23d86fe3697dc073461f293894a931a72','\xdd7724eff52c6ec5f2f7649eadd5025d890b3690','\x920cb3c07b0421f7f577088872c8bda1f3e172fb','\x2c15813a0e3ed4e19815ef927dc4dc5961fcb4c0','\xe3be1d10cb73bdaaefc61cace4bdceefd49c93f2','\xae78b03aeec6e077a7fe4fa0b341284d0b0560fa','\xc13b25ccf12160d60edcac2a4775b5b0df753d6f','\xef1acc76f004ec43a3c3052f189956f995a9d134','\xc2332295cfbcd03531a77b00a019f39335ab8d43','\xf22fff7aa07a38ac1f9459896a6983226835ddcb','\x1841b58d869a720e6f2b49886e0891a866617d92','\x5cac404d11250cd241b719487f47e3d720873cfd','\x9190a046bd8b714aeade0e504d5e1fbbaf17ac07','\x298a68eb9ef8e1485c6bd00827f58076b2c18553','\xec927c1653329d10185ad993a8383af72f53cd7e','\x0c387030a5d3acdcde1a8ddaf26df31bbc1ce763','\x4dea563a60191c7231c8c557623b320a36ebae0c','\x4fa4167b3c94a80416bbc768fb919bf3ace9f8c2','\x8a5d335f9b2789f7db40d8f79cb59a401b268b33','\x8791c9057566af6f55f18fdbea4465e1b1ee2f8e','\x9cd7d8311ad60c987fc39f4c35fed1da3cf86c60','\x6ae68bec21aec25fde2c910b1ce6c40553eb8cd5','\xee836251ee934c3126ac5d9bb29ae9177a6a12e6','\xf9710e525b75ce28b3fb98df42553f87261ccc50','\x476e2651bf97de8a26e4a05a9c8e00a6efa1390c','\x9c57027b1eca93093a6f446422c59c85a5a3fa52','\x0a1f2e1a4585bbf5e54a894fffa74133654bfadc','\xb1562332930f33ff37ae32e2bc126d62d8690bf3','\x83c9440dc34da00c47a0d4dc2b598d7bdb1b53f7','\x291c8ef8f1d362d78f4050672f7d0aeef7bbf37d','\xa5a87f83337410c2250f051773c874067795736a','\x97f3e6408f9679830cbf93b57b30693be566939f','\x1754352eacb753327fec2d4f48f0fb36b672c5e0','\xe49b44bde24db59ce57f34d3d27060f3fce7f603','\x60a7f9c734bd82c472dd05b4eb1add950a6852f5','\x354044d39f1e31109ecab3407b99b2ad5ed6515d','\x7bb9e4701ac444408645f829b53d518955aef634','\x3cca326e89bdcb757160a7a2dd1f83e123cd35a6','\x2b7244194dd9e7464d922d238b5b7e8b6bfdb70e','\x68e858455ef7cab11152d1afabc5c106b690b014','\x19a4c3b23d3df29e9e8a923a1063330c56b8d899','\x463f49d1dc0e1b8891f1e07b1736496bca15e673','\x9d86c4ce36bee7e286bb377eebd2bb84b856e648','\x8d216b875b5a1355e5938cdef73b503231a81c6f','\xbe498c7a06819421bb264237ae7a85363850d8b9','\xb04fa1ed6857e35d16dc435f5241585277e9205e','\xbdcad8330c9b6687e80dcc7fa16343a6bfbef119','\x61cdb70be8d570acc752d2c1261a9e33d7b8816f','\x3025e5c5b227549bac82fdc9e016bf26254d934f','\xd013a8079b138f2806c05e4a86bfb8112a5bce2c','\x9864afd1ba62375dc849c5648b338c976930d303','\x80de2db4695a5e8aa9dd8534abc5e58dba5b6e2f','\x94c985471b62149413e4fc0aa7cf503a9ac7e501','\xb36617313528b5f5e195f681ffc87ed84273a92a','\xbdb9c076a38c64f4a03e5ec00c9f78278fadadd9','\x48dc139fcd166a7d9696f4e8362dee51a57a1431','\x11ea1d48a13efceef01d7aa53ee890ab35388ba0','\x465623b2ce74e0eb844c382d76a900c32566c46b','\x455839e1ffafe624051de0b89d3eb2930ea4d69d','\xcc707819708a144713dad266f22836ee4379ffc0','\xd45672a1300867a072a4c5a8d3ea8e9f41f85ada','\xb527810763eab8916d959f9889f4f83cbe6978b8','\x92edf4c29ab0de7e2190172858409d0f663da3d7','\x102abd17302816efb37d6e20990dc04e37b4d227','\x7131f0dd2a1c6d45ce4035efa8d97f21b7a662d4','\x046f601cbcbfa162228897ac75c9b61daf5cee5f','\x896b91836ac899fbc107c8d496eb1b96ed48d2c8','\x08db79911bb3215ca7406e2b4df23348ea33915a','\x5159f20347d5e9bd5d23bf18833627159f66c07a','\x014607f2d6477badd9d74bf2c5d6356e29a9b957','\x92a4f58009df9eac5f2af6d05977683639f0060e','\xec2b36f1c3a37435b732c0c32e2fd1c6253ff7ed','\xe621b155d4e25254d1a34ba4e0cec27b325b86f5','\xb84066fd214ac2b7ed1d606cd32835287840f826','\xdd77859837f8649fefc633356fac451facc35539','\xe7014a666967f0c99435cdebd2bbe87818be379d','\xa7ac9cf92f4d8fd54ca1a3ad8f7f1cd41fa9dbf5','\x3e9e20680df719e874b60cd44a9329cc629bc4f1','\xb507063cd30bdda9d7c820632b54387eca2ad9d1','\x7abbbf772e03c789f0fb03e465ad8a5b462d0bcb','\x74610aec3faa3b3bd1b638076c86fa7970a563f3','\x30cfbd4a5fba264b3aeec86106defb3ef4442366','\x54cce2fde51da89356a3a5522af39e9c2169d4f4','\x078a50d3de76b334cf70c34c7760b9da24c682b0','\x7ff4f8fe1dbbba8dc27103359bf96e97a4d44114','\x9c0ed629e88a1bf3efd0d82e06cdc314a05e5a98','\x3149bbd58103555c49dc98620e27bca6492d1708','\xc77a1222f675b4142ded8998e7cb938fea1db44d','\xe7fbe5889a2624c256decaaeea0027c1633a8c4c','\xbe02293e12ee9fd9cb185f7bb5a9031f81781df7','\xa226b0069ea5a21a97d2e799c9746f25bd685fb3','\xfff6b41a29881fc97bd6e8778529b1e37597d94a','\x82d0b080c077ad1bc53d5b11a370bbf0d49f629c','\x55f5429343891f0a2b2a8da63a48e82da8d9f2f6','\x4d7e6f4a94f3a322e18ac9cd28eb1ffcc00ea33a','\x468fe1ba226e29a60b0875c377f531de377c2c24','\x3523af5cb5053dfcd90f1a4ae937140ed20234e7','\xfcc803bb4309d3a2f9c7550e677d18ac9e127e17','\x1dc7f23e5b2c705a415b6099dfa86a4e7863ffa8','\x973c7026aff6f21b8df1d8228cb408c06ff7c7a7','\x258937b571395ccc499a6d6cc0660e3574d5600d','\xfb4470ce618546f9ad18370d3550990c07480773','\xcf319c44d09d4775ec5b4176d4664fb9a8fd9ce6','\x52ad7944395d6fc1f905ad6bf8b8c84aa51a310c','\x9f66d7117bc1f44cc95285cf3260e6dec398ece6','\x1dcb6aca2949a1ba6bc576c46c6f1da1b3ea6dd0','\xa995e316d4ae8c6d65dc055b68d0292fa0d24fa4','\xb2aec364e5f5b2535d4470a6db22f4426828c7d3','\x21d99bbbc49846fc9864931a0c3fdc296999aeea','\xe3c7f3837398f5391b7574ce70a3544a3649c07d','\xc9fea6abf1ee0aa8a8596294447f90675a8a99be','\x2d01964aea138c35433a29aaf96669796f884fbc','\xb9fb1c87d81944263633f981b3e13222afc0a2ca','\x4977a4b74d3a81db4c462d9073e10796d0cee333','\xd57c949943bf6a11988181a7f7eaf0be097a52fb','\x8e5c2f736a2df4e2759b56e9c2f1512b18c5f33f','\xb329fb5df5a746d037f3eafd0497d15cc5e193d2','\xf8afa6338e9fabafc49469c32f5fbfe911ea7c04','\xaa48031e9ed27d04cc5cf0fbd98ca701e55a69d8','\x0aa3dceb1e65b8f7d3a58bed68054b1c81585002','\x86e52061feaaa3296de3706ff41acdaf04e3813a','\xe715016c535e0030943ce34b659623215ba830f7','\xb9bd90c9e0aa82a3faad18fc7ec90b4034debf04','\xd0d6e0e58fe68bd495b4fd56bff3b19676460272','\xa5777cdfedff6e84166c76460168f60abc50fec9','\xae3cfb4a88c5dacffff1978b7ae696e111b2c6a3','\x8a77801570a81a5421d2557f1033a6d365833712','\xde9672bd224c1386dda61db911de733f8e1eca9c','\x21766fd1a89eed3797d9e7dad0ccf877b6558502','\xd0ac50d9f7516be16e2449539394a3967bea03c7','\x896002e29fe4cda28a3ae139b0bf7bac26b33a8c','\x9a5cdc551713f81849367f65446a054c7c02079b','\x9c8aeb616de1f4c86d0211ab680e896bfc7d0ae0','\xca6d1eb752d067204a3a8187f72b58719ade38fa','\xfdeabb14d2c092a3d3b85af5b992e0e73a4fc1d0','\xefd975b6e2cbf5a7285d3a5aae275e2e275ce77e','\x6628ec55dff5b6c666cf03b048395cdfbf453673','\x015bec4e0a4fba23c06bccaea9e93fbecf1e953f','\xed8477074529478064ff1ada1bbdb85075a43b57','\x0d307d9c8b6d4aad162a662e4bbfba9ea96a5f81','\xb03f5438f9a243de5c3b830b7841ec315034cd5f','\xe60356ba17a1996a1ccb16d3c9894f08451aa032','\x5fa9d9a07b6d4de57a43ca4d2f24c7d8a4b5f300','\xb86141f68ea86eb20bb523bfe20b35839dca1157','\xca23efd643660d5502c9096464e465d9c06ff56c','\x5686d7e4e15f4c5cd0fb750205da1fb9d2ce42a0','\xb31b9f9cec8ff2ed4ac95bca61f8a83fe7c25d59','\x0cf30daf2fb962ed1d5d19c97f5f6651f3b691c1','\xb35e71b6a5aebb07dfc3aa705968411ebdbc003f','\xcb4620765165432b84130624e52b15dc209476c4','\x08a5979c67528cb8e2b1f15af705f25f4e9f01bc','\xceb4365754e7b12b4a142f08e4b6bb9aee2abd11','\x9526818a8f5d997652c213a28cc532cf6b709aa4','\xc897f9b0b27cb4254e75e6763881f7ef70476032','\xac2e11a760cbfc949c9e95e7227dd43133029838','\xbe39fe921d056769ef3657ec9003d235bf5c381f','\xf1cd68e5aeac18e831e780a4a6a0d2e9879138c4','\x6a1277348cf377c544bf5d0b9d627e10ecb64e61','\xf335baa6e6ad984150a8526238808d2bff69869d','\xd2189c095bd8e69f6ef3bcd46ffaaf1788965e6f','\xcec4c56ed6f1137d0a94f3cc4645a406741fca5c','\x8620459f4f82a495a65672db10e3f952f46bdee2','\x1e8ee48d0621289297693fc98914da2efdce1477','\x94e217f60e6a00f8abfcb255097aeef4b46e73da','\x1c6e17b0a1bf327fba32cce1cbbe5d2bcdcf6c28','\x68d36dcbdd7bbf206e27134f28103abe7cf972df','\x804ecb384a0c2cc19dec3f059d62b33a0d155e4c','\x7d18cf6d8b4745647d197f1bef776690f0da0468','\xd32b0a3d760fd00d9fe44dc7793a5fe3c028159a','\xacf4c2950107ef9b1c37faa1f9a866c8f0da88b9','\xfb5caae76af8d3ce730f3d62c6442744853d43ef','\x3ec44a823e07555b5f889d8d954eec736eb5865b','\x78a4951907533f5898cd598e32eabe75135a8768','\xee56e9cb3ee0fa2e531b263149584a463d9ab064','\x926a2d6c60b62afad82aa73adcb5c48ad5593655','\xb9dc89693eaf1368163e2723cc7e0dd591b461dd','\xfda701f24e65b6e0fb080d63707a6e4eb08b3211','\x82513ba428c3fedab6dcfdfad5b7ebcb5076ffa0','\x3e3672b23eb22946a31263d2d178bf0fb1f4bbfd','\x6cfec3170f708d76f07a6f2eb5688a3f46cac0fd','\x8a1890c305b1d583dcf19cfd208c52c23fac8d74','\xa7829e5e776083fd772caf49ef691bde46b56728','\x18d8b62bfbd1cc3a4b9f0359999a6542fa7100ec','\x4c2395a209360b4ff91c7e7fe7cf41852919917b','\xda98ad3ae2abbeab2345d4d5c329fb0112313f24','\xbce6053b60c5913f4190c95f629f473be0e379aa','\x63eb2ffff3c8ce979b2e83815a3ae86d70c54ee0','\x728c4225d8ee8f9cb3dba1577bbf0bf98996ef17','\x2ef49be798dc5bf8c0ca17230d6d92a49fec5576','\xf4f17df9288e78f2b4a4ced6b11d8b82b4d4b78a','\xa4892c2f2f9e007ea5aabd125ac54d59a4984738','\xf2f34e31ad1f345658e34e754fad93b28ed9ad57','\xa263a0484e89c25873a59f2e5c089fa42fef8e58','\x238926025e84475e3182774df480021470f8f978','\x06c0fd9469111825815c49e9e367a96b971e311d','\x70d43f3f858aea98dc54306ead97e98bcf571b1b','\xe249b21026cfdc51e3346754e2e5f0de41e1fc88','\x69c74e7f6b97e3e106d965a67bc6939e4cb8e76f','\x5e4c3ea7178163515bd90991ae5dfea5b4202582','\x7a92b0cc2cf5f7e44fd449fb6541161bca029757','\x3420c19bcd121e6febcc20fd502b14a71c2f857b','\x4851eae62a29273218a226027c94017fcf396e5b','\x1744cc362a1e0e4fbe0fd4e09ed23a121ff5375f','\xbd1f7d88c76a86c60d41bddd4819fae404e7151e','\xf6244b82a8ff1ac80e880f94fbce44a4bf7e7b01','\xd949eb4ad3287ebafe9c518ce8a4a4aaf52340ef','\x402d130c64bca6aeeddda244687bd6111b06b310','\x6e02f9ebcbea1d919e77d237cd32150d00f41b03','\xdb851d1c7bd4370089bf04641e628cab2a538586','\x25338236e49ae2a45f0349eb63a3055c8612ef5d','\x890c4e184711df8d27a8afa5b626631c7c35757e','\x424af9480e5b27c8a7c140ee75fe378c5ffeb302','\x2a92195a610f21f8da1801ff9756aaa11319ef68','\x0f560d3b9a4000736d41943968181fec774322b3','\x10faa4db982b861ad4be47b2b94c5b4c6f1969d8','\xc67fbd493097fb241eeb8500e8d7ad412b0c463a','\x842189d33359f39681f3b85a285ff0367b7083f5','\xbf227bda5206fcd42e640a16e7b8b59497f2420f','\x47653f66e6c824dfceb06a59e9a7bee73d9c5078','\x6facf564dbafcaf142cce4fbea8fca108bb42408','\x08d16ed605d0ea68a81eb27814aa04bb67f3415e','\x48f88a8d8e4a9dff33c0a4d857a81a189c2d6e07','\x59818079f3044f690783c5991f3609a0baf7d0d4','\xadef37aa14ef396167982a3c547a0c796c01f28c','\x495e06704e9c01199b0b83998d9160b305043234','\x5ab380cc7aa52a97a927cd70a82703a07f97d4c2','\x63cd5c7383ce8fe645e853db1813edbe54464119','\x01f653058536d36bac0b16b90075f1f2acd83f4f','\xf5726dffea33167134e4a4f52d4e8956b9d4e717','\xd669da505b67d308b2dc7376d6829f3723dfc120','\x1e4bb64458c43c72bd3b711631093b1b09a34eb8','\xa7126f204c3dc45ef9f920c72e70c9e5474e6434','\x03894d4ac41dd6c4c2f524ed4417c90fa46972c6','\xb149827a0e8e7826a4cce3ecaf2e74ddc42b14f8','\x98763224d4fcd22c50f523f84bcaac2c1bfa3077','\x708621fea6a3e127f775886f4fcc5a7edc6cc736','\x93e35d313598215d616a4b700af0c932c9a73b24','\xad794c165a8f2f8ced466d4a551f5e942255b387','\xb948128a7b9718747bca009d6cbaef0c6a1e215d','\xadb9b4c10b4930e4a7d99fd6f17e9c6516485416','\x5d8b04e983a2f83174530a3574e89f42e5ee066e','\x40c275b6a532f1175f976aa6fbd0aaa19a82dbeb','\xcda6f2c16417ac134184cb8b67764e2e32888afb','\xa68bb7c3cc33bdd1e0aa740cefbdf5d03078d969','\xbcfb648d3bc83f67fdf77c487e5428cfb1fab4f1','\x6a09221913ba5871663a1b3cbfea727440752260','\x9b616ac1d31f17be9b23560d93699ca7732e2808','\xa96f69fcbf440ecd0a50e8bc351a59909398f6e6','\x0a51ce43427966ba52bb09fe8fbbee549ec3a6d8','\xdee3f6ffe6254223f44f1e5c451eb697a3dba45b','\x8467f76ba0b033232e37c9b8cc4c28756400553a','\x021f25bb178617a8afdf9a968024bbcb412e89b0','\xb48f63b8fcdce3b9a0e6c1e11b97ef9be89616d1','\x74762a153ef51842c0f53fff64481a155f1ff586','\x18c39294fd2f3c3fd2a756435405ca37e4a06a0a','\x95746dcf1f006f693436e91f49a01d9c3b012daf','\x9ee5045986807bd9a5832a61db4db96d634c2dc1','\x016d4da7c7cd614cd50149a373873ff090b9782e','\xa81dd8df74a119cce46965b3e5459814245b91a4','\x5ca54def2e421d51464d4bf5ba1f456416d41a0f','\xad4c632b4744eb663afd3bb28c5167d4a40a53dd','\x17dfd18987b6b131686fea478600b75d11193335','\x526e6a63e359b70a5f746db90410bd83fb63ecce','\xf6459c66d232ec11f082ff3864be3a67461aba32','\xf4eb6a37d1b2fd0edacbba492f501dda8eb18118','\xb08f95dbc639621dbaf48a472ae8fce0f6f56a6e','\xc5d20b24c40a4d8489af847efd2efd12edf5b158','\xf971d9858f66582d4c470859c48324f7accebfc5','\xc4676e5e99b823e54b3e6c32c8143bb441633eea','\xc2c93a56e3a6fe97927d238d12ceeb3a45d3dddb','\xb89b619e3f6c35019d4be83e92e99e809af8ecb3','\x3966db1405e8bad4706cce34d786bc54f5689e41','\x908e8e8084d660f8f9054aa8ad1b31380d04b08f','\x027a43d17dc50640341a27fa7b2636b73b410cf8','\xfdbbed33eeeca1ffd016ec9d7b29a27d535168f2','\x96b8885cfa40a7054914206d116e81f1b5929254','\x75ca45395213e62db2906a1653f601072c63876c','\x1b63f0b0c9ebd868bd4d6044648035aebee1b01c','\x28425420e14f52ece14dcf786cf85e273313610c','\x3aaa1b22b24dcfd0db68660c891e71915aa3dfe7','\x432fcd67815d5cc72808a7815a02373fdee7d740','\x13f4219896bce2d2e2cf0e946896ad946c977470','\x2ff200fb28c3405c89edca16fd2027727e8358a3','\x13389316c576c3e7c9288c1c8f4929c470fa772c','\x4a02cd742904a46e0926cba4d3382ad0403e8fcb','\x8b5d493fb9817efa5b81a85592c60a7c8df38db7','\xb49c54edfe1cfe5ac83e74b179474f6224d0763f','\x9161697e52eb900791d86afbd0baa013305bb012','\x8aef8cab813a8e3cd8fb8dd960da46980e567eb6','\x772d26b1e4779ae85e6c3d6d002605c75eaf919b','\x26160c3c8dfb250cde489e3a489c97756b0bb606','\x934681fb45fd29207854243119c13bbfc11c9c67','\x9fedb4d801a82b9b5f2d0e7dd0f3a1c88b3a6a23','\xeccc484dd4093f62fc24c4725800013fbc2c1d15','\xc7976a835bf0a0fdd4268a9546e7b1bcb64405c3','\x90f5cca4d9063abaa36604c7e045893ed707b62d','\xbc729980ad5dd0a342bd5e32957cc92919324e9b','\xb512f6eda8d66092c5ab1d6c5ec718970e064683','\x373fe167894b0ad6db3d868502311ec4d450c65d','\xa059f92f45c6004414383131da4bacb09182a7b6','\x95f50cf888dfec90321dc376c1e695f15b081595','\xb2d73716ff6305d7bfd9a38e46338d695575b07b','\xa969f38784d041212e9f9d5eae4db62f51892039','\xcd684f4b4d8da36406b984df2201289d8b928134','\x70e52b5b5ab512c047f9cd437dcf8ea4feedeb39','\x0bd55d236eecbdaf01d2c79253da0aeb3488af02','\x2bd21f6abcbe1f8e1b53ab14cefa64cf8c3005d4','\x9cbd3680e05130fd820be2764da0dea52914c646','\xdca9dbf4b1a04a4f6ff13b587008cbc982ff91fd','\x527c6a63840bad5a1c18d61685c2a7a62735ee9f','\x2babe76345d7eb15f6a1c0cddba04d8ee44491d5','\xf61397e4b0ff46e78b34d5f72b49b4d46e8c96dd','\xf9107317b0ff77ed5b7adea15e50514a3564002b','\xfbe22c7f4f3a4b51721e9462c6ea959f5e00becd','\x85162b355eee83ed8d29c3cada25b80ca86e80d1','\xc957e4ef89e5cc8b90ec42309fd5335615282a0b','\x19accce218cb95b2e673812d3e84639a8d3610ba','\xfdc52139ce33c3fd41e09763f676042932db0343','\x5a57552b6690405097e1912415ffcce04a4e5386','\x61655c1aa4941400a7ec2f7c4c7060d57d5e233d','\x0df58d7d446867137824975d95b2d3235f5d3955','\x1ed71ca675436a301a10a3adc53e00a7bd2145a1','\x968a0e5603c5d4dbf24cbd7df562921d158ad19c','\xd174ad0d1e36c7a60cd922e966354095233f8f23','\x517467fd345bca0524b84fb02330af1a5b076274','\x6ca5b974aa4b7b08ae62699b6cb2a5b8a52c4cdb','\x0a771437ee59dcd30429dda71a1a011db8957bd1','\x7d78677ef3b9e71a5e5696171dc55301244f579c','\xda3992bf366d78e0f47d85333182dfac32eb4a82','\x312042fd0432e7810a8820b06631c83fe9472579','\x95d8ac20b2377a00fcda7cf56709c4570edd40b7','\x611422f162e6eadfb3b37ca571c18bfebe4c4c60','\x023bd18dc5251fe4a606f357a18a6e04f10d75ed','\xec1328fe41b5c767e2330b402ae4095cbebe1648','\xbc125c151adb335c14f77ecab5f258edc5f4b016','\xf4342e29e2b7e763a3569622606beb9c4ad2dfc7','\xb3a5cfb7776a4e11fe570c3698837d5b2217ad00','\x6194edd8195fa86141205f88888e50a1753a4b5c','\x0b83fc77303e59754da7f21a856b1a7f7da70a8e','\x09ce596360eaf7f38f0cc8210dbd9ae5baf64226','\xcdb1c59758ca1f63bf3b935ecbdc075bda3e0986','\x864abb5cb1a5d4b10a6f12dd808c9e1e5ad7aae4','\x2fc3fd7c06adfc48736122ea33820038cc16dcdb','\x2a40aaf3e076187b67ccce82e20da5ce27caa2a7','\x3080df76e5b73cf6884b763cd3ae7d7fc3e8caaf','\xf7f720316e258ac0747877ab023d9724afecb5d0','\x5237546a7a08ea5e1ae945d8469d77851425d180','\x4a4f526c9009c2c850da2823b68de351bb4bf238','\x0fb876a859577198e6b2b1e5ecadcd7386b9e722','\xb30845c026325b993530eb89b3654fd596b5f2ba','\x29d9805f44820446de090a23f3ea78d346b6dd3a','\x3d0d364a3c7eecbea4a26ba4b18de44385e2b941','\x39643f31647d78fe1ccfbd9b95c1155262a0f55c','\xbe93d14c5defb8f41af8fb092f58e3c71c712b85','\xb36730b77db513ef82ef3afb87de24355fc81a76','\xbf37a2f4f1eafe152e8336465cfaad1fda44b588','\x6dbe54639368ded896a9d352b771538edeef6db6','\x963deb9191d6a7dc1fb3891d472aa358b3e4b140','\x12b0e1b718b33d16512bd7a81c3680faee3c7e3f','\x94443aed6c67c4201e7eb46ade63d5cc40eb7fb9','\xdd37b78b0850a096ff9ade928d64e6f31e80d061','\x2b93c20b62ecb87649261bd8403be0d59a09e838','\x2a9937b9169b2e3b6f8ebb12811f22effa98af47','\x84d1e52a5c2871d72ec2d190e14d19a065c98726','\x320b460d742a1574dc2f7fb2c6dc56cc5c692174','\xaca4ab44dcd2ec6982bb5238bf1daf268c159699','\x19cd3473bafd2a3cade12262a73be21e02a50490','\xd69125a34e746b1b7301b035960e2e3c042baad6','\x5e4568c4d8343052a06ec8aab1e124af08b73248','\xc48716dd02e60171167262fffce778db7bb3b712','\xe1b400b95a1d6499ee03edfd4854a99caed885ee','\xa7e00be3502860762639d7e531ad1d35d79e78af','\x3ba89593f94ee0480650bed3160f212cdfbd2ead','\x21036fb872efe5a46fcfc5616eadd40ab1f013e1','\x6b3de22ec227d168dfaee06f1fc629b49eb73e60','\xa202aa795beecdeec38ed4c87088a5219a7d712a','\x2f967a5a4c2e2c947e1f044a302e9b33a62eeda3','\x1359db6e976f31d3ea109c0841e8d9d0d10e7aa1','\x38430336153468dcf36af5cea7d6bc472425633a','\xa2486e3e0964801d9e2519e324ade753c0c41f2f','\x6c85553e86609ba71f646bfdc506d65981a4a2d9','\xe8e1336009a0e89edcddeec8439d3c236f82d031','\x66fda6b697155fad61694713f4d6b0c02736e2a3','\x64bb049ce01d2b59961f0968484dd8c96a46c4fd','\x0efbbf1a8cc427eae6b375b0fda5775d479c5f7d','\x1fd7de14c5888155d6e96b582729af91de9bbbad','\xc460494a5c5ff53d8f682132699dc80c748f8e41','\x1b473220a80c652e6b093956885a8783ae389412','\x7c28f16fd858fe8667bec9d7713d2a60961e03d9','\xe3f6e63849b1325f3042c766d16b53fab70db96e','\xddb125bf3a60a892a49e31a2abd2c3e3d6bfa549','\xc1feb0b7d66a3d43a3bdd6a13c28a58bd701fc7b','\x391985fdf0f28de092027d52763621221684cadf','\x0b2783cb60ff4ec7ca869b30b8dafd801e7224b6','\xd43d35f5f1fadf3d7f99350d940fc89aedacc84c','\x1a12006c1f38752abefa4b2841c2b72fc4ca2a47','\xfd958503c1d12b2f9d5f4ba67eab8a604bd0cb67','\x2b3bdcd0e2023437cbe56bcb04fc95142dcb02d9','\xd5093a6bcde4a2fc372e9b001d78da58f35b9be6','\xb7069e17fd46930389980f3680391c54fde20039','\xdda9dcd0965404288fc285183af8b879930c6013','\x4ecbaa7d2f86f2d78c04f49986ec2c57938752a6','\xd6c0f3032b7876b504943cd5252c485d3168a849','\x94bda0ffcd3da88584496d7a2579cdf594509b09','\xeffaa947af692245e1e6a4aad1da086b13ac54a1','\x55c464db5f62727439f1640955f911f5e5fb3433','\xc2997ee0ea49dd3292cae1b7c4c2ef4a4b98a030','\xe540cb616dd8ef64fef2ad5c25a6c470f2c5379d','\x3b4d5f6f2bf6e36a08e6854d28f9095d4a01a3bc','\x0023d9ffe7d793895c5da5833d56c737832ead2b','\x35bf253f60217abf339e9a01e74bd3eefd683ee5','\xb86c267d0b02a961caf3a6b530f3e1542612a6f2','\x49a3c870ccb3985637da5dc80057b4fe5658f326','\xafba1acc74aa89d638612e57aa4a9c60cae7c1c8','\xaa634afa9e085f64c100979d8fc40545e644352b','\x541ffd67537185cb4abc2b028795c2bf4ac6c45f','\xcb9776415d2b989d4a0894912c3fb1aea4b46179','\x2cced186c0b172443884b0dae52695e847ee010d','\xd3a8a2b6f609dc0103ed9b5c503f097f6361dac5','\xd2173762602a375bab56938ddbea1420fa9e5305','\xafb9d7fa614dd77cd9d212bb0596982c850a5085','\xa6036189af87dbc8ef7a1c53917c71647ab80b3f','\x85ef6932088e4f901ac4f0e4346b358fbd65d4ab','\x0a47e99ed9135483f3f4f0f864685526f368c34b','\x1ea34f5ec652d3490fd8e854aecb2a90b75e403e','\xe1964706e2f3c45f67ccfd39348c345a0041333d','\x22536213791b04d8201ba219665dab3835d993f3','\x9ae9b5e208dea9bffb62e1c88ea864eeca85e1ef','\x1bd6153b1f7ef45ae3b39bff86d93df10b64f758','\x317ee35a01393ca21189d648772afcb5e6590a41','\xf335b6bf6a38a782bef87de9aba8598ed63d2d2d','\x90ff89c637fd1537e151b8ced1d1d0cb94e31ca6','\xce1e3befee573a29816893468540cdd2ac0c4d34','\xa4a3a003346a53fec984c89687c1946d536e0c82','\x63a4fcdb46914b65b625cc42c74ef76031740296','\xa2277f4ae7e6380de426fa334b05d4ceb39f1d47','\x14a3f35bc1872e46b6c4308627a884fb75d52acc','\x4ae1ecfd8477645e1c394c39450dd639d3516e70','\x8b104344f397afc33ee55c743a0fbd7d956201cd','\x0b0498e4fb7817358fee5b20501db0ce7e40ba36','\x924f17026ab7e01147f892c3684c85f758775701','\x58d1c86922d050a129c78f76f1f91e73cf8b51ac','\x8998a679e0f9f50af97d3e2a0c5652b7d09c10fe','\xa2c9d3c60bbba8c1b832573ff8c2acbca7253361','\x4a0ede313d1fe3dbc38c3be3471f4fe80d5e3b7e','\x58b543cc037743dec8b74b04293fc3e9eb2675e6','\xcb63a41b273f5abe1ff0a1259e9ae2d85129a187','\x16a15a4fe0ca6a2626db8e849e1cd5659171937a','\xd9293636ee3aa663fc563adb0912b0705dafb62c','\x53b015573630d248a32b11b21e5443efb92d9cfb','\x751949ca0e82da14f6ce1161640684f284e87ba2','\x382cab376440f92d4943f8b47dd45645cf98be0c','\xf3236c9d0b623cc261009484db5cfed2079a007f','\xd3844212d481c135bcd2659a0a1de4075b0d31f5','\x2eb9e7fe272db9689724cbb85d7a06c8c552070a','\xaca546b3dfb987b0f5144c8e27bb13fb63bde326','\x59bf87b25124a859056689efa61cad06884b8553','\x14468ea31273dc32042459d748f662c1caad29f6','\xe4fb9ca52e39b83be69e74e7fac8f807a9c16ef9','\x8847ebaaf29a18396e49191602f8d8d141b98aa7','\x74bcdd2f3a6a91bd34fe6749b8b522f9ecde2e3a','\xe48479817dd736735f48f55e00a9f7abc9a2647f','\x004a1dd8143951e7c0ad25ea1a5917aee92d8edf','\x7b29106c9e25df6074e555ed41b368e03f3b85ad','\xd2e97c2ea2d1a3547d419d4c9503932c7930fe73','\x9a44394ffd96a78d0b5c5b2f5dcff6052c70176d','\x049982627134cc9029549098aeefe8016eb09b15','\x0feceedba5710d0cdfe9440625d5aa35268c989b','\xe0ee6d91ca861ded71da3fb21562e1ab4e10f430','\xa2745bbf0790494a08c8ffcc295065cae19d4e5f','\x84a9d75bf81e519596bca794ff307b73546435c2','\x52f7e63563c537513d32c7528462da1e3a89eb09','\x373e8642172498785ab9e43f1e58b3a4988db841','\x5e3666054b351ffff4c49812f32972fc6ecd1293','\x4fed79ac1648cc3eb168ac93b90eab15cdbf8d59','\x70d6932f5fb6883e6fe7f8476bf3993b86a7b59b','\xd684e69fe23293ed71412bad19c421cd3ef54345','\x355c75222bcc2dae17fca3541a6d1277aa594e43','\x7f96a6269b00c56cdc319721be80bf8c290324a5','\xda428be4f8e0ec294fc0647690073895f406c659','\xf3637714f1da3c899407b2130fbf2250c3fd74ae','\xaaddb6dae54e924648c02eece703dda900208744','\xaccbf26edde55b037fdc030335b0ee1ca9335ba7','\x8b8404af81777466d9ee876c93e949ac2e38a861','\x1d9bd4217ea744a2f82e6fc205e5606318b46f35','\x51470680d9ab003a53a81fe7bcd9f3f85ad84069','\x167987847ad2487d76202583eb34f90007cc95aa','\x339280b9197cc05a2a3b8ff7e9e06323fafdd572','\xc635ebb012bd96db82ff7b6e38dd3371ef53f7ab','\x708800fbf7a7e8e65b1d8bbf651c5c32019e7325','\xcadaa055aada68a2c2a5aeacbd808baeabc8504f','\x2017df91b7eb69308a2a4c08d123d9cc69b28d83','\xc17218f6ad9297c939136e8389dd8449cd1d2100','\xfbe9d0b35cd73178d81f2915ec10b16d0a745c3d','\xa6ca02a46684d048fa4666cab4f2d0f6d7469b44','\x060bbb0bcc744293a1e7df8dd7cc2ec81951bf94','\x24dcdb91b4bf1dfc73cc62a19c391f60bafd163e','\xe84a2a488658907ef8253c07f80fe724c9ae34f5','\xad9083c6cadc572988efb604a87e86f8de205bdc','\x4afddbb29f642002ffabe99aec97b561f806b768','\x2fe59a3d4379a127adb934bcb9fcccf2c770eb97','\x9eadf0f7bfefe1513ff461afba8f8034315f80e0','\xc586a8e28cd5ad10deb1423957932ac88c4b4a91','\xee761583827b82cde09bf9477dd675c40effdc0f','\x5e6406eec60dfb5f99a5c32ebe0af462b8e6c64e','\x7033ce11621aac2f4ea41bc752c9c3212cd7565c','\xbac79de245633fcc4fb32c19bc0ac93f406c9950','\xa181a3c3460ad5a2650f380352e3e68111e3d60e','\xeb978f32ff28f819be2ecb547f70caa823970049','\xc062eeca3891539f75054b1060997aa3459b7390','\x952c23f8f067a5e7e165ff0e42491f51d87dbc95','\xcbdcb14d4963a045d6517a89aab07a097230c9bc','\xc118aad878cd75907cf14945326dfda1a70835af','\x1420d63a395b06e1491bbe42e998f0644934cbd0','\x2ede18cb7fea57f5e8e7e555f80fab4d49aca234','\x3b80a4d6843cea218df6d8963c70572c20ef77d1','\x4941a38312f2e2e1cec5e20e09f0ff455e696100','\xec1625f0be12b31d8edfdd165f7750ee4630a475','\x677db23923c294b859f1c8a2cf29d19d28713ef5','\x6139b35ec6d2db5c72e2c7d1174c52b3543d799f','\x729ba24776365f7e812a9310ff43ddfc7055daec','\xefe3a931c174517507ea7a3bb08dda35f661381d','\x8a329c2c86cbb3d7c268564ca7052ff99c8fda04','\xa73621aeae24869942f1279003bde11d4eac2cab','\xfe36132caa71c4b1a88b38b79373aab5e001457c','\xd26a0a35321c6793e47eb602f1676c915caf111c','\xf2664dfa7924d9f3895349bae785027ab9da1c87','\xd059ae0a5036b3f98c27b1a2d69f982bdb1a3a5a','\xf6c3c3621f42ec1f1cd1207bb1571d93646ab29a','\xf95ed2366cbd4a716f8897e2b8c9c5d809f0b69c','\x6422e2ad6996f7006d125ca960a06c13c0720267','\x819ae34d9362ecf76824cec54435367ca87fba6d','\xd910a770c1a5cbc1747b36414571c64ab645bb49','\xd4d38e83d654d38e0c033973016973a0f71c910f','\xa186fa35ccde3b23c8a0582363010e2e07f2fc22','\x4dfa80b181e49b9a2fb4fbb2f1539b5636a499a4','\xb11e18831624272f2d6ff3e835da24abc13cdb71','\x8c39cfe40b1c583c8298b12b19720eee1ff9917a','\xee3a5970da77a8e2e088bfb428e15c147526464c','\x894740526d04071b5bc4227a174a9230e4d7f44b','\x2ede0ccebfb3bf307dafc57ff700183391620a69','\xd05c9152117bb6244dbe5dc3bc23ff9ead8b0ce0','\x6cd159ed2522ec7704452803d10c588e7a731bad','\x5a8d7719c038a678435447448a3b723e97df1d40','\xddf920f9ea110e1a8030c4015d17291c7befc079','\x58944799b0fdf8f13f134724741967c45f329ba3','\x3be45e9362868b91e93c58ab4a7b8bc5a3b205b0','\xee620a0991d57f464aad452789a4564ba51245e8','\x45b68f9c6c23f2d6ae8a5056a6ae00bc760f7a0c','\xdbc993ff537e3d28b9aa110ab9fb87ec49a60d68','\x21f50b5237f610103a13e6a0f16f018d3ae31d18','\xfcba0693fc16dcb2a4e8fa7ed3da31f5296993e4','\xc02cae8f6217648fa2bfbd08c2be94028969a65d','\xdfb526a58512283f1ed94ade6c7cca5e41de4ce0','\x15c32e94aed196f916aca5ed47842efa2beb80f2','\x46ac0c9c530dc960a4df75b20b594fba243e5b7c','\x0f1993e195d4aeac26eca8d7b2b23fa081d5d10e','\x2b03088c22ae484ce873f21251a2e6fd0509ea07','\x1781d64668787be48bcdcf2e4eac5f2ce382d8ae','\x92123b11c37fd9968bbb6463d809a498b7f838c8','\x7fe43a42412082a260149849fa4e45db15c4afa9','\x3f47751c0412fd3bf48cd3b29aea249e58f0a959','\x86e6034c0eb6ec8d323c709c345b36219f3d3261','\xabc6f5246a7872a37bc4fff64b1b6ccc38b16d84','\x7d4053510c0e2ce0f127cf890fdb84f1a36cdc6d','\x852e45ed1a6502406af4c409df4e0eef3cc0a0e3','\x13b28fd1df2ec7dc8efabe7f15e2e7a8527c6e8f','\xf8219bd4d474a8ed9e4041d6cae01467f3ee1e56','\x134aed753eb1a935606d49029055d01cb9eee794','\xc231ceaec70d076b45a677d73bd0d15389b51833','\x7b2e745d1f56a624e608b90ff5419a1d0e7942de','\x78c0a25ccc21604b3d117100de7c9523f53236c7','\xded91aa5e503764c8f2c24d1042078226092cb24','\xfd1c9858cf79c05b2e154068fb435fb81b8cacef','\x95082541f9792682a31ed94c1bd78ff98f720da5','\x44ad47d676263b7e3e84aa1fbfabc2545cbdd678','\x477c2087f3d6e49b1be5c790a33b3a025a4fa569','\x9a3ccac98c03109f45900a2afad04ed901fbf20e','\xab60ec1a43c5fcd24d2ecede83652a8a49cbb6a8','\x57a7feafc39a427d48d032b115444775b2ba876f','\x14470fb4bf4a46949b987cb901da45aacbdca547','\x00a32e18524c3df72ec65f8aa8e055097e678187','\x06c4865ab16c9c760622f19a313a2e637e2e66a2','\xa1f8def224fd5b7f131119e080c41bbc5056dc1d','\x558e6717eaf6d6329850aaa8f62abb38235adbe8','\xd03ad690ed8065edfdc1e08197a3ebc71535a7ff','\xf8a2d686e11f713b5fad1bb7f56fe65a16fe5cc3','\xceea37ed947c168eb7e66a5f434bc607a2508a9b','\xb9f1cfb8bea36546720d92696601b0bc7e8f74f5','\x11ebee2bf244325b5559f0f583722d35659ddce8','\x9ce2a310d248f4ea09dd61279e1424ce6ff96047','\xd761a3f402692639fa4d8441dc77b07e6e5083c5','\xcd5561b1be55c1fa4bba4749919a03219497b6ef','\x29db953a27d602889ab11032bb1505801c987c49','\xc84852757d9ee72c943137a6b8ceadb64703a268','\x73a4b191658d8b0a78a8001d79f9af03280c666a','\xd48a9bd19d0b9dc2183be55cd743d8758f781a45','\x4547b89eaed946e1cf22050522f48b67370728d6','\xb456ce71f5cbf7f9091898ade4064b955c0bed25','\xb96894d91f1986e0b515d950651991ade2a346ab','\x0c403e0d57eeb8f091bcfa8efdf01c00509f04f2','\x272bd1f2309aca871c84f9b48b5d09f97a770184','\x9ce2345707bc2eaf6015b879f30cbd301087c0b1','\x384d600d124fa0e942b647fdc54586a159a2d321','\x52ff0010d4058bb726725ad76f542c53033d67a1','\x34f310c0bb6aa33336c2f8e052ee7e3d25bc1db0','\x4a2f1806f6f07d783653d87e0ece19020df78a37','\x25d31045bafccfe87af5b7feb593490938bb0892','\xa3615b094d2aa6d93eabb694495cd13efeb9916b','\x438b5e448a9e34e67794fcce2545dea4660a69c6','\x1114ebbee0b6693d9caf6023af96a35a06703506','\xa55a11ff5ef925eedf9c0527c77f5a7cab53c63a','\x770752b48839c4d35b5157dafc128b2662e6c0b4','\x7f3e50cd0a70dc1c6c2325848301f8cd73e4e2d5','\xcb630c28658d8b4f0509d628d8d947e6f95ea20a','\x2bb6f794fa75dba6cc43e04c2e8818569bbcb830','\x59c9d046d43b28816393825a3688d93b82bdd625','\xfe8d459e02b1312e7c9e4adc8c4ae188d40a69d4','\x93e459a7fa7886ce52993a48445646a1342f1bf0','\x4311196566b28005e486fe5b0d43b7641fdced25','\x88004441a0f79727d19a2697344244c901736e0a','\xdac6a1fb1fe64ce8467711e3f32dde29b347f293','\x2405bc3156b9186fb3130398a5b4224ebaebec4a','\x763b0bfc1afb3653725ef8091fc2603c889ce16c','\x6c708dbad5c0383d34334c6c6eeebc6732b1a4f0','\xb804d0a16870e2ff870935e336733bc7fbe65beb','\x933e010f70efc3a921b23ac81c91ebe9dead8a29','\x95aec39b2832da46df1321b29eb04a4d181762ad','\x1c6bf82c79cac58eaa6962513027a142417b99e8','\x6188b71bd47ee7ccb679a6a313ab7173f69054e7','\x21b0d7dd5211dea2a71397d7eaebb946a4953d20','\xa0dc0c245c7c64c294b6df8804fada132e840868','\x5a756d9c7caa740e0342f755fa8ad32e6f83726b','\xa2689f6249626af206792fd320b408f26bf1e84f','\x24710809b3cfa3252b26fd5f5826ea286260d62f','\xcc789933e9f9012ebfde6abe1af23c09d354d5d8','\xea88024ebce19b62620e1fea6d56669751644e65','\xbcb8ece3eb543b0861e94e2b2b06bb45d4490e58','\xeb9069c73cbecf3b1306f2d27ec1b7b538620867','\xb73e95a8ddb359318592e4883c1679648205f19f','\x3aef315b67c2e23aae9e9c1174d05371e2c9b144','\x495d44f6eebf78e9a616cf454a8a598093204d22','\x414442278d18b9ee5e4f1440f5020154c7d4a6c9','\xfe5ca2da988182cbe0c96e7bdfa5669ac502b14b','\x5a375320f86c456d6b33498f8958531677dc880b','\x443d1f8a358b8f76df166e7c59afd4cba70073c7','\x1028c87fee6b56e9e0643e5865f82ced6319bd3d','\xa2c943092a8d2205721ba21c842cb94c40cb5215','\x45452d8508356dc9619f23eab6932b4aab1946e6','\xc4a69b137d22b52a36328f3ac6d5aa9984faab8e','\x23f6b90b62c1e366af62efd4d821ce8246abf8e2','\xb5d2d4043196bdee26a549b8079212b4e295cc27','\xf4dd154c860055c6baed68797e5a8393fd6bfe96','\xfb1e8b6ef17feb63c1172ac9266a0fdb30bd2835','\xd3815588b090cd966fa078134517eb091ea5a22c','\x4e5f8ff60987d5c1bb16230c3373e35d13e67fe5','\xd5b6b09a76ec1278f10e9ccbb1709f7f75cee125','\x4bd0ba218b482a391a1e51cf4779ce04b60fd722','\x8ddad62d517000d206133c0e7f5219d5b1a61394','\xe8e83ddfc373bbbd22edf5a80a30ec7ded8f2b47'
)
GROUP BY 1
ORDER BY 3 ASC

Case函数参考:https://docs.microsoft.com/zh-cn/azure/databricks/sql/language-manual/functions/case

前面的代码就是为了将合约地址和标识符联结起来，并为其取名为symbol12和symbol1，以及去掉单个地址的重复交易取名为suppliers，后通过UNION ALL将三个表格合并且不去重，这里（）外有一个t（table）指的是当前表格。

公众号:一点儿知识

Wechat:The-detail