PREVIEW / stock_daily / 2007-09-07

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-07.parquet
  size:    176 KB
  rows:    5,475
  symbols: 3,304

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-07	AAPL	Stock	4.7146	4.725	4.6429	4.7061	1430576000.0
2007-09-07	MSFT	Stock	28.62	28.83	28.32	28.44	52160900.0
2007-09-07	NVDA	Stock	0.8518	0.8607	0.8278	0.8442	602304000.0
2007-09-07	AMZN	Stock	4.235	4.2485	4.1605	4.226	164624000.0
2007-09-07	TLT	Stock	89.75	90.5	89.69	89.79	2852165.0
2007-09-07	CL	Stock	32.715	33.115	32.605	32.715	4723000.0
2007-09-07	A	Stock	25.8155	26.0801	25.7868	25.9514	2858630.0
2007-09-07	AABA-DELISTED	Stock	23.76	24.05	23.6	23.76	10696808.0
2007-09-07	AACC-DELISTED	Stock	10.73	10.9	10.35	10.48	517917.0
2007-09-07	AAI-DELISTED	Stock	10.33	10.51	10.22	10.38	1451700.0
2007-09-07	AAIC-DELISTED	Stock	89.4	94.0	88.0	91.8	1695300.0
2007-09-07	AAME	Stock	3.14	3.15	3.06	3.15	3800.0
2007-09-07	AAON	Stock	4.0237	4.0454	3.9546	3.9921	289575.0
2007-09-07	AAP	Stock	34.26	34.39	33.6	33.71	930900.0
2007-09-07	AATI-DELISTED	Stock	9.16	9.37	9.16	9.27	264972.0
2007-09-07	AAU-DELISTED	Stock	2.36	2.38	2.25	2.27	104600.0
2007-09-07	AAUAF-DELISTED	Stock	2.36	2.38	2.25	2.2797	104600.0
2007-09-07	AAV-DELISTED	Stock	11.52	11.56	11.35	11.37	436300.0
2007-09-07	AAWW-DELISTED	Stock	50.1	50.38	49.65	50.08	133676.0
2007-09-07	AAXN-DELISTED	Stock	14.77	14.79	14.31	14.52	1722851.0
2007-09-07	AB	Stock	82.46	82.9	81.37	81.98	295600.0
2007-09-07	ABAX-DELISTED	Stock	19.6	19.93	19.46	19.93	128768.0
2007-09-07	ABB-DELISTED	Stock	23.35	23.4	23.04	23.17	3950900.0
2007-09-07	ABBC-DELISTED	Stock	9.39	9.64	9.33	9.37	69462.0
2007-09-07	ABBNY-DELISTED	Stock	23.35	23.4	23.04	23.18	4761800.0
2007-09-07	ABC-DELISTED	Stock	23.2	23.62	23.2	23.52	2380800.0
2007-09-07	ABCB	Stock	19.7154	19.7154	18.8109	18.9179	34751.0
2007-09-07	ABCO-DELISTED	Stock	28.32	28.32	27.95	28.12	123710.0
2007-09-07	ABCW-DELISTED	Stock	26.69	26.69	26.19	26.47	120520.0
2007-09-07	ABD-DELISTED	Stock	22.44	22.66	21.64	21.77	592980.0
2007-09-07	ABE-DELISTED	Stock	21.39	21.6638	21.25	21.36	12700.0
2007-09-07	ABEO	Stock	5587.5	5587.5	4925.0	5437.5	60.0
2007-09-07	ABFS-DELISTED	Stock	34.23	34.69	33.72	33.98	296019.0
2007-09-07	ABG	Stock	21.47	21.7	21.05	21.19	601100.0
2007-09-07	ABK-DELISTED	Stock	59.71	61.22	59.34	60.13	2586300.0
2007-09-07	ABM	Stock	21.3	21.3	20.6	20.83	525600.0
2007-09-07	ABMD-DELISTED	Stock	12.36	12.38	11.85	11.91	145506.0
2007-09-07	ABP-DELISTED	Stock	3.55	3.55	3.3	3.48	155500.0
2007-09-07	ABR	Stock	19.01	19.03	18.19	18.71	209300.0
2007-09-07	ABT	Stock	25.0168	25.2759	24.7049	24.8824	10560442.0
2007-09-07	ABTL-DELISTED	Stock	14.895	15.4	14.593	15.4	40342.0
2007-09-07	ABV-DELISTED	Stock	66.5	67.23	65.18	65.8	439159.0
2007-09-07	ABVA-DELISTED	Stock	9.84	10.0	9.83	9.91	16467.0
2007-09-07	ABVT-DELISTED	Stock	72.0	74.5	72.0	74.25	8490.0
2007-09-07	ABX-DELISTED	Stock	36.95	37.34	36.18	36.65	11109006.0
2007-09-07	ACAD	Stock	15.44	15.44	14.95	15.08	221700.0
2007-09-07	ACAP-DELISTED	Stock	38.44	38.91	37.77	37.78	37435.0
2007-09-07	ACAS-DELISTED	Stock	38.73	39.46	38.6	38.65	4625482.0
2007-09-07	ACAT-DELISTED	Stock	16.32	16.35	15.5	15.98	175708.0
2007-09-07	ACC-DELISTED	Stock	27.24	27.57	26.57	27.31	185238.0

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

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