PREVIEW / stock_daily / 2012-05-25

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-25.parquet
  size:    198 KB
  rows:    6,145
  symbols: 3,523

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-05-25	AAPL	Stock	20.1639	20.2089	19.9454	20.0818	328507200.0
2012-05-25	MSFT	Stock	29.2	29.36	29.01	29.06	29507200.0
2012-05-25	NVDA	Stock	0.3025	0.3125	0.3025	0.31	391752000.0
2012-05-25	AMZN	Stock	10.7495	10.799	10.611	10.6445	43428000.0
2012-05-25	META	Stock	32.9	32.95	31.11	31.91	37149800.0
2012-05-25	TSLA	Stock	2.0107	2.0273	1.9467	1.9873	11355000.0
2012-05-25	TLT	Stock	123.43	123.54	123.14	123.4	4723541.0
2012-05-25	ES	Stock	36.29	36.49	36.23	36.36	5529900.0
2012-05-25	CL	Stock	49.665	49.82	49.335	49.4	2481600.0
2012-05-25	A	Stock	29.3419	29.6567	29.1774	29.3348	2633552.0
2012-05-25	AABA-DELISTED	Stock	15.38	15.48	15.29	15.34	13191931.0
2012-05-25	AACC-DELISTED	Stock	5.63	5.69	5.5108	5.61	23879.0
2012-05-25	AACG	Stock	6.3	6.3	6.23	6.24	500.0
2012-05-25	AAIC-DELISTED	Stock	22.44	22.459	22.1	22.23	60708.0
2012-05-25	AAME	Stock	2.58	2.7	2.44	2.7	7100.0
2012-05-25	AAMRQ-DELISTED	Stock	0.461	0.475	0.452	0.472	672779.0
2012-05-25	AAON	Stock	5.6267	5.757	5.5467	5.757	172125.0
2012-05-25	AAP	Stock	73.03	73.8	72.52	73.67	1436900.0
2012-05-25	AAT	Stock	23.02	23.16	22.87	22.99	75500.0
2012-05-25	AAU-DELISTED	Stock	2.02	2.06	1.9007	2.01	156030.0
2012-05-25	AAUAF-DELISTED	Stock	2.02	2.06	1.9007	2.01	157130.0
2012-05-25	AAV-DELISTED	Stock	2.84	2.86	2.78	2.82	123720.0
2012-05-25	AAWW-DELISTED	Stock	46.65	46.86	45.63	45.91	98667.0
2012-05-25	AAXJ	Stock	50.17	50.2	49.75	49.9	789674.0
2012-05-25	AAXN-DELISTED	Stock	5.39	5.54	5.36	5.46	492422.0
2012-05-25	AB	Stock	13.52	13.57	13.19	13.38	222300.0
2012-05-25	ABAC-DELISTED	Stock	1.5	1.52	1.47	1.5199	7405.0
2012-05-25	ABAX-DELISTED	Stock	32.63	33.0	32.2	32.58	74697.0
2012-05-25	ABB-DELISTED	Stock	16.15	16.31	16.15	16.19	3347038.0
2012-05-25	ABBNY-DELISTED	Stock	16.15	16.31	16.15	16.18	3349238.0
2012-05-25	ABC-DELISTED	Stock	36.53	36.99	36.44	36.885	1366548.0
2012-05-25	ABCB	Stock	11.51	11.59	11.33	11.42	42300.0
2012-05-25	ABCD-DELISTED	Stock	1.29	1.48	1.25	1.36	24988.0
2012-05-25	ABCO-DELISTED	Stock	48.11	48.25	47.02	47.29	221831.0
2012-05-25	ABCW-DELISTED	Stock	0.5221	0.5522	0.5221	0.5522	5350.0
2012-05-25	ABE-DELISTED	Stock	17.8201	17.8801	17.82	17.84	3579.0
2012-05-25	ABEO	Stock	812.5	962.5	812.5	962.5	64.0
2012-05-25	ABFS-DELISTED	Stock	12.86	13.15	12.57	12.99	341415.0
2012-05-25	ABG	Stock	26.85	26.85	26.32	26.55	421200.0
2012-05-25	ABM	Stock	21.74	21.87	21.57	21.73	217100.0
2012-05-25	ABMD-DELISTED	Stock	21.95	21.95	20.27	20.81	1239535.0
2012-05-25	ABR	Stock	5.86	5.9	5.83	5.85	12900.0
2012-05-25	ABT	Stock	29.8292	30.1554	29.8004	29.8676	9987703.0
2012-05-25	ABTL-DELISTED	Stock	4.0141	4.0141	3.75	3.75	29764.0
2012-05-25	ABUS	Stock	2.11	2.34	2.06	2.06	83800.0
2012-05-25	ABV-DELISTED	Stock	37.59	38.13	37.31	37.98	2649871.0
2012-05-25	ABVA-DELISTED	Stock	4.2	4.3	4.2	4.2	45660.0
2012-05-25	ABVT-DELISTED	Stock	83.25	83.31	83.25	83.3	96812.0
2012-05-25	ABX-DELISTED	Stock	39.73	40.21	39.45	40.02	5452679.0
2012-05-25	ACAD	Stock	1.4	1.46	1.38	1.46	179200.0

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

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