PREVIEW / stock_daily / 2007-06-25

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-25.parquet
  size:    177 KB
  rows:    5,429
  symbols: 3,264

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-06-25	AAPL	Stock	4.4354	4.4675	4.3236	4.3693	965403600.0
2007-06-25	MSFT	Stock	29.47	29.77	29.38	29.49	53905800.0
2007-06-25	NVDA	Stock	0.7067	0.724	0.7002	0.7078	819702000.0
2007-06-25	AMZN	Stock	3.4675	3.4815	3.415	3.433	151870000.0
2007-06-25	TLT	Stock	84.15	84.35	83.96	84.22	1323500.0
2007-06-25	CL	Stock	32.685	33.03	32.655	32.705	4836200.0
2007-06-25	A	Stock	27.6538	27.897	27.2604	27.525	3455576.0
2007-06-25	AABA-DELISTED	Stock	27.6	27.77	27.34	27.65	20358414.0
2007-06-25	AACC-DELISTED	Stock	16.84	17.22	16.7	17.07	247991.0
2007-06-25	AAI-DELISTED	Stock	11.27	11.4	10.9	10.97	2117000.0
2007-06-25	AAIC-DELISTED	Stock	115.4	116.4	111.0	114.2	4252800.0
2007-06-25	AAME	Stock	3.91	4.03	3.82	4.02	9400.0
2007-06-25	AAON	Stock	4.0586	4.0981	3.977	4.0349	258187.0
2007-06-25	AAP	Stock	40.23	40.74	39.79	39.86	862100.0
2007-06-25	AATI-DELISTED	Stock	9.22	9.42	9.16	9.36	739259.0
2007-06-25	AAU-DELISTED	Stock	2.31	2.32	2.25	2.25	37300.0
2007-06-25	AAUAF-DELISTED	Stock	2.31	2.32	2.25	2.25	37300.0
2007-06-25	AAV-DELISTED	Stock	14.4	14.58	14.14	14.15	1429100.0
2007-06-25	AAWW-DELISTED	Stock	58.48	58.99	57.61	58.04	144306.0
2007-06-25	AAXN-DELISTED	Stock	13.91	14.03	13.5	13.77	4963737.0
2007-06-25	AB	Stock	85.05	86.53	83.61	84.33	315900.0
2007-06-25	ABAX-DELISTED	Stock	20.95	21.39	20.93	21.14	252580.0
2007-06-25	ABB-DELISTED	Stock	22.31	22.5	22.08	22.11	1608900.0
2007-06-25	ABBC-DELISTED	Stock	16.79	16.85	16.2	16.21	43993.0
2007-06-25	ABBNY-DELISTED	Stock	22.31	22.5	22.08	22.11	1633900.0
2007-06-25	ABC-DELISTED	Stock	24.75	25.1	24.72	24.82	1733852.0
2007-06-25	ABCB	Stock	21.9137	22.1665	21.437	21.651	47499.0
2007-06-25	ABCO-DELISTED	Stock	26.68	27.28	26.68	27.22	933340.0
2007-06-25	ABCW-DELISTED	Stock	27.16	27.29	26.66	26.73	254520.0
2007-06-25	ABD-DELISTED	Stock	24.01	24.13	23.54	23.67	412800.0
2007-06-25	ABE-DELISTED	Stock	21.2	21.4	21.11	21.3	23400.0
2007-06-25	ABEO	Stock	6312.5	6312.5	6250.0	6250.0	2.0
2007-06-25	ABFS-DELISTED	Stock	39.57	40.86	39.37	39.99	602897.0
2007-06-25	ABG	Stock	26.15	26.15	25.43	25.62	435000.0
2007-06-25	ABK-DELISTED	Stock	85.75	85.75	84.02	84.58	2062668.0
2007-06-25	ABM	Stock	25.58	25.63	24.85	25.11	323300.0
2007-06-25	ABMD-DELISTED	Stock	10.99	11.18	10.83	11.0	200117.0
2007-06-25	ABP-DELISTED	Stock	4.39	4.39	4.25	4.31	136600.0
2007-06-25	ABR	Stock	25.97	26.27	25.73	25.76	229300.0
2007-06-25	ABT	Stock	25.5398	26.3362	25.4246	25.9332	19822426.0
2007-06-25	ABTL-DELISTED	Stock	20.5	21.3	20.5	20.65	15050.0
2007-06-25	ABV-DELISTED	Stock	69.2	69.23	67.22	67.55	849600.0
2007-06-25	ABVA-DELISTED	Stock	13.15	13.27	13.13	13.13	1745.0
2007-06-25	ABX-DELISTED	Stock	29.56	29.56	28.89	28.94	5042200.0
2007-06-25	ACAD	Stock	14.41	14.49	13.89	14.1	451400.0
2007-06-25	ACAP-DELISTED	Stock	39.5	40.13	39.0	39.44	74007.0
2007-06-25	ACAS-DELISTED	Stock	43.55	43.61	42.57	42.83	2510494.0
2007-06-25	ACAT-DELISTED	Stock	19.14	20.15	19.13	19.62	73860.0
2007-06-25	ACC-DELISTED	Stock	28.03	28.35	27.61	27.64	194547.0
2007-06-25	ACCL-DELISTED	Stock	6.02	6.04	5.82	5.92	33452.0

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

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