PREVIEW / stock_daily / 2021-03-31

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-31.parquet
  size:    253 KB
  rows:    7,735
  symbols: 2,923

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-03-31	AAPL	Stock	121.65	123.52	121.15	122.15	118323800.0
2021-03-31	MSFT	Stock	232.91	239.1	232.39	235.77	43623500.0
2021-03-31	NVDA	Stock	13.0155	13.4705	12.9825	13.3482	314776000.0
2021-03-31	AMZN	Stock	153.203	155.9665	153.125	154.704	61878000.0
2021-03-31	GOOGL	Stock	102.72	104.313	102.35	103.126	42569640.0
2021-03-31	META	Stock	289.99	296.5	288.61	294.53	19498200.0
2021-03-31	TSLA	Stock	215.54	224.0	213.7033	222.6433	100011900.0
2021-03-31	TLT	Stock	136.34	136.59	134.98	135.45	19271281.0
2021-03-31	ES	Stock	86.15	86.84	85.82	86.59	1785600.0
2021-03-31	CL	Stock	79.75	79.82	78.61	78.83	4493200.0
2021-03-31	A	Stock	125.95	128.48	125.95	127.14	1815500.0
2021-03-31	AA	Stock	33.66	34.29	32.11	32.49	7236600.0
2021-03-31	AAC-DELISTED	Stock	9.75	9.9	9.75	9.9	76783.0
2021-03-31	AACG	Stock	4.2	4.75	4.2	4.37	2152400.0
2021-03-31	AACQ-DELISTED	Stock	10.1	10.1	10.04	10.1	1188638.0
2021-03-31	AACQU-DELISTED	Stock	10.6	10.69	10.6	10.66	3709.0
2021-03-31	AACQW-DELISTED	Stock	1.7	1.741	1.67	1.7	63659.0
2021-03-31	AAIC-DELISTED	Stock	3.98	4.11	3.92	4.05	222262.0
2021-03-31	AAIC.C-DELISTED	Stock	23.51	23.51	23.365	23.51	1964.0
2021-03-31	AAL	Stock	24.03	24.12	23.61	23.9	29800300.0
2021-03-31	AAM.A-DELISTED	Stock	25.91	25.99	25.91	25.92	29631.0
2021-03-31	AAM.B-DELISTED	Stock	26.83	26.87	26.78	26.78	18292.0
2021-03-31	AAMC-DELISTED	Stock	5.3	5.748	5.1147	5.5882	176678.0
2021-03-31	AAME	Stock	3.59	3.75	3.59	3.68	57300.0
2021-03-31	AAMI	Stock	20.98	21.0	19.62	20.38	1115400.0
2021-03-31	AAN-DELISTED	Stock	25.25	26.01	25.01	25.68	335900.0
2021-03-31	AAOI	Stock	8.06	8.43	7.99	8.36	480100.0
2021-03-31	AAON	Stock	47.4333	47.82	46.4533	46.6733	401850.0
2021-03-31	AAP	Stock	186.69	186.77	183.49	183.49	729900.0
2021-03-31	AAT	Stock	32.72	32.96	32.1	32.44	504000.0
2021-03-31	AAU-DELISTED	Stock	0.5115	0.5535	0.511	0.5317	2083801.0
2021-03-31	AAUAF-DELISTED	Stock	0.5115	0.5535	0.511	0.5317	2133074.0
2021-03-31	AAWW-DELISTED	Stock	59.91	60.94	58.8	60.44	453218.0
2021-03-31	AAXJ	Stock	92.01	92.97	92.01	92.66	269369.0
2021-03-31	AB	Stock	39.99	40.46	39.81	39.99	384200.0
2021-03-31	ABB-DELISTED	Stock	30.41	30.57	30.3031	30.47	1324593.0
2021-03-31	ABBNY-DELISTED	Stock	30.41	30.57	30.3031	30.47	1964450.0
2021-03-31	ABBV	Stock	106.88	109.18	106.8	108.22	9048000.0
2021-03-31	ABC-DELISTED	Stock	118.7	119.51	117.855	118.07	1097321.0
2021-03-31	ABCB	Stock	53.02	53.83	52.28	52.51	507400.0
2021-03-31	ABCL	Stock	28.2	36.78	27.5	33.96	3243900.0
2021-03-31	ABCM-DELISTED	Stock	19.3	19.439	19.15	19.22	48670.0
2021-03-31	ABEO	Stock	45.75	48.75	45.25	47.0	47704.0
2021-03-31	ABEV	Stock	2.72	2.78	2.71	2.74	11848900.0
2021-03-31	ABG	Stock	201.34	203.81	195.51	196.5	258400.0
2021-03-31	ABGI-DELISTED	Stock	9.74	9.9	9.74	9.89	9580.0
2021-03-31	ABM	Stock	50.91	51.65	50.61	51.01	508000.0
2021-03-31	ABMD-DELISTED	Stock	311.76	321.8299	307.795	319.05	201248.0
2021-03-31	ABNB	Stock	185.43	192.275	185.13	187.94	3079500.0
2021-03-31	ABR	Stock	16.03	16.15	15.9	15.9	1348900.0

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

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