PREVIEW / stock_daily / 2017-08-31

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-31.parquet
  size:    216 KB
  rows:    6,497
  symbols: 2,972

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-31	AAPL	Stock	40.91	41.13	40.87	41.0	107140400.0
2017-08-31	MSFT	Stock	74.03	74.96	73.8	74.77	27652800.0
2017-08-31	NVDA	Stock	4.1625	4.24	4.155	4.236	612684000.0
2017-08-31	AMZN	Stock	48.735	49.05	48.638	49.03	66630000.0
2017-08-31	GOOGL	Stock	47.315	47.8598	47.3125	47.762	33866260.0
2017-08-31	META	Stock	170.4	172.15	170.06	171.97	17226500.0
2017-08-31	TSLA	Stock	23.57	23.896	23.5213	23.7267	61092000.0
2017-08-31	TLT	Stock	127.64	128.03	127.57	127.99	7978406.0
2017-08-31	ES	Stock	63.3	63.46	62.9	63.0	1782200.0
2017-08-31	CL	Stock	71.04	71.74	71.04	71.64	2947800.0
2017-08-31	A	Stock	64.0	64.83	63.9	64.72	1930100.0
2017-08-31	AA	Stock	43.67	44.0	43.18	43.88	4182000.0
2017-08-31	AAAP-DELISTED	Stock	48.0	49.0	44.57	48.83	29706.0
2017-08-31	AABA-DELISTED	Stock	64.5	64.76	63.835	64.11	3380202.0
2017-08-31	AAC-DELISTED	Stock	9.24	9.48	9.14	9.28	65213.0
2017-08-31	AACG	Stock	4.75	4.75	4.6	4.66	4400.0
2017-08-31	AAIC-DELISTED	Stock	12.83	12.975	12.83	12.92	258326.0
2017-08-31	AAL	Stock	44.54	44.94	44.43	44.74	3799600.0
2017-08-31	AAM.A-DELISTED	Stock	26.03	26.17	26.03	26.17	23678.0
2017-08-31	AAMC-DELISTED	Stock	25.8824	26.9706	25.8235	26.9706	5467.0
2017-08-31	AAME	Stock	3.4	3.4	3.25	3.25	7000.0
2017-08-31	AAMI	Stock	13.52	14.14	13.52	14.13	1142700.0
2017-08-31	AAOI	Stock	61.01	61.19	58.82	59.12	3770400.0
2017-08-31	AAON	Stock	21.6	21.9333	21.5667	21.7333	144300.0
2017-08-31	AAP	Stock	97.29	98.61	96.84	97.9	1913400.0
2017-08-31	AAT	Stock	40.34	40.85	40.34	40.62	207300.0
2017-08-31	AAU-DELISTED	Stock	1.18	1.23	1.15	1.18	308937.0
2017-08-31	AAUAF-DELISTED	Stock	1.18	1.23	1.15	1.18	314228.0
2017-08-31	AAV-DELISTED	Stock	6.3	6.4	6.3	6.4	63232.0
2017-08-31	AAWW-DELISTED	Stock	66.25	66.9	65.925	66.85	249946.0
2017-08-31	AAXJ	Stock	71.98	72.17	71.8799	72.07	802409.0
2017-08-31	AAXN-DELISTED	Stock	21.69	21.87	21.6318	21.72	385599.0
2017-08-31	AB	Stock	23.25	23.6	23.25	23.45	149100.0
2017-08-31	ABAC-DELISTED	Stock	2.06	2.1829	2.06	2.17	5300.0
2017-08-31	ABAX-DELISTED	Stock	45.8	46.32	45.58	46.22	56849.0
2017-08-31	ABB-DELISTED	Stock	23.02	23.21	22.98	23.18	1164036.0
2017-08-31	ABBNY-DELISTED	Stock	23.02	23.21	22.98	23.18	1217559.0
2017-08-31	ABBV	Stock	74.11	75.4	73.92	75.3	6177600.0
2017-08-31	ABC-DELISTED	Stock	78.65	80.5	78.46	80.21	1103017.0
2017-08-31	ABCB	Stock	43.8	44.3	43.58	44.05	131500.0
2017-08-31	ABCD-DELISTED	Stock	5.56	6.24	5.5	5.87	128820.0
2017-08-31	ABCO-DELISTED	Stock	53.15	53.3	53.1	53.3	1984374.0
2017-08-31	ABDC-DELISTED	Stock	10.55	10.73	10.45	10.48	74167.0
2017-08-31	ABE-DELISTED	Stock	14.1	14.1719	14.049	14.1719	1550.0
2017-08-31	ABEO	Stock	337.5	356.25	306.25	328.75	122312.0
2017-08-31	ABEOW-DELISTED	Stock	9.5	9.5	7.56	8.2	36442.0
2017-08-31	ABEV	Stock	6.29	6.29	6.26	6.26	9529800.0
2017-08-31	ABG	Stock	52.45	54.1	51.45	53.85	149700.0
2017-08-31	ABIL-DELISTED	Stock	0.81	0.865	0.782	0.82	597012.0
2017-08-31	ABM	Stock	44.02	44.6	43.9	44.43	145300.0

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

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