PREVIEW / stock_daily / 2018-01-03

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-03.parquet
  size:    218 KB
  rows:    6,492
  symbols: 2,873

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-01-03	AAPL	Stock	43.1325	43.6375	42.99	43.0575	118071600.0
2018-01-03	MSFT	Stock	86.06	86.51	85.97	86.35	26061400.0
2018-01-03	NVDA	Stock	5.1025	5.3425	5.0938	5.3118	914704000.0
2018-01-03	AMZN	Stock	59.415	60.2745	59.415	60.21	62176000.0
2018-01-03	GOOGL	Stock	53.6965	54.805	53.6715	54.576	31318900.0
2018-01-03	META	Stock	181.88	184.78	181.33	184.67	16886600.0
2018-01-03	TSLA	Stock	21.4	21.6833	21.0367	21.15	67822500.0
2018-01-03	TLT	Stock	126.0	126.2	125.49	126.09	8605121.0
2018-01-03	ES	Stock	62.94	63.35	62.3	62.59	2311800.0
2018-01-03	CL	Stock	75.11	75.72	74.66	74.85	3310000.0
2018-01-03	A	Stock	67.62	69.49	67.6	69.32	1698900.0
2018-01-03	AA	Stock	54.92	55.15	52.96	54.5	4100000.0
2018-01-03	AAAP-DELISTED	Stock	81.76	81.79	81.7	81.77	74984.0
2018-01-03	AABA-DELISTED	Stock	73.5	73.86	72.77	73.79	5846698.0
2018-01-03	AAC-DELISTED	Stock	9.2	9.3	9.02	9.25	115314.0
2018-01-03	AACG	Stock	5.33	5.34	5.15	5.34	3000.0
2018-01-03	AAIC-DELISTED	Stock	11.8	11.88	11.65	11.67	511547.0
2018-01-03	AAL	Stock	52.86	52.86	52.06	52.34	5074900.0
2018-01-03	AAM.A-DELISTED	Stock	26.1721	26.1819	25.6	26.1	31376.0
2018-01-03	AAMC-DELISTED	Stock	22.9265	22.9265	22.9265	22.9265	751.0
2018-01-03	AAME	Stock	3.49	3.49	3.25	3.35	24300.0
2018-01-03	AAMI	Stock	16.8	16.98	16.65	16.88	547000.0
2018-01-03	AAOI	Stock	38.27	38.34	37.42	37.89	1037800.0
2018-01-03	AAON	Stock	24.6333	25.2667	24.5	25.0667	244950.0
2018-01-03	AAP	Stock	106.42	107.66	105.3	107.05	2086800.0
2018-01-03	AAT	Stock	38.19	38.28	37.79	37.82	153800.0
2018-01-03	AAU-DELISTED	Stock	1.04	1.04	1.0	1.0	181694.0
2018-01-03	AAUAF-DELISTED	Stock	1.04	1.04	1.0	1.0	224189.0
2018-01-03	AAV-DELISTED	Stock	4.5	4.575	4.3	4.325	190925.0
2018-01-03	AAWW-DELISTED	Stock	58.0	58.85	57.705	58.3	126011.0
2018-01-03	AAXJ	Stock	78.21	78.58	78.18	78.56	637092.0
2018-01-03	AAXN-DELISTED	Stock	26.45	26.79	26.08	26.76	539080.0
2018-01-03	AB	Stock	25.15	25.5	25.05	25.45	218200.0
2018-01-03	ABAC-DELISTED	Stock	2.81	3.028	2.81	2.91	5152.0
2018-01-03	ABAX-DELISTED	Stock	50.07	50.22	49.37	49.52	78810.0
2018-01-03	ABB-DELISTED	Stock	26.92	27.24	26.903	27.205	1892519.0
2018-01-03	ABBNY-DELISTED	Stock	26.92	27.24	26.903	27.22	2692931.0
2018-01-03	ABBV	Stock	98.55	100.1	98.04	99.95	4702300.0
2018-01-03	ABC-DELISTED	Stock	93.4	94.73	92.47	94.42	873604.0
2018-01-03	ABCB	Stock	48.5	48.95	48.05	48.75	206900.0
2018-01-03	ABCD-DELISTED	Stock	5.59	6.05	5.59	6.02	129269.0
2018-01-03	ABDC-DELISTED	Stock	8.58	8.69	8.4156	8.56	89999.0
2018-01-03	ABE-DELISTED	Stock	14.69	14.929	14.67	14.882	4915.0
2018-01-03	ABEO	Stock	431.25	442.5	423.75	432.5	25296.0
2018-01-03	ABEOW-DELISTED	Stock	12.4	12.4	12.22	12.22	913.0
2018-01-03	ABEV	Stock	6.67	6.74	6.62	6.65	13987800.0
2018-01-03	ABG	Stock	63.25	63.95	62.7	63.5	152400.0
2018-01-03	ABIL-DELISTED	Stock	0.4511	0.4659	0.45	0.45	47268.0
2018-01-03	ABLX-DELISTED	Stock	24.67	24.76	24.24	24.33	74598.0
2018-01-03	ABM	Stock	37.61	37.84	37.48	37.72	554800.0

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

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