PREVIEW / stock_daily / 2012-03-22

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-22.parquet
  size:    199 KB
  rows:    6,135
  symbols: 3,517

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-03-22	AAPL	Stock	21.3493	21.5893	21.2689	21.405	623870800.0
2012-03-22	MSFT	Stock	31.81	32.09	31.79	32.0	31749500.0
2012-03-22	NVDA	Stock	0.3588	0.364	0.3578	0.361	425372000.0
2012-03-22	AMZN	Stock	9.527	9.703	9.513	9.62	74792000.0
2012-03-22	TSLA	Stock	2.3313	2.3433	2.2867	2.2933	7836000.0
2012-03-22	TLT	Stock	112.29	112.37	111.87	112.15	8009886.0
2012-03-22	ES	Stock	36.21	36.45	36.08	36.38	1404000.0
2012-03-22	CL	Stock	47.91	48.19	47.87	48.14	2968400.0
2012-03-22	A	Stock	31.4664	31.4664	30.9156	31.2661	4339112.0
2012-03-22	AABA-DELISTED	Stock	15.52	15.56	15.38	15.49	14580021.0
2012-03-22	AACC-DELISTED	Stock	4.75	4.79	4.7	4.74	7100.0
2012-03-22	AACG	Stock	6.34	7.0	6.31	6.33	600.0
2012-03-22	AAIC-DELISTED	Stock	23.01	23.09	22.69	22.76	1060662.0
2012-03-22	AAME	Stock	2.82	2.88	2.65	2.84	1800.0
2012-03-22	AAMRQ-DELISTED	Stock	0.479	0.49	0.4675	0.4875	1313758.0
2012-03-22	AAON	Stock	6.0089	6.0711	5.8933	6.0267	125888.0
2012-03-22	AAP	Stock	88.75	89.72	88.32	89.18	785400.0
2012-03-22	AAT	Stock	22.62	22.64	22.31	22.63	73400.0
2012-03-22	AAU-DELISTED	Stock	2.55	2.62	2.5	2.55	63654.0
2012-03-22	AAUAF-DELISTED	Stock	2.55	2.62	2.5	2.55	63854.0
2012-03-22	AAV-DELISTED	Stock	3.72	3.73	3.55	3.62	343979.0
2012-03-22	AAWW-DELISTED	Stock	48.68	48.68	47.22	48.14	473339.0
2012-03-22	AAXJ	Stock	56.48	56.48	56.0	56.22	248857.0
2012-03-22	AAXN-DELISTED	Stock	4.22	4.59	4.19	4.57	1917717.0
2012-03-22	AB	Stock	15.08	15.11	14.62	14.78	285800.0
2012-03-22	ABAC-DELISTED	Stock	1.6799	1.7	1.6799	1.6899	11214.0
2012-03-22	ABAX-DELISTED	Stock	28.15	28.37	27.7	28.31	41933.0
2012-03-22	ABB-DELISTED	Stock	19.97	20.18	19.925	20.09	2420410.0
2012-03-22	ABBNY-DELISTED	Stock	19.97	20.18	19.925	20.09	2430560.0
2012-03-22	ABC-DELISTED	Stock	38.28	38.74	38.26	38.3	2267281.0
2012-03-22	ABCB	Stock	13.08	13.2	13.01	13.08	54100.0
2012-03-22	ABCD-DELISTED	Stock	2.74	2.74	2.68	2.71	8623.0
2012-03-22	ABCO-DELISTED	Stock	42.53	43.04	41.91	42.8	125467.0
2012-03-22	ABCW-DELISTED	Stock	0.743	0.743	0.6727	0.7028	38280.0
2012-03-22	ABD-DELISTED	Stock	12.48	12.68	12.27	12.47	405990.0
2012-03-22	ABE-DELISTED	Stock	19.14	19.3	19.12	19.12	7816.0
2012-03-22	ABEO	Stock	1275.0	1275.0	1137.5	1262.5	4.0
2012-03-22	ABFS-DELISTED	Stock	19.14	19.21	18.75	18.89	601237.0
2012-03-22	ABG	Stock	26.56	26.82	26.32	26.68	267800.0
2012-03-22	ABH-DELISTED	Stock	15.02	15.02	14.72	14.81	118137.0
2012-03-22	ABM	Stock	23.15	23.3	23.04	23.28	201100.0
2012-03-22	ABMD-DELISTED	Stock	23.05	23.2386	22.74	22.99	521275.0
2012-03-22	ABR	Stock	5.59	5.63	5.44	5.59	38700.0
2012-03-22	ABT	Stock	28.8792	28.9463	28.7784	28.8408	14070446.0
2012-03-22	ABTL-DELISTED	Stock	5.1031	5.1031	4.7969	4.85	17229.0
2012-03-22	ABUS	Stock	2.36	2.38	2.17	2.17	31300.0
2012-03-22	ABV-DELISTED	Stock	41.15	42.56	41.13	42.35	2911843.0
2012-03-22	ABVA-DELISTED	Stock	4.12	4.1201	3.81	3.81	3800.0
2012-03-22	ABVT-DELISTED	Stock	83.35	83.93	83.26	83.4	688261.0
2012-03-22	ABX-DELISTED	Stock	42.87	43.37	42.5	43.08	6955751.0

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

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