PREVIEW / stock_1hour / 2013-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-08.parquet
  size:    1014 KB
  rows:    46,910
  symbols: 3,514

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
2013-08-08 04:00:00	AAPL	Stock	16.5679	16.5714	16.5679	16.5714	16240.0
2013-08-08 05:00:00	AAPL	Stock	16.5775	16.6075	16.5775	16.5982	53200.0
2013-08-08 06:00:00	AAPL	Stock	16.5857	16.5893	16.5464	16.5714	74200.0
2013-08-08 07:00:00	AAPL	Stock	16.5714	16.5857	16.5214	16.5357	305984.0
2013-08-08 08:00:00	AAPL	Stock	16.5357	16.5982	16.5311	16.5636	1772344.0
2013-08-08 09:00:00	AAPL	Stock	16.5661	16.575	16.5007	16.5258	37037588.0
2013-08-08 10:00:00	AAPL	Stock	16.5295	16.5332	16.3554	16.3925	72737924.0
2013-08-08 11:00:00	AAPL	Stock	16.3939	16.4986	16.3846	16.4957	36407056.0
2013-08-08 12:00:00	AAPL	Stock	16.4943	16.5179	16.4657	16.4732	17766896.0
2013-08-08 13:00:00	AAPL	Stock	16.4736	16.5071	16.4643	16.5039	15727572.0
2013-08-08 14:00:00	AAPL	Stock	16.5039	16.5264	16.4857	16.5036	14941556.0
2013-08-08 15:00:00	AAPL	Stock	16.5036	16.5132	16.4632	16.4646	30640456.0
2013-08-08 16:00:00	AAPL	Stock	16.4643	16.4714	16.4382	16.4429	25236092.0
2013-08-08 17:00:00	AAPL	Stock	16.44	16.4464	16.4357	16.4457	80472.0
2013-08-08 18:00:00	AAPL	Stock	16.4404	16.4568	16.4404	16.4464	74620.0
2013-08-08 19:00:00	AAPL	Stock	16.4429	16.4482	16.4346	16.4346	137368.0
2013-08-08 04:00:00	MSFT	Stock	32.21	32.32	32.2	32.32	1700.0
2013-08-08 05:00:00	MSFT	Stock	32.32	32.32	32.32	32.32	170.0
2013-08-08 06:00:00	MSFT	Stock	32.15	32.3	32.15	32.29	9199.0
2013-08-08 07:00:00	MSFT	Stock	32.29	32.29	32.25	32.26	43533.0
2013-08-08 08:00:00	MSFT	Stock	32.26	32.29	32.14	32.19	76425.0
2013-08-08 09:00:00	MSFT	Stock	32.19	32.32	32.11	32.19	4921458.0
2013-08-08 10:00:00	MSFT	Stock	32.18	32.895	32.05	32.87	18228049.0
2013-08-08 11:00:00	MSFT	Stock	32.87	33.03	32.67	32.755	11772651.0
2013-08-08 12:00:00	MSFT	Stock	32.75	33.07	32.75	32.99	6138941.0
2013-08-08 13:00:00	MSFT	Stock	32.99	33.05	32.92	32.96	3731717.0
2013-08-08 14:00:00	MSFT	Stock	32.965	32.98	32.79	32.79	3606740.0
2013-08-08 15:00:00	MSFT	Stock	32.79	32.95	32.78	32.9	8266105.0
2013-08-08 16:00:00	MSFT	Stock	32.89	32.91	31.997	32.89	1948933.0
2013-08-08 17:00:00	MSFT	Stock	32.97	33.01	32.658	32.84	55414.0
2013-08-08 18:00:00	MSFT	Stock	32.84	32.85	32.81	32.85	1775.0
2013-08-08 19:00:00	MSFT	Stock	32.85	32.85	32.81	32.85	1028.0
2013-08-08 08:00:00	NVDA	Stock	0.367	0.3675	0.367	0.3672	80000.0
2013-08-08 09:00:00	NVDA	Stock	0.3662	0.367	0.3628	0.3645	32443040.0
2013-08-08 10:00:00	NVDA	Stock	0.3642	0.367	0.363	0.367	48499840.0
2013-08-08 11:00:00	NVDA	Stock	0.367	0.3688	0.3665	0.3676	41926640.0
2013-08-08 12:00:00	NVDA	Stock	0.3678	0.3678	0.3658	0.3668	30507520.0
2013-08-08 13:00:00	NVDA	Stock	0.3668	0.3688	0.3665	0.3688	58546880.0
2013-08-08 14:00:00	NVDA	Stock	0.3686	0.3691	0.366	0.3668	32362520.0
2013-08-08 15:00:00	NVDA	Stock	0.3668	0.3678	0.3658	0.3675	70586040.0
2013-08-08 16:00:00	NVDA	Stock	0.3675	0.3842	0.36	0.3645	21165000.0
2013-08-08 17:00:00	NVDA	Stock	0.364	0.3688	0.3575	0.3575	3919400.0
2013-08-08 18:00:00	NVDA	Stock	0.3585	0.362	0.358	0.3618	200000.0
2013-08-08 19:00:00	NVDA	Stock	0.3618	0.3618	0.3575	0.3605	549200.0
2013-08-08 06:00:00	AMZN	Stock	14.8875	14.8875	14.8875	14.8875	2000.0
2013-08-08 07:00:00	AMZN	Stock	14.937	14.9425	14.937	14.9425	11500.0
2013-08-08 08:00:00	AMZN	Stock	14.9	14.925	14.8455	14.9005	121640.0
2013-08-08 09:00:00	AMZN	Stock	14.9195	14.926	14.7415	14.8015	9916700.0
2013-08-08 10:00:00	AMZN	Stock	14.801	14.8035	14.6275	14.6845	8900380.0
2013-08-08 11:00:00	AMZN	Stock	14.689	14.8048	14.6865	14.792	7438980.0

> showing 50 of 46,910 rows — these rows as CSV

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