PREVIEW / stock_daily / 2007-07-27

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-27.parquet
  size:    177 KB
  rows:    5,467
  symbols: 3,290

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-27	AAPL	Stock	5.2211	5.3186	5.135	5.1375	1161098400.0
2007-07-27	MSFT	Stock	29.93	30.0	29.36	29.39	69214600.0
2007-07-27	NVDA	Stock	0.7375	0.7715	0.7372	0.7375	615480000.0
2007-07-27	AMZN	Stock	4.2135	4.2665	4.124	4.202	278852000.0
2007-07-27	TLT	Stock	87.05	87.56	86.85	87.28	5367835.0
2007-07-27	CL	Stock	34.435	34.645	34.11	34.225	8409200.0
2007-07-27	A	Stock	27.3605	27.6037	26.9242	26.9242	4499743.0
2007-07-27	AABA-DELISTED	Stock	23.98	24.49	23.47	23.47	34709370.0
2007-07-27	AACC-DELISTED	Stock	14.0	14.16	13.54	13.82	147935.0
2007-07-27	AAI-DELISTED	Stock	9.99	10.03	9.73	9.82	2367500.0
2007-07-27	AAIC-DELISTED	Stock	106.0	111.8	106.0	107.0	2802778.0
2007-07-27	AAME	Stock	3.57	3.57	3.1	3.3	57600.0
2007-07-27	AAON	Stock	3.9664	4.0573	3.836	3.836	455625.0
2007-07-27	AAP	Stock	36.04	36.8	34.91	35.07	3644000.0
2007-07-27	AATI-DELISTED	Stock	9.1	9.27	8.82	8.85	524052.0
2007-07-27	AAU-DELISTED	Stock	2.63	2.8	2.51	2.55	69800.0
2007-07-27	AAUAF-DELISTED	Stock	2.63	2.8	2.51	2.55	69800.0
2007-07-27	AAV-DELISTED	Stock	12.84	12.95	12.6	12.76	433700.0
2007-07-27	AAWW-DELISTED	Stock	55.36	55.36	53.31	53.35	133569.0
2007-07-27	AAXN-DELISTED	Stock	14.33	14.94	14.12	14.223	5403548.0
2007-07-27	AB	Stock	85.0	87.48	84.75	85.65	458900.0
2007-07-27	ABAX-DELISTED	Stock	18.9	18.9	17.91	17.95	903389.0
2007-07-27	ABB-DELISTED	Stock	23.26	23.33	22.68	22.71	5732000.0
2007-07-27	ABBC-DELISTED	Stock	9.27	9.52	9.12	9.5	89186.0
2007-07-27	ABBNY-DELISTED	Stock	23.26	23.33	22.68	22.72	5736200.0
2007-07-27	ABC-DELISTED	Stock	23.78	23.98	23.12	23.16	2755400.0
2007-07-27	ABCB	Stock	18.9179	19.0929	17.9355	18.0133	75567.0
2007-07-27	ABCO-DELISTED	Stock	26.3	26.49	25.72	26.22	248029.0
2007-07-27	ABCW-DELISTED	Stock	22.76	23.06	22.24	22.75	265710.0
2007-07-27	ABD-DELISTED	Stock	20.67	21.0	20.41	20.7	562700.0
2007-07-27	ABE-DELISTED	Stock	21.5	23.2	20.66	21.7	58800.0
2007-07-27	ABFS-DELISTED	Stock	37.2	37.66	36.45	36.57	541065.0
2007-07-27	ABG	Stock	22.5	22.66	21.85	22.24	1038300.0
2007-07-27	ABK-DELISTED	Stock	75.53	76.38	74.51	75.01	2532500.0
2007-07-27	ABM	Stock	24.02	24.27	23.04	23.09	319200.0
2007-07-27	ABMD-DELISTED	Stock	10.52	10.64	10.2579	10.27	183675.0
2007-07-27	ABP-DELISTED	Stock	3.86	3.99	3.75	3.88	243700.0
2007-07-27	ABR	Stock	22.05	22.65	21.69	21.76	257500.0
2007-07-27	ABT	Stock	24.5178	24.6329	23.99	24.0044	18759692.0
2007-07-27	ABTL-DELISTED	Stock	18.55	18.55	17.55	17.75	41936.0
2007-07-27	ABV-DELISTED	Stock	71.0	71.56	69.25	70.52	713500.0
2007-07-27	ABVA-DELISTED	Stock	12.71	12.71	11.95	11.95	6813.0
2007-07-27	ABVT-DELISTED	Stock	70.75	71.0	70.0	70.0	55964.0
2007-07-27	ABX-DELISTED	Stock	32.34	32.72	31.71	32.0	8598400.0
2007-07-27	ACAD	Stock	14.17	14.23	13.71	14.0	261400.0
2007-07-27	ACAP-DELISTED	Stock	38.69	39.18	37.73	37.74	103756.0
2007-07-27	ACAS-DELISTED	Stock	38.67	39.0	37.55	38.13	4098985.0
2007-07-27	ACAT-DELISTED	Stock	19.1	19.1	18.0	18.01	85216.0
2007-07-27	ACC-DELISTED	Stock	26.22	26.25	25.03	25.03	231400.0
2007-07-27	ACCL-DELISTED	Stock	6.87	6.95	6.68	6.79	80565.0

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

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