PREVIEW / stock_daily / 2015-01-28

all stock daily files

  file:    by_date/stock_daily/2015/2015-01-28.parquet
  size:    222 KB
  rows:    6,629
  symbols: 3,520

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
2015-01-28	AAPL	Stock	29.4075	29.53	28.8275	28.8275	585908400.0
2015-01-28	MSFT	Stock	42.74	42.79	41.16	41.19	84507100.0
2015-01-28	NVDA	Stock	0.4968	0.4988	0.4825	0.4828	272728000.0
2015-01-28	AMZN	Stock	15.4905	15.5755	15.19	15.1955	61276000.0
2015-01-28	GOOGL	Stock	26.25	26.2845	25.6175	25.6215	35821540.0
2015-01-28	META	Stock	76.9	77.64	76.0	76.24	53306400.0
2015-01-28	TSLA	Stock	13.7407	13.758	13.228	13.2913	47244000.0
2015-01-28	TLT	Stock	134.75	137.41	134.7	136.77	12230298.0
2015-01-28	ES	Stock	55.79	56.7	55.52	55.66	1223800.0
2015-01-28	CL	Stock	66.05	66.21	64.95	65.12	6750300.0
2015-01-28	A	Stock	39.01	39.05	37.96	38.0	2033500.0
2015-01-28	AA.B-DELISTED	Stock	51.146	51.71	50.75	50.9	262314.0
2015-01-28	AABA-DELISTED	Stock	49.79	50.32	46.3	46.47	80111816.0
2015-01-28	AAC-DELISTED	Stock	27.8	27.92	26.35	26.56	56882.0
2015-01-28	AACG	Stock	4.6	4.94	4.6	4.88	700.0
2015-01-28	AAIC-DELISTED	Stock	27.17	27.17	26.63	26.66	157304.0
2015-01-28	AAL	Stock	52.79	53.7	50.3	50.62	17064800.0
2015-01-28	AAMC-DELISTED	Stock	63.1176	63.1176	56.1029	56.1029	20760.0
2015-01-28	AAME	Stock	3.9	4.0	3.9	4.0	2600.0
2015-01-28	AAMI	Stock	15.28	15.36	15.09	15.19	88200.0
2015-01-28	AAOI	Stock	9.4	9.4	8.94	9.08	235500.0
2015-01-28	AAON	Stock	15.3067	15.3067	14.7067	14.82	167850.0
2015-01-28	AAP	Stock	159.49	161.13	158.52	159.3	1149800.0
2015-01-28	AAT	Stock	44.61	45.09	44.57	44.65	113100.0
2015-01-28	AAU-DELISTED	Stock	1.23	1.252	1.2099	1.21	122140.0
2015-01-28	AAUAF-DELISTED	Stock	1.17	1.21	1.15	1.21	129297.0
2015-01-28	AAV-DELISTED	Stock	4.27	4.27	3.95	4.03	163166.0
2015-01-28	AAVL-DELISTED	Stock	42.07	43.14	39.62	41.03	363798.0
2015-01-28	AAWW-DELISTED	Stock	47.13	47.13	45.17	45.54	112767.0
2015-01-28	AAXJ	Stock	63.67	63.81	62.99	63.09	806237.0
2015-01-28	AAXN-DELISTED	Stock	27.9	28.19	27.28	27.29	1372461.0
2015-01-28	AB	Stock	26.0	26.0	25.05	25.15	204100.0
2015-01-28	ABAC-DELISTED	Stock	1.53	1.6	1.5204	1.6	23365.0
2015-01-28	ABAX-DELISTED	Stock	60.65	60.99	59.82	59.94	441184.0
2015-01-28	ABB-DELISTED	Stock	19.52	19.6846	19.36	19.37	2683522.0
2015-01-28	ABBNY-DELISTED	Stock	19.52	19.6846	19.36	19.38	2811154.0
2015-01-28	ABBV	Stock	63.44	63.56	61.69	61.85	6910100.0
2015-01-28	ABC-DELISTED	Stock	98.8	100.2	95.26	96.36	4968957.0
2015-01-28	ABCB	Stock	23.61	23.64	22.71	22.75	77800.0
2015-01-28	ABCD-DELISTED	Stock	2.55	2.55	2.45	2.53	16111.0
2015-01-28	ABCO-DELISTED	Stock	47.25	47.87	45.92	46.32	366620.0
2015-01-28	ABCW-DELISTED	Stock	33.82	33.82	33.0	33.04	3400.0
2015-01-28	ABDC-DELISTED	Stock	12.96	13.03	12.8835	12.98	30330.0
2015-01-28	ABE-DELISTED	Stock	13.15	13.19	13.15	13.1501	1273.0
2015-01-28	ABEO	Stock	81.25	83.75	79.5	83.75	328.0
2015-01-28	ABEV	Stock	6.59	6.67	6.51	6.57	10789800.0
2015-01-28	ABG	Stock	76.72	78.58	75.57	75.81	522300.0
2015-01-28	ABGB-DELISTED	Stock	15.49	15.54	15.2	15.24	65316.0
2015-01-28	ABM	Stock	29.45	29.54	28.77	29.01	170500.0
2015-01-28	ABMD-DELISTED	Stock	53.48	53.89	49.1878	49.94	3386932.0

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

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