PREVIEW / stock_daily / 2011-01-20

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-20.parquet
  size:    196 KB
  rows:    6,053
  symbols: 3,542

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-20	AAPL	Stock	12.0154	12.0821	11.79	11.8814	764789200.0
2011-01-20	MSFT	Stock	28.5	28.55	28.13	28.35	58613600.0
2011-01-20	NVDA	Stock	0.5548	0.564	0.5448	0.5608	1111408000.0
2011-01-20	AMZN	Stock	9.2645	9.3425	9.05	9.098	114198000.0
2011-01-20	TSLA	Stock	1.602	1.63	1.4913	1.508	34198500.0
2011-01-20	TLT	Stock	91.5	91.615	90.39	90.8	14203347.0
2011-01-20	ES	Stock	32.42	32.8	32.41	32.64	1348300.0
2011-01-20	CL	Stock	39.485	39.71	39.25	39.495	5106400.0
2011-01-20	A	Stock	30.0072	30.4578	29.6567	30.2504	6814970.0
2011-01-20	AABA-DELISTED	Stock	16.3	16.33	16.09	16.23	14363550.0
2011-01-20	AACC-DELISTED	Stock	6.2	6.29	6.16	6.18	17008.0
2011-01-20	AACG	Stock	3.98	4.04	3.98	4.04	5500.0
2011-01-20	AAI-DELISTED	Stock	7.47	7.53	7.44	7.48	2079064.0
2011-01-20	AAIC-DELISTED	Stock	23.93	24.12	23.93	23.98	19174.0
2011-01-20	AAME	Stock	2.21	2.21	2.1	2.17	5000.0
2011-01-20	AAON	Stock	5.2859	5.5072	5.2365	5.3906	401456.0
2011-01-20	AAP	Stock	63.27	64.34	62.85	63.16	693300.0
2011-01-20	AAT	Stock	21.05	21.4	21.03	21.21	736600.0
2011-01-20	AATI-DELISTED	Stock	4.41	4.51	4.4	4.46	100132.0
2011-01-20	AAU-DELISTED	Stock	3.6	3.61	3.39	3.6	819441.0
2011-01-20	AAUAF-DELISTED	Stock	3.6	3.61	3.39	3.6	820341.0
2011-01-20	AAV-DELISTED	Stock	7.09	7.32	6.969	7.32	646748.0
2011-01-20	AAWW-DELISTED	Stock	49.94	53.64	49.94	51.07	463925.0
2011-01-20	AAXJ	Stock	63.5	63.5	62.6	63.08	1063219.0
2011-01-20	AAXN-DELISTED	Stock	4.77	4.83	4.69	4.7	462061.0
2011-01-20	AB	Stock	21.7	21.89	21.5	21.69	679800.0
2011-01-20	ABAC-DELISTED	Stock	5.85	5.85	5.61	5.67	57229.0
2011-01-20	ABAX-DELISTED	Stock	26.5	26.96	26.37	26.64	81607.0
2011-01-20	ABB-DELISTED	Stock	22.88	22.99	22.6332	22.83	1969046.0
2011-01-20	ABBC-DELISTED	Stock	11.01	11.07	10.76	10.81	53644.0
2011-01-20	ABBNY-DELISTED	Stock	22.9	22.99	22.6332	22.81	2171446.0
2011-01-20	ABC-DELISTED	Stock	35.62	35.79	35.04	35.71	2310510.0
2011-01-20	ABCB	Stock	10.32	10.63	10.2	10.2	23600.0
2011-01-20	ABCD-DELISTED	Stock	3.27	3.37	3.19	3.222	14104.0
2011-01-20	ABCO-DELISTED	Stock	24.3	24.71	24.14	24.62	348479.0
2011-01-20	ABCW-DELISTED	Stock	1.4	1.4	1.27	1.33	191970.0
2011-01-20	ABD-DELISTED	Stock	7.945	8.175	7.765	7.965	218400.0
2011-01-20	ABE-DELISTED	Stock	19.0	19.0	18.68	18.78	5322.0
2011-01-20	ABEO	Stock	3000.0	3062.5	3000.0	3062.5	21.0
2011-01-20	ABFS-DELISTED	Stock	25.76	26.11	25.64	26.105	141157.0
2011-01-20	ABG	Stock	18.01	18.35	17.95	18.02	156700.0
2011-01-20	ABH-DELISTED	Stock	26.47	26.61	26.17	26.4	895113.0
2011-01-20	ABM	Stock	25.81	25.99	25.58	25.62	142900.0
2011-01-20	ABMD-DELISTED	Stock	9.66	9.66	9.44	9.5	119137.0
2011-01-20	ABR	Stock	5.94	5.94	5.81	5.86	21600.0
2011-01-20	ABT	Stock	22.7233	23.0112	22.6993	23.0112	23437266.0
2011-01-20	ABTL-DELISTED	Stock	4.8075	4.8974	4.5726	4.7925	32305.0
2011-01-20	ABUS	Stock	7.94	7.94	6.62	6.7	36000.0
2011-01-20	ABV-DELISTED	Stock	27.99	28.01	27.26	27.29	4423953.0
2011-01-20	ABVA-DELISTED	Stock	4.49	4.86	4.47	4.86	4900.0

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

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