PREVIEW / stock_daily / 2010-04-07

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-07.parquet
  size:    192 KB
  rows:    5,946
  symbols: 3,517

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-04-07	AAPL	Stock	8.5554	8.64	8.5236	8.5929	628502000.0
2010-04-07	MSFT	Stock	29.16	29.56	29.14	29.35	58318800.0
2010-04-07	NVDA	Stock	0.4235	0.4362	0.42	0.429	817468000.0
2010-04-07	AMZN	Stock	6.798	6.804	6.693	6.7435	118908000.0
2010-04-07	TLT	Stock	87.45	88.92	87.3	88.73	6389806.0
2010-04-07	ES	Stock	28.14	28.19	27.76	27.92	1915400.0
2010-04-07	CL	Stock	42.4	42.675	42.25	42.555	4380000.0
2010-04-07	A	Stock	24.6567	24.7139	24.4134	24.5279	3269503.0
2010-04-07	AABA-DELISTED	Stock	16.78	16.92	16.76	16.87	19467843.0
2010-04-07	AACC-DELISTED	Stock	6.44	6.57	6.41	6.57	21797.0
2010-04-07	AACG	Stock	4.0	4.07	3.98	4.0	25600.0
2010-04-07	AAI-DELISTED	Stock	5.1	5.19	5.09	5.19	4090001.0
2010-04-07	AAIC-DELISTED	Stock	18.05	19.48	18.05	18.9648	62632.0
2010-04-07	AAON	Stock	4.482	4.5274	4.4425	4.4938	268312.0
2010-04-07	AAP	Stock	42.48	42.76	41.94	42.1	1947000.0
2010-04-07	AATI-DELISTED	Stock	3.73	3.8	3.69	3.76	178165.0
2010-04-07	AAU-DELISTED	Stock	1.24	1.25	1.05	1.13	977199.0
2010-04-07	AAUAF-DELISTED	Stock	1.2	1.21	1.01	1.13	1023170.0
2010-04-07	AAV-DELISTED	Stock	7.16	7.22	7.05	7.1	363339.0
2010-04-07	AAWW-DELISTED	Stock	51.6	51.88	51.15	51.72	391462.0
2010-04-07	AAXJ	Stock	58.86	58.86	58.1801	58.46	947412.0
2010-04-07	AAXN-DELISTED	Stock	5.51	5.72	5.5	5.54	1286055.0
2010-04-07	AB	Stock	32.3	32.78	31.91	32.06	380800.0
2010-04-07	ABAX-DELISTED	Stock	26.73	26.88	26.21	26.44	110263.0
2010-04-07	ABB-DELISTED	Stock	22.09	22.19	21.93	21.99	2601095.0
2010-04-07	ABBC-DELISTED	Stock	8.11	8.23	8.06	8.21	36882.0
2010-04-07	ABBNY-DELISTED	Stock	22.09	22.19	21.93	22.0	2606795.0
2010-04-07	ABC-DELISTED	Stock	28.92	29.07	28.77	29.05	3120281.0
2010-04-07	ABCB	Stock	9.455	9.6142	9.3654	9.6142	32353.0
2010-04-07	ABCD-DELISTED	Stock	4.73	4.73	4.58	4.62	10497.0
2010-04-07	ABCO-DELISTED	Stock	16.465	16.48	16.215	16.245	90062.0
2010-04-07	ABCW-DELISTED	Stock	0.8925	0.8925	0.8123	0.8875	130940.0
2010-04-07	ABD-DELISTED	Stock	8.08	8.08	7.79	7.93	176280.0
2010-04-07	ABE-DELISTED	Stock	17.42	17.42	17.29	17.3	8800.0
2010-04-07	ABEO	Stock	2875.0	2987.5	2850.0	2887.5	25.0
2010-04-07	ABFS-DELISTED	Stock	29.52	29.67	29.0	29.33	834997.0
2010-04-07	ABG	Stock	13.7	14.14	13.7	13.99	274700.0
2010-04-07	ABII-DELISTED	Stock	51.27	51.54	50.75	51.17	51301.0
2010-04-07	ABK-DELISTED	Stock	0.5792	0.62	0.56	0.61	17055481.0
2010-04-07	ABM	Stock	20.78	20.92	20.71	20.87	135100.0
2010-04-07	ABMD-DELISTED	Stock	9.88	10.11	9.53	9.64	279871.0
2010-04-07	ABR	Stock	3.92	4.03	3.9	4.0	402300.0
2010-04-07	ABT	Stock	25.2855	25.3958	25.1319	25.1895	20577115.0
2010-04-07	ABTL-DELISTED	Stock	5.0	5.25	4.7	4.75	45010.0
2010-04-07	ABV-DELISTED	Stock	93.94	93.94	92.32	92.67	450044.0
2010-04-07	ABVA-DELISTED	Stock	2.54	2.54	2.54	2.54	200.0
2010-04-07	ABVT-DELISTED	Stock	48.82	49.19	47.77	48.1	190068.0
2010-04-07	ABX-DELISTED	Stock	39.87	40.93	39.75	40.67	14349344.0
2010-04-07	ACAD	Stock	1.61	1.61	1.51	1.54	268700.0
2010-04-07	ACAP-DELISTED	Stock	32.19	32.89	32.19	32.46	59184.0

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

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