PREVIEW / stock_daily / 2007-10-19

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-19.parquet
  size:    179 KB
  rows:    5,541
  symbols: 3,341

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-10-19	AAPL	Stock	6.2229	6.2368	6.0714	6.0864	1291780000.0
2007-10-19	MSFT	Stock	31.09	31.09	30.11	30.17	75200200.0
2007-10-19	NVDA	Stock	0.9855	0.986	0.9345	0.9348	505768000.0
2007-10-19	AMZN	Stock	4.4965	4.5325	4.466	4.488	182524000.0
2007-10-19	TLT	Stock	89.63	90.6	89.61	90.46	2561800.0
2007-10-19	CL	Stock	36.28	36.595	35.92	35.92	5218200.0
2007-10-19	A	Stock	27.475	27.475	26.6237	26.681	2484526.0
2007-10-19	AABA-DELISTED	Stock	29.35	29.96	28.85	29.03	41932991.0
2007-10-19	AACC-DELISTED	Stock	10.89	10.99	10.56	10.58	281319.0
2007-10-19	AAI-DELISTED	Stock	9.71	9.71	9.46	9.51	1401200.0
2007-10-19	AAIC-DELISTED	Stock	90.8	91.6	86.0	86.0	1940400.0
2007-10-19	AAME	Stock	2.47	2.58	2.4	2.45	14000.0
2007-10-19	AAON	Stock	3.518	3.5911	3.4232	3.4331	475369.0
2007-10-19	AAP	Stock	32.85	33.26	31.94	32.07	988700.0
2007-10-19	AATI-DELISTED	Stock	11.76	11.84	11.6	11.67	379417.0
2007-10-19	AAU-DELISTED	Stock	2.75	2.9	2.73	2.82	71000.0
2007-10-19	AAUAF-DELISTED	Stock	2.75	2.9	2.73	2.82	71000.0
2007-10-19	AAV-DELISTED	Stock	12.78	12.85	12.45	12.65	875400.0
2007-10-19	AAWW-DELISTED	Stock	56.92	56.92	56.0	56.24	208811.0
2007-10-19	AAXN-DELISTED	Stock	16.74	16.79	15.54	15.56	2783648.0
2007-10-19	AB	Stock	86.87	88.11	85.58	85.98	218600.0
2007-10-19	ABAX-DELISTED	Stock	24.74	24.76	23.32	23.32	338420.0
2007-10-19	ABB-DELISTED	Stock	27.95	27.99	27.09	27.13	3421500.0
2007-10-19	ABBC-DELISTED	Stock	9.46	9.46	9.26	9.26	152965.0
2007-10-19	ABBNY-DELISTED	Stock	27.95	27.99	27.09	27.14	3424300.0
2007-10-19	ABC-DELISTED	Stock	22.04	22.53	22.0	22.14	2354272.0
2007-10-19	ABCB	Stock	17.9355	17.9355	17.0213	17.0699	74539.0
2007-10-19	ABCO-DELISTED	Stock	30.2	30.48	30.01	30.13	232343.0
2007-10-19	ABCW-DELISTED	Stock	25.07	25.08	23.8	23.8	111030.0
2007-10-19	ABD-DELISTED	Stock	20.66	20.67	20.24	20.27	418300.0
2007-10-19	ABE-DELISTED	Stock	26.73	26.9399	25.11	25.84	72800.0
2007-10-19	ABEO	Stock	4875.0	4875.0	4750.0	4875.0	8.0
2007-10-19	ABFS-DELISTED	Stock	31.11	31.38	30.25	30.25	375148.0
2007-10-19	ABG	Stock	19.01	19.01	18.48	18.66	374000.0
2007-10-19	ABK-DELISTED	Stock	60.27	60.53	56.33	57.48	5880100.0
2007-10-19	ABM	Stock	24.19	24.19	22.48	22.48	466000.0
2007-10-19	ABMD-DELISTED	Stock	13.16	13.18	12.29	12.29	159666.0
2007-10-19	ABP-DELISTED	Stock	4.59	4.59	4.35	4.36	420300.0
2007-10-19	ABR	Stock	18.1	18.3	17.88	18.06	448600.0
2007-10-19	ABT	Stock	24.7289	25.0839	24.6329	24.6617	16081492.0
2007-10-19	ABTL-DELISTED	Stock	13.325	13.776	12.879	13.175	12188.0
2007-10-19	ABV-DELISTED	Stock	79.64	79.69	75.7	75.88	519986.0
2007-10-19	ABVA-DELISTED	Stock	9.72	9.72	9.72	9.72	1400.0
2007-10-19	ABVT-DELISTED	Stock	83.0	85.5	83.0	84.99	31326.0
2007-10-19	ABX-DELISTED	Stock	42.29	42.4	41.12	41.57	7001100.0
2007-10-19	ACAD	Stock	15.1	15.24	14.88	14.95	290700.0
2007-10-19	ACAP-DELISTED	Stock	41.79	41.79	39.03	39.03	38857.0
2007-10-19	ACAS-DELISTED	Stock	42.91	43.13	41.49	41.49	1638450.0
2007-10-19	ACAT-DELISTED	Stock	16.38	16.38	15.53	15.53	114214.0
2007-10-19	ACC-DELISTED	Stock	28.8	28.8	27.3	27.3	163814.0

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

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