PREVIEW / stock_daily / 2013-08-29

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-29.parquet
  size:    211 KB
  rows:    6,364
  symbols: 3,529

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-08-29	AAPL	Stock	17.5589	17.7321	17.5404	17.5607	239657600.0
2013-08-29	MSFT	Stock	32.93	33.6	32.8	33.55	45284700.0
2013-08-29	NVDA	Stock	0.3688	0.3728	0.3678	0.3692	276216000.0
2013-08-29	AMZN	Stock	14.0725	14.299	14.0	14.199	31328000.0
2013-08-29	META	Stock	40.89	41.78	40.8	41.28	58303400.0
2013-08-29	TSLA	Stock	10.948	11.1833	10.834	11.0707	141540000.0
2013-08-29	TLT	Stock	104.88	106.309	104.79	106.11	6672433.0
2013-08-29	ES	Stock	41.01	41.23	40.83	40.97	1426500.0
2013-08-29	CL	Stock	57.09	57.56	56.94	57.25	2627300.0
2013-08-29	A	Stock	33.3548	33.6409	33.2046	33.4764	2657179.0
2013-08-29	AABA-DELISTED	Stock	27.03	27.45	27.03	27.3	13481635.0
2013-08-29	AACG	Stock	5.1	5.1	5.01	5.01	600.0
2013-08-29	AAIC-DELISTED	Stock	23.13	23.73	23.13	23.65	94167.0
2013-08-29	AAME	Stock	3.75	3.93	3.75	3.93	900.0
2013-08-29	AAMRQ-DELISTED	Stock	3.19	3.39	3.1	3.39	17123926.0
2013-08-29	AAON	Stock	10.4711	10.68	10.3778	10.6444	109800.0
2013-08-29	AAP	Stock	81.0	81.59	80.68	81.26	403100.0
2013-08-29	AAT	Stock	29.52	30.01	29.24	29.79	141000.0
2013-08-29	AAU-DELISTED	Stock	1.76	1.7749	1.71	1.76	72982.0
2013-08-29	AAUAF-DELISTED	Stock	1.76	1.78	1.71	1.75	72891.0
2013-08-29	AAV-DELISTED	Stock	3.74	3.78	3.72	3.72	107747.0
2013-08-29	AAWW-DELISTED	Stock	47.5	47.91	46.85	47.0	264181.0
2013-08-29	AAXJ	Stock	54.2	54.66	54.17	54.26	574131.0
2013-08-29	AAXN-DELISTED	Stock	11.09	12.1	11.06	11.92	2701647.0
2013-08-29	AB	Stock	19.52	19.89	19.39	19.71	395100.0
2013-08-29	ABAC-DELISTED	Stock	0.8	0.828	0.6516	0.828	105770.0
2013-08-29	ABAX-DELISTED	Stock	39.55	39.7944	38.97	39.17	179357.0
2013-08-29	ABB-DELISTED	Stock	21.51	21.66	21.5	21.59	2185498.0
2013-08-29	ABBNY-DELISTED	Stock	21.51	21.66	21.5	21.61	2296579.0
2013-08-29	ABBV	Stock	42.32	43.09	42.26	42.62	2788900.0
2013-08-29	ABC-DELISTED	Stock	56.93	57.33	56.66	57.14	748603.0
2013-08-29	ABCB	Stock	19.52	19.84	19.4	19.55	48600.0
2013-08-29	ABCD-DELISTED	Stock	1.74	1.74	1.7387	1.7387	200.0
2013-08-29	ABCO-DELISTED	Stock	56.94	57.65	56.75	56.93	67148.0
2013-08-29	ABE-DELISTED	Stock	18.47	18.54	18.18	18.232	22120.0
2013-08-29	ABEO	Stock	425.0	425.0	412.5	425.0	17.0
2013-08-29	ABFS-DELISTED	Stock	26.51	27.4	26.51	26.59	419112.0
2013-08-29	ABG	Stock	48.86	50.13	48.86	49.59	103800.0
2013-08-29	ABM	Stock	24.57	25.04	24.57	24.81	87000.0
2013-08-29	ABMD-DELISTED	Stock	22.61	23.735	22.61	23.63	308619.0
2013-08-29	ABR	Stock	6.9	7.03	6.9	7.02	38400.0
2013-08-29	ABR.A-DELISTED	Stock	24.4	24.5299	24.4	24.5299	300.0
2013-08-29	ABR.B-DELISTED	Stock	23.34	23.79	23.34	23.79	700.0
2013-08-29	ABT	Stock	33.63	34.13	33.52	33.73	5676100.0
2013-08-29	ABTL-DELISTED	Stock	5.9	5.95	5.85	5.92	20659.0
2013-08-29	ABUS	Stock	5.14	5.26	5.08	5.19	100100.0
2013-08-29	ABV-DELISTED	Stock	34.34	35.31	34.28	34.99	2354403.0
2013-08-29	ABX-DELISTED	Stock	19.21	19.888	18.87	19.69	17135246.0
2013-08-29	ACAD	Stock	20.1	20.75	20.1	20.47	980600.0
2013-08-29	ACAS-DELISTED	Stock	12.595	12.8	12.59	12.63	1572662.0

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

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