PREVIEW / stock_1hour / 2005-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-13.parquet
  size:    540 KB
  rows:    25,632
  symbols: 2,030

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-07-13 07:00:00	AAPL	Stock	1.375	1.375	1.3643	1.3646	393400.0
2005-07-13 08:00:00	AAPL	Stock	1.3611	1.3732	1.3607	1.3668	812784.0
2005-07-13 09:00:00	AAPL	Stock	1.3671	1.3729	1.3518	1.3682	75692428.0
2005-07-13 10:00:00	AAPL	Stock	1.3686	1.3707	1.3536	1.3582	121496396.0
2005-07-13 11:00:00	AAPL	Stock	1.3586	1.3671	1.3582	1.36	67266388.0
2005-07-13 12:00:00	AAPL	Stock	1.36	1.365	1.3579	1.3636	47294716.0
2005-07-13 13:00:00	AAPL	Stock	1.3636	1.3643	1.36	1.3639	38492104.0
2005-07-13 14:00:00	AAPL	Stock	1.3639	1.3693	1.3611	1.3685	63292488.0
2005-07-13 15:00:00	AAPL	Stock	1.3686	1.375	1.3664	1.3718	150089800.0
2005-07-13 16:00:00	AAPL	Stock	1.37	1.4036	1.3504	1.3982	136845520.0
2005-07-13 17:00:00	AAPL	Stock	1.3979	1.4143	1.3896	1.4107	71291024.0
2005-07-13 18:00:00	AAPL	Stock	1.4107	1.4196	1.4082	1.4182	8653428.0
2005-07-13 08:00:00	MSFT	Stock	25.63	25.63	25.57	25.62	19128.0
2005-07-13 09:00:00	MSFT	Stock	25.61	25.7	25.48	25.62	5798410.0
2005-07-13 10:00:00	MSFT	Stock	25.62	25.67	25.53	25.58	7139081.0
2005-07-13 11:00:00	MSFT	Stock	25.58	25.69	25.57	25.66	5595478.0
2005-07-13 12:00:00	MSFT	Stock	25.66	25.69	25.51	25.528	7359128.0
2005-07-13 13:00:00	MSFT	Stock	25.522	25.595	25.509	25.54	2997900.0
2005-07-13 14:00:00	MSFT	Stock	25.54	25.62	25.53	25.61	4785584.0
2005-07-13 15:00:00	MSFT	Stock	25.6	25.75	25.59	25.65	9961773.0
2005-07-13 16:00:00	MSFT	Stock	25.67	25.68	25.26	25.68	374821.0
2005-07-13 17:00:00	MSFT	Stock	25.66	25.69	25.66	25.66	177946.0
2005-07-13 18:00:00	MSFT	Stock	25.69	25.69	25.65	25.65	5170.0
2005-07-13 08:00:00	NVDA	Stock	0.2304	0.2396	0.2304	0.2395	312000.0
2005-07-13 09:00:00	NVDA	Stock	0.2387	0.2387	0.2357	0.236	78292200.0
2005-07-13 10:00:00	NVDA	Stock	0.236	0.2365	0.2337	0.234	140894400.0
2005-07-13 11:00:00	NVDA	Stock	0.2341	0.2358	0.233	0.2356	91588080.0
2005-07-13 12:00:00	NVDA	Stock	0.2356	0.2368	0.2356	0.2367	61590120.0
2005-07-13 13:00:00	NVDA	Stock	0.2365	0.2375	0.2362	0.2371	31299360.0
2005-07-13 14:00:00	NVDA	Stock	0.2371	0.2374	0.2366	0.2373	56359080.0
2005-07-13 15:00:00	NVDA	Stock	0.2372	0.238	0.2366	0.2369	99186960.0
2005-07-13 16:00:00	NVDA	Stock	0.237	0.2376	0.2367	0.237	1806960.0
2005-07-13 17:00:00	NVDA	Stock	0.2367	0.2376	0.2367	0.2371	828000.0
2005-07-13 18:00:00	NVDA	Stock	0.2362	0.2372	0.2362	0.2372	177000.0
2005-07-13 08:00:00	AMZN	Stock	1.82	1.82	1.8135	1.8135	4000.0
2005-07-13 09:00:00	AMZN	Stock	1.815	1.8196	1.8095	1.813	7997580.0
2005-07-13 10:00:00	AMZN	Stock	1.813	1.8175	1.811	1.815	14976960.0
2005-07-13 11:00:00	AMZN	Stock	1.815	1.8245	1.815	1.8235	8120960.0
2005-07-13 12:00:00	AMZN	Stock	1.824	1.8245	1.82	1.8236	4357800.0
2005-07-13 13:00:00	AMZN	Stock	1.8235	1.827	1.823	1.825	7397480.0
2005-07-13 14:00:00	AMZN	Stock	1.8245	1.8275	1.8235	1.825	6644380.0
2005-07-13 15:00:00	AMZN	Stock	1.825	1.8275	1.8225	1.825	13106440.0
2005-07-13 16:00:00	AMZN	Stock	1.8255	1.8275	1.8127	1.826	451760.0
2005-07-13 17:00:00	AMZN	Stock	1.8275	1.8275	1.8255	1.8255	38280.0
2005-07-13 09:00:00	CL	Stock	25.465	25.625	25.45	25.575	348400.0
2005-07-13 10:00:00	CL	Stock	25.585	25.735	25.575	25.67	945800.0
2005-07-13 11:00:00	CL	Stock	25.675	25.685	25.63	25.64	574400.0
2005-07-13 12:00:00	CL	Stock	25.64	25.65	25.61	25.615	340200.0
2005-07-13 13:00:00	CL	Stock	25.625	25.65	25.625	25.645	192000.0
2005-07-13 14:00:00	CL	Stock	25.635	25.7	25.635	25.655	310800.0

> showing 50 of 25,632 rows — these rows as CSV

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