PREVIEW / stock_daily / 2007-04-30

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-30.parquet
  size:    166 KB
  rows:    4,999
  symbols: 3,120

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-30	AAPL	Stock	3.5746	3.6071	3.5596	3.5643	616509600.0
2007-04-30	MSFT	Stock	30.13	30.37	29.94	29.94	67788800.0
2007-04-30	NVDA	Stock	0.5587	0.5657	0.548	0.5482	563388000.0
2007-04-30	AMZN	Stock	3.0955	3.122	3.059	3.0665	479584000.0
2007-04-30	TLT	Stock	88.33	88.75	88.25	88.75	485700.0
2007-04-30	CL	Stock	33.75	33.89	33.6	33.87	6271600.0
2007-04-30	A	Stock	24.8712	24.9285	24.5708	24.5851	4092226.0
2007-04-30	AABA-DELISTED	Stock	28.32	28.5	28.0	28.04	16096355.0
2007-04-30	AACC-DELISTED	Stock	18.51	18.56	18.25	18.42	538210.0
2007-04-30	AAI-DELISTED	Stock	11.23	11.25	10.97	11.0	1778068.0
2007-04-30	AAIC-DELISTED	Stock	117.8	117.8	110.6	111.0	2590200.0
2007-04-30	AAME	Stock	5.34	5.37	5.26	5.32	9600.0
2007-04-30	AAON	Stock	3.3053	3.3053	3.229	3.2566	271856.0
2007-04-30	AAP	Stock	41.65	42.0	41.08	41.2	988100.0
2007-04-30	AATI-DELISTED	Stock	8.02	8.15	7.95	8.1	579914.0
2007-04-30	AAU-DELISTED	Stock	2.51	2.57	2.5	2.54	46400.0
2007-04-30	AAUAF-DELISTED	Stock	2.51	2.57	2.5	2.54	46400.0
2007-04-30	AAV-DELISTED	Stock	11.37	11.42	11.29	11.35	413400.0
2007-04-30	AAWW-DELISTED	Stock	58.66	58.66	57.03	57.5	87901.0
2007-04-30	AAXN-DELISTED	Stock	8.21000003814697	8.75	8.13000011444092	8.63000011444092	4418500.0
2007-04-30	AB	Stock	91.07	91.78	90.14	90.96	185900.0
2007-04-30	ABAX-DELISTED	Stock	23.0	23.28	22.74	22.82	440983.0
2007-04-30	ABB-DELISTED	Stock	20.28	20.45	19.94	19.94	2126771.0
2007-04-30	ABBC-DELISTED	Stock	19.05	19.05	18.25	18.44	31557.0
2007-04-30	ABC-DELISTED	Stock	25.32	25.34	24.99	25.01	3233280.0
2007-04-30	ABCB	Stock	22.9057	23.1975	22.2638	22.3124	43387.0
2007-04-30	ABCO-DELISTED	Stock	23.65	23.79	23.48	23.74	231730.0
2007-04-30	ABCW-DELISTED	Stock	27.69	27.9	26.76	26.92	92960.0
2007-04-30	ABD-DELISTED	Stock	23.98	24.0	23.74	23.8	529200.0
2007-04-30	ABE-DELISTED	Stock	21.81	21.82	20.5	20.75	41900.0
2007-04-30	ABFS-DELISTED	Stock	39.69	40.48	39.37	39.4	564293.0
2007-04-30	ABG	Stock	30.06	30.06	28.72	28.77	970100.0
2007-04-30	ABK-DELISTED	Stock	94.75	94.75	91.84	91.85	886900.0
2007-04-30	ABM	Stock	28.77	28.86	28.1	28.14	322400.0
2007-04-30	ABMD-DELISTED	Stock	13.29	13.33	12.58	12.82	207564.0
2007-04-30	ABP-DELISTED	Stock	3.39	3.53	3.34	3.49	492300.0
2007-04-30	ABR	Stock	31.63	31.93	30.72	30.79	99500.0
2007-04-30	ABT	Stock	27.315	27.315	27.0463	27.1663	10921009.0
2007-04-30	ABTL-DELISTED	Stock	16.801	17.399	16.751	17.399	26366.0
2007-04-30	ABV-DELISTED	Stock	59.14	59.54	58.27	58.36	407500.0
2007-04-30	ABVA-DELISTED	Stock	14.31	14.45	14.3	14.3	7361.0
2007-04-30	ABX-DELISTED	Stock	28.72	28.72	28.07	28.09	3938073.0
2007-04-30	ACAD	Stock	13.7	14.2	13.53	13.66	948400.0
2007-04-30	ACAP-DELISTED	Stock	40.84	40.98	39.38	39.53	82850.0
2007-04-30	ACAS-DELISTED	Stock	48.95	49.45	48.61	48.68	1310905.0
2007-04-30	ACAT-DELISTED	Stock	18.115	18.215	17.785	17.785	72485.0
2007-04-30	ACC-DELISTED	Stock	31.07	31.18	30.32	30.51	119124.0
2007-04-30	ACCL-DELISTED	Stock	6.44	6.52	6.44	6.52	66137.0
2007-04-30	ACCO	Stock	23.98	24.0	23.74	23.8	531200.0
2007-04-30	ACCP-DELISTED	Stock	4.8	5.25	4.79	5.0	27980.0

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

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