PREVIEW / stock_daily / 2007-03-28

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-28.parquet
  size:    161 KB
  rows:    4,870
  symbols: 3,068

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-03-28	AAPL	Stock	3.3886	3.4071	3.3268	3.33	942337200.0
2007-03-28	MSFT	Stock	27.58	28.0	27.4	27.64	46947000.0
2007-03-28	NVDA	Stock	0.4922	0.4963	0.486	0.4868	459504000.0
2007-03-28	AMZN	Stock	1.9545	1.9755	1.937	1.967	124044000.0
2007-03-28	TLT	Stock	88.91	89.11	88.41	88.57	816815.0
2007-03-28	CL	Stock	33.17	33.49	33.04	33.44	3885800.0
2007-03-28	A	Stock	23.8054	24.1416	23.7268	23.9485	3550361.0
2007-03-28	AABA-DELISTED	Stock	31.4500007629395	31.7000007629395	31.25	31.4099998474121	13162500.0
2007-03-28	AACC-DELISTED	Stock	15.5	15.59	15.35	15.41	154513.0
2007-03-28	AACQ-DELISTED	Stock	4.3	4.34	4.3	4.34	2000.0
2007-03-28	AACQW-DELISTED	Stock	0.57	0.57	0.56	0.56	10000.0
2007-03-28	AAI-DELISTED	Stock	10.25	10.27	10.0278	10.2699	2780000.0
2007-03-28	AAIC-DELISTED	Stock	108.0	112.6	108.0	110.4	3723600.0
2007-03-28	AAME	Stock	3.95	3.95	3.71	3.93	4000.0
2007-03-28	AAON	Stock	3.4384	3.4384	3.3251	3.3699	593831.0
2007-03-28	AAP	Stock	38.92	39.08	38.55	38.73	1451500.0
2007-03-28	AATI-DELISTED	Stock	6.71	6.82	6.51	6.57	479562.0
2007-03-28	AAU-DELISTED	Stock	2.1	2.16	2.06	2.08	49315.0
2007-03-28	AAUAF-DELISTED	Stock	2.11	2.17	2.06	2.08	49200.0
2007-03-28	AAV-DELISTED	Stock	10.75	10.75	10.4	10.57	835000.0
2007-03-28	AAWW-DELISTED	Stock	53.01	53.01	52.15	52.5	372099.0
2007-03-28	AAXN-DELISTED	Stock	8.27000045776367	8.27000045776367	8.14999961853027	8.18000030517578	508400.0
2007-03-28	AB	Stock	87.68	87.68	86.25	87.47	233900.0
2007-03-28	ABAX-DELISTED	Stock	24.97	25.04	24.45	24.87	229584.0
2007-03-28	ABB-DELISTED	Stock	16.95	17.15	16.89	16.96	1477200.0
2007-03-28	ABBC-DELISTED	Stock	19.65	20.04	19.65	19.79	8254.0
2007-03-28	ABC-DELISTED	Stock	26.45	26.8	26.34	26.74	4156800.0
2007-03-28	ABCB	Stock	24.1605	24.1896	23.5088	23.538	100242.0
2007-03-28	ABCO-DELISTED	Stock	25.05	25.19	24.8	25.07	347243.0
2007-03-28	ABCW-DELISTED	Stock	27.88	27.97	27.74	27.93	83400.0
2007-03-28	ABD-DELISTED	Stock	23.43	23.73	23.25	23.44	526310.0
2007-03-28	ABE-DELISTED	Stock	18.28	18.53	18.05	18.53	31600.0
2007-03-28	ABFS-DELISTED	Stock	35.8	36.1	35.37	35.47	852227.0
2007-03-28	ABG	Stock	27.96	28.0	27.66	27.93	344600.0
2007-03-28	ABK-DELISTED	Stock	86.83	87.2	86.23	86.49	604700.0
2007-03-28	ABM	Stock	26.4	26.46	26.25	26.29	745600.0
2007-03-28	ABMD-DELISTED	Stock	13.62	13.8	13.4	13.46	168662.0
2007-03-28	ABP-DELISTED	Stock	3.25	3.27	3.17	3.2	87600.0
2007-03-28	ABR	Stock	30.2	30.26	29.75	29.83	142900.0
2007-03-28	ABT	Stock	26.984	27.1135	26.6337	26.7536	16386828.0
2007-03-28	ABTL-DELISTED	Stock	17.1	17.5	16.4	17.2	230360.0
2007-03-28	ABV-DELISTED	Stock	52.6	53.09	51.85	52.62	307700.0
2007-03-28	ABVA-DELISTED	Stock	15.38	15.85	15.29	15.85	4912.0
2007-03-28	ABX-DELISTED	Stock	29.19	29.2	28.78	28.92	4033800.0
2007-03-28	ACAD	Stock	16.11	16.66	14.64	15.42	1482600.0
2007-03-28	ACAP-DELISTED	Stock	38.45	39.34	38.16	38.75	95839.0
2007-03-28	ACAS-DELISTED	Stock	44.52	44.54	43.98	44.24	1334744.0
2007-03-28	ACAT-DELISTED	Stock	19.3	19.48	18.94	19.02	128733.0
2007-03-28	ACC-DELISTED	Stock	30.12	30.33	29.52	29.91	221800.0
2007-03-28	ACCL-DELISTED	Stock	6.41	6.47	6.2986	6.36	71419.0

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

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