PREVIEW / stock_daily / 2021-07-30

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-30.parquet
  size:    257 KB
  rows:    7,882
  symbols: 2,794

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-07-30	AAPL	Stock	144.38	146.33	144.11	145.86	70440600.0
2021-07-30	MSFT	Stock	285.17	286.66	283.91	284.91	20944800.0
2021-07-30	NVDA	Stock	19.418	19.63	19.263	19.499	183497000.0
2021-07-30	AMZN	Stock	167.3975	168.407	165.349	166.3795	199312000.0
2021-07-30	GOOGL	Stock	135.035	135.3045	134.255	134.7265	25575780.0
2021-07-30	META	Stock	354.0	360.73	352.94	356.3	15976200.0
2021-07-30	TSLA	Stock	223.92	232.51	223.0	229.0667	88969200.0
2021-07-30	TLT	Stock	149.13	149.72	149.06	149.52	14342162.0
2021-07-30	ES	Stock	86.86	88.11	85.98	86.27	2082900.0
2021-07-30	CL	Stock	80.52	81.06	79.22	79.5	9513700.0
2021-07-30	A	Stock	152.52	153.6	152.02	153.23	2310100.0
2021-07-30	AA	Stock	39.16	40.66	38.96	40.15	8142600.0
2021-07-30	AAC-DELISTED	Stock	9.75	9.78	9.75	9.775	7783.0
2021-07-30	AACG	Stock	3.19	3.21	3.07	3.11	74800.0
2021-07-30	AAIC-DELISTED	Stock	3.97	3.975	3.86	3.86	149842.0
2021-07-30	AAIC.C-DELISTED	Stock	25.11	25.4	25.11	25.11	1610.0
2021-07-30	AAL	Stock	20.84	21.15	20.24	20.38	31284000.0
2021-07-30	AAM.A-DELISTED	Stock	26.4	26.4	26.26	26.35	29483.0
2021-07-30	AAM.B-DELISTED	Stock	27.12	27.12	26.95	27.04	20442.0
2021-07-30	AAMC-DELISTED	Stock	4.6176	4.7	4.4176	4.4176	14402.0
2021-07-30	AAME	Stock	4.14	4.23	4.03	4.09	21000.0
2021-07-30	AAMI	Stock	24.72	25.09	24.72	24.99	470200.0
2021-07-30	AAN-DELISTED	Stock	28.5	29.22	28.5	28.87	234000.0
2021-07-30	AAOI	Stock	7.69	7.86	7.67	7.73	369700.0
2021-07-30	AAON	Stock	41.2533	41.9333	41.2533	41.4333	180750.0
2021-07-30	AAP	Stock	213.47	215.92	211.9	212.06	434600.0
2021-07-30	AAQC-DELISTED	Stock	9.6614	9.68	9.6614	9.67	6536.0
2021-07-30	AAT	Stock	37.39	38.15	36.9	36.93	277900.0
2021-07-30	AATC	Stock	7.02	7.1	6.66	6.66	36345.0
2021-07-30	AAU-DELISTED	Stock	0.448	0.46	0.4403	0.445	250675.0
2021-07-30	AAUAF-DELISTED	Stock	0.448	0.46	0.4403	0.4413	257273.0
2021-07-30	AAWW-DELISTED	Stock	67.36	67.935	66.15	66.88	338128.0
2021-07-30	AAXJ	Stock	87.26	87.95	87.11	87.8	1570925.0
2021-07-30	AB	Stock	48.05	48.83	47.81	48.27	282800.0
2021-07-30	ABB-DELISTED	Stock	36.58	36.775	36.515	36.62	929613.0
2021-07-30	ABBNY-DELISTED	Stock	36.58	36.775	36.515	36.62	1013277.0
2021-07-30	ABBV	Stock	119.0	119.15	116.12	116.3	9017200.0
2021-07-30	ABC-DELISTED	Stock	122.81	123.24	122.01	122.17	575949.0
2021-07-30	ABCB	Stock	48.68	49.67	48.28	48.61	495000.0
2021-07-30	ABCL	Stock	15.6	16.17	15.08	15.17	1014700.0
2021-07-30	ABCM-DELISTED	Stock	18.75	19.02	18.75	18.91	51197.0
2021-07-30	ABEO	Stock	30.75	30.75	29.75	30.5	37648.0
2021-07-30	ABEV	Stock	3.32	3.36	3.16	3.17	22481700.0
2021-07-30	ABG	Stock	203.52	206.76	202.75	205.46	125800.0
2021-07-30	ABGI-DELISTED	Stock	9.71	9.71	9.68	9.7	1532.0
2021-07-30	ABM	Stock	46.82	47.6	46.27	46.49	1849100.0
2021-07-30	ABMD-DELISTED	Stock	324.81	330.0	324.4	327.54	57575.0
2021-07-30	ABNB	Stock	141.75	144.69	141.74	144.01	4167100.0
2021-07-30	ABOS	Stock	14.87	15.675	14.85	15.48	149400.0
2021-07-30	ABR	Stock	18.27	18.48	18.09	18.28	1417300.0

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

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