PREVIEW / stock_daily / 2012-01-06

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-06.parquet
  size:    197 KB
  rows:    6,149
  symbols: 3,544

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-01-06	AAPL	Stock	14.9918	15.0982	14.9721	15.0857	318292800.0
2012-01-06	MSFT	Stock	27.53	28.19	27.53	28.11	99455500.0
2012-01-06	NVDA	Stock	0.3675	0.3678	0.3592	0.3635	533252000.0
2012-01-06	AMZN	Stock	8.9035	9.2325	8.875	9.1305	140168000.0
2012-01-06	TSLA	Stock	1.8133	1.8527	1.7607	1.794	14794500.0
2012-01-06	TLT	Stock	117.75	118.96	117.71	118.73	7348438.0
2012-01-06	ES	Stock	35.1	35.17	34.66	35.0	2511000.0
2012-01-06	CL	Stock	45.205	45.225	44.695	44.9	3881000.0
2012-01-06	A	Stock	26.5308	26.867	26.3305	26.7525	4711400.0
2012-01-06	AABA-DELISTED	Stock	15.64	15.66	15.46	15.52	13021933.0
2012-01-06	AACC-DELISTED	Stock	4.12	4.185	4.1	4.15	2642.0
2012-01-06	AACG	Stock	7.37	7.4	7.35	7.35	1800.0
2012-01-06	AAIC-DELISTED	Stock	21.07	21.46	20.68	20.68	77700.0
2012-01-06	AAME	Stock	2.0	2.0	1.94	1.98	1900.0
2012-01-06	AAMRQ-DELISTED	Stock	0.3449	0.414	0.33	0.397	24518858.0
2012-01-06	AAON	Stock	6.0207	6.0859	5.9259	5.9556	190688.0
2012-01-06	AAP	Stock	71.29	72.06	70.8	71.5	1346600.0
2012-01-06	AAT	Stock	20.53	20.62	20.35	20.37	94600.0
2012-01-06	AATI-DELISTED	Stock	5.79	5.795	5.78	5.79	421014.0
2012-01-06	AAU-DELISTED	Stock	2.52	2.55	2.51	2.54	21229.0
2012-01-06	AAUAF-DELISTED	Stock	2.52	2.55	2.51	2.54	21429.0
2012-01-06	AAV-DELISTED	Stock	4.32	4.34	4.26	4.27	185542.0
2012-01-06	AAWW-DELISTED	Stock	38.77	39.608	38.505	39.01	186153.0
2012-01-06	AAXJ	Stock	50.6	50.68	50.25	50.42	353608.0
2012-01-06	AAXN-DELISTED	Stock	5.15	5.2	5.07	5.12	203779.0
2012-01-06	AB	Stock	14.77	15.19	14.68	14.88	672200.0
2012-01-06	ABAC-DELISTED	Stock	1.4	1.4	1.35	1.35	2680.0
2012-01-06	ABAX-DELISTED	Stock	28.13	28.28	27.82	27.92	77718.0
2012-01-06	ABB-DELISTED	Stock	19.45	19.45	19.14	19.25	2789064.0
2012-01-06	ABBNY-DELISTED	Stock	19.45	19.45	19.14	19.24	2790064.0
2012-01-06	ABC-DELISTED	Stock	38.5	38.72	38.25	38.59	1774487.0
2012-01-06	ABCB	Stock	10.35	10.74	10.23	10.64	92300.0
2012-01-06	ABCD-DELISTED	Stock	3.15	3.15	3.08	3.1	22999.0
2012-01-06	ABCO-DELISTED	Stock	37.5	37.66	36.69	36.9	464858.0
2012-01-06	ABCW-DELISTED	Stock	0.3815	0.3815	0.3715	0.3815	4430.0
2012-01-06	ABD-DELISTED	Stock	9.37	9.45	9.26	9.33	314270.0
2012-01-06	ABE-DELISTED	Stock	17.66	17.89	17.57	17.81	6779.0
2012-01-06	ABEO	Stock	1737.5	1737.5	1562.5	1700.0	30.0
2012-01-06	ABFS-DELISTED	Stock	19.88	20.38	19.7724	20.32	465771.0
2012-01-06	ABG	Stock	21.75	22.09	21.45	21.57	423900.0
2012-01-06	ABH-DELISTED	Stock	14.91	15.47	14.91	15.33	312546.0
2012-01-06	ABM	Stock	20.17	20.49	20.0	20.36	194900.0
2012-01-06	ABMD-DELISTED	Stock	18.31	18.49	17.98	18.15	232857.0
2012-01-06	ABR	Stock	3.52	3.63	3.43	3.6	48500.0
2012-01-06	ABT	Stock	27.1039	27.1135	26.7728	26.8016	11986244.0
2012-01-06	ABTL-DELISTED	Stock	3.8516	3.8516	3.6458	3.75	70510.0
2012-01-06	ABUS	Stock	1.63	1.74	1.63	1.63	4200.0
2012-01-06	ABV-DELISTED	Stock	35.02	35.09	34.43	34.52	1909977.0
2012-01-06	ABVA-DELISTED	Stock	3.53	3.61	3.53	3.6	2500.0
2012-01-06	ABVT-DELISTED	Stock	64.52	64.94	64.22	64.78	194913.0

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

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