PREVIEW / stock_1hour / 2005-01-19

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-19.parquet
  size:    534 KB
  rows:    25,488
  symbols: 1,903

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-19 08:00:00	AAPL	Stock	1.2661	1.2688	1.2545	1.2621	2289840.0
2005-01-19 09:00:00	AAPL	Stock	1.263	1.2761	1.2563	1.2646	137482576.0
2005-01-19 10:00:00	AAPL	Stock	1.2646	1.2684	1.2598	1.2641	138368552.0
2005-01-19 11:00:00	AAPL	Stock	1.2643	1.2682	1.2609	1.263	82841248.0
2005-01-19 12:00:00	AAPL	Stock	1.2632	1.2652	1.2543	1.2579	80797304.0
2005-01-19 13:00:00	AAPL	Stock	1.258	1.2634	1.2571	1.2604	51782360.0
2005-01-19 14:00:00	AAPL	Stock	1.2602	1.2623	1.2527	1.2589	88361896.0
2005-01-19 15:00:00	AAPL	Stock	1.2589	1.2618	1.2455	1.2482	151102840.0
2005-01-19 16:00:00	AAPL	Stock	1.2473	1.248	1.2327	1.2434	8570632.0
2005-01-19 17:00:00	AAPL	Stock	1.242	1.2434	1.2305	1.2321	2484496.0
2005-01-19 18:00:00	AAPL	Stock	1.2321	1.2526	1.2321	1.2375	3712464.0
2005-01-19 08:00:00	MSFT	Stock	26.31	26.31	26.25	26.26	13608.0
2005-01-19 09:00:00	MSFT	Stock	26.26	26.28	26.12	26.13	8652826.0
2005-01-19 10:00:00	MSFT	Stock	26.14	26.2	26.07	26.109	8802296.0
2005-01-19 11:00:00	MSFT	Stock	26.1	26.15	26.06	26.1	5547693.0
2005-01-19 12:00:00	MSFT	Stock	26.1	26.2	26.02	26.092	5590944.0
2005-01-19 13:00:00	MSFT	Stock	26.1	26.11	26.02	26.06	4432767.0
2005-01-19 14:00:00	MSFT	Stock	26.07	26.11	26.04	26.06	5350364.0
2005-01-19 15:00:00	MSFT	Stock	26.07	26.1	25.92	25.97	15773614.0
2005-01-19 16:00:00	MSFT	Stock	25.98	25.99	25.84	25.86	660026.0
2005-01-19 17:00:00	MSFT	Stock	25.86	25.86	25.76	25.77	33817.0
2005-01-19 18:00:00	MSFT	Stock	25.8	26.003	25.75	25.8	2858361.0
2005-01-19 08:00:00	NVDA	Stock	0.1817	0.1817	0.1817	0.1817	36000.0
2005-01-19 09:00:00	NVDA	Stock	0.1817	0.1833	0.1817	0.1817	42299040.0
2005-01-19 10:00:00	NVDA	Stock	0.1817	0.1827	0.1813	0.1813	47125560.0
2005-01-19 11:00:00	NVDA	Stock	0.1813	0.1814	0.1795	0.1799	46992960.0
2005-01-19 12:00:00	NVDA	Stock	0.1798	0.1804	0.1795	0.1802	25608720.0
2005-01-19 13:00:00	NVDA	Stock	0.1802	0.181	0.1798	0.1803	23050680.0
2005-01-19 14:00:00	NVDA	Stock	0.1802	0.1812	0.18	0.1803	24859920.0
2005-01-19 15:00:00	NVDA	Stock	0.1803	0.1806	0.1772	0.1772	102245760.0
2005-01-19 16:00:00	NVDA	Stock	0.1777	0.178	0.1774	0.1777	15035160.0
2005-01-19 17:00:00	NVDA	Stock	0.1771	0.1774	0.175	0.175	1412760.0
2005-01-19 18:00:00	NVDA	Stock	0.1785	0.1785	0.1746	0.1746	538800.0
2005-01-19 08:00:00	AMZN	Stock	2.23	2.2395	2.2125	2.225	76000.0
2005-01-19 09:00:00	AMZN	Stock	2.221	2.237	2.186	2.209	25215800.0
2005-01-19 10:00:00	AMZN	Stock	2.2095	2.21	2.194	2.197	16446760.0
2005-01-19 11:00:00	AMZN	Stock	2.197	2.206	2.19	2.1905	9595780.0
2005-01-19 12:00:00	AMZN	Stock	2.1905	2.197	2.1715	2.195	13576160.0
2005-01-19 13:00:00	AMZN	Stock	2.195	2.2175	2.19	2.2005	13646380.0
2005-01-19 14:00:00	AMZN	Stock	2.2005	2.2125	2.1935	2.203	12013300.0
2005-01-19 15:00:00	AMZN	Stock	2.2035	2.204	2.184	2.1935	44590480.0
2005-01-19 16:00:00	AMZN	Stock	2.1935	2.198	2.105	2.1055	6784800.0
2005-01-19 17:00:00	AMZN	Stock	2.1045	2.198	2.09	2.1045	2983460.0
2005-01-19 18:00:00	AMZN	Stock	2.1045	2.1965	2.098	2.105	431000.0
2005-01-19 09:00:00	CL	Stock	25.07	25.15	25.045	25.125	325000.0
2005-01-19 10:00:00	CL	Stock	25.125	25.125	25.0	25.07	537600.0
2005-01-19 11:00:00	CL	Stock	25.07	25.075	24.995	25.01	310000.0
2005-01-19 12:00:00	CL	Stock	25.015	25.1	24.95	25.1	346000.0
2005-01-19 13:00:00	CL	Stock	25.1	25.175	25.08	25.17	188200.0
2005-01-19 14:00:00	CL	Stock	25.17	25.24	25.16	25.17	203600.0

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

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