PREVIEW / stock_daily / 2012-09-25

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-25.parquet
  size:    201 KB
  rows:    6,190
  symbols: 3,513

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-09-25	AAPL	Stock	24.5807	24.7421	24.0357	24.055	518789600.0
2012-09-25	MSFT	Stock	30.95	31.0	30.36	30.39	54266400.0
2012-09-25	NVDA	Stock	0.346	0.3475	0.3348	0.3353	481544000.0
2012-09-25	AMZN	Stock	12.8165	12.9475	12.5515	12.623	88116000.0
2012-09-25	META	Stock	21.2	21.21	20.22	20.28	46291700.0
2012-09-25	TSLA	Stock	1.908	1.9653	1.8353	1.844	85206000.0
2012-09-25	TLT	Stock	122.8	123.74	122.13	123.71	5894556.0
2012-09-25	ES	Stock	38.03	38.33	37.96	38.04	1647000.0
2012-09-25	CL	Stock	53.655	53.905	53.315	53.325	3584000.0
2012-09-25	A	Stock	27.7969	27.8469	27.4034	27.4106	4954093.0
2012-09-25	AABA-DELISTED	Stock	16.09	16.09	15.67	15.685	22667507.0
2012-09-25	AACC-DELISTED	Stock	7.41	7.6	7.41	7.54	20321.0
2012-09-25	AACG	Stock	4.85	4.85	4.79	4.79	1000.0
2012-09-25	AAIC-DELISTED	Stock	25.08	25.2	24.91	25.03	605153.0
2012-09-25	AAME	Stock	2.64	2.75	2.59	2.75	13200.0
2012-09-25	AAMRQ-DELISTED	Stock	0.41	0.415	0.4015	0.405	751105.0
2012-09-25	AAON	Stock	6.0444	6.0444	5.76	5.8074	254138.0
2012-09-25	AAP	Stock	68.13	68.26	67.53	67.53	790400.0
2012-09-25	AAT	Stock	27.27	27.33	26.83	26.83	200300.0
2012-09-25	AAU-DELISTED	Stock	2.83	2.85	2.65	2.72	258163.0
2012-09-25	AAUAF-DELISTED	Stock	2.83	2.85	2.65	2.75	264558.0
2012-09-25	AAV-DELISTED	Stock	3.83	3.84	3.73	3.75	142028.0
2012-09-25	AAWW-DELISTED	Stock	55.97	55.97	52.4	52.5	364357.0
2012-09-25	AAXJ	Stock	56.26	56.5101	55.59	55.59	202431.0
2012-09-25	AAXN-DELISTED	Stock	5.63	5.9	5.61	5.825	698325.0
2012-09-25	AB	Stock	15.88	15.99	15.68	15.73	196200.0
2012-09-25	ABAC-DELISTED	Stock	1.23	1.3	1.14	1.3	16151.0
2012-09-25	ABAX-DELISTED	Stock	36.01	37.55	36.01	36.35	178442.0
2012-09-25	ABB-DELISTED	Stock	19.38	19.42	19.03	19.031	1329448.0
2012-09-25	ABBNY-DELISTED	Stock	19.38	19.42	19.03	19.03	1467323.0
2012-09-25	ABC-DELISTED	Stock	39.36	39.385	38.7	38.83	3215802.0
2012-09-25	ABCB	Stock	12.92	13.03	12.64	12.67	53500.0
2012-09-25	ABCD-DELISTED	Stock	0.99	1.05	0.97	1.05	15650.0
2012-09-25	ABCO-DELISTED	Stock	46.88	47.87	46.59	46.87	188987.0
2012-09-25	ABCW-DELISTED	Stock	0.4	0.41	0.38	0.38	29215.0
2012-09-25	ABE-DELISTED	Stock	20.46	20.55	20.259	20.259	6850.0
2012-09-25	ABEO	Stock	562.5	562.5	500.0	562.5	44.0
2012-09-25	ABFS-DELISTED	Stock	7.95	7.98	7.74	7.87	496866.0
2012-09-25	ABG	Stock	28.31	28.51	27.95	27.99	253600.0
2012-09-25	ABM	Stock	18.88	19.16	18.85	18.93	666100.0
2012-09-25	ABMD-DELISTED	Stock	21.75	22.7	21.4	22.24	764671.0
2012-09-25	ABR	Stock	6.16	6.25	6.03	6.05	63300.0
2012-09-25	ABT	Stock	33.49	33.7827	33.3701	33.3797	14805336.0
2012-09-25	ABTL-DELISTED	Stock	3.65	3.73	3.56	3.7	35602.0
2012-09-25	ABUS	Stock	4.0	4.0	3.96	3.98	8400.0
2012-09-25	ABV-DELISTED	Stock	38.63	38.785	38.14	38.17	1641614.0
2012-09-25	ABVA-DELISTED	Stock	4.65	4.65	4.65	4.65	100.0
2012-09-25	ABX-DELISTED	Stock	41.98	42.26	40.92	40.96	8435143.0
2012-09-25	ACAD	Stock	2.73	2.75	2.51	2.53	1715700.0
2012-09-25	ACAS-DELISTED	Stock	11.73	11.81	11.51	11.52	1869704.0

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

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