PREVIEW / stock_daily / 2015-01-20

all stock daily files

  file:    by_date/stock_daily/2015/2015-01-20.parquet
  size:    222 KB
  rows:    6,654
  symbols: 3,542

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-20	AAPL	Stock	26.96	27.2425	26.625	27.18	199599600.0
2015-01-20	MSFT	Stock	46.3	46.65	45.57	46.39	36161900.0
2015-01-20	NVDA	Stock	0.5025	0.5053	0.4942	0.5005	140308000.0
2015-01-20	AMZN	Stock	14.6295	14.668	14.3195	14.472	61502000.0
2015-01-20	GOOGL	Stock	25.6385	25.7805	25.4685	25.497	46872240.0
2015-01-20	META	Stock	75.72	76.31	74.82	76.24	22821600.0
2015-01-20	TSLA	Stock	12.9247	12.9413	12.4693	12.7953	67548000.0
2015-01-20	TLT	Stock	134.13	135.11	134.07	134.96	7758724.0
2015-01-20	ES	Stock	55.41	55.74	54.97	55.36	1262100.0
2015-01-20	CL	Stock	69.04	69.19	68.38	68.96	3275000.0
2015-01-20	A	Stock	38.43	38.66	37.76	37.93	5033600.0
2015-01-20	AA.B-DELISTED	Stock	49.95	50.1	49.12	50.04	40967.0
2015-01-20	AABA-DELISTED	Stock	46.79	47.89	46.77	47.63	14426939.0
2015-01-20	AAC-DELISTED	Stock	30.04	30.04	28.28	29.01	64407.0
2015-01-20	AACG	Stock	4.76	4.88	4.59	4.77	35200.0
2015-01-20	AAIC-DELISTED	Stock	26.42	26.42	26.14	26.16	158320.0
2015-01-20	AAL	Stock	51.0	52.83	49.93	52.75	15157300.0
2015-01-20	AAMC-DELISTED	Stock	84.4824	86.1794	77.8618	79.3176	37019.0
2015-01-20	AAME	Stock	3.82	3.99	3.82	3.99	1100.0
2015-01-20	AAMI	Stock	15.79	16.11	15.57	16.05	109300.0
2015-01-20	AAOI	Stock	8.58	8.69	8.38	8.6	143900.0
2015-01-20	AAON	Stock	14.62	14.66	14.2733	14.4133	169650.0
2015-01-20	AAP	Stock	150.04	152.75	148.45	152.66	941800.0
2015-01-20	AAT	Stock	44.26	44.69	43.25	43.47	94100.0
2015-01-20	AAU-DELISTED	Stock	1.17	1.24	1.145	1.205	764719.0
2015-01-20	AAUAF-DELISTED	Stock	1.17	1.24	1.145	1.205	766395.0
2015-01-20	AAV-DELISTED	Stock	4.68	4.68	4.33	4.34	181232.0
2015-01-20	AAVL-DELISTED	Stock	48.61	50.0	47.02	47.57	399598.0
2015-01-20	AAWW-DELISTED	Stock	46.07	47.04	46.0205	46.41	194501.0
2015-01-20	AAXJ	Stock	61.82	62.04	61.78	61.96	1209556.0
2015-01-20	AAXN-DELISTED	Stock	25.57	27.45	25.25	26.9	4286027.0
2015-01-20	AB	Stock	26.07	26.07	25.56	25.98	275500.0
2015-01-20	ABAC-DELISTED	Stock	1.45	1.51	1.39	1.43	3512.0
2015-01-20	ABAX-DELISTED	Stock	59.61	60.9	58.81	60.26	224128.0
2015-01-20	ABB-DELISTED	Stock	19.7	19.75	19.46	19.59	2592486.0
2015-01-20	ABBNY-DELISTED	Stock	19.7	19.75	19.46	19.61	2807573.0
2015-01-20	ABBV	Stock	65.06	65.29	62.75	63.45	9065300.0
2015-01-20	ABC-DELISTED	Stock	93.01	93.42	91.39	92.45	1009865.0
2015-01-20	ABCB	Stock	23.56	24.18	23.05	23.35	52900.0
2015-01-20	ABCD-DELISTED	Stock	1.84	2.1	1.84	2.1	71107.0
2015-01-20	ABCO-DELISTED	Stock	48.03	48.44	46.54	47.7	153621.0
2015-01-20	ABCW-DELISTED	Stock	34.69	34.9	32.74	34.85	11007.0
2015-01-20	ABDC-DELISTED	Stock	13.1	13.1	12.68	12.93	19220.0
2015-01-20	ABE-DELISTED	Stock	13.18	13.23	13.11	13.128	2833.0
2015-01-20	ABEO	Stock	83.75	83.75	78.25	78.5	224.0
2015-01-20	ABEOW-DELISTED	Stock	0.75	0.75	0.7	0.7	2200.0
2015-01-20	ABEV	Stock	6.39	6.5	6.38	6.49	11239800.0
2015-01-20	ABG	Stock	70.95	71.44	70.2	70.68	362600.0
2015-01-20	ABGB-DELISTED	Stock	16.5	16.84	16.31	16.62	94685.0
2015-01-20	ABIL-DELISTED	Stock	9.75	9.89	9.75	9.86	1600.0

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

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