PREVIEW / stock_daily / 2018-04-11

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-11.parquet
  size:    216 KB
  rows:    6,480
  symbols: 2,832

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-11	AAPL	Stock	43.0575	43.48	42.925	43.11	89726400.0
2018-04-11	MSFT	Stock	92.01	93.29	91.48	91.86	24872100.0
2018-04-11	NVDA	Stock	5.6828	5.7245	5.623	5.656	460244000.0
2018-04-11	AMZN	Stock	71.972	72.439	71.2445	71.3525	71650000.0
2018-04-11	GOOGL	Stock	51.6	51.7935	50.96	51.253	34060300.0
2018-04-11	META	Stock	165.36	168.65	163.25	166.32	56144600.0
2018-04-11	TSLA	Stock	20.0493	20.5987	19.9773	20.062	112243500.0
2018-04-11	TLT	Stock	121.85	121.89	121.27	121.51	5901296.0
2018-04-11	ES	Stock	59.3	59.76	59.21	59.41	1450500.0
2018-04-11	CL	Stock	71.56	71.89	71.05	71.38	4078500.0
2018-04-11	A	Stock	65.98	66.6	65.82	66.08	1391400.0
2018-04-11	AA	Stock	53.8	54.89	52.65	53.97	5434600.0
2018-04-11	AABA-DELISTED	Stock	70.31	71.4543	70.18	70.54	3766745.0
2018-04-11	AAC-DELISTED	Stock	11.24	11.38	11.0	11.01	42153.0
2018-04-11	AACG	Stock	5.45	5.46	5.16	5.16	4200.0
2018-04-11	AAIC-DELISTED	Stock	11.25	11.345	11.205	11.3	550123.0
2018-04-11	AAL	Stock	47.15	47.46	45.37	45.4	10151100.0
2018-04-11	AAM.A-DELISTED	Stock	24.85	24.93	24.82	24.9	29466.0
2018-04-11	AAM.B-DELISTED	Stock	24.79	24.82	24.72	24.72	370227.0
2018-04-11	AAME	Stock	3.22	3.35	3.22	3.27	700.0
2018-04-11	AAMI	Stock	14.79	14.94	14.725	14.81	723400.0
2018-04-11	AAOI	Stock	27.0	29.81	26.6	29.12	3359400.0
2018-04-11	AAON	Stock	22.8667	22.9667	22.5	22.9667	275400.0
2018-04-11	AAP	Stock	111.16	112.32	110.15	110.93	577600.0
2018-04-11	AAT	Stock	34.03	34.32	34.03	34.23	178400.0
2018-04-11	AAU-DELISTED	Stock	0.85	0.85	0.79	0.8248	294665.0
2018-04-11	AAUAF-DELISTED	Stock	0.85	0.85	0.79	0.8248	308287.0
2018-04-11	AAV-DELISTED	Stock	3.35	3.5	3.3166	3.425	668672.0
2018-04-11	AAWW-DELISTED	Stock	61.9	62.35	61.25	61.7	82502.0
2018-04-11	AAXJ	Stock	77.53	78.05	77.51	77.82	389154.0
2018-04-11	AAXN-DELISTED	Stock	42.01	43.19	42.0	42.78	559427.0
2018-04-11	AB	Stock	26.75	26.95	26.31	26.5	279500.0
2018-04-11	ABAC-DELISTED	Stock	2.74	2.9658	2.43	2.44	11469.0
2018-04-11	ABAX-DELISTED	Stock	70.71	72.25	70.29	71.75	70970.0
2018-04-11	ABB-DELISTED	Stock	22.77	22.88	22.71	22.76	1814573.0
2018-04-11	ABBNY-DELISTED	Stock	22.77	22.88	22.71	22.76	3903391.0
2018-04-11	ABBV	Stock	92.58	94.48	92.4	93.64	7135700.0
2018-04-11	ABC-DELISTED	Stock	87.95	89.9034	87.82	89.08	591997.0
2018-04-11	ABCB	Stock	52.7	52.9	51.95	52.05	218000.0
2018-04-11	ABCD-DELISTED	Stock	11.23	11.6889	11.23	11.47	188935.0
2018-04-11	ABDC-DELISTED	Stock	7.07	7.16	7.0	7.02	42323.0
2018-04-11	ABE-DELISTED	Stock	14.7	14.959	14.7	14.89	3710.0
2018-04-11	ABEO	Stock	437.5	471.25	431.5	453.75	73952.0
2018-04-11	ABEOW-DELISTED	Stock	13.47	13.47	13.32	13.32	300.0
2018-04-11	ABEV	Stock	6.94	7.07	6.93	7.0	22238300.0
2018-04-11	ABG	Stock	67.4	68.0	66.5	67.05	145400.0
2018-04-11	ABIL-DELISTED	Stock	2.98	3.12	2.8701	2.95	10617.0
2018-04-11	ABLX-DELISTED	Stock	55.05	55.129	54.9	54.93	99259.0
2018-04-11	ABM	Stock	32.18	32.73	32.18	32.56	390700.0
2018-04-11	ABMD-DELISTED	Stock	300.4	302.94	295.276	296.399	232270.0

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

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