PREVIEW / stock_daily / 2015-02-18

all stock daily files

  file:    by_date/stock_daily/2015/2015-02-18.parquet
  size:    224 KB
  rows:    6,648
  symbols: 3,530

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-02-18	AAPL	Stock	31.9075	32.195	31.8625	32.18	179566800.0
2015-02-18	MSFT	Stock	43.63	43.7	43.39	43.53	27111700.0
2015-02-18	NVDA	Stock	0.5588	0.5598	0.552	0.553	170948000.0
2015-02-18	AMZN	Stock	18.689	18.837	18.6425	18.6685	53012000.0
2015-02-18	GOOGL	Stock	27.191	27.3775	26.9775	27.1325	31163060.0
2015-02-18	META	Stock	75.94	76.9	75.45	76.71	22426400.0
2015-02-18	TSLA	Stock	13.6113	13.7447	13.5067	13.6307	40704000.0
2015-02-18	TLT	Stock	126.82	127.74	126.47	127.01	14009187.0
2015-02-18	ES	Stock	51.18	52.56	51.12	52.54	2162800.0
2015-02-18	CL	Stock	69.76	70.61	69.76	70.54	2771400.0
2015-02-18	A	Stock	41.12	42.2	40.91	41.54	9007200.0
2015-02-18	AA.B-DELISTED	Stock	50.5	50.8	50.2	50.67	25500.0
2015-02-18	AABA-DELISTED	Stock	43.56	43.82	43.3	43.6499	9785809.0
2015-02-18	AAC-DELISTED	Stock	29.17	30.27	29.16	29.45	32143.0
2015-02-18	AACG	Stock	4.16	4.39	4.15	4.39	1800.0
2015-02-18	AAIC-DELISTED	Stock	25.12	25.13	24.9	25.04	168228.0
2015-02-18	AAL	Stock	48.6	49.45	48.18	49.31	8752700.0
2015-02-18	AAMC-DELISTED	Stock	55.0	57.6029	54.4706	57.6029	12672.0
2015-02-18	AAME	Stock	3.86	3.99	3.86	3.99	800.0
2015-02-18	AAMI	Stock	17.06	17.14	16.58	16.88	62600.0
2015-02-18	AAOI	Stock	10.23	10.31	10.11	10.17	107200.0
2015-02-18	AAON	Stock	15.3867	15.58	15.3733	15.5	167700.0
2015-02-18	AAP	Stock	149.65	153.6	148.5	153.22	1789200.0
2015-02-18	AAT	Stock	42.56	43.49	42.03	43.21	129000.0
2015-02-18	AAU-DELISTED	Stock	1.13	1.13	1.1	1.12	134011.0
2015-02-18	AAUAF-DELISTED	Stock	1.13	1.13	1.1	1.12	135079.0
2015-02-18	AAV-DELISTED	Stock	5.16	5.83	5.1	5.37	493520.0
2015-02-18	AAVL-DELISTED	Stock	36.8	40.25	36.8	39.73	540944.0
2015-02-18	AAWW-DELISTED	Stock	48.24	48.46	47.4	47.92	150497.0
2015-02-18	AAXJ	Stock	63.43	63.61	63.16	63.52	365534.0
2015-02-18	AAXN-DELISTED	Stock	26.76	27.1774	26.4	26.98	776159.0
2015-02-18	AB	Stock	27.36	27.53	27.22	27.49	346100.0
2015-02-18	ABAC-DELISTED	Stock	1.7	1.82	1.6101	1.65	2010.0
2015-02-18	ABAX-DELISTED	Stock	60.9	61.355	60.45	60.53	228586.0
2015-02-18	ABB-DELISTED	Stock	21.3	21.3801	21.24	21.325	1252886.0
2015-02-18	ABBNY-DELISTED	Stock	21.3	21.3801	21.24	21.32	1298307.0
2015-02-18	ABBV	Stock	59.15	59.48	58.31	59.24	10781700.0
2015-02-18	ABC-DELISTED	Stock	100.21	100.92	99.61	100.66	1417479.0
2015-02-18	ABCB	Stock	25.87	26.04	25.68	25.82	53100.0
2015-02-18	ABCD-DELISTED	Stock	2.57	2.65	2.5451	2.65	46128.0
2015-02-18	ABCO-DELISTED	Stock	53.51	54.3	53.23	53.73	430627.0
2015-02-18	ABCW-DELISTED	Stock	33.43	35.0	33.43	35.0	28836.0
2015-02-18	ABDC-DELISTED	Stock	13.5098	13.6	13.5	13.51	19993.0
2015-02-18	ABE-DELISTED	Stock	13.32	13.32	13.14	13.22	4233.0
2015-02-18	ABEO	Stock	75.0	82.25	75.0	77.5	444.0
2015-02-18	ABEOW-DELISTED	Stock	1.08	1.08	1.08	1.08	1000.0
2015-02-18	ABEV	Stock	6.44	6.47	6.37	6.43	5003300.0
2015-02-18	ABG	Stock	78.04	78.53	77.77	78.51	248900.0
2015-02-18	ABGB-DELISTED	Stock	16.27	16.46	16.16	16.4	165187.0
2015-02-18	ABIL-DELISTED	Stock	9.82	9.93	9.8	9.88	7900.0

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

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