PREVIEW / stock_daily / 2021-07-06

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-06.parquet
  size:    257 KB
  rows:    7,898
  symbols: 2,877

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-07-06	AAPL	Stock	140.07	143.15	140.07	142.02	108181800.0
2021-07-06	MSFT	Stock	278.03	279.37	274.3	277.66	31565600.0
2021-07-06	NVDA	Stock	20.7375	20.842	20.3503	20.6985	446708000.0
2021-07-06	AMZN	Stock	176.5055	184.274	176.45	183.787	134896000.0
2021-07-06	GOOGL	Stock	125.6485	126.428	124.5825	126.19	26403580.0
2021-07-06	META	Stock	356.5	358.79	349.18	352.78	13488500.0
2021-07-06	TSLA	Stock	227.2367	228.0	217.1333	219.86	69853500.0
2021-07-06	TLT	Stock	145.72	146.99	145.715	146.74	20037177.0
2021-07-06	ES	Stock	80.68	81.08	79.57	81.04	1130600.0
2021-07-06	CL	Stock	81.67	82.1	81.45	81.97	3221000.0
2021-07-06	A	Stock	149.23	149.23	148.48	148.98	1973300.0
2021-07-06	AA	Stock	37.61	37.948	36.24	36.47	8577500.0
2021-07-06	AAC-DELISTED	Stock	9.73	9.76	9.73	9.75	42929.0
2021-07-06	AACG	Stock	2.88	2.91	2.81	2.87	39100.0
2021-07-06	AAIC-DELISTED	Stock	4.0	4.02	3.87	3.9	306552.0
2021-07-06	AAIC.C-DELISTED	Stock	25.15	25.4	25.0866	25.225	10720.0
2021-07-06	AAL	Stock	21.5	21.79	20.86	21.01	24176500.0
2021-07-06	AAM.A-DELISTED	Stock	26.41	26.46	26.31	26.42	21541.0
2021-07-06	AAM.B-DELISTED	Stock	26.94	26.95	26.9	26.95	11895.0
2021-07-06	AAMC-DELISTED	Stock	5.5882	5.5882	5.4324	5.5162	36081.0
2021-07-06	AAME	Stock	4.46	4.46	4.31	4.4	49300.0
2021-07-06	AAMI	Stock	24.14	24.39	23.92	23.99	406900.0
2021-07-06	AAN-DELISTED	Stock	32.33	32.46	30.89	31.13	275200.0
2021-07-06	AAOI	Stock	8.43	8.43	8.023	8.16	561000.0
2021-07-06	AAON	Stock	42.0067	42.42	40.8867	41.6333	241650.0
2021-07-06	AAP	Stock	210.4	210.55	206.47	208.7	540600.0
2021-07-06	AAQC-DELISTED	Stock	9.6758	9.6863	9.6648	9.67	27921.0
2021-07-06	AAT	Stock	37.5	37.59	36.77	37.46	297200.0
2021-07-06	AAU-DELISTED	Stock	0.51	0.51	0.4801	0.4826	834945.0
2021-07-06	AAUAF-DELISTED	Stock	0.51	0.51	0.4801	0.4826	863115.0
2021-07-06	AAWW-DELISTED	Stock	68.85	68.93	66.2	66.7	232631.0
2021-07-06	AAXJ	Stock	92.87	92.87	91.935	92.26	811566.0
2021-07-06	AB	Stock	47.0	47.36	46.06	47.29	252100.0
2021-07-06	ABB-DELISTED	Stock	34.75	34.78	34.3375	34.56	1117812.0
2021-07-06	ABBNY-DELISTED	Stock	34.75	34.78	34.3375	34.56	1214883.0
2021-07-06	ABBV	Stock	115.17	115.9	114.77	115.73	7172100.0
2021-07-06	ABC-DELISTED	Stock	116.04	116.13	112.66	115.42	691344.0
2021-07-06	ABCB	Stock	49.98	50.23	48.25	48.88	381300.0
2021-07-06	ABCL	Stock	20.46	21.1	19.575	19.62	1840700.0
2021-07-06	ABCM-DELISTED	Stock	19.33	19.44	18.89	19.255	179580.0
2021-07-06	ABEO	Stock	38.5	39.0	36.5	37.5	52748.0
2021-07-06	ABEV	Stock	3.43	3.45	3.32	3.36	22813200.0
2021-07-06	ABG	Stock	175.73	175.94	171.75	174.35	210300.0
2021-07-06	ABM	Stock	44.25	44.32	42.64	43.4	527000.0
2021-07-06	ABMD-DELISTED	Stock	317.28	328.2	317.12	326.71	175431.0
2021-07-06	ABNB	Stock	150.08	152.8	147.81	148.37	5069400.0
2021-07-06	ABOS	Stock	19.31	20.59	18.01	20.2	151600.0
2021-07-06	ABR	Stock	17.89	17.9	17.35	17.72	1568600.0
2021-07-06	ABR.D	Stock	25.42	25.53	25.4	25.42	93289.0
2021-07-06	ABST-DELISTED	Stock	14.48	14.48	14.05	14.155	33429.0

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

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