PREVIEW / stock_daily / 2007-07-10

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-10.parquet
  size:    177 KB
  rows:    5,448
  symbols: 3,276

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-10	AAPL	Stock	4.6029	4.8036	4.6004	4.7268	1255007600.0
2007-07-10	MSFT	Stock	29.7	29.99	29.18	29.33	66013500.0
2007-07-10	NVDA	Stock	0.7468	0.7625	0.7388	0.758	552654000.0
2007-07-10	AMZN	Stock	3.5825	3.597	3.5035	3.514	177708000.0
2007-07-10	TLT	Stock	84.48	85.2	84.43	85.2	2257968.0
2007-07-10	CL	Stock	32.98	33.125	32.84	32.885	5391200.0
2007-07-10	A	Stock	28.5193	28.5622	28.2546	28.3977	3061900.0
2007-07-10	AABA-DELISTED	Stock	27.09	27.57	26.96	26.98	23022070.0
2007-07-10	AACC-DELISTED	Stock	17.89	17.89	17.18	17.22	240572.0
2007-07-10	AAI-DELISTED	Stock	10.89	10.99	10.7	10.72	1767800.0
2007-07-10	AAIC-DELISTED	Stock	107.2	108.0	103.2	104.2	1648000.0
2007-07-10	AAME	Stock	3.97	4.07	3.96	4.04	7700.0
2007-07-10	AAON	Stock	4.1877	4.1956	4.0902	4.1152	196678.0
2007-07-10	AAP	Stock	41.16	41.2	40.18	40.4	823800.0
2007-07-10	AATI-DELISTED	Stock	9.79	9.79	9.51	9.61	299521.0
2007-07-10	AAU-DELISTED	Stock	2.68	2.76	2.68	2.73	109800.0
2007-07-10	AAUAF-DELISTED	Stock	2.68	2.76	2.68	2.73	109800.0
2007-07-10	AAV-DELISTED	Stock	13.8	13.9	13.72	13.89	1156700.0
2007-07-10	AAWW-DELISTED	Stock	59.69	60.3	58.87	59.14	77688.0
2007-07-10	AAXN-DELISTED	Stock	16.895	17.37	16.01	16.25	14703977.0
2007-07-10	AB	Stock	88.7	88.95	86.77	87.05	266000.0
2007-07-10	ABAX-DELISTED	Stock	20.64	20.68	20.09	20.26	184883.0
2007-07-10	ABB-DELISTED	Stock	23.93	24.05	23.65	23.7	2139830.0
2007-07-10	ABBC-DELISTED	Stock	9.65	9.759	9.65	9.66	368577.0
2007-07-10	ABBNY-DELISTED	Stock	23.93	24.05	23.65	23.71	2190830.0
2007-07-10	ABC-DELISTED	Stock	24.66	24.8	24.35	24.36	2330400.0
2007-07-10	ABCB	Stock	22.079	22.079	21.6413	21.6608	64566.0
2007-07-10	ABCO-DELISTED	Stock	28.38	28.64	27.97	27.99	224154.0
2007-07-10	ABCW-DELISTED	Stock	25.75	25.8	24.85	24.85	211830.0
2007-07-10	ABD-DELISTED	Stock	23.23	23.35	22.89	23.05	583200.0
2007-07-10	ABE-DELISTED	Stock	21.8	22.2	21.45	21.86	28600.0
2007-07-10	ABFS-DELISTED	Stock	40.74	40.74	39.3	39.39	343180.0
2007-07-10	ABG	Stock	24.44	25.0	24.13	24.13	528200.0
2007-07-10	ABK-DELISTED	Stock	85.09	85.4	82.25	82.66	2473900.0
2007-07-10	ABM	Stock	25.95	26.15	25.49	25.49	242500.0
2007-07-10	ABMD-DELISTED	Stock	10.51	10.59	10.2	10.4	290403.0
2007-07-10	ABP-DELISTED	Stock	4.38	4.45	4.33	4.44	286500.0
2007-07-10	ABR	Stock	25.88	25.94	25.25	25.25	192800.0
2007-07-10	ABT	Stock	25.6117	25.9044	25.3286	25.391	13456440.0
2007-07-10	ABTL-DELISTED	Stock	21.83	22.13	21.52	21.77	26883.0
2007-07-10	ABV-DELISTED	Stock	72.92	73.03	71.51	72.45	711000.0
2007-07-10	ABVA-DELISTED	Stock	12.72	12.79	12.56	12.56	12374.0
2007-07-10	ABX-DELISTED	Stock	31.23	31.52	31.09	31.37	6424900.0
2007-07-10	ACAD	Stock	13.65	13.9	13.5	13.55	495400.0
2007-07-10	ACAP-DELISTED	Stock	40.48	40.48	39.07	39.1	60888.0
2007-07-10	ACAS-DELISTED	Stock	46.56	46.63	44.89	45.14	5111623.0
2007-07-10	ACAT-DELISTED	Stock	20.59	20.59	20.29	20.39	47278.0
2007-07-10	ACC-DELISTED	Stock	29.08	29.38	28.79	28.95	149200.0
2007-07-10	ACCL-DELISTED	Stock	6.32	6.5	6.26	6.43	87965.0
2007-07-10	ACCO	Stock	23.23	23.35	22.89	23.05	583300.0

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

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