PREVIEW / stock_1hour / 2005-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-24.parquet
  size:    535 KB
  rows:    25,237
  symbols: 1,914

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-01-24 08:00:00	AAPL	Stock	1.2727	1.2741	1.2641	1.2723	3822672.0
2005-01-24 09:00:00	AAPL	Stock	1.2723	1.2777	1.2614	1.2702	132271552.0
2005-01-24 10:00:00	AAPL	Stock	1.27	1.2818	1.2679	1.2702	227414768.0
2005-01-24 11:00:00	AAPL	Stock	1.27	1.2757	1.2623	1.267	131023984.0
2005-01-24 12:00:00	AAPL	Stock	1.2673	1.2707	1.2598	1.2661	81249056.0
2005-01-24 13:00:00	AAPL	Stock	1.2664	1.273	1.2661	1.2703	60057592.0
2005-01-24 14:00:00	AAPL	Stock	1.2702	1.2741	1.2661	1.2682	79718856.0
2005-01-24 15:00:00	AAPL	Stock	1.2682	1.2736	1.2629	1.2659	117164208.0
2005-01-24 16:00:00	AAPL	Stock	1.2643	1.2675	1.2636	1.2661	5060272.0
2005-01-24 17:00:00	AAPL	Stock	1.2671	1.2677	1.2636	1.2671	2550016.0
2005-01-24 18:00:00	AAPL	Stock	1.2664	1.2673	1.2664	1.2671	22400.0
2005-01-24 08:00:00	MSFT	Stock	25.7	25.8	25.7	25.8	98659.0
2005-01-24 09:00:00	MSFT	Stock	25.8	25.81	25.66	25.74	7381698.0
2005-01-24 10:00:00	MSFT	Stock	25.74	25.99	25.72	25.928	12054023.0
2005-01-24 11:00:00	MSFT	Stock	25.93	25.98	25.83	25.89	8793923.0
2005-01-24 12:00:00	MSFT	Stock	25.9	25.98	25.85	25.9	6854598.0
2005-01-24 13:00:00	MSFT	Stock	25.91	26.0	25.85	25.87	6973110.0
2005-01-24 14:00:00	MSFT	Stock	25.88	25.94	25.76	25.8	7838939.0
2005-01-24 15:00:00	MSFT	Stock	25.8	25.87	25.64	25.64	17002731.0
2005-01-24 16:00:00	MSFT	Stock	25.67	25.72	25.64	25.67	728859.0
2005-01-24 17:00:00	MSFT	Stock	25.97	25.97	25.65	25.71	62338.0
2005-01-24 18:00:00	MSFT	Stock	25.71	25.72	25.71	25.72	2800.0
2005-01-24 08:00:00	NVDA	Stock	0.1782	0.1782	0.1782	0.1782	24000.0
2005-01-24 09:00:00	NVDA	Stock	0.1783	0.1802	0.1752	0.1754	46611960.0
2005-01-24 10:00:00	NVDA	Stock	0.1753	0.1777	0.1737	0.1744	98273160.0
2005-01-24 11:00:00	NVDA	Stock	0.1744	0.1748	0.1719	0.1743	75851040.0
2005-01-24 12:00:00	NVDA	Stock	0.1743	0.1753	0.1729	0.1736	43750440.0
2005-01-24 13:00:00	NVDA	Stock	0.1736	0.1759	0.1735	0.1752	48468720.0
2005-01-24 14:00:00	NVDA	Stock	0.1752	0.1757	0.1734	0.1738	43796160.0
2005-01-24 15:00:00	NVDA	Stock	0.1739	0.1745	0.1705	0.1715	96594000.0
2005-01-24 16:00:00	NVDA	Stock	0.1716	0.1723	0.1712	0.1716	1488720.0
2005-01-24 17:00:00	NVDA	Stock	0.1716	0.1716	0.1716	0.1716	132000.0
2005-01-24 08:00:00	AMZN	Stock	2.06	2.0795	2.058	2.0795	156920.0
2005-01-24 09:00:00	AMZN	Stock	2.085	2.0975	2.062	2.0705	27557000.0
2005-01-24 10:00:00	AMZN	Stock	2.071	2.0935	2.0545	2.06	29709620.0
2005-01-24 11:00:00	AMZN	Stock	2.06	2.072	2.035	2.063	28408080.0
2005-01-24 12:00:00	AMZN	Stock	2.0625	2.0645	2.0385	2.0405	18275380.0
2005-01-24 13:00:00	AMZN	Stock	2.0405	2.0525	2.0263	2.0345	23769060.0
2005-01-24 14:00:00	AMZN	Stock	2.033	2.0375	2.016	2.0205	27266560.0
2005-01-24 15:00:00	AMZN	Stock	2.0205	2.033	2.016	2.0165	33678020.0
2005-01-24 16:00:00	AMZN	Stock	2.017	2.024	2.014	2.015	585160.0
2005-01-24 17:00:00	AMZN	Stock	2.019	2.019	2.015	2.015	239440.0
2005-01-24 18:00:00	AMZN	Stock	2.015	2.015	2.015	2.015	10000.0
2005-01-24 09:00:00	CL	Stock	24.9	24.95	24.755	24.76	354600.0
2005-01-24 10:00:00	CL	Stock	24.77	24.795	24.625	24.64	629600.0
2005-01-24 11:00:00	CL	Stock	24.64	24.77	24.61	24.74	496400.0
2005-01-24 12:00:00	CL	Stock	24.74	24.815	24.67	24.71	233800.0
2005-01-24 13:00:00	CL	Stock	24.71	24.785	24.655	24.675	400000.0
2005-01-24 14:00:00	CL	Stock	24.675	24.72	24.59	24.615	291400.0
2005-01-24 15:00:00	CL	Stock	24.615	24.66	24.56	24.595	1055800.0

> showing 50 of 25,237 rows — these rows as CSV

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