PREVIEW / futures_1hour / 2018-07-06

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-06.parquet
  size:    47 KB
  rows:    1,374

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-06 00:00:00	ES	Futures	2985.41	2991.68	2982.96	2987.59	15804.0
2018-07-06 01:00:00	ES	Futures	2987.32	2993.59	2986.78	2993.31	16810.0
2018-07-06 02:00:00	ES	Futures	2993.31	2994.4	2987.05	2988.41	12546.0
2018-07-06 03:00:00	ES	Futures	2988.68	2988.96	2980.51	2983.51	18660.0
2018-07-06 04:00:00	ES	Futures	2983.51	2986.78	2980.51	2985.69	10448.0
2018-07-06 05:00:00	ES	Futures	2985.69	2987.32	2979.96	2982.14	10675.0
2018-07-06 06:00:00	ES	Futures	2982.42	2982.42	2979.15	2979.42	8398.0
2018-07-06 07:00:00	ES	Futures	2979.42	2980.78	2976.69	2977.51	11090.0
2018-07-06 08:00:00	ES	Futures	2977.51	2991.14	2977.24	2983.78	60776.0
2018-07-06 09:00:00	ES	Futures	2983.78	2991.41	2980.24	2991.14	144808.0
2018-07-06 10:00:00	ES	Futures	2991.41	2999.58	2989.5	2997.95	168326.0
2018-07-06 11:00:00	ES	Futures	2997.95	3011.84	2997.67	3009.12	180773.0
2018-07-06 12:00:00	ES	Futures	3009.12	3012.93	3008.03	3009.39	103066.0
2018-07-06 13:00:00	ES	Futures	3009.66	3013.48	3009.39	3011.3	55865.0
2018-07-06 14:00:00	ES	Futures	3011.03	3012.39	3008.03	3011.3	55079.0
2018-07-06 15:00:00	ES	Futures	3011.3	3014.84	3004.49	3009.94	231220.0
2018-07-06 16:00:00	ES	Futures	3009.94	3012.11	3008.3	3010.75	75072.0
2018-07-06 00:00:00	NQ	Futures	8388.86	8422.13	8377.96	8402.4	5239.0
2018-07-06 01:00:00	NQ	Futures	8401.81	8428.31	8398.87	8424.19	4305.0
2018-07-06 02:00:00	NQ	Futures	8424.19	8429.49	8402.69	8406.23	4010.0
2018-07-06 03:00:00	NQ	Futures	8406.52	8410.05	8374.14	8381.2	7521.0
2018-07-06 04:00:00	NQ	Futures	8381.5	8394.16	8370.31	8390.92	5170.0
2018-07-06 05:00:00	NQ	Futures	8391.21	8397.69	8375.61	8383.56	4658.0
2018-07-06 06:00:00	NQ	Futures	8383.56	8383.56	8371.19	8376.79	2983.0
2018-07-06 07:00:00	NQ	Futures	8376.49	8380.02	8367.07	8371.49	3555.0
2018-07-06 08:00:00	NQ	Futures	8371.78	8421.24	8370.01	8395.63	17171.0
2018-07-06 09:00:00	NQ	Futures	8395.33	8435.37	8389.15	8434.2	48177.0
2018-07-06 10:00:00	NQ	Futures	8434.49	8454.22	8422.71	8449.8	46834.0
2018-07-06 11:00:00	NQ	Futures	8449.8	8496.91	8448.03	8490.14	44200.0
2018-07-06 12:00:00	NQ	Futures	8490.43	8506.62	8488.96	8498.97	25512.0
2018-07-06 13:00:00	NQ	Futures	8498.67	8505.45	8496.91	8500.74	11923.0
2018-07-06 14:00:00	NQ	Futures	8500.44	8511.04	8493.08	8506.62	13469.0
2018-07-06 15:00:00	NQ	Futures	8506.92	8523.7	8493.37	8513.69	44672.0
2018-07-06 16:00:00	NQ	Futures	8513.98	8520.76	8510.75	8515.75	8054.0
2018-07-06 00:00:00	YM	Futures	26451.2	26520.8	26421.8	26484.9	4912.0
2018-07-06 01:00:00	YM	Futures	26483.8	26546.9	26475.1	26543.6	4507.0
2018-07-06 02:00:00	YM	Futures	26542.5	26552.3	26476.2	26489.2	3400.0
2018-07-06 03:00:00	YM	Futures	26490.3	26492.5	26408.8	26444.7	4974.0
2018-07-06 04:00:00	YM	Futures	26444.7	26469.7	26403.4	26451.2	2948.0
2018-07-06 05:00:00	YM	Futures	26452.3	26467.5	26394.7	26419.7	2767.0
2018-07-06 06:00:00	YM	Futures	26419.7	26419.7	26372.9	26372.9	2716.0
2018-07-06 07:00:00	YM	Futures	26374.0	26387.0	26353.3	26362.0	3092.0
2018-07-06 08:00:00	YM	Futures	26362.0	26506.6	26361.0	26424.0	13204.0
2018-07-06 09:00:00	YM	Futures	26424.0	26477.3	26381.6	26468.6	22826.0
2018-07-06 10:00:00	YM	Futures	26469.7	26530.5	26433.8	26505.5	20903.0
2018-07-06 11:00:00	YM	Futures	26507.7	26626.2	26499.0	26592.5	23567.0
2018-07-06 12:00:00	YM	Futures	26593.6	26642.5	26586.0	26601.2	12316.0
2018-07-06 13:00:00	YM	Futures	26601.2	26641.4	26599.0	26621.9	6839.0
2018-07-06 14:00:00	YM	Futures	26621.9	26626.2	26575.1	26600.1	6689.0
2018-07-06 15:00:00	YM	Futures	26600.1	26626.2	26527.3	26575.1	18339.0

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

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