PREVIEW / stock_daily / 2009-10-30

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-30.parquet
  size:    186 KB
  rows:    5,856
  symbols: 3,480

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
2009-10-30	AAPL	Stock	7.0021	7.0286	6.7204	6.7321	717525200.0
2009-10-30	MSFT	Stock	28.03	28.4	27.66	27.73	73371800.0
2009-10-30	NVDA	Stock	0.3123	0.3135	0.2975	0.299	604144000.0
2009-10-30	AMZN	Stock	6.0985	6.145	5.9105	5.9405	266244000.0
2009-10-30	TLT	Stock	95.1	96.01	94.87	95.78	5117998.0
2009-10-30	ES	Stock	23.08	23.26	22.89	23.05	3067100.0
2009-10-30	CL	Stock	39.49	40.05	39.04	39.315	9892600.0
2009-10-30	A	Stock	18.3906	18.4621	17.6037	17.6967	7608335.0
2009-10-30	AABA-DELISTED	Stock	16.05	16.37	15.8	15.91	21720115.0
2009-10-30	AACC-DELISTED	Stock	7.22	7.27	7.08	7.27	48358.0
2009-10-30	AACG	Stock	5.17	5.2	5.17	5.19	3700.0
2009-10-30	AAI-DELISTED	Stock	4.28	4.32	4.1	4.22	6203618.0
2009-10-30	AAIC-DELISTED	Stock	12.4	12.4	11.45	11.74	54502.0
2009-10-30	AAME	Stock	1.28	1.28	1.28	1.28	500.0
2009-10-30	AAON	Stock	3.6346	3.6701	3.5556	3.5575	457144.0
2009-10-30	AAP	Stock	37.22	37.71	37.07	37.26	2666600.0
2009-10-30	AATI-DELISTED	Stock	3.11	3.26	3.07	3.16	710828.0
2009-10-30	AAU-DELISTED	Stock	0.7	0.7	0.67	0.67	143000.0
2009-10-30	AAUAF-DELISTED	Stock	0.7	0.7	0.67	0.67	143100.0
2009-10-30	AAV-DELISTED	Stock	6.51	6.57	6.07	6.17	1541679.0
2009-10-30	AAWW-DELISTED	Stock	26.13	26.66	25.73	26.34	952176.0
2009-10-30	AAXJ	Stock	52.66	52.66	50.63	50.92	197334.0
2009-10-30	AAXN-DELISTED	Stock	4.21	4.26	4.07	4.09	490406.0
2009-10-30	AB	Stock	26.98	28.63	26.38	26.98	1445900.0
2009-10-30	ABAX-DELISTED	Stock	23.31	23.5	22.72	22.82	212101.0
2009-10-30	ABB-DELISTED	Stock	19.16	19.21	18.3	18.55	8676322.0
2009-10-30	ABBC-DELISTED	Stock	6.87	6.98	6.78	6.8	58900.0
2009-10-30	ABBNY-DELISTED	Stock	19.16	19.21	18.3	18.53	8941518.0
2009-10-30	ABC-DELISTED	Stock	22.69	22.84	22.13	22.13	5221003.0
2009-10-30	ABCB	Stock	6.0081	6.116	5.6945	5.7729	54891.0
2009-10-30	ABCO-DELISTED	Stock	12.508	12.553	12.197	12.317	114929.0
2009-10-30	ABCW-DELISTED	Stock	0.8	0.8	0.77	0.77	53570.0
2009-10-30	ABD-DELISTED	Stock	6.49	6.59	6.02	6.06	452600.0
2009-10-30	ABE-DELISTED	Stock	16.5	16.5	15.66	15.95	55337.0
2009-10-30	ABEO	Stock	3937.5	3937.5	3750.0	3750.0	36.0
2009-10-30	ABFS-DELISTED	Stock	26.35	26.65	25.6	25.81	497954.0
2009-10-30	ABG	Stock	11.09	11.18	9.69	9.74	677500.0
2009-10-30	ABII-DELISTED	Stock	32.0	32.59	31.2	31.2	36863.0
2009-10-30	ABK-DELISTED	Stock	1.17	1.2	1.08	1.16	14290986.0
2009-10-30	ABM	Stock	19.19	19.19	18.67	18.78	305500.0
2009-10-30	ABMD-DELISTED	Stock	9.19	9.43	8.93	9.05	399628.0
2009-10-30	ABR	Stock	2.09	2.12	1.88	2.0	105500.0
2009-10-30	ABT	Stock	24.3882	24.5658	24.1819	24.2635	14583160.0
2009-10-30	ABTL-DELISTED	Stock	3.6526	3.8961	3.6526	3.75	9776.0
2009-10-30	ABV-DELISTED	Stock	95.18	95.73	89.18	90.18	942948.0
2009-10-30	ABVA-DELISTED	Stock	2.44	2.4401	2.44	2.4401	1885.0
2009-10-30	ABVT-DELISTED	Stock	51.14	51.16	46.41	48.4	176484.0
2009-10-30	ABX-DELISTED	Stock	36.51	36.75	34.8	35.96	16891737.0
2009-10-30	ACAD	Stock	1.4	1.42	1.24	1.3	430400.0
2009-10-30	ACAP-DELISTED	Stock	29.04	29.04	28.23	28.29	75434.0

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

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