PREVIEW / stock_daily / 2015-09-04

all stock daily files

  file:    by_date/stock_daily/2015/2015-09-04.parquet
  size:    221 KB
  rows:    6,619
  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-04	AAPL	Stock	27.2425	27.6125	27.1275	27.3175	199985200.0
2015-09-04	MSFT	Stock	42.81	43.04	42.2	42.61	37138800.0
2015-09-04	NVDA	Stock	0.5472	0.556	0.5435	0.5438	287972000.0
2015-09-04	AMZN	Stock	24.8825	25.1425	24.782	24.95	53850000.0
2015-09-04	GOOGL	Stock	31.485	31.725	31.325	31.448	40499800.0
2015-09-04	META	Stock	87.2	88.39	86.7	88.26	27328700.0
2015-09-04	TSLA	Stock	16.0593	16.2727	15.88	16.1287	55338000.0
2015-09-04	TLT	Stock	122.45	122.925	121.82	122.68	7951303.0
2015-09-04	ES	Stock	46.03	46.18	45.63	45.74	1494700.0
2015-09-04	CL	Stock	61.86	62.19	61.39	61.46	5100300.0
2015-09-04	A	Stock	35.04	35.51	34.9	35.06	2819000.0
2015-09-04	AA.B-DELISTED	Stock	34.51	35.48	34.51	35.28	7730.0
2015-09-04	AABA-DELISTED	Stock	32.01	32.29	31.44	31.59	13119166.0
2015-09-04	AAC-DELISTED	Stock	24.83	25.2	23.58	23.97	435774.0
2015-09-04	AACG	Stock	2.35	2.35	2.3	2.32	9700.0
2015-09-04	AAIC-DELISTED	Stock	16.0	16.003	15.68	15.73	214011.0
2015-09-04	AAL	Stock	40.4	41.32	40.15	40.6	9738400.0
2015-09-04	AAMC-DELISTED	Stock	10.2941	10.2941	9.3382	9.5882	32660.0
2015-09-04	AAME	Stock	3.52	3.55	3.43	3.5	3000.0
2015-09-04	AAMI	Stock	16.14	16.33	16.0	16.25	136600.0
2015-09-04	AAOI	Stock	20.23	20.55	20.09	20.17	217700.0
2015-09-04	AAON	Stock	13.1133	13.3267	13.0	13.1267	222150.0
2015-09-04	AAP	Stock	171.82	173.41	170.96	172.13	687700.0
2015-09-04	AAT	Stock	37.77	38.12	37.27	37.49	63300.0
2015-09-04	AAU-DELISTED	Stock	0.5102	0.54	0.51	0.51	42494.0
2015-09-04	AAUAF-DELISTED	Stock	0.5115	0.54	0.511	0.511	44446.0
2015-09-04	AAV-DELISTED	Stock	5.3	5.39	5.24	5.24	51717.0
2015-09-04	AAVL-DELISTED	Stock	10.02	10.22	9.91	10.17	349180.0
2015-09-04	AAWW-DELISTED	Stock	38.25	38.71	37.75	37.9	206259.0
2015-09-04	AAXJ	Stock	51.33	51.57	50.73	50.94	1189463.0
2015-09-04	AAXN-DELISTED	Stock	23.24	23.9499	23.02	23.64	653347.0
2015-09-04	AB	Stock	25.5	26.0	25.2	25.34	273200.0
2015-09-04	ABAC-DELISTED	Stock	0.85	0.85	0.75	0.7864	3818.0
2015-09-04	ABAX-DELISTED	Stock	46.58	47.43	46.224	47.08	69718.0
2015-09-04	ABB-DELISTED	Stock	18.31	18.4	18.22	18.33	1807813.0
2015-09-04	ABBNY-DELISTED	Stock	18.31	18.4	18.22	18.33	1906084.0
2015-09-04	ABBV	Stock	60.65	60.8	58.96	59.77	9281400.0
2015-09-04	ABC-DELISTED	Stock	100.66	101.4	98.36	98.99	2211269.0
2015-09-04	ABCB	Stock	26.92	27.45	26.92	27.39	87900.0
2015-09-04	ABCD-DELISTED	Stock	4.99	5.15	4.85	5.09	28997.0
2015-09-04	ABCO-DELISTED	Stock	48.02	49.07	47.64	48.37	309919.0
2015-09-04	ABCW-DELISTED	Stock	40.47	41.37	40.17	40.39	16905.0
2015-09-04	ABDC-DELISTED	Stock	12.91	12.945	12.68	12.84	7418.0
2015-09-04	ABE-DELISTED	Stock	10.98	10.98	10.69	10.8075	5022.0
2015-09-04	ABEO	Stock	112.25	120.25	112.0	119.0	1972.0
2015-09-04	ABEOW-DELISTED	Stock	1.8	1.87	1.8	1.83	1685.0
2015-09-04	ABEV	Stock	5.2	5.21	5.07	5.09	9685500.0
2015-09-04	ABG	Stock	78.29	79.27	77.83	78.82	234600.0
2015-09-04	ABGB-DELISTED	Stock	5.0	5.03	4.86	4.93	52332.0
2015-09-04	ABM	Stock	29.94	30.08	29.21	29.24	1105700.0

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

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