PREVIEW / futures_1hour / 2018-05-04

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-05-04.parquet
  size:    46 KB
  rows:    1,369

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-04 00:00:00	ES	Futures	2868.54	2874.81	2868.54	2873.72	4963.0
2018-05-04 01:00:00	ES	Futures	2873.72	2873.99	2869.36	2871.27	3501.0
2018-05-04 02:00:00	ES	Futures	2870.99	2871.81	2864.72	2866.63	14152.0
2018-05-04 03:00:00	ES	Futures	2866.63	2872.08	2863.62	2870.72	36345.0
2018-05-04 04:00:00	ES	Futures	2870.72	2873.99	2867.44	2870.72	17173.0
2018-05-04 05:00:00	ES	Futures	2870.72	2870.99	2866.35	2870.45	10952.0
2018-05-04 06:00:00	ES	Futures	2870.17	2872.08	2866.08	2866.63	11587.0
2018-05-04 07:00:00	ES	Futures	2866.63	2867.72	2863.08	2864.17	12544.0
2018-05-04 08:00:00	ES	Futures	2863.9	2870.45	2856.53	2864.99	82230.0
2018-05-04 09:00:00	ES	Futures	2864.72	2868.81	2851.62	2866.9	211121.0
2018-05-04 10:00:00	ES	Futures	2867.17	2890.64	2864.17	2887.64	286025.0
2018-05-04 11:00:00	ES	Futures	2887.91	2897.74	2887.09	2896.37	193819.0
2018-05-04 12:00:00	ES	Futures	2896.1	2901.01	2894.46	2898.83	124666.0
2018-05-04 13:00:00	ES	Futures	2899.1	2905.65	2897.74	2905.65	97966.0
2018-05-04 14:00:00	ES	Futures	2905.38	2914.11	2904.29	2908.38	168353.0
2018-05-04 15:00:00	ES	Futures	2908.38	2912.47	2900.47	2905.65	234871.0
2018-05-04 16:00:00	ES	Futures	2905.38	2908.65	2903.47	2908.11	76066.0
2018-05-04 00:00:00	NQ	Futures	7861.75	7882.14	7861.75	7880.07	2555.0
2018-05-04 01:00:00	NQ	Futures	7880.07	7880.36	7863.52	7870.32	1629.0
2018-05-04 02:00:00	NQ	Futures	7869.73	7872.39	7848.74	7855.84	3009.0
2018-05-04 03:00:00	NQ	Futures	7855.54	7874.16	7847.86	7867.07	8119.0
2018-05-04 04:00:00	NQ	Futures	7867.36	7879.77	7854.65	7862.63	5241.0
2018-05-04 05:00:00	NQ	Futures	7863.22	7866.77	7852.29	7864.7	1943.0
2018-05-04 06:00:00	NQ	Futures	7865.0	7871.5	7857.31	7859.38	2961.0
2018-05-04 07:00:00	NQ	Futures	7859.38	7865.59	7848.15	7852.29	3102.0
2018-05-04 08:00:00	NQ	Futures	7852.58	7867.95	7823.92	7851.4	19589.0
2018-05-04 09:00:00	NQ	Futures	7850.81	7877.7	7814.46	7873.27	59848.0
2018-05-04 10:00:00	NQ	Futures	7873.57	7962.52	7857.61	7954.54	90548.0
2018-05-04 11:00:00	NQ	Futures	7954.54	7984.1	7954.25	7975.23	52237.0
2018-05-04 12:00:00	NQ	Futures	7975.82	7990.01	7969.32	7979.37	27729.0
2018-05-04 13:00:00	NQ	Futures	7979.66	8002.42	7970.21	8001.24	24258.0
2018-05-04 14:00:00	NQ	Futures	8001.53	8024.88	7996.51	8010.69	31462.0
2018-05-04 15:00:00	NQ	Futures	8010.4	8020.74	7992.67	8006.26	41129.0
2018-05-04 16:00:00	NQ	Futures	8005.97	8014.83	8003.9	8013.95	10535.0
2018-05-04 00:00:00	YM	Futures	25933.1	26008.1	25933.1	25998.3	2254.0
2018-05-04 01:00:00	YM	Futures	25997.2	25998.3	25949.4	25965.7	1850.0
2018-05-04 02:00:00	YM	Futures	25965.7	25971.2	25895.1	25912.5	3373.0
2018-05-04 03:00:00	YM	Futures	25912.5	25960.3	25884.3	25948.4	6787.0
2018-05-04 04:00:00	YM	Futures	25949.4	25978.8	25910.3	25938.6	3328.0
2018-05-04 05:00:00	YM	Futures	25938.6	25950.5	25900.6	25948.4	1723.0
2018-05-04 06:00:00	YM	Futures	25945.1	25961.4	25906.0	25916.9	2380.0
2018-05-04 07:00:00	YM	Futures	25917.9	25928.8	25882.1	25894.1	2504.0
2018-05-04 08:00:00	YM	Futures	25894.1	25947.3	25819.1	25894.1	14546.0
2018-05-04 09:00:00	YM	Futures	25894.1	25954.9	25761.6	25935.3	34628.0
2018-05-04 10:00:00	YM	Futures	25935.3	26177.5	25900.6	26141.7	43090.0
2018-05-04 11:00:00	YM	Futures	26141.7	26225.3	26135.1	26206.8	25714.0
2018-05-04 12:00:00	YM	Futures	26205.7	26253.5	26194.9	26229.6	16031.0
2018-05-04 13:00:00	YM	Futures	26231.8	26301.3	26227.5	26300.2	14932.0
2018-05-04 14:00:00	YM	Futures	26300.2	26368.6	26290.5	26311.1	21726.0
2018-05-04 15:00:00	YM	Futures	26310.0	26350.2	26243.8	26290.5	22062.0

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

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