PREVIEW / stock_daily / 2021-01-21

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-21.parquet
  size:    242 KB
  rows:    7,313
  symbols: 2,655

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-01-21	AAPL	Stock	133.8	139.67	133.59	136.87	120150900.0
2021-01-21	MSFT	Stock	224.7	226.3	222.42	224.97	30709400.0
2021-01-21	NVDA	Stock	13.4185	13.9993	13.253	13.8675	337780000.0
2021-01-21	AMZN	Stock	164.65	167.4275	164.4785	165.3495	98722000.0
2021-01-21	GOOGL	Stock	94.6825	96.604	93.9705	94.2075	58659460.0
2021-01-21	META	Stock	269.26	273.6	267.49	272.87	20838700.0
2021-01-21	TSLA	Stock	285.0	285.24	280.4733	281.6633	61563300.0
2021-01-21	TLT	Stock	151.44	151.75	151.1	151.39	8164729.0
2021-01-21	ES	Stock	87.24	87.53	86.5	87.13	1086600.0
2021-01-21	CL	Stock	80.18	80.43	78.76	79.28	5772000.0
2021-01-21	A	Stock	127.77	128.78	126.42	127.0	1612100.0
2021-01-21	AA	Stock	20.93	21.7	20.0	20.01	22833800.0
2021-01-21	AACG	Stock	1.41	1.42	1.35	1.4	40500.0
2021-01-21	AACQ-DELISTED	Stock	10.87	11.09	10.78	10.92	2089764.0
2021-01-21	AACQU-DELISTED	Stock	11.65	11.9022	11.57	11.79	86423.0
2021-01-21	AACQW-DELISTED	Stock	2.54	2.6	2.36	2.58	374966.0
2021-01-21	AAIC-DELISTED	Stock	3.83	3.9	3.77	3.88	142072.0
2021-01-21	AAIC.C-DELISTED	Stock	21.265	21.5	21.265	21.5	7560.0
2021-01-21	AAL	Stock	15.99	16.22	15.56	15.83	50639200.0
2021-01-21	AAM.A-DELISTED	Stock	26.61	26.85	26.415	26.4294	8697.0
2021-01-21	AAM.B-DELISTED	Stock	27.38	27.38	26.87	26.88	20340.0
2021-01-21	AAMC-DELISTED	Stock	6.4324	6.4324	6.3093	6.3093	2829.0
2021-01-21	AAME	Stock	2.4	2.45	2.29	2.45	11300.0
2021-01-21	AAMI	Stock	21.39	21.69	20.73	20.74	369600.0
2021-01-21	AAN-DELISTED	Stock	20.75	20.79	20.18	20.19	364400.0
2021-01-21	AAOI	Stock	10.75	10.75	10.25	10.49	486000.0
2021-01-21	AAON	Stock	47.9933	48.1667	47.1733	47.7667	250350.0
2021-01-21	AAP	Stock	165.02	167.78	165.02	166.68	472100.0
2021-01-21	AAT	Stock	29.85	29.93	28.7	29.07	328700.0
2021-01-21	AAU-DELISTED	Stock	0.56	0.6502	0.56	0.6365	6428499.0
2021-01-21	AAUAF-DELISTED	Stock	0.56	0.6502	0.56	0.6302	6564334.0
2021-01-21	AAWW-DELISTED	Stock	52.49	52.87	51.9	52.23	229585.0
2021-01-21	AAXJ	Stock	99.01	99.0899	98.36	99.0	1507446.0
2021-01-21	AAXN-DELISTED	Stock	168.04	168.4	161.71	162.54	668785.0
2021-01-21	AB	Stock	36.23	36.45	35.58	35.61	275000.0
2021-01-21	ABB-DELISTED	Stock	29.98	30.16	29.88	30.16	1535111.0
2021-01-21	ABBNY-DELISTED	Stock	29.98	30.16	29.88	30.16	1767800.0
2021-01-21	ABBV	Stock	112.63	112.75	110.76	111.26	5417000.0
2021-01-21	ABC-DELISTED	Stock	103.67	105.41	102.725	104.97	878037.0
2021-01-21	ABCB	Stock	44.66	44.66	42.91	42.95	266200.0
2021-01-21	ABCL	Stock	49.0	51.49	48.07	50.9	1003800.0
2021-01-21	ABCM-DELISTED	Stock	23.54	23.76	23.26	23.35	79260.0
2021-01-21	ABEO	Stock	51.25	51.5	47.5	49.5	110948.0
2021-01-21	ABEV	Stock	3.05	3.05	2.91	2.94	19541500.0
2021-01-21	ABG	Stock	167.35	170.04	166.87	167.3	178800.0
2021-01-21	ABM	Stock	39.48	39.89	38.62	39.11	411300.0
2021-01-21	ABMD-DELISTED	Stock	350.41	352.28	341.77	348.64	182911.0
2021-01-21	ABNB	Stock	164.99	183.47	155.33	180.4	17618400.0
2021-01-21	ABR	Stock	14.69	14.75	14.46	14.65	791000.0
2021-01-21	ABR.A-DELISTED	Stock	25.6858	25.76	25.6858	25.73	1650.0

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

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