PREVIEW / stock_daily / 2019-03-27

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-27.parquet
  size:    220 KB
  rows:    6,524
  symbols: 2,598

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
2019-03-27	AAPL	Stock	47.1875	47.44	46.6375	47.1175	119393600.0
2019-03-27	MSFT	Stock	117.88	118.21	115.52	116.77	22733400.0
2019-03-27	NVDA	Stock	4.4475	4.4942	4.3425	4.4125	474372000.0
2019-03-27	AMZN	Stock	89.2065	89.375	87.284	88.285	86496000.0
2019-03-27	GOOGL	Stock	59.596	59.596	58.2115	58.9005	29428040.0
2019-03-27	META	Stock	167.85	168.94	164.79	165.87	10620300.0
2019-03-27	TSLA	Stock	17.9167	18.358	17.8787	18.322	131688000.0
2019-03-27	TLT	Stock	125.42	126.34	125.31	126.12	14207179.0
2019-03-27	ES	Stock	72.04	72.09	71.07	71.23	1511700.0
2019-03-27	CL	Stock	67.03	67.35	66.47	67.01	2918900.0
2019-03-27	A	Stock	80.5	80.77	78.89	79.0	1446100.0
2019-03-27	AA	Stock	27.9	27.985	27.22	27.91	2523300.0
2019-03-27	AABA-DELISTED	Stock	72.54	73.18	72.17	72.35	4310100.0
2019-03-27	AAC-DELISTED	Stock	1.8	1.85	1.715	1.79	185778.0
2019-03-27	AACG	Stock	0.98	1.03	0.98	1.02	34100.0
2019-03-27	AAIC-DELISTED	Stock	8.3	8.32	8.21	8.28	805369.0
2019-03-27	AAIC.C-DELISTED	Stock	23.11	23.23	23.11	23.12	11993.0
2019-03-27	AAL	Stock	30.27	31.2	30.15	30.94	6406900.0
2019-03-27	AAM.A-DELISTED	Stock	25.02	25.0625	25.01	25.02	21331.0
2019-03-27	AAM.B-DELISTED	Stock	24.73	24.76	24.6	24.6	34255.0
2019-03-27	AAMC-DELISTED	Stock	9.8824	9.8824	9.1176	9.4265	6018.0
2019-03-27	AAME	Stock	2.6	2.6	2.59	2.59	1700.0
2019-03-27	AAMI	Stock	12.96	13.15	12.86	13.0	1200600.0
2019-03-27	AAOI	Stock	12.39	12.49	11.77	12.2	752500.0
2019-03-27	AAON	Stock	28.9267	29.9933	28.8	29.9533	256350.0
2019-03-27	AAP	Stock	167.96	169.71	166.7	166.89	998900.0
2019-03-27	AAT	Stock	45.75	46.13	45.39	45.72	172000.0
2019-03-27	AAU-DELISTED	Stock	0.6518	0.6518	0.629	0.6329	177467.0
2019-03-27	AAUAF-DELISTED	Stock	0.6518	0.6518	0.629	0.633	179285.0
2019-03-27	AAWW-DELISTED	Stock	47.48	48.27	46.7	47.71	252535.0
2019-03-27	AAXJ	Stock	69.67	69.7937	69.19	69.42	660178.0
2019-03-27	AAXN-DELISTED	Stock	53.32	54.21	51.75	52.54	322911.0
2019-03-27	AB	Stock	28.19	28.55	28.18	28.48	157200.0
2019-03-27	ABB-DELISTED	Stock	18.71	18.76	18.55	18.63	1966591.0
2019-03-27	ABBNY-DELISTED	Stock	18.71	18.76	18.55	18.63	2037811.0
2019-03-27	ABBV	Stock	81.0	81.0	79.8	79.89	4006200.0
2019-03-27	ABC-DELISTED	Stock	76.36	76.87	75.65	76.5	1115454.0
2019-03-27	ABCB	Stock	34.27	34.57	33.97	34.34	286500.0
2019-03-27	ABDC-DELISTED	Stock	7.68	7.71	7.55	7.59	38764.0
2019-03-27	ABEO	Stock	186.25	187.75	173.75	179.25	15604.0
2019-03-27	ABEOW-DELISTED	Stock	2.84	3.07	2.653	3.07	1530.0
2019-03-27	ABEV	Stock	4.25	4.32	4.17	4.2	41524600.0
2019-03-27	ABG	Stock	68.54	69.93	68.54	69.62	143100.0
2019-03-27	ABIL-DELISTED	Stock	1.7	1.75	1.6	1.68	450545.0
2019-03-27	ABM	Stock	34.71	35.48	34.55	35.37	368600.0
2019-03-27	ABMD-DELISTED	Stock	286.6	289.0606	272.17	276.34	1232393.0
2019-03-27	ABR	Stock	12.98	13.06	12.91	12.96	576700.0
2019-03-27	ABR.C-DELISTED	Stock	25.9248	25.93	25.9248	25.93	336.0
2019-03-27	ABT	Stock	79.0	79.31	77.89	78.73	4101900.0
2019-03-27	ABTC	Stock	305400.0	306000.0	301500.0	304500.0	5.546666666666667

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

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