PREVIEW / stock_daily / 2011-06-30

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-30.parquet
  size:    198 KB
  rows:    6,148
  symbols: 3,571

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-30	AAPL	Stock	11.9536	12.0046	11.8871	11.9882	322954800.0
2011-06-30	MSFT	Stock	25.74	26.0	25.66	26.0	52535400.0
2011-06-30	NVDA	Stock	0.3945	0.4028	0.3885	0.3985	652300000.0
2011-06-30	AMZN	Stock	10.039	10.26	10.025	10.2245	88962000.0
2011-06-30	TSLA	Stock	1.9	1.9553	1.8933	1.942	14200500.0
2011-06-30	TLT	Stock	94.23	94.31	93.14	94.1	11555558.0
2011-06-30	ES	Stock	35.33	35.36	35.05	35.17	1470500.0
2011-06-30	CL	Stock	43.345	43.765	43.2	43.705	3861600.0
2011-06-30	A	Stock	36.1516	37.1888	36.123	36.5594	4887268.0
2011-06-30	AABA-DELISTED	Stock	14.98	15.1	14.64	15.03	34755150.0
2011-06-30	AACC-DELISTED	Stock	3.94	4.03	3.92	4.0	27175.0
2011-06-30	AACG	Stock	9.67	10.05	9.57	10.0	8900.0
2011-06-30	AAIC-DELISTED	Stock	31.17	31.86	31.11	31.39	121576.0
2011-06-30	AAME	Stock	2.09	2.09	2.04	2.05	700.0
2011-06-30	AAON	Stock	6.5363	6.5985	6.4652	6.4711	189000.0
2011-06-30	AAP	Stock	57.96	58.91	57.96	58.49	1452200.0
2011-06-30	AAT	Stock	22.61	22.69	22.41	22.45	131600.0
2011-06-30	AATI-DELISTED	Stock	6.04	6.065	6.04	6.055	410432.0
2011-06-30	AAU-DELISTED	Stock	3.32	3.3885	3.29	3.31	110591.0
2011-06-30	AAUAF-DELISTED	Stock	3.32	3.3885	3.29	3.31	111491.0
2011-06-30	AAV-DELISTED	Stock	7.98	8.03	7.93	7.93	198396.0
2011-06-30	AAWW-DELISTED	Stock	59.21	60.01	58.928	59.52	79139.0
2011-06-30	AAXJ	Stock	61.4	62.06	61.34	62.01	258035.0
2011-06-30	AAXN-DELISTED	Stock	4.48	4.55	4.45	4.55	248211.0
2011-06-30	AB	Stock	19.59	19.75	19.38	19.44	371800.0
2011-06-30	ABAC-DELISTED	Stock	2.3099	2.4	2.27	2.37	13900.0
2011-06-30	ABAX-DELISTED	Stock	27.55	27.6	27.21	27.25	216044.0
2011-06-30	ABB-DELISTED	Stock	25.66	26.02	25.63	25.94	2944925.0
2011-06-30	ABBC-DELISTED	Stock	10.4	10.55	10.35	10.45	129876.0
2011-06-30	ABBNY-DELISTED	Stock	25.66	26.02	25.63	25.95	2947193.0
2011-06-30	ABC-DELISTED	Stock	41.28	41.655	41.23	41.4	1969352.0
2011-06-30	ABCB	Stock	8.8	8.93	8.8	8.87	28000.0
2011-06-30	ABCD-DELISTED	Stock	3.43	3.43	3.32	3.39	28045.0
2011-06-30	ABCO-DELISTED	Stock	29.32	29.32	28.87	28.95	80927.0
2011-06-30	ABCW-DELISTED	Stock	0.74	0.7401	0.7	0.71	13800.0
2011-06-30	ABD-DELISTED	Stock	7.74	7.9	7.73	7.84	169440.0
2011-06-30	ABE-DELISTED	Stock	18.74	18.93	18.74	18.79	2033.0
2011-06-30	ABEO	Stock	2337.5	2562.5	2250.0	2562.5	31.0
2011-06-30	ABFS-DELISTED	Stock	23.58	23.82	23.37	23.73	392758.0
2011-06-30	ABG	Stock	18.48	18.71	18.17	18.53	196700.0
2011-06-30	ABH-DELISTED	Stock	20.1	20.44	20.0	20.28	1348814.0
2011-06-30	ABM	Stock	23.47	23.55	23.28	23.34	229700.0
2011-06-30	ABMD-DELISTED	Stock	16.04	16.59	15.89	16.19	192683.0
2011-06-30	ABR	Stock	4.68	4.72	4.66	4.68	26100.0
2011-06-30	ABT	Stock	25.3047	25.3286	25.1031	25.2471	12069404.0
2011-06-30	ABTL-DELISTED	Stock	5.7	5.95	5.5005	5.65	32437.0
2011-06-30	ABUS	Stock	2.64	2.64	2.5	2.51	11000.0
2011-06-30	ABV-DELISTED	Stock	33.65	33.8	33.45	33.73	2065100.0
2011-06-30	ABVA-DELISTED	Stock	4.94	5.001	4.9	4.9	4660.0
2011-06-30	ABVT-DELISTED	Stock	69.36	71.36	69.08	70.39	302467.0

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

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