PREVIEW / stock_daily / 2018-12-20

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-20.parquet
  size:    222 KB
  rows:    6,615
  symbols: 2,728

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-20	AAPL	Stock	40.1	40.5275	38.825	39.2075	259092000.0
2018-12-20	MSFT	Stock	103.05	104.31	98.78	101.51	70334200.0
2018-12-20	NVDA	Stock	3.4542	3.545	3.3172	3.3775	749588000.0
2018-12-20	AMZN	Stock	74.2	75.475	71.6345	73.0415	199836000.0
2018-12-20	GOOGL	Stock	51.3	52.372	50.3932	51.179	53673400.0
2018-12-20	META	Stock	130.7	135.57	130.0	133.4	40297900.0
2018-12-20	TSLA	Stock	21.8033	22.0193	20.7913	21.0253	136078500.0
2018-12-20	TLT	Stock	122.01	122.03	120.67	120.74	18543731.0
2018-12-20	ES	Stock	67.33	68.14	66.25	67.17	2050400.0
2018-12-20	CL	Stock	61.74	61.96	60.51	60.98	5552000.0
2018-12-20	A	Stock	66.33	66.46	64.59	65.19	3547800.0
2018-12-20	AA	Stock	27.66	27.78	26.29	27.33	4942500.0
2018-12-20	AABA-DELISTED	Stock	57.49	57.92	56.115	56.71	8118917.0
2018-12-20	AAC-DELISTED	Stock	1.79	1.795	1.63	1.63	380433.0
2018-12-20	AACG	Stock	1.02	1.05	1.0	1.0	53700.0
2018-12-20	AAIC-DELISTED	Stock	7.9	7.97	7.57	7.66	482107.0
2018-12-20	AAL	Stock	32.34	32.68	30.95	31.89	9439600.0
2018-12-20	AAM.A-DELISTED	Stock	21.5	21.5386	21.21	21.27	222079.0
2018-12-20	AAM.B-DELISTED	Stock	21.323	21.4065	21.02	21.25	89173.0
2018-12-20	AAMC-DELISTED	Stock	11.5588	11.5588	10.8912	10.8912	6562.0
2018-12-20	AAME	Stock	2.33	2.33	2.33	2.33	200.0
2018-12-20	AAMI	Stock	10.51	10.68	10.31	10.36	886500.0
2018-12-20	AAOI	Stock	14.88	15.97	14.88	15.22	932200.0
2018-12-20	AAON	Stock	22.4867	22.7333	22.0	22.6	288900.0
2018-12-20	AAP	Stock	155.28	156.15	150.65	152.5	1804900.0
2018-12-20	AAT	Stock	40.51	41.03	39.99	40.36	345900.0
2018-12-20	AAU-DELISTED	Stock	0.59	0.59	0.54	0.5799	208157.0
2018-12-20	AAUAF-DELISTED	Stock	0.59	0.59	0.54	0.5799	219174.0
2018-12-20	AAWW-DELISTED	Stock	39.15	39.86	38.29	38.76	374454.0
2018-12-20	AAXJ	Stock	63.32	63.62	62.77	63.2	1269512.0
2018-12-20	AAXN-DELISTED	Stock	44.44	45.43	40.01	41.37	988707.0
2018-12-20	AB	Stock	25.0	25.55	24.61	24.95	609600.0
2018-12-20	ABAC-DELISTED	Stock	1.0799	1.0799	0.95	0.952	7055.0
2018-12-20	ABB-DELISTED	Stock	18.82	18.93	18.585	18.71	3322129.0
2018-12-20	ABBNY-DELISTED	Stock	18.82	18.93	18.585	18.7	3664112.0
2018-12-20	ABBV	Stock	82.99	86.48	82.41	85.37	9453300.0
2018-12-20	ABC-DELISTED	Stock	75.85	77.02	72.1402	73.22	1781590.0
2018-12-20	ABCB	Stock	31.81	32.1	31.01	31.47	680200.0
2018-12-20	ABDC-DELISTED	Stock	6.41	6.62	6.26	6.26	48239.0
2018-12-20	ABEO	Stock	168.25	171.5	160.5	167.75	35100.0
2018-12-20	ABEOW-DELISTED	Stock	2.4648	2.4648	2.4648	2.4648	400.0
2018-12-20	ABEV	Stock	3.98	4.0	3.87	3.92	20206100.0
2018-12-20	ABG	Stock	64.54	65.41	63.48	64.46	174000.0
2018-12-20	ABIL-DELISTED	Stock	2.2	2.2897	2.06	2.13	197814.0
2018-12-20	ABM	Stock	30.43	31.49	29.98	31.07	1288100.0
2018-12-20	ABMD-DELISTED	Stock	296.14	303.21	275.485	283.89	675833.0
2018-12-20	ABR	Stock	10.76	10.8	9.97	10.1	3000400.0
2018-12-20	ABR.A-DELISTED	Stock	24.4	24.4	24.111	24.16	23964.0
2018-12-20	ABR.B-DELISTED	Stock	24.23	24.647	23.46	23.61	2580.0
2018-12-20	ABR.C-DELISTED	Stock	25.0245	25.1	24.4992	25.04	6827.0

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

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