PREVIEW / stock_daily / 2007-04-12

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-12.parquet
  size:    163 KB
  rows:    4,895
  symbols: 3,078

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
2007-04-12	AAPL	Stock	3.2871	3.2968	3.24	3.2925	656675600.0
2007-04-12	MSFT	Stock	28.06	28.62	28.04	28.54	43762100.0
2007-04-12	NVDA	Stock	0.4888	0.507	0.4857	0.5055	743640000.0
2007-04-12	AMZN	Stock	2.0865	2.1185	2.07	2.1135	95090000.0
2007-04-12	TLT	Stock	87.5	87.5699	87.28	87.39	495043.0
2007-04-12	CL	Stock	32.875	33.175	32.755	33.17	3005200.0
2007-04-12	A	Stock	24.7783	25.0	24.6924	24.9428	2765524.0
2007-04-12	AABA-DELISTED	Stock	31.2600002288818	31.4200000762939	31.1000003814697	31.2099990844727	13904800.0
2007-04-12	AACC-DELISTED	Stock	15.53	15.55	15.23	15.24	142362.0
2007-04-12	AACQ-DELISTED	Stock	4.36	4.4	4.36	4.37	28746.0
2007-04-12	AACQW-DELISTED	Stock	0.61	0.62	0.61	0.62	8250.0
2007-04-12	AAI-DELISTED	Stock	11.47	11.8	11.3	11.54	2815400.0
2007-04-12	AAIC-DELISTED	Stock	109.4	114.6	108.6	114.6	1986490.0
2007-04-12	AAME	Stock	4.01	4.23	3.96	4.08	6100.0
2007-04-12	AAON	Stock	3.3053	3.3567	3.2645	3.3567	160987.0
2007-04-12	AAP	Stock	39.99	40.23	39.37	39.95	594300.0
2007-04-12	AATI-DELISTED	Stock	6.69	6.8	6.66	6.71	465266.0
2007-04-12	AAU-DELISTED	Stock	2.36	2.4173	2.3	2.35	44440.0
2007-04-12	AAUAF-DELISTED	Stock	2.45	2.5099	2.4	2.44	42800.0
2007-04-12	AAV-DELISTED	Stock	10.39	10.45	10.3	10.4	418510.0
2007-04-12	AAWW-DELISTED	Stock	56.07	57.19	55.46	56.68	228750.0
2007-04-12	AAXN-DELISTED	Stock	7.84000015258789	8.10000038146973	7.80000019073486	8.03999996185303	1117800.0
2007-04-12	AB	Stock	92.02	93.06	91.84	93.06	209100.0
2007-04-12	ABAX-DELISTED	Stock	25.43	26.3	25.27	26.07	482112.0
2007-04-12	ABB-DELISTED	Stock	17.72	18.02	17.68	18.02	1640100.0
2007-04-12	ABBC-DELISTED	Stock	19.9	19.98	19.75	19.98	6803.0
2007-04-12	ABC-DELISTED	Stock	26.775	26.9	26.6	26.87	2166000.0
2007-04-12	ABCB	Stock	23.606	24.2091	23.5185	24.1313	25395.0
2007-04-12	ABCO-DELISTED	Stock	25.29	25.69	25.29	25.69	129796.0
2007-04-12	ABCW-DELISTED	Stock	27.55	27.71	27.34	27.62	52440.0
2007-04-12	ABD-DELISTED	Stock	24.86	24.91	24.72	24.84	341900.0
2007-04-12	ABE-DELISTED	Stock	19.7	19.8	19.56	19.79	14800.0
2007-04-12	ABFS-DELISTED	Stock	36.6	37.64	35.9	37.51	486490.0
2007-04-12	ABG	Stock	27.28	27.74	27.12	27.66	370000.0
2007-04-12	ABK-DELISTED	Stock	84.7	86.0	84.7	85.33	2485400.0
2007-04-12	ABM	Stock	26.89	27.0	26.52	26.98	281500.0
2007-04-12	ABMD-DELISTED	Stock	13.28	13.5	13.19	13.38	151555.0
2007-04-12	ABP-DELISTED	Stock	3.01	3.09	3.01	3.06	102900.0
2007-04-12	ABR	Stock	30.3	30.63	29.79	30.58	42600.0
2007-04-12	ABT	Stock	27.2526	27.6077	27.2382	27.5453	10219050.0
2007-04-12	ABTL-DELISTED	Stock	16.725	17.075	16.274	16.775	21698.0
2007-04-12	ABV-DELISTED	Stock	56.13	57.19	56.06	57.17	287900.0
2007-04-12	ABVA-DELISTED	Stock	14.59	15.94	14.57	15.7	6200.0
2007-04-12	ABVT-DELISTED	Stock	61.95	62.45	61.95	62.25	437.0
2007-04-12	ABX-DELISTED	Stock	28.96	29.03	28.76	28.95	5533711.0
2007-04-12	ACAD	Stock	15.8	15.8	15.21	15.63	456300.0
2007-04-12	ACAP-DELISTED	Stock	38.74	38.74	38.06	38.4	40459.0
2007-04-12	ACAS-DELISTED	Stock	45.5	45.58	45.02	45.48	1095599.0
2007-04-12	ACAT-DELISTED	Stock	18.45	18.83	18.41	18.79	59457.0
2007-04-12	ACC-DELISTED	Stock	28.35	30.02	28.35	29.74	115899.0

> showing 50 of 4,895 rows — these rows as CSV

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