PREVIEW / stock_daily / 2017-01-05

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-05.parquet
  size:    215 KB
  rows:    6,479
  symbols: 3,099

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
2017-01-05	AAPL	Stock	28.98	29.215	28.9525	29.1525	88774400.0
2017-01-05	MSFT	Stock	62.19	62.66	62.03	62.3	24876000.0
2017-01-05	NVDA	Stock	2.6133	2.6455	2.5262	2.5435	984296000.0
2017-01-05	AMZN	Stock	38.0775	39.12	38.013	39.0225	116602000.0
2017-01-05	GOOGL	Stock	40.375	40.687	40.296	40.651	26810700.0
2017-01-05	META	Stock	118.86	120.95	118.32	120.67	19492200.0
2017-01-05	TSLA	Stock	15.0947	15.1653	14.7967	15.1167	88675500.0
2017-01-05	TLT	Stock	120.45	122.03	120.17	121.98	13265820.0
2017-01-05	ES	Stock	55.49	55.49	54.8	55.28	1590700.0
2017-01-05	CL	Stock	66.31	66.99	66.13	66.85	2857800.0
2017-01-05	A	Stock	47.05	47.07	46.36	46.54	1503700.0
2017-01-05	AA	Stock	30.18	30.93	30.115	30.65	2444600.0
2017-01-05	AAAP-DELISTED	Stock	27.04	27.68	26.8	27.36	57209.0
2017-01-05	AABA-DELISTED	Stock	40.32	41.37	40.24	41.34	9322054.0
2017-01-05	AAC-DELISTED	Stock	7.66	7.76	7.43	7.54	234475.0
2017-01-05	AACG	Stock	3.82	3.9	3.82	3.9	600.0
2017-01-05	AAIC-DELISTED	Stock	15.22	15.33	15.0	15.05	319447.0
2017-01-05	AAL	Stock	46.52	46.93	45.61	45.89	6825300.0
2017-01-05	AAMC-DELISTED	Stock	16.4706	18.0993	15.2941	17.0588	67833.0
2017-01-05	AAME	Stock	4.17	4.17	3.85	3.85	7000.0
2017-01-05	AAMI	Stock	14.49	14.7	14.27	14.48	227200.0
2017-01-05	AAOI	Stock	23.5	23.51	22.611	22.81	160800.0
2017-01-05	AAON	Stock	22.7	22.7333	21.8	22.0667	219900.0
2017-01-05	AAP	Stock	170.87	173.06	170.23	171.88	861000.0
2017-01-05	AAT	Stock	43.65	44.01	43.32	43.96	312200.0
2017-01-05	AAU-DELISTED	Stock	1.04	1.05	1.0	1.02	441840.0
2017-01-05	AAUAF-DELISTED	Stock	1.04	1.05	1.0	1.02	445707.0
2017-01-05	AAV-DELISTED	Stock	6.65	6.75	6.625	6.65	76612.0
2017-01-05	AAWW-DELISTED	Stock	52.05	52.65	51.15	51.2	158133.0
2017-01-05	AAXJ	Stock	56.58	56.95	56.58	56.81	2471483.0
2017-01-05	AAXN-DELISTED	Stock	24.84	25.0	24.5	24.69	459551.0
2017-01-05	AB	Stock	24.15	24.4	24.0	24.35	241000.0
2017-01-05	ABAC-DELISTED	Stock	3.63	3.7037	3.63	3.7	1000.0
2017-01-05	ABAX-DELISTED	Stock	53.26	54.05	52.2	52.61	96792.0
2017-01-05	ABB-DELISTED	Stock	21.35	21.58	21.345	21.56	1474487.0
2017-01-05	ABBNY-DELISTED	Stock	21.35	21.58	21.345	21.56	1515354.0
2017-01-05	ABBV	Stock	63.38	63.95	63.03	63.77	5359400.0
2017-01-05	ABC-DELISTED	Stock	84.36	84.83	82.62	83.67	1763637.0
2017-01-05	ABCB	Stock	44.45	44.7	43.2	44.2	172100.0
2017-01-05	ABCD-DELISTED	Stock	5.05	5.19	5.0	5.17	37698.0
2017-01-05	ABCO-DELISTED	Stock	33.4	34.65	32.95	34.15	862646.0
2017-01-05	ABDC-DELISTED	Stock	12.81	12.8638	12.48	12.54	23206.0
2017-01-05	ABE-DELISTED	Stock	11.52	11.52	11.49	11.5011	679.0
2017-01-05	ABEO	Stock	133.75	140.0	128.75	140.0	9708.0
2017-01-05	ABEOW-DELISTED	Stock	2.7	2.7	2.7	2.7	314.0
2017-01-05	ABEV	Stock	5.12	5.19	5.1	5.16	9034400.0
2017-01-05	ABG	Stock	61.3	64.7	61.3	62.8	162200.0
2017-01-05	ABIL-DELISTED	Stock	3.13	3.23	3.13	3.1799	45430.0
2017-01-05	ABM	Stock	41.41	41.41	40.56	40.57	457100.0
2017-01-05	ABMD-DELISTED	Stock	115.9	116.05	113.7	114.71	312849.0

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

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