PREVIEW / stock_1hour / 2017-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-20.parquet
  size:    1.0 MB
  rows:    47,748
  symbols: 2,953

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-20 04:00:00	AAPL	Stock	39.605	39.7575	39.605	39.725	6284.0
2017-09-20 05:00:00	AAPL	Stock	39.7275	39.7575	39.7275	39.75	2400.0
2017-09-20 06:00:00	AAPL	Stock	39.7875	39.7875	39.685	39.685	4792.0
2017-09-20 07:00:00	AAPL	Stock	39.6975	39.75	39.635	39.6825	96260.0
2017-09-20 08:00:00	AAPL	Stock	39.7	39.75	39.5175	39.545	305664.0
2017-09-20 09:00:00	AAPL	Stock	39.5425	39.575	39.0125	39.0525	27658632.0
2017-09-20 10:00:00	AAPL	Stock	39.05	39.1625	38.595	38.6215	39411076.0
2017-09-20 11:00:00	AAPL	Stock	38.625	38.795	38.4575	38.6925	37780948.0
2017-09-20 12:00:00	AAPL	Stock	38.6952	38.9762	38.6775	38.92	14941084.0
2017-09-20 13:00:00	AAPL	Stock	38.9225	39.0	38.875	38.97	9203432.0
2017-09-20 14:00:00	AAPL	Stock	38.9688	39.015	38.7175	38.86	18879036.0
2017-09-20 15:00:00	AAPL	Stock	38.8578	39.0575	38.79	39.0125	21983684.0
2017-09-20 16:00:00	AAPL	Stock	39.01	39.035	38.685	39.025	13469764.0
2017-09-20 17:00:00	AAPL	Stock	39.0125	39.0475	38.9775	39.0425	429900.0
2017-09-20 18:00:00	AAPL	Stock	39.0425	39.0525	39.0025	39.025	86168.0
2017-09-20 19:00:00	AAPL	Stock	39.02	39.0625	39.0125	39.0625	29732.0
2017-09-20 05:00:00	MSFT	Stock	75.46	75.46	75.46	75.46	107.0
2017-09-20 06:00:00	MSFT	Stock	75.45	75.45	75.45	75.45	200.0
2017-09-20 07:00:00	MSFT	Stock	75.35	75.45	75.3	75.45	7369.0
2017-09-20 08:00:00	MSFT	Stock	75.45	75.45	75.31	75.31	3911.0
2017-09-20 09:00:00	MSFT	Stock	75.35	75.55	75.115	75.181	2364456.0
2017-09-20 10:00:00	MSFT	Stock	75.19	75.335	74.85	74.86	2274950.0
2017-09-20 11:00:00	MSFT	Stock	74.86	75.09	74.72	75.06	1712997.0
2017-09-20 12:00:00	MSFT	Stock	75.07	75.25	75.05	75.144	825083.0
2017-09-20 13:00:00	MSFT	Stock	75.13	75.166	74.945	75.1	915604.0
2017-09-20 14:00:00	MSFT	Stock	75.1	75.1	74.31	74.53	3264320.0
2017-09-20 15:00:00	MSFT	Stock	74.52	75.01	74.49	74.92	4038696.0
2017-09-20 16:00:00	MSFT	Stock	74.94	75.07	74.92	74.94	2778931.0
2017-09-20 17:00:00	MSFT	Stock	74.92	74.92	74.83	74.83	878.0
2017-09-20 18:00:00	MSFT	Stock	74.81	74.81	74.81	74.81	150.0
2017-09-20 19:00:00	MSFT	Stock	74.91	74.91	74.91	74.91	500.0
2017-09-20 04:00:00	NVDA	Stock	4.7002	4.7038	4.7002	4.7038	34640.0
2017-09-20 05:00:00	NVDA	Stock	4.7	4.7	4.7	4.7	4000.0
2017-09-20 06:00:00	NVDA	Stock	4.6998	4.6998	4.6925	4.6925	20400.0
2017-09-20 07:00:00	NVDA	Stock	4.6828	4.7	4.6828	4.6882	155520.0
2017-09-20 08:00:00	NVDA	Stock	4.6925	4.705	4.6825	4.69	4313000.0
2017-09-20 09:00:00	NVDA	Stock	4.692	4.7355	4.678	4.6932	113593200.0
2017-09-20 10:00:00	NVDA	Stock	4.6935	4.6935	4.64	4.642	133697200.0
2017-09-20 11:00:00	NVDA	Stock	4.644	4.6682	4.635	4.6544	69389920.0
2017-09-20 12:00:00	NVDA	Stock	4.6545	4.6832	4.6534	4.6777	44540400.0
2017-09-20 13:00:00	NVDA	Stock	4.677	4.6812	4.6455	4.6458	45982920.0
2017-09-20 14:00:00	NVDA	Stock	4.6455	4.6592	4.6053	4.6495	116653560.0
2017-09-20 15:00:00	NVDA	Stock	4.6498	4.6745	4.6358	4.6458	112349560.0
2017-09-20 16:00:00	NVDA	Stock	4.6465	4.6544	4.5262	4.555	34815400.0
2017-09-20 17:00:00	NVDA	Stock	4.555	4.5688	4.525	4.5325	11573000.0
2017-09-20 18:00:00	NVDA	Stock	4.5312	4.56	4.4458	4.4715	18673240.0
2017-09-20 19:00:00	NVDA	Stock	4.4713	4.485	4.47	4.4773	8299800.0
2017-09-20 06:00:00	AMZN	Stock	48.55	48.55	48.55	48.55	2180.0
2017-09-20 07:00:00	AMZN	Stock	48.553	48.585	48.55	48.585	14080.0
2017-09-20 08:00:00	AMZN	Stock	48.585	48.585	48.479	48.479	39820.0

> showing 50 of 47,748 rows — these rows as CSV

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