PREVIEW / stock_daily / 2022-05-04

all stock daily files

  file:    by_date/stock_daily/2022/2022-05-04.parquet
  size:    259 KB
  rows:    8,006
  symbols: 2,438

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-05-04	AAPL	Stock	159.67	166.48	159.26	166.02	108256500.0
2022-05-04	MSFT	Stock	282.59	290.88	276.73	289.98	33599300.0
2022-05-04	NVDA	Stock	19.923	20.4	18.751	20.334	648855000.0
2022-05-04	AMZN	Stock	123.6	126.0	119.183	125.9285	110746000.0
2022-05-04	GOOGL	Stock	117.0315	122.8545	115.116	122.261	49915280.0
2022-05-04	META	Stock	210.65	224.3	206.96	223.41	41375900.0
2022-05-04	TSLA	Stock	301.3133	318.5	295.0933	317.54	81643800.0
2022-05-04	TLT	Stock	117.97	118.965	117.35	118.62	25575688.0
2022-05-04	ES	Stock	87.04	88.7	86.69	88.57	1733100.0
2022-05-04	CL	Stock	74.47	77.55	74.3	77.0	8806000.0
2022-05-04	A	Stock	121.69	126.69	121.44	126.3	2460400.0
2022-05-04	AA	Stock	65.0	68.09	64.21	67.96	5753300.0
2022-05-04	AAC-DELISTED	Stock	9.84	9.84	9.82	9.83	27624.0
2022-05-04	AACG	Stock	1.15	1.15	1.14	1.15	11400.0
2022-05-04	AACIW-DELISTED	Stock	0.2799	0.28	0.2755	0.2798	10100.0
2022-05-04	AAIC-DELISTED	Stock	3.19	3.3	3.19	3.22	92619.0
2022-05-04	AAIC.C-DELISTED	Stock	24.75	24.75	24.75	24.75	1544.0
2022-05-04	AAL	Stock	18.83	19.64	18.75	19.62	30759700.0
2022-05-04	AAM.A-DELISTED	Stock	24.43	24.9	24.3	24.9	26374.0
2022-05-04	AAM.B-DELISTED	Stock	25.16	25.33	24.8	25.235	7569.0
2022-05-04	AAMC-DELISTED	Stock	3.0882	3.3118	3.0441	3.2971	94075.0
2022-05-04	AAME	Stock	3.09	3.09	2.92	2.97	3400.0
2022-05-04	AAMI	Stock	20.36	20.77	19.68	20.64	468700.0
2022-05-04	AAN-DELISTED	Stock	21.4	21.8	20.86	21.66	320000.0
2022-05-04	AAOI	Stock	2.76	2.86	2.66	2.85	167400.0
2022-05-04	AAON	Stock	32.5933	33.3933	31.8267	33.3733	266250.0
2022-05-04	AAP	Stock	200.95	207.96	198.0	207.63	912600.0
2022-05-04	AAQC-DELISTED	Stock	9.78	9.79	9.78	9.79	15850.0
2022-05-04	AAT	Stock	36.18	36.7	35.15	36.01	236800.0
2022-05-04	AATC	Stock	6.5295	6.78	6.28	6.4724	7761.0
2022-05-04	AAU-DELISTED	Stock	0.286	0.31	0.283	0.31	424602.0
2022-05-04	AAUAF-DELISTED	Stock	0.286	0.31	0.283	0.31	430755.0
2022-05-04	AAWW-DELISTED	Stock	70.96	72.7322	70.0	72.62	337769.0
2022-05-04	AAXJ	Stock	70.95	72.43	70.46	72.28	1919791.0
2022-05-04	AB	Stock	40.48	42.32	40.13	41.9	571400.0
2022-05-04	ABB-DELISTED	Stock	29.9	30.6	29.45	30.53	2404705.0
2022-05-04	ABBNY-DELISTED	Stock	29.9	30.6	29.45	30.53	2647208.0
2022-05-04	ABBV	Stock	148.18	152.37	147.59	151.59	5791500.0
2022-05-04	ABC-DELISTED	Stock	153.64	157.165	149.99	156.84	2122590.0
2022-05-04	ABCB	Stock	43.28	44.72	42.89	44.55	363100.0
2022-05-04	ABCL	Stock	8.1	8.43	7.7	8.28	1343400.0
2022-05-04	ABCM-DELISTED	Stock	15.0	15.49	14.51	15.34	142099.0
2022-05-04	ABEO	Stock	5.5	5.5	4.5	5.0	235060.0
2022-05-04	ABEV	Stock	2.78	2.9	2.76	2.89	35739800.0
2022-05-04	ABG	Stock	194.59	201.05	192.11	200.72	183200.0
2022-05-04	ABGI-DELISTED	Stock	9.81	9.81	9.8	9.8	27841.0
2022-05-04	ABM	Stock	47.49	48.52	47.18	48.45	591900.0
2022-05-04	ABMD-DELISTED	Stock	285.87	296.085	280.14	295.78	128627.0
2022-05-04	ABNB	Stock	152.55	158.74	145.872	156.18	20598100.0
2022-05-04	ABOS	Stock	3.87	4.02	3.65	4.01	171800.0

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

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