PREVIEW / stock_daily / 2012-06-20

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-20.parquet
  size:    198 KB
  rows:    6,131
  symbols: 3,502

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-20	AAPL	Stock	21.0075	21.0446	20.7429	20.9193	358943200.0
2012-06-20	MSFT	Stock	30.93	31.05	30.64	30.93	36257100.0
2012-06-20	NVDA	Stock	0.3342	0.3425	0.3322	0.3362	972720000.0
2012-06-20	AMZN	Stock	11.2255	11.237	11.042	11.151	48888000.0
2012-06-20	META	Stock	31.92	31.93	31.15	31.6	15553600.0
2012-06-20	TSLA	Stock	2.2333	2.3	2.214	2.252	51336000.0
2012-06-20	TLT	Stock	124.575	126.51	124.09	126.04	13721109.0
2012-06-20	ES	Stock	38.6	38.6	37.7	38.03	2566900.0
2012-06-20	CL	Stock	50.085	50.365	49.81	50.365	5206000.0
2012-06-20	A	Stock	29.4564	29.6495	28.7983	29.0701	4499603.0
2012-06-20	AABA-DELISTED	Stock	15.71	15.75	15.58	15.74	11047155.0
2012-06-20	AACC-DELISTED	Stock	6.25	6.38	5.95	6.19	76172.0
2012-06-20	AACG	Stock	3.76	3.77	3.75	3.75	2400.0
2012-06-20	AAIC-DELISTED	Stock	23.0	23.1	22.93	23.0	149393.0
2012-06-20	AAME	Stock	2.72	2.72	2.7	2.72	6200.0
2012-06-20	AAMRQ-DELISTED	Stock	0.4755	0.51	0.46	0.51	2148628.0
2012-06-20	AAON	Stock	5.9467	5.9467	5.84	5.8696	73238.0
2012-06-20	AAP	Stock	68.69	69.18	68.16	69.03	1632100.0
2012-06-20	AAT	Stock	23.69	23.69	23.35	23.43	69200.0
2012-06-20	AAU-DELISTED	Stock	2.2299	2.289	2.21	2.24	70155.0
2012-06-20	AAUAF-DELISTED	Stock	2.2299	2.289	2.21	2.24	70555.0
2012-06-20	AAV-DELISTED	Stock	2.85	2.9	2.79	2.83	195917.0
2012-06-20	AAWW-DELISTED	Stock	44.29	44.81	43.715	44.05	141882.0
2012-06-20	AAXJ	Stock	53.23	53.35	52.75	53.23	1326675.0
2012-06-20	AAXN-DELISTED	Stock	5.47	5.51	5.41	5.44	369738.0
2012-06-20	AB	Stock	12.02	12.1	11.86	12.05	234000.0
2012-06-20	ABAC-DELISTED	Stock	1.25	1.36	1.21	1.21	45608.0
2012-06-20	ABAX-DELISTED	Stock	35.63	35.92	34.92	35.37	74000.0
2012-06-20	ABB-DELISTED	Stock	16.53	16.685	16.39	16.5	2295678.0
2012-06-20	ABBNY-DELISTED	Stock	16.53	16.685	16.39	16.5	2296199.0
2012-06-20	ABC-DELISTED	Stock	37.92	38.14	37.62	37.96	1291315.0
2012-06-20	ABCB	Stock	11.92	12.14	11.81	11.93	19800.0
2012-06-20	ABCD-DELISTED	Stock	1.11	1.18	1.05	1.05	42647.0
2012-06-20	ABCO-DELISTED	Stock	50.56	50.72	49.14	49.56	338081.0
2012-06-20	ABCW-DELISTED	Stock	0.4619	0.483	0.4418	0.483	49880.0
2012-06-20	ABE-DELISTED	Stock	18.27	18.47	18.26	18.47	7808.0
2012-06-20	ABEO	Stock	850.0	850.0	850.0	850.0	13.0
2012-06-20	ABFS-DELISTED	Stock	12.63	12.68	12.33	12.5	401092.0
2012-06-20	ABG	Stock	25.04	25.25	24.59	24.68	116300.0
2012-06-20	ABM	Stock	20.86	20.91	20.65	20.79	275100.0
2012-06-20	ABMD-DELISTED	Stock	21.94	22.23	21.83	22.12	385629.0
2012-06-20	ABR	Stock	5.02	5.16	5.01	5.12	71100.0
2012-06-20	ABT	Stock	30.1554	30.2226	29.9539	30.141	10753022.0
2012-06-20	ABTL-DELISTED	Stock	3.9	3.9513	3.8995	3.9	1687.0
2012-06-20	ABUS	Stock	1.99	2.0	1.86	1.98	8100.0
2012-06-20	ABV-DELISTED	Stock	38.98	38.98	37.77	38.4	3265614.0
2012-06-20	ABVA-DELISTED	Stock	4.22	4.22	4.22	4.22	8400.0
2012-06-20	ABVT-DELISTED	Stock	83.9	83.91	83.87	83.87	301447.0
2012-06-20	ABX-DELISTED	Stock	39.89	40.91	39.55	40.339	12660723.0
2012-06-20	ACAD	Stock	1.58	1.6	1.53	1.6	281800.0

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

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