PREVIEW / stock_daily / 2011-03-18

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-18.parquet
  size:    198 KB
  rows:    6,063
  symbols: 3,525

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-03-18	AAPL	Stock	12.0404	12.0786	11.7857	11.8096	753214000.0
2011-03-18	MSFT	Stock	25.06	25.18	24.8	24.8	85486700.0
2011-03-18	NVDA	Stock	0.4535	0.455	0.44	0.4405	886960000.0
2011-03-18	AMZN	Stock	8.0595	8.177	8.0295	8.091	148854000.0
2011-03-18	TSLA	Stock	1.546	1.546	1.5007	1.5307	10318500.0
2011-03-18	TLT	Stock	92.75	93.48	92.69	93.46	7262989.0
2011-03-18	ES	Stock	33.84	34.1	33.55	33.67	1351700.0
2011-03-18	CL	Stock	38.625	38.675	38.195	38.475	8786400.0
2011-03-18	A	Stock	30.8512	31.2446	30.5293	30.7153	5429273.0
2011-03-18	AABA-DELISTED	Stock	16.07	16.19	16.01	16.03	25957228.0
2011-03-18	AACC-DELISTED	Stock	5.48	5.48	5.4	5.4	89033.0
2011-03-18	AACG	Stock	8.1	8.1	7.68	7.99	18100.0
2011-03-18	AAI-DELISTED	Stock	7.34	7.37	7.3	7.3	2133906.0
2011-03-18	AAIC-DELISTED	Stock	27.35	27.76	27.35	27.59	70240.0
2011-03-18	AAME	Stock	2.03	2.07	2.03	2.07	226100.0
2011-03-18	AAON	Stock	5.8074	6.0622	5.8074	6.0583	539156.0
2011-03-18	AAP	Stock	64.83	65.06	63.19	64.8	1557200.0
2011-03-18	AAT	Stock	21.1	21.5	20.98	21.5	535500.0
2011-03-18	AATI-DELISTED	Stock	3.51	3.61	3.45	3.57	430033.0
2011-03-18	AAU-DELISTED	Stock	3.56	3.75	3.56	3.63	270070.0
2011-03-18	AAUAF-DELISTED	Stock	3.56	3.75	3.56	3.63	270485.0
2011-03-18	AAV-DELISTED	Stock	8.11	8.33	8.08	8.3	584133.0
2011-03-18	AAWW-DELISTED	Stock	64.42	66.13	64.085	64.88	414073.0
2011-03-18	AAXJ	Stock	59.69	59.69	59.07	59.16	161945.0
2011-03-18	AAXN-DELISTED	Stock	3.8	3.84	3.72	3.775	1145697.0
2011-03-18	AB	Stock	21.32	21.65	21.21	21.57	577200.0
2011-03-18	ABAC-DELISTED	Stock	4.66	5.0	4.43	4.64	114429.0
2011-03-18	ABAX-DELISTED	Stock	27.72	28.25	27.44	28.24	114932.0
2011-03-18	ABB-DELISTED	Stock	23.36	23.37	23.08	23.14	2565833.0
2011-03-18	ABBC-DELISTED	Stock	11.68	11.84	11.6	11.65	101147.0
2011-03-18	ABBNY-DELISTED	Stock	23.36	23.37	23.08	23.14	2566433.0
2011-03-18	ABC-DELISTED	Stock	36.96	37.55	36.86	37.27	2968874.0
2011-03-18	ABCB	Stock	9.64	9.9	9.57	9.9	121500.0
2011-03-18	ABCD-DELISTED	Stock	3.34	3.42	3.3	3.37	54827.0
2011-03-18	ABCO-DELISTED	Stock	23.63	24.13	23.51	24.11	180434.0
2011-03-18	ABCW-DELISTED	Stock	1.0809	1.1422	1.0096	1.03	243050.0
2011-03-18	ABD-DELISTED	Stock	8.81	9.17	8.6	8.66	643110.0
2011-03-18	ABE-DELISTED	Stock	17.74	18.02	17.74	17.8	15641.0
2011-03-18	ABEO	Stock	2500.0	2500.0	2337.5	2500.0	14.0
2011-03-18	ABFS-DELISTED	Stock	24.29	24.29	23.78	24.04	695933.0
2011-03-18	ABG	Stock	17.67	17.83	17.04	17.04	2674900.0
2011-03-18	ABH-DELISTED	Stock	26.31	26.74	26.19	26.55	1636548.0
2011-03-18	ABM	Stock	24.42	24.7	24.09	24.61	412900.0
2011-03-18	ABMD-DELISTED	Stock	13.84	13.95	13.67	13.94	134630.0
2011-03-18	ABR	Stock	5.74	5.77	5.57	5.62	162100.0
2011-03-18	ABT	Stock	22.8241	23.1935	22.7857	22.9872	19049604.0
2011-03-18	ABTL-DELISTED	Stock	5.5991	5.6982	5.4505	5.5	19817.0
2011-03-18	ABUS	Stock	4.1	4.1	3.58	3.71	22600.0
2011-03-18	ABV-DELISTED	Stock	26.65	26.86	26.29	26.78	2516783.0
2011-03-18	ABVA-DELISTED	Stock	4.9082	4.9082	4.9	4.9	387.0

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

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