PREVIEW / stock_daily / 2013-08-16

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-16.parquet
  size:    212 KB
  rows:    6,365
  symbols: 3,517

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-16	AAPL	Stock	17.8625	17.9621	17.8164	17.9404	362306000.0
2013-08-16	MSFT	Stock	31.79	31.99	31.66	31.8	32866300.0
2013-08-16	NVDA	Stock	0.3775	0.385	0.3768	0.3798	660456000.0
2013-08-16	AMZN	Stock	14.3275	14.4165	14.225	14.241	48450000.0
2013-08-16	META	Stock	36.97	37.49	36.9	37.08	45840800.0
2013-08-16	TSLA	Stock	9.442	9.594	9.398	9.4667	106621500.0
2013-08-16	TLT	Stock	103.96	103.9701	102.67	103.37	10176453.0
2013-08-16	ES	Stock	41.77	41.83	41.18	41.3	2387200.0
2013-08-16	CL	Stock	59.52	59.67	59.12	59.47	3130100.0
2013-08-16	A	Stock	33.4835	33.7768	33.2761	33.4692	5067331.0
2013-08-16	AABA-DELISTED	Stock	27.0	27.6	27.0	27.33	14205073.0
2013-08-16	AACG	Stock	5.06	5.11	5.01	5.01	10100.0
2013-08-16	AAIC-DELISTED	Stock	24.42	24.55	24.09	24.15	145775.0
2013-08-16	AAMC-DELISTED	Stock	97.0588	97.0588	96.7647	97.0588	37301.0
2013-08-16	AAMRQ-DELISTED	Stock	2.555	2.77	2.5	2.74	13256132.0
2013-08-16	AAON	Stock	10.9689	11.1911	10.9022	10.9244	295200.0
2013-08-16	AAP	Stock	81.66	81.86	80.72	80.8	640900.0
2013-08-16	AAT	Stock	31.03	31.15	30.23	30.25	266000.0
2013-08-16	AAU-DELISTED	Stock	2.1	2.1	1.94	1.96	173487.0
2013-08-16	AAUAF-DELISTED	Stock	2.1	2.1	1.94	1.96	175391.0
2013-08-16	AAV-DELISTED	Stock	3.72	3.86	3.71	3.76	122735.0
2013-08-16	AAWW-DELISTED	Stock	43.92	44.26	43.51	44.06	216814.0
2013-08-16	AAXJ	Stock	56.69	56.7	56.2	56.24	647151.0
2013-08-16	AAXN-DELISTED	Stock	9.89	10.46	9.89	10.22	2014137.0
2013-08-16	AB	Stock	20.0	20.28	19.86	20.14	309600.0
2013-08-16	ABAC-DELISTED	Stock	0.69	0.73	0.68	0.72	50715.0
2013-08-16	ABAX-DELISTED	Stock	39.33	39.49	38.72	39.17	102635.0
2013-08-16	ABB-DELISTED	Stock	22.53	22.63	22.435	22.52	568278.0
2013-08-16	ABBNY-DELISTED	Stock	22.53	22.63	22.435	22.51	607577.0
2013-08-16	ABBV	Stock	42.94	43.14	42.42	43.0	6093300.0
2013-08-16	ABC-DELISTED	Stock	57.0	57.19	56.53	56.54	2221257.0
2013-08-16	ABCB	Stock	18.59	18.98	18.58	18.72	99300.0
2013-08-16	ABCD-DELISTED	Stock	1.49	1.54	1.43	1.4798	20031.0
2013-08-16	ABCO-DELISTED	Stock	55.27	56.16	55.03	56.0	119678.0
2013-08-16	ABE-DELISTED	Stock	19.85	19.85	19.52	19.66	3700.0
2013-08-16	ABEO	Stock	487.5	487.5	462.5	462.5	23.0
2013-08-16	ABFS-DELISTED	Stock	22.83	23.68	22.69	23.12	298017.0
2013-08-16	ABG	Stock	49.19	50.22	48.94	49.37	277900.0
2013-08-16	ABM	Stock	25.0	25.28	24.89	25.17	103600.0
2013-08-16	ABMD-DELISTED	Stock	22.54	22.65	22.38	22.45	344280.0
2013-08-16	ABR	Stock	7.28	7.28	7.11	7.15	84700.0
2013-08-16	ABR.A-DELISTED	Stock	24.52	24.52	24.16	24.477	11218.0
2013-08-16	ABR.B-DELISTED	Stock	23.3799	23.3799	22.63	22.85	3925.0
2013-08-16	ABT	Stock	34.92	35.0	34.55	34.97	10522400.0
2013-08-16	ABTL-DELISTED	Stock	6.53	6.539	6.22	6.35	20541.0
2013-08-16	ABUS	Stock	5.19	5.34	5.19	5.19	16600.0
2013-08-16	ABV-DELISTED	Stock	36.84	37.155	36.575	36.63	2474059.0
2013-08-16	ABX-DELISTED	Stock	20.01	20.25	19.1	19.32	22363385.0
2013-08-16	ACAD	Stock	19.53	20.25	19.27	19.7	1488900.0
2013-08-16	ACAS-DELISTED	Stock	12.94	13.02	12.85	12.85	2547060.0

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

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