PREVIEW / stock_daily / 2021-12-29

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-29.parquet
  size:    260 KB
  rows:    8,007
  symbols: 2,613

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-29	AAPL	Stock	179.33	180.63	178.14	179.38	62348900.0
2021-12-29	MSFT	Stock	341.3	344.3	339.68	341.95	15042000.0
2021-12-29	NVDA	Stock	30.273	30.548	29.366	30.001	343139000.0
2021-12-29	AMZN	Stock	170.84	171.212	168.6005	169.201	35754000.0
2021-12-29	GOOGL	Stock	146.6443	147.417	145.6475	146.655	17787460.0
2021-12-29	META	Stock	346.91	349.69	341.64	342.94	10747000.0
2021-12-29	TSLA	Stock	366.2133	368.0	354.7133	362.0633	56154000.0
2021-12-29	TLT	Stock	146.91	147.309	146.41	146.67	11771223.0
2021-12-29	ES	Stock	90.15	90.64	89.75	90.61	577500.0
2021-12-29	CL	Stock	84.59	85.09	84.25	84.91	2628900.0
2021-12-29	A	Stock	159.83	161.39	159.18	160.65	833100.0
2021-12-29	AA	Stock	59.13	60.12	58.67	59.63	4022700.0
2021-12-29	AAC-DELISTED	Stock	9.74	9.7599	9.74	9.74	33716.0
2021-12-29	AACG	Stock	1.17	1.17	1.04	1.06	76700.0
2021-12-29	AACIW-DELISTED	Stock	0.5198	0.5494	0.5198	0.5198	471.0
2021-12-29	AAIC-DELISTED	Stock	3.52	3.55	3.51	3.51	74493.0
2021-12-29	AAIC.C-DELISTED	Stock	25.36	25.36	25.36	25.36	125.0
2021-12-29	AAL	Stock	18.4	18.43	17.99	18.05	22627000.0
2021-12-29	AAM.A-DELISTED	Stock	25.4505	25.56	25.43	25.56	9965.0
2021-12-29	AAM.B-DELISTED	Stock	26.592	26.67	26.49	26.67	8053.0
2021-12-29	AAME	Stock	3.11	3.12	2.85	2.88	34400.0
2021-12-29	AAMI	Stock	25.82	25.89	25.41	25.64	5952300.0
2021-12-29	AAN-DELISTED	Stock	24.7	24.97	24.59	24.79	108600.0
2021-12-29	AAOI	Stock	5.49	5.5	5.29	5.3	423600.0
2021-12-29	AAON	Stock	53.0067	53.2867	52.4933	53.14	93900.0
2021-12-29	AAP	Stock	238.94	242.2	238.37	241.03	510400.0
2021-12-29	AAQC-DELISTED	Stock	9.71	9.72	9.7002	9.72	6443.0
2021-12-29	AAT	Stock	36.74	36.77	36.36	36.76	569700.0
2021-12-29	AATC	Stock	6.26	6.4999	6.26	6.4336	19577.0
2021-12-29	AAU-DELISTED	Stock	0.29	0.2997	0.2869	0.2882	889695.0
2021-12-29	AAUAF-DELISTED	Stock	0.29	0.2997	0.2869	0.2882	896611.0
2021-12-29	AAWW-DELISTED	Stock	92.93	94.72	92.665	93.77	168341.0
2021-12-29	AAXJ	Stock	82.39	82.47	81.76	82.16	1222864.0
2021-12-29	AB	Stock	48.65	48.96	48.35	48.76	211900.0
2021-12-29	ABB-DELISTED	Stock	38.32	38.66	38.32	38.66	808545.0
2021-12-29	ABBNY-DELISTED	Stock	38.32	38.66	38.32	38.65	907026.0
2021-12-29	ABBV	Stock	134.61	135.87	134.08	135.36	5594300.0
2021-12-29	ABC-DELISTED	Stock	132.36	133.665	132.19	133.36	373132.0
2021-12-29	ABCB	Stock	50.08	50.58	49.63	50.25	179300.0
2021-12-29	ABCL	Stock	13.64	13.95	13.3	13.67	2014500.0
2021-12-29	ABCM-DELISTED	Stock	23.27	23.64	23.05	23.58	62178.0
2021-12-29	ABEO	Stock	7.5	7.5	7.25	7.25	166180.0
2021-12-29	ABEV	Stock	2.72	2.73	2.69	2.71	9035800.0
2021-12-29	ABG	Stock	170.64	171.66	168.43	169.0	104900.0
2021-12-29	ABGI-DELISTED	Stock	9.7501	9.79	9.7501	9.79	900.0
2021-12-29	ABM	Stock	40.9	41.31	40.52	40.59	226100.0
2021-12-29	ABMD-DELISTED	Stock	358.55	363.86	358.0	361.78	68901.0
2021-12-29	ABNB	Stock	169.52	170.48	165.02	167.44	1995400.0
2021-12-29	ABOS	Stock	6.74	6.76	6.49	6.65	68500.0
2021-12-29	ABR	Stock	18.43	18.52	18.25	18.49	767500.0

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

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