PREVIEW / stock_daily / 2015-03-11

all stock daily files

  file:    by_date/stock_daily/2015/2015-03-11.parquet
  size:    222 KB
  rows:    6,613
  symbols: 3,500

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-03-11	AAPL	Stock	31.1875	31.1925	30.5275	30.56	275756000.0
2015-03-11	MSFT	Stock	42.31	42.37	41.84	41.98	32215300.0
2015-03-11	NVDA	Stock	0.575	0.5825	0.5705	0.572	262120000.0
2015-03-11	AMZN	Stock	18.5305	18.6675	18.313	18.3185	49902000.0
2015-03-11	GOOGL	Stock	27.99	28.209	27.7705	27.7845	40523160.0
2015-03-11	META	Stock	77.8	78.43	77.26	77.57	20215700.0
2015-03-11	TSLA	Stock	12.7433	13.0787	12.734	12.916	74623500.0
2015-03-11	TLT	Stock	126.26	127.46	126.12	127.2	6663085.0
2015-03-11	ES	Stock	48.95	49.2	48.54	48.82	1102600.0
2015-03-11	CL	Stock	68.27	68.42	67.69	67.89	2643200.0
2015-03-11	A	Stock	40.79	41.13	40.67	40.85	2064400.0
2015-03-11	AA.B-DELISTED	Stock	44.95	45.13	44.55	45.099	54101.0
2015-03-11	AABA-DELISTED	Stock	42.77	42.99	42.36	42.505	9355814.0
2015-03-11	AAC-DELISTED	Stock	25.7	26.04	23.94	24.69	284622.0
2015-03-11	AACG	Stock	3.96	4.19	3.96	4.16	1400.0
2015-03-11	AAIC-DELISTED	Stock	24.69	24.69	24.35	24.55	429299.0
2015-03-11	AAL	Stock	46.9	47.89	46.58	47.39	6630300.0
2015-03-11	AAMC-DELISTED	Stock	60.0941	61.1765	58.5176	59.7059	18282.0
2015-03-11	AAME	Stock	4.02	4.05	3.9	3.92	4600.0
2015-03-11	AAMI	Stock	17.4	17.408	17.18	17.27	64900.0
2015-03-11	AAOI	Stock	12.08	12.43	11.9	12.34	169700.0
2015-03-11	AAON	Stock	14.56	14.6267	14.4	14.5867	158250.0
2015-03-11	AAP	Stock	146.97	147.72	145.61	147.33	703900.0
2015-03-11	AAT	Stock	40.79	41.27	40.42	40.9	224900.0
2015-03-11	AAU-DELISTED	Stock	0.8743	0.9251	0.8336	0.92	349804.0
2015-03-11	AAUAF-DELISTED	Stock	0.86	0.92	0.82	0.92	356926.0
2015-03-11	AAV-DELISTED	Stock	5.11	5.13	5.02	5.09	204985.0
2015-03-11	AAVL-DELISTED	Stock	37.98	39.0	37.26	38.55	274994.0
2015-03-11	AAWW-DELISTED	Stock	44.89	45.47	44.33	45.03	191197.0
2015-03-11	AAXJ	Stock	61.38	61.589	61.35	61.54	966651.0
2015-03-11	AAXN-DELISTED	Stock	21.83	22.25	21.7	22.06	1090378.0
2015-03-11	AB	Stock	28.12	28.29	27.64	28.26	262500.0
2015-03-11	ABAC-DELISTED	Stock	1.43	1.62	1.43	1.54	20574.0
2015-03-11	ABAX-DELISTED	Stock	62.41	62.82	61.63	61.96	133208.0
2015-03-11	ABB-DELISTED	Stock	20.18	20.26	20.095	20.17	1265033.0
2015-03-11	ABBNY-DELISTED	Stock	20.18	20.26	20.095	20.17	1371398.0
2015-03-11	ABBV	Stock	56.19	56.88	55.66	56.62	14629000.0
2015-03-11	ABC-DELISTED	Stock	103.4	104.1	102.95	103.84	1578056.0
2015-03-11	ABCB	Stock	25.42	25.79	25.39	25.76	61500.0
2015-03-11	ABCD-DELISTED	Stock	3.09	3.09	2.95	3.0	52254.0
2015-03-11	ABCO-DELISTED	Stock	51.97	52.95	50.76	52.92	215190.0
2015-03-11	ABCW-DELISTED	Stock	34.08	34.4	33.9	34.15	4736.0
2015-03-11	ABDC-DELISTED	Stock	13.62	13.8	13.51	13.65	15375.0
2015-03-11	ABE-DELISTED	Stock	12.63	12.839	12.44	12.62	33481.0
2015-03-11	ABEO	Stock	86.0	87.25	85.0	87.0	596.0
2015-03-11	ABEOW-DELISTED	Stock	1.0	1.0	1.0	1.0	600.0
2015-03-11	ABEV	Stock	5.66	5.82	5.66	5.81	10795700.0
2015-03-11	ABG	Stock	75.26	75.65	74.92	75.43	205200.0
2015-03-11	ABGB-DELISTED	Stock	16.74	16.76	16.38	16.42	24964.0
2015-03-11	ABM	Stock	29.1	29.45	29.0	29.38	160100.0

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

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