PREVIEW / stock_daily / 2013-09-05

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-05.parquet
  size:    212 KB
  rows:    6,366
  symbols: 3,514

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-09-05	AAPL	Stock	17.8661	17.8814	17.63	17.6882	236367600.0
2013-09-05	MSFT	Stock	31.1	31.44	30.95	31.23	71644900.0
2013-09-05	NVDA	Stock	0.371	0.375	0.3708	0.3735	174904000.0
2013-09-05	AMZN	Stock	14.6815	14.85	14.6355	14.705	36332000.0
2013-09-05	META	Stock	41.79	42.77	41.77	42.66	50035400.0
2013-09-05	TSLA	Stock	11.34	11.4333	11.2167	11.3287	100279500.0
2013-09-05	TLT	Stock	103.47	103.6	102.53	102.54	12290993.0
2013-09-05	ES	Stock	40.44	40.62	40.13	40.26	1301700.0
2013-09-05	CL	Stock	57.68	57.78	57.36	57.53	2758900.0
2013-09-05	A	Stock	34.206	34.3991	34.0343	34.1059	1835854.0
2013-09-05	AABA-DELISTED	Stock	28.1	28.35	27.91	28.23	8822668.0
2013-09-05	AACG	Stock	4.75	5.1	4.53	4.53	1200.0
2013-09-05	AAIC-DELISTED	Stock	23.33	23.4899	23.26	23.29	74316.0
2013-09-05	AAME	Stock	3.94	3.94	3.81	3.89	5300.0
2013-09-05	AAMRQ-DELISTED	Stock	3.47	3.48	3.18	3.4	9379073.0
2013-09-05	AAON	Stock	10.8667	10.9511	10.7956	10.8356	114300.0
2013-09-05	AAP	Stock	79.71	80.49	79.71	80.04	296300.0
2013-09-05	AAT	Stock	29.54	29.65	28.65	28.99	156300.0
2013-09-05	AAU-DELISTED	Stock	1.71	1.7696	1.66	1.66	47227.0
2013-09-05	AAUAF-DELISTED	Stock	1.71	1.7696	1.66	1.66	47427.0
2013-09-05	AAV-DELISTED	Stock	3.68	3.74	3.68	3.68	51980.0
2013-09-05	AAWW-DELISTED	Stock	47.33	47.5	46.57	46.62	204456.0
2013-09-05	AAXJ	Stock	56.16	56.73	56.16	56.6	235093.0
2013-09-05	AAXN-DELISTED	Stock	12.33	12.53	12.24	12.25	1065072.0
2013-09-05	AB	Stock	20.07	20.25	19.83	19.96	270700.0
2013-09-05	ABAC-DELISTED	Stock	0.9	0.9	0.78	0.79	74481.0
2013-09-05	ABAX-DELISTED	Stock	40.21	40.98	40.13	40.325	101880.0
2013-09-05	ABB-DELISTED	Stock	21.95	22.09	21.88	21.97	1287943.0
2013-09-05	ABBNY-DELISTED	Stock	21.95	22.09	21.88	21.99	1297091.0
2013-09-05	ABBV	Stock	43.03	43.66	43.0	43.51	3355500.0
2013-09-05	ABC-DELISTED	Stock	58.0	58.33	57.88	58.13	856321.0
2013-09-05	ABCB	Stock	19.08	19.49	18.61	19.21	27000.0
2013-09-05	ABCD-DELISTED	Stock	1.52	1.59	1.48	1.5	3706.0
2013-09-05	ABCO-DELISTED	Stock	56.65	56.91	56.24	56.59	201926.0
2013-09-05	ABE-DELISTED	Stock	18.63	18.65	18.331	18.42	13290.0
2013-09-05	ABEO	Stock	462.5	487.5	437.5	487.5	19.0
2013-09-05	ABFS-DELISTED	Stock	25.78	26.1396	25.45	25.78	293488.0
2013-09-05	ABG	Stock	50.52	52.13	50.5	51.67	267200.0
2013-09-05	ABM	Stock	25.64	25.78	25.44	25.6	155800.0
2013-09-05	ABMD-DELISTED	Stock	24.05	24.285	23.886	24.0	186277.0
2013-09-05	ABR	Stock	7.02	7.04	6.92	6.96	66300.0
2013-09-05	ABR.A-DELISTED	Stock	24.4	24.5999	24.24	24.5999	1561.0
2013-09-05	ABT	Stock	33.5	33.75	33.49	33.74	6317400.0
2013-09-05	ABTL-DELISTED	Stock	6.42	6.87	6.35	6.78	99050.0
2013-09-05	ABUS	Stock	5.61	5.63	5.54	5.6	36300.0
2013-09-05	ABV-DELISTED	Stock	34.4	35.23	34.22	35.19	2856778.0
2013-09-05	ABX-DELISTED	Stock	19.27	19.35	18.84	18.92	13819299.0
2013-09-05	ACAD	Stock	20.47	21.36	20.4	21.2	2181200.0
2013-09-05	ACAS-DELISTED	Stock	12.78	12.98	12.78	12.9	2401508.0
2013-09-05	ACAT-DELISTED	Stock	53.76	54.94	53.76	54.42	50608.0

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

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