PREVIEW / stock_daily / 2012-01-25

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-25.parquet
  size:    197 KB
  rows:    6,146
  symbols: 3,552

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-25	AAPL	Stock	16.23	16.2304	15.8475	15.9521	958314000.0
2012-01-25	MSFT	Stock	29.07	29.65	29.07	29.56	59231700.0
2012-01-25	NVDA	Stock	0.3635	0.3723	0.353	0.3713	1274152000.0
2012-01-25	AMZN	Stock	9.3495	9.4085	9.2305	9.39	86128000.0
2012-01-25	TSLA	Stock	1.818	1.8673	1.8033	1.8647	9168000.0
2012-01-25	TLT	Stock	116.06	118.53	115.89	116.17	12867571.0
2012-01-25	ES	Stock	34.46	34.99	34.21	34.91	1837100.0
2012-01-25	CL	Stock	43.96	44.795	43.96	44.72	4835000.0
2012-01-25	A	Stock	30.6652	31.6237	30.2575	31.5093	6512723.0
2012-01-25	AABA-DELISTED	Stock	15.6	15.705	15.46	15.56	22953700.0
2012-01-25	AACC-DELISTED	Stock	4.4	4.55	4.3	4.5	7165.0
2012-01-25	AACG	Stock	6.28	6.3	6.28	6.3	2400.0
2012-01-25	AAIC-DELISTED	Stock	23.31	23.335	23.14	23.25	28035.0
2012-01-25	AAME	Stock	2.01	2.03	2.01	2.03	200.0
2012-01-25	AAMRQ-DELISTED	Stock	0.56	0.65	0.56	0.616	21823326.0
2012-01-25	AAON	Stock	5.9407	6.0563	5.84	6.0119	138038.0
2012-01-25	AAP	Stock	74.95	76.0	74.87	75.98	491700.0
2012-01-25	AAT	Stock	21.39	21.44	21.28	21.37	135900.0
2012-01-25	AAU-DELISTED	Stock	2.41	2.6553	2.33	2.6352	397692.0
2012-01-25	AAUAF-DELISTED	Stock	2.41	2.65	2.33	2.64	400280.0
2012-01-25	AAV-DELISTED	Stock	3.61	3.71	3.54	3.71	606342.0
2012-01-25	AAWW-DELISTED	Stock	42.94	44.69	42.31	44.37	159556.0
2012-01-25	AAXJ	Stock	54.84	55.65	54.58	55.5	243353.0
2012-01-25	AAXN-DELISTED	Stock	4.84	4.84	4.8	4.83	382635.0
2012-01-25	AB	Stock	15.27	15.52	14.8	14.81	501900.0
2012-01-25	ABAC-DELISTED	Stock	1.6	1.71	1.58	1.6	30350.0
2012-01-25	ABAX-DELISTED	Stock	28.38	29.0	28.28	28.79	96019.0
2012-01-25	ABB-DELISTED	Stock	20.53	21.15	20.48	21.09	2076474.0
2012-01-25	ABBNY-DELISTED	Stock	20.53	21.15	20.48	21.08	2289698.0
2012-01-25	ABC-DELISTED	Stock	39.45	39.81	39.02	39.72	2188310.0
2012-01-25	ABCB	Stock	10.83	10.99	10.5	10.89	28500.0
2012-01-25	ABCD-DELISTED	Stock	3.2	3.25	3.16	3.21	24206.0
2012-01-25	ABCO-DELISTED	Stock	39.67	39.85	39.21	39.61	212838.0
2012-01-25	ABCW-DELISTED	Stock	0.2711	0.3062	0.2711	0.2811	98610.0
2012-01-25	ABD-DELISTED	Stock	9.77	9.82	9.581	9.77	445780.0
2012-01-25	ABE-DELISTED	Stock	18.31	18.5499	18.31	18.41	5794.0
2012-01-25	ABEO	Stock	1575.0	1625.0	1575.0	1625.0	28.0
2012-01-25	ABFS-DELISTED	Stock	21.76	22.02	21.18	21.89	408113.0
2012-01-25	ABG	Stock	23.15	23.31	22.8	23.16	297300.0
2012-01-25	ABH-DELISTED	Stock	14.75	14.75	14.414	14.5	901361.0
2012-01-25	ABM	Stock	21.56	21.82	21.4	21.72	266300.0
2012-01-25	ABMD-DELISTED	Stock	18.08	18.4	17.57	18.39	246993.0
2012-01-25	ABR	Stock	4.2	4.3	4.2	4.25	22600.0
2012-01-25	ABT	Stock	26.4994	26.6049	26.2259	26.4994	25455190.0
2012-01-25	ABTL-DELISTED	Stock	3.8475	4.0991	3.7969	4.05	28158.0
2012-01-25	ABUS	Stock	2.4	2.4	2.3	2.4	20800.0
2012-01-25	ABV-DELISTED	Stock	37.13	37.13	36.485	37.09	2195289.0
2012-01-25	ABVA-DELISTED	Stock	3.45	3.46	3.45	3.45	2600.0
2012-01-25	ABVT-DELISTED	Stock	66.75	67.0	66.21	66.83	76078.0
2012-01-25	ABX-DELISTED	Stock	45.46	48.74	45.2	48.42	12659065.0

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

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