PREVIEW / stock_daily / 2012-12-06

all stock daily files

  file:    by_date/stock_daily/2012/2012-12-06.parquet
  size:    201 KB
  rows:    6,228
  symbols: 3,521

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-12-06	AAPL	Stock	18.8907	19.7611	18.5225	19.5443	1177212400.0
2012-12-06	MSFT	Stock	26.81	26.98	26.61	26.73	39182300.0
2012-12-06	NVDA	Stock	0.2982	0.3015	0.2972	0.2995	412896000.0
2012-12-06	AMZN	Stock	12.65	12.7585	12.5755	12.6685	71158000.0
2012-12-06	META	Stock	27.68	27.75	26.82	26.97	46001500.0
2012-12-06	TSLA	Stock	2.2547	2.32	2.2333	2.26	9906000.0
2012-12-06	TLT	Stock	125.86	126.08	125.51	125.59	2301120.0
2012-12-06	ES	Stock	39.33	39.51	39.09	39.25	1167100.0
2012-12-06	CL	Stock	53.505	53.605	53.15	53.325	3161000.0
2012-12-06	A	Stock	27.568	27.7182	27.2675	27.4106	4989043.0
2012-12-06	AABA-DELISTED	Stock	18.79	19.28	18.77	19.23	25096430.0
2012-12-06	AACC-DELISTED	Stock	5.18	5.24	4.85	5.14	19588.0
2012-12-06	AACG	Stock	3.99	4.0	3.88	3.89	5800.0
2012-12-06	AAIC-DELISTED	Stock	21.4	21.84	21.37	21.77	156312.0
2012-12-06	AAME	Stock	2.94	2.96	2.87	2.96	3000.0
2012-12-06	AAMRQ-DELISTED	Stock	0.507	0.518	0.5003	0.51	837532.0
2012-12-06	AAON	Stock	6.24	6.3437	6.1096	6.2459	206550.0
2012-12-06	AAP	Stock	72.34	72.59	71.67	71.95	496500.0
2012-12-06	AAT	Stock	27.05	27.41	27.0	27.07	95500.0
2012-12-06	AAU-DELISTED	Stock	3.1	3.24	3.0289	3.18	323030.0
2012-12-06	AAUAF-DELISTED	Stock	3.1	3.24	3.0289	3.17	328048.0
2012-12-06	AAV-DELISTED	Stock	3.32	3.36	3.27	3.28	85888.0
2012-12-06	AAWW-DELISTED	Stock	42.18	42.6299	42.02	42.33	137206.0
2012-12-06	AAXJ	Stock	58.64	59.06	58.64	59.04	160621.0
2012-12-06	AAXN-DELISTED	Stock	8.3	8.36	8.08	8.24	316565.0
2012-12-06	AB	Stock	17.25	17.26	16.59	17.0	682900.0
2012-12-06	ABAC-DELISTED	Stock	0.93	0.93	0.9	0.9144	7600.0
2012-12-06	ABAX-DELISTED	Stock	36.88	36.91	36.46	36.83	38704.0
2012-12-06	ABB-DELISTED	Stock	19.85	19.88	19.76	19.88	1232229.0
2012-12-06	ABBNY-DELISTED	Stock	19.85	19.88	19.76	19.88	1293726.0
2012-12-06	ABC-DELISTED	Stock	42.68	42.72	42.2	42.53	3027557.0
2012-12-06	ABCB	Stock	11.4	11.58	11.31	11.58	29400.0
2012-12-06	ABCD-DELISTED	Stock	1.17	1.18	1.02	1.17	27160.0
2012-12-06	ABCO-DELISTED	Stock	46.82	47.65	46.59	47.37	157641.0
2012-12-06	ABCW-DELISTED	Stock	0.38	0.38	0.38	0.38	2312.0
2012-12-06	ABE-DELISTED	Stock	20.71	20.71	20.51	20.6217	1200.0
2012-12-06	ABEO	Stock	325.0	375.0	325.0	325.0	108.0
2012-12-06	ABFS-DELISTED	Stock	8.45	8.55	8.45	8.54	234380.0
2012-12-06	ABG	Stock	31.38	31.84	30.92	31.42	213200.0
2012-12-06	ABM	Stock	19.37	19.64	19.24	19.55	157500.0
2012-12-06	ABR	Stock	5.15	5.19	5.12	5.12	34700.0
2012-12-06	ABT	Stock	30.9471	31.0862	30.8176	30.9855	8853897.0
2012-12-06	ABTL-DELISTED	Stock	3.83	3.9	3.77	3.77	21143.0
2012-12-06	ABUS	Stock	4.74	4.83	4.74	4.83	36200.0
2012-12-06	ABV-DELISTED	Stock	41.71	42.43	41.67	42.35	1422944.0
2012-12-06	ABVA-DELISTED	Stock	4.69	4.85	4.6	4.85	7944.0
2012-12-06	ABX-DELISTED	Stock	33.41	33.9125	33.2	33.43	7106019.0
2012-12-06	ACAD	Stock	4.54	4.87	4.54	4.65	3320200.0
2012-12-06	ACAS-DELISTED	Stock	11.69	11.75	11.58	11.72	1895788.0
2012-12-06	ACAT-DELISTED	Stock	34.16	34.24	33.52	33.86	205623.0

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

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