PREVIEW / futures_1hour / 2017-08-09

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-09.parquet
  size:    53 KB
  rows:    1,626

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-08-09 00:00:00	ES	Futures	2694.58	2695.67	2694.58	2695.12	2804.0
2017-08-09 01:00:00	ES	Futures	2695.4	2697.04	2694.85	2696.49	6578.0
2017-08-09 02:00:00	ES	Futures	2696.49	2697.86	2696.22	2697.31	8946.0
2017-08-09 03:00:00	ES	Futures	2697.58	2698.4	2695.12	2695.4	31289.0
2017-08-09 04:00:00	ES	Futures	2695.12	2695.67	2691.02	2695.12	40926.0
2017-08-09 05:00:00	ES	Futures	2695.12	2695.67	2688.56	2690.2	38350.0
2017-08-09 06:00:00	ES	Futures	2690.48	2695.12	2689.93	2695.12	29127.0
2017-08-09 07:00:00	ES	Futures	2694.85	2695.67	2691.02	2691.84	32012.0
2017-08-09 08:00:00	ES	Futures	2691.84	2695.12	2689.38	2694.3	49408.0
2017-08-09 09:00:00	ES	Futures	2694.3	2698.13	2688.84	2696.49	258811.0
2017-08-09 10:00:00	ES	Futures	2696.49	2699.5	2691.84	2698.13	223839.0
2017-08-09 11:00:00	ES	Futures	2697.86	2700.59	2693.21	2700.59	156359.0
2017-08-09 12:00:00	ES	Futures	2700.32	2701.14	2697.04	2697.31	88349.0
2017-08-09 13:00:00	ES	Futures	2697.31	2699.5	2696.22	2697.04	69736.0
2017-08-09 14:00:00	ES	Futures	2697.04	2697.58	2692.39	2695.4	130395.0
2017-08-09 15:00:00	ES	Futures	2695.4	2702.78	2693.76	2701.69	201733.0
2017-08-09 16:00:00	ES	Futures	2701.96	2705.51	2700.87	2704.97	103318.0
2017-08-09 18:00:00	ES	Futures	2704.97	2705.24	2702.23	2702.51	8104.0
2017-08-09 19:00:00	ES	Futures	2702.78	2703.05	2701.41	2702.23	5346.0
2017-08-09 20:00:00	ES	Futures	2702.23	2703.33	2701.96	2702.51	4672.0
2017-08-09 21:00:00	ES	Futures	2702.51	2703.05	2700.59	2701.41	6798.0
2017-08-09 22:00:00	ES	Futures	2701.14	2701.41	2697.86	2698.4	10518.0
2017-08-09 23:00:00	ES	Futures	2698.4	2699.22	2696.22	2697.31	10488.0
2017-08-09 00:00:00	NQ	Futures	7018.0	7023.95	7018.0	7021.57	734.0
2017-08-09 01:00:00	NQ	Futures	7021.57	7027.23	7019.49	7026.33	1318.0
2017-08-09 02:00:00	NQ	Futures	7026.33	7031.4	7024.85	7031.4	1395.0
2017-08-09 03:00:00	NQ	Futures	7031.1	7034.08	7022.46	7023.06	4131.0
2017-08-09 04:00:00	NQ	Futures	7023.06	7023.06	7004.6	7015.32	6335.0
2017-08-09 05:00:00	NQ	Futures	7015.61	7017.4	6997.75	7001.03	4502.0
2017-08-09 06:00:00	NQ	Futures	7001.32	7015.32	6999.83	7012.64	4505.0
2017-08-09 07:00:00	NQ	Futures	7012.34	7015.91	7001.32	7004.0	6278.0
2017-08-09 08:00:00	NQ	Futures	7004.0	7009.36	6991.5	7004.0	14657.0
2017-08-09 09:00:00	NQ	Futures	7003.7	7018.59	6981.37	7013.53	74695.0
2017-08-09 10:00:00	NQ	Futures	7013.53	7030.8	6999.83	7023.95	67598.0
2017-08-09 11:00:00	NQ	Futures	7023.95	7043.01	7013.23	7042.71	44567.0
2017-08-09 12:00:00	NQ	Futures	7043.31	7047.47	7029.61	7029.61	29316.0
2017-08-09 13:00:00	NQ	Futures	7029.61	7037.95	7027.82	7036.46	19685.0
2017-08-09 14:00:00	NQ	Futures	7036.16	7037.95	7010.85	7023.65	28573.0
2017-08-09 15:00:00	NQ	Futures	7023.65	7049.56	7016.81	7047.18	41036.0
2017-08-09 16:00:00	NQ	Futures	7047.47	7056.11	7046.58	7055.51	7918.0
2017-08-09 18:00:00	NQ	Futures	7053.73	7054.32	7048.37	7048.96	947.0
2017-08-09 19:00:00	NQ	Futures	7049.26	7051.34	7046.28	7050.45	816.0
2017-08-09 20:00:00	NQ	Futures	7050.15	7053.73	7048.96	7052.24	932.0
2017-08-09 21:00:00	NQ	Futures	7052.24	7053.43	7045.39	7046.28	1113.0
2017-08-09 22:00:00	NQ	Futures	7045.99	7047.77	7032.29	7033.48	2431.0
2017-08-09 23:00:00	NQ	Futures	7033.18	7036.16	7029.01	7032.59	1630.0
2017-08-09 00:00:00	YM	Futures	23936.8	23948.8	23936.8	23946.6	529.0
2017-08-09 01:00:00	YM	Futures	23946.6	23954.2	23944.4	23953.1	934.0
2017-08-09 02:00:00	YM	Futures	23952.0	23970.5	23949.9	23970.5	2019.0
2017-08-09 03:00:00	YM	Futures	23970.5	23973.8	23955.3	23956.4	2410.0

> showing 50 of 1,626 rows — these rows as CSV

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