PREVIEW / stock_daily / 2015-07-17

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-17.parquet
  size:    223 KB
  rows:    6,668
  symbols: 3,488

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
2015-07-17	AAPL	Stock	32.27	32.405	32.0775	32.405	184658800.0
2015-07-17	MSFT	Stock	46.55	46.78	46.26	46.62	29467100.0
2015-07-17	NVDA	Stock	0.503	0.5035	0.4952	0.5018	220372000.0
2015-07-17	AMZN	Stock	23.885	24.271	23.8625	24.1505	98644000.0
2015-07-17	GOOGL	Stock	34.0	35.15	33.9	34.981	257162720.0
2015-07-17	META	Stock	92.55	95.39	92.54	94.97	54001600.0
2015-07-17	TSLA	Stock	18.1667	18.3693	17.8833	18.3107	75061500.0
2015-07-17	TLT	Stock	118.37	118.89	118.36	118.72	7404940.0
2015-07-17	ES	Stock	48.3	48.49	47.85	47.92	1246800.0
2015-07-17	CL	Stock	67.36	67.62	67.2	67.5	1792000.0
2015-07-17	A	Stock	40.2	40.33	39.84	39.95	2412400.0
2015-07-17	AA.B-DELISTED	Stock	38.6	38.69	38.21	38.46	64766.0
2015-07-17	AABA-DELISTED	Stock	39.19	39.79	38.93	39.68	14238011.0
2015-07-17	AAC-DELISTED	Stock	43.49	43.8255	40.6	41.77	264296.0
2015-07-17	AACG	Stock	4.34	4.46	4.16	4.33	44100.0
2015-07-17	AAIC-DELISTED	Stock	20.01	20.08	19.97	20.04	594581.0
2015-07-17	AAL	Stock	41.45	41.84	41.24	41.4	9736000.0
2015-07-17	AAMC-DELISTED	Stock	43.3824	44.6735	42.0588	43.1206	29478.0
2015-07-17	AAME	Stock	3.7	3.7	3.7	3.7	1100.0
2015-07-17	AAMI	Stock	17.89	17.89	17.57	17.62	83900.0
2015-07-17	AAOI	Stock	19.34	19.52	19.06	19.28	355000.0
2015-07-17	AAON	Stock	15.08	15.32	14.9867	15.2733	188700.0
2015-07-17	AAP	Stock	169.07	169.87	168.06	169.7	522700.0
2015-07-17	AAT	Stock	41.38	41.6	41.03	41.26	97300.0
2015-07-17	AAU-DELISTED	Stock	0.76	0.77	0.7241	0.7306	146155.0
2015-07-17	AAUAF-DELISTED	Stock	0.76	0.77	0.7241	0.7306	146681.0
2015-07-17	AAV-DELISTED	Stock	5.98	5.98	5.71	5.73	97667.0
2015-07-17	AAVL-DELISTED	Stock	16.57	16.82	16.3	16.65	428201.0
2015-07-17	AAWW-DELISTED	Stock	51.76	52.53	51.29	51.34	402854.0
2015-07-17	AAXJ	Stock	61.85	61.85	61.52	61.62	427505.0
2015-07-17	AAXN-DELISTED	Stock	34.6	34.6	33.81	34.01	1057105.0
2015-07-17	AB	Stock	28.41	28.68	28.0	28.5	212900.0
2015-07-17	ABAC-DELISTED	Stock	1.04	1.1015	1.04	1.1015	2073.0
2015-07-17	ABAX-DELISTED	Stock	54.24	54.83	53.58	54.4	152955.0
2015-07-17	ABB-DELISTED	Stock	20.69	20.7	20.6	20.66	1225010.0
2015-07-17	ABBNY-DELISTED	Stock	20.69	20.7	20.6	20.65	1311339.0
2015-07-17	ABBV	Stock	69.99	70.13	69.7	69.99	6141200.0
2015-07-17	ABC-DELISTED	Stock	111.85	113.66	111.1	113.2	1726902.0
2015-07-17	ABCB	Stock	26.11	26.18	25.75	26.09	65700.0
2015-07-17	ABCD-DELISTED	Stock	4.9	5.05	4.9	5.05	58536.0
2015-07-17	ABCO-DELISTED	Stock	59.0	59.5	58.31	58.62	203588.0
2015-07-17	ABCW-DELISTED	Stock	41.19	41.22	40.42	41.0	19826.0
2015-07-17	ABDC-DELISTED	Stock	13.08	13.28	12.83	12.92	56363.0
2015-07-17	ABE-DELISTED	Stock	13.13	13.18	13.101	13.13	3542.0
2015-07-17	ABEO	Stock	141.5	152.75	138.25	150.0	10128.0
2015-07-17	ABEOW-DELISTED	Stock	1.97	2.01	1.86	1.95	7775.0
2015-07-17	ABEV	Stock	6.22	6.23	6.1	6.16	14297800.0
2015-07-17	ABG	Stock	93.87	95.34	93.51	95.17	414100.0
2015-07-17	ABGB-DELISTED	Stock	15.35	15.39	15.12	15.22	19346.0
2015-07-17	ABM	Stock	32.78	32.82	32.53	32.62	174600.0

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

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