PREVIEW / stock_1hour / 2005-06-17

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-17.parquet
  size:    560 KB
  rows:    26,077
  symbols: 1,985

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-17 07:00:00	AAPL	Stock	1.3629	1.3629	1.3629	1.3629	28000.0
2005-06-17 08:00:00	AAPL	Stock	1.3632	1.3643	1.3571	1.3625	830200.0
2005-06-17 09:00:00	AAPL	Stock	1.3625	1.3793	1.3571	1.36	215895652.0
2005-06-17 10:00:00	AAPL	Stock	1.3604	1.3696	1.3511	1.3607	103522216.0
2005-06-17 11:00:00	AAPL	Stock	1.3611	1.3632	1.3546	1.3586	51312352.0
2005-06-17 12:00:00	AAPL	Stock	1.3589	1.3632	1.3589	1.3611	21567840.0
2005-06-17 13:00:00	AAPL	Stock	1.3607	1.3657	1.3579	1.36	22831928.0
2005-06-17 14:00:00	AAPL	Stock	1.3604	1.3618	1.355	1.3575	29575056.0
2005-06-17 15:00:00	AAPL	Stock	1.3575	1.3686	1.3554	1.3686	92145620.0
2005-06-17 16:00:00	AAPL	Stock	1.3664	1.3718	1.3625	1.3679	19062092.0
2005-06-17 17:00:00	AAPL	Stock	1.3667	1.3693	1.3664	1.3668	1799308.0
2005-06-17 18:00:00	AAPL	Stock	1.3666	1.3682	1.3666	1.3682	4085200.0
2005-06-17 08:00:00	MSFT	Stock	25.1	25.13	25.08	25.1	44685.0
2005-06-17 09:00:00	MSFT	Stock	25.12	25.29	25.04	25.11	33598904.0
2005-06-17 10:00:00	MSFT	Stock	25.1	25.12	25.02	25.06	8892463.0
2005-06-17 11:00:00	MSFT	Stock	25.27	25.27	24.99	25.01	6758870.0
2005-06-17 12:00:00	MSFT	Stock	25.01	25.02	24.92	24.961	8436372.0
2005-06-17 13:00:00	MSFT	Stock	24.96	25.15	24.95	25.03	8553185.0
2005-06-17 14:00:00	MSFT	Stock	25.03	25.08	25.0	25.04	5424589.0
2005-06-17 15:00:00	MSFT	Stock	25.04	25.12	25.03	25.05	11034849.0
2005-06-17 16:00:00	MSFT	Stock	25.04	25.08	25.02	25.03	1950916.0
2005-06-17 17:00:00	MSFT	Stock	25.041	25.15	25.03	25.04	492131.0
2005-06-17 18:00:00	MSFT	Stock	25.045	25.06	24.91	25.06	729501.0
2005-06-17 08:00:00	NVDA	Stock	0.2169	0.2282	0.2169	0.2251	132000.0
2005-06-17 09:00:00	NVDA	Stock	0.2252	0.2279	0.2246	0.2248	83249640.0
2005-06-17 10:00:00	NVDA	Stock	0.2248	0.2267	0.2241	0.2257	58447320.0
2005-06-17 11:00:00	NVDA	Stock	0.2257	0.2267	0.2252	0.2262	42984840.0
2005-06-17 12:00:00	NVDA	Stock	0.2262	0.2264	0.2237	0.2238	74692560.0
2005-06-17 13:00:00	NVDA	Stock	0.2237	0.2257	0.2237	0.2252	44834520.0
2005-06-17 14:00:00	NVDA	Stock	0.2252	0.2256	0.2239	0.2243	27402000.0
2005-06-17 15:00:00	NVDA	Stock	0.2243	0.225	0.2241	0.2245	58108560.0
2005-06-17 16:00:00	NVDA	Stock	0.2244	0.2249	0.2242	0.2247	27564960.0
2005-06-17 17:00:00	NVDA	Stock	0.2247	0.2247	0.2246	0.2247	1362840.0
2005-06-17 18:00:00	NVDA	Stock	0.2246	0.2247	0.2246	0.2247	3620280.0
2005-06-17 09:00:00	AMZN	Stock	1.7855	1.8035	1.785	1.7905	27822660.0
2005-06-17 10:00:00	AMZN	Stock	1.7905	1.792	1.778	1.7825	10669740.0
2005-06-17 11:00:00	AMZN	Stock	1.7825	1.7825	1.774	1.7775	9012540.0
2005-06-17 12:00:00	AMZN	Stock	1.7774	1.778	1.7675	1.7675	4898340.0
2005-06-17 13:00:00	AMZN	Stock	1.7675	1.7745	1.766	1.772	5851760.0
2005-06-17 14:00:00	AMZN	Stock	1.772	1.774	1.758	1.759	11507040.0
2005-06-17 15:00:00	AMZN	Stock	1.759	1.7735	1.7585	1.7645	19396000.0
2005-06-17 16:00:00	AMZN	Stock	1.765	1.775	1.7608	1.772	1219660.0
2005-06-17 17:00:00	AMZN	Stock	1.768	1.768	1.768	1.768	9620.0
2005-06-17 09:00:00	CL	Stock	24.45	24.54	24.45	24.525	2012800.0
2005-06-17 10:00:00	CL	Stock	24.54	24.585	24.525	24.555	921000.0
2005-06-17 11:00:00	CL	Stock	24.565	24.575	24.475	24.5	671200.0
2005-06-17 12:00:00	CL	Stock	24.505	24.585	24.5	24.5615	382800.0
2005-06-17 13:00:00	CL	Stock	24.57	24.695	24.56	24.675	398600.0
2005-06-17 14:00:00	CL	Stock	24.68	24.7	24.595	24.605	339600.0
2005-06-17 15:00:00	CL	Stock	24.605	24.73	24.6	24.675	890600.0

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

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