PREVIEW / stock_daily / 2007-12-28

all stock daily files

  file:    by_date/stock_daily/2007/2007-12-28.parquet
  size:    184 KB
  rows:    5,697
  symbols: 3,453

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-28	AAPL	Stock	7.1639	7.1986	7.0314	7.1368	699647200.0
2007-12-28	MSFT	Stock	36.1	36.23	35.67	36.12	33447200.0
2007-12-28	NVDA	Stock	0.877	0.8875	0.8622	0.8698	262064000.0
2007-12-28	AMZN	Stock	4.7635	4.795	4.605	4.7225	151758000.0
2007-12-28	TLT	Stock	91.65	92.58	91.5	92.48	1967735.0
2007-12-28	CL	Stock	39.095	39.545	39.095	39.37	1836800.0
2007-12-28	A	Stock	26.5236	26.8312	26.5236	26.8169	3284321.0
2007-12-28	AABA-DELISTED	Stock	23.66	23.71	23.21	23.44	13777270.0
2007-12-28	AACC-DELISTED	Stock	10.6	10.85	10.47	10.72	122485.0
2007-12-28	AAI-DELISTED	Stock	7.36	7.55	7.22	7.22	980262.0
2007-12-28	AAIC-DELISTED	Stock	63.2	64.2	60.6	60.8	2308351.0
2007-12-28	AAME	Stock	1.48	1.48	1.42	1.44	3200.0
2007-12-28	AAON	Stock	4.0494	4.164	3.8657	4.0158	226800.0
2007-12-28	AAP	Stock	38.27	38.73	38.06	38.17	606400.0
2007-12-28	AATI-DELISTED	Stock	11.69	11.74	11.5	11.52	171713.0
2007-12-28	AAU-DELISTED	Stock	2.52	2.57	2.49	2.52	60300.0
2007-12-28	AAUAF-DELISTED	Stock	2.52	2.57	2.49	2.5201	75800.0
2007-12-28	AAV-DELISTED	Stock	8.85	8.87	8.7	8.74	1637166.0
2007-12-28	AAWW-DELISTED	Stock	54.21	55.19	53.51	53.6	49412.0
2007-12-28	AAXN-DELISTED	Stock	15.02	15.09	14.67	14.71	577182.0
2007-12-28	AB	Stock	77.74	77.99	76.81	77.34	405700.0
2007-12-28	ABAX-DELISTED	Stock	36.98	38.0	36.43	36.79	177524.0
2007-12-28	ABB-DELISTED	Stock	29.02	29.18	28.85	29.1	3807309.0
2007-12-28	ABBC-DELISTED	Stock	9.52	9.57	9.33	9.46	169843.0
2007-12-28	ABBNY-DELISTED	Stock	29.02	29.18	28.85	29.13	3807309.0
2007-12-28	ABC-DELISTED	Stock	22.97	23.03	22.7	22.72	1267364.0
2007-12-28	ABCB	Stock	16.6322	16.9142	16.1361	16.1945	46780.0
2007-12-28	ABCO-DELISTED	Stock	33.12	33.87	33.02	33.02	143704.0
2007-12-28	ABCW-DELISTED	Stock	24.55	24.92	23.6	23.92	70080.0
2007-12-28	ABD-DELISTED	Stock	16.08	16.33	15.94	16.05	184940.0
2007-12-28	ABE-DELISTED	Stock	27.02	27.921	26.838	27.13	7700.0
2007-12-28	ABEO	Stock	4125.0	4125.0	3437.5	3750.0	11.0
2007-12-28	ABFS-DELISTED	Stock	23.11	23.47	22.11	22.18	431215.0
2007-12-28	ABG	Stock	15.2	15.31	14.96	15.13	284700.0
2007-12-28	ABII-DELISTED	Stock	69.0	69.59	68.13	69.0	44998.0
2007-12-28	ABK-DELISTED	Stock	27.85	27.9	24.75	25.14	7143623.0
2007-12-28	ABM	Stock	20.11	21.0	20.11	20.75	296100.0
2007-12-28	ABMD-DELISTED	Stock	15.7	15.76	15.4	15.49	177443.0
2007-12-28	ABP-DELISTED	Stock	3.96	4.02	3.87	3.94	234389.0
2007-12-28	ABR	Stock	17.25	17.3	16.35	16.44	291300.0
2007-12-28	ABT	Stock	27.387	27.5549	27.1567	27.459	7600250.0
2007-12-28	ABTL-DELISTED	Stock	14.354	14.354	13.646	14.0	15096.0
2007-12-28	ABV-DELISTED	Stock	73.25	73.64	72.31	72.89	532317.0
2007-12-28	ABVA-DELISTED	Stock	7.05	7.05	6.56	6.6	9900.0
2007-12-28	ABVT-DELISTED	Stock	75.5	75.5	75.0	75.0	4461.0
2007-12-28	ABX-DELISTED	Stock	40.72	42.92	40.72	42.86	8040721.0
2007-12-28	ACAD	Stock	11.43	11.63	11.04	11.04	186100.0
2007-12-28	ACAP-DELISTED	Stock	43.3	44.01	41.67	42.15	97478.0
2007-12-28	ACAS-DELISTED	Stock	33.32	33.78	33.0	33.11	3046722.0
2007-12-28	ACAT-DELISTED	Stock	11.98	12.56	11.83	12.01	65653.0

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

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