PREVIEW / stock_daily / 2007-04-23

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-23.parquet
  size:    163 KB
  rows:    4,928
  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-23	AAPL	Stock	3.2711	3.35	3.265	3.3396	780290000.0
2007-04-23	MSFT	Stock	28.96	28.99	28.67	28.78	41739100.0
2007-04-23	NVDA	Stock	0.529	0.53	0.5213	0.5228	595272000.0
2007-04-23	AMZN	Stock	2.2135	2.2405	2.208	2.2385	141772000.0
2007-04-23	TLT	Stock	88.14	88.59	88.04	88.47	419300.0
2007-04-23	CL	Stock	33.7	33.7	33.45	33.53	2272200.0
2007-04-23	A	Stock	25.279	25.4649	24.6638	25.3219	3096850.0
2007-04-23	AABA-DELISTED	Stock	27.5300006866455	28.1399993896484	27.3700008392334	27.8799991607666	27262400.0
2007-04-23	AACC-DELISTED	Stock	16.21	16.21	16.0	16.03	156644.0
2007-04-23	AACQU-DELISTED	Stock	5.65	5.65	5.65	5.65	1500.0
2007-04-23	AACQW-DELISTED	Stock	0.63	0.65	0.63	0.63	10500.0
2007-04-23	AAI-DELISTED	Stock	11.63	11.73	11.38	11.61	2100900.0
2007-04-23	AAIC-DELISTED	Stock	132.6	132.6	121.4	122.2	1706200.0
2007-04-23	AAME	Stock	4.85	5.42	4.85	5.35	52800.0
2007-04-23	AAON	Stock	3.2435	3.3291	3.2435	3.2935	162506.0
2007-04-23	AAP	Stock	40.7	41.27	40.5	41.19	580400.0
2007-04-23	AATI-DELISTED	Stock	6.72	6.78	6.62	6.65	138807.0
2007-04-23	AAU-DELISTED	Stock	2.59	2.62	2.55	2.6	40600.0
2007-04-23	AAUAF-DELISTED	Stock	2.59	2.62	2.55	2.6	40600.0
2007-04-23	AAV-DELISTED	Stock	11.32	11.42	11.3	11.39	843006.0
2007-04-23	AAWW-DELISTED	Stock	59.9	59.96	59.36	59.54	63926.0
2007-04-23	AAXN-DELISTED	Stock	8.39000034332275	8.5	8.21000003814697	8.23999977111816	960300.0
2007-04-23	AB	Stock	93.3	94.94	93.3	93.6	126000.0
2007-04-23	ABAX-DELISTED	Stock	25.44	25.44	24.55	24.86	251248.0
2007-04-23	ABB-DELISTED	Stock	18.88	19.07	18.86	18.89	2485453.0
2007-04-23	ABBC-DELISTED	Stock	19.8	19.8	19.58	19.58	9809.0
2007-04-23	ABC-DELISTED	Stock	27.47	27.54	27.3	27.52	1611800.0
2007-04-23	ABCB	Stock	24.2091	24.5106	24.034	24.1896	18506.0
2007-04-23	ABCO-DELISTED	Stock	25.45	25.46	25.09	25.18	168142.0
2007-04-23	ABCW-DELISTED	Stock	28.31	28.51	27.94	27.99	24210.0
2007-04-23	ABD-DELISTED	Stock	24.4	24.48	24.28	24.36	412800.0
2007-04-23	ABE-DELISTED	Stock	20.79	21.1	20.79	20.844	13800.0
2007-04-23	ABFS-DELISTED	Stock	39.0	39.68	38.72	38.97	576222.0
2007-04-23	ABG	Stock	27.94	28.11	27.41	28.03	344000.0
2007-04-23	ABK-DELISTED	Stock	90.13	90.97	90.12	90.31	640730.0
2007-04-23	ABM	Stock	27.81	28.07	27.75	28.02	256900.0
2007-04-23	ABMD-DELISTED	Stock	13.66	13.89	13.16	13.89	202900.0
2007-04-23	ABP-DELISTED	Stock	3.14	3.14	3.05	3.08	65100.0
2007-04-23	ABR	Stock	31.65	32.07	31.65	32.01	49100.0
2007-04-23	ABT	Stock	27.5885	27.7324	27.3966	27.4494	10998541.0
2007-04-23	ABTL-DELISTED	Stock	17.5	17.5	16.7	16.75	21186.0
2007-04-23	ABV-DELISTED	Stock	59.98	60.31	59.59	59.65	771900.0
2007-04-23	ABVA-DELISTED	Stock	14.81	14.81	14.81	14.81	100.0
2007-04-23	ABX-DELISTED	Stock	28.84	28.87	28.37	28.53	4714259.0
2007-04-23	ACAD	Stock	14.55	14.69	14.26	14.45	433700.0
2007-04-23	ACAP-DELISTED	Stock	39.5	40.26	39.01	39.72	91715.0
2007-04-23	ACAS-DELISTED	Stock	47.47	47.92	47.34	47.62	1270484.0
2007-04-23	ACAT-DELISTED	Stock	18.26	18.58	18.24	18.48	53800.0
2007-04-23	ACC-DELISTED	Stock	30.27	30.85	30.27	30.81	144600.0
2007-04-23	ACCL-DELISTED	Stock	6.43	6.53	6.34	6.49	22612.0

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

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