PREVIEW / stock_daily / 2011-07-12

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-12.parquet
  size:    197 KB
  rows:    6,108
  symbols: 3,554

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-07-12	AAPL	Stock	12.6261	12.7743	12.4507	12.6339	451609200.0
2011-07-12	MSFT	Stock	26.55	26.79	26.34	26.54	47319300.0
2011-07-12	NVDA	Stock	0.3705	0.374	0.361	0.3672	867604000.0
2011-07-12	AMZN	Stock	10.732	10.7825	10.556	10.5615	79714000.0
2011-07-12	TSLA	Stock	1.8913	1.9393	1.8667	1.878	15681000.0
2011-07-12	TLT	Stock	97.3	97.31	96.56	97.13	9090769.0
2011-07-12	ES	Stock	34.83	35.53	34.8	35.38	2489100.0
2011-07-12	CL	Stock	44.245	44.44	43.925	43.975	4624800.0
2011-07-12	A	Stock	34.7568	34.7997	34.0486	34.3848	5866847.0
2011-07-12	AABA-DELISTED	Stock	15.04	15.18	14.85	14.87	22760206.0
2011-07-12	AACC-DELISTED	Stock	4.04	4.24	4.01	4.2	44769.0
2011-07-12	AACG	Stock	11.18	11.18	10.71	10.74	4700.0
2011-07-12	AAIC-DELISTED	Stock	30.15	31.0099	30.09	30.71	35799.0
2011-07-12	AAME	Stock	2.05	2.05	2.03	2.05	700.0
2011-07-12	AAON	Stock	6.6637	6.7941	6.6637	6.7259	148838.0
2011-07-12	AAP	Stock	58.41	59.06	58.3	58.35	1849600.0
2011-07-12	AAT	Stock	22.72	23.21	22.67	22.81	142100.0
2011-07-12	AATI-DELISTED	Stock	6.07	6.08	6.07	6.07	210881.0
2011-07-12	AAU-DELISTED	Stock	3.59	3.8	3.5428	3.75	327389.0
2011-07-12	AAUAF-DELISTED	Stock	3.64	3.85	3.59	3.75	324444.0
2011-07-12	AAV-DELISTED	Stock	7.3	7.49	7.3	7.46	289318.0
2011-07-12	AAWW-DELISTED	Stock	61.42	61.73	58.2	58.86	400605.0
2011-07-12	AAXJ	Stock	60.96	61.324	60.75	60.77	290117.0
2011-07-12	AAXN-DELISTED	Stock	4.42	4.4892	4.35	4.38	171671.0
2011-07-12	AB	Stock	19.92	20.22	19.8	19.88	387000.0
2011-07-12	ABAC-DELISTED	Stock	2.72	2.78	2.57	2.72	20032.0
2011-07-12	ABAX-DELISTED	Stock	29.0	29.37	28.84	28.88	53448.0
2011-07-12	ABB-DELISTED	Stock	25.17	25.62	25.15	25.34	3293624.0
2011-07-12	ABBC-DELISTED	Stock	10.28	10.55	10.28	10.44	25851.0
2011-07-12	ABBNY-DELISTED	Stock	25.17	25.62	25.15	25.36	3694724.0
2011-07-12	ABC-DELISTED	Stock	42.27	42.84	42.2	42.29	1595206.0
2011-07-12	ABCB	Stock	8.94	9.35	8.94	9.13	30100.0
2011-07-12	ABCD-DELISTED	Stock	3.36	3.44	3.29	3.33	19624.0
2011-07-12	ABCO-DELISTED	Stock	27.95	28.18	27.72	28.02	90612.0
2011-07-12	ABCW-DELISTED	Stock	0.72	0.74	0.69	0.7	12840.0
2011-07-12	ABD-DELISTED	Stock	7.91	8.07	7.81	7.85	176660.0
2011-07-12	ABE-DELISTED	Stock	18.75	18.82	18.69	18.74	10191.0
2011-07-12	ABEO	Stock	2375.0	2437.5	2200.0	2437.5	7.0
2011-07-12	ABFS-DELISTED	Stock	26.09	26.72	25.97	26.27	421768.0
2011-07-12	ABG	Stock	19.05	19.11	18.74	18.95	332600.0
2011-07-12	ABH-DELISTED	Stock	20.18	20.18	19.71	19.82	446346.0
2011-07-12	ABM	Stock	23.34	23.84	23.31	23.54	246200.0
2011-07-12	ABMD-DELISTED	Stock	16.28	16.53	16.18	16.23	135584.0
2011-07-12	ABR	Stock	4.61	4.69	4.6	4.6	23500.0
2011-07-12	ABT	Stock	25.463	25.6933	25.3142	25.5685	15136098.0
2011-07-12	ABTL-DELISTED	Stock	5.9	5.9	5.5	5.8	20970.0
2011-07-12	ABUS	Stock	2.35	2.38	2.35	2.37	2100.0
2011-07-12	ABV-DELISTED	Stock	32.12	32.39	31.65	31.69	2081885.0
2011-07-12	ABVA-DELISTED	Stock	4.79	4.8	4.61	4.61	5400.0
2011-07-12	ABVT-DELISTED	Stock	65.54	68.2	61.2	67.43	1141943.0

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

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