PREVIEW / stock_daily / 2010-09-15

all stock daily files

  file:    by_date/stock_daily/2010/2010-09-15.parquet
  size:    190 KB
  rows:    5,946
  symbols: 3,475

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-09-15	AAPL	Stock	9.5775	9.6564	9.5657	9.6507	429368800.0
2010-09-15	MSFT	Stock	25.1	25.22	24.92	25.12	56201900.0
2010-09-15	NVDA	Stock	0.261	0.2643	0.2575	0.264	555572000.0
2010-09-15	AMZN	Stock	7.244	7.281	7.178	7.2725	98072000.0
2010-09-15	TSLA	Stock	1.3987	1.4667	1.386	1.4653	10269000.0
2010-09-15	TLT	Stock	102.75	103.26	102.14	102.27	7925069.0
2010-09-15	ES	Stock	29.95	29.95	29.53	29.61	1450400.0
2010-09-15	CL	Stock	37.72	38.275	37.565	38.135	5240800.0
2010-09-15	A	Stock	20.8512	21.1803	20.5651	21.0372	5233972.0
2010-09-15	AABA-DELISTED	Stock	14.05	14.35	13.77	14.29	89885494.0
2010-09-15	AACC-DELISTED	Stock	3.72	3.72	3.63	3.69	7658.0
2010-09-15	AACG	Stock	2.91	2.98	2.81	2.81	38800.0
2010-09-15	AAI-DELISTED	Stock	4.39	4.5	4.38	4.47	1253750.0
2010-09-15	AAIC-DELISTED	Stock	22.15	22.47	21.87	22.41	13473.0
2010-09-15	AAME	Stock	1.51	1.55	1.51	1.55	10800.0
2010-09-15	AAON	Stock	4.6044	4.6716	4.5491	4.644	235406.0
2010-09-15	AAP	Stock	57.32	57.45	56.66	57.41	672000.0
2010-09-15	AATI-DELISTED	Stock	3.39	3.44	3.35	3.39	55323.0
2010-09-15	AAU-DELISTED	Stock	2.54	2.62	2.5	2.52	450806.0
2010-09-15	AAUAF-DELISTED	Stock	2.54	2.62	2.5	2.52	450706.0
2010-09-15	AAV-DELISTED	Stock	6.23	6.43	6.22	6.42	267030.0
2010-09-15	AAWW-DELISTED	Stock	47.01	48.5	46.76	48.25	186984.0
2010-09-15	AAXJ	Stock	58.27	58.5	58.02	58.42	446595.0
2010-09-15	AAXN-DELISTED	Stock	3.97	4.01	3.89	3.93	185130.0
2010-09-15	AB	Stock	26.28	26.28	25.83	25.99	282100.0
2010-09-15	ABAC-DELISTED	Stock	4.0	4.1	4.0	4.0	11800.0
2010-09-15	ABAX-DELISTED	Stock	19.91	20.41	19.75	20.31	59791.0
2010-09-15	ABB-DELISTED	Stock	20.47	20.6	20.44	20.57	1169893.0
2010-09-15	ABBC-DELISTED	Stock	10.34	10.46	10.34	10.43	16191.0
2010-09-15	ABBNY-DELISTED	Stock	20.47	20.6	20.44	20.59	1182596.0
2010-09-15	ABC-DELISTED	Stock	29.04	30.57	28.95	30.23	5552139.0
2010-09-15	ABCB	Stock	8.6	8.76	8.51	8.73	40000.0
2010-09-15	ABCD-DELISTED	Stock	3.12	3.19	3.12	3.16	23659.0
2010-09-15	ABCO-DELISTED	Stock	21.52	21.87	21.5	21.79	73398.0
2010-09-15	ABCW-DELISTED	Stock	0.7	0.72	0.68	0.68	70120.0
2010-09-15	ABD-DELISTED	Stock	6.45	6.45	5.84	5.98	2041660.0
2010-09-15	ABE-DELISTED	Stock	17.75	17.81	17.7	17.77	8550.0
2010-09-15	ABEO	Stock	2562.5	2625.0	2400.0	2437.5	30.0
2010-09-15	ABFS-DELISTED	Stock	23.21	23.95	22.84	23.74	249076.0
2010-09-15	ABG	Stock	12.64	12.92	12.52	12.8	319800.0
2010-09-15	ABII-DELISTED	Stock	74.53	75.27	74.52	75.25	25294.0
2010-09-15	ABK-DELISTED	Stock	0.5474	0.6	0.5417	0.5771	11091986.0
2010-09-15	ABM	Stock	21.81	22.0	21.54	21.9	188900.0
2010-09-15	ABMD-DELISTED	Stock	10.06	10.2	9.84	10.04	65576.0
2010-09-15	ABR	Stock	4.49	4.79	4.44	4.75	102100.0
2010-09-15	ABT	Stock	24.6425	24.8296	24.5418	24.7865	9559608.0
2010-09-15	ABTL-DELISTED	Stock	4.2025	4.2537	4.1	4.1	14169.0
2010-09-15	ABV-DELISTED	Stock	117.13	120.31	117.13	120.15	483859.0
2010-09-15	ABVA-DELISTED	Stock	2.92	2.92	2.74	2.75	4716.0
2010-09-15	ABVT-DELISTED	Stock	51.96	52.49	51.56	52.42	64557.0

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

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