PREVIEW / futures_1hour / 2018-01-08

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-08.parquet
  size:    52 KB
  rows:    1,672

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-01-08 00:00:00	ES	Futures	3000.87	3001.42	3000.6	3001.14	2466.0
2018-01-08 01:00:00	ES	Futures	3001.14	3001.14	3000.32	3000.6	1454.0
2018-01-08 02:00:00	ES	Futures	3000.87	3001.69	3000.6	3001.42	5345.0
2018-01-08 03:00:00	ES	Futures	3001.42	3001.96	2997.59	2998.14	19611.0
2018-01-08 04:00:00	ES	Futures	2998.14	2999.5	2997.32	2998.41	9470.0
2018-01-08 05:00:00	ES	Futures	2998.68	3000.32	2997.86	2999.5	9319.0
2018-01-08 06:00:00	ES	Futures	2999.23	3000.05	2994.58	2995.13	13787.0
2018-01-08 07:00:00	ES	Futures	2994.86	2996.22	2991.85	2993.49	28897.0
2018-01-08 08:00:00	ES	Futures	2993.76	2995.68	2992.12	2994.86	24219.0
2018-01-08 09:00:00	ES	Futures	2994.86	2997.59	2992.4	2996.22	146807.0
2018-01-08 10:00:00	ES	Futures	2996.5	2997.86	2993.49	2996.77	114706.0
2018-01-08 11:00:00	ES	Futures	2997.04	2999.23	2995.68	2997.32	73286.0
2018-01-08 12:00:00	ES	Futures	2997.59	3000.05	2997.32	2999.5	53837.0
2018-01-08 13:00:00	ES	Futures	2999.78	3003.6	2999.78	3003.06	69776.0
2018-01-08 14:00:00	ES	Futures	3003.33	3004.15	3002.24	3004.15	47474.0
2018-01-08 15:00:00	ES	Futures	3004.15	3004.97	3001.14	3002.78	153575.0
2018-01-08 16:00:00	ES	Futures	3003.06	3004.15	3001.96	3003.33	57589.0
2018-01-08 18:00:00	ES	Futures	3002.78	3004.69	3002.51	3004.42	5579.0
2018-01-08 19:00:00	ES	Futures	3004.42	3004.42	3002.78	3003.6	5441.0
2018-01-08 20:00:00	ES	Futures	3003.6	3003.87	3000.05	3000.6	10484.0
2018-01-08 21:00:00	ES	Futures	3000.6	3000.87	2998.68	3000.32	8023.0
2018-01-08 22:00:00	ES	Futures	3000.32	3001.42	2999.5	3001.14	3947.0
2018-01-08 23:00:00	ES	Futures	3001.14	3001.42	3000.32	3000.6	2678.0
2018-01-08 00:00:00	NQ	Futures	7913.13	7915.21	7910.76	7914.62	525.0
2018-01-08 01:00:00	NQ	Futures	7914.62	7914.91	7911.36	7914.02	480.0
2018-01-08 02:00:00	NQ	Futures	7914.02	7918.18	7912.24	7918.18	1342.0
2018-01-08 03:00:00	NQ	Futures	7918.18	7919.07	7908.39	7909.87	2661.0
2018-01-08 04:00:00	NQ	Futures	7909.87	7913.73	7907.8	7911.06	1613.0
2018-01-08 05:00:00	NQ	Futures	7911.36	7914.91	7909.28	7914.02	1516.0
2018-01-08 06:00:00	NQ	Futures	7914.02	7915.8	7901.86	7903.35	2351.0
2018-01-08 07:00:00	NQ	Futures	7903.35	7905.13	7894.45	7900.97	4686.0
2018-01-08 08:00:00	NQ	Futures	7900.97	7903.35	7893.26	7898.9	4856.0
2018-01-08 09:00:00	NQ	Futures	7898.9	7919.96	7897.42	7915.51	42401.0
2018-01-08 10:00:00	NQ	Futures	7915.51	7927.96	7900.97	7923.81	38874.0
2018-01-08 11:00:00	NQ	Futures	7923.81	7937.75	7920.85	7928.26	21683.0
2018-01-08 12:00:00	NQ	Futures	7928.56	7931.23	7923.22	7926.48	12107.0
2018-01-08 13:00:00	NQ	Futures	7926.78	7933.3	7924.7	7933.01	9831.0
2018-01-08 14:00:00	NQ	Futures	7932.71	7936.57	7922.63	7927.67	11257.0
2018-01-08 15:00:00	NQ	Futures	7927.67	7937.16	7925.0	7932.12	20772.0
2018-01-08 16:00:00	NQ	Futures	7931.82	7937.16	7930.34	7935.68	7204.0
2018-01-08 18:00:00	NQ	Futures	7933.6	7940.72	7933.3	7938.94	1365.0
2018-01-08 19:00:00	NQ	Futures	7938.94	7939.23	7934.79	7938.94	1220.0
2018-01-08 20:00:00	NQ	Futures	7938.94	7940.42	7927.96	7929.45	2216.0
2018-01-08 21:00:00	NQ	Futures	7929.45	7930.63	7923.81	7929.15	1466.0
2018-01-08 22:00:00	NQ	Futures	7929.15	7935.68	7927.37	7933.6	1134.0
2018-01-08 23:00:00	NQ	Futures	7933.6	7934.19	7930.04	7930.63	621.0
2018-01-08 00:00:00	YM	Futures	27531.8	27535.0	27523.1	27531.8	664.0
2018-01-08 01:00:00	YM	Futures	27532.8	27532.8	27523.1	27530.7	715.0
2018-01-08 02:00:00	YM	Futures	27529.6	27544.8	27526.3	27541.5	1376.0
2018-01-08 03:00:00	YM	Futures	27542.6	27549.2	27500.2	27502.4	3273.0

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

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