PREVIEW / stock_1hour / 2004-05-03

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-05-03.parquet
  size:    522 KB
  rows:    24,556
  symbols: 1,765

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-05-03 08:00:00	AAPL	Stock	0.4605	0.4605	0.4605	0.4605	140000.0
2004-05-03 09:00:00	AAPL	Stock	0.4598	0.4689	0.4595	0.465	41316688.0
2004-05-03 10:00:00	AAPL	Stock	0.4652	0.4677	0.4602	0.4655	35153832.0
2004-05-03 11:00:00	AAPL	Stock	0.4657	0.4702	0.4657	0.4698	24617768.0
2004-05-03 12:00:00	AAPL	Stock	0.4698	0.4702	0.4654	0.4655	15147552.0
2004-05-03 13:00:00	AAPL	Stock	0.4655	0.4655	0.4616	0.4639	22572480.0
2004-05-03 14:00:00	AAPL	Stock	0.4643	0.4661	0.4604	0.462	38605728.0
2004-05-03 15:00:00	AAPL	Stock	0.462	0.4664	0.4607	0.4655	64402912.0
2004-05-03 16:00:00	AAPL	Stock	0.4654	0.4663	0.4579	0.4661	12238128.0
2004-05-03 17:00:00	AAPL	Stock	0.4655	0.4655	0.4643	0.4643	1125600.0
2004-05-03 08:00:00	MSFT	Stock	25.9	26.24	25.9	26.14	27900.0
2004-05-03 09:00:00	MSFT	Stock	26.13	26.46	25.95	26.43	5947794.0
2004-05-03 10:00:00	MSFT	Stock	26.43	26.52	26.29	26.42	10294836.0
2004-05-03 11:00:00	MSFT	Stock	26.42	26.48	26.36	26.45	7207834.0
2004-05-03 12:00:00	MSFT	Stock	26.44	26.49	26.39	26.45	3741404.0
2004-05-03 13:00:00	MSFT	Stock	26.45	26.46	26.33	26.41	5089089.0
2004-05-03 14:00:00	MSFT	Stock	26.41	26.49	26.25	26.28	7742275.0
2004-05-03 15:00:00	MSFT	Stock	26.28	26.48	26.26	26.34	11742356.0
2004-05-03 16:00:00	MSFT	Stock	26.32	26.395	26.3	26.31	11179236.0
2004-05-03 17:00:00	MSFT	Stock	26.33	26.36	26.31	26.34	154100.0
2004-05-03 18:00:00	MSFT	Stock	26.33	26.33	26.33	26.33	200.0
2004-05-03 08:00:00	NVDA	Stock	0.1724	0.1724	0.1711	0.1711	276000.0
2004-05-03 09:00:00	NVDA	Stock	0.1712	0.1737	0.1712	0.1727	62553120.0
2004-05-03 10:00:00	NVDA	Stock	0.1726	0.1742	0.1712	0.1729	114391320.0
2004-05-03 11:00:00	NVDA	Stock	0.1729	0.1744	0.1722	0.173	72851520.0
2004-05-03 12:00:00	NVDA	Stock	0.173	0.1746	0.1725	0.1728	41981640.0
2004-05-03 13:00:00	NVDA	Stock	0.1727	0.1728	0.1679	0.1681	64725840.0
2004-05-03 14:00:00	NVDA	Stock	0.1682	0.1692	0.1658	0.166	89622240.0
2004-05-03 15:00:00	NVDA	Stock	0.1661	0.1702	0.1659	0.1684	110310360.0
2004-05-03 16:00:00	NVDA	Stock	0.1684	0.1697	0.1646	0.1684	13734720.0
2004-05-03 17:00:00	NVDA	Stock	0.1712	0.1712	0.1679	0.1679	516000.0
2004-05-03 08:00:00	AMZN	Stock	2.1925	2.1925	2.18	2.1805	70000.0
2004-05-03 09:00:00	AMZN	Stock	2.1775	2.214	2.167	2.212	25246680.0
2004-05-03 10:00:00	AMZN	Stock	2.212	2.24	2.1995	2.23	26306980.0
2004-05-03 11:00:00	AMZN	Stock	2.2305	2.2575	2.229	2.2425	19928520.0
2004-05-03 12:00:00	AMZN	Stock	2.2435	2.2475	2.232	2.237	7924220.0
2004-05-03 13:00:00	AMZN	Stock	2.237	2.237	2.2135	2.2225	10296020.0
2004-05-03 14:00:00	AMZN	Stock	2.223	2.2345	2.196	2.2	16770100.0
2004-05-03 15:00:00	AMZN	Stock	2.2	2.2305	2.1975	2.2175	21192940.0
2004-05-03 16:00:00	AMZN	Stock	2.2185	2.2245	2.217	2.221	1886920.0
2004-05-03 17:00:00	AMZN	Stock	2.2205	2.2205	2.2205	2.2205	240000.0
2004-05-03 09:00:00	CL	Stock	28.945	29.02	28.895	28.9945	314400.0
2004-05-03 10:00:00	CL	Stock	28.995	29.125	28.94	29.065	500800.0
2004-05-03 11:00:00	CL	Stock	29.065	29.14	29.045	29.07	545600.0
2004-05-03 12:00:00	CL	Stock	29.07	29.24	29.055	29.21	450400.0
2004-05-03 13:00:00	CL	Stock	29.21	29.37	29.205	29.35	473000.0
2004-05-03 14:00:00	CL	Stock	29.35	29.365	29.275	29.295	476800.0
2004-05-03 15:00:00	CL	Stock	29.295	29.485	29.28	29.475	1113400.0
2004-05-03 16:00:00	CL	Stock	29.46	29.46	29.45	29.46	100000.0

> showing 49 of 24,556 rows — these rows as CSV

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