PREVIEW / stock_daily / 2013-07-26

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-26.parquet
  size:    212 KB
  rows:    6,362
  symbols: 3,525

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-26	AAPL	Stock	15.5464	15.7514	15.5121	15.7496	200152400.0
2013-07-26	MSFT	Stock	31.26	31.62	31.21	31.62	38633600.0
2013-07-26	NVDA	Stock	0.3522	0.3572	0.3522	0.355	227360000.0
2013-07-26	AMZN	Stock	14.9775	15.681	14.7775	15.6005	176350000.0
2013-07-26	META	Stock	33.77	34.73	33.56	34.01	136028900.0
2013-07-26	TSLA	Stock	8.5427	8.712	8.4407	8.626	144496500.0
2013-07-26	TLT	Stock	108.04	108.28	107.64	108.14	6795438.0
2013-07-26	ES	Stock	44.21	44.45	43.83	44.23	1884700.0
2013-07-26	CL	Stock	59.46	60.26	59.15	60.25	4022400.0
2013-07-26	A	Stock	33.1259	33.3047	32.4964	32.618	5161835.0
2013-07-26	AABA-DELISTED	Stock	28.0	28.3399	27.741	28.12	11821112.0
2013-07-26	AACG	Stock	4.93	5.09	4.75	4.88	11000.0
2013-07-26	AAIC-DELISTED	Stock	25.74	25.88	25.5	25.86	83442.0
2013-07-26	AAME	Stock	3.72	3.79	3.72	3.79	600.0
2013-07-26	AAMRQ-DELISTED	Stock	5.74	5.82	5.62	5.72	5950927.0
2013-07-26	AAON	Stock	10.1911	10.2622	10.1244	10.1911	158850.0
2013-07-26	AAP	Stock	82.93	83.43	82.38	82.64	620100.0
2013-07-26	AAT	Stock	33.42	33.71	33.24	33.66	61600.0
2013-07-26	AAU-DELISTED	Stock	1.7	1.73	1.64	1.69	47406.0
2013-07-26	AAUAF-DELISTED	Stock	1.72	1.75	1.66	1.69	47054.0
2013-07-26	AAV-DELISTED	Stock	3.76	3.78	3.6	3.62	358937.0
2013-07-26	AAWW-DELISTED	Stock	44.39	44.87	44.32	44.61	150699.0
2013-07-26	AAXJ	Stock	56.65	57.04	56.4	57.01	92399.0
2013-07-26	AAXN-DELISTED	Stock	8.76	8.99	8.75	8.94	249672.0
2013-07-26	AB	Stock	22.27	22.41	22.0	22.22	137900.0
2013-07-26	ABAC-DELISTED	Stock	0.6099	0.6099	0.5902	0.6098	4150.0
2013-07-26	ABAX-DELISTED	Stock	39.88	42.48	39.75	41.47	1065561.0
2013-07-26	ABB-DELISTED	Stock	22.09	22.18	21.97	22.15	1178300.0
2013-07-26	ABBNY-DELISTED	Stock	22.1	22.18	21.97	22.14	1199303.0
2013-07-26	ABBV	Stock	45.01	45.12	44.17	44.79	4491100.0
2013-07-26	ABC-DELISTED	Stock	57.28	58.58	57.28	58.48	1695490.0
2013-07-26	ABCB	Stock	19.58	19.63	19.18	19.29	37300.0
2013-07-26	ABCD-DELISTED	Stock	1.2945	1.31	1.2945	1.31	1350.0
2013-07-26	ABCO-DELISTED	Stock	57.23	57.38	56.26	56.46	66049.0
2013-07-26	ABCW-DELISTED	Stock	0.41	0.43	0.37	0.37	76568.0
2013-07-26	ABE-DELISTED	Stock	20.15	20.449	20.06	20.32	14586.0
2013-07-26	ABEO	Stock	575.0	575.0	487.5	500.0	6.0
2013-07-26	ABFS-DELISTED	Stock	21.81	22.83	21.48	22.535	532983.0
2013-07-26	ABG	Stock	46.79	47.79	46.73	47.76	277300.0
2013-07-26	ABM	Stock	25.9	26.13	25.6	25.76	128500.0
2013-07-26	ABMD-DELISTED	Stock	24.3	24.63	24.0	24.44	291521.0
2013-07-26	ABR	Stock	7.7	7.7	7.58	7.65	106400.0
2013-07-26	ABR.A-DELISTED	Stock	25.32	25.35	25.1	25.35	6135.0
2013-07-26	ABT	Stock	36.59	36.85	36.15	36.78	5387400.0
2013-07-26	ABTL-DELISTED	Stock	5.36	5.36	5.24	5.28	16373.0
2013-07-26	ABUS	Stock	5.19	5.28	5.13	5.25	49400.0
2013-07-26	ABV-DELISTED	Stock	36.22	36.515	35.815	36.35	1459446.0
2013-07-26	ABX-DELISTED	Stock	17.36	17.82	17.17	17.82	13228384.0
2013-07-26	ACAD	Stock	18.94	19.06	18.5	18.63	1128100.0
2013-07-26	ACAS-DELISTED	Stock	13.6	13.63	13.49	13.57	1193757.0

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

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