PREVIEW / stock_daily / 2018-01-11

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-11.parquet
  size:    217 KB
  rows:    6,488
  symbols: 2,878

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-01-11	AAPL	Stock	43.6475	43.8725	43.6225	43.82	74670800.0
2018-01-11	MSFT	Stock	88.13	88.13	87.24	88.08	17808900.0
2018-01-11	NVDA	Stock	5.625	5.6568	5.5803	5.602	406032000.0
2018-01-11	AMZN	Stock	62.987	63.8385	62.823	63.834	62500000.0
2018-01-11	GOOGL	Stock	55.6155	55.7425	55.324	55.6025	22424320.0
2018-01-11	META	Stock	188.4	188.4	187.38	187.77	9588600.0
2018-01-11	TSLA	Stock	22.3493	22.9873	22.2173	22.53	99682500.0
2018-01-11	TLT	Stock	123.51	124.59	123.31	124.31	12511001.0
2018-01-11	ES	Stock	61.14	61.53	60.99	61.52	1822400.0
2018-01-11	CL	Stock	74.96	74.99	74.38	74.55	2007400.0
2018-01-11	A	Stock	70.92	71.18	70.3	70.8	1511100.0
2018-01-11	AA	Stock	56.6	57.13	55.87	56.91	2743100.0
2018-01-11	AAAP-DELISTED	Stock	81.89	81.9	81.82	81.87	249811.0
2018-01-11	AABA-DELISTED	Stock	76.54	76.78	76.04	76.14	4348617.0
2018-01-11	AAC-DELISTED	Stock	9.03	9.71	9.03	9.3	85585.0
2018-01-11	AACG	Stock	5.39	5.49	5.15	5.15	3400.0
2018-01-11	AAIC-DELISTED	Stock	11.65	11.82	11.64	11.8	567893.0
2018-01-11	AAL	Stock	54.49	57.0	54.18	56.42	11339900.0
2018-01-11	AAM.A-DELISTED	Stock	26.1916	26.1916	26.05	26.16	17454.0
2018-01-11	AAMC-DELISTED	Stock	23.5265	23.5265	23.5265	23.5265	4318.0
2018-01-11	AAME	Stock	3.3	3.35	3.3	3.35	1900.0
2018-01-11	AAMI	Stock	17.59	17.84	17.47	17.84	539100.0
2018-01-11	AAOI	Stock	35.37	36.28	35.01	35.94	871000.0
2018-01-11	AAON	Stock	24.1	24.3667	23.9667	24.1333	459750.0
2018-01-11	AAP	Stock	110.7	113.42	108.9	112.95	1015900.0
2018-01-11	AAT	Stock	36.36	36.58	36.26	36.38	111900.0
2018-01-11	AAU-DELISTED	Stock	0.95	0.99	0.95	0.99	100778.0
2018-01-11	AAUAF-DELISTED	Stock	0.95	0.99	0.95	0.99	110509.0
2018-01-11	AAV-DELISTED	Stock	3.7	3.85	3.65	3.7	464479.0
2018-01-11	AAWW-DELISTED	Stock	60.85	61.7	60.15	61.4	429873.0
2018-01-11	AAXJ	Stock	78.93	79.41	78.92	79.4	618982.0
2018-01-11	AAXN-DELISTED	Stock	26.58	27.0	26.52	26.9	564429.0
2018-01-11	AB	Stock	27.25	27.3	26.9	27.15	201700.0
2018-01-11	ABAC-DELISTED	Stock	2.9	3.05	2.9	2.95	10266.0
2018-01-11	ABAX-DELISTED	Stock	61.9	62.98	61.54	62.28	112198.0
2018-01-11	ABB-DELISTED	Stock	27.54	27.74	27.51	27.725	1023952.0
2018-01-11	ABBNY-DELISTED	Stock	27.54	27.74	27.51	27.72	1111107.0
2018-01-11	ABBV	Stock	99.37	99.49	98.56	99.27	4240900.0
2018-01-11	ABC-DELISTED	Stock	97.4	98.14	96.53	98.13	623792.0
2018-01-11	ABCB	Stock	51.5	52.8	50.85	52.55	235100.0
2018-01-11	ABCD-DELISTED	Stock	6.19	6.55	6.19	6.31	85845.0
2018-01-11	ABDC-DELISTED	Stock	8.65	8.8	8.54	8.66	134601.0
2018-01-11	ABE-DELISTED	Stock	15.38	15.38	15.1001	15.18	19560.0
2018-01-11	ABEO	Stock	400.0	403.75	392.5	396.25	18692.0
2018-01-11	ABEOW-DELISTED	Stock	11.2	11.35	10.7501	10.9218	6699.0
2018-01-11	ABEV	Stock	6.63	6.77	6.62	6.77	11530800.0
2018-01-11	ABG	Stock	71.3	74.7	71.2	74.65	238400.0
2018-01-11	ABIL-DELISTED	Stock	0.47	0.5051	0.4667	0.4832	198801.0
2018-01-11	ABLX-DELISTED	Stock	42.26	45.775	42.13	44.82	461421.0
2018-01-11	ABM	Stock	38.79	38.99	38.28	38.96	412900.0

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

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