PREVIEW / futures_1hour / 2018-06-11

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-11.parquet
  size:    49 KB
  rows:    1,565

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-06-11 00:00:00	ES	Futures	3031.74	3032.55	3030.64	3030.92	1036.0
2018-06-11 01:00:00	ES	Futures	3030.92	3030.92	3028.46	3029.28	1684.0
2018-06-11 02:00:00	ES	Futures	3029.01	3034.46	3027.91	3032.28	5929.0
2018-06-11 03:00:00	ES	Futures	3032.28	3037.74	3030.92	3035.56	11365.0
2018-06-11 04:00:00	ES	Futures	3035.56	3037.19	3033.92	3035.01	4823.0
2018-06-11 05:00:00	ES	Futures	3034.74	3036.65	3033.65	3035.28	4509.0
2018-06-11 06:00:00	ES	Futures	3035.28	3035.56	3032.01	3032.83	5506.0
2018-06-11 07:00:00	ES	Futures	3032.83	3033.92	3031.19	3031.19	5114.0
2018-06-11 08:00:00	ES	Futures	3031.46	3033.65	3030.1	3033.37	6704.0
2018-06-11 09:00:00	ES	Futures	3033.37	3039.65	3032.55	3036.1	41748.0
2018-06-11 10:00:00	ES	Futures	3036.1	3040.47	3035.01	3036.92	57212.0
2018-06-11 11:00:00	ES	Futures	3036.92	3043.2	3035.28	3042.65	40605.0
2018-06-11 12:00:00	ES	Futures	3042.65	3045.65	3042.11	3044.56	28532.0
2018-06-11 13:00:00	ES	Futures	3044.84	3046.2	3042.11	3043.74	25650.0
2018-06-11 14:00:00	ES	Futures	3043.47	3044.02	3041.01	3042.65	24281.0
2018-06-11 15:00:00	ES	Futures	3042.65	3044.29	3035.83	3037.47	49818.0
2018-06-11 16:00:00	ES	Futures	3037.74	3038.56	3035.01	3036.92	19208.0
2018-06-11 18:00:00	ES	Futures	3036.1	3041.01	3035.56	3040.74	3147.0
2018-06-11 19:00:00	ES	Futures	3040.47	3042.38	3040.47	3040.74	1778.0
2018-06-11 20:00:00	ES	Futures	3040.47	3040.74	3035.56	3036.65	2990.0
2018-06-11 21:00:00	ES	Futures	3036.65	3041.83	3034.46	3040.47	3610.0
2018-06-11 22:00:00	ES	Futures	3040.47	3040.74	3034.46	3039.92	2646.0
2018-06-11 23:00:00	ES	Futures	3039.65	3040.47	3037.19	3037.74	2046.0
2018-06-11 00:00:00	NQ	Futures	8447.79	8451.04	8446.31	8446.6	276.0
2018-06-11 01:00:00	NQ	Futures	8446.31	8446.6	8433.9	8438.33	507.0
2018-06-11 02:00:00	NQ	Futures	8438.33	8454.29	8433.6	8444.83	1113.0
2018-06-11 03:00:00	NQ	Futures	8445.42	8464.04	8440.99	8456.36	2175.0
2018-06-11 04:00:00	NQ	Futures	8456.95	8462.86	8452.51	8455.17	841.0
2018-06-11 05:00:00	NQ	Futures	8455.17	8460.49	8451.33	8456.06	810.0
2018-06-11 06:00:00	NQ	Futures	8452.51	8457.54	8448.08	8453.99	1273.0
2018-06-11 07:00:00	NQ	Futures	8453.4	8456.06	8448.97	8449.26	2166.0
2018-06-11 08:00:00	NQ	Futures	8449.26	8449.85	8436.26	8444.24	3026.0
2018-06-11 09:00:00	NQ	Futures	8443.94	8476.16	8441.58	8469.06	15415.0
2018-06-11 10:00:00	NQ	Futures	8469.06	8471.13	8446.6	8464.93	17293.0
2018-06-11 11:00:00	NQ	Futures	8464.93	8485.91	8458.13	8482.36	10832.0
2018-06-11 12:00:00	NQ	Futures	8482.66	8498.32	8480.59	8490.93	6963.0
2018-06-11 13:00:00	NQ	Futures	8491.23	8495.66	8482.07	8487.09	5289.0
2018-06-11 14:00:00	NQ	Futures	8487.09	8489.75	8476.75	8489.75	4877.0
2018-06-11 15:00:00	NQ	Futures	8489.16	8493.89	8472.61	8477.04	8392.0
2018-06-11 16:00:00	NQ	Futures	8477.04	8478.82	8467.59	8470.25	3969.0
2018-06-11 18:00:00	NQ	Futures	8469.95	8482.07	8469.06	8481.77	329.0
2018-06-11 19:00:00	NQ	Futures	8481.77	8487.39	8481.48	8482.07	309.0
2018-06-11 20:00:00	NQ	Futures	8482.07	8482.07	8466.11	8470.84	603.0
2018-06-11 21:00:00	NQ	Futures	8469.36	8482.66	8458.72	8479.11	1133.0
2018-06-11 22:00:00	NQ	Futures	8478.82	8479.41	8461.68	8478.52	766.0
2018-06-11 23:00:00	NQ	Futures	8478.52	8480.29	8471.13	8475.27	334.0
2018-06-11 00:00:00	YM	Futures	27544.8	27560.1	27539.4	27541.6	890.0
2018-06-11 01:00:00	YM	Futures	27540.5	27540.5	27510.1	27516.6	1050.0
2018-06-11 02:00:00	YM	Futures	27515.5	27572.0	27500.3	27549.2	3084.0
2018-06-11 03:00:00	YM	Futures	27549.2	27610.1	27535.1	27587.2	5137.0

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

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