PREVIEW / stock_1hour / 2018-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-24.parquet
  size:    1.1 MB
  rows:    48,888
  symbols: 2,786

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-08-24 04:00:00	AAPL	Stock	54.075	54.1125	54.025	54.0525	7792.0
2018-08-24 05:00:00	AAPL	Stock	54.0875	54.09	54.0875	54.09	4000.0
2018-08-24 06:00:00	AAPL	Stock	54.0925	54.1125	54.06	54.1125	12688.0
2018-08-24 07:00:00	AAPL	Stock	54.1	54.105	54.0625	54.105	70488.0
2018-08-24 08:00:00	AAPL	Stock	54.0875	54.1625	54.055	54.125	237936.0
2018-08-24 09:00:00	AAPL	Stock	54.1125	54.225	53.95	53.9725	8885736.0
2018-08-24 10:00:00	AAPL	Stock	53.975	54.08	53.7775	53.9575	14872612.0
2018-08-24 11:00:00	AAPL	Stock	53.9562	54.0825	53.855	54.0175	7576736.0
2018-08-24 12:00:00	AAPL	Stock	54.02	54.0475	53.9752	54.011	3919712.0
2018-08-24 13:00:00	AAPL	Stock	54.01	54.0482	53.945	54.0325	4962924.0
2018-08-24 14:00:00	AAPL	Stock	54.0325	54.125	54.015	54.0275	4849764.0
2018-08-24 15:00:00	AAPL	Stock	54.03	54.135	53.985	54.035	9023932.0
2018-08-24 16:00:00	AAPL	Stock	54.04	54.075	54.02	54.0325	7585960.0
2018-08-24 17:00:00	AAPL	Stock	54.04	54.06	54.025	54.04	5056.0
2018-08-24 18:00:00	AAPL	Stock	54.055	54.055	54.0525	54.0525	956.0
2018-08-24 19:00:00	AAPL	Stock	54.0425	54.0875	54.04	54.075	20628.0
2018-08-24 06:00:00	MSFT	Stock	107.78	107.82	107.6	107.6	2954.0
2018-08-24 07:00:00	MSFT	Stock	107.5	107.6	107.35	107.44	6233.0
2018-08-24 08:00:00	MSFT	Stock	107.36	107.753	107.36	107.61	15282.0
2018-08-24 09:00:00	MSFT	Stock	107.61	108.25	107.5	108.129	1830564.0
2018-08-24 10:00:00	MSFT	Stock	108.12	108.56	107.97	108.39	3031383.0
2018-08-24 11:00:00	MSFT	Stock	108.385	108.53	108.22	108.35	1484650.0
2018-08-24 12:00:00	MSFT	Stock	108.35	108.4	108.14	108.2	928173.0
2018-08-24 13:00:00	MSFT	Stock	108.2	108.24	107.9	108.2	1092989.0
2018-08-24 14:00:00	MSFT	Stock	108.19	108.25	108.05	108.1	967633.0
2018-08-24 15:00:00	MSFT	Stock	108.1	108.48	107.96	108.4	2889629.0
2018-08-24 16:00:00	MSFT	Stock	108.41	108.41	108.31	108.4	2869547.0
2018-08-24 17:00:00	MSFT	Stock	108.4	108.45	108.4	108.4	1578.0
2018-08-24 18:00:00	MSFT	Stock	108.45	108.45	108.36	108.36	988.0
2018-08-24 19:00:00	MSFT	Stock	108.4	108.46	108.36	108.46	1206.0
2018-08-24 04:00:00	NVDA	Stock	6.6882	6.6998	6.6882	6.6998	56520.0
2018-08-24 05:00:00	NVDA	Stock	6.7025	6.7025	6.7025	6.7025	4000.0
2018-08-24 06:00:00	NVDA	Stock	6.7	6.7	6.7	6.7	10280.0
2018-08-24 07:00:00	NVDA	Stock	6.71	6.71	6.6862	6.7	234240.0
2018-08-24 08:00:00	NVDA	Stock	6.71	6.71	6.695	6.6975	1349320.0
2018-08-24 09:00:00	NVDA	Stock	6.699	6.7738	6.675	6.7261	95359800.0
2018-08-24 10:00:00	NVDA	Stock	6.7288	6.768	6.725	6.767	84078800.0
2018-08-24 11:00:00	NVDA	Stock	6.768	6.8	6.756	6.7977	85334200.0
2018-08-24 12:00:00	NVDA	Stock	6.7988	6.8202	6.7962	6.8116	57420120.0
2018-08-24 13:00:00	NVDA	Stock	6.8118	6.815	6.785	6.8058	43231440.0
2018-08-24 14:00:00	NVDA	Stock	6.8052	6.812	6.7926	6.7965	25877400.0
2018-08-24 15:00:00	NVDA	Stock	6.7962	6.8112	6.7782	6.807	75891720.0
2018-08-24 16:00:00	NVDA	Stock	6.8055	6.8108	6.7949	6.8028	2733880.0
2018-08-24 17:00:00	NVDA	Stock	6.8028	6.8105	6.8025	6.807	154120.0
2018-08-24 18:00:00	NVDA	Stock	6.8058	6.81	6.8058	6.81	138840.0
2018-08-24 19:00:00	NVDA	Stock	6.81	6.8125	6.8075	6.8125	266320.0
2018-08-24 06:00:00	AMZN	Stock	95.6	95.6	95.6	95.6	9260.0
2018-08-24 07:00:00	AMZN	Stock	95.5565	95.5565	95.4925	95.5285	70720.0
2018-08-24 08:00:00	AMZN	Stock	95.575	95.575	95.4	95.52	229540.0
2018-08-24 09:00:00	AMZN	Stock	95.5245	95.7309	95.375	95.3755	6679300.0

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

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