PREVIEW / stock_1hour / 2005-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-27.parquet
  size:    576 KB
  rows:    27,577
  symbols: 2,007

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-06-27 07:00:00	AAPL	Stock	1.3211	1.3211	1.3125	1.3125	313040.0
2005-06-27 08:00:00	AAPL	Stock	1.3161	1.3321	1.3046	1.3168	8436232.0
2005-06-27 09:00:00	AAPL	Stock	1.3171	1.3339	1.3143	1.3264	94218712.0
2005-06-27 10:00:00	AAPL	Stock	1.3261	1.3607	1.3184	1.3496	150996440.0
2005-06-27 11:00:00	AAPL	Stock	1.3496	1.3511	1.3311	1.3321	78733816.0
2005-06-27 12:00:00	AAPL	Stock	1.3321	1.3354	1.3204	1.3221	59122392.0
2005-06-27 13:00:00	AAPL	Stock	1.3214	1.325	1.31	1.3107	69366220.0
2005-06-27 14:00:00	AAPL	Stock	1.3107	1.3229	1.3104	1.3214	45053288.0
2005-06-27 15:00:00	AAPL	Stock	1.3211	1.3304	1.3175	1.325	78771616.0
2005-06-27 16:00:00	AAPL	Stock	1.325	1.3318	1.3239	1.3293	4003328.0
2005-06-27 17:00:00	AAPL	Stock	1.3293	1.3304	1.3249	1.3286	286916.0
2005-06-27 18:00:00	AAPL	Stock	1.3293	1.3304	1.3243	1.3243	171164.0
2005-06-27 07:00:00	MSFT	Stock	25.03	25.03	25.03	25.03	2200.0
2005-06-27 08:00:00	MSFT	Stock	25.03	25.08	25.03	25.05	37353.0
2005-06-27 09:00:00	MSFT	Stock	25.05	25.23	25.03	25.13	8081805.0
2005-06-27 10:00:00	MSFT	Stock	25.13	25.25	25.06	25.14	9633592.0
2005-06-27 11:00:00	MSFT	Stock	25.14	25.21	25.12	25.19	5904416.0
2005-06-27 12:00:00	MSFT	Stock	25.19	25.25	25.07	25.08	6277926.0
2005-06-27 13:00:00	MSFT	Stock	25.08	25.14	25.06	25.09	7453205.0
2005-06-27 14:00:00	MSFT	Stock	25.09	25.11	25.03	25.07	6862575.0
2005-06-27 15:00:00	MSFT	Stock	25.07	25.11	25.03	25.07	13532484.0
2005-06-27 16:00:00	MSFT	Stock	25.06	25.08	25.04	25.07	448013.0
2005-06-27 17:00:00	MSFT	Stock	25.05	25.127	25.049	25.07	145537.0
2005-06-27 18:00:00	MSFT	Stock	25.05	25.12	25.04	25.12	64698.0
2005-06-27 08:00:00	NVDA	Stock	0.2271	0.2271	0.2271	0.2271	156000.0
2005-06-27 09:00:00	NVDA	Stock	0.2249	0.2262	0.2237	0.2238	32177760.0
2005-06-27 10:00:00	NVDA	Stock	0.2238	0.2255	0.2226	0.2244	59271120.0
2005-06-27 11:00:00	NVDA	Stock	0.2243	0.2243	0.2219	0.2238	46832280.0
2005-06-27 12:00:00	NVDA	Stock	0.2237	0.225	0.2237	0.2237	34863120.0
2005-06-27 13:00:00	NVDA	Stock	0.2237	0.2244	0.2229	0.2229	30967800.0
2005-06-27 14:00:00	NVDA	Stock	0.2229	0.2256	0.2227	0.2247	73957560.0
2005-06-27 15:00:00	NVDA	Stock	0.2248	0.2248	0.2237	0.224	62195160.0
2005-06-27 16:00:00	NVDA	Stock	0.2239	0.224	0.2221	0.224	2831280.0
2005-06-27 17:00:00	NVDA	Stock	0.224	0.2245	0.224	0.2245	715200.0
2005-06-27 09:00:00	AMZN	Stock	1.7435	1.7525	1.739	1.741	10676220.0
2005-06-27 10:00:00	AMZN	Stock	1.741	1.7455	1.728	1.7345	12127000.0
2005-06-27 11:00:00	AMZN	Stock	1.7345	1.7425	1.729	1.7395	10411300.0
2005-06-27 12:00:00	AMZN	Stock	1.7395	1.744	1.7275	1.7295	4975600.0
2005-06-27 13:00:00	AMZN	Stock	1.7295	1.734	1.7125	1.7125	12425540.0
2005-06-27 14:00:00	AMZN	Stock	1.7125	1.7235	1.7085	1.7215	13411100.0
2005-06-27 15:00:00	AMZN	Stock	1.7205	1.738	1.7185	1.726	23679540.0
2005-06-27 16:00:00	AMZN	Stock	1.725	1.738	1.7125	1.726	527560.0
2005-06-27 17:00:00	AMZN	Stock	1.7245	1.734	1.7205	1.734	247280.0
2005-06-27 09:00:00	CL	Stock	25.345	25.345	25.2	25.255	516800.0
2005-06-27 10:00:00	CL	Stock	25.255	25.255	25.14	25.165	572400.0
2005-06-27 11:00:00	CL	Stock	25.165	25.175	25.1145	25.165	556200.0
2005-06-27 12:00:00	CL	Stock	25.165	25.18	25.095	25.125	535400.0
2005-06-27 13:00:00	CL	Stock	25.125	25.125	25.0	25.0	656600.0
2005-06-27 14:00:00	CL	Stock	25.005	25.07	24.98	25.02	667400.0
2005-06-27 15:00:00	CL	Stock	25.02	25.095	25.0	25.08	1278600.0

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

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