PREVIEW / futures_1hour / 2017-07-20

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-20.parquet
  size:    52 KB
  rows:    1,622

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-20 00:00:00	ES	Futures	2701.14	2701.14	2700.59	2700.87	720.0
2017-07-20 01:00:00	ES	Futures	2701.14	2701.96	2700.87	2701.69	2430.0
2017-07-20 02:00:00	ES	Futures	2701.41	2702.23	2700.87	2701.96	8089.0
2017-07-20 03:00:00	ES	Futures	2701.96	2704.97	2701.69	2704.69	21677.0
2017-07-20 04:00:00	ES	Futures	2704.42	2704.97	2702.78	2702.78	15943.0
2017-07-20 05:00:00	ES	Futures	2702.78	2703.87	2702.23	2703.33	11211.0
2017-07-20 06:00:00	ES	Futures	2703.33	2704.15	2702.78	2702.78	6512.0
2017-07-20 07:00:00	ES	Futures	2702.78	2704.42	2702.78	2704.42	11783.0
2017-07-20 08:00:00	ES	Futures	2704.69	2707.43	2703.05	2704.15	44631.0
2017-07-20 09:00:00	ES	Futures	2704.15	2706.33	2702.51	2704.97	115776.0
2017-07-20 10:00:00	ES	Futures	2704.69	2705.51	2695.67	2702.51	284325.0
2017-07-20 11:00:00	ES	Futures	2702.51	2704.69	2698.13	2701.14	163486.0
2017-07-20 12:00:00	ES	Futures	2701.14	2704.97	2700.59	2704.15	61186.0
2017-07-20 13:00:00	ES	Futures	2704.42	2705.51	2702.23	2704.97	53789.0
2017-07-20 14:00:00	ES	Futures	2704.69	2704.97	2701.14	2704.15	71182.0
2017-07-20 15:00:00	ES	Futures	2704.15	2705.79	2701.41	2702.23	128678.0
2017-07-20 16:00:00	ES	Futures	2702.23	2704.42	2701.41	2703.6	75522.0
2017-07-20 18:00:00	ES	Futures	2703.33	2703.87	2702.23	2702.78	4715.0
2017-07-20 19:00:00	ES	Futures	2702.78	2703.05	2701.69	2702.23	1705.0
2017-07-20 20:00:00	ES	Futures	2702.51	2703.6	2702.23	2703.05	3431.0
2017-07-20 21:00:00	ES	Futures	2703.05	2703.33	2702.23	2703.05	2864.0
2017-07-20 22:00:00	ES	Futures	2703.05	2703.05	2701.96	2702.23	2279.0
2017-07-20 23:00:00	ES	Futures	2702.23	2702.78	2701.96	2702.51	1207.0
2017-07-20 00:00:00	NQ	Futures	7050.45	7051.94	7049.26	7051.64	235.0
2017-07-20 01:00:00	NQ	Futures	7051.94	7054.92	7051.34	7054.02	702.0
2017-07-20 02:00:00	NQ	Futures	7054.02	7055.81	7049.26	7050.15	1514.0
2017-07-20 03:00:00	NQ	Futures	7050.15	7052.83	7047.47	7049.56	2140.0
2017-07-20 04:00:00	NQ	Futures	7049.86	7052.54	7045.99	7046.28	1400.0
2017-07-20 05:00:00	NQ	Futures	7046.28	7050.75	7044.5	7049.26	996.0
2017-07-20 06:00:00	NQ	Futures	7049.26	7051.64	7048.07	7049.86	1060.0
2017-07-20 07:00:00	NQ	Futures	7049.86	7060.28	7048.96	7059.68	3089.0
2017-07-20 08:00:00	NQ	Futures	7059.68	7070.7	7057.0	7062.06	10851.0
2017-07-20 09:00:00	NQ	Futures	7062.06	7072.78	7048.07	7059.38	41334.0
2017-07-20 10:00:00	NQ	Futures	7059.09	7059.38	7023.36	7046.58	74720.0
2017-07-20 11:00:00	NQ	Futures	7046.58	7059.09	7043.31	7054.02	37227.0
2017-07-20 12:00:00	NQ	Futures	7054.02	7063.55	7053.13	7056.41	13556.0
2017-07-20 13:00:00	NQ	Futures	7056.11	7059.09	7045.99	7054.92	13299.0
2017-07-20 14:00:00	NQ	Futures	7055.22	7055.51	7035.27	7046.28	19276.0
2017-07-20 15:00:00	NQ	Futures	7046.58	7061.17	7046.58	7054.92	28091.0
2017-07-20 16:00:00	NQ	Futures	7054.92	7065.93	7054.62	7063.55	10019.0
2017-07-20 18:00:00	NQ	Futures	7063.55	7064.15	7043.01	7050.15	2157.0
2017-07-20 19:00:00	NQ	Futures	7050.45	7052.54	7048.37	7050.45	551.0
2017-07-20 20:00:00	NQ	Futures	7050.75	7052.24	7049.86	7051.34	711.0
2017-07-20 21:00:00	NQ	Futures	7051.34	7051.64	7046.58	7047.77	979.0
2017-07-20 22:00:00	NQ	Futures	7047.47	7047.77	7040.03	7045.09	1476.0
2017-07-20 23:00:00	NQ	Futures	7044.79	7047.47	7041.52	7046.28	744.0
2017-07-20 00:00:00	YM	Futures	23497.1	23499.2	23496.0	23498.1	191.0
2017-07-20 01:00:00	YM	Futures	23499.2	23505.8	23499.2	23502.5	410.0
2017-07-20 02:00:00	YM	Futures	23503.6	23506.9	23494.9	23499.2	880.0
2017-07-20 03:00:00	YM	Futures	23500.3	23537.3	23500.3	23535.2	2785.0

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

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