PREVIEW / stock_daily / 2021-12-27

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-27.parquet
  size:    260 KB
  rows:    8,013
  symbols: 2,609

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-12-27	AAPL	Stock	177.09	180.42	177.07	180.33	74919600.0
2021-12-27	MSFT	Stock	335.46	342.48	335.43	342.45	19947000.0
2021-12-27	NVDA	Stock	29.66	31.087	29.64	30.945	403686000.0
2021-12-27	AMZN	Stock	171.037	172.943	169.2155	169.6695	58688000.0
2021-12-27	GOOGL	Stock	147.256	148.344	147.1692	147.9065	15984460.0
2021-12-27	META	Stock	338.85	347.87	338.01	346.18	17795000.0
2021-12-27	TSLA	Stock	357.89	372.3333	356.9067	364.6467	71145900.0
2021-12-27	TLT	Stock	148.46	149.01	148.32	148.88	7822856.0
2021-12-27	ES	Stock	89.8	89.88	88.84	89.22	819700.0
2021-12-27	CL	Stock	83.0	84.05	82.89	83.91	3189600.0
2021-12-27	A	Stock	158.82	159.84	157.19	158.74	951800.0
2021-12-27	AA	Stock	58.37	59.86	57.23	59.83	6268000.0
2021-12-27	AAC-DELISTED	Stock	9.77	9.77	9.74	9.74	7754.0
2021-12-27	AACG	Stock	1.25	1.26	1.15	1.18	28400.0
2021-12-27	AACIW-DELISTED	Stock	0.5199	0.57	0.5199	0.54765	5570.0
2021-12-27	AAIC-DELISTED	Stock	3.54	3.58	3.54	3.54	144947.0
2021-12-27	AAL	Stock	17.66	18.24	17.55	18.17	28059300.0
2021-12-27	AAM.A-DELISTED	Stock	25.48	25.49	25.44	25.45	10795.0
2021-12-27	AAM.B-DELISTED	Stock	26.51	26.6699	26.44	26.45	6893.0
2021-12-27	AAME	Stock	3.09	3.24	3.03	3.06	26100.0
2021-12-27	AAMI	Stock	25.71	26.06	25.5	26.02	694800.0
2021-12-27	AAN-DELISTED	Stock	24.54	24.98	24.12	24.82	126200.0
2021-12-27	AAOI	Stock	5.61	5.685	5.59	5.59	559200.0
2021-12-27	AAON	Stock	52.5533	53.2667	52.4867	53.2067	195600.0
2021-12-27	AAP	Stock	233.37	236.74	232.21	236.5	347600.0
2021-12-27	AAT	Stock	36.26	36.74	36.04	36.73	132200.0
2021-12-27	AATC	Stock	6.44	6.5	6.2935	6.4	10207.0
2021-12-27	AAU-DELISTED	Stock	0.31	0.311	0.3038	0.3038	717463.0
2021-12-27	AAUAF-DELISTED	Stock	0.31	0.311	0.3023	0.3023	720787.0
2021-12-27	AAWW-DELISTED	Stock	92.57	93.25	91.0476	92.69	133707.0
2021-12-27	AAXJ	Stock	82.56	82.93	82.41	82.7	832773.0
2021-12-27	AB	Stock	49.83	49.87	48.55	48.77	226300.0
2021-12-27	ABB-DELISTED	Stock	37.92	38.3	37.9162	38.27	876071.0
2021-12-27	ABBNY-DELISTED	Stock	37.92	38.3	37.9162	38.27	978985.0
2021-12-27	ABBV	Stock	133.19	134.48	133.16	134.41	4436800.0
2021-12-27	ABC-DELISTED	Stock	129.92	132.15	129.6001	131.9	370933.0
2021-12-27	ABCB	Stock	49.44	49.78	48.72	49.75	185000.0
2021-12-27	ABCL	Stock	14.93	15.65	14.71	14.75	1374900.0
2021-12-27	ABCM-DELISTED	Stock	22.43	23.84	22.43	23.83	112470.0
2021-12-27	ABEO	Stock	9.0	9.25	8.0	8.0	243360.0
2021-12-27	ABEV	Stock	2.74	2.76	2.73	2.74	6117200.0
2021-12-27	ABG	Stock	164.0	168.28	163.58	167.49	128000.0
2021-12-27	ABGI-DELISTED	Stock	9.75	9.79	9.75	9.79	38707.0
2021-12-27	ABM	Stock	41.41	41.72	41.12	41.38	287500.0
2021-12-27	ABMD-DELISTED	Stock	353.8	358.19	349.46	357.93	82284.0
2021-12-27	ABNB	Stock	169.806	172.43	168.78	171.68	2725200.0
2021-12-27	ABOS	Stock	7.0	7.08	6.77	6.83	109300.0
2021-12-27	ABR	Stock	18.17	18.26	17.97	18.25	1244600.0
2021-12-27	ABR.D	Stock	25.3	25.3	25.18	25.25	14708.0
2021-12-27	ABR.E	Stock	25.29	25.29	25.155	25.2	4982.0

> showing 50 of 8,013 rows — these rows as CSV

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