PREVIEW / stock_daily / 2007-02-16

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-16.parquet
  size:    160 KB
  rows:    4,838
  symbols: 3,035

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-02-16	AAPL	Stock	3.0446	3.0504	3.0236	3.0296	399868000.0
2007-02-16	MSFT	Stock	28.91	28.94	28.65	28.74	109340300.0
2007-02-16	NVDA	Stock	0.5602	0.5608	0.5437	0.5453	915060000.0
2007-02-16	AMZN	Stock	1.995	2.022	1.9935	2.0165	93580000.0
2007-02-16	TLT	Stock	88.59	88.72	88.48	88.64	1476700.0
2007-02-16	CL	Stock	34.335	34.435	34.075	34.38	4235600.0
2007-02-16	A	Stock	24.1202	24.1345	23.2833	23.4406	7886118.0
2007-02-16	AABA-DELISTED	Stock	31.0	32.0	31.0	31.9099998474121	36774800.0
2007-02-16	AACC-DELISTED	Stock	15.52	15.77	15.4	15.56	77052.0
2007-02-16	AACQ-DELISTED	Stock	5.59	5.6	5.57	5.6	124464.0
2007-02-16	AACQU-DELISTED	Stock	7.0	7.0	7.0	7.0	4000.0
2007-02-16	AACQW-DELISTED	Stock	0.75	0.795	0.75	0.79	771125.0
2007-02-16	AAI-DELISTED	Stock	11.85	11.88	11.3	11.46	1879200.0
2007-02-16	AAIC-DELISTED	Stock	146.4	146.4	141.0	141.8	2429000.0
2007-02-16	AAME	Stock	3.97	3.97	3.79	3.88	8500.0
2007-02-16	AAON	Stock	3.761	3.7663	3.7136	3.7386	97959.0
2007-02-16	AAP	Stock	38.58	38.76	38.33	38.65	600400.0
2007-02-16	AATI-DELISTED	Stock	5.85	6.03	5.72	6.0	395008.0
2007-02-16	AAU-DELISTED	Stock	2.39	2.39	2.31	2.33	48300.0
2007-02-16	AAUAF-DELISTED	Stock	2.39	2.39	2.31	2.33	48300.0
2007-02-16	AAV-DELISTED	Stock	10.71	10.75	10.69	10.72	574300.0
2007-02-16	AAWW-DELISTED	Stock	50.15	50.29	49.81	49.92	80041.0
2007-02-16	AAXN-DELISTED	Stock	8.14000034332275	8.14000034332275	7.92000007629395	8.11999988555908	692500.0
2007-02-16	AB	Stock	92.49	92.49	90.7	90.77	201400.0
2007-02-16	ABAX-DELISTED	Stock	22.72	23.46	22.52	23.45	341317.0
2007-02-16	ABB-DELISTED	Stock	18.11	18.11	17.88	18.11	3654000.0
2007-02-16	ABBC-DELISTED	Stock	19.38	19.42	19.25	19.3	8395.0
2007-02-16	ABC-DELISTED	Stock	27.58	27.62	27.4	27.46	1963600.0
2007-02-16	ABCB	Stock	23.0516	23.1975	22.896	23.0808	126562.0
2007-02-16	ABCO-DELISTED	Stock	26.65	27.31	26.63	27.1	355670.0
2007-02-16	ABCW-DELISTED	Stock	29.07	29.18	28.73	29.15	52830.0
2007-02-16	ABD-DELISTED	Stock	22.86	23.09	22.7	23.03	411500.0
2007-02-16	ABE-DELISTED	Stock	19.0	19.0	18.51	19.0	34000.0
2007-02-16	ABFS-DELISTED	Stock	41.12	41.12	40.31	40.55	341479.0
2007-02-16	ABG	Stock	25.92	26.84	25.87	26.5	372900.0
2007-02-16	ABK-DELISTED	Stock	91.02	91.64	90.42	91.21	580000.0
2007-02-16	ABM	Stock	26.86	27.51	26.72	27.38	305300.0
2007-02-16	ABMD-DELISTED	Stock	14.62	14.8	14.48	14.8	137091.0
2007-02-16	ABP-DELISTED	Stock	3.1	3.1	3.0	3.05	116300.0
2007-02-16	ABR	Stock	33.11	34.41	32.93	34.05	268200.0
2007-02-16	ABT	Stock	25.2039	25.3334	25.0839	25.1847	8422259.0
2007-02-16	ABTL-DELISTED	Stock	18.9	19.3	18.6	19.25	6287.0
2007-02-16	ABV-DELISTED	Stock	53.76	54.03	52.56	52.93	603000.0
2007-02-16	ABVA-DELISTED	Stock	16.01	16.3	16.01	16.14	31815.0
2007-02-16	ABVT-DELISTED	Stock	58.0	58.0	57.0	57.0	133.0
2007-02-16	ABX-DELISTED	Stock	31.41	31.41	31.0	31.23	2967330.0
2007-02-16	ACAD	Stock	7.03	7.15	6.94	7.13	94700.0
2007-02-16	ACAP-DELISTED	Stock	37.4	37.4	36.64	36.64	163761.0
2007-02-16	ACAS-DELISTED	Stock	47.77	48.05	47.4	47.9	1260167.0
2007-02-16	ACAT-DELISTED	Stock	18.0	18.78	17.98	18.5	98532.0

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

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