PREVIEW / stock_daily / 2013-01-07

all stock daily files

  file:    by_date/stock_daily/2013/2013-01-07.parquet
  size:    204 KB
  rows:    6,237
  symbols: 3,496

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-07	AAPL	Stock	18.6429	18.9036	18.4	18.7107	484156400.0
2013-01-07	MSFT	Stock	26.77	26.88	26.64	26.69	37110400.0
2013-01-07	NVDA	Stock	0.3285	0.3295	0.317	0.3193	610732000.0
2013-01-07	AMZN	Stock	13.1485	13.4865	13.1335	13.423	98200000.0
2013-01-07	META	Stock	28.69	29.79	28.65	29.42	83781800.0
2013-01-07	TSLA	Stock	2.32	2.32	2.26	2.2893	6630000.0
2013-01-07	TLT	Stock	118.37	118.73	118.0	118.4499	4196169.0
2013-01-07	ES	Stock	39.44	39.58	39.09	39.21	1944500.0
2013-01-07	CL	Stock	53.635	53.635	52.925	53.04	2803600.0
2013-01-07	A	Stock	30.4721	30.6152	30.3147	30.4363	3589505.0
2013-01-07	AABA-DELISTED	Stock	19.55	19.58	19.28	19.38	23573890.0
2013-01-07	AACC-DELISTED	Stock	4.69	4.7	4.55	4.61	29999.0
2013-01-07	AACG	Stock	6.05	6.05	5.96	5.96	1100.0
2013-01-07	AAIC-DELISTED	Stock	21.8	22.05	21.53	21.91	96337.0
2013-01-07	AAMC-DELISTED	Stock	25.2941	25.8088	23.4706	23.4706	107919.0
2013-01-07	AAME	Stock	3.2	3.23	3.05	3.23	4700.0
2013-01-07	AAMRQ-DELISTED	Stock	0.875	0.8985	0.8705	0.89	3977175.0
2013-01-07	AAON	Stock	6.403	6.4593	6.3585	6.3733	198113.0
2013-01-07	AAP	Stock	73.15	73.8	73.15	73.37	1054400.0
2013-01-07	AAT	Stock	28.05	28.39	28.02	28.32	50000.0
2013-01-07	AAU-DELISTED	Stock	3.08	3.08	2.9	2.98	258299.0
2013-01-07	AAUAF-DELISTED	Stock	3.04	3.04	2.9	2.98	262006.0
2013-01-07	AAV-DELISTED	Stock	3.23	3.37	3.2	3.28	255885.0
2013-01-07	AAWW-DELISTED	Stock	45.0	45.24	44.215	44.77	210051.0
2013-01-07	AAXJ	Stock	60.88	60.88	60.64	60.81	249871.0
2013-01-07	AAXN-DELISTED	Stock	9.24	9.2999	8.86	9.005	635357.0
2013-01-07	AB	Stock	18.75	19.38	18.62	19.2	780400.0
2013-01-07	ABAC-DELISTED	Stock	0.94	0.94	0.93	0.93	1100.0
2013-01-07	ABAX-DELISTED	Stock	37.34	37.9899	37.31	37.49	67100.0
2013-01-07	ABB-DELISTED	Stock	20.83	20.98	20.78	20.97	1337584.0
2013-01-07	ABBNY-DELISTED	Stock	20.83	20.99	20.78	20.99	1364382.0
2013-01-07	ABBV	Stock	34.15	35.45	34.15	34.46	17897100.0
2013-01-07	ABC-DELISTED	Stock	43.7	43.89	43.5	43.82	1797032.0
2013-01-07	ABCB	Stock	12.86	12.94	12.81	12.87	26400.0
2013-01-07	ABCD-DELISTED	Stock	1.22	1.235	1.19	1.1901	57585.0
2013-01-07	ABCO-DELISTED	Stock	49.44	50.2	49.32	50.01	95194.0
2013-01-07	ABCW-DELISTED	Stock	0.408	0.42	0.381	0.42	38738.0
2013-01-07	ABE-DELISTED	Stock	21.83	21.83	21.62	21.75	15928.0
2013-01-07	ABEO	Stock	300.0	312.5	300.0	312.5	38.0
2013-01-07	ABFS-DELISTED	Stock	10.08	10.22	9.81	9.865	286918.0
2013-01-07	ABG	Stock	34.06	34.13	33.36	33.54	371000.0
2013-01-07	ABM	Stock	20.65	20.8	20.45	20.52	281800.0
2013-01-07	ABMD-DELISTED	Stock	13.31	13.4	12.94	13.25	624226.0
2013-01-07	ABR	Stock	6.6	6.75	6.4	6.56	347900.0
2013-01-07	ABT	Stock	33.02	33.34	32.85	33.34	13120000.0
2013-01-07	ABTL-DELISTED	Stock	4.03	4.03	3.9815	3.99	17794.0
2013-01-07	ABUS	Stock	5.07	5.07	4.97	4.98	6400.0
2013-01-07	ABV-DELISTED	Stock	42.67	42.74	42.282	42.35	1745695.0
2013-01-07	ABX-DELISTED	Stock	34.34	34.45	33.99	34.09	5963363.0
2013-01-07	ACAD	Stock	4.89	5.09	4.82	4.87	1345400.0

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

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