application_vnd.jupyter.stderr_output_2.png text_plain_output_3.png text_html_output_1.png text_plain_output_1.png
from bq_helper import BigQueryHelper

from google.cloud import bigquery

import numpy as np
import pandas as pd
from google.cloud import bigquery
from bq_helper import BigQueryHelper
client = bigquery.Client()
query = '\n    #standardSQL\n    SELECT\n        timestamp\n    FROM \n         `bigquery-public-data.bitcoin_blockchain.blocks`\n    ORDER BY\n        timestamp\n    '
bq_assistant = BigQueryHelper('bigquery-public-data', 'bitcoin_blockchain')
df = bq_assistant.query_to_pandas_safe(query, max_gb_scanned=1000)
print('Size of dataframe: {} Bytes'.format(int(df.memory_usage(index=True, deep=True).sum())))
df.head(10)