PREVIEW / stock_1hour / 2010-01-21

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-21.parquet
  size:    920 KB
  rows:    43,319
  symbols: 3,437

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
2010-01-21 04:00:00	AAPL	Stock	7.5714	7.5714	7.5714	7.5714	2800.0
2010-01-21 05:00:00	AAPL	Stock	7.5618	7.5618	7.5618	7.5618	5600.0
2010-01-21 06:00:00	AAPL	Stock	7.5679	7.5679	7.5679	7.5679	5600.0
2010-01-21 07:00:00	AAPL	Stock	7.5918	7.6036	7.5821	7.5918	241220.0
2010-01-21 08:00:00	AAPL	Stock	7.6032	7.6032	7.5404	7.5536	6738004.0
2010-01-21 09:00:00	AAPL	Stock	7.5529	7.6184	7.5082	7.5468	79151352.0
2010-01-21 10:00:00	AAPL	Stock	7.5471	7.5725	7.4357	7.4557	120687140.0
2010-01-21 11:00:00	AAPL	Stock	7.4561	7.4657	7.4011	7.4411	83138132.0
2010-01-21 12:00:00	AAPL	Stock	7.4418	7.4561	7.4093	7.4141	55812372.0
2010-01-21 13:00:00	AAPL	Stock	7.415	7.4554	7.4004	7.4536	50908032.0
2010-01-21 14:00:00	AAPL	Stock	7.4532	7.4929	7.4364	7.4509	65403800.0
2010-01-21 15:00:00	AAPL	Stock	7.4511	7.4646	7.4107	7.4371	128878792.0
2010-01-21 16:00:00	AAPL	Stock	7.4382	7.4682	7.375	7.3889	11603200.0
2010-01-21 17:00:00	AAPL	Stock	7.3929	7.4064	7.3857	7.4	507500.0
2010-01-21 18:00:00	AAPL	Stock	7.4043	7.4311	7.3893	7.4071	398272.0
2010-01-21 19:00:00	AAPL	Stock	7.4096	7.4107	7.3946	7.4018	334460.0
2010-01-21 20:00:00	AAPL	Stock	7.5971	7.5971	7.5971	7.5971	262472.0
2010-01-21 05:00:00	MSFT	Stock	30.35	30.35	30.32	30.32	1000.0
2010-01-21 07:00:00	MSFT	Stock	30.51	30.62	30.51	30.62	5744.0
2010-01-21 08:00:00	MSFT	Stock	30.6	30.6	30.46	30.58	17516.0
2010-01-21 09:00:00	MSFT	Stock	30.58	30.72	30.52	30.56	5705162.0
2010-01-21 10:00:00	MSFT	Stock	30.56	30.71	30.12	30.162	11514455.0
2010-01-21 11:00:00	MSFT	Stock	30.17	30.24	30.0	30.08	11273884.0
2010-01-21 12:00:00	MSFT	Stock	30.08	30.24	30.0	30.05	6821213.0
2010-01-21 13:00:00	MSFT	Stock	30.05	30.292	30.04	30.17	7822179.0
2010-01-21 14:00:00	MSFT	Stock	30.16	30.21	30.06	30.14	8024611.0
2010-01-21 15:00:00	MSFT	Stock	30.14	30.16	30.0	30.06	14650164.0
2010-01-21 16:00:00	MSFT	Stock	30.06	30.35	29.92	30.03	6071903.0
2010-01-21 17:00:00	MSFT	Stock	30.03	30.09	30.03	30.06	72244.0
2010-01-21 18:00:00	MSFT	Stock	30.01	30.05	30.01	30.05	6943.0
2010-01-21 19:00:00	MSFT	Stock	30.06	30.06	29.96	29.96	37662.0
2010-01-21 20:00:00	MSFT	Stock	30.6	30.6	30.6	30.6	526.0
2010-01-21 09:00:00	NVDA	Stock	0.435	0.4415	0.4325	0.4372	65202760.0
2010-01-21 10:00:00	NVDA	Stock	0.4372	0.44	0.4262	0.4275	147127720.0
2010-01-21 11:00:00	NVDA	Stock	0.4278	0.43	0.425	0.4272	125148040.0
2010-01-21 12:00:00	NVDA	Stock	0.4272	0.4278	0.4222	0.4232	64589800.0
2010-01-21 13:00:00	NVDA	Stock	0.4235	0.4282	0.4225	0.427	52925280.0
2010-01-21 14:00:00	NVDA	Stock	0.4269	0.4298	0.4255	0.428	37528120.0
2010-01-21 15:00:00	NVDA	Stock	0.4282	0.4285	0.4253	0.426	88202200.0
2010-01-21 16:00:00	NVDA	Stock	0.4262	0.4289	0.4232	0.4238	26409440.0
2010-01-21 17:00:00	NVDA	Stock	0.4228	0.4238	0.4228	0.4238	32000.0
2010-01-21 06:00:00	AMZN	Stock	6.3345	6.3345	6.3345	6.3345	6000.0
2010-01-21 07:00:00	AMZN	Stock	6.3495	6.35	6.3495	6.35	90000.0
2010-01-21 08:00:00	AMZN	Stock	6.371	6.371	6.3275	6.3475	340700.0
2010-01-21 09:00:00	AMZN	Stock	6.3425	6.4075	6.3145	6.376	30353300.0
2010-01-21 10:00:00	AMZN	Stock	6.3765	6.403	6.2655	6.305	34925060.0
2010-01-21 11:00:00	AMZN	Stock	6.3055	6.3298	6.25	6.2775	32967620.0
2010-01-21 12:00:00	AMZN	Stock	6.277	6.3245	6.2692	6.2775	21237600.0
2010-01-21 13:00:00	AMZN	Stock	6.278	6.358	6.263	6.35	21069220.0
2010-01-21 14:00:00	AMZN	Stock	6.3495	6.371	6.3272	6.35	15389800.0

> showing 50 of 43,319 rows — these rows as CSV

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