PREVIEW / stock_daily / 2018-08-30

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-30.parquet
  size:    218 KB
  rows:    6,504
  symbols: 2,737

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-08-30	AAPL	Stock	55.8125	57.065	55.6	56.2575	195175200.0
2018-08-30	MSFT	Stock	111.67	112.61	111.44	111.95	22798700.0
2018-08-30	NVDA	Stock	6.9308	7.043	6.908	6.9452	346608000.0
2018-08-30	AMZN	Stock	99.871	101.2785	99.345	100.119	145546000.0
2018-08-30	GOOGL	Stock	63.17	63.4745	62.3605	62.722	30104380.0
2018-08-30	META	Stock	175.9	179.79	175.7	177.64	24216500.0
2018-08-30	TSLA	Stock	20.1507	20.3067	19.848	20.21	108250500.0
2018-08-30	TLT	Stock	121.31	121.46	121.08	121.28	5302865.0
2018-08-30	ES	Stock	62.52	62.83	62.23	62.64	1356400.0
2018-08-30	CL	Stock	66.75	66.98	66.04	66.24	2754000.0
2018-08-30	A	Stock	67.0	67.65	66.86	67.26	2246300.0
2018-08-30	AA	Stock	44.99	45.17	44.305	44.37	3086400.0
2018-08-30	AABA-DELISTED	Stock	70.02	70.29	69.09	69.31	7464227.0
2018-08-30	AAC-DELISTED	Stock	9.03	9.135	8.79	8.82	131349.0
2018-08-30	AACG	Stock	2.35	2.44	2.02	2.12	906500.0
2018-08-30	AAIC-DELISTED	Stock	10.17	10.26	10.17	10.2	250690.0
2018-08-30	AAL	Stock	40.36	40.84	40.15	40.4	4330100.0
2018-08-30	AAM.A-DELISTED	Stock	25.65	25.68	25.5208	25.68	20013.0
2018-08-30	AAM.B-DELISTED	Stock	25.16	25.16	25.07	25.12	42037.0
2018-08-30	AAME	Stock	2.54	2.55	2.54	2.55	1200.0
2018-08-30	AAMI	Stock	12.84	12.99	12.61	12.64	538200.0
2018-08-30	AAOI	Stock	42.49	42.84	41.54	41.62	505100.0
2018-08-30	AAON	Stock	27.0667	27.6333	26.9467	27.1667	187950.0
2018-08-30	AAP	Stock	163.42	163.64	161.16	161.8	916300.0
2018-08-30	AAT	Stock	39.38	39.42	39.05	39.15	125500.0
2018-08-30	AAU-DELISTED	Stock	0.64	0.645	0.6264	0.6397	96690.0
2018-08-30	AAUAF-DELISTED	Stock	0.64	0.645	0.6264	0.6398	102601.0
2018-08-30	AAV-DELISTED	Stock	3.2	3.2	3.05	3.1	76634.0
2018-08-30	AAWW-DELISTED	Stock	61.95	62.1	60.7	61.6	140265.0
2018-08-30	AAXJ	Stock	71.93	71.94	71.02	71.18	904339.0
2018-08-30	AAXN-DELISTED	Stock	67.0	67.41	66.17	66.5	349020.0
2018-08-30	AB	Stock	30.2	30.25	29.8	29.9	205400.0
2018-08-30	ABAC-DELISTED	Stock	1.7501	1.7501	1.7501	1.7501	325.0
2018-08-30	ABB-DELISTED	Stock	23.73	23.75	23.51	23.6	2172782.0
2018-08-30	ABBNY-DELISTED	Stock	23.73	23.75	23.51	23.61	2506280.0
2018-08-30	ABBV	Stock	97.5	97.73	96.56	96.79	3434400.0
2018-08-30	ABC-DELISTED	Stock	88.9	90.39	88.32	90.06	1241624.0
2018-08-30	ABCB	Stock	49.35	49.53	48.85	49.1	271900.0
2018-08-30	ABCD-DELISTED	Stock	13.75	13.75	13.44	13.47	45570.0
2018-08-30	ABDC-DELISTED	Stock	6.1	6.1305	6.03	6.05	47454.0
2018-08-30	ABEO	Stock	383.75	390.0	371.25	372.5	15936.0
2018-08-30	ABEOW-DELISTED	Stock	10.5	10.5	10.5	10.5	500.0
2018-08-30	ABEV	Stock	4.62	4.64	4.49	4.58	25749100.0
2018-08-30	ABG	Stock	76.2	76.2	74.6	74.8	98200.0
2018-08-30	ABIL-DELISTED	Stock	3.8	3.9111	3.66	3.66	120093.0
2018-08-30	ABM	Stock	31.66	31.96	31.41	31.62	366000.0
2018-08-30	ABMD-DELISTED	Stock	399.89	414.7	399.89	408.57	403341.0
2018-08-30	ABR	Stock	12.06	12.17	12.05	12.13	859500.0
2018-08-30	ABR.B-DELISTED	Stock	25.48	25.48	25.48	25.48	300.0
2018-08-30	ABR.C-DELISTED	Stock	26.2192	26.2192	26.2192	26.2192	400.0

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

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