PREVIEW / stock_daily / 2018-03-20

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-20.parquet
  size:    217 KB
  rows:    6,499
  symbols: 2,858

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-03-20	AAPL	Stock	43.81	44.2	43.735	43.81	78597600.0
2018-03-20	MSFT	Stock	93.05	93.77	93.0	93.13	23075200.0
2018-03-20	NVDA	Stock	6.028	6.2788	6.028	6.2395	554696000.0
2018-03-20	AMZN	Stock	77.517	79.35	77.2705	79.3255	91632000.0
2018-03-20	GOOGL	Stock	54.92	55.2775	54.121	54.79	54597140.0
2018-03-20	META	Stock	167.47	170.2	161.95	168.15	129851800.0
2018-03-20	TSLA	Stock	20.9913	21.0833	20.584	20.7033	71464500.0
2018-03-20	TLT	Stock	118.91	119.22	118.83	118.95	5445971.0
2018-03-20	ES	Stock	58.08	58.27	57.49	57.67	1507800.0
2018-03-20	CL	Stock	70.22	70.56	69.33	69.69	2403300.0
2018-03-20	A	Stock	69.77	70.07	69.45	69.85	2379100.0
2018-03-20	AA	Stock	46.37	47.06	46.05	46.47	1515400.0
2018-03-20	AABA-DELISTED	Stock	77.88	79.19	77.73	79.07	3609019.0
2018-03-20	AAC-DELISTED	Stock	12.32	12.96	12.275	12.68	128054.0
2018-03-20	AAIC-DELISTED	Stock	11.75	11.76	11.55	11.58	468985.0
2018-03-20	AAL	Stock	54.93	55.7	54.67	55.32	2555600.0
2018-03-20	AAM.A-DELISTED	Stock	25.11	25.1199	25.04	25.06	28773.0
2018-03-20	AAMC-DELISTED	Stock	17.8824	17.8824	17.8824	17.8824	459.0
2018-03-20	AAMI	Stock	15.79	15.8	15.6	15.7	881400.0
2018-03-20	AAOI	Stock	26.07	26.87	25.95	26.67	565000.0
2018-03-20	AAON	Stock	26.0333	26.3333	25.9333	26.1667	274800.0
2018-03-20	AAP	Stock	116.39	116.69	113.74	114.25	636000.0
2018-03-20	AAT	Stock	33.24	33.58	32.67	32.89	193400.0
2018-03-20	AAU-DELISTED	Stock	0.82	0.83	0.783	0.81	307519.0
2018-03-20	AAUAF-DELISTED	Stock	0.82	0.83	0.783	0.81	311095.0
2018-03-20	AAV-DELISTED	Stock	2.85	2.875	2.7748	2.875	132069.0
2018-03-20	AAWW-DELISTED	Stock	63.9	64.45	63.5	64.05	109123.0
2018-03-20	AAXJ	Stock	79.14	79.67	79.14	79.47	413484.0
2018-03-20	AAXN-DELISTED	Stock	37.5	38.66	37.46	38.35	719695.0
2018-03-20	AB	Stock	26.55	26.65	26.25	26.55	184500.0
2018-03-20	ABAX-DELISTED	Stock	73.31	74.31	72.3301	72.78	101949.0
2018-03-20	ABB-DELISTED	Stock	23.93	24.05	23.9101	23.93	1081465.0
2018-03-20	ABBNY-DELISTED	Stock	23.93	24.05	23.9101	23.92	1126935.0
2018-03-20	ABBV	Stock	112.9	114.15	112.09	112.65	4933800.0
2018-03-20	ABC-DELISTED	Stock	92.96	93.19	88.152	89.18	2320418.0
2018-03-20	ABCB	Stock	56.75	56.9	56.05	56.3	310200.0
2018-03-20	ABCD-DELISTED	Stock	10.25	10.74	10.14	10.62	297356.0
2018-03-20	ABDC-DELISTED	Stock	6.09	6.24	5.931	6.13	215550.0
2018-03-20	ABE-DELISTED	Stock	15.0	15.16	15.0	15.1	6506.0
2018-03-20	ABEO	Stock	357.5	365.0	351.25	363.25	23528.0
2018-03-20	ABEOW-DELISTED	Stock	9.2726	9.5	9.2726	9.5	1968.0
2018-03-20	ABEV	Stock	7.17	7.19	7.09	7.09	12882300.0
2018-03-20	ABG	Stock	66.45	66.45	63.65	64.6	488000.0
2018-03-20	ABIL-DELISTED	Stock	0.38	0.415	0.38	0.3982	48569.0
2018-03-20	ABLX-DELISTED	Stock	53.81	53.91	53.68	53.76	23034.0
2018-03-20	ABM	Stock	34.48	34.69	34.2	34.47	339500.0
2018-03-20	ABMD-DELISTED	Stock	288.87	295.83	288.55	293.95	458059.0
2018-03-20	ABR	Stock	8.82	8.88	8.81	8.84	306800.0
2018-03-20	ABR.A-DELISTED	Stock	25.35	25.37	25.345	25.3562	1839.0
2018-03-20	ABR.B-DELISTED	Stock	25.1	25.1007	25.1	25.1007	1171.0

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

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