PREVIEW / stock_1hour / 2012-04-05

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-05.parquet
  size:    922 KB
  rows:    43,782
  symbols: 3,484

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
2012-04-05 04:00:00	AAPL	Stock	22.3136	22.35	22.3136	22.3214	53200.0
2012-04-05 05:00:00	AAPL	Stock	22.2996	22.3286	22.25	22.25	183120.0
2012-04-05 06:00:00	AAPL	Stock	22.2168	22.2604	22.1436	22.2286	190484.0
2012-04-05 07:00:00	AAPL	Stock	22.2464	22.3125	22.2464	22.2857	637308.0
2012-04-05 08:00:00	AAPL	Stock	22.2786	22.4186	22.2161	22.3964	8577660.0
2012-04-05 09:00:00	AAPL	Stock	22.4	22.4039	22.2643	22.2854	76326348.0
2012-04-05 10:00:00	AAPL	Stock	22.2846	22.4086	22.2796	22.4086	77106232.0
2012-04-05 11:00:00	AAPL	Stock	22.4068	22.5311	22.3936	22.5304	91124180.0
2012-04-05 12:00:00	AAPL	Stock	22.5298	22.6664	22.5143	22.5561	135133348.0
2012-04-05 13:00:00	AAPL	Stock	22.5572	22.6011	22.5111	22.5486	70424480.0
2012-04-05 14:00:00	AAPL	Stock	22.5482	22.5982	22.5289	22.5811	44607976.0
2012-04-05 15:00:00	AAPL	Stock	22.5811	22.635	22.5286	22.6311	110701668.0
2012-04-05 16:00:00	AAPL	Stock	22.6314	22.6425	22.302	22.6321	13270152.0
2012-04-05 17:00:00	AAPL	Stock	22.6314	22.6375	22.625	22.625	508844.0
2012-04-05 18:00:00	AAPL	Stock	22.6296	22.6486	22.6268	22.6411	740684.0
2012-04-05 19:00:00	AAPL	Stock	22.6393	22.655	22.6375	22.655	255472.0
2012-04-05 06:00:00	MSFT	Stock	31.27	31.27	31.1	31.1	200.0
2012-04-05 08:00:00	MSFT	Stock	31.25	31.25	31.14	31.25	13167.0
2012-04-05 09:00:00	MSFT	Stock	31.3	31.3	31.05	31.247	2353712.0
2012-04-05 10:00:00	MSFT	Stock	31.245	31.558	31.24	31.55	5898829.0
2012-04-05 11:00:00	MSFT	Stock	31.56	31.58	31.41	31.57	4785004.0
2012-04-05 12:00:00	MSFT	Stock	31.57	31.63	31.53	31.595	3096096.0
2012-04-05 13:00:00	MSFT	Stock	31.6	31.63	31.49	31.52	3083291.0
2012-04-05 14:00:00	MSFT	Stock	31.525	31.54	31.41	31.45	3551939.0
2012-04-05 15:00:00	MSFT	Stock	31.442	31.56	31.43	31.508	10177723.0
2012-04-05 16:00:00	MSFT	Stock	31.51	31.555	31.39	31.5	4244399.0
2012-04-05 17:00:00	MSFT	Stock	31.52	31.52	31.52	31.52	580.0
2012-04-05 18:00:00	MSFT	Stock	31.52	31.52	31.49	31.49	3220.0
2012-04-05 19:00:00	MSFT	Stock	31.52	31.52	31.52	31.52	2800.0
2012-04-05 08:00:00	NVDA	Stock	0.3675	0.3675	0.3675	0.3675	4000.0
2012-04-05 09:00:00	NVDA	Stock	0.3692	0.3713	0.3665	0.3688	14822960.0
2012-04-05 10:00:00	NVDA	Stock	0.3688	0.3698	0.3662	0.3682	45471800.0
2012-04-05 11:00:00	NVDA	Stock	0.3685	0.3685	0.3665	0.3678	32621600.0
2012-04-05 12:00:00	NVDA	Stock	0.3678	0.3685	0.3655	0.3655	32458080.0
2012-04-05 13:00:00	NVDA	Stock	0.3658	0.366	0.3645	0.3652	30495040.0
2012-04-05 14:00:00	NVDA	Stock	0.3652	0.3675	0.365	0.3672	33286480.0
2012-04-05 15:00:00	NVDA	Stock	0.367	0.3672	0.3652	0.366	86997760.0
2012-04-05 16:00:00	NVDA	Stock	0.3658	0.3688	0.3645	0.3688	6459640.0
2012-04-05 17:00:00	NVDA	Stock	0.3662	0.3675	0.3638	0.3638	24240.0
2012-04-05 18:00:00	NVDA	Stock	0.365	0.3662	0.365	0.3662	20000.0
2012-04-05 06:00:00	AMZN	Stock	9.629	9.629	9.629	9.629	2000.0
2012-04-05 07:00:00	AMZN	Stock	9.625	9.639	9.6245	9.6295	38120.0
2012-04-05 08:00:00	AMZN	Stock	9.6175	9.722	9.603	9.6915	287660.0
2012-04-05 09:00:00	AMZN	Stock	9.683	9.7745	9.6715	9.714	11899420.0
2012-04-05 10:00:00	AMZN	Stock	9.7145	9.76	9.6905	9.7561	10639480.0
2012-04-05 11:00:00	AMZN	Stock	9.757	9.798	9.7475	9.798	11826480.0
2012-04-05 12:00:00	AMZN	Stock	9.798	9.8015	9.7405	9.7645	5623820.0
2012-04-05 13:00:00	AMZN	Stock	9.765	9.776	9.727	9.7285	5185260.0
2012-04-05 14:00:00	AMZN	Stock	9.7355	9.754	9.7135	9.748	4526520.0
2012-04-05 15:00:00	AMZN	Stock	9.747	9.7485	9.7165	9.72	10191400.0

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

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