PREVIEW / stock_daily / 2017-10-25

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-25.parquet
  size:    215 KB
  rows:    6,433
  symbols: 2,896

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-10-25	AAPL	Stock	39.2275	39.3875	38.8175	39.1025	84828400.0
2017-10-25	MSFT	Stock	78.58	79.1	78.01	78.63	20410800.0
2017-10-25	NVDA	Stock	4.927	4.9805	4.7792	4.8415	828160000.0
2017-10-25	AMZN	Stock	48.9	49.222	48.312	48.6455	60662000.0
2017-10-25	GOOGL	Stock	49.3135	49.7215	48.8861	49.573	30574200.0
2017-10-25	META	Stock	171.9	172.25	168.89	170.6	15868200.0
2017-10-25	TSLA	Stock	22.4467	22.5	21.5707	21.7227	128911500.0
2017-10-25	TLT	Stock	122.53	122.98	122.42	122.84	9961406.0
2017-10-25	ES	Stock	62.15	62.36	61.59	62.33	2062600.0
2017-10-25	CL	Stock	71.73	71.82	70.74	71.42	3944700.0
2017-10-25	A	Stock	67.9	68.52	67.03	67.39	1795000.0
2017-10-25	AA	Stock	49.73	49.88	48.51	49.52	3750700.0
2017-10-25	AAAP-DELISTED	Stock	74.99	76.49	73.5	73.89	229196.0
2017-10-25	AABA-DELISTED	Stock	66.66	67.04	65.19	65.39	3690461.0
2017-10-25	AAC-DELISTED	Stock	8.41	8.42	8.11	8.29	32177.0
2017-10-25	AACG	Stock	4.64	4.64	4.59	4.59	8300.0
2017-10-25	AAIC-DELISTED	Stock	12.65	12.65	11.4	11.83	2080652.0
2017-10-25	AAL	Stock	51.78	51.78	50.61	51.02	4658300.0
2017-10-25	AAM.A-DELISTED	Stock	26.1214	26.1999	26.0	26.1	42847.0
2017-10-25	AAMC-DELISTED	Stock	24.7353	24.7353	24.2794	24.4118	6202.0
2017-10-25	AAME	Stock	3.25	3.25	3.04	3.1	12500.0
2017-10-25	AAMI	Stock	15.6	15.6	15.33	15.39	333400.0
2017-10-25	AAOI	Stock	41.51	41.98	39.6	40.43	2321800.0
2017-10-25	AAON	Stock	23.4333	23.6867	22.9667	23.2667	177000.0
2017-10-25	AAP	Stock	83.71	84.06	81.82	83.31	2052700.0
2017-10-25	AAT	Stock	39.33	39.55	38.98	39.2	180600.0
2017-10-25	AAU-DELISTED	Stock	1.11	1.125	1.06	1.065	194799.0
2017-10-25	AAUAF-DELISTED	Stock	1.11	1.125	1.06	1.065	199356.0
2017-10-25	AAV-DELISTED	Stock	5.45	5.45	5.255	5.3	72196.0
2017-10-25	AAWW-DELISTED	Stock	63.6	63.6	62.35	63.05	112027.0
2017-10-25	AAXJ	Stock	74.74	74.81	73.83	74.24	2812919.0
2017-10-25	AAXN-DELISTED	Stock	22.14	22.46	22.09	22.17	679696.0
2017-10-25	AB	Stock	25.6	25.8	25.31	25.75	238600.0
2017-10-25	ABAC-DELISTED	Stock	3.41	3.43	3.35	3.35	4486.0
2017-10-25	ABAX-DELISTED	Stock	50.0	51.74	47.92	49.85	246846.0
2017-10-25	ABB-DELISTED	Stock	25.17	25.23	24.95	25.02	1315605.0
2017-10-25	ABBNY-DELISTED	Stock	25.17	25.23	24.95	25.03	1370146.0
2017-10-25	ABBV	Stock	91.78	92.08	90.73	91.77	6924800.0
2017-10-25	ABC-DELISTED	Stock	82.0	82.52	81.41	82.22	1223395.0
2017-10-25	ABCB	Stock	48.85	48.85	48.15	48.4	186600.0
2017-10-25	ABCD-DELISTED	Stock	6.16	6.26	5.78	5.99	104412.0
2017-10-25	ABCO-DELISTED	Stock	53.8	54.0	53.7	53.9	379008.0
2017-10-25	ABDC-DELISTED	Stock	10.01	10.1284	9.93	10.1	38399.0
2017-10-25	ABE-DELISTED	Stock	14.59	14.59	14.45	14.4775	4622.0
2017-10-25	ABEO	Stock	445.0	465.0	438.75	450.0	27848.0
2017-10-25	ABEOW-DELISTED	Stock	13.5	13.5	12.57	12.96	10600.0
2017-10-25	ABEV	Stock	6.53	6.54	6.35	6.48	24722800.0
2017-10-25	ABG	Stock	57.2	59.85	56.48	59.05	229700.0
2017-10-25	ABIL-DELISTED	Stock	0.659	0.6675	0.65	0.6505	65644.0
2017-10-25	ABLX-DELISTED	Stock	17.85	23.66	17.75	22.51	2853845.0

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

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