PREVIEW / stock_daily / 2007-01-16

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-16.parquet
  size:    161 KB
  rows:    4,832
  symbols: 3,043

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-16	AAPL	Stock	3.4171	3.4732	3.4089	3.4679	1244076400.0
2007-01-16	MSFT	Stock	31.26	31.45	31.03	31.16	62379600.0
2007-01-16	NVDA	Stock	0.5917	0.592	0.5815	0.5882	711864000.0
2007-01-16	AMZN	Stock	1.92	1.9445	1.8985	1.933	112874000.0
2007-01-16	TLT	Stock	88.23	88.24	88.03	88.2	702800.0
2007-01-16	CL	Stock	33.87	34.015	33.375	33.43	2985000.0
2007-01-16	A	Stock	23.97	24.2704	23.8484	23.9914	4328907.0
2007-01-16	AABA-DELISTED	Stock	29.8799991607666	29.8799991607666	28.7900009155273	29.2900009155273	24448400.0
2007-01-16	AACC-DELISTED	Stock	16.39	16.68	15.6	15.66	115637.0
2007-01-16	AACQU-DELISTED	Stock	6.66	6.66	6.65	6.66	5550.0
2007-01-16	AAI-DELISTED	Stock	12.74	13.09	12.71	12.86	2336600.0
2007-01-16	AAIC-DELISTED	Stock	165.6	165.8	161.4	162.8	1255300.0
2007-01-16	AAME	Stock	3.38	3.38	3.31	3.33	4000.0
2007-01-16	AAON	Stock	3.7083	3.7241	3.6701	3.6767	292359.0
2007-01-16	AAP	Stock	36.4	36.5	35.96	36.2	1185300.0
2007-01-16	AATI-DELISTED	Stock	6.05	6.09	5.61	5.71	642389.0
2007-01-16	AAU-DELISTED	Stock	2.33	2.36	2.18	2.26	26600.0
2007-01-16	AAUAF-DELISTED	Stock	2.33	2.36	2.18	2.26	26600.0
2007-01-16	AAV-DELISTED	Stock	10.52	10.69	10.4	10.54	561900.0
2007-01-16	AAWW-DELISTED	Stock	47.12	47.46	47.12	47.4	158903.0
2007-01-16	AAXN-DELISTED	Stock	8.19999980926514	8.28999996185303	8.13000011444092	8.18000030517578	649300.0
2007-01-16	AB	Stock	87.31	87.85	86.96	87.6	266000.0
2007-01-16	ABAX-DELISTED	Stock	19.37	19.5	18.95	19.14	243441.0
2007-01-16	ABB-DELISTED	Stock	17.55	17.58	17.43	17.49	1562200.0
2007-01-16	ABBC-DELISTED	Stock	19.17	19.2	18.86	19.0	5055.0
2007-01-16	ABC-DELISTED	Stock	23.79	23.91	23.66	23.83	1525303.0
2007-01-16	ABCB	Stock	27.9051	27.9051	27.1561	27.3507	17170.0
2007-01-16	ABCO-DELISTED	Stock	27.08	27.47	26.82	26.84	304455.0
2007-01-16	ABCW-DELISTED	Stock	29.24	29.25	28.54	28.82	38390.0
2007-01-16	ABD-DELISTED	Stock	25.85	26.03	25.78	26.01	172820.0
2007-01-16	ABE-DELISTED	Stock	18.3	18.42	18.02	18.11	60500.0
2007-01-16	ABFS-DELISTED	Stock	40.14	41.24	39.94	40.22	280480.0
2007-01-16	ABG	Stock	22.12	23.23	22.12	22.94	424200.0
2007-01-16	ABK-DELISTED	Stock	88.7	89.1	88.09	88.35	335800.0
2007-01-16	ABM	Stock	24.83	24.92	24.19	24.24	369700.0
2007-01-16	ABMD-DELISTED	Stock	14.58	14.79	14.5201	14.73	120099.0
2007-01-16	ABP-DELISTED	Stock	3.1	3.2	3.09	3.1	182600.0
2007-01-16	ABR	Stock	30.41	30.65	30.15	30.38	47100.0
2007-01-16	ABT	Stock	24.2347	24.4122	24.1723	24.2827	12213214.0
2007-01-16	ABTL-DELISTED	Stock	16.625	16.675	14.328	16.375	134440.0
2007-01-16	ABV-DELISTED	Stock	50.0	50.3499	49.71	50.28	366300.0
2007-01-16	ABVA-DELISTED	Stock	16.4	16.463	16.4	16.463	400.0
2007-01-16	ABX-DELISTED	Stock	29.26	29.3	28.8	28.96	3011100.0
2007-01-16	ACAD	Stock	7.43	7.44	6.73	6.84	485900.0
2007-01-16	ACAP-DELISTED	Stock	39.22	39.36	38.46	38.63	31669.0
2007-01-16	ACAS-DELISTED	Stock	47.18	47.32	47.0	47.12	787611.0
2007-01-16	ACAT-DELISTED	Stock	16.85	16.91	16.65	16.87	116998.0
2007-01-16	ACC-DELISTED	Stock	29.55	30.45	29.53	29.83	177600.0
2007-01-16	ACCL-DELISTED	Stock	6.05	6.11	5.82	6.08	52086.0
2007-01-16	ACCO	Stock	25.8	26.06	25.8	26.06	221000.0

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

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