PREVIEW / stock_daily / 2012-06-04

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-04.parquet
  size:    199 KB
  rows:    6,180
  symbols: 3,545

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-06-04	AAPL	Stock	20.0536	20.2679	19.5893	20.1532	556995600.0
2012-06-04	MSFT	Stock	28.62	28.78	28.32	28.55	47926300.0
2012-06-04	NVDA	Stock	0.301	0.3028	0.2908	0.2932	432856000.0
2012-06-04	AMZN	Stock	10.37	10.7675	10.3185	10.7285	85992000.0
2012-06-04	META	Stock	27.2	27.65	26.44	26.9	35230300.0
2012-06-04	TSLA	Stock	1.8687	1.894	1.8073	1.8587	15463500.0
2012-06-04	TLT	Stock	129.31	130.18	128.94	129.33	11681948.0
2012-06-04	ES	Stock	36.29	36.49	36.15	36.22	2684000.0
2012-06-04	CL	Stock	48.245	48.65	48.105	48.585	3371400.0
2012-06-04	A	Stock	27.432	27.6323	26.4378	27.0672	7212422.0
2012-06-04	AABA-DELISTED	Stock	14.91	15.03	14.81	15.01	15328310.0
2012-06-04	AACC-DELISTED	Stock	5.67	5.83	5.51	5.76	34067.0
2012-06-04	AACG	Stock	5.4	5.6	5.13	5.6	2200.0
2012-06-04	AAIC-DELISTED	Stock	21.79	21.9	20.9	21.07	106531.0
2012-06-04	AAME	Stock	2.55	2.78	2.55	2.78	13200.0
2012-06-04	AAMRQ-DELISTED	Stock	0.46	0.467	0.45	0.45	1479379.0
2012-06-04	AAON	Stock	5.4281	5.52	5.3778	5.5052	144113.0
2012-06-04	AAP	Stock	71.16	71.98	70.02	70.78	1308700.0
2012-06-04	AAT	Stock	22.22	22.68	22.22	22.46	246000.0
2012-06-04	AAU-DELISTED	Stock	2.09	2.18	2.052	2.16	199462.0
2012-06-04	AAUAF-DELISTED	Stock	2.09	2.18	2.052	2.16	199662.0
2012-06-04	AAV-DELISTED	Stock	2.61	2.63	2.51	2.6	338177.0
2012-06-04	AAWW-DELISTED	Stock	42.39	42.39	40.44	41.11	487829.0
2012-06-04	AAXJ	Stock	49.32	49.585	49.0748	49.39	481410.0
2012-06-04	AAXN-DELISTED	Stock	5.27	5.31	5.16	5.21	321134.0
2012-06-04	AB	Stock	12.46	12.46	12.08	12.41	128000.0
2012-06-04	ABAC-DELISTED	Stock	1.34	1.4	1.34	1.38	4450.0
2012-06-04	ABAX-DELISTED	Stock	31.72	32.06	31.43	31.56	104221.0
2012-06-04	ABB-DELISTED	Stock	15.65	15.7	15.39	15.53	2573585.0
2012-06-04	ABBNY-DELISTED	Stock	15.65	15.7	15.39	15.53	2609845.0
2012-06-04	ABC-DELISTED	Stock	36.24	36.45	36.02	36.38	2548566.0
2012-06-04	ABCB	Stock	10.99	11.27	10.9	11.19	52300.0
2012-06-04	ABCD-DELISTED	Stock	1.19	1.25	1.19	1.23	11634.0
2012-06-04	ABCO-DELISTED	Stock	47.42	48.0	47.0	47.22	283055.0
2012-06-04	ABCW-DELISTED	Stock	0.5321	0.5321	0.4217	0.4418	24630.0
2012-06-04	ABE-DELISTED	Stock	17.48	17.53	17.15	17.37	8590.0
2012-06-04	ABEO	Stock	987.5	1100.0	962.5	1000.0	27.0
2012-06-04	ABFS-DELISTED	Stock	12.78	12.849	11.93	11.99	357169.0
2012-06-04	ABG	Stock	24.84	24.91	23.7	24.3	626300.0
2012-06-04	ABM	Stock	20.56	20.85	20.28	20.52	419200.0
2012-06-04	ABMD-DELISTED	Stock	19.53	20.1	19.18	19.77	979717.0
2012-06-04	ABR	Stock	5.99	6.04	5.9	5.95	72700.0
2012-06-04	ABT	Stock	29.0471	29.0759	28.7592	28.8936	17446436.0
2012-06-04	ABTL-DELISTED	Stock	3.7956	3.7961	3.6497	3.75	16762.0
2012-06-04	ABUS	Stock	2.0	2.0	1.88	1.88	4200.0
2012-06-04	ABV-DELISTED	Stock	35.93	36.2301	35.44	35.59	5310207.0
2012-06-04	ABVA-DELISTED	Stock	4.32	4.42	4.3	4.42	11832.0
2012-06-04	ABVT-DELISTED	Stock	83.21	83.34	83.06	83.1	664072.0
2012-06-04	ABX-DELISTED	Stock	41.91	42.18	40.93	42.15	12157344.0
2012-06-04	ACAD	Stock	1.33	1.34	1.3	1.33	106400.0

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

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