PREVIEW / stock_daily / 2011-06-22

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-22.parquet
  size:    198 KB
  rows:    6,123
  symbols: 3,560

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-06-22	AAPL	Stock	11.6129	11.7464	11.5136	11.5218	390583200.0
2011-06-22	MSFT	Stock	24.6	24.81	24.59	24.65	44287300.0
2011-06-22	NVDA	Stock	0.3962	0.4015	0.3928	0.3935	651720000.0
2011-06-22	AMZN	Stock	9.698	9.76	9.566	9.5815	62594000.0
2011-06-22	TSLA	Stock	1.8247	1.8833	1.8067	1.814	22134000.0
2011-06-22	TLT	Stock	96.96	97.06	96.41	96.65	5505637.0
2011-06-22	ES	Stock	35.09	35.16	34.67	34.81	1842600.0
2011-06-22	CL	Stock	44.37	44.565	43.745	43.765	5510600.0
2011-06-22	A	Stock	35.4578	35.6509	35.0	35.0143	3200302.0
2011-06-22	AABA-DELISTED	Stock	15.3	15.53	15.19	15.225	28172932.0
2011-06-22	AACC-DELISTED	Stock	3.69	3.79	3.57	3.61	70304.0
2011-06-22	AACG	Stock	10.26	10.26	10.2	10.25	8000.0
2011-06-22	AAIC-DELISTED	Stock	30.26	30.65	30.26	30.38	26538.0
2011-06-22	AAME	Stock	2.04	2.05	2.04	2.05	200.0
2011-06-22	AAON	Stock	6.7022	6.7141	6.4385	6.4385	151200.0
2011-06-22	AAP	Stock	58.92	59.37	58.62	58.65	1442800.0
2011-06-22	AAT	Stock	21.99	22.23	21.96	22.07	62100.0
2011-06-22	AATI-DELISTED	Stock	6.04	6.05	6.04	6.05	127387.0
2011-06-22	AAU-DELISTED	Stock	3.35	3.54	3.29	3.44	304055.0
2011-06-22	AAUAF-DELISTED	Stock	3.35	3.54	3.29	3.44	304855.0
2011-06-22	AAV-DELISTED	Stock	7.67	8.09	7.67	7.96	270526.0
2011-06-22	AAWW-DELISTED	Stock	58.2	60.7	58.2	59.27	175807.0
2011-06-22	AAXJ	Stock	60.15	60.2	59.73	59.73	319692.0
2011-06-22	AAXN-DELISTED	Stock	4.22	4.31	4.15	4.29	357422.0
2011-06-22	AB	Stock	19.43	19.54	19.23	19.4	306900.0
2011-06-22	ABAC-DELISTED	Stock	2.1	2.25	2.0694	2.21	30390.0
2011-06-22	ABAX-DELISTED	Stock	28.3	28.98	28.3	28.45	55605.0
2011-06-22	ABB-DELISTED	Stock	25.35	25.5	25.23	25.25	2963687.0
2011-06-22	ABBC-DELISTED	Stock	10.14	10.53	10.1	10.11	85807.0
2011-06-22	ABBNY-DELISTED	Stock	25.35	25.5	25.23	25.24	2963787.0
2011-06-22	ABC-DELISTED	Stock	41.57	41.66	41.21	41.25	1462551.0
2011-06-22	ABCB	Stock	9.11	9.22	8.75	8.75	33900.0
2011-06-22	ABCD-DELISTED	Stock	3.24	3.29	3.22	3.24	15987.0
2011-06-22	ABCO-DELISTED	Stock	26.53	26.72	26.31	26.59	144586.0
2011-06-22	ABCW-DELISTED	Stock	0.72	0.72	0.66	0.72	19270.0
2011-06-22	ABD-DELISTED	Stock	7.85	7.85	7.55	7.63	256500.0
2011-06-22	ABE-DELISTED	Stock	18.47	18.48	18.34	18.4	13328.0
2011-06-22	ABEO	Stock	2375.0	2375.0	2062.5	2350.0	50.0
2011-06-22	ABFS-DELISTED	Stock	22.33	22.84	22.33	22.41	326524.0
2011-06-22	ABG	Stock	17.57	17.84	16.98	17.02	304300.0
2011-06-22	ABH-DELISTED	Stock	21.87	22.14	21.79	22.1	1074354.0
2011-06-22	ABM	Stock	22.9	23.5	22.85	23.27	376500.0
2011-06-22	ABMD-DELISTED	Stock	16.58	16.79	16.52	16.53	102965.0
2011-06-22	ABR	Stock	4.46	4.61	4.43	4.51	119000.0
2011-06-22	ABT	Stock	24.9928	25.1175	24.9736	24.988	9505211.0
2011-06-22	ABTL-DELISTED	Stock	4.9495	4.999	4.8579	4.9	27172.0
2011-06-22	ABUS	Stock	2.6	2.65	2.51	2.55	12500.0
2011-06-22	ABV-DELISTED	Stock	32.31	32.85	32.22	32.23	1745560.0
2011-06-22	ABVA-DELISTED	Stock	4.6	4.95	4.6	4.8499	8900.0
2011-06-22	ABVT-DELISTED	Stock	70.3	70.95	69.9	70.48	159048.0

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

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