PREVIEW / stock_1hour / 2019-04-11

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-11.parquet
  size:    1.1 MB
  rows:    49,420
  symbols: 2,625

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
2019-04-11 04:00:00	AAPL	Stock	50.0975	50.125	50.0975	50.125	4420.0
2019-04-11 05:00:00	AAPL	Stock	50.125	50.15	50.09	50.09	16872.0
2019-04-11 06:00:00	AAPL	Stock	50.1525	50.175	50.125	50.125	6476.0
2019-04-11 07:00:00	AAPL	Stock	50.1875	50.32	50.155	50.25	208916.0
2019-04-11 08:00:00	AAPL	Stock	50.2242	50.32	50.1475	50.2075	252000.0
2019-04-11 09:00:00	AAPL	Stock	50.2125	50.2875	49.94	50.12	13456216.0
2019-04-11 10:00:00	AAPL	Stock	50.125	50.23	50.0075	50.12	10321624.0
2019-04-11 11:00:00	AAPL	Stock	50.1225	50.155	49.905	50.017	8090112.0
2019-04-11 12:00:00	AAPL	Stock	50.015	50.1015	49.9825	50.05	4864932.0
2019-04-11 13:00:00	AAPL	Stock	50.051	50.0725	49.7825	49.8125	7089840.0
2019-04-11 14:00:00	AAPL	Stock	49.8125	49.84	49.6875	49.795	7432592.0
2019-04-11 15:00:00	AAPL	Stock	49.795	49.83	49.6108	49.735	12395296.0
2019-04-11 16:00:00	AAPL	Stock	49.7375	49.75	49.6925	49.7	9218136.0
2019-04-11 17:00:00	AAPL	Stock	49.7	49.7375	49.7	49.7075	53536.0
2019-04-11 18:00:00	AAPL	Stock	49.7325	49.75	49.7	49.725	36372.0
2019-04-11 19:00:00	AAPL	Stock	49.7125	49.72	49.6925	49.7125	43000.0
2019-04-11 04:00:00	MSFT	Stock	120.52	120.61	120.46	120.48	700.0
2019-04-11 05:00:00	MSFT	Stock	120.57	120.57	120.57	120.57	390.0
2019-04-11 06:00:00	MSFT	Stock	120.57	120.68	120.57	120.68	1704.0
2019-04-11 07:00:00	MSFT	Stock	120.7	120.7	120.5	120.5	1599.0
2019-04-11 08:00:00	MSFT	Stock	120.6	120.739	120.19	120.4	46605.0
2019-04-11 09:00:00	MSFT	Stock	120.4	120.85	119.92	120.01	2160889.0
2019-04-11 10:00:00	MSFT	Stock	120.01	120.36	119.98	120.36	1750349.0
2019-04-11 11:00:00	MSFT	Stock	120.36	120.47	120.05	120.095	1434111.0
2019-04-11 12:00:00	MSFT	Stock	120.1	120.35	120.07	120.29	1065444.0
2019-04-11 13:00:00	MSFT	Stock	120.286	120.35	120.13	120.175	924843.0
2019-04-11 14:00:00	MSFT	Stock	120.17	120.24	119.93	120.065	960526.0
2019-04-11 15:00:00	MSFT	Stock	120.065	120.34	119.96	120.33	2504710.0
2019-04-11 16:00:00	MSFT	Stock	120.33	120.33	120.0	120.3	1471737.0
2019-04-11 17:00:00	MSFT	Stock	120.3	120.33	120.21	120.3	2884.0
2019-04-11 18:00:00	MSFT	Stock	120.29	120.5	120.28	120.4	6554.0
2019-04-11 19:00:00	MSFT	Stock	120.27	120.3	120.27	120.29	3130.0
2019-04-11 04:00:00	NVDA	Stock	4.7972	4.7972	4.7972	4.7972	4000.0
2019-04-11 05:00:00	NVDA	Stock	4.7938	4.795	4.7938	4.795	42280.0
2019-04-11 07:00:00	NVDA	Stock	4.8125	4.8138	4.7988	4.8035	459720.0
2019-04-11 08:00:00	NVDA	Stock	4.8112	4.8148	4.7962	4.8015	942120.0
2019-04-11 09:00:00	NVDA	Stock	4.8045	4.81	4.7388	4.754	61558840.0
2019-04-11 10:00:00	NVDA	Stock	4.7545	4.794	4.7438	4.7913	72695200.0
2019-04-11 11:00:00	NVDA	Stock	4.7913	4.8136	4.783	4.8102	57910480.0
2019-04-11 12:00:00	NVDA	Stock	4.8098	4.8368	4.8013	4.8326	38197520.0
2019-04-11 13:00:00	NVDA	Stock	4.8322	4.8362	4.796	4.7968	31687760.0
2019-04-11 14:00:00	NVDA	Stock	4.7972	4.8008	4.7693	4.776	28235120.0
2019-04-11 15:00:00	NVDA	Stock	4.776	4.7905	4.7722	4.7878	42261640.0
2019-04-11 16:00:00	NVDA	Stock	4.7885	4.7885	4.7825	4.7875	2857200.0
2019-04-11 17:00:00	NVDA	Stock	4.7862	4.7888	4.775	4.7775	186800.0
2019-04-11 18:00:00	NVDA	Stock	4.7815	4.7862	4.7815	4.785	106600.0
2019-04-11 19:00:00	NVDA	Stock	4.7875	4.7885	4.785	4.7885	328600.0
2019-04-11 04:00:00	AMZN	Stock	92.1	92.1	92.1	92.1	8200.0
2019-04-11 05:00:00	AMZN	Stock	92.187	92.187	92.187	92.187	4620.0
2019-04-11 06:00:00	AMZN	Stock	92.209	92.3745	92.2	92.365	14240.0

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

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