PREVIEW / stock_1hour / 2004-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-01-06.parquet
  size:    498 KB
  rows:    23,002
  symbols: 1,707

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
2004-01-06 08:00:00	AAPL	Stock	0.3961	0.3973	0.3943	0.3973	677600.0
2004-01-06 09:00:00	AAPL	Stock	0.3964	0.3991	0.3889	0.3921	70892360.0
2004-01-06 10:00:00	AAPL	Stock	0.392	0.393	0.3877	0.392	49172984.0
2004-01-06 11:00:00	AAPL	Stock	0.392	0.3982	0.3918	0.3973	86470328.0
2004-01-06 12:00:00	AAPL	Stock	0.397	0.4004	0.3938	0.3939	46520600.0
2004-01-06 13:00:00	AAPL	Stock	0.3938	0.3975	0.3929	0.3971	34583136.0
2004-01-06 14:00:00	AAPL	Stock	0.3973	0.3984	0.3957	0.398	62957104.0
2004-01-06 15:00:00	AAPL	Stock	0.3977	0.398	0.3932	0.3939	78526056.0
2004-01-06 16:00:00	AAPL	Stock	0.3946	0.3973	0.392	0.3927	27693456.0
2004-01-06 17:00:00	AAPL	Stock	0.3921	0.3946	0.3916	0.3946	712544.0
2004-01-06 18:00:00	AAPL	Stock	0.3945	0.3945	0.3945	0.3945	5600.0
2004-01-06 08:00:00	MSFT	Stock	28.16	28.16	28.13	28.14	48560.0
2004-01-06 09:00:00	MSFT	Stock	28.15	28.19	28.07	28.17	5490102.0
2004-01-06 10:00:00	MSFT	Stock	28.17	28.23	28.11	28.2	10271118.0
2004-01-06 11:00:00	MSFT	Stock	28.19	28.23	28.15	28.15	5850191.0
2004-01-06 12:00:00	MSFT	Stock	28.15	28.21	28.14	28.15	3323287.0
2004-01-06 13:00:00	MSFT	Stock	28.16	28.23	28.13	28.2	3572671.0
2004-01-06 14:00:00	MSFT	Stock	28.19	28.22	28.15	28.209	5303688.0
2004-01-06 15:00:00	MSFT	Stock	28.2	28.28	28.18	28.25	8869695.0
2004-01-06 16:00:00	MSFT	Stock	28.25	28.25	28.1847	28.21	1227465.0
2004-01-06 17:00:00	MSFT	Stock	28.21	28.25	28.1327	28.2	15251.0
2004-01-06 18:00:00	MSFT	Stock	28.23	28.23	28.2	28.2	3300.0
2004-01-06 08:00:00	NVDA	Stock	0.1982	0.1987	0.1982	0.1987	180000.0
2004-01-06 09:00:00	NVDA	Stock	0.1979	0.2022	0.1976	0.1997	100366560.0
2004-01-06 10:00:00	NVDA	Stock	0.1997	0.2087	0.1971	0.2085	383862840.0
2004-01-06 11:00:00	NVDA	Stock	0.2085	0.2089	0.2045	0.2065	164236920.0
2004-01-06 12:00:00	NVDA	Stock	0.2066	0.2087	0.2057	0.2073	85237680.0
2004-01-06 13:00:00	NVDA	Stock	0.2072	0.2085	0.2064	0.2085	61216440.0
2004-01-06 14:00:00	NVDA	Stock	0.2084	0.2094	0.2074	0.2083	98063280.0
2004-01-06 15:00:00	NVDA	Stock	0.2087	0.2087	0.2061	0.2063	117996240.0
2004-01-06 16:00:00	NVDA	Stock	0.2067	0.2071	0.2059	0.2067	8697600.0
2004-01-06 17:00:00	NVDA	Stock	0.2069	0.2069	0.2067	0.2067	312000.0
2004-01-06 18:00:00	NVDA	Stock	0.2067	0.2067	0.2067	0.2067	12111600.0
2004-01-06 08:00:00	AMZN	Stock	2.6628	2.667	2.6585	2.6585	104000.0
2004-01-06 09:00:00	AMZN	Stock	2.6585	2.6695	2.637	2.666	19928840.0
2004-01-06 10:00:00	AMZN	Stock	2.667	2.675	2.6385	2.658	28328880.0
2004-01-06 11:00:00	AMZN	Stock	2.658	2.658	2.6375	2.6385	9902760.0
2004-01-06 12:00:00	AMZN	Stock	2.639	2.66	2.638	2.649	9083340.0
2004-01-06 13:00:00	AMZN	Stock	2.6495	2.6595	2.6425	2.648	13117760.0
2004-01-06 14:00:00	AMZN	Stock	2.648	2.6535	2.6405	2.65	13543440.0
2004-01-06 15:00:00	AMZN	Stock	2.65	2.6525	2.645	2.6525	18128460.0
2004-01-06 16:00:00	AMZN	Stock	2.65	2.653	2.6455	2.652	1394000.0
2004-01-06 17:00:00	AMZN	Stock	2.6525	2.6525	2.65	2.65	113000.0
2004-01-06 18:00:00	AMZN	Stock	2.65	2.6535	2.65	2.6535	12000.0
2004-01-06 09:00:00	CL	Stock	25.0	25.045	24.935	25.04	836000.0
2004-01-06 10:00:00	CL	Stock	25.04	25.27	25.02	25.215	1446800.0
2004-01-06 11:00:00	CL	Stock	25.215	25.235	25.1	25.185	1054400.0
2004-01-06 12:00:00	CL	Stock	25.185	25.225	25.165	25.195	970400.0
2004-01-06 13:00:00	CL	Stock	25.195	25.23	25.175	25.2	1033600.0
2004-01-06 14:00:00	CL	Stock	25.205	25.215	25.11	25.15	1327400.0

> showing 50 of 23,002 rows — these rows as CSV

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