PREVIEW / futures_1hour / 2018-07-13

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-13.parquet
  size:    45 KB
  rows:    1,356

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-13 00:00:00	ES	Futures	3057.89	3059.52	3057.89	3058.98	5458.0
2018-07-13 01:00:00	ES	Futures	3058.98	3058.98	3057.62	3057.89	4329.0
2018-07-13 02:00:00	ES	Futures	3057.89	3059.25	3056.25	3056.8	7089.0
2018-07-13 03:00:00	ES	Futures	3056.8	3057.89	3053.8	3055.16	12788.0
2018-07-13 04:00:00	ES	Futures	3055.16	3055.44	3051.89	3052.44	10375.0
2018-07-13 05:00:00	ES	Futures	3052.71	3052.71	3046.72	3049.72	20183.0
2018-07-13 06:00:00	ES	Futures	3049.99	3052.44	3048.63	3051.62	9984.0
2018-07-13 07:00:00	ES	Futures	3051.89	3053.26	3048.63	3052.98	11747.0
2018-07-13 08:00:00	ES	Futures	3052.98	3052.98	3048.63	3048.63	17853.0
2018-07-13 09:00:00	ES	Futures	3048.9	3053.26	3044.27	3045.9	131747.0
2018-07-13 10:00:00	ES	Futures	3046.17	3056.8	3045.36	3055.16	168387.0
2018-07-13 11:00:00	ES	Futures	3055.16	3058.43	3051.89	3055.16	130318.0
2018-07-13 12:00:00	ES	Futures	3055.16	3058.16	3053.8	3057.89	85241.0
2018-07-13 13:00:00	ES	Futures	3057.62	3058.43	3053.53	3055.71	40643.0
2018-07-13 14:00:00	ES	Futures	3055.44	3055.71	3052.71	3054.62	39912.0
2018-07-13 15:00:00	ES	Futures	3054.62	3056.53	3053.26	3054.35	125526.0
2018-07-13 16:00:00	ES	Futures	3054.35	3056.8	3053.26	3056.25	46672.0
2018-07-13 00:00:00	NQ	Futures	8725.08	8730.09	8725.08	8729.2	2267.0
2018-07-13 01:00:00	NQ	Futures	8728.91	8731.56	8725.67	8728.03	2198.0
2018-07-13 02:00:00	NQ	Futures	8728.03	8729.79	8721.25	8722.73	2474.0
2018-07-13 03:00:00	NQ	Futures	8722.14	8728.91	8717.72	8720.37	4534.0
2018-07-13 04:00:00	NQ	Futures	8720.08	8721.55	8709.48	8710.07	4393.0
2018-07-13 05:00:00	NQ	Futures	8710.07	8710.07	8688.57	8698.29	7069.0
2018-07-13 06:00:00	NQ	Futures	8698.88	8707.71	8694.17	8704.18	3864.0
2018-07-13 07:00:00	NQ	Futures	8704.18	8707.71	8694.17	8704.77	4479.0
2018-07-13 08:00:00	NQ	Futures	8704.18	8707.42	8692.7	8694.17	6390.0
2018-07-13 09:00:00	NQ	Futures	8694.46	8710.07	8675.91	8683.27	51022.0
2018-07-13 10:00:00	NQ	Futures	8682.98	8717.72	8679.45	8706.83	52027.0
2018-07-13 11:00:00	NQ	Futures	8706.83	8720.67	8704.77	8713.6	36813.0
2018-07-13 12:00:00	NQ	Futures	8713.6	8720.67	8706.83	8712.42	21076.0
2018-07-13 13:00:00	NQ	Futures	8712.42	8713.6	8690.34	8697.41	18109.0
2018-07-13 14:00:00	NQ	Futures	8697.7	8702.71	8690.63	8700.94	13477.0
2018-07-13 15:00:00	NQ	Futures	8701.23	8715.07	8699.17	8706.83	25774.0
2018-07-13 16:00:00	NQ	Futures	8706.53	8712.13	8703.29	8712.13	5542.0
2018-07-13 00:00:00	YM	Futures	27157.8	27175.2	27157.8	27168.7	1353.0
2018-07-13 01:00:00	YM	Futures	27168.7	27168.7	27148.0	27150.2	1031.0
2018-07-13 02:00:00	YM	Futures	27150.2	27162.2	27130.6	27133.9	1560.0
2018-07-13 03:00:00	YM	Futures	27132.8	27152.4	27112.2	27128.5	2561.0
2018-07-13 04:00:00	YM	Futures	27126.3	27128.5	27087.2	27091.5	2683.0
2018-07-13 05:00:00	YM	Futures	27091.5	27094.8	27036.1	27066.5	4091.0
2018-07-13 06:00:00	YM	Futures	27066.5	27089.3	27053.5	27085.0	2813.0
2018-07-13 07:00:00	YM	Futures	27085.0	27108.9	27057.8	27105.6	2465.0
2018-07-13 08:00:00	YM	Futures	27104.6	27106.7	27064.3	27068.7	3574.0
2018-07-13 09:00:00	YM	Futures	27068.7	27127.4	27042.6	27056.7	19690.0
2018-07-13 10:00:00	YM	Futures	27054.5	27177.4	27050.2	27158.9	26252.0
2018-07-13 11:00:00	YM	Futures	27158.9	27192.6	27127.4	27166.5	21450.0
2018-07-13 12:00:00	YM	Futures	27166.5	27206.7	27154.6	27204.6	11499.0
2018-07-13 13:00:00	YM	Futures	27204.6	27208.9	27163.3	27191.5	9219.0
2018-07-13 14:00:00	YM	Futures	27192.6	27197.0	27164.3	27179.6	6451.0
2018-07-13 15:00:00	YM	Futures	27179.6	27199.1	27167.6	27181.7	12337.0

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

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