PREVIEW / stock_daily / 2018-04-20

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-20.parquet
  size:    216 KB
  rows:    6,456
  symbols: 2,811

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
2018-04-20	AAPL	Stock	42.65	42.805	41.3575	41.43	261964400.0
2018-04-20	MSFT	Stock	95.91	96.11	94.05	95.0	31154400.0
2018-04-20	NVDA	Stock	5.7172	5.8025	5.6862	5.7178	386200000.0
2018-04-20	AMZN	Stock	78.06	78.06	75.8045	76.3745	110832000.0
2018-04-20	GOOGL	Stock	54.2135	54.7375	53.605	53.866	42433840.0
2018-04-20	META	Stock	167.79	168.43	165.81	166.28	19119400.0
2018-04-20	TSLA	Stock	19.678	19.9987	19.3167	19.3493	84418500.0
2018-04-20	TLT	Stock	118.89	119.13	118.4314	118.46	7579370.0
2018-04-20	ES	Stock	59.94	59.94	58.93	59.22	1478700.0
2018-04-20	CL	Stock	69.57	69.75	67.43	67.52	8636900.0
2018-04-20	A	Stock	68.04	68.26	67.32	67.55	1917200.0
2018-04-20	AA	Stock	59.82	60.14	57.49	60.01	7635800.0
2018-04-20	AABA-DELISTED	Stock	71.57	72.14	70.59	71.05	5126638.0
2018-04-20	AAC-DELISTED	Stock	11.32	11.32	10.92	11.0	82378.0
2018-04-20	AACG	Stock	5.32	5.45	5.16	5.45	3200.0
2018-04-20	AAIC-DELISTED	Stock	11.18	11.23	11.13	11.16	497474.0
2018-04-20	AAL	Stock	46.91	47.24	46.44	46.78	5344700.0
2018-04-20	AAM.A-DELISTED	Stock	24.36	24.56	24.2	24.44	88564.0
2018-04-20	AAM.B-DELISTED	Stock	24.34	24.57	24.08	24.5	2191279.0
2018-04-20	AAMC-DELISTED	Stock	16.8529	17.0735	16.8529	16.9412	6773.0
2018-04-20	AAME	Stock	3.12	3.12	3.12	3.12	600.0
2018-04-20	AAMI	Stock	15.02	15.06	14.83	14.91	305700.0
2018-04-20	AAOI	Stock	31.79	34.17	30.78	32.99	3099300.0
2018-04-20	AAON	Stock	23.8667	24.1667	23.8067	24.0333	286350.0
2018-04-20	AAP	Stock	105.28	106.45	102.9	103.76	1064500.0
2018-04-20	AAT	Stock	33.17	33.45	32.75	32.8	151000.0
2018-04-20	AAU-DELISTED	Stock	0.84	0.85	0.8305	0.8498	50654.0
2018-04-20	AAUAF-DELISTED	Stock	0.84	0.85	0.8305	0.8498	52099.0
2018-04-20	AAV-DELISTED	Stock	3.1	3.1	3.0	3.1	425018.0
2018-04-20	AAWW-DELISTED	Stock	63.9	64.85	63.5	64.05	142069.0
2018-04-20	AAXJ	Stock	76.75	76.75	75.89	76.26	661707.0
2018-04-20	AAXN-DELISTED	Stock	42.92	43.27	42.63	42.7	482808.0
2018-04-20	AB	Stock	26.45	26.5	26.0	26.2	184100.0
2018-04-20	ABAC-DELISTED	Stock	2.51	2.52	2.5	2.5	4086.0
2018-04-20	ABAX-DELISTED	Stock	72.72	73.61	72.45	72.71	53519.0
2018-04-20	ABB-DELISTED	Stock	24.31	24.375	24.17	24.19	3067905.0
2018-04-20	ABBNY-DELISTED	Stock	24.31	24.375	24.17	24.2	3162261.0
2018-04-20	ABBV	Stock	93.41	93.8	92.02	92.6	4754800.0
2018-04-20	ABC-DELISTED	Stock	92.0	92.02	89.12	89.86	758922.0
2018-04-20	ABCB	Stock	50.55	52.85	50.2	52.2	268100.0
2018-04-20	ABCD-DELISTED	Stock	13.61	13.7582	9.6301	10.31	1913308.0
2018-04-20	ABDC-DELISTED	Stock	6.68	6.7192	6.59	6.64	40923.0
2018-04-20	ABE-DELISTED	Stock	14.98	14.98	14.9	14.91	2878.0
2018-04-20	ABEO	Stock	507.5	542.5	500.25	522.5	49212.0
2018-04-20	ABEOW-DELISTED	Stock	15.9	15.9	15.9	15.9	500.0
2018-04-20	ABEV	Stock	6.81	6.84	6.76	6.81	18565300.0
2018-04-20	ABG	Stock	67.45	67.55	65.95	66.2	105400.0
2018-04-20	ABIL-DELISTED	Stock	2.9499	2.9499	2.87	2.89	5003.0
2018-04-20	ABLX-DELISTED	Stock	54.83	54.87	54.455	54.58	45105.0
2018-04-20	ABM	Stock	32.12	32.22	31.72	31.75	518900.0

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

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