PREVIEW / stock_daily / 2021-06-17

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-17.parquet
  size:    259 KB
  rows:    7,870
  symbols: 2,917

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
2021-06-17	AAPL	Stock	129.8	132.55	129.65	131.79	96721700.0
2021-06-17	MSFT	Stock	256.07	261.75	256.01	260.9	27565500.0
2021-06-17	NVDA	Stock	17.7745	18.835	17.7562	18.6572	809656000.0
2021-06-17	AMZN	Stock	170.159	174.86	170.05	174.462	102730000.0
2021-06-17	GOOGL	Stock	120.6975	122.5225	120.5	121.7435	25848880.0
2021-06-17	META	Stock	330.49	337.98	330.15	336.51	17794100.0
2021-06-17	TSLA	Stock	200.63	207.1567	200.4467	205.5333	68104200.0
2021-06-17	TLT	Stock	141.86	144.925	141.64	143.04	35225794.0
2021-06-17	ES	Stock	82.0	83.22	81.61	82.69	1601100.0
2021-06-17	CL	Stock	81.81	82.65	81.47	82.43	3253100.0
2021-06-17	A	Stock	143.49	147.68	143.49	146.92	2822400.0
2021-06-17	AA	Stock	35.26	35.35	32.63	33.58	12414500.0
2021-06-17	AAC-DELISTED	Stock	9.76	9.77	9.75	9.76	15352.0
2021-06-17	AACG	Stock	3.03	3.04	2.9	2.95	42100.0
2021-06-17	AACQ-DELISTED	Stock	10.0	10.0	9.97	9.98	3791682.0
2021-06-17	AACQU-DELISTED	Stock	10.7815	10.87	10.6236	10.87	2798.0
2021-06-17	AACQW-DELISTED	Stock	2.5	2.5	2.25	2.36	259073.0
2021-06-17	AAIC-DELISTED	Stock	4.1	4.1299	3.99	4.02	181300.0
2021-06-17	AAIC.C-DELISTED	Stock	24.81	24.9185	24.76	24.8439	5100.0
2021-06-17	AAL	Stock	22.83	23.13	21.83	22.23	32879100.0
2021-06-17	AAM.A-DELISTED	Stock	26.41	26.42	26.28	26.34	43881.0
2021-06-17	AAM.B-DELISTED	Stock	27.2	27.25	27.11	27.22	15302.0
2021-06-17	AAMC-DELISTED	Stock	5.7132	5.7132	5.6029	5.6029	6613.0
2021-06-17	AAME	Stock	4.23	4.27	4.03	4.05	86900.0
2021-06-17	AAMI	Stock	23.21	23.57	22.63	22.91	679200.0
2021-06-17	AAN-DELISTED	Stock	36.21	36.21	34.665	34.82	408700.0
2021-06-17	AAOI	Stock	8.8	8.9	8.62	8.62	384200.0
2021-06-17	AAON	Stock	42.0133	42.2067	41.4267	42.1267	226350.0
2021-06-17	AAP	Stock	197.35	197.56	193.23	194.39	1220700.0
2021-06-17	AAQC-DELISTED	Stock	9.75	9.75	9.68	9.72	23424.0
2021-06-17	AAT	Stock	38.2	38.36	37.36	37.89	394000.0
2021-06-17	AAU-DELISTED	Stock	0.51	0.5163	0.502	0.5034	810995.0
2021-06-17	AAUAF-DELISTED	Stock	0.51	0.5163	0.502	0.5058	829732.0
2021-06-17	AAWW-DELISTED	Stock	71.21	71.53	69.74	70.62	338001.0
2021-06-17	AAXJ	Stock	93.13	93.74	93.13	93.49	578275.0
2021-06-17	AB	Stock	44.85	45.25	44.3	44.65	284100.0
2021-06-17	ABB-DELISTED	Stock	33.68	33.78	33.2	33.45	1343961.0
2021-06-17	ABBNY-DELISTED	Stock	33.68	33.78	33.2	33.45	1483827.0
2021-06-17	ABBV	Stock	114.98	115.89	114.03	114.9	4172300.0
2021-06-17	ABC-DELISTED	Stock	118.53	118.725	116.92	118.11	461683.0
2021-06-17	ABCB	Stock	55.85	56.06	52.74	52.91	455200.0
2021-06-17	ABCL	Stock	23.01	23.09	22.35	22.81	2114600.0
2021-06-17	ABCM-DELISTED	Stock	18.84	19.34	18.84	19.27	166673.0
2021-06-17	ABEO	Stock	42.5	44.25	42.0	42.75	30936.0
2021-06-17	ABEV	Stock	3.86	3.88	3.74	3.76	34688300.0
2021-06-17	ABG	Stock	172.45	173.79	168.7	169.89	523100.0
2021-06-17	ABGI-DELISTED	Stock	9.9	9.95	9.9	9.93	1500.0
2021-06-17	ABM	Stock	46.69	46.69	45.43	45.6	413900.0
2021-06-17	ABMD-DELISTED	Stock	303.33	313.31	301.5227	312.72	249132.0
2021-06-17	ABNB	Stock	148.99	152.29	148.612	150.7	8171300.0

> showing 50 of 7,870 rows — these rows as CSV

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