PREVIEW / futures_1hour / 2018-01-18

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-18.parquet
  size:    55 KB
  rows:    1,681

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-01-18 00:00:00	ES	Futures	3068.38	3068.65	3062.09	3063.19	13084.0
2018-01-18 01:00:00	ES	Futures	3063.19	3066.74	3062.64	3065.92	6617.0
2018-01-18 02:00:00	ES	Futures	3066.19	3068.11	3065.37	3067.01	8496.0
2018-01-18 03:00:00	ES	Futures	3067.01	3068.11	3062.37	3062.37	16875.0
2018-01-18 04:00:00	ES	Futures	3062.64	3065.1	3061.55	3064.28	14919.0
2018-01-18 05:00:00	ES	Futures	3064.55	3065.65	3061.82	3064.83	10916.0
2018-01-18 06:00:00	ES	Futures	3064.83	3068.65	3064.28	3068.65	11510.0
2018-01-18 07:00:00	ES	Futures	3068.38	3069.47	3063.73	3064.83	21537.0
2018-01-18 08:00:00	ES	Futures	3065.1	3065.65	3061.0	3062.91	35641.0
2018-01-18 09:00:00	ES	Futures	3062.91	3068.38	3061.0	3066.19	145266.0
2018-01-18 10:00:00	ES	Futures	3066.19	3066.47	3056.63	3059.91	169458.0
2018-01-18 11:00:00	ES	Futures	3059.91	3064.55	3054.44	3057.99	183929.0
2018-01-18 12:00:00	ES	Futures	3057.99	3062.91	3057.72	3061.27	62419.0
2018-01-18 13:00:00	ES	Futures	3061.55	3064.28	3058.54	3063.73	72607.0
2018-01-18 14:00:00	ES	Futures	3064.01	3069.75	3063.46	3066.47	100864.0
2018-01-18 15:00:00	ES	Futures	3066.47	3067.29	3057.72	3061.55	209125.0
2018-01-18 16:00:00	ES	Futures	3061.27	3063.46	3055.26	3057.99	90680.0
2018-01-18 18:00:00	ES	Futures	3057.99	3062.37	3057.72	3060.18	13020.0
2018-01-18 19:00:00	ES	Futures	3059.91	3060.45	3058.54	3059.09	7516.0
2018-01-18 20:00:00	ES	Futures	3058.81	3061.0	3057.99	3059.36	7167.0
2018-01-18 21:00:00	ES	Futures	3059.36	3060.18	3054.99	3056.35	11016.0
2018-01-18 22:00:00	ES	Futures	3056.35	3056.63	3052.25	3053.89	10311.0
2018-01-18 23:00:00	ES	Futures	3053.89	3055.81	3053.07	3054.44	6621.0
2018-01-18 00:00:00	NQ	Futures	8094.06	8095.24	8072.41	8076.26	3526.0
2018-01-18 01:00:00	NQ	Futures	8076.26	8090.5	8073.3	8087.83	1779.0
2018-01-18 02:00:00	NQ	Futures	8087.83	8095.24	8084.57	8090.79	2025.0
2018-01-18 03:00:00	NQ	Futures	8091.09	8094.95	8076.56	8077.15	3273.0
2018-01-18 04:00:00	NQ	Futures	8077.74	8087.53	8075.96	8085.75	2837.0
2018-01-18 05:00:00	NQ	Futures	8085.75	8086.64	8076.56	8084.86	2002.0
2018-01-18 06:00:00	NQ	Futures	8084.86	8092.28	8084.27	8091.68	2850.0
2018-01-18 07:00:00	NQ	Futures	8091.68	8095.24	8075.96	8078.93	4508.0
2018-01-18 08:00:00	NQ	Futures	8079.23	8080.12	8065.29	8071.52	10581.0
2018-01-18 09:00:00	NQ	Futures	8071.52	8098.8	8066.18	8089.9	50770.0
2018-01-18 10:00:00	NQ	Futures	8090.2	8094.65	8062.62	8081.3	63051.0
2018-01-18 11:00:00	NQ	Futures	8081.01	8100.88	8070.63	8083.68	46559.0
2018-01-18 12:00:00	NQ	Futures	8083.68	8104.14	8081.9	8098.21	20252.0
2018-01-18 13:00:00	NQ	Futures	8098.21	8105.03	8090.2	8102.66	21286.0
2018-01-18 14:00:00	NQ	Futures	8102.96	8112.45	8099.4	8106.81	23971.0
2018-01-18 15:00:00	NQ	Futures	8106.81	8108.89	8084.27	8094.65	31866.0
2018-01-18 16:00:00	NQ	Futures	8094.95	8102.96	8078.04	8086.35	8714.0
2018-01-18 18:00:00	NQ	Futures	8086.94	8098.21	8085.46	8092.57	2456.0
2018-01-18 19:00:00	NQ	Futures	8092.57	8093.46	8086.94	8089.31	1704.0
2018-01-18 20:00:00	NQ	Futures	8088.72	8097.62	8085.75	8092.28	2169.0
2018-01-18 21:00:00	NQ	Futures	8091.68	8094.06	8080.12	8085.16	2477.0
2018-01-18 22:00:00	NQ	Futures	8085.16	8085.46	8069.14	8078.04	3440.0
2018-01-18 23:00:00	NQ	Futures	8078.04	8084.27	8076.56	8080.71	2121.0
2018-01-18 00:00:00	YM	Futures	28394.7	28396.9	28308.9	28327.4	5112.0
2018-01-18 01:00:00	YM	Futures	28327.4	28383.9	28323.0	28377.4	2556.0
2018-01-18 02:00:00	YM	Futures	28377.4	28402.4	28368.7	28390.4	2384.0
2018-01-18 03:00:00	YM	Futures	28391.5	28402.4	28337.1	28340.4	3598.0

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

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