PREVIEW / stock_daily / 2007-07-31

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-31.parquet
  size:    178 KB
  rows:    5,490
  symbols: 3,296

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-07-31	AAPL	Stock	5.1061	5.1243	4.6971	4.7057	1762392800.0
2007-07-31	MSFT	Stock	29.71	29.72	28.98	28.99	66554000.0
2007-07-31	NVDA	Stock	0.7882	0.7988	0.7617	0.7627	711492000.0
2007-07-31	AMZN	Stock	4.185	4.1865	3.9	3.927	282090000.0
2007-07-31	TLT	Stock	87.13	87.75	86.95	87.66	2467536.0
2007-07-31	CL	Stock	34.37	34.37	32.995	33.0	9104200.0
2007-07-31	A	Stock	27.3605	27.6395	27.1102	27.289	4769836.0
2007-07-31	AABA-DELISTED	Stock	23.88	23.93	23.24	23.25	18810106.0
2007-07-31	AACC-DELISTED	Stock	14.2	14.31	13.82	13.88	178549.0
2007-07-31	AAI-DELISTED	Stock	10.18	10.24	9.8	9.83	2495500.0
2007-07-31	AAIC-DELISTED	Stock	106.0	109.8	98.0	98.4	2344494.0
2007-07-31	AAME	Stock	3.21	3.21	3.13	3.19	5600.0
2007-07-31	AAON	Stock	4.0283	4.1692	3.9019	3.9388	440437.0
2007-07-31	AAP	Stock	35.59	36.08	34.77	34.77	1571400.0
2007-07-31	AATI-DELISTED	Stock	9.5	9.56	8.69	8.85	1650975.0
2007-07-31	AAU-DELISTED	Stock	2.49	2.6	2.48	2.56	42200.0
2007-07-31	AAUAF-DELISTED	Stock	2.49	2.6	2.48	2.556	42200.0
2007-07-31	AAV-DELISTED	Stock	12.53	12.81	12.53	12.65	521100.0
2007-07-31	AAWW-DELISTED	Stock	54.8	54.91	53.99	54.25	109363.0
2007-07-31	AAXN-DELISTED	Stock	15.92	16.05	15.02	15.25	4761444.0
2007-07-31	AB	Stock	87.45	87.94	83.56	83.92	452400.0
2007-07-31	ABAX-DELISTED	Stock	18.6	18.6	18.09	18.2	229785.0
2007-07-31	ABB-DELISTED	Stock	24.5	24.69	24.01	24.03	6941800.0
2007-07-31	ABBC-DELISTED	Stock	9.5	9.5	9.15	9.25	91466.0
2007-07-31	ABBNY-DELISTED	Stock	24.5	24.69	24.01	24.07	6910100.0
2007-07-31	ABC-DELISTED	Stock	23.56	23.86	23.38	23.55	3730800.0
2007-07-31	ABCB	Stock	18.5289	18.5289	17.3325	17.3617	96027.0
2007-07-31	ABCO-DELISTED	Stock	26.24	26.49	25.74	25.74	178990.0
2007-07-31	ABCW-DELISTED	Stock	23.08	23.12	22.34	22.35	249760.0
2007-07-31	ABD-DELISTED	Stock	20.79	21.01	20.54	20.64	661650.0
2007-07-31	ABE-DELISTED	Stock	22.45	22.65	21.2416	21.48	28100.0
2007-07-31	ABEO	Stock	5500.0	5625.0	5375.0	5500.0	12.0
2007-07-31	ABFS-DELISTED	Stock	37.05	37.26	36.0	36.01	398912.0
2007-07-31	ABG	Stock	22.18	22.39	21.93	22.12	612000.0
2007-07-31	ABK-DELISTED	Stock	72.9	73.0	65.48	67.04	6416700.0
2007-07-31	ABM	Stock	24.92	26.11	24.92	25.16	518500.0
2007-07-31	ABMD-DELISTED	Stock	10.61	10.69	10.048	10.33	243696.0
2007-07-31	ABP-DELISTED	Stock	3.95	4.05	3.9	3.97	171300.0
2007-07-31	ABR	Stock	21.25	21.66	19.75	19.75	584400.0
2007-07-31	ABT	Stock	24.6137	24.7049	24.1963	24.3211	15923718.0
2007-07-31	ABTL-DELISTED	Stock	17.7	18.001	17.449	17.8	23023.0
2007-07-31	ABV-DELISTED	Stock	72.12	72.35	68.42	68.42	1034701.0
2007-07-31	ABVA-DELISTED	Stock	11.8	12.23	11.57	12.09	4519.0
2007-07-31	ABVT-DELISTED	Stock	72.5	74.0	71.0	74.0	10288.0
2007-07-31	ABX-DELISTED	Stock	33.5	33.83	32.77	32.9	6055800.0
2007-07-31	ACAD	Stock	14.24	14.36	13.95	14.04	304500.0
2007-07-31	ACAP-DELISTED	Stock	37.81	38.52	37.64	37.9	98590.0
2007-07-31	ACAS-DELISTED	Stock	39.7	41.0	37.98	37.98	4213489.0
2007-07-31	ACAT-DELISTED	Stock	18.43	18.72	18.08	18.12	155415.0
2007-07-31	ACC-DELISTED	Stock	25.51	26.63	24.74	25.55	420116.0

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

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