PREVIEW / stock_daily / 2017-08-14

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-14.parquet
  size:    214 KB
  rows:    6,467
  symbols: 2,964

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
2017-08-14	AAPL	Stock	39.83	40.0525	39.6875	39.9625	88490800.0
2017-08-14	MSFT	Stock	73.06	73.72	72.95	73.59	20096600.0
2017-08-14	NVDA	Stock	3.9918	4.2138	3.98	4.21	1279020000.0
2017-08-14	AMZN	Stock	48.9205	49.275	48.8095	49.165	63458000.0
2017-08-14	GOOGL	Stock	46.9535	47.052	46.7243	46.9465	23012240.0
2017-08-14	META	Stock	170.09	171.08	169.29	170.75	12954200.0
2017-08-14	TSLA	Stock	24.3087	24.5107	24.1733	24.2533	67788000.0
2017-08-14	TLT	Stock	125.99	126.275	125.73	125.78	5111040.0
2017-08-14	ES	Stock	61.89	62.25	61.85	62.17	892400.0
2017-08-14	CL	Stock	71.48	71.68	71.27	71.45	3043200.0
2017-08-14	A	Stock	59.8	60.04	59.55	59.62	2409800.0
2017-08-14	AA	Stock	38.11	38.158	37.125	37.19	2129500.0
2017-08-14	AAAP-DELISTED	Stock	49.65	49.94	48.515	49.65	52634.0
2017-08-14	AABA-DELISTED	Stock	58.7	59.02	58.5	58.87	7033249.0
2017-08-14	AAC-DELISTED	Stock	8.75	9.23	8.46	8.99	107529.0
2017-08-14	AACG	Stock	4.79	4.79	4.62	4.77	3400.0
2017-08-14	AAIC-DELISTED	Stock	13.02	13.0899	13.0	13.03	245698.0
2017-08-14	AAL	Stock	48.86	49.17	48.5	48.81	2996500.0
2017-08-14	AAM.A-DELISTED	Stock	26.06	26.06	25.9	26.05	17705.0
2017-08-14	AAMC-DELISTED	Stock	21.6324	21.6324	20.7327	21.6324	5933.0
2017-08-14	AAME	Stock	3.4	3.4	3.25	3.25	1200.0
2017-08-14	AAMI	Stock	13.9	14.03	13.73	13.79	316200.0
2017-08-14	AAOI	Stock	67.82	69.21	66.17	68.92	3258000.0
2017-08-14	AAON	Stock	22.1667	22.5333	22.1667	22.4667	109350.0
2017-08-14	AAP	Stock	107.88	109.81	106.33	109.32	2130200.0
2017-08-14	AAT	Stock	40.0	40.71	40.0	40.67	218500.0
2017-08-14	AAU-DELISTED	Stock	1.1	1.18	1.1	1.12	179319.0
2017-08-14	AAUAF-DELISTED	Stock	1.1	1.18	1.1	1.12	198743.0
2017-08-14	AAV-DELISTED	Stock	6.45	6.55	6.3	6.3	79740.0
2017-08-14	AAWW-DELISTED	Stock	61.3	62.15	61.1	62.1	165782.0
2017-08-14	AAXJ	Stock	70.02	70.21	69.88	70.07	531548.0
2017-08-14	AAXN-DELISTED	Stock	22.56	22.65	22.04	22.18	502742.0
2017-08-14	AB	Stock	23.9	24.25	23.75	24.0	194100.0
2017-08-14	ABAC-DELISTED	Stock	2.2	2.2	2.08	2.08	2900.0
2017-08-14	ABAX-DELISTED	Stock	47.0	47.73	46.94	47.03	78972.0
2017-08-14	ABB-DELISTED	Stock	23.02	23.06	22.93	22.96	1203472.0
2017-08-14	ABBNY-DELISTED	Stock	23.02	23.06	22.93	22.95	1240693.0
2017-08-14	ABBV	Stock	71.23	71.29	70.7	70.82	2648800.0
2017-08-14	ABC-DELISTED	Stock	80.31	80.53	79.66	80.08	1792182.0
2017-08-14	ABCB	Stock	43.5	45.15	43.5	45.1	235200.0
2017-08-14	ABCD-DELISTED	Stock	5.3	5.3	4.99	5.08	70716.0
2017-08-14	ABCO-DELISTED	Stock	52.05	52.175	51.425	51.675	403747.0
2017-08-14	ABDC-DELISTED	Stock	10.71	11.23	10.71	11.18	102793.0
2017-08-14	ABE-DELISTED	Stock	12.76	13.77	12.76	13.66	16357.0
2017-08-14	ABEO	Stock	190.0	191.25	181.25	185.0	14188.0
2017-08-14	ABEV	Stock	6.11	6.2	6.09	6.12	21934100.0
2017-08-14	ABG	Stock	52.6	52.9	51.85	51.9	347600.0
2017-08-14	ABIL-DELISTED	Stock	0.66	0.66	0.6321	0.6415	20708.0
2017-08-14	ABM	Stock	43.62	44.17	43.57	44.16	124300.0
2017-08-14	ABMD-DELISTED	Stock	152.6	154.4	152.41	154.21	133121.0

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

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