PREVIEW / stock_daily / 2007-01-22

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-22.parquet
  size:    160 KB
  rows:    4,827
  symbols: 3,025

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-22	AAPL	Stock	3.1836	3.1843	3.0589	3.0996	1454026000.0
2007-01-22	MSFT	Stock	31.06	31.12	30.51	30.72	56143900.0
2007-01-22	NVDA	Stock	0.5363	0.545	0.5293	0.5313	730644000.0
2007-01-22	AMZN	Stock	1.8825	1.895	1.84	1.8475	166340000.0
2007-01-22	TLT	Stock	88.15	88.33	88.12	88.2	432000.0
2007-01-22	CL	Stock	33.45	33.58	32.93	33.26	3742200.0
2007-01-22	A	Stock	23.3691	23.412	23.2403	23.2976	4712099.0
2007-01-22	AABA-DELISTED	Stock	27.8500003814697	27.8999996185303	27.1800003051758	27.4200000762939	23199800.0
2007-01-22	AACC-DELISTED	Stock	15.45	15.51	15.31	15.39	60324.0
2007-01-22	AACQ-DELISTED	Stock	5.55	5.55	5.55	5.55	70000.0
2007-01-22	AACQU-DELISTED	Stock	6.78	6.78	6.78	6.78	200.0
2007-01-22	AACQW-DELISTED	Stock	0.65	0.65	0.64	0.64	31000.0
2007-01-22	AAI-DELISTED	Stock	12.06	12.16	11.67	11.7727	1796500.0
2007-01-22	AAIC-DELISTED	Stock	160.4	161.0	159.0	160.2	954200.0
2007-01-22	AAME	Stock	3.29	3.42	3.29	3.31	9700.0
2007-01-22	AAON	Stock	3.5819	3.5819	3.4831	3.4897	192122.0
2007-01-22	AAP	Stock	37.44	37.58	36.62	37.06	526600.0
2007-01-22	AATI-DELISTED	Stock	5.65	5.69	5.47	5.6	761526.0
2007-01-22	AAU-DELISTED	Stock	2.24	2.2401	2.21	2.23	23800.0
2007-01-22	AAUAF-DELISTED	Stock	2.24	2.2401	2.21	2.23	23800.0
2007-01-22	AAV-DELISTED	Stock	10.67	10.99	10.51	10.95	1218800.0
2007-01-22	AAWW-DELISTED	Stock	47.56	47.56	46.5	46.75	160540.0
2007-01-22	AAXN-DELISTED	Stock	7.88000011444092	7.90000009536743	7.75	7.84999990463257	885800.0
2007-01-22	AB	Stock	88.35	88.35	86.98	88.06	373500.0
2007-01-22	ABAX-DELISTED	Stock	17.93	18.15	17.45	17.66	252026.0
2007-01-22	ABB-DELISTED	Stock	17.54	17.58	17.41	17.47	846600.0
2007-01-22	ABBC-DELISTED	Stock	18.95	19.02	18.7	18.83	19131.0
2007-01-22	ABC-DELISTED	Stock	24.0	24.15	23.71	23.78	2494800.0
2007-01-22	ABCB	Stock	26.3683	26.3683	25.9793	25.9988	18095.0
2007-01-22	ABCO-DELISTED	Stock	27.0	27.11	26.63	26.99	143556.0
2007-01-22	ABCW-DELISTED	Stock	28.6	28.72	28.35	28.41	38480.0
2007-01-22	ABD-DELISTED	Stock	24.4	24.6	23.96	24.28	316990.0
2007-01-22	ABE-DELISTED	Stock	18.49	18.5	17.63	17.83	26100.0
2007-01-22	ABFS-DELISTED	Stock	39.27	39.37	38.16	38.48	532712.0
2007-01-22	ABG	Stock	23.74	23.82	23.48	23.61	153800.0
2007-01-22	ABK-DELISTED	Stock	87.53	87.53	86.39	86.9	378500.0
2007-01-22	ABM	Stock	24.35	24.46	24.2	24.35	382000.0
2007-01-22	ABMD-DELISTED	Stock	14.21	14.36	14.12	14.16	127588.0
2007-01-22	ABP-DELISTED	Stock	3.15	3.2	3.1	3.11	240600.0
2007-01-22	ABR	Stock	31.07	31.22	30.83	31.04	118800.0
2007-01-22	ABT	Stock	25.5254	25.6501	25.4198	25.5829	14853689.0
2007-01-22	ABTL-DELISTED	Stock	17.275	17.275	16.526	16.675	14074.0
2007-01-22	ABV-DELISTED	Stock	50.6	51.05	50.42	50.94	324600.0
2007-01-22	ABVA-DELISTED	Stock	16.77	16.79	16.71	16.79	4750.0
2007-01-22	ABVT-DELISTED	Stock	59.0	59.0	59.0	59.0	3.0
2007-01-22	ABX-DELISTED	Stock	28.61	28.78	28.09	28.37	4861600.0
2007-01-22	ACAD	Stock	7.22	7.29	7.18	7.25	129800.0
2007-01-22	ACAP-DELISTED	Stock	36.84	36.84	35.54	35.76	43714.0
2007-01-22	ACAS-DELISTED	Stock	47.38	47.38	46.95	47.13	518115.0
2007-01-22	ACAT-DELISTED	Stock	16.725	16.725	16.535	16.535	66578.0

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

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