CREATE EXTERNAL TABLE datalake_processed_878695318857_ek_1201695.agg_stockdata(
    total_volume double,
    total_dollars double,
    total_cnt_of_transactions int,
    type string
)
PARTITIONED BY (
    symbol string,
    year int,
    month int,
    day int)
ROW FORMAT SERDE
'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
's3://datalake-processed-878695318857-ek-1201695/agg_stockdata'