PREVIEW / stock_daily / 2007-10-25

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-25.parquet
  size:    178 KB
  rows:    5,547
  symbols: 3,365

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-25	AAPL	Stock	6.6025	6.6393	6.4879	6.5279	973602000.0
2007-10-25	MSFT	Stock	31.57	32.22	31.49	31.99	169588700.0
2007-10-25	NVDA	Stock	0.9213	0.93	0.8398	0.8675	806192000.0
2007-10-25	AMZN	Stock	4.4115	4.475	4.316	4.4105	232618000.0
2007-10-25	TLT	Stock	91.06	91.18	90.7	90.71	3062200.0
2007-10-25	CL	Stock	36.92	36.945	36.595	36.845	5313800.0
2007-10-25	A	Stock	26.4664	26.5594	25.7511	25.9227	2125240.0
2007-10-25	AABA-DELISTED	Stock	30.75	31.62	30.5	31.34	38851764.0
2007-10-25	AACC-DELISTED	Stock	11.07	11.22	10.9	10.92	223704.0
2007-10-25	AAI-DELISTED	Stock	9.58	9.6	9.13	9.28	1554200.0
2007-10-25	AAIC-DELISTED	Stock	83.0	88.0	81.4	82.4	4084500.0
2007-10-25	AAME	Stock	2.48	2.48	2.41	2.43	1700.0
2007-10-25	AAON	Stock	3.362	3.4607	3.3086	3.3086	555862.0
2007-10-25	AAP	Stock	33.66	34.07	33.32	34.04	1431200.0
2007-10-25	AATI-DELISTED	Stock	11.75	11.84	11.1	11.1	541407.0
2007-10-25	AAU-DELISTED	Stock	2.77	2.84	2.77	2.82	60100.0
2007-10-25	AAUAF-DELISTED	Stock	2.77	2.84	2.7676	2.824	60100.0
2007-10-25	AAV-DELISTED	Stock	12.82	12.9	12.77	12.77	547000.0
2007-10-25	AAWW-DELISTED	Stock	57.56	57.75	56.85	57.47	264754.0
2007-10-25	AAXN-DELISTED	Stock	17.56	17.5788	16.75	16.75	2163459.0
2007-10-25	AB	Stock	84.3	85.59	81.47	83.35	763000.0
2007-10-25	ABAX-DELISTED	Stock	24.25	29.73	24.04	29.38	1899593.0
2007-10-25	ABB-DELISTED	Stock	28.76	29.1	28.61	29.05	14205500.0
2007-10-25	ABBC-DELISTED	Stock	9.35	9.57	9.26	9.41	59880.0
2007-10-25	ABBNY-DELISTED	Stock	28.76	29.1	28.61	29.04	13866500.0
2007-10-25	ABC-DELISTED	Stock	22.24	22.5	22.12	22.34	1900200.0
2007-10-25	ABCB	Stock	16.7878	16.9435	16.4377	16.4377	31255.0
2007-10-25	ABCO-DELISTED	Stock	31.06	31.06	29.83	30.3	321740.0
2007-10-25	ABCW-DELISTED	Stock	24.36	24.68	23.9	24.15	98850.0
2007-10-25	ABD-DELISTED	Stock	20.77	20.98	20.55	20.8	252920.0
2007-10-25	ABE-DELISTED	Stock	26.77	26.77	26.354	26.6	21000.0
2007-10-25	ABEO	Stock	4437.5	4750.0	4437.5	4750.0	2.0
2007-10-25	ABFS-DELISTED	Stock	31.2	31.7	30.1	31.26	512358.0
2007-10-25	ABG	Stock	19.49	19.69	18.83	19.15	338500.0
2007-10-25	ABK-DELISTED	Stock	52.35	52.72	40.54	43.95	16444200.0
2007-10-25	ABM	Stock	22.66	23.11	22.3	22.67	351500.0
2007-10-25	ABMD-DELISTED	Stock	12.79	13.32	12.79	13.28	223034.0
2007-10-25	ABP-DELISTED	Stock	4.3	4.41	4.25	4.25	132400.0
2007-10-25	ABR	Stock	18.35	18.69	18.05	18.39	378900.0
2007-10-25	ABT	Stock	25.367	25.9428	25.2663	25.8468	16599000.0
2007-10-25	ABTL-DELISTED	Stock	12.602	12.753	12.249	12.35	25920.0
2007-10-25	ABV-DELISTED	Stock	78.7	78.7	76.58	77.3	647314.0
2007-10-25	ABVA-DELISTED	Stock	9.61	10.34	9.55	10.25	70387.0
2007-10-25	ABX-DELISTED	Stock	42.59	42.72	41.78	42.19	5518800.0
2007-10-25	ACAD	Stock	15.37	15.6	15.0	15.14	138700.0
2007-10-25	ACAP-DELISTED	Stock	39.43	40.91	39.43	40.76	43707.0
2007-10-25	ACAS-DELISTED	Stock	41.25	41.96	40.58	41.1	1057400.0
2007-10-25	ACAT-DELISTED	Stock	16.41	16.41	15.64	15.67	143692.0
2007-10-25	ACC-DELISTED	Stock	27.76	28.2	27.17	27.87	183100.0
2007-10-25	ACCL-DELISTED	Stock	7.24	7.25	7.12	7.24	48806.0

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

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