PREVIEW / stock_daily / 2010-04-09

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-09.parquet
  size:    192 KB
  rows:    5,952
  symbols: 3,512

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-09	AAPL	Stock	8.6225	8.6389	8.5879	8.6354	334182800.0
2010-04-09	MSFT	Stock	29.95	30.41	29.9	30.34	54752500.0
2010-04-09	NVDA	Stock	0.421	0.4262	0.4188	0.4248	817572000.0
2010-04-09	AMZN	Stock	7.036	7.0665	6.9535	7.003	120222000.0
2010-04-09	TLT	Stock	88.61	89.055	88.41	88.98	2311262.0
2010-04-09	ES	Stock	27.7	27.84	27.45	27.81	832800.0
2010-04-09	CL	Stock	42.275	42.375	42.005	42.135	5346000.0
2010-04-09	A	Stock	24.3491	24.485	24.2275	24.485	3908668.0
2010-04-09	AABA-DELISTED	Stock	17.42	18.07	17.245	17.53	46497470.0
2010-04-09	AACC-DELISTED	Stock	6.63	6.64	6.5	6.54	44954.0
2010-04-09	AACG	Stock	3.98	3.98	3.91	3.92	3800.0
2010-04-09	AAI-DELISTED	Stock	5.36	5.38	5.28	5.3	3414259.0
2010-04-09	AAIC-DELISTED	Stock	19.22	19.25	18.91	19.19	14197.0
2010-04-09	AAME	Stock	1.29	1.5	1.28	1.5	1400.0
2010-04-09	AAON	Stock	4.4464	4.482	4.3615	4.4681	192881.0
2010-04-09	AAP	Stock	42.34	42.38	41.84	42.13	1338400.0
2010-04-09	AATI-DELISTED	Stock	3.72	3.81	3.72	3.8	145369.0
2010-04-09	AAU-DELISTED	Stock	1.13	1.16	1.1	1.14	247340.0
2010-04-09	AAUAF-DELISTED	Stock	1.17	1.2	1.14	1.14	239067.0
2010-04-09	AAV-DELISTED	Stock	7.08	7.15	6.95	7.03	653914.0
2010-04-09	AAWW-DELISTED	Stock	52.84	55.03	52.84	54.29	381113.0
2010-04-09	AAXJ	Stock	58.88	58.95	58.58	58.86	558230.0
2010-04-09	AAXN-DELISTED	Stock	5.5	5.6	5.37	5.52	1307262.0
2010-04-09	AB	Stock	32.09	32.26	31.68	31.95	310800.0
2010-04-09	ABAX-DELISTED	Stock	26.06	26.28	25.5335	26.19	140072.0
2010-04-09	ABB-DELISTED	Stock	21.97	22.35	21.96	22.34	2895711.0
2010-04-09	ABBC-DELISTED	Stock	8.24	8.2699	8.15	8.17	33784.0
2010-04-09	ABBNY-DELISTED	Stock	21.97	22.35	21.96	22.33	2896821.0
2010-04-09	ABC-DELISTED	Stock	29.26	29.48	29.18	29.47	2016636.0
2010-04-09	ABCB	Stock	9.6839	9.8332	9.3654	9.7038	36473.0
2010-04-09	ABCD-DELISTED	Stock	4.85	5.14	4.81	5.09	48798.0
2010-04-09	ABCO-DELISTED	Stock	16.21	16.495	16.005	16.385	183708.0
2010-04-09	ABCW-DELISTED	Stock	0.8284	0.9583	0.8284	0.89	167790.0
2010-04-09	ABD-DELISTED	Stock	7.58	7.75	7.48	7.67	164640.0
2010-04-09	ABE-DELISTED	Stock	17.4	17.42	17.3	17.35	8087.0
2010-04-09	ABEO	Stock	3062.5	3125.0	3000.0	3125.0	10.0
2010-04-09	ABFS-DELISTED	Stock	30.06	30.15	29.68	30.01	422803.0
2010-04-09	ABG	Stock	13.57	13.75	13.48	13.59	205700.0
2010-04-09	ABII-DELISTED	Stock	50.94	50.9785	49.6	50.25	211810.0
2010-04-09	ABK-DELISTED	Stock	1.08	1.19	1.02	1.1	196820690.0
2010-04-09	ABM	Stock	20.68	20.85	20.26	20.81	174200.0
2010-04-09	ABMD-DELISTED	Stock	9.5	9.64	9.25	9.32	150076.0
2010-04-09	ABR	Stock	4.26	4.78	4.03	4.4	853800.0
2010-04-09	ABT	Stock	25.1175	25.3574	25.0839	25.2999	11637557.0
2010-04-09	ABTL-DELISTED	Stock	4.8	5.0	4.8	4.9	3269.0
2010-04-09	ABV-DELISTED	Stock	93.74	94.58	93.01	94.44	507778.0
2010-04-09	ABVT-DELISTED	Stock	48.5	49.18	48.12	48.98	230102.0
2010-04-09	ABX-DELISTED	Stock	41.21	41.85	40.87	41.3	9259616.0
2010-04-09	ACAD	Stock	1.55	1.55	1.49	1.53	223900.0
2010-04-09	ACAP-DELISTED	Stock	32.93	33.26	32.36	32.72	20484.0

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

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