PREVIEW / stock_daily / 2012-11-05

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-05.parquet
  size:    200 KB
  rows:    6,172
  symbols: 3,484

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
2012-11-05	AAPL	Stock	20.84	20.9918	20.6286	20.8793	529135600.0
2012-11-05	MSFT	Stock	29.62	29.74	29.33	29.63	38070800.0
2012-11-05	NVDA	Stock	0.3115	0.3268	0.3115	0.3255	444840000.0
2012-11-05	AMZN	Stock	11.602	11.7415	11.5055	11.7165	36922000.0
2012-11-05	META	Stock	21.1	21.48	20.92	21.25	31806700.0
2012-11-05	TSLA	Stock	1.9867	2.1053	1.9553	2.1	30733500.0
2012-11-05	TLT	Stock	122.82	123.25	122.79	122.95	2935974.0
2012-11-05	ES	Stock	39.32	39.32	38.75	39.03	1269700.0
2012-11-05	CL	Stock	52.27	52.875	52.27	52.615	1935800.0
2012-11-05	A	Stock	26.4664	26.9742	26.3591	26.9027	3789419.0
2012-11-05	AABA-DELISTED	Stock	17.12	17.43	17.01	17.37	31483154.0
2012-11-05	AACC-DELISTED	Stock	6.33	6.54	6.09	6.22	26967.0
2012-11-05	AACG	Stock	4.61	4.99	4.61	4.85	2100.0
2012-11-05	AAIC-DELISTED	Stock	22.21	22.35	21.88	21.98	110638.0
2012-11-05	AAME	Stock	2.91	2.93	2.76	2.92	1400.0
2012-11-05	AAMRQ-DELISTED	Stock	0.3761	0.394	0.3761	0.38	764226.0
2012-11-05	AAON	Stock	6.0119	6.2193	6.0119	6.0948	83025.0
2012-11-05	AAP	Stock	80.1	81.06	79.27	80.79	906800.0
2012-11-05	AAT	Stock	27.15	27.33	26.86	27.03	166600.0
2012-11-05	AAU-DELISTED	Stock	2.56	2.599	2.5	2.53	42889.0
2012-11-05	AAUAF-DELISTED	Stock	2.57	2.609	2.51	2.52	43171.0
2012-11-05	AAV-DELISTED	Stock	3.58	3.58	3.51	3.56	84729.0
2012-11-05	AAWW-DELISTED	Stock	44.61	45.17	43.54	43.8	363346.0
2012-11-05	AAXJ	Stock	57.08	57.34	56.79	57.29	226591.0
2012-11-05	AAXN-DELISTED	Stock	7.87	8.21	7.64	8.135	881080.0
2012-11-05	AB	Stock	16.53	16.67	16.35	16.56	188600.0
2012-11-05	ABAC-DELISTED	Stock	1.18	1.26	1.1717	1.2432	8169.0
2012-11-05	ABAX-DELISTED	Stock	37.11	38.195	36.6	37.35	157245.0
2012-11-05	ABB-DELISTED	Stock	18.16	18.26	18.1	18.23	1217929.0
2012-11-05	ABBNY-DELISTED	Stock	18.16	18.26	18.1	18.24	1265249.0
2012-11-05	ABC-DELISTED	Stock	40.28	40.58	40.12	40.27	1586554.0
2012-11-05	ABCB	Stock	10.77	10.98	10.68	10.98	29500.0
2012-11-05	ABCD-DELISTED	Stock	0.81	0.85	0.8	0.84	25612.0
2012-11-05	ABCO-DELISTED	Stock	49.04	49.3	48.22	48.75	180827.0
2012-11-05	ABCW-DELISTED	Stock	0.36	0.395	0.36	0.36	3396.0
2012-11-05	ABE-DELISTED	Stock	20.71	20.76	20.66	20.76	6588.0
2012-11-05	ABEO	Stock	437.5	437.5	387.5	387.5	3.0
2012-11-05	ABFS-DELISTED	Stock	8.25	8.4	8.06	8.2	250487.0
2012-11-05	ABG	Stock	31.05	31.42	30.88	31.27	271400.0
2012-11-05	ABM	Stock	19.66	19.71	19.2	19.29	310200.0
2012-11-05	ABMD-DELISTED	Stock	13.92	13.92	12.98	13.48	1433268.0
2012-11-05	ABR	Stock	5.54	5.54	5.38	5.41	135500.0
2012-11-05	ABT	Stock	31.0814	31.2686	31.0431	31.2062	9482493.0
2012-11-05	ABTL-DELISTED	Stock	3.96	4.02	3.96	4.02	10679.0
2012-11-05	ABUS	Stock	4.66	4.66	4.17	4.19	26400.0
2012-11-05	ABV-DELISTED	Stock	40.75	40.94	40.53	40.93	1464412.0
2012-11-05	ABVA-DELISTED	Stock	4.2	4.35	4.18	4.35	3500.0
2012-11-05	ABX-DELISTED	Stock	35.72	35.9	35.07	35.1	8704874.0
2012-11-05	ACAD	Stock	2.2	2.39	2.2	2.27	1463400.0
2012-11-05	ACAS-DELISTED	Stock	11.74	11.9	11.65	11.83	2374597.0

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

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