PREVIEW / futures_1hour / 2018-03-01

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-01.parquet
  size:    58 KB
  rows:    1,704

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-01 00:00:00	ES	Futures	2962.06	2962.88	2956.59	2960.42	5742.0
2018-03-01 01:00:00	ES	Futures	2960.42	2967.52	2958.5	2966.7	6578.0
2018-03-01 02:00:00	ES	Futures	2966.7	2974.9	2966.43	2972.44	20587.0
2018-03-01 03:00:00	ES	Futures	2972.17	2976.54	2971.08	2973.54	19121.0
2018-03-01 04:00:00	ES	Futures	2973.54	2973.54	2958.78	2960.69	29139.0
2018-03-01 05:00:00	ES	Futures	2960.69	2964.79	2956.32	2962.88	24586.0
2018-03-01 06:00:00	ES	Futures	2963.15	2966.43	2949.76	2954.4	29981.0
2018-03-01 07:00:00	ES	Futures	2954.68	2961.24	2953.31	2957.96	28640.0
2018-03-01 08:00:00	ES	Futures	2957.68	2971.35	2956.32	2969.71	54122.0
2018-03-01 09:00:00	ES	Futures	2969.71	2973.81	2950.85	2953.58	250389.0
2018-03-01 10:00:00	ES	Futures	2953.58	2985.84	2950.3	2963.15	385695.0
2018-03-01 11:00:00	ES	Futures	2963.15	2975.72	2958.5	2970.8	248217.0
2018-03-01 12:00:00	ES	Futures	2970.8	2971.62	2947.3	2949.76	230089.0
2018-03-01 13:00:00	ES	Futures	2949.76	2949.76	2920.78	2921.06	329946.0
2018-03-01 14:00:00	ES	Futures	2921.06	2924.34	2906.57	2919.69	422622.0
2018-03-01 15:00:00	ES	Futures	2919.42	2939.92	2912.04	2925.7	462466.0
2018-03-01 16:00:00	ES	Futures	2925.43	2933.63	2924.06	2929.8	96787.0
2018-03-01 18:00:00	ES	Futures	2928.71	2932.81	2925.98	2931.17	9174.0
2018-03-01 19:00:00	ES	Futures	2931.17	2935.0	2930.62	2934.72	7395.0
2018-03-01 20:00:00	ES	Futures	2934.72	2935.27	2925.98	2929.26	12882.0
2018-03-01 21:00:00	ES	Futures	2929.26	2929.26	2917.78	2921.88	13284.0
2018-03-01 22:00:00	ES	Futures	2921.88	2926.25	2918.32	2919.69	11139.0
2018-03-01 23:00:00	ES	Futures	2919.69	2927.34	2919.69	2924.88	7479.0
2018-03-01 00:00:00	NQ	Futures	8147.74	8150.11	8128.46	8141.22	2585.0
2018-03-01 01:00:00	NQ	Futures	8141.22	8156.34	8136.17	8154.27	2754.0
2018-03-01 02:00:00	NQ	Futures	8154.27	8176.81	8152.19	8169.99	7161.0
2018-03-01 03:00:00	NQ	Futures	8169.1	8184.52	8164.65	8176.21	5959.0
2018-03-01 04:00:00	NQ	Futures	8176.21	8176.21	8127.87	8133.5	6935.0
2018-03-01 05:00:00	NQ	Futures	8133.21	8145.07	8121.94	8139.73	6239.0
2018-03-01 06:00:00	NQ	Futures	8139.44	8147.15	8094.65	8111.26	7353.0
2018-03-01 07:00:00	NQ	Futures	8111.26	8133.5	8105.33	8123.12	7756.0
2018-03-01 08:00:00	NQ	Futures	8123.42	8164.35	8118.97	8160.79	15522.0
2018-03-01 09:00:00	NQ	Futures	8160.49	8173.25	8068.55	8075.08	84032.0
2018-03-01 10:00:00	NQ	Futures	8075.96	8183.63	8063.51	8110.37	123135.0
2018-03-01 11:00:00	NQ	Futures	8110.67	8155.75	8105.03	8142.7	79857.0
2018-03-01 12:00:00	NQ	Futures	8142.7	8145.66	8070.63	8075.67	75619.0
2018-03-01 13:00:00	NQ	Futures	8075.67	8075.67	7975.12	7975.42	89161.0
2018-03-01 14:00:00	NQ	Futures	7975.72	8008.93	7935.68	7998.26	118493.0
2018-03-01 15:00:00	NQ	Futures	7997.66	8053.72	7970.38	8011.6	111396.0
2018-03-01 16:00:00	NQ	Futures	8011.01	8032.96	8006.56	8026.73	13165.0
2018-03-01 18:00:00	NQ	Futures	8024.36	8038.0	8017.83	8031.77	3093.0
2018-03-01 19:00:00	NQ	Futures	8032.07	8041.26	8031.18	8039.78	2983.0
2018-03-01 20:00:00	NQ	Futures	8040.08	8041.56	8014.27	8027.62	6739.0
2018-03-01 21:00:00	NQ	Futures	8027.32	8027.32	7997.37	8009.53	5212.0
2018-03-01 22:00:00	NQ	Futures	8010.12	8024.36	8001.52	8008.04	4092.0
2018-03-01 23:00:00	NQ	Futures	8008.34	8033.26	8007.75	8025.54	3174.0
2018-03-01 00:00:00	YM	Futures	27162.2	27169.8	27116.6	27148.1	3445.0
2018-03-01 01:00:00	YM	Futures	27147.0	27224.2	27131.8	27209.0	3827.0
2018-03-01 02:00:00	YM	Futures	27207.9	27273.1	27207.9	27240.5	8422.0
2018-03-01 03:00:00	YM	Futures	27238.3	27278.5	27226.3	27248.1	5932.0

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

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