PREVIEW / stock_1hour / 2017-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-23.parquet
  size:    1.1 MB
  rows:    47,902
  symbols: 2,926

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
2017-10-23 04:00:00	AAPL	Stock	39.0625	39.1625	39.0625	39.1625	3924.0
2017-10-23 05:00:00	AAPL	Stock	39.1	39.15	39.1	39.115	6304.0
2017-10-23 06:00:00	AAPL	Stock	39.115	39.2	39.115	39.15	21844.0
2017-10-23 07:00:00	AAPL	Stock	39.1375	39.1625	39.105	39.1225	23272.0
2017-10-23 08:00:00	AAPL	Stock	39.15	39.2225	39.1025	39.2225	110108.0
2017-10-23 09:00:00	AAPL	Stock	39.23	39.275	39.0625	39.2125	8863324.0
2017-10-23 10:00:00	AAPL	Stock	39.215	39.215	38.9775	39.0288	11245496.0
2017-10-23 11:00:00	AAPL	Stock	39.03	39.1375	39.03	39.0922	4619048.0
2017-10-23 12:00:00	AAPL	Stock	39.09	39.4225	39.0888	39.3725	12117052.0
2017-10-23 13:00:00	AAPL	Stock	39.3725	39.3925	39.2375	39.2512	5729208.0
2017-10-23 14:00:00	AAPL	Stock	39.25	39.29	39.12	39.1788	6877644.0
2017-10-23 15:00:00	AAPL	Stock	39.1775	39.185	38.875	39.05	16849844.0
2017-10-23 16:00:00	AAPL	Stock	39.0425	39.095	38.985	39.0175	10314372.0
2017-10-23 17:00:00	AAPL	Stock	39.0375	39.0375	39.0025	39.015	14772.0
2017-10-23 18:00:00	AAPL	Stock	39.0075	39.04	39.0075	39.0375	45604.0
2017-10-23 19:00:00	AAPL	Stock	39.03	39.0375	39.0125	39.02	39072.0
2017-10-23 06:00:00	MSFT	Stock	78.93	79.0	78.85	79.0	1246.0
2017-10-23 07:00:00	MSFT	Stock	78.89	78.94	78.89	78.9	4715.0
2017-10-23 08:00:00	MSFT	Stock	78.89	78.96	78.89	78.96	11739.0
2017-10-23 09:00:00	MSFT	Stock	78.95	79.13	78.85	79.037	1894874.0
2017-10-23 10:00:00	MSFT	Stock	79.03	79.1	78.88	78.95	2660325.0
2017-10-23 11:00:00	MSFT	Stock	78.95	79.19	78.95	79.12	1731058.0
2017-10-23 12:00:00	MSFT	Stock	79.12	79.21	79.065	79.14	1040397.0
2017-10-23 13:00:00	MSFT	Stock	79.135	79.17	78.94	79.16	1497576.0
2017-10-23 14:00:00	MSFT	Stock	79.17	79.34	79.11	79.23	2176077.0
2017-10-23 15:00:00	MSFT	Stock	79.23	79.23	78.76	78.85	5036111.0
2017-10-23 16:00:00	MSFT	Stock	78.83	78.85	78.8	78.85	3080757.0
2017-10-23 17:00:00	MSFT	Stock	78.85	78.85	78.8	78.8	2455.0
2017-10-23 18:00:00	MSFT	Stock	78.83	78.83	78.81	78.83	833.0
2017-10-23 19:00:00	MSFT	Stock	78.83	78.85	78.82	78.85	8082.0
2017-10-23 04:00:00	NVDA	Stock	4.9438	4.9758	4.92	4.975	302640.0
2017-10-23 05:00:00	NVDA	Stock	4.975	4.975	4.975	4.975	24000.0
2017-10-23 06:00:00	NVDA	Stock	4.9702	4.9702	4.959	4.9648	352880.0
2017-10-23 07:00:00	NVDA	Stock	4.9495	4.9575	4.9378	4.9448	314080.0
2017-10-23 08:00:00	NVDA	Stock	4.9432	4.95	4.9405	4.9485	1720880.0
2017-10-23 09:00:00	NVDA	Stock	4.9488	4.9528	4.9072	4.914	66248640.0
2017-10-23 10:00:00	NVDA	Stock	4.913	4.94	4.895	4.9318	69209760.0
2017-10-23 11:00:00	NVDA	Stock	4.9315	4.9498	4.9263	4.9366	39246320.0
2017-10-23 12:00:00	NVDA	Stock	4.9375	4.9663	4.9341	4.9662	43390760.0
2017-10-23 13:00:00	NVDA	Stock	4.9665	4.9713	4.95	4.9646	42615000.0
2017-10-23 14:00:00	NVDA	Stock	4.9642	4.9675	4.9388	4.944	31234000.0
2017-10-23 15:00:00	NVDA	Stock	4.9438	4.9438	4.9002	4.9155	71250480.0
2017-10-23 16:00:00	NVDA	Stock	4.9155	4.924	4.9125	4.9155	20120120.0
2017-10-23 17:00:00	NVDA	Stock	4.9188	4.9188	4.9105	4.9112	399560.0
2017-10-23 18:00:00	NVDA	Stock	4.9125	4.9232	4.9125	4.9193	174760.0
2017-10-23 19:00:00	NVDA	Stock	4.9183	4.9188	4.9138	4.9138	471600.0
2017-10-23 04:00:00	AMZN	Stock	49.2	49.2	49.2	49.2	4000.0
2017-10-23 06:00:00	AMZN	Stock	49.336	49.35	49.336	49.35	17980.0
2017-10-23 07:00:00	AMZN	Stock	49.3055	49.3105	49.226	49.226	19680.0
2017-10-23 08:00:00	AMZN	Stock	49.225	49.3	49.225	49.28	98400.0

> showing 50 of 47,902 rows — these rows as CSV

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