PREVIEW / stock_daily / 2013-01-22

all stock daily files

  file:    by_date/stock_daily/2013/2013-01-22.parquet
  size:    205 KB
  rows:    6,256
  symbols: 3,515

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-01-22	AAPL	Stock	18.02	18.1386	17.7368	18.0275	461546400.0
2013-01-22	MSFT	Stock	27.3	27.45	27.0	27.15	58650600.0
2013-01-22	NVDA	Stock	0.304	0.3068	0.3012	0.3028	308224000.0
2013-01-22	AMZN	Stock	13.581	13.605	13.4615	13.5095	42754000.0
2013-01-22	META	Stock	29.75	30.89	29.74	30.73	55243300.0
2013-01-22	TSLA	Stock	2.304	2.37	2.284	2.346	28803000.0
2013-01-22	TLT	Stock	119.55	120.3	119.38	120.27	3874061.0
2013-01-22	ES	Stock	39.26	39.92	39.25	39.85	2123900.0
2013-01-22	CL	Stock	54.02	54.23	53.87	54.23	2610400.0
2013-01-22	A	Stock	31.4449	31.9385	31.3662	31.9313	3164233.0
2013-01-22	AABA-DELISTED	Stock	19.91	19.95	19.72	19.9	13790664.0
2013-01-22	AACC-DELISTED	Stock	4.86	4.88	4.76	4.8599	24368.0
2013-01-22	AACG	Stock	5.68	5.68	5.68	5.68	100.0
2013-01-22	AAIC-DELISTED	Stock	22.83	23.1	22.82	23.04	143008.0
2013-01-22	AAMC-DELISTED	Stock	34.4118	37.2059	34.4118	37.2059	90086.0
2013-01-22	AAME	Stock	3.29	3.3	3.29	3.3	2900.0
2013-01-22	AAMRQ-DELISTED	Stock	1.345	1.43	1.32	1.41	13715387.0
2013-01-22	AAON	Stock	6.7319	6.7526	6.6311	6.7467	227138.0
2013-01-22	AAP	Stock	73.75	74.44	73.61	74.08	418300.0
2013-01-22	AAT	Stock	28.52	29.05	28.5	28.77	102600.0
2013-01-22	AAU-DELISTED	Stock	3.175	3.23	3.0754	3.18	181449.0
2013-01-22	AAUAF-DELISTED	Stock	3.18	3.24	3.0802	3.17	181575.0
2013-01-22	AAV-DELISTED	Stock	3.2	3.21	3.16	3.18	350770.0
2013-01-22	AAWW-DELISTED	Stock	46.09	47.0	46.09	46.86	162810.0
2013-01-22	AAXJ	Stock	61.19	61.19	60.92	61.11	849456.0
2013-01-22	AAXN-DELISTED	Stock	9.3	9.52	9.2	9.46	937712.0
2013-01-22	AB	Stock	20.14	20.72	20.01	20.53	333700.0
2013-01-22	ABAX-DELISTED	Stock	39.23	39.37	38.8	39.3	41376.0
2013-01-22	ABB-DELISTED	Stock	20.89	21.07	20.81	21.05	2535295.0
2013-01-22	ABBNY-DELISTED	Stock	20.89	21.07	20.81	21.05	2685891.0
2013-01-22	ABBV	Stock	36.98	37.25	35.93	36.42	15809700.0
2013-01-22	ABC-DELISTED	Stock	45.9	45.91	45.31	45.63	1365466.0
2013-01-22	ABCB	Stock	12.95	13.1	12.85	13.07	19700.0
2013-01-22	ABCD-DELISTED	Stock	1.3	1.4	1.23	1.31	39044.0
2013-01-22	ABCO-DELISTED	Stock	52.88	53.05	52.2	53.04	67151.0
2013-01-22	ABCW-DELISTED	Stock	0.72	0.85	0.61	0.69	61580.0
2013-01-22	ABE-DELISTED	Stock	22.42	22.72	22.03	22.12	34712.0
2013-01-22	ABEO	Stock	425.0	475.0	375.0	475.0	55.0
2013-01-22	ABFS-DELISTED	Stock	10.26	10.75	10.15	10.72	420025.0
2013-01-22	ABG	Stock	34.0	34.32	33.35	33.61	208200.0
2013-01-22	ABM	Stock	20.9	20.97	20.77	20.96	213900.0
2013-01-22	ABMD-DELISTED	Stock	12.49	12.66	12.41	12.53	677580.0
2013-01-22	ABR	Stock	7.16	7.2	7.09	7.12	229700.0
2013-01-22	ABT	Stock	32.78	33.0	32.55	32.9	18077900.0
2013-01-22	ABTL-DELISTED	Stock	3.9901	4.1599	3.99	4.15	24156.0
2013-01-22	ABUS	Stock	4.99	5.0	4.91	4.98	20000.0
2013-01-22	ABV-DELISTED	Stock	44.9	45.2	44.753	45.13	1054488.0
2013-01-22	ABX-DELISTED	Stock	34.14	34.96	34.01	34.8	7760190.0
2013-01-22	ACAD	Stock	5.23	5.74	5.16	5.67	2329700.0
2013-01-22	ACAS-DELISTED	Stock	13.17	13.19	13.06	13.14	3231363.0

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

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