Skip to content

Instantly share code, notes, and snippets.

@rs6000

rs6000/jsontodataframe.ipynb

Last active March 25, 2022 23:55
Show Gist options
  • Save rs6000/a0601bceb34135fb821dc025f09861e5 to your computer and use it in GitHub Desktop.
Save rs6000/a0601bceb34135fb821dc025f09861e5 to your computer and use it in GitHub Desktop.
Download ZIP
Json convert to Dataframe
Display the source blob
Display the rendered blob
Raw
jsontodataframe.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"id": "2572c666",
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"import requests\n",
"import pandas as pd\n",
"import json\n",
"from pandas import json_normalize"
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "98e4f823",
"metadata": {},
"outputs": [],
"source": [
"#Python 中使用 Json 套件處理、讀寫 Json 格式文件\n",
"#https://bit.ly/348V1F3\n",
"url='http://phisix-api4.appspot.com/stocks.json'\n",
"get_data=requests.get(url)\n",
"data=json.loads(get_data.text)"
]
},
{
"cell_type": "code",
"execution_count": 3,
"id": "59019f6b",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"{'stock': [{'name': '2GO Group',\n",
" 'price': {'currency': 'PHP', 'amount': 7.29},\n",
" 'percent_change': -0.14,\n",
" 'volume': 2400,\n",
" 'symbol': '2GO'},\n",
" {'name': 'HOUSE PREF B',\n",
" 'price': {'currency': 'PHP', 'amount': 101.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 50000,\n",
" 'symbol': '8990B'},\n",
" {'name': 'HOUSE PREF A',\n",
" 'price': {'currency': 'PHP', 'amount': 100.0},\n",
" 'percent_change': 0.2,\n",
" 'volume': 500,\n",
" 'symbol': '8990P'},\n",
" {'name': 'Atok A',\n",
" 'price': {'currency': 'PHP', 'amount': 5.93},\n",
" 'percent_change': 0.68,\n",
" 'volume': 5700,\n",
" 'symbol': 'AB'},\n",
" {'name': 'ABACORE CAPITAL',\n",
" 'price': {'currency': 'PHP', 'amount': 1.03},\n",
" 'percent_change': 1.98,\n",
" 'volume': 34663000,\n",
" 'symbol': 'ABA'},\n",
" {'name': 'Asiabest Gorup',\n",
" 'price': {'currency': 'PHP', 'amount': 3.52},\n",
" 'percent_change': -8.09,\n",
" 'volume': 13000,\n",
" 'symbol': 'ABG'},\n",
" {'name': 'ABS-CBN',\n",
" 'price': {'currency': 'PHP', 'amount': 12.92},\n",
" 'percent_change': 2.54,\n",
" 'volume': 178300,\n",
" 'symbol': 'ABS'},\n",
" {'name': 'ABS-CBN PDR',\n",
" 'price': {'currency': 'PHP', 'amount': 11.9},\n",
" 'percent_change': 2.59,\n",
" 'volume': 23300,\n",
" 'symbol': 'ABSP'},\n",
" {'name': 'Ayala Corp',\n",
" 'price': {'currency': 'PHP', 'amount': 817.5},\n",
" 'percent_change': -0.18,\n",
" 'volume': 105140,\n",
" 'symbol': 'AC'},\n",
" {'name': 'AC ENERGY',\n",
" 'price': {'currency': 'PHP', 'amount': 8.3},\n",
" 'percent_change': 1.84,\n",
" 'volume': 18210300,\n",
" 'symbol': 'ACEN'},\n",
" {'name': 'AC ENEXOR',\n",
" 'price': {'currency': 'PHP', 'amount': 17.14},\n",
" 'percent_change': 6.46,\n",
" 'volume': 256100,\n",
" 'symbol': 'ACEX'},\n",
" {'name': 'AC PREF B1',\n",
" 'price': {'currency': 'PHP', 'amount': 510.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 70,\n",
" 'symbol': 'ACPB1'},\n",
" {'name': 'Alsons Cons',\n",
" 'price': {'currency': 'PHP', 'amount': 1.06},\n",
" 'percent_change': -2.75,\n",
" 'volume': 10000,\n",
" 'symbol': 'ACR'},\n",
" {'name': 'Aboitiz',\n",
" 'price': {'currency': 'PHP', 'amount': 58.95},\n",
" 'percent_change': 1.64,\n",
" 'volume': 617250,\n",
" 'symbol': 'AEV'},\n",
" {'name': 'Alliance Global',\n",
" 'price': {'currency': 'PHP', 'amount': 12.9},\n",
" 'percent_change': -0.77,\n",
" 'volume': 539200,\n",
" 'symbol': 'AGI'},\n",
" {'name': 'Arthaland',\n",
" 'price': {'currency': 'PHP', 'amount': 0.59},\n",
" 'percent_change': 0.0,\n",
" 'volume': 5000,\n",
" 'symbol': 'ALCO'},\n",
" {'name': 'Ayala Land',\n",
" 'price': {'currency': 'PHP', 'amount': 36.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 8273400,\n",
" 'symbol': 'ALI'},\n",
" {'name': 'ALLDAY',\n",
" 'price': {'currency': 'PHP', 'amount': 0.475},\n",
" 'percent_change': 0.0,\n",
" 'volume': 7210000,\n",
" 'symbol': 'ALLDY'},\n",
" {'name': 'AYALA LAND LOG',\n",
" 'price': {'currency': 'PHP', 'amount': 4.93},\n",
" 'percent_change': 1.44,\n",
" 'volume': 659000,\n",
" 'symbol': 'ALLHC'},\n",
" {'name': 'AgriNurture',\n",
" 'price': {'currency': 'PHP', 'amount': 5.22},\n",
" 'percent_change': 0.0,\n",
" 'volume': 1216700,\n",
" 'symbol': 'ANI'},\n",
" {'name': 'Anscor',\n",
" 'price': {'currency': 'PHP', 'amount': 9.0},\n",
" 'percent_change': 5.26,\n",
" 'volume': 90200,\n",
" 'symbol': 'ANS'},\n",
" {'name': 'Aboitiz Power',\n",
" 'price': {'currency': 'PHP', 'amount': 35.55},\n",
" 'percent_change': 0.28,\n",
" 'volume': 1611900,\n",
" 'symbol': 'AP'},\n",
" {'name': 'AC PREF B2R',\n",
" 'price': {'currency': 'PHP', 'amount': 502.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 3420,\n",
" 'symbol': 'APB2R'},\n",
" {'name': 'APC Group',\n",
" 'price': {'currency': 'PHP', 'amount': 0.226},\n",
" 'percent_change': -0.44,\n",
" 'volume': 10000,\n",
" 'symbol': 'APC'},\n",
" {'name': 'APOLLO GLOBAL',\n",
" 'price': {'currency': 'PHP', 'amount': 0.043},\n",
" 'percent_change': 0.0,\n",
" 'volume': 118600000,\n",
" 'symbol': 'APL'},\n",
" {'name': 'Anglo-Phil Hldg',\n",
" 'price': {'currency': 'PHP', 'amount': 0.91},\n",
" 'percent_change': 0.0,\n",
" 'volume': 605000,\n",
" 'symbol': 'APO'},\n",
" {'name': 'ALTUS PROP',\n",
" 'price': {'currency': 'PHP', 'amount': 16.22},\n",
" 'percent_change': -1.7,\n",
" 'volume': 3800,\n",
" 'symbol': 'APVI'},\n",
" {'name': 'Apex Mining A',\n",
" 'price': {'currency': 'PHP', 'amount': 1.63},\n",
" 'percent_change': -0.61,\n",
" 'volume': 3163000,\n",
" 'symbol': 'APX'},\n",
" {'name': 'AREIT RT',\n",
" 'price': {'currency': 'PHP', 'amount': 46.8},\n",
" 'percent_change': 3.31,\n",
" 'volume': 753700,\n",
" 'symbol': 'AREIT'},\n",
" {'name': 'Atlas Mining',\n",
" 'price': {'currency': 'PHP', 'amount': 7.0},\n",
" 'percent_change': -1.13,\n",
" 'volume': 454600,\n",
" 'symbol': 'AT'},\n",
" {'name': 'Asian Terminals',\n",
" 'price': {'currency': 'PHP', 'amount': 13.9},\n",
" 'percent_change': -0.43,\n",
" 'volume': 1000,\n",
" 'symbol': 'ATI'},\n",
" {'name': 'ATN Holdings A',\n",
" 'price': {'currency': 'PHP', 'amount': 0.63},\n",
" 'percent_change': 3.28,\n",
" 'volume': 6776000,\n",
" 'symbol': 'ATN'},\n",
" {'name': 'ATN Holdings B',\n",
" 'price': {'currency': 'PHP', 'amount': 0.62},\n",
" 'percent_change': -1.59,\n",
" 'volume': 196000,\n",
" 'symbol': 'ATNB'},\n",
" {'name': 'ASIA UNITED',\n",
" 'price': {'currency': 'PHP', 'amount': 43.7},\n",
" 'percent_change': 0.46,\n",
" 'volume': 2500,\n",
" 'symbol': 'AUB'},\n",
" {'name': 'AXELUM',\n",
" 'price': {'currency': 'PHP', 'amount': 2.62},\n",
" 'percent_change': 4.8,\n",
" 'volume': 233000,\n",
" 'symbol': 'AXLM'},\n",
" {'name': 'Prime Gaming',\n",
" 'price': {'currency': 'PHP', 'amount': 5.59},\n",
" 'percent_change': 0.0,\n",
" 'volume': 3000,\n",
" 'symbol': 'BCOR'},\n",
" {'name': 'Banco de Oro',\n",
" 'price': {'currency': 'PHP', 'amount': 132.5},\n",
" 'percent_change': 1.92,\n",
" 'volume': 1569250,\n",
" 'symbol': 'BDO'},\n",
" {'name': 'Belle Corp.',\n",
" 'price': {'currency': 'PHP', 'amount': 1.31},\n",
" 'percent_change': -1.5,\n",
" 'volume': 23000,\n",
" 'symbol': 'BEL'},\n",
" {'name': 'Bright Kindle',\n",
" 'price': {'currency': 'PHP', 'amount': 2.11},\n",
" 'percent_change': 2.93,\n",
" 'volume': 772000,\n",
" 'symbol': 'BKR'},\n",
" {'name': 'Bloomberry',\n",
" 'price': {'currency': 'PHP', 'amount': 6.29},\n",
" 'percent_change': 1.13,\n",
" 'volume': 11784800,\n",
" 'symbol': 'BLOOM'},\n",
" {'name': 'BPI',\n",
" 'price': {'currency': 'PHP', 'amount': 99.9},\n",
" 'percent_change': 0.91,\n",
" 'volume': 895640,\n",
" 'symbol': 'BPI'},\n",
" {'name': 'A. Brown',\n",
" 'price': {'currency': 'PHP', 'amount': 0.93},\n",
" 'percent_change': 1.09,\n",
" 'volume': 1025000,\n",
" 'symbol': 'BRN'},\n",
" {'name': 'BRN PREF A',\n",
" 'price': {'currency': 'PHP', 'amount': 105.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 200,\n",
" 'symbol': 'BRNP'},\n",
" {'name': 'BASIC ENERGY',\n",
" 'price': {'currency': 'PHP', 'amount': 0.42},\n",
" 'percent_change': -2.33,\n",
" 'volume': 2120000,\n",
" 'symbol': 'BSC'},\n",
" {'name': 'CHELSEA',\n",
" 'price': {'currency': 'PHP', 'amount': 1.57},\n",
" 'percent_change': 0.0,\n",
" 'volume': 73000,\n",
" 'symbol': 'C'},\n",
" {'name': 'Concrete A',\n",
" 'price': {'currency': 'PHP', 'amount': 48.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 1600,\n",
" 'symbol': 'CA'},\n",
" {'name': 'Cityland Devt.',\n",
" 'price': {'currency': 'PHP', 'amount': 0.71},\n",
" 'percent_change': 1.43,\n",
" 'volume': 6000,\n",
" 'symbol': 'CDC'},\n",
" {'name': '5J',\n",
" 'price': {'currency': 'PHP', 'amount': 44.2},\n",
" 'percent_change': -0.45,\n",
" 'volume': 75600,\n",
" 'symbol': 'CEB'},\n",
" {'name': 'CEB PREF',\n",
" 'price': {'currency': 'PHP', 'amount': 44.0},\n",
" 'percent_change': 0.92,\n",
" 'volume': 1700,\n",
" 'symbol': 'CEBCP'},\n",
" {'name': 'Crown Equities',\n",
" 'price': {'currency': 'PHP', 'amount': 0.093},\n",
" 'percent_change': 3.33,\n",
" 'volume': 80000,\n",
" 'symbol': 'CEI'},\n",
" {'name': 'Chinabank',\n",
" 'price': {'currency': 'PHP', 'amount': 26.4},\n",
" 'percent_change': -1.12,\n",
" 'volume': 329000,\n",
" 'symbol': 'CHIB'},\n",
" {'name': 'Cemex Hldg',\n",
" 'price': {'currency': 'PHP', 'amount': 0.9},\n",
" 'percent_change': 1.12,\n",
" 'volume': 483000,\n",
" 'symbol': 'CHP'},\n",
" {'name': 'CONCEPCION',\n",
" 'price': {'currency': 'PHP', 'amount': 20.0},\n",
" 'percent_change': -2.2,\n",
" 'volume': 500,\n",
" 'symbol': 'CIC'},\n",
" {'name': 'CEB LANDMASTERS',\n",
" 'price': {'currency': 'PHP', 'amount': 2.97},\n",
" 'percent_change': 0.0,\n",
" 'volume': 594000,\n",
" 'symbol': 'CLI'},\n",
" {'name': 'CENTURY FOOD',\n",
" 'price': {'currency': 'PHP', 'amount': 21.5},\n",
" 'percent_change': -1.38,\n",
" 'volume': 222700,\n",
" 'symbol': 'CNPF'},\n",
" {'name': 'CONVERGE',\n",
" 'price': {'currency': 'PHP', 'amount': 28.5},\n",
" 'percent_change': 2.52,\n",
" 'volume': 16870100,\n",
" 'symbol': 'CNVRG'},\n",
" {'name': 'COL Financial',\n",
" 'price': {'currency': 'PHP', 'amount': 3.9},\n",
" 'percent_change': 0.0,\n",
" 'volume': 30000,\n",
" 'symbol': 'COL'},\n",
" {'name': 'COSCO CAPITAL',\n",
" 'price': {'currency': 'PHP', 'amount': 5.02},\n",
" 'percent_change': 0.8,\n",
" 'volume': 985000,\n",
" 'symbol': 'COSCO'},\n",
" {'name': 'CPG',\n",
" 'price': {'currency': 'PHP', 'amount': 0.41},\n",
" 'percent_change': 0.0,\n",
" 'volume': 490000,\n",
" 'symbol': 'CPG'},\n",
" {'name': 'CENTURY PEAK',\n",
" 'price': {'currency': 'PHP', 'amount': 2.72},\n",
" 'percent_change': -1.09,\n",
" 'volume': 135000,\n",
" 'symbol': 'CPM'},\n",
" {'name': 'CITICORE RT',\n",
" 'price': {'currency': 'PHP', 'amount': 2.68},\n",
" 'percent_change': 2.68,\n",
" 'volume': 4394000,\n",
" 'symbol': 'CREIT'},\n",
" {'name': 'CROWN ASIA',\n",
" 'price': {'currency': 'PHP', 'amount': 1.8},\n",
" 'percent_change': -4.26,\n",
" 'volume': 218000,\n",
" 'symbol': 'CROWN'},\n",
" {'name': 'DOUBLEDRAGON',\n",
" 'price': {'currency': 'PHP', 'amount': 8.88},\n",
" 'percent_change': -1.33,\n",
" 'volume': 310400,\n",
" 'symbol': 'DD'},\n",
" {'name': 'DDMP RT',\n",
" 'price': {'currency': 'PHP', 'amount': 1.6},\n",
" 'percent_change': 1.27,\n",
" 'volume': 2021000,\n",
" 'symbol': 'DDMPR'},\n",
" {'name': 'DD PREF',\n",
" 'price': {'currency': 'PHP', 'amount': 101.0},\n",
" 'percent_change': 0.5,\n",
" 'volume': 48220,\n",
" 'symbol': 'DDPR'},\n",
" {'name': 'DEL MONTE',\n",
" 'price': {'currency': 'PHP', 'amount': 14.56},\n",
" 'percent_change': 3.12,\n",
" 'volume': 12300,\n",
" 'symbol': 'DELM'},\n",
" {'name': 'Diversified',\n",
" 'price': {'currency': 'PHP', 'amount': 2.41},\n",
" 'percent_change': -2.43,\n",
" 'volume': 34000,\n",
" 'symbol': 'DFNN'},\n",
" {'name': 'ISM Comm.',\n",
" 'price': {'currency': 'PHP', 'amount': 5.14},\n",
" 'percent_change': -1.91,\n",
" 'volume': 4600800,\n",
" 'symbol': 'DITO'},\n",
" {'name': 'DMCI Holdings',\n",
" 'price': {'currency': 'PHP', 'amount': 9.04},\n",
" 'percent_change': -0.22,\n",
" 'volume': 7372000,\n",
" 'symbol': 'DMC'},\n",
" {'name': 'DM WENCESLAO',\n",
" 'price': {'currency': 'PHP', 'amount': 6.89},\n",
" 'percent_change': 0.0,\n",
" 'volume': 24000,\n",
" 'symbol': 'DMW'},\n",
" {'name': 'DNL INDUS',\n",
" 'price': {'currency': 'PHP', 'amount': 7.94},\n",
" 'percent_change': 3.66,\n",
" 'volume': 4773600,\n",
" 'symbol': 'DNL'},\n",
" {'name': 'DISCOVERY WORLD',\n",
" 'price': {'currency': 'PHP', 'amount': 1.6},\n",
" 'percent_change': 5.96,\n",
" 'volume': 612000,\n",
" 'symbol': 'DWC'},\n",
" {'name': 'EAGLE CEMENT',\n",
" 'price': {'currency': 'PHP', 'amount': 13.08},\n",
" 'percent_change': -3.82,\n",
" 'volume': 12500,\n",
" 'symbol': 'EAGLE'},\n",
" {'name': 'Easycall',\n",
" 'price': {'currency': 'PHP', 'amount': 4.05},\n",
" 'percent_change': -9.4,\n",
" 'volume': 1000,\n",
" 'symbol': 'ECP'},\n",
" {'name': 'EEI Corp.',\n",
" 'price': {'currency': 'PHP', 'amount': 6.0},\n",
" 'percent_change': 2.21,\n",
" 'volume': 88000,\n",
" 'symbol': 'EEI'},\n",
" {'name': 'EEI PREF B',\n",
" 'price': {'currency': 'PHP', 'amount': 109.7},\n",
" 'percent_change': -0.18,\n",
" 'volume': 9000,\n",
" 'symbol': 'EEIPB'},\n",
" {'name': 'Empire East',\n",
" 'price': {'currency': 'PHP', 'amount': 0.233},\n",
" 'percent_change': -2.92,\n",
" 'volume': 50000,\n",
" 'symbol': 'ELI'},\n",
" {'name': 'EMPERADOR',\n",
" 'price': {'currency': 'PHP', 'amount': 14.64},\n",
" 'percent_change': 0.14,\n",
" 'volume': 6467600,\n",
" 'symbol': 'EMP'},\n",
" {'name': 'Euromed',\n",
" 'price': {'currency': 'PHP', 'amount': 1.1},\n",
" 'percent_change': -5.98,\n",
" 'volume': 138000,\n",
" 'symbol': 'EURO'},\n",
" {'name': 'Ever-Gotesco',\n",
" 'price': {'currency': 'PHP', 'amount': 0.275},\n",
" 'percent_change': -1.79,\n",
" 'volume': 2570000,\n",
" 'symbol': 'EVER'},\n",
" {'name': 'EW',\n",
" 'price': {'currency': 'PHP', 'amount': 8.4},\n",
" 'percent_change': 0.24,\n",
" 'volume': 66100,\n",
" 'symbol': 'EW'},\n",
" {'name': 'Purefoods',\n",
" 'price': {'currency': 'PHP', 'amount': 63.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 28440,\n",
" 'symbol': 'FB'},\n",
" {'name': 'FIGARO COFFEE',\n",
" 'price': {'currency': 'PHP', 'amount': 0.62},\n",
" 'percent_change': -3.12,\n",
" 'volume': 10030000,\n",
" 'symbol': 'FCG'},\n",
" {'name': 'Filinvest Dev.',\n",
" 'price': {'currency': 'PHP', 'amount': 6.79},\n",
" 'percent_change': 0.59,\n",
" 'volume': 24000,\n",
" 'symbol': 'FDC'},\n",
" {'name': 'Far Eastern U.',\n",
" 'price': {'currency': 'PHP', 'amount': 530.0},\n",
" 'percent_change': -0.09,\n",
" 'volume': 790,\n",
" 'symbol': 'FEU'},\n",
" {'name': 'Filipino Fund',\n",
" 'price': {'currency': 'PHP', 'amount': 6.55},\n",
" 'percent_change': 0.0,\n",
" 'volume': 300,\n",
" 'symbol': 'FFI'},\n",
" {'name': 'First Gen',\n",
" 'price': {'currency': 'PHP', 'amount': 25.6},\n",
" 'percent_change': 3.02,\n",
" 'volume': 391300,\n",
" 'symbol': 'FGEN'},\n",
" {'name': 'FILINVEST RT',\n",
" 'price': {'currency': 'PHP', 'amount': 7.16},\n",
" 'percent_change': 0.14,\n",
" 'volume': 6574300,\n",
" 'symbol': 'FILRT'},\n",
" {'name': 'F&J Prince A',\n",
" 'price': {'currency': 'PHP', 'amount': 2.29},\n",
" 'percent_change': -8.4,\n",
" 'volume': 34000,\n",
" 'symbol': 'FJP'},\n",
" {'name': 'Filinvest Land',\n",
" 'price': {'currency': 'PHP', 'amount': 1.07},\n",
" 'percent_change': 2.88,\n",
" 'volume': 957000,\n",
" 'symbol': 'FLI'},\n",
" {'name': 'FIRST METRO ETF',\n",
" 'price': {'currency': 'PHP', 'amount': 108.4},\n",
" 'percent_change': 0.37,\n",
" 'volume': 8580,\n",
" 'symbol': 'FMETF'},\n",
" {'name': 'FERRONICKEL',\n",
" 'price': {'currency': 'PHP', 'amount': 2.93},\n",
" 'percent_change': 0.34,\n",
" 'volume': 10300000,\n",
" 'symbol': 'FNI'},\n",
" {'name': 'Tuna',\n",
" 'price': {'currency': 'PHP', 'amount': 0.6},\n",
" 'percent_change': 0.0,\n",
" 'volume': 16000,\n",
" 'symbol': 'FOOD'},\n",
" {'name': 'First Phil Hldg',\n",
" 'price': {'currency': 'PHP', 'amount': 69.55},\n",
" 'percent_change': -0.5,\n",
" 'volume': 2910,\n",
" 'symbol': 'FPH'},\n",
" {'name': 'FRUITAS HLDG',\n",
" 'price': {'currency': 'PHP', 'amount': 1.12},\n",
" 'percent_change': 0.0,\n",
" 'volume': 687000,\n",
" 'symbol': 'FRUIT'},\n",
" {'name': 'GEOGRACE',\n",
" 'price': {'currency': 'PHP', 'amount': 0.187},\n",
" 'percent_change': 0.0,\n",
" 'volume': 10000,\n",
" 'symbol': 'GEO'},\n",
" {'name': 'Globe Telecom',\n",
" 'price': {'currency': 'PHP', 'amount': 2638.0},\n",
" 'percent_change': 3.05,\n",
" 'volume': 68560,\n",
" 'symbol': 'GLO'},\n",
" {'name': 'GMA Network',\n",
" 'price': {'currency': 'PHP', 'amount': 15.9},\n",
" 'percent_change': 0.76,\n",
" 'volume': 13149300,\n",
" 'symbol': 'GMA7'},\n",
" {'name': 'GMA Holdings',\n",
" 'price': {'currency': 'PHP', 'amount': 14.96},\n",
" 'percent_change': -0.27,\n",
" 'volume': 474600,\n",
" 'symbol': 'GMAP'},\n",
" {'name': 'Grand Plaza',\n",
" 'price': {'currency': 'PHP', 'amount': 13.46},\n",
" 'percent_change': -6.53,\n",
" 'volume': 500,\n",
" 'symbol': 'GPH'},\n",
" {'name': 'GREEN',\n",
" 'price': {'currency': 'PHP', 'amount': 1.79},\n",
" 'percent_change': 2.29,\n",
" 'volume': 13319000,\n",
" 'symbol': 'GREEN'},\n",
" {'name': 'Ginebra',\n",
" 'price': {'currency': 'PHP', 'amount': 108.0},\n",
" 'percent_change': -0.92,\n",
" 'volume': 13860,\n",
" 'symbol': 'GSMI'},\n",
" {'name': 'GT Capital',\n",
" 'price': {'currency': 'PHP', 'amount': 506.5},\n",
" 'percent_change': 0.3,\n",
" 'volume': 137880,\n",
" 'symbol': 'GTCAP'},\n",
" {'name': 'GTCAP PREF B',\n",
" 'price': {'currency': 'PHP', 'amount': 1019.0},\n",
" 'percent_change': -1.92,\n",
" 'volume': 1215,\n",
" 'symbol': 'GTPPB'},\n",
" {'name': 'Holcim',\n",
" 'price': {'currency': 'PHP', 'amount': 5.74},\n",
" 'percent_change': 3.42,\n",
" 'volume': 41100,\n",
" 'symbol': 'HLCM'},\n",
" {'name': 'ALLHOME',\n",
" 'price': {'currency': 'PHP', 'amount': 7.45},\n",
" 'percent_change': 0.68,\n",
" 'volume': 505600,\n",
" 'symbol': 'HOME'},\n",
" {'name': '8990 HLDG',\n",
" 'price': {'currency': 'PHP', 'amount': 13.88},\n",
" 'percent_change': 0.29,\n",
" 'volume': 80800,\n",
" 'symbol': 'HOUSE'},\n",
" {'name': 'HAUS TALK',\n",
" 'price': {'currency': 'PHP', 'amount': 1.18},\n",
" 'percent_change': 1.72,\n",
" 'volume': 4094000,\n",
" 'symbol': 'HTI'},\n",
" {'name': 'GOLDEN MV',\n",
" 'price': {'currency': 'PHP', 'amount': 678.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 120,\n",
" 'symbol': 'HVN'},\n",
" {'name': 'IRemit',\n",
" 'price': {'currency': 'PHP', 'amount': 0.79},\n",
" 'percent_change': -3.66,\n",
" 'volume': 3000,\n",
" 'symbol': 'I'},\n",
" {'name': 'Intl Container',\n",
" 'price': {'currency': 'PHP', 'amount': 224.0},\n",
" 'percent_change': 0.9,\n",
" 'volume': 930540,\n",
" 'symbol': 'ICT'},\n",
" {'name': 'Italpinas',\n",
" 'price': {'currency': 'PHP', 'amount': 0.91},\n",
" 'percent_change': -1.09,\n",
" 'volume': 151000,\n",
" 'symbol': 'IDC'},\n",
" {'name': 'Integ. Micro',\n",
" 'price': {'currency': 'PHP', 'amount': 8.1},\n",
" 'percent_change': 0.25,\n",
" 'volume': 70900,\n",
" 'symbol': 'IMI'},\n",
" {'name': 'Ionics',\n",
" 'price': {'currency': 'PHP', 'amount': 0.7},\n",
" 'percent_change': 0.0,\n",
" 'volume': 12000,\n",
" 'symbol': 'ION'},\n",
" {'name': 'IPM HLDG',\n",
" 'price': {'currency': 'PHP', 'amount': 6.7},\n",
" 'percent_change': 0.0,\n",
" 'volume': 2500,\n",
" 'symbol': 'IPM'},\n",
" {'name': 'IPeople',\n",
" 'price': {'currency': 'PHP', 'amount': 6.7},\n",
" 'percent_change': 0.15,\n",
" 'volume': 9700,\n",
" 'symbol': 'IPO'},\n",
" {'name': 'PHIL INFRADEV',\n",
" 'price': {'currency': 'PHP', 'amount': 0.95},\n",
" 'percent_change': 1.06,\n",
" 'volume': 79000,\n",
" 'symbol': 'IRC'},\n",
" {'name': 'Jollibee',\n",
" 'price': {'currency': 'PHP', 'amount': 214.0},\n",
" 'percent_change': 0.47,\n",
" 'volume': 333260,\n",
" 'symbol': 'JFC'},\n",
" {'name': 'JFC PREF A',\n",
" 'price': {'currency': 'PHP', 'amount': 985.0},\n",
" 'percent_change': -0.51,\n",
" 'volume': 50,\n",
" 'symbol': 'JFCPA'},\n",
" {'name': 'JG Summit',\n",
" 'price': {'currency': 'PHP', 'amount': 58.0},\n",
" 'percent_change': -1.69,\n",
" 'volume': 567840,\n",
" 'symbol': 'JGS'},\n",
" {'name': 'KEEPERS HLDG',\n",
" 'price': {'currency': 'PHP', 'amount': 1.2},\n",
" 'percent_change': 0.0,\n",
" 'volume': 4740000,\n",
" 'symbol': 'KEEPR'},\n",
" {'name': 'City & Land',\n",
" 'price': {'currency': 'PHP', 'amount': 0.82},\n",
" 'percent_change': 0.0,\n",
" 'volume': 62000,\n",
" 'symbol': 'LAND'},\n",
" {'name': 'Lepanto A',\n",
" 'price': {'currency': 'PHP', 'amount': 0.158},\n",
" 'percent_change': 0.0,\n",
" 'volume': 4190000,\n",
" 'symbol': 'LC'},\n",
" {'name': 'Lepanto B',\n",
" 'price': {'currency': 'PHP', 'amount': 0.156},\n",
" 'percent_change': -2.5,\n",
" 'volume': 6620000,\n",
" 'symbol': 'LCB'},\n",
" {'name': 'Liberty Flour',\n",
" 'price': {'currency': 'PHP', 'amount': 25.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 100,\n",
" 'symbol': 'LFM'},\n",
" {'name': 'Leisure',\n",
" 'price': {'currency': 'PHP', 'amount': 1.32},\n",
" 'percent_change': 1.54,\n",
" 'volume': 38000,\n",
" 'symbol': 'LR'},\n",
" {'name': 'LT GROUP',\n",
" 'price': {'currency': 'PHP', 'amount': 8.9},\n",
" 'percent_change': -2.41,\n",
" 'volume': 5847100,\n",
" 'symbol': 'LTG'},\n",
" {'name': 'Manila Mining A',\n",
" 'price': {'currency': 'PHP', 'amount': 0.011},\n",
" 'percent_change': 0.0,\n",
" 'volume': 6900000,\n",
" 'symbol': 'MA'},\n",
" {'name': 'Macroasia',\n",
" 'price': {'currency': 'PHP', 'amount': 5.25},\n",
" 'percent_change': 0.57,\n",
" 'volume': 347000,\n",
" 'symbol': 'MAC'},\n",
" {'name': 'Marcventures',\n",
" 'price': {'currency': 'PHP', 'amount': 1.88},\n",
" 'percent_change': -0.53,\n",
" 'volume': 3216000,\n",
" 'symbol': 'MARC'},\n",
" {'name': 'MAXS GROUP',\n",
" 'price': {'currency': 'PHP', 'amount': 6.18},\n",
" 'percent_change': 1.31,\n",
" 'volume': 47800,\n",
" 'symbol': 'MAXS'},\n",
" {'name': 'Manila Bulletin',\n",
" 'price': {'currency': 'PHP', 'amount': 0.395},\n",
" 'percent_change': -1.25,\n",
" 'volume': 170000,\n",
" 'symbol': 'MB'},\n",
" {'name': 'Metrobank',\n",
" 'price': {'currency': 'PHP', 'amount': 54.55},\n",
" 'percent_change': 3.02,\n",
" 'volume': 2413310,\n",
" 'symbol': 'MBT'},\n",
" {'name': 'MEDILINES',\n",
" 'price': {'currency': 'PHP', 'amount': 0.87},\n",
" 'percent_change': 1.16,\n",
" 'volume': 708000,\n",
" 'symbol': 'MEDIC'},\n",
" {'name': 'Megaworld',\n",
" 'price': {'currency': 'PHP', 'amount': 3.05},\n",
" 'percent_change': -1.61,\n",
" 'volume': 7534000,\n",
" 'symbol': 'MEG'},\n",
" {'name': 'Meralco A',\n",
" 'price': {'currency': 'PHP', 'amount': 369.0},\n",
" 'percent_change': -2.64,\n",
" 'volume': 111060,\n",
" 'symbol': 'MER'},\n",
" {'name': 'Manulife',\n",
" 'price': {'currency': 'PHP', 'amount': 1000.0},\n",
" 'percent_change': -9.58,\n",
" 'volume': 15,\n",
" 'symbol': 'MFC'},\n",
" {'name': 'Manila Jockey',\n",
" 'price': {'currency': 'PHP', 'amount': 1.82},\n",
" 'percent_change': 0.0,\n",
" 'volume': 765000,\n",
" 'symbol': 'MJC'},\n",
" {'name': 'MERRYMART',\n",
" 'price': {'currency': 'PHP', 'amount': 1.87},\n",
" 'percent_change': 0.0,\n",
" 'volume': 889000,\n",
" 'symbol': 'MM'},\n",
" {'name': 'MONDE NISSIN',\n",
" 'price': {'currency': 'PHP', 'amount': 13.5},\n",
" 'percent_change': 0.0,\n",
" 'volume': 6945300,\n",
" 'symbol': 'MONDE'},\n",
" {'name': 'Metro Pac Inv ',\n",
" 'price': {'currency': 'PHP', 'amount': 3.78},\n",
" 'percent_change': -0.26,\n",
" 'volume': 7211000,\n",
" 'symbol': 'MPI'},\n",
" {'name': 'MRC Allied',\n",
" 'price': {'currency': 'PHP', 'amount': 0.255},\n",
" 'percent_change': 2.0,\n",
" 'volume': 2690000,\n",
" 'symbol': 'MRC'},\n",
" {'name': 'MREIT RT',\n",
" 'price': {'currency': 'PHP', 'amount': 18.94},\n",
" 'percent_change': 2.38,\n",
" 'volume': 1553500,\n",
" 'symbol': 'MREIT'},\n",
" {'name': 'Metro Retail',\n",
" 'price': {'currency': 'PHP', 'amount': 1.41},\n",
" 'percent_change': 0.0,\n",
" 'volume': 33000,\n",
" 'symbol': 'MRSGI'},\n",
" {'name': 'Mabuhay Vinyl',\n",
" 'price': {'currency': 'PHP', 'amount': 4.42},\n",
" 'percent_change': 1.14,\n",
" 'volume': 4000,\n",
" 'symbol': 'MVC'},\n",
" {'name': 'Manila Water',\n",
" 'price': {'currency': 'PHP', 'amount': 20.05},\n",
" 'percent_change': -2.43,\n",
" 'volume': 1272600,\n",
" 'symbol': 'MWC'},\n",
" {'name': 'Megawide',\n",
" 'price': {'currency': 'PHP', 'amount': 5.07},\n",
" 'percent_change': -0.78,\n",
" 'volume': 151100,\n",
" 'symbol': 'MWIDE'},\n",
" {'name': 'MWIDE PREF 4',\n",
" 'price': {'currency': 'PHP', 'amount': 100.0},\n",
" 'percent_change': -0.1,\n",
" 'volume': 15000,\n",
" 'symbol': 'MWP4'},\n",
" {'name': 'NiHAO',\n",
" 'price': {'currency': 'PHP', 'amount': 1.03},\n",
" 'percent_change': 0.98,\n",
" 'volume': 102000,\n",
" 'symbol': 'NI'},\n",
" {'name': 'NICKELASIA',\n",
" 'price': {'currency': 'PHP', 'amount': 8.22},\n",
" 'percent_change': -0.12,\n",
" 'volume': 10073600,\n",
" 'symbol': 'NIKL'},\n",
" {'name': 'NOW CORP',\n",
" 'price': {'currency': 'PHP', 'amount': 1.3},\n",
" 'percent_change': 1.56,\n",
" 'volume': 2049000,\n",
" 'symbol': 'NOW'},\n",
" {'name': 'PhilNaRe',\n",
" 'price': {'currency': 'PHP', 'amount': 0.6},\n",
" 'percent_change': -1.64,\n",
" 'volume': 226000,\n",
" 'symbol': 'NRCP'},\n",
" {'name': 'ORNTL PETROL A',\n",
" 'price': {'currency': 'PHP', 'amount': 0.012},\n",
" 'percent_change': 9.09,\n",
" 'volume': 23500000,\n",
" 'symbol': 'OPM'},\n",
" {'name': 'ORNTL PETROL B',\n",
" 'price': {'currency': 'PHP', 'amount': 0.012},\n",
" 'percent_change': 0.0,\n",
" 'volume': 300000,\n",
" 'symbol': 'OPMB'},\n",
" {'name': 'Oriental P',\n",
" 'price': {'currency': 'PHP', 'amount': 1.02},\n",
" 'percent_change': -1.92,\n",
" 'volume': 2247000,\n",
" 'symbol': 'ORE'},\n",
" {'name': 'Philodrill A',\n",
" 'price': {'currency': 'PHP', 'amount': 0.0095},\n",
" 'percent_change': 0.0,\n",
" 'volume': 13000000,\n",
" 'symbol': 'OV'},\n",
" {'name': 'PB BANK',\n",
" 'price': {'currency': 'PHP', 'amount': 9.1},\n",
" 'percent_change': -0.22,\n",
" 'volume': 5200,\n",
" 'symbol': 'PBB'},\n",
" {'name': 'Petron',\n",
" 'price': {'currency': 'PHP', 'amount': 3.31},\n",
" 'percent_change': -1.49,\n",
" 'volume': 614000,\n",
" 'symbol': 'PCOR'},\n",
" {'name': 'PetroEnergy',\n",
" 'price': {'currency': 'PHP', 'amount': 4.97},\n",
" 'percent_change': 0.61,\n",
" 'volume': 8000,\n",
" 'symbol': 'PERC'},\n",
" {'name': 'PUREGOLD',\n",
" 'price': {'currency': 'PHP', 'amount': 32.95},\n",
" 'percent_change': 1.23,\n",
" 'volume': 1267700,\n",
" 'symbol': 'PGOLD'},\n",
" {'name': 'PremiereHorizon',\n",
" 'price': {'currency': 'PHP', 'amount': 0.55},\n",
" 'percent_change': -1.79,\n",
" 'volume': 2251000,\n",
" 'symbol': 'PHA'},\n",
" {'name': 'Phil Estates',\n",
" 'price': {'currency': 'PHP', 'amount': 0.41},\n",
" 'percent_change': 2.5,\n",
" 'volume': 330000,\n",
" 'symbol': 'PHES'},\n",
" {'name': 'Phinma ',\n",
" 'price': {'currency': 'PHP', 'amount': 19.48},\n",
" 'percent_change': -0.1,\n",
" 'volume': 20700,\n",
" 'symbol': 'PHN'},\n",
" {'name': 'PH RESORTS GRP',\n",
" 'price': {'currency': 'PHP', 'amount': 1.03},\n",
" 'percent_change': 0.98,\n",
" 'volume': 1755000,\n",
" 'symbol': 'PHR'},\n",
" {'name': 'SHAKEYS PIZZA',\n",
" 'price': {'currency': 'PHP', 'amount': 7.76},\n",
" 'percent_change': -0.39,\n",
" 'volume': 137100,\n",
" 'symbol': 'PIZZA'},\n",
" {'name': 'PREMIUM LEISURE',\n",
" 'price': {'currency': 'PHP', 'amount': 0.45},\n",
" 'percent_change': 1.12,\n",
" 'volume': 2590000,\n",
" 'symbol': 'PLC'},\n",
" {'name': 'Panasonic',\n",
" 'price': {'currency': 'PHP', 'amount': 6.24},\n",
" 'percent_change': 0.81,\n",
" 'volume': 18300,\n",
" 'symbol': 'PMPC'},\n",
" {'name': 'Phil Natl Bank',\n",
" 'price': {'currency': 'PHP', 'amount': 18.82},\n",
" 'percent_change': -0.53,\n",
" 'volume': 205900,\n",
" 'symbol': 'PNB'},\n",
" {'name': 'PHX PETROLEUM',\n",
" 'price': {'currency': 'PHP', 'amount': 10.6},\n",
" 'percent_change': -0.56,\n",
" 'volume': 7700,\n",
" 'symbol': 'PNX'},\n",
" {'name': 'PNX PREF 3B',\n",
" 'price': {'currency': 'PHP', 'amount': 102.0},\n",
" 'percent_change': -0.2,\n",
" 'volume': 420,\n",
" 'symbol': 'PNX3B'},\n",
" {'name': 'PNX PREF 4',\n",
" 'price': {'currency': 'PHP', 'amount': 970.0},\n",
" 'percent_change': -1.02,\n",
" 'volume': 5500,\n",
" 'symbol': 'PNX4'},\n",
" {'name': 'PCOR PREF 3A',\n",
" 'price': {'currency': 'PHP', 'amount': 1050.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 200,\n",
" 'symbol': 'PRF3A'},\n",
" {'name': 'PCOR PREF 3B',\n",
" 'price': {'currency': 'PHP', 'amount': 1081.0},\n",
" 'percent_change': -0.09,\n",
" 'volume': 970,\n",
" 'symbol': 'PRF3B'},\n",
" {'name': 'Prime Media',\n",
" 'price': {'currency': 'PHP', 'amount': 1.57},\n",
" 'percent_change': -2.48,\n",
" 'volume': 185000,\n",
" 'symbol': 'PRIM'},\n",
" {'name': 'Primex Corp.',\n",
" 'price': {'currency': 'PHP', 'amount': 2.7},\n",
" 'percent_change': 1.5,\n",
" 'volume': 1899000,\n",
" 'symbol': 'PRMX'},\n",
" {'name': 'PSBank',\n",
" 'price': {'currency': 'PHP', 'amount': 55.05},\n",
" 'percent_change': 0.09,\n",
" 'volume': 3760,\n",
" 'symbol': 'PSB'},\n",
" {'name': 'PSE',\n",
" 'price': {'currency': 'PHP', 'amount': 202.0},\n",
" 'percent_change': 1.0,\n",
" 'volume': 10,\n",
" 'symbol': 'PSE'},\n",
" {'name': 'PX MINING',\n",
" 'price': {'currency': 'PHP', 'amount': 5.69},\n",
" 'percent_change': -1.04,\n",
" 'volume': 1297800,\n",
" 'symbol': 'PX'},\n",
" {'name': 'PXP ENERGY',\n",
" 'price': {'currency': 'PHP', 'amount': 5.66},\n",
" 'percent_change': -0.7,\n",
" 'volume': 243000,\n",
" 'symbol': 'PXP'},\n",
" {'name': 'RCBC',\n",
" 'price': {'currency': 'PHP', 'amount': 20.85},\n",
" 'percent_change': 2.46,\n",
" 'volume': 300,\n",
" 'symbol': 'RCB'},\n",
" {'name': 'CADP Group',\n",
" 'price': {'currency': 'PHP', 'amount': 0.6},\n",
" 'percent_change': 0.0,\n",
" 'volume': 1536000,\n",
" 'symbol': 'RCI'},\n",
" {'name': 'RL COMM RT',\n",
" 'price': {'currency': 'PHP', 'amount': 7.38},\n",
" 'percent_change': 0.27,\n",
" 'volume': 3488200,\n",
" 'symbol': 'RCR'},\n",
" {'name': 'Robinsons Land',\n",
" 'price': {'currency': 'PHP', 'amount': 20.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 2582500,\n",
" 'symbol': 'RLC'},\n",
" {'name': 'PhilRealty',\n",
" 'price': {'currency': 'PHP', 'amount': 0.216},\n",
" 'percent_change': 0.47,\n",
" 'volume': 190000,\n",
" 'symbol': 'RLT'},\n",
" {'name': 'ROCK',\n",
" 'price': {'currency': 'PHP', 'amount': 1.47},\n",
" 'percent_change': 0.0,\n",
" 'volume': 3000,\n",
" 'symbol': 'ROCK'},\n",
" {'name': 'Roxas Hldg.',\n",
" 'price': {'currency': 'PHP', 'amount': 1.3},\n",
" 'percent_change': -8.45,\n",
" 'volume': 218000,\n",
" 'symbol': 'ROX'},\n",
" {'name': 'ROBINSONS RTL',\n",
" 'price': {'currency': 'PHP', 'amount': 54.75},\n",
" 'percent_change': 0.55,\n",
" 'volume': 1613580,\n",
" 'symbol': 'RRHI'},\n",
" {'name': 'SBS Phil Corp',\n",
" 'price': {'currency': 'PHP', 'amount': 3.93},\n",
" 'percent_change': 0.77,\n",
" 'volume': 31000,\n",
" 'symbol': 'SBS'},\n",
" {'name': 'Semirara Mining',\n",
" 'price': {'currency': 'PHP', 'amount': 31.6},\n",
" 'percent_change': -0.94,\n",
" 'volume': 1811100,\n",
" 'symbol': 'SCC'},\n",
" {'name': 'Security Bank',\n",
" 'price': {'currency': 'PHP', 'amount': 109.0},\n",
" 'percent_change': -0.82,\n",
" 'volume': 505380,\n",
" 'symbol': 'SECB'},\n",
" {'name': '11-Jul',\n",
" 'price': {'currency': 'PHP', 'amount': 65.25},\n",
" 'percent_change': 0.31,\n",
" 'volume': 15520,\n",
" 'symbol': 'SEVN'},\n",
" {'name': 'TRANSGRID',\n",
" 'price': {'currency': 'PHP', 'amount': 12.26},\n",
" 'percent_change': 0.49,\n",
" 'volume': 1898400,\n",
" 'symbol': 'SGP'},\n",
" {'name': 'PILIPINAS SHELL',\n",
" 'price': {'currency': 'PHP', 'amount': 17.7},\n",
" 'percent_change': -1.56,\n",
" 'volume': 694600,\n",
" 'symbol': 'SHLPH'},\n",
" {'name': 'SHNG Properties',\n",
" 'price': {'currency': 'PHP', 'amount': 2.61},\n",
" 'percent_change': 0.38,\n",
" 'volume': 114000,\n",
" 'symbol': 'SHNG'},\n",
" {'name': 'Sun Life',\n",
" 'price': {'currency': 'PHP', 'amount': 2750.0},\n",
" 'percent_change': 3.7,\n",
" 'volume': 5,\n",
" 'symbol': 'SLF'},\n",
" {'name': 'Sta.Lucia Land',\n",
" 'price': {'currency': 'PHP', 'amount': 2.8},\n",
" 'percent_change': 5.66,\n",
" 'volume': 37000,\n",
" 'symbol': 'SLI'},\n",
" {'name': 'SM Investments ',\n",
" 'price': {'currency': 'PHP', 'amount': 897.0},\n",
" 'percent_change': 1.36,\n",
" 'volume': 203940,\n",
" 'symbol': 'SM'},\n",
" {'name': 'San Miguel A',\n",
" 'price': {'currency': 'PHP', 'amount': 110.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 535040,\n",
" 'symbol': 'SMC'},\n",
" {'name': 'SMC Pref 2F',\n",
" 'price': {'currency': 'PHP', 'amount': 77.85},\n",
" 'percent_change': -0.19,\n",
" 'volume': 800000,\n",
" 'symbol': 'SMC2F'},\n",
" {'name': 'SMC Pref 2I',\n",
" 'price': {'currency': 'PHP', 'amount': 78.25},\n",
" 'percent_change': 0.0,\n",
" 'volume': 20000,\n",
" 'symbol': 'SMC2I'},\n",
" {'name': 'SMC PREF 2K',\n",
" 'price': {'currency': 'PHP', 'amount': 76.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 850000,\n",
" 'symbol': 'SMC2K'},\n",
" {'name': 'SM Prime Hldg.',\n",
" 'price': {'currency': 'PHP', 'amount': 37.7},\n",
" 'percent_change': -0.66,\n",
" 'volume': 6312400,\n",
" 'symbol': 'SMPH'},\n",
" {'name': 'SPC POWER',\n",
" 'price': {'currency': 'PHP', 'amount': 14.28},\n",
" 'percent_change': -0.7,\n",
" 'volume': 95200,\n",
" 'symbol': 'SPC'},\n",
" {'name': 'SOLAR PH',\n",
" 'price': {'currency': 'PHP', 'amount': 2.0},\n",
" 'percent_change': 1.52,\n",
" 'volume': 70089000,\n",
" 'symbol': 'SPNEC'},\n",
" {'name': 'SSI GROUP',\n",
" 'price': {'currency': 'PHP', 'amount': 1.06},\n",
" 'percent_change': 0.0,\n",
" 'volume': 94000,\n",
" 'symbol': 'SSI'},\n",
" {'name': 'PHX SEMICNDCTR',\n",
" 'price': {'currency': 'PHP', 'amount': 1.04},\n",
" 'percent_change': 0.97,\n",
" 'volume': 124000,\n",
" 'symbol': 'SSP'},\n",
" {'name': 'STI_HOLDINGS',\n",
" 'price': {'currency': 'PHP', 'amount': 0.36},\n",
" 'percent_change': 1.41,\n",
" 'volume': 290000,\n",
" 'symbol': 'STI'},\n",
" {'name': 'Starmalls',\n",
" 'price': {'currency': 'PHP', 'amount': 3.23},\n",
" 'percent_change': 1.57,\n",
" 'volume': 11000,\n",
" 'symbol': 'STR'},\n",
" {'name': 'TKC METALS',\n",
" 'price': {'currency': 'PHP', 'amount': 0.78},\n",
" 'percent_change': -2.5,\n",
" 'volume': 137000,\n",
" 'symbol': 'T'},\n",
" {'name': 'Transpacific Br',\n",
" 'price': {'currency': 'PHP', 'amount': 0.335},\n",
" 'percent_change': 0.0,\n",
" 'volume': 5120000,\n",
" 'symbol': 'TBGI'},\n",
" {'name': 'TECH PREF B2D',\n",
" 'price': {'currency': 'PHP', 'amount': 54.95},\n",
" 'percent_change': 0.0,\n",
" 'volume': 560,\n",
" 'symbol': 'TCB2D'},\n",
" {'name': 'CHIPS',\n",
" 'price': {'currency': 'PHP', 'amount': 3.19},\n",
" 'percent_change': 0.31,\n",
" 'volume': 228000,\n",
" 'symbol': 'TECH'},\n",
" {'name': 'TECH WARRANT',\n",
" 'price': {'currency': 'PHP', 'amount': 0.63},\n",
" 'percent_change': -1.56,\n",
" 'volume': 132000,\n",
" 'symbol': 'TECHW'},\n",
" {'name': 'PLDT',\n",
" 'price': {'currency': 'PHP', 'amount': 1850.0},\n",
" 'percent_change': 1.04,\n",
" 'volume': 127745,\n",
" 'symbol': 'TEL'},\n",
" {'name': 'TOP FRONTIER',\n",
" 'price': {'currency': 'PHP', 'amount': 119.4},\n",
" 'percent_change': -0.33,\n",
" 'volume': 1120,\n",
" 'symbol': 'TFHI'},\n",
" {'name': 'HARBOR STAR',\n",
" 'price': {'currency': 'PHP', 'amount': 0.74},\n",
" 'percent_change': 0.0,\n",
" 'volume': 56000,\n",
" 'symbol': 'TUGS'},\n",
" {'name': 'Union Bank',\n",
" 'price': {'currency': 'PHP', 'amount': 90.0},\n",
" 'percent_change': -1.64,\n",
" 'volume': 26940,\n",
" 'symbol': 'UBP'},\n",
" {'name': 'United Paragon',\n",
" 'price': {'currency': 'PHP', 'amount': 0.0065},\n",
" 'percent_change': -1.52,\n",
" 'volume': 8000000,\n",
" 'symbol': 'UPM'},\n",
" {'name': 'Univ Robina',\n",
" 'price': {'currency': 'PHP', 'amount': 117.0},\n",
" 'percent_change': 3.63,\n",
" 'volume': 2188570,\n",
" 'symbol': 'URC'},\n",
" {'name': 'IVantage',\n",
" 'price': {'currency': 'PHP', 'amount': 0.77},\n",
" 'percent_change': 0.0,\n",
" 'volume': 218000,\n",
" 'symbol': 'V'},\n",
" {'name': 'Vitarich',\n",
" 'price': {'currency': 'PHP', 'amount': 0.61},\n",
" 'percent_change': -3.17,\n",
" 'volume': 49000,\n",
" 'symbol': 'VITA'},\n",
" {'name': 'Vista Land',\n",
" 'price': {'currency': 'PHP', 'amount': 2.59},\n",
" 'percent_change': 0.0,\n",
" 'volume': 5403000,\n",
" 'symbol': 'VLL'},\n",
" {'name': 'Victorias ',\n",
" 'price': {'currency': 'PHP', 'amount': 2.42},\n",
" 'percent_change': -1.22,\n",
" 'volume': 5000,\n",
" 'symbol': 'VMC'},\n",
" {'name': 'Vulcan Ind`l',\n",
" 'price': {'currency': 'PHP', 'amount': 1.02},\n",
" 'percent_change': -3.77,\n",
" 'volume': 1783000,\n",
" 'symbol': 'VUL'},\n",
" {'name': 'PhilWeb',\n",
" 'price': {'currency': 'PHP', 'amount': 2.1},\n",
" 'percent_change': -1.87,\n",
" 'volume': 104000,\n",
" 'symbol': 'WEB'},\n",
" {'name': 'WILCON DEPOT',\n",
" 'price': {'currency': 'PHP', 'amount': 26.3},\n",
" 'percent_change': 0.38,\n",
" 'volume': 1117900,\n",
" 'symbol': 'WLCON'},\n",
" {'name': 'Waterfront',\n",
" 'price': {'currency': 'PHP', 'amount': 0.43},\n",
" 'percent_change': 0.0,\n",
" 'volume': 30000,\n",
" 'symbol': 'WPI'},\n",
" {'name': 'XURPAS',\n",
" 'price': {'currency': 'PHP', 'amount': 0.34},\n",
" 'percent_change': 0.0,\n",
" 'volume': 300000,\n",
" 'symbol': 'X'},\n",
" {'name': 'Zeus Holdings',\n",
" 'price': {'currency': 'PHP', 'amount': 0.162},\n",
" 'percent_change': 0.0,\n",
" 'volume': 80000,\n",
" 'symbol': 'ZHI'},\n",
" {'name': 'PSEi',\n",
" 'price': {'currency': 'PHP', 'amount': 42.23},\n",
" 'percent_change': 0.6,\n",
" 'volume': 7124,\n",
" 'symbol': 'PSEi'},\n",
" {'name': 'All Shares',\n",
" 'price': {'currency': 'PHP', 'amount': 15.24},\n",
" 'percent_change': 0.4,\n",
" 'volume': 3774,\n",
" 'symbol': 'ALL'},\n",
" {'name': 'Financials',\n",
" 'price': {'currency': 'PHP', 'amount': 21.01},\n",
" 'percent_change': 1.27,\n",
" 'volume': 1675,\n",
" 'symbol': 'FIN'},\n",
" {'name': 'Industrial',\n",
" 'price': {'currency': 'PHP', 'amount': 34.91},\n",
" 'percent_change': 0.37,\n",
" 'volume': 9567,\n",
" 'symbol': 'IND'},\n",
" {'name': 'Holding Firms',\n",
" 'price': {'currency': 'PHP', 'amount': 26.68},\n",
" 'percent_change': 0.4,\n",
" 'volume': 6783,\n",
" 'symbol': 'HDG'},\n",
" {'name': 'Property',\n",
" 'price': {'currency': 'PHP', 'amount': -8.59},\n",
" 'percent_change': -0.26,\n",
" 'volume': 3336,\n",
" 'symbol': 'PRO'},\n",
" {'name': 'Services',\n",
" 'price': {'currency': 'PHP', 'amount': 23.65},\n",
" 'percent_change': 1.24,\n",
" 'volume': 1931,\n",
" 'symbol': 'SVC'},\n",
" {'name': 'Mining and Oil',\n",
" 'price': {'currency': 'PHP', 'amount': -73.5},\n",
" 'percent_change': -0.57,\n",
" 'volume': 12881,\n",
" 'symbol': 'M-O'}],\n",
" 'as_of': '2022-03-25T14:50:00+08:00'}"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#整包資料\n",
"data"
]
},
{
"cell_type": "code",
"execution_count": 4,
"id": "c6f7a880",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[{'name': '2GO Group',\n",
" 'price': {'currency': 'PHP', 'amount': 7.29},\n",
" 'percent_change': -0.14,\n",
" 'volume': 2400,\n",
" 'symbol': '2GO'},\n",
" {'name': 'HOUSE PREF B',\n",
" 'price': {'currency': 'PHP', 'amount': 101.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 50000,\n",
" 'symbol': '8990B'},\n",
" {'name': 'HOUSE PREF A',\n",
" 'price': {'currency': 'PHP', 'amount': 100.0},\n",
" 'percent_change': 0.2,\n",
" 'volume': 500,\n",
" 'symbol': '8990P'},\n",
" {'name': 'Atok A',\n",
" 'price': {'currency': 'PHP', 'amount': 5.93},\n",
" 'percent_change': 0.68,\n",
" 'volume': 5700,\n",
" 'symbol': 'AB'},\n",
" {'name': 'ABACORE CAPITAL',\n",
" 'price': {'currency': 'PHP', 'amount': 1.03},\n",
" 'percent_change': 1.98,\n",
" 'volume': 34663000,\n",
" 'symbol': 'ABA'},\n",
" {'name': 'Asiabest Gorup',\n",
" 'price': {'currency': 'PHP', 'amount': 3.52},\n",
" 'percent_change': -8.09,\n",
" 'volume': 13000,\n",
" 'symbol': 'ABG'},\n",
" {'name': 'ABS-CBN',\n",
" 'price': {'currency': 'PHP', 'amount': 12.92},\n",
" 'percent_change': 2.54,\n",
" 'volume': 178300,\n",
" 'symbol': 'ABS'},\n",
" {'name': 'ABS-CBN PDR',\n",
" 'price': {'currency': 'PHP', 'amount': 11.9},\n",
" 'percent_change': 2.59,\n",
" 'volume': 23300,\n",
" 'symbol': 'ABSP'},\n",
" {'name': 'Ayala Corp',\n",
" 'price': {'currency': 'PHP', 'amount': 817.5},\n",
" 'percent_change': -0.18,\n",
" 'volume': 105140,\n",
" 'symbol': 'AC'},\n",
" {'name': 'AC ENERGY',\n",
" 'price': {'currency': 'PHP', 'amount': 8.3},\n",
" 'percent_change': 1.84,\n",
" 'volume': 18210300,\n",
" 'symbol': 'ACEN'},\n",
" {'name': 'AC ENEXOR',\n",
" 'price': {'currency': 'PHP', 'amount': 17.14},\n",
" 'percent_change': 6.46,\n",
" 'volume': 256100,\n",
" 'symbol': 'ACEX'},\n",
" {'name': 'AC PREF B1',\n",
" 'price': {'currency': 'PHP', 'amount': 510.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 70,\n",
" 'symbol': 'ACPB1'},\n",
" {'name': 'Alsons Cons',\n",
" 'price': {'currency': 'PHP', 'amount': 1.06},\n",
" 'percent_change': -2.75,\n",
" 'volume': 10000,\n",
" 'symbol': 'ACR'},\n",
" {'name': 'Aboitiz',\n",
" 'price': {'currency': 'PHP', 'amount': 58.95},\n",
" 'percent_change': 1.64,\n",
" 'volume': 617250,\n",
" 'symbol': 'AEV'},\n",
" {'name': 'Alliance Global',\n",
" 'price': {'currency': 'PHP', 'amount': 12.9},\n",
" 'percent_change': -0.77,\n",
" 'volume': 539200,\n",
" 'symbol': 'AGI'},\n",
" {'name': 'Arthaland',\n",
" 'price': {'currency': 'PHP', 'amount': 0.59},\n",
" 'percent_change': 0.0,\n",
" 'volume': 5000,\n",
" 'symbol': 'ALCO'},\n",
" {'name': 'Ayala Land',\n",
" 'price': {'currency': 'PHP', 'amount': 36.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 8273400,\n",
" 'symbol': 'ALI'},\n",
" {'name': 'ALLDAY',\n",
" 'price': {'currency': 'PHP', 'amount': 0.475},\n",
" 'percent_change': 0.0,\n",
" 'volume': 7210000,\n",
" 'symbol': 'ALLDY'},\n",
" {'name': 'AYALA LAND LOG',\n",
" 'price': {'currency': 'PHP', 'amount': 4.93},\n",
" 'percent_change': 1.44,\n",
" 'volume': 659000,\n",
" 'symbol': 'ALLHC'},\n",
" {'name': 'AgriNurture',\n",
" 'price': {'currency': 'PHP', 'amount': 5.22},\n",
" 'percent_change': 0.0,\n",
" 'volume': 1216700,\n",
" 'symbol': 'ANI'},\n",
" {'name': 'Anscor',\n",
" 'price': {'currency': 'PHP', 'amount': 9.0},\n",
" 'percent_change': 5.26,\n",
" 'volume': 90200,\n",
" 'symbol': 'ANS'},\n",
" {'name': 'Aboitiz Power',\n",
" 'price': {'currency': 'PHP', 'amount': 35.55},\n",
" 'percent_change': 0.28,\n",
" 'volume': 1611900,\n",
" 'symbol': 'AP'},\n",
" {'name': 'AC PREF B2R',\n",
" 'price': {'currency': 'PHP', 'amount': 502.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 3420,\n",
" 'symbol': 'APB2R'},\n",
" {'name': 'APC Group',\n",
" 'price': {'currency': 'PHP', 'amount': 0.226},\n",
" 'percent_change': -0.44,\n",
" 'volume': 10000,\n",
" 'symbol': 'APC'},\n",
" {'name': 'APOLLO GLOBAL',\n",
" 'price': {'currency': 'PHP', 'amount': 0.043},\n",
" 'percent_change': 0.0,\n",
" 'volume': 118600000,\n",
" 'symbol': 'APL'},\n",
" {'name': 'Anglo-Phil Hldg',\n",
" 'price': {'currency': 'PHP', 'amount': 0.91},\n",
" 'percent_change': 0.0,\n",
" 'volume': 605000,\n",
" 'symbol': 'APO'},\n",
" {'name': 'ALTUS PROP',\n",
" 'price': {'currency': 'PHP', 'amount': 16.22},\n",
" 'percent_change': -1.7,\n",
" 'volume': 3800,\n",
" 'symbol': 'APVI'},\n",
" {'name': 'Apex Mining A',\n",
" 'price': {'currency': 'PHP', 'amount': 1.63},\n",
" 'percent_change': -0.61,\n",
" 'volume': 3163000,\n",
" 'symbol': 'APX'},\n",
" {'name': 'AREIT RT',\n",
" 'price': {'currency': 'PHP', 'amount': 46.8},\n",
" 'percent_change': 3.31,\n",
" 'volume': 753700,\n",
" 'symbol': 'AREIT'},\n",
" {'name': 'Atlas Mining',\n",
" 'price': {'currency': 'PHP', 'amount': 7.0},\n",
" 'percent_change': -1.13,\n",
" 'volume': 454600,\n",
" 'symbol': 'AT'},\n",
" {'name': 'Asian Terminals',\n",
" 'price': {'currency': 'PHP', 'amount': 13.9},\n",
" 'percent_change': -0.43,\n",
" 'volume': 1000,\n",
" 'symbol': 'ATI'},\n",
" {'name': 'ATN Holdings A',\n",
" 'price': {'currency': 'PHP', 'amount': 0.63},\n",
" 'percent_change': 3.28,\n",
" 'volume': 6776000,\n",
" 'symbol': 'ATN'},\n",
" {'name': 'ATN Holdings B',\n",
" 'price': {'currency': 'PHP', 'amount': 0.62},\n",
" 'percent_change': -1.59,\n",
" 'volume': 196000,\n",
" 'symbol': 'ATNB'},\n",
" {'name': 'ASIA UNITED',\n",
" 'price': {'currency': 'PHP', 'amount': 43.7},\n",
" 'percent_change': 0.46,\n",
" 'volume': 2500,\n",
" 'symbol': 'AUB'},\n",
" {'name': 'AXELUM',\n",
" 'price': {'currency': 'PHP', 'amount': 2.62},\n",
" 'percent_change': 4.8,\n",
" 'volume': 233000,\n",
" 'symbol': 'AXLM'},\n",
" {'name': 'Prime Gaming',\n",
" 'price': {'currency': 'PHP', 'amount': 5.59},\n",
" 'percent_change': 0.0,\n",
" 'volume': 3000,\n",
" 'symbol': 'BCOR'},\n",
" {'name': 'Banco de Oro',\n",
" 'price': {'currency': 'PHP', 'amount': 132.5},\n",
" 'percent_change': 1.92,\n",
" 'volume': 1569250,\n",
" 'symbol': 'BDO'},\n",
" {'name': 'Belle Corp.',\n",
" 'price': {'currency': 'PHP', 'amount': 1.31},\n",
" 'percent_change': -1.5,\n",
" 'volume': 23000,\n",
" 'symbol': 'BEL'},\n",
" {'name': 'Bright Kindle',\n",
" 'price': {'currency': 'PHP', 'amount': 2.11},\n",
" 'percent_change': 2.93,\n",
" 'volume': 772000,\n",
" 'symbol': 'BKR'},\n",
" {'name': 'Bloomberry',\n",
" 'price': {'currency': 'PHP', 'amount': 6.29},\n",
" 'percent_change': 1.13,\n",
" 'volume': 11784800,\n",
" 'symbol': 'BLOOM'},\n",
" {'name': 'BPI',\n",
" 'price': {'currency': 'PHP', 'amount': 99.9},\n",
" 'percent_change': 0.91,\n",
" 'volume': 895640,\n",
" 'symbol': 'BPI'},\n",
" {'name': 'A. Brown',\n",
" 'price': {'currency': 'PHP', 'amount': 0.93},\n",
" 'percent_change': 1.09,\n",
" 'volume': 1025000,\n",
" 'symbol': 'BRN'},\n",
" {'name': 'BRN PREF A',\n",
" 'price': {'currency': 'PHP', 'amount': 105.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 200,\n",
" 'symbol': 'BRNP'},\n",
" {'name': 'BASIC ENERGY',\n",
" 'price': {'currency': 'PHP', 'amount': 0.42},\n",
" 'percent_change': -2.33,\n",
" 'volume': 2120000,\n",
" 'symbol': 'BSC'},\n",
" {'name': 'CHELSEA',\n",
" 'price': {'currency': 'PHP', 'amount': 1.57},\n",
" 'percent_change': 0.0,\n",
" 'volume': 73000,\n",
" 'symbol': 'C'},\n",
" {'name': 'Concrete A',\n",
" 'price': {'currency': 'PHP', 'amount': 48.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 1600,\n",
" 'symbol': 'CA'},\n",
" {'name': 'Cityland Devt.',\n",
" 'price': {'currency': 'PHP', 'amount': 0.71},\n",
" 'percent_change': 1.43,\n",
" 'volume': 6000,\n",
" 'symbol': 'CDC'},\n",
" {'name': '5J',\n",
" 'price': {'currency': 'PHP', 'amount': 44.2},\n",
" 'percent_change': -0.45,\n",
" 'volume': 75600,\n",
" 'symbol': 'CEB'},\n",
" {'name': 'CEB PREF',\n",
" 'price': {'currency': 'PHP', 'amount': 44.0},\n",
" 'percent_change': 0.92,\n",
" 'volume': 1700,\n",
" 'symbol': 'CEBCP'},\n",
" {'name': 'Crown Equities',\n",
" 'price': {'currency': 'PHP', 'amount': 0.093},\n",
" 'percent_change': 3.33,\n",
" 'volume': 80000,\n",
" 'symbol': 'CEI'},\n",
" {'name': 'Chinabank',\n",
" 'price': {'currency': 'PHP', 'amount': 26.4},\n",
" 'percent_change': -1.12,\n",
" 'volume': 329000,\n",
" 'symbol': 'CHIB'},\n",
" {'name': 'Cemex Hldg',\n",
" 'price': {'currency': 'PHP', 'amount': 0.9},\n",
" 'percent_change': 1.12,\n",
" 'volume': 483000,\n",
" 'symbol': 'CHP'},\n",
" {'name': 'CONCEPCION',\n",
" 'price': {'currency': 'PHP', 'amount': 20.0},\n",
" 'percent_change': -2.2,\n",
" 'volume': 500,\n",
" 'symbol': 'CIC'},\n",
" {'name': 'CEB LANDMASTERS',\n",
" 'price': {'currency': 'PHP', 'amount': 2.97},\n",
" 'percent_change': 0.0,\n",
" 'volume': 594000,\n",
" 'symbol': 'CLI'},\n",
" {'name': 'CENTURY FOOD',\n",
" 'price': {'currency': 'PHP', 'amount': 21.5},\n",
" 'percent_change': -1.38,\n",
" 'volume': 222700,\n",
" 'symbol': 'CNPF'},\n",
" {'name': 'CONVERGE',\n",
" 'price': {'currency': 'PHP', 'amount': 28.5},\n",
" 'percent_change': 2.52,\n",
" 'volume': 16870100,\n",
" 'symbol': 'CNVRG'},\n",
" {'name': 'COL Financial',\n",
" 'price': {'currency': 'PHP', 'amount': 3.9},\n",
" 'percent_change': 0.0,\n",
" 'volume': 30000,\n",
" 'symbol': 'COL'},\n",
" {'name': 'COSCO CAPITAL',\n",
" 'price': {'currency': 'PHP', 'amount': 5.02},\n",
" 'percent_change': 0.8,\n",
" 'volume': 985000,\n",
" 'symbol': 'COSCO'},\n",
" {'name': 'CPG',\n",
" 'price': {'currency': 'PHP', 'amount': 0.41},\n",
" 'percent_change': 0.0,\n",
" 'volume': 490000,\n",
" 'symbol': 'CPG'},\n",
" {'name': 'CENTURY PEAK',\n",
" 'price': {'currency': 'PHP', 'amount': 2.72},\n",
" 'percent_change': -1.09,\n",
" 'volume': 135000,\n",
" 'symbol': 'CPM'},\n",
" {'name': 'CITICORE RT',\n",
" 'price': {'currency': 'PHP', 'amount': 2.68},\n",
" 'percent_change': 2.68,\n",
" 'volume': 4394000,\n",
" 'symbol': 'CREIT'},\n",
" {'name': 'CROWN ASIA',\n",
" 'price': {'currency': 'PHP', 'amount': 1.8},\n",
" 'percent_change': -4.26,\n",
" 'volume': 218000,\n",
" 'symbol': 'CROWN'},\n",
" {'name': 'DOUBLEDRAGON',\n",
" 'price': {'currency': 'PHP', 'amount': 8.88},\n",
" 'percent_change': -1.33,\n",
" 'volume': 310400,\n",
" 'symbol': 'DD'},\n",
" {'name': 'DDMP RT',\n",
" 'price': {'currency': 'PHP', 'amount': 1.6},\n",
" 'percent_change': 1.27,\n",
" 'volume': 2021000,\n",
" 'symbol': 'DDMPR'},\n",
" {'name': 'DD PREF',\n",
" 'price': {'currency': 'PHP', 'amount': 101.0},\n",
" 'percent_change': 0.5,\n",
" 'volume': 48220,\n",
" 'symbol': 'DDPR'},\n",
" {'name': 'DEL MONTE',\n",
" 'price': {'currency': 'PHP', 'amount': 14.56},\n",
" 'percent_change': 3.12,\n",
" 'volume': 12300,\n",
" 'symbol': 'DELM'},\n",
" {'name': 'Diversified',\n",
" 'price': {'currency': 'PHP', 'amount': 2.41},\n",
" 'percent_change': -2.43,\n",
" 'volume': 34000,\n",
" 'symbol': 'DFNN'},\n",
" {'name': 'ISM Comm.',\n",
" 'price': {'currency': 'PHP', 'amount': 5.14},\n",
" 'percent_change': -1.91,\n",
" 'volume': 4600800,\n",
" 'symbol': 'DITO'},\n",
" {'name': 'DMCI Holdings',\n",
" 'price': {'currency': 'PHP', 'amount': 9.04},\n",
" 'percent_change': -0.22,\n",
" 'volume': 7372000,\n",
" 'symbol': 'DMC'},\n",
" {'name': 'DM WENCESLAO',\n",
" 'price': {'currency': 'PHP', 'amount': 6.89},\n",
" 'percent_change': 0.0,\n",
" 'volume': 24000,\n",
" 'symbol': 'DMW'},\n",
" {'name': 'DNL INDUS',\n",
" 'price': {'currency': 'PHP', 'amount': 7.94},\n",
" 'percent_change': 3.66,\n",
" 'volume': 4773600,\n",
" 'symbol': 'DNL'},\n",
" {'name': 'DISCOVERY WORLD',\n",
" 'price': {'currency': 'PHP', 'amount': 1.6},\n",
" 'percent_change': 5.96,\n",
" 'volume': 612000,\n",
" 'symbol': 'DWC'},\n",
" {'name': 'EAGLE CEMENT',\n",
" 'price': {'currency': 'PHP', 'amount': 13.08},\n",
" 'percent_change': -3.82,\n",
" 'volume': 12500,\n",
" 'symbol': 'EAGLE'},\n",
" {'name': 'Easycall',\n",
" 'price': {'currency': 'PHP', 'amount': 4.05},\n",
" 'percent_change': -9.4,\n",
" 'volume': 1000,\n",
" 'symbol': 'ECP'},\n",
" {'name': 'EEI Corp.',\n",
" 'price': {'currency': 'PHP', 'amount': 6.0},\n",
" 'percent_change': 2.21,\n",
" 'volume': 88000,\n",
" 'symbol': 'EEI'},\n",
" {'name': 'EEI PREF B',\n",
" 'price': {'currency': 'PHP', 'amount': 109.7},\n",
" 'percent_change': -0.18,\n",
" 'volume': 9000,\n",
" 'symbol': 'EEIPB'},\n",
" {'name': 'Empire East',\n",
" 'price': {'currency': 'PHP', 'amount': 0.233},\n",
" 'percent_change': -2.92,\n",
" 'volume': 50000,\n",
" 'symbol': 'ELI'},\n",
" {'name': 'EMPERADOR',\n",
" 'price': {'currency': 'PHP', 'amount': 14.64},\n",
" 'percent_change': 0.14,\n",
" 'volume': 6467600,\n",
" 'symbol': 'EMP'},\n",
" {'name': 'Euromed',\n",
" 'price': {'currency': 'PHP', 'amount': 1.1},\n",
" 'percent_change': -5.98,\n",
" 'volume': 138000,\n",
" 'symbol': 'EURO'},\n",
" {'name': 'Ever-Gotesco',\n",
" 'price': {'currency': 'PHP', 'amount': 0.275},\n",
" 'percent_change': -1.79,\n",
" 'volume': 2570000,\n",
" 'symbol': 'EVER'},\n",
" {'name': 'EW',\n",
" 'price': {'currency': 'PHP', 'amount': 8.4},\n",
" 'percent_change': 0.24,\n",
" 'volume': 66100,\n",
" 'symbol': 'EW'},\n",
" {'name': 'Purefoods',\n",
" 'price': {'currency': 'PHP', 'amount': 63.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 28440,\n",
" 'symbol': 'FB'},\n",
" {'name': 'FIGARO COFFEE',\n",
" 'price': {'currency': 'PHP', 'amount': 0.62},\n",
" 'percent_change': -3.12,\n",
" 'volume': 10030000,\n",
" 'symbol': 'FCG'},\n",
" {'name': 'Filinvest Dev.',\n",
" 'price': {'currency': 'PHP', 'amount': 6.79},\n",
" 'percent_change': 0.59,\n",
" 'volume': 24000,\n",
" 'symbol': 'FDC'},\n",
" {'name': 'Far Eastern U.',\n",
" 'price': {'currency': 'PHP', 'amount': 530.0},\n",
" 'percent_change': -0.09,\n",
" 'volume': 790,\n",
" 'symbol': 'FEU'},\n",
" {'name': 'Filipino Fund',\n",
" 'price': {'currency': 'PHP', 'amount': 6.55},\n",
" 'percent_change': 0.0,\n",
" 'volume': 300,\n",
" 'symbol': 'FFI'},\n",
" {'name': 'First Gen',\n",
" 'price': {'currency': 'PHP', 'amount': 25.6},\n",
" 'percent_change': 3.02,\n",
" 'volume': 391300,\n",
" 'symbol': 'FGEN'},\n",
" {'name': 'FILINVEST RT',\n",
" 'price': {'currency': 'PHP', 'amount': 7.16},\n",
" 'percent_change': 0.14,\n",
" 'volume': 6574300,\n",
" 'symbol': 'FILRT'},\n",
" {'name': 'F&J Prince A',\n",
" 'price': {'currency': 'PHP', 'amount': 2.29},\n",
" 'percent_change': -8.4,\n",
" 'volume': 34000,\n",
" 'symbol': 'FJP'},\n",
" {'name': 'Filinvest Land',\n",
" 'price': {'currency': 'PHP', 'amount': 1.07},\n",
" 'percent_change': 2.88,\n",
" 'volume': 957000,\n",
" 'symbol': 'FLI'},\n",
" {'name': 'FIRST METRO ETF',\n",
" 'price': {'currency': 'PHP', 'amount': 108.4},\n",
" 'percent_change': 0.37,\n",
" 'volume': 8580,\n",
" 'symbol': 'FMETF'},\n",
" {'name': 'FERRONICKEL',\n",
" 'price': {'currency': 'PHP', 'amount': 2.93},\n",
" 'percent_change': 0.34,\n",
" 'volume': 10300000,\n",
" 'symbol': 'FNI'},\n",
" {'name': 'Tuna',\n",
" 'price': {'currency': 'PHP', 'amount': 0.6},\n",
" 'percent_change': 0.0,\n",
" 'volume': 16000,\n",
" 'symbol': 'FOOD'},\n",
" {'name': 'First Phil Hldg',\n",
" 'price': {'currency': 'PHP', 'amount': 69.55},\n",
" 'percent_change': -0.5,\n",
" 'volume': 2910,\n",
" 'symbol': 'FPH'},\n",
" {'name': 'FRUITAS HLDG',\n",
" 'price': {'currency': 'PHP', 'amount': 1.12},\n",
" 'percent_change': 0.0,\n",
" 'volume': 687000,\n",
" 'symbol': 'FRUIT'},\n",
" {'name': 'GEOGRACE',\n",
" 'price': {'currency': 'PHP', 'amount': 0.187},\n",
" 'percent_change': 0.0,\n",
" 'volume': 10000,\n",
" 'symbol': 'GEO'},\n",
" {'name': 'Globe Telecom',\n",
" 'price': {'currency': 'PHP', 'amount': 2638.0},\n",
" 'percent_change': 3.05,\n",
" 'volume': 68560,\n",
" 'symbol': 'GLO'},\n",
" {'name': 'GMA Network',\n",
" 'price': {'currency': 'PHP', 'amount': 15.9},\n",
" 'percent_change': 0.76,\n",
" 'volume': 13149300,\n",
" 'symbol': 'GMA7'},\n",
" {'name': 'GMA Holdings',\n",
" 'price': {'currency': 'PHP', 'amount': 14.96},\n",
" 'percent_change': -0.27,\n",
" 'volume': 474600,\n",
" 'symbol': 'GMAP'},\n",
" {'name': 'Grand Plaza',\n",
" 'price': {'currency': 'PHP', 'amount': 13.46},\n",
" 'percent_change': -6.53,\n",
" 'volume': 500,\n",
" 'symbol': 'GPH'},\n",
" {'name': 'GREEN',\n",
" 'price': {'currency': 'PHP', 'amount': 1.79},\n",
" 'percent_change': 2.29,\n",
" 'volume': 13319000,\n",
" 'symbol': 'GREEN'},\n",
" {'name': 'Ginebra',\n",
" 'price': {'currency': 'PHP', 'amount': 108.0},\n",
" 'percent_change': -0.92,\n",
" 'volume': 13860,\n",
" 'symbol': 'GSMI'},\n",
" {'name': 'GT Capital',\n",
" 'price': {'currency': 'PHP', 'amount': 506.5},\n",
" 'percent_change': 0.3,\n",
" 'volume': 137880,\n",
" 'symbol': 'GTCAP'},\n",
" {'name': 'GTCAP PREF B',\n",
" 'price': {'currency': 'PHP', 'amount': 1019.0},\n",
" 'percent_change': -1.92,\n",
" 'volume': 1215,\n",
" 'symbol': 'GTPPB'},\n",
" {'name': 'Holcim',\n",
" 'price': {'currency': 'PHP', 'amount': 5.74},\n",
" 'percent_change': 3.42,\n",
" 'volume': 41100,\n",
" 'symbol': 'HLCM'},\n",
" {'name': 'ALLHOME',\n",
" 'price': {'currency': 'PHP', 'amount': 7.45},\n",
" 'percent_change': 0.68,\n",
" 'volume': 505600,\n",
" 'symbol': 'HOME'},\n",
" {'name': '8990 HLDG',\n",
" 'price': {'currency': 'PHP', 'amount': 13.88},\n",
" 'percent_change': 0.29,\n",
" 'volume': 80800,\n",
" 'symbol': 'HOUSE'},\n",
" {'name': 'HAUS TALK',\n",
" 'price': {'currency': 'PHP', 'amount': 1.18},\n",
" 'percent_change': 1.72,\n",
" 'volume': 4094000,\n",
" 'symbol': 'HTI'},\n",
" {'name': 'GOLDEN MV',\n",
" 'price': {'currency': 'PHP', 'amount': 678.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 120,\n",
" 'symbol': 'HVN'},\n",
" {'name': 'IRemit',\n",
" 'price': {'currency': 'PHP', 'amount': 0.79},\n",
" 'percent_change': -3.66,\n",
" 'volume': 3000,\n",
" 'symbol': 'I'},\n",
" {'name': 'Intl Container',\n",
" 'price': {'currency': 'PHP', 'amount': 224.0},\n",
" 'percent_change': 0.9,\n",
" 'volume': 930540,\n",
" 'symbol': 'ICT'},\n",
" {'name': 'Italpinas',\n",
" 'price': {'currency': 'PHP', 'amount': 0.91},\n",
" 'percent_change': -1.09,\n",
" 'volume': 151000,\n",
" 'symbol': 'IDC'},\n",
" {'name': 'Integ. Micro',\n",
" 'price': {'currency': 'PHP', 'amount': 8.1},\n",
" 'percent_change': 0.25,\n",
" 'volume': 70900,\n",
" 'symbol': 'IMI'},\n",
" {'name': 'Ionics',\n",
" 'price': {'currency': 'PHP', 'amount': 0.7},\n",
" 'percent_change': 0.0,\n",
" 'volume': 12000,\n",
" 'symbol': 'ION'},\n",
" {'name': 'IPM HLDG',\n",
" 'price': {'currency': 'PHP', 'amount': 6.7},\n",
" 'percent_change': 0.0,\n",
" 'volume': 2500,\n",
" 'symbol': 'IPM'},\n",
" {'name': 'IPeople',\n",
" 'price': {'currency': 'PHP', 'amount': 6.7},\n",
" 'percent_change': 0.15,\n",
" 'volume': 9700,\n",
" 'symbol': 'IPO'},\n",
" {'name': 'PHIL INFRADEV',\n",
" 'price': {'currency': 'PHP', 'amount': 0.95},\n",
" 'percent_change': 1.06,\n",
" 'volume': 79000,\n",
" 'symbol': 'IRC'},\n",
" {'name': 'Jollibee',\n",
" 'price': {'currency': 'PHP', 'amount': 214.0},\n",
" 'percent_change': 0.47,\n",
" 'volume': 333260,\n",
" 'symbol': 'JFC'},\n",
" {'name': 'JFC PREF A',\n",
" 'price': {'currency': 'PHP', 'amount': 985.0},\n",
" 'percent_change': -0.51,\n",
" 'volume': 50,\n",
" 'symbol': 'JFCPA'},\n",
" {'name': 'JG Summit',\n",
" 'price': {'currency': 'PHP', 'amount': 58.0},\n",
" 'percent_change': -1.69,\n",
" 'volume': 567840,\n",
" 'symbol': 'JGS'},\n",
" {'name': 'KEEPERS HLDG',\n",
" 'price': {'currency': 'PHP', 'amount': 1.2},\n",
" 'percent_change': 0.0,\n",
" 'volume': 4740000,\n",
" 'symbol': 'KEEPR'},\n",
" {'name': 'City & Land',\n",
" 'price': {'currency': 'PHP', 'amount': 0.82},\n",
" 'percent_change': 0.0,\n",
" 'volume': 62000,\n",
" 'symbol': 'LAND'},\n",
" {'name': 'Lepanto A',\n",
" 'price': {'currency': 'PHP', 'amount': 0.158},\n",
" 'percent_change': 0.0,\n",
" 'volume': 4190000,\n",
" 'symbol': 'LC'},\n",
" {'name': 'Lepanto B',\n",
" 'price': {'currency': 'PHP', 'amount': 0.156},\n",
" 'percent_change': -2.5,\n",
" 'volume': 6620000,\n",
" 'symbol': 'LCB'},\n",
" {'name': 'Liberty Flour',\n",
" 'price': {'currency': 'PHP', 'amount': 25.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 100,\n",
" 'symbol': 'LFM'},\n",
" {'name': 'Leisure',\n",
" 'price': {'currency': 'PHP', 'amount': 1.32},\n",
" 'percent_change': 1.54,\n",
" 'volume': 38000,\n",
" 'symbol': 'LR'},\n",
" {'name': 'LT GROUP',\n",
" 'price': {'currency': 'PHP', 'amount': 8.9},\n",
" 'percent_change': -2.41,\n",
" 'volume': 5847100,\n",
" 'symbol': 'LTG'},\n",
" {'name': 'Manila Mining A',\n",
" 'price': {'currency': 'PHP', 'amount': 0.011},\n",
" 'percent_change': 0.0,\n",
" 'volume': 6900000,\n",
" 'symbol': 'MA'},\n",
" {'name': 'Macroasia',\n",
" 'price': {'currency': 'PHP', 'amount': 5.25},\n",
" 'percent_change': 0.57,\n",
" 'volume': 347000,\n",
" 'symbol': 'MAC'},\n",
" {'name': 'Marcventures',\n",
" 'price': {'currency': 'PHP', 'amount': 1.88},\n",
" 'percent_change': -0.53,\n",
" 'volume': 3216000,\n",
" 'symbol': 'MARC'},\n",
" {'name': 'MAXS GROUP',\n",
" 'price': {'currency': 'PHP', 'amount': 6.18},\n",
" 'percent_change': 1.31,\n",
" 'volume': 47800,\n",
" 'symbol': 'MAXS'},\n",
" {'name': 'Manila Bulletin',\n",
" 'price': {'currency': 'PHP', 'amount': 0.395},\n",
" 'percent_change': -1.25,\n",
" 'volume': 170000,\n",
" 'symbol': 'MB'},\n",
" {'name': 'Metrobank',\n",
" 'price': {'currency': 'PHP', 'amount': 54.55},\n",
" 'percent_change': 3.02,\n",
" 'volume': 2413310,\n",
" 'symbol': 'MBT'},\n",
" {'name': 'MEDILINES',\n",
" 'price': {'currency': 'PHP', 'amount': 0.87},\n",
" 'percent_change': 1.16,\n",
" 'volume': 708000,\n",
" 'symbol': 'MEDIC'},\n",
" {'name': 'Megaworld',\n",
" 'price': {'currency': 'PHP', 'amount': 3.05},\n",
" 'percent_change': -1.61,\n",
" 'volume': 7534000,\n",
" 'symbol': 'MEG'},\n",
" {'name': 'Meralco A',\n",
" 'price': {'currency': 'PHP', 'amount': 369.0},\n",
" 'percent_change': -2.64,\n",
" 'volume': 111060,\n",
" 'symbol': 'MER'},\n",
" {'name': 'Manulife',\n",
" 'price': {'currency': 'PHP', 'amount': 1000.0},\n",
" 'percent_change': -9.58,\n",
" 'volume': 15,\n",
" 'symbol': 'MFC'},\n",
" {'name': 'Manila Jockey',\n",
" 'price': {'currency': 'PHP', 'amount': 1.82},\n",
" 'percent_change': 0.0,\n",
" 'volume': 765000,\n",
" 'symbol': 'MJC'},\n",
" {'name': 'MERRYMART',\n",
" 'price': {'currency': 'PHP', 'amount': 1.87},\n",
" 'percent_change': 0.0,\n",
" 'volume': 889000,\n",
" 'symbol': 'MM'},\n",
" {'name': 'MONDE NISSIN',\n",
" 'price': {'currency': 'PHP', 'amount': 13.5},\n",
" 'percent_change': 0.0,\n",
" 'volume': 6945300,\n",
" 'symbol': 'MONDE'},\n",
" {'name': 'Metro Pac Inv ',\n",
" 'price': {'currency': 'PHP', 'amount': 3.78},\n",
" 'percent_change': -0.26,\n",
" 'volume': 7211000,\n",
" 'symbol': 'MPI'},\n",
" {'name': 'MRC Allied',\n",
" 'price': {'currency': 'PHP', 'amount': 0.255},\n",
" 'percent_change': 2.0,\n",
" 'volume': 2690000,\n",
" 'symbol': 'MRC'},\n",
" {'name': 'MREIT RT',\n",
" 'price': {'currency': 'PHP', 'amount': 18.94},\n",
" 'percent_change': 2.38,\n",
" 'volume': 1553500,\n",
" 'symbol': 'MREIT'},\n",
" {'name': 'Metro Retail',\n",
" 'price': {'currency': 'PHP', 'amount': 1.41},\n",
" 'percent_change': 0.0,\n",
" 'volume': 33000,\n",
" 'symbol': 'MRSGI'},\n",
" {'name': 'Mabuhay Vinyl',\n",
" 'price': {'currency': 'PHP', 'amount': 4.42},\n",
" 'percent_change': 1.14,\n",
" 'volume': 4000,\n",
" 'symbol': 'MVC'},\n",
" {'name': 'Manila Water',\n",
" 'price': {'currency': 'PHP', 'amount': 20.05},\n",
" 'percent_change': -2.43,\n",
" 'volume': 1272600,\n",
" 'symbol': 'MWC'},\n",
" {'name': 'Megawide',\n",
" 'price': {'currency': 'PHP', 'amount': 5.07},\n",
" 'percent_change': -0.78,\n",
" 'volume': 151100,\n",
" 'symbol': 'MWIDE'},\n",
" {'name': 'MWIDE PREF 4',\n",
" 'price': {'currency': 'PHP', 'amount': 100.0},\n",
" 'percent_change': -0.1,\n",
" 'volume': 15000,\n",
" 'symbol': 'MWP4'},\n",
" {'name': 'NiHAO',\n",
" 'price': {'currency': 'PHP', 'amount': 1.03},\n",
" 'percent_change': 0.98,\n",
" 'volume': 102000,\n",
" 'symbol': 'NI'},\n",
" {'name': 'NICKELASIA',\n",
" 'price': {'currency': 'PHP', 'amount': 8.22},\n",
" 'percent_change': -0.12,\n",
" 'volume': 10073600,\n",
" 'symbol': 'NIKL'},\n",
" {'name': 'NOW CORP',\n",
" 'price': {'currency': 'PHP', 'amount': 1.3},\n",
" 'percent_change': 1.56,\n",
" 'volume': 2049000,\n",
" 'symbol': 'NOW'},\n",
" {'name': 'PhilNaRe',\n",
" 'price': {'currency': 'PHP', 'amount': 0.6},\n",
" 'percent_change': -1.64,\n",
" 'volume': 226000,\n",
" 'symbol': 'NRCP'},\n",
" {'name': 'ORNTL PETROL A',\n",
" 'price': {'currency': 'PHP', 'amount': 0.012},\n",
" 'percent_change': 9.09,\n",
" 'volume': 23500000,\n",
" 'symbol': 'OPM'},\n",
" {'name': 'ORNTL PETROL B',\n",
" 'price': {'currency': 'PHP', 'amount': 0.012},\n",
" 'percent_change': 0.0,\n",
" 'volume': 300000,\n",
" 'symbol': 'OPMB'},\n",
" {'name': 'Oriental P',\n",
" 'price': {'currency': 'PHP', 'amount': 1.02},\n",
" 'percent_change': -1.92,\n",
" 'volume': 2247000,\n",
" 'symbol': 'ORE'},\n",
" {'name': 'Philodrill A',\n",
" 'price': {'currency': 'PHP', 'amount': 0.0095},\n",
" 'percent_change': 0.0,\n",
" 'volume': 13000000,\n",
" 'symbol': 'OV'},\n",
" {'name': 'PB BANK',\n",
" 'price': {'currency': 'PHP', 'amount': 9.1},\n",
" 'percent_change': -0.22,\n",
" 'volume': 5200,\n",
" 'symbol': 'PBB'},\n",
" {'name': 'Petron',\n",
" 'price': {'currency': 'PHP', 'amount': 3.31},\n",
" 'percent_change': -1.49,\n",
" 'volume': 614000,\n",
" 'symbol': 'PCOR'},\n",
" {'name': 'PetroEnergy',\n",
" 'price': {'currency': 'PHP', 'amount': 4.97},\n",
" 'percent_change': 0.61,\n",
" 'volume': 8000,\n",
" 'symbol': 'PERC'},\n",
" {'name': 'PUREGOLD',\n",
" 'price': {'currency': 'PHP', 'amount': 32.95},\n",
" 'percent_change': 1.23,\n",
" 'volume': 1267700,\n",
" 'symbol': 'PGOLD'},\n",
" {'name': 'PremiereHorizon',\n",
" 'price': {'currency': 'PHP', 'amount': 0.55},\n",
" 'percent_change': -1.79,\n",
" 'volume': 2251000,\n",
" 'symbol': 'PHA'},\n",
" {'name': 'Phil Estates',\n",
" 'price': {'currency': 'PHP', 'amount': 0.41},\n",
" 'percent_change': 2.5,\n",
" 'volume': 330000,\n",
" 'symbol': 'PHES'},\n",
" {'name': 'Phinma ',\n",
" 'price': {'currency': 'PHP', 'amount': 19.48},\n",
" 'percent_change': -0.1,\n",
" 'volume': 20700,\n",
" 'symbol': 'PHN'},\n",
" {'name': 'PH RESORTS GRP',\n",
" 'price': {'currency': 'PHP', 'amount': 1.03},\n",
" 'percent_change': 0.98,\n",
" 'volume': 1755000,\n",
" 'symbol': 'PHR'},\n",
" {'name': 'SHAKEYS PIZZA',\n",
" 'price': {'currency': 'PHP', 'amount': 7.76},\n",
" 'percent_change': -0.39,\n",
" 'volume': 137100,\n",
" 'symbol': 'PIZZA'},\n",
" {'name': 'PREMIUM LEISURE',\n",
" 'price': {'currency': 'PHP', 'amount': 0.45},\n",
" 'percent_change': 1.12,\n",
" 'volume': 2590000,\n",
" 'symbol': 'PLC'},\n",
" {'name': 'Panasonic',\n",
" 'price': {'currency': 'PHP', 'amount': 6.24},\n",
" 'percent_change': 0.81,\n",
" 'volume': 18300,\n",
" 'symbol': 'PMPC'},\n",
" {'name': 'Phil Natl Bank',\n",
" 'price': {'currency': 'PHP', 'amount': 18.82},\n",
" 'percent_change': -0.53,\n",
" 'volume': 205900,\n",
" 'symbol': 'PNB'},\n",
" {'name': 'PHX PETROLEUM',\n",
" 'price': {'currency': 'PHP', 'amount': 10.6},\n",
" 'percent_change': -0.56,\n",
" 'volume': 7700,\n",
" 'symbol': 'PNX'},\n",
" {'name': 'PNX PREF 3B',\n",
" 'price': {'currency': 'PHP', 'amount': 102.0},\n",
" 'percent_change': -0.2,\n",
" 'volume': 420,\n",
" 'symbol': 'PNX3B'},\n",
" {'name': 'PNX PREF 4',\n",
" 'price': {'currency': 'PHP', 'amount': 970.0},\n",
" 'percent_change': -1.02,\n",
" 'volume': 5500,\n",
" 'symbol': 'PNX4'},\n",
" {'name': 'PCOR PREF 3A',\n",
" 'price': {'currency': 'PHP', 'amount': 1050.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 200,\n",
" 'symbol': 'PRF3A'},\n",
" {'name': 'PCOR PREF 3B',\n",
" 'price': {'currency': 'PHP', 'amount': 1081.0},\n",
" 'percent_change': -0.09,\n",
" 'volume': 970,\n",
" 'symbol': 'PRF3B'},\n",
" {'name': 'Prime Media',\n",
" 'price': {'currency': 'PHP', 'amount': 1.57},\n",
" 'percent_change': -2.48,\n",
" 'volume': 185000,\n",
" 'symbol': 'PRIM'},\n",
" {'name': 'Primex Corp.',\n",
" 'price': {'currency': 'PHP', 'amount': 2.7},\n",
" 'percent_change': 1.5,\n",
" 'volume': 1899000,\n",
" 'symbol': 'PRMX'},\n",
" {'name': 'PSBank',\n",
" 'price': {'currency': 'PHP', 'amount': 55.05},\n",
" 'percent_change': 0.09,\n",
" 'volume': 3760,\n",
" 'symbol': 'PSB'},\n",
" {'name': 'PSE',\n",
" 'price': {'currency': 'PHP', 'amount': 202.0},\n",
" 'percent_change': 1.0,\n",
" 'volume': 10,\n",
" 'symbol': 'PSE'},\n",
" {'name': 'PX MINING',\n",
" 'price': {'currency': 'PHP', 'amount': 5.69},\n",
" 'percent_change': -1.04,\n",
" 'volume': 1297800,\n",
" 'symbol': 'PX'},\n",
" {'name': 'PXP ENERGY',\n",
" 'price': {'currency': 'PHP', 'amount': 5.66},\n",
" 'percent_change': -0.7,\n",
" 'volume': 243000,\n",
" 'symbol': 'PXP'},\n",
" {'name': 'RCBC',\n",
" 'price': {'currency': 'PHP', 'amount': 20.85},\n",
" 'percent_change': 2.46,\n",
" 'volume': 300,\n",
" 'symbol': 'RCB'},\n",
" {'name': 'CADP Group',\n",
" 'price': {'currency': 'PHP', 'amount': 0.6},\n",
" 'percent_change': 0.0,\n",
" 'volume': 1536000,\n",
" 'symbol': 'RCI'},\n",
" {'name': 'RL COMM RT',\n",
" 'price': {'currency': 'PHP', 'amount': 7.38},\n",
" 'percent_change': 0.27,\n",
" 'volume': 3488200,\n",
" 'symbol': 'RCR'},\n",
" {'name': 'Robinsons Land',\n",
" 'price': {'currency': 'PHP', 'amount': 20.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 2582500,\n",
" 'symbol': 'RLC'},\n",
" {'name': 'PhilRealty',\n",
" 'price': {'currency': 'PHP', 'amount': 0.216},\n",
" 'percent_change': 0.47,\n",
" 'volume': 190000,\n",
" 'symbol': 'RLT'},\n",
" {'name': 'ROCK',\n",
" 'price': {'currency': 'PHP', 'amount': 1.47},\n",
" 'percent_change': 0.0,\n",
" 'volume': 3000,\n",
" 'symbol': 'ROCK'},\n",
" {'name': 'Roxas Hldg.',\n",
" 'price': {'currency': 'PHP', 'amount': 1.3},\n",
" 'percent_change': -8.45,\n",
" 'volume': 218000,\n",
" 'symbol': 'ROX'},\n",
" {'name': 'ROBINSONS RTL',\n",
" 'price': {'currency': 'PHP', 'amount': 54.75},\n",
" 'percent_change': 0.55,\n",
" 'volume': 1613580,\n",
" 'symbol': 'RRHI'},\n",
" {'name': 'SBS Phil Corp',\n",
" 'price': {'currency': 'PHP', 'amount': 3.93},\n",
" 'percent_change': 0.77,\n",
" 'volume': 31000,\n",
" 'symbol': 'SBS'},\n",
" {'name': 'Semirara Mining',\n",
" 'price': {'currency': 'PHP', 'amount': 31.6},\n",
" 'percent_change': -0.94,\n",
" 'volume': 1811100,\n",
" 'symbol': 'SCC'},\n",
" {'name': 'Security Bank',\n",
" 'price': {'currency': 'PHP', 'amount': 109.0},\n",
" 'percent_change': -0.82,\n",
" 'volume': 505380,\n",
" 'symbol': 'SECB'},\n",
" {'name': '11-Jul',\n",
" 'price': {'currency': 'PHP', 'amount': 65.25},\n",
" 'percent_change': 0.31,\n",
" 'volume': 15520,\n",
" 'symbol': 'SEVN'},\n",
" {'name': 'TRANSGRID',\n",
" 'price': {'currency': 'PHP', 'amount': 12.26},\n",
" 'percent_change': 0.49,\n",
" 'volume': 1898400,\n",
" 'symbol': 'SGP'},\n",
" {'name': 'PILIPINAS SHELL',\n",
" 'price': {'currency': 'PHP', 'amount': 17.7},\n",
" 'percent_change': -1.56,\n",
" 'volume': 694600,\n",
" 'symbol': 'SHLPH'},\n",
" {'name': 'SHNG Properties',\n",
" 'price': {'currency': 'PHP', 'amount': 2.61},\n",
" 'percent_change': 0.38,\n",
" 'volume': 114000,\n",
" 'symbol': 'SHNG'},\n",
" {'name': 'Sun Life',\n",
" 'price': {'currency': 'PHP', 'amount': 2750.0},\n",
" 'percent_change': 3.7,\n",
" 'volume': 5,\n",
" 'symbol': 'SLF'},\n",
" {'name': 'Sta.Lucia Land',\n",
" 'price': {'currency': 'PHP', 'amount': 2.8},\n",
" 'percent_change': 5.66,\n",
" 'volume': 37000,\n",
" 'symbol': 'SLI'},\n",
" {'name': 'SM Investments ',\n",
" 'price': {'currency': 'PHP', 'amount': 897.0},\n",
" 'percent_change': 1.36,\n",
" 'volume': 203940,\n",
" 'symbol': 'SM'},\n",
" {'name': 'San Miguel A',\n",
" 'price': {'currency': 'PHP', 'amount': 110.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 535040,\n",
" 'symbol': 'SMC'},\n",
" {'name': 'SMC Pref 2F',\n",
" 'price': {'currency': 'PHP', 'amount': 77.85},\n",
" 'percent_change': -0.19,\n",
" 'volume': 800000,\n",
" 'symbol': 'SMC2F'},\n",
" {'name': 'SMC Pref 2I',\n",
" 'price': {'currency': 'PHP', 'amount': 78.25},\n",
" 'percent_change': 0.0,\n",
" 'volume': 20000,\n",
" 'symbol': 'SMC2I'},\n",
" {'name': 'SMC PREF 2K',\n",
" 'price': {'currency': 'PHP', 'amount': 76.0},\n",
" 'percent_change': 0.0,\n",
" 'volume': 850000,\n",
" 'symbol': 'SMC2K'},\n",
" {'name': 'SM Prime Hldg.',\n",
" 'price': {'currency': 'PHP', 'amount': 37.7},\n",
" 'percent_change': -0.66,\n",
" 'volume': 6312400,\n",
" 'symbol': 'SMPH'},\n",
" {'name': 'SPC POWER',\n",
" 'price': {'currency': 'PHP', 'amount': 14.28},\n",
" 'percent_change': -0.7,\n",
" 'volume': 95200,\n",
" 'symbol': 'SPC'},\n",
" {'name': 'SOLAR PH',\n",
" 'price': {'currency': 'PHP', 'amount': 2.0},\n",
" 'percent_change': 1.52,\n",
" 'volume': 70089000,\n",
" 'symbol': 'SPNEC'},\n",
" {'name': 'SSI GROUP',\n",
" 'price': {'currency': 'PHP', 'amount': 1.06},\n",
" 'percent_change': 0.0,\n",
" 'volume': 94000,\n",
" 'symbol': 'SSI'},\n",
" {'name': 'PHX SEMICNDCTR',\n",
" 'price': {'currency': 'PHP', 'amount': 1.04},\n",
" 'percent_change': 0.97,\n",
" 'volume': 124000,\n",
" 'symbol': 'SSP'},\n",
" {'name': 'STI_HOLDINGS',\n",
" 'price': {'currency': 'PHP', 'amount': 0.36},\n",
" 'percent_change': 1.41,\n",
" 'volume': 290000,\n",
" 'symbol': 'STI'},\n",
" {'name': 'Starmalls',\n",
" 'price': {'currency': 'PHP', 'amount': 3.23},\n",
" 'percent_change': 1.57,\n",
" 'volume': 11000,\n",
" 'symbol': 'STR'},\n",
" {'name': 'TKC METALS',\n",
" 'price': {'currency': 'PHP', 'amount': 0.78},\n",
" 'percent_change': -2.5,\n",
" 'volume': 137000,\n",
" 'symbol': 'T'},\n",
" {'name': 'Transpacific Br',\n",
" 'price': {'currency': 'PHP', 'amount': 0.335},\n",
" 'percent_change': 0.0,\n",
" 'volume': 5120000,\n",
" 'symbol': 'TBGI'},\n",
" {'name': 'TECH PREF B2D',\n",
" 'price': {'currency': 'PHP', 'amount': 54.95},\n",
" 'percent_change': 0.0,\n",
" 'volume': 560,\n",
" 'symbol': 'TCB2D'},\n",
" {'name': 'CHIPS',\n",
" 'price': {'currency': 'PHP', 'amount': 3.19},\n",
" 'percent_change': 0.31,\n",
" 'volume': 228000,\n",
" 'symbol': 'TECH'},\n",
" {'name': 'TECH WARRANT',\n",
" 'price': {'currency': 'PHP', 'amount': 0.63},\n",
" 'percent_change': -1.56,\n",
" 'volume': 132000,\n",
" 'symbol': 'TECHW'},\n",
" {'name': 'PLDT',\n",
" 'price': {'currency': 'PHP', 'amount': 1850.0},\n",
" 'percent_change': 1.04,\n",
" 'volume': 127745,\n",
" 'symbol': 'TEL'},\n",
" {'name': 'TOP FRONTIER',\n",
" 'price': {'currency': 'PHP', 'amount': 119.4},\n",
" 'percent_change': -0.33,\n",
" 'volume': 1120,\n",
" 'symbol': 'TFHI'},\n",
" {'name': 'HARBOR STAR',\n",
" 'price': {'currency': 'PHP', 'amount': 0.74},\n",
" 'percent_change': 0.0,\n",
" 'volume': 56000,\n",
" 'symbol': 'TUGS'},\n",
" {'name': 'Union Bank',\n",
" 'price': {'currency': 'PHP', 'amount': 90.0},\n",
" 'percent_change': -1.64,\n",
" 'volume': 26940,\n",
" 'symbol': 'UBP'},\n",
" {'name': 'United Paragon',\n",
" 'price': {'currency': 'PHP', 'amount': 0.0065},\n",
" 'percent_change': -1.52,\n",
" 'volume': 8000000,\n",
" 'symbol': 'UPM'},\n",
" {'name': 'Univ Robina',\n",
" 'price': {'currency': 'PHP', 'amount': 117.0},\n",
" 'percent_change': 3.63,\n",
" 'volume': 2188570,\n",
" 'symbol': 'URC'},\n",
" {'name': 'IVantage',\n",
" 'price': {'currency': 'PHP', 'amount': 0.77},\n",
" 'percent_change': 0.0,\n",
" 'volume': 218000,\n",
" 'symbol': 'V'},\n",
" {'name': 'Vitarich',\n",
" 'price': {'currency': 'PHP', 'amount': 0.61},\n",
" 'percent_change': -3.17,\n",
" 'volume': 49000,\n",
" 'symbol': 'VITA'},\n",
" {'name': 'Vista Land',\n",
" 'price': {'currency': 'PHP', 'amount': 2.59},\n",
" 'percent_change': 0.0,\n",
" 'volume': 5403000,\n",
" 'symbol': 'VLL'},\n",
" {'name': 'Victorias ',\n",
" 'price': {'currency': 'PHP', 'amount': 2.42},\n",
" 'percent_change': -1.22,\n",
" 'volume': 5000,\n",
" 'symbol': 'VMC'},\n",
" {'name': 'Vulcan Ind`l',\n",
" 'price': {'currency': 'PHP', 'amount': 1.02},\n",
" 'percent_change': -3.77,\n",
" 'volume': 1783000,\n",
" 'symbol': 'VUL'},\n",
" {'name': 'PhilWeb',\n",
" 'price': {'currency': 'PHP', 'amount': 2.1},\n",
" 'percent_change': -1.87,\n",
" 'volume': 104000,\n",
" 'symbol': 'WEB'},\n",
" {'name': 'WILCON DEPOT',\n",
" 'price': {'currency': 'PHP', 'amount': 26.3},\n",
" 'percent_change': 0.38,\n",
" 'volume': 1117900,\n",
" 'symbol': 'WLCON'},\n",
" {'name': 'Waterfront',\n",
" 'price': {'currency': 'PHP', 'amount': 0.43},\n",
" 'percent_change': 0.0,\n",
" 'volume': 30000,\n",
" 'symbol': 'WPI'},\n",
" {'name': 'XURPAS',\n",
" 'price': {'currency': 'PHP', 'amount': 0.34},\n",
" 'percent_change': 0.0,\n",
" 'volume': 300000,\n",
" 'symbol': 'X'},\n",
" {'name': 'Zeus Holdings',\n",
" 'price': {'currency': 'PHP', 'amount': 0.162},\n",
" 'percent_change': 0.0,\n",
" 'volume': 80000,\n",
" 'symbol': 'ZHI'},\n",
" {'name': 'PSEi',\n",
" 'price': {'currency': 'PHP', 'amount': 42.23},\n",
" 'percent_change': 0.6,\n",
" 'volume': 7124,\n",
" 'symbol': 'PSEi'},\n",
" {'name': 'All Shares',\n",
" 'price': {'currency': 'PHP', 'amount': 15.24},\n",
" 'percent_change': 0.4,\n",
" 'volume': 3774,\n",
" 'symbol': 'ALL'},\n",
" {'name': 'Financials',\n",
" 'price': {'currency': 'PHP', 'amount': 21.01},\n",
" 'percent_change': 1.27,\n",
" 'volume': 1675,\n",
" 'symbol': 'FIN'},\n",
" {'name': 'Industrial',\n",
" 'price': {'currency': 'PHP', 'amount': 34.91},\n",
" 'percent_change': 0.37,\n",
" 'volume': 9567,\n",
" 'symbol': 'IND'},\n",
" {'name': 'Holding Firms',\n",
" 'price': {'currency': 'PHP', 'amount': 26.68},\n",
" 'percent_change': 0.4,\n",
" 'volume': 6783,\n",
" 'symbol': 'HDG'},\n",
" {'name': 'Property',\n",
" 'price': {'currency': 'PHP', 'amount': -8.59},\n",
" 'percent_change': -0.26,\n",
" 'volume': 3336,\n",
" 'symbol': 'PRO'},\n",
" {'name': 'Services',\n",
" 'price': {'currency': 'PHP', 'amount': 23.65},\n",
" 'percent_change': 1.24,\n",
" 'volume': 1931,\n",
" 'symbol': 'SVC'},\n",
" {'name': 'Mining and Oil',\n",
" 'price': {'currency': 'PHP', 'amount': -73.5},\n",
" 'percent_change': -0.57,\n",
" 'volume': 12881,\n",
" 'symbol': 'M-O'}]"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#股票資料\n",
"data[\"stock\"]"
]
},
{
"cell_type": "code",
"execution_count": 5,
"id": "89160307",
"metadata": {
"scrolled": true
},
"outputs": [
{
"data": {
"text/plain": [
"'2022-03-25T14:50:00+08:00'"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#時間\n",
"data[\"as_of\"]"
]
},
{
"cell_type": "code",
"execution_count": 6,
"id": "cccb3970",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"<class 'dict'>\n"
]
}
],
"source": [
"print(type(data))"
]
},
{
"cell_type": "code",
"execution_count": 7,
"id": "c60c6098",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"2GO Group\n"
]
}
],
"source": [
"print(data[\"stock\"][0][\"name\"])"
]
},
{
"cell_type": "code",
"execution_count": 8,
"id": "107899d3",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" name percent_change volume symbol price.currency \\\n",
"1 HOUSE PREF B 0.00 50000 8990B PHP \n",
"2 HOUSE PREF A 0.20 500 8990P PHP \n",
"3 Atok A 0.68 5700 AB PHP \n",
"4 ABACORE CAPITAL 1.98 34663000 ABA PHP \n",
"5 Asiabest Gorup -8.09 13000 ABG PHP \n",
"6 ABS-CBN 2.54 178300 ABS PHP \n",
"7 ABS-CBN PDR 2.59 23300 ABSP PHP \n",
"8 Ayala Corp -0.18 105140 AC PHP \n",
"9 AC ENERGY 1.84 18210300 ACEN PHP \n",
"\n",
" price.amount \n",
"1 101.00 \n",
"2 100.00 \n",
"3 5.93 \n",
"4 1.03 \n",
"5 3.52 \n",
"6 12.92 \n",
"7 11.90 \n",
"8 817.50 \n",
"9 8.30 \n"
]
}
],
"source": [
"#把 Json格式轉成 Pandas 的 dataframe格式\n",
"df = json_normalize(data['stock'])\n",
"print(df[1:10])"
]
},
{
"cell_type": "code",
"execution_count": 9,
"id": "f1311df4",
"metadata": {},
"outputs": [],
"source": [
"#資料清洗\n",
"#刪除不要的欄位\n",
"df2=df.drop(columns=['name','price.currency'],axis=1)"
]
},
{
"cell_type": "code",
"execution_count": 10,
"id": "e0678920",
"metadata": {},
"outputs": [],
"source": [
"#改名 多欄 ok\n",
"df2.rename(columns={'percent_change':'change','price.amount': 'amount'},inplace=True)"
]
},
{
"cell_type": "code",
"execution_count": 11,
"id": "cb449245",
"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>symbol</th>\n",
" <th>amount</th>\n",
" <th>change</th>\n",
" <th>volume</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2GO</td>\n",
" <td>7.29</td>\n",
" <td>-0.14</td>\n",
" <td>2400</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>8990B</td>\n",
" <td>101.00</td>\n",
" <td>0.00</td>\n",
" <td>50000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>8990P</td>\n",
" <td>100.00</td>\n",
" <td>0.20</td>\n",
" <td>500</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>AB</td>\n",
" <td>5.93</td>\n",
" <td>0.68</td>\n",
" <td>5700</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>ABA</td>\n",
" <td>1.03</td>\n",
" <td>1.98</td>\n",
" <td>34663000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>232</th>\n",
" <td>IND</td>\n",
" <td>34.91</td>\n",
" <td>0.37</td>\n",
" <td>9567</td>\n",
" </tr>\n",
" <tr>\n",
" <th>233</th>\n",
" <td>HDG</td>\n",
" <td>26.68</td>\n",
" <td>0.40</td>\n",
" <td>6783</td>\n",
" </tr>\n",
" <tr>\n",
" <th>234</th>\n",
" <td>PRO</td>\n",
" <td>-8.59</td>\n",
" <td>-0.26</td>\n",
" <td>3336</td>\n",
" </tr>\n",
" <tr>\n",
" <th>235</th>\n",
" <td>SVC</td>\n",
" <td>23.65</td>\n",
" <td>1.24</td>\n",
" <td>1931</td>\n",
" </tr>\n",
" <tr>\n",
" <th>236</th>\n",
" <td>M-O</td>\n",
" <td>-73.50</td>\n",
" <td>-0.57</td>\n",
" <td>12881</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>237 rows × 4 columns</p>\n",
"</div>"
],
"text/plain": [
" symbol amount change volume\n",
"0 2GO 7.29 -0.14 2400\n",
"1 8990B 101.00 0.00 50000\n",
"2 8990P 100.00 0.20 500\n",
"3 AB 5.93 0.68 5700\n",
"4 ABA 1.03 1.98 34663000\n",
".. ... ... ... ...\n",
"232 IND 34.91 0.37 9567\n",
"233 HDG 26.68 0.40 6783\n",
"234 PRO -8.59 -0.26 3336\n",
"235 SVC 23.65 1.24 1931\n",
"236 M-O -73.50 -0.57 12881\n",
"\n",
"[237 rows x 4 columns]"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#欄位順序\n",
"df2=df2.reindex(columns=['symbol','amount','change','volume'])\n",
"df2"
]
},
{
"cell_type": "code",
"execution_count": 12,
"id": "28f9cac8",
"metadata": {},
"outputs": [],
"source": [
"#指定 index\n",
"df_example = df2.set_index(['symbol'])"
]
},
{
"cell_type": "code",
"execution_count": 13,
"id": "deb6a7e7",
"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>amount</th>\n",
" <th>change</th>\n",
" <th>volume</th>\n",
" </tr>\n",
" <tr>\n",
" <th>symbol</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>NOW</th>\n",
" <td>1.300</td>\n",
" <td>1.56</td>\n",
" <td>2049000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BDO</th>\n",
" <td>132.500</td>\n",
" <td>1.92</td>\n",
" <td>1569250</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DITO</th>\n",
" <td>5.140</td>\n",
" <td>-1.91</td>\n",
" <td>4600800</td>\n",
" </tr>\n",
" <tr>\n",
" <th>EVER</th>\n",
" <td>0.275</td>\n",
" <td>-1.79</td>\n",
" <td>2570000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>JFC</th>\n",
" <td>214.000</td>\n",
" <td>0.47</td>\n",
" <td>333260</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ALI</th>\n",
" <td>36.000</td>\n",
" <td>0.00</td>\n",
" <td>8273400</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DMC</th>\n",
" <td>9.040</td>\n",
" <td>-0.22</td>\n",
" <td>7372000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" amount change volume\n",
"symbol \n",
"NOW 1.300 1.56 2049000\n",
"BDO 132.500 1.92 1569250\n",
"DITO 5.140 -1.91 4600800\n",
"EVER 0.275 -1.79 2570000\n",
"JFC 214.000 0.47 333260\n",
"ALI 36.000 0.00 8273400\n",
"DMC 9.040 -0.22 7372000"
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_example.loc[[\"NOW\",\"BDO\",\"DITO\",\"EVER\",\"JFC\",\"ALI\",\"DMC\"]]"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "c5c2f313",
"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.9.6"
}
},
"nbformat": 4,
"nbformat_minor": 5
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment