PREVIEW / stock_daily / 2012-08-07

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-07.parquet
  size:    200 KB
  rows:    6,187
  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
2012-08-07	AAPL	Stock	22.2418	22.3214	22.0729	22.1754	290446800.0
2012-08-07	MSFT	Stock	30.07	30.35	29.87	30.26	28002900.0
2012-08-07	NVDA	Stock	0.3545	0.3575	0.3518	0.3538	407340000.0
2012-08-07	AMZN	Stock	11.7065	11.9	11.6625	11.828	41166000.0
2012-08-07	META	Stock	22.2	22.45	20.5	20.72	36782900.0
2012-08-07	TSLA	Stock	1.918	2.06	1.9	2.0167	35808000.0
2012-08-07	TLT	Stock	125.96	126.13	125.43	125.83	6613817.0
2012-08-07	ES	Stock	39.68	39.74	39.43	39.48	1863100.0
2012-08-07	CL	Stock	53.3	53.525	52.405	52.44	4507600.0
2012-08-07	A	Stock	28.1474	29.02	28.0758	28.7911	3077417.0
2012-08-07	AABA-DELISTED	Stock	16.09	16.37	16.07	16.21	17181467.0
2012-08-07	AACC-DELISTED	Stock	5.81	5.89	5.81	5.85	45889.0
2012-08-07	AACG	Stock	4.28	4.64	4.27	4.4	2400.0
2012-08-07	AAIC-DELISTED	Stock	22.5	22.89	22.48	22.85	64582.0
2012-08-07	AAME	Stock	2.7	2.7	2.55	2.7	7900.0
2012-08-07	AAMRQ-DELISTED	Stock	0.503	0.516	0.498	0.5025	860477.0
2012-08-07	AAON	Stock	5.6296	5.6296	5.4815	5.5674	125888.0
2012-08-07	AAP	Stock	69.23	71.14	69.05	70.66	1137200.0
2012-08-07	AAT	Stock	26.59	26.59	26.36	26.46	131000.0
2012-08-07	AAU-DELISTED	Stock	1.96	2.08	1.91	2.05	358634.0
2012-08-07	AAUAF-DELISTED	Stock	1.96	2.08	1.91	2.03	362634.0
2012-08-07	AAV-DELISTED	Stock	3.84	3.88	3.82	3.84	149194.0
2012-08-07	AAWW-DELISTED	Stock	52.08	54.725	51.77	52.83	485041.0
2012-08-07	AAXJ	Stock	54.04	54.38	53.99	54.12	197164.0
2012-08-07	AAXN-DELISTED	Stock	5.58	5.69	5.53	5.61	1098162.0
2012-08-07	AB	Stock	12.6	12.89	12.39	12.59	258700.0
2012-08-07	ABAC-DELISTED	Stock	0.9	0.9499	0.9	0.92	11267.0
2012-08-07	ABAX-DELISTED	Stock	37.42	37.8	37.22	37.27	54686.0
2012-08-07	ABB-DELISTED	Stock	18.02	18.14	17.99	18.05	1870781.0
2012-08-07	ABBNY-DELISTED	Stock	18.02	18.14	17.99	18.05	2047794.0
2012-08-07	ABC-DELISTED	Stock	39.25	39.6	39.2	39.33	2520736.0
2012-08-07	ABCB	Stock	11.9	11.96	11.66	11.92	46900.0
2012-08-07	ABCD-DELISTED	Stock	1.03	1.0694	1.0	1.06	58638.0
2012-08-07	ABCO-DELISTED	Stock	42.87	43.47	42.36	42.37	281978.0
2012-08-07	ABCW-DELISTED	Stock	0.46	0.48	0.4	0.4	10034.0
2012-08-07	ABE-DELISTED	Stock	19.59	19.66	19.54	19.56	2655.0
2012-08-07	ABEO	Stock	612.5	625.0	550.0	587.5	82.0
2012-08-07	ABFS-DELISTED	Stock	10.46	10.83	10.0601	10.44	419470.0
2012-08-07	ABG	Stock	27.31	27.51	26.69	26.76	525400.0
2012-08-07	ABM	Stock	19.02	19.13	18.81	18.83	247200.0
2012-08-07	ABMD-DELISTED	Stock	22.55	22.81	22.2	22.4	516828.0
2012-08-07	ABR	Stock	5.55	5.76	5.55	5.65	52300.0
2012-08-07	ABT	Stock	31.8443	31.8683	31.5852	31.6812	9502501.0
2012-08-07	ABTL-DELISTED	Stock	3.63	4.0	3.52	3.57	37332.0
2012-08-07	ABUS	Stock	3.3	3.47	3.25	3.4	21700.0
2012-08-07	ABV-DELISTED	Stock	39.2	39.65	39.02	39.14	1183723.0
2012-08-07	ABVA-DELISTED	Stock	4.54	4.54	4.54	4.54	326.0
2012-08-07	ABX-DELISTED	Stock	33.71	34.16	33.53	34.01	7368676.0
2012-08-07	ACAD	Stock	1.56	1.57	1.52	1.52	123600.0
2012-08-07	ACAS-DELISTED	Stock	10.7	10.85	10.69	10.74	4122106.0

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

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