PREVIEW / stock_daily / 2007-04-16

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-16.parquet
  size:    164 KB
  rows:    4,929
  symbols: 3,106

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-16	AAPL	Stock	3.2346	3.2679	3.2232	3.2654	609033600.0
2007-04-16	MSFT	Stock	28.6	28.75	28.21	28.73	30740100.0
2007-04-16	NVDA	Stock	0.5083	0.5122	0.5005	0.507	671838000.0
2007-04-16	AMZN	Stock	2.1885	2.265	2.1835	2.26	268880000.0
2007-04-16	TLT	Stock	87.4	87.6763	87.4	87.59	833600.0
2007-04-16	CL	Stock	33.185	33.25	32.985	33.1	4508600.0
2007-04-16	A	Stock	24.6781	25.0429	24.6209	25.0215	2795581.0
2007-04-16	AABA-DELISTED	Stock	31.6800003051758	31.7900009155273	31.2399997711182	31.6100006103516	14359100.0
2007-04-16	AACC-DELISTED	Stock	15.56	16.09	15.56	16.09	96809.0
2007-04-16	AACQ-DELISTED	Stock	4.38	4.38	4.38	4.38	500.0
2007-04-16	AACQW-DELISTED	Stock	0.62	0.62	0.62	0.62	9100.0
2007-04-16	AAI-DELISTED	Stock	11.62	11.98	11.62	11.82	2434565.0
2007-04-16	AAIC-DELISTED	Stock	116.0	119.0	115.6	118.0	1324810.0
2007-04-16	AAME	Stock	3.92	4.26	3.92	4.21	12200.0
2007-04-16	AAON	Stock	3.3159	3.3212	3.2909	3.2922	114666.0
2007-04-16	AAP	Stock	39.9	40.31	39.81	40.25	423800.0
2007-04-16	AATI-DELISTED	Stock	6.86	6.95	6.75	6.83	410483.0
2007-04-16	AAU-DELISTED	Stock	2.53	2.66	2.5	2.6	134000.0
2007-04-16	AAUAF-DELISTED	Stock	2.53	2.66	2.5	2.6	134000.0
2007-04-16	AAV-DELISTED	Stock	10.54	10.65	10.5	10.63	645375.0
2007-04-16	AAWW-DELISTED	Stock	58.75	59.97	58.75	59.8	112209.0
2007-04-16	AAXN-DELISTED	Stock	8.14999961853027	8.22000026702881	8.10999965667725	8.15999984741211	609000.0
2007-04-16	AB	Stock	92.2	93.55	92.14	93.32	162800.0
2007-04-16	ABAX-DELISTED	Stock	26.54	26.98	26.46	26.9615	198331.0
2007-04-16	ABB-DELISTED	Stock	18.37	18.44	18.33	18.43	1394448.0
2007-04-16	ABBC-DELISTED	Stock	19.96	20.2	19.96	20.02	9058.0
2007-04-16	ABC-DELISTED	Stock	27.25	27.41	27.18	27.34	1580400.0
2007-04-16	ABCB	Stock	24.316	25.0942	24.3063	25.0261	24778.0
2007-04-16	ABCO-DELISTED	Stock	25.73	26.06	25.73	26.06	50356.0
2007-04-16	ABCW-DELISTED	Stock	27.99	28.62	27.94	28.57	36380.0
2007-04-16	ABD-DELISTED	Stock	24.94	25.09	24.79	24.85	396700.0
2007-04-16	ABE-DELISTED	Stock	19.9	20.55	19.81	20.22	22700.0
2007-04-16	ABFS-DELISTED	Stock	37.78	38.83	37.78	38.64	417023.0
2007-04-16	ABG	Stock	27.05	27.9	27.05	27.7	594100.0
2007-04-16	ABK-DELISTED	Stock	87.3	88.38	87.29	88.1	881000.0
2007-04-16	ABM	Stock	27.14	27.43	27.12	27.4	187500.0
2007-04-16	ABMD-DELISTED	Stock	13.52	13.6	13.48	13.6	79295.0
2007-04-16	ABP-DELISTED	Stock	3.07	3.18	3.07	3.16	88100.0
2007-04-16	ABR	Stock	31.18	31.41	31.16	31.27	89600.0
2007-04-16	ABT	Stock	28.2074	28.3322	28.1355	28.2506	10061276.0
2007-04-16	ABTL-DELISTED	Stock	16.852	17.503	16.852	17.248	16491.0
2007-04-16	ABV-DELISTED	Stock	58.19	58.58	58.19	58.43	461400.0
2007-04-16	ABVA-DELISTED	Stock	14.82	15.01	14.7747	14.838	2920.0
2007-04-16	ABX-DELISTED	Stock	29.41	29.81	29.35	29.7	5599957.0
2007-04-16	ACAD	Stock	15.57	15.63	15.32	15.48	279600.0
2007-04-16	ACAP-DELISTED	Stock	38.19	39.11	38.19	38.99	46969.0
2007-04-16	ACAS-DELISTED	Stock	46.0	46.75	46.0	46.75	1186074.0
2007-04-16	ACAT-DELISTED	Stock	18.745	19.235	18.745	19.175	69247.0
2007-04-16	ACC-DELISTED	Stock	29.85	30.44	29.8	30.44	82924.0
2007-04-16	ACCL-DELISTED	Stock	6.53	6.58	6.47	6.48	25551.0

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

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