PREVIEW / stock_1hour / 2017-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-14.parquet
  size:    1.1 MB
  rows:    48,606
  symbols: 2,967

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-09-14 04:00:00	AAPL	Stock	39.8725	39.9225	39.85	39.85	18072.0
2017-09-14 05:00:00	AAPL	Stock	39.85	39.85	39.85	39.85	4876.0
2017-09-14 06:00:00	AAPL	Stock	39.85	39.895	39.825	39.845	11100.0
2017-09-14 07:00:00	AAPL	Stock	39.83	39.83	39.7475	39.75	80100.0
2017-09-14 08:00:00	AAPL	Stock	39.8025	39.8425	39.715	39.765	587368.0
2017-09-14 09:00:00	AAPL	Stock	39.7825	39.85	39.62	39.7975	14719404.0
2017-09-14 10:00:00	AAPL	Stock	39.7962	39.8472	39.6975	39.75	11643204.0
2017-09-14 11:00:00	AAPL	Stock	39.75	39.8325	39.72	39.7475	8583400.0
2017-09-14 12:00:00	AAPL	Stock	39.75	39.76	39.6	39.7062	9117360.0
2017-09-14 13:00:00	AAPL	Stock	39.7068	39.73	39.6675	39.685	5134408.0
2017-09-14 14:00:00	AAPL	Stock	39.6875	39.73	39.65	39.6788	5204592.0
2017-09-14 15:00:00	AAPL	Stock	39.6788	39.6888	39.5225	39.5675	17021584.0
2017-09-14 16:00:00	AAPL	Stock	39.57	39.575	39.5225	39.5375	9692736.0
2017-09-14 17:00:00	AAPL	Stock	39.545	39.55	39.5075	39.515	37624.0
2017-09-14 18:00:00	AAPL	Stock	39.515	39.515	39.425	39.425	247712.0
2017-09-14 19:00:00	AAPL	Stock	39.4275	39.455	39.415	39.4375	130744.0
2017-09-14 07:00:00	MSFT	Stock	75.29	75.29	75.17	75.17	600.0
2017-09-14 08:00:00	MSFT	Stock	75.2	75.2	74.8	74.94	14516.0
2017-09-14 09:00:00	MSFT	Stock	74.93	75.0	74.52	74.94	1881019.0
2017-09-14 10:00:00	MSFT	Stock	74.935	75.42	74.89	75.39	2144103.0
2017-09-14 11:00:00	MSFT	Stock	75.385	75.49	75.26	75.315	1484075.0
2017-09-14 12:00:00	MSFT	Stock	75.315	75.34	75.08	75.15	763706.0
2017-09-14 13:00:00	MSFT	Stock	75.15	75.155	74.9	74.91	949220.0
2017-09-14 14:00:00	MSFT	Stock	74.915	75.04	74.895	74.96	964388.0
2017-09-14 15:00:00	MSFT	Stock	74.96	74.98	74.7	74.77	3001959.0
2017-09-14 16:00:00	MSFT	Stock	74.77	74.87	74.7	74.75	2844771.0
2017-09-14 17:00:00	MSFT	Stock	74.78	74.89	74.6	74.89	24046.0
2017-09-14 18:00:00	MSFT	Stock	74.66	74.7	74.6	74.6	5755.0
2017-09-14 19:00:00	MSFT	Stock	74.6	74.64	74.55	74.6	5006.0
2017-09-14 06:00:00	NVDA	Stock	4.2472	4.2472	4.2425	4.2425	12000.0
2017-09-14 07:00:00	NVDA	Stock	4.2375	4.2375	4.2252	4.2255	367360.0
2017-09-14 08:00:00	NVDA	Stock	4.23	4.23	4.2078	4.2112	3939680.0
2017-09-14 09:00:00	NVDA	Stock	4.215	4.25	4.195	4.245	83735120.0
2017-09-14 10:00:00	NVDA	Stock	4.246	4.292	4.2352	4.2892	106293360.0
2017-09-14 11:00:00	NVDA	Stock	4.2894	4.314	4.288	4.2943	98595000.0
2017-09-14 12:00:00	NVDA	Stock	4.2943	4.3015	4.2732	4.2965	48308320.0
2017-09-14 13:00:00	NVDA	Stock	4.2965	4.3	4.2828	4.2835	29444480.0
2017-09-14 14:00:00	NVDA	Stock	4.2835	4.2853	4.2695	4.2708	33451560.0
2017-09-14 15:00:00	NVDA	Stock	4.27	4.2718	4.2278	4.2348	81240840.0
2017-09-14 16:00:00	NVDA	Stock	4.235	4.2712	4.2222	4.2322	3649920.0
2017-09-14 17:00:00	NVDA	Stock	4.23	4.2325	4.23	4.2325	282400.0
2017-09-14 18:00:00	NVDA	Stock	4.24	4.24	4.2013	4.21	1077840.0
2017-09-14 19:00:00	NVDA	Stock	4.2125	4.2165	4.2038	4.2048	602240.0
2017-09-14 05:00:00	AMZN	Stock	50.09	50.09	50.09	50.09	2000.0
2017-09-14 06:00:00	AMZN	Stock	50.05	50.05	50.05	50.05	2000.0
2017-09-14 07:00:00	AMZN	Stock	50.03	50.08	50.0045	50.02	101080.0
2017-09-14 08:00:00	AMZN	Stock	50.025	50.0675	49.7475	49.8265	258560.0
2017-09-14 09:00:00	AMZN	Stock	49.83	49.928	49.5806	49.7828	12731260.0
2017-09-14 10:00:00	AMZN	Stock	49.7825	49.7905	49.451	49.638	11153180.0
2017-09-14 11:00:00	AMZN	Stock	49.645	49.6824	49.5125	49.631	6435580.0

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

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