PREVIEW / stock_1hour / 2016-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-21.parquet
  size:    1.0 MB
  rows:    48,148
  symbols: 3,289

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
2016-06-21 04:00:00	AAPL	Stock	23.77	23.8	23.7675	23.775	6640.0
2016-06-21 05:00:00	AAPL	Stock	23.7625	23.7775	23.7525	23.7525	5404.0
2016-06-21 06:00:00	AAPL	Stock	23.775	23.7775	23.765	23.765	14944.0
2016-06-21 07:00:00	AAPL	Stock	23.7875	23.815	23.785	23.7875	39880.0
2016-06-21 08:00:00	AAPL	Stock	23.8	23.8325	23.7625	23.795	233752.0
2016-06-21 09:00:00	AAPL	Stock	23.7925	24.035	23.669	24.0275	26482944.0
2016-06-21 10:00:00	AAPL	Stock	24.0275	24.0275	23.9225	23.98	23468332.0
2016-06-21 11:00:00	AAPL	Stock	23.98	24.0775	23.965	24.07	15080672.0
2016-06-21 12:00:00	AAPL	Stock	24.07	24.0875	24.0012	24.0238	13509928.0
2016-06-21 13:00:00	AAPL	Stock	24.0225	24.0575	23.95	23.975	11457196.0
2016-06-21 14:00:00	AAPL	Stock	23.9775	24.0675	23.9625	24.035	10705000.0
2016-06-21 15:00:00	AAPL	Stock	24.035	24.0712	23.975	23.9775	21520448.0
2016-06-21 16:00:00	AAPL	Stock	23.9775	23.985	23.955	23.955	6513276.0
2016-06-21 17:00:00	AAPL	Stock	23.955	24.13	23.95	24.1125	453784.0
2016-06-21 18:00:00	AAPL	Stock	24.1125	24.13	24.04	24.045	175872.0
2016-06-21 19:00:00	AAPL	Stock	24.0525	24.095	24.04	24.09	95736.0
2016-06-21 07:00:00	MSFT	Stock	50.23	50.23	50.23	50.23	100.0
2016-06-21 08:00:00	MSFT	Stock	50.27	50.27	50.24	50.24	7545.0
2016-06-21 09:00:00	MSFT	Stock	50.26	50.69	50.16	50.675	3272348.0
2016-06-21 10:00:00	MSFT	Stock	50.675	51.05	50.57	50.91	5879317.0
2016-06-21 11:00:00	MSFT	Stock	50.905	51.18	50.88	51.14	3265274.0
2016-06-21 12:00:00	MSFT	Stock	51.145	51.26	51.03	51.055	2836826.0
2016-06-21 13:00:00	MSFT	Stock	51.05	51.2	51.01	51.154	2778759.0
2016-06-21 14:00:00	MSFT	Stock	51.16	51.31	51.11	51.24	3541575.0
2016-06-21 15:00:00	MSFT	Stock	51.23	51.43	51.12	51.19	7941830.0
2016-06-21 16:00:00	MSFT	Stock	51.19	51.24	51.15	51.19	2236022.0
2016-06-21 17:00:00	MSFT	Stock	51.16	51.16	51.16	51.16	109.0
2016-06-21 18:00:00	MSFT	Stock	51.16	51.19	51.16	51.19	1200.0
2016-06-21 19:00:00	MSFT	Stock	51.19	51.19	51.16	51.16	7451.0
2016-06-21 07:00:00	NVDA	Stock	1.2	1.2	1.2	1.2	20000.0
2016-06-21 08:00:00	NVDA	Stock	1.2005	1.2005	1.195	1.195	82760.0
2016-06-21 09:00:00	NVDA	Stock	1.194	1.1973	1.1893	1.1938	27144200.0
2016-06-21 10:00:00	NVDA	Stock	1.1938	1.194	1.1818	1.1819	36206080.0
2016-06-21 11:00:00	NVDA	Stock	1.1818	1.1888	1.1809	1.188	21718000.0
2016-06-21 12:00:00	NVDA	Stock	1.1881	1.1905	1.1842	1.1842	17230920.0
2016-06-21 13:00:00	NVDA	Stock	1.1842	1.1875	1.1829	1.1848	15462400.0
2016-06-21 14:00:00	NVDA	Stock	1.1845	1.1852	1.182	1.1829	24173400.0
2016-06-21 15:00:00	NVDA	Stock	1.1828	1.1862	1.18	1.1815	51425320.0
2016-06-21 16:00:00	NVDA	Stock	1.181	1.183	1.1755	1.1755	1330200.0
2016-06-21 17:00:00	NVDA	Stock	1.1785	1.1818	1.1785	1.1818	808000.0
2016-06-21 18:00:00	NVDA	Stock	1.179	1.179	1.179	1.179	4000.0
2016-06-21 19:00:00	NVDA	Stock	1.18	1.18	1.18	1.18	8000.0
2016-06-21 05:00:00	AMZN	Stock	35.7565	35.7565	35.7565	35.7565	2000.0
2016-06-21 07:00:00	AMZN	Stock	35.85	35.8505	35.8115	35.8115	31500.0
2016-06-21 08:00:00	AMZN	Stock	35.813	35.85	35.7625	35.776	110100.0
2016-06-21 09:00:00	AMZN	Stock	35.8315	35.92	35.6765	35.84	7496720.0
2016-06-21 10:00:00	AMZN	Stock	35.825	35.862	35.65	35.665	6916880.0
2016-06-21 11:00:00	AMZN	Stock	35.679	35.7942	35.6361	35.7448	4268060.0
2016-06-21 12:00:00	AMZN	Stock	35.738	35.879	35.7315	35.7585	3733480.0
2016-06-21 13:00:00	AMZN	Stock	35.762	35.7815	35.65	35.71	2657280.0

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

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