PREVIEW / stock_daily / 2007-07-02

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-02.parquet
  size:    176 KB
  rows:    5,398
  symbols: 3,240

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-07-02	AAPL	Stock	4.3232	4.3604	4.2607	4.3307	994862400.0
2007-07-02	MSFT	Stock	29.67	29.8	29.49	29.74	47316000.0
2007-07-02	NVDA	Stock	0.6983	0.7175	0.6962	0.7172	563850000.0
2007-07-02	AMZN	Stock	3.4405	3.4855	3.41	3.4805	98122000.0
2007-07-02	TLT	Stock	84.81	85.37	84.81	85.29	2811660.0
2007-07-02	CL	Stock	32.61	32.78	32.43	32.575	3654800.0
2007-07-02	A	Stock	27.6824	28.0973	27.5036	28.0401	2540306.0
2007-07-02	AABA-DELISTED	Stock	27.19	27.27	26.76	26.88	19953269.0
2007-07-02	AACC-DELISTED	Stock	17.85	17.85	17.45	17.61	172609.0
2007-07-02	AAI-DELISTED	Stock	10.99	11.16	10.95	11.14	1355700.0
2007-07-02	AAIC-DELISTED	Stock	110.0	110.6	106.4	108.0	1725800.0
2007-07-02	AAME	Stock	4.05	4.05	3.97	3.97	1000.0
2007-07-02	AAON	Stock	4.2127	4.2601	4.1982	4.2443	438919.0
2007-07-02	AAP	Stock	40.81	41.19	40.64	41.03	841000.0
2007-07-02	AATI-DELISTED	Stock	9.72	9.9	9.72	9.86	282159.0
2007-07-02	AAU-DELISTED	Stock	2.25	2.25	2.06	2.24	94700.0
2007-07-02	AAUAF-DELISTED	Stock	2.25	2.25	2.06	2.24	94700.0
2007-07-02	AAV-DELISTED	Stock	14.1	14.14	13.9	13.99	539100.0
2007-07-02	AAWW-DELISTED	Stock	59.1	59.69	59.1	59.58	77195.0
2007-07-02	AAXN-DELISTED	Stock	14.1	14.39	14.0	14.39	4486505.0
2007-07-02	AB	Stock	86.75	88.77	86.55	88.66	213200.0
2007-07-02	ABAX-DELISTED	Stock	21.0	21.05	20.84	21.03	122259.0
2007-07-02	ABB-DELISTED	Stock	23.06	23.4	23.04	23.4	2910625.0
2007-07-02	ABBC-DELISTED	Stock	9.727	9.78	9.557	9.663	262887.0
2007-07-02	ABBNY-DELISTED	Stock	23.06	23.4	23.04	23.38	3544625.0
2007-07-02	ABC-DELISTED	Stock	24.87	24.94	24.64	24.92	2094800.0
2007-07-02	ABCB	Stock	21.972	22.6334	21.7774	22.5069	54696.0
2007-07-02	ABCO-DELISTED	Stock	27.86	28.56	27.83	28.34	361406.0
2007-07-02	ABCW-DELISTED	Stock	26.36	26.43	26.1	26.27	192080.0
2007-07-02	ABD-DELISTED	Stock	23.2	23.8	23.1	23.76	484100.0
2007-07-02	ABE-DELISTED	Stock	21.28	21.39	21.1	21.16	33000.0
2007-07-02	ABEO	Stock	6250.0	6375.0	5937.5	6375.0	10.0
2007-07-02	ABFS-DELISTED	Stock	39.18	39.73	39.04	39.4	298003.0
2007-07-02	ABG	Stock	24.97	25.41	24.97	25.28	291500.0
2007-07-02	ABK-DELISTED	Stock	87.2	87.73	86.78	87.49	917400.0
2007-07-02	ABM	Stock	25.95	26.11	25.54	26.0	227200.0
2007-07-02	ABMD-DELISTED	Stock	10.86	10.86	10.27	10.52	319725.0
2007-07-02	ABP-DELISTED	Stock	4.48	4.73	4.48	4.69	321700.0
2007-07-02	ABR	Stock	25.85	26.48	25.57	26.4	143400.0
2007-07-02	ABT	Stock	25.9044	26.0867	25.8276	26.0627	11009379.0
2007-07-02	ABTL-DELISTED	Stock	20.88	22.37	20.68	21.52	62987.0
2007-07-02	ABV-DELISTED	Stock	71.07	71.22	68.93	69.61	616900.0
2007-07-02	ABVA-DELISTED	Stock	13.35	13.35	13.13	13.17	4598.0
2007-07-02	ABVT-DELISTED	Stock	61.0	62.75	61.0	62.75	512944.0
2007-07-02	ABX-DELISTED	Stock	29.32	29.87	29.18	29.77	4342561.0
2007-07-02	ACAD	Stock	13.68	13.95	13.67	13.92	384200.0
2007-07-02	ACAP-DELISTED	Stock	40.75	41.24	40.24	40.64	36235.0
2007-07-02	ACAS-DELISTED	Stock	42.88	43.0	42.53	43.0	1647692.0
2007-07-02	ACAT-DELISTED	Stock	19.93	20.5	19.68	20.44	149302.0
2007-07-02	ACC-DELISTED	Stock	28.43	28.96	28.39	28.86	124300.0

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

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