PREVIEW / stock_1hour / 2019-06-13

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-13.parquet
  size:    1.1 MB
  rows:    49,240
  symbols: 2,595

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-06-13 04:00:00	AAPL	Stock	48.5875	48.8575	48.5875	48.84	20256.0
2019-06-13 05:00:00	AAPL	Stock	48.825	48.8375	48.8075	48.8225	17308.0
2019-06-13 06:00:00	AAPL	Stock	48.7625	48.8375	48.7175	48.8375	34088.0
2019-06-13 07:00:00	AAPL	Stock	48.8175	48.84	48.71	48.7425	141496.0
2019-06-13 08:00:00	AAPL	Stock	48.79	48.85	48.6425	48.72	170120.0
2019-06-13 09:00:00	AAPL	Stock	48.7	49.16	48.61	49.1362	12520488.0
2019-06-13 10:00:00	AAPL	Stock	49.14	49.1975	48.885	48.9175	11892856.0
2019-06-13 11:00:00	AAPL	Stock	48.92	48.99	48.765	48.92	7344124.0
2019-06-13 12:00:00	AAPL	Stock	48.9175	48.9595	48.795	48.9075	4415916.0
2019-06-13 13:00:00	AAPL	Stock	48.91	48.9575	48.815	48.82	3952264.0
2019-06-13 14:00:00	AAPL	Stock	48.82	48.82	48.614	48.6875	5812464.0
2019-06-13 15:00:00	AAPL	Stock	48.6825	48.85	48.4	48.685	17279044.0
2019-06-13 16:00:00	AAPL	Stock	48.6825	48.6825	48.3125	48.3625	7041336.0
2019-06-13 17:00:00	AAPL	Stock	48.3625	48.5375	48.0025	48.1	1764180.0
2019-06-13 18:00:00	AAPL	Stock	48.135	48.1875	48.125	48.1775	119004.0
2019-06-13 19:00:00	AAPL	Stock	48.17	48.235	48.1275	48.1875	67480.0
2019-06-13 04:00:00	MSFT	Stock	131.99	131.99	131.95	131.95	350.0
2019-06-13 06:00:00	MSFT	Stock	132.08	132.2	132.07	132.2	1919.0
2019-06-13 07:00:00	MSFT	Stock	132.2	132.3	132.09	132.15	5654.0
2019-06-13 08:00:00	MSFT	Stock	132.34	132.34	131.6	131.998	47896.0
2019-06-13 09:00:00	MSFT	Stock	131.9	132.5	131.83	132.465	1997684.0
2019-06-13 10:00:00	MSFT	Stock	132.47	133.0	131.83	131.84	2481043.0
2019-06-13 11:00:00	MSFT	Stock	131.84	132.1	131.56	132.01	1534096.0
2019-06-13 12:00:00	MSFT	Stock	132.017	132.083	131.56	131.95	1111942.0
2019-06-13 13:00:00	MSFT	Stock	131.96	132.23	131.83	132.19	1137868.0
2019-06-13 14:00:00	MSFT	Stock	132.19	132.31	131.94	132.13	1662255.0
2019-06-13 15:00:00	MSFT	Stock	132.13	132.42	131.83	132.32	3368842.0
2019-06-13 16:00:00	MSFT	Stock	132.31	132.58	132.18	132.5	1647338.0
2019-06-13 17:00:00	MSFT	Stock	132.55	132.55	132.2	132.32	7335.0
2019-06-13 18:00:00	MSFT	Stock	132.32	132.46	132.23	132.23	7145.0
2019-06-13 19:00:00	MSFT	Stock	132.43	132.49	132.32	132.35	6051.0
2019-06-13 04:00:00	NVDA	Stock	3.659	3.7015	3.6572	3.6975	135920.0
2019-06-13 05:00:00	NVDA	Stock	3.697	3.7138	3.697	3.7125	142120.0
2019-06-13 06:00:00	NVDA	Stock	3.7002	3.7002	3.7	3.7	29080.0
2019-06-13 07:00:00	NVDA	Stock	3.7025	3.7068	3.6838	3.6888	398200.0
2019-06-13 08:00:00	NVDA	Stock	3.6942	3.705	3.664	3.691	1248520.0
2019-06-13 09:00:00	NVDA	Stock	3.6952	3.725	3.6595	3.721	54182240.0
2019-06-13 10:00:00	NVDA	Stock	3.722	3.7238	3.671	3.6722	45424400.0
2019-06-13 11:00:00	NVDA	Stock	3.6723	3.69	3.6668	3.6868	30552720.0
2019-06-13 12:00:00	NVDA	Stock	3.6862	3.71	3.6812	3.7086	33155920.0
2019-06-13 13:00:00	NVDA	Stock	3.7093	3.712	3.6998	3.7078	23592600.0
2019-06-13 14:00:00	NVDA	Stock	3.7068	3.7087	3.6892	3.7034	23774560.0
2019-06-13 15:00:00	NVDA	Stock	3.7031	3.7083	3.6848	3.708	47035040.0
2019-06-13 16:00:00	NVDA	Stock	3.7065	3.7075	3.65	3.6562	26229880.0
2019-06-13 17:00:00	NVDA	Stock	3.6625	3.6625	3.6375	3.6408	1241120.0
2019-06-13 18:00:00	NVDA	Stock	3.6438	3.65	3.6403	3.645	302800.0
2019-06-13 19:00:00	NVDA	Stock	3.647	3.6488	3.6278	3.6278	521120.0
2019-06-13 04:00:00	AMZN	Stock	93.1625	93.22	93.1625	93.22	21980.0
2019-06-13 06:00:00	AMZN	Stock	93.344	93.4495	93.3	93.4495	22000.0
2019-06-13 07:00:00	AMZN	Stock	93.428	93.4305	93.3	93.3	38580.0

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

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