PREVIEW / stock_daily / 2020-07-17

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-17.parquet
  size:    222 KB
  rows:    6,736
  symbols: 2,401

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-07-17	AAPL	Stock	96.9875	97.1475	95.84	96.3275	92186800.0
2020-07-17	MSFT	Stock	204.47	205.04	201.39	202.88	31635300.0
2020-07-17	NVDA	Stock	10.2255	10.2485	10.0878	10.2015	266284000.0
2020-07-17	AMZN	Stock	150.45	151.2	147.4225	148.0985	95226000.0
2020-07-17	GOOGL	Stock	75.8455	76.1715	74.905	75.8425	34264620.0
2020-07-17	META	Stock	241.0	244.16	237.86	242.03	18152400.0
2020-07-17	TSLA	Stock	100.8967	102.5007	99.3333	100.056	139950000.0
2020-07-17	TLT	Stock	167.27	167.4	166.47	166.78	8550164.0
2020-07-17	ES	Stock	86.47	88.14	86.22	87.84	1617200.0
2020-07-17	CL	Stock	74.92	75.29	74.38	75.2	2871800.0
2020-07-17	A	Stock	93.41	94.51	92.69	94.37	3457700.0
2020-07-17	AA	Stock	13.54	13.86	12.78	13.06	9756100.0
2020-07-17	AACG	Stock	1.76	1.76	1.59	1.71	70200.0
2020-07-17	AACQU-DELISTED	Stock	10.35	10.42	10.35	10.36	391012.0
2020-07-17	AAIC-DELISTED	Stock	3.02	3.085	2.9901	3.03	148201.0
2020-07-17	AAL	Stock	12.48	12.6	11.89	11.91	67934100.0
2020-07-17	AAM.A-DELISTED	Stock	26.4449	26.54	26.31	26.31	11994.0
2020-07-17	AAM.B-DELISTED	Stock	26.8501	26.98	26.75	26.75	13432.0
2020-07-17	AAMC-DELISTED	Stock	4.0459	4.2971	4.0459	4.1599	7058.0
2020-07-17	AAME	Stock	1.68	1.74	1.68	1.74	3500.0
2020-07-17	AAMI	Stock	12.38	12.475	12.19	12.35	444600.0
2020-07-17	AAOI	Stock	10.65	11.41	10.61	11.24	746000.0
2020-07-17	AAON	Stock	38.3333	38.8667	38.1667	38.7333	279750.0
2020-07-17	AAP	Stock	146.2	146.22	143.03	144.86	386500.0
2020-07-17	AAT	Stock	26.3	26.53	25.92	26.37	242000.0
2020-07-17	AAU-DELISTED	Stock	0.49	0.5046	0.47	0.4986	387134.0
2020-07-17	AAUAF-DELISTED	Stock	0.49	0.5046	0.47	0.4991	394290.0
2020-07-17	AAWW-DELISTED	Stock	49.34	50.09	48.98	49.96	295870.0
2020-07-17	AAXJ	Stock	74.02	74.12	73.6	73.94	936456.0
2020-07-17	AAXN-DELISTED	Stock	91.55	91.6188	90.26	90.68	357594.0
2020-07-17	AB	Stock	28.53	28.67	27.91	28.26	257800.0
2020-07-17	ABB-DELISTED	Stock	24.71	24.82	24.7	24.77	1369177.0
2020-07-17	ABBNY-DELISTED	Stock	24.71	24.82	24.7	24.76	1466757.0
2020-07-17	ABBV	Stock	100.29	101.28	99.92	100.83	6890900.0
2020-07-17	ABC-DELISTED	Stock	103.31	105.08	102.79	104.45	2392606.0
2020-07-17	ABCB	Stock	22.17	22.29	21.42	21.54	255300.0
2020-07-17	ABEO	Stock	74.75	76.25	72.75	74.5	23976.0
2020-07-17	ABEV	Stock	2.67	2.68	2.59	2.61	47180900.0
2020-07-17	ABG	Stock	101.43	101.43	97.68	99.25	169000.0
2020-07-17	ABM	Stock	35.16	36.28	35.0	36.09	523400.0
2020-07-17	ABMD-DELISTED	Stock	273.86	284.73	272.24	284.55	319208.0
2020-07-17	ABR	Stock	8.66	8.71	8.42	8.64	1129500.0
2020-07-17	ABR.A-DELISTED	Stock	24.94	24.94	24.94	24.94	200.0
2020-07-17	ABR.B-DELISTED	Stock	23.84	23.84	23.84	23.84	100.0
2020-07-17	ABR.C-DELISTED	Stock	24.96	24.96	24.96	24.96	400.0
2020-07-17	ABT	Stock	97.87	100.0	97.68	99.25	8315500.0
2020-07-17	ABTC	Stock	213300.0	217740.0	204000.0	208500.0	2.5199999999999996
2020-07-17	ABTS	Stock	16.8	17.025	16.8	16.8	2353.0
2020-07-17	ABTX-DELISTED	Stock	23.61	23.91	22.99	23.07	28258.0
2020-07-17	ABUS	Stock	2.09	2.58	2.04	2.4	3518200.0

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

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