PREVIEW / stock_1hour / 2014-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-15.parquet
  size:    1.0 MB
  rows:    48,877
  symbols: 3,586

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
2014-07-15 04:00:00	AAPL	Stock	24.1875	24.2025	24.1675	24.1675	25552.0
2014-07-15 05:00:00	AAPL	Stock	24.1675	24.1675	24.1675	24.1675	2580.0
2014-07-15 06:00:00	AAPL	Stock	24.1775	24.1775	24.15	24.155	28096.0
2014-07-15 07:00:00	AAPL	Stock	24.1625	24.2375	24.16	24.2125	132684.0
2014-07-15 08:00:00	AAPL	Stock	24.2075	24.2375	24.075	24.2	578200.0
2014-07-15 09:00:00	AAPL	Stock	24.2	24.225	24.0625	24.1075	24726476.0
2014-07-15 10:00:00	AAPL	Stock	24.1075	24.125	23.875	23.9	33214676.0
2014-07-15 11:00:00	AAPL	Stock	23.9	23.9925	23.81	23.81	20988020.0
2014-07-15 12:00:00	AAPL	Stock	23.81	23.95	23.7575	23.8925	20031876.0
2014-07-15 13:00:00	AAPL	Stock	23.8938	23.945	23.8675	23.875	14078016.0
2014-07-15 14:00:00	AAPL	Stock	23.8762	23.9075	23.855	23.88	10485524.0
2014-07-15 15:00:00	AAPL	Stock	23.88	23.88	23.8275	23.8275	22867656.0
2014-07-15 16:00:00	AAPL	Stock	23.83	24.29	23.8252	24.2175	15499276.0
2014-07-15 17:00:00	AAPL	Stock	24.215	24.24	24.1475	24.19	1953832.0
2014-07-15 18:00:00	AAPL	Stock	24.1925	24.2225	24.1825	24.1925	714484.0
2014-07-15 19:00:00	AAPL	Stock	24.1925	24.2125	23.83	24.2	476772.0
2014-07-15 06:00:00	MSFT	Stock	42.19	42.4	42.19	42.19	1240.0
2014-07-15 07:00:00	MSFT	Stock	42.25	42.35	42.25	42.33	2850.0
2014-07-15 08:00:00	MSFT	Stock	42.31	42.37	42.31	42.37	12230.0
2014-07-15 09:00:00	MSFT	Stock	42.35	42.47	42.26	42.33	3758491.0
2014-07-15 10:00:00	MSFT	Stock	42.33	42.4	42.17	42.25	4507819.0
2014-07-15 11:00:00	MSFT	Stock	42.251	42.285	42.08	42.1	3956262.0
2014-07-15 12:00:00	MSFT	Stock	42.1	42.23	42.03	42.151	2481672.0
2014-07-15 13:00:00	MSFT	Stock	42.15	42.3	42.11	42.258	1916530.0
2014-07-15 14:00:00	MSFT	Stock	42.26	42.4	42.24	42.315	2126502.0
2014-07-15 15:00:00	MSFT	Stock	42.31	42.46	42.18	42.45	5518420.0
2014-07-15 16:00:00	MSFT	Stock	42.45	42.73	42.238	42.53	3387827.0
2014-07-15 17:00:00	MSFT	Stock	42.53	42.53	42.4	42.46	12562.0
2014-07-15 18:00:00	MSFT	Stock	42.46	42.51	42.46	42.51	4835.0
2014-07-15 19:00:00	MSFT	Stock	42.51	42.51	42.51	42.51	6800.0
2014-07-15 09:00:00	NVDA	Stock	0.483	0.4852	0.4818	0.4838	28580080.0
2014-07-15 10:00:00	NVDA	Stock	0.4838	0.4855	0.4815	0.4825	62985720.0
2014-07-15 11:00:00	NVDA	Stock	0.4825	0.4832	0.4808	0.4814	62135680.0
2014-07-15 12:00:00	NVDA	Stock	0.4812	0.484	0.4798	0.483	59516760.0
2014-07-15 13:00:00	NVDA	Stock	0.4831	0.484	0.4811	0.4814	31082040.0
2014-07-15 14:00:00	NVDA	Stock	0.4814	0.4828	0.481	0.4824	20540920.0
2014-07-15 15:00:00	NVDA	Stock	0.4822	0.4845	0.4822	0.4845	79820720.0
2014-07-15 16:00:00	NVDA	Stock	0.4843	0.4848	0.4821	0.4848	22976040.0
2014-07-15 17:00:00	NVDA	Stock	0.485	0.4875	0.485	0.4875	44000.0
2014-07-15 04:00:00	AMZN	Stock	17.794	17.794	17.794	17.794	2120.0
2014-07-15 05:00:00	AMZN	Stock	17.744	17.744	17.744	17.744	2000.0
2014-07-15 07:00:00	AMZN	Stock	17.6805	17.766	17.6805	17.766	38460.0
2014-07-15 08:00:00	AMZN	Stock	17.766	17.766	17.7	17.725	247280.0
2014-07-15 09:00:00	AMZN	Stock	17.724	17.7795	17.636	17.6815	13624920.0
2014-07-15 10:00:00	AMZN	Stock	17.695	17.7245	17.5165	17.592	19967820.0
2014-07-15 11:00:00	AMZN	Stock	17.589	17.693	17.5075	17.515	10645900.0
2014-07-15 12:00:00	AMZN	Stock	17.508	17.6885	17.47	17.6185	9885420.0
2014-07-15 13:00:00	AMZN	Stock	17.6185	17.739	17.6105	17.6574	6599740.0
2014-07-15 14:00:00	AMZN	Stock	17.658	17.728	17.652	17.72	4639140.0
2014-07-15 15:00:00	AMZN	Stock	17.719	17.7375	17.669	17.721	9313820.0

> showing 50 of 48,877 rows — these rows as CSV

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