PREVIEW / stock_daily / 2010-01-07

all stock daily files

  file:    by_date/stock_daily/2010/2010-01-07.parquet
  size:    189 KB
  rows:    5,907
  symbols: 3,496

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-01-07	AAPL	Stock	7.5625	7.5714	7.4661	7.5207	477131200.0
2010-01-07	MSFT	Stock	30.63	30.7	30.19	30.45	50559700.0
2010-01-07	NVDA	Stock	0.4695	0.4715	0.4593	0.4628	547792000.0
2010-01-07	AMZN	Stock	6.6005	6.616	6.44	6.5	220604000.0
2010-01-07	TLT	Stock	89.22	89.6422	89.12	89.33	2794417.0
2010-01-07	ES	Stock	26.04	26.16	25.81	25.97	881300.0
2010-01-07	CL	Stock	41.53	41.535	41.125	41.5	3752200.0
2010-01-07	A	Stock	22.0172	22.0458	21.8169	22.0386	3095172.0
2010-01-07	AABA-DELISTED	Stock	16.81	16.9	16.57	16.71	30580898.0
2010-01-07	AACC-DELISTED	Stock	6.83	6.85	6.52	6.55	23916.0
2010-01-07	AACG	Stock	4.52	4.52	4.52	4.52	200.0
2010-01-07	AAI-DELISTED	Stock	5.04	5.22	5.04	5.1499	4729089.0
2010-01-07	AAIC-DELISTED	Stock	16.17	16.23	15.95	16.05	55414.0
2010-01-07	AAME	Stock	1.29	1.4	1.29	1.32	16400.0
2010-01-07	AAON	Stock	3.7274	3.8281	3.6998	3.8183	360450.0
2010-01-07	AAP	Stock	39.55	40.54	39.55	40.48	1256800.0
2010-01-07	AATI-DELISTED	Stock	3.79	3.85	3.73	3.81	210911.0
2010-01-07	AAU-DELISTED	Stock	1.29	1.32	1.2	1.24	399405.0
2010-01-07	AAUAF-DELISTED	Stock	1.29	1.32	1.2	1.24	418620.0
2010-01-07	AAV-DELISTED	Stock	7.24	7.3	7.06	7.1	553278.0
2010-01-07	AAWW-DELISTED	Stock	38.66	39.26	38.26	38.98	170149.0
2010-01-07	AAXJ	Stock	57.64	57.67	57.22	57.48	236242.0
2010-01-07	AAXN-DELISTED	Stock	5.74	6.05	5.46	5.66	4112618.0
2010-01-07	AB	Stock	28.47	28.76	28.2	28.4	385900.0
2010-01-07	ABAX-DELISTED	Stock	25.77	26.03	25.3	25.71	67042.0
2010-01-07	ABB-DELISTED	Stock	20.03	20.21	19.98	20.2	2156926.0
2010-01-07	ABBC-DELISTED	Stock	6.62	6.75	6.6	6.7	38864.0
2010-01-07	ABBNY-DELISTED	Stock	20.03	20.21	19.98	20.17	2158714.0
2010-01-07	ABC-DELISTED	Stock	25.77	26.16	25.66	25.76	5231892.0
2010-01-07	ABCB	Stock	7.5457	7.7334	7.4371	7.6939	12555.0
2010-01-07	ABCD-DELISTED	Stock	4.05	4.05	3.93	3.99	150239.0
2010-01-07	ABCO-DELISTED	Stock	15.983	16.097	15.928	15.992	140993.0
2010-01-07	ABCW-DELISTED	Stock	0.68	0.69	0.66	0.67	37790.0
2010-01-07	ABD-DELISTED	Stock	7.885	8.115	7.845	8.105	438220.0
2010-01-07	ABE-DELISTED	Stock	16.93	17.1	16.93	17.06	8114.0
2010-01-07	ABEO	Stock	3900.0	4062.5	3812.5	4062.5	33.0
2010-01-07	ABFS-DELISTED	Stock	28.3	28.82	27.38	27.81	626095.0
2010-01-07	ABG	Stock	12.83	13.18	12.62	13.05	306200.0
2010-01-07	ABII-DELISTED	Stock	42.0	42.19	41.14	41.52	25932.0
2010-01-07	ABK-DELISTED	Stock	0.814	0.88	0.8	0.83	23825282.0
2010-01-07	ABM	Stock	20.89	21.24	20.64	21.24	107100.0
2010-01-07	ABMD-DELISTED	Stock	8.63	8.82	8.3	8.4	566832.0
2010-01-07	ABR	Stock	2.2	2.34	2.13	2.25	340800.0
2010-01-07	ABT	Stock	26.0579	26.2834	25.9428	26.2786	12857232.0
2010-01-07	ABTL-DELISTED	Stock	4.802	4.802	4.0649	4.5	79512.0
2010-01-07	ABV-DELISTED	Stock	103.6	103.889	102.65	103.42	288512.0
2010-01-07	ABVA-DELISTED	Stock	3.0	3.0	3.0	3.0	100.0
2010-01-07	ABVT-DELISTED	Stock	65.73	66.69	65.09	65.31	73135.0
2010-01-07	ABX-DELISTED	Stock	41.69	41.69	40.89	41.18	9227023.0
2010-01-07	ACAD	Stock	1.31	1.37	1.31	1.37	441500.0

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

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