PREVIEW / stock_daily / 2016-01-21

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-21.parquet
  size:    219 KB
  rows:    6,619
  symbols: 3,385

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
2016-01-21	AAPL	Stock	24.265	24.47	23.735	24.075	208646000.0
2016-01-21	MSFT	Stock	51.0	51.58	50.3	50.48	40191200.0
2016-01-21	NVDA	Stock	0.6945	0.7058	0.6802	0.695	481456000.0
2016-01-21	AMZN	Stock	28.679	29.4405	28.411	28.751	99044000.0
2016-01-21	GOOGL	Stock	36.0085	36.8835	35.5555	36.3335	51938320.0
2016-01-21	META	Stock	94.91	95.99	92.62	94.16	30518900.0
2016-01-21	TSLA	Stock	13.4367	13.5487	13.0013	13.3313	47493000.0
2016-01-21	TLT	Stock	126.94	127.288	125.67	125.82	11001621.0
2016-01-21	ES	Stock	51.27	51.47	50.21	50.58	2350200.0
2016-01-21	CL	Stock	62.32	63.96	61.91	63.65	5645300.0
2016-01-21	A	Stock	37.35	37.83	36.81	37.23	2298400.0
2016-01-21	AA.B-DELISTED	Stock	24.56	25.84	24.5	25.43	110992.0
2016-01-21	AAAP-DELISTED	Stock	27.0	27.0	26.12	26.48	43942.0
2016-01-21	AABA-DELISTED	Stock	28.75	29.795	28.1899	29.31	15115809.0
2016-01-21	AAC-DELISTED	Stock	16.38	17.37	16.28	16.51	125297.0
2016-01-21	AACG	Stock	5.13	5.39	5.0	5.19	25300.0
2016-01-21	AAIC-DELISTED	Stock	10.25	10.59	10.04	10.25	284925.0
2016-01-21	AAL	Stock	38.93	40.0	38.02	39.79	9781700.0
2016-01-21	AAMC-DELISTED	Stock	4.8235	4.8559	4.3647	4.5412	119313.0
2016-01-21	AAME	Stock	4.12	4.31	4.0	4.22	3300.0
2016-01-21	AAMI	Stock	11.57	11.77	11.14	11.16	191300.0
2016-01-21	AAOI	Stock	12.43	13.05	12.22	12.93	214700.0
2016-01-21	AAON	Stock	13.2867	13.58	13.2	13.3	208500.0
2016-01-21	AAP	Stock	143.24	146.39	142.27	143.8	706800.0
2016-01-21	AAT	Stock	36.23	36.69	35.9	36.4	171100.0
2016-01-21	AAU-DELISTED	Stock	0.54	0.5494	0.5296	0.5368	30199.0
2016-01-21	AAUAF-DELISTED	Stock	0.54	0.5494	0.5296	0.5368	31137.0
2016-01-21	AAV-DELISTED	Stock	4.85	5.25	4.76	5.08	164781.0
2016-01-21	AAVL-DELISTED	Stock	6.22	6.4	5.92	6.24	277909.0
2016-01-21	AAWW-DELISTED	Stock	36.02	37.467	35.87	36.29	224417.0
2016-01-21	AAXJ	Stock	47.01	47.83	46.8	47.32	1187918.0
2016-01-21	AAXN-DELISTED	Stock	15.86	16.68	15.1	15.66	2867807.0
2016-01-21	AB	Stock	18.17	18.99	18.04	18.59	346200.0
2016-01-21	ABAC-DELISTED	Stock	0.661	0.7143	0.661	0.7143	2700.0
2016-01-21	ABAX-DELISTED	Stock	53.36	53.74	51.81	52.34	338470.0
2016-01-21	ABB-DELISTED	Stock	15.96	16.195	15.83	16.09	3104981.0
2016-01-21	ABBNY-DELISTED	Stock	15.96	16.195	15.83	16.09	3170313.0
2016-01-21	ABBV	Stock	57.29	58.77	56.92	58.36	12097000.0
2016-01-21	ABC-DELISTED	Stock	90.9	91.83	89.79	90.56	1836678.0
2016-01-21	ABCB	Stock	29.26	29.41	28.9	29.22	229400.0
2016-01-21	ABCD-DELISTED	Stock	4.16	4.4399	4.03	4.29	141180.0
2016-01-21	ABCO-DELISTED	Stock	45.23	45.23	43.73	43.93	178125.0
2016-01-21	ABCW-DELISTED	Stock	41.8	42.18	41.37	41.47	145722.0
2016-01-21	ABDC-DELISTED	Stock	9.0	9.91	9.0	9.78	85342.0
2016-01-21	ABE-DELISTED	Stock	9.54	9.84	9.54	9.83	8209.0
2016-01-21	ABEO	Stock	70.75	75.0	69.5	71.25	2052.0
2016-01-21	ABEV	Stock	3.92	3.97	3.86	3.88	26020500.0
2016-01-21	ABG	Stock	48.5	49.53	47.2	47.36	376700.0
2016-01-21	ABGB-DELISTED	Stock	0.8705	0.8955	0.8109	0.82	42569.0
2016-01-21	ABIL-DELISTED	Stock	9.0	9.214	9.0	9.1	35700.0

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

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