PREVIEW / stock_daily / 2009-01-27

all stock daily files

  file:    by_date/stock_daily/2009/2009-01-27.parquet
  size:    175 KB
  rows:    5,697
  symbols: 3,405

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-01-27	AAPL	Stock	3.2211	3.2696	3.205	3.2404	618038400.0
2009-01-27	MSFT	Stock	17.78	17.97	17.43	17.66	61695000.0
2009-01-27	NVDA	Stock	0.2025	0.2125	0.2018	0.211	725300000.0
2009-01-27	AMZN	Stock	2.465	2.521	2.386	2.422	174764000.0
2009-01-27	TLT	Stock	107.8	109.59	107.63	109.26	3421407.0
2009-01-27	CL	Stock	30.99	31.45	30.975	31.11	6133200.0
2009-01-27	A	Stock	13.5265	13.6552	13.0901	13.3763	6613658.0
2009-01-27	AABA-DELISTED	Stock	11.21	11.37	10.97	11.35	32090568.0
2009-01-27	AACC-DELISTED	Stock	4.09	4.18	4.02	4.12	20119.0
2009-01-27	AACG	Stock	3.57	3.75	3.1	3.46	40800.0
2009-01-27	AAI-DELISTED	Stock	4.54	4.54	4.04	4.1	2292278.0
2009-01-27	AAIC-DELISTED	Stock	3.4	4.0	3.4	3.8	244007.0
2009-01-27	AAME	Stock	0.86	0.95	0.86	0.9	2900.0
2009-01-27	AAON	Stock	3.5812	3.7116	3.4844	3.6504	398419.0
2009-01-27	AAP	Stock	33.37	33.89	32.6	33.03	1059900.0
2009-01-27	AATI-DELISTED	Stock	3.14	3.6	3.14	3.46	199075.0
2009-01-27	AAU-DELISTED	Stock	0.75	0.75	0.72	0.73	29285.0
2009-01-27	AAUAF-DELISTED	Stock	0.75	0.75	0.72	0.73	30285.0
2009-01-27	AAV-DELISTED	Stock	4.35	4.36	4.28	4.34	663706.0
2009-01-27	AAWW-DELISTED	Stock	16.64	17.015	16.58	16.74	136576.0
2009-01-27	AAXJ	Stock	30.64	31.0299	30.2423	30.94	46589.0
2009-01-27	AAXN-DELISTED	Stock	5.07	5.19	4.96	5.13	343045.0
2009-01-27	AB	Stock	17.68	18.16	16.76	17.71	494900.0
2009-01-27	ABAX-DELISTED	Stock	13.57	14.53	13.57	14.16	231273.0
2009-01-27	ABB-DELISTED	Stock	12.39	12.6005	12.27	12.52	3781282.0
2009-01-27	ABBC-DELISTED	Stock	7.26	7.7	7.16	7.54	45428.0
2009-01-27	ABBNY-DELISTED	Stock	12.39	12.6005	12.27	12.52	3785882.0
2009-01-27	ABC-DELISTED	Stock	18.45	18.83	18.33	18.44	6517412.0
2009-01-27	ABCB	Stock	7.9951	8.7538	7.9951	8.4231	20974.0
2009-01-27	ABCO-DELISTED	Stock	8.96	9.115	8.795	8.915	276704.0
2009-01-27	ABCW-DELISTED	Stock	2.25	2.47	2.2	2.3	71040.0
2009-01-27	ABD-DELISTED	Stock	1.77	1.81	1.75	1.76	116900.0
2009-01-27	ABE-DELISTED	Stock	12.37	12.37	11.86	12.29	8957.0
2009-01-27	ABEO	Stock	950.0	1125.0	950.0	1125.0	1.0
2009-01-27	ABFS-DELISTED	Stock	22.65	23.63	22.65	23.32	547228.0
2009-01-27	ABG	Stock	3.87	4.15	3.68	3.87	266000.0
2009-01-27	ABII-DELISTED	Stock	69.93	70.0	64.59	66.8	23972.0
2009-01-27	ABK-DELISTED	Stock	1.06	1.07	1.02	1.04	5480141.0
2009-01-27	ABM	Stock	15.97	16.14	15.66	15.97	283100.0
2009-01-27	ABMD-DELISTED	Stock	12.75	13.86	12.6	13.73	399400.0
2009-01-27	ABR	Stock	2.31	2.31	1.81	1.89	393700.0
2009-01-27	ABT	Stock	25.8708	26.2978	25.6309	26.0963	22438308.0
2009-01-27	ABTL-DELISTED	Stock	1.8	2.2	1.8	2.0	2530.0
2009-01-27	ABV-DELISTED	Stock	40.78	41.38	40.36	40.88	608638.0
2009-01-27	ABX-DELISTED	Stock	37.6	38.54	36.9	37.09	13776689.0
2009-01-27	ACAD	Stock	1.25	1.25	1.19	1.2	683800.0
2009-01-27	ACAP-DELISTED	Stock	40.73	42.26	40.73	42.1	36839.0
2009-01-27	ACAS-DELISTED	Stock	4.07	4.2	3.85	4.09	2336882.0
2009-01-27	ACAT-DELISTED	Stock	4.77	4.92	4.68	4.7	26351.0
2009-01-27	ACC-DELISTED	Stock	21.23	21.46	20.93	21.35	414319.0

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

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