PREVIEW / stock_daily / 2021-06-04

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-04.parquet
  size:    257 KB
  rows:    7,835
  symbols: 2,928

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-06-04	AAPL	Stock	124.07	126.16	123.85	125.89	75169300.0
2021-06-04	MSFT	Stock	247.76	251.65	247.51	250.79	25281100.0
2021-06-04	NVDA	Stock	17.1125	17.661	17.0955	17.5782	617120000.0
2021-06-04	AMZN	Stock	160.6	161.05	159.9405	160.311	44994000.0
2021-06-04	GOOGL	Stock	118.4635	119.9515	118.1205	119.6785	24458200.0
2021-06-04	META	Stock	325.9	332.46	325.18	330.35	13289400.0
2021-06-04	TSLA	Stock	193.2367	200.2033	192.4	199.6833	72110700.0
2021-06-04	TLT	Stock	138.52	139.9	138.52	139.9	15773737.0
2021-06-04	ES	Stock	82.45	82.66	81.85	82.04	1478200.0
2021-06-04	CL	Stock	84.4	84.52	83.7	83.97	3660200.0
2021-06-04	A	Stock	137.7	138.41	137.39	137.9	1069700.0
2021-06-04	AA	Stock	39.32	39.58	38.32	38.84	3361200.0
2021-06-04	AAC-DELISTED	Stock	9.85	9.85	9.77	9.78	44354.0
2021-06-04	AACG	Stock	3.24	3.51	3.2	3.24	238200.0
2021-06-04	AACQ-DELISTED	Stock	9.95	9.97	9.95	9.965	1224446.0
2021-06-04	AACQU-DELISTED	Stock	10.55	10.59	10.55	10.59	1830.0
2021-06-04	AACQW-DELISTED	Stock	1.88	1.97	1.82	1.94	120327.0
2021-06-04	AAIC-DELISTED	Stock	4.04	4.04	4.0	4.0	96129.0
2021-06-04	AAIC.C-DELISTED	Stock	25.15	25.15	25.1	25.1325	1702.0
2021-06-04	AAL	Stock	25.13	25.18	24.26	24.3	28977300.0
2021-06-04	AAM.A-DELISTED	Stock	26.049	26.07	25.94	26.03	7991.0
2021-06-04	AAM.B-DELISTED	Stock	27.24	27.24	27.17	27.18	7863.0
2021-06-04	AAMC-DELISTED	Stock	5.0041	5.0434	4.9941	4.9941	5620.0
2021-06-04	AAME	Stock	4.4	4.49	4.25	4.25	193800.0
2021-06-04	AAMI	Stock	22.22	22.36	22.11	22.28	477900.0
2021-06-04	AAN-DELISTED	Stock	35.91	36.235	35.54	36.18	132700.0
2021-06-04	AAOI	Stock	8.39	8.549	8.38	8.44	413100.0
2021-06-04	AAON	Stock	42.8333	43.3333	42.8333	42.88	134250.0
2021-06-04	AAP	Stock	191.56	193.06	188.79	192.76	681800.0
2021-06-04	AAQC-DELISTED	Stock	9.74	9.74	9.72	9.74	10074.0
2021-06-04	AAT	Stock	38.04	38.13	37.61	38.05	304700.0
2021-06-04	AAU-DELISTED	Stock	0.5321	0.5393	0.5264	0.5297	750207.0
2021-06-04	AAUAF-DELISTED	Stock	0.5321	0.5393	0.5264	0.5326	796730.0
2021-06-04	AAWW-DELISTED	Stock	74.32	74.83	73.81	74.23	212539.0
2021-06-04	AAXJ	Stock	95.31	95.58	95.2601	95.58	429651.0
2021-06-04	AB	Stock	45.54	45.54	44.71	45.09	169300.0
2021-06-04	ABB-DELISTED	Stock	35.0	35.135	34.91	35.09	595592.0
2021-06-04	ABBNY-DELISTED	Stock	35.0	35.135	34.91	35.1	674567.0
2021-06-04	ABBV	Stock	112.4	113.11	112.16	112.36	4255400.0
2021-06-04	ABC-DELISTED	Stock	116.9	117.21	115.95	116.92	484567.0
2021-06-04	ABCB	Stock	56.33	56.54	55.73	56.47	182100.0
2021-06-04	ABCL	Stock	25.69	26.005	25.2	25.97	769800.0
2021-06-04	ABCM-DELISTED	Stock	19.51	19.51	19.24	19.37	279371.0
2021-06-04	ABEO	Stock	46.0	46.0	41.75	42.25	66088.0
2021-06-04	ABEV	Stock	3.82	3.88	3.77	3.87	27290400.0
2021-06-04	ABG	Stock	190.33	190.53	183.62	184.09	136700.0
2021-06-04	ABGI-DELISTED	Stock	9.95	9.95	9.895	9.895	3638.0
2021-06-04	ABM	Stock	49.51	49.76	49.2	49.66	254300.0
2021-06-04	ABMD-DELISTED	Stock	285.0	292.95	284.26	289.5	162240.0
2021-06-04	ABNB	Stock	145.83	151.57	145.0	150.73	8534900.0

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

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