PREVIEW / stock_daily / 2012-01-03

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-03.parquet
  size:    199 KB
  rows:    6,214
  symbols: 3,596

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-01-03	AAPL	Stock	14.6214	14.7321	14.6071	14.6868	302220800.0
2012-01-03	MSFT	Stock	26.55	26.96	26.39	26.77	64731500.0
2012-01-03	NVDA	Stock	0.3575	0.36	0.3502	0.351	468044000.0
2012-01-03	AMZN	Stock	8.7945	8.974	8.7775	8.9515	102216000.0
2012-01-03	TSLA	Stock	1.9293	1.9667	1.8433	1.872	13921500.0
2012-01-03	TLT	Stock	119.42	120.2	118.93	119.43	9076885.0
2012-01-03	ES	Stock	36.46	36.52	35.55	35.7	1301100.0
2012-01-03	CL	Stock	45.695	46.06	45.3	45.54	6347600.0
2012-01-03	A	Stock	25.6366	26.4592	25.5651	26.0944	4156394.0
2012-01-03	AABA-DELISTED	Stock	16.27	16.39	16.2	16.31	16304067.0
2012-01-03	AACC-DELISTED	Stock	4.12	4.19	4.04	4.15	9404.0
2012-01-03	AACG	Stock	7.15	7.5	7.15	7.39	2200.0
2012-01-03	AAIC-DELISTED	Stock	21.77	21.77	21.13	21.42	61617.0
2012-01-03	AAME	Stock	1.96	1.99	1.96	1.97	1400.0
2012-01-03	AAON	Stock	6.2696	6.3111	6.0711	6.1067	275400.0
2012-01-03	AAP	Stock	71.14	71.6	69.06	69.1	786600.0
2012-01-03	AAT	Stock	20.81	21.1	20.65	20.92	103700.0
2012-01-03	AATI-DELISTED	Stock	5.78	5.79	5.77	5.789	845571.0
2012-01-03	AAU-DELISTED	Stock	2.59	2.61	2.51	2.55	80709.0
2012-01-03	AAUAF-DELISTED	Stock	2.59	2.61	2.51	2.55	81509.0
2012-01-03	AAV-DELISTED	Stock	4.23	4.33	4.2	4.29	533747.0
2012-01-03	AAWW-DELISTED	Stock	39.4	39.87	38.645	38.88	278464.0
2012-01-03	AAXJ	Stock	50.84	51.49	50.84	51.24	379664.0
2012-01-03	AAXN-DELISTED	Stock	5.24	5.34	5.23	5.29	590216.0
2012-01-03	AB	Stock	13.33	13.54	13.31	13.45	417900.0
2012-01-03	ABAC-DELISTED	Stock	1.23	1.45	1.23	1.28	9485.0
2012-01-03	ABAX-DELISTED	Stock	27.75	28.37	27.74	28.22	135256.0
2012-01-03	ABB-DELISTED	Stock	19.66	19.91	19.64	19.81	3108457.0
2012-01-03	ABBNY-DELISTED	Stock	19.66	19.91	19.64	19.82	3126407.0
2012-01-03	ABC-DELISTED	Stock	37.77	38.38	37.68	38.08	1936183.0
2012-01-03	ABCB	Stock	10.5	10.7	10.34	10.57	51100.0
2012-01-03	ABCD-DELISTED	Stock	3.1	3.14	2.91	3.09	17705.0
2012-01-03	ABCO-DELISTED	Stock	37.81	38.23	36.46	36.79	169045.0
2012-01-03	ABCW-DELISTED	Stock	0.3414	0.3615	0.3414	0.3615	87560.0
2012-01-03	ABD-DELISTED	Stock	9.95	9.98	9.7	9.77	515920.0
2012-01-03	ABE-DELISTED	Stock	17.69	18.0	17.68	18.0	35001.0
2012-01-03	ABEO	Stock	1775.0	1775.0	1625.0	1750.0	14.0
2012-01-03	ABFS-DELISTED	Stock	19.9	20.18	19.3	19.37	277749.0
2012-01-03	ABG	Stock	22.04	22.19	21.53	21.71	436900.0
2012-01-03	ABH-DELISTED	Stock	14.84	15.14	14.75	14.97	227880.0
2012-01-03	ABM	Stock	21.07	21.35	20.72	20.88	283600.0
2012-01-03	ABMD-DELISTED	Stock	18.97	19.09	18.22	18.22	282243.0
2012-01-03	ABR	Stock	3.6	3.63	3.48	3.53	29700.0
2012-01-03	ABT	Stock	27.1471	27.2718	26.8976	27.2143	17693206.0
2012-01-03	ABTL-DELISTED	Stock	3.712	3.9074	3.7	3.7	11037.0
2012-01-03	ABUS	Stock	1.61	1.61	1.52	1.59	3600.0
2012-01-03	ABV-DELISTED	Stock	36.83	37.16	36.27	36.32	3246017.0
2012-01-03	ABVT-DELISTED	Stock	66.33	66.48	65.11	65.41	173352.0
2012-01-03	ABX-DELISTED	Stock	46.19	47.81	46.19	47.59	8769190.0
2012-01-03	ACAD	Stock	1.1	1.15	1.07	1.11	301900.0

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

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