PREVIEW / stock_daily / 2010-04-19

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-19.parquet
  size:    193 KB
  rows:    5,977
  symbols: 3,527

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-04-19	AAPL	Stock	8.8225	8.8532	8.6346	8.8239	566924400.0
2010-04-19	MSFT	Stock	30.77	31.25	30.76	31.04	64970300.0
2010-04-19	NVDA	Stock	0.4232	0.4258	0.4102	0.4245	1094492000.0
2010-04-19	AMZN	Stock	7.1175	7.1835	6.9565	7.1215	120440000.0
2010-04-19	TLT	Stock	89.87	90.03	89.52	89.64	3211477.0
2010-04-19	ES	Stock	27.38	27.46	27.13	27.46	1390500.0
2010-04-19	CL	Stock	41.625	42.1	41.505	42.075	5416000.0
2010-04-19	A	Stock	25.279	25.3505	24.7854	25.1502	4006388.0
2010-04-19	AABA-DELISTED	Stock	18.01	18.4	17.99	18.4	26882871.0
2010-04-19	AACC-DELISTED	Stock	6.79	6.85	6.77	6.79	6041.0
2010-04-19	AACG	Stock	3.59	3.61	3.53	3.53	12600.0
2010-04-19	AAI-DELISTED	Stock	5.66	5.96	5.61	5.79	5016217.0
2010-04-19	AAIC-DELISTED	Stock	20.22	20.22	20.02	20.17	42232.0
2010-04-19	AAME	Stock	1.44	1.45	1.44	1.44	2200.0
2010-04-19	AAON	Stock	4.6281	4.7012	4.5946	4.6736	248569.0
2010-04-19	AAP	Stock	44.37	44.67	43.69	44.45	1574800.0
2010-04-19	AATI-DELISTED	Stock	4.05	4.18	3.94	4.0	276202.0
2010-04-19	AAU-DELISTED	Stock	1.05	1.08	1.01	1.02	95968.0
2010-04-19	AAUAF-DELISTED	Stock	1.05	1.08	1.01	1.02	96468.0
2010-04-19	AAV-DELISTED	Stock	6.9	6.95	6.75	6.86	359417.0
2010-04-19	AAWW-DELISTED	Stock	56.37	57.68	54.87	56.0	380322.0
2010-04-19	AAXJ	Stock	56.7	57.41	56.7	57.25	337616.0
2010-04-19	AAXN-DELISTED	Stock	5.27	5.4	5.2	5.3	1198548.0
2010-04-19	AB	Stock	31.68	32.79	31.22	32.75	453600.0
2010-04-19	ABAX-DELISTED	Stock	26.67	26.67	26.24	26.57	98376.0
2010-04-19	ABB-DELISTED	Stock	21.85	22.26	21.83	22.26	2333867.0
2010-04-19	ABBC-DELISTED	Stock	8.44	8.442	8.2	8.26	22412.0
2010-04-19	ABBNY-DELISTED	Stock	21.84	22.26	21.83	22.24	2348593.0
2010-04-19	ABC-DELISTED	Stock	29.89	29.99	29.58	29.82	4212156.0
2010-04-19	ABCB	Stock	10.3308	10.6692	10.2512	10.5199	139963.0
2010-04-19	ABCD-DELISTED	Stock	5.18	5.18	5.02	5.16	61645.0
2010-04-19	ABCO-DELISTED	Stock	16.61	16.825	16.25	16.675	74638.0
2010-04-19	ABCW-DELISTED	Stock	1.01	1.1	1.0014	1.05	156330.0
2010-04-19	ABD-DELISTED	Stock	7.36	7.74	7.36	7.63	533540.0
2010-04-19	ABE-DELISTED	Stock	17.0	17.0	16.8035	16.89	4273.0
2010-04-19	ABEO	Stock	3375.0	3500.0	3212.5	3500.0	65.0
2010-04-19	ABFS-DELISTED	Stock	29.94	31.6	29.9399	31.35	1485683.0
2010-04-19	ABG	Stock	13.8	13.83	13.23	13.5	359400.0
2010-04-19	ABII-DELISTED	Stock	51.11	52.5	50.49	51.52	129895.0
2010-04-19	ABK-DELISTED	Stock	1.79	2.03	1.78	1.93	141074722.0
2010-04-19	ABM	Stock	21.28	21.5	21.05	21.45	121100.0
2010-04-19	ABMD-DELISTED	Stock	9.21	9.34	8.92	9.32	545158.0
2010-04-19	ABR	Stock	3.9	3.9	3.54	3.72	200000.0
2010-04-19	ABT	Stock	25.0743	25.4918	24.9784	25.3862	18932472.0
2010-04-19	ABTL-DELISTED	Stock	5.0	5.0	4.7625	4.85	9686.0
2010-04-19	ABV-DELISTED	Stock	96.44	97.6	96.11	97.25	387009.0
2010-04-19	ABVA-DELISTED	Stock	2.94	2.95	2.94	2.95	1800.0
2010-04-19	ABVT-DELISTED	Stock	53.78	54.14	51.94	52.73	201408.0
2010-04-19	ABX-DELISTED	Stock	38.54	39.14	38.14	39.14	6800080.0
2010-04-19	ACAD	Stock	1.73	1.76	1.62	1.67	964300.0

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

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