PREVIEW / stock_daily / 2014-01-08

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-08.parquet
  size:    217 KB
  rows:    6,444
  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
2014-01-08	AAPL	Stock	19.2432	19.4843	19.2389	19.4093	258529600.0
2014-01-08	MSFT	Stock	36.0	36.14	35.58	35.76	59971700.0
2014-01-08	NVDA	Stock	0.405	0.411	0.4035	0.409	308192000.0
2014-01-08	AMZN	Stock	19.9235	20.15	19.802	20.096	46330000.0
2014-01-08	META	Stock	57.6	58.41	57.23	58.23	56682400.0
2014-01-08	TSLA	Stock	9.9233	10.2467	9.9173	10.0853	92448000.0
2014-01-08	TLT	Stock	102.45	102.69	102.1	102.58	8512987.0
2014-01-08	ES	Stock	41.77	41.86	41.46	41.74	2225300.0
2014-01-08	CL	Stock	64.17	64.2	63.41	63.54	3286300.0
2014-01-08	A	Stock	41.0086	41.8741	40.8941	41.7668	3717981.0
2014-01-08	AABA-DELISTED	Stock	41.32	41.7201	41.02	41.03	17589376.0
2014-01-08	AACG	Stock	4.05	4.1	4.02	4.05	32800.0
2014-01-08	AAIC-DELISTED	Stock	26.35	26.38	26.11	26.38	115981.0
2014-01-08	AAL	Stock	26.37	27.68	26.35	27.63	15733900.0
2014-01-08	AAMC-DELISTED	Stock	268.2353	274.9265	266.1765	273.3824	32246.0
2014-01-08	AAME	Stock	4.05	4.06	3.92	4.01	20000.0
2014-01-08	AAOI	Stock	14.75	14.82	14.5	14.66	37600.0
2014-01-08	AAON	Stock	13.9956	14.2222	13.8178	14.1156	370800.0
2014-01-08	AAP	Stock	112.47	113.62	111.91	112.3	777200.0
2014-01-08	AAT	Stock	31.89	31.89	31.09	31.45	75100.0
2014-01-08	AAU-DELISTED	Stock	1.22	1.25	1.1898	1.23	49868.0
2014-01-08	AAUAF-DELISTED	Stock	1.21	1.24	1.18	1.23	50922.0
2014-01-08	AAV-DELISTED	Stock	4.56	4.56	4.4	4.51	170249.0
2014-01-08	AAWW-DELISTED	Stock	40.6	40.89	40.25	40.83	303797.0
2014-01-08	AAXJ	Stock	57.91	58.21	57.77	57.92	1059212.0
2014-01-08	AAXN-DELISTED	Stock	16.55	18.5664	16.5	17.92	5095383.0
2014-01-08	AB	Stock	22.3	22.46	21.88	21.91	233500.0
2014-01-08	ABAC-DELISTED	Stock	2.094	2.19	2.09	2.15	18798.0
2014-01-08	ABAX-DELISTED	Stock	42.4	42.4	39.15	42.18	279147.0
2014-01-08	ABB-DELISTED	Stock	25.78	25.91	25.721	25.85	1118228.0
2014-01-08	ABBNY-DELISTED	Stock	25.8	25.91	25.721	25.84	1151154.0
2014-01-08	ABBV	Stock	50.63	51.11	50.24	50.36	6811100.0
2014-01-08	ABC-DELISTED	Stock	70.33	71.412	70.28	71.14	1840620.0
2014-01-08	ABCB	Stock	20.94	21.01	20.52	20.58	114900.0
2014-01-08	ABCD-DELISTED	Stock	1.89	2.29	1.89	2.15	244018.0
2014-01-08	ABCO-DELISTED	Stock	60.54	61.94	60.196	61.84	204911.0
2014-01-08	ABE-DELISTED	Stock	13.77	13.929	13.72	13.74	12479.0
2014-01-08	ABEO	Stock	400.0	412.5	337.5	375.0	35.0
2014-01-08	ABEV	Stock	7.24	7.32	7.21	7.25	7226100.0
2014-01-08	ABFS-DELISTED	Stock	33.9	34.23	32.92	33.31	570335.0
2014-01-08	ABG	Stock	52.75	52.9	51.98	52.09	214600.0
2014-01-08	ABGB-DELISTED	Stock	15.51	15.7	15.2501	15.31	4300.0
2014-01-08	ABM	Stock	28.41	28.64	28.17	28.28	206900.0
2014-01-08	ABMD-DELISTED	Stock	27.54	28.3373	27.25	28.23	365343.0
2014-01-08	ABR	Stock	6.95	6.95	6.79	6.81	82400.0
2014-01-08	ABR.A-DELISTED	Stock	24.09	24.4	24.09	24.25	1300.0
2014-01-08	ABR.B-DELISTED	Stock	22.61	22.61	22.609	22.609	1547.0
2014-01-08	ABT	Stock	38.85	39.22	38.72	39.2	6140700.0
2014-01-08	ABTL-DELISTED	Stock	15.0	15.397	14.73	15.003	114748.0
2014-01-08	ABUS	Stock	7.98	8.57	7.98	8.52	197500.0

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

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