PREVIEW / stock_1hour / 2006-04-26

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-26.parquet
  size:    602 KB
  rows:    28,344
  symbols: 2,244

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
2006-04-26 08:00:00	AAPL	Stock	2.3696	2.3746	2.3679	2.37	752612.0
2006-04-26 09:00:00	AAPL	Stock	2.3696	2.3957	2.3693	2.3857	82438020.0
2006-04-26 10:00:00	AAPL	Stock	2.3857	2.4211	2.3807	2.4186	152667508.0
2006-04-26 11:00:00	AAPL	Stock	2.4179	2.4329	2.4054	2.4187	114350544.0
2006-04-26 12:00:00	AAPL	Stock	2.4189	2.4211	2.4011	2.4189	79395596.0
2006-04-26 13:00:00	AAPL	Stock	2.4189	2.4307	2.4179	2.4289	58389296.0
2006-04-26 14:00:00	AAPL	Stock	2.4289	2.4321	2.4182	2.4289	65691332.0
2006-04-26 15:00:00	AAPL	Stock	2.4286	2.4386	2.4211	2.4336	125985300.0
2006-04-26 16:00:00	AAPL	Stock	2.4321	2.4361	2.4321	2.4357	9888872.0
2006-04-26 17:00:00	AAPL	Stock	2.4354	2.4364	2.4339	2.4343	372680.0
2006-04-26 18:00:00	AAPL	Stock	2.435	2.4371	2.435	2.4371	100240.0
2006-04-26 07:00:00	MSFT	Stock	27.11	27.11	27.11	27.11	1000.0
2006-04-26 08:00:00	MSFT	Stock	27.12	27.18	27.12	27.13	8497.0
2006-04-26 09:00:00	MSFT	Stock	27.14	27.23	27.06	27.19	4191230.0
2006-04-26 10:00:00	MSFT	Stock	27.19	27.22	27.1	27.14	5946936.0
2006-04-26 11:00:00	MSFT	Stock	27.14	27.15	27.0	27.11	3400381.0
2006-04-26 12:00:00	MSFT	Stock	27.11	27.14	27.09	27.1	3159417.0
2006-04-26 13:00:00	MSFT	Stock	27.1	27.16	27.1	27.12	3478769.0
2006-04-26 14:00:00	MSFT	Stock	27.12	27.13	27.06	27.08	4557079.0
2006-04-26 15:00:00	MSFT	Stock	27.08	27.1	27.0	27.1	12139757.0
2006-04-26 16:00:00	MSFT	Stock	27.09	27.11	27.07	27.09	181446.0
2006-04-26 17:00:00	MSFT	Stock	27.09	27.1	27.09	27.1	24850.0
2006-04-26 18:00:00	MSFT	Stock	27.1	27.1	27.09	27.1	3997.0
2006-04-26 08:00:00	NVDA	Stock	0.4817	0.4817	0.4817	0.4817	30000.0
2006-04-26 09:00:00	NVDA	Stock	0.4793	0.491	0.4793	0.4837	51847380.0
2006-04-26 10:00:00	NVDA	Stock	0.4837	0.4883	0.4807	0.4847	61105260.0
2006-04-26 11:00:00	NVDA	Stock	0.4847	0.4858	0.4753	0.4763	55068000.0
2006-04-26 12:00:00	NVDA	Stock	0.4762	0.4818	0.4752	0.48	29649660.0
2006-04-26 13:00:00	NVDA	Stock	0.48	0.4835	0.4792	0.482	17960760.0
2006-04-26 14:00:00	NVDA	Stock	0.4822	0.4825	0.4755	0.4793	34479480.0
2006-04-26 15:00:00	NVDA	Stock	0.4794	0.4797	0.4733	0.4783	61629960.0
2006-04-26 16:00:00	NVDA	Stock	0.4785	0.4873	0.4778	0.4782	861540.0
2006-04-26 07:00:00	AMZN	Stock	1.782	1.805	1.782	1.803	145400.0
2006-04-26 08:00:00	AMZN	Stock	1.8055	1.8055	1.776	1.791	3349680.0
2006-04-26 09:00:00	AMZN	Stock	1.79	1.8175	1.7575	1.785	73750440.0
2006-04-26 10:00:00	AMZN	Stock	1.786	1.7905	1.767	1.779	56030000.0
2006-04-26 11:00:00	AMZN	Stock	1.7785	1.788	1.776	1.7855	21409200.0
2006-04-26 12:00:00	AMZN	Stock	1.785	1.7915	1.783	1.7905	16287540.0
2006-04-26 13:00:00	AMZN	Stock	1.79	1.793	1.787	1.79	12320580.0
2006-04-26 14:00:00	AMZN	Stock	1.79	1.794	1.789	1.7895	11649220.0
2006-04-26 15:00:00	AMZN	Stock	1.7895	1.792	1.789	1.79	23859360.0
2006-04-26 16:00:00	AMZN	Stock	1.7905	1.791	1.7853	1.7853	153000.0
2006-04-26 17:00:00	AMZN	Stock	1.783	1.783	1.783	1.783	2000.0
2006-04-26 18:00:00	AMZN	Stock	1.783	1.783	1.783	1.783	10000.0
2006-04-26 08:00:00	CL	Stock	29.5	29.5	28.675	29.325	274200.0
2006-04-26 09:00:00	CL	Stock	29.125	29.23	29.0	29.16	978600.0
2006-04-26 10:00:00	CL	Stock	29.165	29.37	29.02	29.22	1496600.0
2006-04-26 11:00:00	CL	Stock	29.22	29.245	29.085	29.085	772000.0
2006-04-26 12:00:00	CL	Stock	29.085	29.2	29.01	29.2	447400.0
2006-04-26 13:00:00	CL	Stock	29.195	29.25	29.13	29.185	928000.0

> showing 50 of 28,344 rows — these rows as CSV

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