PREVIEW / stock_1hour / 2019-04-25

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-25.parquet
  size:    1.1 MB
  rows:    49,546
  symbols: 2,608

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-25 04:00:00	AAPL	Stock	51.965	51.965	51.8625	51.885	12612.0
2019-04-25 05:00:00	AAPL	Stock	51.9	51.9125	51.875	51.875	7044.0
2019-04-25 06:00:00	AAPL	Stock	51.8875	51.925	51.805	51.8625	18436.0
2019-04-25 07:00:00	AAPL	Stock	51.8475	51.9925	51.8475	51.9375	83060.0
2019-04-25 08:00:00	AAPL	Stock	51.95	51.9725	51.8575	51.8575	243952.0
2019-04-25 09:00:00	AAPL	Stock	51.885	51.94	51.6625	51.6925	11279272.0
2019-04-25 10:00:00	AAPL	Stock	51.6925	51.8075	51.28	51.5212	13386224.0
2019-04-25 11:00:00	AAPL	Stock	51.52	51.6925	51.42	51.5625	5975472.0
2019-04-25 12:00:00	AAPL	Stock	51.5675	51.61	51.4275	51.5225	4917396.0
2019-04-25 13:00:00	AAPL	Stock	51.525	51.58	51.375	51.5275	4455796.0
2019-04-25 14:00:00	AAPL	Stock	51.5275	51.61	51.465	51.535	4321508.0
2019-04-25 15:00:00	AAPL	Stock	51.535	51.565	51.2825	51.31	12149304.0
2019-04-25 16:00:00	AAPL	Stock	51.32	51.3625	51.175	51.25	5821716.0
2019-04-25 17:00:00	AAPL	Stock	51.295	51.295	51.0375	51.2225	226196.0
2019-04-25 18:00:00	AAPL	Stock	51.175	51.225	51.15	51.195	45676.0
2019-04-25 19:00:00	AAPL	Stock	51.195	51.2925	51.15	51.2925	66636.0
2019-04-25 04:00:00	MSFT	Stock	129.35	130.23	129.35	130.0	26629.0
2019-04-25 05:00:00	MSFT	Stock	130.05	130.3	129.99	130.3	10344.0
2019-04-25 06:00:00	MSFT	Stock	130.46	131.5	130.35	131.2	50782.0
2019-04-25 07:00:00	MSFT	Stock	131.29	131.5	130.5	130.85	154662.0
2019-04-25 08:00:00	MSFT	Stock	131.14	131.85	130.56	131.07	435297.0
2019-04-25 09:00:00	MSFT	Stock	131.08	131.37	129.07	130.14	9773915.0
2019-04-25 10:00:00	MSFT	Stock	130.13	130.34	128.83	129.88	7082775.0
2019-04-25 11:00:00	MSFT	Stock	129.87	130.18	129.42	129.672	3497478.0
2019-04-25 12:00:00	MSFT	Stock	129.67	129.815	129.14	129.28	2254105.0
2019-04-25 13:00:00	MSFT	Stock	129.282	129.48	129.08	129.47	1620332.0
2019-04-25 14:00:00	MSFT	Stock	129.48	129.89	129.435	129.815	2345313.0
2019-04-25 15:00:00	MSFT	Stock	129.815	129.815	129.08	129.08	3794271.0
2019-04-25 16:00:00	MSFT	Stock	129.15	129.43	128.9	129.0	2831288.0
2019-04-25 17:00:00	MSFT	Stock	129.0	129.03	128.54	128.984	38633.0
2019-04-25 18:00:00	MSFT	Stock	128.99	129.08	128.9	128.98	21492.0
2019-04-25 19:00:00	MSFT	Stock	128.98	129.06	128.9	129.06	2951.0
2019-04-25 04:00:00	NVDA	Stock	4.7625	4.7738	4.7625	4.7712	35200.0
2019-04-25 05:00:00	NVDA	Stock	4.7715	4.7715	4.7715	4.7715	4000.0
2019-04-25 07:00:00	NVDA	Stock	4.771	4.771	4.7438	4.7462	396720.0
2019-04-25 08:00:00	NVDA	Stock	4.75	4.7725	4.7388	4.7563	1562240.0
2019-04-25 09:00:00	NVDA	Stock	4.7575	4.7612	4.6715	4.6792	79097960.0
2019-04-25 10:00:00	NVDA	Stock	4.6797	4.6935	4.5925	4.6345	118383440.0
2019-04-25 11:00:00	NVDA	Stock	4.6335	4.676	4.6148	4.6682	60700240.0
2019-04-25 12:00:00	NVDA	Stock	4.669	4.6942	4.6612	4.6923	31323920.0
2019-04-25 13:00:00	NVDA	Stock	4.6925	4.6975	4.6705	4.6795	22613280.0
2019-04-25 14:00:00	NVDA	Stock	4.679	4.7088	4.679	4.7041	33404920.0
2019-04-25 15:00:00	NVDA	Stock	4.7038	4.7058	4.6598	4.671	53554200.0
2019-04-25 16:00:00	NVDA	Stock	4.6728	4.675	4.525	4.5375	23018240.0
2019-04-25 17:00:00	NVDA	Stock	4.5388	4.5575	4.5288	4.55	2623640.0
2019-04-25 18:00:00	NVDA	Stock	4.5462	4.5688	4.5462	4.5572	740240.0
2019-04-25 19:00:00	NVDA	Stock	4.555	4.5625	4.5413	4.555	931880.0
2019-04-25 04:00:00	AMZN	Stock	96.025	96.1	96.0	96.0	45400.0
2019-04-25 05:00:00	AMZN	Stock	96.0	96.0	95.95	95.95	13240.0
2019-04-25 06:00:00	AMZN	Stock	95.925	95.9395	95.85	95.9	61040.0

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

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