PREVIEW / stock_daily / 2022-01-14

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-14.parquet
  size:    261 KB
  rows:    8,009
  symbols: 2,580

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
2022-01-14	AAPL	Stock	171.34	173.78	171.09	173.07	80440800.0
2022-01-14	MSFT	Stock	304.25	310.82	303.75	310.2	39846400.0
2022-01-14	NVDA	Stock	26.3	27.197	26.21	26.942	395832000.0
2022-01-14	AMZN	Stock	160.15	162.25	159.8005	162.138	45974000.0
2022-01-14	GOOGL	Stock	137.079	140.742	136.9985	139.4805	29661280.0
2022-01-14	META	Stock	321.79	332.73	321.21	331.9	16868500.0
2022-01-14	TSLA	Stock	339.96	350.6667	337.7933	349.87	72924300.0
2022-01-14	TLT	Stock	143.42	143.46	141.795	142.1	22997531.0
2022-01-14	ES	Stock	87.98	88.18	86.6	87.38	1195900.0
2022-01-14	CL	Stock	82.61	83.62	82.04	83.45	4431900.0
2022-01-14	A	Stock	144.04	145.15	142.36	144.68	2225400.0
2022-01-14	AA	Stock	60.27	61.44	59.34	61.39	4397100.0
2022-01-14	AAC-DELISTED	Stock	9.76	9.76	9.74	9.74	209755.0
2022-01-14	AACG	Stock	1.85	2.09	1.83	1.91	191900.0
2022-01-14	AACIU	Stock	10.07	10.07	10.05	10.0612	1615.0
2022-01-14	AACIW-DELISTED	Stock	0.4776	0.4776	0.4776	0.4776	244.0
2022-01-14	AAIC-DELISTED	Stock	3.51	3.59	3.51	3.58	46414.0
2022-01-14	AAIC.C-DELISTED	Stock	25.27	25.29	25.27	25.2899	702.0
2022-01-14	AAL	Stock	19.11	19.16	18.4	18.49	44983100.0
2022-01-14	AAM.A-DELISTED	Stock	25.39	25.5	25.39	25.5	27904.0
2022-01-14	AAM.B-DELISTED	Stock	26.5754	26.64	26.45	26.62	31917.0
2022-01-14	AAME	Stock	2.7	3.05	2.67	2.72	17700.0
2022-01-14	AAMI	Stock	24.23	24.52	24.06	24.44	525700.0
2022-01-14	AAN-DELISTED	Stock	22.56	23.095	22.56	22.96	192400.0
2022-01-14	AAOI	Stock	4.19	4.24	4.04	4.11	755400.0
2022-01-14	AAON	Stock	47.6267	48.0467	46.92	47.64	371250.0
2022-01-14	AAP	Stock	238.98	241.92	237.52	239.6	391000.0
2022-01-14	AAQC-DELISTED	Stock	9.71	9.71	9.7	9.7	603771.0
2022-01-14	AAT	Stock	38.6	39.05	38.35	38.88	240800.0
2022-01-14	AATC	Stock	6.24	6.3899	6.24	6.29	11021.0
2022-01-14	AAU-DELISTED	Stock	0.3	0.3	0.2845	0.2925	564536.0
2022-01-14	AAUAF-DELISTED	Stock	0.3	0.3	0.2845	0.2925	571198.0
2022-01-14	AAWW-DELISTED	Stock	85.14	85.217	81.9	82.21	661924.0
2022-01-14	AAXJ	Stock	84.08	84.665	84.0	84.36	850780.0
2022-01-14	AB	Stock	50.45	50.83	49.86	50.42	240700.0
2022-01-14	ABB-DELISTED	Stock	37.35	37.595	37.0	37.35	1650505.0
2022-01-14	ABBNY-DELISTED	Stock	37.35	37.595	37.0	37.35	1881048.0
2022-01-14	ABBV	Stock	133.35	136.05	132.29	135.87	10484500.0
2022-01-14	ABC-DELISTED	Stock	134.75	136.305	133.33	136.2	694272.0
2022-01-14	ABCB	Stock	54.0	55.39	54.0	55.27	354800.0
2022-01-14	ABCL	Stock	10.77	10.8	9.92	10.05	3533300.0
2022-01-14	ABCM-DELISTED	Stock	18.73	18.77	17.79	17.8	464266.0
2022-01-14	ABEO	Stock	7.5	7.5	6.5	6.75	297468.0
2022-01-14	ABEV	Stock	2.71	2.75	2.7	2.75	10849400.0
2022-01-14	ABG	Stock	166.02	168.3	163.13	167.21	238000.0
2022-01-14	ABGI-DELISTED	Stock	9.74	9.75	9.73	9.74	15770.0
2022-01-14	ABM	Stock	44.63	45.44	44.27	45.17	488300.0
2022-01-14	ABMD-DELISTED	Stock	304.64	311.105	295.605	300.96	197532.0
2022-01-14	ABNB	Stock	165.75	167.63	160.24	163.99	4144000.0
2022-01-14	ABOS	Stock	5.28	5.46	5.115	5.38	59400.0

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

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