PREVIEW / stock_daily / 2010-06-21

all stock daily files

  file:    by_date/stock_daily/2010/2010-06-21.parquet
  size:    189 KB
  rows:    5,946
  symbols: 3,504

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-21	AAPL	Stock	9.9175	9.9646	9.5975	9.6489	776490400.0
2010-06-21	MSFT	Stock	26.78	26.89	25.89	25.95	54625300.0
2010-06-21	NVDA	Stock	0.314	0.3148	0.2975	0.3002	579836000.0
2010-06-21	AMZN	Stock	6.3395	6.374	6.0705	6.1275	106554000.0
2010-06-21	TLT	Stock	96.46	97.55	96.41	97.41	5740875.0
2010-06-21	ES	Stock	27.08	27.18	26.51	26.65	1440500.0
2010-06-21	CL	Stock	40.575	40.775	40.42	40.58	5114400.0
2010-06-21	A	Stock	23.6481	23.8698	23.0472	23.1974	4096000.0
2010-06-21	AABA-DELISTED	Stock	15.69	15.84	15.09	15.21	20156241.0
2010-06-21	AACC-DELISTED	Stock	4.74	4.74	4.62	4.68	102739.0
2010-06-21	AACG	Stock	3.2	3.2	3.2	3.2	600.0
2010-06-21	AAI-DELISTED	Stock	5.46	5.54	5.22	5.24	3994596.0
2010-06-21	AAIC-DELISTED	Stock	20.41	20.41	20.208	20.27	18635.0
2010-06-21	AAME	Stock	1.51	1.55	1.51	1.55	1200.0
2010-06-21	AAON	Stock	4.9383	4.9896	4.8514	4.877	370575.0
2010-06-21	AAP	Stock	51.99	52.13	51.0	51.34	1025400.0
2010-06-21	AATI-DELISTED	Stock	3.77	3.82	3.62	3.64	192497.0
2010-06-21	AAU-DELISTED	Stock	1.01	1.04	0.94	0.96	126968.0
2010-06-21	AAUAF-DELISTED	Stock	1.01	1.04	0.94	0.96	127068.0
2010-06-21	AAV-DELISTED	Stock	7.07	7.18	6.8	6.82	475739.0
2010-06-21	AAWW-DELISTED	Stock	53.99	54.63	51.92	52.24	148600.0
2010-06-21	AAXJ	Stock	55.73	56.24	55.37	55.57	2218528.0
2010-06-21	AAXN-DELISTED	Stock	4.21	4.24	4.0	4.02	661027.0
2010-06-21	AB	Stock	29.89	29.94	28.71	29.19	313500.0
2010-06-21	ABAX-DELISTED	Stock	22.72	23.2	21.91	22.03	68834.0
2010-06-21	ABB-DELISTED	Stock	19.24	19.28	18.83	18.92	4788649.0
2010-06-21	ABBC-DELISTED	Stock	9.09	9.09	8.83	8.84	90935.0
2010-06-21	ABBNY-DELISTED	Stock	19.24	19.28	18.83	18.93	4878883.0
2010-06-21	ABC-DELISTED	Stock	32.8	32.994	32.29	32.42	3168656.0
2010-06-21	ABCB	Stock	10.4801	10.5	10.082	10.1019	71539.0
2010-06-21	ABCD-DELISTED	Stock	4.7	4.7	4.42	4.5	49167.0
2010-06-21	ABCO-DELISTED	Stock	21.7	21.74	21.46	21.49	156830.0
2010-06-21	ABCW-DELISTED	Stock	0.7197	0.7296	0.6901	0.7	113300.0
2010-06-21	ABD-DELISTED	Stock	5.46	5.62	5.17	5.25	409000.0
2010-06-21	ABE-DELISTED	Stock	16.2	16.5054	16.2	16.27	15370.0
2010-06-21	ABEO	Stock	3000.0	3062.5	2875.0	3037.5	19.0
2010-06-21	ABFS-DELISTED	Stock	22.08	22.12	21.07	21.22	373894.0
2010-06-21	ABG	Stock	12.48	12.64	11.74	11.82	445900.0
2010-06-21	ABII-DELISTED	Stock	63.0	63.23	60.6	61.25	63755.0
2010-06-21	ABK-DELISTED	Stock	0.825	0.83	0.76	0.7685	9333811.0
2010-06-21	ABM	Stock	22.96	23.0	22.56	22.67	298900.0
2010-06-21	ABMD-DELISTED	Stock	9.42	9.89	9.42	9.53	102091.0
2010-06-21	ABR	Stock	5.39	5.64	5.35	5.48	399300.0
2010-06-21	ABT	Stock	23.587	23.6206	23.0592	23.1743	15873281.0
2010-06-21	ABTL-DELISTED	Stock	6.25	6.35	5.856	6.0	47177.0
2010-06-21	ABV-DELISTED	Stock	106.81	107.94	106.75	107.92	873174.0
2010-06-21	ABVA-DELISTED	Stock	2.62	2.646	2.62	2.62	1032.0
2010-06-21	ABVT-DELISTED	Stock	48.14	48.31	47.48	48.2	166903.0
2010-06-21	ABX-DELISTED	Stock	46.16	46.36	44.47	44.82	10605776.0
2010-06-21	ACAD	Stock	1.27	1.27	1.2	1.23	361800.0

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

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