PREVIEW / stock_daily / 2020-06-11

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-11.parquet
  size:    221 KB
  rows:    6,694
  symbols: 2,396

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-11	AAPL	Stock	87.3275	87.765	83.87	83.975	201662400.0
2020-06-11	MSFT	Stock	193.13	195.76	186.07	186.27	52854700.0
2020-06-11	NVDA	Stock	9.15	9.2612	8.786	8.7962	583652000.0
2020-06-11	AMZN	Stock	130.175	133.569	126.8115	127.898	116002000.0
2020-06-11	GOOGL	Stock	72.0515	72.5802	69.9205	70.095	47144860.0
2020-06-11	META	Stock	229.94	232.89	223.55	224.43	26708200.0
2020-06-11	TSLA	Stock	66.0133	67.9307	64.8	64.856	238747500.0
2020-06-11	TLT	Stock	163.245	164.23	162.63	163.88	17086373.0
2020-06-11	ES	Stock	86.0	86.18	83.15	84.35	2812000.0
2020-06-11	CL	Stock	73.85	75.0	72.82	73.1	5547300.0
2020-06-11	A	Stock	88.63	88.63	85.02	85.03	2491300.0
2020-06-11	AA	Stock	10.89	11.44	10.27	10.42	11959400.0
2020-06-11	AACG	Stock	1.31	1.5	1.02	1.12	416100.0
2020-06-11	AAIC-DELISTED	Stock	2.93	3.045	2.8	2.82	600276.0
2020-06-11	AAIC.C-DELISTED	Stock	19.825	19.825	19.0	19.79	8384.0
2020-06-11	AAL	Stock	14.61	15.68	14.07	14.38	124220800.0
2020-06-11	AAM.A-DELISTED	Stock	25.59	25.84	25.17	25.72	35934.0
2020-06-11	AAM.B-DELISTED	Stock	26.14	26.14	25.5	25.7	17008.0
2020-06-11	AAMC-DELISTED	Stock	5.8235	5.8235	4.2647	4.4382	48406.0
2020-06-11	AAME	Stock	1.91	1.91	1.87	1.87	800.0
2020-06-11	AAMI	Stock	9.24	9.68	9.1	9.12	520400.0
2020-06-11	AAOI	Stock	9.0	9.32	8.65	8.65	542500.0
2020-06-11	AAON	Stock	36.6267	36.6267	34.5467	34.5933	618000.0
2020-06-11	AAP	Stock	136.71	138.83	131.6	133.13	943000.0
2020-06-11	AAT	Stock	28.92	29.92	28.04	28.25	485200.0
2020-06-11	AAU-DELISTED	Stock	0.55	0.55	0.48	0.4849	740558.0
2020-06-11	AAUAF-DELISTED	Stock	0.55	0.55	0.48	0.4849	806095.0
2020-06-11	AAWW-DELISTED	Stock	39.41	40.38	38.79	39.19	460686.0
2020-06-11	AAXJ	Stock	68.3	68.61	66.94	66.97	3092690.0
2020-06-11	AAXN-DELISTED	Stock	98.51	98.58	90.0	90.01	1108425.0
2020-06-11	AB	Stock	25.16	25.72	24.15	24.5	670200.0
2020-06-11	ABB-DELISTED	Stock	21.31	21.37	20.365	20.38	3227112.0
2020-06-11	ABBNY-DELISTED	Stock	21.3	21.37	20.365	20.39	3413884.0
2020-06-11	ABBV	Stock	95.69	96.89	92.03	92.26	12584800.0
2020-06-11	ABC-DELISTED	Stock	95.79	95.79	92.57	93.51	1063167.0
2020-06-11	ABCB	Stock	24.53	24.88	23.12	23.33	530700.0
2020-06-11	ABEO	Stock	67.5	70.0	64.5	65.0	38332.0
2020-06-11	ABEV	Stock	2.65	2.69	2.59	2.64	33465700.0
2020-06-11	ABG	Stock	73.45	75.25	72.3	73.93	223100.0
2020-06-11	ABM	Stock	32.3	32.76	31.32	31.46	375400.0
2020-06-11	ABMD-DELISTED	Stock	246.41	246.43	234.0	235.1101	366117.0
2020-06-11	ABR	Stock	9.05	9.57	8.76	9.05	2789400.0
2020-06-11	ABR.A-DELISTED	Stock	24.5	24.5	23.51	23.55	15464.0
2020-06-11	ABR.B-DELISTED	Stock	23.49	23.49	20.63	23.38	6442.0
2020-06-11	ABR.C-DELISTED	Stock	24.85	24.9901	23.85	23.9	5208.0
2020-06-11	ABT	Stock	92.17	92.5	86.94	87.78	8168300.0
2020-06-11	ABTC	Stock	318000.0	318000.0	295110.0	300000.0	4.426666666666667
2020-06-11	ABTS	Stock	18.3	20.4	16.5	17.7	28327.0
2020-06-11	ABTX-DELISTED	Stock	25.41	25.74	24.36	24.53	52746.0
2020-06-11	ABUS	Stock	1.8	1.8	1.6	1.64	1307200.0

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

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