PREVIEW / stock_daily / 2007-06-26

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-26.parquet
  size:    177 KB
  rows:    5,407
  symbols: 3,249

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-26	AAPL	Stock	4.4279	4.4286	4.24	4.2732	1345005200.0
2007-06-26	MSFT	Stock	29.55	29.8	29.5	29.52	48340300.0
2007-06-26	NVDA	Stock	0.706	0.708	0.6733	0.675	868482000.0
2007-06-26	AMZN	Stock	3.4265	3.4315	3.369	3.374	224956000.0
2007-06-26	TLT	Stock	84.29	84.32	83.97	84.24	2187780.0
2007-06-26	CL	Stock	32.77	32.775	32.285	32.325	7936400.0
2007-06-26	A	Stock	27.6037	27.6753	27.1888	27.4678	2308098.0
2007-06-26	AABA-DELISTED	Stock	27.73	28.18	27.36	27.73	24250697.0
2007-06-26	AACC-DELISTED	Stock	17.12	17.25	17.04	17.07	234103.0
2007-06-26	AAI-DELISTED	Stock	10.52	11.08	10.52	10.73	2077900.0
2007-06-26	AAIC-DELISTED	Stock	115.0	116.2	109.2	110.2	2827238.0
2007-06-26	AAME	Stock	4.07	4.1	3.95	3.96	5600.0
2007-06-26	AAON	Stock	4.0494	4.1152	4.0165	4.0955	441197.0
2007-06-26	AAP	Stock	40.02	40.08	39.22	39.31	1089400.0
2007-06-26	AATI-DELISTED	Stock	9.43	9.79	9.43	9.65	472387.0
2007-06-26	AAU-DELISTED	Stock	2.25	2.29	2.23	2.25	48500.0
2007-06-26	AAUAF-DELISTED	Stock	2.25	2.29	2.23	2.25	48500.0
2007-06-26	AAV-DELISTED	Stock	14.16	14.34	13.6	13.89	1478200.0
2007-06-26	AAWW-DELISTED	Stock	58.22	58.91	57.05	57.69	206940.0
2007-06-26	AAXN-DELISTED	Stock	13.94	13.99	13.08	13.19	4342222.0
2007-06-26	AB	Stock	83.53	84.84	82.9	84.0	535100.0
2007-06-26	ABAX-DELISTED	Stock	21.26	21.45	20.93	20.95	981556.0
2007-06-26	ABB-DELISTED	Stock	22.2	22.44	22.03	22.12	2173075.0
2007-06-26	ABBC-DELISTED	Stock	16.4	16.4	15.91	15.93	31934.0
2007-06-26	ABBNY-DELISTED	Stock	22.2	22.44	22.03	22.12	2191575.0
2007-06-26	ABC-DELISTED	Stock	24.94	25.04	24.68	24.73	1814600.0
2007-06-26	ABCB	Stock	21.7288	22.5362	21.4176	22.4194	89241.0
2007-06-26	ABCO-DELISTED	Stock	27.28	27.69	27.04	27.47	362714.0
2007-06-26	ABCW-DELISTED	Stock	26.75	26.9	26.46	26.51	241480.0
2007-06-26	ABD-DELISTED	Stock	23.85	23.95	23.49	23.51	310500.0
2007-06-26	ABE-DELISTED	Stock	20.41	21.06	20.21	21.05	69800.0
2007-06-26	ABEO	Stock	6375.0	6375.0	6125.0	6137.5	10.0
2007-06-26	ABFS-DELISTED	Stock	40.0	40.06	38.98	39.17	403815.0
2007-06-26	ABG	Stock	25.65	25.67	24.84	25.03	544400.0
2007-06-26	ABK-DELISTED	Stock	84.48	85.58	84.07	85.07	2010194.0
2007-06-26	ABM	Stock	25.14	25.18	24.79	24.89	351400.0
2007-06-26	ABMD-DELISTED	Stock	11.1	11.32	10.98	11.18	182074.0
2007-06-26	ABP-DELISTED	Stock	4.31	4.38	4.26	4.32	202200.0
2007-06-26	ABR	Stock	25.79	26.0	25.53	25.89	136500.0
2007-06-26	ABT	Stock	26.6289	26.6289	25.8276	25.8948	16454564.0
2007-06-26	ABTL-DELISTED	Stock	20.9	21.15	20.75	21.05	22638.0
2007-06-26	ABV-DELISTED	Stock	68.39	68.4	66.68	66.84	768300.0
2007-06-26	ABVA-DELISTED	Stock	13.29	13.4	13.14	13.18	5378.0
2007-06-26	ABVT-DELISTED	Stock	65.0	65.0	61.5	61.5	822.0
2007-06-26	ABX-DELISTED	Stock	28.97	28.98	27.98	28.18	7238166.0
2007-06-26	ACAD	Stock	14.16	14.25	14.0	14.18	398000.0
2007-06-26	ACAP-DELISTED	Stock	39.64	40.15	39.45	39.82	59918.0
2007-06-26	ACAS-DELISTED	Stock	42.86	42.96	42.15	42.42	2390552.0
2007-06-26	ACAT-DELISTED	Stock	19.7	20.39	19.7	20.33	110361.0
2007-06-26	ACC-DELISTED	Stock	27.64	28.0	27.18	27.54	246200.0

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

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