PREVIEW / stock_daily / 2016-08-12

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-12.parquet
  size:    218 KB
  rows:    6,523
  symbols: 3,228

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-08-12	AAPL	Stock	26.945	27.11	26.945	27.045	74641600.0
2016-08-12	MSFT	Stock	58.03	58.19	57.62	57.94	21655200.0
2016-08-12	NVDA	Stock	1.5475	1.5845	1.5158	1.576	1425744000.0
2016-08-12	AMZN	Stock	38.423	38.6575	38.421	38.628	31266000.0
2016-08-12	GOOGL	Stock	40.2545	40.3595	40.182	40.3525	17945660.0
2016-08-12	META	Stock	124.7	125.0	124.18	124.88	12159000.0
2016-08-12	TSLA	Stock	15.0273	15.11	14.936	15.0407	27202500.0
2016-08-12	TLT	Stock	140.41	140.86	139.87	140.08	7989640.0
2016-08-12	ES	Stock	57.32	57.62	57.13	57.25	650400.0
2016-08-12	CL	Stock	75.0	75.38	74.84	74.97	1658300.0
2016-08-12	A	Stock	47.97	48.2	47.7	48.14	1538600.0
2016-08-12	AA.B-DELISTED	Stock	35.98	35.98	34.92	35.21	34026.0
2016-08-12	AAAP-DELISTED	Stock	31.86	32.2	31.54	32.06	14974.0
2016-08-12	AABA-DELISTED	Stock	41.28	42.98	41.28	42.93	23694336.0
2016-08-12	AAC-DELISTED	Stock	17.4	17.56	17.05	17.35	75854.0
2016-08-12	AACG	Stock	4.03	4.1	3.9	4.1	1500.0
2016-08-12	AAIC-DELISTED	Stock	14.78	14.83	14.7	14.7	176041.0
2016-08-12	AAL	Stock	34.74	35.17	34.66	34.92	6063900.0
2016-08-12	AAMC-DELISTED	Stock	3.8676	4.0588	3.8238	3.9118	30447.0
2016-08-12	AAMI	Stock	13.59	13.74	13.42	13.48	53900.0
2016-08-12	AAOI	Stock	13.58	14.05	13.43	14.01	493800.0
2016-08-12	AAON	Stock	18.2867	18.2867	18.04	18.1467	76800.0
2016-08-12	AAP	Stock	166.09	166.5	163.49	166.0	1165200.0
2016-08-12	AAT	Stock	45.53	46.02	45.34	45.41	91600.0
2016-08-12	AAU-DELISTED	Stock	1.73	1.74	1.62	1.64	380185.0
2016-08-12	AAUAF-DELISTED	Stock	1.73	1.74	1.62	1.65	385318.0
2016-08-12	AAV-DELISTED	Stock	6.79	6.92	6.78	6.86	117767.0
2016-08-12	AAWW-DELISTED	Stock	35.29	35.47	34.44	34.65	342422.0
2016-08-12	AAXJ	Stock	59.33	59.46	59.22	59.43	1214073.0
2016-08-12	AAXN-DELISTED	Stock	29.0	29.35	28.85	29.13	461559.0
2016-08-12	AB	Stock	21.45	22.02	21.39	21.93	244200.0
2016-08-12	ABAC-DELISTED	Stock	0.6836	0.88	0.6836	0.8743	143478.0
2016-08-12	ABAX-DELISTED	Stock	49.74	49.95	49.239	49.65	51311.0
2016-08-12	ABB-DELISTED	Stock	22.12	22.15	22.02	22.07	1030465.0
2016-08-12	ABBNY-DELISTED	Stock	22.12	22.15	22.02	22.07	1067928.0
2016-08-12	ABBV	Stock	66.86	67.39	66.55	67.19	5215400.0
2016-08-12	ABC-DELISTED	Stock	89.14	89.19	88.33	88.89	1129232.0
2016-08-12	ABCB	Stock	33.24	33.28	32.99	33.25	69000.0
2016-08-12	ABCD-DELISTED	Stock	4.63	4.9292	4.63	4.81	13972.0
2016-08-12	ABCO-DELISTED	Stock	41.56	41.6	40.91	41.49	130000.0
2016-08-12	ABDC-DELISTED	Stock	12.27	12.41	12.27	12.36	14205.0
2016-08-12	ABE-DELISTED	Stock	12.77	12.78	12.74	12.78	2790.0
2016-08-12	ABEO	Stock	88.75	90.75	88.0	89.5	1648.0
2016-08-12	ABEOW-DELISTED	Stock	1.7	1.7	1.47	1.54	700.0
2016-08-12	ABEV	Stock	6.18	6.27	6.17	6.2	17504600.0
2016-08-12	ABG	Stock	56.59	56.89	55.54	55.86	144600.0
2016-08-12	ABIL-DELISTED	Stock	5.26	5.26	4.64	4.88	71251.0
2016-08-12	ABM	Stock	38.0	38.0	37.47	37.73	115700.0
2016-08-12	ABMD-DELISTED	Stock	123.81	123.96	122.24	123.72	163351.0
2016-08-12	ABR	Stock	7.3	7.35	7.28	7.3	218700.0

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

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