PREVIEW / stock_daily / 2007-02-07

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-07.parquet
  size:    161 KB
  rows:    4,852
  symbols: 3,050

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-07	AAPL	Stock	3.0171	3.085	2.9839	3.0768	1066825200.0
2007-02-07	MSFT	Stock	29.64	29.7	29.25	29.37	65145500.0
2007-02-07	NVDA	Stock	0.5632	0.5818	0.5598	0.5805	761058000.0
2007-02-07	AMZN	Stock	1.9245	1.976	1.92	1.949	210064000.0
2007-02-07	TLT	Stock	87.9	88.12	87.84	88.06	836200.0
2007-02-07	CL	Stock	33.575	33.71	33.44	33.5	3267200.0
2007-02-07	A	Stock	22.9256	23.3906	22.9256	23.2976	4781440.0
2007-02-07	AABA-DELISTED	Stock	29.3500003814697	30.1499996185303	29.1200008392334	29.8899993896484	29162600.0
2007-02-07	AACC-DELISTED	Stock	15.86	16.0	15.82	15.93	69598.0
2007-02-07	AACQ-DELISTED	Stock	5.57	5.57	5.55	5.55	22813.0
2007-02-07	AACQU-DELISTED	Stock	7.02	7.02	7.02	7.02	3000.0
2007-02-07	AACQW-DELISTED	Stock	0.775	0.8	0.76	0.76	106000.0
2007-02-07	AAI-DELISTED	Stock	11.89	11.9	11.59	11.67	1771100.0
2007-02-07	AAIC-DELISTED	Stock	156.4	163.8	156.0	161.6	1080300.0
2007-02-07	AAME	Stock	3.4	3.48	3.35	3.48	9000.0
2007-02-07	AAON	Stock	3.6543	3.6543	3.5753	3.6333	43284.0
2007-02-07	AAP	Stock	37.99	38.35	37.76	38.33	584600.0
2007-02-07	AATI-DELISTED	Stock	5.62	5.68	5.56	5.57	150623.0
2007-02-07	AAU-DELISTED	Stock	2.46	2.46	2.42	2.45	6200.0
2007-02-07	AAUAF-DELISTED	Stock	2.46	2.46	2.42	2.45	6200.0
2007-02-07	AAV-DELISTED	Stock	10.72	10.79	10.7101	10.76	411000.0
2007-02-07	AAWW-DELISTED	Stock	49.35	49.35	48.96	49.16	37619.0
2007-02-07	AAXN-DELISTED	Stock	8.0	8.07999992370605	7.94000005722046	7.98000001907349	1184900.0
2007-02-07	AB	Stock	92.0	92.94	91.65	92.32	262200.0
2007-02-07	ABAX-DELISTED	Stock	22.66	22.74	22.15	22.3	111832.0
2007-02-07	ABB-DELISTED	Stock	18.75	18.85	18.67	18.72	1876000.0
2007-02-07	ABBC-DELISTED	Stock	19.28	19.47	19.25	19.33	10582.0
2007-02-07	ABC-DELISTED	Stock	26.24	26.29	26.1	26.24	1245600.0
2007-02-07	ABCB	Stock	23.4212	24.0826	23.3726	24.0826	43901.0
2007-02-07	ABCO-DELISTED	Stock	27.53	28.15	27.25	27.29	326817.0
2007-02-07	ABCW-DELISTED	Stock	29.51	29.85	29.37	29.68	48740.0
2007-02-07	ABD-DELISTED	Stock	24.7	25.05	23.96	24.1	774980.0
2007-02-07	ABE-DELISTED	Stock	18.74	18.9	18.55	18.72	24400.0
2007-02-07	ABFS-DELISTED	Stock	39.69	40.27	39.69	39.91	332360.0
2007-02-07	ABG	Stock	24.5	25.2	24.5	25.11	288000.0
2007-02-07	ABK-DELISTED	Stock	89.92	90.05	89.39	89.79	731700.0
2007-02-07	ABM	Stock	26.55	26.63	26.35	26.4	250900.0
2007-02-07	ABMD-DELISTED	Stock	14.69	14.75	14.51	14.7	120546.0
2007-02-07	ABP-DELISTED	Stock	3.27	3.32	3.26	3.29	57200.0
2007-02-07	ABR	Stock	32.7	33.0	32.13	32.85	161000.0
2007-02-07	ABT	Stock	25.1895	25.2519	25.0312	25.1655	7338891.0
2007-02-07	ABTL-DELISTED	Stock	19.55	19.8	19.1	19.25	12996.0
2007-02-07	ABV-DELISTED	Stock	52.89	52.89	52.28	52.57	223100.0
2007-02-07	ABVA-DELISTED	Stock	16.31	16.3565	16.31	16.354	3752.0
2007-02-07	ABVT-DELISTED	Stock	57.5	57.5	57.0	57.0	9.0
2007-02-07	ABX-DELISTED	Stock	30.48	30.67	30.1	30.31	3111700.0
2007-02-07	ACAD	Stock	7.19	7.19	7.09	7.12	74800.0
2007-02-07	ACAP-DELISTED	Stock	39.0	39.15	38.75	39.0	19986.0
2007-02-07	ACAS-DELISTED	Stock	47.44	47.46	46.01	47.29	2141856.0
2007-02-07	ACAT-DELISTED	Stock	17.91	18.08	17.82	18.05	100787.0

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

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