PREVIEW / stock_daily / 2011-03-21

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-21.parquet
  size:    197 KB
  rows:    6,077
  symbols: 3,540

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-21	AAPL	Stock	11.9996	12.1336	11.9736	12.1179	409402000.0
2011-03-21	MSFT	Stock	25.18	25.58	25.15	25.33	46878100.0
2011-03-21	NVDA	Stock	0.45	0.4545	0.4395	0.444	751832000.0
2011-03-21	AMZN	Stock	8.1685	8.2895	8.086	8.226	81102000.0
2011-03-21	TSLA	Stock	1.5367	1.5367	1.5027	1.5153	6175500.0
2011-03-21	TLT	Stock	93.13	93.18	92.57	92.91	10545515.0
2011-03-21	ES	Stock	33.98	34.5	33.91	34.21	984100.0
2011-03-21	CL	Stock	38.665	39.255	38.64	39.205	6728800.0
2011-03-21	A	Stock	31.1302	31.7382	31.0944	31.4378	4382311.0
2011-03-21	AABA-DELISTED	Stock	16.18	16.5	16.16	16.29	20466384.0
2011-03-21	AACC-DELISTED	Stock	5.49	5.51	5.4	5.45	93006.0
2011-03-21	AACG	Stock	8.0	8.0	7.8	7.91	14700.0
2011-03-21	AAI-DELISTED	Stock	7.33	7.37	7.3	7.35	1154217.0
2011-03-21	AAIC-DELISTED	Stock	27.88	28.58	27.77	28.58	28086.0
2011-03-21	AAME	Stock	2.11	2.18	2.1	2.18	1900.0
2011-03-21	AAON	Stock	6.1195	6.1807	6.0642	6.1333	153394.0
2011-03-21	AAP	Stock	65.34	65.84	64.98	65.0	1002100.0
2011-03-21	AAT	Stock	21.5	21.56	21.32	21.46	84600.0
2011-03-21	AATI-DELISTED	Stock	3.6	3.65	3.53	3.63	149475.0
2011-03-21	AAU-DELISTED	Stock	3.8	3.86	3.75	3.78	206005.0
2011-03-21	AAUAF-DELISTED	Stock	3.8	3.86	3.75	3.78	207545.0
2011-03-21	AAV-DELISTED	Stock	8.4	8.56	8.36	8.46	425579.0
2011-03-21	AAWW-DELISTED	Stock	65.89	67.87	65.47	67.08	279423.0
2011-03-21	AAXJ	Stock	60.29	60.54	60.05	60.45	168441.0
2011-03-21	AAXN-DELISTED	Stock	3.82	3.92	3.79	3.815	485275.0
2011-03-21	AB	Stock	21.93	21.98	21.52	21.73	453000.0
2011-03-21	ABAC-DELISTED	Stock	4.76	4.76	4.4	4.41	24169.0
2011-03-21	ABAX-DELISTED	Stock	28.55	29.82	28.55	29.56	144997.0
2011-03-21	ABB-DELISTED	Stock	23.75	23.8795	23.66	23.79	2975028.0
2011-03-21	ABBC-DELISTED	Stock	11.74	12.0	11.66	11.98	89399.0
2011-03-21	ABBNY-DELISTED	Stock	23.74	23.8795	23.66	23.78	3145613.0
2011-03-21	ABC-DELISTED	Stock	37.61	38.46	37.51	37.87	2687697.0
2011-03-21	ABCB	Stock	10.0	10.03	9.79	10.0	36400.0
2011-03-21	ABCD-DELISTED	Stock	3.4	3.47	3.35	3.41	30314.0
2011-03-21	ABCO-DELISTED	Stock	24.21	24.87	23.91	24.72	68751.0
2011-03-21	ABCW-DELISTED	Stock	1.06	1.06	0.992	1.01	81970.0
2011-03-21	ABD-DELISTED	Stock	8.8	8.99	8.76	8.99	306520.0
2011-03-21	ABE-DELISTED	Stock	18.0	18.12	17.89	17.95	22054.0
2011-03-21	ABEO	Stock	2500.0	2650.0	2325.0	2500.0	17.0
2011-03-21	ABFS-DELISTED	Stock	24.42	25.44	23.83	25.14	1320005.0
2011-03-21	ABG	Stock	17.15	18.24	17.14	18.21	703800.0
2011-03-21	ABH-DELISTED	Stock	26.7	27.44	26.5	27.15	352883.0
2011-03-21	ABM	Stock	24.86	25.19	24.75	25.18	265800.0
2011-03-21	ABMD-DELISTED	Stock	14.09	14.3	13.98	14.28	92626.0
2011-03-21	ABR	Stock	5.71	5.88	5.71	5.74	50900.0
2011-03-21	ABT	Stock	23.0928	23.1408	22.9488	23.0448	12221759.0
2011-03-21	ABTL-DELISTED	Stock	5.55	5.75	5.55	5.65	15418.0
2011-03-21	ABUS	Stock	3.68	3.76	3.58	3.63	39300.0
2011-03-21	ABV-DELISTED	Stock	27.21	27.29	26.96	27.15	1166543.0
2011-03-21	ABVA-DELISTED	Stock	5.0	5.08	4.94	5.08	5635.0

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

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