PREVIEW / stock_1hour / 2005-04-01

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-01.parquet
  size:    554 KB
  rows:    26,420
  symbols: 1,961

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2005-04-01 08:00:00	AAPL	Stock	1.4946	1.5086	1.4882	1.5082	2945460.0
2005-04-01 09:00:00	AAPL	Stock	1.5082	1.5129	1.4911	1.495	77436380.0
2005-04-01 10:00:00	AAPL	Stock	1.4946	1.5032	1.4489	1.4596	207850160.0
2005-04-01 11:00:00	AAPL	Stock	1.4596	1.4718	1.4561	1.4596	80252368.0
2005-04-01 12:00:00	AAPL	Stock	1.46	1.4671	1.4536	1.4571	68194532.0
2005-04-01 13:00:00	AAPL	Stock	1.4571	1.4654	1.4518	1.4536	47584572.0
2005-04-01 14:00:00	AAPL	Stock	1.4532	1.4657	1.4529	1.4586	57953308.0
2005-04-01 15:00:00	AAPL	Stock	1.4586	1.4696	1.4561	1.4607	85962660.0
2005-04-01 16:00:00	AAPL	Stock	1.4607	1.4679	1.4593	1.4607	1580544.0
2005-04-01 17:00:00	AAPL	Stock	1.4611	1.4639	1.4611	1.4639	268184.0
2005-04-01 18:00:00	AAPL	Stock	1.4636	1.4636	1.4604	1.4607	95200.0
2005-04-01 08:00:00	MSFT	Stock	24.21	24.28	24.12	24.27	307268.0
2005-04-01 09:00:00	MSFT	Stock	24.27	24.35	24.22	24.29	6989340.0
2005-04-01 10:00:00	MSFT	Stock	24.3	24.33	24.12	24.13	14377344.0
2005-04-01 11:00:00	MSFT	Stock	24.13	24.28	24.11	24.24	8406037.0
2005-04-01 12:00:00	MSFT	Stock	24.24	24.25	24.14	24.14	5041039.0
2005-04-01 13:00:00	MSFT	Stock	24.14	24.23	24.11	24.13	6637614.0
2005-04-01 14:00:00	MSFT	Stock	24.13	24.18	24.12	24.15	8322140.0
2005-04-01 15:00:00	MSFT	Stock	24.15	24.23	24.1	24.13	11651850.0
2005-04-01 16:00:00	MSFT	Stock	24.12	24.14	24.1	24.12	994940.0
2005-04-01 17:00:00	MSFT	Stock	24.12	24.12	24.11	24.12	10570.0
2005-04-01 18:00:00	MSFT	Stock	24.12	24.12	24.1	24.1	2800.0
2005-04-01 08:00:00	NVDA	Stock	0.2003	0.2003	0.2003	0.2003	132000.0
2005-04-01 09:00:00	NVDA	Stock	0.1988	0.2016	0.1985	0.2005	85757640.0
2005-04-01 10:00:00	NVDA	Stock	0.2006	0.2013	0.1976	0.1977	80863680.0
2005-04-01 11:00:00	NVDA	Stock	0.1977	0.2003	0.1971	0.199	43409160.0
2005-04-01 12:00:00	NVDA	Stock	0.1989	0.2	0.1975	0.1978	49519440.0
2005-04-01 13:00:00	NVDA	Stock	0.1979	0.1996	0.1961	0.1962	52780440.0
2005-04-01 14:00:00	NVDA	Stock	0.1962	0.1977	0.1949	0.1957	75851640.0
2005-04-01 15:00:00	NVDA	Stock	0.1957	0.1967	0.1954	0.1958	104348760.0
2005-04-01 16:00:00	NVDA	Stock	0.1971	0.1972	0.1958	0.1959	3031080.0
2005-04-01 17:00:00	NVDA	Stock	0.1961	0.1961	0.1961	0.1961	91200.0
2005-04-01 08:00:00	AMZN	Stock	1.7195	1.723	1.7195	1.723	212000.0
2005-04-01 09:00:00	AMZN	Stock	1.732	1.7355	1.7135	1.7275	11082580.0
2005-04-01 10:00:00	AMZN	Stock	1.7275	1.7345	1.689	1.6905	25013420.0
2005-04-01 11:00:00	AMZN	Stock	1.6905	1.7095	1.689	1.7095	16168500.0
2005-04-01 12:00:00	AMZN	Stock	1.709	1.7185	1.7025	1.703	18024300.0
2005-04-01 13:00:00	AMZN	Stock	1.703	1.7185	1.7025	1.704	8137280.0
2005-04-01 14:00:00	AMZN	Stock	1.7035	1.7115	1.7025	1.7055	9853840.0
2005-04-01 15:00:00	AMZN	Stock	1.706	1.7085	1.7	1.7	10223700.0
2005-04-01 16:00:00	AMZN	Stock	1.7005	1.7135	1.6975	1.7135	832540.0
2005-04-01 17:00:00	AMZN	Stock	1.7005	1.7005	1.7005	1.7005	83280.0
2005-04-01 18:00:00	AMZN	Stock	1.7025	1.7025	1.7025	1.7025	2000.0
2005-04-01 09:00:00	CL	Stock	26.15	26.235	26.085	26.15	301200.0
2005-04-01 10:00:00	CL	Stock	26.135	26.205	25.875	25.885	326200.0
2005-04-01 11:00:00	CL	Stock	25.885	26.035	25.835	26.025	309600.0
2005-04-01 12:00:00	CL	Stock	26.025	26.035	25.765	25.785	315600.0
2005-04-01 13:00:00	CL	Stock	25.78	25.865	25.745	25.76	419600.0
2005-04-01 14:00:00	CL	Stock	25.755	25.815	25.625	25.65	493400.0
2005-04-01 15:00:00	CL	Stock	25.645	25.9	25.625	25.755	681600.0

> showing 50 of 26,420 rows — these rows as CSV

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