PREVIEW / stock_daily / 2019-08-19

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-19.parquet
  size:    219 KB
  rows:    6,570
  symbols: 2,514

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-08-19	AAPL	Stock	52.655	53.1825	52.5075	52.5875	97654400.0
2019-08-19	MSFT	Stock	137.85	138.55	136.89	138.41	24355700.0
2019-08-19	NVDA	Stock	4.103	4.2855	4.0868	4.2695	815112000.0
2019-08-19	AMZN	Stock	90.904	91.3	90.6305	90.806	56326000.0
2019-08-19	GOOGL	Stock	59.5915	60.4695	59.52	60.022	24457080.0
2019-08-19	META	Stock	186.01	187.5	184.85	186.17	9691200.0
2019-08-19	TSLA	Stock	14.9473	15.1887	14.78	15.122	79644000.0
2019-08-19	TLT	Stock	143.57	144.66	143.515	144.04	13615286.0
2019-08-19	ES	Stock	78.68	79.35	78.34	78.97	1338400.0
2019-08-19	CL	Stock	73.01	73.26	72.64	73.08	2139500.0
2019-08-19	A	Stock	71.93	72.28	71.5	71.75	2050400.0
2019-08-19	AA	Stock	17.84	18.37	17.81	18.23	3505000.0
2019-08-19	AABA-DELISTED	Stock	69.98	70.0	69.7	69.72	6725733.0
2019-08-19	AAC-DELISTED	Stock	0.62	0.6701	0.603	0.62	281219.0
2019-08-19	AACG	Stock	2.07	2.08	2.02	2.02	67000.0
2019-08-19	AAIC-DELISTED	Stock	5.64	5.672	5.6	5.6	203822.0
2019-08-19	AAIC.C-DELISTED	Stock	22.5654	22.6581	22.3336	22.379	6372.0
2019-08-19	AAL	Stock	26.2	26.69	26.08	26.1	9034800.0
2019-08-19	AAM.A-DELISTED	Stock	26.5856	26.6441	26.5856	26.59	2256.0
2019-08-19	AAM.B-DELISTED	Stock	26.51	26.68	26.51	26.68	8281.0
2019-08-19	AAMC-DELISTED	Stock	2.4735	2.8559	2.4735	2.8529	9789.0
2019-08-19	AAME	Stock	2.4	2.4	2.4	2.4	300.0
2019-08-19	AAMI	Stock	8.71	8.84	8.63	8.72	489900.0
2019-08-19	AAOI	Stock	9.45	9.6	9.25	9.53	359300.0
2019-08-19	AAON	Stock	31.8933	32.58	31.5667	31.5867	216600.0
2019-08-19	AAP	Stock	138.0	138.26	135.22	136.35	1287800.0
2019-08-19	AAT	Stock	47.29	47.33	46.32	47.28	182600.0
2019-08-19	AAU-DELISTED	Stock	0.732	0.755	0.7	0.71	283678.0
2019-08-19	AAUAF-DELISTED	Stock	0.732	0.755	0.7	0.71	302793.0
2019-08-19	AAWW-DELISTED	Stock	27.69	27.8495	27.0866	27.435	257060.0
2019-08-19	AAXJ	Stock	65.54	65.59	65.1	65.13	972423.0
2019-08-19	AAXN-DELISTED	Stock	60.4	60.91	59.59	60.04	633685.0
2019-08-19	AB	Stock	27.03	27.61	27.03	27.36	248000.0
2019-08-19	ABB-DELISTED	Stock	18.69	18.71	18.59	18.62	1202622.0
2019-08-19	ABBNY-DELISTED	Stock	18.69	18.71	18.59	18.63	1292521.0
2019-08-19	ABBV	Stock	65.04	66.88	64.97	66.56	9826300.0
2019-08-19	ABC-DELISTED	Stock	88.21	88.97	87.63	87.75	730456.0
2019-08-19	ABCB	Stock	37.04	37.14	36.65	36.84	241400.0
2019-08-19	ABDC-DELISTED	Stock	8.83	8.9353	8.8	8.905	230339.0
2019-08-19	ABEO	Stock	56.25	56.75	53.75	55.75	14944.0
2019-08-19	ABEOW-DELISTED	Stock	0.25	0.25	0.25	0.25	100.0
2019-08-19	ABEV	Stock	4.75	4.76	4.59	4.67	20560800.0
2019-08-19	ABG	Stock	91.03	91.87	87.46	90.96	92600.0
2019-08-19	ABIL-DELISTED	Stock	0.62	0.6799	0.5722	0.64	195150.0
2019-08-19	ABM	Stock	38.97	39.22	38.68	38.93	234400.0
2019-08-19	ABMD-DELISTED	Stock	195.0	195.0	190.22	192.3	304611.0
2019-08-19	ABR	Stock	12.27	12.35	12.01	12.32	623600.0
2019-08-19	ABR.A-DELISTED	Stock	25.99	25.99	25.925	25.97	3835.0
2019-08-19	ABR.C-DELISTED	Stock	26.6	26.6	25.8	26.44	4745.0
2019-08-19	ABT	Stock	85.79	86.13	85.33	85.56	4579800.0

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

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