PREVIEW / stock_daily / 2014-04-17

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-17.parquet
  size:    217 KB
  rows:    6,511
  symbols: 3,544

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-04-17	AAPL	Stock	18.5714	18.8486	18.5429	18.7479	284334400.0
2014-04-17	MSFT	Stock	40.01	40.2	39.51	40.01	36688400.0
2014-04-17	NVDA	Stock	0.4605	0.4683	0.4595	0.464	153532000.0
2014-04-17	AMZN	Stock	15.988	16.433	15.988	16.2455	85984000.0
2014-04-17	GOOGL	Stock	27.816	27.85	26.97	27.167	112337240.0
2014-04-17	META	Stock	59.3	60.58	58.72	58.94	88040000.0
2014-04-17	TSLA	Stock	13.3073	13.486	12.9387	13.208	88902000.0
2014-04-17	TLT	Stock	111.37	111.45	109.7	110.05	8622740.0
2014-04-17	ES	Stock	46.42	46.64	45.79	45.93	1435400.0
2014-04-17	CL	Stock	66.75	67.17	66.53	66.94	3599300.0
2014-04-17	A	Stock	38.4406	39.2632	38.3476	39.0916	2882676.0
2014-04-17	AABA-DELISTED	Stock	36.27	36.6	35.55	36.38	27926198.0
2014-04-17	AACG	Stock	4.12	4.15	4.12	4.15	5000.0
2014-04-17	AAIC-DELISTED	Stock	25.87	25.9295	25.76	25.86	105620.0
2014-04-17	AAL	Stock	35.5	35.87	34.82	35.4	9225000.0
2014-04-17	AAMC-DELISTED	Stock	276.4706	294.1147	276.4706	286.7647	53261.0
2014-04-17	AAME	Stock	3.54	3.54	3.47	3.47	10200.0
2014-04-17	AAOI	Stock	22.7	23.9	22.36	23.61	216700.0
2014-04-17	AAON	Stock	11.64	11.8933	11.5556	11.8667	162225.0
2014-04-17	AAP	Stock	119.48	122.34	119.07	120.84	803400.0
2014-04-17	AAT	Stock	33.17	33.35	33.0	33.25	104400.0
2014-04-17	AAU-DELISTED	Stock	1.36	1.46	1.34	1.37	189200.0
2014-04-17	AAUAF-DELISTED	Stock	1.34	1.44	1.32	1.37	193542.0
2014-04-17	AAV-DELISTED	Stock	5.65	5.75	5.55	5.73	478640.0
2014-04-17	AAWW-DELISTED	Stock	34.93	35.42	34.72	35.37	202349.0
2014-04-17	AAXJ	Stock	60.74	61.07	60.67	60.87	149723.0
2014-04-17	AAXN-DELISTED	Stock	17.79	17.94	17.39	17.87	1215215.0
2014-04-17	AB	Stock	25.58	25.63	24.94	25.4	443100.0
2014-04-17	ABAC-DELISTED	Stock	1.95	2.04	1.95	2.01	24350.0
2014-04-17	ABAX-DELISTED	Stock	38.61	39.47	38.43	39.16	82044.0
2014-04-17	ABB-DELISTED	Stock	25.75	26.0	25.73	25.89	1493876.0
2014-04-17	ABBNY-DELISTED	Stock	25.75	26.0	25.73	25.9	1617533.0
2014-04-17	ABBV	Stock	47.92	48.78	47.72	48.55	6196800.0
2014-04-17	ABC-DELISTED	Stock	64.75	65.09	64.48	64.69	929718.0
2014-04-17	ABCB	Stock	22.3	22.4	22.15	22.26	47400.0
2014-04-17	ABCD-DELISTED	Stock	2.161	2.18	2.15	2.15	9952.0
2014-04-17	ABCO-DELISTED	Stock	60.23	61.46	59.68	60.43	117829.0
2014-04-17	ABE-DELISTED	Stock	13.27	13.47	13.27	13.41	12332.0
2014-04-17	ABEO	Stock	562.5	575.0	562.5	562.5	5.0
2014-04-17	ABEV	Stock	7.72	7.78	7.67	7.77	9064700.0
2014-04-17	ABFS-DELISTED	Stock	37.25	38.24	36.92	38.05	206939.0
2014-04-17	ABG	Stock	54.85	55.73	54.85	55.03	160900.0
2014-04-17	ABGB-DELISTED	Stock	21.86	22.64	21.86	22.57	7731.0
2014-04-17	ABIL-DELISTED	Stock	9.69	9.835	9.634	9.64	78186.0
2014-04-17	ABM	Stock	27.24	27.79	27.23	27.69	137400.0
2014-04-17	ABMD-DELISTED	Stock	24.42	24.86	24.25	24.64	219975.0
2014-04-17	ABR	Stock	6.98	7.04	6.96	7.01	80600.0
2014-04-17	ABR.A-DELISTED	Stock	24.98	25.02	24.98	25.02	1204.0
2014-04-17	ABR.B-DELISTED	Stock	23.34	23.52	23.27	23.43	24939.0
2014-04-17	ABR.C-DELISTED	Stock	24.8423	24.85	24.8423	24.85	5155.0

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

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