PREVIEW / stock_daily / 2012-08-28

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-28.parquet
  size:    197 KB
  rows:    6,108
  symbols: 3,459

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
2012-08-28	AAPL	Stock	24.1064	24.1464	23.9525	24.1	267416800.0
2012-08-28	MSFT	Stock	30.7	30.8	30.52	30.63	23947900.0
2012-08-28	NVDA	Stock	0.356	0.3608	0.3553	0.3572	310764000.0
2012-08-28	AMZN	Stock	12.1985	12.339	12.15	12.3055	54846000.0
2012-08-28	META	Stock	19.1	19.38	18.95	19.34	25417000.0
2012-08-28	TSLA	Stock	1.8933	1.9587	1.8667	1.9127	21040500.0
2012-08-28	TLT	Stock	125.75	126.36	125.59	125.84	3412537.0
2012-08-28	ES	Stock	37.85	38.16	37.76	38.02	1453000.0
2012-08-28	CL	Stock	52.71	53.33	52.71	53.175	3483600.0
2012-08-28	A	Stock	26.7382	26.7954	26.3948	26.4306	6934919.0
2012-08-28	AABA-DELISTED	Stock	14.87	14.91	14.69	14.7	12478990.0
2012-08-28	AACC-DELISTED	Stock	6.42	6.5	6.38	6.48	14162.0
2012-08-28	AACG	Stock	4.43	4.6	4.38	4.4	3700.0
2012-08-28	AAIC-DELISTED	Stock	22.85	23.0	22.8201	23.0	42780.0
2012-08-28	AAME	Stock	2.67	2.67	2.56	2.67	1400.0
2012-08-28	AAMRQ-DELISTED	Stock	0.4678	0.48	0.466	0.469	1208579.0
2012-08-28	AAON	Stock	5.4222	5.4548	5.4015	5.4311	156938.0
2012-08-28	AAP	Stock	71.39	72.45	70.96	72.09	627600.0
2012-08-28	AAT	Stock	27.0	27.51	26.91	27.47	88200.0
2012-08-28	AAU-DELISTED	Stock	2.7	2.75	2.5	2.52	422848.0
2012-08-28	AAUAF-DELISTED	Stock	2.7	2.75	2.5	2.52	441048.0
2012-08-28	AAV-DELISTED	Stock	3.55	3.59	3.53	3.55	96023.0
2012-08-28	AAWW-DELISTED	Stock	50.66	51.1	49.98	50.47	299194.0
2012-08-28	AAXJ	Stock	53.33	53.44	53.15	53.28	170754.0
2012-08-28	AAXN-DELISTED	Stock	5.44	5.565	5.4	5.55	340784.0
2012-08-28	AB	Stock	13.73	14.29	13.73	14.19	1251600.0
2012-08-28	ABAC-DELISTED	Stock	1.12	1.13	1.0807	1.0807	1300.0
2012-08-28	ABAX-DELISTED	Stock	38.21	38.87	37.83	37.83	78467.0
2012-08-28	ABB-DELISTED	Stock	17.31	17.412	17.27	17.34	1780567.0
2012-08-28	ABBNY-DELISTED	Stock	17.31	17.412	17.27	17.35	1850644.0
2012-08-28	ABC-DELISTED	Stock	37.77	37.81	36.73	37.5	4593421.0
2012-08-28	ABCB	Stock	12.01	12.1	11.85	12.04	31800.0
2012-08-28	ABCO-DELISTED	Stock	42.69	43.78	42.51	43.77	195999.0
2012-08-28	ABCW-DELISTED	Stock	0.4043	0.425	0.36	0.42	75810.0
2012-08-28	ABE-DELISTED	Stock	19.53	19.53	19.4833	19.5	9118.0
2012-08-28	ABEO	Stock	762.5	762.5	750.0	750.0	1.0
2012-08-28	ABFS-DELISTED	Stock	9.38	9.46	9.21	9.27	236446.0
2012-08-28	ABG	Stock	26.71	26.94	26.43	26.82	182800.0
2012-08-28	ABM	Stock	20.34	20.64	20.24	20.34	316200.0
2012-08-28	ABMD-DELISTED	Stock	22.38	22.54	22.1901	22.51	388385.0
2012-08-28	ABR	Stock	5.64	5.69	5.57	5.62	25500.0
2012-08-28	ABT	Stock	31.4509	31.6188	31.2158	31.5373	5737807.0
2012-08-28	ABTL-DELISTED	Stock	3.77	3.81	3.7148	3.78	6434.0
2012-08-28	ABUS	Stock	3.4	3.42	3.34	3.35	8700.0
2012-08-28	ABV-DELISTED	Stock	37.42	37.59	36.99	37.14	1297158.0
2012-08-28	ABVA-DELISTED	Stock	4.56	4.57	4.54	4.55	4100.0
2012-08-28	ABX-DELISTED	Stock	37.66	38.15	37.56	37.72	6577161.0
2012-08-28	ACAD	Stock	1.82	1.82	1.77	1.8	480000.0
2012-08-28	ACAS-DELISTED	Stock	11.14	11.21	11.13	11.18	1526700.0
2012-08-28	ACAT-DELISTED	Stock	43.57	44.36	43.0	44.3	140250.0

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

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