PREVIEW / stock_daily / 2014-10-22

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-22.parquet
  size:    220 KB
  rows:    6,600
  symbols: 3,545

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-10-22	AAPL	Stock	25.71	26.0275	25.65	25.7475	273052400.0
2014-10-22	MSFT	Stock	45.0	45.07	44.23	44.38	33570900.0
2014-10-22	NVDA	Stock	0.4572	0.4588	0.4472	0.4472	239512000.0
2014-10-22	AMZN	Stock	15.7715	15.949	15.632	15.6485	62518000.0
2014-10-22	GOOGL	Stock	27.0525	27.538	27.0115	27.1345	59491000.0
2014-10-22	META	Stock	78.82	79.85	78.01	78.37	41862000.0
2014-10-22	TSLA	Stock	15.546	15.826	15.3707	15.4067	61749000.0
2014-10-22	TLT	Stock	120.47	120.85	120.22	120.67	9262018.0
2014-10-22	ES	Stock	47.8	48.44	47.72	48.07	1518700.0
2014-10-22	CL	Stock	65.41	65.7	65.26	65.32	4656000.0
2014-10-22	A	Stock	38.4621	38.5265	37.9041	37.9471	3021218.0
2014-10-22	AA.B-DELISTED	Stock	50.8	51.29	50.4	50.6	462482.0
2014-10-22	AABA-DELISTED	Stock	42.43	42.88	41.77	42.0	66547134.0
2014-10-22	AAC-DELISTED	Stock	19.41	21.02	19.2	20.52	308456.0
2014-10-22	AACG	Stock	4.29	4.29	4.18	4.18	4600.0
2014-10-22	AAIC-DELISTED	Stock	26.73	26.92	26.55	26.57	216119.0
2014-10-22	AAL	Stock	38.05	38.22	36.94	37.04	18958400.0
2014-10-22	AAMC-DELISTED	Stock	176.7941	182.7088	169.1176	169.1206	106818.0
2014-10-22	AAME	Stock	3.93	3.95	3.83	3.95	3200.0
2014-10-22	AAMI	Stock	14.5	15.32	14.37	14.7	403900.0
2014-10-22	AAOI	Stock	15.0	15.31	14.69	14.73	233600.0
2014-10-22	AAON	Stock	12.4267	12.4267	11.9267	11.9333	159900.0
2014-10-22	AAP	Stock	141.71	142.2	138.3	138.78	864000.0
2014-10-22	AAT	Stock	36.51	36.63	36.24	36.57	154200.0
2014-10-22	AAU-DELISTED	Stock	1.3414	1.3482	1.2	1.26	206271.0
2014-10-22	AAUAF-DELISTED	Stock	1.31	1.3166	1.2	1.26	213432.0
2014-10-22	AAV-DELISTED	Stock	4.62	4.7	4.27	4.29	195313.0
2014-10-22	AAVL-DELISTED	Stock	32.52	33.46	31.54	32.62	51424.0
2014-10-22	AAWW-DELISTED	Stock	34.5	35.18	33.47	33.52	163580.0
2014-10-22	AAXJ	Stock	61.42	61.48	61.03	61.19	648827.0
2014-10-22	AAXN-DELISTED	Stock	15.16	15.25	14.82	14.97	824197.0
2014-10-22	AB	Stock	26.03	26.55	25.51	25.55	272600.0
2014-10-22	ABAC-DELISTED	Stock	2.21	2.24	2.05	2.1699	86592.0
2014-10-22	ABAX-DELISTED	Stock	49.55	52.5	49.44	51.1	405828.0
2014-10-22	ABB-DELISTED	Stock	21.28	21.4	21.03	21.09	3645222.0
2014-10-22	ABBNY-DELISTED	Stock	21.28	21.4	21.03	21.09	3944741.0
2014-10-22	ABBV	Stock	56.96	57.45	56.26	56.9	16048100.0
2014-10-22	ABC-DELISTED	Stock	76.9	77.2	76.59	76.64	1743012.0
2014-10-22	ABCB	Stock	24.14	24.23	23.37	23.41	99000.0
2014-10-22	ABCD-DELISTED	Stock	1.3999	1.4698	1.3999	1.45	10500.0
2014-10-22	ABCO-DELISTED	Stock	49.74	50.62	48.94	49.33	287775.0
2014-10-22	ABCW-DELISTED	Stock	28.66	31.43	28.0	30.26	141552.0
2014-10-22	ABDC-DELISTED	Stock	12.388	12.61	12.26	12.5	62983.0
2014-10-22	ABE-DELISTED	Stock	13.61	13.73	13.61	13.7	6626.0
2014-10-22	ABEO	Stock	275.0	300.0	250.0	300.0	32.0
2014-10-22	ABEV	Stock	6.33	6.42	6.2	6.27	12321900.0
2014-10-22	ABG	Stock	63.35	64.72	61.31	61.46	695600.0
2014-10-22	ABGB-DELISTED	Stock	20.82	21.08	20.67	20.725	14797.0
2014-10-22	ABIL-DELISTED	Stock	9.7	9.7	9.7	9.7	1606278.0
2014-10-22	ABM	Stock	26.35	26.43	26.0	26.05	173100.0

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

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