PREVIEW / stock_daily / 2016-07-29

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-29.parquet
  size:    220 KB
  rows:    6,572
  symbols: 3,267

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-07-29	AAPL	Stock	26.0475	26.1375	25.92	26.0525	110934800.0
2016-07-29	MSFT	Stock	56.26	56.76	56.05	56.68	30558700.0
2016-07-29	NVDA	Stock	1.4098	1.4313	1.3845	1.4275	409588000.0
2016-07-29	AMZN	Stock	38.25	38.3	37.75	37.9405	135542000.0
2016-07-29	GOOGL	Stock	39.8855	40.197	39.5	39.567	101810540.0
2016-07-29	META	Stock	124.65	125.84	123.71	123.94	35058800.0
2016-07-29	TSLA	Stock	15.38	15.6853	15.3493	15.6527	46062000.0
2016-07-29	TLT	Stock	140.45	141.68	140.22	141.56	8766743.0
2016-07-29	ES	Stock	58.15	58.69	58.02	58.49	1349600.0
2016-07-29	CL	Stock	73.12	74.97	73.07	74.43	4459800.0
2016-07-29	A	Stock	47.49	48.18	47.36	48.11	1881400.0
2016-07-29	AA.B-DELISTED	Stock	36.29	36.5599	35.91	36.4	26071.0
2016-07-29	AAAP-DELISTED	Stock	31.05	31.39	30.92	31.26	41929.0
2016-07-29	AABA-DELISTED	Stock	38.47	38.52	38.075	38.19	12642160.0
2016-07-29	AAC-DELISTED	Stock	22.59	23.02	22.36	22.63	58882.0
2016-07-29	AACG	Stock	3.71	3.8	3.71	3.79	6900.0
2016-07-29	AAIC-DELISTED	Stock	13.78	14.01	13.7	13.93	337364.0
2016-07-29	AAL	Stock	36.26	36.74	35.5	35.5	9138600.0
2016-07-29	AAMC-DELISTED	Stock	3.8206	3.9191	3.7588	3.7824	61720.0
2016-07-29	AAME	Stock	4.1	4.22	4.1	4.22	600.0
2016-07-29	AAMI	Stock	13.99	14.1	13.88	14.0	118500.0
2016-07-29	AAOI	Stock	12.23	12.28	11.77	11.84	303200.0
2016-07-29	AAON	Stock	17.7267	17.8067	17.5867	17.6533	181500.0
2016-07-29	AAP	Stock	170.0	170.29	168.5	169.86	1369200.0
2016-07-29	AAT	Stock	45.0	46.01	45.0	45.88	277600.0
2016-07-29	AAU-DELISTED	Stock	1.5	1.52	1.41	1.5025	317590.0
2016-07-29	AAUAF-DELISTED	Stock	1.5	1.52	1.41	1.51	321795.0
2016-07-29	AAV-DELISTED	Stock	6.25	6.36	6.21	6.35	50229.0
2016-07-29	AAWW-DELISTED	Stock	42.23	43.38	41.87	43.22	168979.0
2016-07-29	AAXJ	Stock	57.41	57.705	57.245	57.64	1096817.0
2016-07-29	AAXN-DELISTED	Stock	28.6	29.0799	28.0531	28.97	1057048.0
2016-07-29	AB	Stock	23.84	24.4	23.65	23.96	225200.0
2016-07-29	ABAC-DELISTED	Stock	0.69	0.7499	0.6606	0.729	35027.0
2016-07-29	ABAX-DELISTED	Stock	49.75	50.24	49.39	49.47	155114.0
2016-07-29	ABB-DELISTED	Stock	21.24	21.38	21.165	21.24	1600273.0
2016-07-29	ABBNY-DELISTED	Stock	21.24	21.38	21.165	21.25	1697206.0
2016-07-29	ABBV	Stock	65.27	66.4	65.15	66.23	10525000.0
2016-07-29	ABC-DELISTED	Stock	84.34	85.375	84.12	85.19	1728537.0
2016-07-29	ABCB	Stock	33.41	33.61	33.13	33.16	190400.0
2016-07-29	ABCD-DELISTED	Stock	4.97	4.97	4.82	4.84	31795.0
2016-07-29	ABCO-DELISTED	Stock	41.26	41.99	40.08	41.78	528070.0
2016-07-29	ABDC-DELISTED	Stock	12.1	12.37	12.1	12.24	27543.0
2016-07-29	ABE-DELISTED	Stock	12.65	12.65	12.56	12.64	3135.0
2016-07-29	ABEO	Stock	64.75	67.75	63.5	67.25	2160.0
2016-07-29	ABEV	Stock	5.83	5.84	5.73	5.78	33967800.0
2016-07-29	ABG	Stock	58.97	61.4	58.97	60.8	404500.0
2016-07-29	ABIL-DELISTED	Stock	4.69	4.77	4.65	4.7401	62809.0
2016-07-29	ABM	Stock	37.23	37.37	36.95	37.21	224200.0
2016-07-29	ABMD-DELISTED	Stock	115.24	119.93	115.24	117.98	758922.0
2016-07-29	ABR	Stock	7.15	7.25	7.11	7.15	83300.0

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

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