PREVIEW / stock_daily / 2018-03-06

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-06.parquet
  size:    217 KB
  rows:    6,484
  symbols: 2,842

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-03-06	AAPL	Stock	44.4775	44.5625	44.0325	44.1675	95154000.0
2018-03-06	MSFT	Stock	94.34	94.49	92.94	93.32	22175800.0
2018-03-06	NVDA	Stock	5.9775	6.0735	5.934	6.054	636808000.0
2018-03-06	AMZN	Stock	76.66	77.1065	76.4	76.882	91234000.0
2018-03-06	GOOGL	Stock	55.1051	55.2815	54.725	55.045	23381360.0
2018-03-06	META	Stock	181.78	182.38	179.11	179.78	15086800.0
2018-03-06	TSLA	Stock	22.25	22.4247	21.802	21.88	64285500.0
2018-03-06	TLT	Stock	118.36	118.68	118.12	118.14	5452045.0
2018-03-06	ES	Stock	57.55	57.59	56.57	56.68	1877000.0
2018-03-06	CL	Stock	70.09	70.41	69.23	69.64	2948300.0
2018-03-06	A	Stock	67.78	68.42	67.45	68.11	2944600.0
2018-03-06	AA	Stock	46.19	47.52	46.03	46.99	4431200.0
2018-03-06	AABA-DELISTED	Stock	74.42	75.5	74.36	75.22	6953568.0
2018-03-06	AAC-DELISTED	Stock	9.8	10.17	9.79	10.08	158960.0
2018-03-06	AAIC-DELISTED	Stock	11.26	11.34	11.08	11.33	540589.0
2018-03-06	AAL	Stock	53.34	54.02	52.9	53.57	4273800.0
2018-03-06	AAM.A-DELISTED	Stock	25.5195	25.66	25.5	25.64	16648.0
2018-03-06	AAME	Stock	3.4	3.4	3.3	3.3	2200.0
2018-03-06	AAMI	Stock	15.06	15.28	14.96	15.21	440700.0
2018-03-06	AAOI	Stock	28.14	28.43	27.3	27.45	1596200.0
2018-03-06	AAON	Stock	23.7	24.0667	23.4333	23.9667	331500.0
2018-03-06	AAP	Stock	116.54	119.04	115.13	118.59	1003700.0
2018-03-06	AAT	Stock	32.1	32.35	31.83	32.26	307800.0
2018-03-06	AAU-DELISTED	Stock	0.89	0.9	0.86	0.87	146575.0
2018-03-06	AAUAF-DELISTED	Stock	0.89	0.9	0.86	0.87	149165.0
2018-03-06	AAV-DELISTED	Stock	3.05	3.2	2.95	3.0	760382.0
2018-03-06	AAWW-DELISTED	Stock	60.45	61.4356	60.0	61.05	129582.0
2018-03-06	AAXJ	Stock	77.87	78.06	77.26	77.54	636527.0
2018-03-06	AAXN-DELISTED	Stock	37.5	39.7	37.42	39.09	1392798.0
2018-03-06	AB	Stock	26.7	27.15	26.6	27.05	338600.0
2018-03-06	ABAC-DELISTED	Stock	2.49	2.53	2.41	2.53	38333.0
2018-03-06	ABAX-DELISTED	Stock	69.77	71.5899	68.31	71.19	214850.0
2018-03-06	ABB-DELISTED	Stock	24.4	24.4575	24.29	24.34	1318641.0
2018-03-06	ABBNY-DELISTED	Stock	24.4	24.4575	24.29	24.33	1471702.0
2018-03-06	ABBV	Stock	116.01	116.3	113.83	114.56	3650500.0
2018-03-06	ABC-DELISTED	Stock	95.49	95.53	94.0763	94.71	1186092.0
2018-03-06	ABCB	Stock	55.55	56.45	54.85	56.45	307800.0
2018-03-06	ABCD-DELISTED	Stock	7.02	7.2286	6.87	7.05	62115.0
2018-03-06	ABDC-DELISTED	Stock	7.5	7.765	7.45	7.72	62843.0
2018-03-06	ABE-DELISTED	Stock	15.17	15.29	15.1235	15.2	13145.0
2018-03-06	ABEO	Stock	387.5	405.0	383.75	393.75	46496.0
2018-03-06	ABEOW-DELISTED	Stock	11.04	11.62	10.7288	10.7288	4701.0
2018-03-06	ABEV	Stock	6.94	7.09	6.92	7.07	31283700.0
2018-03-06	ABG	Stock	67.35	68.55	67.05	68.3	139300.0
2018-03-06	ABIL-DELISTED	Stock	0.371	0.4075	0.371	0.3995	233377.0
2018-03-06	ABLX-DELISTED	Stock	54.39	54.57	54.33	54.54	46062.0
2018-03-06	ABM	Stock	35.2	35.84	35.0	35.67	688300.0
2018-03-06	ABMD-DELISTED	Stock	280.67	285.48	276.765	281.43	411933.0
2018-03-06	ABR	Stock	8.65	8.71	8.61	8.7	722800.0
2018-03-06	ABR.A-DELISTED	Stock	25.25	25.35	25.2445	25.2934	2834.0

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

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