PREVIEW / stock_daily / 2018-01-16

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-16.parquet
  size:    217 KB
  rows:    6,508
  symbols: 2,889

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-16	AAPL	Stock	44.475	44.8475	44.035	44.0475	118263600.0
2018-01-16	MSFT	Stock	90.1	90.79	88.01	88.35	36599700.0
2018-01-16	NVDA	Stock	5.6012	5.6878	5.4172	5.5028	702348000.0
2018-01-16	AMZN	Stock	66.15	66.997	64.615	65.243	144414000.0
2018-01-16	GOOGL	Stock	57.0155	57.444	56.333	56.535	36462000.0
2018-01-16	META	Stock	181.5	181.75	178.04	178.39	36183800.0
2018-01-16	TSLA	Stock	22.5027	23.0	22.32	22.6707	97114500.0
2018-01-16	TLT	Stock	125.17	125.28	124.56	125.04	9125890.0
2018-01-16	ES	Stock	61.36	61.64	60.33	60.95	2079300.0
2018-01-16	CL	Stock	74.94	75.73	74.6	75.42	4580500.0
2018-01-16	A	Stock	72.02	72.47	71.06	71.23	1702700.0
2018-01-16	AA	Stock	56.09	57.04	55.46	56.24	3888400.0
2018-01-16	AAAP-DELISTED	Stock	81.85	81.9	81.82	81.861	279346.0
2018-01-16	AABA-DELISTED	Stock	76.44	77.01	73.71	73.91	5799235.0
2018-01-16	AAC-DELISTED	Stock	9.37	9.41	9.0	9.06	55726.0
2018-01-16	AACG	Stock	5.55	5.65	5.55	5.62	17000.0
2018-01-16	AAIC-DELISTED	Stock	11.94	11.99	11.78	11.84	458729.0
2018-01-16	AAL	Stock	58.79	59.08	57.53	57.98	5283900.0
2018-01-16	AAM.A-DELISTED	Stock	25.99	26.0057	25.78	25.78	26570.0
2018-01-16	AAMC-DELISTED	Stock	22.3382	22.3382	22.3382	22.3382	989.0
2018-01-16	AAME	Stock	3.25	3.35	3.25	3.3	5900.0
2018-01-16	AAMI	Stock	18.46	18.58	18.14	18.14	453400.0
2018-01-16	AAOI	Stock	35.69	35.73	33.63	34.17	1510400.0
2018-01-16	AAON	Stock	24.5	24.6333	23.9	24.0333	199800.0
2018-01-16	AAP	Stock	116.76	116.84	112.86	113.9	1498100.0
2018-01-16	AAT	Stock	36.16	36.67	36.0	36.1	198200.0
2018-01-16	AAU-DELISTED	Stock	1.01	1.01	0.969	0.97	180458.0
2018-01-16	AAUAF-DELISTED	Stock	1.01	1.01	0.969	0.97	206481.0
2018-01-16	AAV-DELISTED	Stock	3.85	3.85	3.6	3.675	555088.0
2018-01-16	AAWW-DELISTED	Stock	61.95	62.8	60.925	61.75	162034.0
2018-01-16	AAXJ	Stock	80.4	80.665	79.65	79.78	765007.0
2018-01-16	AAXN-DELISTED	Stock	27.59	27.96	27.276	27.3	389704.0
2018-01-16	AB	Stock	27.15	27.35	26.65	26.75	321400.0
2018-01-16	ABAC-DELISTED	Stock	2.95	2.95	2.613	2.76	18416.0
2018-01-16	ABAX-DELISTED	Stock	62.27	63.18	61.94	62.26	88054.0
2018-01-16	ABB-DELISTED	Stock	28.2	28.265	28.02	28.07	1714905.0
2018-01-16	ABBNY-DELISTED	Stock	28.2	28.265	28.02	28.07	1776060.0
2018-01-16	ABBV	Stock	100.26	103.0	100.0	102.49	8528600.0
2018-01-16	ABC-DELISTED	Stock	99.1	100.67	98.97	99.55	1519395.0
2018-01-16	ABCB	Stock	53.5	53.85	53.05	53.1	200800.0
2018-01-16	ABCD-DELISTED	Stock	6.66	7.19	6.66	6.87	190046.0
2018-01-16	ABDC-DELISTED	Stock	8.88	8.88	8.63	8.65	153426.0
2018-01-16	ABE-DELISTED	Stock	15.1515	15.23	15.1515	15.1959	5748.0
2018-01-16	ABEO	Stock	396.25	397.5	368.75	371.25	25860.0
2018-01-16	ABEOW-DELISTED	Stock	10.01	10.01	9.8398	9.89	15324.0
2018-01-16	ABEV	Stock	6.71	6.78	6.69	6.75	15720200.0
2018-01-16	ABG	Stock	75.85	76.4	72.55	73.0	188000.0
2018-01-16	ABIL-DELISTED	Stock	0.5411	0.5788	0.5004	0.525	626414.0
2018-01-16	ABLX-DELISTED	Stock	41.86	42.09	40.73	41.1	248114.0
2018-01-16	ABM	Stock	38.97	39.16	38.22	38.47	374100.0

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

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