PREVIEW / stock_1hour / 2011-06-02

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-02.parquet
  size:    931 KB
  rows:    44,047
  symbols: 3,547

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-06-02 04:00:00	AAPL	Stock	12.3718	12.3929	12.3718	12.3929	42000.0
2011-06-02 05:00:00	AAPL	Stock	12.3729	12.3957	12.3718	12.3857	25200.0
2011-06-02 06:00:00	AAPL	Stock	12.4107	12.4107	12.3875	12.3929	28000.0
2011-06-02 07:00:00	AAPL	Stock	12.3757	12.3821	12.3589	12.3714	221200.0
2011-06-02 08:00:00	AAPL	Stock	12.375	12.4129	12.3614	12.4004	2439080.0
2011-06-02 09:00:00	AAPL	Stock	12.4018	12.4125	12.3339	12.3821	60267900.0
2011-06-02 10:00:00	AAPL	Stock	12.3836	12.4279	12.3589	12.3886	65993312.0
2011-06-02 11:00:00	AAPL	Stock	12.3886	12.3986	12.2964	12.3464	55407184.0
2011-06-02 12:00:00	AAPL	Stock	12.3468	12.3636	12.3311	12.3507	27250888.0
2011-06-02 13:00:00	AAPL	Stock	12.3504	12.4004	12.3475	12.3961	35418264.0
2011-06-02 14:00:00	AAPL	Stock	12.3939	12.4096	12.3561	12.3911	36403612.0
2011-06-02 15:00:00	AAPL	Stock	12.3918	12.3986	12.3436	12.355	42991928.0
2011-06-02 16:00:00	AAPL	Stock	12.3568	12.3815	12.3393	12.3679	9390164.0
2011-06-02 17:00:00	AAPL	Stock	12.3721	12.3739	12.3668	12.3714	228200.0
2011-06-02 18:00:00	AAPL	Stock	12.3732	12.3739	12.3607	12.3739	92400.0
2011-06-02 19:00:00	AAPL	Stock	12.3746	12.3746	12.3654	12.3661	67060.0
2011-06-02 06:00:00	MSFT	Stock	24.54	24.54	24.54	24.54	200.0
2011-06-02 07:00:00	MSFT	Stock	24.54	24.55	24.51	24.51	4022.0
2011-06-02 08:00:00	MSFT	Stock	24.54	24.55	24.46	24.54	64090.0
2011-06-02 09:00:00	MSFT	Stock	24.53	24.65	24.39	24.46	5312573.0
2011-06-02 10:00:00	MSFT	Stock	24.46	24.53	24.42	24.433	6158640.0
2011-06-02 11:00:00	MSFT	Stock	24.43	24.435	24.24	24.305	6919593.0
2011-06-02 12:00:00	MSFT	Stock	24.306	24.32	24.24	24.25	5111252.0
2011-06-02 13:00:00	MSFT	Stock	24.25	24.28	24.19	24.21	6867419.0
2011-06-02 14:00:00	MSFT	Stock	24.21	24.28	24.19	24.215	7800772.0
2011-06-02 15:00:00	MSFT	Stock	24.22	24.25	24.19	24.22	11249805.0
2011-06-02 16:00:00	MSFT	Stock	24.22	24.43	24.21	24.23	1278719.0
2011-06-02 17:00:00	MSFT	Stock	24.24	24.24	24.22	24.22	2615.0
2011-06-02 18:00:00	MSFT	Stock	24.21	24.22	24.21	24.22	52573.0
2011-06-02 19:00:00	MSFT	Stock	24.22	24.22	24.07	24.19	15358.0
2011-06-02 07:00:00	NVDA	Stock	0.479	0.479	0.479	0.479	4000.0
2011-06-02 08:00:00	NVDA	Stock	0.4795	0.4815	0.4795	0.4815	392640.0
2011-06-02 09:00:00	NVDA	Stock	0.4812	0.484	0.4723	0.4782	96031520.0
2011-06-02 10:00:00	NVDA	Stock	0.4785	0.4828	0.4778	0.478	135517320.0
2011-06-02 11:00:00	NVDA	Stock	0.478	0.4793	0.4713	0.475	84883880.0
2011-06-02 12:00:00	NVDA	Stock	0.475	0.475	0.4705	0.4745	55451600.0
2011-06-02 13:00:00	NVDA	Stock	0.4745	0.4768	0.4723	0.476	54349080.0
2011-06-02 14:00:00	NVDA	Stock	0.476	0.4782	0.4742	0.476	75062920.0
2011-06-02 15:00:00	NVDA	Stock	0.476	0.4778	0.4748	0.476	92449000.0
2011-06-02 16:00:00	NVDA	Stock	0.476	0.477	0.474	0.475	10342040.0
2011-06-02 17:00:00	NVDA	Stock	0.475	0.475	0.475	0.475	90800.0
2011-06-02 18:00:00	NVDA	Stock	0.475	0.475	0.475	0.475	320000.0
2011-06-02 19:00:00	NVDA	Stock	0.474	0.474	0.4738	0.4738	20000.0
2011-06-02 08:00:00	AMZN	Stock	9.695	9.695	9.6375	9.6375	39000.0
2011-06-02 09:00:00	AMZN	Stock	9.6425	9.685	9.528	9.6705	11571520.0
2011-06-02 10:00:00	AMZN	Stock	9.671	9.722	9.6475	9.65	8003620.0
2011-06-02 11:00:00	AMZN	Stock	9.6485	9.6564	9.556	9.587	6894840.0
2011-06-02 12:00:00	AMZN	Stock	9.5878	9.647	9.5849	9.6415	5574820.0
2011-06-02 13:00:00	AMZN	Stock	9.6455	9.7025	9.6145	9.6815	7321800.0
2011-06-02 14:00:00	AMZN	Stock	9.6815	9.6995	9.6425	9.6795	7064560.0

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

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