PREVIEW / stock_daily / 2007-01-18

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-18.parquet
  size:    160 KB
  rows:    4,808
  symbols: 3,016

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-18	AAPL	Stock	3.2893	3.2896	3.1804	3.1811	2364605600.0
2007-01-18	MSFT	Stock	31.15	31.37	30.8	31.0	56364300.0
2007-01-18	NVDA	Stock	0.5708	0.5708	0.521	0.5282	1501638000.0
2007-01-18	AMZN	Stock	1.875	1.8825	1.836	1.849	182100000.0
2007-01-18	TLT	Stock	87.94	88.28	87.78	88.23	918300.0
2007-01-18	CL	Stock	33.255	33.41	33.115	33.24	2710800.0
2007-01-18	A	Stock	23.4263	23.4549	22.8183	23.0687	5071525.0
2007-01-18	AABA-DELISTED	Stock	28.9200000762939	28.9899997711182	27.8199996948242	28.1200008392334	23869400.0
2007-01-18	AACC-DELISTED	Stock	15.73	15.86	15.5401	15.57	44709.0
2007-01-18	AACQ-DELISTED	Stock	5.52	5.53	5.52	5.53	2000.0
2007-01-18	AACQU-DELISTED	Stock	6.75	6.8	6.75	6.8	5500.0
2007-01-18	AACQW-DELISTED	Stock	0.63	0.65	0.63	0.65	108646.0
2007-01-18	AAI-DELISTED	Stock	12.44	12.68	12.02	12.04	2680500.0
2007-01-18	AAIC-DELISTED	Stock	160.0	160.6	157.6	158.4	1202800.0
2007-01-18	AAON	Stock	3.6319	3.6319	3.4897	3.4963	198197.0
2007-01-18	AAP	Stock	36.34	37.11	36.34	36.98	922900.0
2007-01-18	AATI-DELISTED	Stock	5.83	5.86	5.6	5.64	304983.0
2007-01-18	AAU-DELISTED	Stock	2.23	2.24	2.19	2.19	42500.0
2007-01-18	AAUAF-DELISTED	Stock	2.23	2.24	2.19	2.19	42500.0
2007-01-18	AAV-DELISTED	Stock	10.85	11.0	10.8	10.87	633100.0
2007-01-18	AAWW-DELISTED	Stock	47.63	48.0	47.399	47.7	154005.0
2007-01-18	AAXN-DELISTED	Stock	8.02000045776367	8.05000019073486	7.76999998092651	7.80999994277954	1118200.0
2007-01-18	AB	Stock	87.69	88.42	87.69	87.98	382900.0
2007-01-18	ABAX-DELISTED	Stock	19.01	19.08	18.51	18.61	112161.0
2007-01-18	ABB-DELISTED	Stock	17.75	17.86	17.61	17.7801	2208900.0
2007-01-18	ABBC-DELISTED	Stock	18.89	19.0	18.85	18.89	7114.0
2007-01-18	ABC-DELISTED	Stock	24.2	24.4	23.98	24.02	1874800.0
2007-01-18	ABCB	Stock	26.8449	26.9519	25.9403	26.0376	53360.0
2007-01-18	ABCO-DELISTED	Stock	27.15	27.15	26.45	26.48	165935.0
2007-01-18	ABCW-DELISTED	Stock	28.83	28.84	28.57	28.76	50610.0
2007-01-18	ABD-DELISTED	Stock	23.51	24.13	23.3	23.51	1191730.0
2007-01-18	ABE-DELISTED	Stock	18.67	18.6799	18.11	18.38	27900.0
2007-01-18	ABFS-DELISTED	Stock	39.75	39.83	38.85	38.88	361626.0
2007-01-18	ABG	Stock	23.41	23.61	23.33	23.38	114200.0
2007-01-18	ABK-DELISTED	Stock	87.35	87.58	86.68	87.41	475200.0
2007-01-18	ABM	Stock	24.69	24.81	24.48	24.5	299400.0
2007-01-18	ABMD-DELISTED	Stock	14.7	14.7	14.4	14.52	66371.0
2007-01-18	ABP-DELISTED	Stock	3.07	3.13	3.04	3.04	151000.0
2007-01-18	ABR	Stock	30.54	30.59	29.94	30.49	470100.0
2007-01-18	ABT	Stock	24.9496	25.391	24.9496	25.3286	27157774.0
2007-01-18	ABTL-DELISTED	Stock	16.65	16.85	16.5	16.75	46986.0
2007-01-18	ABV-DELISTED	Stock	50.8	50.95	50.07	50.33	330300.0
2007-01-18	ABVA-DELISTED	Stock	16.5054	16.58	16.5054	16.58	1500.0
2007-01-18	ABX-DELISTED	Stock	29.0	29.2	28.29	28.36	4942325.0
2007-01-18	ACAD	Stock	7.07	7.41	7.06	7.37	233300.0
2007-01-18	ACAP-DELISTED	Stock	37.63	37.69	36.64	36.64	56324.0
2007-01-18	ACAS-DELISTED	Stock	47.16	47.25	46.84	47.02	611267.0
2007-01-18	ACAT-DELISTED	Stock	16.715	16.825	16.715	16.775	69161.0
2007-01-18	ACC-DELISTED	Stock	30.44	30.45	29.97	30.15	80600.0
2007-01-18	ACCL-DELISTED	Stock	6.11	6.19	6.0	6.02	43619.0

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

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