PREVIEW / stock_daily / 2007-09-27

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-27.parquet
  size:    177 KB
  rows:    5,489
  symbols: 3,308

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-09-27	AAPL	Stock	5.4918	5.5186	5.44	5.5179	658198800.0
2007-09-27	MSFT	Stock	29.7	29.72	29.44	29.49	43407100.0
2007-09-27	NVDA	Stock	0.9255	0.93	0.9098	0.9195	378280000.0
2007-09-27	AMZN	Stock	4.7035	4.7055	4.6555	4.669	56254000.0
2007-09-27	TLT	Stock	88.24	88.78	88.15	88.52	1802900.0
2007-09-27	CL	Stock	35.825	35.955	35.57	35.79	4417400.0
2007-09-27	A	Stock	26.4664	26.6166	26.3019	26.4521	2657878.0
2007-09-27	AABA-DELISTED	Stock	26.89	26.95	26.17	26.28	21439128.0
2007-09-27	AACC-DELISTED	Stock	11.32	11.74	11.32	11.7	338877.0
2007-09-27	AAI-DELISTED	Stock	9.95	9.98	9.81	9.85	1303300.0
2007-09-27	AAIC-DELISTED	Stock	96.2	97.2	94.8	95.4	1153300.0
2007-09-27	AAME	Stock	2.75	2.75	2.62	2.72	1900.0
2007-09-27	AAON	Stock	4.0277	4.0632	3.9328	3.9842	301725.0
2007-09-27	AAP	Stock	33.07	33.38	32.91	33.32	683800.0
2007-09-27	AATI-DELISTED	Stock	10.8	10.83	10.58	10.66	247197.0
2007-09-27	AAU-DELISTED	Stock	2.3	2.32	2.27	2.31	22700.0
2007-09-27	AAUAF-DELISTED	Stock	2.3	2.32	2.27	2.31	22700.0
2007-09-27	AAV-DELISTED	Stock	12.17	12.3	12.14	12.3	1110198.0
2007-09-27	AAWW-DELISTED	Stock	53.48	53.48	52.77	52.91	101888.0
2007-09-27	AAXN-DELISTED	Stock	15.93	15.97	15.74	15.86	1409344.0
2007-09-27	AB	Stock	86.22	87.47	85.91	87.4	176500.0
2007-09-27	ABAX-DELISTED	Stock	21.95	22.23	21.83	22.2	238534.0
2007-09-27	ABB-DELISTED	Stock	25.94	26.0	25.81	25.88	4212900.0
2007-09-27	ABBC-DELISTED	Stock	9.77	9.82	9.73	9.76	64534.0
2007-09-27	ABBNY-DELISTED	Stock	25.94	26.0	25.808	25.91	4212900.0
2007-09-27	ABC-DELISTED	Stock	22.56	22.8	22.26	22.38	1838600.0
2007-09-27	ABCB	Stock	18.2954	18.3051	17.9064	18.2176	12954.0
2007-09-27	ABCO-DELISTED	Stock	29.58	29.59	28.91	29.34	210708.0
2007-09-27	ABCW-DELISTED	Stock	27.82	28.15	27.57	27.58	65240.0
2007-09-27	ABD-DELISTED	Stock	22.21	22.54	22.1	22.42	327160.0
2007-09-27	ABE-DELISTED	Stock	23.4	24.0	23.3601	23.9099	42100.0
2007-09-27	ABEO	Stock	5625.0	5712.5	5375.0	5575.0	7.0
2007-09-27	ABFS-DELISTED	Stock	32.42	32.88	32.35	32.68	368723.0
2007-09-27	ABG	Stock	19.41	19.41	18.58	19.01	564700.0
2007-09-27	ABK-DELISTED	Stock	62.61	63.84	62.45	63.71	1719700.0
2007-09-27	ABM	Stock	20.5	20.5	19.96	20.08	200400.0
2007-09-27	ABMD-DELISTED	Stock	11.88	12.2	11.88	12.18	63479.0
2007-09-27	ABP-DELISTED	Stock	3.65	3.72	3.62	3.7	135200.0
2007-09-27	ABR	Stock	19.44	19.79	19.44	19.5	179400.0
2007-09-27	ABT	Stock	26.0531	26.1395	25.8612	25.9332	7353689.0
2007-09-27	ABTL-DELISTED	Stock	17.02	17.585	16.249	16.3	16832.0
2007-09-27	ABV-DELISTED	Stock	71.47	72.37	70.93	72.26	603300.0
2007-09-27	ABVA-DELISTED	Stock	9.93	9.96	9.8	9.8	3634.0
2007-09-27	ABX-DELISTED	Stock	39.21	39.64	38.64	39.2	5580022.0
2007-09-27	ACAD	Stock	15.28	15.46	14.95	15.35	144900.0
2007-09-27	ACAP-DELISTED	Stock	37.77	39.0	37.67	38.89	49949.0
2007-09-27	ACAS-DELISTED	Stock	41.72	41.98	41.66	41.95	1085393.0
2007-09-27	ACAT-DELISTED	Stock	16.63	16.75	16.48	16.7	114804.0
2007-09-27	ACC-DELISTED	Stock	29.27	29.47	29.15	29.33	58142.0
2007-09-27	ACCL-DELISTED	Stock	6.44	6.95	6.44	6.94	430924.0

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

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