PREVIEW / stock_daily / 2013-01-31

all stock daily files

  file:    by_date/stock_daily/2013/2013-01-31.parquet
  size:    204 KB
  rows:    6,224
  symbols: 3,479

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
2013-01-31	AAPL	Stock	16.3207	16.4029	16.2493	16.2675	319334400.0
2013-01-31	MSFT	Stock	27.79	27.97	27.4	27.45	50530000.0
2013-01-31	NVDA	Stock	0.308	0.3115	0.3045	0.3065	470544000.0
2013-01-31	AMZN	Stock	13.552	13.797	13.185	13.275	135442000.0
2013-01-31	META	Stock	29.15	31.47	28.74	30.98	190744900.0
2013-01-31	TSLA	Stock	2.5247	2.5247	2.462	2.5007	13521000.0
2013-01-31	TLT	Stock	117.03	117.34	116.552	117.32	6789172.0
2013-01-31	ES	Stock	40.89	41.01	40.66	40.73	4990600.0
2013-01-31	CL	Stock	54.07	55.54	53.37	53.685	9270000.0
2013-01-31	A	Stock	31.7239	32.0959	31.6953	32.0315	4729853.0
2013-01-31	AABA-DELISTED	Stock	19.92	19.99	19.57	19.62	32565227.0
2013-01-31	AACC-DELISTED	Stock	5.28	5.37	5.24	5.37	18227.0
2013-01-31	AACG	Stock	5.43	5.71	5.4	5.71	1800.0
2013-01-31	AAIC-DELISTED	Stock	23.37	23.45	23.25	23.37	75830.0
2013-01-31	AAMC-DELISTED	Stock	36.6912	37.6471	36.6912	36.9853	18068.0
2013-01-31	AAME	Stock	3.32	3.35	3.31	3.35	1500.0
2013-01-31	AAMRQ-DELISTED	Stock	1.055	1.3021	1.03	1.28	9453898.0
2013-01-31	AAON	Stock	6.6815	6.7585	6.6696	6.7378	305775.0
2013-01-31	AAP	Stock	73.47	74.05	73.04	73.52	1019200.0
2013-01-31	AAT	Stock	28.93	29.22	28.85	28.9	162200.0
2013-01-31	AAU-DELISTED	Stock	2.76	2.8	2.53	2.71	624537.0
2013-01-31	AAUAF-DELISTED	Stock	2.76	2.8	2.53	2.71	628519.0
2013-01-31	AAV-DELISTED	Stock	2.96	3.0	2.89	2.89	231049.0
2013-01-31	AAWW-DELISTED	Stock	45.29	45.6	44.7	45.1	266348.0
2013-01-31	AAXJ	Stock	60.53	60.6	60.395	60.47	2069581.0
2013-01-31	AAXN-DELISTED	Stock	8.31	8.62	8.25	8.37	472376.0
2013-01-31	AB	Stock	20.44	20.55	20.25	20.36	385400.0
2013-01-31	ABAC-DELISTED	Stock	0.8701	0.923	0.851	0.89	30400.0
2013-01-31	ABAX-DELISTED	Stock	38.37	40.0	38.29	38.72	107693.0
2013-01-31	ABB-DELISTED	Stock	21.53	21.57	21.37	21.4	1515267.0
2013-01-31	ABBNY-DELISTED	Stock	21.53	21.57	21.37	21.41	1527408.0
2013-01-31	ABBV	Stock	36.84	36.93	36.27	36.69	10720700.0
2013-01-31	ABC-DELISTED	Stock	45.52	45.56	45.17	45.4	2792741.0
2013-01-31	ABCB	Stock	13.13	13.35	13.01	13.26	91100.0
2013-01-31	ABCD-DELISTED	Stock	1.28	1.39	1.28	1.32	8450.0
2013-01-31	ABCO-DELISTED	Stock	54.02	54.64	53.8	54.22	188083.0
2013-01-31	ABCW-DELISTED	Stock	0.65	0.65	0.62	0.62	2327.0
2013-01-31	ABE-DELISTED	Stock	21.93	21.93	21.67	21.72	7010.0
2013-01-31	ABEO	Stock	550.0	612.5	550.0	612.5	5.0
2013-01-31	ABFS-DELISTED	Stock	10.48	10.93	10.32	10.5	619430.0
2013-01-31	ABG	Stock	34.33	36.29	34.15	35.56	551600.0
2013-01-31	ABM	Stock	21.84	21.94	21.74	21.92	346400.0
2013-01-31	ABMD-DELISTED	Stock	13.39	14.08	13.01	13.95	720430.0
2013-01-31	ABR	Stock	7.1	7.17	6.99	7.13	96700.0
2013-01-31	ABT	Stock	33.16	33.88	33.11	33.88	33862200.0
2013-01-31	ABTL-DELISTED	Stock	4.05	4.05	4.04	4.04	300.0
2013-01-31	ABUS	Stock	4.85	4.94	4.54	4.7	124300.0
2013-01-31	ABV-DELISTED	Stock	46.71	47.172	45.72	47.04	2856298.0
2013-01-31	ABX-DELISTED	Stock	32.2	32.22	31.81	31.91	8522761.0
2013-01-31	ACAD	Stock	6.17	6.23	5.89	6.03	2376300.0

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

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