PREVIEW / futures_1hour / 2017-10-16

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-16.parquet
  size:    51 KB
  rows:    1,639

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-16 00:00:00	ES	Futures	2796.32	2796.32	2795.22	2795.77	2461.0
2017-10-16 01:00:00	ES	Futures	2795.77	2795.77	2794.67	2794.95	3127.0
2017-10-16 02:00:00	ES	Futures	2795.22	2795.22	2793.58	2794.4	6954.0
2017-10-16 03:00:00	ES	Futures	2794.13	2794.4	2792.49	2794.13	15188.0
2017-10-16 04:00:00	ES	Futures	2793.85	2794.4	2793.31	2793.85	7472.0
2017-10-16 05:00:00	ES	Futures	2793.85	2794.4	2793.31	2794.13	4631.0
2017-10-16 06:00:00	ES	Futures	2794.13	2794.67	2793.85	2794.13	2900.0
2017-10-16 07:00:00	ES	Futures	2794.4	2794.4	2792.76	2794.13	6777.0
2017-10-16 08:00:00	ES	Futures	2794.4	2795.77	2794.13	2794.95	11152.0
2017-10-16 09:00:00	ES	Futures	2795.22	2798.78	2794.4	2797.41	102648.0
2017-10-16 10:00:00	ES	Futures	2797.14	2797.68	2792.49	2793.03	147267.0
2017-10-16 11:00:00	ES	Futures	2793.03	2795.5	2792.76	2793.85	69570.0
2017-10-16 12:00:00	ES	Futures	2793.85	2794.13	2791.12	2793.03	70445.0
2017-10-16 13:00:00	ES	Futures	2793.03	2795.22	2792.49	2793.58	48204.0
2017-10-16 14:00:00	ES	Futures	2793.58	2794.95	2793.31	2794.13	44726.0
2017-10-16 15:00:00	ES	Futures	2794.4	2796.86	2793.85	2796.32	154444.0
2017-10-16 16:00:00	ES	Futures	2796.32	2797.41	2796.04	2796.32	54999.0
2017-10-16 18:00:00	ES	Futures	2796.32	2796.59	2795.5	2796.04	4894.0
2017-10-16 19:00:00	ES	Futures	2796.04	2796.86	2796.04	2796.59	1769.0
2017-10-16 20:00:00	ES	Futures	2796.32	2797.96	2796.32	2796.86	5386.0
2017-10-16 21:00:00	ES	Futures	2796.86	2797.41	2794.95	2795.22	6864.0
2017-10-16 22:00:00	ES	Futures	2795.5	2796.59	2795.22	2796.59	2815.0
2017-10-16 23:00:00	ES	Futures	2796.32	2796.86	2796.32	2796.86	1697.0
2017-10-16 00:00:00	NQ	Futures	7270.94	7271.24	7267.37	7268.56	751.0
2017-10-16 01:00:00	NQ	Futures	7268.56	7268.86	7267.07	7267.97	796.0
2017-10-16 02:00:00	NQ	Futures	7267.67	7268.26	7263.8	7265.29	1294.0
2017-10-16 03:00:00	NQ	Futures	7265.29	7267.07	7260.83	7267.07	2017.0
2017-10-16 04:00:00	NQ	Futures	7266.78	7269.45	7263.8	7265.59	1694.0
2017-10-16 05:00:00	NQ	Futures	7265.88	7266.78	7263.5	7265.88	686.0
2017-10-16 06:00:00	NQ	Futures	7265.88	7268.26	7264.4	7266.18	860.0
2017-10-16 07:00:00	NQ	Futures	7266.18	7266.48	7261.42	7265.88	1542.0
2017-10-16 08:00:00	NQ	Futures	7266.18	7271.24	7265.88	7269.45	3500.0
2017-10-16 09:00:00	NQ	Futures	7269.45	7278.67	7267.67	7276.0	26555.0
2017-10-16 10:00:00	NQ	Futures	7276.0	7278.67	7261.42	7268.86	33263.0
2017-10-16 11:00:00	NQ	Futures	7268.86	7273.62	7263.8	7269.45	16059.0
2017-10-16 12:00:00	NQ	Futures	7269.75	7271.53	7254.58	7263.21	20384.0
2017-10-16 13:00:00	NQ	Futures	7263.5	7268.56	7259.64	7263.21	13027.0
2017-10-16 14:00:00	NQ	Futures	7263.5	7270.64	7262.91	7268.56	9145.0
2017-10-16 15:00:00	NQ	Futures	7268.56	7277.48	7267.67	7276.59	19340.0
2017-10-16 16:00:00	NQ	Futures	7276.89	7282.54	7276.0	7280.75	8185.0
2017-10-16 18:00:00	NQ	Futures	7280.46	7280.46	7277.48	7280.46	1104.0
2017-10-16 19:00:00	NQ	Futures	7280.46	7283.73	7280.16	7283.13	813.0
2017-10-16 20:00:00	NQ	Futures	7283.13	7286.7	7282.84	7284.92	1267.0
2017-10-16 21:00:00	NQ	Futures	7284.62	7286.11	7277.48	7278.38	1996.0
2017-10-16 22:00:00	NQ	Futures	7278.38	7281.35	7277.48	7281.35	822.0
2017-10-16 23:00:00	NQ	Futures	7281.05	7282.24	7280.75	7281.35	473.0
2017-10-16 00:00:00	YM	Futures	24860.1	24860.1	24853.6	24855.8	510.0
2017-10-16 01:00:00	YM	Futures	24856.8	24857.9	24849.2	24851.4	789.0
2017-10-16 02:00:00	YM	Futures	24851.4	24855.8	24847.1	24851.4	1454.0
2017-10-16 03:00:00	YM	Futures	24850.3	24854.7	24838.4	24849.2	1621.0

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

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