PREVIEW / stock_daily / 2015-01-06

all stock daily files

  file:    by_date/stock_daily/2015/2015-01-06.parquet
  size:    223 KB
  rows:    6,669
  symbols: 3,548

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-01-06	AAPL	Stock	26.635	26.8575	26.1575	26.565	263188400.0
2015-01-06	MSFT	Stock	46.38	46.75	45.54	45.65	36447900.0
2015-01-06	NVDA	Stock	0.4955	0.496	0.4793	0.4798	197764000.0
2015-01-06	AMZN	Stock	15.112	15.15	14.619	14.7645	70380000.0
2015-01-06	GOOGL	Stock	26.025	26.0605	25.2775	25.332	54636260.0
2015-01-06	META	Stock	77.23	77.59	75.36	76.15	27399300.0
2015-01-06	TSLA	Stock	14.004	14.28	13.614	14.0853	93928500.0
2015-01-06	TLT	Stock	130.7	132.49	130.19	131.65	18331287.0
2015-01-06	ES	Stock	53.39	54.19	53.06	53.29	2680800.0
2015-01-06	CL	Stock	68.73	68.87	67.63	67.81	3437400.0
2015-01-06	A	Stock	39.81	40.02	39.02	39.18	2080600.0
2015-01-06	AA.B-DELISTED	Stock	49.51	49.68	48.67	48.81	109820.0
2015-01-06	AABA-DELISTED	Stock	49.2	49.73	48.33	49.2	14956724.0
2015-01-06	AAC-DELISTED	Stock	29.84	29.84	28.29	29.33	60179.0
2015-01-06	AACG	Stock	4.4	4.8	4.13	4.51	44600.0
2015-01-06	AAIC-DELISTED	Stock	26.61	26.68	26.0	26.17	263046.0
2015-01-06	AAL	Stock	54.27	54.43	52.13	53.04	13772200.0
2015-01-06	AAMC-DELISTED	Stock	99.2647	99.2647	91.2412	96.4706	102309.0
2015-01-06	AAME	Stock	3.95	3.95	3.75	3.92	9700.0
2015-01-06	AAMI	Stock	15.99	16.11	15.05	15.47	271200.0
2015-01-06	AAOI	Stock	10.65	10.69	10.15	10.25	183500.0
2015-01-06	AAON	Stock	14.14	14.16	13.66	13.9	188850.0
2015-01-06	AAP	Stock	156.56	157.29	153.9	156.36	872300.0
2015-01-06	AAT	Stock	41.0	41.21	40.59	41.15	307300.0
2015-01-06	AAU-DELISTED	Stock	0.98	1.0394	0.96	1.0	268368.0
2015-01-06	AAUAF-DELISTED	Stock	0.98	1.0394	0.96	1.0	269811.0
2015-01-06	AAV-DELISTED	Stock	4.52	4.62	4.33	4.53	311997.0
2015-01-06	AAVL-DELISTED	Stock	58.49	59.87	53.76	53.87	362153.0
2015-01-06	AAWW-DELISTED	Stock	47.15	47.55	45.55	45.67	326230.0
2015-01-06	AAXJ	Stock	59.6	59.838	59.04	59.32	725938.0
2015-01-06	AAXN-DELISTED	Stock	26.11	26.2199	24.743	25.56	3312185.0
2015-01-06	AB	Stock	25.2	25.52	24.63	24.63	298800.0
2015-01-06	ABAC-DELISTED	Stock	1.7798	1.7798	1.7	1.7	5600.0
2015-01-06	ABAX-DELISTED	Stock	57.62	58.07	56.41	57.11	192232.0
2015-01-06	ABB-DELISTED	Stock	20.29	20.42	20.04	20.11	1564261.0
2015-01-06	ABBNY-DELISTED	Stock	20.29	20.42	20.04	20.1	1772011.0
2015-01-06	ABBV	Stock	65.62	65.75	63.7	64.33	5483700.0
2015-01-06	ABC-DELISTED	Stock	90.14	91.42	89.52	90.2	1543844.0
2015-01-06	ABCB	Stock	25.26	25.26	24.41	24.73	103300.0
2015-01-06	ABCD-DELISTED	Stock	1.73	1.75	1.67	1.7299	24523.0
2015-01-06	ABCO-DELISTED	Stock	48.81	49.18	48.01	48.54	244968.0
2015-01-06	ABCW-DELISTED	Stock	34.8	34.96	34.47	34.96	28701.0
2015-01-06	ABDC-DELISTED	Stock	12.89	12.99	12.8	12.97	51228.0
2015-01-06	ABE-DELISTED	Stock	12.88	12.98	12.86	12.9232	9425.0
2015-01-06	ABEO	Stock	85.0	87.5	80.25	81.25	228.0
2015-01-06	ABEOW-DELISTED	Stock	0.919	0.919	0.919	0.919	500.0
2015-01-06	ABEV	Stock	5.85	6.09	5.84	6.06	22492100.0
2015-01-06	ABG	Stock	72.82	74.13	71.78	72.69	453600.0
2015-01-06	ABGB-DELISTED	Stock	12.73	13.024	12.22	12.22	123697.0
2015-01-06	ABIL-DELISTED	Stock	9.74	9.88	9.73	9.77	15100.0

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

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