PREVIEW / stock_daily / 2007-04-17

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-17.parquet
  size:    163 KB
  rows:    4,912
  symbols: 3,097

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-04-17	AAPL	Stock	3.2857	3.2964	3.2036	3.2268	751920400.0
2007-04-17	MSFT	Stock	28.63	28.89	28.56	28.85	33170200.0
2007-04-17	NVDA	Stock	0.5198	0.5317	0.5093	0.5118	1059108000.0
2007-04-17	AMZN	Stock	2.264	2.266	2.2375	2.2535	147978000.0
2007-04-17	TLT	Stock	87.89	88.16	87.84	88.09	1254120.0
2007-04-17	CL	Stock	33.055	33.375	32.99	33.335	3682200.0
2007-04-17	A	Stock	24.9213	25.608	24.8927	25.4363	5438919.0
2007-04-17	AABA-DELISTED	Stock	31.9799995422363	32.1399993896484	31.7099990844727	32.0900001525879	43223800.0
2007-04-17	AACC-DELISTED	Stock	16.06	16.16	15.862	16.07	57775.0
2007-04-17	AACQ-DELISTED	Stock	4.38	4.4	4.34	4.4	105800.0
2007-04-17	AAI-DELISTED	Stock	11.8	11.94	11.66	11.82	1621600.0
2007-04-17	AAIC-DELISTED	Stock	117.8	120.0	116.0	118.6	1334389.0
2007-04-17	AAME	Stock	4.11	4.28	4.01	4.22	6600.0
2007-04-17	AAON	Stock	3.3014	3.412	3.3014	3.3857	205031.0
2007-04-17	AAP	Stock	40.34	40.49	40.05	40.2	511400.0
2007-04-17	AATI-DELISTED	Stock	6.86	6.86	6.67	6.8	278786.0
2007-04-17	AAU-DELISTED	Stock	2.71	2.72	2.6072	2.64	126200.0
2007-04-17	AAUAF-DELISTED	Stock	2.71	2.72	2.6072	2.64	126200.0
2007-04-17	AAV-DELISTED	Stock	10.74	11.13	10.71	11.11	1839939.0
2007-04-17	AAWW-DELISTED	Stock	59.97	59.97	58.81	59.19	208339.0
2007-04-17	AAXN-DELISTED	Stock	8.19999980926514	8.27000045776367	8.07999992370605	8.25	1005200.0
2007-04-17	AB	Stock	92.34	93.37	92.31	92.9	171400.0
2007-04-17	ABAX-DELISTED	Stock	26.97	27.0	26.45	26.99	346610.0
2007-04-17	ABB-DELISTED	Stock	18.38	18.39	18.18	18.21	5354946.0
2007-04-17	ABBC-DELISTED	Stock	20.14	20.17	19.9	19.93	6000.0
2007-04-17	ABC-DELISTED	Stock	27.38	27.44	27.2	27.4	1160000.0
2007-04-17	ABCB	Stock	25.0942	25.2595	24.7538	25.0358	20048.0
2007-04-17	ABCO-DELISTED	Stock	26.03	26.05	25.79	26.02	254957.0
2007-04-17	ABCW-DELISTED	Stock	28.55	28.78	28.32	28.55	27190.0
2007-04-17	ABD-DELISTED	Stock	24.88	25.0	24.69	24.85	330200.0
2007-04-17	ABE-DELISTED	Stock	20.26	20.5	20.26	20.46	20500.0
2007-04-17	ABFS-DELISTED	Stock	38.55	38.61	37.51	37.59	380753.0
2007-04-17	ABG	Stock	27.84	27.95	27.71	27.88	472800.0
2007-04-17	ABK-DELISTED	Stock	87.93	88.46	87.69	88.15	1071300.0
2007-04-17	ABM	Stock	27.36	27.8	27.28	27.71	319300.0
2007-04-17	ABMD-DELISTED	Stock	13.6	13.84	13.52	13.77	193329.0
2007-04-17	ABP-DELISTED	Stock	3.13	3.17	3.07	3.11	98200.0
2007-04-17	ABR	Stock	31.58	31.98	31.43	31.79	102200.0
2007-04-17	ABT	Stock	28.1403	28.5001	28.1403	28.3082	12598166.0
2007-04-17	ABTL-DELISTED	Stock	17.15	18.0	17.15	17.85	14153.0
2007-04-17	ABV-DELISTED	Stock	58.67	58.69	58.19	58.35	379500.0
2007-04-17	ABVA-DELISTED	Stock	14.74	14.83	14.74	14.83	767.0
2007-04-17	ABX-DELISTED	Stock	29.69	29.92	29.43	29.5	4337900.0
2007-04-17	ACAD	Stock	15.45	16.37	15.45	15.5	1266000.0
2007-04-17	ACAP-DELISTED	Stock	39.1	39.1	38.24	38.77	44990.0
2007-04-17	ACAS-DELISTED	Stock	46.87	47.09	46.69	46.97	1473826.0
2007-04-17	ACAT-DELISTED	Stock	19.21	19.25	18.7	18.87	46644.0
2007-04-17	ACC-DELISTED	Stock	30.42	30.84	30.39	30.75	74000.0
2007-04-17	ACCL-DELISTED	Stock	6.54	6.64	6.47	6.53	32048.0
2007-04-17	ACCO	Stock	24.88	25.0	24.69	24.85	331500.0

> showing 50 of 4,912 rows — these rows as CSV

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