PREVIEW / stock_daily / 2018-01-08

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-08.parquet
  size:    216 KB
  rows:    6,494
  symbols: 2,882

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-08	AAPL	Stock	43.5875	43.9025	43.4825	43.5875	82271200.0
2018-01-08	MSFT	Stock	88.2	88.58	87.6	88.28	22113000.0
2018-01-08	NVDA	Stock	5.51	5.625	5.4645	5.55	881216000.0
2018-01-08	AMZN	Stock	61.8	62.654	61.6015	62.3435	85590000.0
2018-01-08	GOOGL	Stock	55.55	55.958	55.5	55.7105	24644420.0
2018-01-08	META	Stock	187.2	188.9	186.33	188.28	17994700.0
2018-01-08	TSLA	Stock	21.0667	22.468	21.0333	22.4273	147891000.0
2018-01-08	TLT	Stock	125.99	126.03	125.17	125.63	8850576.0
2018-01-08	ES	Stock	61.82	62.29	61.56	62.25	1804600.0
2018-01-08	CL	Stock	75.16	75.63	75.0	75.53	1688600.0
2018-01-08	A	Stock	69.73	70.33	69.55	70.05	1613400.0
2018-01-08	AA	Stock	53.96	56.15	53.66	55.0	5028100.0
2018-01-08	AAAP-DELISTED	Stock	81.74	81.85	81.74	81.81	273899.0
2018-01-08	AABA-DELISTED	Stock	76.21	76.81	75.98	76.47	4380351.0
2018-01-08	AAC-DELISTED	Stock	9.08	9.16	8.88	8.91	170310.0
2018-01-08	AACG	Stock	5.49	5.5	5.27	5.27	2600.0
2018-01-08	AAIC-DELISTED	Stock	11.74	11.84	11.66	11.8	558496.0
2018-01-08	AAL	Stock	52.6	52.64	51.93	52.13	3515800.0
2018-01-08	AAM.A-DELISTED	Stock	26.06	26.25	26.04	26.08	23062.0
2018-01-08	AAME	Stock	3.6	3.6	3.35	3.35	12800.0
2018-01-08	AAMI	Stock	17.0	17.73	17.0	17.48	1135200.0
2018-01-08	AAOI	Stock	38.9	38.99	37.44	38.37	899700.0
2018-01-08	AAON	Stock	25.3	25.4333	24.8667	24.9667	330750.0
2018-01-08	AAP	Stock	112.05	112.29	110.64	111.39	1257100.0
2018-01-08	AAT	Stock	37.11	37.28	36.91	37.22	131100.0
2018-01-08	AAU-DELISTED	Stock	0.98	1.0	0.95	0.9522	208087.0
2018-01-08	AAUAF-DELISTED	Stock	0.98	1.0	0.95	0.9522	231762.0
2018-01-08	AAV-DELISTED	Stock	4.0	4.06	4.0	4.05	74855.0
2018-01-08	AAWW-DELISTED	Stock	56.5	56.6	55.7	56.25	326653.0
2018-01-08	AAXJ	Stock	79.17	79.62	79.17	79.49	567703.0
2018-01-08	AAXN-DELISTED	Stock	26.82	26.825	26.27	26.76	456167.0
2018-01-08	AB	Stock	26.2	26.85	26.18	26.7	424900.0
2018-01-08	ABAC-DELISTED	Stock	3.12	3.12	2.7582	2.9	18220.0
2018-01-08	ABAX-DELISTED	Stock	55.12	55.51	52.8	52.92	97263.0
2018-01-08	ABB-DELISTED	Stock	27.51	27.65	27.495	27.6	1975939.0
2018-01-08	ABBNY-DELISTED	Stock	27.51	27.65	27.495	27.6	2473236.0
2018-01-08	ABBV	Stock	101.28	101.28	98.18	99.49	5582000.0
2018-01-08	ABC-DELISTED	Stock	95.11	97.81	94.81	96.9	1524695.0
2018-01-08	ABCB	Stock	50.35	50.45	49.7	50.4	251600.0
2018-01-08	ABCD-DELISTED	Stock	5.98	6.04	5.83	5.98	46305.0
2018-01-08	ABDC-DELISTED	Stock	8.57	8.65	8.533	8.6	61461.0
2018-01-08	ABE-DELISTED	Stock	15.05	15.13	14.96	15.05	27925.0
2018-01-08	ABEO	Stock	391.25	392.75	376.25	381.25	18144.0
2018-01-08	ABEV	Stock	6.63	6.66	6.59	6.62	10900000.0
2018-01-08	ABG	Stock	66.95	70.85	66.95	70.8	367700.0
2018-01-08	ABIL-DELISTED	Stock	0.4625	0.54	0.4625	0.52	372877.0
2018-01-08	ABLX-DELISTED	Stock	36.64	39.32	36.37	38.6	1769709.0
2018-01-08	ABM	Stock	39.02	39.65	38.78	39.55	578900.0
2018-01-08	ABMD-DELISTED	Stock	208.24	211.34	204.67	207.8	307324.0
2018-01-08	ABR	Stock	8.56	8.68	8.54	8.66	441200.0

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

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