PREVIEW / stock_daily / 2015-09-24

all stock daily files

  file:    by_date/stock_daily/2015/2015-09-24.parquet
  size:    221 KB
  rows:    6,616
  symbols: 3,429

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-09-24	AAPL	Stock	28.3125	28.875	28.0925	28.75	200878000.0
2015-09-24	MSFT	Stock	43.45	44.13	43.27	43.91	27905600.0
2015-09-24	NVDA	Stock	0.5715	0.592	0.5625	0.586	382440000.0
2015-09-24	AMZN	Stock	26.5275	26.728	26.1435	26.6875	70020000.0
2015-09-24	GOOGL	Stock	32.4485	32.8385	32.1082	32.7455	38692780.0
2015-09-24	META	Stock	93.06	94.77	92.24	94.41	29106000.0
2015-09-24	TSLA	Stock	17.302	17.5633	17.0807	17.5413	51723000.0
2015-09-24	TLT	Stock	123.17	123.68	122.49	122.6	9605760.0
2015-09-24	ES	Stock	47.59	48.24	47.46	48.17	2281700.0
2015-09-24	CL	Stock	61.8	62.42	61.46	62.25	3791600.0
2015-09-24	A	Stock	34.56	34.64	34.15	34.55	2028900.0
2015-09-24	AA.B-DELISTED	Stock	33.09	33.45	32.33	33.3	50487.0
2015-09-24	AABA-DELISTED	Stock	29.47	29.57	28.85	29.34	17974498.0
2015-09-24	AAC-DELISTED	Stock	24.15	24.81	23.78	24.665	353209.0
2015-09-24	AACG	Stock	2.42	2.65	2.42	2.55	22900.0
2015-09-24	AAIC-DELISTED	Stock	15.75	15.8	15.51	15.76	572399.0
2015-09-24	AAL	Stock	41.15	41.15	39.92	40.25	10507300.0
2015-09-24	AAMC-DELISTED	Stock	6.8765	7.1941	6.5853	7.1765	39964.0
2015-09-24	AAME	Stock	3.79	3.96	3.79	3.96	9200.0
2015-09-24	AAMI	Stock	15.52	15.6	15.06	15.21	260800.0
2015-09-24	AAOI	Stock	18.63	18.72	18.25	18.64	236900.0
2015-09-24	AAON	Stock	12.9533	13.06	12.8267	13.0333	256500.0
2015-09-24	AAP	Stock	175.19	175.19	173.62	174.8	427200.0
2015-09-24	AAT	Stock	39.61	39.99	39.33	39.92	329200.0
2015-09-24	AAU-DELISTED	Stock	0.533	0.5499	0.53	0.53	44895.0
2015-09-24	AAUAF-DELISTED	Stock	0.533	0.5499	0.53	0.53	45148.0
2015-09-24	AAV-DELISTED	Stock	5.4	5.45	5.27	5.41	79419.0
2015-09-24	AAVL-DELISTED	Stock	9.77	10.05	9.75	9.84	376324.0
2015-09-24	AAWW-DELISTED	Stock	35.73	36.3	35.35	36.23	184278.0
2015-09-24	AAXJ	Stock	52.03	52.42	51.64	52.27	2721607.0
2015-09-24	AAXN-DELISTED	Stock	23.56	24.43	23.34	24.04	1649793.0
2015-09-24	AB	Stock	26.35	26.44	26.03	26.27	183800.0
2015-09-24	ABAC-DELISTED	Stock	0.66	0.66	0.5999	0.6099	22559.0
2015-09-24	ABAX-DELISTED	Stock	47.05	47.34	46.57	46.85	135587.0
2015-09-24	ABB-DELISTED	Stock	17.19	17.42	17.145	17.35	3315454.0
2015-09-24	ABBNY-DELISTED	Stock	17.18	17.42	17.145	17.36	3827094.0
2015-09-24	ABBV	Stock	56.93	57.48	55.92	56.57	8625500.0
2015-09-24	ABC-DELISTED	Stock	102.43	102.57	100.59	101.99	1377216.0
2015-09-24	ABCB	Stock	27.69	28.4	27.69	28.3	209300.0
2015-09-24	ABCD-DELISTED	Stock	4.89	4.95	4.78	4.93	37814.0
2015-09-24	ABCO-DELISTED	Stock	47.85	48.25	46.29	47.02	219803.0
2015-09-24	ABCW-DELISTED	Stock	39.59	40.68	39.59	40.66	61572.0
2015-09-24	ABDC-DELISTED	Stock	12.86	12.95	12.62	12.89	125219.0
2015-09-24	ABE-DELISTED	Stock	10.72	10.7629	10.7131	10.7629	2165.0
2015-09-24	ABEO	Stock	120.0	128.5	118.75	123.25	5044.0
2015-09-24	ABEOW-DELISTED	Stock	2.35	2.35	1.82	2.0	15922.0
2015-09-24	ABEV	Stock	4.44	4.77	4.41	4.74	21122600.0
2015-09-24	ABG	Stock	82.85	83.12	80.73	82.08	207000.0
2015-09-24	ABGB-DELISTED	Stock	5.51	5.51	5.19	5.37	80578.0
2015-09-24	ABM	Stock	28.85	28.88	28.54	28.69	334200.0

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

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