PREVIEW / stock_daily / 2021-09-14

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-14.parquet
  size:    257 KB
  rows:    7,887
  symbols: 2,724

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-09-14	AAPL	Stock	150.35	151.07	146.91	148.12	109296300.0
2021-09-14	MSFT	Stock	299.56	301.39	298.1	299.79	21853400.0
2021-09-14	NVDA	Stock	22.275	22.41	22.086	22.242	199755000.0
2021-09-14	AMZN	Stock	173.7775	174.3405	171.8855	172.5	38738000.0
2021-09-14	GOOGL	Stock	142.9953	143.363	141.75	142.5445	19673860.0
2021-09-14	META	Stock	377.4	378.59	375.11	376.53	8711600.0
2021-09-14	TSLA	Stock	247.5233	251.49	245.4667	248.1633	55574700.0
2021-09-14	TLT	Stock	149.73	151.57	149.58	151.11	19918375.0
2021-09-14	ES	Stock	88.68	88.88	86.42	86.97	2134400.0
2021-09-14	CL	Stock	77.38	77.59	77.09	77.3	2950600.0
2021-09-14	A	Stock	172.55	173.98	171.76	172.42	1337400.0
2021-09-14	AA	Stock	48.98	49.244	47.62	48.0	6902600.0
2021-09-14	AAC-DELISTED	Stock	9.78	9.78	9.75	9.77	1641303.0
2021-09-14	AACG	Stock	2.87	2.87	2.77	2.83	24200.0
2021-09-14	AACIU	Stock	9.8147	9.93	9.8147	9.92	31653.0
2021-09-14	AAIC-DELISTED	Stock	3.81	3.8199	3.76	3.79	79205.0
2021-09-14	AAIC.C-DELISTED	Stock	25.4405	25.54	25.4405	25.54	1500.0
2021-09-14	AAL	Stock	19.35	19.52	19.04	19.21	23820100.0
2021-09-14	AAM.A-DELISTED	Stock	25.97	26.0	25.86	25.96	18113.0
2021-09-14	AAM.B-DELISTED	Stock	27.0001	27.0001	26.83	26.92	57019.0
2021-09-14	AAMC-DELISTED	Stock	8.0941	8.6618	7.85	8.1618	136442.0
2021-09-14	AAME	Stock	3.87	3.93	3.82	3.91	45100.0
2021-09-14	AAMI	Stock	27.06	27.16	26.47	26.6	800200.0
2021-09-14	AAN-DELISTED	Stock	26.66	26.97	25.69	25.86	219200.0
2021-09-14	AAOI	Stock	7.44	7.52	7.12	7.21	330600.0
2021-09-14	AAON	Stock	43.5133	43.8667	42.8333	43.6133	258300.0
2021-09-14	AAP	Stock	200.03	201.24	197.89	201.17	471500.0
2021-09-14	AAQC-DELISTED	Stock	9.69	9.71	9.69	9.71	87449.0
2021-09-14	AAT	Stock	39.71	39.74	38.89	39.14	181400.0
2021-09-14	AATC	Stock	8.02	8.0659	7.79	7.86	36423.0
2021-09-14	AAU-DELISTED	Stock	0.419	0.419	0.3951	0.4017	312401.0
2021-09-14	AAUAF-DELISTED	Stock	0.419	0.419	0.3951	0.4017	323785.0
2021-09-14	AAWW-DELISTED	Stock	75.0359	76.33	72.96	75.44	313360.0
2021-09-14	AAXJ	Stock	88.75	88.88	88.18	88.4	470936.0
2021-09-14	AB	Stock	52.24	52.39	50.65	50.97	253900.0
2021-09-14	ABB-DELISTED	Stock	37.03	37.04	36.725	36.81	762502.0
2021-09-14	ABBNY-DELISTED	Stock	37.03	37.04	36.725	36.81	872875.0
2021-09-14	ABBV	Stock	107.99	108.07	106.25	106.48	6102700.0
2021-09-14	ABC-DELISTED	Stock	124.0	124.47	122.71	123.07	324603.0
2021-09-14	ABCB	Stock	47.71	48.15	46.46	46.68	517300.0
2021-09-14	ABCL	Stock	17.8	17.96	17.4	17.56	1982900.0
2021-09-14	ABCM-DELISTED	Stock	20.55	20.995	20.48	20.76	26067.0
2021-09-14	ABEO	Stock	32.5	32.5	30.5	30.5	21124.0
2021-09-14	ABEV	Stock	3.1	3.15	3.07	3.08	21977500.0
2021-09-14	ABG	Stock	174.71	174.88	169.99	171.62	127200.0
2021-09-14	ABGI-DELISTED	Stock	9.65	9.69	9.65	9.69	48935.0
2021-09-14	ABM	Stock	46.38	46.38	45.42	45.96	374600.0
2021-09-14	ABMD-DELISTED	Stock	354.52	355.84	349.73	353.83	85243.0
2021-09-14	ABNB	Stock	160.66	164.7	159.41	163.3	4655500.0
2021-09-14	ABOS	Stock	15.81	16.62	15.36	15.95	335000.0

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

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