PREVIEW / stock_daily / 2010-07-02

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-02.parquet
  size:    187 KB
  rows:    5,918
  symbols: 3,480

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
2010-07-02	AAPL	Stock	8.9461	8.9618	8.6857	8.8193	693842800.0
2010-07-02	MSFT	Stock	23.36	23.48	23.05	23.27	62485100.0
2010-07-02	NVDA	Stock	0.2605	0.261	0.2475	0.2563	737096000.0
2010-07-02	AMZN	Stock	5.546	5.5645	5.428	5.457	89542000.0
2010-07-02	TSLA	Stock	1.5333	1.54	1.2473	1.28	77097000.0
2010-07-02	TLT	Stock	101.11	101.44	100.16	100.79	6297545.0
2010-07-02	ES	Stock	25.44	25.84	25.44	25.65	1228700.0
2010-07-02	CL	Stock	39.67	39.67	39.195	39.36	3917800.0
2010-07-02	A	Stock	20.2861	20.3076	19.7353	19.8784	4633951.0
2010-07-02	AABA-DELISTED	Stock	14.08	14.24	14.03	14.07	18503610.0
2010-07-02	AACC-DELISTED	Stock	4.1	4.12	3.8418	3.96	32036.0
2010-07-02	AACG	Stock	2.81	3.07	2.72	2.8	19600.0
2010-07-02	AAI-DELISTED	Stock	4.83	4.9399	4.72	4.76	2548211.0
2010-07-02	AAIC-DELISTED	Stock	18.74	18.74	18.14	18.44	30401.0
2010-07-02	AAME	Stock	1.26	1.26	1.26	1.26	300.0
2010-07-02	AAON	Stock	4.7565	4.8119	4.6578	4.7664	247556.0
2010-07-02	AAP	Stock	51.72	51.99	50.68	51.01	922300.0
2010-07-02	AATI-DELISTED	Stock	3.12	3.17	3.07	3.07	43017.0
2010-07-02	AAU-DELISTED	Stock	0.86	0.88	0.8214	0.86	112265.0
2010-07-02	AAUAF-DELISTED	Stock	0.86	0.88	0.8214	0.86	113365.0
2010-07-02	AAV-DELISTED	Stock	5.75	5.88	5.7	5.81	408945.0
2010-07-02	AAWW-DELISTED	Stock	47.96	48.557	46.11	46.81	217859.0
2010-07-02	AAXJ	Stock	52.17	52.59	51.9419	52.2	431315.0
2010-07-02	AAXN-DELISTED	Stock	3.71	3.75	3.59	3.72	514272.0
2010-07-02	AB	Stock	25.15	25.67	24.82	25.24	216500.0
2010-07-02	ABAX-DELISTED	Stock	20.98	21.39	20.73	21.22	97560.0
2010-07-02	ABB-DELISTED	Stock	17.63	17.68	17.25	17.4	2263135.0
2010-07-02	ABBC-DELISTED	Stock	8.91	8.91	8.81	8.82	29683.0
2010-07-02	ABBNY-DELISTED	Stock	17.63	17.68	17.25	17.43	2315269.0
2010-07-02	ABC-DELISTED	Stock	30.95	31.17	30.725	30.9	3432294.0
2010-07-02	ABCB	Stock	9.83	9.9	9.61	9.71	86200.0
2010-07-02	ABCD-DELISTED	Stock	3.6	3.65	3.41	3.51	38851.0
2010-07-02	ABCO-DELISTED	Stock	21.63	21.65	21.27	21.43	99670.0
2010-07-02	ABCW-DELISTED	Stock	0.48	0.55	0.46	0.47	72160.0
2010-07-02	ABD-DELISTED	Stock	5.16	5.21	4.9	4.97	536940.0
2010-07-02	ABE-DELISTED	Stock	15.75	15.87	15.75	15.87	8911.0
2010-07-02	ABEO	Stock	2500.0	2500.0	2312.5	2500.0	9.0
2010-07-02	ABFS-DELISTED	Stock	20.24	20.24	19.28	19.37	299133.0
2010-07-02	ABG	Stock	10.36	10.48	10.13	10.34	381800.0
2010-07-02	ABII-DELISTED	Stock	73.87	74.37	73.85	74.2	322666.0
2010-07-02	ABK-DELISTED	Stock	0.66	0.66	0.63	0.641	3478518.0
2010-07-02	ABM	Stock	20.92	21.05	20.54	20.71	146000.0
2010-07-02	ABMD-DELISTED	Stock	9.87	9.9	9.59	9.68	122107.0
2010-07-02	ABR	Stock	4.94	4.97	4.53	4.62	132800.0
2010-07-02	ABT	Stock	22.3011	22.4354	22.1764	22.2915	11833264.0
2010-07-02	ABTL-DELISTED	Stock	5.7029	6.0004	5.6475	5.95	15203.0
2010-07-02	ABV-DELISTED	Stock	101.86	103.62	101.64	102.78	678765.0
2010-07-02	ABVT-DELISTED	Stock	46.84	48.1	46.5101	47.69	197819.0
2010-07-02	ABX-DELISTED	Stock	43.24	44.02	42.96	43.24	8802056.0
2010-07-02	ACAD	Stock	1.05	1.15	1.01	1.14	274500.0

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

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