PREVIEW / stock_daily / 2011-11-22

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-22.parquet
  size:    194 KB
  rows:    6,083
  symbols: 3,528

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-11-22	AAPL	Stock	13.2507	13.4975	13.2479	13.4468	409021200.0
2011-11-22	MSFT	Stock	24.89	24.96	24.65	24.79	49204500.0
2011-11-22	NVDA	Stock	0.3698	0.379	0.3678	0.377	1287480000.0
2011-11-22	AMZN	Stock	9.3475	9.702	9.179	9.617	198312000.0
2011-11-22	TSLA	Stock	2.1173	2.186	2.07	2.138	10989000.0
2011-11-22	TLT	Stock	120.35	121.41	119.85	121.39	7866399.0
2011-11-22	ES	Stock	33.81	33.86	33.29	33.61	2237600.0
2011-11-22	CL	Stock	43.885	44.545	43.795	44.1	4613200.0
2011-11-22	A	Stock	25.4793	25.8369	25.0644	25.4506	3709313.0
2011-11-22	AABA-DELISTED	Stock	14.87	15.08	14.75	14.98	14787309.0
2011-11-22	AACC-DELISTED	Stock	2.9	3.13	2.9	3.0	132807.0
2011-11-22	AACG	Stock	9.47	9.85	9.14	9.85	13900.0
2011-11-22	AAIC-DELISTED	Stock	20.46	20.49	19.79	19.92	64084.0
2011-11-22	AAME	Stock	1.85	1.99	1.85	1.99	3400.0
2011-11-22	AAON	Stock	6.0296	6.0563	5.8578	5.8637	174488.0
2011-11-22	AAP	Stock	67.37	67.55	66.85	66.95	1134100.0
2011-11-22	AAT	Stock	20.54	20.57	19.94	20.14	422400.0
2011-11-22	AATI-DELISTED	Stock	4.3	4.37	4.235	4.29	174890.0
2011-11-22	AAU-DELISTED	Stock	2.49	2.559	2.46	2.52	60508.0
2011-11-22	AAUAF-DELISTED	Stock	2.49	2.559	2.46	2.51	60608.0
2011-11-22	AAV-DELISTED	Stock	4.86	4.99	4.735	4.85	444445.0
2011-11-22	AAWW-DELISTED	Stock	38.01	38.54	37.09	37.37	230761.0
2011-11-22	AAXJ	Stock	49.46	49.76	49.05	49.47	298392.0
2011-11-22	AAXN-DELISTED	Stock	5.87	6.11	5.87	5.97	800574.0
2011-11-22	AB	Stock	13.06	13.11	12.84	12.92	379400.0
2011-11-22	ABAC-DELISTED	Stock	1.7844	1.98	1.7844	1.98	57939.0
2011-11-22	ABAX-DELISTED	Stock	25.86	26.44	25.62	25.9	46067.0
2011-11-22	ABB-DELISTED	Stock	17.05	17.21	16.93	17.09	3065671.0
2011-11-22	ABBNY-DELISTED	Stock	17.05	17.21	16.93	17.08	3065671.0
2011-11-22	ABC-DELISTED	Stock	36.37	37.16	36.36	36.65	2545818.0
2011-11-22	ABCB	Stock	9.66	9.69	9.47	9.5	42500.0
2011-11-22	ABCD-DELISTED	Stock	2.93	2.96	2.82	2.87	37633.0
2011-11-22	ABCO-DELISTED	Stock	33.97	34.27	33.76	34.02	98266.0
2011-11-22	ABCW-DELISTED	Stock	0.3514	0.3815	0.3113	0.3615	220380.0
2011-11-22	ABD-DELISTED	Stock	9.12	9.39	8.87	8.89	843270.0
2011-11-22	ABE-DELISTED	Stock	17.38	17.6	17.377	17.377	4021.0
2011-11-22	ABEO	Stock	1675.0	1687.5	1637.5	1650.0	31.0
2011-11-22	ABFS-DELISTED	Stock	18.11	18.34	17.62	17.89	298569.0
2011-11-22	ABG	Stock	18.9	19.11	18.7	18.89	226500.0
2011-11-22	ABH-DELISTED	Stock	15.99	16.07	15.83	15.92	526501.0
2011-11-22	ABM	Stock	20.18	20.48	20.01	20.07	459900.0
2011-11-22	ABMD-DELISTED	Stock	17.86	18.22	17.62	17.66	159169.0
2011-11-22	ABR	Stock	3.6	3.67	3.6	3.61	13500.0
2011-11-22	ABT	Stock	25.2807	25.439	25.1559	25.2807	10992705.0
2011-11-22	ABTL-DELISTED	Stock	3.8	3.999	3.61	3.85	16579.0
2011-11-22	ABUS	Stock	1.6	1.6	1.46	1.54	7600.0
2011-11-22	ABV-DELISTED	Stock	32.13	32.25	31.69	31.93	1780750.0
2011-11-22	ABVA-DELISTED	Stock	5.11	5.23	5.04	5.23	91711.0
2011-11-22	ABVT-DELISTED	Stock	56.42	57.34	56.09	56.36	179945.0
2011-11-22	ABX-DELISTED	Stock	48.44	49.65	48.36	49.08	5367986.0

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

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