PREVIEW / stock_daily / 2011-04-01

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-01.parquet
  size:    198 KB
  rows:    6,088
  symbols: 3,550

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-04-01	AAPL	Stock	12.5396	12.5568	12.2607	12.3057	418661600.0
2011-04-01	MSFT	Stock	25.53	25.53	25.31	25.48	63114200.0
2011-04-01	NVDA	Stock	0.4675	0.468	0.4488	0.455	850072000.0
2011-04-01	AMZN	Stock	9.079	9.1625	8.9295	9.0065	113682000.0
2011-04-01	TSLA	Stock	1.83	1.8787	1.7713	1.7773	42972000.0
2011-04-01	TLT	Stock	91.5	92.27	91.42	92.19	7860305.0
2011-04-01	ES	Stock	34.74	35.03	34.69	34.88	929300.0
2011-04-01	CL	Stock	40.5	40.67	40.16	40.26	4520800.0
2011-04-01	A	Stock	32.103	32.5322	32.0315	32.289	3092795.0
2011-04-01	AABA-DELISTED	Stock	16.84	16.975	16.72	16.83	12078614.0
2011-04-01	AACC-DELISTED	Stock	5.43	5.43	5.34	5.35	20605.0
2011-04-01	AACG	Stock	7.9	7.99	7.9	7.99	600.0
2011-04-01	AAI-DELISTED	Stock	7.44	7.47	7.43	7.46	2888569.0
2011-04-01	AAIC-DELISTED	Stock	30.5	30.7555	30.4	30.53	34893.0
2011-04-01	AAME	Stock	2.16	2.18	2.16	2.18	300.0
2011-04-01	AAON	Stock	6.477	6.5047	6.3348	6.3467	203006.0
2011-04-01	AAP	Stock	65.98	66.39	65.73	66.16	571100.0
2011-04-01	AAT	Stock	21.3	21.88	21.27	21.67	737700.0
2011-04-01	AATI-DELISTED	Stock	3.79	3.87	3.7	3.74	99239.0
2011-04-01	AAU-DELISTED	Stock	4.053	4.053	3.87	3.8767	212661.0
2011-04-01	AAUAF-DELISTED	Stock	4.05	4.05	3.87	3.88	213322.0
2011-04-01	AAV-DELISTED	Stock	9.02	9.1	8.98	9.05	353391.0
2011-04-01	AAWW-DELISTED	Stock	70.0	70.0	67.56	68.9	220283.0
2011-04-01	AAXJ	Stock	63.5	64.28	63.48	64.13	2699407.0
2011-04-01	AAXN-DELISTED	Stock	4.09	4.19	3.985	4.03	403909.0
2011-04-01	AB	Stock	22.0	22.3	21.91	22.19	260900.0
2011-04-01	ABAC-DELISTED	Stock	4.2	4.25	4.1501	4.17	33886.0
2011-04-01	ABAX-DELISTED	Stock	28.92	29.13	28.8	28.87	143809.0
2011-04-01	ABB-DELISTED	Stock	24.25	24.67	24.15	24.63	2875086.0
2011-04-01	ABBC-DELISTED	Stock	12.32	12.49	12.2	12.29	75517.0
2011-04-01	ABBNY-DELISTED	Stock	24.26	24.67	24.15	24.65	3034591.0
2011-04-01	ABC-DELISTED	Stock	39.75	40.56	39.7	40.34	4151242.0
2011-04-01	ABCB	Stock	10.18	10.25	10.1	10.16	56500.0
2011-04-01	ABCD-DELISTED	Stock	3.43	3.43	3.16	3.41	13675.0
2011-04-01	ABCO-DELISTED	Stock	25.83	25.88	25.25	25.35	104710.0
2011-04-01	ABCW-DELISTED	Stock	1.01	1.01	0.97	0.99	23500.0
2011-04-01	ABD-DELISTED	Stock	9.59	9.79	9.42	9.63	611990.0
2011-04-01	ABE-DELISTED	Stock	18.87	18.91	18.79	18.81	65638.0
2011-04-01	ABEO	Stock	2775.0	2775.0	2750.0	2775.0	6.0
2011-04-01	ABFS-DELISTED	Stock	26.09	26.33	25.81	25.99	321523.0
2011-04-01	ABG	Stock	18.69	19.03	18.45	18.66	294300.0
2011-04-01	ABH-DELISTED	Stock	27.17	27.185	26.74	26.85	224836.0
2011-04-01	ABM	Stock	25.52	25.59	25.21	25.37	315700.0
2011-04-01	ABMD-DELISTED	Stock	14.19	14.7	14.04	14.65	227223.0
2011-04-01	ABR	Stock	5.7	5.71	5.53	5.56	77500.0
2011-04-01	ABT	Stock	23.5822	23.7021	23.5342	23.6877	13283035.0
2011-04-01	ABTL-DELISTED	Stock	7.148	7.401	6.8438	7.3	62166.0
2011-04-01	ABUS	Stock	3.15	3.23	3.14	3.16	14500.0
2011-04-01	ABV-DELISTED	Stock	28.57	29.39	28.41	29.14	2445127.0
2011-04-01	ABVT-DELISTED	Stock	64.99	66.2	64.82	66.05	86490.0

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

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