PREVIEW / stock_daily / 2010-03-16

all stock daily files

  file:    by_date/stock_daily/2010/2010-03-16.parquet
  size:    192 KB
  rows:    5,951
  symbols: 3,520

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
2010-03-16	AAPL	Stock	8.0064	8.035	7.9468	8.0161	446908000.0
2010-03-16	MSFT	Stock	29.42	29.49	29.2	29.37	36723500.0
2010-03-16	NVDA	Stock	0.4288	0.4465	0.4285	0.444	664988000.0
2010-03-16	AMZN	Stock	6.562	6.6145	6.525	6.5895	82650000.0
2010-03-16	TLT	Stock	90.56	91.09	90.54	91.08	3932548.0
2010-03-16	ES	Stock	27.01	27.25	26.81	27.25	1094900.0
2010-03-16	CL	Stock	42.22	42.415	42.045	42.31	3490600.0
2010-03-16	A	Stock	23.8841	24.02	23.7625	23.9056	3285999.0
2010-03-16	AABA-DELISTED	Stock	16.41	16.59	16.23	16.36	17996111.0
2010-03-16	AACC-DELISTED	Stock	6.08	6.09	6.01	6.06	13172.0
2010-03-16	AACG	Stock	4.56	4.56	4.13	4.21	30500.0
2010-03-16	AAI-DELISTED	Stock	5.41	5.48	5.34	5.41	2169074.0
2010-03-16	AAIC-DELISTED	Stock	18.59	18.66	18.11	18.32	17984.0
2010-03-16	AAME	Stock	1.41	1.52	1.38	1.38	6000.0
2010-03-16	AAON	Stock	4.1659	4.1877	4.1106	4.158	463725.0
2010-03-16	AAP	Stock	41.87	42.65	41.85	42.3	843400.0
2010-03-16	AATI-DELISTED	Stock	3.4	3.4001	3.35	3.37	314318.0
2010-03-16	AAU-DELISTED	Stock	0.9111	0.94	0.9015	0.9297	76400.0
2010-03-16	AAUAF-DELISTED	Stock	0.9111	0.94	0.9015	0.9297	77400.0
2010-03-16	AAV-DELISTED	Stock	7.82	7.83	7.66	7.8	641634.0
2010-03-16	AAWW-DELISTED	Stock	48.39	49.14	47.53	49.14	284540.0
2010-03-16	AAXJ	Stock	55.55	55.92	55.34	55.83	857603.0
2010-03-16	AAXN-DELISTED	Stock	6.88	6.96	6.77	6.79	952394.0
2010-03-16	AB	Stock	29.51	29.51	29.2	29.25	365700.0
2010-03-16	ABAX-DELISTED	Stock	27.41	27.57	27.09	27.57	123422.0
2010-03-16	ABB-DELISTED	Stock	21.11	21.4001	21.07	21.37	1730149.0
2010-03-16	ABBC-DELISTED	Stock	8.07	8.5	8.07	8.43	81415.0
2010-03-16	ABBNY-DELISTED	Stock	21.11	21.4001	21.07	21.36	1731378.0
2010-03-16	ABC-DELISTED	Stock	28.42	28.45	27.93	28.37	4184371.0
2010-03-16	ABCB	Stock	9.4519	9.4914	9.3334	9.4914	12352.0
2010-03-16	ABCD-DELISTED	Stock	3.72	3.98	3.72	3.94	23586.0
2010-03-16	ABCO-DELISTED	Stock	16.405	16.405	16.065	16.36	76739.0
2010-03-16	ABCW-DELISTED	Stock	1.3397	1.3494	1.2718	1.33	123090.0
2010-03-16	ABD-DELISTED	Stock	7.78	7.95	7.34	7.42	251410.0
2010-03-16	ABE-DELISTED	Stock	16.64	16.7399	16.56	16.7399	11186.0
2010-03-16	ABEO	Stock	3075.0	3187.5	3075.0	3187.5	13.0
2010-03-16	ABFS-DELISTED	Stock	29.23	30.94	29.2	29.97	1028758.0
2010-03-16	ABG	Stock	13.59	14.03	13.35	13.98	561000.0
2010-03-16	ABII-DELISTED	Stock	40.59	40.59	39.52	39.85	36552.0
2010-03-16	ABK-DELISTED	Stock	0.762	0.85	0.7562	0.7701	17249323.0
2010-03-16	ABM	Stock	19.95	19.95	19.48	19.71	360600.0
2010-03-16	ABMD-DELISTED	Stock	10.35	10.37	10.25	10.29	252187.0
2010-03-16	ABR	Stock	2.97	3.03	2.96	3.01	92300.0
2010-03-16	ABT	Stock	26.3122	26.3842	26.1347	26.2355	12421426.0
2010-03-16	ABTL-DELISTED	Stock	5.6	5.8	5.4	5.45	33688.0
2010-03-16	ABV-DELISTED	Stock	95.61	96.95	95.6	96.89	566583.0
2010-03-16	ABVA-DELISTED	Stock	2.5899	2.5899	2.47	2.5	2349.0
2010-03-16	ABVT-DELISTED	Stock	54.57	55.02	54.235	54.7899	142497.0
2010-03-16	ABX-DELISTED	Stock	39.63	40.35	39.46	40.07	10148689.0
2010-03-16	ACAD	Stock	1.72	1.74	1.6	1.64	938700.0

> showing 50 of 5,951 rows — these rows as CSV

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