PREVIEW / futures_1hour / 2018-01-04

all futures 1-hour files

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

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-04 00:00:00	ES	Futures	2965.34	2967.52	2965.34	2967.25	5947.0
2018-01-04 01:00:00	ES	Futures	2967.25	2967.25	2965.61	2965.61	3277.0
2018-01-04 02:00:00	ES	Futures	2965.61	2966.7	2965.34	2966.16	5329.0
2018-01-04 03:00:00	ES	Futures	2965.88	2967.52	2965.88	2966.43	13965.0
2018-01-04 04:00:00	ES	Futures	2966.43	2969.44	2966.43	2968.34	11479.0
2018-01-04 05:00:00	ES	Futures	2968.34	2968.89	2966.43	2966.43	14695.0
2018-01-04 06:00:00	ES	Futures	2966.43	2968.89	2966.16	2968.34	11153.0
2018-01-04 07:00:00	ES	Futures	2968.34	2970.8	2968.07	2969.16	13168.0
2018-01-04 08:00:00	ES	Futures	2969.16	2972.72	2968.89	2972.17	26806.0
2018-01-04 09:00:00	ES	Futures	2972.17	2980.37	2971.9	2979.55	207427.0
2018-01-04 10:00:00	ES	Futures	2979.82	2983.65	2977.91	2980.64	194412.0
2018-01-04 11:00:00	ES	Futures	2980.64	2980.92	2975.45	2977.36	133705.0
2018-01-04 12:00:00	ES	Futures	2977.64	2980.92	2977.09	2980.37	88151.0
2018-01-04 13:00:00	ES	Futures	2980.37	2981.46	2978.73	2981.19	70213.0
2018-01-04 14:00:00	ES	Futures	2981.19	2982.56	2979.28	2980.64	66330.0
2018-01-04 15:00:00	ES	Futures	2980.92	2981.46	2977.09	2978.18	162957.0
2018-01-04 16:00:00	ES	Futures	2978.18	2980.1	2976.27	2979.28	74930.0
2018-01-04 18:00:00	ES	Futures	2979.28	2980.92	2979.0	2979.82	7023.0
2018-01-04 19:00:00	ES	Futures	2980.1	2980.37	2979.28	2979.55	3712.0
2018-01-04 20:00:00	ES	Futures	2979.82	2980.37	2978.73	2979.28	4424.0
2018-01-04 21:00:00	ES	Futures	2979.28	2979.82	2977.91	2979.55	3983.0
2018-01-04 22:00:00	ES	Futures	2979.28	2980.1	2979.0	2979.82	1605.0
2018-01-04 23:00:00	ES	Futures	2979.82	2980.64	2979.55	2980.64	1986.0
2018-01-04 00:00:00	NQ	Futures	7821.19	7828.9	7820.89	7827.42	1549.0
2018-01-04 01:00:00	NQ	Futures	7827.72	7828.61	7823.56	7826.53	1104.0
2018-01-04 02:00:00	NQ	Futures	7826.53	7828.31	7824.45	7825.94	1356.0
2018-01-04 03:00:00	NQ	Futures	7826.23	7832.16	7825.05	7826.83	2349.0
2018-01-04 04:00:00	NQ	Futures	7826.83	7832.46	7825.94	7830.09	1568.0
2018-01-04 05:00:00	NQ	Futures	7829.79	7831.57	7822.67	7823.86	1666.0
2018-01-04 06:00:00	NQ	Futures	7823.56	7828.31	7821.49	7827.42	2156.0
2018-01-04 07:00:00	NQ	Futures	7827.42	7836.61	7826.83	7831.87	3065.0
2018-01-04 08:00:00	NQ	Futures	7831.87	7850.85	7831.57	7846.4	9604.0
2018-01-04 09:00:00	NQ	Futures	7846.4	7849.07	7814.07	7828.31	62525.0
2018-01-04 10:00:00	NQ	Futures	7828.9	7846.1	7820.89	7836.02	42402.0
2018-01-04 11:00:00	NQ	Futures	7835.72	7837.21	7820.0	7825.64	29441.0
2018-01-04 12:00:00	NQ	Futures	7825.94	7837.5	7822.08	7824.45	19223.0
2018-01-04 13:00:00	NQ	Futures	7824.16	7827.42	7815.85	7825.64	17525.0
2018-01-04 14:00:00	NQ	Futures	7825.64	7831.87	7820.0	7828.01	15486.0
2018-01-04 15:00:00	NQ	Futures	7828.01	7833.35	7822.08	7825.34	23713.0
2018-01-04 16:00:00	NQ	Futures	7825.05	7839.58	7822.67	7838.1	8873.0
2018-01-04 18:00:00	NQ	Futures	7839.58	7841.66	7834.24	7835.72	1617.0
2018-01-04 19:00:00	NQ	Futures	7836.02	7841.36	7835.13	7838.69	851.0
2018-01-04 20:00:00	NQ	Futures	7838.39	7841.66	7834.54	7835.72	1159.0
2018-01-04 21:00:00	NQ	Futures	7836.02	7839.28	7829.79	7836.32	1517.0
2018-01-04 22:00:00	NQ	Futures	7836.61	7840.77	7835.13	7839.28	582.0
2018-01-04 23:00:00	NQ	Futures	7839.28	7843.44	7839.28	7842.84	695.0
2018-01-04 00:00:00	YM	Futures	27093.7	27116.6	27092.7	27107.9	2103.0
2018-01-04 01:00:00	YM	Futures	27109.0	27112.2	27098.1	27102.4	850.0
2018-01-04 02:00:00	YM	Futures	27101.4	27105.7	27090.5	27099.2	1603.0
2018-01-04 03:00:00	YM	Futures	27099.2	27112.2	27098.1	27107.9	2115.0

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

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