PREVIEW / stock_daily / 2019-09-04

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-04.parquet
  size:    219 KB
  rows:    6,573
  symbols: 2,525

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-09-04	AAPL	Stock	52.0975	52.37	51.83	52.2975	76752400.0
2019-09-04	MSFT	Stock	137.3	137.69	136.48	137.63	17995900.0
2019-09-04	NVDA	Stock	4.1652	4.2265	4.1652	4.219	227728000.0
2019-09-04	AMZN	Stock	90.25	90.3815	89.8115	90.031	46482000.0
2019-09-04	GOOGL	Stock	58.9725	59.244	58.5765	59.1135	21313320.0
2019-09-04	META	Stock	184.65	187.75	183.89	187.14	11308000.0
2019-09-04	TSLA	Stock	15.126	15.2307	14.614	14.712	86415000.0
2019-09-04	TLT	Stock	146.53	147.62	146.48	147.43	7962232.0
2019-09-04	ES	Stock	83.1	83.1	81.82	82.49	1914400.0
2019-09-04	CL	Stock	74.83	75.0	74.46	74.87	2422900.0
2019-09-04	A	Stock	70.94	71.22	69.96	70.86	1820600.0
2019-09-04	AA	Stock	18.02	18.39	17.96	18.28	2573200.0
2019-09-04	AABA-DELISTED	Stock	69.53	69.61	69.43	69.61	4831505.0
2019-09-04	AAC-DELISTED	Stock	0.5445	0.6199	0.5445	0.571	247829.0
2019-09-04	AACG	Stock	1.87	1.93	1.87	1.87	37900.0
2019-09-04	AAIC-DELISTED	Stock	4.98	5.13	4.98	5.04	507949.0
2019-09-04	AAIC.C-DELISTED	Stock	22.1145	22.1145	21.75	21.83	5934.0
2019-09-04	AAL	Stock	26.66	27.22	26.52	27.0	5653300.0
2019-09-04	AAM.A-DELISTED	Stock	26.32	26.77	26.29	26.7	84376.0
2019-09-04	AAM.B-DELISTED	Stock	26.6	26.7	26.49	26.69	74733.0
2019-09-04	AAME	Stock	2.85	2.85	2.7	2.7	300.0
2019-09-04	AAMI	Stock	9.17	9.26	9.05	9.06	418200.0
2019-09-04	AAOI	Stock	8.86	9.39	8.855	9.1	550700.0
2019-09-04	AAON	Stock	31.1267	31.9133	31.0	31.7467	177150.0
2019-09-04	AAP	Stock	141.57	142.31	138.51	141.89	1235200.0
2019-09-04	AAT	Stock	47.33	47.66	47.24	47.54	247900.0
2019-09-04	AAU-DELISTED	Stock	0.77	0.77	0.72	0.7277	162952.0
2019-09-04	AAUAF-DELISTED	Stock	0.77	0.77	0.72	0.7277	177240.0
2019-09-04	AAWW-DELISTED	Stock	25.32	25.52	24.79	25.3	226617.0
2019-09-04	AAXJ	Stock	65.99	66.205	65.86	66.14	2631600.0
2019-09-04	AAXN-DELISTED	Stock	59.71	60.24	59.13	60.0	264825.0
2019-09-04	AB	Stock	28.61	28.8	28.36	28.6	157000.0
2019-09-04	ABB-DELISTED	Stock	18.85	18.98	18.81	18.96	1832201.0
2019-09-04	ABBNY-DELISTED	Stock	18.85	18.98	18.81	18.96	1901448.0
2019-09-04	ABBV	Stock	65.67	66.42	64.44	66.38	9618300.0
2019-09-04	ABC-DELISTED	Stock	84.36	85.45	84.34	85.19	603200.0
2019-09-04	ABCB	Stock	34.23	34.46	33.97	34.15	227500.0
2019-09-04	ABDC-DELISTED	Stock	8.98	8.98	8.8886	8.97	21346.0
2019-09-04	ABEO	Stock	68.25	74.25	64.0	74.25	196520.0
2019-09-04	ABEOW-DELISTED	Stock	0.3807	0.45	0.3807	0.45	600.0
2019-09-04	ABEV	Stock	4.5	4.6	4.5	4.58	19266300.0
2019-09-04	ABG	Stock	93.43	95.4	92.89	95.28	90600.0
2019-09-04	ABIL-DELISTED	Stock	0.6208	0.67	0.6101	0.6438	36001.0
2019-09-04	ABM	Stock	37.0	37.15	36.34	36.65	597900.0
2019-09-04	ABMD-DELISTED	Stock	185.84	186.9893	180.0	183.38	304054.0
2019-09-04	ABR	Stock	12.47	12.61	12.47	12.56	674300.0
2019-09-04	ABR.A-DELISTED	Stock	25.92	25.985	25.92	25.985	3264.0
2019-09-04	ABR.B-DELISTED	Stock	25.58	25.58	25.58	25.58	100.0
2019-09-04	ABR.C-DELISTED	Stock	26.296	26.77	26.296	26.36	5650.0
2019-09-04	ABT	Stock	84.5	84.7	83.78	84.22	3673100.0

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

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