PREVIEW / stock_daily / 2010-06-09

all stock daily files

  file:    by_date/stock_daily/2010/2010-06-09.parquet
  size:    188 KB
  rows:    5,907
  symbols: 3,481

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-06-09	AAPL	Stock	8.9811	8.9964	8.6604	8.6857	854630000.0
2010-06-09	MSFT	Stock	25.22	25.52	24.75	24.79	87794000.0
2010-06-09	NVDA	Stock	0.281	0.2885	0.2718	0.2728	697152000.0
2010-06-09	AMZN	Stock	6.0155	6.0735	5.868	5.8955	147384000.0
2010-06-09	TLT	Stock	97.6	98.12	97.21	97.94	5598095.0
2010-06-09	ES	Stock	25.59	25.71	25.18	25.28	1220000.0
2010-06-09	CL	Stock	39.415	39.605	39.205	39.36	5436600.0
2010-06-09	A	Stock	21.4449	21.7954	21.03	21.1159	6052082.0
2010-06-09	AABA-DELISTED	Stock	14.93	15.06	14.65	14.66	18098769.0
2010-06-09	AACC-DELISTED	Stock	4.9	4.9	4.51	4.6	19418.0
2010-06-09	AAI-DELISTED	Stock	5.66	5.73	5.51	5.56	3419302.0
2010-06-09	AAIC-DELISTED	Stock	19.03	19.2	18.668	18.668	15008.0
2010-06-09	AAON	Stock	4.5788	4.7368	4.5669	4.5985	305269.0
2010-06-09	AAP	Stock	49.73	50.57	49.49	49.69	2053300.0
2010-06-09	AATI-DELISTED	Stock	3.38	3.47	3.33	3.34	234744.0
2010-06-09	AAU-DELISTED	Stock	1.03	1.03	0.9622	0.9835	95675.0
2010-06-09	AAUAF-DELISTED	Stock	1.03	1.03	0.9622	0.9835	96175.0
2010-06-09	AAV-DELISTED	Stock	6.17	6.23	5.88	5.93	468347.0
2010-06-09	AAWW-DELISTED	Stock	48.25	50.12	47.44	47.75	181858.0
2010-06-09	AAXJ	Stock	52.88	52.88	51.06	51.34	226271.0
2010-06-09	AAXN-DELISTED	Stock	4.15	4.2	4.1	4.12	565525.0
2010-06-09	AB	Stock	27.8	28.06	27.2	27.31	398700.0
2010-06-09	ABAX-DELISTED	Stock	20.8	22.14	20.74	21.7	223757.0
2010-06-09	ABB-DELISTED	Stock	16.98	17.19	16.7	16.78	3200243.0
2010-06-09	ABBC-DELISTED	Stock	8.7	8.77	8.62	8.63	37838.0
2010-06-09	ABBNY-DELISTED	Stock	16.98	17.19	16.7	16.8	3241355.0
2010-06-09	ABC-DELISTED	Stock	30.78	31.56	30.75	30.96	3992331.0
2010-06-09	ABCB	Stock	10.4104	10.6194	10.0322	10.1318	79778.0
2010-06-09	ABCD-DELISTED	Stock	4.52	4.56	4.4	4.41	7539.0
2010-06-09	ABCO-DELISTED	Stock	19.505	19.505	19.1	19.27	98734.0
2010-06-09	ABCW-DELISTED	Stock	0.76	0.79	0.74	0.77	19820.0
2010-06-09	ABD-DELISTED	Stock	5.93	5.93	5.57	5.62	407210.0
2010-06-09	ABE-DELISTED	Stock	15.33	15.52	15.3	15.34	31495.0
2010-06-09	ABEO	Stock	2987.5	2987.5	2787.5	2875.0	26.0
2010-06-09	ABFS-DELISTED	Stock	21.18	21.71	20.76	20.84	466377.0
2010-06-09	ABG	Stock	11.81	12.17	11.54	11.96	410400.0
2010-06-09	ABII-DELISTED	Stock	54.33	56.94	53.7	56.45	98843.0
2010-06-09	ABK-DELISTED	Stock	0.88	0.93	0.62	0.65	89970608.0
2010-06-09	ABM	Stock	20.38	20.57	20.17	20.36	320400.0
2010-06-09	ABMD-DELISTED	Stock	9.66	9.72	9.17	9.38	349680.0
2010-06-09	ABR	Stock	4.14	4.25	4.13	4.14	115400.0
2010-06-09	ABT	Stock	22.2579	22.3347	21.9413	22.0036	18267612.0
2010-06-09	ABTL-DELISTED	Stock	5.8005	5.9	5.65	5.7995	21996.0
2010-06-09	ABV-DELISTED	Stock	97.79	99.1	97.01	97.34	854653.0
2010-06-09	ABVT-DELISTED	Stock	42.99	44.62	42.86	43.72	235843.0
2010-06-09	ABX-DELISTED	Stock	43.15	43.53	42.43	42.68	9043750.0
2010-06-09	ACAD	Stock	1.21	1.3	1.16	1.18	303500.0
2010-06-09	ACAP-DELISTED	Stock	29.78	29.78	29.5	29.64	40334.0
2010-06-09	ACAS-DELISTED	Stock	4.54	5.01	4.52	4.75	19133642.0
2010-06-09	ACAT-DELISTED	Stock	9.39	9.77	9.04	9.36	107256.0

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

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