PREVIEW / stock_daily / 2007-01-26

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-26.parquet
  size:    160 KB
  rows:    4,811
  symbols: 3,021

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-01-26	AAPL	Stock	3.1111	3.1204	3.0354	3.0493	986874000.0
2007-01-26	MSFT	Stock	31.22	31.23	30.6	30.6	96103700.0
2007-01-26	NVDA	Stock	0.5333	0.5385	0.515	0.5245	829584000.0
2007-01-26	AMZN	Stock	1.863	1.863	1.815	1.8425	82786000.0
2007-01-26	TLT	Stock	86.78	87.08	86.61	86.91	1737300.0
2007-01-26	CL	Stock	33.025	33.14	32.815	33.09	3357000.0
2007-01-26	A	Stock	22.8898	23.2475	22.8827	23.1545	2507593.0
2007-01-26	AABA-DELISTED	Stock	28.3299999237061	28.5200004577637	27.9599990844727	28.0400009155273	21334800.0
2007-01-26	AACC-DELISTED	Stock	15.5	15.76	15.38	15.72	77638.0
2007-01-26	AACQ-DELISTED	Stock	5.56	5.59	5.56	5.59	2500.0
2007-01-26	AACQW-DELISTED	Stock	0.78	0.79	0.78	0.78	155500.0
2007-01-26	AAI-DELISTED	Stock	10.92	11.26	10.72	11.15	3236400.0
2007-01-26	AAIC-DELISTED	Stock	153.8	154.6	148.0	154.2	1196000.0
2007-01-26	AAME	Stock	3.38	3.41	3.29	3.3	11600.0
2007-01-26	AAON	Stock	3.6649	3.6649	3.5398	3.6491	120741.0
2007-01-26	AAP	Stock	37.38	37.56	36.89	37.49	375300.0
2007-01-26	AATI-DELISTED	Stock	6.04	6.04	5.888	5.94	164316.0
2007-01-26	AAU-DELISTED	Stock	2.349	2.4	2.32	2.36	34200.0
2007-01-26	AAUAF-DELISTED	Stock	2.349	2.4	2.32	2.36	34200.0
2007-01-26	AAV-DELISTED	Stock	10.96	11.01	10.92	10.9601	586000.0
2007-01-26	AAWW-DELISTED	Stock	47.3	47.65	46.6	47.38	88128.0
2007-01-26	AAXN-DELISTED	Stock	7.63000011444092	7.69000005722046	7.5	7.6399998664856	686000.0
2007-01-26	AB	Stock	91.4	91.4	89.34	90.65	298000.0
2007-01-26	ABAX-DELISTED	Stock	18.72	20.89	18.54	20.63	1226779.0
2007-01-26	ABB-DELISTED	Stock	17.64	17.65	17.3	17.46	892900.0
2007-01-26	ABBC-DELISTED	Stock	18.99	19.04	18.9	18.96	5360.0
2007-01-26	ABC-DELISTED	Stock	26.49	26.6	26.2	26.44	2800000.0
2007-01-26	ABCB	Stock	25.7945	25.7945	24.8607	25.5027	20357.0
2007-01-26	ABCO-DELISTED	Stock	27.03	27.22	26.65	27.22	236256.0
2007-01-26	ABCW-DELISTED	Stock	28.75	28.99	28.6	28.95	41430.0
2007-01-26	ABD-DELISTED	Stock	24.82	24.83	24.5	24.7	245900.0
2007-01-26	ABE-DELISTED	Stock	18.25	18.45	18.0	18.37	38100.0
2007-01-26	ABFS-DELISTED	Stock	37.21	37.23	35.85	36.48	744915.0
2007-01-26	ABG	Stock	23.71	23.86	23.57	23.86	86700.0
2007-01-26	ABK-DELISTED	Stock	87.23	87.36	86.11	87.3	357400.0
2007-01-26	ABM	Stock	24.5	24.74	24.36	24.7	182200.0
2007-01-26	ABMD-DELISTED	Stock	14.3	14.44	14.15	14.3	84328.0
2007-01-26	ABP-DELISTED	Stock	3.18	3.25	3.11	3.18	76100.0
2007-01-26	ABR	Stock	31.2	31.3	30.86	31.19	99000.0
2007-01-26	ABT	Stock	25.2855	25.3142	24.9256	25.2135	14243852.0
2007-01-26	ABTL-DELISTED	Stock	18.825	19.025	18.526	19.025	32923.0
2007-01-26	ABV-DELISTED	Stock	51.65	51.65	50.43	50.89	291000.0
2007-01-26	ABVA-DELISTED	Stock	16.4	16.45	16.4	16.45	1200.0
2007-01-26	ABVT-DELISTED	Stock	57.95	57.95	57.95	57.95	1.0
2007-01-26	ABX-DELISTED	Stock	29.18	29.37	29.0	29.08	3233415.0
2007-01-26	ACAD	Stock	7.05	7.05	6.99	7.02	261700.0
2007-01-26	ACAP-DELISTED	Stock	36.73	36.76	35.99	36.6	36769.0
2007-01-26	ACAS-DELISTED	Stock	47.59	47.77	47.18	47.7	645845.0
2007-01-26	ACAT-DELISTED	Stock	18.26	18.6	17.95	18.57	69394.0
2007-01-26	ACC-DELISTED	Stock	31.1	31.1	30.73	30.98	36092.0

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

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