PREVIEW / stock_daily / 2018-02-16

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-16.parquet
  size:    217 KB
  rows:    6,484
  symbols: 2,861

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
2018-02-16	AAPL	Stock	43.09	43.705	42.9425	43.1075	160704400.0
2018-02-16	MSFT	Stock	92.45	93.5	91.8	92.0	30596900.0
2018-02-16	NVDA	Stock	6.135	6.25	6.0868	6.096	637656000.0
2018-02-16	AMZN	Stock	72.8685	73.29	72.328	72.4345	89452000.0
2018-02-16	GOOGL	Stock	54.669	55.4155	54.5775	54.775	39948100.0
2018-02-16	META	Stock	178.99	179.88	176.3	177.36	20645300.0
2018-02-16	TSLA	Stock	22.1667	22.8747	22.1093	22.366	84639000.0
2018-02-16	TLT	Stock	119.04	119.21	118.34	118.71	8454089.0
2018-02-16	ES	Stock	58.47	59.38	58.47	59.12	1509700.0
2018-02-16	CL	Stock	70.94	71.84	70.81	71.46	4421700.0
2018-02-16	A	Stock	71.97	72.7	71.62	71.97	2887100.0
2018-02-16	AA	Stock	47.5	50.18	46.52	47.36	8372200.0
2018-02-16	AABA-DELISTED	Stock	74.37	74.98	73.3	73.51	6300571.0
2018-02-16	AAC-DELISTED	Stock	8.33	8.49	8.29	8.31	47060.0
2018-02-16	AACG	Stock	5.25	5.55	5.2	5.35	11700.0
2018-02-16	AAIC-DELISTED	Stock	11.26	11.47	11.25	11.42	552596.0
2018-02-16	AAL	Stock	51.8	52.21	51.53	51.58	3891300.0
2018-02-16	AAM.A-DELISTED	Stock	25.25	25.4	25.25	25.34	35533.0
2018-02-16	AAME	Stock	3.45	3.9	3.45	3.5	7900.0
2018-02-16	AAMI	Stock	15.68	15.94	15.64	15.78	859500.0
2018-02-16	AAOI	Stock	31.63	32.2	30.59	31.99	1267400.0
2018-02-16	AAON	Stock	22.9667	23.6667	22.9667	23.3667	148500.0
2018-02-16	AAP	Stock	108.72	109.34	105.78	107.57	946700.0
2018-02-16	AAT	Stock	32.12	32.73	32.12	32.53	475100.0
2018-02-16	AAU-DELISTED	Stock	0.96	0.966	0.9203	0.9525	181480.0
2018-02-16	AAUAF-DELISTED	Stock	0.96	0.966	0.9203	0.9551	190720.0
2018-02-16	AAV-DELISTED	Stock	2.95	3.0	2.9	2.975	167017.0
2018-02-16	AAWW-DELISTED	Stock	55.35	56.75	55.25	55.35	213946.0
2018-02-16	AAXJ	Stock	78.88	79.61	78.7	78.93	658847.0
2018-02-16	AAXN-DELISTED	Stock	28.4	29.0	28.4	28.73	668618.0
2018-02-16	AB	Stock	27.05	27.45	26.8	27.35	527000.0
2018-02-16	ABAC-DELISTED	Stock	2.12	2.238	2.05	2.15	18512.0
2018-02-16	ABAX-DELISTED	Stock	68.76	69.98	68.76	69.0501	83741.0
2018-02-16	ABB-DELISTED	Stock	25.3	25.6	25.29	25.41	1894230.0
2018-02-16	ABBNY-DELISTED	Stock	25.3	25.6	25.29	25.42	3014585.0
2018-02-16	ABBV	Stock	115.23	119.2	115.2	118.6	8717000.0
2018-02-16	ABC-DELISTED	Stock	96.73	100.055	96.55	99.4	2541482.0
2018-02-16	ABCB	Stock	53.9	55.2	53.9	54.65	210700.0
2018-02-16	ABCD-DELISTED	Stock	7.56	7.6	6.88	7.13	54517.0
2018-02-16	ABDC-DELISTED	Stock	7.43	7.6	7.4	7.55	27243.0
2018-02-16	ABE-DELISTED	Stock	15.11	15.2101	15.1	15.2101	1762.0
2018-02-16	ABEO	Stock	296.25	330.0	290.0	312.5	63008.0
2018-02-16	ABEOW-DELISTED	Stock	7.65	8.349	7.64	8.3	5400.0
2018-02-16	ABEV	Stock	6.77	6.96	6.77	6.9	17444100.0
2018-02-16	ABG	Stock	68.35	69.6	68.1	68.8	143200.0
2018-02-16	ABIL-DELISTED	Stock	0.3906	0.3999	0.3601	0.3601	89064.0
2018-02-16	ABLX-DELISTED	Stock	54.45	54.58	54.21	54.28	23784.0
2018-02-16	ABM	Stock	36.3	37.06	36.21	36.62	762900.0
2018-02-16	ABMD-DELISTED	Stock	260.43	268.72	260.01	267.755	333230.0
2018-02-16	ABR	Stock	8.3	8.45	8.3	8.43	407400.0

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

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