PREVIEW / stock_daily / 2015-06-18

all stock daily files

  file:    by_date/stock_daily/2015/2015-06-18.parquet
  size:    225 KB
  rows:    6,688
  symbols: 3,520

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-06-18	AAPL	Stock	31.8075	32.0775	31.805	31.97	141628800.0
2015-06-18	MSFT	Stock	46.22	46.8	46.17	46.72	32658300.0
2015-06-18	NVDA	Stock	0.544	0.552	0.5425	0.5485	299404000.0
2015-06-18	AMZN	Stock	21.515	21.9865	21.4705	21.9695	67568000.0
2015-06-18	GOOGL	Stock	27.4	27.8625	27.4	27.809	41192060.0
2015-06-18	META	Stock	81.64	83.19	81.57	82.91	26782600.0
2015-06-18	TSLA	Stock	17.4667	17.564	17.3347	17.4593	41740500.0
2015-06-18	TLT	Stock	117.37	117.74	116.75	117.57	10123276.0
2015-06-18	ES	Stock	46.93	47.71	46.84	47.29	1518200.0
2015-06-18	CL	Stock	66.59	67.53	66.57	67.17	4435100.0
2015-06-18	A	Stock	39.8	40.06	39.72	39.9	1865000.0
2015-06-18	AA.B-DELISTED	Stock	42.9	42.95	42.0	42.0	210181.0
2015-06-18	AABA-DELISTED	Stock	41.04	41.27	40.79	40.92	9606530.0
2015-06-18	AAC-DELISTED	Stock	43.42	43.85	43.25	43.66	148397.0
2015-06-18	AACG	Stock	5.8	5.92	5.6	5.84	24900.0
2015-06-18	AAIC-DELISTED	Stock	20.93	21.21	20.89	21.11	422234.0
2015-06-18	AAL	Stock	39.8	40.22	39.61	39.98	10647000.0
2015-06-18	AAMC-DELISTED	Stock	44.25	45.0794	43.4676	45.0794	11482.0
2015-06-18	AAME	Stock	3.6	3.73	3.51	3.68	8500.0
2015-06-18	AAMI	Stock	17.67	18.02	17.59	17.93	1060900.0
2015-06-18	AAOI	Stock	18.76	19.1	18.59	18.99	267500.0
2015-06-18	AAON	Stock	15.62	15.8067	15.5867	15.68	173850.0
2015-06-18	AAP	Stock	159.67	160.78	159.13	160.25	470700.0
2015-06-18	AAT	Stock	40.25	41.38	39.97	41.29	367600.0
2015-06-18	AAU-DELISTED	Stock	0.883	0.883	0.8596	0.87	88211.0
2015-06-18	AAUAF-DELISTED	Stock	0.883	0.883	0.8596	0.8677	89851.0
2015-06-18	AAV-DELISTED	Stock	6.3	6.37	6.195	6.28	41685.0
2015-06-18	AAVL-DELISTED	Stock	16.89	17.16	16.03	16.08	2339669.0
2015-06-18	AAWW-DELISTED	Stock	53.54	55.77	53.51	55.03	437904.0
2015-06-18	AAXJ	Stock	64.28	64.62	64.04	64.46	789737.0
2015-06-18	AAXN-DELISTED	Stock	35.27	35.79	34.81	34.95	2655849.0
2015-06-18	AB	Stock	30.8	31.15	30.6	30.88	124000.0
2015-06-18	ABAC-DELISTED	Stock	1.4	1.4	1.39	1.3999	7300.0
2015-06-18	ABAX-DELISTED	Stock	51.78	52.37	51.66	52.0	219663.0
2015-06-18	ABB-DELISTED	Stock	21.98	22.305	21.97	22.15	2041081.0
2015-06-18	ABBNY-DELISTED	Stock	21.98	22.305	21.97	22.14	2360602.0
2015-06-18	ABBV	Stock	67.79	69.07	67.79	68.98	9079000.0
2015-06-18	ABC-DELISTED	Stock	111.5	112.63	110.72	111.92	1121529.0
2015-06-18	ABCB	Stock	25.76	26.0	25.6	25.85	91600.0
2015-06-18	ABCD-DELISTED	Stock	4.17	4.3	4.1675	4.21	68958.0
2015-06-18	ABCO-DELISTED	Stock	53.16	53.99	51.826	53.42	201045.0
2015-06-18	ABCW-DELISTED	Stock	36.98	37.1	36.96	37.0299	28342.0
2015-06-18	ABDC-DELISTED	Stock	13.75	13.88	13.68	13.7	47579.0
2015-06-18	ABE-DELISTED	Stock	12.86	12.95	12.86	12.88	1740.0
2015-06-18	ABEO	Stock	172.5	173.5	162.25	163.25	48412.0
2015-06-18	ABEOW-DELISTED	Stock	2.42	2.48	2.31	2.44	10000.0
2015-06-18	ABEV	Stock	6.09	6.19	6.07	6.14	10649900.0
2015-06-18	ABG	Stock	88.51	88.94	87.78	87.94	339100.0
2015-06-18	ABGB-DELISTED	Stock	16.2752	16.54	16.27	16.39	6052.0
2015-06-18	ABM	Stock	32.95	33.39	32.92	33.28	198400.0

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

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