PREVIEW / stock_1hour / 2005-01-20

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-20.parquet
  size:    536 KB
  rows:    25,408
  symbols: 1,899

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-20 08:00:00	AAPL	Stock	1.2366	1.2438	1.2366	1.242	3168144.0
2005-01-20 09:00:00	AAPL	Stock	1.242	1.2536	1.2395	1.2482	117909344.0
2005-01-20 10:00:00	AAPL	Stock	1.248	1.2607	1.2475	1.2596	151823224.0
2005-01-20 11:00:00	AAPL	Stock	1.2595	1.2727	1.2571	1.2691	165543056.0
2005-01-20 12:00:00	AAPL	Stock	1.2686	1.2714	1.2568	1.267	114200968.0
2005-01-20 13:00:00	AAPL	Stock	1.2671	1.2705	1.2595	1.2605	98875168.0
2005-01-20 14:00:00	AAPL	Stock	1.2607	1.2705	1.2602	1.2641	109743984.0
2005-01-20 15:00:00	AAPL	Stock	1.2641	1.2677	1.2559	1.2579	127368416.0
2005-01-20 16:00:00	AAPL	Stock	1.258	1.2686	1.258	1.2625	11250176.0
2005-01-20 17:00:00	AAPL	Stock	1.2602	1.2677	1.2602	1.2614	385560.0
2005-01-20 18:00:00	AAPL	Stock	1.2611	1.2632	1.2611	1.2629	296072.0
2005-01-20 08:00:00	MSFT	Stock	25.76	25.85	25.7	25.81	46910.0
2005-01-20 09:00:00	MSFT	Stock	25.8	26.001	25.8	25.92	7308881.0
2005-01-20 10:00:00	MSFT	Stock	25.92	26.03	25.85	25.98	8831535.0
2005-01-20 11:00:00	MSFT	Stock	25.97	26.071	25.94	26.05	8469670.0
2005-01-20 12:00:00	MSFT	Stock	26.05	26.1	25.95	25.95	5326329.0
2005-01-20 13:00:00	MSFT	Stock	25.96	25.97	25.85	25.88	8360602.0
2005-01-20 14:00:00	MSFT	Stock	25.89	25.99	25.88	25.941	7213254.0
2005-01-20 15:00:00	MSFT	Stock	25.94	25.97	25.74	25.85	10860906.0
2005-01-20 16:00:00	MSFT	Stock	25.86	25.935	25.83	25.84	702434.0
2005-01-20 17:00:00	MSFT	Stock	25.83	25.94	25.83	25.85	12950.0
2005-01-20 18:00:00	MSFT	Stock	25.85	25.86	25.85	25.85	2000.0
2005-01-20 09:00:00	NVDA	Stock	0.1754	0.1782	0.1741	0.1778	69181800.0
2005-01-20 10:00:00	NVDA	Stock	0.1778	0.1806	0.1776	0.1792	87126120.0
2005-01-20 11:00:00	NVDA	Stock	0.1792	0.1827	0.1792	0.1823	80051760.0
2005-01-20 12:00:00	NVDA	Stock	0.1823	0.1823	0.1802	0.1808	68514600.0
2005-01-20 13:00:00	NVDA	Stock	0.1808	0.1808	0.1787	0.1797	52293360.0
2005-01-20 14:00:00	NVDA	Stock	0.1798	0.1807	0.1782	0.1787	52359600.0
2005-01-20 15:00:00	NVDA	Stock	0.1786	0.1799	0.1771	0.1782	205368000.0
2005-01-20 16:00:00	NVDA	Stock	0.178	0.179	0.1778	0.1781	506280.0
2005-01-20 17:00:00	NVDA	Stock	0.1775	0.1775	0.1775	0.1775	180000.0
2005-01-20 08:00:00	AMZN	Stock	2.1	2.1155	2.0825	2.088	1525140.0
2005-01-20 09:00:00	AMZN	Stock	2.0875	2.1625	2.075	2.1035	53032940.0
2005-01-20 10:00:00	AMZN	Stock	2.1038	2.114	2.0965	2.1035	54049340.0
2005-01-20 11:00:00	AMZN	Stock	2.1035	2.131	2.1	2.1245	36451860.0
2005-01-20 12:00:00	AMZN	Stock	2.1245	2.125	2.106	2.1075	15843260.0
2005-01-20 13:00:00	AMZN	Stock	2.1075	2.1255	2.102	2.1155	25566080.0
2005-01-20 14:00:00	AMZN	Stock	2.1155	2.134	2.1145	2.125	25927020.0
2005-01-20 15:00:00	AMZN	Stock	2.125	2.1259	2.11	2.118	34529900.0
2005-01-20 16:00:00	AMZN	Stock	2.1155	2.1185	2.114	2.1145	1524900.0
2005-01-20 17:00:00	AMZN	Stock	2.1145	2.1225	2.1145	2.1225	39080.0
2005-01-20 18:00:00	AMZN	Stock	2.1225	2.123	2.1225	2.123	6000.0
2005-01-20 09:00:00	CL	Stock	25.06	25.16	25.005	25.06	289600.0
2005-01-20 10:00:00	CL	Stock	25.045	25.075	24.94	25.025	701200.0
2005-01-20 11:00:00	CL	Stock	25.035	25.09	25.005	25.06	290200.0
2005-01-20 12:00:00	CL	Stock	25.06	25.06	25.0	25.02	323600.0
2005-01-20 13:00:00	CL	Stock	25.015	25.105	24.98	25.095	305600.0
2005-01-20 14:00:00	CL	Stock	25.095	25.23	25.095	25.175	481600.0
2005-01-20 15:00:00	CL	Stock	25.175	25.18	25.025	25.075	751000.0
2005-01-20 16:00:00	CL	Stock	25.06	25.06	25.06	25.06	6200.0

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

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