PREVIEW / stock_daily / 2018-01-10

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-10.parquet
  size:    216 KB
  rows:    6,475
  symbols: 2,872

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-10	AAPL	Stock	43.29	43.575	43.25	43.5725	95839600.0
2018-01-10	MSFT	Stock	87.86	88.19	87.41	87.82	18652200.0
2018-01-10	NVDA	Stock	5.455	5.5955	5.4	5.592	582664000.0
2018-01-10	AMZN	Stock	62.2575	62.7165	61.8615	62.7165	53720000.0
2018-01-10	GOOGL	Stock	55.35	55.639	55.1992	55.507	20733100.0
2018-01-10	META	Stock	186.94	187.89	185.63	187.84	10529900.0
2018-01-10	TSLA	Stock	22.1467	22.4667	22.0	22.32	64648500.0
2018-01-10	TLT	Stock	122.81	123.93	122.66	123.8	14302604.0
2018-01-10	ES	Stock	61.6	61.63	61.15	61.32	1716000.0
2018-01-10	CL	Stock	75.2	75.48	74.49	74.82	3138300.0
2018-01-10	A	Stock	71.45	71.45	70.11	70.79	2957200.0
2018-01-10	AA	Stock	54.37	56.26	54.23	56.17	5056100.0
2018-01-10	AAAP-DELISTED	Stock	81.87	81.9	81.78	81.88	109534.0
2018-01-10	AABA-DELISTED	Stock	75.76	76.66	75.45	76.53	9065851.0
2018-01-10	AAC-DELISTED	Stock	9.0	9.04	8.95	9.0	70080.0
2018-01-10	AACG	Stock	5.22	5.51	5.22	5.31	1800.0
2018-01-10	AAIC-DELISTED	Stock	11.75	11.76	11.541	11.67	490289.0
2018-01-10	AAL	Stock	53.23	54.02	52.88	53.78	7655800.0
2018-01-10	AAM.A-DELISTED	Stock	26.09	26.19	26.01	26.1	34676.0
2018-01-10	AAME	Stock	3.35	3.35	3.33	3.35	1500.0
2018-01-10	AAMI	Stock	17.64	17.87	17.47	17.49	502300.0
2018-01-10	AAOI	Stock	35.04	35.92	33.78	35.31	1725900.0
2018-01-10	AAON	Stock	24.6	24.8333	24.0	24.0667	457650.0
2018-01-10	AAP	Stock	110.27	112.0	109.79	110.59	711200.0
2018-01-10	AAT	Stock	36.37	36.47	35.82	36.35	159500.0
2018-01-10	AAU-DELISTED	Stock	0.95	0.9584	0.945	0.9564	191124.0
2018-01-10	AAUAF-DELISTED	Stock	0.95	0.9584	0.945	0.9564	192843.0
2018-01-10	AAV-DELISTED	Stock	3.9	3.9	3.6	3.625	338246.0
2018-01-10	AAWW-DELISTED	Stock	58.8	62.0	58.4	60.65	531336.0
2018-01-10	AAXJ	Stock	78.89	79.075	78.645	78.92	813719.0
2018-01-10	AAXN-DELISTED	Stock	26.78	26.88	26.4	26.56	378228.0
2018-01-10	AB	Stock	27.4	27.75	27.05	27.1	263000.0
2018-01-10	ABAC-DELISTED	Stock	2.87	2.9	2.81	2.81	4911.0
2018-01-10	ABAX-DELISTED	Stock	61.66	61.99	59.63	61.66	193845.0
2018-01-10	ABB-DELISTED	Stock	27.55	27.56	27.46	27.53	1320157.0
2018-01-10	ABBNY-DELISTED	Stock	27.55	27.56	27.46	27.54	1852279.0
2018-01-10	ABBV	Stock	99.65	100.2	99.18	99.69	4608600.0
2018-01-10	ABC-DELISTED	Stock	96.54	97.31	94.75	97.2	865895.0
2018-01-10	ABCB	Stock	51.05	51.85	50.95	51.15	282300.0
2018-01-10	ABCD-DELISTED	Stock	6.05	6.19	6.05	6.16	46455.0
2018-01-10	ABDC-DELISTED	Stock	8.36	8.435	8.3	8.38	43762.0
2018-01-10	ABE-DELISTED	Stock	14.98	15.129	14.98	15.1	4475.0
2018-01-10	ABEO	Stock	402.5	406.25	390.0	400.0	24864.0
2018-01-10	ABEOW-DELISTED	Stock	11.0	11.0	11.0	11.0	752.0
2018-01-10	ABEV	Stock	6.61	6.66	6.56	6.61	8253300.0
2018-01-10	ABG	Stock	70.9	72.1	70.75	71.1	177900.0
2018-01-10	ABIL-DELISTED	Stock	0.4994	0.4999	0.46	0.4656	132569.0
2018-01-10	ABLX-DELISTED	Stock	42.37	42.57	41.0	41.5699	697357.0
2018-01-10	ABM	Stock	39.33	39.45	38.71	38.78	414500.0
2018-01-10	ABMD-DELISTED	Stock	209.57	209.76	206.541	208.21	112842.0

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

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