PREVIEW / stock_daily / 2007-07-17

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-17.parquet
  size:    178 KB
  rows:    5,448
  symbols: 3,278

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-17	AAPL	Stock	4.9393	4.9857	4.9107	4.9611	709959600.0
2007-07-17	MSFT	Stock	30.02	30.88	30.01	30.78	77539600.0
2007-07-17	NVDA	Stock	0.7815	0.7972	0.7743	0.775	643812000.0
2007-07-17	AMZN	Stock	3.7195	3.726	3.6795	3.6895	121688000.0
2007-07-17	TLT	Stock	84.86	85.09	84.5	84.89	734125.0
2007-07-17	CL	Stock	34.275	34.375	34.035	34.035	5183800.0
2007-07-17	A	Stock	28.2833	28.5408	28.226	28.4692	3799904.0
2007-07-17	AABA-DELISTED	Stock	26.74	27.8	26.7	27.49	42884812.0
2007-07-17	AACC-DELISTED	Stock	15.17	15.312	14.76	14.95	399999.0
2007-07-17	AAI-DELISTED	Stock	10.64	10.77	10.49	10.5	1421900.0
2007-07-17	AAIC-DELISTED	Stock	104.2	105.4	101.798	102.4	944200.0
2007-07-17	AAME	Stock	3.98	4.02	3.98	4.02	1100.0
2007-07-17	AAON	Stock	4.4695	4.563	4.4655	4.48	285525.0
2007-07-17	AAP	Stock	39.75	39.98	39.32	39.69	639900.0
2007-07-17	AATI-DELISTED	Stock	10.26	10.5	10.26	10.35	479294.0
2007-07-17	AAU-DELISTED	Stock	2.75	2.75	2.68	2.69	57200.0
2007-07-17	AAUAF-DELISTED	Stock	2.75	2.75	2.68	2.6878	57200.0
2007-07-17	AAV-DELISTED	Stock	13.72	13.89	13.71	13.82	637000.0
2007-07-17	AAWW-DELISTED	Stock	59.65	60.65	59.15	60.07	114314.0
2007-07-17	AAXN-DELISTED	Stock	16.37	16.54	16.0	16.2	3145005.0
2007-07-17	AB	Stock	88.22	90.89	88.0	89.87	495600.0
2007-07-17	ABAX-DELISTED	Stock	19.64	20.04	19.17	19.19	324359.0
2007-07-17	ABB-DELISTED	Stock	24.54	24.7	24.34	24.42	1879800.0
2007-07-17	ABBC-DELISTED	Stock	9.73	9.76	9.58	9.62	401404.0
2007-07-17	ABBNY-DELISTED	Stock	24.54	24.7	24.34	24.39	1907300.0
2007-07-17	ABC-DELISTED	Stock	24.95	25.38	24.82	25.13	1643000.0
2007-07-17	ABCB	Stock	21.651	22.0401	21.6219	21.6608	27965.0
2007-07-17	ABCO-DELISTED	Stock	28.64	28.75	28.34	28.36	162678.0
2007-07-17	ABCW-DELISTED	Stock	24.48	24.62	24.17	24.22	112440.0
2007-07-17	ABD-DELISTED	Stock	22.8	22.86	22.04	22.08	694200.0
2007-07-17	ABE-DELISTED	Stock	22.5	22.89	22.38	22.44	36200.0
2007-07-17	ABEO	Stock	6187.5	6187.5	5562.5	6050.0	13.0
2007-07-17	ABFS-DELISTED	Stock	40.66	41.01	40.41	40.67	303238.0
2007-07-17	ABG	Stock	24.19	24.35	24.06	24.19	689500.0
2007-07-17	ABK-DELISTED	Stock	85.47	85.47	84.58	85.0	1530200.0
2007-07-17	ABM	Stock	25.41	25.56	25.34	25.39	211700.0
2007-07-17	ABMD-DELISTED	Stock	10.97	11.2	10.85	11.14	135793.0
2007-07-17	ABP-DELISTED	Stock	4.4	4.49	4.22	4.23	285800.0
2007-07-17	ABR	Stock	25.19	25.57	25.11	25.2	312800.0
2007-07-17	ABT	Stock	25.6693	25.7509	25.5014	25.6165	12257399.0
2007-07-17	ABTL-DELISTED	Stock	21.65	21.65	21.15	21.25	22070.0
2007-07-17	ABV-DELISTED	Stock	75.22	75.33	74.39	75.1	666700.0
2007-07-17	ABVA-DELISTED	Stock	12.81	12.81	12.768	12.768	1905.0
2007-07-17	ABVT-DELISTED	Stock	69.0	73.0	68.0	73.0	12796.0
2007-07-17	ABX-DELISTED	Stock	31.77	32.09	31.66	32.06	4998886.0
2007-07-17	ACAD	Stock	13.52	13.66	13.39	13.66	293700.0
2007-07-17	ACAP-DELISTED	Stock	38.26	38.98	37.83	38.22	87861.0
2007-07-17	ACAS-DELISTED	Stock	45.96	46.18	45.13	45.29	1385136.0
2007-07-17	ACAT-DELISTED	Stock	19.68	20.17	19.68	19.81	78480.0
2007-07-17	ACC-DELISTED	Stock	29.3	29.49	28.34	28.34	53611.0

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

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