PREVIEW / stock_daily / 2018-12-24

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-24.parquet
  size:    215 KB
  rows:    6,523
  symbols: 2,661

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-24	AAPL	Stock	37.0375	37.8875	36.6475	36.7075	148676800.0
2018-12-24	MSFT	Stock	97.68	97.97	93.98	94.13	43935200.0
2018-12-24	NVDA	Stock	3.1623	3.2495	3.1125	3.177	463840000.0
2018-12-24	AMZN	Stock	67.3	69.8015	65.35	67.198	144400000.0
2018-12-24	GOOGL	Stock	49.216	50.606	48.883	49.2335	36359100.0
2018-12-24	META	Stock	123.1	129.74	123.02	124.06	22066000.0
2018-12-24	TSLA	Stock	20.9	20.9667	19.68	19.6927	83398500.0
2018-12-24	TLT	Stock	121.13	121.42	120.91	121.32	8377482.0
2018-12-24	ES	Stock	66.64	66.95	63.36	63.38	871300.0
2018-12-24	CL	Stock	59.96	60.0	57.85	58.04	3872300.0
2018-12-24	A	Stock	62.93	63.63	62.22	62.67	1668500.0
2018-12-24	AA	Stock	26.27	26.27	25.08	25.15	1926900.0
2018-12-24	AABA-DELISTED	Stock	54.88	56.53	54.75	55.72	5366293.0
2018-12-24	AAC-DELISTED	Stock	1.61	1.61	1.52	1.52	150495.0
2018-12-24	AACG	Stock	1.01	1.01	0.95	0.97	34400.0
2018-12-24	AAIC-DELISTED	Stock	7.65	7.68	7.5	7.56	352838.0
2018-12-24	AAL	Stock	30.51	30.92	29.67	29.72	5902000.0
2018-12-24	AAM.A-DELISTED	Stock	21.5996	21.6415	21.19	21.62	59545.0
2018-12-24	AAM.B-DELISTED	Stock	21.21	21.45	21.21	21.4	60900.0
2018-12-24	AAMC-DELISTED	Stock	9.3235	10.0882	9.3235	9.7059	17792.0
2018-12-24	AAME	Stock	2.37	2.37	2.24	2.37	1300.0
2018-12-24	AAMI	Stock	10.07	10.43	10.05	10.13	372300.0
2018-12-24	AAOI	Stock	14.0	14.47	13.42	13.84	842500.0
2018-12-24	AAON	Stock	21.7067	22.94	21.56	21.6133	117000.0
2018-12-24	AAP	Stock	151.03	152.0	148.37	148.92	649100.0
2018-12-24	AAT	Stock	40.05	40.05	38.45	38.56	160700.0
2018-12-24	AAU-DELISTED	Stock	0.595	0.606	0.586	0.5878	112191.0
2018-12-24	AAUAF-DELISTED	Stock	0.595	0.606	0.586	0.5878	131186.0
2018-12-24	AAWW-DELISTED	Stock	36.67	38.07	35.59	37.31	129227.0
2018-12-24	AAXJ	Stock	62.6	63.0	62.12	62.12	287317.0
2018-12-24	AAXN-DELISTED	Stock	40.45	40.86	39.43	39.79	580725.0
2018-12-24	AB	Stock	24.0	24.19	23.34	23.68	648400.0
2018-12-24	ABAC-DELISTED	Stock	0.9518	1.0	0.92	0.92	4091.0
2018-12-24	ABB-DELISTED	Stock	18.38	18.43	18.14	18.19	1668369.0
2018-12-24	ABBNY-DELISTED	Stock	18.38	18.43	18.14	18.19	1725079.0
2018-12-24	ABBV	Stock	84.85	86.44	83.6	84.16	5097900.0
2018-12-24	ABC-DELISTED	Stock	71.97	72.71	70.63	70.77	436384.0
2018-12-24	ABCB	Stock	30.52	31.21	30.15	30.19	270100.0
2018-12-24	ABDC-DELISTED	Stock	6.25	6.31	6.17	6.25	28828.0
2018-12-24	ABEO	Stock	162.5	166.75	156.5	160.0	21304.0
2018-12-24	ABEV	Stock	3.86	3.89	3.82	3.82	7510100.0
2018-12-24	ABG	Stock	62.33	62.71	61.47	62.3	162800.0
2018-12-24	ABIL-DELISTED	Stock	1.88	1.88	1.5401	1.726	184266.0
2018-12-24	ABM	Stock	29.9	30.34	28.72	28.78	381600.0
2018-12-24	ABMD-DELISTED	Stock	286.04	286.76	274.02	281.08	249401.0
2018-12-24	ABR	Stock	9.92	9.99	9.62	9.78	1369400.0
2018-12-24	ABR.A-DELISTED	Stock	24.25	24.49	24.1	24.2	9839.0
2018-12-24	ABR.B-DELISTED	Stock	23.3	24.45	23.3	23.6	12100.0
2018-12-24	ABR.C-DELISTED	Stock	25.298	25.46	25.0	25.46	5500.0
2018-12-24	ABT	Stock	66.82	67.05	65.44	65.56	4026200.0

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

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