PREVIEW / stock_daily / 2007-12-13

all stock daily files

  file:    by_date/stock_daily/2007/2007-12-13.parquet
  size:    181 KB
  rows:    5,611
  symbols: 3,400

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-13	AAPL	Stock	6.7925	6.8614	6.7079	6.8511	864617600.0
2007-12-13	MSFT	Stock	34.48	35.45	34.28	35.22	73913200.0
2007-12-13	NVDA	Stock	0.876	0.8818	0.837	0.8625	500364000.0
2007-12-13	AMZN	Stock	4.5525	4.65	4.5315	4.62	120926000.0
2007-12-13	TLT	Stock	91.61	91.82	90.9	91.03	1222100.0
2007-12-13	CL	Stock	39.785	40.37	39.765	40.195	3993800.0
2007-12-13	A	Stock	26.3448	26.6094	26.1588	26.4378	2762867.0
2007-12-13	AABA-DELISTED	Stock	24.4	24.75	24.19	24.37	23798399.0
2007-12-13	AACC-DELISTED	Stock	11.16	11.67	10.97	11.19	128627.0
2007-12-13	AAI-DELISTED	Stock	8.0	8.17	7.73	8.07	2484668.0
2007-12-13	AAIC-DELISTED	Stock	55.2	58.2	54.0	58.2	1170600.0
2007-12-13	AAME	Stock	1.42	1.56	1.42	1.53	5100.0
2007-12-13	AAON	Stock	3.7827	3.8459	3.7175	3.842	301219.0
2007-12-13	AAP	Stock	38.22	38.66	37.97	38.52	964400.0
2007-12-13	AATI-DELISTED	Stock	11.72	11.79	11.4	11.56	534208.0
2007-12-13	AAU-DELISTED	Stock	2.41	2.53	2.39	2.44	44100.0
2007-12-13	AAUAF-DELISTED	Stock	2.41	2.53	2.39	2.44	45100.0
2007-12-13	AAV-DELISTED	Stock	10.1	10.13	10.03	10.06	509400.0
2007-12-13	AAWW-DELISTED	Stock	53.71	54.21	52.81	54.02	136323.0
2007-12-13	AAXN-DELISTED	Stock	14.8	14.93	14.28	14.6	1260230.0
2007-12-13	AB	Stock	79.01	80.68	78.09	79.98	290300.0
2007-12-13	ABAX-DELISTED	Stock	35.72	37.14	35.5	36.89	223423.0
2007-12-13	ABB-DELISTED	Stock	28.38	28.44	27.93	28.35	3193193.0
2007-12-13	ABBC-DELISTED	Stock	8.88	9.0	8.84	8.94	68803.0
2007-12-13	ABBNY-DELISTED	Stock	28.38	28.44	27.93	28.37	3193193.0
2007-12-13	ABC-DELISTED	Stock	21.83	22.08	21.74	21.87	2733600.0
2007-12-13	ABCB	Stock	16.2917	17.3617	16.2917	17.2157	45546.0
2007-12-13	ABCO-DELISTED	Stock	32.37	32.42	31.82	32.29	182428.0
2007-12-13	ABCW-DELISTED	Stock	24.02	24.52	23.75	24.34	73460.0
2007-12-13	ABD-DELISTED	Stock	16.47	16.65	16.3	16.53	238900.0
2007-12-13	ABE-DELISTED	Stock	27.73	27.74	27.08	27.17	29570.0
2007-12-13	ABEO	Stock	3062.5	3437.5	3062.5	3062.5	3.0
2007-12-13	ABFS-DELISTED	Stock	22.79	23.38	22.6	23.34	578632.0
2007-12-13	ABG	Stock	15.87	15.88	15.07	15.29	640000.0
2007-12-13	ABII-DELISTED	Stock	71.5	72.17	70.64	71.0	77403.0
2007-12-13	ABK-DELISTED	Stock	24.25	25.98	22.97	23.69	15652814.0
2007-12-13	ABM	Stock	19.56	19.59	19.16	19.51	381400.0
2007-12-13	ABMD-DELISTED	Stock	14.43	15.0	14.2	14.95	234446.0
2007-12-13	ABP-DELISTED	Stock	3.41	3.47	3.26	3.34	234900.0
2007-12-13	ABR	Stock	17.82	18.0	17.25	17.96	211600.0
2007-12-13	ABT	Stock	27.766	28.0587	27.5885	28.0107	8323051.0
2007-12-13	ABTL-DELISTED	Stock	15.0	15.05	14.849	15.0	12362.0
2007-12-13	ABV-DELISTED	Stock	73.92	74.43	73.03	73.91	574300.0
2007-12-13	ABVA-DELISTED	Stock	6.9	7.0699	6.9	7.0699	2600.0
2007-12-13	ABVT-DELISTED	Stock	76.5	76.85	76.5	76.85	7100.0
2007-12-13	ABX-DELISTED	Stock	39.1	39.39	37.93	38.13	8607825.0
2007-12-13	ACAD	Stock	12.22	12.29	11.62	11.99	341700.0
2007-12-13	ACAP-DELISTED	Stock	43.92	45.1	43.6	44.6	72612.0
2007-12-13	ACAS-DELISTED	Stock	36.53	36.93	36.05	36.8	2520876.0
2007-12-13	ACAT-DELISTED	Stock	12.03	12.58	11.55	12.01	145103.0

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

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