PREVIEW / stock_daily / 2015-01-12

all stock daily files

  file:    by_date/stock_daily/2015/2015-01-12.parquet
  size:    222 KB
  rows:    6,664
  symbols: 3,549

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-12	AAPL	Stock	28.15	28.1575	27.2	27.3125	198603200.0
2015-01-12	MSFT	Stock	47.42	47.54	46.36	46.6	23651900.0
2015-01-12	NVDA	Stock	0.4998	0.5	0.4878	0.4923	190732000.0
2015-01-12	AMZN	Stock	14.878	14.9255	14.464	14.5705	68428000.0
2015-01-12	GOOGL	Stock	24.962	25.014	24.5455	24.853	57138760.0
2015-01-12	META	Stock	77.84	78.0	76.21	76.72	19190200.0
2015-01-12	TSLA	Stock	13.5367	13.6313	13.2833	13.4807	89254500.0
2015-01-12	TLT	Stock	131.0	132.3099	130.92	131.82	6658148.0
2015-01-12	ES	Stock	53.71	53.74	52.99	53.33	1040100.0
2015-01-12	CL	Stock	68.6	68.96	67.77	68.26	2353900.0
2015-01-12	A	Stock	40.61	40.72	39.95	40.11	2770800.0
2015-01-12	AA.B-DELISTED	Stock	51.31	51.8	51.13	51.34	41903.0
2015-01-12	AABA-DELISTED	Stock	49.92	49.93	48.56	48.8	9722484.0
2015-01-12	AAC-DELISTED	Stock	30.31	30.61	29.05	29.23	32237.0
2015-01-12	AACG	Stock	4.49	4.5	4.4	4.46	20400.0
2015-01-12	AAIC-DELISTED	Stock	26.32	26.34	25.934	26.02	207131.0
2015-01-12	AAL	Stock	51.06	51.45	49.2	49.58	18261300.0
2015-01-12	AAMC-DELISTED	Stock	89.4118	94.65	88.8353	94.65	53373.0
2015-01-12	AAME	Stock	4.0	4.0	4.0	4.0	1000.0
2015-01-12	AAMI	Stock	15.34	15.52	15.1	15.4	151600.0
2015-01-12	AAOI	Stock	10.06	10.06	9.57	9.7	159900.0
2015-01-12	AAON	Stock	14.2267	14.2933	13.9933	14.2467	216150.0
2015-01-12	AAP	Stock	160.13	160.41	158.22	158.93	756700.0
2015-01-12	AAT	Stock	42.37	42.84	42.26	42.78	132100.0
2015-01-12	AAU-DELISTED	Stock	1.16	1.1903	1.1396	1.17	405411.0
2015-01-12	AAUAF-DELISTED	Stock	1.14	1.17	1.12	1.17	413600.0
2015-01-12	AAV-DELISTED	Stock	4.46	4.48	4.35	4.45	211924.0
2015-01-12	AAVL-DELISTED	Stock	58.7	59.49	57.02	58.76	260200.0
2015-01-12	AAWW-DELISTED	Stock	47.73	48.16	46.23	46.62	134389.0
2015-01-12	AAXJ	Stock	61.4	61.58	61.11	61.18	684380.0
2015-01-12	AAXN-DELISTED	Stock	26.24	26.37	25.53	25.84	1139707.0
2015-01-12	AB	Stock	25.64	25.85	25.3	25.7	270300.0
2015-01-12	ABAC-DELISTED	Stock	1.51	1.5385	1.3601	1.37	34007.0
2015-01-12	ABAX-DELISTED	Stock	57.38	58.206	57.161	57.2	228057.0
2015-01-12	ABB-DELISTED	Stock	20.14	20.14	19.7	19.79	2484797.0
2015-01-12	ABBNY-DELISTED	Stock	20.14	20.14	19.7	19.79	2597363.0
2015-01-12	ABBV	Stock	66.34	66.93	65.31	65.76	6159800.0
2015-01-12	ABC-DELISTED	Stock	93.77	94.35	90.55	90.91	3194519.0
2015-01-12	ABCB	Stock	23.98	24.02	23.55	23.77	72600.0
2015-01-12	ABCD-DELISTED	Stock	1.78	1.7899	1.73	1.77	1412.0
2015-01-12	ABCO-DELISTED	Stock	49.82	49.99	47.81	47.89	226905.0
2015-01-12	ABCW-DELISTED	Stock	34.65	34.745	34.61	34.61	690.0
2015-01-12	ABDC-DELISTED	Stock	13.1	13.1	12.97	13.03	17162.0
2015-01-12	ABE-DELISTED	Stock	13.23	13.246	12.93	12.97	17055.0
2015-01-12	ABEO	Stock	80.0	87.5	80.0	87.5	596.0
2015-01-12	ABEOW-DELISTED	Stock	0.7	0.7	0.7	0.7	1000.0
2015-01-12	ABEV	Stock	6.24	6.34	6.22	6.32	9476200.0
2015-01-12	ABG	Stock	74.45	74.46	72.95	73.67	349100.0
2015-01-12	ABGB-DELISTED	Stock	15.53	15.71	14.79	15.5	138268.0
2015-01-12	ABIL-DELISTED	Stock	9.78	9.85	9.75	9.82	3302.0

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

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