PREVIEW / stock_daily / 2010-06-28

all stock daily files

  file:    by_date/stock_daily/2010/2010-06-28.parquet
  size:    189 KB
  rows:    5,923
  symbols: 3,487

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-06-28	AAPL	Stock	9.5332	9.6339	9.4471	9.5821	584948000.0
2010-06-28	MSFT	Stock	24.51	24.61	24.12	24.31	73784800.0
2010-06-28	NVDA	Stock	0.279	0.2815	0.2725	0.2775	372008000.0
2010-06-28	AMZN	Stock	5.9425	6.002	5.855	5.89	112244000.0
2010-06-28	TLT	Stock	99.6	100.0	99.4172	99.98	5437428.0
2010-06-28	ES	Stock	25.75	26.11	25.61	26.0	631600.0
2010-06-28	CL	Stock	39.56	39.785	39.28	39.62	3760200.0
2010-06-28	A	Stock	21.9099	22.0744	21.6667	21.8741	3104399.0
2010-06-28	AABA-DELISTED	Stock	14.83	14.86	14.59	14.72	8060504.0
2010-06-28	AACC-DELISTED	Stock	4.59	4.74	4.59	4.64	71944.0
2010-06-28	AACG	Stock	3.34	3.35	3.01	3.11	18200.0
2010-06-28	AAI-DELISTED	Stock	5.08	5.18	5.06	5.08	1940807.0
2010-06-28	AAIC-DELISTED	Stock	19.23	19.6	19.03	19.2	78640.0
2010-06-28	AAME	Stock	1.26	1.3	1.26	1.3	1000.0
2010-06-28	AAON	Stock	4.7467	4.7783	4.6973	4.7111	322481.0
2010-06-28	AAP	Stock	51.19	51.19	50.2	50.47	611000.0
2010-06-28	AATI-DELISTED	Stock	3.38	3.48	3.37	3.45	113230.0
2010-06-28	AAU-DELISTED	Stock	0.9975	0.9975	0.95	0.95	59258.0
2010-06-28	AAUAF-DELISTED	Stock	0.9975	0.9975	0.95	0.95	60358.0
2010-06-28	AAV-DELISTED	Stock	6.44	6.47	6.36	6.4	183742.0
2010-06-28	AAWW-DELISTED	Stock	51.4	52.51	50.91	51.32	159679.0
2010-06-28	AAXJ	Stock	54.57	54.57	54.046	54.29	403201.0
2010-06-28	AAXN-DELISTED	Stock	4.02	4.07	3.96	3.97	810262.0
2010-06-28	AB	Stock	28.27	28.27	27.52	27.64	187600.0
2010-06-28	ABAX-DELISTED	Stock	21.49	22.23	21.33	21.98	104512.0
2010-06-28	ABB-DELISTED	Stock	18.43	18.47	18.18	18.25	2741942.0
2010-06-28	ABBC-DELISTED	Stock	8.8501	8.93	8.76	8.81	64169.0
2010-06-28	ABBNY-DELISTED	Stock	18.43	18.47	18.18	18.25	2772728.0
2010-06-28	ABC-DELISTED	Stock	32.01	32.67	31.64	32.55	4974868.0
2010-06-28	ABCB	Stock	10.88	10.88	10.08	10.09	172000.0
2010-06-28	ABCD-DELISTED	Stock	4.1	4.14	3.96	3.98	79263.0
2010-06-28	ABCO-DELISTED	Stock	21.38	22.06	21.22	21.6	157813.0
2010-06-28	ABCW-DELISTED	Stock	0.57	0.57	0.4	0.45	194270.0
2010-06-28	ABD-DELISTED	Stock	5.68	5.75	5.42	5.53	487350.0
2010-06-28	ABE-DELISTED	Stock	16.07	16.07	16.01	16.059	11500.0
2010-06-28	ABEO	Stock	2625.0	2750.0	2562.5	2750.0	16.0
2010-06-28	ABFS-DELISTED	Stock	20.57	21.36	20.57	21.22	711461.0
2010-06-28	ABG	Stock	11.39	11.45	10.91	10.96	460000.0
2010-06-28	ABII-DELISTED	Stock	62.62	63.5	62.06	63.11	35053.0
2010-06-28	ABK-DELISTED	Stock	0.75	0.76	0.69	0.7068	8294901.0
2010-06-28	ABM	Stock	22.41	22.73	22.18	22.2	202500.0
2010-06-28	ABMD-DELISTED	Stock	9.75	9.95	9.54	9.85	102486.0
2010-06-28	ABR	Stock	5.21	5.27	5.02	5.22	95900.0
2010-06-28	ABT	Stock	22.6706	22.8385	22.5698	22.637	11372864.0
2010-06-28	ABTL-DELISTED	Stock	5.6038	5.9449	5.6038	5.75	63097.0
2010-06-28	ABV-DELISTED	Stock	106.1	108.2	105.26	108.12	610610.0
2010-06-28	ABVA-DELISTED	Stock	2.74	2.87	2.451	2.518	3182.0
2010-06-28	ABVT-DELISTED	Stock	49.36	49.96	48.61	48.72	293901.0
2010-06-28	ABX-DELISTED	Stock	46.53	47.25	45.72	46.22	10743926.0
2010-06-28	ACAD	Stock	1.2	1.25	1.19	1.21	180000.0

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

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