PREVIEW / stock_daily / 2021-04-08

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-08.parquet
  size:    253 KB
  rows:    7,728
  symbols: 2,912

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-04-08	AAPL	Stock	128.95	130.39	128.52	130.36	88844600.0
2021-04-08	MSFT	Stock	252.77	254.14	252.0	253.25	23625200.0
2021-04-08	NVDA	Stock	14.2528	14.4715	14.249	14.317	244416000.0
2021-04-08	AMZN	Stock	165.545	166.225	164.6	164.965	56242000.0
2021-04-08	GOOGL	Stock	113.2	113.5895	112.1505	112.5215	28664280.0
2021-04-08	META	Stock	314.85	315.88	310.05	313.02	20894100.0
2021-04-08	TSLA	Stock	225.7933	229.85	223.8833	227.9333	71772900.0
2021-04-08	TLT	Stock	137.39	138.07	137.36	138.01	7847918.0
2021-04-08	ES	Stock	88.0	88.19	86.97	87.24	1337100.0
2021-04-08	CL	Stock	79.7	79.85	79.19	79.64	3773000.0
2021-04-08	A	Stock	130.26	131.73	129.87	130.69	925100.0
2021-04-08	AA	Stock	31.8	31.92	30.025	31.45	5776100.0
2021-04-08	AAC-DELISTED	Stock	9.83	9.92	9.81	9.9	57305.0
2021-04-08	AACG	Stock	4.0	4.14	3.86	4.06	311700.0
2021-04-08	AACQ-DELISTED	Stock	10.29	10.44	10.26	10.38	639167.0
2021-04-08	AACQU-DELISTED	Stock	11.02	11.05	10.98	11.05	5100.0
2021-04-08	AACQW-DELISTED	Stock	1.98	2.1	1.98	2.0	69431.0
2021-04-08	AAIC-DELISTED	Stock	4.06	4.08	4.0	4.07	92722.0
2021-04-08	AAIC.C-DELISTED	Stock	23.6	23.68	23.5915	23.65	9769.0
2021-04-08	AAL	Stock	23.88	23.88	22.63	23.65	28606600.0
2021-04-08	AAM.A-DELISTED	Stock	26.26	26.26	26.06	26.07	9349.0
2021-04-08	AAM.B-DELISTED	Stock	26.95	26.95	26.85	26.88	6803.0
2021-04-08	AAMC-DELISTED	Stock	5.6824	5.6824	5.4735	5.5912	10924.0
2021-04-08	AAME	Stock	3.8	4.39	3.78	3.98	1965800.0
2021-04-08	AAMI	Stock	21.52	22.75	21.27	22.55	2028600.0
2021-04-08	AAN-DELISTED	Stock	25.2	25.2	24.545	24.94	189800.0
2021-04-08	AAOI	Stock	8.52	8.52	8.28	8.41	301900.0
2021-04-08	AAON	Stock	46.3	46.5933	45.5	45.8	200100.0
2021-04-08	AAP	Stock	183.05	183.05	179.6	180.5	546200.0
2021-04-08	AAT	Stock	33.19	33.19	32.77	32.94	206700.0
2021-04-08	AAU-DELISTED	Stock	0.55	0.55	0.5346	0.5457	997953.0
2021-04-08	AAUAF-DELISTED	Stock	0.55	0.55	0.5346	0.5457	1060384.0
2021-04-08	AAWW-DELISTED	Stock	62.28	62.28	60.69	61.79	288831.0
2021-04-08	AAXJ	Stock	94.21	94.34	93.91	93.93	584930.0
2021-04-08	AB	Stock	40.58	40.8	40.45	40.68	219100.0
2021-04-08	ABB-DELISTED	Stock	31.58	31.6	31.4	31.58	1565896.0
2021-04-08	ABBNY-DELISTED	Stock	31.58	31.6	31.4	31.58	1700609.0
2021-04-08	ABBV	Stock	105.4	106.92	105.35	106.1	5881800.0
2021-04-08	ABC-DELISTED	Stock	116.26	116.505	114.8	115.49	425681.0
2021-04-08	ABCB	Stock	51.63	51.75	49.98	51.47	467100.0
2021-04-08	ABCL	Stock	30.79	31.62	29.63	30.59	814100.0
2021-04-08	ABCM-DELISTED	Stock	19.89	20.0	19.54	19.72	71875.0
2021-04-08	ABEO	Stock	41.0	42.75	39.75	41.75	47584.0
2021-04-08	ABEV	Stock	2.76	2.84	2.74	2.81	44545000.0
2021-04-08	ABG	Stock	193.82	195.75	190.34	195.4	142500.0
2021-04-08	ABGI-DELISTED	Stock	9.9303	9.95	9.93	9.95	4271.0
2021-04-08	ABM	Stock	51.23	52.09	50.54	52.01	571200.0
2021-04-08	ABMD-DELISTED	Stock	324.34	331.22	320.67	329.83	159946.0
2021-04-08	ABNB	Stock	181.648	183.9	179.3	180.18	2625300.0
2021-04-08	ABR	Stock	15.9	16.2	15.88	16.17	1308300.0

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

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