PREVIEW / stock_daily / 2021-03-03

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-03.parquet
  size:    251 KB
  rows:    7,569
  symbols: 2,831

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-03	AAPL	Stock	124.81	125.71	121.84	122.06	112966300.0
2021-03-03	MSFT	Stock	232.16	233.58	227.26	227.56	34029500.0
2021-03-03	NVDA	Stock	13.4262	13.4515	12.7988	12.8048	377592000.0
2021-03-03	AMZN	Stock	154.059	155.389	149.75	150.25	79774000.0
2021-03-03	GOOGL	Stock	102.5975	103.7995	99.7	100.5705	33892900.0
2021-03-03	META	Stock	260.29	260.99	255.1	255.41	15513500.0
2021-03-03	TSLA	Stock	229.33	233.5667	217.2367	217.7333	90624000.0
2021-03-03	TLT	Stock	139.38	140.15	138.76	139.54	19763736.0
2021-03-03	ES	Stock	79.61	80.26	76.64	77.78	1751700.0
2021-03-03	CL	Stock	75.1	75.27	74.18	74.61	5705600.0
2021-03-03	A	Stock	122.78	122.78	119.25	119.3	1612400.0
2021-03-03	AA	Stock	28.9	31.37	28.52	30.83	17570200.0
2021-03-03	AACG	Stock	5.0	5.16	4.63	4.63	146600.0
2021-03-03	AACQ-DELISTED	Stock	10.69	10.81	10.3099	10.38	1969603.0
2021-03-03	AACQU-DELISTED	Stock	11.56	11.6431	11.01	11.03	76314.0
2021-03-03	AACQW-DELISTED	Stock	2.65	2.65	2.12	2.17	465354.0
2021-03-03	AAIC-DELISTED	Stock	4.08	4.15	4.0	4.02	191986.0
2021-03-03	AAIC.C-DELISTED	Stock	22.24	22.24	21.96	22.05	7825.0
2021-03-03	AAL	Stock	21.87	22.59	21.73	22.17	49301300.0
2021-03-03	AAM.A-DELISTED	Stock	25.77	25.8	25.7	25.76	61075.0
2021-03-03	AAM.B-DELISTED	Stock	26.35	26.41	26.25	26.33	22406.0
2021-03-03	AAMC-DELISTED	Stock	7.2568	7.4284	6.7794	6.7794	272768.0
2021-03-03	AAME	Stock	4.66	4.68	4.41	4.43	55800.0
2021-03-03	AAMI	Stock	19.01	19.44	18.9	18.9	910100.0
2021-03-03	AAN-DELISTED	Stock	22.01	22.52	21.82	22.13	366500.0
2021-03-03	AAOI	Stock	8.67	8.79	8.35	8.36	1044200.0
2021-03-03	AAON	Stock	49.8533	50.3733	49.24	49.3933	214200.0
2021-03-03	AAP	Stock	164.19	169.08	164.15	165.83	757500.0
2021-03-03	AAT	Stock	32.52	34.27	32.4	33.9	502100.0
2021-03-03	AAU-DELISTED	Stock	0.7381	0.7498	0.7	0.7097	1378365.0
2021-03-03	AAUAF-DELISTED	Stock	0.7381	0.7498	0.7	0.7097	1412676.0
2021-03-03	AAWW-DELISTED	Stock	57.2	58.86	56.58	57.19	344452.0
2021-03-03	AAXJ	Stock	97.03	97.23	95.59	95.62	2076111.0
2021-03-03	AB	Stock	37.72	38.09	37.39	37.79	436700.0
2021-03-03	ABB-DELISTED	Stock	29.62	29.745	29.37	29.43	1248329.0
2021-03-03	ABBNY-DELISTED	Stock	29.62	29.745	29.37	29.42	1348632.0
2021-03-03	ABBV	Stock	106.86	107.14	105.46	106.71	7218700.0
2021-03-03	ABC-DELISTED	Stock	104.13	104.94	103.315	103.33	605153.0
2021-03-03	ABCB	Stock	49.4	51.98	49.4	50.16	866500.0
2021-03-03	ABCL	Stock	39.0	39.0	35.5	35.67	493200.0
2021-03-03	ABCM-DELISTED	Stock	22.7	22.7	21.66	22.16	65073.0
2021-03-03	ABEO	Stock	59.5	60.0	54.0	54.75	145272.0
2021-03-03	ABEV	Stock	2.45	2.58	2.4	2.55	50174100.0
2021-03-03	ABG	Stock	167.89	171.02	166.65	166.94	107200.0
2021-03-03	ABGI-DELISTED	Stock	10.14	10.19	10.04	10.09	27896.0
2021-03-03	ABM	Stock	43.55	45.44	43.42	44.5	438800.0
2021-03-03	ABMD-DELISTED	Stock	323.14	325.26	306.7	307.37	198581.0
2021-03-03	ABNB	Stock	186.97	188.48	178.8	180.4	10592900.0
2021-03-03	ABR	Stock	16.62	16.93	16.36	16.37	1263100.0
2021-03-03	ABR.A-DELISTED	Stock	25.965	25.965	25.965	25.965	150.0

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

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