PREVIEW / stock_daily / 2007-07-09

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-09.parquet
  size:    177 KB
  rows:    5,453
  symbols: 3,275

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-09	AAPL	Stock	4.7279	4.7464	4.6136	4.6546	995820000.0
2007-07-09	MSFT	Stock	29.86	29.95	29.81	29.87	33831400.0
2007-07-09	NVDA	Stock	0.7322	0.7542	0.732	0.7507	536784000.0
2007-07-09	AMZN	Stock	3.469	3.6175	3.451	3.6035	296338000.0
2007-07-09	TLT	Stock	83.87	83.93	83.68	83.78	795400.0
2007-07-09	CL	Stock	33.05	33.16	32.96	33.105	4619000.0
2007-07-09	A	Stock	28.3262	28.598	28.3262	28.5265	2467889.0
2007-07-09	AABA-DELISTED	Stock	26.92	27.33	26.82	27.2	16027975.0
2007-07-09	AACC-DELISTED	Stock	17.49	17.88	17.47	17.84	220451.0
2007-07-09	AAI-DELISTED	Stock	10.93	11.0	10.89	10.99	1696744.0
2007-07-09	AAIC-DELISTED	Stock	107.8	109.4	107.4	108.2	995900.0
2007-07-09	AAME	Stock	3.97	3.98	3.85	3.97	73100.0
2007-07-09	AAON	Stock	4.2469	4.2469	4.1956	4.2127	332606.0
2007-07-09	AAP	Stock	41.92	41.92	41.27	41.46	405400.0
2007-07-09	AATI-DELISTED	Stock	9.84	9.89	9.8	9.83	311830.0
2007-07-09	AAU-DELISTED	Stock	2.74	2.8	2.66	2.68	136600.0
2007-07-09	AAUAF-DELISTED	Stock	2.74	2.8	2.66	2.6801	136600.0
2007-07-09	AAV-DELISTED	Stock	14.13	14.2	13.8	13.84	1858800.0
2007-07-09	AAWW-DELISTED	Stock	60.82	61.0	59.49	60.26	122299.0
2007-07-09	AAXN-DELISTED	Stock	14.0	16.65	13.93	16.61	16823184.0
2007-07-09	AB	Stock	89.44	90.59	88.74	88.76	300700.0
2007-07-09	ABAX-DELISTED	Stock	20.93	21.12	20.64	20.74	158040.0
2007-07-09	ABB-DELISTED	Stock	23.97	24.11	23.75	24.0	1176700.0
2007-07-09	ABBC-DELISTED	Stock	9.833	9.929	9.673	9.737	140381.0
2007-07-09	ABBNY-DELISTED	Stock	23.97	24.11	23.75	24.0	1205500.0
2007-07-09	ABC-DELISTED	Stock	24.97	25.03	24.74	24.76	1257000.0
2007-07-09	ABCB	Stock	21.9526	22.4972	21.9039	21.9817	42256.0
2007-07-09	ABCO-DELISTED	Stock	28.64	28.7	28.18	28.53	179736.0
2007-07-09	ABCW-DELISTED	Stock	25.96	26.07	25.78	25.91	145850.0
2007-07-09	ABD-DELISTED	Stock	23.61	24.02	23.2	23.42	306620.0
2007-07-09	ABE-DELISTED	Stock	22.12	22.62	22.05	22.3	25500.0
2007-07-09	ABEO	Stock	6062.5	6450.0	6062.5	6437.5	3.0
2007-07-09	ABFS-DELISTED	Stock	39.82	40.94	39.58	40.84	415667.0
2007-07-09	ABG	Stock	24.52	25.07	24.2	24.62	758600.0
2007-07-09	ABK-DELISTED	Stock	86.37	87.15	85.74	86.11	891600.0
2007-07-09	ABM	Stock	26.01	26.36	25.92	26.24	456200.0
2007-07-09	ABMD-DELISTED	Stock	10.57	10.71	10.35	10.57	237050.0
2007-07-09	ABP-DELISTED	Stock	4.45	4.47	4.35	4.38	175000.0
2007-07-09	ABR	Stock	26.07	26.32	25.86	25.94	226300.0
2007-07-09	ABT	Stock	25.9092	25.9908	25.7461	25.7701	6106503.0
2007-07-09	ABTL-DELISTED	Stock	21.87	22.13	21.62	21.93	30235.0
2007-07-09	ABV-DELISTED	Stock	72.85	73.72	72.58	72.86	317400.0
2007-07-09	ABVA-DELISTED	Stock	13.1	13.29	11.71	12.6	38019.0
2007-07-09	ABVT-DELISTED	Stock	62.375	62.75	62.375	62.75	24217.0
2007-07-09	ABX-DELISTED	Stock	31.05	31.46	30.88	31.23	8794600.0
2007-07-09	ACAD	Stock	13.76	13.76	13.36	13.45	472500.0
2007-07-09	ACAP-DELISTED	Stock	39.74	40.72	39.74	40.52	27547.0
2007-07-09	ACAS-DELISTED	Stock	46.84	46.9	46.33	46.54	6090806.0
2007-07-09	ACAT-DELISTED	Stock	20.48	20.65	20.47	20.65	101994.0
2007-07-09	ACC-DELISTED	Stock	29.42	29.51	29.28	29.34	137559.0

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

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