PREVIEW / stock_daily / 2012-04-05

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-05.parquet
  size:    197 KB
  rows:    6,118
  symbols: 3,499

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-04-05	AAPL	Stock	22.3921	22.6664	22.2643	22.6314	641298000.0
2012-04-05	MSFT	Stock	31.15	31.63	31.05	31.52	50368600.0
2012-04-05	NVDA	Stock	0.3668	0.3713	0.3645	0.3658	369424000.0
2012-04-05	AMZN	Stock	9.6775	9.8015	9.6775	9.7195	64350000.0
2012-04-05	TSLA	Stock	2.34	2.3627	2.294	2.2987	22641000.0
2012-04-05	TLT	Stock	113.0	113.07	112.33	112.91	6364219.0
2012-04-05	ES	Stock	37.03	37.21	36.61	36.89	3767500.0
2012-04-05	CL	Stock	48.9	49.14	48.64	49.08	4318800.0
2012-04-05	A	Stock	31.2303	32.1745	31.1588	32.0243	6933381.0
2012-04-05	AABA-DELISTED	Stock	15.14	15.26	15.0	15.07	11516281.0
2012-04-05	AACC-DELISTED	Stock	4.84	4.99	4.75	4.92	20045.0
2012-04-05	AACG	Stock	6.66	7.43	6.66	6.83	4100.0
2012-04-05	AAIC-DELISTED	Stock	22.69	22.93	22.67	22.84	109509.0
2012-04-05	AAME	Stock	2.92	2.92	2.86	2.88	1600.0
2012-04-05	AAMRQ-DELISTED	Stock	0.49	0.5	0.485	0.496	893097.0
2012-04-05	AAON	Stock	5.8281	5.8785	5.8193	5.8578	86400.0
2012-04-05	AAP	Stock	89.39	90.45	89.38	90.2	584400.0
2012-04-05	AAT	Stock	22.94	23.2	22.89	23.19	67500.0
2012-04-05	AAU-DELISTED	Stock	2.5	2.5	2.3352	2.35	200414.0
2012-04-05	AAUAF-DELISTED	Stock	2.51	2.51	2.34	2.34	200606.0
2012-04-05	AAV-DELISTED	Stock	3.2	3.2	3.05	3.07	268896.0
2012-04-05	AAWW-DELISTED	Stock	48.21	48.97	48.1675	48.85	290780.0
2012-04-05	AAXJ	Stock	56.09	56.6	56.09	56.45	274988.0
2012-04-05	AAXN-DELISTED	Stock	4.15	4.199	4.04	4.09	317373.0
2012-04-05	AB	Stock	15.25	15.42	15.03	15.03	166300.0
2012-04-05	ABAC-DELISTED	Stock	1.6101	1.67	1.61	1.65	10050.0
2012-04-05	ABAX-DELISTED	Stock	28.27	28.32	27.8	28.18	65177.0
2012-04-05	ABB-DELISTED	Stock	19.69	19.95	19.6701	19.93	1734353.0
2012-04-05	ABBNY-DELISTED	Stock	19.69	19.95	19.6701	19.92	1735958.0
2012-04-05	ABC-DELISTED	Stock	38.28	38.54	38.2	38.23	2417441.0
2012-04-05	ABCB	Stock	12.86	13.07	12.83	13.0	28000.0
2012-04-05	ABCD-DELISTED	Stock	2.54	2.56	2.4	2.45	13001.0
2012-04-05	ABCO-DELISTED	Stock	42.61	43.3	42.52	42.76	291449.0
2012-04-05	ABCW-DELISTED	Stock	0.8534	0.984	0.8534	0.984	3410.0
2012-04-05	ABD-DELISTED	Stock	12.03	12.23	11.94	12.03	593040.0
2012-04-05	ABE-DELISTED	Stock	19.21	19.89	19.21	19.43	9880.0
2012-04-05	ABEO	Stock	1387.5	1462.5	1387.5	1462.5	35.0
2012-04-05	ABFS-DELISTED	Stock	19.11	19.3625	18.9	19.26	190960.0
2012-04-05	ABG	Stock	28.21	28.35	27.73	27.8	350400.0
2012-04-05	ABH-DELISTED	Stock	13.8	13.88	13.73	13.86	212657.0
2012-04-05	ABM	Stock	23.68	24.06	23.66	24.04	242300.0
2012-04-05	ABMD-DELISTED	Stock	21.37	21.7	21.3	21.48	198931.0
2012-04-05	ABR	Stock	5.19	5.19	5.08	5.12	51200.0
2012-04-05	ABT	Stock	29.4549	29.5029	29.3158	29.4117	12295748.0
2012-04-05	ABTL-DELISTED	Stock	4.645	4.7699	4.645	4.705	15084.0
2012-04-05	ABV-DELISTED	Stock	40.73	40.85	40.32	40.56	3845100.0
2012-04-05	ABVA-DELISTED	Stock	4.06	4.06	4.06	4.06	200.0
2012-04-05	ABVT-DELISTED	Stock	82.86	83.042	82.86	82.94	318632.0
2012-04-05	ABX-DELISTED	Stock	41.43	41.58	40.41	40.72	9029092.0
2012-04-05	ACAD	Stock	1.89	1.9	1.76	1.82	835900.0

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

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