PREVIEW / stock_daily / 2014-12-26

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-26.parquet
  size:    220 KB
  rows:    6,606
  symbols: 3,503

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-26	AAPL	Stock	28.025	28.63	28.0025	28.4975	134884000.0
2014-12-26	MSFT	Stock	48.41	48.41	47.82	47.88	13197800.0
2014-12-26	NVDA	Stock	0.5142	0.5175	0.513	0.5148	52636000.0
2014-12-26	AMZN	Stock	15.25	15.539	15.1905	15.4545	57876000.0
2014-12-26	GOOGL	Stock	26.8465	27.1625	26.7745	27.076	22269280.0
2014-12-26	META	Stock	81.02	81.28	80.51	80.78	10647400.0
2014-12-26	TSLA	Stock	14.7673	15.2333	14.7667	15.188	49905000.0
2014-12-26	TLT	Stock	124.55	124.59	124.02	124.41	2921323.0
2014-12-26	ES	Stock	55.16	55.83	55.11	55.67	1676900.0
2014-12-26	CL	Stock	70.57	71.02	70.57	70.88	1303300.0
2014-12-26	A	Stock	41.34	41.57	41.29	41.38	588000.0
2014-12-26	AA.B-DELISTED	Stock	50.86	50.9047	50.4	50.689	8915.0
2014-12-26	AABA-DELISTED	Stock	50.7	51.06	50.61	50.865	4916719.0
2014-12-26	AAC-DELISTED	Stock	29.48	30.0	29.288	29.72	18285.0
2014-12-26	AACG	Stock	3.58	3.8	3.55	3.8	9000.0
2014-12-26	AAIC-DELISTED	Stock	27.75	27.85	27.55	27.78	216717.0
2014-12-26	AAL	Stock	51.46	52.25	51.06	51.96	6841800.0
2014-12-26	AAMC-DELISTED	Stock	98.2382	98.8971	96.2258	98.8235	19033.0
2014-12-26	AAME	Stock	3.89	3.9	3.79	3.9	5500.0
2014-12-26	AAMI	Stock	16.26	16.7	16.1	16.25	279600.0
2014-12-26	AAOI	Stock	10.73	10.73	10.34	10.63	109800.0
2014-12-26	AAON	Stock	14.8867	15.0933	14.84	14.9133	82200.0
2014-12-26	AAP	Stock	160.28	161.25	159.86	160.0	307500.0
2014-12-26	AAT	Stock	40.4	40.68	40.18	40.53	80000.0
2014-12-26	AAU-DELISTED	Stock	1.0	1.0	0.9549	0.97	73379.0
2014-12-26	AAUAF-DELISTED	Stock	0.98	0.98	0.9401	0.97	75454.0
2014-12-26	AAV-DELISTED	Stock	4.69	4.7507	4.57	4.59	47986.0
2014-12-26	AAVL-DELISTED	Stock	47.5	48.81	46.515	48.64	47339.0
2014-12-26	AAWW-DELISTED	Stock	48.68	49.26	48.37	49.16	117360.0
2014-12-26	AAXJ	Stock	60.97	61.27	60.97	61.02	259663.0
2014-12-26	AAXN-DELISTED	Stock	27.01	27.65	26.54	26.9	2503888.0
2014-12-26	AB	Stock	25.76	25.99	25.7	25.9	226200.0
2014-12-26	ABAC-DELISTED	Stock	1.6404	1.736	1.621	1.7	7648.0
2014-12-26	ABAX-DELISTED	Stock	58.46	59.25	58.03	58.56	67670.0
2014-12-26	ABB-DELISTED	Stock	21.47	21.73	21.47	21.68	693187.0
2014-12-26	ABBNY-DELISTED	Stock	21.47	21.73	21.47	21.68	719904.0
2014-12-26	ABBV	Stock	66.51	67.24	66.51	66.98	4158200.0
2014-12-26	ABC-DELISTED	Stock	91.54	92.21	91.3	91.51	340115.0
2014-12-26	ABCB	Stock	26.0	26.08	25.83	25.97	36900.0
2014-12-26	ABCD-DELISTED	Stock	1.66	1.68	1.66	1.68	300.0
2014-12-26	ABCO-DELISTED	Stock	49.53	49.6	48.91	49.18	154094.0
2014-12-26	ABCW-DELISTED	Stock	34.9	34.9	34.59	34.64	4057.0
2014-12-26	ABDC-DELISTED	Stock	12.5	12.77	12.35	12.74	51515.0
2014-12-26	ABE-DELISTED	Stock	13.07	13.35	13.07	13.28	8490.0
2014-12-26	ABEO	Stock	88.0	91.25	84.25	91.0	200.0
2014-12-26	ABEOW-DELISTED	Stock	0.78	0.78	0.75	0.75	4300.0
2014-12-26	ABEV	Stock	6.07	6.15	6.04	6.04	5291300.0
2014-12-26	ABG	Stock	77.67	78.28	77.04	77.56	148100.0
2014-12-26	ABGB-DELISTED	Stock	11.901	12.045	11.7901	11.9	21285.0
2014-12-26	ABM	Stock	29.09	29.35	29.08	29.21	90500.0

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

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