PREVIEW / futures_1hour / 2017-08-31

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-31.parquet
  size:    52 KB
  rows:    1,610

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-31 00:00:00	ES	Futures	2687.2	2687.47	2686.65	2687.2	1686.0
2017-08-31 01:00:00	ES	Futures	2687.2	2687.47	2686.38	2687.2	3271.0
2017-08-31 02:00:00	ES	Futures	2687.47	2688.29	2686.92	2687.2	5338.0
2017-08-31 03:00:00	ES	Futures	2687.47	2688.56	2686.1	2686.92	18797.0
2017-08-31 04:00:00	ES	Futures	2686.92	2692.94	2686.92	2692.39	30076.0
2017-08-31 05:00:00	ES	Futures	2692.12	2694.58	2691.84	2694.58	15254.0
2017-08-31 06:00:00	ES	Futures	2694.3	2695.12	2689.66	2691.84	26660.0
2017-08-31 07:00:00	ES	Futures	2691.57	2692.94	2689.11	2689.66	15107.0
2017-08-31 08:00:00	ES	Futures	2689.66	2692.66	2689.11	2691.84	18983.0
2017-08-31 09:00:00	ES	Futures	2691.84	2697.04	2691.84	2696.76	168233.0
2017-08-31 10:00:00	ES	Futures	2696.49	2700.04	2694.3	2696.49	284908.0
2017-08-31 11:00:00	ES	Futures	2696.49	2697.86	2693.21	2697.31	154020.0
2017-08-31 12:00:00	ES	Futures	2697.04	2700.04	2697.04	2698.68	87134.0
2017-08-31 13:00:00	ES	Futures	2698.68	2699.77	2697.31	2698.68	78095.0
2017-08-31 14:00:00	ES	Futures	2698.68	2702.78	2697.04	2702.23	124159.0
2017-08-31 15:00:00	ES	Futures	2702.23	2705.24	2698.68	2701.41	482304.0
2017-08-31 16:00:00	ES	Futures	2701.14	2701.41	2698.68	2701.14	126573.0
2017-08-31 18:00:00	ES	Futures	2700.87	2703.05	2700.59	2701.96	6589.0
2017-08-31 19:00:00	ES	Futures	2701.69	2703.6	2701.41	2703.33	3959.0
2017-08-31 20:00:00	ES	Futures	2703.33	2703.6	2701.96	2702.23	5223.0
2017-08-31 21:00:00	ES	Futures	2701.96	2702.78	2701.14	2702.23	5613.0
2017-08-31 22:00:00	ES	Futures	2702.51	2702.51	2701.69	2701.69	2202.0
2017-08-31 23:00:00	ES	Futures	2701.96	2702.51	2701.14	2701.41	3770.0
2017-08-31 00:00:00	NQ	Futures	7081.12	7082.31	7079.93	7081.12	428.0
2017-08-31 01:00:00	NQ	Futures	7081.42	7081.72	7077.84	7080.82	680.0
2017-08-31 02:00:00	NQ	Futures	7081.12	7084.99	7078.14	7078.14	1926.0
2017-08-31 03:00:00	NQ	Futures	7078.44	7085.88	7072.19	7075.76	3103.0
2017-08-31 04:00:00	NQ	Futures	7075.76	7090.05	7075.76	7088.27	5620.0
2017-08-31 05:00:00	NQ	Futures	7088.27	7094.82	7084.4	7093.92	2676.0
2017-08-31 06:00:00	NQ	Futures	7093.92	7094.52	7078.14	7084.4	3705.0
2017-08-31 07:00:00	NQ	Futures	7084.4	7087.97	7076.06	7078.44	2653.0
2017-08-31 08:00:00	NQ	Futures	7077.84	7086.48	7076.65	7084.1	5698.0
2017-08-31 09:00:00	NQ	Futures	7084.1	7110.3	7082.61	7108.51	41533.0
2017-08-31 10:00:00	NQ	Futures	7108.81	7117.74	7101.37	7107.62	49278.0
2017-08-31 11:00:00	NQ	Futures	7107.62	7119.53	7101.66	7117.15	29182.0
2017-08-31 12:00:00	NQ	Futures	7117.15	7131.74	7116.85	7127.27	25413.0
2017-08-31 13:00:00	NQ	Futures	7127.57	7130.25	7121.02	7126.97	14267.0
2017-08-31 14:00:00	NQ	Futures	7126.68	7133.52	7119.53	7131.44	16618.0
2017-08-31 15:00:00	NQ	Futures	7131.44	7143.65	7125.19	7135.91	46482.0
2017-08-31 16:00:00	NQ	Futures	7135.61	7141.86	7133.23	7140.67	12153.0
2017-08-31 18:00:00	NQ	Futures	7138.88	7147.22	7137.99	7140.97	2045.0
2017-08-31 19:00:00	NQ	Futures	7140.67	7146.33	7140.37	7146.03	942.0
2017-08-31 20:00:00	NQ	Futures	7145.73	7146.03	7141.56	7142.46	955.0
2017-08-31 21:00:00	NQ	Futures	7141.86	7145.73	7138.88	7144.54	1324.0
2017-08-31 22:00:00	NQ	Futures	7144.54	7145.73	7142.75	7144.54	835.0
2017-08-31 23:00:00	NQ	Futures	7144.24	7145.73	7141.27	7143.05	603.0
2017-08-31 00:00:00	YM	Futures	23842.1	23843.2	23831.2	23837.8	718.0
2017-08-31 01:00:00	YM	Futures	23837.8	23843.2	23832.3	23842.1	649.0
2017-08-31 02:00:00	YM	Futures	23843.2	23850.8	23837.8	23841.0	913.0
2017-08-31 03:00:00	YM	Futures	23841.0	23853.0	23833.4	23837.8	2169.0

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

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