PREVIEW / stock_daily / 2017-08-29

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-29.parquet
  size:    213 KB
  rows:    6,440
  symbols: 2,948

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-08-29	AAPL	Stock	40.025	40.78	40.0	40.7275	118067600.0
2017-08-29	MSFT	Stock	72.25	73.16	72.05	73.05	11478400.0
2017-08-29	NVDA	Stock	4.0648	4.1395	4.0565	4.1175	324096000.0
2017-08-29	AMZN	Stock	47.0	47.8	46.8165	47.703	57486000.0
2017-08-29	GOOGL	Stock	45.9975	46.9095	45.9655	46.7875	23171520.0
2017-08-29	META	Stock	165.25	168.43	165.0	168.05	11121000.0
2017-08-29	TSLA	Stock	22.632	23.27	22.5833	23.1573	61105500.0
2017-08-29	TLT	Stock	128.46	128.5225	127.31	127.65	7659555.0
2017-08-29	ES	Stock	63.41	63.67	63.21	63.29	647300.0
2017-08-29	CL	Stock	70.78	71.86	70.67	71.3	2691800.0
2017-08-29	A	Stock	63.04	63.63	63.02	63.49	1206600.0
2017-08-29	AA	Stock	41.66	43.18	41.38	43.0	3982400.0
2017-08-29	AAAP-DELISTED	Stock	48.5	49.05	47.76	48.4	44122.0
2017-08-29	AABA-DELISTED	Stock	62.3	63.72	62.1	63.165	3284805.0
2017-08-29	AAC-DELISTED	Stock	9.15	9.16	8.9	8.98	56799.0
2017-08-29	AACG	Stock	4.7	4.7	4.53	4.67	2100.0
2017-08-29	AAIC-DELISTED	Stock	12.95	12.99	12.8079	12.85	207362.0
2017-08-29	AAL	Stock	44.53	44.85	44.38	44.56	5195100.0
2017-08-29	AAM.A-DELISTED	Stock	26.2656	26.43	26.2656	26.3556	31688.0
2017-08-29	AAMC-DELISTED	Stock	23.2353	25.2941	23.2353	25.2941	9241.0
2017-08-29	AAME	Stock	3.4	3.4	3.3	3.3	4900.0
2017-08-29	AAMI	Stock	13.39	13.53	13.37	13.49	272000.0
2017-08-29	AAOI	Stock	60.03	63.34	60.01	62.69	2719200.0
2017-08-29	AAON	Stock	21.2	21.4667	21.0667	21.3333	190650.0
2017-08-29	AAP	Stock	93.9	95.31	93.1	95.12	1749400.0
2017-08-29	AAT	Stock	40.32	40.66	39.98	40.31	244200.0
2017-08-29	AAU-DELISTED	Stock	1.19	1.2	1.16	1.19	257862.0
2017-08-29	AAUAF-DELISTED	Stock	1.19	1.2	1.16	1.19	269604.0
2017-08-29	AAV-DELISTED	Stock	6.3	6.345	6.2	6.325	39723.0
2017-08-29	AAWW-DELISTED	Stock	63.95	65.05	63.1	64.85	214978.0
2017-08-29	AAXJ	Stock	71.16	71.69	71.07	71.62	1123434.0
2017-08-29	AAXN-DELISTED	Stock	21.77	21.91	21.61	21.615	318837.0
2017-08-29	AB	Stock	23.0	23.4	23.0	23.2	157700.0
2017-08-29	ABAC-DELISTED	Stock	2.2721	2.3	2.2	2.29	13943.0
2017-08-29	ABAX-DELISTED	Stock	45.31	47.05	45.31	45.83	74494.0
2017-08-29	ABB-DELISTED	Stock	22.94	22.965	22.88	22.925	1459332.0
2017-08-29	ABBNY-DELISTED	Stock	22.94	22.965	22.88	22.92	1504225.0
2017-08-29	ABBV	Stock	72.78	73.9	72.78	73.89	3390800.0
2017-08-29	ABC-DELISTED	Stock	78.16	79.08	77.84	78.565	1107545.0
2017-08-29	ABCB	Stock	43.7	44.0	43.5	43.8	85300.0
2017-08-29	ABCD-DELISTED	Stock	5.36	5.44	5.33	5.36	27251.0
2017-08-29	ABCO-DELISTED	Stock	52.95	53.05	52.8	53.0	15470636.0
2017-08-29	ABDC-DELISTED	Stock	10.66	10.6799	10.5	10.51	45534.0
2017-08-29	ABE-DELISTED	Stock	13.8937	13.929	13.8384	13.929	800.0
2017-08-29	ABEO	Stock	251.25	290.0	240.0	281.25	111496.0
2017-08-29	ABEOW-DELISTED	Stock	5.2	8.59	5.2	7.45	40874.0
2017-08-29	ABEV	Stock	6.19	6.26	6.19	6.23	9653600.0
2017-08-29	ABG	Stock	50.4	51.35	50.3	50.85	111500.0
2017-08-29	ABIL-DELISTED	Stock	0.77	0.81	0.72	0.753	449186.0
2017-08-29	ABM	Stock	43.71	44.04	43.69	43.81	155000.0

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

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