PREVIEW / stock_daily / 2011-10-03

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-03.parquet
  size:    194 KB
  rows:    6,117
  symbols: 3,548

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
2011-10-03	AAPL	Stock	13.5846	13.6657	13.3275	13.3786	669099200.0
2011-10-03	MSFT	Stock	24.72	25.34	24.52	24.53	64592500.0
2011-10-03	NVDA	Stock	0.3088	0.3185	0.2952	0.2952	949896000.0
2011-10-03	AMZN	Stock	10.8505	11.08	10.5695	10.599	132488000.0
2011-10-03	TSLA	Stock	1.6633	1.6667	1.55	1.582	15348000.0
2011-10-03	TLT	Stock	121.88	123.81	121.1142	123.81	15882645.0
2011-10-03	ES	Stock	33.64	33.8	32.06	32.06	3653000.0
2011-10-03	CL	Stock	44.18	44.92	44.115	44.15	5884400.0
2011-10-03	A	Stock	22.103	22.2031	21.0157	21.03	7265266.0
2011-10-03	AABA-DELISTED	Stock	13.69	14.04	13.37	13.53	42666526.0
2011-10-03	AACC-DELISTED	Stock	3.14	3.42	2.98	3.08	12799.0
2011-10-03	AACG	Stock	8.88	8.9	8.48	8.55	10700.0
2011-10-03	AAIC-DELISTED	Stock	24.0	24.22	21.09	21.8	184192.0
2011-10-03	AAME	Stock	1.82	1.9	1.5	1.88	11500.0
2011-10-03	AAON	Stock	4.6104	4.8415	4.48	4.483	312863.0
2011-10-03	AAP	Stock	57.84	58.52	56.27	56.3	675300.0
2011-10-03	AAT	Stock	17.93	17.94	16.47	16.96	237800.0
2011-10-03	AATI-DELISTED	Stock	4.29	4.45	4.21	4.21	625383.0
2011-10-03	AAU-DELISTED	Stock	2.613	2.734	2.38	2.4	274479.0
2011-10-03	AAUAF-DELISTED	Stock	2.58	2.7	2.35	2.4	278325.0
2011-10-03	AAV-DELISTED	Stock	3.71	4.07	3.71	3.74	1110307.0
2011-10-03	AAWW-DELISTED	Stock	33.01	34.05	30.86	30.9	313623.0
2011-10-03	AAXJ	Stock	46.22	46.86	45.29	45.36	505178.0
2011-10-03	AAXN-DELISTED	Stock	4.27	4.45	4.21	4.21	405402.0
2011-10-03	AB	Stock	13.62	13.79	13.12	13.14	315800.0
2011-10-03	ABAC-DELISTED	Stock	1.37	1.49	1.35	1.41	18500.0
2011-10-03	ABAX-DELISTED	Stock	22.65	23.59	22.14	22.15	214144.0
2011-10-03	ABB-DELISTED	Stock	16.9	17.2	16.42	16.44	2344598.0
2011-10-03	ABBNY-DELISTED	Stock	16.9	17.2	16.42	16.42	2347598.0
2011-10-03	ABC-DELISTED	Stock	37.01	37.59	35.72	35.73	5352707.0
2011-10-03	ABCB	Stock	8.62	9.07	8.53	8.55	113400.0
2011-10-03	ABCD-DELISTED	Stock	2.99	3.0199	2.87	2.87	54330.0
2011-10-03	ABCO-DELISTED	Stock	32.1	32.34	29.33	29.36	417036.0
2011-10-03	ABCW-DELISTED	Stock	0.55	0.55	0.49	0.53	29650.0
2011-10-03	ABD-DELISTED	Stock	4.6898	4.9292	4.4503	4.4702	499880.0
2011-10-03	ABE-DELISTED	Stock	16.79	17.25	16.41	16.53	8703.0
2011-10-03	ABEO	Stock	2325.0	2475.0	2187.5	2375.0	10.0
2011-10-03	ABFS-DELISTED	Stock	15.99	16.28	15.01	15.03	410853.0
2011-10-03	ABG	Stock	16.4	16.68	15.49	15.52	502400.0
2011-10-03	ABH-DELISTED	Stock	14.91	15.01	13.99	14.05	819182.0
2011-10-03	ABM	Stock	18.89	19.36	17.84	17.85	359000.0
2011-10-03	ABMD-DELISTED	Stock	10.9	11.06	10.01	10.09	234334.0
2011-10-03	ABR	Stock	3.71	3.71	3.51	3.51	346200.0
2011-10-03	ABT	Stock	24.417	24.8105	24.0428	24.062	23510838.0
2011-10-03	ABTL-DELISTED	Stock	4.1	4.1885	3.875	4.0	14579.0
2011-10-03	ABUS	Stock	1.71	1.79	1.7	1.75	1700.0
2011-10-03	ABV-DELISTED	Stock	30.25	30.57	29.74	29.9	4246777.0
2011-10-03	ABVT-DELISTED	Stock	52.9	53.59	51.52	51.68	276732.0
2011-10-03	ABX-DELISTED	Stock	47.24	47.63	46.17	46.19	6835508.0
2011-10-03	ACAD	Stock	1.07	1.08	0.91	0.92	390100.0

> showing 50 of 6,117 rows — these rows as CSV

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