PREVIEW / futures_1hour / 2018-03-05

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-05.parquet
  size:    55 KB
  rows:    1,662

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-03-05 00:00:00	ES	Futures	2921.6	2927.34	2921.6	2924.88	5450.0
2018-03-05 01:00:00	ES	Futures	2924.88	2925.43	2921.6	2922.42	4480.0
2018-03-05 02:00:00	ES	Futures	2922.42	2924.06	2912.31	2915.86	25105.0
2018-03-05 03:00:00	ES	Futures	2915.59	2936.09	2913.68	2933.36	34545.0
2018-03-05 04:00:00	ES	Futures	2933.36	2939.1	2928.71	2938.0	24121.0
2018-03-05 05:00:00	ES	Futures	2938.0	2942.92	2935.27	2941.28	21341.0
2018-03-05 06:00:00	ES	Futures	2941.56	2941.83	2932.26	2932.26	22981.0
2018-03-05 07:00:00	ES	Futures	2932.26	2935.82	2928.16	2929.53	18534.0
2018-03-05 08:00:00	ES	Futures	2929.53	2936.36	2925.98	2928.16	43870.0
2018-03-05 09:00:00	ES	Futures	2927.89	2935.0	2921.88	2929.26	200021.0
2018-03-05 10:00:00	ES	Futures	2928.98	2947.3	2924.06	2946.75	193302.0
2018-03-05 11:00:00	ES	Futures	2946.75	2967.25	2945.38	2964.52	258459.0
2018-03-05 12:00:00	ES	Futures	2964.24	2970.26	2959.6	2969.98	142068.0
2018-03-05 13:00:00	ES	Futures	2970.26	2975.18	2964.79	2970.26	137778.0
2018-03-05 14:00:00	ES	Futures	2970.26	2978.46	2961.24	2978.18	164724.0
2018-03-05 15:00:00	ES	Futures	2978.18	2982.28	2973.26	2975.18	263923.0
2018-03-05 16:00:00	ES	Futures	2974.9	2975.18	2969.71	2972.44	74466.0
2018-03-05 18:00:00	ES	Futures	2972.72	2975.18	2971.62	2971.9	7193.0
2018-03-05 19:00:00	ES	Futures	2972.17	2975.45	2970.8	2974.9	8133.0
2018-03-05 20:00:00	ES	Futures	2974.9	2976.54	2973.26	2973.26	6962.0
2018-03-05 21:00:00	ES	Futures	2973.26	2974.9	2969.44	2972.44	8140.0
2018-03-05 22:00:00	ES	Futures	2972.44	2974.63	2971.62	2972.99	2224.0
2018-03-05 23:00:00	ES	Futures	2972.72	2973.54	2971.08	2971.62	1804.0
2018-03-05 00:00:00	NQ	Futures	8025.84	8043.64	8024.95	8035.03	2932.0
2018-03-05 01:00:00	NQ	Futures	8034.74	8035.92	8024.36	8026.43	2453.0
2018-03-05 02:00:00	NQ	Futures	8026.43	8029.4	7999.15	8007.75	7263.0
2018-03-05 03:00:00	NQ	Futures	8008.34	8071.81	8000.04	8063.51	10596.0
2018-03-05 04:00:00	NQ	Futures	8064.1	8083.68	8051.05	8076.26	7328.0
2018-03-05 05:00:00	NQ	Futures	8076.56	8106.51	8072.11	8098.51	7724.0
2018-03-05 06:00:00	NQ	Futures	8098.51	8099.69	8074.48	8076.26	6329.0
2018-03-05 07:00:00	NQ	Futures	8076.26	8084.27	8056.09	8058.76	8170.0
2018-03-05 08:00:00	NQ	Futures	8059.06	8080.12	8051.94	8057.58	14894.0
2018-03-05 09:00:00	NQ	Futures	8057.58	8069.44	8022.28	8041.56	62990.0
2018-03-05 10:00:00	NQ	Futures	8041.56	8091.39	8011.9	8090.5	69645.0
2018-03-05 11:00:00	NQ	Futures	8090.2	8152.19	8087.24	8147.74	62886.0
2018-03-05 12:00:00	NQ	Futures	8147.74	8165.54	8134.1	8164.35	40452.0
2018-03-05 13:00:00	NQ	Futures	8164.65	8181.55	8145.96	8161.98	34734.0
2018-03-05 14:00:00	NQ	Futures	8161.98	8182.74	8129.35	8181.26	40114.0
2018-03-05 15:00:00	NQ	Futures	8181.26	8191.34	8164.65	8167.91	46979.0
2018-03-05 16:00:00	NQ	Futures	8167.91	8169.69	8157.53	8164.05	8877.0
2018-03-05 18:00:00	NQ	Futures	8162.87	8169.99	8161.38	8164.05	1968.0
2018-03-05 19:00:00	NQ	Futures	8164.35	8172.95	8158.71	8171.76	3908.0
2018-03-05 20:00:00	NQ	Futures	8171.76	8177.7	8167.61	8169.99	3397.0
2018-03-05 21:00:00	NQ	Futures	8169.39	8173.84	8160.2	8168.8	3482.0
2018-03-05 22:00:00	NQ	Futures	8168.5	8176.51	8165.83	8171.47	1518.0
2018-03-05 23:00:00	NQ	Futures	8171.47	8174.73	8167.91	8168.5	1217.0
2018-03-05 00:00:00	YM	Futures	26517.7	26574.2	26517.7	26555.7	2882.0
2018-03-05 01:00:00	YM	Futures	26555.7	26562.3	26525.3	26538.4	2425.0
2018-03-05 02:00:00	YM	Futures	26537.3	26547.0	26423.1	26454.7	8371.0
2018-03-05 03:00:00	YM	Futures	26455.8	26643.8	26430.8	26606.8	10261.0

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

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