PREVIEW / futures_1hour / 2018-07-19

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-19.parquet
  size:    55 KB
  rows:    1,680

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-19 00:00:00	ES	Futures	3068.52	3068.52	3066.88	3067.15	2706.0
2018-07-19 01:00:00	ES	Futures	3067.15	3068.24	3066.06	3066.34	4089.0
2018-07-19 02:00:00	ES	Futures	3066.61	3067.15	3063.61	3065.25	7705.0
2018-07-19 03:00:00	ES	Futures	3065.25	3066.34	3061.7	3062.25	13957.0
2018-07-19 04:00:00	ES	Futures	3062.25	3065.52	3060.34	3064.16	11301.0
2018-07-19 05:00:00	ES	Futures	3064.16	3064.97	3061.16	3062.25	6936.0
2018-07-19 06:00:00	ES	Futures	3062.25	3062.52	3058.43	3061.43	16767.0
2018-07-19 07:00:00	ES	Futures	3061.43	3062.52	3059.52	3059.52	13520.0
2018-07-19 08:00:00	ES	Futures	3059.52	3061.16	3058.43	3059.8	24972.0
2018-07-19 09:00:00	ES	Futures	3059.52	3065.52	3051.89	3055.71	175475.0
2018-07-19 10:00:00	ES	Futures	3055.44	3060.34	3053.8	3058.16	167368.0
2018-07-19 11:00:00	ES	Futures	3058.16	3064.16	3057.89	3062.79	109149.0
2018-07-19 12:00:00	ES	Futures	3063.07	3063.61	3056.8	3058.71	64702.0
2018-07-19 13:00:00	ES	Futures	3058.71	3064.16	3055.44	3064.16	120243.0
2018-07-19 14:00:00	ES	Futures	3063.88	3066.06	3058.98	3060.89	86463.0
2018-07-19 15:00:00	ES	Futures	3060.61	3062.52	3055.71	3058.16	146252.0
2018-07-19 16:00:00	ES	Futures	3058.16	3058.71	3055.98	3057.07	61556.0
2018-07-19 18:00:00	ES	Futures	3057.62	3060.07	3056.8	3058.16	5861.0
2018-07-19 19:00:00	ES	Futures	3058.43	3060.61	3057.89	3058.71	2264.0
2018-07-19 20:00:00	ES	Futures	3058.71	3062.52	3058.43	3062.25	5966.0
2018-07-19 21:00:00	ES	Futures	3062.25	3063.07	3044.54	3046.17	42214.0
2018-07-19 22:00:00	ES	Futures	3046.45	3052.98	3044.81	3049.99	14309.0
2018-07-19 23:00:00	ES	Futures	3049.99	3052.44	3048.9	3052.17	5222.0
2018-07-19 00:00:00	NQ	Futures	8724.79	8725.38	8715.95	8717.43	1526.0
2018-07-19 01:00:00	NQ	Futures	8717.43	8721.84	8713.01	8716.25	1325.0
2018-07-19 02:00:00	NQ	Futures	8716.54	8718.31	8705.06	8710.07	2682.0
2018-07-19 03:00:00	NQ	Futures	8709.77	8713.31	8700.65	8702.71	4135.0
2018-07-19 04:00:00	NQ	Futures	8702.71	8711.83	8698.0	8706.53	4047.0
2018-07-19 05:00:00	NQ	Futures	8706.83	8708.89	8695.64	8698.29	2413.0
2018-07-19 06:00:00	NQ	Futures	8698.0	8699.76	8681.21	8691.81	5208.0
2018-07-19 07:00:00	NQ	Futures	8691.52	8695.64	8685.34	8685.92	4397.0
2018-07-19 08:00:00	NQ	Futures	8685.92	8694.76	8681.21	8685.04	7374.0
2018-07-19 09:00:00	NQ	Futures	8684.75	8716.84	8668.85	8680.92	54769.0
2018-07-19 10:00:00	NQ	Futures	8680.92	8694.76	8669.73	8688.87	49355.0
2018-07-19 11:00:00	NQ	Futures	8689.16	8710.95	8688.57	8702.12	31051.0
2018-07-19 12:00:00	NQ	Futures	8702.41	8704.77	8665.61	8678.86	25971.0
2018-07-19 13:00:00	NQ	Futures	8678.56	8705.36	8666.49	8698.58	39708.0
2018-07-19 14:00:00	NQ	Futures	8698.29	8706.24	8676.8	8684.75	26625.0
2018-07-19 15:00:00	NQ	Futures	8685.04	8687.69	8665.61	8677.39	37790.0
2018-07-19 16:00:00	NQ	Futures	8677.09	8687.1	8661.49	8675.03	11944.0
2018-07-19 18:00:00	NQ	Futures	8691.52	8706.53	8691.22	8694.17	3268.0
2018-07-19 19:00:00	NQ	Futures	8694.76	8704.18	8694.76	8700.06	1396.0
2018-07-19 20:00:00	NQ	Futures	8699.17	8717.72	8698.88	8715.66	3472.0
2018-07-19 21:00:00	NQ	Futures	8715.66	8723.02	8656.78	8664.73	13229.0
2018-07-19 22:00:00	NQ	Futures	8664.73	8690.93	8661.19	8678.27	4807.0
2018-07-19 23:00:00	NQ	Futures	8678.27	8688.28	8674.15	8686.51	2160.0
2018-07-19 00:00:00	YM	Futures	27373.1	27373.1	27360.0	27362.2	710.0
2018-07-19 01:00:00	YM	Futures	27363.3	27369.8	27341.6	27350.3	1556.0
2018-07-19 02:00:00	YM	Futures	27350.3	27357.9	27304.6	27338.3	4218.0
2018-07-19 03:00:00	YM	Futures	27337.2	27345.9	27304.6	27307.9	3031.0

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

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