PREVIEW / stock_daily / 2017-09-06

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-06.parquet
  size:    214 KB
  rows:    6,465
  symbols: 2,951

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-09-06	AAPL	Stock	40.6775	40.7475	40.13	40.4775	86606800.0
2017-09-06	MSFT	Stock	73.74	74.04	73.35	73.4	16535800.0
2017-09-06	NVDA	Stock	4.181	4.195	4.11	4.1452	397672000.0
2017-09-06	AMZN	Stock	48.416	48.592	48.03	48.39	42598000.0
2017-09-06	GOOGL	Stock	47.1935	47.225	46.634	47.101	27830580.0
2017-09-06	META	Stock	170.91	172.48	169.57	172.09	13906300.0
2017-09-06	TSLA	Stock	23.3	23.3987	22.7707	22.9687	61371000.0
2017-09-06	TLT	Stock	128.72	129.0	127.74	127.97	9066915.0
2017-09-06	ES	Stock	63.13	63.13	62.46	62.61	1769600.0
2017-09-06	CL	Stock	71.11	71.78	70.98	71.49	3007800.0
2017-09-06	A	Stock	64.56	64.81	64.05	64.71	974500.0
2017-09-06	AA	Stock	44.4	44.5	43.3	44.43	3419900.0
2017-09-06	AAAP-DELISTED	Stock	49.79	50.51	48.25	49.4992	111411.0
2017-09-06	AABA-DELISTED	Stock	63.71	64.2787	62.9	63.3	3923064.0
2017-09-06	AAC-DELISTED	Stock	9.88	10.42	9.6938	10.36	95207.0
2017-09-06	AACG	Stock	4.61	4.77	4.6	4.73	26200.0
2017-09-06	AAIC-DELISTED	Stock	12.86	12.88	12.76	12.86	242667.0
2017-09-06	AAL	Stock	43.09	44.68	42.61	44.31	8796700.0
2017-09-06	AAM.A-DELISTED	Stock	26.1	26.15	26.021	26.07	36908.0
2017-09-06	AAMC-DELISTED	Stock	28.9706	34.1176	28.2647	31.9706	104254.0
2017-09-06	AAME	Stock	3.35	3.45	3.35	3.45	1800.0
2017-09-06	AAMI	Stock	13.61	13.66	13.38	13.52	587600.0
2017-09-06	AAOI	Stock	56.36	58.73	56.36	58.06	2290000.0
2017-09-06	AAON	Stock	21.6667	21.8533	21.6	21.7	161700.0
2017-09-06	AAP	Stock	96.92	97.7	95.02	95.61	1893200.0
2017-09-06	AAT	Stock	40.66	41.37	40.52	40.61	232400.0
2017-09-06	AAU-DELISTED	Stock	1.25	1.27	1.25	1.255	187144.0
2017-09-06	AAUAF-DELISTED	Stock	1.25	1.27	1.25	1.255	195903.0
2017-09-06	AAV-DELISTED	Stock	6.35	6.5	6.125	6.2	138382.0
2017-09-06	AAWW-DELISTED	Stock	66.8	66.8	65.15	66.45	300820.0
2017-09-06	AAXJ	Stock	71.68	71.82	71.55	71.76	280078.0
2017-09-06	AAXN-DELISTED	Stock	22.0	22.0	21.7	21.74	472532.0
2017-09-06	AB	Stock	23.4	23.65	23.18	23.6	264600.0
2017-09-06	ABAC-DELISTED	Stock	2.2	2.25	2.17	2.25	4101.0
2017-09-06	ABAX-DELISTED	Stock	46.22	46.6	46.04	46.19	65378.0
2017-09-06	ABB-DELISTED	Stock	23.72	23.87	23.71	23.78	1544854.0
2017-09-06	ABBNY-DELISTED	Stock	23.72	23.87	23.71	23.78	1583100.0
2017-09-06	ABBV	Stock	75.61	77.46	75.35	77.05	7755200.0
2017-09-06	ABC-DELISTED	Stock	80.0	80.935	79.84	80.74	1109173.0
2017-09-06	ABCB	Stock	43.85	43.85	42.75	42.8	111000.0
2017-09-06	ABCD-DELISTED	Stock	6.14	6.21	6.01	6.12	33218.0
2017-09-06	ABCO-DELISTED	Stock	53.25	53.425	53.2	53.35	1060340.0
2017-09-06	ABDC-DELISTED	Stock	10.94	11.15	10.7898	10.99	55831.0
2017-09-06	ABE-DELISTED	Stock	14.021	14.05	14.0001	14.0292	1823.0
2017-09-06	ABEO	Stock	353.75	362.5	326.0	335.0	53980.0
2017-09-06	ABEOW-DELISTED	Stock	8.6	8.6	8.55	8.55	1000.0
2017-09-06	ABEV	Stock	6.34	6.47	6.34	6.45	15062700.0
2017-09-06	ABG	Stock	54.95	55.0	54.0	54.25	217800.0
2017-09-06	ABIL-DELISTED	Stock	0.84	0.84	0.77	0.7999	173744.0
2017-09-06	ABM	Stock	44.1	44.58	44.07	44.14	224500.0

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

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