PREVIEW / stock_daily / 2011-03-23

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-23.parquet
  size:    197 KB
  rows:    6,075
  symbols: 3,534

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-23	AAPL	Stock	12.1171	12.1507	11.9982	12.1139	372996400.0
2011-03-23	MSFT	Stock	25.23	25.61	25.18	25.54	43969000.0
2011-03-23	NVDA	Stock	0.4355	0.4465	0.426	0.4452	782396000.0
2011-03-23	AMZN	Stock	8.115	8.313	8.041	8.266	94426000.0
2011-03-23	TSLA	Stock	1.474	1.4847	1.4513	1.4807	6342000.0
2011-03-23	TLT	Stock	93.85	93.88	92.93	93.1	8358941.0
2011-03-23	ES	Stock	34.08	34.24	33.88	34.2	894900.0
2011-03-23	CL	Stock	39.21	39.395	38.94	39.145	5456200.0
2011-03-23	A	Stock	30.7225	31.3662	30.5794	31.2375	5258018.0
2011-03-23	AABA-DELISTED	Stock	16.31	16.34	15.98	16.12	30685301.0
2011-03-23	AACC-DELISTED	Stock	5.41	5.56	5.37	5.54	12820.0
2011-03-23	AACG	Stock	7.84	7.99	7.84	7.99	4100.0
2011-03-23	AAI-DELISTED	Stock	7.3	7.38	7.28	7.35	3186905.0
2011-03-23	AAIC-DELISTED	Stock	28.41	28.7	27.94	28.7	50806.0
2011-03-23	AAME	Stock	2.15	2.16	2.02	2.11	2000.0
2011-03-23	AAON	Stock	6.1965	6.236	6.1175	6.1294	132131.0
2011-03-23	AAP	Stock	64.94	65.65	64.33	65.34	836500.0
2011-03-23	AAT	Stock	21.5	21.54	21.03	21.36	117500.0
2011-03-23	AATI-DELISTED	Stock	3.65	3.73	3.63	3.68	95472.0
2011-03-23	AAU-DELISTED	Stock	3.93	4.16	3.88	4.08	595910.0
2011-03-23	AAUAF-DELISTED	Stock	3.93	4.16	3.88	4.06	599200.0
2011-03-23	AAV-DELISTED	Stock	8.35	8.49	8.35	8.38	407914.0
2011-03-23	AAWW-DELISTED	Stock	66.21	67.46	65.82	67.22	234936.0
2011-03-23	AAXJ	Stock	60.58	61.03	60.27	60.83	173218.0
2011-03-23	AAXN-DELISTED	Stock	3.73	3.78	3.72	3.75	373848.0
2011-03-23	AB	Stock	21.62	21.72	21.32	21.53	269700.0
2011-03-23	ABAC-DELISTED	Stock	4.4799	4.49	4.25	4.3	25633.0
2011-03-23	ABAX-DELISTED	Stock	30.6	31.1544	29.5	29.52	178358.0
2011-03-23	ABB-DELISTED	Stock	23.5	23.61	23.3301	23.55	1543107.0
2011-03-23	ABBC-DELISTED	Stock	11.85	11.85	11.47	11.61	44723.0
2011-03-23	ABBNY-DELISTED	Stock	23.5	23.61	23.3301	23.54	1545292.0
2011-03-23	ABC-DELISTED	Stock	38.02	38.3	37.83	38.17	2364522.0
2011-03-23	ABCB	Stock	9.85	10.1	9.71	10.09	49600.0
2011-03-23	ABCD-DELISTED	Stock	3.37	3.39	3.33	3.37	17130.0
2011-03-23	ABCO-DELISTED	Stock	25.01	25.03	24.87	24.99	122981.0
2011-03-23	ABCW-DELISTED	Stock	0.9989	1.0001	0.9501	0.9611	61680.0
2011-03-23	ABD-DELISTED	Stock	8.95	9.08	8.87	9.02	682190.0
2011-03-23	ABE-DELISTED	Stock	17.81	18.1	17.81	18.1	4463.0
2011-03-23	ABEO	Stock	2375.0	2612.5	2375.0	2612.5	28.0
2011-03-23	ABFS-DELISTED	Stock	24.5	25.25	24.13	25.08	300058.0
2011-03-23	ABG	Stock	17.45	17.66	16.9	17.61	459900.0
2011-03-23	ABH-DELISTED	Stock	26.92	27.15	26.8	26.99	336570.0
2011-03-23	ABM	Stock	25.05	25.3	24.79	25.21	171900.0
2011-03-23	ABMD-DELISTED	Stock	14.35	14.6	14.26	14.39	171874.0
2011-03-23	ABR	Stock	5.74	5.92	5.7	5.76	42100.0
2011-03-23	ABT	Stock	23.0064	23.0448	22.6849	23.0256	12868487.0
2011-03-23	ABTL-DELISTED	Stock	5.55	6.15	5.55	5.85	49312.0
2011-03-23	ABUS	Stock	3.47	3.58	3.45	3.5	9000.0
2011-03-23	ABV-DELISTED	Stock	27.36	27.6	27.2	27.54	1515346.0
2011-03-23	ABVA-DELISTED	Stock	4.87	4.99	4.81	4.99	1600.0

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

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