PREVIEW / stock_daily / 2007-02-21

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-21.parquet
  size:    162 KB
  rows:    4,868
  symbols: 3,067

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-02-21	AAPL	Stock	3.0707	3.1961	3.07	3.1857	1155313600.0
2007-02-21	MSFT	Stock	28.75	29.39	28.74	29.35	68604900.0
2007-02-21	NVDA	Stock	0.5457	0.5515	0.5365	0.542	655332000.0
2007-02-21	AMZN	Stock	2.0595	2.066	2.046	2.063	90168000.0
2007-02-21	TLT	Stock	88.53	88.7	88.48	88.69	379800.0
2007-02-21	CL	Stock	34.285	34.36	34.24	34.25	2499800.0
2007-02-21	A	Stock	23.1259	23.5908	23.1044	23.4263	5606679.0
2007-02-21	AABA-DELISTED	Stock	31.7399997711182	31.7700004577637	31.2199993133545	31.6499996185303	27999200.0
2007-02-21	AACC-DELISTED	Stock	15.51	15.68	15.44	15.55	55945.0
2007-02-21	AACQ-DELISTED	Stock	5.59	5.6	5.51	5.54	111956.0
2007-02-21	AACQU-DELISTED	Stock	7.1	7.1	7.1	7.1	1700.0
2007-02-21	AACQW-DELISTED	Stock	0.78	0.82	0.77	0.8	173000.0
2007-02-21	AAI-DELISTED	Stock	11.41	11.57	11.41	11.54	1403400.0
2007-02-21	AAIC-DELISTED	Stock	139.4	139.6	134.8	138.2	2923500.0
2007-02-21	AAME	Stock	3.92	4.04	3.88	3.9	15400.0
2007-02-21	AAON	Stock	3.8519	3.8584	3.786	3.8176	330328.0
2007-02-21	AAP	Stock	38.0	38.42	37.76	38.31	1783200.0
2007-02-21	AATI-DELISTED	Stock	6.35	6.56	6.17	6.44	351326.0
2007-02-21	AAU-DELISTED	Stock	2.31	2.35	2.21	2.35	96000.0
2007-02-21	AAUAF-DELISTED	Stock	2.31	2.35	2.21	2.35	96000.0
2007-02-21	AAV-DELISTED	Stock	10.59	10.62	10.51	10.62	662200.0
2007-02-21	AAWW-DELISTED	Stock	50.01	50.1801	49.74	50.04	99775.0
2007-02-21	AAXN-DELISTED	Stock	8.75	9.27000045776367	8.52000045776367	8.53999996185303	9153100.0
2007-02-21	AB	Stock	91.93	92.92	91.71	92.1	217300.0
2007-02-21	ABAX-DELISTED	Stock	23.53	23.85	23.36	23.6	267033.0
2007-02-21	ABB-DELISTED	Stock	17.85	17.88	17.7	17.83	2601100.0
2007-02-21	ABBC-DELISTED	Stock	19.52	19.61	19.4	19.4	3750.0
2007-02-21	ABC-DELISTED	Stock	27.39	27.48	27.33	27.4	1166800.0
2007-02-21	ABCB	Stock	23.2462	23.2656	22.9738	23.0905	7403.0
2007-02-21	ABCO-DELISTED	Stock	26.84	27.01	26.76	26.88	149684.0
2007-02-21	ABCW-DELISTED	Stock	29.1	29.21	29.04	29.2	41140.0
2007-02-21	ABD-DELISTED	Stock	22.8	22.84	22.58	22.63	321800.0
2007-02-21	ABE-DELISTED	Stock	19.24	19.24	18.83	19.12	22600.0
2007-02-21	ABFS-DELISTED	Stock	40.69	41.57	40.37	41.55	290666.0
2007-02-21	ABG	Stock	26.92	27.36	26.81	26.94	325000.0
2007-02-21	ABK-DELISTED	Stock	91.0	91.25	90.2	90.34	848400.0
2007-02-21	ABM	Stock	27.1	27.38	26.76	27.07	388400.0
2007-02-21	ABMD-DELISTED	Stock	14.77	14.84	14.61	14.63	76191.0
2007-02-21	ABP-DELISTED	Stock	3.01	3.1	2.99	2.99	244500.0
2007-02-21	ABR	Stock	34.12	34.19	33.51	33.83	208800.0
2007-02-21	ABT	Stock	25.1895	25.3238	25.1367	25.2903	9009796.0
2007-02-21	ABTL-DELISTED	Stock	20.0	20.0	19.05	20.0	30989.0
2007-02-21	ABV-DELISTED	Stock	52.51	53.11	51.84	51.9	361000.0
2007-02-21	ABVA-DELISTED	Stock	16.12	16.12	16.12	16.12	100.0
2007-02-21	ABX-DELISTED	Stock	31.1	32.26	30.74	32.02	7862582.0
2007-02-21	ACAD	Stock	7.18	7.39	7.17	7.34	206900.0
2007-02-21	ACAP-DELISTED	Stock	38.75	38.75	38.19	38.41	41615.0
2007-02-21	ACAS-DELISTED	Stock	47.48	48.0	46.35	46.75	1963990.0
2007-02-21	ACAT-DELISTED	Stock	18.03	19.0	18.03	18.77	96188.0
2007-02-21	ACC-DELISTED	Stock	31.18	32.09	31.18	31.53	81200.0

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

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