PREVIEW / stock_daily / 2020-06-10

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-10.parquet
  size:    221 KB
  rows:    6,690
  symbols: 2,391

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-10	AAPL	Stock	86.975	88.6925	86.5225	88.21	166651600.0
2020-06-10	MSFT	Stock	191.13	198.52	191.01	196.84	43872300.0
2020-06-10	NVDA	Stock	9.1678	9.5	9.1535	9.3668	632180000.0
2020-06-10	AMZN	Stock	132.25	136.1175	131.313	132.3725	98920000.0
2020-06-10	GOOGL	Stock	73.0755	73.6385	72.7178	73.235	31762320.0
2020-06-10	META	Stock	240.96	241.21	235.28	236.73	20720700.0
2020-06-10	TSLA	Stock	66.1253	68.4987	65.5	68.3367	278451000.0
2020-06-10	TLT	Stock	159.24	160.9	159.05	160.84	13135518.0
2020-06-10	ES	Stock	85.46	86.92	85.4	86.26	1428600.0
2020-06-10	CL	Stock	73.74	74.9	73.43	74.36	5726600.0
2020-06-10	A	Stock	90.32	90.58	89.46	89.81	1410300.0
2020-06-10	AA	Stock	12.51	12.61	11.93	12.17	8252100.0
2020-06-10	AACG	Stock	0.93	1.0	0.93	1.0	30500.0
2020-06-10	AAIC-DELISTED	Stock	3.4	3.455	3.05	3.19	551515.0
2020-06-10	AAIC.C-DELISTED	Stock	20.17	20.47	20.0	20.44	13182.0
2020-06-10	AAL	Stock	17.69	18.16	15.92	17.02	163952500.0
2020-06-10	AAM.A-DELISTED	Stock	25.92	26.01	25.86	26.01	13224.0
2020-06-10	AAM.B-DELISTED	Stock	26.2	26.23	26.18	26.23	3322.0
2020-06-10	AAMC-DELISTED	Stock	5.6176	6.25	5.5853	6.0324	73943.0
2020-06-10	AAME	Stock	1.92	1.92	1.92	1.92	400.0
2020-06-10	AAMI	Stock	9.73	10.06	9.65	9.76	383800.0
2020-06-10	AAOI	Stock	9.73	9.81	9.38	9.39	308800.0
2020-06-10	AAON	Stock	38.4533	38.4533	37.4467	37.5667	324900.0
2020-06-10	AAP	Stock	144.32	144.32	140.37	140.38	864900.0
2020-06-10	AAT	Stock	32.86	33.05	30.89	30.89	644200.0
2020-06-10	AAU-DELISTED	Stock	0.53	0.59	0.53	0.561	696945.0
2020-06-10	AAUAF-DELISTED	Stock	0.53	0.59	0.53	0.5644	732227.0
2020-06-10	AAWW-DELISTED	Stock	42.07	42.07	39.89	41.01	384223.0
2020-06-10	AAXJ	Stock	70.0	70.55	69.64	70.45	1202956.0
2020-06-10	AAXN-DELISTED	Stock	101.54	104.9	100.28	103.17	1429095.0
2020-06-10	AB	Stock	26.86	26.86	25.81	26.25	330400.0
2020-06-10	ABB-DELISTED	Stock	22.0	22.05	21.62	21.63	1576424.0
2020-06-10	ABBNY-DELISTED	Stock	22.01	22.05	21.62	21.64	1681978.0
2020-06-10	ABBV	Stock	96.99	99.35	96.8	96.9	11138300.0
2020-06-10	ABC-DELISTED	Stock	100.38	100.58	96.93	96.94	684021.0
2020-06-10	ABCB	Stock	28.09	28.13	26.22	26.3	248900.0
2020-06-10	ABEO	Stock	73.25	73.5	69.5	69.5	34596.0
2020-06-10	ABEV	Stock	2.95	2.98	2.81	2.82	39396000.0
2020-06-10	ABG	Stock	80.73	81.15	76.84	78.11	250500.0
2020-06-10	ABM	Stock	35.38	35.5	33.7	33.74	393300.0
2020-06-10	ABMD-DELISTED	Stock	246.41	252.98	244.59	250.86	239589.0
2020-06-10	ABR	Stock	10.41	10.45	9.52	9.96	2756900.0
2020-06-10	ABR.A-DELISTED	Stock	25.31	25.31	24.875	25.0001	860.0
2020-06-10	ABR.B-DELISTED	Stock	24.16	24.19	23.99	23.99	2696.0
2020-06-10	ABR.C-DELISTED	Stock	25.04	25.52	24.85	25.03	6960.0
2020-06-10	ABT	Stock	90.85	92.75	90.64	92.16	5829100.0
2020-06-10	ABTC	Stock	310800.0	324000.0	295500.0	324000.0	3.9466666666666668
2020-06-10	ABTS	Stock	18.45	39.0	16.65	24.45	383520.0
2020-06-10	ABTX-DELISTED	Stock	29.0	29.0	26.88	27.01	37199.0
2020-06-10	ABUS	Stock	1.96	1.97	1.75	1.85	1213200.0

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

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