PREVIEW / stock_1hour / 2005-10-06

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-06.parquet
  size:    580 KB
  rows:    27,584
  symbols: 2,087

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-06 07:00:00	AAPL	Stock	1.8929	1.8929	1.8929	1.8929	42000.0
2005-10-06 08:00:00	AAPL	Stock	1.8929	1.9071	1.8929	1.9018	1967588.0
2005-10-06 09:00:00	AAPL	Stock	1.8982	1.9104	1.8871	1.8975	77006776.0
2005-10-06 10:00:00	AAPL	Stock	1.8975	1.9014	1.8686	1.8921	128350656.0
2005-10-06 11:00:00	AAPL	Stock	1.8918	1.9079	1.8875	1.8907	73480344.0
2005-10-06 12:00:00	AAPL	Stock	1.8904	1.8971	1.8771	1.8857	48218072.0
2005-10-06 13:00:00	AAPL	Stock	1.8854	1.8968	1.8757	1.8796	57351560.0
2005-10-06 14:00:00	AAPL	Stock	1.8796	1.8796	1.8429	1.8507	131258008.0
2005-10-06 15:00:00	AAPL	Stock	1.8507	1.8571	1.8168	1.8461	229155556.0
2005-10-06 16:00:00	AAPL	Stock	1.8454	1.8536	1.8454	1.8532	1221920.0
2005-10-06 17:00:00	AAPL	Stock	1.8525	1.8525	1.8279	1.8464	436044.0
2005-10-06 18:00:00	AAPL	Stock	1.8446	1.8694	1.8446	1.85	133560.0
2005-10-06 06:00:00	MSFT	Stock	24.7	24.7	24.7	24.7	1000.0
2005-10-06 08:00:00	MSFT	Stock	24.65	24.74	24.65	24.73	174464.0
2005-10-06 09:00:00	MSFT	Stock	24.7	24.87	24.6	24.71	11717204.0
2005-10-06 10:00:00	MSFT	Stock	24.7	24.95	24.62	24.85	12873983.0
2005-10-06 11:00:00	MSFT	Stock	24.848	24.9	24.76	24.78	6717182.0
2005-10-06 12:00:00	MSFT	Stock	24.79	24.819	24.67	24.75	6219081.0
2005-10-06 13:00:00	MSFT	Stock	24.74	24.83	24.7	24.72	8356340.0
2005-10-06 14:00:00	MSFT	Stock	24.72	24.78	24.67	24.72	9358721.0
2005-10-06 15:00:00	MSFT	Stock	24.72	24.8	24.53	24.72	23717861.0
2005-10-06 16:00:00	MSFT	Stock	24.73	24.78	24.68	24.77	505634.0
2005-10-06 17:00:00	MSFT	Stock	24.743	24.77	24.6	24.77	51951.0
2005-10-06 18:00:00	MSFT	Stock	24.74	24.85	24.74	24.79	8420.0
2005-10-06 08:00:00	NVDA	Stock	0.2812	0.2827	0.2812	0.2817	240000.0
2005-10-06 09:00:00	NVDA	Stock	0.2825	0.2825	0.2707	0.2751	123891240.0
2005-10-06 10:00:00	NVDA	Stock	0.2751	0.2775	0.2739	0.2755	120745920.0
2005-10-06 11:00:00	NVDA	Stock	0.2756	0.2806	0.2754	0.2804	80156520.0
2005-10-06 12:00:00	NVDA	Stock	0.2804	0.2814	0.2793	0.2812	68781600.0
2005-10-06 13:00:00	NVDA	Stock	0.2811	0.2841	0.2797	0.2797	89523480.0
2005-10-06 14:00:00	NVDA	Stock	0.2797	0.282	0.2782	0.2797	72124080.0
2005-10-06 15:00:00	NVDA	Stock	0.2797	0.2797	0.2759	0.2789	105579480.0
2005-10-06 16:00:00	NVDA	Stock	0.2791	0.2805	0.2786	0.2786	2230680.0
2005-10-06 17:00:00	NVDA	Stock	0.2781	0.2781	0.2781	0.2781	58800.0
2005-10-06 08:00:00	AMZN	Stock	2.2305	2.24	2.2245	2.235	256000.0
2005-10-06 09:00:00	AMZN	Stock	2.238	2.245	2.202	2.218	12557660.0
2005-10-06 10:00:00	AMZN	Stock	2.2175	2.2225	2.1875	2.2135	16693440.0
2005-10-06 11:00:00	AMZN	Stock	2.2135	2.231	2.2	2.2285	14358300.0
2005-10-06 12:00:00	AMZN	Stock	2.229	2.2335	2.2185	2.229	9049340.0
2005-10-06 13:00:00	AMZN	Stock	2.229	2.2335	2.2055	2.2085	8456840.0
2005-10-06 14:00:00	AMZN	Stock	2.209	2.2095	2.187	2.195	15289040.0
2005-10-06 15:00:00	AMZN	Stock	2.195	2.2185	2.1665	2.204	41699280.0
2005-10-06 16:00:00	AMZN	Stock	2.204	2.2095	2.197	2.2015	1323480.0
2005-10-06 17:00:00	AMZN	Stock	2.1685	2.2066	2.1685	2.19	27780.0
2005-10-06 09:00:00	CL	Stock	26.295	26.335	26.105	26.195	383000.0
2005-10-06 10:00:00	CL	Stock	26.21	26.475	26.125	26.385	855000.0
2005-10-06 11:00:00	CL	Stock	26.375	26.42	26.275	26.285	835800.0
2005-10-06 12:00:00	CL	Stock	26.285	26.31	26.175	26.24	526600.0
2005-10-06 13:00:00	CL	Stock	26.245	26.3	26.2	26.21	374000.0
2005-10-06 14:00:00	CL	Stock	26.215	26.265	26.065	26.12	679600.0

> showing 50 of 27,584 rows — these rows as CSV

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