PREVIEW / stock_daily / 2015-05-04

all stock daily files

  file:    by_date/stock_daily/2015/2015-05-04.parquet
  size:    223 KB
  rows:    6,656
  symbols: 3,521

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-05-04	AAPL	Stock	32.375	32.6425	32.065	32.175	203953200.0
2015-05-04	MSFT	Stock	48.37	48.87	48.18	48.24	34039500.0
2015-05-04	NVDA	Stock	0.5682	0.572	0.5635	0.5652	200720000.0
2015-05-04	AMZN	Stock	21.24	21.4885	21.121	21.152	45408000.0
2015-05-04	GOOGL	Stock	27.5495	27.8345	27.3695	27.642	35259040.0
2015-05-04	META	Stock	79.33	79.69	78.63	78.81	14692000.0
2015-05-04	TSLA	Stock	15.212	15.6487	15.1407	15.3673	66519000.0
2015-05-04	TLT	Stock	124.3	124.53	122.72	122.83	9144659.0
2015-05-04	ES	Stock	49.26	49.91	48.97	49.36	1102200.0
2015-05-04	CL	Stock	67.83	68.25	67.71	67.86	2377400.0
2015-05-04	A	Stock	41.88	42.08	41.7	41.94	1073800.0
2015-05-04	AA.B-DELISTED	Stock	47.25	47.48	46.95	46.95	188389.0
2015-05-04	AABA-DELISTED	Stock	42.5	42.55	41.83	42.03	13332566.0
2015-05-04	AAC-DELISTED	Stock	34.73	34.84	32.98	34.14	145569.0
2015-05-04	AACG	Stock	4.42	4.48	4.41	4.42	8400.0
2015-05-04	AAIC-DELISTED	Stock	21.52	21.84	21.5	21.63	308777.0
2015-05-04	AAL	Stock	49.41	50.08	48.8	48.95	5589800.0
2015-05-04	AAMC-DELISTED	Stock	64.2118	66.4912	60.6088	63.6765	56369.0
2015-05-04	AAMI	Stock	19.39	19.745	19.2	19.63	101700.0
2015-05-04	AAOI	Stock	13.58	14.25	13.36	13.67	165600.0
2015-05-04	AAON	Stock	16.12	16.2467	16.0333	16.1467	139350.0
2015-05-04	AAP	Stock	145.25	146.15	144.95	145.45	675100.0
2015-05-04	AAT	Stock	40.44	40.78	40.3	40.47	114900.0
2015-05-04	AAU-DELISTED	Stock	0.8	0.82	0.795	0.81	57431.0
2015-05-04	AAUAF-DELISTED	Stock	0.8	0.82	0.795	0.81	57847.0
2015-05-04	AAV-DELISTED	Stock	6.15	6.199	6.07	6.09	67582.0
2015-05-04	AAVL-DELISTED	Stock	31.7	32.13	29.47	30.9	438464.0
2015-05-04	AAWW-DELISTED	Stock	52.28	54.59	52.105	54.33	893295.0
2015-05-04	AAXJ	Stock	68.69	69.175	68.6	69.1	469636.0
2015-05-04	AAXN-DELISTED	Stock	32.83	34.24	32.18	33.7	5870983.0
2015-05-04	AB	Stock	32.39	32.74	32.05	32.4	638200.0
2015-05-04	ABAC-DELISTED	Stock	1.68	1.68	1.58	1.62	36464.0
2015-05-04	ABAX-DELISTED	Stock	55.48	56.35	55.0005	55.03	274987.0
2015-05-04	ABB-DELISTED	Stock	21.29	21.42	21.28	21.4	1819722.0
2015-05-04	ABBNY-DELISTED	Stock	21.29	21.42	21.28	21.4	2025494.0
2015-05-04	ABBV	Stock	64.32	65.44	64.01	64.68	8493500.0
2015-05-04	ABC-DELISTED	Stock	114.67	116.28	114.51	115.22	1925247.0
2015-05-04	ABCB	Stock	24.86	25.62	24.62	24.85	161500.0
2015-05-04	ABCD-DELISTED	Stock	2.95	3.11	2.92	2.96	19325.0
2015-05-04	ABCO-DELISTED	Stock	51.25	52.26	51.12	51.88	172458.0
2015-05-04	ABCW-DELISTED	Stock	36.27	37.0	36.27	36.91	6291.0
2015-05-04	ABDC-DELISTED	Stock	13.8999	13.9799	13.7	13.83	12994.0
2015-05-04	ABE-DELISTED	Stock	13.2	13.2599	13.16	13.16	5362.0
2015-05-04	ABEO	Stock	70.5	73.75	69.75	71.5	21624.0
2015-05-04	ABEOW-DELISTED	Stock	1.35	1.35	1.35	1.35	200.0
2015-05-04	ABEV	Stock	6.28	6.33	6.24	6.27	6525900.0
2015-05-04	ABG	Stock	85.12	85.8	84.93	85.33	286600.0
2015-05-04	ABGB-DELISTED	Stock	16.1	16.27	16.1	16.2195	14870.0
2015-05-04	ABM	Stock	32.25	32.58	32.17	32.32	208800.0
2015-05-04	ABMD-DELISTED	Stock	64.15	65.5	63.58	65.14	441783.0

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

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