PREVIEW / stock_1hour / 2005-12-21

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-21.parquet
  size:    582 KB
  rows:    27,478
  symbols: 2,160

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-12-21 07:00:00	AAPL	Stock	2.5786	2.5929	2.5786	2.5861	86800.0
2005-12-21 08:00:00	AAPL	Stock	2.5871	2.5911	2.5839	2.585	1320228.0
2005-12-21 09:00:00	AAPL	Stock	2.5857	2.6154	2.5857	2.6046	80847676.0
2005-12-21 10:00:00	AAPL	Stock	2.605	2.6246	2.605	2.6182	101884720.0
2005-12-21 11:00:00	AAPL	Stock	2.6182	2.6229	2.6104	2.6192	51201276.0
2005-12-21 12:00:00	AAPL	Stock	2.6193	2.6289	2.6192	2.6229	49948024.0
2005-12-21 13:00:00	AAPL	Stock	2.6232	2.6243	2.6036	2.6143	55160000.0
2005-12-21 14:00:00	AAPL	Stock	2.6143	2.6196	2.6089	2.6132	40319944.0
2005-12-21 15:00:00	AAPL	Stock	2.6129	2.6286	2.61	2.6246	82201756.0
2005-12-21 16:00:00	AAPL	Stock	2.6246	2.6268	2.6221	2.625	862960.0
2005-12-21 17:00:00	AAPL	Stock	2.6264	2.6268	2.6232	2.6248	413868.0
2005-12-21 18:00:00	AAPL	Stock	2.625	2.625	2.6155	2.6239	3280200.0
2005-12-21 08:00:00	MSFT	Stock	26.88	26.88	26.81	26.86	17972.0
2005-12-21 09:00:00	MSFT	Stock	26.86	26.94	26.77	26.78	7804943.0
2005-12-21 10:00:00	MSFT	Stock	26.78	26.83	26.76	26.82	8824901.0
2005-12-21 11:00:00	MSFT	Stock	26.82	26.83	26.79	26.809	5186811.0
2005-12-21 12:00:00	MSFT	Stock	26.8	26.838	26.74	26.82	13064206.0
2005-12-21 13:00:00	MSFT	Stock	26.81	26.83	26.77	26.81	13458863.0
2005-12-21 14:00:00	MSFT	Stock	26.802	26.82	26.71	26.73	14220199.0
2005-12-21 15:00:00	MSFT	Stock	26.73	26.8	26.71	26.73	8987374.0
2005-12-21 16:00:00	MSFT	Stock	26.74	26.78	26.72	26.78	253003.0
2005-12-21 17:00:00	MSFT	Stock	26.79	26.798	26.73	26.73	45229.0
2005-12-21 18:00:00	MSFT	Stock	26.793	26.793	26.74	26.74	2650936.0
2005-12-21 08:00:00	NVDA	Stock	0.3042	0.3042	0.3004	0.3005	78000.0
2005-12-21 09:00:00	NVDA	Stock	0.3006	0.3057	0.2985	0.3019	43661760.0
2005-12-21 10:00:00	NVDA	Stock	0.3017	0.3054	0.3017	0.3041	38306280.0
2005-12-21 11:00:00	NVDA	Stock	0.3042	0.3054	0.3037	0.3038	20128920.0
2005-12-21 12:00:00	NVDA	Stock	0.3038	0.3042	0.3027	0.3028	18242640.0
2005-12-21 13:00:00	NVDA	Stock	0.3029	0.3037	0.2996	0.2997	28777800.0
2005-12-21 14:00:00	NVDA	Stock	0.2997	0.3007	0.2988	0.2996	42541440.0
2005-12-21 15:00:00	NVDA	Stock	0.2996	0.3015	0.2994	0.3015	53324280.0
2005-12-21 16:00:00	NVDA	Stock	0.3015	0.3015	0.3012	0.3015	227760.0
2005-12-21 17:00:00	NVDA	Stock	0.3012	0.3012	0.3012	0.3012	129000.0
2005-12-21 18:00:00	NVDA	Stock	0.3015	0.302	0.3015	0.302	11328000.0
2005-12-21 09:00:00	AMZN	Stock	2.4125	2.425	2.4	2.416	12719040.0
2005-12-21 10:00:00	AMZN	Stock	2.417	2.4215	2.389	2.403	23541320.0
2005-12-21 11:00:00	AMZN	Stock	2.4045	2.415	2.4	2.404	8739860.0
2005-12-21 12:00:00	AMZN	Stock	2.404	2.4145	2.4	2.4125	12175980.0
2005-12-21 13:00:00	AMZN	Stock	2.4135	2.4415	2.4125	2.4375	29598680.0
2005-12-21 14:00:00	AMZN	Stock	2.4375	2.4495	2.4315	2.4375	21648440.0
2005-12-21 15:00:00	AMZN	Stock	2.438	2.453	2.433	2.448	31507120.0
2005-12-21 16:00:00	AMZN	Stock	2.4505	2.454	2.4475	2.4525	390360.0
2005-12-21 17:00:00	AMZN	Stock	2.451	2.451	2.4485	2.451	150100.0
2005-12-21 18:00:00	AMZN	Stock	2.4263	2.4263	2.4263	2.4263	4320000.0
2005-12-21 09:00:00	CL	Stock	27.695	27.88	27.6755	27.725	357800.0
2005-12-21 10:00:00	CL	Stock	27.73	27.84	27.725	27.77	444400.0
2005-12-21 11:00:00	CL	Stock	27.77	27.785	27.66	27.66	390200.0
2005-12-21 12:00:00	CL	Stock	27.66	27.795	27.645	27.7	417400.0
2005-12-21 13:00:00	CL	Stock	27.7	27.725	27.525	27.625	606800.0
2005-12-21 14:00:00	CL	Stock	27.615	27.67	27.56	27.57	325000.0

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

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