PREVIEW / futures_1hour / 2018-12-04

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-04.parquet
  size:    56 KB
  rows:    1,697

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-12-04 00:00:00	ES	Futures	3020.81	3020.81	3011.29	3012.92	13261.0
2018-12-04 01:00:00	ES	Futures	3013.2	3018.09	3010.75	3016.46	8432.0
2018-12-04 02:00:00	ES	Futures	3016.19	3021.9	3016.19	3020.54	11160.0
2018-12-04 03:00:00	ES	Futures	3020.54	3025.16	3019.45	3020.81	19151.0
2018-12-04 04:00:00	ES	Futures	3020.81	3023.53	3016.73	3018.36	14750.0
2018-12-04 05:00:00	ES	Futures	3018.64	3027.07	3016.73	3025.71	18252.0
2018-12-04 06:00:00	ES	Futures	3025.98	3028.7	3024.08	3024.89	14442.0
2018-12-04 07:00:00	ES	Futures	3024.89	3027.07	3021.36	3024.62	19311.0
2018-12-04 08:00:00	ES	Futures	3024.62	3032.51	3024.62	3030.06	31487.0
2018-12-04 09:00:00	ES	Futures	3030.06	3032.51	3015.92	3020.54	219703.0
2018-12-04 10:00:00	ES	Futures	3020.27	3022.99	3013.2	3014.56	228545.0
2018-12-04 11:00:00	ES	Futures	3014.83	3018.91	3005.85	3006.12	203560.0
2018-12-04 12:00:00	ES	Futures	3006.4	3006.4	2960.43	2968.04	482071.0
2018-12-04 13:00:00	ES	Futures	2968.04	2971.04	2939.76	2960.16	376422.0
2018-12-04 14:00:00	ES	Futures	2959.88	2972.12	2953.08	2960.7	263747.0
2018-12-04 15:00:00	ES	Futures	2960.7	2961.24	2934.59	2941.39	497777.0
2018-12-04 16:00:00	ES	Futures	2941.39	2943.56	2933.23	2939.48	118156.0
2018-12-04 18:00:00	ES	Futures	2937.04	2947.64	2935.4	2947.64	13201.0
2018-12-04 19:00:00	ES	Futures	2947.64	2953.36	2945.47	2946.56	19590.0
2018-12-04 20:00:00	ES	Futures	2946.56	2952.27	2945.2	2952.0	9835.0
2018-12-04 21:00:00	ES	Futures	2952.0	2954.44	2950.09	2951.45	6564.0
2018-12-04 22:00:00	ES	Futures	2951.18	2952.27	2947.37	2949.0	5671.0
2018-12-04 23:00:00	ES	Futures	2949.0	2953.36	2948.73	2950.91	5489.0
2018-12-04 00:00:00	NQ	Futures	8227.17	8227.17	8191.97	8197.84	7010.0
2018-12-04 01:00:00	NQ	Futures	8197.84	8212.8	8189.62	8210.45	5045.0
2018-12-04 02:00:00	NQ	Futures	8210.45	8224.82	8209.86	8220.72	4830.0
2018-12-04 03:00:00	NQ	Futures	8220.72	8237.14	8218.37	8224.82	7254.0
2018-12-04 04:00:00	NQ	Futures	8225.41	8232.45	8207.52	8213.09	7041.0
2018-12-04 05:00:00	NQ	Futures	8212.8	8245.06	8208.69	8240.07	7314.0
2018-12-04 06:00:00	NQ	Futures	8240.07	8251.22	8231.86	8235.38	5639.0
2018-12-04 07:00:00	NQ	Futures	8235.38	8240.66	8221.89	8233.91	6846.0
2018-12-04 08:00:00	NQ	Futures	8234.79	8262.37	8234.5	8256.21	12329.0
2018-12-04 09:00:00	NQ	Futures	8256.5	8267.65	8226.0	8245.06	86443.0
2018-12-04 10:00:00	NQ	Futures	8245.65	8273.81	8237.14	8243.3	80998.0
2018-12-04 11:00:00	NQ	Futures	8243.3	8252.39	8203.7	8204.88	74100.0
2018-12-04 12:00:00	NQ	Futures	8205.17	8205.17	8050.59	8079.34	148695.0
2018-12-04 13:00:00	NQ	Futures	8079.34	8094.0	7989.58	8048.54	110568.0
2018-12-04 14:00:00	NQ	Futures	8048.54	8091.07	8031.82	8051.77	80570.0
2018-12-04 15:00:00	NQ	Futures	8051.47	8052.94	7964.07	7979.32	114774.0
2018-12-04 16:00:00	NQ	Futures	7979.32	7994.57	7958.2	7980.78	21341.0
2018-12-04 18:00:00	NQ	Futures	7973.45	8007.18	7969.35	8006.6	5436.0
2018-12-04 19:00:00	NQ	Futures	8006.3	8022.73	7998.38	8005.72	8015.0
2018-12-04 20:00:00	NQ	Futures	8005.13	8020.68	8001.32	8019.8	6036.0
2018-12-04 21:00:00	NQ	Futures	8020.09	8024.78	8011.58	8017.16	3017.0
2018-12-04 22:00:00	NQ	Futures	8017.45	8021.26	8009.82	8013.64	2292.0
2018-12-04 23:00:00	NQ	Futures	8013.34	8025.37	8012.76	8021.26	3007.0
2018-12-04 00:00:00	YM	Futures	27937.5	27938.6	27827.8	27847.3	4689.0
2018-12-04 01:00:00	YM	Futures	27847.3	27898.4	27822.3	27887.5	3480.0
2018-12-04 02:00:00	YM	Futures	27887.5	27936.4	27887.5	27926.6	3545.0
2018-12-04 03:00:00	YM	Futures	27926.6	27972.3	27892.9	27914.7	6398.0

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

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