PREVIEW / stock_daily / 2013-11-27

all stock daily files

  file:    by_date/stock_daily/2013/2013-11-27.parquet
  size:    216 KB
  rows:    6,458
  symbols: 3,553

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2013-11-27	AAPL	Stock	19.1539	19.5	19.05	19.4986	363448400.0
2013-11-27	MSFT	Stock	37.57	37.76	37.49	37.6	26002100.0
2013-11-27	NVDA	Stock	0.3908	0.3938	0.3882	0.3925	181272000.0
2013-11-27	AMZN	Stock	19.175	19.35	19.1305	19.3355	45394000.0
2013-11-27	META	Stock	45.97	46.67	45.53	46.49	44993000.0
2013-11-27	TSLA	Stock	8.0873	8.4633	7.968	8.4627	185514000.0
2013-11-27	TLT	Stock	104.68	104.7	103.96	104.42	6063360.0
2013-11-27	ES	Stock	41.27	41.35	41.07	41.18	1240700.0
2013-11-27	CL	Stock	66.23	66.25	65.44	65.83	1764000.0
2013-11-27	A	Stock	38.4692	38.6266	38.3691	38.4907	1663340.0
2013-11-27	AABA-DELISTED	Stock	36.7	37.12	36.51	36.97	10103361.0
2013-11-27	AACG	Stock	4.09	4.1	4.08	4.08	2900.0
2013-11-27	AAIC-DELISTED	Stock	26.61	26.75	26.42	26.6	106035.0
2013-11-27	AAME	Stock	4.01	4.03	4.01	4.03	4900.0
2013-11-27	AAMRQ-DELISTED	Stock	11.98	12.35	11.93	12.25	11003065.0
2013-11-27	AAOI	Stock	12.5	12.99	12.24	12.96	36200.0
2013-11-27	AAON	Stock	13.5111	13.7378	13.4978	13.5911	181125.0
2013-11-27	AAP	Stock	102.26	102.67	101.41	102.03	400600.0
2013-11-27	AAT	Stock	31.62	31.7	31.28	31.29	158900.0
2013-11-27	AAU-DELISTED	Stock	1.09	1.11	1.07	1.09	65869.0
2013-11-27	AAUAF-DELISTED	Stock	1.08	1.1	1.06	1.09	71981.0
2013-11-27	AAV-DELISTED	Stock	4.02	4.03	3.97	4.0	103558.0
2013-11-27	AAWW-DELISTED	Stock	37.15	38.19	36.92	38.16	321524.0
2013-11-27	AAXJ	Stock	60.23	60.72	60.23	60.62	211582.0
2013-11-27	AAXN-DELISTED	Stock	17.71	17.87	17.43	17.6	837701.0
2013-11-27	AB	Stock	22.14	22.21	21.96	21.99	291700.0
2013-11-27	ABAC-DELISTED	Stock	1.758	1.84	1.75	1.83	11100.0
2013-11-27	ABAX-DELISTED	Stock	35.92	36.39	35.7	36.28	96988.0
2013-11-27	ABB-DELISTED	Stock	25.62	25.67	25.46	25.53	616559.0
2013-11-27	ABBNY-DELISTED	Stock	25.62	25.67	25.46	25.53	627259.0
2013-11-27	ABBV	Stock	48.83	48.95	48.24	48.25	3414900.0
2013-11-27	ABC-DELISTED	Stock	70.59	70.91	70.16	70.5	858322.0
2013-11-27	ABCB	Stock	20.12	20.58	20.12	20.55	47300.0
2013-11-27	ABCD-DELISTED	Stock	1.55	1.59	1.52	1.54	22758.0
2013-11-27	ABCO-DELISTED	Stock	63.26	64.61	63.21	64.59	151672.0
2013-11-27	ABE-DELISTED	Stock	19.58	19.664	19.5404	19.664	3097.0
2013-11-27	ABEO	Stock	325.0	362.5	325.0	362.5	37.0
2013-11-27	ABEV	Stock	7.58	7.59	7.42	7.53	6956100.0
2013-11-27	ABFS-DELISTED	Stock	32.27	32.8999	32.14	32.65	447236.0
2013-11-27	ABG	Stock	51.48	52.0	50.93	51.87	112400.0
2013-11-27	ABGB-DELISTED	Stock	12.26	12.268	11.85	11.87	4806.0
2013-11-27	ABM	Stock	27.99	27.99	27.87	27.95	152800.0
2013-11-27	ABMD-DELISTED	Stock	28.3	28.99	27.81	28.55	299720.0
2013-11-27	ABR	Stock	6.7	6.71	6.59	6.61	35100.0
2013-11-27	ABR.A-DELISTED	Stock	24.501	24.589	24.47	24.589	728.0
2013-11-27	ABR.B-DELISTED	Stock	22.8899	22.8899	22.87	22.87	400.0
2013-11-27	ABT	Stock	38.74	38.74	38.0	38.32	4510100.0
2013-11-27	ABTL-DELISTED	Stock	11.98	12.95	11.9407	12.35	238934.0
2013-11-27	ABUS	Stock	8.04	8.09	7.88	7.99	64500.0
2013-11-27	ABX-DELISTED	Stock	16.46	16.6	16.19	16.36	11157377.0

> showing 50 of 6,458 rows — these rows as CSV

> unlock the full archive -- $79 one-time