PREVIEW / stock_daily / 2011-01-21

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-21.parquet
  size:    196 KB
  rows:    6,067
  symbols: 3,546

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
2011-01-21	AAPL	Stock	11.9204	11.96	11.6654	11.6686	754401200.0
2011-01-21	MSFT	Stock	28.4	28.43	28.02	28.02	58080300.0
2011-01-21	NVDA	Stock	0.5668	0.5748	0.5545	0.5555	739244000.0
2011-01-21	AMZN	Stock	9.15	9.1625	8.842	8.871	136124000.0
2011-01-21	TSLA	Stock	1.5413	1.5727	1.514	1.536	18255000.0
2011-01-21	TLT	Stock	90.69	91.52	90.51	91.52	9085822.0
2011-01-21	ES	Stock	32.87	32.87	32.47	32.58	1212200.0
2011-01-21	CL	Stock	39.3	39.575	39.005	39.5	6760800.0
2011-01-21	A	Stock	30.4006	30.9442	30.0644	30.1216	4200431.0
2011-01-21	AABA-DELISTED	Stock	16.27	16.31	15.93	15.96	20905594.0
2011-01-21	AACC-DELISTED	Stock	6.21	6.21	5.995	6.05	31483.0
2011-01-21	AACG	Stock	4.01	4.01	3.99	4.0	1900.0
2011-01-21	AAI-DELISTED	Stock	7.48	7.52	7.46	7.48	2527059.0
2011-01-21	AAIC-DELISTED	Stock	24.12	24.17	23.93	23.99	27368.0
2011-01-21	AAME	Stock	2.25	2.25	2.2	2.2	600.0
2011-01-21	AAON	Stock	5.4321	5.4321	5.2642	5.276	167062.0
2011-01-21	AAP	Stock	63.56	63.94	62.52	63.51	756800.0
2011-01-21	AAT	Stock	21.3	21.3	21.03	21.25	636800.0
2011-01-21	AATI-DELISTED	Stock	4.48	4.49	4.13	4.15	211749.0
2011-01-21	AAU-DELISTED	Stock	3.6	4.17	3.53	4.04	1333350.0
2011-01-21	AAUAF-DELISTED	Stock	3.6	4.17	3.53	4.03	1334450.0
2011-01-21	AAV-DELISTED	Stock	7.35	7.38	7.21	7.28	355379.0
2011-01-21	AAWW-DELISTED	Stock	51.39	51.7575	50.2	50.76	228239.0
2011-01-21	AAXJ	Stock	63.07	63.13	62.17	62.27	1080596.0
2011-01-21	AAXN-DELISTED	Stock	4.75	4.76	4.6	4.6	426437.0
2011-01-21	AB	Stock	21.92	21.99	21.61	21.7	555200.0
2011-01-21	ABAC-DELISTED	Stock	5.7	5.71	5.5	5.7	59573.0
2011-01-21	ABAX-DELISTED	Stock	26.78	27.0	26.52	26.65	108770.0
2011-01-21	ABB-DELISTED	Stock	23.46	23.47	23.29	23.37	1729071.0
2011-01-21	ABBC-DELISTED	Stock	10.86	11.18	10.86	11.04	70078.0
2011-01-21	ABBNY-DELISTED	Stock	23.46	23.47	23.29	23.36	1879271.0
2011-01-21	ABC-DELISTED	Stock	35.87	36.3	35.72	36.12	5714668.0
2011-01-21	ABCB	Stock	10.11	10.3	10.01	10.03	45400.0
2011-01-21	ABCD-DELISTED	Stock	3.23	3.27	3.1	3.2	43850.0
2011-01-21	ABCO-DELISTED	Stock	24.77	24.92	24.28	24.44	229400.0
2011-01-21	ABCW-DELISTED	Stock	1.31	1.34	1.3	1.33	86500.0
2011-01-21	ABD-DELISTED	Stock	8.01	8.07	7.79	7.85	239830.0
2011-01-21	ABE-DELISTED	Stock	18.8	18.9	18.76	18.86	11736.0
2011-01-21	ABEO	Stock	3100.0	3187.5	3025.0	3125.0	38.0
2011-01-21	ABFS-DELISTED	Stock	26.26	26.28	25.5	25.55	142213.0
2011-01-21	ABG	Stock	18.15	18.3	18.06	18.11	232300.0
2011-01-21	ABH-DELISTED	Stock	26.54	27.33	26.54	27.07	3891700.0
2011-01-21	ABM	Stock	25.76	25.79	25.46	25.59	155300.0
2011-01-21	ABMD-DELISTED	Stock	9.52	9.78	9.416	9.76	290248.0
2011-01-21	ABR	Stock	5.86	5.86	5.69	5.69	27700.0
2011-01-21	ABT	Stock	23.0832	23.112	22.944	22.992	17318049.0
2011-01-21	ABTL-DELISTED	Stock	4.6598	4.6598	4.3857	4.5902	14921.0
2011-01-21	ABUS	Stock	6.63	6.91	6.63	6.66	12900.0
2011-01-21	ABV-DELISTED	Stock	27.64	27.6698	26.7	27.08	6080899.0
2011-01-21	ABVA-DELISTED	Stock	4.7	4.7	4.5	4.6	2269.0

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

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