PREVIEW / stock_daily / 2020-05-11

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-11.parquet
  size:    217 KB
  rows:    6,600
  symbols: 2,343

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-05-11	AAPL	Stock	77.025	79.2625	76.81	78.7525	145946400.0
2020-05-11	MSFT	Stock	183.15	187.51	182.85	186.74	30892700.0
2020-05-11	NVDA	Stock	7.8075	8.1125	7.7788	8.0655	469060000.0
2020-05-11	AMZN	Stock	118.735	120.9835	118.6055	120.45	65184000.0
2020-05-11	GOOGL	Stock	68.8395	70.7765	68.775	70.1795	32717120.0
2020-05-11	META	Stock	210.89	215.0	210.37	213.18	12911900.0
2020-05-11	TSLA	Stock	52.7007	54.9333	52.3333	54.086	247794000.0
2020-05-11	TLT	Stock	163.66	164.22	162.095	162.7	8713747.0
2020-05-11	ES	Stock	77.56	77.82	76.06	77.02	1416500.0
2020-05-11	CL	Stock	69.53	70.0	68.92	69.38	2797200.0
2020-05-11	A	Stock	79.6	81.99	79.5	81.27	1691600.0
2020-05-11	AA	Stock	7.78	7.91	7.66	7.77	8314500.0
2020-05-11	AACG	Stock	0.79	0.8	0.71	0.76	16600.0
2020-05-11	AAIC-DELISTED	Stock	2.76	2.8498	2.4721	2.53	607722.0
2020-05-11	AAIC.C-DELISTED	Stock	16.9	16.91	16.5611	16.61	5964.0
2020-05-11	AAL	Stock	9.92	10.25	9.59	10.1	48705900.0
2020-05-11	AAM.A-DELISTED	Stock	25.805	25.99	25.54	25.99	9203.0
2020-05-11	AAM.B-DELISTED	Stock	25.93	25.99	25.44	25.98	38497.0
2020-05-11	AAMC-DELISTED	Stock	4.6029	4.6618	4.5765	4.5784	8503.0
2020-05-11	AAME	Stock	1.8	1.87	1.77	1.77	14700.0
2020-05-11	AAMI	Stock	8.36	8.36	8.005	8.03	391400.0
2020-05-11	AAOI	Stock	10.02	10.09	9.63	9.71	935600.0
2020-05-11	AAON	Stock	32.24	33.3333	31.98	32.2933	500250.0
2020-05-11	AAP	Stock	124.11	126.39	123.0	125.94	851200.0
2020-05-11	AAT	Stock	27.27	27.67	26.06	26.06	324500.0
2020-05-11	AAU-DELISTED	Stock	0.444	0.444	0.4201	0.425	157762.0
2020-05-11	AAUAF-DELISTED	Stock	0.444	0.444	0.4201	0.425	173118.0
2020-05-11	AAWW-DELISTED	Stock	38.33	38.57	37.15	37.88	496236.0
2020-05-11	AAXJ	Stock	64.17	64.59	64.11	64.26	621929.0
2020-05-11	AAXN-DELISTED	Stock	86.0	89.43	84.07	84.98	1044314.0
2020-05-11	AB	Stock	22.5	22.87	22.11	22.51	242500.0
2020-05-11	ABB-DELISTED	Stock	18.25	18.395	18.17	18.29	1243419.0
2020-05-11	ABBNY-DELISTED	Stock	18.25	18.395	18.17	18.29	1332978.0
2020-05-11	ABBV	Stock	85.08	88.46	83.98	87.9	19219800.0
2020-05-11	ABC-DELISTED	Stock	89.07	91.86	88.52	90.64	985974.0
2020-05-11	ABCB	Stock	23.3	23.3	21.21	21.82	625200.0
2020-05-11	ABEO	Stock	68.0	82.0	67.5	81.0	118428.0
2020-05-11	ABEV	Stock	2.15	2.17	2.07	2.09	21380800.0
2020-05-11	ABG	Stock	69.22	69.22	65.79	66.78	230000.0
2020-05-11	ABM	Stock	33.03	33.83	32.15	33.7	446200.0
2020-05-11	ABMD-DELISTED	Stock	187.1	197.45	186.645	194.74	340206.0
2020-05-11	ABR	Stock	7.44	7.45	6.87	6.97	3625300.0
2020-05-11	ABR.A-DELISTED	Stock	23.75	24.48	23.68	24.0779	4135.0
2020-05-11	ABR.B-DELISTED	Stock	23.12	24.6788	23.12	24.6788	3292.0
2020-05-11	ABR.C-DELISTED	Stock	24.5	24.7478	24.49	24.7478	4413.0
2020-05-11	ABT	Stock	93.22	96.49	93.14	96.07	7239100.0
2020-05-11	ABTC	Stock	236100.0	240000.0	225000.0	232200.0	1.84
2020-05-11	ABTS	Stock	13.485	13.485	11.25	11.85	2533.0
2020-05-11	ABTX-DELISTED	Stock	23.59	24.075	22.6	23.49	82794.0
2020-05-11	ABUS	Stock	1.48	1.5	1.24	1.44	1654300.0

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

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