PREVIEW / stock_daily / 2018-04-17

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-17.parquet
  size:    216 KB
  rows:    6,478
  symbols: 2,821

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-04-17	AAPL	Stock	44.1225	44.735	44.1025	44.56	106421600.0
2018-04-17	MSFT	Stock	95.0	96.54	94.88	96.07	26771000.0
2018-04-17	NVDA	Stock	5.84	5.96	5.7838	5.9385	447224000.0
2018-04-17	AMZN	Stock	73.115	75.3595	72.851	75.1915	102288000.0
2018-04-17	GOOGL	Stock	53.06	54.25	52.8545	53.968	54583940.0
2018-04-17	META	Stock	165.83	169.0	165.66	168.66	22743000.0
2018-04-17	TSLA	Stock	19.258	19.478	18.834	19.1793	105000000.0
2018-04-17	TLT	Stock	120.92	121.58	120.82	121.27	5590360.0
2018-04-17	ES	Stock	59.74	60.45	59.61	60.24	1738700.0
2018-04-17	CL	Stock	72.51	72.53	71.84	72.23	3307300.0
2018-04-17	A	Stock	68.6	68.85	68.07	68.44	2682600.0
2018-04-17	AA	Stock	55.37	57.488	54.76	57.08	6077400.0
2018-04-17	AABA-DELISTED	Stock	70.29	71.49	70.17	71.13	3089306.0
2018-04-17	AAC-DELISTED	Stock	11.12	11.31	10.86	11.17	38727.0
2018-04-17	AACG	Stock	5.32	5.38	5.3	5.34	1500.0
2018-04-17	AAIC-DELISTED	Stock	11.2	11.31	11.18	11.28	339235.0
2018-04-17	AAL	Stock	46.75	47.03	45.62	45.75	6961100.0
2018-04-17	AAM.A-DELISTED	Stock	24.7	24.7	24.62	24.65	31863.0
2018-04-17	AAM.B-DELISTED	Stock	24.6655	24.7	24.57	24.59	113004.0
2018-04-17	AAMC-DELISTED	Stock	17.8529	17.8529	17.8529	17.8529	2081.0
2018-04-17	AAME	Stock	3.1	3.1	3.1	3.1	2900.0
2018-04-17	AAMI	Stock	14.84	15.03	14.74	14.96	588200.0
2018-04-17	AAOI	Stock	30.09	30.116	28.29	28.33	1217400.0
2018-04-17	AAON	Stock	23.6333	23.9333	23.2	23.8667	224550.0
2018-04-17	AAP	Stock	108.75	109.93	106.78	108.2	1254300.0
2018-04-17	AAT	Stock	34.03	34.54	33.84	34.1	242400.0
2018-04-17	AAU-DELISTED	Stock	0.83	0.83	0.8	0.8173	56983.0
2018-04-17	AAUAF-DELISTED	Stock	0.83	0.83	0.8	0.8173	58818.0
2018-04-17	AAV-DELISTED	Stock	3.15	3.25	3.06	3.2	177383.0
2018-04-17	AAWW-DELISTED	Stock	64.9	64.9	61.7	63.2	299487.0
2018-04-17	AAXJ	Stock	76.6	77.2	76.56	76.98	852034.0
2018-04-17	AAXN-DELISTED	Stock	43.06	43.84	42.97	43.0	858577.0
2018-04-17	AB	Stock	27.0	27.05	26.45	26.65	264300.0
2018-04-17	ABAC-DELISTED	Stock	2.51	2.63	2.51	2.56	1526.0
2018-04-17	ABAX-DELISTED	Stock	74.21	74.85	72.71	73.86	114945.0
2018-04-17	ABB-DELISTED	Stock	23.25	23.365	23.205	23.29	1959650.0
2018-04-17	ABBNY-DELISTED	Stock	23.25	23.365	23.205	23.29	2186358.0
2018-04-17	ABBV	Stock	93.2	94.01	92.62	93.59	4474700.0
2018-04-17	ABC-DELISTED	Stock	89.5	91.39	89.44	91.03	2560757.0
2018-04-17	ABCB	Stock	52.8	52.95	51.5	51.8	215400.0
2018-04-17	ABCD-DELISTED	Stock	12.5	12.889	12.3402	12.66	416296.0
2018-04-17	ABDC-DELISTED	Stock	6.7	6.86	6.7	6.83	16456.0
2018-04-17	ABE-DELISTED	Stock	14.91	15.0	14.91	14.9798	14764.0
2018-04-17	ABEO	Stock	493.75	503.75	478.25	482.5	69976.0
2018-04-17	ABEOW-DELISTED	Stock	14.85	14.85	14.55	14.75	490.0
2018-04-17	ABEV	Stock	6.71	6.79	6.64	6.76	29688900.0
2018-04-17	ABG	Stock	68.6	69.25	68.3	69.05	146900.0
2018-04-17	ABIL-DELISTED	Stock	3.35	3.39	2.98	3.12	10177.0
2018-04-17	ABLX-DELISTED	Stock	55.07	55.07	54.88	54.9	16891.0
2018-04-17	ABM	Stock	32.73	32.77	32.34	32.47	503400.0

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

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