PREVIEW / futures_1hour / 2018-06-04

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-04.parquet
  size:    53 KB
  rows:    1,673

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-06-04 00:00:00	ES	Futures	2987.52	2988.62	2987.25	2988.07	1276.0
2018-06-04 01:00:00	ES	Futures	2987.8	2989.71	2986.98	2989.16	2714.0
2018-06-04 02:00:00	ES	Futures	2989.16	2990.8	2987.52	2990.53	7373.0
2018-06-04 03:00:00	ES	Futures	2990.53	2994.35	2987.52	2993.53	21469.0
2018-06-04 04:00:00	ES	Futures	2993.8	2994.89	2990.8	2994.62	14633.0
2018-06-04 05:00:00	ES	Futures	2994.62	2998.44	2994.07	2995.44	18359.0
2018-06-04 06:00:00	ES	Futures	2995.17	2997.08	2993.8	2994.35	11971.0
2018-06-04 07:00:00	ES	Futures	2994.35	2995.98	2991.62	2993.53	11238.0
2018-06-04 08:00:00	ES	Futures	2993.26	2995.44	2991.89	2993.26	18643.0
2018-06-04 09:00:00	ES	Futures	2993.26	3001.17	2990.8	2999.53	122525.0
2018-06-04 10:00:00	ES	Futures	2999.81	3001.17	2991.62	2995.17	138407.0
2018-06-04 11:00:00	ES	Futures	2995.17	2997.35	2991.07	2995.71	82098.0
2018-06-04 12:00:00	ES	Futures	2995.44	2998.99	2993.26	2997.89	53229.0
2018-06-04 13:00:00	ES	Futures	2997.89	2999.53	2994.89	2996.26	47387.0
2018-06-04 14:00:00	ES	Futures	2996.26	2998.99	2995.71	2998.44	42173.0
2018-06-04 15:00:00	ES	Futures	2998.44	3000.08	2996.53	2998.44	122905.0
2018-06-04 16:00:00	ES	Futures	2998.44	2998.44	2996.53	2998.17	47782.0
2018-06-04 18:00:00	ES	Futures	2997.62	2998.44	2995.44	2996.26	5645.0
2018-06-04 19:00:00	ES	Futures	2995.98	2997.62	2995.98	2997.35	3012.0
2018-06-04 20:00:00	ES	Futures	2997.08	2999.26	2994.35	2995.44	5384.0
2018-06-04 21:00:00	ES	Futures	2995.17	2996.26	2993.26	2995.17	4506.0
2018-06-04 22:00:00	ES	Futures	2995.44	2995.44	2993.8	2995.17	2388.0
2018-06-04 23:00:00	ES	Futures	2995.17	2995.98	2994.35	2995.17	1239.0
2018-06-04 00:00:00	NQ	Futures	8395.18	8399.02	8392.52	8396.07	888.0
2018-06-04 01:00:00	NQ	Futures	8395.77	8403.75	8391.93	8400.8	1471.0
2018-06-04 02:00:00	NQ	Futures	8400.5	8403.75	8394.59	8403.75	3080.0
2018-06-04 03:00:00	NQ	Futures	8403.75	8411.73	8396.95	8408.78	6215.0
2018-06-04 04:00:00	NQ	Futures	8408.78	8410.84	8400.8	8410.25	3570.0
2018-06-04 05:00:00	NQ	Futures	8409.96	8417.64	8408.18	8409.66	3913.0
2018-06-04 06:00:00	NQ	Futures	8409.37	8413.5	8404.34	8404.64	3292.0
2018-06-04 07:00:00	NQ	Futures	8404.34	8406.71	8393.11	8398.14	4243.0
2018-06-04 08:00:00	NQ	Futures	8397.84	8405.82	8391.93	8400.8	5865.0
2018-06-04 09:00:00	NQ	Futures	8401.09	8426.51	8393.11	8419.71	41260.0
2018-06-04 10:00:00	NQ	Futures	8419.71	8424.73	8396.07	8421.48	43681.0
2018-06-04 11:00:00	NQ	Futures	8421.48	8430.65	8410.84	8426.8	29218.0
2018-06-04 12:00:00	NQ	Futures	8426.8	8452.51	8421.19	8446.31	23205.0
2018-06-04 13:00:00	NQ	Futures	8446.31	8453.99	8434.78	8439.51	15489.0
2018-06-04 14:00:00	NQ	Futures	8439.51	8450.15	8436.56	8448.97	12690.0
2018-06-04 15:00:00	NQ	Futures	8448.97	8452.51	8442.47	8448.67	27564.0
2018-06-04 16:00:00	NQ	Futures	8448.97	8452.22	8444.54	8451.33	6492.0
2018-06-04 18:00:00	NQ	Futures	8449.26	8451.92	8442.17	8444.24	1354.0
2018-06-04 19:00:00	NQ	Futures	8443.94	8451.33	8443.65	8448.97	918.0
2018-06-04 20:00:00	NQ	Futures	8449.56	8457.83	8442.17	8446.31	2077.0
2018-06-04 21:00:00	NQ	Futures	8445.72	8447.2	8437.44	8444.54	1682.0
2018-06-04 22:00:00	NQ	Futures	8444.24	8446.01	8439.51	8443.94	936.0
2018-06-04 23:00:00	NQ	Futures	8444.24	8447.2	8441.88	8446.01	554.0
2018-06-04 00:00:00	YM	Futures	26803.1	26808.5	26798.7	26804.1	530.0
2018-06-04 01:00:00	YM	Futures	26804.1	26822.6	26795.5	26816.1	924.0
2018-06-04 02:00:00	YM	Futures	26813.9	26834.5	26796.5	26832.4	2520.0
2018-06-04 03:00:00	YM	Futures	26832.4	26865.0	26805.2	26860.6	4593.0

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

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