Consume yahoo api and use google visualitazation datatable

HTML

<script src="https://www.google.com/jsapi"></script>
<div id="table_div"></div>

JavaScript

function drawTable() {
    // use jQuery to make an AJAX request for data
    $.ajax({
        type: "get",
        dataType: 'json',
        url: 'http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quoteslist%20where%20symbol%3D%27BRDT%2CAPPL%27&format=json&diagnostics=false&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&callback=',
        success: function (data) {
            var dt = new google.visualization.DataTable();
            dt.addColumn('string', 'Symbol');
            dt.addColumn('number', 'Open');

            // parse the JSON into the DataTable
            for (var i = 0; i < data.query.results.quote.length; i++) {
                Symbol = data.query.results.quote[i].Symbol;

                Open = parseFloat(data.query.results.quote[i].Open);
                
                if (isNaN(Open)) {
                    Open = 0;
                }

                dt.addRow([Symbol, Open]);
            }

            var table = new google.visualization.Table(document.querySelector('#table_div'));
            table.draw(dt);
        },
        error: function (e, a, s) {
            alert(s);
        }
    });
}
google.load('visualization', '1', {
    packages: ['table'],
    callback: drawTable
});