PREVIEW / stock_1hour / 2007-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-24.parquet
  size:    686 KB
  rows:    32,320
  symbols: 2,598

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
2007-04-24 07:00:00	AAPL	Stock	3.3482	3.3607	3.3411	3.3564	592424.0
2007-04-24 08:00:00	AAPL	Stock	3.3539	3.3632	3.3536	3.3554	3406872.0
2007-04-24 09:00:00	AAPL	Stock	3.3554	3.3607	3.2607	3.3479	110681032.0
2007-04-24 10:00:00	AAPL	Stock	3.3475	3.3579	3.3121	3.3246	101080028.0
2007-04-24 11:00:00	AAPL	Stock	3.3246	3.3325	3.3143	3.3264	59698212.0
2007-04-24 12:00:00	AAPL	Stock	3.3264	3.3604	3.3225	3.3479	101395980.0
2007-04-24 13:00:00	AAPL	Stock	3.3482	3.4425	3.2714	3.3668	379195348.0
2007-04-24 14:00:00	AAPL	Stock	3.3671	3.3779	3.3554	3.3607	143700172.0
2007-04-24 15:00:00	AAPL	Stock	3.3607	3.3629	3.3218	3.33	136286136.0
2007-04-24 16:00:00	AAPL	Stock	3.3296	3.3393	3.3289	3.3389	12408424.0
2007-04-24 17:00:00	AAPL	Stock	3.3382	3.3464	3.335	3.3375	618996.0
2007-04-24 18:00:00	AAPL	Stock	3.3375	3.3418	3.3375	3.3375	260596.0
2007-04-24 19:00:00	AAPL	Stock	3.3379	3.3525	3.3379	3.3518	753564.0
2007-04-24 06:00:00	MSFT	Stock	28.78	28.78	28.78	28.78	200.0
2007-04-24 07:00:00	MSFT	Stock	28.78	28.78	28.78	28.78	800.0
2007-04-24 08:00:00	MSFT	Stock	28.79	28.79	28.75	28.79	15267.0
2007-04-24 09:00:00	MSFT	Stock	28.79	28.89	28.73	28.79	4122075.0
2007-04-24 10:00:00	MSFT	Stock	28.79	28.79	28.59	28.68	5381523.0
2007-04-24 11:00:00	MSFT	Stock	28.672	28.79	28.63	28.76	3486153.0
2007-04-24 12:00:00	MSFT	Stock	28.76	28.96	28.76	28.9	3832400.0
2007-04-24 13:00:00	MSFT	Stock	28.9	28.92	28.84	28.87	3564987.0
2007-04-24 14:00:00	MSFT	Stock	28.86	28.92	28.83	28.84	3943926.0
2007-04-24 15:00:00	MSFT	Stock	28.84	28.9	28.77	28.79	5097741.0
2007-04-24 16:00:00	MSFT	Stock	28.79	28.84	28.79	28.79	3235205.0
2007-04-24 17:00:00	MSFT	Stock	28.76	28.81	28.76	28.81	2181.0
2007-04-24 19:00:00	MSFT	Stock	28.77	28.77	28.77	28.77	800.0
2007-04-24 07:00:00	NVDA	Stock	0.5333	0.5333	0.5333	0.5333	300000.0
2007-04-24 08:00:00	NVDA	Stock	0.5333	0.5333	0.5283	0.5283	468000.0
2007-04-24 09:00:00	NVDA	Stock	0.5288	0.5322	0.5282	0.531	62195460.0
2007-04-24 10:00:00	NVDA	Stock	0.5308	0.5358	0.5295	0.5333	153599700.0
2007-04-24 11:00:00	NVDA	Stock	0.5335	0.535	0.5323	0.5333	173346960.0
2007-04-24 12:00:00	NVDA	Stock	0.5333	0.5417	0.5332	0.5412	172010460.0
2007-04-24 13:00:00	NVDA	Stock	0.5413	0.5442	0.539	0.5435	113194680.0
2007-04-24 14:00:00	NVDA	Stock	0.5435	0.5473	0.5425	0.5447	148192320.0
2007-04-24 15:00:00	NVDA	Stock	0.5447	0.5465	0.5408	0.5428	183273720.0
2007-04-24 16:00:00	NVDA	Stock	0.5433	0.5442	0.5403	0.5403	4041720.0
2007-04-24 17:00:00	NVDA	Stock	0.5425	0.5427	0.5408	0.5408	606000.0
2007-04-24 18:00:00	NVDA	Stock	0.5408	0.5422	0.5408	0.5422	126000.0
2007-04-24 08:00:00	AMZN	Stock	2.232	2.237	2.232	2.232	34000.0
2007-04-24 09:00:00	AMZN	Stock	2.239	2.25	2.2215	2.235	13007580.0
2007-04-24 10:00:00	AMZN	Stock	2.2345	2.238	2.2225	2.226	19632780.0
2007-04-24 11:00:00	AMZN	Stock	2.226	2.2375	2.2245	2.2305	20702480.0
2007-04-24 12:00:00	AMZN	Stock	2.2305	2.2485	2.2295	2.233	22946840.0
2007-04-24 13:00:00	AMZN	Stock	2.2335	2.237	2.2246	2.236	15055020.0
2007-04-24 14:00:00	AMZN	Stock	2.236	2.243	2.228	2.2345	19043940.0
2007-04-24 15:00:00	AMZN	Stock	2.2345	2.242	2.2314	2.2375	46283660.0
2007-04-24 16:00:00	AMZN	Stock	2.239	2.4875	2.226	2.4375	206614480.0
2007-04-24 17:00:00	AMZN	Stock	2.437	2.5075	2.4335	2.5	46513360.0
2007-04-24 18:00:00	AMZN	Stock	2.501	2.5145	2.495	2.5145	10458500.0
2007-04-24 19:00:00	AMZN	Stock	2.515	2.5165	2.5025	2.515	7104300.0

> showing 50 of 32,320 rows — these rows as CSV

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