PREVIEW / stock_daily / 2020-06-25

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-25.parquet
  size:    222 KB
  rows:    6,713
  symbols: 2,394

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
2020-06-25	AAPL	Stock	90.175	91.25	89.3925	91.21	137522400.0
2020-06-25	MSFT	Stock	197.8	200.61	195.47	200.34	27803900.0
2020-06-25	NVDA	Stock	9.3558	9.505	9.1823	9.49	376072000.0
2020-06-25	AMZN	Stock	136.9775	137.8115	135.607	137.729	59374000.0
2020-06-25	GOOGL	Stock	71.561	72.116	70.977	72.055	23958140.0
2020-06-25	META	Stock	234.62	237.3	232.74	235.68	18704300.0
2020-06-25	TSLA	Stock	63.618	65.732	62.4767	65.732	138817500.0
2020-06-25	TLT	Stock	164.21	164.35	163.4	163.5	10967984.0
2020-06-25	ES	Stock	82.56	82.79	81.16	82.36	1420500.0
2020-06-25	CL	Stock	72.11	72.73	71.26	72.64	3379900.0
2020-06-25	A	Stock	86.43	87.35	84.8	87.26	1350100.0
2020-06-25	AA	Stock	11.01	11.84	10.86	11.83	6728600.0
2020-06-25	AACG	Stock	1.22	1.25	1.11	1.23	72900.0
2020-06-25	AAIC-DELISTED	Stock	2.79	2.9307	2.79	2.9	348698.0
2020-06-25	AAIC.C-DELISTED	Stock	19.7402	19.75	19.725	19.725	996.0
2020-06-25	AAL	Stock	12.53	13.24	12.18	13.17	117383400.0
2020-06-25	AAM.A-DELISTED	Stock	26.03	26.195	25.96	26.12	27484.0
2020-06-25	AAM.B-DELISTED	Stock	26.04	26.04	25.9	26.04	15742.0
2020-06-25	AAMC-DELISTED	Stock	5.1471	5.3206	5.0676	5.1029	11951.0
2020-06-25	AAME	Stock	1.73	1.98	1.63	1.88	72900.0
2020-06-25	AAMI	Stock	9.73	10.07	9.6	10.07	898800.0
2020-06-25	AAOI	Stock	9.32	9.425	9.11	9.38	354900.0
2020-06-25	AAON	Stock	34.9867	35.4267	34.34	35.3933	319650.0
2020-06-25	AAP	Stock	141.85	143.49	140.07	142.91	920600.0
2020-06-25	AAT	Stock	27.06	27.95	26.92	27.94	402100.0
2020-06-25	AAU-DELISTED	Stock	0.4997	0.5098	0.49	0.4915	76649.0
2020-06-25	AAUAF-DELISTED	Stock	0.4997	0.5098	0.49	0.4926	79089.0
2020-06-25	AAWW-DELISTED	Stock	40.51	40.62	38.89	39.98	391123.0
2020-06-25	AAXJ	Stock	69.36	69.79	69.1	69.79	455745.0
2020-06-25	AAXN-DELISTED	Stock	92.71	95.95	91.53	95.95	720325.0
2020-06-25	AB	Stock	24.93	25.82	24.75	25.79	458500.0
2020-06-25	ABB-DELISTED	Stock	21.83	22.11	21.71	22.11	3434812.0
2020-06-25	ABBNY-DELISTED	Stock	21.83	22.11	21.71	22.1	3578241.0
2020-06-25	ABBV	Stock	95.18	97.07	94.32	96.99	6411700.0
2020-06-25	ABC-DELISTED	Stock	98.54	100.88	98.48	100.67	770143.0
2020-06-25	ABCB	Stock	22.54	23.69	22.33	23.65	319400.0
2020-06-25	ABEO	Stock	72.25	74.25	70.25	73.5	25712.0
2020-06-25	ABEV	Stock	2.62	2.71	2.62	2.68	46837700.0
2020-06-25	ABG	Stock	72.32	74.56	71.96	74.36	149900.0
2020-06-25	ABM	Stock	35.48	36.1	35.02	35.73	410700.0
2020-06-25	ABMD-DELISTED	Stock	240.0	242.47	235.99	242.09	279760.0
2020-06-25	ABR	Stock	9.37	10.15	9.36	10.08	2972300.0
2020-06-25	ABR.A-DELISTED	Stock	24.62	24.72	24.2923	24.2923	968.0
2020-06-25	ABR.B-DELISTED	Stock	23.25	23.31	22.595	23.15	5700.0
2020-06-25	ABR.C-DELISTED	Stock	25.1	25.1	25.04	25.09	579.0
2020-06-25	ABT	Stock	87.24	89.81	86.16	89.62	5781100.0
2020-06-25	ABTC	Stock	247500.0	290400.0	234930.0	280500.0	10.2
2020-06-25	ABTS	Stock	14.25	14.55	13.5	14.25	3780.0
2020-06-25	ABTX-DELISTED	Stock	23.75	24.71	23.75	24.69	63372.0
2020-06-25	ABUS	Stock	2.14	2.18	2.07	2.1	773200.0

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

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