PREVIEW / stock_1hour / 2015-02-17

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-17.parquet
  size:    1.1 MB
  rows:    49,491
  symbols: 3,536

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
2015-02-17 04:00:00	AAPL	Stock	31.65	32.0	31.65	31.9125	128248.0
2015-02-17 05:00:00	AAPL	Stock	31.9075	32.02	31.9025	32.015	84364.0
2015-02-17 06:00:00	AAPL	Stock	32.0	32.1175	31.9875	32.085	216292.0
2015-02-17 07:00:00	AAPL	Stock	32.0825	32.0975	32.0	32.09	344008.0
2015-02-17 08:00:00	AAPL	Stock	32.0825	32.095	31.5875	31.955	1821964.0
2015-02-17 09:00:00	AAPL	Stock	31.94	31.9725	31.73	31.9	40429736.0
2015-02-17 10:00:00	AAPL	Stock	31.9	32.22	31.9	32.13	48899480.0
2015-02-17 11:00:00	AAPL	Stock	32.13	32.1712	32.0075	32.111	30424224.0
2015-02-17 12:00:00	AAPL	Stock	32.11	32.1225	31.8175	31.86	28924324.0
2015-02-17 13:00:00	AAPL	Stock	31.8575	31.98	31.845	31.9115	21172048.0
2015-02-17 14:00:00	AAPL	Stock	31.91	31.9438	31.835	31.9162	16986400.0
2015-02-17 15:00:00	AAPL	Stock	31.9175	32.03	31.8825	31.955	34138420.0
2015-02-17 16:00:00	AAPL	Stock	31.955	32.1592	31.861	31.93	8576472.0
2015-02-17 17:00:00	AAPL	Stock	31.935	31.9575	31.925	31.9325	123504.0
2015-02-17 18:00:00	AAPL	Stock	31.9275	31.9575	31.92	31.9325	263844.0
2015-02-17 19:00:00	AAPL	Stock	31.9325	31.9325	31.905	31.925	221728.0
2015-02-17 04:00:00	MSFT	Stock	43.6	43.6	43.4	43.5	3600.0
2015-02-17 05:00:00	MSFT	Stock	43.52	43.53	43.23	43.53	1600.0
2015-02-17 06:00:00	MSFT	Stock	43.47	43.47	43.47	43.47	200.0
2015-02-17 07:00:00	MSFT	Stock	43.53	43.53	43.5	43.53	6030.0
2015-02-17 08:00:00	MSFT	Stock	43.65	43.69	43.51	43.56	22969.0
2015-02-17 09:00:00	MSFT	Stock	43.56	44.0	43.24	43.33	5483585.0
2015-02-17 10:00:00	MSFT	Stock	43.34	43.35	43.21	43.225	4101192.0
2015-02-17 11:00:00	MSFT	Stock	43.227	43.33	43.19	43.305	2994353.0
2015-02-17 12:00:00	MSFT	Stock	43.305	43.325	43.22	43.312	2915450.0
2015-02-17 13:00:00	MSFT	Stock	43.32	43.45	43.28	43.386	2572138.0
2015-02-17 14:00:00	MSFT	Stock	43.39	43.5	43.35	43.445	2443626.0
2015-02-17 15:00:00	MSFT	Stock	43.45	43.58	43.4	43.575	5603360.0
2015-02-17 16:00:00	MSFT	Stock	43.58	43.584	43.249	43.336	5592257.0
2015-02-17 17:00:00	MSFT	Stock	43.48	43.53	43.46	43.46	2731.0
2015-02-17 18:00:00	MSFT	Stock	43.481	43.481	43.481	43.481	200.0
2015-02-17 19:00:00	MSFT	Stock	43.48	43.56	43.48	43.56	450.0
2015-02-17 08:00:00	NVDA	Stock	0.5558	0.5558	0.5558	0.5558	13160.0
2015-02-17 09:00:00	NVDA	Stock	0.5562	0.5615	0.5532	0.5612	35438800.0
2015-02-17 10:00:00	NVDA	Stock	0.5615	0.5622	0.5555	0.5565	36154880.0
2015-02-17 11:00:00	NVDA	Stock	0.5566	0.56	0.5562	0.5582	24115640.0
2015-02-17 12:00:00	NVDA	Stock	0.5582	0.559	0.5552	0.5555	26958400.0
2015-02-17 13:00:00	NVDA	Stock	0.5558	0.56	0.5555	0.5585	12994520.0
2015-02-17 14:00:00	NVDA	Stock	0.5585	0.5602	0.5578	0.5595	17378840.0
2015-02-17 15:00:00	NVDA	Stock	0.5595	0.5598	0.5582	0.5595	30144680.0
2015-02-17 16:00:00	NVDA	Stock	0.5594	0.5602	0.5581	0.5602	4483400.0
2015-02-17 17:00:00	NVDA	Stock	0.5577	0.5605	0.5577	0.5605	347800.0
2015-02-17 19:00:00	NVDA	Stock	0.5592	0.5592	0.5592	0.5592	4000.0
2015-02-17 06:00:00	AMZN	Stock	19.0055	19.05	19.005	19.05	8060.0
2015-02-17 07:00:00	AMZN	Stock	19.015	19.055	19.015	19.055	19200.0
2015-02-17 08:00:00	AMZN	Stock	19.0375	19.0525	18.99	19.015	60400.0
2015-02-17 09:00:00	AMZN	Stock	19.024	19.024	18.7405	18.7455	14469860.0
2015-02-17 10:00:00	AMZN	Stock	18.751	18.7905	18.6415	18.6695	13864320.0
2015-02-17 11:00:00	AMZN	Stock	18.6635	18.762	18.6335	18.75	8930580.0
2015-02-17 12:00:00	AMZN	Stock	18.75	18.7835	18.7102	18.7645	4859940.0

> showing 50 of 49,491 rows — these rows as CSV

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