PREVIEW / stock_1hour / 2018-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-20.parquet
  size:    1.1 MB
  rows:    48,108
  symbols: 2,839

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
2018-04-20 04:00:00	AAPL	Stock	43.075	43.075	43.0	43.0025	18148.0
2018-04-20 05:00:00	AAPL	Stock	43.05	43.075	43.0	43.0	26984.0
2018-04-20 06:00:00	AAPL	Stock	42.9375	43.0325	42.8875	43.0325	57868.0
2018-04-20 07:00:00	AAPL	Stock	43.03	43.28	43.015	43.0625	167808.0
2018-04-20 08:00:00	AAPL	Stock	43.105	43.225	42.9225	42.9875	701624.0
2018-04-20 09:00:00	AAPL	Stock	42.9875	43.125	41.715	41.85	60165828.0
2018-04-20 10:00:00	AAPL	Stock	41.85	42.025	41.6825	41.7375	45136344.0
2018-04-20 11:00:00	AAPL	Stock	41.7375	41.82	41.6325	41.725	22938532.0
2018-04-20 12:00:00	AAPL	Stock	41.7275	41.7495	41.3975	41.485	24361200.0
2018-04-20 13:00:00	AAPL	Stock	41.48	41.6125	41.42	41.4625	14380264.0
2018-04-20 14:00:00	AAPL	Stock	41.4625	41.525	41.38	41.46	14504956.0
2018-04-20 15:00:00	AAPL	Stock	41.46	41.6	41.3575	41.43	31434936.0
2018-04-20 16:00:00	AAPL	Stock	41.43	41.497	41.4	41.45	16181612.0
2018-04-20 17:00:00	AAPL	Stock	41.475	41.4925	41.45	41.4825	81184.0
2018-04-20 18:00:00	AAPL	Stock	41.4825	41.5375	41.465	41.5375	107692.0
2018-04-20 19:00:00	AAPL	Stock	41.5375	41.5625	41.52	41.525	75816.0
2018-04-20 04:00:00	MSFT	Stock	95.72	95.72	95.72	95.72	100.0
2018-04-20 05:00:00	MSFT	Stock	95.7	95.7	95.7	95.7	100.0
2018-04-20 06:00:00	MSFT	Stock	95.61	95.9	95.61	95.9	1048.0
2018-04-20 07:00:00	MSFT	Stock	96.05	96.3	96.0	96.05	9063.0
2018-04-20 08:00:00	MSFT	Stock	96.3	96.3	95.63	95.9	23736.0
2018-04-20 09:00:00	MSFT	Stock	95.78	96.11	94.97	95.05	4418739.0
2018-04-20 10:00:00	MSFT	Stock	95.05	95.54	94.7	94.79	3868090.0
2018-04-20 11:00:00	MSFT	Stock	94.8	94.84	94.05	94.31	3156715.0
2018-04-20 12:00:00	MSFT	Stock	94.31	94.56	94.23	94.45	2220658.0
2018-04-20 13:00:00	MSFT	Stock	94.44	95.33	94.34	95.115	2767151.0
2018-04-20 14:00:00	MSFT	Stock	95.12	95.205	94.65	94.945	2158642.0
2018-04-20 15:00:00	MSFT	Stock	94.94	95.05	94.41	95.0	4727185.0
2018-04-20 16:00:00	MSFT	Stock	95.0	95.08	94.375	95.0	5309687.0
2018-04-20 17:00:00	MSFT	Stock	95.03	95.04	94.98	95.0	5648.0
2018-04-20 18:00:00	MSFT	Stock	95.0	95.04	95.0	95.04	10022.0
2018-04-20 19:00:00	MSFT	Stock	95.05	95.1	95.05	95.1	3325.0
2018-04-20 04:00:00	NVDA	Stock	5.6878	5.69	5.6878	5.69	24000.0
2018-04-20 05:00:00	NVDA	Stock	5.69	5.69	5.69	5.69	27040.0
2018-04-20 06:00:00	NVDA	Stock	5.7135	5.726	5.7135	5.726	24000.0
2018-04-20 07:00:00	NVDA	Stock	5.7245	5.736	5.7135	5.7188	203560.0
2018-04-20 08:00:00	NVDA	Stock	5.7135	5.725	5.7005	5.7188	664800.0
2018-04-20 09:00:00	NVDA	Stock	5.72	5.7968	5.6958	5.7828	79285000.0
2018-04-20 10:00:00	NVDA	Stock	5.7842	5.8025	5.7453	5.7598	64231000.0
2018-04-20 11:00:00	NVDA	Stock	5.758	5.7581	5.6973	5.7305	54457320.0
2018-04-20 12:00:00	NVDA	Stock	5.7319	5.7409	5.7128	5.7188	28710400.0
2018-04-20 13:00:00	NVDA	Stock	5.7153	5.7613	5.711	5.747	30803200.0
2018-04-20 14:00:00	NVDA	Stock	5.7475	5.755	5.7225	5.7362	27296360.0
2018-04-20 15:00:00	NVDA	Stock	5.7365	5.7375	5.6862	5.7178	59263440.0
2018-04-20 16:00:00	NVDA	Stock	5.7178	5.7228	5.6875	5.7	4253360.0
2018-04-20 17:00:00	NVDA	Stock	5.6975	5.7025	5.6938	5.6938	111440.0
2018-04-20 18:00:00	NVDA	Stock	5.6988	5.7125	5.6938	5.7115	148920.0
2018-04-20 19:00:00	NVDA	Stock	5.7125	5.7125	5.6975	5.71	320120.0
2018-04-20 04:00:00	AMZN	Stock	77.5	77.5	77.499	77.499	7820.0
2018-04-20 06:00:00	AMZN	Stock	77.85	77.85	77.8495	77.8495	18380.0

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

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