PREVIEW / stock_daily / 2018-04-24

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-24.parquet
  size:    216 KB
  rows:    6,482
  symbols: 2,827

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-04-24	AAPL	Stock	41.4175	41.5825	40.305	40.735	134768000.0
2018-04-24	MSFT	Stock	96.24	96.47	92.41	93.12	34524800.0
2018-04-24	NVDA	Stock	5.623	5.72	5.464	5.53	414596000.0
2018-04-24	AMZN	Stock	76.79	76.975	72.4225	73.0045	149894000.0
2018-04-24	GOOGL	Stock	52.96	53.2245	50.6428	51.132	128220760.0
2018-04-24	META	Stock	165.43	166.1	158.19	159.69	35079900.0
2018-04-24	TSLA	Stock	19.0	19.1393	18.564	18.8973	85279500.0
2018-04-24	TLT	Stock	118.21	118.45	117.7608	117.95	8190786.0
2018-04-24	ES	Stock	59.29	59.91	59.06	59.44	2045300.0
2018-04-24	CL	Stock	66.69	66.91	65.85	66.63	5004600.0
2018-04-24	A	Stock	66.39	67.91	66.04	66.64	3701600.0
2018-04-24	AA	Stock	51.47	52.2	49.9	50.82	7258100.0
2018-04-24	AABA-DELISTED	Stock	70.55	70.75	68.46	69.2	2650846.0
2018-04-24	AAC-DELISTED	Stock	11.18	11.18	10.76	10.85	73028.0
2018-04-24	AACG	Stock	5.3	5.3	5.18	5.18	2700.0
2018-04-24	AAIC-DELISTED	Stock	11.12	11.185	11.045	11.16	449209.0
2018-04-24	AAL	Stock	46.72	47.17	45.11	45.69	3954300.0
2018-04-24	AAM.A-DELISTED	Stock	24.3	24.3	24.15	24.28	25574.0
2018-04-24	AAM.B-DELISTED	Stock	24.3285	24.3285	24.16	24.2	31673.0
2018-04-24	AAMC-DELISTED	Stock	17.3529	17.6471	16.6618	17.1765	65338.0
2018-04-24	AAMI	Stock	15.0	15.14	14.82	14.88	446000.0
2018-04-24	AAOI	Stock	32.7	34.105	31.79	32.9	1564600.0
2018-04-24	AAON	Stock	24.2	24.2667	23.2	23.5	297600.0
2018-04-24	AAP	Stock	105.76	107.83	105.2	106.93	1162900.0
2018-04-24	AAT	Stock	32.54	32.87	32.25	32.75	295500.0
2018-04-24	AAU-DELISTED	Stock	0.8	0.8197	0.8	0.8194	75667.0
2018-04-24	AAUAF-DELISTED	Stock	0.8	0.8197	0.8	0.81	83424.0
2018-04-24	AAV-DELISTED	Stock	3.2	3.3	3.15	3.3	380336.0
2018-04-24	AAWW-DELISTED	Stock	63.9	64.545	62.3	63.3	91054.0
2018-04-24	AAXJ	Stock	76.35	76.58	75.21	75.54	561211.0
2018-04-24	AAXN-DELISTED	Stock	43.03	43.7319	41.7	42.81	576130.0
2018-04-24	AB	Stock	26.25	26.55	26.2	26.35	371200.0
2018-04-24	ABAC-DELISTED	Stock	2.48	2.5	2.45	2.45	1123.0
2018-04-24	ABAX-DELISTED	Stock	72.66	73.56	71.215	72.45	121784.0
2018-04-24	ABB-DELISTED	Stock	24.23	24.24	23.585	23.76	2467280.0
2018-04-24	ABBNY-DELISTED	Stock	24.23	24.24	23.585	23.76	2636687.0
2018-04-24	ABBV	Stock	92.95	93.48	90.44	91.36	6378300.0
2018-04-24	ABC-DELISTED	Stock	91.4	91.98	89.385	90.14	819474.0
2018-04-24	ABCB	Stock	51.95	52.9	51.85	52.45	259500.0
2018-04-24	ABCD-DELISTED	Stock	11.35	11.5	9.9	10.13	802184.0
2018-04-24	ABDC-DELISTED	Stock	6.58	6.587	6.45	6.51	41223.0
2018-04-24	ABE-DELISTED	Stock	14.7389	14.7389	14.72	14.72	700.0
2018-04-24	ABEO	Stock	496.25	522.25	452.75	461.25	55744.0
2018-04-24	ABEOW-DELISTED	Stock	14.95	14.95	13.35	13.35	3650.0
2018-04-24	ABEV	Stock	6.73	6.8	6.66	6.69	15131500.0
2018-04-24	ABG	Stock	71.25	73.45	68.55	69.3	260600.0
2018-04-24	ABIL-DELISTED	Stock	2.9	3.4787	2.53	2.63	242759.0
2018-04-24	ABLX-DELISTED	Stock	54.61	54.73	54.61	54.66	28479.0
2018-04-24	ABM	Stock	32.18	32.62	31.76	31.98	617900.0
2018-04-24	ABMD-DELISTED	Stock	303.23	305.49	285.0201	290.94	441461.0

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

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