PREVIEW / futures_1hour / 2018-10-11

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-11.parquet
  size:    57 KB
  rows:    1,722

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-10-11 00:00:00	ES	Futures	3008.57	3009.66	2996.33	2999.6	15637.0
2018-10-11 01:00:00	ES	Futures	2999.6	3001.77	2990.35	2997.15	21666.0
2018-10-11 02:00:00	ES	Futures	2997.15	3017.82	2996.88	3011.56	42196.0
2018-10-11 03:00:00	ES	Futures	3011.56	3024.35	3000.96	3002.32	85665.0
2018-10-11 04:00:00	ES	Futures	3002.32	3006.4	2996.06	2998.24	61089.0
2018-10-11 05:00:00	ES	Futures	2997.96	3005.31	2988.99	3003.4	55406.0
2018-10-11 06:00:00	ES	Futures	3003.4	3006.67	2996.88	3003.68	31942.0
2018-10-11 07:00:00	ES	Futures	3003.95	3013.74	2998.78	3009.39	59576.0
2018-10-11 08:00:00	ES	Futures	3009.39	3031.69	3009.39	3024.89	164012.0
2018-10-11 09:00:00	ES	Futures	3024.89	3045.02	3015.92	3043.66	492380.0
2018-10-11 10:00:00	ES	Futures	3043.39	3043.66	3009.66	3010.75	477356.0
2018-10-11 11:00:00	ES	Futures	3010.75	3022.72	2990.35	3014.01	471928.0
2018-10-11 12:00:00	ES	Futures	3014.01	3032.78	3010.75	3017.0	237442.0
2018-10-11 13:00:00	ES	Futures	3017.0	3022.99	3000.96	3012.65	212850.0
2018-10-11 14:00:00	ES	Futures	3012.65	3014.56	2950.91	2974.3	482681.0
2018-10-11 15:00:00	ES	Futures	2974.3	3009.12	2968.86	2972.12	623743.0
2018-10-11 16:00:00	ES	Futures	2972.12	2997.15	2966.68	2989.8	164977.0
2018-10-11 18:00:00	ES	Futures	2990.35	3001.5	2987.9	3000.68	19169.0
2018-10-11 19:00:00	ES	Futures	3000.68	3006.67	2998.51	3000.14	16802.0
2018-10-11 20:00:00	ES	Futures	3000.14	3009.93	2999.05	3005.04	26340.0
2018-10-11 21:00:00	ES	Futures	3004.76	3007.76	3001.77	3006.67	17245.0
2018-10-11 22:00:00	ES	Futures	3006.67	3008.84	3002.86	3004.49	9207.0
2018-10-11 23:00:00	ES	Futures	3004.76	3013.47	3004.22	3011.56	11136.0
2018-10-11 00:00:00	NQ	Futures	8202.24	8206.05	8156.19	8172.03	6844.0
2018-10-11 01:00:00	NQ	Futures	8172.03	8180.24	8136.53	8154.72	8366.0
2018-10-11 02:00:00	NQ	Futures	8155.01	8231.27	8150.91	8218.37	16574.0
2018-10-11 03:00:00	NQ	Futures	8218.08	8262.37	8192.56	8196.96	30677.0
2018-10-11 04:00:00	NQ	Futures	8196.66	8216.61	8174.37	8181.12	16435.0
2018-10-11 05:00:00	NQ	Futures	8181.41	8211.62	8150.03	8196.96	16342.0
2018-10-11 06:00:00	NQ	Futures	8196.08	8208.1	8168.8	8194.32	9147.0
2018-10-11 07:00:00	NQ	Futures	8193.44	8215.73	8158.83	8202.24	18677.0
2018-10-11 08:00:00	NQ	Futures	8202.53	8271.46	8196.96	8247.11	48173.0
2018-10-11 09:00:00	NQ	Futures	8246.82	8374.71	8215.14	8370.89	147682.0
2018-10-11 10:00:00	NQ	Futures	8371.19	8371.19	8242.71	8248.87	151011.0
2018-10-11 11:00:00	NQ	Futures	8248.87	8321.91	8184.05	8279.97	142799.0
2018-10-11 12:00:00	NQ	Futures	8279.67	8351.83	8272.93	8298.15	81250.0
2018-10-11 13:00:00	NQ	Futures	8298.44	8329.24	8250.34	8288.18	70977.0
2018-10-11 14:00:00	NQ	Futures	8287.88	8298.15	8104.56	8172.03	133199.0
2018-10-11 15:00:00	NQ	Futures	8171.44	8299.62	8154.72	8194.32	135180.0
2018-10-11 16:00:00	NQ	Futures	8194.61	8281.43	8171.15	8263.25	29287.0
2018-10-11 18:00:00	NQ	Futures	8260.61	8295.8	8252.98	8293.75	5645.0
2018-10-11 19:00:00	NQ	Futures	8293.75	8317.8	8289.94	8297.27	6661.0
2018-10-11 20:00:00	NQ	Futures	8297.27	8331.0	8293.75	8306.66	8225.0
2018-10-11 21:00:00	NQ	Futures	8306.95	8322.5	8299.91	8315.46	7810.0
2018-10-11 22:00:00	NQ	Futures	8315.46	8319.56	8301.08	8307.83	4865.0
2018-10-11 23:00:00	NQ	Futures	8307.54	8338.33	8305.48	8330.71	4115.0
2018-10-11 00:00:00	YM	Futures	27511.6	27523.5	27402.9	27442.0	3573.0
2018-10-11 01:00:00	YM	Futures	27441.0	27462.7	27359.5	27421.4	3962.0
2018-10-11 02:00:00	YM	Futures	27421.4	27619.1	27421.4	27559.4	10894.0
2018-10-11 03:00:00	YM	Futures	27559.4	27685.4	27454.0	27468.1	19932.0

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

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