PREVIEW / futures_1hour / 2018-02-19

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-19.parquet
  size:    40 KB
  rows:    1,214

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-02-19 00:00:00	ES	Futures	3002.51	3003.33	3001.42	3002.78	1998.0
2018-02-19 01:00:00	ES	Futures	3002.78	3002.78	2999.78	3000.87	2227.0
2018-02-19 02:00:00	ES	Futures	3000.87	3001.69	2999.5	2999.78	3527.0
2018-02-19 03:00:00	ES	Futures	2999.78	3000.32	2995.4	2995.68	9292.0
2018-02-19 04:00:00	ES	Futures	2995.68	2996.77	2993.49	2994.58	4963.0
2018-02-19 05:00:00	ES	Futures	2994.58	2995.4	2993.49	2995.4	5615.0
2018-02-19 06:00:00	ES	Futures	2995.4	2997.32	2994.58	2995.4	8049.0
2018-02-19 07:00:00	ES	Futures	2995.4	2995.68	2990.48	2991.58	7642.0
2018-02-19 08:00:00	ES	Futures	2991.58	2992.12	2988.3	2990.21	9952.0
2018-02-19 09:00:00	ES	Futures	2990.21	2991.03	2984.2	2986.66	17309.0
2018-02-19 10:00:00	ES	Futures	2986.93	2986.93	2974.08	2976.27	46593.0
2018-02-19 11:00:00	ES	Futures	2976.27	2986.66	2973.26	2985.56	27881.0
2018-02-19 12:00:00	ES	Futures	2985.84	2988.02	2982.28	2983.1	13895.0
2018-02-19 18:00:00	ES	Futures	2982.83	2987.75	2982.83	2985.84	5042.0
2018-02-19 19:00:00	ES	Futures	2986.11	2990.21	2985.02	2989.39	4836.0
2018-02-19 20:00:00	ES	Futures	2989.66	2989.66	2977.64	2979.28	11564.0
2018-02-19 21:00:00	ES	Futures	2979.0	2987.2	2976.54	2986.66	9025.0
2018-02-19 22:00:00	ES	Futures	2986.66	2987.48	2982.83	2985.84	4671.0
2018-02-19 23:00:00	ES	Futures	2985.56	2989.12	2985.29	2986.11	3507.0
2018-02-19 00:00:00	NQ	Futures	8086.35	8090.5	8084.86	8087.53	1318.0
2018-02-19 01:00:00	NQ	Futures	8087.53	8088.72	8081.01	8083.38	864.0
2018-02-19 02:00:00	NQ	Futures	8083.38	8088.42	8081.6	8081.9	1200.0
2018-02-19 03:00:00	NQ	Futures	8081.9	8082.79	8073.59	8074.19	2117.0
2018-02-19 04:00:00	NQ	Futures	8074.78	8077.45	8068.25	8076.26	1950.0
2018-02-19 05:00:00	NQ	Futures	8076.26	8079.52	8069.14	8076.26	1097.0
2018-02-19 06:00:00	NQ	Futures	8076.85	8086.64	8076.26	8079.82	749.0
2018-02-19 07:00:00	NQ	Futures	8079.82	8082.49	8065.58	8068.25	1438.0
2018-02-19 08:00:00	NQ	Futures	8067.96	8072.11	8062.03	8065.88	3359.0
2018-02-19 09:00:00	NQ	Futures	8065.58	8076.26	8044.82	8056.39	7197.0
2018-02-19 10:00:00	NQ	Futures	8056.98	8058.47	8024.06	8029.7	13175.0
2018-02-19 11:00:00	NQ	Futures	8029.4	8052.53	8017.83	8051.94	6065.0
2018-02-19 12:00:00	NQ	Futures	8051.94	8057.28	8038.59	8043.34	2877.0
2018-02-19 18:00:00	NQ	Futures	8046.31	8056.09	8042.75	8051.94	2022.0
2018-02-19 19:00:00	NQ	Futures	8051.94	8063.21	8050.46	8059.65	2729.0
2018-02-19 20:00:00	NQ	Futures	8059.65	8059.95	8022.58	8029.1	7071.0
2018-02-19 21:00:00	NQ	Futures	8028.51	8054.31	8021.69	8053.42	6244.0
2018-02-19 22:00:00	NQ	Futures	8053.13	8054.61	8040.08	8051.94	3421.0
2018-02-19 23:00:00	NQ	Futures	8051.64	8057.58	8048.09	8050.16	1726.0
2018-02-19 00:00:00	YM	Futures	27532.8	27536.1	27515.5	27532.8	1126.0
2018-02-19 01:00:00	YM	Futures	27532.8	27533.9	27500.2	27514.4	1232.0
2018-02-19 02:00:00	YM	Futures	27512.2	27526.3	27487.2	27491.5	1435.0
2018-02-19 03:00:00	YM	Futures	27491.5	27510.0	27454.6	27460.0	2783.0
2018-02-19 04:00:00	YM	Futures	27460.0	27478.5	27447.0	27463.3	1884.0
2018-02-19 05:00:00	YM	Futures	27462.2	27486.1	27449.2	27476.3	1522.0
2018-02-19 06:00:00	YM	Futures	27476.3	27515.5	27473.1	27486.1	1681.0
2018-02-19 07:00:00	YM	Futures	27483.9	27487.2	27432.9	27454.6	2062.0
2018-02-19 08:00:00	YM	Futures	27454.6	27457.9	27407.9	27433.9	3036.0
2018-02-19 09:00:00	YM	Futures	27431.8	27442.6	27327.4	27355.7	5506.0
2018-02-19 10:00:00	YM	Futures	27355.7	27360.0	27230.7	27270.9	10546.0
2018-02-19 11:00:00	YM	Futures	27274.2	27387.2	27240.5	27365.5	5549.0

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

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