PREVIEW / stock_daily / 2016-01-07

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-07.parquet
  size:    221 KB
  rows:    6,657
  symbols: 3,409

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-01-07	AAPL	Stock	24.67	25.0325	24.1075	24.1125	324377600.0
2016-01-07	MSFT	Stock	52.7	53.49	52.07	52.17	56564900.0
2016-01-07	NVDA	Stock	0.7685	0.7738	0.747	0.757	645304000.0
2016-01-07	AMZN	Stock	31.09	31.5	30.2605	30.397	141498000.0
2016-01-07	GOOGL	Stock	37.3245	37.7655	36.764	37.05	63131260.0
2016-01-07	META	Stock	100.5	101.43	97.3	97.92	45172900.0
2016-01-07	TSLA	Stock	14.2793	14.5627	14.2447	14.3767	53314500.0
2016-01-07	TLT	Stock	122.68	122.93	121.785	122.81	10202158.0
2016-01-07	ES	Stock	50.8	51.29	50.76	51.14	2141700.0
2016-01-07	CL	Stock	63.4	63.9	62.76	63.01	4476300.0
2016-01-07	A	Stock	40.14	40.15	38.81	39.0	3504300.0
2016-01-07	AA.B-DELISTED	Stock	29.75	29.78	28.53	28.8	105502.0
2016-01-07	AAAP-DELISTED	Stock	30.02	30.02	28.365	29.65	14088.0
2016-01-07	AABA-DELISTED	Stock	30.94	31.19	30.02	30.17	19969531.0
2016-01-07	AAC-DELISTED	Stock	18.75	18.93	18.01	18.19	86244.0
2016-01-07	AACG	Stock	7.2	7.2	6.33	6.35	169500.0
2016-01-07	AAIC-DELISTED	Stock	13.23	13.35	12.9	12.9	306000.0
2016-01-07	AAL	Stock	40.97	41.52	39.68	40.45	11312900.0
2016-01-07	AAMC-DELISTED	Stock	5.7147	5.7176	4.4529	4.5529	321633.0
2016-01-07	AAME	Stock	4.66	4.66	4.41	4.58	1700.0
2016-01-07	AAMI	Stock	14.0	14.19	13.45	13.6	310300.0
2016-01-07	AAOI	Stock	15.48	16.03	14.92	15.29	374300.0
2016-01-07	AAON	Stock	14.1733	14.3133	14.06	14.14	237450.0
2016-01-07	AAP	Stock	144.8	149.46	143.13	148.83	1343700.0
2016-01-07	AAT	Stock	38.23	38.47	37.78	37.9	249900.0
2016-01-07	AAU-DELISTED	Stock	0.6633	0.6636	0.6288	0.643	24750.0
2016-01-07	AAUAF-DELISTED	Stock	0.6633	0.6636	0.6288	0.643	25100.0
2016-01-07	AAV-DELISTED	Stock	4.58	4.84	4.58	4.73	259213.0
2016-01-07	AAVL-DELISTED	Stock	7.74	8.215	7.26	7.5	256489.0
2016-01-07	AAWW-DELISTED	Stock	38.34	41.185	35.81	35.92	309789.0
2016-01-07	AAXJ	Stock	49.68	50.46	49.52	49.52	964165.0
2016-01-07	AAXN-DELISTED	Stock	17.23	17.49	16.5	16.59	1959609.0
2016-01-07	AB	Stock	22.55	22.73	22.23	22.45	414300.0
2016-01-07	ABAC-DELISTED	Stock	0.75	0.8724	0.75	0.8699	2250.0
2016-01-07	ABAX-DELISTED	Stock	53.97	54.79	52.82	53.11	115645.0
2016-01-07	ABB-DELISTED	Stock	16.65	16.785	16.565	16.61	2356384.0
2016-01-07	ABBNY-DELISTED	Stock	16.65	16.785	16.565	16.6	2422522.0
2016-01-07	ABBV	Stock	56.52	57.84	56.34	57.21	9292600.0
2016-01-07	ABC-DELISTED	Stock	100.87	101.15	98.49	98.53	3387148.0
2016-01-07	ABCB	Stock	31.7	32.17	31.43	31.54	366500.0
2016-01-07	ABCD-DELISTED	Stock	4.85	5.03	4.77	4.78	24976.0
2016-01-07	ABCO-DELISTED	Stock	46.23	47.32	45.96	46.41	166758.0
2016-01-07	ABCW-DELISTED	Stock	43.41	44.03	43.02	43.2	12631.0
2016-01-07	ABDC-DELISTED	Stock	11.86	11.8653	11.53	11.63	24439.0
2016-01-07	ABE-DELISTED	Stock	10.5	10.5	10.37	10.37	19648.0
2016-01-07	ABEO	Stock	79.25	80.5	73.0	73.25	7620.0
2016-01-07	ABEOW-DELISTED	Stock	1.05	1.13	1.05	1.065	1585.0
2016-01-07	ABEV	Stock	4.2	4.22	4.11	4.11	13126700.0
2016-01-07	ABG	Stock	56.15	57.74	55.58	55.62	491500.0
2016-01-07	ABGB-DELISTED	Stock	1.23	1.23	1.09	1.1	39766.0

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

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