PREVIEW / futures_1hour / 2018-05-11

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-11.parquet
  size:    45 KB
  rows:    1,378

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-05-11 00:00:00	ES	Futures	2971.7	2972.24	2970.88	2971.42	1845.0
2018-05-11 01:00:00	ES	Futures	2971.7	2971.97	2970.88	2971.15	2192.0
2018-05-11 02:00:00	ES	Futures	2971.15	2971.42	2965.42	2966.24	10943.0
2018-05-11 03:00:00	ES	Futures	2966.51	2969.51	2966.24	2966.78	11847.0
2018-05-11 04:00:00	ES	Futures	2966.78	2972.51	2966.51	2972.51	9857.0
2018-05-11 05:00:00	ES	Futures	2972.24	2973.06	2969.79	2971.15	9470.0
2018-05-11 06:00:00	ES	Futures	2971.15	2976.61	2970.88	2974.7	14990.0
2018-05-11 07:00:00	ES	Futures	2974.42	2975.24	2973.06	2973.88	10815.0
2018-05-11 08:00:00	ES	Futures	2973.61	2974.97	2970.88	2972.24	26084.0
2018-05-11 09:00:00	ES	Futures	2972.24	2979.06	2969.51	2978.25	128376.0
2018-05-11 10:00:00	ES	Futures	2977.97	2982.61	2975.79	2982.61	176730.0
2018-05-11 11:00:00	ES	Futures	2982.34	2982.88	2973.33	2975.79	110668.0
2018-05-11 12:00:00	ES	Futures	2975.79	2977.7	2968.42	2972.79	100332.0
2018-05-11 13:00:00	ES	Futures	2972.79	2974.42	2969.24	2971.97	54907.0
2018-05-11 14:00:00	ES	Futures	2971.97	2974.15	2965.69	2973.61	101243.0
2018-05-11 15:00:00	ES	Futures	2973.33	2977.97	2972.79	2977.15	160719.0
2018-05-11 16:00:00	ES	Futures	2977.15	2979.88	2976.61	2977.97	68500.0
2018-05-11 00:00:00	NQ	Futures	8239.44	8240.32	8235.89	8236.19	427.0
2018-05-11 01:00:00	NQ	Futures	8236.19	8237.66	8232.93	8234.41	739.0
2018-05-11 02:00:00	NQ	Futures	8234.71	8235.3	8215.79	8219.04	2419.0
2018-05-11 03:00:00	NQ	Futures	8219.04	8228.5	8218.45	8222.3	2760.0
2018-05-11 04:00:00	NQ	Futures	8222.3	8235.3	8221.41	8234.41	2464.0
2018-05-11 05:00:00	NQ	Futures	8234.71	8237.96	8228.21	8232.05	1871.0
2018-05-11 06:00:00	NQ	Futures	8232.34	8250.67	8229.98	8244.16	3744.0
2018-05-11 07:00:00	NQ	Futures	8244.46	8248.89	8240.03	8246.53	3211.0
2018-05-11 08:00:00	NQ	Futures	8245.94	8247.12	8223.18	8226.14	7946.0
2018-05-11 09:00:00	NQ	Futures	8226.14	8230.57	8201.02	8226.14	39780.0
2018-05-11 10:00:00	NQ	Futures	8225.84	8245.35	8219.04	8244.76	44201.0
2018-05-11 11:00:00	NQ	Futures	8244.46	8245.35	8218.16	8231.75	29151.0
2018-05-11 12:00:00	NQ	Futures	8231.46	8235.0	8195.99	8209.29	31721.0
2018-05-11 13:00:00	NQ	Futures	8209.59	8216.68	8202.79	8209.29	16455.0
2018-05-11 14:00:00	NQ	Futures	8209.59	8212.25	8190.08	8205.75	25711.0
2018-05-11 15:00:00	NQ	Futures	8205.45	8228.21	8205.15	8226.43	29846.0
2018-05-11 16:00:00	NQ	Futures	8226.43	8229.98	8219.34	8224.07	8079.0
2018-05-11 00:00:00	YM	Futures	26870.4	26871.5	26860.6	26865.0	533.0
2018-05-11 01:00:00	YM	Futures	26865.0	26868.2	26858.4	26863.9	743.0
2018-05-11 02:00:00	YM	Futures	26862.8	26863.9	26809.6	26815.0	4245.0
2018-05-11 03:00:00	YM	Futures	26816.1	26843.2	26815.0	26820.4	2231.0
2018-05-11 04:00:00	YM	Futures	26819.3	26862.8	26818.3	26861.7	1825.0
2018-05-11 05:00:00	YM	Futures	26861.7	26865.0	26841.1	26859.5	1400.0
2018-05-11 06:00:00	YM	Futures	26859.5	26908.4	26849.8	26880.2	3537.0
2018-05-11 07:00:00	YM	Futures	26879.1	26887.8	26865.0	26872.6	1743.0
2018-05-11 08:00:00	YM	Futures	26872.6	26880.2	26836.7	26856.3	4411.0
2018-05-11 09:00:00	YM	Futures	26857.4	26961.6	26844.3	26954.0	19466.0
2018-05-11 10:00:00	YM	Futures	26956.2	26984.4	26924.7	26969.2	22407.0
2018-05-11 11:00:00	YM	Futures	26969.2	26976.8	26895.4	26905.1	16528.0
2018-05-11 12:00:00	YM	Futures	26905.1	26943.2	26850.8	26893.2	15772.0
2018-05-11 13:00:00	YM	Futures	26893.2	26910.6	26855.2	26892.1	8111.0
2018-05-11 14:00:00	YM	Futures	26891.0	26909.5	26815.0	26900.8	13577.0
2018-05-11 15:00:00	YM	Futures	26899.7	26954.0	26893.2	26944.2	16183.0

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

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