PREVIEW / stock_daily / 2010-07-06

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-06.parquet
  size:    189 KB
  rows:    5,941
  symbols: 3,497

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-07-06	AAPL	Stock	8.9643	9.0286	8.7914	8.8796	615235600.0
2010-07-06	MSFT	Stock	23.7	24.09	23.58	23.82	73592000.0
2010-07-06	NVDA	Stock	0.2553	0.2635	0.2513	0.2535	712020000.0
2010-07-06	AMZN	Stock	5.5325	5.6265	5.45	5.503	104386000.0
2010-07-06	TSLA	Stock	1.3333	1.3333	1.0553	1.074	103003500.0
2010-07-06	TLT	Stock	100.83	101.75	100.74	101.62	6620321.0
2010-07-06	ES	Stock	25.86	26.13	25.71	26.02	1238000.0
2010-07-06	CL	Stock	39.6	39.67	39.085	39.385	4166000.0
2010-07-06	A	Stock	20.279	20.4363	19.6924	19.8498	5281924.0
2010-07-06	AABA-DELISTED	Stock	14.23	14.46	14.0	14.14	16977239.0
2010-07-06	AACC-DELISTED	Stock	4.06	4.1	3.71	3.85	54591.0
2010-07-06	AACG	Stock	2.77	2.95	2.76	2.8	2000.0
2010-07-06	AAI-DELISTED	Stock	4.87	4.94	4.63	4.64	3724689.0
2010-07-06	AAIC-DELISTED	Stock	18.62	18.68	18.11	18.32	55759.0
2010-07-06	AAME	Stock	1.4	1.44	1.21	1.21	1900.0
2010-07-06	AAON	Stock	4.8198	4.8198	4.5037	4.5195	541687.0
2010-07-06	AAP	Stock	51.8	52.38	49.76	50.5	1460300.0
2010-07-06	AATI-DELISTED	Stock	3.1	3.15	2.84	2.96	288632.0
2010-07-06	AAU-DELISTED	Stock	0.845	0.88	0.845	0.87	69700.0
2010-07-06	AAUAF-DELISTED	Stock	0.845	0.88	0.845	0.87	72200.0
2010-07-06	AAV-DELISTED	Stock	5.85	5.87	5.68	5.74	380652.0
2010-07-06	AAWW-DELISTED	Stock	47.65	48.43	46.54	47.03	201889.0
2010-07-06	AAXJ	Stock	53.58	53.8	52.6604	53.01	150249.0
2010-07-06	AAXN-DELISTED	Stock	3.77	3.96	3.68	3.73	447666.0
2010-07-06	AB	Stock	25.43	26.18	24.72	24.9	315900.0
2010-07-06	ABAX-DELISTED	Stock	21.44	21.79	20.78	20.82	96880.0
2010-07-06	ABB-DELISTED	Stock	17.88	18.03	17.55	17.72	2920536.0
2010-07-06	ABBC-DELISTED	Stock	8.9	8.9	8.72	8.72	78144.0
2010-07-06	ABBNY-DELISTED	Stock	17.87	18.03	17.55	17.69	2954987.0
2010-07-06	ABC-DELISTED	Stock	31.41	31.69	31.12	31.32	3316311.0
2010-07-06	ABCB	Stock	9.88	9.88	9.69	9.78	107700.0
2010-07-06	ABCD-DELISTED	Stock	3.59	3.6	3.43	3.45	66402.0
2010-07-06	ABCO-DELISTED	Stock	21.62	21.8	20.82	20.99	176439.0
2010-07-06	ABCW-DELISTED	Stock	0.5	0.51	0.48	0.48	58380.0
2010-07-06	ABD-DELISTED	Stock	5.09	5.2001	4.79	4.84	421240.0
2010-07-06	ABE-DELISTED	Stock	16.01	16.23	15.96	16.08	21886.0
2010-07-06	ABEO	Stock	2350.0	2500.0	2250.0	2500.0	7.0
2010-07-06	ABFS-DELISTED	Stock	19.66	20.148	18.84	18.96	400059.0
2010-07-06	ABG	Stock	10.54	10.69	9.69	9.82	516700.0
2010-07-06	ABII-DELISTED	Stock	74.0	74.5	73.37	73.72	136810.0
2010-07-06	ABK-DELISTED	Stock	0.68	0.7096	0.6409	0.66	6284240.0
2010-07-06	ABM	Stock	20.96	21.02	20.26	20.35	316500.0
2010-07-06	ABMD-DELISTED	Stock	9.65	10.35	9.65	9.97	481997.0
2010-07-06	ABR	Stock	4.69	4.78	4.45	4.45	104200.0
2010-07-06	ABT	Stock	22.445	22.5362	22.2195	22.4019	20032305.0
2010-07-06	ABTL-DELISTED	Stock	6.0	6.0504	5.7479	6.0	24644.0
2010-07-06	ABV-DELISTED	Stock	104.09	105.91	103.139	103.99	867771.0
2010-07-06	ABVT-DELISTED	Stock	47.99	48.512	46.44	46.77	125207.0
2010-07-06	ABX-DELISTED	Stock	43.73	43.87	42.44	42.98	11043584.0
2010-07-06	ACAD	Stock	1.14	1.16	1.04	1.05	242500.0

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

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