PREVIEW / stock_daily / 2015-04-01

all stock daily files

  file:    by_date/stock_daily/2015/2015-04-01.parquet
  size:    223 KB
  rows:    6,633
  symbols: 3,502

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
2015-04-01	AAPL	Stock	31.205	31.28	30.775	31.0625	162485600.0
2015-04-01	MSFT	Stock	40.6	40.76	40.31	40.72	36865300.0
2015-04-01	NVDA	Stock	0.5253	0.527	0.5162	0.5253	330768000.0
2015-04-01	AMZN	Stock	18.605	18.658	18.417	18.513	49162000.0
2015-04-01	GOOGL	Stock	27.7415	27.925	27.3015	27.4745	38901800.0
2015-04-01	META	Stock	82.5	82.72	80.87	81.67	22058200.0
2015-04-01	TSLA	Stock	12.58	12.82	12.4033	12.506	56919000.0
2015-04-01	TLT	Stock	131.33	132.48	131.3	132.13	9273941.0
2015-04-01	ES	Stock	50.16	50.89	49.86	50.73	1060800.0
2015-04-01	CL	Stock	69.34	69.34	68.61	69.09	3075100.0
2015-04-01	A	Stock	41.46	41.52	40.72	41.39	2170300.0
2015-04-01	AA.B-DELISTED	Stock	44.1	44.47	43.92	44.19	127680.0
2015-04-01	AABA-DELISTED	Stock	44.45	44.6	43.95	44.12	10054382.0
2015-04-01	AAC-DELISTED	Stock	30.58	31.76	30.44	30.78	153094.0
2015-04-01	AACG	Stock	4.12	4.12	3.9	3.93	5900.0
2015-04-01	AAIC-DELISTED	Stock	24.05	24.28	23.87	24.02	242326.0
2015-04-01	AAL	Stock	51.1	51.38	50.11	50.44	15191500.0
2015-04-01	AAMC-DELISTED	Stock	57.3471	61.7	56.7676	59.6971	114060.0
2015-04-01	AAME	Stock	3.96	3.98	3.96	3.98	700.0
2015-04-01	AAMI	Stock	18.64	18.97	18.5	18.58	135800.0
2015-04-01	AAOI	Stock	13.83	13.89	13.16	13.43	192800.0
2015-04-01	AAON	Stock	16.22	16.32	15.8267	15.8933	287550.0
2015-04-01	AAP	Stock	147.78	148.85	143.45	143.75	2423300.0
2015-04-01	AAT	Stock	43.2	43.5	42.83	43.15	93900.0
2015-04-01	AAU-DELISTED	Stock	0.92	0.92	0.8821	0.8997	61977.0
2015-04-01	AAUAF-DELISTED	Stock	0.92	0.92	0.8821	0.9	62612.0
2015-04-01	AAV-DELISTED	Stock	5.35	5.57	5.35	5.49	180942.0
2015-04-01	AAVL-DELISTED	Stock	40.28	40.28	38.17	39.06	444935.0
2015-04-01	AAWW-DELISTED	Stock	42.74	44.34	42.6357	43.41	177997.0
2015-04-01	AAXJ	Stock	64.4	64.64	64.29	64.62	1206047.0
2015-04-01	AAXN-DELISTED	Stock	24.01	24.38	23.41	24.24	937020.0
2015-04-01	AB	Stock	30.97	31.0	30.55	30.93	198000.0
2015-04-01	ABAC-DELISTED	Stock	1.5	1.56	1.5	1.51	42636.0
2015-04-01	ABAX-DELISTED	Stock	63.92	64.02	62.52	63.86	100200.0
2015-04-01	ABB-DELISTED	Stock	21.38	21.43	21.23	21.37	1628235.0
2015-04-01	ABBNY-DELISTED	Stock	21.38	21.43	21.23	21.38	1684281.0
2015-04-01	ABBV	Stock	58.48	58.49	56.33	57.1	14903300.0
2015-04-01	ABC-DELISTED	Stock	113.93	113.93	111.41	112.04	1816254.0
2015-04-01	ABCB	Stock	26.38	26.67	26.23	26.66	111900.0
2015-04-01	ABCD-DELISTED	Stock	3.17	3.2225	3.1401	3.2	28343.0
2015-04-01	ABCO-DELISTED	Stock	52.96	53.71	50.74	51.86	271074.0
2015-04-01	ABCW-DELISTED	Stock	34.75	34.98	34.3	34.95	14988.0
2015-04-01	ABDC-DELISTED	Stock	13.31	13.69	13.3	13.55	32983.0
2015-04-01	ABE-DELISTED	Stock	12.59	12.76	12.59	12.7201	15874.0
2015-04-01	ABEO	Stock	75.75	75.75	73.75	75.5	576.0
2015-04-01	ABEV	Stock	5.93	6.02	5.82	5.92	23946500.0
2015-04-01	ABG	Stock	83.07	83.55	81.46	82.26	261600.0
2015-04-01	ABGB-DELISTED	Stock	18.2	18.2	18.0	18.13	14682.0
2015-04-01	ABIL-DELISTED	Stock	10.05	10.09	10.05	10.09	484919.0
2015-04-01	ABM	Stock	31.89	32.11	31.64	31.92	266700.0

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

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