PREVIEW / stock_daily / 2007-04-05

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-05.parquet
  size:    162 KB
  rows:    4,901
  symbols: 3,078

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-04-05	AAPL	Stock	3.3614	3.3814	3.34	3.3814	355516000.0
2007-04-05	MSFT	Stock	28.32	28.65	28.3	28.55	30131200.0
2007-04-05	NVDA	Stock	0.4783	0.5155	0.4783	0.515	1332900000.0
2007-04-05	AMZN	Stock	2.0785	2.088	2.072	2.084	65768000.0
2007-04-05	TLT	Stock	88.1	88.12	87.71	87.75	436400.0
2007-04-05	CL	Stock	33.12	33.34	33.025	33.315	2376600.0
2007-04-05	A	Stock	24.8927	25.0	24.814	24.8283	3725530.0
2007-04-05	AABA-DELISTED	Stock	32.0	32.0900001525879	31.7199993133545	31.9599990844727	13878100.0
2007-04-05	AACC-DELISTED	Stock	15.63	15.72	15.55	15.56	121076.0
2007-04-05	AACQW-DELISTED	Stock	0.56	0.56	0.56	0.56	2500.0
2007-04-05	AAI-DELISTED	Stock	10.63	10.91	10.63	10.75	1236100.0
2007-04-05	AAIC-DELISTED	Stock	110.0	113.0	109.8	112.6	1746200.0
2007-04-05	AAME	Stock	4.21	4.29	3.91	4.04	21500.0
2007-04-05	AAON	Stock	3.4502	3.4502	3.3857	3.387	76697.0
2007-04-05	AAP	Stock	38.61	39.72	38.46	39.56	900500.0
2007-04-05	AATI-DELISTED	Stock	6.93	7.0199	6.78	6.92	548751.0
2007-04-05	AAU-DELISTED	Stock	2.43	2.4636	2.34	2.36	114800.0
2007-04-05	AAUAF-DELISTED	Stock	2.43	2.4636	2.34	2.36	114800.0
2007-04-05	AAV-DELISTED	Stock	10.4	10.49	10.39	10.449	424800.0
2007-04-05	AAWW-DELISTED	Stock	55.66	56.63	55.56	56.15	107379.0
2007-04-05	AAXN-DELISTED	Stock	8.0600004196167	8.07999992370605	7.96999979019165	7.98000001907349	551800.0
2007-04-05	AB	Stock	91.41	91.41	89.8	90.3	222600.0
2007-04-05	ABAX-DELISTED	Stock	24.57	24.81	24.43	24.75	131067.0
2007-04-05	ABB-DELISTED	Stock	18.01	18.04	17.84	17.9	1747298.0
2007-04-05	ABBC-DELISTED	Stock	20.23	20.23	20.15	20.18	11645.0
2007-04-05	ABC-DELISTED	Stock	26.92	27.09	26.79	27.03	1126712.0
2007-04-05	ABCB	Stock	23.8589	24.6856	23.8589	24.1507	86980.0
2007-04-05	ABCO-DELISTED	Stock	25.66	25.94	25.57	25.7	109377.0
2007-04-05	ABCW-DELISTED	Stock	27.83	28.13	27.83	27.99	22030.0
2007-04-05	ABD-DELISTED	Stock	25.14	25.47	25.07	25.25	383980.0
2007-04-05	ABE-DELISTED	Stock	19.8	19.84	19.54	19.54	15000.0
2007-04-05	ABFS-DELISTED	Stock	36.02	36.53	35.99	36.26	325049.0
2007-04-05	ABG	Stock	27.2	27.2	26.86	27.01	733500.0
2007-04-05	ABK-DELISTED	Stock	86.45	86.67	85.63	85.82	945533.0
2007-04-05	ABM	Stock	26.23	26.88	26.16	26.84	473200.0
2007-04-05	ABMD-DELISTED	Stock	13.52	13.72	13.35	13.7	198021.0
2007-04-05	ABP-DELISTED	Stock	3.08	3.14	3.02	3.06	150400.0
2007-04-05	ABR	Stock	29.87	30.07	29.87	29.94	45400.0
2007-04-05	ABT	Stock	27.0463	27.4014	27.0127	27.3582	10560233.0
2007-04-05	ABTL-DELISTED	Stock	17.9	17.9	17.2	17.3	15703.0
2007-04-05	ABV-DELISTED	Stock	56.03	56.41	55.66	56.21	341100.0
2007-04-05	ABVA-DELISTED	Stock	14.6701	14.69	14.66	14.66	955.0
2007-04-05	ABVT-DELISTED	Stock	62.0	62.0	62.0	62.0	150.0
2007-04-05	ABX-DELISTED	Stock	29.49	29.72	29.25	29.3	5288080.0
2007-04-05	ACAD	Stock	15.89	16.0	15.24	15.65	2888900.0
2007-04-05	ACAP-DELISTED	Stock	39.12	39.41	38.43	38.54	50246.0
2007-04-05	ACAS-DELISTED	Stock	45.5	45.73	45.21	45.63	797392.0
2007-04-05	ACAT-DELISTED	Stock	18.98	19.24	18.86	18.98	66168.0
2007-04-05	ACC-DELISTED	Stock	30.51	30.53	30.17	30.35	90400.0
2007-04-05	ACCL-DELISTED	Stock	6.45	6.55	6.41	6.48	44195.0

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

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