PREVIEW / stock_daily / 2005-03-18

all stock daily files

  file:    by_date/stock_daily/2005/2005-03-18.parquet
  size:    136 KB
  rows:    4,030
  symbols: 2,526

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
2005-03-18	AAPL	Stock	1.5475	1.5514	1.5179	1.5343	940150400.0
2005-03-18	MSFT	Stock	24.53	24.91	24.28	24.31	135904000.0
2005-03-18	NVDA	Stock	0.2057	0.2064	0.1977	0.2014	639012000.0
2005-03-18	AMZN	Stock	1.7075	1.714	1.6825	1.708	105894000.0
2005-03-18	CL	Stock	25.895	26.13	25.71	26.07	4777000.0
2005-03-18	A	Stock	16.1087	16.1588	15.8441	15.9871	9052889.0
2005-03-18	AABA-DELISTED	Stock	31.5300006866455	31.7299995422363	30.9099998474121	31.1100006103516	20796400.0
2005-03-18	AACC-DELISTED	Stock	19.93	20.4	19.86	20.3	123066.0
2005-03-18	AACQ-DELISTED	Stock	5.14	5.14	5.12	5.12	29400.0
2005-03-18	AACQU-DELISTED	Stock	6.45	6.45	6.4	6.401	43000.0
2005-03-18	AACQW-DELISTED	Stock	0.67	0.68	0.635	0.675	128500.0
2005-03-18	AAI-DELISTED	Stock	8.5	8.53	8.13	8.23	1819700.0
2005-03-18	AAIC-DELISTED	Stock	340.0	340.2	324.0	333.6	4159400.0
2005-03-18	AAME	Stock	3.0	3.05	2.99	3.05	21100.0
2005-03-18	AAON	Stock	2.1057	2.1228	2.0754	2.078	324253.0
2005-03-18	AAP	Stock	33.2067	33.28	33.02	33.26	683700.0
2005-03-18	AAV-DELISTED	Stock	16.74	16.74	16.59	16.74	45900.0
2005-03-18	AAXN-DELISTED	Stock	12.9099998474121	13.1000003814697	12.4099998474121	12.5200004577637	4518300.0
2005-03-18	ABAX-DELISTED	Stock	9.19	9.38	9.01	9.02	123541.0
2005-03-18	ABB-DELISTED	Stock	6.13	6.17	6.1	6.15	239700.0
2005-03-18	ABBC-DELISTED	Stock	13.36	13.68	13.26	13.378	16165.0
2005-03-18	ABC-DELISTED	Stock	15.2	15.38	15.08	15.21	3420000.0
2005-03-18	ABCB	Stock	18.2079	18.3343	17.5562	17.5562	56444.0
2005-03-18	ABCO-DELISTED	Stock	20.89	21.74	20.69	21.26	1174662.0
2005-03-18	ABCW-DELISTED	Stock	27.9	27.9	27.43	27.61	118340.0
2005-03-18	ABE-DELISTED	Stock	9.65	9.65	9.35	9.57	31100.0
2005-03-18	ABFS-DELISTED	Stock	42.43	42.88	41.22	41.48	487729.0
2005-03-18	ABG	Stock	15.07	15.15	14.66	15.02	82100.0
2005-03-18	ABK-DELISTED	Stock	77.35	77.7	75.85	76.54	597300.0
2005-03-18	ABM	Stock	19.88	19.88	19.35	19.45	336000.0
2005-03-18	ABMD-DELISTED	Stock	10.6	10.6	10.11	10.41	106599.0
2005-03-18	ABP-DELISTED	Stock	2.78	2.8	2.65	2.65	118200.0
2005-03-18	ABR	Stock	25.95	25.95	25.62	25.68	44300.0
2005-03-18	ABT	Stock	21.2599	21.3799	21.0296	21.3367	14699250.0
2005-03-18	ABTL-DELISTED	Stock	26.85	27.25	26.5	27.05	57800.0
2005-03-18	ABV-DELISTED	Stock	28.7	28.78	28.35	28.44	447800.0
2005-03-18	ABVA-DELISTED	Stock	16.4	16.4	16.17	16.17	600.0
2005-03-18	ABX-DELISTED	Stock	25.32	25.5	25.14	25.24	1670900.0
2005-03-18	ACAD	Stock	7.18	7.46	7.1	7.28	24600.0
2005-03-18	ACAP-DELISTED	Stock	35.13	35.13	34.75	34.87	59910.0
2005-03-18	ACAS-DELISTED	Stock	33.25	33.38	32.49	32.67	728210.0
2005-03-18	ACAT-DELISTED	Stock	28.02	28.92	27.82	28.01	228080.0
2005-03-18	ACC-DELISTED	Stock	22.27	22.27	21.95	21.95	73400.0
2005-03-18	ACCL-DELISTED	Stock	5.22	5.35	5.13	5.15	213048.0
2005-03-18	ACE-DELISTED	Stock	43.76	44.0	42.54	43.02	1774500.0
2005-03-18	ACF-DELISTED	Stock	24.23	24.35	23.86	24.17	1026400.0
2005-03-18	ACFC-DELISTED	Stock	67.88	68.04	66.2	67.12	11327.0
2005-03-18	ACG-DELISTED	Stock	8.28	8.28	8.17	8.22	379100.0
2005-03-18	ACGL	Stock	4.5089	4.5189	4.4311	4.4389	590400.0
2005-03-18	ACGN-DELISTED	Stock	657.3288	668.6712	634.6712	657.3288	129100.0

> showing 50 of 4,030 rows — these rows as CSV

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