PREVIEW / stock_daily / 2021-03-01

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-01.parquet
  size:    250 KB
  rows:    7,574
  symbols: 2,837

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-01	AAPL	Stock	123.75	127.93	122.79	127.79	116307900.0
2021-03-01	MSFT	Stock	235.9	237.47	233.15	236.94	25324000.0
2021-03-01	NVDA	Stock	13.875	13.925	13.5532	13.8418	353184000.0
2021-03-01	AMZN	Stock	156.3945	157.478	154.8995	157.307	54582000.0
2021-03-01	GOOGL	Stock	102.4	103.8115	101.721	103.483	26061780.0
2021-03-01	META	Stock	260.82	266.65	257.9	264.91	22157300.0
2021-03-01	TSLA	Stock	230.0367	239.6667	228.35	239.4767	81408600.0
2021-03-01	TLT	Stock	140.66	141.41	140.09	141.06	22050428.0
2021-03-01	ES	Stock	80.04	81.47	80.0	80.73	1300900.0
2021-03-01	CL	Stock	75.44	76.36	75.33	75.6	3872400.0
2021-03-01	A	Stock	123.05	125.15	122.88	124.48	1404400.0
2021-03-01	AA	Stock	25.67	26.38	25.4	25.99	5550800.0
2021-03-01	AACG	Stock	5.02	5.26	4.91	5.15	221600.0
2021-03-01	AACQ-DELISTED	Stock	11.07	11.31	10.82	11.23	3885097.0
2021-03-01	AACQU-DELISTED	Stock	12.06	12.3	11.76	12.01	42516.0
2021-03-01	AACQW-DELISTED	Stock	2.9	3.05	2.81	2.87	664778.0
2021-03-01	AAIC-DELISTED	Stock	4.07	4.15	4.03	4.06	166572.0
2021-03-01	AAIC.C-DELISTED	Stock	21.7601	22.26	21.7601	22.2	2090.0
2021-03-01	AAL	Stock	21.75	22.29	21.05	21.18	45406100.0
2021-03-01	AAM.A-DELISTED	Stock	25.7	25.78	25.65	25.78	24345.0
2021-03-01	AAM.B-DELISTED	Stock	26.09	26.25	26.07	26.25	20964.0
2021-03-01	AAMC-DELISTED	Stock	6.6427	7.35	6.6427	6.9529	53468.0
2021-03-01	AAME	Stock	4.51	4.87	4.3	4.76	70700.0
2021-03-01	AAMI	Stock	18.47	19.27	18.16	19.2	446500.0
2021-03-01	AAN-DELISTED	Stock	22.46	22.88	22.1	22.22	439600.0
2021-03-01	AAOI	Stock	9.52	9.635	8.82	9.02	1276500.0
2021-03-01	AAON	Stock	52.3	52.5933	51.2467	51.5867	217500.0
2021-03-01	AAP	Stock	162.13	163.74	161.77	162.66	814500.0
2021-03-01	AAT	Stock	31.81	32.41	31.45	31.98	301600.0
2021-03-01	AAU-DELISTED	Stock	0.71	0.7755	0.71	0.746	1560985.0
2021-03-01	AAUAF-DELISTED	Stock	0.71	0.7755	0.71	0.746	1647100.0
2021-03-01	AAWW-DELISTED	Stock	55.25	55.95	54.0701	55.3	552284.0
2021-03-01	AAXJ	Stock	96.56	97.47	96.3	97.34	582300.0
2021-03-01	AB	Stock	37.24	37.86	37.0	37.3	697600.0
2021-03-01	ABB-DELISTED	Stock	29.25	29.5	29.23	29.28	1440706.0
2021-03-01	ABBNY-DELISTED	Stock	29.25	29.5	29.23	29.28	1539677.0
2021-03-01	ABBV	Stock	108.53	109.21	108.07	108.41	4709500.0
2021-03-01	ABC-DELISTED	Stock	101.92	103.86	101.92	103.18	812420.0
2021-03-01	ABCB	Stock	48.85	49.12	48.3	49.02	312000.0
2021-03-01	ABCL	Stock	38.46	40.6	38.46	39.69	291100.0
2021-03-01	ABCM-DELISTED	Stock	23.05	23.33	22.25	22.52	157936.0
2021-03-01	ABEO	Stock	63.75	64.5	58.0	58.5	191220.0
2021-03-01	ABEV	Stock	2.54	2.58	2.49	2.5	18560700.0
2021-03-01	ABG	Stock	174.04	176.22	171.23	172.15	122700.0
2021-03-01	ABGI-DELISTED	Stock	10.35	10.36	10.25	10.25	208930.0
2021-03-01	ABM	Stock	44.06	44.45	43.68	44.03	186200.0
2021-03-01	ABMD-DELISTED	Stock	329.59	330.98	322.94	324.06	119513.0
2021-03-01	ABNB	Stock	195.82	199.69	192.62	196.42	15798500.0
2021-03-01	ABR	Stock	17.03	17.12	16.71	16.87	2070900.0
2021-03-01	ABR.A-DELISTED	Stock	25.9	26.08	25.8	26.08	1977.0

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

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