PREVIEW / stock_daily / 2007-01-30

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-30.parquet
  size:    161 KB
  rows:    4,835
  symbols: 3,037

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-01-30	AAPL	Stock	3.0868	3.0889	3.0446	3.0554	577970400.0
2007-01-30	MSFT	Stock	30.57	30.64	30.14	30.48	61900400.0
2007-01-30	NVDA	Stock	0.5063	0.516	0.5018	0.5127	636174000.0
2007-01-30	AMZN	Stock	1.8645	1.871	1.8315	1.8525	96270000.0
2007-01-30	TLT	Stock	86.89	86.91	86.76	86.82	1295100.0
2007-01-30	CL	Stock	33.26	33.775	33.0	33.71	8629200.0
2007-01-30	A	Stock	22.8827	22.9471	22.7969	22.8898	2007808.0
2007-01-30	AABA-DELISTED	Stock	27.8700008392334	28.3899993896484	27.6100006103516	28.0400009155273	13576600.0
2007-01-30	AACC-DELISTED	Stock	15.37	15.55	15.37	15.47	103716.0
2007-01-30	AACQ-DELISTED	Stock	5.58	5.58	5.58	5.58	5000.0
2007-01-30	AACQW-DELISTED	Stock	0.75	0.8	0.75	0.8	199400.0
2007-01-30	AAI-DELISTED	Stock	11.25	11.27	11.01	11.205	2171700.0
2007-01-30	AAIC-DELISTED	Stock	152.4	154.8	151.0	153.8	627600.0
2007-01-30	AAME	Stock	3.25	3.34	3.25	3.32	1800.0
2007-01-30	AAON	Stock	3.6359	3.6583	3.599	3.6412	86569.0
2007-01-30	AAP	Stock	37.46	37.55	36.93	37.06	554200.0
2007-01-30	AATI-DELISTED	Stock	5.88	5.88	5.73	5.74	341151.0
2007-01-30	AAU-DELISTED	Stock	2.5	2.51	2.3352	2.46	66566.0
2007-01-30	AAUAF-DELISTED	Stock	2.49	2.5	2.3305	2.46	66700.0
2007-01-30	AAV-DELISTED	Stock	10.81	10.87	10.77	10.84	479800.0
2007-01-30	AAWW-DELISTED	Stock	47.5	47.5	46.61	47.16	41167.0
2007-01-30	AAXN-DELISTED	Stock	7.67000007629395	7.84999990463257	7.67000007629395	7.82999992370605	740000.0
2007-01-30	AB	Stock	89.8	90.2	88.79	89.4	424200.0
2007-01-30	ABAX-DELISTED	Stock	21.87	21.9499	21.41	21.67	237154.0
2007-01-30	ABB-DELISTED	Stock	17.65	17.8	17.59	17.79	800700.0
2007-01-30	ABBC-DELISTED	Stock	19.16	19.16	19.01	19.16	6802.0
2007-01-30	ABC-DELISTED	Stock	26.02	26.2	25.86	26.17	2675600.0
2007-01-30	ABCB	Stock	26.0376	26.0376	25.2692	25.4152	33209.0
2007-01-30	ABCO-DELISTED	Stock	27.42	27.44	27.13	27.34	98631.0
2007-01-30	ABCW-DELISTED	Stock	29.16	29.5	28.85	29.5	80220.0
2007-01-30	ABD-DELISTED	Stock	24.78	24.97	24.3	24.92	611200.0
2007-01-30	ABE-DELISTED	Stock	18.49	18.5	18.2713	18.37	20600.0
2007-01-30	ABFS-DELISTED	Stock	37.28	38.66	37.1	38.29	652210.0
2007-01-30	ABG	Stock	24.27	24.4	24.06	24.12	134100.0
2007-01-30	ABK-DELISTED	Stock	87.1	88.58	86.59	88.28	605100.0
2007-01-30	ABM	Stock	25.4	25.6	25.24	25.53	215500.0
2007-01-30	ABMD-DELISTED	Stock	14.35	14.6	14.35	14.52	53548.0
2007-01-30	ABP-DELISTED	Stock	3.14	3.41	3.1	3.39	304300.0
2007-01-30	ABR	Stock	31.53	31.79	31.45	31.79	45200.0
2007-01-30	ABT	Stock	25.3095	25.535	25.2951	25.5206	13542726.0
2007-01-30	ABTL-DELISTED	Stock	18.075	18.725	17.926	18.725	29461.0
2007-01-30	ABV-DELISTED	Stock	50.15	50.91	49.97	50.67	360000.0
2007-01-30	ABVA-DELISTED	Stock	16.55	16.6	16.5	16.6	1600.0
2007-01-30	ABVT-DELISTED	Stock	57.5	57.5	57.5	57.5	2.0
2007-01-30	ABX-DELISTED	Stock	29.17	29.58	29.12	29.4	3637300.0
2007-01-30	ACAD	Stock	7.06	7.1	7.01	7.03	54100.0
2007-01-30	ACAP-DELISTED	Stock	38.65	38.82	38.27	38.78	30935.0
2007-01-30	ACAS-DELISTED	Stock	47.85	47.86	47.52	47.75	566294.0
2007-01-30	ACAT-DELISTED	Stock	18.75	18.87	18.33	18.68	73466.0
2007-01-30	ACC-DELISTED	Stock	31.13	31.42	31.01	31.27	77765.0

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

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