PREVIEW / stock_daily / 2012-03-26

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-26.parquet
  size:    201 KB
  rows:    6,220
  symbols: 3,578

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-03-26	AAPL	Stock	21.4211	21.6839	21.2593	21.6779	595742000.0
2012-03-26	MSFT	Stock	32.19	32.61	32.15	32.59	36758300.0
2012-03-26	NVDA	Stock	0.3672	0.3698	0.3638	0.368	288600000.0
2012-03-26	AMZN	Stock	9.824	10.1485	9.775	10.1435	152274000.0
2012-03-26	TSLA	Stock	2.3727	2.5393	2.336	2.4933	47107500.0
2012-03-26	TLT	Stock	112.83	113.01	111.8	112.63	8118600.0
2012-03-26	ES	Stock	36.93	37.19	36.88	37.14	1598900.0
2012-03-26	CL	Stock	48.115	48.42	48.045	48.405	3088800.0
2012-03-26	A	Stock	32.0959	32.2747	31.9242	32.2246	4847006.0
2012-03-26	AABA-DELISTED	Stock	15.48	15.56	15.36	15.54	10816451.0
2012-03-26	AACC-DELISTED	Stock	4.73	4.95	4.6101	4.79	14970.0
2012-03-26	AACG	Stock	6.81	6.81	6.45	6.61	4200.0
2012-03-26	AAIC-DELISTED	Stock	22.96	23.0	22.68	22.82	144540.0
2012-03-26	AAME	Stock	2.79	2.82	2.5	2.78	13600.0
2012-03-26	AAMRQ-DELISTED	Stock	0.498	0.5	0.48	0.492	1361613.0
2012-03-26	AAON	Stock	6.3556	6.4741	6.2548	6.3348	240638.0
2012-03-26	AAP	Stock	89.58	90.4	89.54	90.33	481300.0
2012-03-26	AAT	Stock	23.18	23.31	22.84	22.99	108500.0
2012-03-26	AAU-DELISTED	Stock	2.65	2.7	2.55	2.68	103961.0
2012-03-26	AAUAF-DELISTED	Stock	2.65	2.7	2.55	2.68	104661.0
2012-03-26	AAV-DELISTED	Stock	3.52	3.54	3.35	3.39	633795.0
2012-03-26	AAWW-DELISTED	Stock	49.59	50.59	49.4	50.23	220411.0
2012-03-26	AAXJ	Stock	56.74	57.06	56.63	57.03	720705.0
2012-03-26	AAXN-DELISTED	Stock	4.38	4.5	4.35	4.42	432545.0
2012-03-26	AB	Stock	15.5	15.9	15.36	15.8	296200.0
2012-03-26	ABAC-DELISTED	Stock	1.68	1.7	1.62	1.63	14014.0
2012-03-26	ABAX-DELISTED	Stock	28.74	29.58	28.62	29.54	116996.0
2012-03-26	ABB-DELISTED	Stock	20.56	20.66	20.5	20.62	2495802.0
2012-03-26	ABBNY-DELISTED	Stock	20.56	20.66	20.5	20.61	2498496.0
2012-03-26	ABC-DELISTED	Stock	39.15	39.6	39.01	39.6	2316075.0
2012-03-26	ABCB	Stock	13.44	13.45	13.28	13.32	68000.0
2012-03-26	ABCD-DELISTED	Stock	2.88	2.95	2.71	2.86	18212.0
2012-03-26	ABCO-DELISTED	Stock	43.28	44.7	43.27	44.63	213592.0
2012-03-26	ABCW-DELISTED	Stock	0.7229	0.753	0.6526	0.733	43050.0
2012-03-26	ABD-DELISTED	Stock	12.62	12.76	12.55	12.7	447880.0
2012-03-26	ABE-DELISTED	Stock	19.24	19.3555	19.19	19.3	17836.0
2012-03-26	ABEO	Stock	1350.0	1462.5	1350.0	1437.5	16.0
2012-03-26	ABFS-DELISTED	Stock	19.26	19.45	18.91	19.05	264801.0
2012-03-26	ABG	Stock	26.85	28.24	26.75	28.23	324200.0
2012-03-26	ABH-DELISTED	Stock	15.16	15.36	14.84	14.89	141149.0
2012-03-26	ABM	Stock	23.98	24.5	23.88	24.5	398400.0
2012-03-26	ABMD-DELISTED	Stock	23.12	23.8	22.9	23.53	316661.0
2012-03-26	ABR	Stock	5.69	5.89	5.68	5.85	78300.0
2012-03-26	ABT	Stock	29.0807	29.263	29.0711	29.263	15347020.0
2012-03-26	ABTL-DELISTED	Stock	4.8005	4.9455	4.751	4.85	4192.0
2012-03-26	ABUS	Stock	2.41	2.44	2.36	2.44	6000.0
2012-03-26	ABV-DELISTED	Stock	42.77	44.12	42.72	44.12	3012347.0
2012-03-26	ABVA-DELISTED	Stock	4.02	4.2	3.89	3.89	4142.0
2012-03-26	ABVT-DELISTED	Stock	83.57	83.58	82.93	83.37	1179444.0
2012-03-26	ABX-DELISTED	Stock	44.75	44.84	43.97	44.49	7298799.0

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

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