PREVIEW / stock_daily / 2013-06-19

all stock daily files

  file:    by_date/stock_daily/2013/2013-06-19.parquet
  size:    209 KB
  rows:    6,334
  symbols: 3,527

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-06-19	AAPL	Stock	15.4071	15.4164	15.1071	15.1071	310940000.0
2013-06-19	MSFT	Stock	34.96	35.09	34.59	34.59	30816200.0
2013-06-19	NVDA	Stock	0.3632	0.387	0.362	0.371	1159588000.0
2013-06-19	AMZN	Stock	14.063	14.167	13.8935	13.908	56550000.0
2013-06-19	META	Stock	24.2	25.19	24.1	24.31	31790600.0
2013-06-19	TSLA	Stock	6.804	7.1113	6.8007	6.9787	128683500.0
2013-06-19	TLT	Stock	113.74	113.79	111.62	112.11	17141072.0
2013-06-19	ES	Stock	42.49	42.5	41.28	41.29	1129500.0
2013-06-19	CL	Stock	59.67	59.8	57.98	58.0	4256400.0
2013-06-19	A	Stock	32.0029	32.103	31.1159	31.1302	8116648.0
2013-06-19	AABA-DELISTED	Stock	26.61	26.78	26.23	26.23	11365544.0
2013-06-19	AACG	Stock	4.25	4.25	4.25	4.25	100.0
2013-06-19	AAIC-DELISTED	Stock	28.68	28.789	28.0957	28.12	205404.0
2013-06-19	AAMC-DELISTED	Stock	82.3235	82.3235	79.4118	79.4118	1530.0
2013-06-19	AAME	Stock	3.9	3.96	3.89	3.92	7500.0
2013-06-19	AAMRQ-DELISTED	Stock	4.7	4.75	4.6	4.64	1758156.0
2013-06-19	AAON	Stock	9.7926	9.8459	9.6681	9.6711	138713.0
2013-06-19	AAP	Stock	83.3	84.48	82.44	84.07	1079300.0
2013-06-19	AAT	Stock	32.24	32.31	31.07	31.1	54900.0
2013-06-19	AAU-DELISTED	Stock	1.58	1.6	1.53	1.53	42127.0
2013-06-19	AAUAF-DELISTED	Stock	1.58	1.6	1.52	1.52	42327.0
2013-06-19	AAV-DELISTED	Stock	4.26	4.35	4.26	4.29	98729.0
2013-06-19	AAWW-DELISTED	Stock	46.81	46.945	46.06	46.22	152791.0
2013-06-19	AAXJ	Stock	56.08	56.12	54.94	54.99	517298.0
2013-06-19	AAXN-DELISTED	Stock	9.4	9.4	9.11	9.2	468013.0
2013-06-19	AB	Stock	24.96	24.96	23.9	23.93	212700.0
2013-06-19	ABAC-DELISTED	Stock	0.72	0.77	0.67	0.7	56840.0
2013-06-19	ABAX-DELISTED	Stock	46.7401	46.96	45.59	45.96	96151.0
2013-06-19	ABB-DELISTED	Stock	22.69	22.75	22.19	22.23	1814450.0
2013-06-19	ABBNY-DELISTED	Stock	22.69	22.75	22.19	22.24	1871502.0
2013-06-19	ABBV	Stock	43.56	43.83	43.01	43.04	3663300.0
2013-06-19	ABC-DELISTED	Stock	55.78	56.39	55.39	55.55	2070031.0
2013-06-19	ABCB	Stock	16.39	16.42	16.14	16.17	11300.0
2013-06-19	ABCD-DELISTED	Stock	1.28	1.28	1.28	1.28	900.0
2013-06-19	ABCO-DELISTED	Stock	54.41	54.9	53.82	53.83	132148.0
2013-06-19	ABCW-DELISTED	Stock	0.53	0.56	0.53	0.56	1500.0
2013-06-19	ABE-DELISTED	Stock	20.05	20.06	19.9	19.9499	6003.0
2013-06-19	ABEO	Stock	625.0	625.0	625.0	625.0	33.0
2013-06-19	ABFS-DELISTED	Stock	19.63	19.8541	19.36	19.63	266684.0
2013-06-19	ABG	Stock	41.22	41.66	39.97	39.99	191700.0
2013-06-19	ABM	Stock	24.74	24.81	24.22	24.29	151200.0
2013-06-19	ABMD-DELISTED	Stock	22.0	22.47	21.85	22.08	350283.0
2013-06-19	ABR	Stock	6.52	6.67	6.42	6.47	178000.0
2013-06-19	ABR.A-DELISTED	Stock	24.85	24.949	24.61	24.8999	5715.0
2013-06-19	ABR.B-DELISTED	Stock	24.3	24.3	24.3	24.3	1500.0
2013-06-19	ABT	Stock	37.27	37.27	36.21	36.21	6741400.0
2013-06-19	ABTL-DELISTED	Stock	4.72	4.77	4.67	4.76	10288.0
2013-06-19	ABUS	Stock	4.75	4.78	4.68	4.76	22100.0
2013-06-19	ABV-DELISTED	Stock	35.94	36.25	34.67	34.91	3041895.0
2013-06-19	ABX-DELISTED	Stock	18.94	19.14	17.92	18.0	19624000.0

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

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