PREVIEW / stock_1hour / 2005-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-09.parquet
  size:    563 KB
  rows:    26,779
  symbols: 2,071

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-09-09 08:00:00	AAPL	Stock	1.7854	1.7854	1.7789	1.78	784476.0
2005-09-09 09:00:00	AAPL	Stock	1.78	1.7943	1.7782	1.7882	93405256.0
2005-09-09 10:00:00	AAPL	Stock	1.7882	1.8018	1.7836	1.7989	106479352.0
2005-09-09 11:00:00	AAPL	Stock	1.7989	1.8214	1.7979	1.8211	127099756.0
2005-09-09 12:00:00	AAPL	Stock	1.8211	1.8214	1.8096	1.8139	58634044.0
2005-09-09 13:00:00	AAPL	Stock	1.8139	1.8211	1.8136	1.8193	47304460.0
2005-09-09 14:00:00	AAPL	Stock	1.8193	1.8196	1.8129	1.8157	37530248.0
2005-09-09 15:00:00	AAPL	Stock	1.8161	1.8339	1.8146	1.8314	133050120.0
2005-09-09 16:00:00	AAPL	Stock	1.8321	1.8329	1.8282	1.8314	3297280.0
2005-09-09 17:00:00	AAPL	Stock	1.8321	1.8375	1.8321	1.8364	169400.0
2005-09-09 18:00:00	AAPL	Stock	1.8357	1.8393	1.8346	1.8357	255920.0
2005-09-09 08:00:00	MSFT	Stock	26.65	26.68	26.51	26.63	50396.0
2005-09-09 09:00:00	MSFT	Stock	26.63	26.75	26.61	26.71	3762371.0
2005-09-09 10:00:00	MSFT	Stock	26.71	26.77	26.67	26.74	4624498.0
2005-09-09 11:00:00	MSFT	Stock	26.74	26.81	26.72	26.8	5372581.0
2005-09-09 12:00:00	MSFT	Stock	26.79	26.82	26.72	26.721	3653866.0
2005-09-09 13:00:00	MSFT	Stock	26.73	26.73	26.63	26.65	6247981.0
2005-09-09 14:00:00	MSFT	Stock	26.658	26.66	26.53	26.629	6677238.0
2005-09-09 15:00:00	MSFT	Stock	26.62	26.69	26.55	26.6	8586292.0
2005-09-09 16:00:00	MSFT	Stock	26.6	26.666	26.56	26.57	578453.0
2005-09-09 17:00:00	MSFT	Stock	26.59	26.724	26.57	26.724	22465.0
2005-09-09 18:00:00	MSFT	Stock	26.632	26.632	26.57	26.6	22346.0
2005-09-09 08:00:00	NVDA	Stock	0.265	0.2677	0.265	0.2677	24000.0
2005-09-09 09:00:00	NVDA	Stock	0.2658	0.2678	0.2633	0.2656	74725920.0
2005-09-09 10:00:00	NVDA	Stock	0.2656	0.2665	0.2649	0.2659	71059200.0
2005-09-09 11:00:00	NVDA	Stock	0.2659	0.2677	0.265	0.2674	76114080.0
2005-09-09 12:00:00	NVDA	Stock	0.2674	0.2688	0.2674	0.2685	55538040.0
2005-09-09 13:00:00	NVDA	Stock	0.2685	0.2688	0.2677	0.2677	49043160.0
2005-09-09 14:00:00	NVDA	Stock	0.2677	0.2681	0.2667	0.2677	42141120.0
2005-09-09 15:00:00	NVDA	Stock	0.2677	0.2683	0.2673	0.2682	67606560.0
2005-09-09 16:00:00	NVDA	Stock	0.2677	0.2682	0.2677	0.2679	3678840.0
2005-09-09 17:00:00	NVDA	Stock	0.2682	0.2682	0.268	0.268	83280.0
2005-09-09 18:00:00	NVDA	Stock	0.267	0.267	0.267	0.267	3312000.0
2005-09-09 09:00:00	AMZN	Stock	2.1545	2.16	2.142	2.1425	6330040.0
2005-09-09 10:00:00	AMZN	Stock	2.142	2.1505	2.1405	2.1475	7618440.0
2005-09-09 11:00:00	AMZN	Stock	2.148	2.155	2.1405	2.152	5558760.0
2005-09-09 12:00:00	AMZN	Stock	2.1515	2.158	2.1495	2.155	9303400.0
2005-09-09 13:00:00	AMZN	Stock	2.1555	2.1585	2.15	2.154	7242360.0
2005-09-09 14:00:00	AMZN	Stock	2.154	2.154	2.1445	2.145	10257140.0
2005-09-09 15:00:00	AMZN	Stock	2.145	2.149	2.143	2.148	18714800.0
2005-09-09 16:00:00	AMZN	Stock	2.147	2.148	2.1465	2.147	61260.0
2005-09-09 17:00:00	AMZN	Stock	2.1475	2.1475	2.1475	2.1475	6000.0
2005-09-09 18:00:00	AMZN	Stock	2.1494	2.1494	2.144	2.1485	3035320.0
2005-09-09 09:00:00	CL	Stock	26.8	26.83	26.635	26.65	263000.0
2005-09-09 10:00:00	CL	Stock	26.65	26.73	26.635	26.655	359400.0
2005-09-09 11:00:00	CL	Stock	26.66	26.815	26.645	26.78	313200.0
2005-09-09 12:00:00	CL	Stock	26.765	26.85	26.715	26.74	395800.0
2005-09-09 13:00:00	CL	Stock	26.74	26.79	26.675	26.765	369200.0
2005-09-09 14:00:00	CL	Stock	26.76	26.76	26.72	26.745	224200.0
2005-09-09 15:00:00	CL	Stock	26.745	26.76	26.665	26.665	628800.0

> showing 50 of 26,779 rows — these rows as CSV

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