PREVIEW / stock_daily / 2012-06-27

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-27.parquet
  size:    197 KB
  rows:    6,158
  symbols: 3,524

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
2012-06-27	AAPL	Stock	20.5357	20.5979	20.4257	20.5179	202997200.0
2012-06-27	MSFT	Stock	30.19	30.5	30.03	30.17	33781700.0
2012-06-27	NVDA	Stock	0.3185	0.3308	0.3185	0.3285	506064000.0
2012-06-27	AMZN	Stock	11.2505	11.375	11.165	11.281	55984000.0
2012-06-27	META	Stock	32.46	32.9	31.9	32.23	28568000.0
2012-06-27	TSLA	Stock	2.1267	2.1633	2.1047	2.1307	15708000.0
2012-06-27	TLT	Stock	126.56	126.788	126.032	126.54	5860922.0
2012-06-27	ES	Stock	38.13	38.43	38.12	38.33	1314300.0
2012-06-27	CL	Stock	50.14	50.8	50.135	50.75	2985600.0
2012-06-27	A	Stock	27.4964	27.6681	27.289	27.432	2155436.0
2012-06-27	AABA-DELISTED	Stock	15.41	15.63	15.38	15.53	11139095.0
2012-06-27	AACC-DELISTED	Stock	6.28	6.79	6.1801	6.76	56775.0
2012-06-27	AACG	Stock	4.18	4.18	4.1	4.1	1900.0
2012-06-27	AAIC-DELISTED	Stock	21.69	21.83	21.52	21.55	137855.0
2012-06-27	AAME	Stock	2.7	2.7	2.55	2.7	2300.0
2012-06-27	AAMRQ-DELISTED	Stock	0.525	0.565	0.525	0.55	4584386.0
2012-06-27	AAON	Stock	5.5022	5.5704	5.4044	5.4756	412763.0
2012-06-27	AAP	Stock	60.87	66.02	60.87	65.59	3743900.0
2012-06-27	AAT	Stock	23.48	23.67	23.38	23.55	153300.0
2012-06-27	AAU-DELISTED	Stock	2.15	2.16	2.05	2.06	71059.0
2012-06-27	AAUAF-DELISTED	Stock	2.15	2.16	2.05	2.06	71259.0
2012-06-27	AAV-DELISTED	Stock	2.56	2.8	2.55	2.74	182651.0
2012-06-27	AAWW-DELISTED	Stock	40.83	41.54	40.36	41.41	116461.0
2012-06-27	AAXJ	Stock	51.01	51.27	50.97	51.18	214075.0
2012-06-27	AAXN-DELISTED	Stock	5.38	5.39	5.16	5.21	403543.0
2012-06-27	AB	Stock	12.08	12.62	12.04	12.42	288100.0
2012-06-27	ABAC-DELISTED	Stock	1.1699	1.17	1.14	1.14	12166.0
2012-06-27	ABAX-DELISTED	Stock	35.06	35.24	34.76	35.07	113005.0
2012-06-27	ABB-DELISTED	Stock	15.46	15.61	15.4	15.54	2816987.0
2012-06-27	ABBNY-DELISTED	Stock	15.46	15.61	15.4	15.53	2853027.0
2012-06-27	ABC-DELISTED	Stock	37.66	38.2	37.58	38.12	1638201.0
2012-06-27	ABCB	Stock	12.02	12.25	11.98	12.23	21200.0
2012-06-27	ABCD-DELISTED	Stock	1.01	1.01	0.96	0.9712	45599.0
2012-06-27	ABCO-DELISTED	Stock	47.98	48.84	47.87	48.66	263400.0
2012-06-27	ABCW-DELISTED	Stock	0.45	0.46	0.45	0.45	11298.0
2012-06-27	ABE-DELISTED	Stock	18.18	18.27	18.14	18.27	5029.0
2012-06-27	ABEO	Stock	812.5	875.0	812.5	875.0	20.0
2012-06-27	ABFS-DELISTED	Stock	11.83	12.27	11.81	12.03	208922.0
2012-06-27	ABG	Stock	22.16	22.56	21.93	22.43	419900.0
2012-06-27	ABM	Stock	19.91	20.21	19.89	20.17	210700.0
2012-06-27	ABMD-DELISTED	Stock	21.06	21.9	20.58	21.87	508175.0
2012-06-27	ABR	Stock	5.19	5.36	5.18	5.33	82600.0
2012-06-27	ABT	Stock	29.9875	30.285	29.9683	30.165	7436015.0
2012-06-27	ABTL-DELISTED	Stock	3.8126	3.8613	3.5884	3.7374	15068.0
2012-06-27	ABUS	Stock	2.0	2.05	2.0	2.05	20100.0
2012-06-27	ABV-DELISTED	Stock	37.03	37.09	36.32	36.5	2594058.0
2012-06-27	ABVA-DELISTED	Stock	4.28	4.335	4.28	4.335	600.0
2012-06-27	ABVT-DELISTED	Stock	83.96	83.96	83.95	83.96	63776.0
2012-06-27	ABX-DELISTED	Stock	36.96	37.05	36.23	36.59	7452458.0
2012-06-27	ACAD	Stock	1.54	1.65	1.53	1.62	420100.0

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

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