PREVIEW / stock_daily / 2013-07-01

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-01.parquet
  size:    209 KB
  rows:    6,325
  symbols: 3,510

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
2013-07-01	AAPL	Stock	14.3818	14.7239	14.3293	14.615	391053600.0
2013-07-01	MSFT	Stock	34.75	34.99	34.33	34.36	31055400.0
2013-07-01	NVDA	Stock	0.3535	0.3542	0.3502	0.3525	199524000.0
2013-07-01	AMZN	Stock	13.95	14.1645	13.858	14.105	57764000.0
2013-07-01	META	Stock	24.97	25.06	24.62	24.81	20582200.0
2013-07-01	TSLA	Stock	7.2907	7.8513	7.2767	7.812	163554000.0
2013-07-01	TLT	Stock	109.73	110.5	109.43	110.41	5500732.0
2013-07-01	ES	Stock	42.17	42.37	41.13	41.25	2234200.0
2013-07-01	CL	Stock	57.6	58.66	57.58	57.95	3727600.0
2013-07-01	A	Stock	30.794	31.309	30.6938	31.1803	5988473.0
2013-07-01	AABA-DELISTED	Stock	25.26	25.535	25.18	25.25	10577221.0
2013-07-01	AACG	Stock	4.38	4.77	4.38	4.72	17900.0
2013-07-01	AAIC-DELISTED	Stock	27.01	27.2	26.756	27.03	140640.0
2013-07-01	AAMC-DELISTED	Stock	80.8824	80.8824	80.8824	80.8824	5076.0
2013-07-01	AAME	Stock	3.87	3.9	3.8	3.82	3200.0
2013-07-01	AAMRQ-DELISTED	Stock	4.05	4.45	4.05	4.43	5586925.0
2013-07-01	AAON	Stock	9.8815	10.1185	9.7985	10.0681	210263.0
2013-07-01	AAP	Stock	81.72	82.7	81.46	81.89	721300.0
2013-07-01	AAT	Stock	31.12	31.53	30.94	31.47	192300.0
2013-07-01	AAU-DELISTED	Stock	1.43	1.53	1.41	1.5191	163577.0
2013-07-01	AAUAF-DELISTED	Stock	1.43	1.53	1.41	1.52	164227.0
2013-07-01	AAV-DELISTED	Stock	3.93	4.03	3.91	3.94	107460.0
2013-07-01	AAWW-DELISTED	Stock	43.31	43.88	42.5	43.5	378436.0
2013-07-01	AAXJ	Stock	55.18	55.23	54.73	54.83	455709.0
2013-07-01	AAXN-DELISTED	Stock	8.58	8.9	8.546	8.84	403548.0
2013-07-01	AB	Stock	20.84	21.33	20.26	20.52	597500.0
2013-07-01	ABAC-DELISTED	Stock	0.6098	0.699	0.6098	0.68	61580.0
2013-07-01	ABAX-DELISTED	Stock	47.62	48.57	47.3575	48.39	73473.0
2013-07-01	ABB-DELISTED	Stock	21.74	21.94	21.72	21.86	1116894.0
2013-07-01	ABBNY-DELISTED	Stock	21.74	21.94	21.72	21.86	1132120.0
2013-07-01	ABBV	Stock	41.4	41.93	41.07	41.61	4588200.0
2013-07-01	ABC-DELISTED	Stock	56.11	56.23	54.97	55.02	2810048.0
2013-07-01	ABCB	Stock	16.85	17.4	16.77	17.35	94200.0
2013-07-01	ABCD-DELISTED	Stock	1.221	1.2407	1.21	1.2407	1660.0
2013-07-01	ABCO-DELISTED	Stock	55.17	55.27	54.68	54.75	113090.0
2013-07-01	ABCW-DELISTED	Stock	0.58	0.58	0.55	0.55	12021.0
2013-07-01	ABE-DELISTED	Stock	19.57	19.7899	19.57	19.77	3086.0
2013-07-01	ABEO	Stock	600.0	600.0	600.0	600.0	3.0
2013-07-01	ABFS-DELISTED	Stock	23.11	23.62	22.01	22.52	765121.0
2013-07-01	ABG	Stock	40.47	41.21	40.2	40.55	232300.0
2013-07-01	ABM	Stock	24.6	24.83	24.57	24.73	212900.0
2013-07-01	ABMD-DELISTED	Stock	21.64	22.46	21.62	22.27	242896.0
2013-07-01	ABR	Stock	6.33	6.46	6.33	6.4	94000.0
2013-07-01	ABR.A-DELISTED	Stock	25.0	25.179	24.9999	25.0	2835.0
2013-07-01	ABR.B-DELISTED	Stock	24.29	24.3	24.29	24.3	1175.0
2013-07-01	ABT	Stock	34.97	35.47	34.9	35.03	6346900.0
2013-07-01	ABTL-DELISTED	Stock	4.76	4.79	4.66	4.72	9136.0
2013-07-01	ABUS	Stock	4.91	5.0	4.7	4.93	119900.0
2013-07-01	ABV-DELISTED	Stock	37.6	37.87	37.39	37.58	3969236.0
2013-07-01	ABX-DELISTED	Stock	15.89	16.15	15.08	15.24	29284239.0

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

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