PREVIEW / stock_daily / 2021-06-14

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-14.parquet
  size:    258 KB
  rows:    7,879
  symbols: 2,930

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
2021-06-14	AAPL	Stock	127.82	130.54	127.07	130.48	96906500.0
2021-06-14	MSFT	Stock	257.9	259.95	256.8	259.89	19150500.0
2021-06-14	NVDA	Stock	17.906	18.0395	17.6628	18.0188	321376000.0
2021-06-14	AMZN	Stock	167.3415	169.25	166.775	169.1935	51394000.0
2021-06-14	GOOGL	Stock	121.613	122.446	120.9	122.4455	22097560.0
2021-06-14	META	Stock	331.9	336.82	329.81	336.77	12250800.0
2021-06-14	TSLA	Stock	204.0767	208.4967	203.06	205.8967	61272000.0
2021-06-14	TLT	Stock	142.1	142.1	141.015	141.22	9401341.0
2021-06-14	ES	Stock	83.01	83.01	82.11	82.55	1307000.0
2021-06-14	CL	Stock	83.66	83.66	82.86	83.41	2345200.0
2021-06-14	A	Stock	143.5	144.43	142.76	144.39	934200.0
2021-06-14	AA	Stock	37.3	37.785	36.46	36.95	5887300.0
2021-06-14	AAC-DELISTED	Stock	9.81	9.81	9.778	9.8	45930.0
2021-06-14	AACG	Stock	3.18	3.44	3.17	3.24	641400.0
2021-06-14	AACQ-DELISTED	Stock	10.01	10.015	9.98	9.99	1288785.0
2021-06-14	AACQU-DELISTED	Stock	10.81	10.82	10.8	10.82	4654.0
2021-06-14	AACQW-DELISTED	Stock	2.41	2.5	2.3318	2.48	155436.0
2021-06-14	AAIC-DELISTED	Stock	4.14	4.18	4.11	4.12	149862.0
2021-06-14	AAIC.C-DELISTED	Stock	24.96	25.09	24.61	24.85	10893.0
2021-06-14	AAL	Stock	23.49	23.74	22.93	22.99	22613100.0
2021-06-14	AAM.A-DELISTED	Stock	26.2	26.45	26.06	26.45	39839.0
2021-06-14	AAM.B-DELISTED	Stock	27.04	27.24	27.025	27.24	18810.0
2021-06-14	AAMC-DELISTED	Stock	5.8059	5.8059	5.5765	5.7674	13059.0
2021-06-14	AAME	Stock	4.28	4.81	4.15	4.42	248200.0
2021-06-14	AAMI	Stock	22.71	22.76	22.25	22.3	582600.0
2021-06-14	AAN-DELISTED	Stock	36.5	36.9	36.183	36.37	207700.0
2021-06-14	AAOI	Stock	8.78	9.03	8.76	8.79	446000.0
2021-06-14	AAON	Stock	43.08	43.08	42.2667	42.5733	254850.0
2021-06-14	AAP	Stock	199.06	200.94	197.92	198.59	793900.0
2021-06-14	AAQC-DELISTED	Stock	9.68	9.73	9.68	9.72	3101.0
2021-06-14	AAT	Stock	38.77	38.95	38.51	38.83	226300.0
2021-06-14	AAU-DELISTED	Stock	0.5416	0.5465	0.5323	0.535	591541.0
2021-06-14	AAUAF-DELISTED	Stock	0.5416	0.5465	0.5323	0.5334	612687.0
2021-06-14	AAWW-DELISTED	Stock	74.33	74.76	72.622	73.04	227401.0
2021-06-14	AAXJ	Stock	94.62	94.94	94.4962	94.9	405638.0
2021-06-14	AB	Stock	46.0	46.02	45.16	45.51	219700.0
2021-06-14	ABB-DELISTED	Stock	34.54	34.63	34.385	34.63	1144921.0
2021-06-14	ABBNY-DELISTED	Stock	34.54	34.63	34.385	34.63	1231269.0
2021-06-14	ABBV	Stock	115.07	115.48	114.19	115.4	4427600.0
2021-06-14	ABC-DELISTED	Stock	119.83	119.83	117.75	118.72	448472.0
2021-06-14	ABCB	Stock	54.38	54.91	53.2	53.74	352500.0
2021-06-14	ABCL	Stock	26.602	26.602	24.18	24.55	3569500.0
2021-06-14	ABCM-DELISTED	Stock	18.79	18.82	18.55	18.55	43685.0
2021-06-14	ABEO	Stock	45.5	46.0	45.0	45.0	26904.0
2021-06-14	ABEV	Stock	3.76	3.86	3.75	3.83	9222400.0
2021-06-14	ABG	Stock	177.0	177.52	169.81	171.5	252100.0
2021-06-14	ABGI-DELISTED	Stock	9.99	9.99	9.9	9.92	6002.0
2021-06-14	ABM	Stock	48.47	48.47	47.2	47.76	303200.0
2021-06-14	ABMD-DELISTED	Stock	299.74	305.12	299.5	302.88	187522.0
2021-06-14	ABNB	Stock	149.25	149.6	146.85	149.21	6107500.0

> showing 50 of 7,879 rows — these rows as CSV

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