PREVIEW / stock_daily / 2007-04-24

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-24.parquet
  size:    164 KB
  rows:    4,922
  symbols: 3,098

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
2007-04-24	AAPL	Stock	3.3557	3.4425	3.2607	3.33	1055252800.0
2007-04-24	MSFT	Stock	28.79	28.96	28.59	28.79	34236700.0
2007-04-24	NVDA	Stock	0.5317	0.5473	0.5282	0.5425	1028088000.0
2007-04-24	AMZN	Stock	2.2375	2.25	2.2215	2.2375	397752000.0
2007-04-24	TLT	Stock	88.45	88.82	88.45	88.8	881228.0
2007-04-24	CL	Stock	33.95	34.07	33.405	33.96	5380600.0
2007-04-24	A	Stock	25.3934	25.4864	25.1788	25.279	2730294.0
2007-04-24	AABA-DELISTED	Stock	28.0300006866455	28.2600002288818	27.6900005340576	28.0200004577637	25964000.0
2007-04-24	AACC-DELISTED	Stock	16.04	16.16	15.76	16.14	153176.0
2007-04-24	AACQ-DELISTED	Stock	4.5	4.59	4.5	4.55	12500.0
2007-04-24	AACQW-DELISTED	Stock	0.65	0.65	0.65	0.65	5200.0
2007-04-24	AAI-DELISTED	Stock	11.56	11.6858	11.4	11.59	2375100.0
2007-04-24	AAIC-DELISTED	Stock	122.2	123.0	120.6	121.4	1152000.0
2007-04-24	AAME	Stock	5.4	5.44	5.12	5.13	32000.0
2007-04-24	AAON	Stock	3.2948	3.4147	3.2764	3.4094	209587.0
2007-04-24	AAP	Stock	41.2	41.2	40.59	41.06	923300.0
2007-04-24	AATI-DELISTED	Stock	6.68	7.0	6.57	6.93	406484.0
2007-04-24	AAU-DELISTED	Stock	2.56	2.6	2.52	2.54	54700.0
2007-04-24	AAUAF-DELISTED	Stock	2.56	2.6	2.52	2.54	54700.0
2007-04-24	AAV-DELISTED	Stock	11.39	11.47	11.38	11.4	902700.0
2007-04-24	AAWW-DELISTED	Stock	59.96	59.96	58.4	58.58	91232.0
2007-04-24	AAXN-DELISTED	Stock	8.5	8.60000038146973	8.25	8.5600004196167	1628600.0
2007-04-24	AB	Stock	94.25	94.25	92.19	92.75	208400.0
2007-04-24	ABAX-DELISTED	Stock	24.84	25.11	24.63	24.93	135414.0
2007-04-24	ABB-DELISTED	Stock	18.85	18.85	18.66	18.76	2979400.0
2007-04-24	ABBC-DELISTED	Stock	19.57	19.57	19.11	19.39	8474.0
2007-04-24	ABC-DELISTED	Stock	27.5	28.28	27.43	28.18	5068200.0
2007-04-24	ABCB	Stock	24.2674	24.2966	23.8978	24.0145	10487.0
2007-04-24	ABCO-DELISTED	Stock	25.26	25.36	24.85	25.14	163992.0
2007-04-24	ABCW-DELISTED	Stock	27.25	27.94	27.25	27.86	49210.0
2007-04-24	ABD-DELISTED	Stock	24.42	24.63	24.22	24.28	389710.0
2007-04-24	ABE-DELISTED	Stock	20.95	21.62	20.9	21.3	47300.0
2007-04-24	ABFS-DELISTED	Stock	38.5	40.04	38.5	39.24	914323.0
2007-04-24	ABG	Stock	28.12	28.29	27.87	28.24	714900.0
2007-04-24	ABK-DELISTED	Stock	90.42	90.43	89.44	90.0	847100.0
2007-04-24	ABM	Stock	28.02	28.23	27.86	28.05	275400.0
2007-04-24	ABMD-DELISTED	Stock	13.93	13.96	13.59	13.66	169606.0
2007-04-24	ABP-DELISTED	Stock	3.07	3.18	3.07	3.16	116200.0
2007-04-24	ABR	Stock	32.04	32.04	31.48	31.56	71300.0
2007-04-24	ABT	Stock	27.387	27.4781	27.1327	27.4302	11378491.0
2007-04-24	ABTL-DELISTED	Stock	16.75	17.75	16.5	17.5	22355.0
2007-04-24	ABV-DELISTED	Stock	59.94	60.14	59.41	59.92	244600.0
2007-04-24	ABVA-DELISTED	Stock	14.76	14.85	14.32	14.364	6620.0
2007-04-24	ABX-DELISTED	Stock	28.36	28.73	28.29	28.39	3581500.0
2007-04-24	ACAD	Stock	14.36	14.55	14.24	14.36	170000.0
2007-04-24	ACAP-DELISTED	Stock	39.74	39.75	38.73	39.05	72194.0
2007-04-24	ACAS-DELISTED	Stock	47.69	47.76	47.18	47.52	1047065.0
2007-04-24	ACAT-DELISTED	Stock	18.42	18.42	17.91	18.26	54850.0
2007-04-24	ACC-DELISTED	Stock	30.94	30.94	30.36	30.78	71600.0
2007-04-24	ACCL-DELISTED	Stock	6.49	6.49	6.35	6.43	275779.0

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

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