PREVIEW / futures_1hour / 2017-07-27

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-27.parquet
  size:    54 KB
  rows:    1,662

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-07-27 00:00:00	ES	Futures	2709.07	2710.16	2708.79	2709.61	3636.0
2017-07-27 01:00:00	ES	Futures	2709.61	2710.16	2708.79	2709.34	2942.0
2017-07-27 02:00:00	ES	Futures	2709.61	2710.16	2707.7	2707.97	11065.0
2017-07-27 03:00:00	ES	Futures	2708.25	2711.53	2707.97	2709.89	32771.0
2017-07-27 04:00:00	ES	Futures	2709.89	2710.71	2708.25	2708.25	20073.0
2017-07-27 05:00:00	ES	Futures	2708.25	2709.07	2707.97	2708.79	12161.0
2017-07-27 06:00:00	ES	Futures	2708.79	2710.16	2707.97	2709.89	12402.0
2017-07-27 07:00:00	ES	Futures	2709.89	2709.89	2708.25	2708.79	12266.0
2017-07-27 08:00:00	ES	Futures	2708.52	2710.16	2708.52	2709.89	13177.0
2017-07-27 09:00:00	ES	Futures	2709.89	2712.07	2706.88	2707.7	155163.0
2017-07-27 10:00:00	ES	Futures	2707.43	2711.25	2706.88	2710.71	102524.0
2017-07-27 11:00:00	ES	Futures	2710.71	2711.25	2708.52	2710.98	85724.0
2017-07-27 12:00:00	ES	Futures	2710.98	2711.25	2699.5	2701.69	179087.0
2017-07-27 13:00:00	ES	Futures	2701.69	2703.05	2686.38	2692.66	418652.0
2017-07-27 14:00:00	ES	Futures	2692.66	2697.86	2690.48	2694.85	186482.0
2017-07-27 15:00:00	ES	Futures	2695.12	2703.87	2692.12	2703.33	253196.0
2017-07-27 16:00:00	ES	Futures	2703.33	2703.6	2698.68	2703.05	108948.0
2017-07-27 18:00:00	ES	Futures	2702.78	2702.78	2700.04	2700.59	5190.0
2017-07-27 19:00:00	ES	Futures	2700.59	2701.14	2698.68	2698.95	3254.0
2017-07-27 20:00:00	ES	Futures	2698.95	2699.5	2694.58	2695.4	12037.0
2017-07-27 21:00:00	ES	Futures	2695.12	2695.67	2692.12	2694.3	16630.0
2017-07-27 22:00:00	ES	Futures	2694.3	2695.67	2694.3	2695.12	3479.0
2017-07-27 23:00:00	ES	Futures	2695.12	2695.12	2692.94	2693.48	4097.0
2017-07-27 00:00:00	NQ	Futures	7123.7	7127.27	7122.21	7125.49	955.0
2017-07-27 01:00:00	NQ	Futures	7125.78	7128.76	7124.59	7125.49	1316.0
2017-07-27 02:00:00	NQ	Futures	7125.49	7127.57	7122.81	7124.0	1674.0
2017-07-27 03:00:00	NQ	Futures	7124.29	7126.97	7120.42	7121.61	2608.0
2017-07-27 04:00:00	NQ	Futures	7121.61	7124.29	7118.64	7119.53	1514.0
2017-07-27 05:00:00	NQ	Futures	7119.23	7121.61	7117.74	7119.53	1116.0
2017-07-27 06:00:00	NQ	Futures	7119.23	7125.49	7116.25	7121.91	1572.0
2017-07-27 07:00:00	NQ	Futures	7121.91	7126.38	7118.34	7125.78	2933.0
2017-07-27 08:00:00	NQ	Futures	7125.49	7138.29	7125.19	7134.42	9104.0
2017-07-27 09:00:00	NQ	Futures	7134.42	7139.48	7113.87	7117.74	41884.0
2017-07-27 10:00:00	NQ	Futures	7117.45	7139.18	7116.85	7135.01	36175.0
2017-07-27 11:00:00	NQ	Futures	7135.01	7140.97	7127.57	7135.61	25665.0
2017-07-27 12:00:00	NQ	Futures	7135.61	7136.8	7037.65	7052.24	79031.0
2017-07-27 13:00:00	NQ	Futures	7051.94	7062.36	6961.13	7008.47	167552.0
2017-07-27 14:00:00	NQ	Futures	7008.77	7035.27	6995.96	7020.68	67377.0
2017-07-27 15:00:00	NQ	Futures	7020.38	7046.88	7006.98	7045.39	55796.0
2017-07-27 16:00:00	NQ	Futures	7045.09	7049.86	7012.64	7033.78	20954.0
2017-07-27 18:00:00	NQ	Futures	7037.65	7037.65	7021.27	7024.55	2191.0
2017-07-27 19:00:00	NQ	Futures	7025.14	7025.14	7015.91	7016.51	1115.0
2017-07-27 20:00:00	NQ	Futures	7016.51	7019.49	7003.11	7006.38	3054.0
2017-07-27 21:00:00	NQ	Futures	7006.68	7009.06	6987.92	6997.15	5191.0
2017-07-27 22:00:00	NQ	Futures	6996.86	7000.13	6994.47	6998.35	1882.0
2017-07-27 23:00:00	NQ	Futures	6998.35	6999.24	6991.2	6994.18	1825.0
2017-07-27 00:00:00	YM	Futures	23583.0	23593.9	23577.6	23589.6	1901.0
2017-07-27 01:00:00	YM	Futures	23589.6	23596.1	23585.2	23593.9	1019.0
2017-07-27 02:00:00	YM	Futures	23595.0	23598.3	23580.9	23585.2	1523.0
2017-07-27 03:00:00	YM	Futures	23585.2	23611.3	23578.7	23597.2	3761.0

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

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