PREVIEW / stock_daily / 2015-02-19

all stock daily files

  file:    by_date/stock_daily/2015/2015-02-19.parquet
  size:    222 KB
  rows:    6,624
  symbols: 3,505

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-19	AAPL	Stock	32.12	32.2575	32.0825	32.1125	149449600.0
2015-02-19	MSFT	Stock	43.18	43.53	43.05	43.5	27603400.0
2015-02-19	NVDA	Stock	0.56	0.561	0.552	0.5545	169432000.0
2015-02-19	AMZN	Stock	18.6745	19.094	18.6715	18.95	59076000.0
2015-02-19	GOOGL	Stock	27.1235	27.343	27.0375	27.3225	30833380.0
2015-02-19	META	Stock	76.99	79.84	76.95	79.42	45851200.0
2015-02-19	TSLA	Stock	13.6667	14.1627	13.5833	14.114	77311500.0
2015-02-19	TLT	Stock	126.78	127.445	126.17	126.17	8584765.0
2015-02-19	ES	Stock	53.23	53.63	52.06	52.5	1119700.0
2015-02-19	CL	Stock	70.36	70.79	69.92	70.21	3245500.0
2015-02-19	A	Stock	41.4	41.57	41.04	41.15	3737300.0
2015-02-19	AA.B-DELISTED	Stock	51.0	51.13	50.41	51.13	13601.0
2015-02-19	AABA-DELISTED	Stock	43.65	44.42	43.5	44.39	12593657.0
2015-02-19	AAC-DELISTED	Stock	29.58	29.58	29.2228	29.39	8150.0
2015-02-19	AACG	Stock	4.33	4.38	4.16	4.38	7700.0
2015-02-19	AAIC-DELISTED	Stock	24.97	25.1265	24.8475	24.9	277882.0
2015-02-19	AAL	Stock	50.78	50.8	49.59	49.78	11462600.0
2015-02-19	AAMC-DELISTED	Stock	55.8941	60.3235	55.8824	58.6765	22817.0
2015-02-19	AAME	Stock	3.91	3.96	3.83	3.9	8300.0
2015-02-19	AAMI	Stock	16.89	17.43	16.72	17.21	166100.0
2015-02-19	AAOI	Stock	10.12	10.29	10.05	10.21	152900.0
2015-02-19	AAON	Stock	15.44	15.6667	15.44	15.6267	113850.0
2015-02-19	AAP	Stock	153.18	154.95	152.46	153.27	1149700.0
2015-02-19	AAT	Stock	43.3	43.34	42.21	42.35	85600.0
2015-02-19	AAU-DELISTED	Stock	1.1	1.1506	1.1	1.13	101398.0
2015-02-19	AAUAF-DELISTED	Stock	1.1	1.13	1.08	1.13	105926.0
2015-02-19	AAV-DELISTED	Stock	5.25	5.4925	5.14	5.48	167475.0
2015-02-19	AAVL-DELISTED	Stock	39.3	40.82	38.69	39.89	390337.0
2015-02-19	AAWW-DELISTED	Stock	47.97	48.3399	47.384	47.77	119467.0
2015-02-19	AAXJ	Stock	63.42	63.57	63.21	63.35	427546.0
2015-02-19	AAXN-DELISTED	Stock	26.84	27.6409	26.77	27.15	868573.0
2015-02-19	AB	Stock	26.97	27.12	26.71	27.0	336000.0
2015-02-19	ABAC-DELISTED	Stock	1.8	1.809	1.66	1.799	2175.0
2015-02-19	ABAX-DELISTED	Stock	60.54	61.19	60.29	60.32	110308.0
2015-02-19	ABB-DELISTED	Stock	21.28	21.33	21.18	21.19	1319560.0
2015-02-19	ABBNY-DELISTED	Stock	21.28	21.33	21.18	21.2	1387714.0
2015-02-19	ABBV	Stock	58.92	59.08	58.65	59.0	8665500.0
2015-02-19	ABC-DELISTED	Stock	100.52	101.03	100.09	101.01	1264636.0
2015-02-19	ABCB	Stock	25.84	25.99	25.7	25.76	27500.0
2015-02-19	ABCD-DELISTED	Stock	2.7	2.74	2.5924	2.6501	18099.0
2015-02-19	ABCO-DELISTED	Stock	53.38	54.125	52.91	53.48	187510.0
2015-02-19	ABCW-DELISTED	Stock	34.79	34.79	33.67	34.75	18032.0
2015-02-19	ABDC-DELISTED	Stock	13.3648	13.7	13.35	13.69	22024.0
2015-02-19	ABE-DELISTED	Stock	13.05	13.165	13.05	13.08	16608.0
2015-02-19	ABEO	Stock	75.0	80.0	75.0	77.5	860.0
2015-02-19	ABEOW-DELISTED	Stock	1.0	1.08	1.0	1.08	1100.0
2015-02-19	ABEV	Stock	6.4	6.43	6.34	6.37	4326300.0
2015-02-19	ABG	Stock	78.51	79.55	78.09	78.94	181500.0
2015-02-19	ABGB-DELISTED	Stock	16.76	17.0	16.7	16.92	99082.0
2015-02-19	ABM	Stock	30.57	30.71	30.36	30.69	174100.0

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

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