amir007Open Analyitics Bounty: Arbitrum - Top 10 Tokens TVL (Past Week)
Updated 2022-07-27Copy Reference Fork
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- get from https://arbiscan.io/tokens & https://etherscan.io/
-- get symbol from arbiscan and search it in etherscan
with tokens(arbi_address, decimals, eth_address, symbol, name) as
(
select '0x7cb16cb78ea464ad35c8a50abf95dff3c9e09d5d', 8,'0xb6ed7644c69416d67b522e20bc294a9a9b405b31','0xBTC','0xBitcoin Token' union all
select '0x0e15258734300290a651fdbae8deb039a8e7a2fa',18,'0x0000a1c00009a619684135b824ba02f7fbf3a572','ALCH','Alchemy' union all
select '0xac9ac2c17cdfed4abc80a53c5553388575714d03',18,'0xa2120b9e674d3fc3875f415a7df52e382f141225','ATA','Automata' union all
select '0xea986d33ef8a20a96120ecc44dbdd49830192043',18,'0xc12d099be31567add4e4e4d0d45691c3f58f5663','AUC','Auctus Token' union all
select '0x6f67043201c903bbcbc129750cb3b328dd56a0a5',18,'0x3449fc1cd036255ba1eb19d65ff4ba2b8903a69a','BAC','BAC' union all
select '0xbfa641051ba0a0ad1b0acf549a89536a0d76472e',18,'0x3472a5a71965499acd81997a54bba8d852c6e53d','BADGER','Badger' union all
select '0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8',18,'0xba100000625a3754423978a60c9317c58a424e3d','BAL','Balancer' union all
select '0xa5ec9d64b64b8b9e94feaa7538c084b38117e7ba',18,'0x41a3dba3d677e573636ba691a70ff2d606c29666','BLANK','GoBlank Token' union all
select '0x0d81e50bc677fa67341c44d7eaa9228dee64a4e1',18,'0x0391d2021f89dc339f60fff84546ea23e337750f','BOND','BarnBridge Governance Token' union all
select '0xba9a5dd807c9f072850be15a52df3408ba25fd18',18,'0xb683d83a532e2cb7dfa5275eed3698436371cc9f','BTU','BTU Protocol' union all
select '0x031d35296154279dc1984dcd93e392b1f946737b',18,'0x43044f861ec040db59a7e324c40507addb673142','CAP','Cap' union all
select '0x3a8b787f78d775aecfeea15706d4221b40f345ab',18,'0x4f9254c83eb525f9fcf346490bbb3ed28a81c667','CELR','CelerToken' union all
select '0x989d099d29f62b839c8cbd41c82c6554a5515752',18,'0x429876c4a6f89fb470e92456b8313879df98b63c','CNT','Cryption Network Token' union all
select '0x354a6da3fcde098f8389cad84b0182725c6c91de',18,'0xc00e94cb662c3520282e6f5717214004a7f26888','COMP','Compound' union all
select '0x6fe14d3cc2f7bddffba5cdb3bbe7467dd81ea101',18,'0xddb3422497e61e13543bea06989c0789117555c5','COTI','COTI Token' union all
select '0xf4d48ce3ee1ac3651998971541badbb9a14d7234',18,'0x2ba592f78db6436527729929aaf6c908497cb200','CREAM','Cream' union all
select '0x11cdb42b0eb46d95f990bedd4695a6e3fa034978',18,'0xd533a949740bb3306d119cc777fa900ba034cd52','CRV','Curve DAO Token' union all
select '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1',18,'0x6b175474e89094c44da98b954eedeac495271d0f','DAI','Dai Stablecoin' union all
select '0xae6aab43c4f3e0cea4ab83752c278f8debaba689',18,'0xa73862c5a66cf3be4bf86f60acf085bd927f83f8','DF', 'dForce' union all
select '0x1d54aa7e322e02a0453c0f2fa21505ce7f2e9e93',18,'0x9695e0114e12c0d3a3636fab5a18e6b737529023','DFYN','DFYN Token' union all
select '0x39f91452a6e9994762876e1edd87be28a46d5c99',18,'0x84ca8bc7997272c7cfb4d0cd3d55cd942b3c9419','DIA','DIAToken' union all
select '0x69eb4fa4a2fbd498c257c57ea8b7655a2559a581',18,'0x43dfc4159d86f3a37a5a4b3d4580b888ad7d4ddd','DODO','DODO bird' union all
select '0x6c2c06790b3e3e3c38e12ee22f8183b37a13ee55',18,'0xeec2be5c91ae7f8a338e1e5f3b5de49d07afdc81','DPX','Dopex Governance Token' union all
select '0xa7aa2921618e3d63da433829d448b58c9445a4c3',18,'0xdddddd4301a082e62e84e43f474f044423921918','DVF','DeversiFi Token' union all
select '0xf80d589b3dbe130c270a69f1a69d050f268786df',18,'0x469eda64aed3a3ad6f868c44564291aa415cb1d9','FLUX','Flux' union all
select '0xDb298285FE4C5410B05390cA80e8Fbe9DE1F259B',18,'0xdb298285fe4c5410b05390ca80e8fbe9de1f259b','FOREX','handleFOREX' union all
select '0x17fc002b466eec40dae837fc4be5c67993ddbd6f',18,'0x853d955acef822db058eb8505911ed77f175b99e','FRAX','Frax' union all
select '0xbdef0e9ef12e689f366fe494a7a7d0dad25d9286',18,'0x970b9bb2c0444f5e81e9d0efb84c8ccdcdcaf84d','FUSE','Fuse Token' union all
select '0x9d2f299715d94d8a7e6f5eaa8e654e8c74a988a7',18,'0x3432b6a60d23ca0dfca7761b7ab56459d9c964d0','FXS','Frax Share' union all
select '0xa0b862f60edef4452f25b4160f177db44deb6cf1',18,'0x6810e776880c02933d47db1b9fc05908e5386b96','GNO','Gnosis Token' union all
select '0x07e49d5de43dda6162fa28d24d5935c151875283',18,'0xeeaa40b28a2d1b0b08f6f97bb1dd4b75316c6107','GOVI','GOVI' union all
select '0x23a941036ae778ac51ab04cea08ed6e2fe103614',18,'0xc944e90c64b2c07662a292be6244bdf05cda44a7','GRT','Graph Token' union all
Run a query to Download Data