PREVIEW / stock_daily / 2012-07-09

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-09.parquet
  size:    198 KB
  rows:    6,128
  symbols: 3,492

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-07-09	AAPL	Stock	21.6179	21.925	21.5754	21.9246	379405600.0
2012-07-09	MSFT	Stock	30.12	30.23	29.78	30.0	30680800.0
2012-07-09	NVDA	Stock	0.333	0.3345	0.3278	0.3305	306336000.0
2012-07-09	AMZN	Stock	11.25	11.3	11.1725	11.2525	38440000.0
2012-07-09	META	Stock	32.1	32.88	31.99	32.17	17785200.0
2012-07-09	TSLA	Stock	2.0627	2.122	2.0447	2.0993	13657500.0
2012-07-09	TLT	Stock	127.38	128.26	127.11	128.18	5646969.0
2012-07-09	ES	Stock	38.71	38.71	38.28	38.56	1164600.0
2012-07-09	CL	Stock	52.285	52.305	51.89	52.13	2553800.0
2012-07-09	A	Stock	27.1459	27.3677	26.7525	26.9099	3173460.0
2012-07-09	AABA-DELISTED	Stock	15.78	15.84	15.7	15.76	9486229.0
2012-07-09	AACC-DELISTED	Stock	7.32	7.405	6.85	7.12	168710.0
2012-07-09	AACG	Stock	4.23	4.23	4.1	4.1	4500.0
2012-07-09	AAIC-DELISTED	Stock	22.48	22.48	22.23	22.39	36004.0
2012-07-09	AAME	Stock	2.74	2.8	2.74	2.8	500.0
2012-07-09	AAMRQ-DELISTED	Stock	0.49	0.495	0.485	0.49	1100246.0
2012-07-09	AAON	Stock	5.9259	5.9674	5.8459	5.923	161663.0
2012-07-09	AAP	Stock	68.86	70.12	68.58	70.1	1036600.0
2012-07-09	AAT	Stock	24.89	25.07	24.74	25.05	91900.0
2012-07-09	AAU-DELISTED	Stock	2.08	2.08	1.97	2.01	78353.0
2012-07-09	AAUAF-DELISTED	Stock	2.1	2.1	1.99	2.01	78080.0
2012-07-09	AAV-DELISTED	Stock	3.24	3.39	3.24	3.33	264636.0
2012-07-09	AAWW-DELISTED	Stock	45.34	45.38	44.21	44.33	174693.0
2012-07-09	AAXJ	Stock	52.25	52.25	51.9	52.16	240182.0
2012-07-09	AAXN-DELISTED	Stock	5.22	5.395	5.14	5.34	200040.0
2012-07-09	AB	Stock	12.77	12.8	12.53	12.79	95900.0
2012-07-09	ABAC-DELISTED	Stock	1.17	1.17	1.17	1.17	4600.0
2012-07-09	ABAX-DELISTED	Stock	38.66	39.07	38.58	39.03	176780.0
2012-07-09	ABB-DELISTED	Stock	15.96	16.02	15.86	15.98	1882578.0
2012-07-09	ABBNY-DELISTED	Stock	15.96	16.02	15.86	15.97	2052103.0
2012-07-09	ABC-DELISTED	Stock	38.63	39.04	38.63	38.89	1412835.0
2012-07-09	ABCB	Stock	12.5	12.71	12.49	12.65	11200.0
2012-07-09	ABCD-DELISTED	Stock	1.11	1.12	1.05	1.05	16708.0
2012-07-09	ABCO-DELISTED	Stock	50.4101	50.62	49.1229	50.48	131853.0
2012-07-09	ABCW-DELISTED	Stock	0.5	0.5	0.46	0.46	34991.0
2012-07-09	ABE-DELISTED	Stock	18.88	19.01	18.88	19.01	1943.0
2012-07-09	ABEO	Stock	762.5	762.5	737.5	750.0	2.0
2012-07-09	ABFS-DELISTED	Stock	12.78	12.83	12.6	12.66	222276.0
2012-07-09	ABG	Stock	25.71	25.76	25.15	25.26	304000.0
2012-07-09	ABM	Stock	19.07	19.25	18.4	18.56	464200.0
2012-07-09	ABMD-DELISTED	Stock	23.46	23.86	23.3	23.62	294856.0
2012-07-09	ABR	Stock	5.4	5.4	5.32	5.36	40600.0
2012-07-09	ABT	Stock	31.1102	31.4893	31.091	31.4797	48254898.0
2012-07-09	ABTL-DELISTED	Stock	3.855	3.9551	3.7548	3.895	8637.0
2012-07-09	ABUS	Stock	2.1	2.15	2.1	2.1	2200.0
2012-07-09	ABV-DELISTED	Stock	37.58	38.04	37.22	37.48	1165636.0
2012-07-09	ABX-DELISTED	Stock	36.9	37.09	36.23	36.64	5863494.0
2012-07-09	ACAD	Stock	1.94	1.96	1.84	1.88	767900.0
2012-07-09	ACAS-DELISTED	Stock	10.07	10.1	9.965	10.07	1213906.0
2012-07-09	ACAT-DELISTED	Stock	36.94	37.7	36.44	37.58	131918.0

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

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