PREVIEW / stock_daily / 2017-07-06

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-06.parquet
  size:    214 KB
  rows:    6,432
  symbols: 2,962

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-07-06	AAPL	Stock	35.755	35.875	35.6025	35.6825	96515200.0
2017-07-06	MSFT	Stock	68.27	68.78	68.12	68.57	21117600.0
2017-07-06	NVDA	Stock	3.5468	3.6345	3.494	3.587	746284000.0
2017-07-06	AMZN	Stock	48.233	48.72	47.951	48.257	65192000.0
2017-07-06	GOOGL	Stock	46.25	46.807	45.9925	46.3845	40297100.0
2017-07-06	META	Stock	149.03	150.04	148.0	148.82	14951800.0
2017-07-06	TSLA	Stock	21.1507	21.386	20.42	20.5887	289867500.0
2017-07-06	TLT	Stock	123.52	123.64	122.93	123.46	10853050.0
2017-07-06	ES	Stock	59.91	60.09	59.66	59.99	1334900.0
2017-07-06	CL	Stock	73.68	74.0	73.3	73.45	2854000.0
2017-07-06	A	Stock	59.46	59.77	59.07	59.22	2249500.0
2017-07-06	AA	Stock	33.61	35.38	33.6	33.89	6220900.0
2017-07-06	AAAP-DELISTED	Stock	38.65	38.91	38.185	38.78	90239.0
2017-07-06	AABA-DELISTED	Stock	55.05	55.2	54.41	54.53	5380468.0
2017-07-06	AAC-DELISTED	Stock	6.89	7.05	6.1	6.43	103775.0
2017-07-06	AACG	Stock	4.7	4.7	4.38	4.57	400.0
2017-07-06	AAIC-DELISTED	Stock	13.79	13.89	13.685	13.71	350084.0
2017-07-06	AAL	Stock	50.97	52.58	50.86	52.05	7021400.0
2017-07-06	AAM.A-DELISTED	Stock	25.72	25.82	25.66	25.77	117482.0
2017-07-06	AAMC-DELISTED	Stock	26.3235	27.4126	26.3235	27.0588	19363.0
2017-07-06	AAME	Stock	3.68	3.75	3.67	3.7	1000.0
2017-07-06	AAMI	Stock	14.92	14.96	14.75	14.77	670200.0
2017-07-06	AAOI	Stock	59.7	62.817	59.15	61.47	1540700.0
2017-07-06	AAON	Stock	24.5333	24.8	24.3667	24.4	123450.0
2017-07-06	AAP	Stock	104.48	105.83	102.25	103.16	2718300.0
2017-07-06	AAT	Stock	39.2	39.43	38.79	38.89	175000.0
2017-07-06	AAU-DELISTED	Stock	1.16	1.19	1.16	1.18	123554.0
2017-07-06	AAUAF-DELISTED	Stock	1.16	1.19	1.16	1.18	124848.0
2017-07-06	AAV-DELISTED	Stock	6.6	6.8	6.6	6.65	87645.0
2017-07-06	AAWW-DELISTED	Stock	54.45	55.5	53.55	54.9	424796.0
2017-07-06	AAXJ	Stock	67.08	67.17	66.75	66.77	689731.0
2017-07-06	AAXN-DELISTED	Stock	25.28	25.39	24.94	25.05	469007.0
2017-07-06	AB	Stock	23.5	23.7	23.5	23.55	150300.0
2017-07-06	ABAC-DELISTED	Stock	2.23	2.24	2.18	2.24	620.0
2017-07-06	ABAX-DELISTED	Stock	52.84	52.88	51.99	52.31	74364.0
2017-07-06	ABB-DELISTED	Stock	24.6	24.86	24.59	24.79	1882485.0
2017-07-06	ABBNY-DELISTED	Stock	24.6	24.86	24.59	24.81	1929663.0
2017-07-06	ABBV	Stock	72.24	72.45	71.41	71.73	4372100.0
2017-07-06	ABC-DELISTED	Stock	94.71	95.19	92.24	92.51	768379.0
2017-07-06	ABCB	Stock	49.0	49.75	48.35	48.9	189500.0
2017-07-06	ABCD-DELISTED	Stock	4.99	5.11	4.99	5.08	19118.0
2017-07-06	ABCO-DELISTED	Stock	52.15	59.5	51.525	54.25	1115430.0
2017-07-06	ABDC-DELISTED	Stock	13.46	13.63	13.21	13.28	56041.0
2017-07-06	ABE-DELISTED	Stock	13.74	13.79	13.67	13.79	13429.0
2017-07-06	ABEO	Stock	185.0	201.25	173.75	197.5	38260.0
2017-07-06	ABEOW-DELISTED	Stock	3.64	4.19	3.64	4.12	7060.0
2017-07-06	ABEV	Stock	5.47	5.48	5.33	5.34	37237200.0
2017-07-06	ABG	Stock	56.0	56.4	54.45	54.75	162600.0
2017-07-06	ABIL-DELISTED	Stock	1.26	1.26	1.1	1.14	203671.0
2017-07-06	ABM	Stock	40.97	41.06	40.46	40.54	312300.0

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

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