PREVIEW / stock_daily / 2010-03-23

all stock daily files

  file:    by_date/stock_daily/2010/2010-03-23.parquet
  size:    192 KB
  rows:    5,941
  symbols: 3,516

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-03-23	AAPL	Stock	8.0586	8.1707	8.0036	8.1557	602431200.0
2010-03-23	MSFT	Stock	29.59	29.9	29.41	29.88	42026600.0
2010-03-23	NVDA	Stock	0.4415	0.4495	0.4385	0.4472	493612000.0
2010-03-23	AMZN	Stock	6.5445	6.547	6.4035	6.463	84262000.0
2010-03-23	TLT	Stock	91.07	91.32	90.91	90.93	2909928.0
2010-03-23	ES	Stock	27.12	27.27	26.97	27.24	755400.0
2010-03-23	CL	Stock	42.475	42.785	42.24	42.67	4531200.0
2010-03-23	A	Stock	24.1631	24.4707	24.0773	24.3991	5195807.0
2010-03-23	AABA-DELISTED	Stock	16.37	16.37	15.97	16.03	31254096.0
2010-03-23	AACC-DELISTED	Stock	6.29	6.4	6.25	6.37	9383.0
2010-03-23	AACG	Stock	4.0	4.05	3.92	4.0	56600.0
2010-03-23	AAI-DELISTED	Stock	5.1	5.13	5.0	5.1	2894833.0
2010-03-23	AAIC-DELISTED	Stock	18.02	18.28	17.97	18.05	81611.0
2010-03-23	AAME	Stock	1.48	1.55	1.48	1.55	2800.0
2010-03-23	AAON	Stock	4.3358	4.4365	4.3299	4.4089	269325.0
2010-03-23	AAP	Stock	43.77	44.11	43.66	43.96	1447500.0
2010-03-23	AATI-DELISTED	Stock	3.66	3.7102	3.58	3.68	225341.0
2010-03-23	AAU-DELISTED	Stock	0.9101	0.9349	0.9099	0.92	37469.0
2010-03-23	AAUAF-DELISTED	Stock	0.9102	0.935	0.91	0.92	37969.0
2010-03-23	AAV-DELISTED	Stock	7.02	7.3	7.02	7.19	1149180.0
2010-03-23	AAWW-DELISTED	Stock	48.69	50.97	48.2625	50.73	244402.0
2010-03-23	AAXJ	Stock	56.07	56.37	55.75	56.21	419456.0
2010-03-23	AAXN-DELISTED	Stock	6.42	6.6	6.4001	6.6	821381.0
2010-03-23	AB	Stock	29.0	30.09	28.9	30.03	486800.0
2010-03-23	ABAX-DELISTED	Stock	28.25	28.49	27.93	28.42	91173.0
2010-03-23	ABB-DELISTED	Stock	21.56	21.79	21.52	21.78	2004478.0
2010-03-23	ABBC-DELISTED	Stock	8.42	8.45	8.36	8.38	59743.0
2010-03-23	ABBNY-DELISTED	Stock	21.56	21.79	21.52	21.79	2004578.0
2010-03-23	ABC-DELISTED	Stock	29.43	29.43	28.9015	29.2	2335667.0
2010-03-23	ABCB	Stock	9.5112	9.7581	9.4025	9.6495	28147.0
2010-03-23	ABCD-DELISTED	Stock	3.9	3.93	3.81	3.91	29260.0
2010-03-23	ABCO-DELISTED	Stock	16.433	16.717	16.348	16.692	65133.0
2010-03-23	ABCW-DELISTED	Stock	1.24	1.24	1.2	1.21	131030.0
2010-03-23	ABD-DELISTED	Stock	7.31	7.4	7.09	7.36	328750.0
2010-03-23	ABE-DELISTED	Stock	16.67	16.7299	16.55	16.71	9431.0
2010-03-23	ABEO	Stock	3187.5	3187.5	3075.0	3187.5	24.0
2010-03-23	ABFS-DELISTED	Stock	29.92	30.22	29.52	30.04	222885.0
2010-03-23	ABG	Stock	14.02	14.33	13.9	14.24	282600.0
2010-03-23	ABII-DELISTED	Stock	52.02	53.4581	51.43	52.63	100278.0
2010-03-23	ABK-DELISTED	Stock	0.76	0.765	0.7	0.729	9655109.0
2010-03-23	ABM	Stock	20.65	20.95	20.54	20.91	198000.0
2010-03-23	ABMD-DELISTED	Stock	10.22	10.42	10.1401	10.41	101709.0
2010-03-23	ABR	Stock	2.7	2.97	2.7	2.89	210200.0
2010-03-23	ABT	Stock	25.962	26.0963	25.8228	26.0723	9704460.0
2010-03-23	ABTL-DELISTED	Stock	5.55	5.55	5.3	5.35	24990.0
2010-03-23	ABV-DELISTED	Stock	93.45	93.53	92.0	92.7	570054.0
2010-03-23	ABVA-DELISTED	Stock	2.65	2.65	2.6499	2.65	3000.0
2010-03-23	ABVT-DELISTED	Stock	54.85	55.01	54.27	54.79	97216.0
2010-03-23	ABX-DELISTED	Stock	39.24	39.76	38.621	38.7983	13165464.0
2010-03-23	ACAD	Stock	1.57	1.6	1.53	1.58	369500.0

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

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