PREVIEW / stock_1hour / 2017-01-05

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-05.parquet
  size:    1.0 MB
  rows:    48,455
  symbols: 3,123

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
2017-01-05 07:00:00	AAPL	Stock	28.9625	28.985	28.9425	28.945	13928.0
2017-01-05 08:00:00	AAPL	Stock	28.9975	29.0175	28.945	29.0175	86092.0
2017-01-05 09:00:00	AAPL	Stock	29.015	29.216	28.9525	29.1675	15597040.0
2017-01-05 10:00:00	AAPL	Stock	29.17	29.2	29.02	29.0825	14420164.0
2017-01-05 11:00:00	AAPL	Stock	29.08	29.1	28.985	29.0725	11008568.0
2017-01-05 12:00:00	AAPL	Stock	29.0725	29.205	29.0525	29.1725	12340272.0
2017-01-05 13:00:00	AAPL	Stock	29.1725	29.175	29.085	29.12	5759056.0
2017-01-05 14:00:00	AAPL	Stock	29.1215	29.1538	29.075	29.08	5007088.0
2017-01-05 15:00:00	AAPL	Stock	29.0775	29.19	29.0725	29.1525	12971640.0
2017-01-05 16:00:00	AAPL	Stock	29.1525	29.17	29.13	29.165	4979720.0
2017-01-05 17:00:00	AAPL	Stock	29.1675	29.1725	29.1575	29.1725	40800.0
2017-01-05 18:00:00	AAPL	Stock	29.175	29.18	29.16	29.1675	55604.0
2017-01-05 19:00:00	AAPL	Stock	29.1675	29.1775	29.16	29.175	6560.0
2017-01-05 06:00:00	MSFT	Stock	62.3	62.3	62.3	62.3	1439.0
2017-01-05 07:00:00	MSFT	Stock	62.3	62.3	62.15	62.15	677.0
2017-01-05 08:00:00	MSFT	Stock	62.17	62.3	62.17	62.3	2200.0
2017-01-05 09:00:00	MSFT	Stock	62.3	62.66	62.03	62.48	2655984.0
2017-01-05 10:00:00	MSFT	Stock	62.47	62.52	62.21	62.37	2978019.0
2017-01-05 11:00:00	MSFT	Stock	62.37	62.466	62.17	62.445	2076465.0
2017-01-05 12:00:00	MSFT	Stock	62.445	62.52	62.36	62.43	2090441.0
2017-01-05 13:00:00	MSFT	Stock	62.425	62.51	62.31	62.31	1923179.0
2017-01-05 14:00:00	MSFT	Stock	62.315	62.41	62.27	62.275	2089741.0
2017-01-05 15:00:00	MSFT	Stock	62.28	62.43	62.27	62.3	3287109.0
2017-01-05 16:00:00	MSFT	Stock	62.3	62.43	62.24	62.3	3166367.0
2017-01-05 17:00:00	MSFT	Stock	62.35	62.35	62.3	62.35	6816.0
2017-01-05 18:00:00	MSFT	Stock	62.31	62.35	62.3	62.35	2414.0
2017-01-05 19:00:00	MSFT	Stock	62.31	62.31	62.31	62.31	200.0
2017-01-05 04:00:00	NVDA	Stock	2.6503	2.6688	2.645	2.6688	220000.0
2017-01-05 05:00:00	NVDA	Stock	2.6588	2.675	2.6588	2.6712	194960.0
2017-01-05 06:00:00	NVDA	Stock	2.6788	2.6878	2.6738	2.6775	437800.0
2017-01-05 07:00:00	NVDA	Stock	2.6775	2.6813	2.635	2.645	1997320.0
2017-01-05 08:00:00	NVDA	Stock	2.6493	2.6875	2.5928	2.607	9586800.0
2017-01-05 09:00:00	NVDA	Stock	2.6122	2.6455	2.5765	2.6282	167047560.0
2017-01-05 10:00:00	NVDA	Stock	2.6284	2.6298	2.5608	2.5759	199476880.0
2017-01-05 11:00:00	NVDA	Stock	2.5753	2.5782	2.5262	2.54	162308760.0
2017-01-05 12:00:00	NVDA	Stock	2.5408	2.5545	2.539	2.5486	78418480.0
2017-01-05 13:00:00	NVDA	Stock	2.5487	2.549	2.5325	2.5351	65937800.0
2017-01-05 14:00:00	NVDA	Stock	2.5342	2.5688	2.5338	2.5466	97487600.0
2017-01-05 15:00:00	NVDA	Stock	2.5462	2.5573	2.5384	2.5435	113233200.0
2017-01-05 16:00:00	NVDA	Stock	2.5435	2.5673	2.5413	2.5433	49152800.0
2017-01-05 17:00:00	NVDA	Stock	2.5435	2.5438	2.543	2.5438	491360.0
2017-01-05 18:00:00	NVDA	Stock	2.5438	2.5498	2.5425	2.5445	210600.0
2017-01-05 19:00:00	NVDA	Stock	2.545	2.546	2.5413	2.5425	357200.0
2017-01-05 05:00:00	AMZN	Stock	37.8685	37.887	37.8685	37.887	6000.0
2017-01-05 06:00:00	AMZN	Stock	37.8595	37.8595	37.8595	37.8595	10000.0
2017-01-05 08:00:00	AMZN	Stock	37.8495	37.9	37.8	37.9	90400.0
2017-01-05 09:00:00	AMZN	Stock	37.9	38.5684	37.859	38.4498	20226980.0
2017-01-05 10:00:00	AMZN	Stock	38.45	38.775	38.4285	38.692	21389840.0
2017-01-05 11:00:00	AMZN	Stock	38.688	38.765	38.6075	38.742	12656920.0
2017-01-05 12:00:00	AMZN	Stock	38.7425	38.85	38.7125	38.8375	9406060.0

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

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