PREVIEW / stock_daily / 2010-04-20

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-20.parquet
  size:    192 KB
  rows:    5,966
  symbols: 3,519

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-20	AAPL	Stock	8.8764	8.9018	8.6771	8.7354	738326400.0
2010-04-20	MSFT	Stock	31.22	31.44	31.13	31.36	52199500.0
2010-04-20	NVDA	Stock	0.4275	0.432	0.4205	0.426	678188000.0
2010-04-20	AMZN	Stock	7.1915	7.232	7.105	7.21	86234000.0
2010-04-20	TLT	Stock	89.85	89.99	89.6445	89.96	2284968.0
2010-04-20	ES	Stock	27.62	27.63	27.48	27.58	877500.0
2010-04-20	CL	Stock	42.165	42.33	41.91	42.27	3439600.0
2010-04-20	A	Stock	25.3076	26.0873	25.3076	25.9585	6989860.0
2010-04-20	AABA-DELISTED	Stock	18.5	18.55	18.225	18.42	38648693.0
2010-04-20	AACC-DELISTED	Stock	6.73	6.94	6.73	6.94	4391.0
2010-04-20	AAI-DELISTED	Stock	5.83	5.9	5.59	5.79	4951995.0
2010-04-20	AAIC-DELISTED	Stock	20.33	20.34	19.96	20.23	36366.0
2010-04-20	AAME	Stock	1.44	1.49	1.42	1.49	6700.0
2010-04-20	AAON	Stock	4.6854	4.6874	4.5867	4.6874	278437.0
2010-04-20	AAP	Stock	44.64	44.86	44.27	44.46	1169500.0
2010-04-20	AATI-DELISTED	Stock	3.99	4.08	3.97	4.04	214517.0
2010-04-20	AAU-DELISTED	Stock	1.02	1.11	1.02	1.0801	123358.0
2010-04-20	AAUAF-DELISTED	Stock	1.02	1.11	1.02	1.0801	125758.0
2010-04-20	AAV-DELISTED	Stock	6.99	7.29	6.96	7.27	707520.0
2010-04-20	AAWW-DELISTED	Stock	56.51	56.6	54.2	54.99	230357.0
2010-04-20	AAXJ	Stock	58.04	58.07	57.63	58.07	131256.0
2010-04-20	AAXN-DELISTED	Stock	5.35	5.43	5.31	5.39	970143.0
2010-04-20	AB	Stock	33.23	33.57	32.74	33.53	495100.0
2010-04-20	ABAX-DELISTED	Stock	26.78	26.92	26.18	26.58	138172.0
2010-04-20	ABB-DELISTED	Stock	22.54	22.58	22.32	22.44	1800966.0
2010-04-20	ABBC-DELISTED	Stock	8.09	8.44	8.07	8.44	55556.0
2010-04-20	ABBNY-DELISTED	Stock	22.54	22.58	22.32	22.46	1925944.0
2010-04-20	ABC-DELISTED	Stock	29.97	30.49	29.88	30.38	4155281.0
2010-04-20	ABCB	Stock	10.5896	10.6991	10.4801	10.6692	182867.0
2010-04-20	ABCD-DELISTED	Stock	5.1	5.24	5.0901	5.16	45759.0
2010-04-20	ABCO-DELISTED	Stock	16.69	17.165	16.675	17.15	74886.0
2010-04-20	ABCW-DELISTED	Stock	1.0504	1.07	1.0307	1.07	90610.0
2010-04-20	ABD-DELISTED	Stock	7.72	7.92	7.68	7.91	358430.0
2010-04-20	ABE-DELISTED	Stock	16.95	17.0901	16.95	17.05	13108.0
2010-04-20	ABEO	Stock	3562.5	3562.5	3250.0	3362.5	27.0
2010-04-20	ABFS-DELISTED	Stock	32.39	32.56	29.78	30.6	2292089.0
2010-04-20	ABG	Stock	13.57	13.72	13.47	13.59	90500.0
2010-04-20	ABII-DELISTED	Stock	51.81	53.0	51.1	51.31	114054.0
2010-04-20	ABK-DELISTED	Stock	2.12	2.13	1.95	2.13	104846390.0
2010-04-20	ABM	Stock	21.48	21.64	21.4	21.59	142300.0
2010-04-20	ABMD-DELISTED	Stock	9.32	9.6	9.32	9.6	187529.0
2010-04-20	ABR	Stock	3.7	4.0	3.64	3.91	204000.0
2010-04-20	ABT	Stock	25.4438	25.5494	25.391	25.4582	13302001.0
2010-04-20	ABTL-DELISTED	Stock	4.85	4.95	4.7	4.85	9680.0
2010-04-20	ABV-DELISTED	Stock	97.4	98.5	97.15	97.6	272329.0
2010-04-20	ABVA-DELISTED	Stock	3.0	3.185	2.93	3.04	6900.0
2010-04-20	ABVT-DELISTED	Stock	53.1	53.65	52.31	52.74	102417.0
2010-04-20	ABX-DELISTED	Stock	39.7	39.84	39.11	39.13	5695098.0
2010-04-20	ACAD	Stock	1.67	1.73	1.63	1.72	350100.0
2010-04-20	ACAP-DELISTED	Stock	32.5	32.78	32.26	32.52	27673.0

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

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