PREVIEW / stock_1hour / 2005-10-24

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-24.parquet
  size:    576 KB
  rows:    27,576
  symbols: 2,102

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-10-24 08:00:00	AAPL	Stock	1.9875	1.9893	1.9668	1.9825	966924.0
2005-10-24 09:00:00	AAPL	Stock	1.9825	1.9982	1.9675	1.9939	92782648.0
2005-10-24 10:00:00	AAPL	Stock	1.9939	2.0107	1.9789	1.9868	125644764.0
2005-10-24 11:00:00	AAPL	Stock	1.9875	2.0207	1.985	2.01	100327080.0
2005-10-24 12:00:00	AAPL	Stock	2.0096	2.025	2.0096	2.0193	87514028.0
2005-10-24 13:00:00	AAPL	Stock	2.0196	2.0204	2.0104	2.0179	50971340.0
2005-10-24 14:00:00	AAPL	Stock	2.0182	2.0196	2.0064	2.0071	44715580.0
2005-10-24 15:00:00	AAPL	Stock	2.0071	2.0279	2.0064	2.0246	96627944.0
2005-10-24 16:00:00	AAPL	Stock	2.0282	2.0321	2.0196	2.025	4019260.0
2005-10-24 17:00:00	AAPL	Stock	2.0268	2.0268	2.0232	2.0236	193872.0
2005-10-24 18:00:00	AAPL	Stock	2.0236	2.0236	2.0232	2.0232	180656.0
2005-10-24 06:00:00	MSFT	Stock	24.85	24.85	24.85	24.85	700.0
2005-10-24 08:00:00	MSFT	Stock	24.82	24.86	24.81	24.84	49964.0
2005-10-24 09:00:00	MSFT	Stock	24.84	24.95	24.82	24.86	5232335.0
2005-10-24 10:00:00	MSFT	Stock	24.85	24.9	24.68	24.73	6881713.0
2005-10-24 11:00:00	MSFT	Stock	24.73	24.91	24.72	24.84	8266708.0
2005-10-24 12:00:00	MSFT	Stock	24.84	25.04	24.83	25.02	7827312.0
2005-10-24 13:00:00	MSFT	Stock	25.02	25.02	24.87	24.91	4501688.0
2005-10-24 14:00:00	MSFT	Stock	24.91	25.02	24.91	24.93	3544437.0
2005-10-24 15:00:00	MSFT	Stock	24.93	25.1	24.92	25.09	14203913.0
2005-10-24 16:00:00	MSFT	Stock	25.1	25.13	25.05	25.08	396966.0
2005-10-24 17:00:00	MSFT	Stock	25.07	25.1	25.05	25.08	505400.0
2005-10-24 18:00:00	MSFT	Stock	25.1	25.1	25.06	25.08	1086.0
2005-10-24 09:00:00	NVDA	Stock	0.2689	0.2717	0.2667	0.268	41596320.0
2005-10-24 10:00:00	NVDA	Stock	0.2682	0.2695	0.2662	0.2662	54634920.0
2005-10-24 11:00:00	NVDA	Stock	0.2662	0.2692	0.2661	0.2686	22404120.0
2005-10-24 12:00:00	NVDA	Stock	0.2686	0.271	0.2681	0.2704	28482720.0
2005-10-24 13:00:00	NVDA	Stock	0.2704	0.2734	0.2695	0.2732	43538640.0
2005-10-24 14:00:00	NVDA	Stock	0.2732	0.2733	0.2708	0.2709	26209320.0
2005-10-24 15:00:00	NVDA	Stock	0.2709	0.2734	0.2709	0.2733	65588520.0
2005-10-24 16:00:00	NVDA	Stock	0.2734	0.2734	0.2718	0.2734	700680.0
2005-10-24 17:00:00	NVDA	Stock	0.2718	0.2718	0.2718	0.2718	24000.0
2005-10-24 09:00:00	AMZN	Stock	2.3	2.325	2.293	2.299	13938840.0
2005-10-24 10:00:00	AMZN	Stock	2.2985	2.345	2.298	2.3255	30185860.0
2005-10-24 11:00:00	AMZN	Stock	2.3255	2.3365	2.3135	2.3215	11729100.0
2005-10-24 12:00:00	AMZN	Stock	2.321	2.332	2.3125	2.326	8475340.0
2005-10-24 13:00:00	AMZN	Stock	2.3265	2.3335	2.3125	2.32	11144840.0
2005-10-24 14:00:00	AMZN	Stock	2.321	2.332	2.3165	2.3195	7547940.0
2005-10-24 15:00:00	AMZN	Stock	2.3195	2.348	2.3175	2.344	23487620.0
2005-10-24 16:00:00	AMZN	Stock	2.343	2.3475	2.34	2.3415	320560.0
2005-10-24 17:00:00	AMZN	Stock	2.344	2.3465	2.3415	2.3465	71500.0
2005-10-24 09:00:00	CL	Stock	25.98	26.245	25.98	26.1	242400.0
2005-10-24 10:00:00	CL	Stock	26.08	26.12	25.91	25.96	428800.0
2005-10-24 11:00:00	CL	Stock	25.965	26.075	25.935	26.015	390800.0
2005-10-24 12:00:00	CL	Stock	26.02	26.075	26.0	26.0	243200.0
2005-10-24 13:00:00	CL	Stock	26.005	26.07	25.98	26.055	245200.0
2005-10-24 14:00:00	CL	Stock	26.06	26.105	26.02	26.055	262000.0
2005-10-24 15:00:00	CL	Stock	26.06	26.245	26.0505	26.23	556600.0
2005-10-24 16:00:00	CL	Stock	26.25	26.25	26.25	26.25	400.0

> showing 49 of 27,576 rows — these rows as CSV

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