PREVIEW / stock_daily / 2007-12-27

all stock daily files

  file:    by_date/stock_daily/2007/2007-12-27.parquet
  size:    183 KB
  rows:    5,685
  symbols: 3,445

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-27	AAPL	Stock	7.1054	7.2486	7.0643	7.0918	795527600.0
2007-12-27	MSFT	Stock	36.35	36.55	35.94	35.97	33311100.0
2007-12-27	NVDA	Stock	0.905	0.91	0.8762	0.8785	241368000.0
2007-12-27	AMZN	Stock	4.6335	4.7645	4.625	4.7125	142274000.0
2007-12-27	TLT	Stock	90.88	91.1599	90.51	91.06	468600.0
2007-12-27	CL	Stock	39.33	39.625	39.17	39.255	2143800.0
2007-12-27	A	Stock	26.6738	26.8455	26.5665	26.5665	2628520.0
2007-12-27	AABA-DELISTED	Stock	23.6	24.15	23.57	23.7	16041411.0
2007-12-27	AACC-DELISTED	Stock	10.94	11.01	10.5	10.52	86221.0
2007-12-27	AAI-DELISTED	Stock	7.61	7.64	7.35	7.36	1255935.0
2007-12-27	AAIC-DELISTED	Stock	64.2	65.6	61.8	63.0	2230518.0
2007-12-27	AAME	Stock	1.38	1.5	1.38	1.48	16200.0
2007-12-27	AAON	Stock	4.164	4.2094	3.9743	3.998	325012.0
2007-12-27	AAP	Stock	38.42	38.78	38.14	38.25	598800.0
2007-12-27	AATI-DELISTED	Stock	12.13	12.13	11.53	11.62	409679.0
2007-12-27	AAU-DELISTED	Stock	2.5	2.55	2.46	2.48	34700.0
2007-12-27	AAUAF-DELISTED	Stock	2.5	2.55	2.46	2.48	35400.0
2007-12-27	AAV-DELISTED	Stock	8.94	9.06	8.71	8.87	1590545.0
2007-12-27	AAWW-DELISTED	Stock	55.43	55.44	53.81	53.82	84934.0
2007-12-27	AAXN-DELISTED	Stock	15.17	15.3	14.87	14.8828	636662.0
2007-12-27	AB	Stock	79.6	79.73	77.97	78.11	142200.0
2007-12-27	ABAX-DELISTED	Stock	38.98	38.98	36.6176	36.76	234999.0
2007-12-27	ABB-DELISTED	Stock	28.57	29.09	28.5	28.77	4832893.0
2007-12-27	ABBC-DELISTED	Stock	9.42	9.54	9.42	9.47	44905.0
2007-12-27	ABBNY-DELISTED	Stock	28.57	29.09	28.5	28.8	4849893.0
2007-12-27	ABC-DELISTED	Stock	22.68	22.88	22.59	22.75	1663400.0
2007-12-27	ABCB	Stock	17.7702	17.7702	16.389	16.4279	61379.0
2007-12-27	ABCO-DELISTED	Stock	34.51	34.51	32.94	32.94	124052.0
2007-12-27	ABCW-DELISTED	Stock	25.24	25.24	24.15	24.18	115660.0
2007-12-27	ABD-DELISTED	Stock	16.41	16.78	15.84	15.99	399010.0
2007-12-27	ABE-DELISTED	Stock	27.5	27.66	26.6901	27.01	7700.0
2007-12-27	ABEO	Stock	4125.0	4125.0	3125.0	4125.0	12.0
2007-12-27	ABFS-DELISTED	Stock	22.91	23.04	21.81	21.95	360651.0
2007-12-27	ABG	Stock	15.51	15.6	15.04	15.04	133400.0
2007-12-27	ABII-DELISTED	Stock	67.06	70.0	67.06	69.41	10835.0
2007-12-27	ABK-DELISTED	Stock	29.84	30.04	26.74	29.13	2814130.0
2007-12-27	ABM	Stock	20.81	21.32	20.04	20.11	215000.0
2007-12-27	ABMD-DELISTED	Stock	15.76	15.87	15.57	15.61	216210.0
2007-12-27	ABP-DELISTED	Stock	3.9	4.09	3.79	3.86	299890.0
2007-12-27	ABR	Stock	17.67	17.82	16.7	16.88	341600.0
2007-12-27	ABT	Stock	27.6701	27.79	27.315	27.339	7759066.0
2007-12-27	ABTL-DELISTED	Stock	14.575	14.976	14.175	14.225	8717.0
2007-12-27	ABV-DELISTED	Stock	73.63	73.63	72.05	72.55	340392.0
2007-12-27	ABVA-DELISTED	Stock	6.9	7.08	6.84	6.84	1570.0
2007-12-27	ABVT-DELISTED	Stock	75.0	75.0	74.5	75.0	6650.0
2007-12-27	ABX-DELISTED	Stock	40.39	40.74	39.94	40.24	4639803.0
2007-12-27	ACAD	Stock	12.2	12.34	11.37	11.41	157200.0
2007-12-27	ACAP-DELISTED	Stock	43.08	44.0	42.84	43.18	69718.0
2007-12-27	ACAS-DELISTED	Stock	33.9646	34.2442	33.1157	33.3	2856766.0
2007-12-27	ACAT-DELISTED	Stock	12.69	12.92	11.8	11.87	142515.0

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

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