PREVIEW / stock_daily / 2010-05-06

all stock daily files

  file:    by_date/stock_daily/2010/2010-05-06.parquet
  size:    192 KB
  rows:    5,977
  symbols: 3,523

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-05-06	AAPL	Stock	9.0654	9.2232	7.1161	8.7946	1285860800.0
2010-05-06	MSFT	Stock	29.59	29.88	27.91	28.98	128613000.0
2010-05-06	NVDA	Stock	0.36	0.3675	0.326	0.355	1002888000.0
2010-05-06	AMZN	Stock	6.5	6.6165	6.03	6.4355	203780000.0
2010-05-06	TLT	Stock	94.16	100.0	93.78	96.79	19579051.0
2010-05-06	ES	Stock	26.98	26.98	25.0	26.0	2291400.0
2010-05-06	CL	Stock	41.365	41.755	39.75	40.885	9461800.0
2010-05-06	A	Stock	24.6924	24.907	21.9313	23.8054	9026606.0
2010-05-06	AABA-DELISTED	Stock	16.34	16.51	15.43	15.92	31816314.0
2010-05-06	AACC-DELISTED	Stock	7.36	8.16	7.05	7.17	30298.0
2010-05-06	AACG	Stock	3.52	3.58	3.5	3.53	14100.0
2010-05-06	AAI-DELISTED	Stock	5.18	5.28	4.82	5.03	6910524.0
2010-05-06	AAIC-DELISTED	Stock	20.57	20.57	18.39	19.25	81193.0
2010-05-06	AAME	Stock	1.65	1.65	1.62	1.62	5900.0
2010-05-06	AAON	Stock	4.4286	4.5096	4.2489	4.3536	642431.0
2010-05-06	AAP	Stock	44.87	45.1	42.19	44.2	1738900.0
2010-05-06	AATI-DELISTED	Stock	3.76	3.76	3.43	3.55	315235.0
2010-05-06	AAU-DELISTED	Stock	1.11	1.12	1.05	1.1	156610.0
2010-05-06	AAUAF-DELISTED	Stock	1.11	1.12	1.05	1.1	155610.0
2010-05-06	AAV-DELISTED	Stock	6.55	6.6501	5.85	6.16	1084892.0
2010-05-06	AAWW-DELISTED	Stock	54.8	55.06	48.76	52.79	1056396.0
2010-05-06	AAXJ	Stock	54.17	57.43	22.0	52.43	1064795.0
2010-05-06	AAXN-DELISTED	Stock	4.72	4.78	4.48	4.61	2550274.0
2010-05-06	AB	Stock	30.62	31.08	23.0	29.21	1082600.0
2010-05-06	ABAX-DELISTED	Stock	25.02	25.45	22.65	24.11	107189.0
2010-05-06	ABB-DELISTED	Stock	18.38	18.59	16.8	17.69	7236039.0
2010-05-06	ABBC-DELISTED	Stock	9.76	9.92	9.25	9.8	103686.0
2010-05-06	ABBNY-DELISTED	Stock	18.38	18.59	16.8	17.7	7278851.0
2010-05-06	ABC-DELISTED	Stock	30.87	31.43	28.95	30.71	6033623.0
2010-05-06	ABCB	Stock	10.5796	10.9379	9.9526	10.5299	163173.0
2010-05-06	ABCD-DELISTED	Stock	4.95	5.0925	4.85	5.01	20978.0
2010-05-06	ABCO-DELISTED	Stock	18.041	21.19	18.041	18.704	1067204.0
2010-05-06	ABCW-DELISTED	Stock	1.0	1.0	0.93	1.0	243890.0
2010-05-06	ABD-DELISTED	Stock	8.05	8.53	6.9	7.69	352220.0
2010-05-06	ABE-DELISTED	Stock	15.9	16.14	15.15	15.51	37054.0
2010-05-06	ABEO	Stock	3075.0	3125.0	2850.0	2987.5	34.0
2010-05-06	ABFS-DELISTED	Stock	28.62	28.98	26.44	27.93	898007.0
2010-05-06	ABG	Stock	14.55	14.8	12.52	13.87	499700.0
2010-05-06	ABII-DELISTED	Stock	48.63	49.11	45.0	47.47	75597.0
2010-05-06	ABK-DELISTED	Stock	1.48	1.55	1.31	1.38	33072978.0
2010-05-06	ABM	Stock	21.65	21.81	20.9	21.18	533500.0
2010-05-06	ABMD-DELISTED	Stock	8.93	9.28	8.79	8.92	291746.0
2010-05-06	ABR	Stock	4.04	4.04	3.36	3.83	559900.0
2010-05-06	ABT	Stock	24.0572	24.1723	21.8789	23.5102	26043351.0
2010-05-06	ABTL-DELISTED	Stock	5.3592	6.2082	4.2507	5.2	454018.0
2010-05-06	ABV-DELISTED	Stock	94.75	95.91	89.12	93.07	1217769.0
2010-05-06	ABVA-DELISTED	Stock	3.0899	3.09	2.84	2.85	3200.0
2010-05-06	ABVT-DELISTED	Stock	48.49	52.62	47.9801	51.72	964424.0
2010-05-06	ABX-DELISTED	Stock	42.73	44.33	42.53	43.7	21954970.0
2010-05-06	ACAD	Stock	1.59	1.59	1.35	1.48	469800.0

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

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