PREVIEW / futures_1hour / 2018-11-08

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-08.parquet
  size:    56 KB
  rows:    1,723

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-11-08 00:00:00	ES	Futures	3063.24	3063.24	3058.89	3060.25	6433.0
2018-11-08 01:00:00	ES	Futures	3060.25	3061.07	3057.53	3058.62	5770.0
2018-11-08 02:00:00	ES	Futures	3058.62	3062.7	3057.8	3062.7	12274.0
2018-11-08 03:00:00	ES	Futures	3062.7	3064.33	3059.44	3060.52	26080.0
2018-11-08 04:00:00	ES	Futures	3060.8	3061.61	3052.36	3052.64	19424.0
2018-11-08 05:00:00	ES	Futures	3052.64	3053.18	3048.56	3049.1	26535.0
2018-11-08 06:00:00	ES	Futures	3049.1	3053.18	3048.01	3051.55	17838.0
2018-11-08 07:00:00	ES	Futures	3051.55	3055.36	3051.55	3054.27	18047.0
2018-11-08 08:00:00	ES	Futures	3054.54	3056.17	3051.0	3053.45	30044.0
2018-11-08 09:00:00	ES	Futures	3053.72	3060.8	3050.46	3059.71	167397.0
2018-11-08 10:00:00	ES	Futures	3059.71	3060.8	3051.28	3057.8	176310.0
2018-11-08 11:00:00	ES	Futures	3057.8	3062.16	3054.27	3059.98	94727.0
2018-11-08 12:00:00	ES	Futures	3060.25	3062.97	3056.44	3056.44	72926.0
2018-11-08 13:00:00	ES	Futures	3056.72	3058.08	3050.73	3055.63	71058.0
2018-11-08 14:00:00	ES	Futures	3055.36	3059.71	3040.94	3047.74	199007.0
2018-11-08 15:00:00	ES	Futures	3048.01	3054.54	3042.57	3054.54	223198.0
2018-11-08 16:00:00	ES	Futures	3054.27	3058.08	3052.09	3052.36	72050.0
2018-11-08 18:00:00	ES	Futures	3050.73	3053.18	3049.1	3052.91	6861.0
2018-11-08 19:00:00	ES	Futures	3052.91	3056.99	3052.64	3053.72	8072.0
2018-11-08 20:00:00	ES	Futures	3054.0	3055.08	3049.64	3051.0	12124.0
2018-11-08 21:00:00	ES	Futures	3051.0	3052.36	3046.11	3048.83	9158.0
2018-11-08 22:00:00	ES	Futures	3048.83	3051.55	3046.92	3051.0	7546.0
2018-11-08 23:00:00	ES	Futures	3051.0	3058.62	3050.73	3055.9	9451.0
2018-11-08 00:00:00	NQ	Futures	8459.47	8459.47	8440.99	8448.62	2730.0
2018-11-08 01:00:00	NQ	Futures	8448.62	8452.43	8437.47	8445.69	2320.0
2018-11-08 02:00:00	NQ	Futures	8444.51	8458.59	8437.47	8457.71	4733.0
2018-11-08 03:00:00	NQ	Futures	8458.01	8465.93	8455.07	8458.89	8013.0
2018-11-08 04:00:00	NQ	Futures	8458.59	8466.51	8429.56	8430.14	8805.0
2018-11-08 05:00:00	NQ	Futures	8429.56	8429.85	8402.86	8409.32	11746.0
2018-11-08 06:00:00	NQ	Futures	8409.02	8425.16	8404.33	8419.88	8287.0
2018-11-08 07:00:00	NQ	Futures	8420.17	8437.47	8419.58	8430.73	9975.0
2018-11-08 08:00:00	NQ	Futures	8430.73	8435.13	8416.65	8424.28	16320.0
2018-11-08 09:00:00	NQ	Futures	8424.28	8445.1	8392.89	8440.7	73411.0
2018-11-08 10:00:00	NQ	Futures	8440.7	8450.38	8406.38	8425.74	67033.0
2018-11-08 11:00:00	NQ	Futures	8425.74	8438.94	8403.45	8425.45	44761.0
2018-11-08 12:00:00	NQ	Futures	8425.74	8432.2	8409.61	8411.08	29266.0
2018-11-08 13:00:00	NQ	Futures	8411.37	8418.12	8384.09	8409.9	31970.0
2018-11-08 14:00:00	NQ	Futures	8410.2	8433.95	8370.31	8388.78	63916.0
2018-11-08 15:00:00	NQ	Futures	8389.08	8410.49	8367.67	8410.2	58106.0
2018-11-08 16:00:00	NQ	Futures	8410.2	8419.88	8387.61	8388.49	11507.0
2018-11-08 18:00:00	NQ	Futures	8383.8	8397.0	8379.69	8396.7	2516.0
2018-11-08 19:00:00	NQ	Futures	8395.82	8407.85	8393.18	8393.48	3407.0
2018-11-08 20:00:00	NQ	Futures	8393.77	8399.93	8384.68	8389.37	5103.0
2018-11-08 21:00:00	NQ	Futures	8389.08	8393.18	8373.53	8380.28	3577.0
2018-11-08 22:00:00	NQ	Futures	8380.28	8388.49	8369.43	8381.45	2739.0
2018-11-08 23:00:00	NQ	Futures	8382.04	8405.8	8380.57	8396.12	3759.0
2018-11-08 00:00:00	YM	Futures	28446.0	28449.2	28411.2	28419.9	1914.0
2018-11-08 01:00:00	YM	Futures	28418.8	28425.3	28399.3	28413.4	1582.0
2018-11-08 02:00:00	YM	Futures	28412.3	28443.8	28401.4	28441.6	3536.0
2018-11-08 03:00:00	YM	Futures	28441.6	28472.1	28428.6	28439.5	5944.0

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

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