PREVIEW / stock_1hour / 2011-03-31

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-31.parquet
  size:    956 KB
  rows:    44,601
  symbols: 3,535

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
2011-03-31 04:00:00	AAPL	Stock	12.4643	12.4643	12.4639	12.4639	8400.0
2011-03-31 05:00:00	AAPL	Stock	12.4643	12.4643	12.4429	12.4639	16800.0
2011-03-31 06:00:00	AAPL	Stock	12.4393	12.4393	12.4314	12.4314	5600.0
2011-03-31 07:00:00	AAPL	Stock	12.4143	12.4279	12.4032	12.4132	171444.0
2011-03-31 08:00:00	AAPL	Stock	12.4107	12.4107	12.3632	12.3836	1743924.0
2011-03-31 09:00:00	AAPL	Stock	12.3821	12.4929	12.3593	12.4532	53096960.0
2011-03-31 10:00:00	AAPL	Stock	12.4532	12.4775	12.4136	12.4689	43386812.0
2011-03-31 11:00:00	AAPL	Stock	12.4689	12.4721	12.4007	12.4221	29858724.0
2011-03-31 12:00:00	AAPL	Stock	12.4211	12.4671	12.4186	12.4561	25206244.0
2011-03-31 13:00:00	AAPL	Stock	12.4568	12.4696	12.4432	12.4432	13250552.0
2011-03-31 14:00:00	AAPL	Stock	12.4432	12.4671	12.4182	12.4375	23999276.0
2011-03-31 15:00:00	AAPL	Stock	12.4375	12.4643	12.4139	12.4491	53540648.0
2011-03-31 16:00:00	AAPL	Stock	12.4494	12.4614	12.4375	12.4589	24362632.0
2011-03-31 17:00:00	AAPL	Stock	12.4589	12.4621	12.4429	12.4443	331380.0
2011-03-31 18:00:00	AAPL	Stock	12.4436	12.4536	12.4436	12.45	24220.0
2011-03-31 19:00:00	AAPL	Stock	12.4482	12.4768	12.4468	12.4571	346444.0
2011-03-31 06:00:00	MSFT	Stock	25.7	25.7	25.7	25.7	800.0
2011-03-31 08:00:00	MSFT	Stock	25.68	25.68	25.65	25.65	8110.0
2011-03-31 09:00:00	MSFT	Stock	25.64	25.68	25.51	25.55	2982216.0
2011-03-31 10:00:00	MSFT	Stock	25.54	25.63	25.54	25.558	4509362.0
2011-03-31 11:00:00	MSFT	Stock	25.56	25.62	25.5	25.5	6704661.0
2011-03-31 12:00:00	MSFT	Stock	25.508	25.51	25.465	25.49	4709154.0
2011-03-31 13:00:00	MSFT	Stock	25.485	25.51	25.4	25.42	8183525.0
2011-03-31 14:00:00	MSFT	Stock	25.415	25.5	25.36	25.49	12254512.0
2011-03-31 15:00:00	MSFT	Stock	25.49	25.55	25.35	25.35	16805834.0
2011-03-31 16:00:00	MSFT	Stock	25.35	25.537	25.34	25.4	6583699.0
2011-03-31 17:00:00	MSFT	Stock	25.4	25.42	25.38	25.41	3637.0
2011-03-31 18:00:00	MSFT	Stock	25.39	25.42	25.39	25.39	11880.0
2011-03-31 19:00:00	MSFT	Stock	25.39	25.41	25.39	25.39	41996.0
2011-03-31 08:00:00	NVDA	Stock	0.462	0.4622	0.4578	0.4588	720000.0
2011-03-31 09:00:00	NVDA	Stock	0.4598	0.465	0.4565	0.4635	95196200.0
2011-03-31 10:00:00	NVDA	Stock	0.4635	0.467	0.453	0.4668	181818000.0
2011-03-31 11:00:00	NVDA	Stock	0.4668	0.4668	0.4588	0.4593	92657400.0
2011-03-31 12:00:00	NVDA	Stock	0.4593	0.4618	0.459	0.46	49528480.0
2011-03-31 13:00:00	NVDA	Stock	0.46	0.4615	0.4598	0.4605	37328960.0
2011-03-31 14:00:00	NVDA	Stock	0.4605	0.463	0.4603	0.4625	47797360.0
2011-03-31 15:00:00	NVDA	Stock	0.4628	0.463	0.46	0.4612	108117360.0
2011-03-31 16:00:00	NVDA	Stock	0.4615	0.463	0.4606	0.463	31188640.0
2011-03-31 17:00:00	NVDA	Stock	0.4625	0.4628	0.4622	0.4628	48800.0
2011-03-31 18:00:00	NVDA	Stock	0.4612	0.4612	0.4612	0.4612	11480.0
2011-03-31 19:00:00	NVDA	Stock	0.4612	0.4612	0.46	0.4603	223480.0
2011-03-31 06:00:00	AMZN	Stock	9.001	9.001	9.001	9.001	2000.0
2011-03-31 07:00:00	AMZN	Stock	9.006	9.006	8.975	8.975	24000.0
2011-03-31 08:00:00	AMZN	Stock	8.9895	9.013	8.9675	8.975	198460.0
2011-03-31 09:00:00	AMZN	Stock	8.986	9.0255	8.925	8.998	13786200.0
2011-03-31 10:00:00	AMZN	Stock	8.994	9.0785	8.96	9.05	18459660.0
2011-03-31 11:00:00	AMZN	Stock	9.05	9.057	8.9655	8.9705	9001600.0
2011-03-31 12:00:00	AMZN	Stock	8.9724	9.0395	8.9415	9.034	16323880.0
2011-03-31 13:00:00	AMZN	Stock	9.033	9.059	9.03	9.0375	9791620.0
2011-03-31 14:00:00	AMZN	Stock	9.037	9.0418	9.015	9.0263	6627980.0

> showing 50 of 44,601 rows — these rows as CSV

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