PREVIEW / stock_daily / 2017-08-11

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-11.parquet
  size:    213 KB
  rows:    6,426
  symbols: 2,944

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
2017-08-11	AAPL	Stock	39.15	39.6425	39.0175	39.37	105028400.0
2017-08-11	MSFT	Stock	71.61	72.7	71.28	72.5	21443700.0
2017-08-11	NVDA	Stock	3.9285	3.975	3.8228	3.899	1497196000.0
2017-08-11	AMZN	Stock	48.0	48.5195	47.569	48.3995	69360000.0
2017-08-11	GOOGL	Stock	46.1855	46.668	46.061	46.5045	32334160.0
2017-08-11	META	Stock	167.95	168.82	166.85	168.08	13791200.0
2017-08-11	TSLA	Stock	23.798	24.084	23.5747	23.858	65487000.0
2017-08-11	TLT	Stock	125.77	126.46	125.55	126.43	5717807.0
2017-08-11	ES	Stock	62.0	62.29	61.59	61.86	1416400.0
2017-08-11	CL	Stock	71.78	71.88	71.23	71.26	2023500.0
2017-08-11	A	Stock	58.7	59.7	58.69	59.33	1511600.0
2017-08-11	AA	Stock	37.21	37.91	36.93	37.78	2974300.0
2017-08-11	AAAP-DELISTED	Stock	49.0	49.17	48.1732	48.56	13390.0
2017-08-11	AABA-DELISTED	Stock	57.78	58.2325	56.84	57.915	5022939.0
2017-08-11	AAC-DELISTED	Stock	8.42	8.75	8.2	8.66	60793.0
2017-08-11	AACG	Stock	4.55	4.8	4.55	4.8	4700.0
2017-08-11	AAIC-DELISTED	Stock	12.91	13.0	12.81	12.98	316128.0
2017-08-11	AAL	Stock	48.5	48.79	47.44	48.35	5610700.0
2017-08-11	AAM.A-DELISTED	Stock	26.07	26.07	25.87	25.87	22516.0
2017-08-11	AAMC-DELISTED	Stock	20.5882	22.3529	20.5882	21.6176	29039.0
2017-08-11	AAME	Stock	3.5	3.5	3.2	3.2	1000.0
2017-08-11	AAMI	Stock	13.56	13.85	13.41	13.8	1237800.0
2017-08-11	AAOI	Stock	63.61	66.89	63.02	65.84	2857000.0
2017-08-11	AAON	Stock	22.3667	22.4667	22.0333	22.0667	166800.0
2017-08-11	AAP	Stock	106.09	107.47	105.24	107.34	1902800.0
2017-08-11	AAT	Stock	39.63	40.17	39.63	39.77	370300.0
2017-08-11	AAU-DELISTED	Stock	1.11	1.11	1.0688	1.11	139295.0
2017-08-11	AAUAF-DELISTED	Stock	1.11	1.11	1.0688	1.1	143442.0
2017-08-11	AAV-DELISTED	Stock	6.45	6.55	6.45	6.45	60258.0
2017-08-11	AAWW-DELISTED	Stock	62.0	62.35	60.3	60.65	312807.0
2017-08-11	AAXJ	Stock	69.21	69.53	69.03	69.24	1593215.0
2017-08-11	AAXN-DELISTED	Stock	22.65	22.73	21.91	22.37	1038406.0
2017-08-11	AB	Stock	23.5	24.0	23.15	23.75	253100.0
2017-08-11	ABAC-DELISTED	Stock	2.18	2.2547	2.03	2.09	12521.0
2017-08-11	ABAX-DELISTED	Stock	45.66	47.05	45.49	46.67	122417.0
2017-08-11	ABB-DELISTED	Stock	22.87	22.97	22.814	22.83	1303471.0
2017-08-11	ABBNY-DELISTED	Stock	22.87	22.97	22.814	22.83	1363867.0
2017-08-11	ABBV	Stock	70.74	71.01	70.43	70.63	3248300.0
2017-08-11	ABC-DELISTED	Stock	78.83	80.31	78.73	80.0	1868517.0
2017-08-11	ABCB	Stock	43.95	44.05	42.98	43.25	122000.0
2017-08-11	ABCD-DELISTED	Stock	5.21	5.3	5.2	5.22	14137.0
2017-08-11	ABCO-DELISTED	Stock	50.75	52.25	50.75	52.025	666020.0
2017-08-11	ABDC-DELISTED	Stock	10.2	10.83	10.2	10.79	162054.0
2017-08-11	ABE-DELISTED	Stock	13.69	13.74	13.66	13.74	2750.0
2017-08-11	ABEO	Stock	192.5	195.0	186.25	188.75	8632.0
2017-08-11	ABEOW-DELISTED	Stock	4.5946	4.6	4.5946	4.6	300.0
2017-08-11	ABEV	Stock	6.1	6.15	6.07	6.12	11601600.0
2017-08-11	ABG	Stock	51.3	52.45	51.05	52.25	195800.0
2017-08-11	ABIL-DELISTED	Stock	0.66	0.7275	0.66	0.6882	38098.0
2017-08-11	ABM	Stock	43.19	43.89	42.98	43.26	240400.0

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

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