PREVIEW / stock_daily / 2011-03-14

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-14.parquet
  size:    197 KB
  rows:    6,059
  symbols: 3,530

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-14	AAPL	Stock	12.6136	12.7314	12.5468	12.6271	435957200.0
2011-03-14	MSFT	Stock	25.49	25.76	25.35	25.69	54473400.0
2011-03-14	NVDA	Stock	0.4548	0.4662	0.4475	0.455	1003360000.0
2011-03-14	AMZN	Stock	8.33	8.404	8.2285	8.3365	80440000.0
2011-03-14	TSLA	Stock	1.588	1.6	1.5467	1.55	17490000.0
2011-03-14	TLT	Stock	91.48	91.92	91.32	91.51	6767868.0
2011-03-14	ES	Stock	34.34	34.44	34.06	34.31	1904200.0
2011-03-14	CL	Stock	39.355	39.44	38.965	39.135	5188400.0
2011-03-14	A	Stock	32.2532	32.4821	31.5522	32.0744	7917853.0
2011-03-14	AABA-DELISTED	Stock	17.27	17.44	17.09	17.33	20914700.0
2011-03-14	AACC-DELISTED	Stock	5.57	5.59	5.5	5.56	13100.0
2011-03-14	AACG	Stock	7.59	7.92	7.59	7.77	66600.0
2011-03-14	AAI-DELISTED	Stock	7.41	7.45	7.39	7.42	2306433.0
2011-03-14	AAIC-DELISTED	Stock	28.54	28.7085	27.6	27.7	38711.0
2011-03-14	AAME	Stock	2.11	2.11	2.11	2.11	100.0
2011-03-14	AAON	Stock	5.6	5.7185	5.5802	5.679	275400.0
2011-03-14	AAP	Stock	65.18	65.98	64.91	65.28	1021000.0
2011-03-14	AAT	Stock	20.58	21.07	20.49	20.99	120400.0
2011-03-14	AATI-DELISTED	Stock	3.81	3.86	3.76	3.8	146486.0
2011-03-14	AAU-DELISTED	Stock	3.94	3.94	3.62	3.65	248212.0
2011-03-14	AAUAF-DELISTED	Stock	3.94	3.94	3.62	3.65	250712.0
2011-03-14	AAV-DELISTED	Stock	8.05	8.09	7.76	8.07	643143.0
2011-03-14	AAWW-DELISTED	Stock	64.51	65.7	64.0	64.13	201479.0
2011-03-14	AAXJ	Stock	60.59	61.1	60.56	61.06	265197.0
2011-03-14	AAXN-DELISTED	Stock	4.1	4.14	4.0	4.01	427408.0
2011-03-14	AB	Stock	21.79	21.84	21.33	21.5	430800.0
2011-03-14	ABAC-DELISTED	Stock	4.95	4.95	4.64	4.75	67972.0
2011-03-14	ABAX-DELISTED	Stock	27.86	28.59	27.86	28.12	121836.0
2011-03-14	ABB-DELISTED	Stock	22.98	23.1	22.8601	23.06	2028590.0
2011-03-14	ABBC-DELISTED	Stock	11.83	11.98	11.64	11.83	42622.0
2011-03-14	ABBNY-DELISTED	Stock	22.98	23.1	22.8601	23.05	2095490.0
2011-03-14	ABC-DELISTED	Stock	36.67	37.09	36.5	36.63	1905329.0
2011-03-14	ABCB	Stock	9.57	9.62	9.53	9.53	53400.0
2011-03-14	ABCD-DELISTED	Stock	3.36	3.36	3.3	3.3	26995.0
2011-03-14	ABCO-DELISTED	Stock	23.92	24.23	23.86	24.09	129652.0
2011-03-14	ABCW-DELISTED	Stock	1.04	1.04	0.98	1.01	55630.0
2011-03-14	ABD-DELISTED	Stock	8.875	9.165	8.825	8.895	200210.0
2011-03-14	ABE-DELISTED	Stock	17.83	18.01	17.82	18.01	7269.0
2011-03-14	ABEO	Stock	2425.0	2487.5	2425.0	2487.5	2.0
2011-03-14	ABFS-DELISTED	Stock	24.02	24.2	23.74	24.06	107875.0
2011-03-14	ABG	Stock	18.77	19.23	17.57	17.8	622600.0
2011-03-14	ABH-DELISTED	Stock	27.04	27.84	26.8	27.09	492474.0
2011-03-14	ABM	Stock	23.9	24.91	22.8	24.81	521400.0
2011-03-14	ABMD-DELISTED	Stock	13.84	14.16	13.84	14.11	137610.0
2011-03-14	ABR	Stock	5.86	5.96	5.71	5.77	38800.0
2011-03-14	ABT	Stock	23.1791	23.1839	23.016	23.136	12797624.0
2011-03-14	ABTL-DELISTED	Stock	5.9997	6.2497	5.6498	5.8003	28646.0
2011-03-14	ABUS	Stock	4.6	4.79	4.59	4.74	2200.0
2011-03-14	ABV-DELISTED	Stock	27.63	27.84	27.34	27.78	2373543.0
2011-03-14	ABVA-DELISTED	Stock	4.87	4.88	4.8	4.8	3900.0

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

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