PREVIEW / stock_daily / 2013-04-03

all stock daily files

  file:    by_date/stock_daily/2013/2013-04-03.parquet
  size:    207 KB
  rows:    6,298
  symbols: 3,499

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-04-03	AAPL	Stock	15.4061	15.6171	15.3682	15.4282	363216000.0
2013-04-03	MSFT	Stock	28.75	28.95	28.54	28.56	35062800.0
2013-04-03	NVDA	Stock	0.3065	0.3083	0.301	0.3032	353156000.0
2013-04-03	AMZN	Stock	13.106	13.1835	12.8875	12.9515	48276000.0
2013-04-03	META	Stock	25.83	26.39	25.7	26.25	48195200.0
2013-04-03	TSLA	Stock	2.8733	2.898	2.6807	2.74	84654000.0
2013-04-03	TLT	Stock	118.31	119.292	118.25	118.969	9527382.0
2013-04-03	ES	Stock	42.86	43.55	42.86	43.22	1911200.0
2013-04-03	CL	Stock	59.5	59.56	58.52	58.655	3354000.0
2013-04-03	A	Stock	29.0629	29.3205	28.8412	28.9843	7380042.0
2013-04-03	AABA-DELISTED	Stock	23.78	23.88	23.24	23.38	14918455.0
2013-04-03	AACC-DELISTED	Stock	6.72	6.72	6.69	6.7	237939.0
2013-04-03	AACG	Stock	3.98	3.98	3.98	3.98	100.0
2013-04-03	AAIC-DELISTED	Stock	25.62	25.78	25.41	25.49	310006.0
2013-04-03	AAMC-DELISTED	Stock	38.2353	38.2353	37.5	38.0294	9996.0
2013-04-03	AAME	Stock	3.27	3.39	3.26	3.39	3300.0
2013-04-03	AAMRQ-DELISTED	Stock	3.74	3.75	3.1	3.51	22231647.0
2013-04-03	AAON	Stock	7.9022	8.0859	7.9022	7.9941	567675.0
2013-04-03	AAP	Stock	82.8	82.95	81.5	82.12	846100.0
2013-04-03	AAT	Stock	32.52	32.91	32.25	32.68	219300.0
2013-04-03	AAU-DELISTED	Stock	1.95	1.98	1.77	1.77	307103.0
2013-04-03	AAUAF-DELISTED	Stock	1.95	1.98	1.77	1.77	307303.0
2013-04-03	AAV-DELISTED	Stock	3.68	3.68	3.53	3.565	892784.0
2013-04-03	AAWW-DELISTED	Stock	39.11	40.15	39.02	39.48	216267.0
2013-04-03	AAXJ	Stock	58.69	58.76	58.13	58.28	520106.0
2013-04-03	AAXN-DELISTED	Stock	7.52	7.65	7.24	7.36	720816.0
2013-04-03	AB	Stock	22.02	22.09	20.92	21.05	320200.0
2013-04-03	ABAC-DELISTED	Stock	0.7	0.75	0.6999	0.75	7702.0
2013-04-03	ABAX-DELISTED	Stock	47.33	47.54	45.53	45.7	131998.0
2013-04-03	ABB-DELISTED	Stock	22.88	22.95	22.43	22.5	1484780.0
2013-04-03	ABBNY-DELISTED	Stock	22.88	22.95	22.43	22.5	1506779.0
2013-04-03	ABBV	Stock	40.75	41.45	40.35	40.57	4122100.0
2013-04-03	ABC-DELISTED	Stock	52.57	52.83	51.315	51.69	4401565.0
2013-04-03	ABCB	Stock	14.16	14.4	13.95	13.96	41800.0
2013-04-03	ABCD-DELISTED	Stock	0.9901	1.04	0.9901	1.02	11991.0
2013-04-03	ABCO-DELISTED	Stock	51.43	51.43	50.21	50.34	182358.0
2013-04-03	ABCW-DELISTED	Stock	0.62	0.68	0.62	0.68	26019.0
2013-04-03	ABE-DELISTED	Stock	20.76	20.76	20.39	20.616	9897.0
2013-04-03	ABEO	Stock	550.0	637.5	537.5	637.5	16.0
2013-04-03	ABFS-DELISTED	Stock	11.36	11.42	11.08	11.1	199439.0
2013-04-03	ABG	Stock	36.91	37.0	34.38	34.62	348100.0
2013-04-03	ABM	Stock	21.77	21.87	21.44	21.59	208100.0
2013-04-03	ABMD-DELISTED	Stock	17.92	18.02	17.06	17.22	419538.0
2013-04-03	ABR	Stock	7.94	7.97	7.77	7.8	294900.0
2013-04-03	ABR.A-DELISTED	Stock	25.918	25.918	25.8	25.8	2100.0
2013-04-03	ABT	Stock	36.13	36.39	35.9	36.32	10143200.0
2013-04-03	ABTL-DELISTED	Stock	4.289	4.36	4.239	4.34	4508.0
2013-04-03	ABUS	Stock	4.51	4.6	4.35	4.4	188300.0
2013-04-03	ABV-DELISTED	Stock	41.65	41.83	40.83	40.85	2616102.0
2013-04-03	ABX-DELISTED	Stock	28.2	28.47	26.54	26.72	22999603.0

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

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