PREVIEW / stock_daily / 2014-01-10

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-10.parquet
  size:    216 KB
  rows:    6,446
  symbols: 3,525

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-10	AAPL	Stock	19.2796	19.3143	18.9682	19.0336	304976000.0
2014-01-10	MSFT	Stock	35.9	36.15	35.75	36.04	40548800.0
2014-01-10	NVDA	Stock	0.395	0.3978	0.3898	0.3933	218492000.0
2014-01-10	AMZN	Stock	20.1265	20.188	19.69	19.883	53590000.0
2014-01-10	META	Stock	57.13	58.3	57.06	57.94	42449500.0
2014-01-10	TSLA	Stock	9.8973	9.9267	9.4833	9.7147	111691500.0
2014-01-10	TLT	Stock	103.77	104.5425	103.69	104.41	13197803.0
2014-01-10	ES	Stock	42.14	42.84	42.14	42.65	1657400.0
2014-01-10	CL	Stock	65.12	65.46	64.88	65.08	2956500.0
2014-01-10	A	Stock	41.8526	42.2103	41.588	42.1531	2269234.0
2014-01-10	AABA-DELISTED	Stock	40.9	41.35	40.82	41.23	8252305.0
2014-01-10	AACG	Stock	4.1	4.1	4.0	4.0	64800.0
2014-01-10	AAIC-DELISTED	Stock	26.34	26.7	26.24	26.69	115110.0
2014-01-10	AAL	Stock	29.05	29.83	28.75	29.35	12807800.0
2014-01-10	AAMC-DELISTED	Stock	289.7059	303.4382	286.7706	301.1765	41181.0
2014-01-10	AAME	Stock	4.04	4.06	3.99	4.02	14400.0
2014-01-10	AAOI	Stock	14.16	14.32	13.58	14.0	48200.0
2014-01-10	AAON	Stock	14.0311	14.5911	13.84	13.9644	226125.0
2014-01-10	AAP	Stock	114.28	115.8	113.64	115.64	678600.0
2014-01-10	AAT	Stock	31.28	31.99	31.28	31.97	75900.0
2014-01-10	AAU-DELISTED	Stock	1.25	1.25	1.2	1.2	67124.0
2014-01-10	AAUAF-DELISTED	Stock	1.25	1.25	1.2	1.2	67648.0
2014-01-10	AAV-DELISTED	Stock	4.24	4.36	4.2	4.36	127664.0
2014-01-10	AAWW-DELISTED	Stock	41.99	43.05	41.75	43.05	241079.0
2014-01-10	AAXJ	Stock	57.86	58.52	57.86	58.41	355872.0
2014-01-10	AAXN-DELISTED	Stock	17.79	18.88	17.5	18.68	2653769.0
2014-01-10	AB	Stock	22.2	22.46	22.02	22.25	353900.0
2014-01-10	ABAC-DELISTED	Stock	2.03	2.18	2.02	2.15	74194.0
2014-01-10	ABAX-DELISTED	Stock	42.25	43.45	42.08	43.42	144415.0
2014-01-10	ABB-DELISTED	Stock	26.09	26.3	26.07	26.29	858610.0
2014-01-10	ABBNY-DELISTED	Stock	26.1	26.3	26.07	26.3	1297496.0
2014-01-10	ABBV	Stock	51.27	51.49	50.76	50.9	5517700.0
2014-01-10	ABC-DELISTED	Stock	71.49	71.55	71.0401	71.35	1443274.0
2014-01-10	ABCB	Stock	20.61	20.77	19.7	20.54	132500.0
2014-01-10	ABCD-DELISTED	Stock	2.31	2.31	2.14	2.24	89789.0
2014-01-10	ABCO-DELISTED	Stock	61.36	62.03	59.49	60.0	273709.0
2014-01-10	ABE-DELISTED	Stock	13.62	13.624	13.53	13.54	14395.0
2014-01-10	ABEO	Stock	362.5	375.0	312.5	350.0	11.0
2014-01-10	ABEV	Stock	7.11	7.32	7.09	7.3	13637500.0
2014-01-10	ABFS-DELISTED	Stock	34.19	34.77	33.84	34.25	729220.0
2014-01-10	ABG	Stock	52.01	52.02	51.01	51.43	140900.0
2014-01-10	ABGB-DELISTED	Stock	15.48	16.2099	15.48	15.97	66884.0
2014-01-10	ABM	Stock	28.48	28.58	28.21	28.39	281500.0
2014-01-10	ABMD-DELISTED	Stock	29.67	30.77	29.32	30.03	399598.0
2014-01-10	ABR	Stock	6.82	6.87	6.76	6.79	63600.0
2014-01-10	ABR.A-DELISTED	Stock	24.51	24.51	24.51	24.51	100.0
2014-01-10	ABR.B-DELISTED	Stock	22.61	22.61	22.4	22.41	4080.0
2014-01-10	ABT	Stock	39.27	39.63	39.11	39.57	6360500.0
2014-01-10	ABTL-DELISTED	Stock	14.52	14.54	13.88	14.12	112935.0
2014-01-10	ABUS	Stock	9.25	10.16	9.11	9.88	366200.0

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

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