PREVIEW / stock_daily / 2017-05-04

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-04.parquet
  size:    215 KB
  rows:    6,450
  symbols: 3,030

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-05-04	AAPL	Stock	36.63	36.785	36.4525	36.6325	93487600.0
2017-05-04	MSFT	Stock	69.03	69.08	68.64	68.81	21749400.0
2017-05-04	NVDA	Stock	2.6125	2.6238	2.5883	2.5962	209788000.0
2017-05-04	AMZN	Stock	47.2375	47.25	46.711	46.8765	48368000.0
2017-05-04	GOOGL	Stock	47.5145	47.957	47.3685	47.736	38765200.0
2017-05-04	META	Stock	150.17	151.52	148.72	150.85	36225500.0
2017-05-04	TSLA	Stock	20.496	20.518	19.384	19.6973	212280000.0
2017-05-04	TLT	Stock	121.01	121.22	120.665	121.18	9707211.0
2017-05-04	ES	Stock	58.11	59.52	58.11	59.49	1308700.0
2017-05-04	CL	Stock	71.4	72.22	71.1	71.95	4348300.0
2017-05-04	A	Stock	56.2	56.75	56.16	56.7	2615600.0
2017-05-04	AA	Stock	31.22	31.36	30.42	31.04	7917800.0
2017-05-04	AAAP-DELISTED	Stock	38.11	38.11	37.765	38.0	22089.0
2017-05-04	AABA-DELISTED	Stock	48.52	48.68	48.16	48.45	5308343.0
2017-05-04	AAC-DELISTED	Stock	8.16	8.987	7.77	7.94	317676.0
2017-05-04	AACG	Stock	3.67	3.67	3.53	3.63	26100.0
2017-05-04	AAIC-DELISTED	Stock	14.26	14.28	13.95	14.07	447852.0
2017-05-04	AAL	Stock	44.18	44.39	43.2	43.91	4476100.0
2017-05-04	AAM.A-DELISTED	Stock	25.56	25.59	25.48	25.59	106375.0
2017-05-04	AAMC-DELISTED	Stock	20.3382	20.4853	19.8088	20.4853	14137.0
2017-05-04	AAME	Stock	3.75	3.75	3.7	3.73	6200.0
2017-05-04	AAMI	Stock	15.67	16.01	14.82	15.04	245500.0
2017-05-04	AAOI	Stock	47.3	48.75	46.34	46.81	2998200.0
2017-05-04	AAON	Stock	24.8333	25.1333	24.5333	24.8333	177900.0
2017-05-04	AAP	Stock	142.71	144.95	142.71	144.81	595900.0
2017-05-04	AAT	Stock	41.26	41.45	40.68	41.35	318000.0
2017-05-04	AAU-DELISTED	Stock	1.42	1.43	1.35	1.355	461082.0
2017-05-04	AAUAF-DELISTED	Stock	1.42	1.43	1.35	1.35	463950.0
2017-05-04	AAV-DELISTED	Stock	6.0	6.0	5.8233	5.95	95581.0
2017-05-04	AAWW-DELISTED	Stock	54.35	54.695	51.4	52.8	470251.0
2017-05-04	AAXJ	Stock	64.58	64.61	64.14	64.15	4544783.0
2017-05-04	AAXN-DELISTED	Stock	24.77	24.9	24.68	24.84	511753.0
2017-05-04	AB	Stock	20.9	21.15	20.4	20.6	1080200.0
2017-05-04	ABAC-DELISTED	Stock	1.7126	1.78	1.67	1.67	18590.0
2017-05-04	ABAX-DELISTED	Stock	47.5	47.83	47.16	47.4	77354.0
2017-05-04	ABB-DELISTED	Stock	24.61	24.81	24.585	24.8	2289286.0
2017-05-04	ABBNY-DELISTED	Stock	24.61	24.81	24.585	24.79	2488827.0
2017-05-04	ABBV	Stock	66.74	67.4	66.62	67.23	4287400.0
2017-05-04	ABC-DELISTED	Stock	83.5	87.97	83.5	86.515	3335466.0
2017-05-04	ABCB	Stock	47.3	47.95	46.85	47.15	143600.0
2017-05-04	ABCD-DELISTED	Stock	5.32	5.32	4.97	5.06	24731.0
2017-05-04	ABCO-DELISTED	Stock	50.7	50.9	49.3	49.65	482372.0
2017-05-04	ABDC-DELISTED	Stock	14.03	14.23	13.62	13.82	56386.0
2017-05-04	ABE-DELISTED	Stock	13.77	13.77	13.6141	13.63	2426.0
2017-05-04	ABEO	Stock	132.5	141.25	132.5	141.25	4664.0
2017-05-04	ABEOW-DELISTED	Stock	2.8	2.8	2.77	2.77	500.0
2017-05-04	ABEV	Stock	5.87	6.02	5.83	5.94	63704900.0
2017-05-04	ABG	Stock	59.1	59.4	57.53	58.25	164700.0
2017-05-04	ABIL-DELISTED	Stock	0.7896	0.82	0.75	0.7679	5891.0
2017-05-04	ABM	Stock	43.51	43.54	43.07	43.51	149100.0

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

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