PortfolioProjetoAutomatizaçaoWebsite.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "5e2f2665",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'status': {'timestamp': '2024-03-02T17:10:07.586Z', 'error_code': 0, 'error_message': None, 'elapsed': 30, 'credit_count': 1, 'notice': None, 'total_count': 8891}, 'data': [{'id': 1, 'name': 'Bitcoin', 'symbol': 'BTC', 'slug': 'bitcoin', 'num_market_pairs': 10844, 'date_added': '2010-07-13T00:00:00.000Z', 'tags': ['mineable', 'pow', 'sha-256', 'store-of-value', 'state-channel', 'coinbase-ventures-portfolio', 'three-arrows-capital-portfolio', 'polychain-capital-portfolio', 'binance-labs-portfolio', 'blockchain-capital-portfolio', 'boostvc-portfolio', 'cms-holdings-portfolio', 'dcg-portfolio', 'dragonfly-capital-portfolio', 'electric-capital-portfolio', 'fabric-ventures-portfolio', 'framework-ventures-portfolio', 'galaxy-digital-portfolio', 'huobi-capital-portfolio', 'alameda-research-portfolio', 'a16z-portfolio', '1confirmation-portfolio', 'winklevoss-capital-portfolio', 'usv-portfolio', 'placeholder-ventures-portfolio', 'pantera-capital-portfolio', 'multicoin-capital-portfolio', 'paradigm-portfolio', 'bitcoin-ecosystem', 'ftx-bankruptcy-estate'], 'max_supply': 21000000, 'circulating_supply': 19642768, 'total_supply': 19642768, 'infinite_supply': False, 'platform': None, 'cmc_rank': 1, 'self_reported_circulating_supply': None, 'self_reported_market_cap': None, 'tvl_ratio': None, 'last_updated': '2024-03-02T17:09:00.000Z', 'quote': {'USD': {'price': 61946.5185242406, 'volume_24h': 30552460841.335487, 'volume_change_24h': -36.5514, 'percent_change_1h': 0.09664766, 'percent_change_24h': 0.68308596, 'percent_change_7d': 20.84740117, 'percent_change_30d': 44.4814212, 'percent_change_60d': 36.57075468, 'percent_change_90d': 56.41996673, 'market_cap': 1216801091779.3606, 'market_cap_dominance': 52.1486, 'fully_diluted_market_cap': 1300876889009.05, 'tvl': None, 'last_updated': '2024-03-02T17:09:00.000Z'}}}, {'id': 1027, 'name': 'Ethereum', 'symbol': 'ETH', 'slug': 'ethereum', 'num_market_pairs': 8486, 'date_added': '2015-08-07T00:00:00.000Z', 'tags': ['pos', 'smart-contracts', 'ethereum-ecosystem', 'coinbase-ventures-portfolio', 'three-arrows-capital-portfolio', 'polychain-capital-portfolio', 'binance-labs-portfolio', 'blockchain-capital-portfolio', 'boostvc-portfolio', 'cms-holdings-portfolio', 'dcg-portfolio', 'dragonfly-capital-portfolio', 'electric-capital-portfolio', 'fabric-ventures-portfolio', 'framework-ventures-portfolio', 'hashkey-capital-portfolio', 'kenetic-capital-portfolio', 'huobi-capital-portfolio', 'alameda-research-portfolio', 'a16z-portfolio', '1confirmation-portfolio', 'winklevoss-capital-portfolio', 'usv-portfolio', 'placeholder-ventures-portfolio', 'pantera-capital-portfolio', 'multicoin-capital-portfolio', 'paradigm-portfolio', 'injective-ecosystem', 'layer-1', 'ftx-bankruptcy-estate'], 'max_supply': None, 'circulating_supply': 120138874.305299, 'total_supply': 120138874.305299, 'infinite_supply': True, 'platform': None, 'cmc_rank': 2, 'self_reported_circulating_supply': None, 'self_reported_market_cap': None, 'tvl_ratio': None, 'last_updated': '2024-03-02T17:09:00.000Z', 'quote': {'USD': {'price': 3433.3811929841036, 'volume_24h': 13381175338.565105, 'volume_change_24h': -36.3802, 'percent_change_1h': 0.31485431, 'percent_change_24h': 1.18646336, 'percent_change_7d': 15.47019658, 'percent_change_30d': 49.2257865, 'percent_change_60d': 45.01289506, 'percent_change_90d': 59.16353542, 'market_cap': 412482551586.0947, 'market_cap_dominance': 17.6803, 'fully_diluted_market_cap': 412482551586.09, 'tvl': None, 'last_updated': '2024-03-02T17:09:00.000Z'}}}, {'id': 825, 'name': 'Tether USDt', 'symbol': 'USDT', 'slug': 'tether', 'num_market_pairs': 76680, 'date_added': '2015-02-25T00:00:00.000Z', 'tags': ['payments', 'stablecoin', 'asset-backed-stablecoin', 'avalanche-ecosystem', 'solana-ecosystem', 'arbitrum-ecosytem', 'moonriver-ecosystem', 'injective-ecosystem', 'bnb-chain', 'usd-stablecoin', 'optimism-ecosystem'], 'max_supply': None, 'circulating_supply': 99179337470.68521, 'total_supply': 101600078701.91211, 'platform': {'id': 1027, 'name': 'Ethereum', 'symbol': 'ETH', 'slug': 'ethereum', 'token_address': '0xdac17f958d2ee523a2206206994597c13d831ec7'}, 'infinite_supply': True, 'cmc_rank': 3, 'self_reported_circulating_supply': None, 'self_reported_market_cap': None, 'tvl_ratio': None, 'last_updated': '2024-03-02T17:08:00.000Z', 'quote': {'USD': {'price': 1.0010545914850015, 'volume_24h': 74480029592.87395, 'volume_change_24h': -12.6335, 'percent_change_1h': 0.02608203, 'percent_change_24h': 0.086137, 'percent_change_7d': 0.12337549, 'percent_change_30d': 0.14681615, 'percent_change_60d': 0.0444061, 'percent_change_90d': 0.06610229, 'market_cap': 99283931155.4699, 'market_cap_dominance': 4.2556, 'fully_diluted_market_cap': 101707225279.79, 'tvl': None, 'last_updated': '2024-03-02T17:08:00.000Z'}}}, {'id': 1839, 'name': 'BNB', 'symbol': 'BNB', 'slug': 'bnb', 'num_market_pairs': 2081, 'date_added': '2017-07-25T00:00:00.000Z', 'tags': ['marketplace', 'centralized-exchange', 'payments', 'smart-contracts', 'alameda-research-portfolio', 'multicoin-capital-portfolio', 'bnb-chain', 'layer-1', 'sec-security-token', 'alleged-sec-securities', 'celsius-bankruptcy-estate'], 'max_supply': None, 'circulating_supply': 149541973.92887828, 'total_supply': 149541973.92887828, 'infinite_supply': False, 'platform': None, 'cmc_rank': 4, 'self_reported_circulating_supply': None, 'self_reported_market_cap': None, 'tvl_ratio': None, 'last_updated': '2024-03-02T17:08:00.000Z', 'quote': {'USD': {'price': 408.68391770034344, 'volume_24h': 1553490080.345728, 'volume_change_24h': -7.2636, 'percent_change_1h': -0.05371695, 'percent_change_24h': 1.11011814, 'percent_change_7d': 7.34793933, 'percent_change_30d': 36.01824083, 'percent_change_60d': 31.39101032, 'percent_change_90d': 80.02118151, 'market_cap': 61115399765.89659, 'market_cap_dominance': 2.6196, 'fully_diluted_market_cap': 61115399765.9, 'tvl': None, 'last_updated': '2024-03-02T17:08:00.000Z'}}}, {'id': 5426, 'name': 'Solana', 'symbol': 'SOL', 'slug': 'solana', 'num_market_pairs': 628, 'date_added': '2020-04-10T00:00:00.000Z', 'tags': ['pos', 'platform', 'solana-ecosystem', 'cms-holdings-portfolio', 'kenetic-capital-portfolio', 'alameda-research-portfolio', 'multicoin-capital-portfolio', 'okex-blockdream-ventures-portfolio', 'layer-1', 'ftx-bankruptcy-estate', 'sec-security-token', 'alleged-sec-securities'], 'max_supply': None, 'circulating_supply': 442824284.4873725, 'total_supply': 570876604.6772165, 'infinite_supply': True, 'platform': None, 'cmc_rank': 5, 'self_reported_circulating_supply': None, 'self_reported_market_cap': None, 'tvl_ratio': None, 'last_updated': '2024-03-02T17:09:00.000Z', 'quote': {'USD': {'price': 128.75055852290828, 'volume_24h': 3259082644.776246, 'volume_change_24h': -37.1115, 'percent_change_1h': 0.0481007, 'percent_change_24h': -0.85760477, 'percent_change_7d': 25.27217251, 'percent_change_30d': 33.32366748, 'percent_change_60d': 16.6920951, 'percent_change_90d': 105.29958385, 'market_cap': 57013873955.25644, 'market_cap_dominance': 2.4438, 'fully_diluted_market_cap': 73500681699.85, 'tvl': None, 'last_updated': '2024-03-02T17:09:00.000Z'}}}, {'id': 52, 'name': 'XRP', 'symbol': 'XRP', 'slug': 'xrp', 'num_market_pairs': 1237, 'date_added': '2013-08-04T00:00:00.000Z', 'tags': ['medium-of-exchange', 'enterprise-solutions', 'arrington-xrp-capital-portfolio', 'galaxy-digital-portfolio', 'a16z-portfolio', 'pantera-capital-portfolio', 'ftx-bankruptcy-estate'], 'max_supply': 100000000000, 'circulating_supply': 54664031281, 'total_supply': 99987852435, 'infinite_supply': False, 'platform': None, 'cmc_rank': 6, 'self_reported_circulating_supply': None, 'self_reported_market_cap': None, 'tvl_ratio': None, 'last_updated': '2024-03-02T17:09:00.000Z', 'quote': {'USD': {'price': 0.6303313590542399, 'volume_24h': 2962218364.013608, 'volume_change_24h': 35.1, 'percent_change_1h': -0.35804878, 'percent_change_24h': 6.30590025, 'percent_change_7d': 15.5461651, 'percent_change_30d': 25.60791148, 'percent_change_60d': 0.4942338, 'percent_change_90d': 1.70174847, 'market_cap': 34456453128.73621, 'market_cap_dominance': 1.4769, 'fully_diluted_market_cap': 63033135905.42, 'tvl': None, 'last_updated': '2024-03-02T17:09:00.000Z'}}}, {'id': 3408, 'name': 'USDC', 'symbol': 'USDC', 'slug': 'usd-coin', 'num_market_pairs': 16975, 'date_added': '2018-10-08T00:00:00.000Z', 'tags': ['medium-of-exchange', 'stablecoin', 'asset-backed-stablecoin', 'coinbase-ventures-portfolio', 'hedera-hashgraph-ecosystem', 'fantom-ecosystem', 'arbitrum-ecosytem', 'moonriver-ecosystem', 'bnb-chain', 'usd-stablecoin', 'optimism-ecosystem'], 'max_supply': None, 'circulating_supply': 29022872285.291573, 'total_supply': 29022872285.291573, 'platform': {'id': 1027, 'name': 'Ethereum', 'symbol': 'ETH', 'slug': 'ethereum', 'token_address': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}, 'infinite_supply': False, 'cmc_rank': 7, 'self_reported_circulating_supply': None, 'self_reported_market_cap': None, 'tvl_ratio': None, 'last_updated': '2024-03-02T17:09:00.000Z', 'quote': {'USD': {'price': 1.0000674472452105, 'volume_24h': 6751430682.435516, 'volume_change_24h': -20.652, 'percent_change_1h': 0.00874947, 'percent_change_24h': 0.01745057, 'percent_change_7d': 0.01119982, 'percent_change_30d': -0.02519849, 'percent_change_60d': 0.01597025, 'percent_change_90d': 0.0092744, 'market_cap': 29024829798.07531, 'market_cap_dominance': 1.2437, 'fully_diluted_market_cap': 29024829798.08, 'tvl': None, 'last_updated': '2024-03-02T17:09:00.000Z'}}}, {'id': 2010, 'name': 'Cardano', 'symbol': 'ADA', 'slug': 'cardano', 'num_market_pairs': 1085, 'date_added': '2017-10-01T00:00:00.000Z', 'tags': ['dpos', 'pos', 'platform', 'research', 'smart-contracts', 'staking', 'cardano-ecosystem', 'cardano', 'layer-1', 'sec-security-token', 'alleged-sec-securities'], 'max_supply': 45000000000, 'circulating_supply': 35479772338.09, 'total_supply': 36671429496.447, 'infinite_supply': False, 'platform': None, 'cmc_rank': 8, 'self_reported_circulating_supply': None, 'self_reported_market_cap': None, 'tvl_ratio': None, 'last_updated': '2024-03-02T17:08:00.000Z', 'quote': {'USD': {'price': 0.735202787516248, 'volume_24h': 1333098185.2124493, 'volume_change_24h': 34.4857, 'percent_change_1h': 0.22198636, 'percent_change_24h': 7.90853744, 'percent_change_7d': 24.68807723, 'percent_change_30d': 48.82185188, 'percent_change_60d': 18.99561453, 'percent_change_90d': 88.16188788, 'market_cap': 26084827523.405632, 'market_cap_dominance': 1.1183, 'fully_diluted_market_cap': 33084125438.23, 'tvl': None, 'last_updated': '2024-03-02T17:08:00.000Z'}}}, {'id': 74, 'name': 'Dogecoin', 'symbol': 'DOGE', 'slug': 'dogecoin', 'num_market_pairs': 899, 'date_added': '2013-12-15T00:00:00.000Z', 'tags': ['mineable', 'pow', 'scrypt', 'medium-of-exchange', 'memes', 'payments', 'doggone-doggerel', 'bnb-chain', 'ftx-bankruptcy-estate'], 'max_supply': None, 'circulating_supply': 143302336383.70517, 'total_supply': 143302336383.70517, 'infinite_supply': True, 'platform': None, 'cmc_rank': 9, 'self_reported_circulating_supply': None, 'self_reported_market_cap': None, 'tvl_ratio': None, 'last_updated': '2024-03-02T17:09:00.000Z', 'quote': {'USD': {'price': 0.13905814562399865, 'volume_24h': 4765192490.973514, 'volume_change_24h': 63.134, 'percent_change_1h': -0.05737092, 'percent_change_24h': 6.87906239, 'percent_change_7d': 61.47541228, 'percent_change_30d': 75.00379106, 'percent_change_60d': 51.2576994, 'percent_change_90d': 65.2493734, 'market_cap': 19927357161.104515, 'market_cap_dominance': 0.8541, 'fully_diluted_market_cap': 19927357161.1, 'tvl': None, 'last_updated': '2024-03-02T17:09:00.000Z'}}}, {'id': 5805, 'name': 'Avalanche', 'symbol': 'AVAX', 'slug': 'avalanche', 'num_market_pairs': 674, 'date_added': '2020-07-13T00:00:00.000Z', 'tags': ['defi', 'smart-contracts', 'three-arrows-capital-portfolio', 'polychain-capital-portfolio', 'avalanche-ecosystem', 'cms-holdings-portfolio', 'dragonfly-capital-portfolio', 'moonriver-ecosystem', 'injective-ecosystem', 'real-world-assets', 'layer-1'], 'max_supply': 720000000, 'circulating_supply': 377244063.4289033, 'total_supply': 435933703.4289033, 'infinite_supply': False, 'platform': None, 'cmc_rank': 10, 'self_reported_circulating_supply': None, 'self_reported_market_cap': None, 'tvl_ratio': None, 'last_updated': '2024-03-02T17:08:00.000Z', 'quote': {'USD': {'price': 42.88520749527677, 'volume_24h': 685831077.6712615, 'volume_change_24h': -1.1462, 'percent_change_1h': 0.605745, 'percent_change_24h': 3.2807738, 'percent_change_7d': 17.19624651, 'percent_change_30d': 28.2730986, 'percent_change_60d': 3.67870065, 'percent_change_90d': 96.92926716, 'market_cap': 16178189936.509867, 'market_cap_dominance': 0.6934, 'fully_diluted_market_cap': 30877349396.6, 'tvl': None, 'last_updated': '2024-03-02T17:08:00.000Z'}}}, {'id': 1975, 'name': 'Chainlink', 'symbol': 'LINK', 'slug': 'chainlink', 'num_market_pairs': 1662, 'date_added': '2017-09-20T00:00:00.000Z', 'tags': ['platform', 'defi', 'oracles', 'smart-contracts', 'substrate', 'polkadot', 'polkadot-ecosystem', 'avalanche-ecosystem', 'solana-ecosystem', 'framework-ventures-portfolio', 'polygon-ecosystem', 'fantom-ecosystem', 'cardano-ecosystem', 'web3', 'near-protocol-ecosystem', 'arbitrum-ecosytem', 'cardano', 'injective-ecosystem', 'optimism-ecosystem', 'real-world-assets', 'celsius-bankruptcy-estate'], 'max_supply': 1000000000, 'circulating_supply': 587099970.4527867, 'total_supply': 1000000000, 'platform': {'id': 1027, 'name': 'Ethereum', 'symbol': 'ETH', 'slug': 'ethereum', 'token_address': '0x514910771af9ca656af840dff83e8264ecf986ca'}, 'infinite_supply': False, 'cmc_rank': 11, 'self_reported_circulating_supply': None, 'self_reported_market_cap': None, 'tvl_ratio': None, 'last_updated': '2024-03-02T17:08:00.000Z', 'quote': {'USD': {'price': 21.672753934866382, 'volume_24h': 888159716.9675676, 'volume_change_24h': 59.3962, 'percent_change_1h': 2.02555968, 'percent_change_24h': 9.73685908, 'percent_change_7d': 18.13166926, 'percent_change_30d': 29.00736476, 'percent_change_60d': 40.60520651, 'percent_change_90d': 36.59803318, 'market_cap': 12724073194.79057, 'market_cap_dominance': 0.5455, 'fully_diluted_market_cap': 21672753934.87, 'tvl': None, 'last_updated': '2024-03-02T17:08:00.000Z'}}}, {'id': 1958, 'name': 'TRON', 'symbol': 'TRX', 'slug': 'tron', 'num_market_pairs': 937, 'date_added': '2017-09-13T00:00:00.000Z', 'tags': ['media', 'payments', 'tron-ecosystem', 'layer-1', 'dwf-labs-portfolio', 'sec-security-token', 'alleged-sec-securities'], 'max_supply': None, 'circulating_supply': 87963365369.53621, 'total_supply': 87963449103.83116, 'infinite_supply': True, 'platform': None, 'cmc_rank': 12, 'self_reported_circulating_supply': 71659659264, 'self_reported_market_cap': 10093597890.882885, 'tvl_ratio': None, 'last_updated': '2024-03-02T17:08:00.000Z', 'quote': {'USD': {'price': 0.14085467325063955, 'volume_24h': 323987495.0817358, 'volume_change_24h': -12.2835, 'percent_change_1h': -0.02140195, 'percent_change_24h': 0.22348538, 'percent_change_7d': 2.58800162, 'percent_change_30d': 22.24184021, 'percent_change_60d': 28.56183787, 'percent_change_90d': 36.80236481, 'market_cap': 12390051087.152645, 'market_cap_dominance': 0.5311, 'fully_diluted_market_cap': 12390062881.52, 'tvl': None, 'last_updated': '2024-03-02T17:08:00.000Z'}}}, {'id': 6636, 'name': 'Polkadot', 'symbol': 'DOT', 'slug': 'polkadot-new', 'num_market_pairs': 697, 'date_added': '2020-08-19T00:00:00.000Z', 'tags': ['substrate', 'polkadot', 'binance-chain', 'polkadot-ecosystem', 'three-arrows-capital-portfolio', 'polychain-capital-portfolio', 'arrington-xrp-capital-portfolio', 'blockchain-capital-portfolio', 'boostvc-portfolio', 'cms-holdings-portfolio', 'coinfund-portfolio', 'fabric-ventures-portfolio', 'fenbushi-capital-portfolio', 'hashkey-capital-portfolio', 'kenetic-capital-portfolio', '1confirmation-portfolio', 'placeholder-ventures-portfolio', 'pantera-capital-portfolio', 'exnetwork-capital-portfolio', 'web3', 'spartan-group', 'injective-ecosystem', 'bnb-chain', 'layer-1'], 'max_supply': None, 'circulating_supply': 1311998920.6901844, 'total_supply': 1417330746.8030589, 'infinite_supply': True, 'platform': None, 'cmc_rank': 13, 'self_reported_circulating_supply': None, 'self_reported_market_cap': None, 'tvl_ratio': None, 'last_updated': '2024-03-02T17:08:00.000Z', 'quote': {'USD': {'price': 9.15380395554155, 'volume_24h': 510379635.17874616, 'volume_change_24h': 35.5462, 'percent_change_1h': 0.76033948, 'percent_change_24h': 9.79677542, 'percent_change_7d': 17.42058505, 'percent_change_30d': 35.3061384, 'percent_change_60d': 7.74027873, 'percent_change_90d': 66.89578171, 'market_cap': 12009780909.880054, 'market_cap_dominance': 0.5148, 'fully_diluted_market_cap': 12973967796.4, 'tvl': None, 'last_updated': '2024-03-02T17:08:00.000Z'}}}, {'id': 5994, 'name': 'Shiba Inu', 'symbol': 'SHIB', 'slug': 'shiba-inu', 'num_market_pairs': 749, 'date_added': '2020-08-01T00:00:00.000Z', 'tags': ['memes', 'ethereum-ecosystem', 'doggone-doggerel'], 'max_supply': None, 'circulating_supply': 589289521148465.9, 'total_supply': 589534114404941.2, 'platform': {'id': 1027, 'name': 'Ethereum', 'symbol': 'ETH', 'slug': 'ethereum', 'token_address': '0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'}, 'infinite_supply': False, 'cmc_rank': 14, 'self_reported_circulating_supply': None, 'self_reported_market_cap': None, 'tvl_ratio': None, 'last_updated': '2024-03-02T17:08:00.000Z', 'quote': {'USD': {'price': 2.0266173608074076e-05, 'volume_24h': 6207658212.911462, 'volume_change_24h': 348.8703, 'percent_change_1h': -0.83720275, 'percent_change_24h': 39.8717461, 'percent_change_7d': 111.26371393, 'percent_change_30d': 125.69364051, 'percent_change_60d': 90.23825102, 'percent_change_90d': 139.16117413, 'market_cap': 11942643741.013649, 'market_cap_dominance': 0.5118, 'fully_diluted_market_cap': 11947600710.41, 'tvl': None, 'last_updated': '2024-03-02T17:08:00.000Z'}}}, {'id': 3890, 'name': 'Polygon', 'symbol': 'MATIC', 'slug': 'polygon', 'num_market_pairs': 1295, 'date_added': '2019-04-28T00:00:00.000Z', 'tags': ['pos', 'platform', 'enterprise-solutions', 'zero-knowledge-proofs', 'scaling', 'state-channel', 'coinbase-ventures-portfolio', 'layer-2', 'binance-launchpad', 'binance-labs-portfolio', 'polygon-ecosystem', 'moonriver-ecosystem', 'injective-ecosystem', 'ftx-bankruptcy-estate', 'sec-security-token', 'alleged-sec-securities', 'modular-blockchain', 'standard-crypto-portfolio'], 'max_supply': 10000000000, 'circulating_supply': 9899154754.452854, 'total_supply': 10000000000, 'infinite_supply': False, 'platform': None, 'cmc_rank': 15, 'self_reported_circulating_supply': None, 'self_reported_market_cap': None, 'tvl_ratio': None, 'last_updated': '2024-03-02T17:08:00.000Z', 'quote': {'USD': {'price': 1.0767496923252136, 'volume_24h': 741919557.5918107, 'volume_change_24h': 26.8714, 'percent_change_1h': 0.00503, 'percent_change_24h': 6.56147129, 'percent_change_7d': 8.28151448, 'percent_change_30d': 34.97791486, 'percent_change_60d': 9.09719071, 'percent_change_90d': 33.65143585, 'market_cap': 10658911836.136786, 'market_cap_dominance': 0.4569, 'fully_diluted_market_cap': 10767496923.25, 'tvl': None, 'last_updated': '2024-03-02T17:08:00.000Z'}}}]}\n"
     ]
    }
   ],
   "source": [
    "from requests import Request, Session\n",
    "from requests.exceptions import ConnectionError, Timeout, TooManyRedirects\n",
    "import json\n",
    "\n",
    "# Informações retiradas de forma gratuita no site <https://coinmarketcap.com/>\n",
    "url = 'https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest' \n",
    "parameters = {\n",
    "  'start':'1',\n",
    "  'limit':'15',\n",
    "  'convert':'USD'\n",
    "}\n",
    "headers = {\n",
    "  'Accepts': 'application/json',\n",
    "  'X-CMC_PRO_API_KEY': '0ad53085-1cb2-4eb8-ad9e-3ffbd7e56509',\n",
    "}\n",
    "session = Session()\n",
    "session.headers.update(headers)\n",
    "\n",
    "# A API utilizada também foi disponibilizada de forma gratuita\n",
    "\n",
    "try:\n",
    "  response = session.get(url, params=parameters)\n",
    "  data = json.loads(response.text)\n",
    "  print(data)\n",
    "except (ConnectionError, Timeout, TooManyRedirects) as e:\n",
    "  print(e)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "daef8e5d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "ba7257dd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>symbol</th>\n",
       "      <th>slug</th>\n",
       "      <th>num_market_pairs</th>\n",
       "      <th>date_added</th>\n",
       "      <th>tags</th>\n",
       "      <th>max_supply</th>\n",
       "      <th>circulating_supply</th>\n",
       "      <th>total_supply</th>\n",
       "      <th>infinite_supply</th>\n",
       "      <th>platform</th>\n",
       "      <th>cmc_rank</th>\n",
       "      <th>self_reported_circulating_supply</th>\n",
       "      <th>self_reported_market_cap</th>\n",
       "      <th>tvl_ratio</th>\n",
       "      <th>last_updated</th>\n",
       "      <th>quote.USD.price</th>\n",
       "      <th>quote.USD.volume_24h</th>\n",
       "      <th>quote.USD.volume_change_24h</th>\n",
       "      <th>quote.USD.percent_change_1h</th>\n",
       "      <th>quote.USD.percent_change_24h</th>\n",
       "      <th>quote.USD.percent_change_7d</th>\n",
       "      <th>quote.USD.percent_change_30d</th>\n",
       "      <th>quote.USD.percent_change_60d</th>\n",
       "      <th>quote.USD.percent_change_90d</th>\n",
       "      <th>quote.USD.market_cap</th>\n",
       "      <th>quote.USD.market_cap_dominance</th>\n",
       "      <th>quote.USD.fully_diluted_market_cap</th>\n",
       "      <th>quote.USD.tvl</th>\n",
       "      <th>quote.USD.last_updated</th>\n",
       "      <th>platform.id</th>\n",
       "      <th>platform.name</th>\n",
       "      <th>platform.symbol</th>\n",
       "      <th>platform.slug</th>\n",
       "      <th>platform.token_address</th>\n",
       "      <th>timestamp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Bitcoin</td>\n",
       "      <td>BTC</td>\n",
       "      <td>bitcoin</td>\n",
       "      <td>10844</td>\n",
       "      <td>2010-07-13T00:00:00.000Z</td>\n",
       "      <td>[mineable, pow, sha-256, store-of-value, state...</td>\n",
       "      <td>2.100000e+07</td>\n",
       "      <td>1.964277e+07</td>\n",
       "      <td>1.964277e+07</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:09:00.000Z</td>\n",
       "      <td>61946.518524</td>\n",
       "      <td>3.055246e+10</td>\n",
       "      <td>-36.5514</td>\n",
       "      <td>0.096648</td>\n",
       "      <td>0.683086</td>\n",
       "      <td>20.847401</td>\n",
       "      <td>44.481421</td>\n",
       "      <td>36.570755</td>\n",
       "      <td>56.419967</td>\n",
       "      <td>1.216801e+12</td>\n",
       "      <td>52.1486</td>\n",
       "      <td>1.300877e+12</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:09:00.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2024-03-02 14:10:12.589455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1027</td>\n",
       "      <td>Ethereum</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ethereum</td>\n",
       "      <td>8486</td>\n",
       "      <td>2015-08-07T00:00:00.000Z</td>\n",
       "      <td>[pos, smart-contracts, ethereum-ecosystem, coi...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.201389e+08</td>\n",
       "      <td>1.201389e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:09:00.000Z</td>\n",
       "      <td>3433.381193</td>\n",
       "      <td>1.338118e+10</td>\n",
       "      <td>-36.3802</td>\n",
       "      <td>0.314854</td>\n",
       "      <td>1.186463</td>\n",
       "      <td>15.470197</td>\n",
       "      <td>49.225786</td>\n",
       "      <td>45.012895</td>\n",
       "      <td>59.163535</td>\n",
       "      <td>4.124826e+11</td>\n",
       "      <td>17.6803</td>\n",
       "      <td>4.124826e+11</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:09:00.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2024-03-02 14:10:12.589455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>825</td>\n",
       "      <td>Tether USDt</td>\n",
       "      <td>USDT</td>\n",
       "      <td>tether</td>\n",
       "      <td>76680</td>\n",
       "      <td>2015-02-25T00:00:00.000Z</td>\n",
       "      <td>[payments, stablecoin, asset-backed-stablecoin...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.917934e+10</td>\n",
       "      <td>1.016001e+11</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>1.001055</td>\n",
       "      <td>7.448003e+10</td>\n",
       "      <td>-12.6335</td>\n",
       "      <td>0.026082</td>\n",
       "      <td>0.086137</td>\n",
       "      <td>0.123375</td>\n",
       "      <td>0.146816</td>\n",
       "      <td>0.044406</td>\n",
       "      <td>0.066102</td>\n",
       "      <td>9.928393e+10</td>\n",
       "      <td>4.2556</td>\n",
       "      <td>1.017072e+11</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>1027.0</td>\n",
       "      <td>Ethereum</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ethereum</td>\n",
       "      <td>0xdac17f958d2ee523a2206206994597c13d831ec7</td>\n",
       "      <td>2024-03-02 14:10:12.589455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1839</td>\n",
       "      <td>BNB</td>\n",
       "      <td>BNB</td>\n",
       "      <td>bnb</td>\n",
       "      <td>2081</td>\n",
       "      <td>2017-07-25T00:00:00.000Z</td>\n",
       "      <td>[marketplace, centralized-exchange, payments, ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.495420e+08</td>\n",
       "      <td>1.495420e+08</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>408.683918</td>\n",
       "      <td>1.553490e+09</td>\n",
       "      <td>-7.2636</td>\n",
       "      <td>-0.053717</td>\n",
       "      <td>1.110118</td>\n",
       "      <td>7.347939</td>\n",
       "      <td>36.018241</td>\n",
       "      <td>31.391010</td>\n",
       "      <td>80.021182</td>\n",
       "      <td>6.111540e+10</td>\n",
       "      <td>2.6196</td>\n",
       "      <td>6.111540e+10</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2024-03-02 14:10:12.589455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5426</td>\n",
       "      <td>Solana</td>\n",
       "      <td>SOL</td>\n",
       "      <td>solana</td>\n",
       "      <td>628</td>\n",
       "      <td>2020-04-10T00:00:00.000Z</td>\n",
       "      <td>[pos, platform, solana-ecosystem, cms-holdings...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.428243e+08</td>\n",
       "      <td>5.708766e+08</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:09:00.000Z</td>\n",
       "      <td>128.750559</td>\n",
       "      <td>3.259083e+09</td>\n",
       "      <td>-37.1115</td>\n",
       "      <td>0.048101</td>\n",
       "      <td>-0.857605</td>\n",
       "      <td>25.272173</td>\n",
       "      <td>33.323667</td>\n",
       "      <td>16.692095</td>\n",
       "      <td>105.299584</td>\n",
       "      <td>5.701387e+10</td>\n",
       "      <td>2.4438</td>\n",
       "      <td>7.350068e+10</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:09:00.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2024-03-02 14:10:12.589455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>52</td>\n",
       "      <td>XRP</td>\n",
       "      <td>XRP</td>\n",
       "      <td>xrp</td>\n",
       "      <td>1237</td>\n",
       "      <td>2013-08-04T00:00:00.000Z</td>\n",
       "      <td>[medium-of-exchange, enterprise-solutions, arr...</td>\n",
       "      <td>1.000000e+11</td>\n",
       "      <td>5.466403e+10</td>\n",
       "      <td>9.998785e+10</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:09:00.000Z</td>\n",
       "      <td>0.630331</td>\n",
       "      <td>2.962218e+09</td>\n",
       "      <td>35.1000</td>\n",
       "      <td>-0.358049</td>\n",
       "      <td>6.305900</td>\n",
       "      <td>15.546165</td>\n",
       "      <td>25.607911</td>\n",
       "      <td>0.494234</td>\n",
       "      <td>1.701748</td>\n",
       "      <td>3.445645e+10</td>\n",
       "      <td>1.4769</td>\n",
       "      <td>6.303314e+10</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:09:00.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2024-03-02 14:10:12.589455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3408</td>\n",
       "      <td>USDC</td>\n",
       "      <td>USDC</td>\n",
       "      <td>usd-coin</td>\n",
       "      <td>16975</td>\n",
       "      <td>2018-10-08T00:00:00.000Z</td>\n",
       "      <td>[medium-of-exchange, stablecoin, asset-backed-...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.902287e+10</td>\n",
       "      <td>2.902287e+10</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:09:00.000Z</td>\n",
       "      <td>1.000067</td>\n",
       "      <td>6.751431e+09</td>\n",
       "      <td>-20.6520</td>\n",
       "      <td>0.008749</td>\n",
       "      <td>0.017451</td>\n",
       "      <td>0.011200</td>\n",
       "      <td>-0.025198</td>\n",
       "      <td>0.015970</td>\n",
       "      <td>0.009274</td>\n",
       "      <td>2.902483e+10</td>\n",
       "      <td>1.2437</td>\n",
       "      <td>2.902483e+10</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:09:00.000Z</td>\n",
       "      <td>1027.0</td>\n",
       "      <td>Ethereum</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ethereum</td>\n",
       "      <td>0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48</td>\n",
       "      <td>2024-03-02 14:10:12.589455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2010</td>\n",
       "      <td>Cardano</td>\n",
       "      <td>ADA</td>\n",
       "      <td>cardano</td>\n",
       "      <td>1085</td>\n",
       "      <td>2017-10-01T00:00:00.000Z</td>\n",
       "      <td>[dpos, pos, platform, research, smart-contract...</td>\n",
       "      <td>4.500000e+10</td>\n",
       "      <td>3.547977e+10</td>\n",
       "      <td>3.667143e+10</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>0.735203</td>\n",
       "      <td>1.333098e+09</td>\n",
       "      <td>34.4857</td>\n",
       "      <td>0.221986</td>\n",
       "      <td>7.908537</td>\n",
       "      <td>24.688077</td>\n",
       "      <td>48.821852</td>\n",
       "      <td>18.995615</td>\n",
       "      <td>88.161888</td>\n",
       "      <td>2.608483e+10</td>\n",
       "      <td>1.1183</td>\n",
       "      <td>3.308413e+10</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2024-03-02 14:10:12.589455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>74</td>\n",
       "      <td>Dogecoin</td>\n",
       "      <td>DOGE</td>\n",
       "      <td>dogecoin</td>\n",
       "      <td>899</td>\n",
       "      <td>2013-12-15T00:00:00.000Z</td>\n",
       "      <td>[mineable, pow, scrypt, medium-of-exchange, me...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.433023e+11</td>\n",
       "      <td>1.433023e+11</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:09:00.000Z</td>\n",
       "      <td>0.139058</td>\n",
       "      <td>4.765192e+09</td>\n",
       "      <td>63.1340</td>\n",
       "      <td>-0.057371</td>\n",
       "      <td>6.879062</td>\n",
       "      <td>61.475412</td>\n",
       "      <td>75.003791</td>\n",
       "      <td>51.257699</td>\n",
       "      <td>65.249373</td>\n",
       "      <td>1.992736e+10</td>\n",
       "      <td>0.8541</td>\n",
       "      <td>1.992736e+10</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:09:00.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2024-03-02 14:10:12.589455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5805</td>\n",
       "      <td>Avalanche</td>\n",
       "      <td>AVAX</td>\n",
       "      <td>avalanche</td>\n",
       "      <td>674</td>\n",
       "      <td>2020-07-13T00:00:00.000Z</td>\n",
       "      <td>[defi, smart-contracts, three-arrows-capital-p...</td>\n",
       "      <td>7.200000e+08</td>\n",
       "      <td>3.772441e+08</td>\n",
       "      <td>4.359337e+08</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>42.885207</td>\n",
       "      <td>6.858311e+08</td>\n",
       "      <td>-1.1462</td>\n",
       "      <td>0.605745</td>\n",
       "      <td>3.280774</td>\n",
       "      <td>17.196247</td>\n",
       "      <td>28.273099</td>\n",
       "      <td>3.678701</td>\n",
       "      <td>96.929267</td>\n",
       "      <td>1.617819e+10</td>\n",
       "      <td>0.6934</td>\n",
       "      <td>3.087735e+10</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2024-03-02 14:10:12.589455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1975</td>\n",
       "      <td>Chainlink</td>\n",
       "      <td>LINK</td>\n",
       "      <td>chainlink</td>\n",
       "      <td>1662</td>\n",
       "      <td>2017-09-20T00:00:00.000Z</td>\n",
       "      <td>[platform, defi, oracles, smart-contracts, sub...</td>\n",
       "      <td>1.000000e+09</td>\n",
       "      <td>5.871000e+08</td>\n",
       "      <td>1.000000e+09</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>21.672754</td>\n",
       "      <td>8.881597e+08</td>\n",
       "      <td>59.3962</td>\n",
       "      <td>2.025560</td>\n",
       "      <td>9.736859</td>\n",
       "      <td>18.131669</td>\n",
       "      <td>29.007365</td>\n",
       "      <td>40.605207</td>\n",
       "      <td>36.598033</td>\n",
       "      <td>1.272407e+10</td>\n",
       "      <td>0.5455</td>\n",
       "      <td>2.167275e+10</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>1027.0</td>\n",
       "      <td>Ethereum</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ethereum</td>\n",
       "      <td>0x514910771af9ca656af840dff83e8264ecf986ca</td>\n",
       "      <td>2024-03-02 14:10:12.589455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1958</td>\n",
       "      <td>TRON</td>\n",
       "      <td>TRX</td>\n",
       "      <td>tron</td>\n",
       "      <td>937</td>\n",
       "      <td>2017-09-13T00:00:00.000Z</td>\n",
       "      <td>[media, payments, tron-ecosystem, layer-1, dwf...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.796337e+10</td>\n",
       "      <td>8.796345e+10</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>7.165966e+10</td>\n",
       "      <td>1.009360e+10</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>0.140855</td>\n",
       "      <td>3.239875e+08</td>\n",
       "      <td>-12.2835</td>\n",
       "      <td>-0.021402</td>\n",
       "      <td>0.223485</td>\n",
       "      <td>2.588002</td>\n",
       "      <td>22.241840</td>\n",
       "      <td>28.561838</td>\n",
       "      <td>36.802365</td>\n",
       "      <td>1.239005e+10</td>\n",
       "      <td>0.5311</td>\n",
       "      <td>1.239006e+10</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2024-03-02 14:10:12.589455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6636</td>\n",
       "      <td>Polkadot</td>\n",
       "      <td>DOT</td>\n",
       "      <td>polkadot-new</td>\n",
       "      <td>697</td>\n",
       "      <td>2020-08-19T00:00:00.000Z</td>\n",
       "      <td>[substrate, polkadot, binance-chain, polkadot-...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.311999e+09</td>\n",
       "      <td>1.417331e+09</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>9.153804</td>\n",
       "      <td>5.103796e+08</td>\n",
       "      <td>35.5462</td>\n",
       "      <td>0.760339</td>\n",
       "      <td>9.796775</td>\n",
       "      <td>17.420585</td>\n",
       "      <td>35.306138</td>\n",
       "      <td>7.740279</td>\n",
       "      <td>66.895782</td>\n",
       "      <td>1.200978e+10</td>\n",
       "      <td>0.5148</td>\n",
       "      <td>1.297397e+10</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2024-03-02 14:10:12.589455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>5994</td>\n",
       "      <td>Shiba Inu</td>\n",
       "      <td>SHIB</td>\n",
       "      <td>shiba-inu</td>\n",
       "      <td>749</td>\n",
       "      <td>2020-08-01T00:00:00.000Z</td>\n",
       "      <td>[memes, ethereum-ecosystem, doggone-doggerel]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.892895e+14</td>\n",
       "      <td>5.895341e+14</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>0.000020</td>\n",
       "      <td>6.207658e+09</td>\n",
       "      <td>348.8703</td>\n",
       "      <td>-0.837203</td>\n",
       "      <td>39.871746</td>\n",
       "      <td>111.263714</td>\n",
       "      <td>125.693641</td>\n",
       "      <td>90.238251</td>\n",
       "      <td>139.161174</td>\n",
       "      <td>1.194264e+10</td>\n",
       "      <td>0.5118</td>\n",
       "      <td>1.194760e+10</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>1027.0</td>\n",
       "      <td>Ethereum</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ethereum</td>\n",
       "      <td>0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce</td>\n",
       "      <td>2024-03-02 14:10:12.589455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>3890</td>\n",
       "      <td>Polygon</td>\n",
       "      <td>MATIC</td>\n",
       "      <td>polygon</td>\n",
       "      <td>1295</td>\n",
       "      <td>2019-04-28T00:00:00.000Z</td>\n",
       "      <td>[pos, platform, enterprise-solutions, zero-kno...</td>\n",
       "      <td>1.000000e+10</td>\n",
       "      <td>9.899155e+09</td>\n",
       "      <td>1.000000e+10</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>1.076750</td>\n",
       "      <td>7.419196e+08</td>\n",
       "      <td>26.8714</td>\n",
       "      <td>0.005030</td>\n",
       "      <td>6.561471</td>\n",
       "      <td>8.281514</td>\n",
       "      <td>34.977915</td>\n",
       "      <td>9.097191</td>\n",
       "      <td>33.651436</td>\n",
       "      <td>1.065891e+10</td>\n",
       "      <td>0.4569</td>\n",
       "      <td>1.076750e+10</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-03-02T17:08:00.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2024-03-02 14:10:12.589455</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      id         name symbol          slug  num_market_pairs  \\\n",
       "0      1      Bitcoin    BTC       bitcoin             10844   \n",
       "1   1027     Ethereum    ETH      ethereum              8486   \n",
       "2    825  Tether USDt   USDT        tether             76680   \n",
       "3   1839          BNB    BNB           bnb              2081   \n",
       "4   5426       Solana    SOL        solana               628   \n",
       "5     52          XRP    XRP           xrp              1237   \n",
       "6   3408         USDC   USDC      usd-coin             16975   \n",
       "7   2010      Cardano    ADA       cardano              1085   \n",
       "8     74     Dogecoin   DOGE      dogecoin               899   \n",
       "9   5805    Avalanche   AVAX     avalanche               674   \n",
       "10  1975    Chainlink   LINK     chainlink              1662   \n",
       "11  1958         TRON    TRX          tron               937   \n",
       "12  6636     Polkadot    DOT  polkadot-new               697   \n",
       "13  5994    Shiba Inu   SHIB     shiba-inu               749   \n",
       "14  3890      Polygon  MATIC       polygon              1295   \n",
       "\n",
       "                  date_added  \\\n",
       "0   2010-07-13T00:00:00.000Z   \n",
       "1   2015-08-07T00:00:00.000Z   \n",
       "2   2015-02-25T00:00:00.000Z   \n",
       "3   2017-07-25T00:00:00.000Z   \n",
       "4   2020-04-10T00:00:00.000Z   \n",
       "5   2013-08-04T00:00:00.000Z   \n",
       "6   2018-10-08T00:00:00.000Z   \n",
       "7   2017-10-01T00:00:00.000Z   \n",
       "8   2013-12-15T00:00:00.000Z   \n",
       "9   2020-07-13T00:00:00.000Z   \n",
       "10  2017-09-20T00:00:00.000Z   \n",
       "11  2017-09-13T00:00:00.000Z   \n",
       "12  2020-08-19T00:00:00.000Z   \n",
       "13  2020-08-01T00:00:00.000Z   \n",
       "14  2019-04-28T00:00:00.000Z   \n",
       "\n",
       "                                                 tags    max_supply  \\\n",
       "0   [mineable, pow, sha-256, store-of-value, state...  2.100000e+07   \n",
       "1   [pos, smart-contracts, ethereum-ecosystem, coi...           NaN   \n",
       "2   [payments, stablecoin, asset-backed-stablecoin...           NaN   \n",
       "3   [marketplace, centralized-exchange, payments, ...           NaN   \n",
       "4   [pos, platform, solana-ecosystem, cms-holdings...           NaN   \n",
       "5   [medium-of-exchange, enterprise-solutions, arr...  1.000000e+11   \n",
       "6   [medium-of-exchange, stablecoin, asset-backed-...           NaN   \n",
       "7   [dpos, pos, platform, research, smart-contract...  4.500000e+10   \n",
       "8   [mineable, pow, scrypt, medium-of-exchange, me...           NaN   \n",
       "9   [defi, smart-contracts, three-arrows-capital-p...  7.200000e+08   \n",
       "10  [platform, defi, oracles, smart-contracts, sub...  1.000000e+09   \n",
       "11  [media, payments, tron-ecosystem, layer-1, dwf...           NaN   \n",
       "12  [substrate, polkadot, binance-chain, polkadot-...           NaN   \n",
       "13      [memes, ethereum-ecosystem, doggone-doggerel]           NaN   \n",
       "14  [pos, platform, enterprise-solutions, zero-kno...  1.000000e+10   \n",
       "\n",
       "    circulating_supply  total_supply  infinite_supply  platform  cmc_rank  \\\n",
       "0         1.964277e+07  1.964277e+07            False       NaN         1   \n",
       "1         1.201389e+08  1.201389e+08             True       NaN         2   \n",
       "2         9.917934e+10  1.016001e+11             True       NaN         3   \n",
       "3         1.495420e+08  1.495420e+08            False       NaN         4   \n",
       "4         4.428243e+08  5.708766e+08             True       NaN         5   \n",
       "5         5.466403e+10  9.998785e+10            False       NaN         6   \n",
       "6         2.902287e+10  2.902287e+10            False       NaN         7   \n",
       "7         3.547977e+10  3.667143e+10            False       NaN         8   \n",
       "8         1.433023e+11  1.433023e+11             True       NaN         9   \n",
       "9         3.772441e+08  4.359337e+08            False       NaN        10   \n",
       "10        5.871000e+08  1.000000e+09            False       NaN        11   \n",
       "11        8.796337e+10  8.796345e+10             True       NaN        12   \n",
       "12        1.311999e+09  1.417331e+09             True       NaN        13   \n",
       "13        5.892895e+14  5.895341e+14            False       NaN        14   \n",
       "14        9.899155e+09  1.000000e+10            False       NaN        15   \n",
       "\n",
       "    self_reported_circulating_supply  self_reported_market_cap tvl_ratio  \\\n",
       "0                                NaN                       NaN      None   \n",
       "1                                NaN                       NaN      None   \n",
       "2                                NaN                       NaN      None   \n",
       "3                                NaN                       NaN      None   \n",
       "4                                NaN                       NaN      None   \n",
       "5                                NaN                       NaN      None   \n",
       "6                                NaN                       NaN      None   \n",
       "7                                NaN                       NaN      None   \n",
       "8                                NaN                       NaN      None   \n",
       "9                                NaN                       NaN      None   \n",
       "10                               NaN                       NaN      None   \n",
       "11                      7.165966e+10              1.009360e+10      None   \n",
       "12                               NaN                       NaN      None   \n",
       "13                               NaN                       NaN      None   \n",
       "14                               NaN                       NaN      None   \n",
       "\n",
       "                last_updated  quote.USD.price  quote.USD.volume_24h  \\\n",
       "0   2024-03-02T17:09:00.000Z     61946.518524          3.055246e+10   \n",
       "1   2024-03-02T17:09:00.000Z      3433.381193          1.338118e+10   \n",
       "2   2024-03-02T17:08:00.000Z         1.001055          7.448003e+10   \n",
       "3   2024-03-02T17:08:00.000Z       408.683918          1.553490e+09   \n",
       "4   2024-03-02T17:09:00.000Z       128.750559          3.259083e+09   \n",
       "5   2024-03-02T17:09:00.000Z         0.630331          2.962218e+09   \n",
       "6   2024-03-02T17:09:00.000Z         1.000067          6.751431e+09   \n",
       "7   2024-03-02T17:08:00.000Z         0.735203          1.333098e+09   \n",
       "8   2024-03-02T17:09:00.000Z         0.139058          4.765192e+09   \n",
       "9   2024-03-02T17:08:00.000Z        42.885207          6.858311e+08   \n",
       "10  2024-03-02T17:08:00.000Z        21.672754          8.881597e+08   \n",
       "11  2024-03-02T17:08:00.000Z         0.140855          3.239875e+08   \n",
       "12  2024-03-02T17:08:00.000Z         9.153804          5.103796e+08   \n",
       "13  2024-03-02T17:08:00.000Z         0.000020          6.207658e+09   \n",
       "14  2024-03-02T17:08:00.000Z         1.076750          7.419196e+08   \n",
       "\n",
       "    quote.USD.volume_change_24h  quote.USD.percent_change_1h  \\\n",
       "0                      -36.5514                     0.096648   \n",
       "1                      -36.3802                     0.314854   \n",
       "2                      -12.6335                     0.026082   \n",
       "3                       -7.2636                    -0.053717   \n",
       "4                      -37.1115                     0.048101   \n",
       "5                       35.1000                    -0.358049   \n",
       "6                      -20.6520                     0.008749   \n",
       "7                       34.4857                     0.221986   \n",
       "8                       63.1340                    -0.057371   \n",
       "9                       -1.1462                     0.605745   \n",
       "10                      59.3962                     2.025560   \n",
       "11                     -12.2835                    -0.021402   \n",
       "12                      35.5462                     0.760339   \n",
       "13                     348.8703                    -0.837203   \n",
       "14                      26.8714                     0.005030   \n",
       "\n",
       "    quote.USD.percent_change_24h  quote.USD.percent_change_7d  \\\n",
       "0                       0.683086                    20.847401   \n",
       "1                       1.186463                    15.470197   \n",
       "2                       0.086137                     0.123375   \n",
       "3                       1.110118                     7.347939   \n",
       "4                      -0.857605                    25.272173   \n",
       "5                       6.305900                    15.546165   \n",
       "6                       0.017451                     0.011200   \n",
       "7                       7.908537                    24.688077   \n",
       "8                       6.879062                    61.475412   \n",
       "9                       3.280774                    17.196247   \n",
       "10                      9.736859                    18.131669   \n",
       "11                      0.223485                     2.588002   \n",
       "12                      9.796775                    17.420585   \n",
       "13                     39.871746                   111.263714   \n",
       "14                      6.561471                     8.281514   \n",
       "\n",
       "    quote.USD.percent_change_30d  quote.USD.percent_change_60d  \\\n",
       "0                      44.481421                     36.570755   \n",
       "1                      49.225786                     45.012895   \n",
       "2                       0.146816                      0.044406   \n",
       "3                      36.018241                     31.391010   \n",
       "4                      33.323667                     16.692095   \n",
       "5                      25.607911                      0.494234   \n",
       "6                      -0.025198                      0.015970   \n",
       "7                      48.821852                     18.995615   \n",
       "8                      75.003791                     51.257699   \n",
       "9                      28.273099                      3.678701   \n",
       "10                     29.007365                     40.605207   \n",
       "11                     22.241840                     28.561838   \n",
       "12                     35.306138                      7.740279   \n",
       "13                    125.693641                     90.238251   \n",
       "14                     34.977915                      9.097191   \n",
       "\n",
       "    quote.USD.percent_change_90d  quote.USD.market_cap  \\\n",
       "0                      56.419967          1.216801e+12   \n",
       "1                      59.163535          4.124826e+11   \n",
       "2                       0.066102          9.928393e+10   \n",
       "3                      80.021182          6.111540e+10   \n",
       "4                     105.299584          5.701387e+10   \n",
       "5                       1.701748          3.445645e+10   \n",
       "6                       0.009274          2.902483e+10   \n",
       "7                      88.161888          2.608483e+10   \n",
       "8                      65.249373          1.992736e+10   \n",
       "9                      96.929267          1.617819e+10   \n",
       "10                     36.598033          1.272407e+10   \n",
       "11                     36.802365          1.239005e+10   \n",
       "12                     66.895782          1.200978e+10   \n",
       "13                    139.161174          1.194264e+10   \n",
       "14                     33.651436          1.065891e+10   \n",
       "\n",
       "    quote.USD.market_cap_dominance  quote.USD.fully_diluted_market_cap  \\\n",
       "0                          52.1486                        1.300877e+12   \n",
       "1                          17.6803                        4.124826e+11   \n",
       "2                           4.2556                        1.017072e+11   \n",
       "3                           2.6196                        6.111540e+10   \n",
       "4                           2.4438                        7.350068e+10   \n",
       "5                           1.4769                        6.303314e+10   \n",
       "6                           1.2437                        2.902483e+10   \n",
       "7                           1.1183                        3.308413e+10   \n",
       "8                           0.8541                        1.992736e+10   \n",
       "9                           0.6934                        3.087735e+10   \n",
       "10                          0.5455                        2.167275e+10   \n",
       "11                          0.5311                        1.239006e+10   \n",
       "12                          0.5148                        1.297397e+10   \n",
       "13                          0.5118                        1.194760e+10   \n",
       "14                          0.4569                        1.076750e+10   \n",
       "\n",
       "   quote.USD.tvl    quote.USD.last_updated  platform.id platform.name  \\\n",
       "0           None  2024-03-02T17:09:00.000Z          NaN           NaN   \n",
       "1           None  2024-03-02T17:09:00.000Z          NaN           NaN   \n",
       "2           None  2024-03-02T17:08:00.000Z       1027.0      Ethereum   \n",
       "3           None  2024-03-02T17:08:00.000Z          NaN           NaN   \n",
       "4           None  2024-03-02T17:09:00.000Z          NaN           NaN   \n",
       "5           None  2024-03-02T17:09:00.000Z          NaN           NaN   \n",
       "6           None  2024-03-02T17:09:00.000Z       1027.0      Ethereum   \n",
       "7           None  2024-03-02T17:08:00.000Z          NaN           NaN   \n",
       "8           None  2024-03-02T17:09:00.000Z          NaN           NaN   \n",
       "9           None  2024-03-02T17:08:00.000Z          NaN           NaN   \n",
       "10          None  2024-03-02T17:08:00.000Z       1027.0      Ethereum   \n",
       "11          None  2024-03-02T17:08:00.000Z          NaN           NaN   \n",
       "12          None  2024-03-02T17:08:00.000Z          NaN           NaN   \n",
       "13          None  2024-03-02T17:08:00.000Z       1027.0      Ethereum   \n",
       "14          None  2024-03-02T17:08:00.000Z          NaN           NaN   \n",
       "\n",
       "   platform.symbol platform.slug                      platform.token_address  \\\n",
       "0              NaN           NaN                                         NaN   \n",
       "1              NaN           NaN                                         NaN   \n",
       "2              ETH      ethereum  0xdac17f958d2ee523a2206206994597c13d831ec7   \n",
       "3              NaN           NaN                                         NaN   \n",
       "4              NaN           NaN                                         NaN   \n",
       "5              NaN           NaN                                         NaN   \n",
       "6              ETH      ethereum  0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48   \n",
       "7              NaN           NaN                                         NaN   \n",
       "8              NaN           NaN                                         NaN   \n",
       "9              NaN           NaN                                         NaN   \n",
       "10             ETH      ethereum  0x514910771af9ca656af840dff83e8264ecf986ca   \n",
       "11             NaN           NaN                                         NaN   \n",
       "12             NaN           NaN                                         NaN   \n",
       "13             ETH      ethereum  0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce   \n",
       "14             NaN           NaN                                         NaN   \n",
       "\n",
       "                    timestamp  \n",
       "0  2024-03-02 14:10:12.589455  \n",
       "1  2024-03-02 14:10:12.589455  \n",
       "2  2024-03-02 14:10:12.589455  \n",
       "3  2024-03-02 14:10:12.589455  \n",
       "4  2024-03-02 14:10:12.589455  \n",
       "5  2024-03-02 14:10:12.589455  \n",
       "6  2024-03-02 14:10:12.589455  \n",
       "7  2024-03-02 14:10:12.589455  \n",
       "8  2024-03-02 14:10:12.589455  \n",
       "9  2024-03-02 14:10:12.589455  \n",
       "10 2024-03-02 14:10:12.589455  \n",
       "11 2024-03-02 14:10:12.589455  \n",
       "12 2024-03-02 14:10:12.589455  \n",
       "13 2024-03-02 14:10:12.589455  \n",
       "14 2024-03-02 14:10:12.589455  "
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Para organização e visualização dos dados \n",
    "\n",
    "import pandas as pd\n",
    "\n",
    "pd.set_option('display.max_columns', None)\n",
    "pd.set_option('display.max_rows', None)\n",
    "\n",
    "# Cria uma coluna nova para mostrar a hora e o dia das informações retiradas\n",
    "df = pd.json_normalize(data['data'])\n",
    "df['timestamp'] = pd.to_datetime('now')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "19e5f20e",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Cria uma função para continuar retirando informações do marketcoin em um loop:\n",
    "import pandas as pd\n",
    "\n",
    "def api_runner():\n",
    "    global df\n",
    "    url = 'https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest'\n",
    "    #Ambiente original: 'https://sandbox-api.coinmarketcap.com/v1/cryptocurrency/listings/latest'\n",
    "    parameters = {\n",
    "      'start':'1',\n",
    "      'limit':'15',\n",
    "      'convert':'USD'\n",
    "    }\n",
    "    headers = {\n",
    "      'Accepts': 'application/json',\n",
    "      'X-CMC_PRO_API_KEY': '0ad53085-1cb2-4eb8-ad9e-3ffbd7e56509',\n",
    "    }\n",
    "\n",
    "    session = Session()\n",
    "    session.headers.update(headers)\n",
    "\n",
    "    try:\n",
    "      response = session.get(url, params=parameters)\n",
    "      data = json.loads(response.text)\n",
    "      #print(data)\n",
    "    except (ConnectionError, Timeout, TooManyRedirects) as e:\n",
    "      print(e)\n",
    "\n",
    "# Para manter as informações dentro de um dataframe:\n",
    "    df2 = pd.json_normalize(data['data'])\n",
    "    df2['Timestamp'] = pd.to_datetime('now')\n",
    "    df = df.append(df2)\n",
    "    \n",
    "# Ou, para criar um arquivo csv:\n",
    "#df = pd.json_normalize(data['data'])\n",
    "#df['timestamp'] = pd.to_datetime('now')\n",
    "#df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "34db5c69",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}