PREVIEW / stock_daily / 2007-06-01

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-01.parquet
  size:    173 KB
  rows:    5,234
  symbols: 3,086

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-06-01	AAPL	Stock	4.325	4.3282	4.2246	4.2286	885262000.0
2007-06-01	MSFT	Stock	30.79	30.9	30.55	30.59	39469400.0
2007-06-01	NVDA	Stock	0.5838	0.5925	0.5803	0.5813	429084000.0
2007-06-01	AMZN	Stock	3.445	3.465	3.4175	3.429	140290000.0
2007-06-01	TLT	Stock	85.9	86.84	85.54	85.59	1694300.0
2007-06-01	CL	Stock	33.475	33.715	33.405	33.705	3750400.0
2007-06-01	A	Stock	27.3033	27.4392	27.0744	27.382	2656759.0
2007-06-01	AACC-DELISTED	Stock	19.11	19.25	18.99	19.05	81285.0
2007-06-01	AAI-DELISTED	Stock	12.36	12.5	12.3	12.46	1636520.0
2007-06-01	AAIC-DELISTED	Stock	126.2	130.0	125.0	126.4	3964100.0
2007-06-01	AAME	Stock	4.89	5.2	4.76	4.99	7000.0
2007-06-01	AAON	Stock	3.923	3.9506	3.8887	3.9467	160228.0
2007-06-01	AAP	Stock	41.55	41.74	41.28	41.61	811000.0
2007-06-01	AATI-DELISTED	Stock	8.89	9.2	8.87	9.16	609417.0
2007-06-01	AAU-DELISTED	Stock	2.27	2.4	2.27	2.4	112800.0
2007-06-01	AAUAF-DELISTED	Stock	2.27	2.4	2.27	2.4	112800.0
2007-06-01	AAV-DELISTED	Stock	12.41	12.67	12.4	12.61	489600.0
2007-06-01	AAWW-DELISTED	Stock	58.7	59.79	58.26	58.79	207197.0
2007-06-01	AAXN-DELISTED	Stock	4.26	4.33	4.26	4.3	4850237.0
2007-06-01	AB	Stock	91.43	92.1	91.32	91.99	144000.0
2007-06-01	ABAX-DELISTED	Stock	23.02	23.6	22.5	23.33	485330.0
2007-06-01	ABB-DELISTED	Stock	21.72	21.82	21.63	21.74	1355564.0
2007-06-01	ABBC-DELISTED	Stock	18.4	18.5	18.31	18.39	8672.0
2007-06-01	ABBNY-DELISTED	Stock	21.72	21.82	21.63	21.74	1358064.0
2007-06-01	ABC-DELISTED	Stock	25.68	25.84	25.5	25.68	2545200.0
2007-06-01	ABCB	Stock	22.6917	23.2753	22.6723	22.7598	26834.0
2007-06-01	ABCO-DELISTED	Stock	26.07	26.37	25.99	26.26	405008.0
2007-06-01	ABCW-DELISTED	Stock	28.86	28.95	28.42	28.58	65530.0
2007-06-01	ABD-DELISTED	Stock	25.14	25.38	25.09	25.21	759700.0
2007-06-01	ABE-DELISTED	Stock	22.3	22.3	22.0	22.05	61400.0
2007-06-01	ABEO	Stock	5950.0	6375.0	5937.5	6375.0	11.0
2007-06-01	ABFS-DELISTED	Stock	41.46	41.87	40.86	40.97	551351.0
2007-06-01	ABG	Stock	27.38	27.7	27.26	27.55	256700.0
2007-06-01	ABK-DELISTED	Stock	89.5	90.05	89.22	89.86	1288887.0
2007-06-01	ABM	Stock	29.62	30.16	29.62	29.98	449500.0
2007-06-01	ABMD-DELISTED	Stock	11.6	12.09	11.51	12.06	330715.0
2007-06-01	ABP-DELISTED	Stock	4.0	4.15	3.95	4.0	266400.0
2007-06-01	ABR	Stock	28.45	28.97	28.29	28.85	102600.0
2007-06-01	ABT	Stock	27.0367	27.2047	26.8304	27.0127	10357024.0
2007-06-01	ABTL-DELISTED	Stock	21.6	21.75	21.5	21.7	18589.0
2007-06-01	ABV-DELISTED	Stock	71.43	71.43	69.04	70.71	533480.0
2007-06-01	ABVA-DELISTED	Stock	14.39	14.43	14.32	14.32	18141.0
2007-06-01	ABX-DELISTED	Stock	29.43	29.65	29.25	29.38	11623892.0
2007-06-01	ACAD	Stock	12.81	12.95	12.48	12.7	223600.0
2007-06-01	ACAP-DELISTED	Stock	40.95	41.95	40.9	41.83	54235.0
2007-06-01	ACAS-DELISTED	Stock	48.72	48.79	47.96	48.42	906901.0
2007-06-01	ACAT-DELISTED	Stock	19.22	19.4	18.99	19.27	118578.0
2007-06-01	ACC-DELISTED	Stock	29.42	30.55	29.42	29.55	1520000.0
2007-06-01	ACCL-DELISTED	Stock	6.29	6.42	6.27	6.36	109087.0
2007-06-01	ACCO	Stock	25.14	25.38	25.09	25.21	762300.0

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

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