PREVIEW / stock_daily / 2010-08-05

all stock daily files

  file:    by_date/stock_daily/2010/2010-08-05.parquet
  size:    190 KB
  rows:    5,943
  symbols: 3,486

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-08-05	AAPL	Stock	9.3475	9.3993	9.3054	9.3464	289097200.0
2010-08-05	MSFT	Stock	25.49	25.58	25.21	25.37	64922100.0
2010-08-05	NVDA	Stock	0.2338	0.2365	0.2295	0.236	800504000.0
2010-08-05	AMZN	Stock	6.3385	6.4	6.291	6.3915	85646000.0
2010-08-05	TSLA	Stock	1.436	1.4367	1.3367	1.3633	11943000.0
2010-08-05	TLT	Stock	99.34	99.49	98.84	99.02	3704154.0
2010-08-05	ES	Stock	28.72	29.19	28.57	29.14	1600100.0
2010-08-05	CL	Stock	39.025	39.09	38.475	38.565	6605600.0
2010-08-05	A	Stock	20.0501	20.4793	20.0	20.3577	2891483.0
2010-08-05	AABA-DELISTED	Stock	14.15	14.25	14.02	14.16	12862380.0
2010-08-05	AACC-DELISTED	Stock	4.55	4.735	4.14	4.25	35657.0
2010-08-05	AACG	Stock	2.99	3.14	2.99	3.0	10100.0
2010-08-05	AAI-DELISTED	Stock	4.74	4.79	4.7	4.72	1158968.0
2010-08-05	AAIC-DELISTED	Stock	19.88	20.45	19.88	20.32	79364.0
2010-08-05	AAME	Stock	1.22	1.22	1.22	1.22	200.0
2010-08-05	AAON	Stock	5.0351	5.12	4.9778	4.9857	140737.0
2010-08-05	AAP	Stock	53.26	54.06	52.6	53.87	795700.0
2010-08-05	AATI-DELISTED	Stock	3.23	3.32	3.23	3.31	53978.0
2010-08-05	AAU-DELISTED	Stock	0.98	0.9912	0.9689	0.9812	51128.0
2010-08-05	AAUAF-DELISTED	Stock	0.98	0.9925	0.9701	0.9825	51265.0
2010-08-05	AAV-DELISTED	Stock	6.33	6.46	6.29	6.33	295184.0
2010-08-05	AAWW-DELISTED	Stock	50.31	51.0	50.01	50.45	282467.0
2010-08-05	AAXJ	Stock	56.63	57.06	56.63	56.98	391722.0
2010-08-05	AAXN-DELISTED	Stock	4.0	4.07	4.0	4.02	294229.0
2010-08-05	AB	Stock	26.89	27.37	26.65	27.1	286800.0
2010-08-05	ABAC-DELISTED	Stock	4.0	4.0	3.6	3.69	41849.0
2010-08-05	ABAX-DELISTED	Stock	21.09	21.37	20.9	20.97	131738.0
2010-08-05	ABB-DELISTED	Stock	20.69	20.8	20.59	20.67	1809943.0
2010-08-05	ABBC-DELISTED	Stock	9.39	9.4	9.34	9.38	19786.0
2010-08-05	ABBNY-DELISTED	Stock	20.69	20.8	20.59	20.7	1823052.0
2010-08-05	ABC-DELISTED	Stock	30.08	30.37	29.9	30.34	3008025.0
2010-08-05	ABCB	Stock	9.53	9.54	9.42	9.43	56400.0
2010-08-05	ABCD-DELISTED	Stock	3.6	3.69	3.46	3.61	7645.0
2010-08-05	ABCO-DELISTED	Stock	22.12	22.41	21.99	22.33	113347.0
2010-08-05	ABCW-DELISTED	Stock	0.62	0.69	0.57	0.57	53200.0
2010-08-05	ABD-DELISTED	Stock	6.375	6.4949	6.2851	6.375	351910.0
2010-08-05	ABE-DELISTED	Stock	17.49	17.49	17.3	17.45	11924.0
2010-08-05	ABEO	Stock	2562.5	2612.5	2562.5	2612.5	6.0
2010-08-05	ABFS-DELISTED	Stock	22.61	22.66	22.0	22.16	278109.0
2010-08-05	ABG	Stock	13.63	13.68	13.4	13.46	219500.0
2010-08-05	ABII-DELISTED	Stock	75.6	76.002	75.6	75.74	30245.0
2010-08-05	ABK-DELISTED	Stock	0.899	0.975	0.865	0.882	27052953.0
2010-08-05	ABM	Stock	21.79	21.99	21.57	21.74	93900.0
2010-08-05	ABMD-DELISTED	Stock	10.41	10.41	10.09	10.24	351066.0
2010-08-05	ABR	Stock	5.99	5.99	5.71	5.78	53100.0
2010-08-05	ABT	Stock	23.9564	24.0284	23.8557	23.9804	12290538.0
2010-08-05	ABTL-DELISTED	Stock	5.511	5.6019	5.3495	5.4	15343.0
2010-08-05	ABV-DELISTED	Stock	108.49	108.49	107.0	107.81	437865.0
2010-08-05	ABVA-DELISTED	Stock	3.29	3.29	2.9	3.09	6858.0
2010-08-05	ABVT-DELISTED	Stock	53.93	53.93	52.33	52.43	204869.0

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

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