PREVIEW / stock_daily / 2012-06-07

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-07.parquet
  size:    198 KB
  rows:    6,177
  symbols: 3,537

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-06-07	AAPL	Stock	20.6175	20.6186	20.375	20.4186	379766800.0
2012-06-07	MSFT	Stock	29.64	29.7	29.17	29.23	37792800.0
2012-06-07	NVDA	Stock	0.3143	0.316	0.297	0.2972	526780000.0
2012-06-07	AMZN	Stock	10.9825	11.0745	10.9055	10.94	70078000.0
2012-06-07	META	Stock	27.0	27.35	26.15	26.31	26159500.0
2012-06-07	TSLA	Stock	1.9873	1.9913	1.9233	1.9287	7381500.0
2012-06-07	TLT	Stock	124.65	125.74	124.39	125.24	18901313.0
2012-06-07	ES	Stock	37.0	37.45	36.97	37.1	1549200.0
2012-06-07	CL	Stock	49.37	49.705	49.305	49.375	3901600.0
2012-06-07	A	Stock	29.0057	29.0129	28.412	28.5837	6334757.0
2012-06-07	AABA-DELISTED	Stock	15.49	15.5	15.33	15.36	12341236.0
2012-06-07	AACC-DELISTED	Stock	5.62	5.73	5.55	5.66	16553.0
2012-06-07	AACG	Stock	5.6	5.6	5.39	5.4	2600.0
2012-06-07	AAIC-DELISTED	Stock	22.47	22.47	21.971	22.08	78434.0
2012-06-07	AAME	Stock	2.78	2.78	2.77	2.77	600.0
2012-06-07	AAMRQ-DELISTED	Stock	0.451	0.454	0.443	0.445	789824.0
2012-06-07	AAON	Stock	5.7659	5.8104	5.6444	5.7393	181238.0
2012-06-07	AAP	Stock	74.15	74.15	73.31	73.72	903800.0
2012-06-07	AAT	Stock	23.86	23.86	23.46	23.55	116700.0
2012-06-07	AAU-DELISTED	Stock	2.33	2.36	2.1	2.14	165599.0
2012-06-07	AAUAF-DELISTED	Stock	2.33	2.36	2.1	2.14	165899.0
2012-06-07	AAV-DELISTED	Stock	3.06	3.11	2.84	2.85	284472.0
2012-06-07	AAWW-DELISTED	Stock	44.32	45.19	44.04	44.08	419944.0
2012-06-07	AAXJ	Stock	52.19	52.25	51.46	51.56	1193255.0
2012-06-07	AAXN-DELISTED	Stock	5.43	5.43	5.21	5.21	261215.0
2012-06-07	AB	Stock	12.45	12.67	12.03	12.1	414800.0
2012-06-07	ABAC-DELISTED	Stock	1.52	1.52	1.35	1.36	1900.0
2012-06-07	ABAX-DELISTED	Stock	32.4	32.54	31.75	32.01	79366.0
2012-06-07	ABB-DELISTED	Stock	16.47	16.48	16.33	16.35	2866972.0
2012-06-07	ABBNY-DELISTED	Stock	16.47	16.48	16.33	16.37	2862824.0
2012-06-07	ABC-DELISTED	Stock	37.53	37.58	36.94	37.0	1812611.0
2012-06-07	ABCB	Stock	11.64	11.75	11.48	11.51	35800.0
2012-06-07	ABCD-DELISTED	Stock	1.23	1.26	1.22	1.25	21050.0
2012-06-07	ABCO-DELISTED	Stock	47.36	47.95	47.21	47.5	350351.0
2012-06-07	ABCW-DELISTED	Stock	0.4719	0.4719	0.4267	0.4368	88650.0
2012-06-07	ABE-DELISTED	Stock	18.26	18.32	18.0	18.0	8303.0
2012-06-07	ABEO	Stock	925.0	975.0	862.5	887.5	36.0
2012-06-07	ABFS-DELISTED	Stock	12.54	12.76	11.94	11.951	235466.0
2012-06-07	ABG	Stock	25.53	25.58	24.58	25.06	303200.0
2012-06-07	ABM	Stock	21.74	22.07	20.3	20.39	2141900.0
2012-06-07	ABMD-DELISTED	Stock	21.71	22.05	21.17	21.27	480577.0
2012-06-07	ABR	Stock	5.34	5.42	5.32	5.33	1908300.0
2012-06-07	ABT	Stock	29.4405	29.5461	29.2822	29.3638	16439767.0
2012-06-07	ABTL-DELISTED	Stock	3.8987	4.0521	3.8474	3.95	30951.0
2012-06-07	ABUS	Stock	2.0	2.0	1.96	1.96	8900.0
2012-06-07	ABV-DELISTED	Stock	37.91	37.91	37.21	37.42	2844987.0
2012-06-07	ABVT-DELISTED	Stock	83.49	83.54	83.39	83.47	243259.0
2012-06-07	ABX-DELISTED	Stock	40.3	40.36	38.07	38.77	17292613.0
2012-06-07	ACAD	Stock	1.34	1.34	1.32	1.33	131400.0
2012-06-07	ACAS-DELISTED	Stock	9.185	9.23	9.01	9.015	2377570.0

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

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