PREVIEW / stock_daily / 2018-03-26

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-26.parquet
  size:    217 KB
  rows:    6,492
  symbols: 2,853

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-26	AAPL	Stock	42.0175	43.275	41.61	43.1925	150164800.0
2018-03-26	MSFT	Stock	90.61	94.0	90.4	93.78	56396800.0
2018-03-26	NVDA	Stock	5.95	6.1133	5.8975	6.112	611424000.0
2018-03-26	AMZN	Stock	76.5	77.8495	74.9625	77.793	112494000.0
2018-03-26	GOOGL	Stock	52.53	52.9635	50.529	52.7045	65983020.0
2018-03-26	META	Stock	160.82	161.1	149.02	160.06	126116600.0
2018-03-26	TSLA	Stock	20.4893	20.506	19.424	20.2787	125628000.0
2018-03-26	TLT	Stock	120.0	120.45	119.67	119.71	8237947.0
2018-03-26	ES	Stock	57.0	57.68	56.9	57.53	1408600.0
2018-03-26	CL	Stock	68.88	69.11	67.86	68.19	3271100.0
2018-03-26	A	Stock	67.2	68.29	66.66	68.2	2263800.0
2018-03-26	AA	Stock	45.26	46.53	44.27	45.77	5187000.0
2018-03-26	AABA-DELISTED	Stock	74.56	75.99	73.69	75.84	5265488.0
2018-03-26	AAC-DELISTED	Stock	12.15	12.34	11.54	12.29	154686.0
2018-03-26	AACG	Stock	5.2	5.25	5.1	5.1	16200.0
2018-03-26	AAIC-DELISTED	Stock	11.62	11.68	11.48	11.66	760568.0
2018-03-26	AAL	Stock	51.94	52.04	50.64	51.86	3210500.0
2018-03-26	AAM.A-DELISTED	Stock	25.08	25.08	24.82	24.86	49292.0
2018-03-26	AAM.B-DELISTED	Stock	24.87	24.95	24.75	24.79	197051.0
2018-03-26	AAMC-DELISTED	Stock	17.2353	17.6397	17.2059	17.2353	6780.0
2018-03-26	AAMI	Stock	12.88	16.0	12.88	15.74	482700.0
2018-03-26	AAOI	Stock	25.55	25.84	23.51	24.53	1839400.0
2018-03-26	AAON	Stock	25.2333	25.3333	24.7333	25.3	173400.0
2018-03-26	AAP	Stock	112.49	115.07	111.88	114.77	1008800.0
2018-03-26	AAT	Stock	32.03	32.27	31.79	32.22	420400.0
2018-03-26	AAU-DELISTED	Stock	0.87	0.87	0.8304	0.8572	176957.0
2018-03-26	AAUAF-DELISTED	Stock	0.87	0.87	0.8304	0.8572	184109.0
2018-03-26	AAV-DELISTED	Stock	3.2	3.25	3.11	3.2	237349.0
2018-03-26	AAWW-DELISTED	Stock	59.3	61.0	58.9	59.95	158760.0
2018-03-26	AAXJ	Stock	77.3	77.8	76.3	77.74	2622778.0
2018-03-26	AAXN-DELISTED	Stock	38.26	38.77	37.521	38.72	346207.0
2018-03-26	AB	Stock	26.45	26.65	26.19	26.5	260600.0
2018-03-26	ABAC-DELISTED	Stock	2.85	2.85	2.43	2.4848	32818.0
2018-03-26	ABAX-DELISTED	Stock	73.27	74.35	72.31	74.26	98645.0
2018-03-26	ABB-DELISTED	Stock	23.5	23.54	23.08	23.48	1392311.0
2018-03-26	ABBNY-DELISTED	Stock	23.5	23.54	23.08	23.47	1498942.0
2018-03-26	ABBV	Stock	99.49	99.91	91.76	95.28	13760600.0
2018-03-26	ABC-DELISTED	Stock	84.89	85.08	82.88	84.95	1468227.0
2018-03-26	ABCB	Stock	52.9	53.75	52.5	53.75	248600.0
2018-03-26	ABCD-DELISTED	Stock	10.38	10.899	10.2509	10.3801	248417.0
2018-03-26	ABDC-DELISTED	Stock	7.16	7.28	7.1532	7.24	97460.0
2018-03-26	ABE-DELISTED	Stock	14.8	14.85	14.68	14.78	10961.0
2018-03-26	ABEO	Stock	353.75	377.5	353.75	376.25	37116.0
2018-03-26	ABEOW-DELISTED	Stock	9.87	9.87	9.8419	9.8419	800.0
2018-03-26	ABEV	Stock	7.24	7.27	7.1	7.2	21579000.0
2018-03-26	ABG	Stock	64.8	65.65	63.95	65.45	128300.0
2018-03-26	ABIL-DELISTED	Stock	3.79	5.07	3.65	4.01	331054.0
2018-03-26	ABLX-DELISTED	Stock	54.46	54.68	54.4	54.52	32207.0
2018-03-26	ABM	Stock	32.94	33.51	32.6	33.3	1054600.0
2018-03-26	ABMD-DELISTED	Stock	288.03	295.75	285.05	295.64	236179.0

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

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