PREVIEW / stock_daily / 2013-07-29

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-29.parquet
  size:    211 KB
  rows:    6,348
  symbols: 3,515

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-29	AAPL	Stock	15.7429	16.0711	15.7214	15.9925	248057600.0
2013-07-29	MSFT	Stock	31.47	31.6	31.4	31.54	28870700.0
2013-07-29	NVDA	Stock	0.3542	0.3588	0.3533	0.3542	179540000.0
2013-07-29	AMZN	Stock	15.5535	15.65	15.295	15.305	64236000.0
2013-07-29	META	Stock	34.07	35.63	34.01	35.43	124718800.0
2013-07-29	TSLA	Stock	8.6213	9.0247	8.55	8.9747	145183500.0
2013-07-29	TLT	Stock	107.65	107.82	107.07	107.35	6397790.0
2013-07-29	ES	Stock	44.1	44.27	43.84	44.04	1712200.0
2013-07-29	CL	Stock	59.99	60.36	59.85	60.08	2992400.0
2013-07-29	A	Stock	32.6109	32.6896	32.1745	32.432	2743016.0
2013-07-29	AABA-DELISTED	Stock	27.95	28.33	27.8	27.93	10477448.0
2013-07-29	AACG	Stock	5.0	5.27	4.9	5.12	8100.0
2013-07-29	AAIC-DELISTED	Stock	25.85	25.85	25.171	25.44	120301.0
2013-07-29	AAMC-DELISTED	Stock	94.1176	98.5294	94.1176	95.8824	15575.0
2013-07-29	AAME	Stock	3.78	3.86	3.75	3.85	3500.0
2013-07-29	AAMRQ-DELISTED	Stock	5.72	5.78	5.64	5.75	5296157.0
2013-07-29	AAON	Stock	10.1867	10.2178	9.8933	9.9022	134325.0
2013-07-29	AAP	Stock	82.61	82.88	81.93	82.33	332100.0
2013-07-29	AAT	Stock	33.65	33.74	33.0	33.2	60900.0
2013-07-29	AAU-DELISTED	Stock	1.73	1.77	1.715	1.73	115048.0
2013-07-29	AAUAF-DELISTED	Stock	1.73	1.78	1.72	1.73	115266.0
2013-07-29	AAV-DELISTED	Stock	3.6	3.63	3.46	3.51	239934.0
2013-07-29	AAWW-DELISTED	Stock	44.52	44.87	44.26	44.59	141467.0
2013-07-29	AAXJ	Stock	56.46	56.5	56.23	56.32	651243.0
2013-07-29	AAXN-DELISTED	Stock	8.94	9.01	8.88	8.97	213688.0
2013-07-29	AB	Stock	22.22	22.45	21.88	22.15	185000.0
2013-07-29	ABAC-DELISTED	Stock	0.5909	0.61	0.5901	0.5901	1245.0
2013-07-29	ABAX-DELISTED	Stock	41.55	42.0799	40.44	40.865	245930.0
2013-07-29	ABB-DELISTED	Stock	22.04	22.11	21.92	21.98	884952.0
2013-07-29	ABBNY-DELISTED	Stock	22.04	22.11	21.92	21.96	897586.0
2013-07-29	ABBV	Stock	44.72	45.45	44.47	45.06	4326200.0
2013-07-29	ABC-DELISTED	Stock	58.37	58.78	58.17	58.39	1423464.0
2013-07-29	ABCB	Stock	19.21	19.37	19.0	19.07	39400.0
2013-07-29	ABCD-DELISTED	Stock	1.32	1.32	1.3	1.301	3600.0
2013-07-29	ABCO-DELISTED	Stock	56.38	57.13	56.03	56.75	82076.0
2013-07-29	ABCW-DELISTED	Stock	0.43	0.43	0.3501	0.37	75505.0
2013-07-29	ABE-DELISTED	Stock	20.19	20.19	20.011	20.07	20136.0
2013-07-29	ABEO	Stock	487.5	487.5	475.0	475.0	7.0
2013-07-29	ABFS-DELISTED	Stock	22.32	22.54	21.81	22.33	329396.0
2013-07-29	ABG	Stock	47.64	48.17	47.19	47.67	137300.0
2013-07-29	ABM	Stock	25.66	25.79	25.38	25.39	124500.0
2013-07-29	ABMD-DELISTED	Stock	24.54	24.87	24.45	24.66	181604.0
2013-07-29	ABR	Stock	7.6	7.71	7.58	7.69	164900.0
2013-07-29	ABR.A-DELISTED	Stock	25.38	25.38	25.37	25.37	1600.0
2013-07-29	ABR.B-DELISTED	Stock	24.4	24.42	24.3	24.3	600.0
2013-07-29	ABT	Stock	36.62	36.95	36.5	36.74	5587300.0
2013-07-29	ABTL-DELISTED	Stock	5.22	5.3	5.08	5.3	73052.0
2013-07-29	ABUS	Stock	5.19	5.22	5.1	5.17	21500.0
2013-07-29	ABV-DELISTED	Stock	36.21	36.5	35.86	35.91	1726654.0
2013-07-29	ABX-DELISTED	Stock	17.82	17.84	17.439	17.56	10990678.0

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

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