PREVIEW / stock_daily / 2013-06-27

all stock daily files

  file:    by_date/stock_daily/2013/2013-06-27.parquet
  size:    209 KB
  rows:    6,357
  symbols: 3,530

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-27	AAPL	Stock	14.2589	14.3354	14.055	14.0636	337246000.0
2013-06-27	MSFT	Stock	34.52	34.78	34.5	34.62	28993100.0
2013-06-27	NVDA	Stock	0.3545	0.355	0.3465	0.3502	808036000.0
2013-06-27	AMZN	Stock	13.959	14.01	13.727	13.8775	50390000.0
2013-06-27	META	Stock	24.24	24.84	24.21	24.66	34694100.0
2013-06-27	TSLA	Stock	7.1167	7.35	7.0753	7.2833	131173500.0
2013-06-27	TLT	Stock	109.54	109.97	108.95	109.69	12026600.0
2013-06-27	ES	Stock	41.5	42.26	41.45	41.74	1837000.0
2013-06-27	CL	Stock	57.51	57.83	57.14	57.39	2983100.0
2013-06-27	A	Stock	30.4435	30.9657	30.4149	30.8155	4816250.0
2013-06-27	AABA-DELISTED	Stock	25.47	25.975	25.44	25.47	14269430.0
2013-06-27	AACG	Stock	4.27	4.31	4.27	4.31	2200.0
2013-06-27	AAIC-DELISTED	Stock	25.82	26.41	25.58	26.38	171532.0
2013-06-27	AAMC-DELISTED	Stock	77.9412	78.0882	76.7647	77.0588	54594.0
2013-06-27	AAME	Stock	3.9	3.9	3.88	3.89	2600.0
2013-06-27	AAMRQ-DELISTED	Stock	3.98	4.04	3.76	3.99	2466884.0
2013-06-27	AAON	Stock	9.6119	9.9259	9.5615	9.8607	218363.0
2013-06-27	AAP	Stock	80.22	80.75	79.86	80.02	672900.0
2013-06-27	AAT	Stock	30.29	31.12	30.15	31.11	117800.0
2013-06-27	AAU-DELISTED	Stock	1.16	1.28	1.16	1.26	266906.0
2013-06-27	AAUAF-DELISTED	Stock	1.16	1.28	1.16	1.26	267406.0
2013-06-27	AAV-DELISTED	Stock	3.97	4.0	3.87	3.88	108955.0
2013-06-27	AAWW-DELISTED	Stock	44.0	44.565	43.555	44.0	237185.0
2013-06-27	AAXJ	Stock	54.05	54.59	54.05	54.45	381333.0
2013-06-27	AAXN-DELISTED	Stock	8.62	8.73	8.59	8.64	373270.0
2013-06-27	AB	Stock	21.4	21.84	21.22	21.7	422100.0
2013-06-27	ABAC-DELISTED	Stock	0.57	0.575	0.55	0.575	47850.0
2013-06-27	ABAX-DELISTED	Stock	46.73	46.78	46.26	46.69	106978.0
2013-06-27	ABB-DELISTED	Stock	21.52	21.72	21.51	21.69	2080149.0
2013-06-27	ABBNY-DELISTED	Stock	21.52	21.72	21.51	21.69	2143428.0
2013-06-27	ABBV	Stock	43.56	43.98	42.74	43.13	5163900.0
2013-06-27	ABC-DELISTED	Stock	55.37	55.76	55.1	55.32	2410335.0
2013-06-27	ABCB	Stock	16.44	16.85	16.29	16.82	34300.0
2013-06-27	ABCD-DELISTED	Stock	1.382	1.382	1.29	1.35	5277.0
2013-06-27	ABCO-DELISTED	Stock	54.49	54.74	53.95	54.63	95205.0
2013-06-27	ABCW-DELISTED	Stock	0.585	0.598	0.585	0.598	11300.0
2013-06-27	ABE-DELISTED	Stock	19.36	19.57	19.17	19.57	6363.0
2013-06-27	ABEO	Stock	600.0	600.0	537.5	600.0	1.0
2013-06-27	ABFS-DELISTED	Stock	19.53	20.15	19.53	19.96	452898.0
2013-06-27	ABG	Stock	39.39	40.27	39.31	40.1	163000.0
2013-06-27	ABM	Stock	24.4	24.77	24.35	24.64	202300.0
2013-06-27	ABMD-DELISTED	Stock	21.32	21.43	21.05	21.36	313458.0
2013-06-27	ABR	Stock	6.15	6.29	6.02	6.25	151600.0
2013-06-27	ABR.A-DELISTED	Stock	24.68	24.9	24.68	24.8154	9120.0
2013-06-27	ABR.B-DELISTED	Stock	24.1	24.3199	24.1	24.3199	1200.0
2013-06-27	ABT	Stock	35.77	35.78	35.22	35.36	5625400.0
2013-06-27	ABTL-DELISTED	Stock	4.64	4.64	4.58	4.59	10183.0
2013-06-27	ABUS	Stock	4.8	4.8	4.72	4.76	6000.0
2013-06-27	ABV-DELISTED	Stock	36.49	37.275	36.36	37.12	6072076.0
2013-06-27	ABX-DELISTED	Stock	15.04	15.3001	14.78	14.86	30026354.0

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

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