PREVIEW / stock_1hour / 2004-05-26

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-05-26.parquet
  size:    509 KB
  rows:    24,359
  symbols: 1,770

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-26 08:00:00	AAPL	Stock	0.5089	0.5089	0.5066	0.5066	50400.0
2004-05-26 09:00:00	AAPL	Stock	0.5055	0.5071	0.5039	0.5045	34144768.0
2004-05-26 10:00:00	AAPL	Stock	0.5046	0.5089	0.5	0.5082	40456752.0
2004-05-26 11:00:00	AAPL	Stock	0.5084	0.513	0.5079	0.5125	45222912.0
2004-05-26 12:00:00	AAPL	Stock	0.5129	0.5139	0.5036	0.5079	54398792.0
2004-05-26 13:00:00	AAPL	Stock	0.5079	0.5098	0.5034	0.5066	36974504.0
2004-05-26 14:00:00	AAPL	Stock	0.5066	0.5129	0.5038	0.51	52375904.0
2004-05-26 15:00:00	AAPL	Stock	0.5104	0.5104	0.5061	0.5093	42657832.0
2004-05-26 16:00:00	AAPL	Stock	0.5091	0.5093	0.5086	0.5091	2011408.0
2004-05-26 17:00:00	AAPL	Stock	0.5086	0.509	0.5086	0.509	226128.0
2004-05-26 18:00:00	AAPL	Stock	0.5052	0.5052	0.5052	0.5052	5600.0
2004-05-26 08:00:00	MSFT	Stock	26.02	26.1	26.02	26.07	4598.0
2004-05-26 09:00:00	MSFT	Stock	26.05	26.229	25.93	25.99	4873244.0
2004-05-26 10:00:00	MSFT	Stock	25.98	26.01	25.87	25.95	6612557.0
2004-05-26 11:00:00	MSFT	Stock	25.96	25.96	25.85	25.89	7034665.0
2004-05-26 12:00:00	MSFT	Stock	25.88	25.93	25.85	25.88	4884622.0
2004-05-26 13:00:00	MSFT	Stock	25.89	26.02	25.85	25.99	5532713.0
2004-05-26 14:00:00	MSFT	Stock	25.99	26.1	25.93	26.05	8225066.0
2004-05-26 15:00:00	MSFT	Stock	26.05	26.14	25.94	26.14	8932833.0
2004-05-26 16:00:00	MSFT	Stock	26.14	26.19	26.1	26.13	778493.0
2004-05-26 17:00:00	MSFT	Stock	26.13	26.14	25.95	26.1	94934.0
2004-05-26 18:00:00	MSFT	Stock	26.1	26.11	26.09	26.1	8099.0
2004-05-26 08:00:00	NVDA	Stock	0.1813	0.1813	0.1813	0.1813	24000.0
2004-05-26 09:00:00	NVDA	Stock	0.1825	0.1882	0.1825	0.1877	71647680.0
2004-05-26 10:00:00	NVDA	Stock	0.1877	0.1878	0.1833	0.1862	85535040.0
2004-05-26 11:00:00	NVDA	Stock	0.1863	0.1881	0.1847	0.1879	88911600.0
2004-05-26 12:00:00	NVDA	Stock	0.1878	0.1899	0.1877	0.1896	65961840.0
2004-05-26 13:00:00	NVDA	Stock	0.1895	0.19	0.1884	0.1885	44913360.0
2004-05-26 14:00:00	NVDA	Stock	0.1885	0.1899	0.1882	0.1884	63852600.0
2004-05-26 15:00:00	NVDA	Stock	0.1885	0.1887	0.1862	0.1878	78029400.0
2004-05-26 16:00:00	NVDA	Stock	0.1878	0.188	0.1872	0.1878	2883600.0
2004-05-26 17:00:00	NVDA	Stock	0.1877	0.1877	0.1868	0.1868	192360.0
2004-05-26 08:00:00	AMZN	Stock	2.173	2.18	2.1655	2.173	62000.0
2004-05-26 09:00:00	AMZN	Stock	2.1775	2.25	2.1775	2.246	32382460.0
2004-05-26 10:00:00	AMZN	Stock	2.245	2.246	2.214	2.236	32307300.0
2004-05-26 11:00:00	AMZN	Stock	2.235	2.244	2.225	2.232	16055400.0
2004-05-26 12:00:00	AMZN	Stock	2.2325	2.2405	2.226	2.235	9345000.0
2004-05-26 13:00:00	AMZN	Stock	2.2345	2.237	2.227	2.2275	9187900.0
2004-05-26 14:00:00	AMZN	Stock	2.229	2.241	2.217	2.239	23632500.0
2004-05-26 15:00:00	AMZN	Stock	2.2385	2.241	2.2255	2.237	18194060.0
2004-05-26 16:00:00	AMZN	Stock	2.237	2.2395	2.2305	2.233	2024660.0
2004-05-26 17:00:00	AMZN	Stock	2.2367	2.237	2.2367	2.237	441000.0
2004-05-26 18:00:00	AMZN	Stock	2.233	2.237	2.233	2.237	122960.0
2004-05-26 09:00:00	CL	Stock	28.58	28.59	28.405	28.49	312400.0
2004-05-26 10:00:00	CL	Stock	28.495	28.825	28.49	28.81	524400.0
2004-05-26 11:00:00	CL	Stock	28.81	28.845	28.72	28.78	305000.0
2004-05-26 12:00:00	CL	Stock	28.775	28.78	28.7	28.765	243600.0
2004-05-26 13:00:00	CL	Stock	28.77	28.91	28.77	28.885	311400.0
2004-05-26 14:00:00	CL	Stock	28.885	29.0	28.85	28.89	430600.0
2004-05-26 15:00:00	CL	Stock	28.89	29.0	28.87	28.965	733800.0

> showing 50 of 24,359 rows — these rows as CSV

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