PREVIEW / stock_daily / 2010-09-09

all stock daily files

  file:    by_date/stock_daily/2010/2010-09-09.parquet
  size:    189 KB
  rows:    5,925
  symbols: 3,474

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-09-09	AAPL	Stock	9.4657	9.5186	9.39	9.3954	438575200.0
2010-09-09	MSFT	Stock	24.19	24.21	23.99	24.01	46028900.0
2010-09-09	NVDA	Stock	0.2612	0.2615	0.2513	0.2545	697748000.0
2010-09-09	AMZN	Stock	7.0195	7.0685	6.963	7.019	99160000.0
2010-09-09	TSLA	Stock	1.4	1.4033	1.3793	1.3807	5643000.0
2010-09-09	TLT	Stock	103.7	103.84	102.64	102.79	8588826.0
2010-09-09	ES	Stock	29.44	29.63	29.31	29.48	1140400.0
2010-09-09	CL	Stock	37.525	37.605	37.195	37.28	4286000.0
2010-09-09	A	Stock	20.9227	21.0229	20.6867	20.6938	2937198.0
2010-09-09	AABA-DELISTED	Stock	13.88	13.92	13.57	13.64	17650594.0
2010-09-09	AACC-DELISTED	Stock	3.81	3.81	3.72	3.77	11410.0
2010-09-09	AACG	Stock	2.88	2.89	2.85	2.85	11700.0
2010-09-09	AAI-DELISTED	Stock	4.58	4.6	4.32	4.32	3234962.0
2010-09-09	AAIC-DELISTED	Stock	21.53	21.7	21.42	21.66	29580.0
2010-09-09	AAME	Stock	1.44	1.44	1.25	1.43	11000.0
2010-09-09	AAON	Stock	4.4958	4.5037	4.3931	4.4662	121500.0
2010-09-09	AAP	Stock	57.15	57.26	55.81	56.04	729500.0
2010-09-09	AATI-DELISTED	Stock	3.35	3.35	3.25	3.31	59614.0
2010-09-09	AAU-DELISTED	Stock	2.64	2.7021	2.5395	2.57	616875.0
2010-09-09	AAUAF-DELISTED	Stock	2.6	2.66	2.5	2.57	626950.0
2010-09-09	AAV-DELISTED	Stock	6.43	6.46	6.28	6.32	190254.0
2010-09-09	AAWW-DELISTED	Stock	48.1	48.29	46.52	46.92	190667.0
2010-09-09	AAXJ	Stock	56.94	56.99	56.66	56.83	144741.0
2010-09-09	AAXN-DELISTED	Stock	3.91	3.985	3.9	3.94	245515.0
2010-09-09	AB	Stock	24.8	25.19	24.67	25.06	425200.0
2010-09-09	ABAC-DELISTED	Stock	3.76	3.77	3.72	3.72	9650.0
2010-09-09	ABAX-DELISTED	Stock	19.99	20.0	19.17	19.4	75020.0
2010-09-09	ABB-DELISTED	Stock	20.58	20.62	20.34	20.47	1240194.0
2010-09-09	ABBC-DELISTED	Stock	10.37	10.4	10.3	10.34	30637.0
2010-09-09	ABBNY-DELISTED	Stock	20.58	20.62	20.34	20.46	1247138.0
2010-09-09	ABC-DELISTED	Stock	28.24	28.36	28.13	28.26	1307575.0
2010-09-09	ABCB	Stock	8.61	8.81	8.39	8.44	26500.0
2010-09-09	ABCD-DELISTED	Stock	3.07	3.07	2.89	2.94	11023.0
2010-09-09	ABCO-DELISTED	Stock	21.6	21.62	21.22	21.49	118703.0
2010-09-09	ABCW-DELISTED	Stock	0.7	0.74	0.68	0.72	196830.0
2010-09-09	ABD-DELISTED	Stock	6.3	6.37	5.99	6.07	193240.0
2010-09-09	ABE-DELISTED	Stock	17.5	17.602	17.5	17.58	8681.0
2010-09-09	ABEO	Stock	2400.0	2500.0	2400.0	2400.0	22.0
2010-09-09	ABFS-DELISTED	Stock	23.03	23.24	22.5301	22.76	256688.0
2010-09-09	ABG	Stock	13.29	13.33	12.64	12.88	91300.0
2010-09-09	ABII-DELISTED	Stock	74.45	74.545	74.34	74.35	24307.0
2010-09-09	ABK-DELISTED	Stock	0.5296	0.535	0.5	0.5136	6925088.0
2010-09-09	ABM	Stock	21.34	21.64	21.18	21.55	216400.0
2010-09-09	ABMD-DELISTED	Stock	9.56	9.71	9.49	9.66	95237.0
2010-09-09	ABR	Stock	4.55	4.61	4.43	4.6	99800.0
2010-09-09	ABT	Stock	24.4458	24.6233	24.4458	24.513	10887245.0
2010-09-09	ABTL-DELISTED	Stock	4.2512	4.2512	4.159	4.2	9624.0
2010-09-09	ABV-DELISTED	Stock	115.13	115.46	114.2	114.88	411555.0
2010-09-09	ABVA-DELISTED	Stock	2.75	2.75	2.75	2.75	400.0
2010-09-09	ABVT-DELISTED	Stock	52.43	52.56	51.62	51.9	57741.0

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

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