PREVIEW / stock_daily / 2013-03-06

all stock daily files

  file:    by_date/stock_daily/2013/2013-03-06.parquet
  size:    207 KB
  rows:    6,279
  symbols: 3,498

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-03-06	AAPL	Stock	15.5182	15.5446	15.1582	15.2021	460250000.0
2013-03-06	MSFT	Stock	28.21	28.23	27.78	28.09	51448500.0
2013-03-06	NVDA	Stock	0.322	0.325	0.3183	0.3198	342928000.0
2013-03-06	AMZN	Stock	13.788	13.8245	13.5915	13.6895	41014000.0
2013-03-06	META	Stock	28.1	28.13	27.35	27.45	33532600.0
2013-03-06	TSLA	Stock	2.4673	2.5253	2.4647	2.5127	17250000.0
2013-03-06	TLT	Stock	117.11	117.5	116.85	116.86	6516384.0
2013-03-06	ES	Stock	42.65	42.8	42.41	42.53	742400.0
2013-03-06	CL	Stock	57.925	57.975	57.42	57.675	2423400.0
2013-03-06	A	Stock	30.7582	31.1302	30.6867	30.9299	4189806.0
2013-03-06	AABA-DELISTED	Stock	23.06	23.09	22.71	22.8	15146318.0
2013-03-06	AACC-DELISTED	Stock	6.41	6.46	6.4	6.45	1358687.0
2013-03-06	AACG	Stock	4.09	4.09	4.07	4.07	5100.0
2013-03-06	AAIC-DELISTED	Stock	26.41	26.55	26.16	26.23	137825.0
2013-03-06	AAMC-DELISTED	Stock	38.8235	38.9706	38.8235	38.9706	9452.0
2013-03-06	AAME	Stock	3.45	3.45	3.4	3.4	4600.0
2013-03-06	AAMRQ-DELISTED	Stock	2.875	2.97	2.87	2.92	11977168.0
2013-03-06	AAON	Stock	7.3333	7.3333	7.2385	7.3007	131963.0
2013-03-06	AAP	Stock	77.1	77.24	75.97	76.18	1255700.0
2013-03-06	AAT	Stock	31.53	31.54	30.95	31.3	133000.0
2013-03-06	AAU-DELISTED	Stock	1.83	2.0099	1.83	2.0	143211.0
2013-03-06	AAUAF-DELISTED	Stock	1.85	2.03	1.85	2.0	142192.0
2013-03-06	AAV-DELISTED	Stock	3.0	3.05	2.99	3.05	92905.0
2013-03-06	AAWW-DELISTED	Stock	46.18	46.38	45.32	45.43	169840.0
2013-03-06	AAXJ	Stock	60.44	60.44	60.141	60.32	545840.0
2013-03-06	AAXN-DELISTED	Stock	7.92	8.06	7.88	7.92	759517.0
2013-03-06	AB	Stock	23.0	23.25	22.7	22.96	410400.0
2013-03-06	ABAC-DELISTED	Stock	0.8201	0.8301	0.8	0.8	15200.0
2013-03-06	ABAX-DELISTED	Stock	43.83	43.83	42.85	43.1	85521.0
2013-03-06	ABB-DELISTED	Stock	22.99	22.99	22.81	22.85	945706.0
2013-03-06	ABBNY-DELISTED	Stock	22.99	22.99	22.81	22.85	955354.0
2013-03-06	ABBV	Stock	37.56	37.86	37.37	37.74	5489500.0
2013-03-06	ABC-DELISTED	Stock	48.44	48.8	48.27	48.48	1477598.0
2013-03-06	ABCB	Stock	14.27	14.35	14.16	14.28	23600.0
2013-03-06	ABCD-DELISTED	Stock	1.15	1.21	1.15	1.21	25838.0
2013-03-06	ABCO-DELISTED	Stock	53.0	53.45	52.46	52.58	132664.0
2013-03-06	ABCW-DELISTED	Stock	0.53	0.6499	0.53	0.58	26014.0
2013-03-06	ABE-DELISTED	Stock	21.36	21.44	21.3	21.42	15617.0
2013-03-06	ABEO	Stock	612.5	612.5	562.5	562.5	1.0
2013-03-06	ABFS-DELISTED	Stock	11.88	12.0	11.61	11.63	210921.0
2013-03-06	ABG	Stock	34.67	35.35	34.48	35.35	551900.0
2013-03-06	ABM	Stock	22.13	22.44	21.8	21.95	239400.0
2013-03-06	ABMD-DELISTED	Stock	16.37	16.66	16.08	16.13	308229.0
2013-03-06	ABR	Stock	8.37	8.38	8.0	8.06	902700.0
2013-03-06	ABR.A-DELISTED	Stock	25.5	25.55	25.5	25.55	2382.0
2013-03-06	ABT	Stock	34.67	34.7	34.15	34.27	6412100.0
2013-03-06	ABTL-DELISTED	Stock	4.22	4.4	4.19	4.27	27694.0
2013-03-06	ABUS	Stock	4.44	4.46	4.41	4.41	13400.0
2013-03-06	ABV-DELISTED	Stock	45.2	45.96	45.09	45.83	1532017.0
2013-03-06	ABX-DELISTED	Stock	28.5	29.7	28.31	29.69	13938037.0

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

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