PREVIEW / stock_daily / 2010-04-15

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-15.parquet
  size:    193 KB
  rows:    5,964
  symbols: 3,525

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-15	AAPL	Stock	8.7779	8.8939	8.7682	8.89	376784800.0
2010-04-15	MSFT	Stock	30.82	30.95	30.71	30.87	52745400.0
2010-04-15	NVDA	Stock	0.4485	0.453	0.444	0.4502	957596000.0
2010-04-15	AMZN	Stock	7.2275	7.3545	7.2	7.291	156592000.0
2010-04-15	TLT	Stock	88.85	89.5	88.68	89.21	3697982.0
2010-04-15	ES	Stock	27.67	27.97	27.65	27.89	843700.0
2010-04-15	CL	Stock	42.275	42.28	41.76	42.125	5188400.0
2010-04-15	A	Stock	24.6423	25.6867	24.4778	25.4864	12788624.0
2010-04-15	AABA-DELISTED	Stock	18.3	19.12	18.25	18.96	58536314.0
2010-04-15	AACC-DELISTED	Stock	6.8	6.86	6.66	6.8	27949.0
2010-04-15	AACG	Stock	3.59	3.61	3.52	3.59	4700.0
2010-04-15	AAI-DELISTED	Stock	5.91	6.02	5.82	5.9499	11393059.0
2010-04-15	AAIC-DELISTED	Stock	20.5	20.5	20.27	20.39	39110.0
2010-04-15	AAME	Stock	1.5	1.5	1.5	1.5	2100.0
2010-04-15	AAON	Stock	4.6341	4.6894	4.6301	4.6578	204019.0
2010-04-15	AAP	Stock	45.61	46.34	45.33	45.38	3249700.0
2010-04-15	AATI-DELISTED	Stock	4.02	4.1	3.96	4.04	268759.0
2010-04-15	AAU-DELISTED	Stock	1.1	1.12	1.08	1.1	119454.0
2010-04-15	AAUAF-DELISTED	Stock	1.1	1.12	1.08	1.1	122754.0
2010-04-15	AAV-DELISTED	Stock	7.17	7.23	6.99	7.1	381658.0
2010-04-15	AAWW-DELISTED	Stock	58.38	59.075	57.89	58.84	304333.0
2010-04-15	AAXJ	Stock	59.15	59.26	58.9	59.0	1403785.0
2010-04-15	AAXN-DELISTED	Stock	5.44	5.46	5.27	5.35	706141.0
2010-04-15	AB	Stock	33.86	34.0	33.07	33.24	383600.0
2010-04-15	ABAX-DELISTED	Stock	26.95	27.27	26.92	26.97	129919.0
2010-04-15	ABB-DELISTED	Stock	22.4	22.61	22.371	22.53	2278119.0
2010-04-15	ABBC-DELISTED	Stock	8.37	8.44	8.3495	8.41	26076.0
2010-04-15	ABBNY-DELISTED	Stock	22.4	22.61	22.371	22.51	2337200.0
2010-04-15	ABC-DELISTED	Stock	29.19	29.5	29.09	29.5	2215029.0
2010-04-15	ABCB	Stock	10.4204	10.6791	10.2014	10.3706	2749732.0
2010-04-15	ABCD-DELISTED	Stock	5.03	5.1	4.9269	5.1	57752.0
2010-04-15	ABCO-DELISTED	Stock	16.645	16.85	16.63	16.81	20416.0
2010-04-15	ABCW-DELISTED	Stock	1.1	1.1	1.05	1.06	124860.0
2010-04-15	ABD-DELISTED	Stock	7.86	7.98	7.69	7.73	191460.0
2010-04-15	ABE-DELISTED	Stock	17.39	17.41	17.01	17.33	7288.0
2010-04-15	ABEO	Stock	3137.5	3500.0	3125.0	3437.5	42.0
2010-04-15	ABFS-DELISTED	Stock	30.65	31.17	30.01	30.11	741168.0
2010-04-15	ABG	Stock	13.88	14.05	13.71	14.03	242900.0
2010-04-15	ABII-DELISTED	Stock	51.25	51.64	50.89	50.9	51802.0
2010-04-15	ABK-DELISTED	Stock	2.03	2.03	1.78	1.83	87575031.0
2010-04-15	ABM	Stock	21.33	21.59	21.31	21.5	121400.0
2010-04-15	ABMD-DELISTED	Stock	9.6	9.7	9.46	9.5	110249.0
2010-04-15	ABR	Stock	4.14	4.2	4.06	4.11	126500.0
2010-04-15	ABT	Stock	25.0983	25.1655	24.9832	25.1223	15013756.0
2010-04-15	ABTL-DELISTED	Stock	4.85	5.1	4.803	5.0	4719.0
2010-04-15	ABV-DELISTED	Stock	97.42	99.96	97.34	99.19	495212.0
2010-04-15	ABVA-DELISTED	Stock	2.84	2.84	2.5565	2.59	10200.0
2010-04-15	ABVT-DELISTED	Stock	53.2	54.59	53.0	53.13	406430.0
2010-04-15	ABX-DELISTED	Stock	40.49	40.8601	39.94	39.97	8796619.0
2010-04-15	ACAD	Stock	1.77	1.8	1.64	1.77	952700.0

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

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