PREVIEW / stock_daily / 2012-01-04

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-04.parquet
  size:    196 KB
  rows:    6,119
  symbols: 3,533

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-04	AAPL	Stock	14.6429	14.81	14.6171	14.7657	260022000.0
2012-01-04	MSFT	Stock	26.82	27.47	26.78	27.4	80516100.0
2012-01-04	NVDA	Stock	0.3513	0.3565	0.348	0.355	347372000.0
2012-01-04	AMZN	Stock	8.9605	9.025	8.8035	8.8755	84104000.0
2012-01-04	TSLA	Stock	1.8807	1.9113	1.8333	1.8473	9451500.0
2012-01-04	TLT	Stock	119.26	119.28	117.68	118.01	8417068.0
2012-01-04	ES	Stock	35.57	35.68	35.02	35.07	2760400.0
2012-01-04	CL	Stock	45.5	45.54	45.065	45.3	4350200.0
2012-01-04	A	Stock	25.8584	26.0086	25.4578	25.887	4651845.0
2012-01-04	AABA-DELISTED	Stock	16.11	16.16	15.74	15.76	34329165.0
2012-01-04	AACC-DELISTED	Stock	4.08	4.14	4.04	4.12	7754.0
2012-01-04	AACG	Stock	7.25	7.59	7.25	7.39	1100.0
2012-01-04	AAIC-DELISTED	Stock	21.44	21.44	20.67	20.8	78290.0
2012-01-04	AAME	Stock	1.96	1.96	1.96	1.96	400.0
2012-01-04	AAON	Stock	6.0563	6.2844	5.997	6.0563	182250.0
2012-01-04	AAP	Stock	69.0	71.1	68.79	70.72	1412800.0
2012-01-04	AAT	Stock	20.76	21.02	20.24	20.25	93600.0
2012-01-04	AATI-DELISTED	Stock	5.78	5.79	5.78	5.79	225362.0
2012-01-04	AAU-DELISTED	Stock	2.56	2.58	2.49	2.51	105445.0
2012-01-04	AAUAF-DELISTED	Stock	2.56	2.58	2.49	2.51	106045.0
2012-01-04	AAV-DELISTED	Stock	4.29	4.39	4.23	4.38	389773.0
2012-01-04	AAWW-DELISTED	Stock	38.61	39.56	38.61	39.28	166631.0
2012-01-04	AAXJ	Stock	50.74	50.97	50.53	50.87	314404.0
2012-01-04	AAXN-DELISTED	Stock	5.27	5.33	5.15	5.15	240079.0
2012-01-04	AB	Stock	13.48	14.29	13.45	14.1	560800.0
2012-01-04	ABAC-DELISTED	Stock	1.32	1.36	1.2901	1.33	13135.0
2012-01-04	ABAX-DELISTED	Stock	28.01	29.03	27.9301	28.08	54779.0
2012-01-04	ABB-DELISTED	Stock	19.56	19.78	19.42	19.72	2137303.0
2012-01-04	ABBNY-DELISTED	Stock	19.56	19.78	19.42	19.71	2215223.0
2012-01-04	ABC-DELISTED	Stock	38.06	38.32	37.75	38.2	1601802.0
2012-01-04	ABCB	Stock	10.47	10.54	10.22	10.36	47000.0
2012-01-04	ABCD-DELISTED	Stock	3.07	3.43	3.0	3.07	16355.0
2012-01-04	ABCO-DELISTED	Stock	36.75	38.0	36.59	37.76	184938.0
2012-01-04	ABCW-DELISTED	Stock	0.3615	0.3615	0.3615	0.3615	18130.0
2012-01-04	ABD-DELISTED	Stock	9.65	9.73	9.56	9.67	237220.0
2012-01-04	ABE-DELISTED	Stock	17.94	18.23	17.46	17.79	12291.0
2012-01-04	ABEO	Stock	1750.0	1775.0	1625.0	1750.0	5.0
2012-01-04	ABFS-DELISTED	Stock	19.23	19.89	19.17	19.72	361071.0
2012-01-04	ABG	Stock	21.56	21.84	21.4	21.5	280600.0
2012-01-04	ABH-DELISTED	Stock	14.98	15.19	14.91	15.12	327171.0
2012-01-04	ABM	Stock	20.69	20.89	20.45	20.62	182900.0
2012-01-04	ABMD-DELISTED	Stock	18.12	18.5	17.96	18.1	166263.0
2012-01-04	ABR	Stock	3.47	3.6	3.35	3.48	61100.0
2012-01-04	ABT	Stock	27.2191	27.2718	26.9792	27.1087	13370154.0
2012-01-04	ABTL-DELISTED	Stock	3.5877	3.7247	3.5786	3.7	7062.0
2012-01-04	ABUS	Stock	1.58	1.62	1.52	1.62	22400.0
2012-01-04	ABV-DELISTED	Stock	36.21	36.27	35.09	35.15	3624691.0
2012-01-04	ABVA-DELISTED	Stock	3.49	3.4955	3.4801	3.4801	1300.0
2012-01-04	ABVT-DELISTED	Stock	65.2	65.51	64.54	64.64	51107.0
2012-01-04	ABX-DELISTED	Stock	47.48	48.49	47.33	48.17	8623907.0

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

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