PREVIEW / stock_daily / 2012-08-01

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-01.parquet
  size:    197 KB
  rows:    6,098
  symbols: 3,466

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-01	AAPL	Stock	21.9968	22.0143	21.5357	21.6718	384501600.0
2012-08-01	MSFT	Stock	29.59	29.65	29.21	29.41	31721800.0
2012-08-01	NVDA	Stock	0.3405	0.3438	0.3333	0.3348	335912000.0
2012-08-01	AMZN	Stock	11.707	11.719	11.535	11.6045	50876000.0
2012-08-01	META	Stock	21.5	21.58	20.84	20.88	44604400.0
2012-08-01	TSLA	Stock	1.866	1.866	1.7353	1.75	23884500.0
2012-08-01	TLT	Stock	128.53	129.74	128.15	128.78	7972052.0
2012-08-01	ES	Stock	39.52	40.36	39.1	39.1	3418600.0
2012-08-01	CL	Stock	53.905	54.92	53.135	53.3	3948600.0
2012-08-01	A	Stock	27.7039	27.7039	27.1245	27.3104	2653963.0
2012-08-01	AABA-DELISTED	Stock	15.86	16.07	15.83	15.99	13807106.0
2012-08-01	AACC-DELISTED	Stock	5.86	5.88	5.6	5.79	48037.0
2012-08-01	AACG	Stock	4.01	4.58	4.01	4.21	10100.0
2012-08-01	AAIC-DELISTED	Stock	22.61	22.94	22.1901	22.23	91661.0
2012-08-01	AAME	Stock	2.7	2.7	2.7	2.7	2000.0
2012-08-01	AAMRQ-DELISTED	Stock	0.498	0.52	0.498	0.507	412144.0
2012-08-01	AAON	Stock	5.4756	5.517	5.2681	5.2681	305775.0
2012-08-01	AAP	Stock	70.49	71.82	67.89	68.06	1267500.0
2012-08-01	AAT	Stock	26.2	26.22	25.97	26.0	158000.0
2012-08-01	AAU-DELISTED	Stock	2.12	2.16	1.55	1.935	5136239.0
2012-08-01	AAUAF-DELISTED	Stock	2.12	2.16	1.55	1.9	5136439.0
2012-08-01	AAV-DELISTED	Stock	3.92	3.92	3.83	3.85	197200.0
2012-08-01	AAWW-DELISTED	Stock	45.68	45.94	44.59	45.3	254968.0
2012-08-01	AAXJ	Stock	53.64	53.64	53.03	53.12	167233.0
2012-08-01	AAXN-DELISTED	Stock	5.44	5.48	5.3	5.34	487827.0
2012-08-01	AB	Stock	12.15	12.25	12.02	12.12	122900.0
2012-08-01	ABAC-DELISTED	Stock	0.93	0.93	0.76	0.76	43661.0
2012-08-01	ABAX-DELISTED	Stock	35.87	36.21	35.69	35.8	121650.0
2012-08-01	ABB-DELISTED	Stock	17.57	17.61	17.32	17.36	2937975.0
2012-08-01	ABBNY-DELISTED	Stock	17.57	17.61	17.32	17.36	2970668.0
2012-08-01	ABC-DELISTED	Stock	39.89	40.11	39.31	39.36	3697952.0
2012-08-01	ABCB	Stock	11.96	12.13	11.58	11.58	57700.0
2012-08-01	ABCD-DELISTED	Stock	1.06	1.15	1.06	1.14	6849.0
2012-08-01	ABCO-DELISTED	Stock	44.19	45.6	42.27	43.86	760172.0
2012-08-01	ABCW-DELISTED	Stock	0.4	0.43	0.4	0.41	9785.0
2012-08-01	ABE-DELISTED	Stock	19.35	19.37	19.2831	19.3015	2657.0
2012-08-01	ABEO	Stock	750.0	912.5	750.0	912.5	13.0
2012-08-01	ABFS-DELISTED	Stock	12.89	13.07	11.03	11.14	1106777.0
2012-08-01	ABG	Stock	26.4	26.44	25.07	25.09	442200.0
2012-08-01	ABM	Stock	18.66	18.66	18.18	18.2	365300.0
2012-08-01	ABMD-DELISTED	Stock	22.71	23.18	22.213	22.98	583649.0
2012-08-01	ABR	Stock	5.38	5.4	5.34	5.36	60900.0
2012-08-01	ABT	Stock	31.8731	32.0219	31.6956	31.7148	9149854.0
2012-08-01	ABTL-DELISTED	Stock	3.82	3.89	3.63	3.815	53148.0
2012-08-01	ABUS	Stock	3.52	3.74	3.37	3.68	44200.0
2012-08-01	ABV-DELISTED	Stock	38.93	39.68	38.72	38.94	2172952.0
2012-08-01	ABVA-DELISTED	Stock	4.48	4.48	4.4	4.4	4026.0
2012-08-01	ABX-DELISTED	Stock	32.8	33.19	31.48	32.47	8848188.0
2012-08-01	ACAD	Stock	1.61	1.61	1.51	1.53	311000.0
2012-08-01	ACAS-DELISTED	Stock	10.03	10.35	10.01	10.23	8268558.0

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

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