PREVIEW / stock_daily / 2010-04-06

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-06.parquet
  size:    191 KB
  rows:    5,939
  symbols: 3,502

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-06	AAPL	Stock	8.5071	8.58	8.4643	8.555	447017200.0
2010-04-06	MSFT	Stock	29.15	29.58	28.98	29.32	47366800.0
2010-04-06	NVDA	Stock	0.4315	0.4325	0.4188	0.4262	809260000.0
2010-04-06	AMZN	Stock	6.5615	6.8	6.559	6.778	159006000.0
2010-04-06	TLT	Stock	87.8	87.85	87.35	87.61	3584555.0
2010-04-06	ES	Stock	27.98	28.21	27.93	28.2	638500.0
2010-04-06	CL	Stock	42.645	42.66	42.155	42.465	4068200.0
2010-04-06	A	Stock	24.7783	24.814	24.6209	24.721	3499054.0
2010-04-06	AABA-DELISTED	Stock	16.55	16.98	16.42	16.93	25528264.0
2010-04-06	AACC-DELISTED	Stock	6.5	6.5101	6.45	6.46	3130.0
2010-04-06	AACG	Stock	3.98	4.06	3.98	4.06	1300.0
2010-04-06	AAI-DELISTED	Stock	5.06	5.17	5.05	5.13	2422489.0
2010-04-06	AAIC-DELISTED	Stock	18.12	18.13	18.0	18.11	36134.0
2010-04-06	AAME	Stock	1.46	1.5	1.46	1.5	3800.0
2010-04-06	AAON	Stock	4.5156	4.5511	4.4642	4.4998	127069.0
2010-04-06	AAP	Stock	42.53	42.81	42.42	42.56	729200.0
2010-04-06	AATI-DELISTED	Stock	3.62	3.81	3.61	3.74	186911.0
2010-04-06	AAU-DELISTED	Stock	1.0	1.04	0.99	1.0101	215299.0
2010-04-06	AAUAF-DELISTED	Stock	1.0	1.04	0.99	1.0101	216299.0
2010-04-06	AAV-DELISTED	Stock	7.21	7.31	7.17	7.2	328239.0
2010-04-06	AAWW-DELISTED	Stock	52.34	52.45	51.41	51.84	301145.0
2010-04-06	AAXJ	Stock	58.7	59.06	58.48	58.9	195958.0
2010-04-06	AAXN-DELISTED	Stock	5.6	5.8	5.54	5.64	1681888.0
2010-04-06	AB	Stock	32.8	32.91	32.01	32.55	375300.0
2010-04-06	ABAX-DELISTED	Stock	26.87	27.39	26.69	26.81	135183.0
2010-04-06	ABB-DELISTED	Stock	22.13	22.42	22.04	22.32	2542336.0
2010-04-06	ABBC-DELISTED	Stock	8.09	8.19	8.09	8.1	44346.0
2010-04-06	ABBNY-DELISTED	Stock	22.13	22.42	22.04	22.31	2822478.0
2010-04-06	ABC-DELISTED	Stock	28.92	29.14	28.8	29.06	1738836.0
2010-04-06	ABCB	Stock	9.455	9.8133	9.3555	9.5047	17985.0
2010-04-06	ABCD-DELISTED	Stock	4.65	4.75	4.5878	4.7	31055.0
2010-04-06	ABCO-DELISTED	Stock	16.245	16.53	16.175	16.53	83756.0
2010-04-06	ABCW-DELISTED	Stock	0.87	0.87	0.8211	0.87	258340.0
2010-04-06	ABD-DELISTED	Stock	7.835	8.135	7.735	8.115	184070.0
2010-04-06	ABE-DELISTED	Stock	17.28	17.43	17.28	17.43	21329.0
2010-04-06	ABEO	Stock	3037.5	3037.5	2900.0	2975.0	30.0
2010-04-06	ABFS-DELISTED	Stock	29.87	30.28	29.71	29.83	323409.0
2010-04-06	ABG	Stock	13.71	13.81	13.63	13.76	143300.0
2010-04-06	ABII-DELISTED	Stock	51.7	51.7	51.3	51.55	85404.0
2010-04-06	ABK-DELISTED	Stock	0.56	0.575	0.552	0.56	5770494.0
2010-04-06	ABM	Stock	20.9	20.94	20.78	20.86	94900.0
2010-04-06	ABMD-DELISTED	Stock	10.17	10.2	9.88	9.93	491780.0
2010-04-06	ABR	Stock	3.72	3.92	3.7	3.92	510800.0
2010-04-06	ABT	Stock	25.367	25.487	25.2279	25.3526	15102334.0
2010-04-06	ABTL-DELISTED	Stock	5.3	5.3	5.0	5.0	20857.0
2010-04-06	ABV-DELISTED	Stock	93.37	94.14	93.0	93.99	695643.0
2010-04-06	ABVA-DELISTED	Stock	2.53	2.7	2.53	2.7	2750.0
2010-04-06	ABVT-DELISTED	Stock	48.96	49.31	48.82	49.17	303492.0
2010-04-06	ABX-DELISTED	Stock	39.5	39.73	39.3	39.4	7112246.0
2010-04-06	ACAD	Stock	1.57	1.6	1.55	1.59	211900.0

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

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