PREVIEW / stock_daily / 2012-04-12

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-12.parquet
  size:    200 KB
  rows:    6,164
  symbols: 3,534

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-04-12	AAPL	Stock	22.3214	22.5475	22.1607	22.2418	614336800.0
2012-04-12	MSFT	Stock	30.48	31.04	30.42	30.98	38304000.0
2012-04-12	NVDA	Stock	0.359	0.369	0.3575	0.367	384868000.0
2012-04-12	AMZN	Stock	9.403	9.613	9.2805	9.5345	80558000.0
2012-04-12	TSLA	Stock	2.2513	2.2987	2.1947	2.2293	15508500.0
2012-04-12	TLT	Stock	115.67	115.75	114.82	114.98	9008577.0
2012-04-12	ES	Stock	35.69	35.87	35.63	35.72	2812900.0
2012-04-12	CL	Stock	48.215	48.815	48.19	48.72	14848400.0
2012-04-12	A	Stock	30.4864	31.2446	30.4006	31.1373	2185074.0
2012-04-12	AABA-DELISTED	Stock	14.93	15.1	14.84	15.06	9439320.0
2012-04-12	AACC-DELISTED	Stock	4.89	5.14	4.89	4.92	7987.0
2012-04-12	AACG	Stock	7.15	7.25	6.89	6.98	3200.0
2012-04-12	AAIC-DELISTED	Stock	22.49	22.72	22.48	22.65	63473.0
2012-04-12	AAME	Stock	2.87	3.0	2.85	2.93	10500.0
2012-04-12	AAMRQ-DELISTED	Stock	0.505	0.505	0.49	0.49	1045220.0
2012-04-12	AAON	Stock	5.5674	5.7422	5.5556	5.7274	210600.0
2012-04-12	AAP	Stock	89.93	90.5	89.55	89.95	970000.0
2012-04-12	AAT	Stock	22.7	22.87	22.53	22.77	72900.0
2012-04-12	AAU-DELISTED	Stock	2.25	2.44	2.23	2.4	105831.0
2012-04-12	AAUAF-DELISTED	Stock	2.25	2.44	2.23	2.4	106031.0
2012-04-12	AAV-DELISTED	Stock	2.85	3.05	2.82	3.02	279457.0
2012-04-12	AAWW-DELISTED	Stock	46.6	48.32	46.11	47.41	301290.0
2012-04-12	AAXJ	Stock	55.72	56.71	55.69	56.7	234055.0
2012-04-12	AAXN-DELISTED	Stock	4.13	4.22	4.1	4.18	237257.0
2012-04-12	AB	Stock	14.37	14.6	14.0	14.54	214100.0
2012-04-12	ABAC-DELISTED	Stock	1.64	1.72	1.62	1.65	21800.0
2012-04-12	ABAX-DELISTED	Stock	27.58	28.09	27.56	27.71	52020.0
2012-04-12	ABB-DELISTED	Stock	19.72	20.02	19.71	19.93	2536234.0
2012-04-12	ABBNY-DELISTED	Stock	19.72	20.02	19.71	19.93	2838834.0
2012-04-12	ABC-DELISTED	Stock	39.0	39.49	38.78	38.82	3300427.0
2012-04-12	ABCB	Stock	13.08	13.21	13.02	13.16	35800.0
2012-04-12	ABCD-DELISTED	Stock	2.58	2.64	2.47	2.55	15880.0
2012-04-12	ABCO-DELISTED	Stock	42.69	42.86	42.31	42.64	485404.0
2012-04-12	ABCW-DELISTED	Stock	0.8836	0.9237	0.8836	0.9237	22350.0
2012-04-12	ABD-DELISTED	Stock	11.67	12.03	11.64	11.83	539460.0
2012-04-12	ABE-DELISTED	Stock	19.17	19.2716	19.16	19.25	6477.0
2012-04-12	ABEO	Stock	1425.0	1437.5	1375.0	1425.0	14.0
2012-04-12	ABFS-DELISTED	Stock	18.56	18.86	18.52	18.6	240259.0
2012-04-12	ABG	Stock	27.3	27.79	27.16	27.7	203600.0
2012-04-12	ABH-DELISTED	Stock	13.42	13.64	13.38	13.47	347883.0
2012-04-12	ABM	Stock	23.38	23.75	23.36	23.6	207200.0
2012-04-12	ABMD-DELISTED	Stock	21.21	21.41	20.91	21.02	193390.0
2012-04-12	ABR	Stock	5.38	5.54	5.37	5.5	26200.0
2012-04-12	ABT	Stock	28.6968	28.7496	28.5337	28.6537	13437474.0
2012-04-12	ABTL-DELISTED	Stock	4.6	4.719	4.6	4.65	15333.0
2012-04-12	ABUS	Stock	2.33	2.37	2.25	2.33	19100.0
2012-04-12	ABV-DELISTED	Stock	42.32	42.75	42.195	42.73	2457773.0
2012-04-12	ABVA-DELISTED	Stock	4.16	4.47	4.05	4.47	1401.0
2012-04-12	ABVT-DELISTED	Stock	83.06	83.17	83.06	83.07	243712.0
2012-04-12	ABX-DELISTED	Stock	41.2	42.44	41.0	42.22	6657910.0

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

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