PREVIEW / stock_daily / 2015-04-21

all stock daily files

  file:    by_date/stock_daily/2015/2015-04-21.parquet
  size:    223 KB
  rows:    6,621
  symbols: 3,495

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-21	AAPL	Stock	32.025	32.05	31.6675	31.7275	129740400.0
2015-04-21	MSFT	Stock	43.0	43.15	42.53	42.64	26013800.0
2015-04-21	NVDA	Stock	0.559	0.559	0.5488	0.5515	230456000.0
2015-04-21	AMZN	Stock	19.5655	19.73	19.34	19.559	92870000.0
2015-04-21	GOOGL	Stock	27.3155	27.3887	27.1105	27.1462	29127740.0
2015-04-21	META	Stock	84.0	84.49	83.54	83.62	27171900.0
2015-04-21	TSLA	Stock	13.72	14.05	13.6207	13.9607	51487500.0
2015-04-21	TLT	Stock	130.23	130.45	129.56	129.7	4563763.0
2015-04-21	ES	Stock	49.77	50.85	49.37	49.61	2150400.0
2015-04-21	CL	Stock	68.64	69.33	68.64	69.01	2934100.0
2015-04-21	A	Stock	43.42	43.5	42.87	42.89	1719700.0
2015-04-21	AA.B-DELISTED	Stock	46.0	46.0	45.39	45.74	60845.0
2015-04-21	AABA-DELISTED	Stock	45.08	45.18	44.45	44.48	17885503.0
2015-04-21	AAC-DELISTED	Stock	33.14	33.35	32.68	33.1	61009.0
2015-04-21	AACG	Stock	4.59	4.59	4.45	4.56	6800.0
2015-04-21	AAIC-DELISTED	Stock	24.01	24.1	23.93	23.95	271546.0
2015-04-21	AAL	Stock	50.0	51.42	49.46	51.36	10850300.0
2015-04-21	AAMC-DELISTED	Stock	66.1794	69.2412	66.1794	66.8824	55495.0
2015-04-21	AAME	Stock	3.91	3.96	3.91	3.96	700.0
2015-04-21	AAMI	Stock	18.93	19.05	18.83	18.94	120400.0
2015-04-21	AAOI	Stock	14.88	14.97	14.72	14.97	197000.0
2015-04-21	AAON	Stock	16.26	16.3467	16.0733	16.24	129900.0
2015-04-21	AAP	Stock	153.28	154.66	152.18	152.4	898800.0
2015-04-21	AAT	Stock	41.23	41.62	41.19	41.29	123100.0
2015-04-21	AAU-DELISTED	Stock	0.8324	0.84	0.8169	0.8276	54091.0
2015-04-21	AAUAF-DELISTED	Stock	0.8249	0.83	0.8095	0.83	55216.0
2015-04-21	AAV-DELISTED	Stock	6.13	6.15	6.01	6.06	184142.0
2015-04-21	AAVL-DELISTED	Stock	39.87	39.87	39.02	39.26	196420.0
2015-04-21	AAWW-DELISTED	Stock	44.06	44.17	43.243	43.8	105644.0
2015-04-21	AAXJ	Stock	68.6	68.76	68.38	68.43	1119352.0
2015-04-21	AAXN-DELISTED	Stock	29.96	30.0	28.74	29.5	2931499.0
2015-04-21	AB	Stock	31.7	31.72	31.18	31.27	158600.0
2015-04-21	ABAC-DELISTED	Stock	1.7684	1.7684	1.72	1.76	4242.0
2015-04-21	ABAX-DELISTED	Stock	62.92	63.5	62.92	63.32	75205.0
2015-04-21	ABB-DELISTED	Stock	22.1	22.19	21.96	22.08	1427972.0
2015-04-21	ABBNY-DELISTED	Stock	22.1	22.19	21.96	22.07	1694642.0
2015-04-21	ABBV	Stock	63.89	64.24	63.27	63.61	8457300.0
2015-04-21	ABC-DELISTED	Stock	113.89	114.49	113.24	113.89	1042835.0
2015-04-21	ABCB	Stock	25.7	26.24	25.65	25.76	51200.0
2015-04-21	ABCD-DELISTED	Stock	3.2	3.215	3.05	3.1	136669.0
2015-04-21	ABCO-DELISTED	Stock	52.42	53.03	52.05	52.08	196957.0
2015-04-21	ABCW-DELISTED	Stock	34.3	34.4	33.985	34.05	12752.0
2015-04-21	ABDC-DELISTED	Stock	13.9	13.91	13.76	13.89	27659.0
2015-04-21	ABE-DELISTED	Stock	13.3	13.36	13.2701	13.36	2468.0
2015-04-21	ABEO	Stock	81.25	81.25	77.75	79.25	2848.0
2015-04-21	ABEOW-DELISTED	Stock	1.02	1.26	0.85	1.25	28056.0
2015-04-21	ABEV	Stock	6.2	6.26	6.17	6.23	9691900.0
2015-04-21	ABG	Stock	89.74	89.97	85.57	87.13	422000.0
2015-04-21	ABGB-DELISTED	Stock	16.63	16.74	16.541	16.67	27373.0
2015-04-21	ABM	Stock	31.53	32.12	31.37	32.02	173700.0

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

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