PREVIEW / stock_daily / 2018-12-17

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-17.parquet
  size:    220 KB
  rows:    6,575
  symbols: 2,696

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-12-17	AAPL	Stock	41.3625	42.0875	40.6825	40.985	177151600.0
2018-12-17	MSFT	Stock	105.41	105.8	101.71	102.89	56957300.0
2018-12-17	NVDA	Stock	3.631	3.7038	3.531	3.5895	662868000.0
2018-12-17	AMZN	Stock	78.3	78.8065	75.2505	76.0455	176596000.0
2018-12-17	GOOGL	Stock	52.3505	53.119	50.8315	51.2825	49931020.0
2018-12-17	META	Stock	143.08	144.92	138.42	140.19	24334000.0
2018-12-17	TSLA	Stock	24.1333	24.38	22.9253	23.228	115110000.0
2018-12-17	TLT	Stock	118.59	119.3	118.58	119.17	9726781.0
2018-12-17	ES	Stock	69.5	69.63	66.96	67.25	2151400.0
2018-12-17	CL	Stock	65.15	65.35	62.42	62.92	7167600.0
2018-12-17	A	Stock	69.11	69.63	67.4	67.85	2241700.0
2018-12-17	AA	Stock	28.5	29.02	27.835	28.11	2186600.0
2018-12-17	AABA-DELISTED	Stock	61.25	61.63	59.37	60.08	7937624.0
2018-12-17	AAC-DELISTED	Stock	2.18	2.18	1.93	1.96	326010.0
2018-12-17	AACG	Stock	1.06	1.06	1.02	1.02	26700.0
2018-12-17	AAIC-DELISTED	Stock	8.41	8.41	8.05	8.07	611452.0
2018-12-17	AAL	Stock	32.3	32.86	31.7	32.04	7638100.0
2018-12-17	AAM.A-DELISTED	Stock	22.09	22.12	21.35	21.43	97678.0
2018-12-17	AAM.B-DELISTED	Stock	21.83	22.07	21.35	21.35	127317.0
2018-12-17	AAMC-DELISTED	Stock	13.6235	13.6235	12.7618	12.7618	12583.0
2018-12-17	AAME	Stock	2.4	2.42	2.38	2.42	8800.0
2018-12-17	AAMI	Stock	11.0	11.13	10.74	10.82	665700.0
2018-12-17	AAOI	Stock	17.5	17.98	16.927	17.11	838500.0
2018-12-17	AAON	Stock	23.52	23.7467	22.7133	22.8533	234300.0
2018-12-17	AAP	Stock	162.61	162.73	158.13	158.84	1223800.0
2018-12-17	AAT	Stock	41.91	41.91	40.33	40.62	352000.0
2018-12-17	AAU-DELISTED	Stock	0.64	0.655	0.62	0.632	255333.0
2018-12-17	AAUAF-DELISTED	Stock	0.64	0.655	0.62	0.632	259702.0
2018-12-17	AAWW-DELISTED	Stock	45.0	45.03	42.45	42.65	329149.0
2018-12-17	AAXJ	Stock	65.08	65.31	64.225	64.47	2614778.0
2018-12-17	AAXN-DELISTED	Stock	44.5	45.07	43.475	43.81	514905.0
2018-12-17	AB	Stock	26.19	26.81	25.16	25.35	1074700.0
2018-12-17	ABAC-DELISTED	Stock	1.11	1.1399	1.1	1.1	6350.0
2018-12-17	ABB-DELISTED	Stock	19.49	19.52	19.005	19.12	4634628.0
2018-12-17	ABBNY-DELISTED	Stock	19.48	19.52	19.005	19.1	4804300.0
2018-12-17	ABBV	Stock	85.07	86.88	84.2	84.93	5958200.0
2018-12-17	ABC-DELISTED	Stock	78.31	78.55	76.5	77.02	1219542.0
2018-12-17	ABCB	Stock	32.0	33.11	30.72	31.18	1571000.0
2018-12-17	ABCD-DELISTED	Stock	14.49	14.51	14.48	14.49	729254.0
2018-12-17	ABDC-DELISTED	Stock	6.61	6.69	6.46	6.47	138476.0
2018-12-17	ABEO	Stock	182.5	191.5	177.75	182.75	36832.0
2018-12-17	ABEV	Stock	4.09	4.11	4.03	4.05	16120600.0
2018-12-17	ABG	Stock	66.13	68.02	65.06	66.94	370900.0
2018-12-17	ABIL-DELISTED	Stock	2.28	2.46	2.25	2.28	620578.0
2018-12-17	ABM	Stock	25.96	26.78	25.64	25.94	967900.0
2018-12-17	ABMD-DELISTED	Stock	312.57	312.57	295.405	298.62	526479.0
2018-12-17	ABR	Stock	11.5	11.52	10.85	10.93	2884200.0
2018-12-17	ABR.A-DELISTED	Stock	25.27	25.27	25.04	25.04	4015.0
2018-12-17	ABR.B-DELISTED	Stock	25.3112	25.371	25.23	25.371	1200.0
2018-12-17	ABR.C-DELISTED	Stock	25.55	25.55	25.3791	25.54	7709.0

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

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