PREVIEW / stock_daily / 2007-10-15

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-15.parquet
  size:    179 KB
  rows:    5,516
  symbols: 3,333

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-15	AAPL	Stock	5.9993	6.0561	5.8393	5.9636	1077930000.0
2007-10-15	MSFT	Stock	30.1	30.33	30.0	30.04	47150500.0
2007-10-15	NVDA	Stock	0.9062	0.9215	0.902	0.9098	355900000.0
2007-10-15	AMZN	Stock	4.59	4.606	4.505	4.5265	112176000.0
2007-10-15	TLT	Stock	87.48	87.72	87.4	87.65	553300.0
2007-10-15	CL	Stock	37.225	37.26	36.66	36.83	4994400.0
2007-10-15	A	Stock	27.1173	27.6466	26.9027	27.3104	2944048.0
2007-10-15	AABA-DELISTED	Stock	28.36	28.4	27.46	27.86	22995567.0
2007-10-15	AACC-DELISTED	Stock	10.99	11.11	10.86	11.0	337046.0
2007-10-15	AAI-DELISTED	Stock	9.93	10.0	9.67	9.82	1376600.0
2007-10-15	AAIC-DELISTED	Stock	95.0	95.8	90.8	91.6	1737700.0
2007-10-15	AAME	Stock	2.59	2.59	2.51	2.53	8500.0
2007-10-15	AAON	Stock	4.0	4.0	3.8558	3.9309	224269.0
2007-10-15	AAP	Stock	34.93	34.98	33.92	34.41	792100.0
2007-10-15	AATI-DELISTED	Stock	12.11	12.38	11.93	12.0	355571.0
2007-10-15	AAU-DELISTED	Stock	3.01	3.2	3.0	3.19	238900.0
2007-10-15	AAUAF-DELISTED	Stock	3.01	3.2	3.0	3.19	238900.0
2007-10-15	AAV-DELISTED	Stock	12.28	12.34	12.21	12.25	602800.0
2007-10-15	AAWW-DELISTED	Stock	54.24	55.78	53.9	55.78	201125.0
2007-10-15	AAXN-DELISTED	Stock	17.92	18.04	17.24	17.59	1835181.0
2007-10-15	AB	Stock	90.76	90.95	87.8	88.68	341800.0
2007-10-15	ABAX-DELISTED	Stock	25.03	25.9	24.92	25.33	317793.0
2007-10-15	ABB-DELISTED	Stock	28.16	28.19	27.85	27.97	3015300.0
2007-10-15	ABBC-DELISTED	Stock	9.65	9.71	9.6	9.69	47147.0
2007-10-15	ABBNY-DELISTED	Stock	28.16	28.19	27.85	27.98	3015200.0
2007-10-15	ABC-DELISTED	Stock	22.58	22.77	22.36	22.42	1282600.0
2007-10-15	ABCB	Stock	18.2565	18.2565	17.9453	18.0814	33723.0
2007-10-15	ABCO-DELISTED	Stock	30.4	30.77	29.75	30.01	168578.0
2007-10-15	ABCW-DELISTED	Stock	27.45	27.45	26.02	26.15	138590.0
2007-10-15	ABD-DELISTED	Stock	21.43	21.52	20.67	21.04	970550.0
2007-10-15	ABE-DELISTED	Stock	26.98	27.9	26.676	27.0	48700.0
2007-10-15	ABEO	Stock	4962.5	4962.5	4812.5	4937.5	7.0
2007-10-15	ABFS-DELISTED	Stock	33.13	33.43	32.11	32.31	403480.0
2007-10-15	ABG	Stock	20.0	20.11	19.75	20.08	285300.0
2007-10-15	ABK-DELISTED	Stock	68.93	70.38	66.03	66.54	2484200.0
2007-10-15	ABM	Stock	23.98	24.13	23.1	23.27	469900.0
2007-10-15	ABMD-DELISTED	Stock	13.38	13.38	12.63	13.04	155344.0
2007-10-15	ABP-DELISTED	Stock	4.11	4.2	4.08	4.18	133200.0
2007-10-15	ABR	Stock	19.14	19.28	18.5	18.61	282800.0
2007-10-15	ABT	Stock	25.2903	25.319	24.6425	24.9112	16241559.0
2007-10-15	ABTL-DELISTED	Stock	15.1	15.45	13.7	13.7	17459.0
2007-10-15	ABV-DELISTED	Stock	78.94	79.61	76.31	77.15	599500.0
2007-10-15	ABVA-DELISTED	Stock	9.7378	9.75	9.73	9.75	3845.0
2007-10-15	ABVT-DELISTED	Stock	82.0	85.49	82.0	85.49	10682.0
2007-10-15	ABX-DELISTED	Stock	42.98	43.24	42.47	42.92	8910100.0
2007-10-15	ACAD	Stock	15.98	16.29	15.13	15.25	265800.0
2007-10-15	ACAP-DELISTED	Stock	42.31	42.31	40.69	41.59	63342.0
2007-10-15	ACAS-DELISTED	Stock	44.9	46.07	44.29	44.74	2355778.0
2007-10-15	ACAT-DELISTED	Stock	17.4	17.47	16.91	17.0	56192.0
2007-10-15	ACC-DELISTED	Stock	30.09	30.12	28.8	29.32	157000.0

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

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