PREVIEW / stock_daily / 2012-10-16

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-16.parquet
  size:    200 KB
  rows:    6,181
  symbols: 3,495

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-10-16	AAPL	Stock	22.6918	23.225	22.5357	23.2068	549771600.0
2012-10-16	MSFT	Stock	29.45	29.74	29.32	29.49	47739400.0
2012-10-16	NVDA	Stock	0.3225	0.33	0.3195	0.329	367696000.0
2012-10-16	AMZN	Stock	12.2435	12.2885	12.104	12.197	44082000.0
2012-10-16	META	Stock	19.68	19.69	19.3	19.48	21834700.0
2012-10-16	TSLA	Stock	1.8447	1.8727	1.8227	1.8707	7189500.0
2012-10-16	TLT	Stock	122.9	122.94	121.94	121.9803	5398643.0
2012-10-16	ES	Stock	39.24	39.49	38.93	39.1	952100.0
2012-10-16	CL	Stock	54.375	54.415	54.05	54.295	2413600.0
2012-10-16	A	Stock	26.8026	27.1674	26.7883	27.1173	3280407.0
2012-10-16	AABA-DELISTED	Stock	15.82	15.98	15.76	15.93	20125879.0
2012-10-16	AACC-DELISTED	Stock	7.96	8.0	7.58	7.72	16294.0
2012-10-16	AACG	Stock	5.04	5.16	4.98	4.98	2500.0
2012-10-16	AAIC-DELISTED	Stock	22.14	22.2	22.0292	22.12	102028.0
2012-10-16	AAME	Stock	2.75	2.82	2.63	2.8	5000.0
2012-10-16	AAMRQ-DELISTED	Stock	0.3755	0.3825	0.3725	0.3725	1018000.0
2012-10-16	AAON	Stock	5.6415	5.7689	5.5644	5.7363	354038.0
2012-10-16	AAP	Stock	67.52	68.81	67.34	68.17	744700.0
2012-10-16	AAT	Stock	27.84	28.29	27.84	28.22	146400.0
2012-10-16	AAU-DELISTED	Stock	2.51	2.55	2.5	2.5	75243.0
2012-10-16	AAUAF-DELISTED	Stock	2.51	2.55	2.5	2.5	75443.0
2012-10-16	AAV-DELISTED	Stock	3.85	3.88	3.82	3.86	68206.0
2012-10-16	AAWW-DELISTED	Stock	51.78	53.06	51.404	52.89	95309.0
2012-10-16	AAXJ	Stock	56.76	57.0699	56.67	57.01	285893.0
2012-10-16	AAXN-DELISTED	Stock	6.1	6.24	6.0817	6.21	451160.0
2012-10-16	AB	Stock	15.98	16.34	15.98	16.34	246700.0
2012-10-16	ABAC-DELISTED	Stock	1.3	1.39	1.3	1.32	2000.0
2012-10-16	ABAX-DELISTED	Stock	36.39	37.13	36.255	37.05	74999.0
2012-10-16	ABB-DELISTED	Stock	19.18	19.3	19.15	19.29	1126240.0
2012-10-16	ABBNY-DELISTED	Stock	19.18	19.3	19.15	19.28	1141334.0
2012-10-16	ABC-DELISTED	Stock	39.92	40.85	39.91	40.75	3449767.0
2012-10-16	ABCB	Stock	12.52	12.54	12.27	12.35	22700.0
2012-10-16	ABCD-DELISTED	Stock	0.9712	1.03	0.97	1.01	6194.0
2012-10-16	ABCO-DELISTED	Stock	48.6	48.7	48.03	48.49	68133.0
2012-10-16	ABCW-DELISTED	Stock	0.3899	0.405	0.3899	0.4	33409.0
2012-10-16	ABE-DELISTED	Stock	20.7	20.75	20.7	20.742	4060.0
2012-10-16	ABEO	Stock	437.5	475.0	425.0	450.0	45.0
2012-10-16	ABFS-DELISTED	Stock	8.3	8.35	8.15	8.21	199742.0
2012-10-16	ABG	Stock	30.0	30.16	29.9	30.0	148900.0
2012-10-16	ABM	Stock	18.17	18.54	18.05	18.51	391800.0
2012-10-16	ABMD-DELISTED	Stock	20.6	21.02	20.37	21.0	379262.0
2012-10-16	ABR	Stock	5.59	5.59	5.5	5.56	208800.0
2012-10-16	ABT	Stock	34.5936	34.7711	34.2961	34.608	14045852.0
2012-10-16	ABTL-DELISTED	Stock	3.84	3.84	3.8	3.83	500.0
2012-10-16	ABUS	Stock	3.97	3.97	3.94	3.94	14300.0
2012-10-16	ABV-DELISTED	Stock	40.95	41.24	40.77	41.0	2779749.0
2012-10-16	ABX-DELISTED	Stock	39.32	39.89	39.0	39.82	7172517.0
2012-10-16	ACAD	Stock	2.4	2.46	2.35	2.44	1095900.0
2012-10-16	ACAS-DELISTED	Stock	11.47	11.7	11.45	11.6	3394970.0
2012-10-16	ACAT-DELISTED	Stock	39.35	39.86	39.07	39.82	53699.0

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

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