PREVIEW / stock_daily / 2016-04-21

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-21.parquet
  size:    219 KB
  rows:    6,565
  symbols: 3,307

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
2016-04-21	AAPL	Stock	26.7325	26.7325	26.38	26.4925	126210000.0
2016-04-21	MSFT	Stock	55.8	56.23	55.42	55.78	38909100.0
2016-04-21	NVDA	Stock	0.9115	0.9158	0.9062	0.9102	178280000.0
2016-04-21	AMZN	Stock	31.55	31.891	31.425	31.55	51926000.0
2016-04-21	GOOGL	Stock	38.8655	39.084	38.5775	39.0	77628400.0
2016-04-21	META	Stock	112.55	114.04	112.31	113.44	20875200.0
2016-04-21	TSLA	Stock	16.5993	16.7267	16.4607	16.5527	41746500.0
2016-04-21	TLT	Stock	128.44	129.07	128.29	128.69	11154216.0
2016-04-21	ES	Stock	55.41	55.61	54.51	55.02	2802500.0
2016-04-21	CL	Stock	70.2	70.32	68.81	68.98	4127600.0
2016-04-21	A	Stock	41.5	42.0	41.42	41.93	1670400.0
2016-04-21	AA.B-DELISTED	Stock	36.6	36.7	36.0	36.1999	33328.0
2016-04-21	AAAP-DELISTED	Stock	34.48	34.97	34.45	34.78	5700.0
2016-04-21	AABA-DELISTED	Stock	37.92	38.12	37.35	37.68	11130431.0
2016-04-21	AAC-DELISTED	Stock	20.68	20.94	20.07	20.12	83456.0
2016-04-21	AACG	Stock	5.84	6.05	5.84	5.91	37300.0
2016-04-21	AAIC-DELISTED	Stock	13.06	13.17	12.9	13.07	199617.0
2016-04-21	AAL	Stock	40.8	40.93	39.8	40.01	10782600.0
2016-04-21	AAMC-DELISTED	Stock	5.3971	5.3971	4.8824	4.8971	74817.0
2016-04-21	AAME	Stock	4.6	4.6	4.54	4.54	300.0
2016-04-21	AAMI	Stock	13.83	14.11	13.61	13.75	151200.0
2016-04-21	AAOI	Stock	11.54	11.54	11.01	11.01	567900.0
2016-04-21	AAON	Stock	18.0933	18.28	17.9533	18.0	304200.0
2016-04-21	AAP	Stock	158.4	158.83	156.38	157.13	686000.0
2016-04-21	AAT	Stock	37.89	38.15	37.45	37.64	323400.0
2016-04-21	AAU-DELISTED	Stock	1.23	1.25	1.15	1.17	605467.0
2016-04-21	AAUAF-DELISTED	Stock	1.23	1.25	1.15	1.17	613512.0
2016-04-21	AAV-DELISTED	Stock	5.5	5.54	5.43	5.45	37842.0
2016-04-21	AAVL-DELISTED	Stock	5.67	6.16	5.67	6.105	383772.0
2016-04-21	AAWW-DELISTED	Stock	40.7	40.7	39.9	40.28	114047.0
2016-04-21	AAXJ	Stock	55.53	55.6	55.09	55.17	548352.0
2016-04-21	AAXN-DELISTED	Stock	19.01	19.1	18.57	18.665	712776.0
2016-04-21	AB	Stock	24.52	24.65	24.11	24.12	162400.0
2016-04-21	ABAX-DELISTED	Stock	45.21	46.225	44.98	45.76	183338.0
2016-04-21	ABB-DELISTED	Stock	20.69	20.84	20.6199	20.69	2533200.0
2016-04-21	ABBNY-DELISTED	Stock	20.7	20.84	20.6199	20.69	2701974.0
2016-04-21	ABBV	Stock	60.57	61.43	60.54	61.37	5702400.0
2016-04-21	ABC-DELISTED	Stock	91.63	92.48	91.52	91.81	2086840.0
2016-04-21	ABCB	Stock	31.09	31.37	30.92	31.16	156600.0
2016-04-21	ABCD-DELISTED	Stock	4.39	4.53	4.31	4.38	28572.0
2016-04-21	ABCO-DELISTED	Stock	31.8	32.26	31.47	31.49	215303.0
2016-04-21	ABCW-DELISTED	Stock	46.99	47.139	46.64	46.91	25583.0
2016-04-21	ABDC-DELISTED	Stock	11.59	11.79	11.59	11.76	18348.0
2016-04-21	ABE-DELISTED	Stock	12.1	12.17	12.05	12.05	10816.0
2016-04-21	ABEO	Stock	67.5	69.5	66.5	68.5	1060.0
2016-04-21	ABEV	Stock	5.44	5.45	5.31	5.39	12796500.0
2016-04-21	ABG	Stock	59.94	60.47	56.88	57.08	558100.0
2016-04-21	ABGB-DELISTED	Stock	1.44	1.48	1.4	1.4	38768.0
2016-04-21	ABIL-DELISTED	Stock	7.27	7.9792	7.16	7.46	26730.0
2016-04-21	ABM	Stock	32.29	32.34	31.97	32.02	140600.0

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

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