PREVIEW / futures_1hour / 2017-10-17

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-17.parquet
  size:    50 KB
  rows:    1,614

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-17 00:00:00	ES	Futures	2796.86	2797.41	2796.59	2796.86	1432.0
2017-10-17 01:00:00	ES	Futures	2796.86	2797.41	2796.86	2797.14	2063.0
2017-10-17 02:00:00	ES	Futures	2797.14	2797.41	2796.04	2796.04	3115.0
2017-10-17 03:00:00	ES	Futures	2796.32	2796.86	2795.5	2795.5	10211.0
2017-10-17 04:00:00	ES	Futures	2795.5	2796.32	2794.95	2795.77	6477.0
2017-10-17 05:00:00	ES	Futures	2796.04	2797.14	2795.22	2796.04	5893.0
2017-10-17 06:00:00	ES	Futures	2796.32	2796.59	2795.77	2796.59	4171.0
2017-10-17 07:00:00	ES	Futures	2796.59	2797.41	2796.04	2796.86	10460.0
2017-10-17 08:00:00	ES	Futures	2796.86	2797.41	2795.5	2796.32	17761.0
2017-10-17 09:00:00	ES	Futures	2796.04	2796.59	2794.4	2796.04	80850.0
2017-10-17 10:00:00	ES	Futures	2796.04	2797.14	2792.76	2794.67	123685.0
2017-10-17 11:00:00	ES	Futures	2794.67	2797.14	2793.85	2794.4	96229.0
2017-10-17 12:00:00	ES	Futures	2794.4	2795.77	2794.13	2794.67	42254.0
2017-10-17 13:00:00	ES	Futures	2794.67	2795.22	2793.03	2794.13	52193.0
2017-10-17 14:00:00	ES	Futures	2793.85	2796.32	2793.85	2796.04	47151.0
2017-10-17 15:00:00	ES	Futures	2796.04	2798.78	2795.5	2798.23	132025.0
2017-10-17 16:00:00	ES	Futures	2797.96	2798.5	2797.14	2797.41	63953.0
2017-10-17 18:00:00	ES	Futures	2797.41	2797.96	2797.14	2797.41	2795.0
2017-10-17 19:00:00	ES	Futures	2797.68	2799.6	2797.14	2799.05	4583.0
2017-10-17 20:00:00	ES	Futures	2799.33	2799.6	2797.68	2798.5	4576.0
2017-10-17 21:00:00	ES	Futures	2798.23	2799.05	2798.23	2799.05	4505.0
2017-10-17 22:00:00	ES	Futures	2798.78	2799.05	2798.5	2799.05	1306.0
2017-10-17 23:00:00	ES	Futures	2799.05	2799.05	2798.5	2798.78	1052.0
2017-10-17 00:00:00	NQ	Futures	7281.65	7283.73	7280.46	7281.05	611.0
2017-10-17 01:00:00	NQ	Futures	7281.05	7281.94	7280.46	7281.05	451.0
2017-10-17 02:00:00	NQ	Futures	7281.05	7282.24	7278.38	7278.67	862.0
2017-10-17 03:00:00	NQ	Futures	7278.97	7282.54	7276.0	7276.59	1656.0
2017-10-17 04:00:00	NQ	Futures	7276.89	7278.97	7274.51	7277.78	1217.0
2017-10-17 05:00:00	NQ	Futures	7277.78	7280.16	7276.0	7277.78	832.0
2017-10-17 06:00:00	NQ	Futures	7277.78	7278.97	7276.29	7278.97	629.0
2017-10-17 07:00:00	NQ	Futures	7278.97	7281.05	7277.78	7280.16	1838.0
2017-10-17 08:00:00	NQ	Futures	7280.16	7281.35	7273.02	7278.08	5170.0
2017-10-17 09:00:00	NQ	Futures	7277.78	7278.08	7267.67	7272.43	24096.0
2017-10-17 10:00:00	NQ	Futures	7272.13	7277.48	7262.91	7273.91	30595.0
2017-10-17 11:00:00	NQ	Futures	7274.21	7281.65	7270.05	7271.83	22905.0
2017-10-17 12:00:00	NQ	Futures	7272.13	7276.59	7270.34	7272.72	10054.0
2017-10-17 13:00:00	NQ	Futures	7273.02	7277.78	7271.24	7273.32	10565.0
2017-10-17 14:00:00	NQ	Futures	7273.02	7280.16	7273.02	7279.56	9892.0
2017-10-17 15:00:00	NQ	Futures	7279.56	7287.3	7276.89	7285.81	21118.0
2017-10-17 16:00:00	NQ	Futures	7285.51	7286.7	7282.54	7282.54	5382.0
2017-10-17 18:00:00	NQ	Futures	7283.43	7286.41	7282.54	7285.81	850.0
2017-10-17 19:00:00	NQ	Futures	7285.81	7291.16	7284.03	7290.57	1131.0
2017-10-17 20:00:00	NQ	Futures	7290.27	7291.16	7287.3	7289.08	1248.0
2017-10-17 21:00:00	NQ	Futures	7289.38	7290.57	7287.89	7289.97	1101.0
2017-10-17 22:00:00	NQ	Futures	7289.97	7290.27	7287.6	7288.49	593.0
2017-10-17 23:00:00	NQ	Futures	7288.19	7288.78	7287.3	7288.19	478.0
2017-10-17 00:00:00	YM	Futures	24908.0	24916.7	24908.0	24910.1	481.0
2017-10-17 01:00:00	YM	Futures	24910.1	24917.8	24910.1	24915.6	535.0
2017-10-17 02:00:00	YM	Futures	24915.6	24919.9	24906.9	24912.3	1313.0
2017-10-17 03:00:00	YM	Futures	24912.3	24918.8	24906.9	24906.9	1549.0

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

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