PREVIEW / stock_daily / 2007-12-24

all stock daily files

  file:    by_date/stock_daily/2007/2007-12-24.parquet
  size:    178 KB
  rows:    5,578
  symbols: 3,374

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-12-24	AAPL	Stock	6.9654	7.1189	6.9568	7.1	480202800.0
2007-12-24	MSFT	Stock	36.13	36.72	36.05	36.58	29622600.0
2007-12-24	NVDA	Stock	0.8855	0.8988	0.879	0.8945	104008000.0
2007-12-24	AMZN	Stock	4.5525	4.578	4.515	4.5505	40342000.0
2007-12-24	TLT	Stock	91.22	91.47	91.08	91.24	550257.0
2007-12-24	CL	Stock	39.5	39.66	39.14	39.23	1581000.0
2007-12-24	A	Stock	26.5308	26.6738	26.3662	26.4521	1075062.0
2007-12-24	AABA-DELISTED	Stock	24.02	24.19	23.94	24.04	24861780.0
2007-12-24	AACC-DELISTED	Stock	11.16	11.24	10.92	11.2	91066.0
2007-12-24	AAI-DELISTED	Stock	7.73	7.84	7.65	7.82	538683.0
2007-12-24	AAIC-DELISTED	Stock	65.4	69.8	65.0	69.8	924149.0
2007-12-24	AAME	Stock	1.39	1.43	1.39	1.42	11500.0
2007-12-24	AAON	Stock	4.1679	4.3378	3.9546	4.3378	233381.0
2007-12-24	AAP	Stock	38.35	38.58	38.11	38.5	259200.0
2007-12-24	AATI-DELISTED	Stock	12.24	12.3	11.96	12.018	177078.0
2007-12-24	AAU-DELISTED	Stock	2.47	2.53	2.44	2.44	15230.0
2007-12-24	AAUAF-DELISTED	Stock	2.47	2.53	2.44	2.4414	15960.0
2007-12-24	AAV-DELISTED	Stock	9.2	9.2	9.05	9.1	703632.0
2007-12-24	AAWW-DELISTED	Stock	55.76	55.99	54.75	55.59	25917.0
2007-12-24	AAXN-DELISTED	Stock	15.25	15.31	15.06	15.2	500174.0
2007-12-24	AB	Stock	78.56	80.95	78.56	80.03	104900.0
2007-12-24	ABAX-DELISTED	Stock	37.71	39.75	37.43	39.698	260845.0
2007-12-24	ABB-DELISTED	Stock	28.3	28.47	28.05	28.4	1109242.0
2007-12-24	ABBC-DELISTED	Stock	9.57	9.57	9.46	9.5	18283.0
2007-12-24	ABBNY-DELISTED	Stock	28.3	28.47	28.05	28.4	1109242.0
2007-12-24	ABC-DELISTED	Stock	22.54	22.71	22.3	22.7	814400.0
2007-12-24	ABCB	Stock	17.7799	18.0911	17.7118	18.0717	25395.0
2007-12-24	ABCO-DELISTED	Stock	33.42	33.86	32.81	33.8	88465.0
2007-12-24	ABCW-DELISTED	Stock	24.98	25.66	24.5	25.66	46430.0
2007-12-24	ABD-DELISTED	Stock	16.26	16.57	15.9	16.5	124400.0
2007-12-24	ABE-DELISTED	Stock	26.89	27.41	26.89	27.38	13180.0
2007-12-24	ABEO	Stock	3325.0	5250.0	3325.0	4375.0	50.0
2007-12-24	ABFS-DELISTED	Stock	22.67	23.32	22.53	23.25	134080.0
2007-12-24	ABG	Stock	15.35	15.84	15.13	15.79	94600.0
2007-12-24	ABII-DELISTED	Stock	65.55	68.76	61.8301	68.07	11364.0
2007-12-24	ABK-DELISTED	Stock	27.48	27.48	25.72	26.77	1357082.0
2007-12-24	ABM	Stock	20.67	20.99	20.47	20.99	69800.0
2007-12-24	ABMD-DELISTED	Stock	15.57	15.84	15.22	15.74	109194.0
2007-12-24	ABP-DELISTED	Stock	3.54	3.7	3.5	3.52	84125.0
2007-12-24	ABR	Stock	17.26	18.0	17.25	17.97	94000.0
2007-12-24	ABT	Stock	27.8956	28.0971	27.8524	27.9963	2770113.0
2007-12-24	ABTL-DELISTED	Stock	15.4	15.4	14.7	14.75	7965.0
2007-12-24	ABV-DELISTED	Stock	72.09	73.86	71.79	73.65	122700.0
2007-12-24	ABVA-DELISTED	Stock	6.71	7.17	6.7	7.17	6225.0
2007-12-24	ABVT-DELISTED	Stock	76.0	76.0	76.0	76.0	1000.0
2007-12-24	ABX-DELISTED	Stock	39.2	39.68	39.15	39.37	1648206.0
2007-12-24	ACAD	Stock	12.44	12.52	12.18	12.37	104400.0
2007-12-24	ACAP-DELISTED	Stock	43.03	44.5	42.56	43.92	68183.0
2007-12-24	ACAS-DELISTED	Stock	34.48	34.85	34.3	34.65	1291832.0
2007-12-24	ACAT-DELISTED	Stock	13.01	13.08	12.78	12.79	33120.0

> showing 50 of 5,578 rows — these rows as CSV

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