PREVIEW / futures_1hour / 2018-07-17

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-17.parquet
  size:    54 KB
  rows:    1,666

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
2018-07-17 00:00:00	ES	Futures	3049.44	3050.81	3049.44	3050.53	2211.0
2018-07-17 01:00:00	ES	Futures	3050.81	3050.81	3043.99	3044.81	8622.0
2018-07-17 02:00:00	ES	Futures	3044.54	3046.99	3043.45	3044.27	8208.0
2018-07-17 03:00:00	ES	Futures	3044.27	3046.72	3041.27	3046.45	13621.0
2018-07-17 04:00:00	ES	Futures	3046.45	3049.17	3045.36	3046.99	12575.0
2018-07-17 05:00:00	ES	Futures	3047.26	3047.81	3045.9	3046.17	6447.0
2018-07-17 06:00:00	ES	Futures	3046.45	3046.99	3041.54	3043.72	10580.0
2018-07-17 07:00:00	ES	Futures	3043.99	3045.9	3042.09	3044.27	14537.0
2018-07-17 08:00:00	ES	Futures	3044.27	3046.17	3042.36	3042.63	19370.0
2018-07-17 09:00:00	ES	Futures	3042.9	3047.26	3040.45	3046.72	129125.0
2018-07-17 10:00:00	ES	Futures	3046.99	3056.8	3046.72	3055.71	152907.0
2018-07-17 11:00:00	ES	Futures	3055.71	3061.16	3054.89	3060.61	138817.0
2018-07-17 12:00:00	ES	Futures	3060.89	3065.52	3058.98	3064.7	105303.0
2018-07-17 13:00:00	ES	Futures	3064.43	3067.15	3063.07	3064.97	73455.0
2018-07-17 14:00:00	ES	Futures	3064.7	3066.06	3062.52	3062.79	82286.0
2018-07-17 15:00:00	ES	Futures	3062.79	3068.79	3061.98	3064.7	159345.0
2018-07-17 16:00:00	ES	Futures	3064.43	3067.43	3062.79	3065.79	49602.0
2018-07-17 18:00:00	ES	Futures	3065.79	3069.06	3065.52	3067.43	4533.0
2018-07-17 19:00:00	ES	Futures	3067.43	3068.52	3066.34	3067.7	2933.0
2018-07-17 20:00:00	ES	Futures	3067.43	3069.61	3067.43	3068.79	5647.0
2018-07-17 21:00:00	ES	Futures	3069.06	3069.33	3066.34	3066.61	5880.0
2018-07-17 22:00:00	ES	Futures	3066.61	3067.97	3065.52	3067.7	3090.0
2018-07-17 23:00:00	ES	Futures	3067.7	3067.7	3065.25	3066.34	2870.0
2018-07-17 00:00:00	NQ	Futures	8624.1	8629.1	8624.1	8627.92	1016.0
2018-07-17 01:00:00	NQ	Futures	8627.63	8627.63	8603.49	8604.66	2889.0
2018-07-17 02:00:00	NQ	Futures	8604.37	8610.85	8598.78	8599.95	3651.0
2018-07-17 03:00:00	NQ	Futures	8600.25	8607.31	8594.07	8605.25	5335.0
2018-07-17 04:00:00	NQ	Futures	8605.84	8619.39	8605.55	8617.03	4480.0
2018-07-17 05:00:00	NQ	Futures	8617.03	8620.56	8614.68	8619.09	2438.0
2018-07-17 06:00:00	NQ	Futures	8619.09	8621.15	8601.13	8609.67	4009.0
2018-07-17 07:00:00	NQ	Futures	8609.96	8624.98	8607.02	8621.74	5755.0
2018-07-17 08:00:00	NQ	Futures	8622.04	8625.86	8606.73	8607.61	6441.0
2018-07-17 09:00:00	NQ	Futures	8607.61	8645.59	8588.18	8644.12	58489.0
2018-07-17 10:00:00	NQ	Futures	8643.82	8685.04	8640.0	8679.74	57984.0
2018-07-17 11:00:00	NQ	Futures	8680.04	8708.01	8678.56	8707.42	38699.0
2018-07-17 12:00:00	NQ	Futures	8707.12	8741.27	8699.76	8728.32	44167.0
2018-07-17 13:00:00	NQ	Futures	8728.32	8748.64	8728.03	8738.33	22634.0
2018-07-17 14:00:00	NQ	Futures	8737.45	8746.87	8729.5	8731.26	21977.0
2018-07-17 15:00:00	NQ	Futures	8730.97	8757.17	8727.73	8740.69	35863.0
2018-07-17 16:00:00	NQ	Futures	8740.39	8748.64	8737.15	8744.22	7164.0
2018-07-17 18:00:00	NQ	Futures	8743.34	8752.76	8743.34	8748.34	1192.0
2018-07-17 19:00:00	NQ	Futures	8748.64	8754.23	8745.4	8751.87	1199.0
2018-07-17 20:00:00	NQ	Futures	8752.17	8759.23	8752.17	8756.29	2409.0
2018-07-17 21:00:00	NQ	Futures	8756.58	8759.23	8745.99	8746.87	2486.0
2018-07-17 22:00:00	NQ	Futures	8747.16	8754.82	8742.45	8754.23	1577.0
2018-07-17 23:00:00	NQ	Futures	8753.93	8753.93	8744.81	8748.05	1456.0
2018-07-17 00:00:00	YM	Futures	27247.0	27262.2	27247.0	27261.1	861.0
2018-07-17 01:00:00	YM	Futures	27261.1	27262.2	27217.6	27222.0	1965.0
2018-07-17 02:00:00	YM	Futures	27222.0	27244.8	27208.9	27219.8	2682.0
2018-07-17 03:00:00	YM	Futures	27220.9	27241.5	27187.2	27230.7	3939.0

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

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