PREVIEW / stock_daily / 2014-12-29

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-29.parquet
  size:    223 KB
  rows:    6,672
  symbols: 3,550

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
2014-12-29	AAPL	Stock	28.4475	28.6925	28.425	28.4775	110395600.0
2014-12-29	MSFT	Stock	47.7	47.78	47.26	47.45	14439500.0
2014-12-29	NVDA	Stock	0.5133	0.5175	0.5108	0.514	82944000.0
2014-12-29	AMZN	Stock	15.3925	15.7135	15.329	15.602	60180000.0
2014-12-29	GOOGL	Stock	27.025	27.1965	26.858	26.8655	44372640.0
2014-12-29	META	Stock	80.49	80.96	79.71	80.02	14134700.0
2014-12-29	TSLA	Stock	15.1267	15.194	14.9347	15.0473	42037500.0
2014-12-29	TLT	Stock	124.91	125.66	124.81	125.34	4070721.0
2014-12-29	ES	Stock	55.59	56.66	55.59	56.15	2194500.0
2014-12-29	CL	Stock	70.65	70.86	70.33	70.48	1715200.0
2014-12-29	A	Stock	41.36	41.57	41.31	41.33	975900.0
2014-12-29	AA.B-DELISTED	Stock	50.77	50.79	50.4	50.65	9073.0
2014-12-29	AABA-DELISTED	Stock	50.63	51.01	50.51	50.54	6044405.0
2014-12-29	AAC-DELISTED	Stock	29.59	29.98	29.28	29.88	46003.0
2014-12-29	AACG	Stock	3.79	3.98	3.79	3.98	20900.0
2014-12-29	AAIC-DELISTED	Stock	26.93	27.19	26.8805	27.16	294258.0
2014-12-29	AAL	Stock	51.65	53.24	51.3	52.85	8788900.0
2014-12-29	AAMC-DELISTED	Stock	98.5294	104.0397	97.0559	98.25	48154.0
2014-12-29	AAME	Stock	3.86	3.9	3.78	3.9	3100.0
2014-12-29	AAMI	Stock	16.21	16.48	16.14	16.25	112100.0
2014-12-29	AAOI	Stock	10.71	11.1	10.53	10.94	234300.0
2014-12-29	AAON	Stock	14.8933	15.0	14.8067	14.8667	109500.0
2014-12-29	AAP	Stock	160.18	162.13	159.74	161.22	417700.0
2014-12-29	AAT	Stock	40.61	41.0	40.27	40.65	63900.0
2014-12-29	AAU-DELISTED	Stock	0.9057	0.9535	0.9057	0.92	150941.0
2014-12-29	AAUAF-DELISTED	Stock	0.9403	0.9899	0.9168	0.9168	145796.0
2014-12-29	AAV-DELISTED	Stock	4.6	4.82	4.58	4.67	261261.0
2014-12-29	AAVL-DELISTED	Stock	48.86	52.6299	48.81	51.99	109412.0
2014-12-29	AAWW-DELISTED	Stock	49.17	49.4	48.87	49.16	104843.0
2014-12-29	AAXJ	Stock	61.03	61.15	60.91	60.95	366526.0
2014-12-29	AAXN-DELISTED	Stock	26.71	27.18	26.27	26.71	1942442.0
2014-12-29	AB	Stock	25.82	26.11	25.74	25.74	571600.0
2014-12-29	ABAC-DELISTED	Stock	1.68	1.7	1.6401	1.7	16150.0
2014-12-29	ABAX-DELISTED	Stock	58.66	59.09	57.21	57.88	90039.0
2014-12-29	ABB-DELISTED	Stock	21.525	21.67	21.5	21.56	883655.0
2014-12-29	ABBNY-DELISTED	Stock	21.525	21.67	21.5	21.56	935223.0
2014-12-29	ABBV	Stock	66.58	67.37	66.42	67.14	3872800.0
2014-12-29	ABC-DELISTED	Stock	91.26	91.89	91.18	91.63	647231.0
2014-12-29	ABCB	Stock	26.01	26.27	25.93	26.0	82800.0
2014-12-29	ABCD-DELISTED	Stock	1.64	1.66	1.64	1.66	1150.0
2014-12-29	ABCO-DELISTED	Stock	49.24	50.56	48.64	49.732	361781.0
2014-12-29	ABCW-DELISTED	Stock	35.0	35.0	34.52	35.0	4903.0
2014-12-29	ABDC-DELISTED	Stock	12.66	12.83	12.2001	12.78	73770.0
2014-12-29	ABE-DELISTED	Stock	13.13	13.13	13.0	13.038	10985.0
2014-12-29	ABEO	Stock	82.5	87.5	82.5	87.5	572.0
2014-12-29	ABEV	Stock	6.06	6.16	6.06	6.16	11861400.0
2014-12-29	ABG	Stock	77.57	78.73	77.02	77.54	271900.0
2014-12-29	ABGB-DELISTED	Stock	11.64	12.07	11.58	11.93	39380.0
2014-12-29	ABM	Stock	29.24	29.65	29.15	29.37	194900.0
2014-12-29	ABMD-DELISTED	Stock	38.54	39.01	38.02	38.45	205696.0

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

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