PREVIEW / stock_daily / 2015-04-14

all stock daily files

  file:    by_date/stock_daily/2015/2015-04-14.parquet
  size:    223 KB
  rows:    6,645
  symbols: 3,514

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-04-14	AAPL	Stock	31.75	31.8225	31.4775	31.575	102098400.0
2015-04-14	MSFT	Stock	41.8	42.03	41.39	41.65	24244400.0
2015-04-14	NVDA	Stock	0.5615	0.5638	0.5535	0.559	220276000.0
2015-04-14	AMZN	Stock	19.1755	19.3905	19.0605	19.2555	51672000.0
2015-04-14	GOOGL	Stock	27.3285	27.3285	26.787	26.989	47206580.0
2015-04-14	META	Stock	83.17	83.69	82.44	83.52	19634200.0
2015-04-14	TSLA	Stock	13.9047	13.966	13.7	13.8307	45390000.0
2015-04-14	TLT	Stock	131.31	131.86	130.48	130.72	6075465.0
2015-04-14	ES	Stock	49.98	50.33	49.69	50.23	940800.0
2015-04-14	CL	Stock	69.04	70.02	69.0	69.63	2468600.0
2015-04-14	A	Stock	42.96	43.2	42.58	43.07	1777700.0
2015-04-14	AA.B-DELISTED	Stock	45.08	45.35	45.0	45.28	48549.0
2015-04-14	AABA-DELISTED	Stock	44.82	45.6399	44.79	45.53	11599574.0
2015-04-14	AAC-DELISTED	Stock	31.27	31.4	30.78	31.09	143759.0
2015-04-14	AACG	Stock	4.56	4.56	4.45	4.5	8500.0
2015-04-14	AAIC-DELISTED	Stock	24.04	24.2	24.0	24.12	181284.0
2015-04-14	AAL	Stock	47.49	47.78	46.88	47.42	9878400.0
2015-04-14	AAMC-DELISTED	Stock	66.4735	67.0588	65.2412	67.0588	12845.0
2015-04-14	AAMI	Stock	18.96	19.11	18.81	18.93	121500.0
2015-04-14	AAOI	Stock	13.24	13.46	12.75	13.02	529500.0
2015-04-14	AAON	Stock	15.8933	16.2467	15.7733	16.12	109650.0
2015-04-14	AAP	Stock	148.77	150.19	147.63	149.05	731700.0
2015-04-14	AAT	Stock	41.81	41.89	41.55	41.64	115800.0
2015-04-14	AAU-DELISTED	Stock	0.79	0.8015	0.79	0.8	79141.0
2015-04-14	AAUAF-DELISTED	Stock	0.79	0.8015	0.79	0.8	80348.0
2015-04-14	AAV-DELISTED	Stock	5.71	5.78	5.67	5.76	85963.0
2015-04-14	AAVL-DELISTED	Stock	39.39	40.72	39.16	40.06	282906.0
2015-04-14	AAWW-DELISTED	Stock	44.81	45.1	44.23	44.67	269592.0
2015-04-14	AAXJ	Stock	68.23	68.44	67.99	68.28	1363629.0
2015-04-14	AAXN-DELISTED	Stock	27.15	27.58	26.6	26.84	1148890.0
2015-04-14	AB	Stock	31.1	32.0	31.0	31.74	307900.0
2015-04-14	ABAX-DELISTED	Stock	64.56	64.64	63.8125	64.39	126875.0
2015-04-14	ABB-DELISTED	Stock	21.74	21.84	21.695	21.8	1415071.0
2015-04-14	ABBNY-DELISTED	Stock	21.74	21.84	21.695	21.8	1598949.0
2015-04-14	ABBV	Stock	61.4	61.81	60.51	61.72	13071400.0
2015-04-14	ABC-DELISTED	Stock	114.34	114.45	112.7	114.0	866049.0
2015-04-14	ABCB	Stock	26.81	26.81	26.39	26.47	47500.0
2015-04-14	ABCD-DELISTED	Stock	2.97	3.0299	2.9	2.99	17133.0
2015-04-14	ABCO-DELISTED	Stock	53.54	53.635	51.2	52.66	325544.0
2015-04-14	ABCW-DELISTED	Stock	34.61	34.65	34.2001	34.26	9719.0
2015-04-14	ABDC-DELISTED	Stock	14.1	14.24	13.83	13.96	32530.0
2015-04-14	ABE-DELISTED	Stock	13.24	13.2576	13.18	13.2576	9384.0
2015-04-14	ABEO	Stock	85.0	86.0	82.0	84.0	1776.0
2015-04-14	ABEOW-DELISTED	Stock	1.09	1.09	1.09	1.09	250.0
2015-04-14	ABEV	Stock	6.28	6.31	6.23	6.25	9979200.0
2015-04-14	ABG	Stock	85.17	86.05	84.43	85.45	361900.0
2015-04-14	ABGB-DELISTED	Stock	17.39	17.56	17.14	17.28	125906.0
2015-04-14	ABIL-DELISTED	Stock	9.96	10.08	9.96	10.0	11640.0
2015-04-14	ABM	Stock	31.97	32.13	31.74	32.04	193600.0
2015-04-14	ABMD-DELISTED	Stock	67.85	68.42	66.98	67.46	401563.0

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

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