PREVIEW / stock_daily / 2006-07-31

all stock daily files

  file:    by_date/stock_daily/2006/2006-07-31.parquet
  size:    149 KB
  rows:    4,468
  symbols: 2,818

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
2006-07-31	AAPL	Stock	2.3868	2.4511	2.3671	2.4271	892841600.0
2006-07-31	MSFT	Stock	24.07	24.42	24.01	24.06	40254400.0
2006-07-31	NVDA	Stock	0.3738	0.3777	0.368	0.369	594762000.0
2006-07-31	AMZN	Stock	1.351	1.3645	1.337	1.3445	160764000.0
2006-07-31	CL	Stock	29.71	29.965	29.61	29.66	3745600.0
2006-07-31	A	Stock	19.8856	20.4149	19.7783	20.3433	2374363.0
2006-07-31	AABA-DELISTED	Stock	27.4599990844727	27.5499992370605	26.9899997711182	27.1399993896484	16492600.0
2006-07-31	AACC-DELISTED	Stock	18.18	18.43	17.61	18.18	74195.0
2006-07-31	AACQW-DELISTED	Stock	0.4	0.4	0.4	0.4	200.0
2006-07-31	AAI-DELISTED	Stock	12.92	12.95	12.5	12.53	1200700.0
2006-07-31	AAIC-DELISTED	Stock	186.0	186.0	180.6	183.6	1460400.0
2006-07-31	AAME	Stock	2.88	2.88	2.75	2.75	4900.0
2006-07-31	AAON	Stock	3.063	3.1131	3.0512	3.0762	82772.0
2006-07-31	AAP	Stock	30.42	30.68	30.2	30.27	913200.0
2006-07-31	AATI-DELISTED	Stock	9.19	9.5	8.95	9.39	276920.0
2006-07-31	AAU-DELISTED	Stock	2.41	2.56	2.41	2.5	51900.0
2006-07-31	AAUAF-DELISTED	Stock	2.41	2.56	2.41	2.5	51900.0
2006-07-31	AAV-DELISTED	Stock	16.44	16.4901	16.2	16.45	432400.0
2006-07-31	AAWW-DELISTED	Stock	40.97	42.64	40.97	42.04	69817.0
2006-07-31	AAXN-DELISTED	Stock	7.09999990463257	7.23000001907349	7.09999990463257	7.21999979019165	766100.0
2006-07-31	AB	Stock	66.0	66.37	64.94	65.0	180700.0
2006-07-31	ABAX-DELISTED	Stock	22.3	22.8	21.84	22.67	297293.0
2006-07-31	ABB-DELISTED	Stock	12.88	12.97	12.86	12.93	3822600.0
2006-07-31	ABBC-DELISTED	Stock	14.62	14.71	14.5	14.58	15497.0
2006-07-31	ABC-DELISTED	Stock	21.5	21.62	21.44	21.49	2120400.0
2006-07-31	ABCB	Stock	23.538	25.2498	23.538	24.8024	174576.0
2006-07-31	ABCO-DELISTED	Stock	23.66	23.66	23.02	23.17	196890.0
2006-07-31	ABCW-DELISTED	Stock	30.27	30.27	29.38	29.7	31810.0
2006-07-31	ABD-DELISTED	Stock	20.1	20.1	19.5	19.63	154290.0
2006-07-31	ABE-DELISTED	Stock	12.9	13.0	12.8	12.95	14100.0
2006-07-31	ABFS-DELISTED	Stock	44.62	44.96	43.62	44.43	335816.0
2006-07-31	ABG	Stock	20.2	20.47	20.06	20.07	150500.0
2006-07-31	ABK-DELISTED	Stock	82.88	83.31	82.55	83.06	1891600.0
2006-07-31	ABM	Stock	16.78	16.78	16.31	16.5	161800.0
2006-07-31	ABMD-DELISTED	Stock	13.59	13.77	13.3	13.65	106092.0
2006-07-31	ABP-DELISTED	Stock	4.35	4.49	4.04	4.47	548500.0
2006-07-31	ABR	Stock	25.45	25.95	25.37	25.77	96900.0
2006-07-31	ABT	Stock	22.8865	22.992	22.8001	22.92	9487912.0
2006-07-31	ABTL-DELISTED	Stock	16.375	16.876	16.024	16.375	63122.0
2006-07-31	ABV-DELISTED	Stock	40.55	40.86	40.11	40.25	291400.0
2006-07-31	ABVA-DELISTED	Stock	15.973	16.0	15.48	15.48	5895.0
2006-07-31	ABX-DELISTED	Stock	30.44	30.87	30.16	30.79	3467409.0
2006-07-31	ACAD	Stock	6.65	6.66	6.4	6.43	113300.0
2006-07-31	ACAP-DELISTED	Stock	46.65	47.03	46.31	46.35	38811.0
2006-07-31	ACAS-DELISTED	Stock	35.0	35.0	34.84	35.0	756547.0
2006-07-31	ACAT-DELISTED	Stock	18.02	18.23	17.5	17.66	136921.0
2006-07-31	ACC-DELISTED	Stock	25.1	25.5	25.1	25.33	59100.0
2006-07-31	ACCL-DELISTED	Stock	6.31	6.39	6.01	6.26	31447.0
2006-07-31	ACCO	Stock	20.1	20.1	19.5	19.63	178500.0
2006-07-31	ACCP-DELISTED	Stock	1.05	1.05	1.05	1.05	1075.0

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

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