PREVIEW / stock_daily / 2007-10-09

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-09.parquet
  size:    178 KB
  rows:    5,524
  symbols: 3,333

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-10-09	AAPL	Stock	6.0786	6.1111	5.9529	5.995	1104286400.0
2007-10-09	MSFT	Stock	30.03	30.39	30.0	30.1	63603100.0
2007-10-09	NVDA	Stock	0.9382	0.9425	0.908	0.9218	403008000.0
2007-10-09	AMZN	Stock	4.8295	4.8365	4.7375	4.766	142892000.0
2007-10-09	TLT	Stock	88.16	88.36	87.78	88.1	901000.0
2007-10-09	CL	Stock	36.15	36.5	36.005	36.43	5384200.0
2007-10-09	A	Stock	27.1173	27.3176	27.0887	27.2961	1835854.0
2007-10-09	AABA-DELISTED	Stock	28.35	28.76	27.94	28.35	19668924.0
2007-10-09	AACC-DELISTED	Stock	11.74	11.78	11.42	11.55	299140.0
2007-10-09	AAI-DELISTED	Stock	10.5	10.59	10.35	10.4	1056700.0
2007-10-09	AAIC-DELISTED	Stock	94.6	96.2	92.2	96.2	1927700.0
2007-10-09	AAME	Stock	2.68	2.75	2.68	2.68	1500.0
2007-10-09	AAON	Stock	4.0691	4.1383	3.9881	4.1067	396900.0
2007-10-09	AAP	Stock	35.48	35.5	34.72	34.8	724600.0
2007-10-09	AATI-DELISTED	Stock	11.89	12.17	11.77	12.14	998126.0
2007-10-09	AAU-DELISTED	Stock	2.64	2.75	2.56	2.7	146600.0
2007-10-09	AAUAF-DELISTED	Stock	2.64	2.75	2.56	2.6999	145900.0
2007-10-09	AAV-DELISTED	Stock	12.19	12.38	12.12	12.24	636900.0
2007-10-09	AAWW-DELISTED	Stock	53.91	54.39	53.41	54.32	82818.0
2007-10-09	AAXN-DELISTED	Stock	18.75	19.1	18.53	18.81	3194169.0
2007-10-09	AB	Stock	91.57	92.0	89.18	90.91	292100.0
2007-10-09	ABAX-DELISTED	Stock	24.86	25.72	24.86	25.64	186396.0
2007-10-09	ABB-DELISTED	Stock	26.95	27.38	26.92	27.34	2729900.0
2007-10-09	ABBC-DELISTED	Stock	9.85	9.93	9.72	9.81	38428.0
2007-10-09	ABBNY-DELISTED	Stock	26.95	27.38	26.9195	27.33	2729900.0
2007-10-09	ABC-DELISTED	Stock	22.64	22.7	21.18	22.57	1814200.0
2007-10-09	ABCB	Stock	18.1106	18.3829	17.8188	18.2468	33106.0
2007-10-09	ABCO-DELISTED	Stock	31.14	31.38	30.75	31.29	126158.0
2007-10-09	ABCW-DELISTED	Stock	27.83	27.9	27.48	27.8	69510.0
2007-10-09	ABD-DELISTED	Stock	25.1	25.17	24.94	25.06	470820.0
2007-10-09	ABE-DELISTED	Stock	24.99	25.43	24.99	25.4	41900.0
2007-10-09	ABEO	Stock	5000.0	5000.0	4900.0	5000.0	17.0
2007-10-09	ABFS-DELISTED	Stock	34.06	34.74	33.79	34.16	361134.0
2007-10-09	ABG	Stock	20.39	20.95	20.36	20.77	435600.0
2007-10-09	ABK-DELISTED	Stock	68.97	69.2	67.79	68.61	1280800.0
2007-10-09	ABM	Stock	23.27	23.44	22.55	23.17	499200.0
2007-10-09	ABMD-DELISTED	Stock	13.48	13.48	13.0	13.28	146126.0
2007-10-09	ABP-DELISTED	Stock	4.02	4.09	4.02	4.05	84700.0
2007-10-09	ABR	Stock	20.05	20.27	19.56	19.9	371200.0
2007-10-09	ABT	Stock	26.3986	26.6241	26.1731	26.3218	9318883.0
2007-10-09	ABTL-DELISTED	Stock	16.05	16.399	15.851	16.1	7876.0
2007-10-09	ABV-DELISTED	Stock	80.44	80.93	79.75	80.6	833641.0
2007-10-09	ABX-DELISTED	Stock	40.49	42.12	40.46	41.86	8704783.0
2007-10-09	ACAD	Stock	15.09	16.38	15.08	15.95	709600.0
2007-10-09	ACAP-DELISTED	Stock	41.17	41.88	40.85	41.86	28717.0
2007-10-09	ACAS-DELISTED	Stock	44.92	45.49	44.43	45.48	1530586.0
2007-10-09	ACAT-DELISTED	Stock	17.795	17.945	17.705	17.795	58158.0
2007-10-09	ACC-DELISTED	Stock	29.98	30.47	29.59	30.38	208291.0
2007-10-09	ACCL-DELISTED	Stock	7.2	7.25	6.92	6.97	62948.0
2007-10-09	ACCO	Stock	25.08	25.15	24.93	25.08	449200.0

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

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